Premium access provided by: MIT Personal account: Create | Sign in
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 IDSequence NumberLine NumberStart PositionTotal Cells in TableTable TitleSubject Area
B084060003 751 CELLSSEX OF WORKERS BY MEANS OF TRANSPORTATION TO WORK FOR WORKPLACE GEOGRAPHYJourney to Work
B084060003   Universe: Workers 16 years and over 
B0840600031  Total: 
B0840600032  Car, truck, or van: 
B0840600033  Drove alone 
B0840600034  Carpooled: 
B0840600035  In 2-person carpool 
B0840600036  In 3-person carpool 
B0840600037  In 4-or-more-person carpool 
B0840600038  Public transportation (excluding taxicab): 
B0840600039  Bus or trolley bus 
B08406000310  Streetcar or trolley car (carro publico in Puerto Rico) 
B08406000311  Subway or elevated 
B08406000312  Railroad 
B08406000313  Ferryboat 
B08406000314  Bicycle 
B08406000315  Walked 
B08406000316  Taxicab, motorcycle, or other means 
B08406000317  Worked at home 
B08406000318  Male: 
B08406000319  Car, truck, or van: 
B08406000320  Drove alone 
B08406000321  Carpooled: 
B08406000322  In 2-person carpool 
B08406000323  In 3-person carpool 
B08406000324  In 4-or-more-person carpool 
B08406000325  Public transportation (excluding taxicab): 
B08406000326  Bus or trolley bus 
B08406000327  Streetcar or trolley car (carro publico in Puerto Rico) 
B08406000328  Subway or elevated 
B08406000329  Railroad 
B08406000330  Ferryboat 
B08406000331  Bicycle 
B08406000332  Walked 
B08406000333  Taxicab, motorcycle, or other means 
B08406000334  Worked at home 
B08406000335  Female: 
B08406000336  Car, truck, or van: 
B08406000337  Drove alone 
B08406000338  Carpooled: 
B08406000339  In 2-person carpool 
B08406000340  In 3-person carpool 
B08406000341  In 4-or-more-person carpool 
B08406000342  Public transportation (excluding taxicab): 
B08406000343  Bus or trolley bus 
B08406000344  Streetcar or trolley car (carro publico in Puerto Rico) 
B08406000345  Subway or elevated 
B08406000346  Railroad 
B08406000347  Ferryboat 
B08406000348  Bicycle 
B08406000349  Walked 
B08406000350  Taxicab, motorcycle, or other means 
B08406000351  Worked at home 
B084120003 5839 CELLSSEX OF WORKERS BY TRAVEL TIME TO WORK FOR WORKPLACE GEOGRAPHYJourney to Work
B084120003   Universe: Workers 16 years and over who did not work at home 
B0841200031  Total: 
B0841200032  Less than 5 minutes 
B0841200033  5 to 9 minutes 
B0841200034  10 to 14 minutes 
B0841200035  15 to 19 minutes 
B0841200036  20 to 24 minutes 
B0841200037  25 to 29 minutes 
B0841200038  30 to 34 minutes 
B0841200039  35 to 39 minutes 
B08412000310  40 to 44 minutes 
B08412000311  45 to 59 minutes 
B08412000312  60 to 89 minutes 
B08412000313  90 or more minutes 
B08412000314  Male: 
B08412000315  Less than 5 minutes 
B08412000316  5 to 9 minutes 
B08412000317  10 to 14 minutes 
B08412000318  15 to 19 minutes 
B08412000319  20 to 24 minutes 
B08412000320  25 to 29 minutes 
B08412000321  30 to 34 minutes 
B08412000322  35 to 39 minutes 
B08412000323  40 to 44 minutes 
B08412000324  45 to 59 minutes 
B08412000325  60 to 89 minutes 
B08412000326  90 or more minutes 
B08412000327  Female: 
B08412000328  Less than 5 minutes 
B08412000329  5 to 9 minutes 
B08412000330  10 to 14 minutes 
B08412000331  15 to 19 minutes 
B08412000332  20 to 24 minutes 
B08412000333  25 to 29 minutes 
B08412000334  30 to 34 minutes 
B08412000335  35 to 39 minutes 
B08412000336  40 to 44 minutes 
B08412000337  45 to 59 minutes 
B08412000338  60 to 89 minutes 
B08412000339  90 or more minutes 



« Previous ‹Table of Contents› Next »
©2024 Social Explorer. All rights reserved.