Work with interactive mapping tools from across the Census Bureau.
Read briefs and reports from Census Bureau experts.
Watch Census Bureau vignettes, testimonials, and video files.
Read research analyses from Census Bureau experts.
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.
Explore Census data with interactive visualizations covering a broad range of topics.
Information about the U.S. Census Bureau.
Information about what we do at the U.S. Census Bureau.
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.
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)