DRAFT: Some links provided may not be active yet.

README

Census 2000 Summary File 3 Delivered via FTP

Contents

About the FTP Application

Other Sources of the Data

File Naming Convention

Technical Documentation

Data Records and Segmentation

File Record Layout

FTP File Transfer

UnZipping the Files

Spreadsheet and Data Base Aids

Maximum File Sizes

About the FTP Application

|	▪ The application is intended for experienced users of census data, compressed files, and spreadsheet/database software.

|	▪ FTP users should have a fast file transfer capability.

|	▪ Users of the FTP application need to unzip the compressed file after downloading, then import it into the spreadsheet/database software of their choice for data analysis and table presentation.

Other Sources of the Data

|	▪ American FactFinder at factfinder.census.gov .

▪ This system provides Internet access to all tables plus additional derived tables called Quick Tables and Geographic Comparison Tables.

|	▪ The system can create thematic maps on various data items.

|	▪The system can create reference maps defining the geographic area.

|	▪ Tables are available on American FactFinder on the morning of public release.

|	▪DVD/CD-ROM

| ▪ CD-ROMs are available for individual states on or shortly after the public release date. These early CD-ROMs are in flat ASCII format without software.

|	▪ DVDs are created after all states are released. These DVD's and the final CD-ROM package contain software.

|	▪ They can be purchased online ($50 for CD-ROM; $70 for DVD) from the Census Catalog (www.census.gov, select Census Catalog from left sidebar) or ordered by telephone from the Customer Services Center (301-457-INFO).

|	▪ DVDs and CD-ROMs contain the same software.

|	▪ Software is proprietary but are in a format the can easily be imported into data bases or spreadsheets.

File Naming Conventions

|▪ The naming convention for geographic header files is ssgeo_uf3.zip

|	▪ ss is USPS state abbreviation

|	▪ The codes are in technical documentation on page 7-1, located at

http://www.census.gov/prod/cen2000/doc/sf3.pdf

|	▪ geo_uf3.zip is a constant across SF3 geographic header names.

|▪ Naming convention for SF3 data files is ssiiiyy_uf3.zip.

|	▪ ss is USPS state abbreviation

|	▪ iii is the characteristic iteration (total population, race groups, American Indian and Alaska Native tribes, and Hispanic/Latino groups). These only apply to SF 2 and SF 4. In SF 1 and SF 3, the characteristic iteration will always be 000.

|	▪ yy is the number of the file

|	▪ Valid codes are 01 through 76. See below for distribution of tables across files.

|	▪_uf3.zip is a constant across SF3 data file names

Technical Documentation

▪ The complete technical documentation for SF3 is available at

http://www.census.gov/prod/cen2000/doc/sf3.pdf .

Data Records and Segmentation

▪ Table distribution across data files is as follows:

Figure 2-2. File/Table Segmentation

File Name

(CIFSN)	NUMBER OF

DATA ITEMS	STARTING

MATRIX

NUMBER	ENDING

MATRIX

NUMBER
stgeo.uf3
st00001.uf3	248	P1	p14
st00002.uf3	218	P15	P24
st00003.uf3	241	P25	P37
st00004.uf3	227	P38	P46
st00005.uf3	220	P47	P50
st00006.uf3	250	P51	P67
st00007.uf3	213	P68	P91
st00008.uf3	245	P92	P138
st00009.uf3	203	P139	P145C
st000010.uf3	245	P145D	P145H
st000011.uf3	235	P145I	P146F
st000012..uf3	246	P146G	P147I
st000013.uf3	241	P148A	P149D
st000014.uf3	245	P149E	p150I
st000015.uf3	239	P151A	P154D
st000016.uf3	240	P154E	P159G
st000017.uf3	239	P159H	P160E
st000018.uf3	164	P160F	P160I
st000019.uf3	247	PCT1	PCT8
st000020.uf3	204	PCT9	PCT15
st000021.uf3	222	PCT16	PCT17
st000022.uf3	235	PCT18	PCT19
st000023.uf3	233	PCT20	PCT24
st000024.uf3	233	PCT25	PCT27
st000025.uf3	221	PCT28	PCT32
st000026.uf3	106	PCT33	PCT34
st000027.uf3	221	PCT35	PCT37
st000028.uf3	162	PCT38	PCT43
st000029.uf3	205	PCT44	PCT48
st000030.uf3	224	PCT49	PCT51
st000031.uf3	205	PCT52	PCT56
st000032.uf3	243	PCT57	PCT61
st000033.uf3	243	PCT62A	PCT63C
st000034.uf3	234	PCT63D	PCT64H
st000035.uf3	231	PCT64I	PCT66C
st000036.uf3	233	PCT66D	PCT67E
st000037.uf3	223	PCT67F	PCT68C
st000038.uf3	245	PCT68D	PCT68H
st000039.uf3	247	PCT68I	PCT69I
st000040.uf3	243	PCT70A	PCT70I
st000041.uf3	245	PCT71A	PCT71E
st000042.uf3	196	PCT71F	PCT71I
st000043.uf3	240	PCT72A	PCT72B
st000044.uf3	240	PCT72C	PCT72D
st000045.uf3	240	PCT72E	PCT72F
st000046.uf3	240	PCT72G	PCT72H
st000047.uf3	215	PCT72I	PCT73A
st000048.uf3	190	PCT73B	PCT73C
st000049.uf3	190	PCT73D	PCT73E
st000050.uf3	190	PCT73F	PCT73G
st000051.uf3	190	PCT73H	PCT73I
st000052.uf3	231	PCT74A	PCT75C
st000053.uf3	236	PCT75D	PCT75G
st000054.uf3	234	PCT75H	PCT76D
st000055.uf3	145	PCT76E	PCT76I
st000056.uf3	127	H1	H18
st000057.uf3	249	H19	H26
st000058.uf3	216	H27	H44
st000059.uf3	250	H45	H68
st000060.uf3	248	H69	H86
st000061.uf3	250	H87	H104
st000062.uf3	59	H105	H121
st000063.uf3	171	HCT1	HCT3
st000064.uf3	115	HCT4	HCT4
st000065.uf3	143	HCT5	HCT5
st000066.uf3	248	HCT6	HCT7
st000067.uf3	219	HCT8	HCT14
st000068.uf3	214	HCT15	HCT17
st000069.uf3	220	HCT18	HCT23
st000070.uf3	248	HCT24	HCT31C
st000071.uf3	246	HCT31D	HCT36
st000072.uf3	246	HCT36E	HCT40I
st000073.uf3	243	HCT41A	HCT43I
st000074.uf3	224	HCT44A	HCT44G
st000075.uf3	247	HCT44H	HCT47F
st000076.uf3	96	HCT47G	HCT48I

▪ Five fields are carried over from the geographic header file into each data file.

|	▪ These fields are file identification (FILEID), state abbreviation (STUSAB),

characteristic iteration (CHARITER), characteristic iteration file sequence number

(CIFSN) and logical record number (LOGRECNO).

▪ These five fields appear in the geographic header file in a fixed field format.

|	▪ These five fields appear in the four data files in a comma delimited format.

|	▪ These fields are used to "match" records in the four data files to the geographic

information in the geoheader.

A file set structure schematic appears in the technical documentation (page xxxxx) which is

located at http://www.census.gov/prod/cen2000/doc/sf3.pdf

File Record Layout

▪ For a layout of the individual tables for each file, see the technical documentation at

www.census.gov/prod/cen2000/doc/sf3.pdf . Select Chapter 6, Summary Table Outlines.

FTP File Transfer

|▪ Summary File 3 (SF3) FTP directory is http://ftp2.census.gov/census_2000/datasets/Summary_File_3 .

|	▪ Each state directory provides all files for the identified state.

|	▪ The directory for each state has a geographic header file and 76 data files.

|	▪ The chart on page 3 of this document lists the table numbers available in each of the 76 files.

|	▪ Once uncompressed, the files are in a flat ASCII format.

|	▪ No software is provided.

|▪ Downloading multiple files

|	▪ UNIX environment—"mget" subcommand allows transfer of multiple files using the

wildcard character.

|	▪ Example: ftp> prompt off

ftp>mget ne* (for this example, Nebraska is selected).

▪ Windows Environment—many FTP products have been developed which have the

capability to download multiple files with a single command.

|	▪ We used the ws_ftp product in testing the download.

|	▪ A demonstration copy is available at http://www.ipswitch.com/

|	▪ An Internet search using the term "download multiple files" yielded other similar

products.

|	▪ For step-by-step instructions with screen shots, please see

http://www.census.gov/support/2000/SF3/ ..

Unzipping the Files

|▪ Files compress at approximately 95% compression.

|▪ Any standard UnZIP software package can be used.

|	▪ In testing we used PKZIP for Windows. It's available at www.pkware.com. .

|▪ Unzipped files are in flat ASCII format.

For step-by-step instructions with screen shots, please see

http://www.census.gov/support/2000/SF3/ .

Unzipped Files

|▪ Geographic header file has fixed fields.

|▪ File data dictionary is at http://www.census.gov/prod/cen2000/doc/sf3.pdf . See chapter 7 for the data dictionary.

|▪ Data files (files 01-76) have comma delimited fields

|	▪ Fields from the geographic header file carried over to the data files are comma

delimited in the data files .

Spreadsheet and Data Base Aids

|▪ For step-by-step instructions with screen shots for moving the data and structure to a spreadsheet, please see www.census.gov/support/SF3ASCII.html .

|▪ Structure files in Access97 and other formats are available at

http://www.census.gov/support/2000/SF3/ .

|▪ We are unable to provide one-on-one support for applications of the data to specific spreadsheets or data base software.

Maximum File Sizes

||▪ The figures below are the maximum file sizes for SF3 and are identical to the sizes for SF1.

||▪ As state tables are run, we will update this listing.

SF3

GeoHeader and File01-File76

Maximum File Sizes

unzipped	zipped

State

Alabama	1.7G	87M

Alaska	.3G	11.7M

Arizona	1.5G	51M

Arkansas	1.5G	35M

California	5.1G	260M

Colorado	1.5G	75M

Connecticut	.6G	28M

Delaware	.2G	7.8M

District of

Columbia	.6G	4.6M

Florida	3.4G	170M

Georgia	2.3G	110M

Hawaii	.2G	27.8M

Idaho	.9G	12.5M

Illinois	4.1G	209M

Indiana	2.1G	108M

Iowa	1.7G	37M

Kansas	1.7G	88M

Kentucky	1.1G	58M

Louisiana	1.5G	77M

Maine	.5G	10M

Maryland	.9G	54M

Massachusetts	1.2G	58M

Michigan	2.7G	136M

Minnesota	2G	105M

Mississippi	1.4G	33.5M

Missouri	2.5G	125M

Montana	.9G	12M

Nebraska	1.4G	21M

Nevada	.7G	23M

New

Hampshire	.3G	8M

New Jersey	1.7G	82M

New Mexico	1.4G	26M

New York	3.6G	180M

North Carolina	2.5G	123M

North Dakota	.9G	8M

Ohio	2.8G	138M

Oklahoma	1.8G	90M

Oregon	1.4G	71M

Pennsylvania	3.5G	174M

Rhode Island	.24G	12M

South Carolina	1.5G	35M

South Dakota	.8G	12M

Tennessee	1.9G	42M

Texas	6.8G	198M

Utah	.8G	21M

Vermont	.25G	8M

Virginia	1.5G	64M

Washington	2G	100M

West Virginia	.9G	18M

Wisconsin	2G	100M

Wyoming	7G	6M

Puerto Rico	.8G	35M

. st represents the United States Postal Service 2-character alphabetic state abbreviation.

5