Facebook
TwitterThe Bureau of the Census has released Census 2000 Summary File 1 (SF1) 100-Percent data. The file includes the following population items: sex, age, race, Hispanic or Latino origin, household relationship, and household and family characteristics. Housing items include occupancy status and tenure (whether the unit is owner or renter occupied). SF1 does not include information on incomes, poverty status, overcrowded housing or age of housing. These topics will be covered in Summary File 3. Data are available for states, counties, county subdivisions, places, census tracts, block groups, and, where applicable, American Indian and Alaskan Native Areas and Hawaiian Home Lands. The SF1 data are available on the Bureau's web site and may be retrieved from American FactFinder as tables, lists, or maps. Users may also download a set of compressed ASCII files for each state via the Bureau's FTP server. There are over 8000 data items available for each geographic area. The full listing of these data items is available here as a downloadable compressed data base file named TABLES.ZIP. The uncompressed is in FoxPro data base file (dbf) format and may be imported to ACCESS, EXCEL, and other software formats. While all of this information is useful, the Office of Community Planning and Development has downloaded selected information for all states and areas and is making this information available on the CPD web pages. The tables and data items selected are those items used in the CDBG and HOME allocation formulas plus topics most pertinent to the Comprehensive Housing Affordability Strategy (CHAS), the Consolidated Plan, and similar overall economic and community development plans. The information is contained in five compressed (zipped) dbf tables for each state. When uncompressed the tables are ready for use with FoxPro and they can be imported into ACCESS, EXCEL, and other spreadsheet, GIS and database software. The data are at the block group summary level. The first two characters of the file name are the state abbreviation. The next two letters are BG for block group. Each record is labeled with the code and name of the city and county in which it is located so that the data can be summarized to higher-level geography. The last part of the file name describes the contents . The GEO file contains standard Census Bureau geographic identifiers for each block group, such as the metropolitan area code and congressional district code. The only data included in this table is total population and total housing units. POP1 and POP2 contain selected population variables and selected housing items are in the HU file. The MA05 table data is only for use by State CDBG grantees for the reporting of the racial composition of beneficiaries of Area Benefit activities. The complete package for a state consists of the dictionary file named TABLES, and the five data files for the state. The logical record number (LOGRECNO) links the records across tables.
Facebook
TwitterCC0 1.0 Universal Public Domain Dedicationhttps://creativecommons.org/publicdomain/zero/1.0/
License information was derived automatically
Key Table Information.Table Title.Selected Housing Characteristics.Table ID.ACSDP1Y2024.DP04.Survey/Program.American Community Survey.Year.2024.Dataset.ACS 1-Year Estimates Data Profiles.Source.U.S. Census Bureau, 2024 American Community Survey, 1-Year Estimates.Dataset Universe.The dataset universe of the American Community Survey (ACS) is the U.S. resident population and housing. For more information about ACS residence rules, see the ACS Design and Methodology Report. Note that each table describes the specific universe of interest for that set of estimates..Methodology.Unit(s) of Observation.American Community Survey (ACS) data are collected from individuals living in housing units and group quarters, and about housing units whether occupied or vacant. For more information about ACS sampling and data collection, see the ACS Design and Methodology Report..Geography Coverage.ACS data generally reflect the geographic boundaries of legal and statistical areas as of January 1 of the estimate year. For more information, see Geography Boundaries by Year.Estimates of urban and rural populations, housing units, and characteristics reflect boundaries of urban areas defined based on 2020 Census data. As a result, data for urban and rural areas from the ACS do not necessarily reflect the results of ongoing urbanization..Sampling.The ACS consists of two separate samples: housing unit addresses and group quarters facilities. Independent housing unit address samples are selected for each county or county-equivalent in the U.S. and Puerto Rico, with sampling rates depending on a measure of size for the area. For more information on sampling in the ACS, see the Accuracy of the Data document..Confidentiality.The Census Bureau has modified or suppressed some estimates in ACS data products to protect respondents' confidentiality. Title 13 United States Code, Section 9, prohibits the Census Bureau from publishing results in which an individual's data can be identified. For more information on confidentiality protection in the ACS, see the Accuracy of the Data document..Technical Documentation/Methodology.Information about the American Community Survey (ACS) can be found on the ACS website. Supporting documentation including code lists, subject definitions, data accuracy, and statistical testing, and a full list of ACS tables and table shells (without estimates) can be found on the Technical Documentation section of the ACS website.Sample size and data quality measures (including coverage rates, allocation rates, and response rates) can be found on the American Community Survey website in the Methodology section.Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted roughly as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see ACS Technical Documentation). The effect of nonsampling error is not represented in these tables.Users must consider potential differences in geographic boundaries, questionnaire content or coding, or other methodological issues when comparing ACS data from different years. Statistically significant differences shown in ACS Comparison Profiles, or in data users' own analysis, may be the result of these differences and thus might not necessarily reflect changes to the social, economic, housing, or demographic characteristics being compared. For more information, see Comparing ACS Data..Weights.ACS estimates are obtained from a raking ratio estimation procedure that results in the assignment of two sets of weights: a weight to each sample person record and a weight to each sample housing unit record. Estimates of person characteristics are based on the person weight. Estimates of family, household, and housing unit characteristics are based on the housing unit weight. For any given geographic area, a characteristic total is estimated by summing the weights assigned to the persons, households, families or housing units possessing the characteristic in the geographic area. For more information on weighting and estimation in the ACS, see the Accuracy of the Data document.Although the American Community Survey (ACS) produces population, demographic and housing unit estimates, the decennial census is the official source of population totals for April 1st of each decennial year. In between censuses, the Census Bureau's Population Estimates Program produces and disseminates the official estimates of the population for the nation, states, counties, cities, and towns and estimates of ...
Facebook
TwitterThis data comes from the 2010 Census Profile of General Population and Housing Characteristics. Zip codes are limited to those that fall at least partially within LA city boundaries. The dataset will be updated after the next census in 2020. To view all possible columns and access the data directly, visit http://factfinder.census.gov/faces/affhelp/jsf/pages/metadata.xhtml?lang=en&type=table&id=table.en.DEC_10_SF1_SF1DP1#main_content.
Facebook
TwitterHousing Units by Type by U.S. Postal ZIP Code from the 2020 Decennial Census
Facebook
Twitterhttps://www.icpsr.umich.edu/web/ICPSR/studies/6116/termshttps://www.icpsr.umich.edu/web/ICPSR/studies/6116/terms
Summary Tape File 3B contains sample data weighted to represent the total population. The collection also contains 100-percent counts and unweighted sample counts for total persons and total housing units. Additional population and housing variables include items such as age, ancestry, disability, citizenship, education, income, marital status, race, sex, travel time to work, rent, tenure, value of housing unit, number of vehicles, and monthly owner costs. The collection includes 178 population tables and 99 housing tables. Data are provided by 5-digit ZIP code within each state, including county portions of the ZIP codes.
Facebook
TwitterAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This layer shows housing units broken down by owner occupied and renter occupied in Tempe Zip Codes.Data is from US Census American Community Survey (ACS) 5-year estimates.To see the full list of attributes available in this service, go to the "Data" tab, and choose "Fields" at the top right (in ArcGIS Online).A ‘Null’ entry in the estimate indicates that data for this geographic area cannot be displayed because the number of sample cases is too small (per the U.S. Census).Vintage: 2016-2020ACS Table(s): S2502 (Not all lines of this ACS table are available in this feature layer.)Data downloaded from: Census Bureau's API for American Community Survey Data Preparation: Data table downloaded and joined with Zip Code boundaries in the City of Tempe.Date of Census update: March 17, 2022National Figures: data.census.gov
Facebook
Twitterhttps://www.icpsr.umich.edu/web/ICPSR/studies/8051/termshttps://www.icpsr.umich.edu/web/ICPSR/studies/8051/terms
This data collection relates ZIP codes to counties, to standard metropolitan statistical areas (SMSAs), and, in New England, to minor civil divisions (MCDs). The relationships between ZIP codes and other geographical units are based on 1979 boundaries, and changes since that time are not reflected. The Census Bureau used various sources to determine ZIP code-county or ZIP code-MCD relationships. In the cases where the sources were confusing or contradictory as to the geographical boundaries of a ZIP code, multiple ZIP-code records (each representing the territory contained in that ZIP-code area) were included in the data file. As a result, the file tends to overstate the ZIP code-county or ZIP code-MCD crossovers. The file is organized by ZIP code and is a byproduct of data used to administer the 1980 Census. Variables include ZIP codes, post office names, FIPS state and county codes, county or MCD names, and SMSA codes.
Facebook
TwitterA crosswalk dataset matching US ZIP codes to corresponding census tracts
The denominators used to calculate the address ratios are the ZIP code totals. When a ZIP is split by any of the other geographies, that ZIP code is duplicated in the crosswalk file.
**Example: **ZIP code 03870 is split by two different Census tracts, 33015066000 and 33015071000, which appear in the tract column. The ratio of residential addresses in the first ZIP-Tract record to the total number of residential addresses in the ZIP code is .0042 (.42%). The remaining residential addresses in that ZIP (99.58%) fall into the second ZIP-Tract record.
So, for example, if one wanted to allocate data from ZIP code 03870 to each Census tract located in that ZIP code, one would multiply the number of observations in the ZIP code by the residential ratio for each tract associated with that ZIP code.
https://redivis.com/fileUploads/4ecb405e-f533-4a5b-8286-11e56bb93368%3E" alt="">(Note that the sum of each ratio column for each distinct ZIP code may not always equal 1.00 (or 100%) due to rounding issues.)
Census tract definition
A census tract, census area, census district or meshblock is a geographic region defined for the purpose of taking a census. Sometimes these coincide with the limits of cities, towns or other administrative areas and several tracts commonly exist within a county. In unincorporated areas of the United States these are often arbitrary, except for coinciding with political lines.
Further reading
The following article demonstrates how to more effectively use the U.S. Department of Housing and Urban Development (HUD) United States Postal Service ZIP Code Crosswalk Files when working with disparate geographies.
Wilson, Ron and Din, Alexander, 2018. “Understanding and Enhancing the U.S. Department of Housing and Urban Development’s ZIP Code Crosswalk Files,” Cityscape: A Journal of Policy Development and Research, Volume 20 Number 2, 277 – 294. URL: https://www.huduser.gov/portal/periodicals/cityscpe/vol20num2/ch16.pdf
Contact information
Questions regarding these crosswalk files can be directed to Alex Din with the subject line HUD-Crosswalks.
Acknowledgement
This dataset is taken from the U.S. Department of Housing and Urban Development (HUD) office: https://www.huduser.gov/portal/datasets/usps_crosswalk.html#codebook
Facebook
TwitterMIT Licensehttps://opensource.org/licenses/MIT
License information was derived automatically
Table contains count and percentage of housing units in the county that were built before 1980. Data are presented at county, city, zip code and census tract level. Data are presented for zip codes (ZCTAs) fully within the county. Source: U.S. Census Bureau, 2016-2020 American Community Survey 5-year estimates, Table B25034; data accessed on July 20, 2022 from https://api.census.gov. The 2020 Decennial geographies are used for data summarization.METADATA:notes (String): Lists table title, notes, sourcesgeolevel (String): Level of geographyGEOID (Numeric): Geography IDNAME (String): Name of geographyHU_total (Numeric): Total housing unitsHU_before1980 (Numeric): Number of housing units built before 1980pct_before1980 (Numeric): Percent of housing units built before 1980
Facebook
TwitterThe 1990 Census Block Statistics portion of the Archive of Census Related Products (ACRP) contains population and housing data from the U.S. Census Bureau's 1990 Summary Tape File (STF1B). The population data includes total population, age, race, and hispanic origin, while the housing data comprises number of housing Units, tenure, room density, mean contract rent, mean value, and mean number of rooms. Additional data includes land area, water area, centroids, Metropolitan Statistical Area (MSA) codes, place codes, and special area codes. This portion of the ACRP is produced by the Columbia University Center for International Earth Science Information Network (CIESIN).
Facebook
Twitterhttps://www.icpsr.umich.edu/web/ICPSR/studies/8318/termshttps://www.icpsr.umich.edu/web/ICPSR/studies/8318/terms
This data collection is a component of Summary Tape File (STF) 3, which consists of four sets of data files containing detailed tabulations of the nation's population and housing characteristics produced from the 1980 Census. The STF 3 files contain sample data inflated to represent the total United States population. The files also contain 100-percent counts and unweighted sample counts of persons and housing units. All files in the STF 3 series are identical, containing 321 substantive data variables organized in the form of 150 "tables," as well as standard geographic identification variables. Population items tabulated for each person include demographic data and information on schooling, Spanish origin, language spoken at home and ability to speak English, labor force status in 1979, residency in 1975, number of children ever born, means of transportation to work, current occupation, industry, and 1979 details on occupation, hours worked, and income. Housing items include size and condition of the housing unit as well as information on value, age, water, sewage and heating, number of vehicles, and monthly owner costs (e.g., sum of payments for real estate taxes, property insurance, utilities, and regular mortgage payments). Selected aggregates and medians are also provided. Each dataset in STF 3 provides different geographic coverage. Summary Tape File 3B provides summaries for each 5-digit ZIP-code area within a state, and for 5-digit ZIP-code areas within states that were contained within Standard Metropolitan Statistical Areas (SMSAs), portions of SMSAs, or within counties, county portions, or county equivalents. All persons and housing units in the United States were sampled. Population and housing items include household relationship, sex, race, age, marital status, Hispanic origin, number of units at address, complete plumbing facilities, number of rooms, whether owned or rented, vacancy status, and value for noncondominiums. The Census Bureau's machine-readable data dictionary for STF 3 is also available through CENSUS OF POPULATION AND HOUSING, 1980 [UNITED STATES]: CENSUS SOFTWARE PACKAGE (CENSPAC) VERSION 3.2 WITH STF4 DATA DICTIONARIES (ICPSR 7789), the software package designed specifically by the Census Bureau for use with the 1980 Census data files.
Facebook
TwitterUpdates data on the size, composition and territorial distribution of the population, households and existing housing in the country. Data 2020.
Facebook
TwitterHousing Units by Type by U.S. Postal ZIP Code from the 2000 Decennial Census
Facebook
TwitterSummary File 1 (SF1) Urban/Rural Update contains summary statistics on population and housing subjects derived from the responses to the 2010 Census questionnaire. Population items include sex, age, race, Hispanic or Latino origin, household relationship, household type, household size, family type, family size, and group quarters. Housing items include occupancy status, vacancy status, and tenure (whether a housing unit is owner-occupied or renter-occupied). The summary statistics are presented in 333 tables, which are tabulated for multiple levels of observation (called "summary levels" in the Census Bureau's nomenclature), including, but not limited to, regions, divisions, states, metropolitan/micropolitan statistical areas, counties, county subdivisions, places, congressional districts, American Indian Areas, Alaska Native Areas, Hawaiian Home Lands, ZIP Code tabulation areas, census tracts, block groups, and blocks. There are 177 population tables and 58 housing tables shown down to the block level; 84 population tables and 4 housing tables shown down to the census tract level; and 10 population tables shown down to the county level. Some of the summary areas are iterated for "geographic components" or portions of geographic areas, e.g., the principal city of a metropolitan statistical area (MSA) or the urban and rural portions of a MSA. With one variable per table cell and additional variables with geographic information, the collection comprises 2,597 data files, 49 per state, the District of Columbia, Puerto Rico, and the National File. The Census Bureau released SF1 in three stages: initial release, National Update, and Urban/Rural Update. The National Update added summary levels for the United States, regions, divisions, and geographic areas that cross state lines such as Combined Statistical Areas. This update adds urban and rural population and housing unit counts, summary levels for urban areas and the urban/rural components of census tracts and block groups, geographic components involving urbanized areas and urban clusters, and two new tables (household type by relationship for the population 65 years and over and a new tabulation of the total population by race). The initial release and National Update is available as ICPSR 33461. ICPSR supplies this data collection in 54 ZIP archives. There is a separate archive for each state, the District of Columbia, Puerto Rico, and the National File. The last archive contains a Microsoft Access database shell and additional documentation files besides the codebook.
Facebook
TwitterApache License, v2.0https://www.apache.org/licenses/LICENSE-2.0
License information was derived automatically
A dataset comprising various variables around housing and demographics for the top 50 American cities by population.
Variables:
Zip Code: Zip code within which the listing is present.
Price: Listed price for the property.
Beds: Number of beds mentioned in the listing.
Baths: Number of baths mentioned in the listing.
Living Space: The total size of the living space, in square feet, mentioned in the listing.
Address: Street address of the listing.
City: City name where the listing is located.
State: State name where the listing is located.
Zip Code Population: The estimated number of individuals within the zip code. Data from Simplemaps.com.
Zip Code Density: The estimated number of individuals per square mile within the zip code. Data from Simplemaps.com.
County: County where the listing is located.
Median Household income: Estimated median household income. Data from the U.S. Census Bureau.
Latitude: Latitude of the zip code. ** Data from Simplemaps.com.**
Longitude: Longitude of the zip code. Data from Simplemaps.com.
Facebook
TwitterCC0 1.0 Universal Public Domain Dedicationhttps://creativecommons.org/publicdomain/zero/1.0/
License information was derived automatically
Although the American Community Survey (ACS) produces population, demographic and housing unit estimates, for 2020, the 2020 Census provides the official counts of the population and housing units for the nation, states, counties, cities, and towns. For 2016 to 2019, the Population Estimates Program provides estimates of the population for the nation, states, counties, cities, and towns and intercensal housing unit estimates for the nation, states, and counties..Supporting documentation on code lists, subject definitions, data accuracy, and statistical testing can be found on the American Community Survey website in the Technical Documentation section.Sample size and data quality measures (including coverage rates, allocation rates, and response rates) can be found on the American Community Survey website in the Methodology section..Source: U.S. Census Bureau, 2016-2020 American Community Survey 5-Year Estimates.Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted roughly as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see ACS Technical Documentation). The effect of nonsampling error is not represented in these tables..For more information on understanding race and Hispanic origin data, please see the Census 2010 Brief entitled, Overview of Race and Hispanic Origin: 2010, issued March 2011. (pdf format).The Hispanic origin and race codes were updated in 2020. For more information on the Hispanic origin and race code changes, please visit the American Community Survey Technical Documentation website..The 2016-2020 American Community Survey (ACS) data generally reflect the September 2018 Office of Management and Budget (OMB) delineations of metropolitan and micropolitan statistical areas. In certain instances, the names, codes, and boundaries of the principal cities shown in ACS tables may differ from the OMB delineation lists due to differences in the effective dates of the geographic entities..Estimates of urban and rural populations, housing units, and characteristics reflect boundaries of urban areas defined based on Census 2010 data. As a result, data for urban and rural areas from the ACS do not necessarily reflect the results of ongoing urbanization..Explanation of Symbols:- The estimate could not be computed because there were an insufficient number of sample observations. For a ratio of medians estimate, one or both of the median estimates falls in the lowest interval or highest interval of an open-ended distribution.N The estimate or margin of error cannot be displayed because there were an insufficient number of sample cases in the selected geographic area. (X) The estimate or margin of error is not applicable or not available.median- The median falls in the lowest interval of an open-ended distribution (for example "2,500-")median+ The median falls in the highest interval of an open-ended distribution (for example "250,000+").** The margin of error could not be computed because there were an insufficient number of sample observations.*** The margin of error could not be computed because the median falls in the lowest interval or highest interval of an open-ended distribution.***** A margin of error is not appropriate because the corresponding estimate is controlled to an independent population or housing estimate. Effectively, the corresponding estimate has no sampling error and the margin of error may be treated as zero.
Facebook
TwitterThe 1990 Zip Equivalency Files portion of the Archive of Census Related Products (ACRP) contains population and housing data derived from the U.S. Census Bureau's 1990 STF3B header file. The data are available at the census block and census blockgroup levels, and encompass 5-digit zip codes, POLygon IDentification (POLID) block fields that correspond to the POLID of the Tiger-based boundary file, and population centroids. This portion of the ACRP is produced by the Center for International Earth Science Information Network (CIESIN).
Facebook
Twitterhttps://www.icpsr.umich.edu/web/ICPSR/studies/8323/termshttps://www.icpsr.umich.edu/web/ICPSR/studies/8323/terms
Master Area Reference Files (MARFs) link geographic areas with their respective numeric codes. This data collection is a five-digit ZIP-code equivalency file created for the 1980 Census of Population and Housing. The data contain geographic items from Summary Tape Files 1A and 3A, as well as total population and housing unit counts. This equivalency file was created to allow users to prepare additional data summaries relevant to ZIP-code areas. The file enables users to equate detailed record files having ZIP codes with census geographic units. This national file is hierarchically sequenced by geographic area.
Facebook
Twitterhttps://www.icpsr.umich.edu/web/ICPSR/studies/34755/termshttps://www.icpsr.umich.edu/web/ICPSR/studies/34755/terms
This data collection contains summary statistics on population and housing subjects derived from the responses to the 2010 Census questionnaire. Population items include sex, age, average household size, household type, and relationship to householder such as nonrelative or child. Housing items include tenure (whether a housing unit is owner-occupied or renter-occupied), age of householder, and household size for occupied housing units. Selected aggregates and medians also are provided. The summary statistics are presented in 71 tables, which are tabulated for multiple levels of observation (called "summary levels" in the Census Bureau's nomenclature), including, but not limited to, regions, divisions, states, metropolitan/micropolitan areas, counties, county subdivisions, places, ZIP Code Tabulation Areas (ZCTAs), school districts, census tracts, American Indian and Alaska Native areas, tribal subdivisions, and Hawaiian home lands. There are 10 population tables shown down to the county level and 47 population tables and 14 housing tables shown down to the census tract level. Every table cell is represented by a separate variable in the data. Each table is iterated for up to 330 population groups, which are called "characteristic iterations" in the Census Bureau's nomenclature: the total population, 74 race categories, 114 American Indian and Alaska Native categories, 47 Asian categories, 43 Native Hawaiian and Other Pacific Islander categories, and 51 Hispanic/not Hispanic groups. Moreover, the tables for some large summary areas (e.g., regions, divisions, and states) are iterated for portions of geographic areas ("geographic components" in the Census Bureau's nomenclature) such as metropolitan/micropolitan statistical areas and the principal cities of metropolitan statistical areas. The collection has a separate set of files for every state, the District of Columbia, Puerto Rico, and the National File. Each file set has 11 data files per characteristic iteration, a data file with geographic variables called the "geographic header file," and a documentation file called the "packing list" with information about the files in the file set. Altogether, the 53 file sets have 110,416 data files and 53 packing list files. Each file set is compressed in a separate ZIP archive (Datasets 1-56, 72, and 99). Another ZIP archive (Dataset 100) contains a Microsoft Access database shell and additional documentation files besides the codebook. The National File (Dataset 99) constitutes the National Update for Summary File 2. The National Update added summary levels for the United States as a whole, regions, divisions, and geographic areas that cross state lines such as Core Based Statistical Areas.
Facebook
TwitterThe United States census count (also known as the Decennial Census of Population and Housing) is a count of every resident of the US. The census occurs every 10 years and is conducted by the United States Census Bureau. Census data is publicly available through the census website, but much of the data is available in summarized data and graphs. The raw data is often difficult to obtain, is typically divided by region, and it must be processed and combined to provide information about the nation as a whole. The United States census dataset includes nationwide population counts from the 2000 and 2010 censuses. Data is broken out by gender, age and location using zip code tabular areas (ZCTAs) and GEOIDs. ZCTAs are generalized representations of zip codes, and often, though not always, are the same as the zip code for an area. GEOIDs are numeric codes that uniquely identify all administrative, legal, and statistical geographic areas for which the Census Bureau tabulates data. GEOIDs are useful for correlating census data with other censuses and surveys. This public dataset is hosted in Google BigQuery and is included in BigQuery's 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets. What is BigQuery .
Facebook
TwitterThe Bureau of the Census has released Census 2000 Summary File 1 (SF1) 100-Percent data. The file includes the following population items: sex, age, race, Hispanic or Latino origin, household relationship, and household and family characteristics. Housing items include occupancy status and tenure (whether the unit is owner or renter occupied). SF1 does not include information on incomes, poverty status, overcrowded housing or age of housing. These topics will be covered in Summary File 3. Data are available for states, counties, county subdivisions, places, census tracts, block groups, and, where applicable, American Indian and Alaskan Native Areas and Hawaiian Home Lands. The SF1 data are available on the Bureau's web site and may be retrieved from American FactFinder as tables, lists, or maps. Users may also download a set of compressed ASCII files for each state via the Bureau's FTP server. There are over 8000 data items available for each geographic area. The full listing of these data items is available here as a downloadable compressed data base file named TABLES.ZIP. The uncompressed is in FoxPro data base file (dbf) format and may be imported to ACCESS, EXCEL, and other software formats. While all of this information is useful, the Office of Community Planning and Development has downloaded selected information for all states and areas and is making this information available on the CPD web pages. The tables and data items selected are those items used in the CDBG and HOME allocation formulas plus topics most pertinent to the Comprehensive Housing Affordability Strategy (CHAS), the Consolidated Plan, and similar overall economic and community development plans. The information is contained in five compressed (zipped) dbf tables for each state. When uncompressed the tables are ready for use with FoxPro and they can be imported into ACCESS, EXCEL, and other spreadsheet, GIS and database software. The data are at the block group summary level. The first two characters of the file name are the state abbreviation. The next two letters are BG for block group. Each record is labeled with the code and name of the city and county in which it is located so that the data can be summarized to higher-level geography. The last part of the file name describes the contents . The GEO file contains standard Census Bureau geographic identifiers for each block group, such as the metropolitan area code and congressional district code. The only data included in this table is total population and total housing units. POP1 and POP2 contain selected population variables and selected housing items are in the HU file. The MA05 table data is only for use by State CDBG grantees for the reporting of the racial composition of beneficiaries of Area Benefit activities. The complete package for a state consists of the dictionary file named TABLES, and the five data files for the state. The logical record number (LOGRECNO) links the records across tables.