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 |
|
