Bureau of Transportation Statistics (BTS)
Printable Version

Appendix B - Data Dictionary
Post-9/11 Long

Excel | CSV

Variable Name Variable Type Variable Length Label Question Number Value Range Code Frequency Weighted Frequency Data File
ACCDIV Char 2 Access place (to far dest)-Census division   -1 = Appropriate Skip 24,097 2,207,240,281 POST-911 LONG
-9 = Not Ascertained 106 13,487,381  
0 = Puerto Rico and Island Areas 3 113,965  
1 = New England 148 15,486,266  
2 = Middle Atlantic 532 42,462,998  
3 = East North Central 378 35,093,870  
4 = West North Central 201 13,896,601  
5 = South Atlantic 475 47,919,355  
6 = East South Central 115 10,445,244  
7 = West South Central 256 24,158,852  
8 = Mountain 234 18,404,179  
9 = Pacific 404 37,090,408  
ACCMDOB Num 8 Charter/school/other bus- to airport/terminal   -9 = Not Ascertained 57 5,193,303 POST-911 LONG
-1 = Appropriate Skip 24,138 2,214,971,431  
0 = No 2,658 235,756,424  
1 = Yes 96 9,878,240  
ACCMDOT Num 8 Intercity/other train- to airport/terminal   -9 = Not Ascertained 57 5,193,303 POST-911 LONG
-1 = Appropriate Skip 24,138 2,214,971,431  
0 = No 2,747 244,930,982  
1 = Yes 7 703,683  
ACCMDOTH Num 8 Other means- to airport/terminal   -9 = Not Ascertained 57 5,193,303 POST-911 LONG
-1 = Appropriate Skip 24,138 2,214,971,431  
0 = No 2,748 245,210,389  
1 = Yes 6 424,275  
ACCMDPOV Num 8 Personal vehicle- to airport/terminal   -9 = Not Ascertained 57 5,193,303 POST-911 LONG
-1 = Appropriate Skip 24,138 2,214,971,431  
0 = No 468 50,255,237  
1 = Yes 2,286 195,379,428  
ACCMDPTB Num 8 Public transit bus- to airport/terminal   -9 = Not Ascertained 57 5,193,303 POST-911 LONG
-1 = Appropriate Skip 24,138 2,214,971,431  
0 = No 2,733 242,791,378  
1 = Yes 21 2,843,287  
ACCMDSHP Num 8 Ferry/boat/ship- to airport/terminal   -9 = Not Ascertained 57 5,193,303 POST-911 LONG
-1 = Appropriate Skip 24,138 2,214,971,431  
0 = No 2,754 245,634,664  
ACCMDSHT Num 8 Shuttle/limo- to airport/terminal   -9 = Not Ascertained 57 5,193,303 POST-911 LONG
-1 = Appropriate Skip 24,138 2,214,971,431  
0 = No 2,582 230,006,649  
1 = Yes 172 15,628,016  
ACCMDSUB Num 8 Subway/commuter train- to airport/terminal   -9 = Not Ascertained 57 5,193,303 POST-911 LONG
-1 = Appropriate Skip 24,138 2,214,971,431  
0 = No 2,717 239,563,380  
1 = Yes 37 6,071,284  
ACCMDTXI Num 8 Taxi- to airport/terminal   -9 = Not Ascertained 57 5,193,303 POST-911 LONG
-1 = Appropriate Skip 24,138 2,214,971,431  
0 = No 2,601 228,247,362  
1 = Yes 153 17,387,302  
ACCMDWLK Num 8 Walking- to airport/terminal   -9 = Not Ascertained 57 5,193,303 POST-911 LONG
-1 = Appropriate Skip 24,138 2,214,971,431  
0 = No 2,520 225,293,106  
1 = Yes 234 20,341,559  
ACCMOD21 Char 2 Trans used: start to access place-1 I8 -1 = Appropriate Skip 24,138 2,214,971,431 POST-911 LONG
-9 = Not Ascertained 57 5,193,303  
01 = Personal Vehicle 2,258 193,452,053  
02 = Air 16 1,253,914  
03 = Bus 107 11,098,822  
04 = Train 32 5,276,475  
06 = Other 341 34,553,401  
ACCMOD22 Char 2 Trans used: start to access place-2 I8 -1 = Appropriate Skip 26,682 2,442,949,118 POST-911 LONG
01 = Personal Vehicle 34 2,154,201  
02 = Air 4 248,946  
03 = Bus 9 1,585,094  
04 = Train 11 1,218,059  
06 = Other 209 17,643,979  
ACCMOD23 Char 2 Trans used: start to access place-3 I8 -1 = Appropriate Skip 26,928 2,463,265,358 POST-911 LONG
01 = Personal Vehicle 3 437,908  
03 = Bus 2 176,354  
04 = Train 3 501,901  
06 = Other 13 1,417,877  
ACCMODE1 Char 2 Detail-Trans used: start to access place-1 I8 -1 = Appropriate Skip 24,138 2,214,971,431 POST-911 LONG
-9 = Not Ascertained 57 5,193,303  
01 = Car 1,674 142,074,441  
02 = Van 160 13,078,880  
03 = SUV 276 26,324,383  
04 = Pickup truck 147 11,886,211  
05 = Other truck 1 88,138  
08 = Commercial/charter airplane 15 1,158,646  
09 = Private/corporate airplane 1 95,268  
10 = Local public transit bus 18 2,163,056  
11 = Commuter bus 15 1,741,079  
12 = School bus 49 5,073,807  
13 = Charter/tour bus 23 2,074,500  
14 = City to city bus 2 46,380  
15 = Amtrak/inter city train 6 587,201  
16 = Commuter train 25 4,611,693  
18 = Street car/trolley 1 77,581  
22 = Taxicab 139 16,390,733  
23 = Limousine 58 6,014,332  
24 = Hotel/airport shuttle 35 3,261,411  
25 = Bicycle 1 69,319  
26 = Walk 104 8,587,257  
91 = Other 4 230,349  
ACCMODE2 Char 2 Detail-Trans used: start to access place-2 I8 -1 = Appropriate Skip 26,682 2,442,949,118 POST-911 LONG
01 = Car 26 1,632,207  
02 = Van 6 427,576  
04 = Pickup truck 2 94,418  
08 = Commercial/charter airplane 4 248,946  
10 = Local public transit bus 3 680,231  
11 = Commuter bus 3 439,722  
13 = Charter/tour bus 3 465,142  
15 = Amtrak/inter city train 4 255,055  
16 = Commuter train 3 261,523  
17 = Subway/elevated rail 2 330,434  
18 = Street car/trolley 2 371,047  
22 = Taxicab 14 996,569  
23 = Limousine 1 77,969  
24 = Hotel/airport shuttle 75 6,076,344  
26 = Walk 119 10,493,097  
ACCMODE3 Char 2 Detail-Trans used: start to access place-3 I8 -1 = Appropriate Skip 26,928 2,463,265,358 POST-911 LONG
01 = Car 1 274,926  
02 = Van 2 162,981  
11 = Commuter bus 1 74,695  
13 = Charter/tour bus 1 101,659  
16 = Commuter train 1 157,250  
17 = Subway/elevated rail 2 344,651  
24 = Hotel/airport shuttle 1 32,064  
26 = Walk 11 1,261,205  
91 = Other 1 124,608  
ACCMSA Char 4 Access place (to far dest)-PMSA/MSA/CMSA   -1 = Appropriate Skip 18,021 1,680,405,286 POST-911 LONG
-9 = Not Ascertained 86 12,294,955  
0080 = Akron, OH PMSA 3 394,803  
0160 = Albany-Schenectady-Troy, NY MSA 6 492,597  
0200 = Albuquerque, NM MSA 1 50,822  
0220 = Alexandria, LA MSA 3 335,176  
0240 = Allentown-Bethlehem-Easton, PA MSA 3 57,096  
0320 = Amarillo, TX MSA 1 20,843  
0440 = Ann Arbor, MI PMSA 3 297,690  
0460 = Appleton-Oshkosh-Neenah, WI MSA 1 84,683  
0520 = Atlanta, GA MSA 49 5,516,825  
0560 = Atlantic-Cape May, NJ PMSA 4 117,023  
0640 = Austin-San Marcos, TX MSA 17 1,436,777  
0720 = Baltimore, MD PMSA 33 3,826,905  
0875 = Bergen-Passaic, NJ PMSA 2 288,005  
0880 = Billings, MT MSA 1 77,012  
0960 = Binghamton, NY MSA 1 100,517  
1000 = Birmingham, AL MSA 2 156,050  
1080 = Boise City, ID MSA 1 62,453  
1120 = Boston, MA-NH PMSA 43 6,810,486  
1150 = Bremerton, WA PMSA 2 191,279  
1160 = Bridgeport, CT PMSA 1 18,993  
1280 = Buffalo-Niagara Falls, NY MSA 16 814,643  
1305 = Burlington, VT MSA 5 217,297  
1350 = Casper, WY MSA 1 75,191  
1520 = Charlotte-Gastonia-Rock Hill, NC-SC MSA 18 2,931,289  
1540 = Charlottesville, VA MSA 1 245,387  
1600 = Chicago, IL PMSA 98 10,826,916  
1640 = Cincinnati, OH-KY-IN PMSA 21 1,891,266  
1680 = Cleveland-Lorain-Elyria, OH PMSA 32 3,927,800  
1720 = Colorado Springs, CO MSA 1 103,857  
1840 = Columbus, OH MSA 28 2,576,318  
1920 = Dallas, TX PMSA 9 1,214,987  
1960 = Davenport-Moline-Rock Island, IA-IL MSA 2 169,833  
2000 = Dayton-Springfield, OH MSA 1 14,355  
2080 = Denver, CO PMSA 37 3,352,488  
2120 = Des Moines, IA MSA 1 140,616  
2160 = Detroit, MI PMSA 62 6,321,329  
2190 = Dover, DE MSA 1 76,990  
2240 = Duluth-Superior, MN-WI MSA 2 134,221  
2281 = Dutchess County, NY PMSA 28 770,691  
2440 = Evansville-Henderson, IN-KY MSA 2 100,577  
2640 = Flint, MI PMSA 4 251,245  
2680 = Fort Lauderdale, FL PMSA 15 1,452,557  
2760 = Fort Wayne, IN MSA 2 107,373  
2800 = Fort Worth-Arlington, TX PMSA 49 4,826,007  
2920 = Galveston-Texas City, TX PMSA 2 54,790  
2980 = Goldsboro, NC MSA 1 22,634  
3000 = Grand Rapids-Muskegon-Holland, MI MSA 3 237,905  
3120 = Greensboro--Winston-Salem--High Point, NC MSA 9 860,310  
3160 = Greenville-Spartanburg-Anderson, SC MSA 1 57,826  
3180 = Hagerstown, MD PMSA 2 770,408  
3240 = Harrisburg-Lebanon-Carlisle, PA MSA 2 41,428  
3280 = Hartford, CT MSA 19 1,616,379  
3360 = Houston, TX PMSA 49 4,740,858  
3480 = Indianapolis, IN MSA 12 1,030,983  
3600 = Jacksonville, FL MSA 8 779,305  
3640 = Jersey City, NJ PMSA 2 134,830  
3760 = Kansas City, MO-KS MSA 25 1,771,562  
3800 = Kenosha, WI PMSA 3 215,665  
3840 = Knoxville, TN MSA 3 199,198  
4040 = Lansing-East Lansing, MI MSA 2 114,581  
4120 = Las Vegas, NV-AZ MSA 32 2,284,180  
4280 = Lexington, KY MSA 2 170,795  
4360 = Lincoln, NE MSA 2 116,765  
4480 = Los Angeles-Long Beach, CA PMSA 57 8,024,204  
4520 = Louisville, KY-IN MSA 10 618,086  
4720 = Madison, WI MSA 1 41,664  
4760 = Manchester, NH PMSA 9 774,053  
4900 = Melbourne-Titusville-Palm Bay, FL MSA 3 359,148  
4920 = Memphis, TN-AR-MS MSA 11 1,177,984  
4940 = Merced, CA MSA 3 399,374  
5000 = Miami, FL PMSA 20 3,296,662  
5015 = Middlesex-Somerset-Hunterdon, NJ PMSA 18 1,784,858  
5080 = Milwaukee-Waukesha, WI PMSA 23 1,530,545  
5120 = Minneapolis-St. Paul, MN-WI MSA 52 3,814,701  
5140 = Missoula, MT MSA 2 187,688  
5190 = Monmouth-Ocean, NJ PMSA 5 287,408  
5360 = Nashville, TN MSA 35 2,485,070  
5380 = Nassau-Suffolk, NY PMSA 32 2,215,339  
5480 = New Haven-Meriden, CT PMSA 7 449,020  
5560 = New Orleans, LA MSA 25 2,661,145  
5600 = New York, NY PMSA 141 13,559,550  
5640 = Newark, NJ PMSA 61 5,349,462  
5660 = Newburgh, NY-PA PMSA 3 194,885  
5720 = Norfolk-Virginia Beach-Newport News, VA-NC MSA 14 1,361,764  
5775 = Oakland, CA PMSA 25 2,507,531  
5800 = Odessa-Midland, TX MSA 2 109,863  
5880 = Oklahoma City, OK MSA 7 849,583  
5910 = Olympia, WA PMSA 1 26,363  
5920 = Omaha, NE-IA MSA 6 325,174  
5945 = Orange County, CA PMSA 14 998,594  
5960 = Orlando, FL MSA 25 2,103,055  
6160 = Philadelphia, PA-NJ PMSA 72 7,144,326  
6200 = Phoenix-Mesa, AZ MSA 51 4,252,787  
6280 = Pittsburgh, PA MSA 30 1,951,485  
6400 = Portland, ME MSA 4 234,225  
6440 = Portland-Vancouver, OR-WA PMSA 26 2,121,690  
6450 = Portsmouth-Rochester, NH-ME PMSA 1 196,812  
6480 = Providence-Fall River-Warwick, RI-MA MSA 10 560,896  
6640 = Raleigh-Durham-Chapel Hill, NC MSA 11 1,071,700  
6660 = Rapid City, SD MSA 1 72,071  
6680 = Reading, PA MSA 2 77,258  
6720 = Reno, NV MSA 4 158,717  
6760 = Richmond-Petersburg, VA MSA 6 570,406  
6780 = Riverside-San Bernardino, CA PMSA 17 2,363,416  
6840 = Rochester, NY MSA 24 1,297,070  
6880 = Rockford, IL MSA 1 74,997  
6920 = Sacramento, CA PMSA 31 2,301,476  
6960 = Saginaw-Bay City-Midland, MI MSA 2 200,477  
7040 = St. Louis, MO-IL MSA 31 2,579,453  
7080 = Salem, OR PMSA 2 74,058  
7160 = Salt Lake City-Ogden, UT MSA 26 1,721,245  
7240 = San Antonio, TX MSA 17 1,706,024  
7320 = San Diego, CA MSA 15 1,284,105  
7360 = San Francisco, CA PMSA 32 2,671,090  
7400 = San Jose, CA PMSA 24 1,919,123  
7440 = San Juan-Bayamon, PR PMSA 3 113,965  
7600 = Seattle-Bellevue-Everett, WA PMSA 75 6,314,444  
7800 = South Bend, IN MSA 2 108,061  
7840 = Spokane, WA MSA 1 20,659  
7920 = Springfield, MO MSA 1 33,120  
8040 = Stamford-Norwalk, CT PMSA 2 364,798  
8160 = Syracuse, NY MSA 4 288,588  
8200 = Tacoma, WA PMSA 4 213,771  
8240 = Tallahassee, FL MSA 2 31,689  
8280 = Tampa-St. Petersburg-Clearwater, FL MSA 33 2,022,411  
8480 = Trenton, NJ PMSA 6 891,998  
8560 = Tulsa, OK MSA 3 134,961  
8600 = Tuscaloosa, AL MSA 1 366,400  
8680 = Utica-Rome, NY MSA 1 138,743  
8720 = Vallejo-Fairfield-Napa, CA PMSA 1 22,928  
8735 = Ventura, CA PMSA 14 643,305  
8840 = Washington, DC-MD-VA-WV PMSA 92 9,747,810  
8920 = Waterloo-Cedar Falls, IA MSA 1 16,657  
8940 = Wausau, WI MSA 2 144,606  
8960 = West Palm Beach-Boca Raton, FL MSA 2 386,093  
9040 = Wichita, KS MSA 3 24,692  
9160 = Wilmington-Newark, DE-MD PMSA 8 1,305,747  
9200 = Wilmington, NC MSA 1 80,230  
9240 = Worcester, MA-CT PMSA 7 414,540  
9270 = Yolo, CA PMSA 1 40,788  
9999 = Not in an MSA 166 14,459,472  
XXXX = Suppressed, in an MSA of less than 1 million 6,562 562,571,333  
ACCREG Char 2 Access place (to far dest)-Census region   -1 = Appropriate Skip 24,097 2,207,240,281 POST-911 LONG
-9 = Not Ascertained 106 13,487,381  
0 = Puerto Rico and Island Areas 3 113,965  
1 = Northeast 680 57,949,264  
2 = Midwest 579 48,990,470  
3 = South 846 82,523,450  
4 = West 638 55,494,587  
ACCST Char 2 Access place (to far dest)-State I9 -1 = Appropriate Skip 21,945 2,039,199,760 POST-911 LONG
-8 = Don't Know 2 194,819  
-9 = Not Ascertained 39 4,014,921  
AL = Alabama 16 2,457,245  
AR = Arkansas 6 634,907  
AZ = Arizona 71 5,669,904  
CA = California 249 24,927,969  
CO = Colorado 55 5,420,268  
CT = Connecticut 32 2,591,470  
DC = District of Columbia 56 6,055,084  
DE = Delaware 2 289,039  
FL = Florida 151 13,379,690  
GA = Georgia 54 6,049,844  
IA = Iowa 20 1,319,474  
IL = Illinois 115 12,210,683  
IN = Indiana 33 2,173,618  
KS = Kansas 16 752,485  
KY = Kentucky 32 2,626,734  
LA = Louisiana 40 4,299,232  
MA = Massachusetts 48 7,020,569  
MD = Maryland