Introducing a new way to navigate by topics. Access the latest news, data, publications and more around topics of interest.
Our population statistics cover age, sex, race, Hispanic origin, migration, ancestry, language use, veterans, as well as population estimates and projections.
This section provides information on a range of educational topics, from educational attainment and school enrollment to school districts, costs and financing.
We measure the state of the nations workforce, including employment and unemployment levels, weeks and hours worked, occupations, and commuting.
Our statistics highlight trends in household and family composition, describe characteristics of the residents of housing units, and show how they are related.
Health statistics on insurance coverage, disability, fertility and other health issues are increasingly important in measuring the nation's overall well-being.
We measure the housing and construction industry, track homeownership rates, and produce statistics on the physical and financial characteristics of our homes.
The U.S. Census Bureau is the official source for U.S. export and import statistics and regulations governing the reporting of exports from the U.S.
The U.S. Census Bureau provides data for the Federal, state and local governments as well as voting, redistricting, apportionment and congressional affairs.
Search an alphabetical index of keywords and phrases to access Census Bureau statistics, publications, products, services, data, and data tools.
Geography provides the framework for Census Bureau survey design, sample selection, data collection, tabulation, and dissemination.
Geography is central to the work of the Bureau, providing the framework for survey design, sample selection, data collection, tabulation, and dissemination.
Find resources on how to use geographic data and products with statistical data, educational blog postings, and presentations.
The Geographic Support System Initiative will integrate improved address coverage, spatial feature updates, and enhanced quality assessment and measurement.
Work with interactive mapping tools from across the Census Bureau.
Find geographic data and products such as Shapefiles, KMLs, TIGERweb, boundary files, geographic relationship files, and reference and thematic maps.
Metropolitan and micropolitan areas are geographic entities used by Federal statistical agencies in collecting, tabulating, and publishing Federal statistics.
Find information about specific partnership programs and learn more about our partnerships with other organizations.
Definitions of geographic terms, why geographic areas are defined, and how the Census Bureau defines geographic areas.
We conduct research on geographic topics such as how to define geographic areas and how geography changes over time.
Visit our library of Census Bureau multimedia files. Collection formats include audio, video, mobile apps, images, and publications.
Official audio files from the Census Bureau, including "Profile America," a daily series of bite-sized statistics, placing current data in a historical context.
Infographics include information on the Census Bureau's history of data collection, our nation's veterans and the American Community Survey.
Stock photos that illustrate official Census Bureau operations and activities.
Read briefs and reports from Census Bureau experts.
Watch Census Bureau vignettes, testimonials, and video files.
Read research analyses from Census Bureau experts.
Access data through products and tools including data visualizations, mobile apps, interactive web apps and other software.
Developer portal to access services and documentation for the Census Bureau's APIs.
Explore Census Bureau data on your mobile device with interactive tools.
Find a multitude of DVDs, CDs and publications in print by topic.
These external sites provide more data.
Download extraction tools to help you get the in-depth data you need.
Learn more about our data from this collection of e-tutorials, presentations, webinars and other training materials. Sign up for training sessions.
Explore Census data with interactive visualizations covering a broad range of topics.
Learn how we serve the public as the most reliable source of data about the nation's people and economy.
Information about the U.S. Census Bureau.
Information about what we do at the U.S. Census Bureau.
Our researchers explore innovative ways to conduct surveys, increase respondent participation, reduce costs, and improve accuracy.
Our surveys provide periodic and comprehensive statistics about the nation, critical for government programs, policies, and decisionmaking.
Learn about other opportunities to collaborate with us.
Explore the rich historical background of an organization with roots almost as old as the nation.
Explore prospective positions available at the U.S. Census Bureau.
Information about the current field vacancies available at the U.S. Census Bureau Regional Offices.
Discover the latest in Census Bureau data releases, reports, and events.
The Census Bureau's Director writes on how we measure America's people, places and economy.
Find interesting and quirky statistics regarding national celebrations and major events.
Profile America is a daily, 60-second feature that uses interesting vignettes for that day to highlight information collected by the Census Bureau.
Find media toolkits, advisories, and all the latest Census news.
See what's coming up in releases and reports.
Windows XP File Download Setting
Basic Information on Mastgroups File
Basic Information on Mastdata File
Locating the Correct Data File
Locating Corresponding Columns Associating with Selected Item_Id
Data Type Applied
Mastgroups File Format
Mastdata File Format
Appendix A - Source Notes and Explanations
Questions or Additional Information
1) Mastgroups - (KeyAbr and KeyAbreviation)
Open Excel file Mastgroups. It will have two columns KeyAbr and Descript. In column KeyAbr, the user will find a standard three character abbreviation or acronymn for its official title as listed under Descript. Try to become familiar with the three character abbreviation or acronymn being used.
If a user is interested in the descript of Agriculture - NAICS then they should write down or become familiar with the abbreviation or acronymn of AGN. This will come into play when the user next opens the Mastdata file.
2) Mastdata - (Item_id and Item_Description)
Next, open file Mastdata. This Excel file has two columns with column names of Item_id and Item_description (row 1).
Column Item_id provides a name of an Excel column, for example, AFN110197D. The AFN of AFN110197D indicates this is AFN type data. The 110 of AFN110197D indicates the group-series number of AFN data. The 197 of AFN110197D indicates this is data of the year 1997, and D stands for data. Likewise, 202 of AFN110202D indicates this is data of the year 2002.
The user should examine the titles in column Item_description and locate the description they are looking for. Once a user locates an Item_description they are looking for, make note of the Item_id corresponding to that Item_description. That Item_id is column name the user will be looking for in one of the actual Excel data files.
3) Locating the Correct Data File, with selected data columns
If a user is interested in file AGE110197D, they examine Excel files AGE01.xls, AGE02.xls, or AGE03.xls, or they may use zip file AGE.zip. The columns of files AGE01.xls, AGE02.xls, and AGE03.xls are listed in alphabetical order. For example, for AGE series, the columns would range from AGE010180D to AGE430202D in AGE01, AGE430203D to AGE830205D in AGE02, and AGE830206D to AGE900206D in AGE03. Therefore, column AGE110197D would be located in the AGE010180D to AGE430202D range, which can be found in files AGE01.xls orAGE.zip.
Note that sum topics only have one related file, and some may have 2,3,4 or more files related to the key topic. The example above in reference to AGE has three files AGE01, AGE02, or AGE03.
4) Locating the Corresponding Columns of the Selected Item_id
Every data file, e.g. AGE01, AGE02, or AGE03, has its first two columns as Areaname and STCOU. STCOU stands for the State-County code of a specific region (county, state, federal). Each Item_id, e.g., AFN110197D has four columns (flag, data values, footkey1, footkey2). The name ending with F is the flag column of the selected Item_id, for example, AFN110197F. The name ending with D is the datavalue column of the selected Item_id, i.e., AFN110197D. The name ending with N1 is the Footnote1 column of the selected Item_id, i.e., AFN110197N1. The name ending with N2 is the Footnote2 column of the selected Item_id, i.e., AFN110197N2.
Each table selected (Item_id) has four corresponding columns of data: flag, datavalue,
footkey1, footkey2 e.g. AFN110197F, AFN110197D, AFN110197N1, and AFN110197N2.
5) Data type
Moreover, the flag column of a selected Item_id is integer data and the datavalue column of a selected Item_id is double (numeric) data. The Footkey1 and Footkey2 columns of a selected Item_id are text data. The STCOU column is text data, and the Areaname column is text data.
|Field 1:||KeyAbr (text data)||Acronym for Mastgroup title in DESCRIPT field, e.g. acronym HEA stands for Health|
|Field 2:||DESCRIPT (text data)||Name of a specific group of data e.g. Health is a group, where there may be many individual Health files (Excel columns)|
|Field 1:||Item_Id (text data)||Official name of data subject (e.g. AFN110197D has four parts: mastgroup, file number, year of data, and D. In this case the mastgroup is AFN and the file number is 110. The year is 197 which stands for 1997 and is followed by the letter D)|
|Field 2:||Item_Description (text data)||Detail description of name under Item_Id|
|Field 1:||ID (text data)||Acronym for Unit Description|
|Field 2:||DESCRIPT||Units in reference to data value|
|Field 1:||ID (text data)||Acronym for Description (Data Provider)|
|Field 2:||DESCRIPTION (text data)||Name of data provider|
|Field 1:||ID (text data)||Four digit footnote code|
|Field 2:||DESCRIPTION (text data)||Detail description corresponding to footnote code|
|Field 1:||ID (text data)||Id of a particular flag_reference|
|Field 2:||DESCRIPTION (text data)||Detail description of a particular flag reference|
For comments on data quality, see Appendix A - Source Notes and Explanations [PDF, 203KB] from the 2007 edition of the country and City Data Book
For further information visit https://ask.census.gov
Source: U.S. Census Bureau