README File for ACS 2003 Data Products Delivered via FTP Data Available at this FTP Site Three types of data products are provided on this site – core tables, profiles and ranking tables. Core tables provide basic housing and population characteristics these tables are the foundation upon which higher-level profiles are built. The core tables come complete with the margin of error, as indicated by the upper and lower bounds around the estimate. These bounds represent the 90-percent confidence interval. 2003 Single-Year Profiles provide estimates of selected demographic, social, economic, and housing characteristics for each geographic area. The profiles come complete with the margin of error, as indicated by the upper and lower bounds around the estimate. These bounds represent the 90-percent confidence interval. 2000-2003 Multi-Year Profiles use estimates from the single-year tabular profiles to show year-to-year changes, the related percentage distributions, and whether the differences are statistically significant. Ranking tables and graphs show how state and large jurisdictions compare to each other for 19 selected characteristics. The survey estimates and 90-percent confidence intervals are shown on the graph so a data user can easily view the statistical significance of comparisons among jurisdictions. In addition, spreadsheets are provided which can be used to determine if a difference in a rank for two geographic areas are statistically significant. Finding the Data Under the FTP directory, there are three sub-directories, Core_Tables, Ranking_Tables and Profiles. Core Tables The Core_Tables directory contains all of the published core detailed tables. The core detailed tables are stored in the Core_Tables directory by geography summary level, using the following naming convention "ACS_2003_" geography summary level ".zip". The geography levels are: Geography summary level Description 010 Nation 040 State 050 County 060 County Subdivision 155 Place - County (part) 160 Place 380 Consolidated Metropolitan Statistical Area/Metropolitan Statistical Area 385 Primary Metropolitan Statistical Area 500 Congressional District (108th Congress) 001 ACS Test Site Each one of these zipped files contain a csv file with the following file layout [Variable name in brackets]: Column 1-Geography ID [GEOID] Column 2-Table ID [TBLID] Column 3-Line Number within Table [ORDER] Column 4-Direct Estimate [EST] Column 5-Lower Bound Estimate [LB] Column 6-Upper Bound Estimate [UB] There is also a file named ACS_2003_META.zip that contains a # delimited file ACS_2003_META.txt; this file contains all core table metadata with the following file layout [Variable name in brackets]: Column 1-Table ID [TBLID] Column 2-Line Number (A line number of 'T' represents the Core Table's Title) [ORDER] Column 3-Stub [STUB] There is also a file named geograpghy_key.xls this file contains which geography ID matches up to which geography name. Profiles The Profiles directory is subdivided into the following directories: 2000-2003_Profiles and 2003_Profiles. Each of these directories contains one spreadsheet for the United States and separate directories for each state (including the District of Columbia) and geographic summary level. The state directories contain one state spreadsheet and, depending upon the data available, up to eight subdirectories for the following geographic levels: Geography summary level Description 050 County 060 County Subdivision 155 Place - County (part) 160 Place 380 Consolidated Metropolitan Statistical Area/ Metropolitan Statistical Area 385 Primary Metropolitan Statistical Area 500 Congressional District (108th Congress) 001 ACS Test Site The 2000-2003_Profiles and 2003_Profiles directories also contain subdirectories for files in an entire geographic summary level for example: the 050County directory contains all published counties regardless of state. In the 2003_Profiles directories for an entire geographic summary level (example: 050County) there will also be a comma delimited file that contains all published geographies for that geography level with the naming convention of "total" geography summary level ".csv"; the file layout is as follows: Column 1-Geography ID [geoid] Column 2-Table ID [PROFTBL] Column 3-Line Number within Table [PROFLN] Column 4-Direct Estimate [CEST] Column 5-Lower Bound Estimate [CLB] Column 6-Upper Bound Estimate [CUB] The geograpghy_key.xls file will also match up to the 2003 profiles geography, for reference purposes a key of what stub matches to what line is located at csv_2003_profile_layout.xls under the 2003_Profiles directory. In the 2000-2003_Profiles directory there is file named total_multiyearprofile.csv this file contains all published 2000-2003 profiles (195 geographies published) in a csv format with the following layout: Column 1-Geography Name [GEONAME] Column 2-Table ID [PROFTBL] Column 3-Line Number within Table [PROFLN] Column 4-Stub [STUB] Column 5-2000 Estimate [pctd_00] Column 6-2001 Estimate [pctd_01] Column 7-2002 Estimate [pctd_02] Column 8-2003 Estimate [pctd_03] Note: 2000-2003 Estimates Data followed by an * indicates a Significant Difference at the 90 percent level between that data and the data from the most current year. Ranking Charts Under the Ranking_Tables directory there is a subdirectory for each ranked characteristic with the characteristic as the name and subdirectories for the three geography levels being ranked. Each of these directories contains up to three subdirectories: State, County, and Place. The ranked characteristics are: Average Travel Time to Work of Workers 16 Years and Over Who Did Not Work at Home Median Family Income Median Household Income Median Housing Value of Specified Owner-Occupied Housing Units With a Mortgage Median Monthly Housing Costs for Renter-occupied Housing Units Median Monthly Housing Costs for Specified Owner-occupied Housing Units Percent of Children Under 18 Years Below Poverty Level in the Past 12 Months Percent of Children Under 6 Years Old With All Parents in the Labor Force (State only) Percent of Occupied Housing Units That are Owner-occupied Percent of People 16 Years and Over Who are in the Labor Force (State only) Percent of People 25 Years and Over Who Have Completed a Bachelor's Degree Percent of People 25 Years and Over Who Have Completed High School Percent of People 5 Years and Over Who Speak a Language Other Than English At Home Percent of People 5 Years and Over Who Speak Spanish at Home Percent of People 65 Years and Over Below Poverty Level in the Past 12 Months (State only) Percent of People Below Poverty Level in the Past 12 Months Percent of Population That is Foreign Born Percent of Related Children Under 18 Years Below Poverty Level in the Past 12 Months (State only) Percent of the Civilian Population 18 Years and Over Who are Veterans About the FTP Application About the FTP Application TC \l1 "About the FTP Application This FTP (File Transfer Protocol) application is intended for users of census data, compressed files, and spreadsheet/database software. It provides quick access to data users, such as State Data Centers and news media, who need to begin their analysis immediately upon data release. Each state directory provides all files available for the identified state. Once downloaded, the data are in Excel or PDF format. No software is provided. Users of the FTP application can then import it into the spreadsheet/database software of their choice for data analysis and table presentation.Other Sources of the Data TC \l1 "Other Sources of the Data FTP File Transfer To facilitate transferring files, we suggest using features commonly found in most vendors' FTP utility. When testing the download in a PC environment, we used the ws_ftp product. This product, and many other FTP products developed for the PC environment, allows individual or multiple file selection using the control key or block multiple file selection using the shift key. In the UNIX environment, the "mget" command allows the transferring of single or multiple files. Using the ftp command mget, followed by a single filename, will allow a single file to be downloaded. Using the command mget followed by a wildcard character such as *, or *.* , allows multiple files to be downloaded. For example, once you have navigated into the 2003 Profile directory for California, you can download all of the spreadsheets in the County Level subdirectory with the following ftp commands: ftp>binary (set file transfer mode to binary) ftp>prompt off (to avoid being asked for verification of each file, optional) ftp>mget *.* (to copy multiple files) ftp>quit (to exit ftp) Where to find more information: The 2003American Community Survey press release may be found on the Web site at: A fact sheet explaining the differences between the income and poverty estimates from the American Community Survey and the Annual Social and Economic Supplement to the Current Population Survey can be found on the following link: http://www.census.gov/Press-Release/www/2004/factsheet.html In addition, data from previous years can be located on the Census Bureau's ftp site at . For additional information, contact Stephen Buckner in the Census Bureau's Public Information Office on (301) 763-3691. 4 1