Documentation: ACS 2009 (1-Year Estimates)
you are here: choose a survey survey document chapter
Publisher: U.S. Census Bureau
Document: ACS 2009-1yr Summary File: Technical Documentation
citation:
Social Explorer; U.S. Census Bureau; American Community Survey 2009 Summary File: Technical Documentation.
ACS 2009-1yr Summary File: Technical Documentation
Chapter 5. Data Dictionary - List of Detailed Tables and Sequence Numbers
The Summary Files are created in the American Standard Code for Information Interchange (ASCII) format, and they contain estimates, an ASCII header, file label, and data elements identified by its file position. The files provided within the ACS Summary File product package contain one file providing geographic information that contains one record for each geographic entity, estimate data file and margin of error file. The geographic information file includes logical record numbers assigned to geographies sequentially. The same geography sequence numbers match related data records creating a relationship between the data and geographic information. The documentation on tables and associated sequence numbers can be found in these 2 files: merge_5_6.xls and merge_5_6.sas7bdat, which are available at the top level of the Summary File directory along with the technical documentation. Here is an example of the contents of the merge_5_6.xls file:

Table ID Sequence Number Line Number Start Position Total Cells in Table Table Title Subject Area
B08406 0003   7 51 CELLS SEX OF WORKERS BY MEANS OF TRANSPORTATION TO WORK FOR WORKPLACE GEOGRAPHY Journey to Work
B08406 0003       Universe: Workers 16 years and over  
B08406 0003 1     Total:  
B08406 0003 2     Car, truck, or van:  
B08406 0003 3     Drove alone  
B08406 0003 4     Carpooled:  
B08406 0003 5     In 2-person carpool  
B08406 0003 6     In 3-person carpool  
B08406 0003 7     In 4-or-more-person carpool  
B08406 0003 8     Public transportation (excluding taxicab):  
B08406 0003 9     Bus or trolley bus  
B08406 0003 10     Streetcar or trolley car (carro publico in Puerto Rico)  
B08406 0003 11     Subway or elevated  
B08406 0003 12     Railroad  
B08406 0003 13     Ferryboat  
B08406 0003 14     Bicycle  
B08406 0003 15     Walked  
B08406 0003 16     Taxicab, motorcycle, or other means  
B08406 0003 17     Worked at home  
B08406 0003 18     Male:  
B08406 0003 19     Car, truck, or van:  
B08406 0003 20     Drove alone  
B08406 0003 21     Carpooled:  
B08406 0003 22     In 2-person carpool  
B08406 0003 23     In 3-person carpool  
B08406 0003 24     In 4-or-more-person carpool  
B08406 0003 25     Public transportation (excluding taxicab):  
B08406 0003 26     Bus or trolley bus  
B08406 0003 27     Streetcar or trolley car (carro publico in Puerto Rico)  
B08406 0003 28     Subway or elevated  
B08406 0003 29     Railroad  
B08406 0003 30     Ferryboat  
B08406 0003 31     Bicycle  
B08406 0003 32     Walked  
B08406 0003 33     Taxicab, motorcycle, or other means  
B08406 0003 34     Worked at home  
B08406 0003 35     Female:  
B08406 0003 36     Car, truck, or van:  
B08406 0003 37     Drove alone  
B08406 0003 38     Carpooled:  
B08406 0003 39     In 2-person carpool  
B08406 0003 40     In 3-person carpool  
B08406 0003 41     In 4-or-more-person carpool  
B08406 0003 42     Public transportation (excluding taxicab):  
B08406 0003 43     Bus or trolley bus  
B08406 0003 44     Streetcar or trolley car (carro publico in Puerto Rico)  
B08406 0003 45     Subway or elevated  
B08406 0003 46     Railroad  
B08406 0003 47     Ferryboat  
B08406 0003 48     Bicycle  
B08406 0003 49     Walked  
B08406 0003 50     Taxicab, motorcycle, or other means  
B08406 0003 51     Worked at home  
B08412 0003   58 39 CELLS SEX OF WORKERS BY TRAVEL TIME TO WORK FOR WORKPLACE GEOGRAPHY Journey to Work
B08412 0003       Universe: Workers 16 years and over who did not work at home  
B08412 0003 1     Total:  
B08412 0003 2     Less than 5 minutes  
B08412 0003 3     5 to 9 minutes  
B08412 0003 4     10 to 14 minutes  
B08412 0003 5     15 to 19 minutes  
B08412 0003 6     20 to 24 minutes  
B08412 0003 7     25 to 29 minutes  
B08412 0003 8     30 to 34 minutes  
B08412 0003 9     35 to 39 minutes  
B08412 0003 10     40 to 44 minutes  
B08412 0003 11     45 to 59 minutes  
B08412 0003 12     60 to 89 minutes  
B08412 0003 13     90 or more minutes  
B08412 0003 14     Male:  
B08412 0003 15     Less than 5 minutes  
B08412 0003 16     5 to 9 minutes  
B08412 0003 17     10 to 14 minutes  
B08412 0003 18     15 to 19 minutes  
B08412 0003 19     20 to 24 minutes  
B08412 0003 20     25 to 29 minutes  
B08412 0003 21     30 to 34 minutes  
B08412 0003 22     35 to 39 minutes  
B08412 0003 23     40 to 44 minutes  
B08412 0003 24     45 to 59 minutes  
B08412 0003 25     60 to 89 minutes  
B08412 0003 26     90 or more minutes  
B08412 0003 27     Female:  
B08412 0003 28     Less than 5 minutes  
B08412 0003 29     5 to 9 minutes  
B08412 0003 30     10 to 14 minutes  
B08412 0003 31     15 to 19 minutes  
B08412 0003 32     20 to 24 minutes  
B08412 0003 33     25 to 29 minutes  
B08412 0003 34     30 to 34 minutes  
B08412 0003 35     35 to 39 minutes  
B08412 0003 36     40 to 44 minutes  
B08412 0003 37     45 to 59 minutes  
B08412 0003 38     60 to 89 minutes  
B08412 0003 39     90 or more minutes