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.
The geographic file is fixed width with no field delimiters; Both data files are comma delimited. None of the files contain header records (a first record with field names).
The only relationship between any one file (geographic or data) and another is the field LOGRECNO (logical record number). This field is a unique key. There is a one to one correspondence based on LOGRECNO between the geographic file and both data files.
The directions for unzipping the data files given below apply only to PKZIP for Windows 4.0 or higher (available from pkware.com ).
Some data files are too large to import into Access 97. More recent versions of Access can be used for these cases.
Access 2000 does not recognize the "uf1" file name extension (not related to file format). Change the file name extensions of the uncompressed ASCII text data files from "uf1" to "txt". This must be done from a DOS prompt (using the rename command) for most versions of Windows.
Volume in drive C has no label Volume Serial Number is 1057-18CE Directory of C:\sf1ascii DEGEO UF1 8,161,404 09-13-01 12:04p degeo.uf1 DE00001 UF1 9,813,749 09-13-01 12:05p de00001.uf1 2 file(s) 17,975,153 bytes 0 dir(s) 134,721,536 bytes free C:\sf1ascii>rename *.uf1 *.txt C:\sf1ascii>dir *.txt Volume in drive C has no label Volume Serial Number is 1057-18CE Directory of C:\sf1ascii DE00001 TXT 9,813,749 09-13-01 12:05p de00001.txt DEGEO TXT 8,161,404 09-13-01 12:04p degeo.txt 2 file(s) 17,975,153 bytes 0 dir(s) 134,721,536 bytes free C:\sf1ascii>
[Back to Top]Deciding which files to use
A data set for a state consists of a geographic file and two data files. The data was split into multiple files due to a limit in the number of fields allowed per record in most popular database and spreadsheet programs.
All geographic data identifiers (area names, FIPS codes, etc.) are in the geographic file only. See chapter 3: Subject Locator in the technical documentation to identify tables you want. Go to Chapter 2: How to Use This File to identify the data files(s) that contain these tables. Also, see file layouts ( in ASCII format).
Technical documentation [, 3,994 KB]
[Back to Top] Uncompressing the data files
The data files contain a line feed character only at the end of each record. For successful use with many programs running in a Windows environment1, these files need to be modified to use the ASCII carriage return/line feed sequence, chr(13) + chr(10), as a record terminator. PKZIP for Windows version 4.00 instructions appear below.
Select "None - no conversion" under the Miscellaneous section to unzip file structures downloaded from this page.
[Back to Top]Using Microsoft Access (tm)