Replica Trip Data - All Fields

Trip Table Fields
activity_id
person_id
distance_meters
duration_seconds
mode
travel_purpose
previous_activity_type
start_time
start_local_hour
end_time
end_local_hour
origin_us_county
origin_bgrp
origin_bgrp_lat
origin_bgrp_lng
destination_us_county
destination_bgrp
destination_bgrp_lat
destination_bgrp_lng
vehicle_type
vehicle_fuel_type
vehicle_fuel_technology
age
employment
race_ethnicity
resident_type
BLOCKGROUP_home
lat_home
lng_home
BLOCKGROUP_work
lat_work
lng_work
household_id
household_income
vehicles
household_size

Geographic Coverage - Counties in Dataset

Unique County FIPS Codes

Unique County FIPS Codes
12001
12003
12005
12007
12009
12011
12013
12015
12017
12019
12021
12023
12027
12029
12031
12033
12035
12037
12039
12041
12043
12045
12047
12049
12051
12053
12055
12057
12059
12061
12063
12065
12067
12069
12071
12073
12075
12077
12079
12081
12083
12085
12086
12087
12089
12091
12093
12095
12097
12099
12101
12103
12105
12107
12109
12111
12113
12115
12117
12119
12121
12123
12125
12127
12129
12131
12133
out_of_region

Field Exploration

Data Frame Summary

trips

Dimensions: 7728125 x 26
Duplicates: 122
No Variable Stats / Values Freqs (% of Valid) Valid Missing
1 activity_id [numeric] UPC codes
1. 1.52e+19
2. 1.09e+19
3. 1.29e+19
4. 1.8e+19
5. 1.77e+19
6. 1.83e+19
7. 1.28e+19
8. 1.62e+19
9. 1.47e+19
10. 1.26e+19
11. 1.04e+19
12. 1.61e+19
13. 1.14e+19
14. 1.3e+19
15. 1.57e+19
[ 3773649 others ]
8065(0.1%)
8057(0.1%)
8021(0.1%)
8021(0.1%)
8019(0.1%)
8014(0.1%)
8008(0.1%)
8006(0.1%)
8004(0.1%)
7998(0.1%)
7996(0.1%)
7994(0.1%)
7992(0.1%)
7986(0.1%)
7984(0.1%)
7607960(98.4%)
7728125 (100.0%) 0 (0.0%)
2 person_id [character]
1. \N
2. 4278102819491175171
3. 10880338530843488482
4. 10967400100170503144
5. 11871719825209842373
6. 11894741418659770894
7. 12692606510414728074
8. 12851251672186792470
9. 14954993111514614339
10. 15373635656274333008
11. 15433991751344805423
12. 16495525466365922440
13. 16733411363011636949
14. 18225511319175484432
15. 3218560677300254887
[ 2132748 others ]
337643(4.4%)
17(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
16(0.0%)
7390257(95.6%)
7728125 (100.0%) 0 (0.0%)
3 distance_meters [numeric]
Mean (sd) : 26420.4 (95276.4)
min ≤ med ≤ max:
0 ≤ 7886 ≤ 4374830
IQR (CV) : 22048 (3.6)
14000 distinct values 7728125 (100.0%) 0 (0.0%)
4 duration_seconds [numeric]
Mean (sd) : 1527.9 (5306.5)
min ≤ med ≤ max:
0 ≤ 660 ≤ 86340
IQR (CV) : 1140 (3.5)
1438 distinct values 7728125 (100.0%) 0 (0.0%)
5 mode [character]
1. BIKING
2. CARPOOL
3. COMMERCIAL
4. ON_DEMAND_AUTO
5. OTHER_TRAVEL_MODE
6. PRIVATE_AUTO
7. PUBLIC_TRANSIT
8. WALKING
95897(1.2%)
1155225(14.9%)
332027(4.3%)
74322(1.0%)
271432(3.5%)
4496580(58.2%)
58268(0.8%)
1244374(16.1%)
7728125 (100.0%) 0 (0.0%)
6 travel_purpose [character]
1. COMMERCIAL
2. EAT
3. HOME
4. LODGING
5. MAINTENANCE
6. OTHER_ACTIVITY_TYPE
7. RECREATION
8. REGION_DEPARTURE
9. SCHOOL
10. SHOP
11. SOCIAL
12. STAGE
13. WORK
337394(4.4%)
424736(5.5%)
2557231(33.1%)
59429(0.8%)
339354(4.4%)
119735(1.5%)
344346(4.5%)
30925(0.4%)
416913(5.4%)
1380547(17.9%)
474407(6.1%)
249(0.0%)
1242859(16.1%)
7728125 (100.0%) 0 (0.0%)
7 previous_activity_type [character]
1. COMMERCIAL
2. EAT
3. HOME
4. LODGING
5. MAINTENANCE
6. OTHER_ACTIVITY_TYPE
7. RECREATION
8. SCHOOL
9. SHOP
10. SOCIAL
11. STAGE
12. WORK
337394(4.4%)
432076(5.6%)
2508361(32.5%)
56002(0.7%)
350647(4.5%)
130561(1.7%)
353916(4.6%)
412397(5.3%)
1467367(19.0%)
506221(6.6%)
249(0.0%)
1172934(15.2%)
7728125 (100.0%) 0 (0.0%)
8 origin_us_county [character]
1. 12011
2. 12086
3. 12099
4. out_of_region
5. 12095
6. 12111
7. 12071
8. 12057
9. 12021
10. 12085
11. 12009
12. 12087
13. 12031
14. 12097
15. 12103
[ 53 others ]
6851105(88.7%)
500594(6.5%)
273319(3.5%)
20021(0.3%)
15137(0.2%)
7607(0.1%)
7144(0.1%)
5177(0.1%)
4730(0.1%)
4616(0.1%)
3163(0.0%)
3091(0.0%)
2859(0.0%)
2626(0.0%)
2468(0.0%)
24468(0.3%)
7728125 (100.0%) 0 (0.0%)
9 origin_bgrp [character]
1. 120110425002
2. 120110601204
3. 120110802001
4. 120110702042
5. 120110703171
6. 120110502071
7. 120110105032
8. 120110305001
9. 120110805004
10. 120110502042
11. 120110702041
12. 120110306003
13. 120111103092
14. 120110502083
15. 120111106003
[ 9122 others ]
89521(1.2%)
79764(1.0%)
72651(0.9%)
66657(0.9%)
52407(0.7%)
44776(0.6%)
39505(0.5%)
35713(0.5%)
35055(0.5%)
34541(0.4%)
32277(0.4%)
31274(0.4%)
30181(0.4%)
29517(0.4%)
27902(0.4%)
7026384(90.9%)
7728125 (100.0%) 0 (0.0%)
10 destination_us_county [character]
1. 12011
2. 12086
3. 12099
4. out_of_region
5. 12095
6. 12111
7. 12071
8. 12057
9. 12021
10. 12085
11. 12009
12. 12087
13. 12031
14. 12097
15. 12103
[ 51 others ]
6850342(88.6%)
503162(6.5%)
271975(3.5%)
20209(0.3%)
14823(0.2%)
7583(0.1%)
7067(0.1%)
5330(0.1%)
4779(0.1%)
4618(0.1%)
3078(0.0%)
3073(0.0%)
2924(0.0%)
2692(0.0%)
2351(0.0%)
24119(0.3%)
7728125 (100.0%) 0 (0.0%)
11 destination_bgrp [character]
1. 120110425002
2. 120110601204
3. 120110802001
4. 120110702042
5. 120110703171
6. 120110502071
7. 120110105032
8. 120110305001
9. 120110805004
10. 120110502042
11. 120110702041
12. 120110306003
13. 120111103092
14. 120110502083
15. 120111106003
[ 9110 others ]
89582(1.2%)
79753(1.0%)
73014(0.9%)
66589(0.9%)
52379(0.7%)
44821(0.6%)
39323(0.5%)
35726(0.5%)
34988(0.5%)
34726(0.4%)
32177(0.4%)
31317(0.4%)
30176(0.4%)
29281(0.4%)
28068(0.4%)
7026205(90.9%)
7728125 (100.0%) 0 (0.0%)
12 vehicle_type [character]
1. \N
2. HEAVY_COMMERCIAL
3. MEDIUM_COMMERCIAL
4. PASSENGER_CAR
5. UNKNOWN_VEHICLE_TYPE
271619(3.5%)
31465(0.4%)
300562(3.9%)
249(0.0%)
7124230(92.2%)
7728125 (100.0%) 0 (0.0%)
13 vehicle_fuel_type [character]
1. \N
2. UNKNOWN_FUEL_TYPE
271619(3.5%)
7456506(96.5%)
7728125 (100.0%) 0 (0.0%)
14 vehicle_fuel_technology [character]
1. \N
2. UNKNOWN_FUEL_TECHNOLOGY
271619(3.5%)
7456506(96.5%)
7728125 (100.0%) 0 (0.0%)
15 age [numeric]
Mean (sd) : 44.5 (19.9)
min ≤ med ≤ max:
3 ≤ 45 ≤ 95
IQR (CV) : 30 (0.4)
91 distinct values 7168802 (92.8%) 559323 (7.2%)
16 employment [character]
1. \N
2. employed
3. not_in_labor_force
4. unemployed
559323(7.2%)
4297443(55.6%)
2593443(33.6%)
277916(3.6%)
7728125 (100.0%) 0 (0.0%)
17 race_ethnicity [character]
1. \N
2. aian_not_hispanic_or_lati
3. asian_not_hispanic_or_lat
4. black_not_hispanic_or_lat
5. hispanic_or_latino_origin
6. nhopi_not_hispanic_or_lat
7. other_not_hispanic_or_lat
8. two_races_not_hispanic_or
9. white_not_hispanic_or_lat
559323(7.2%)
14175(0.2%)
294494(3.8%)
1861092(24.1%)
2213439(28.6%)
3454(0.0%)
32523(0.4%)
124323(1.6%)
2625302(34.0%)
7728125 (100.0%) 0 (0.0%)
18 resident_type [character]
1. \N
2. core
3. visitor
337643(4.4%)
7168802(92.8%)
221680(2.9%)
7728125 (100.0%) 0 (0.0%)
19 BLOCKGROUP_home [character]
1. out_of_region
2. 120110703171
3. 120110105032
4. 120111103221
5. 120111103254
6. 120111103422
7. 120111103244
8. 120110705021
9. 120110106063
10. 120110703141
11. 120111103271
12. 120111103321
13. 120110907002
14. 120110202052
15. 120110703182
[ 7219 others ]
559323(7.2%)
50307(0.7%)
50293(0.7%)
29902(0.4%)
29844(0.4%)
28587(0.4%)
26009(0.3%)
23611(0.3%)
18885(0.2%)
18201(0.2%)
17448(0.2%)
17404(0.2%)
17323(0.2%)
17174(0.2%)
17103(0.2%)
6806711(88.1%)
7728125 (100.0%) 0 (0.0%)
20 BLOCKGROUP_work [character]
1. out_of_region
2. 120110425002
3. 120110702042
4. 120110502071
5. 120110601204
6. 120110802001
7. 120110502042
8. 120110305001
9. 120990071001
10. 120110703171
11. 120111103212
12. 120990070021
13. 120110805004
14. 120110306003
15. 120110502083
[ 5095 others ]
2731414(35.3%)
203822(2.6%)
126443(1.6%)
98714(1.3%)
89583(1.2%)
52691(0.7%)
50164(0.6%)
37197(0.5%)
33461(0.4%)
33422(0.4%)
32734(0.4%)
32130(0.4%)
31529(0.4%)
30843(0.4%)
30320(0.4%)
4113658(53.2%)
7728125 (100.0%) 0 (0.0%)
21 household_id [character]
1. \N
2. 18198570409633731378
3. 4351553987078162662
4. 10792826352914225536
5. 2832757667743464403
6. 17655688358972374035
7. 2765710845867573347
8. 7439996174412714014
9. 10761837528483982545
10. 13619605027503126392
11. 5125250932944045106
12. 12123724079303933610
13. 13011765591948642692
14. 14174497665644946649
15. 16114337350465787732
[ 987122 others ]
559323(7.2%)
59(0.0%)
58(0.0%)
57(0.0%)
57(0.0%)
55(0.0%)
55(0.0%)
55(0.0%)
54(0.0%)
54(0.0%)
54(0.0%)
53(0.0%)
53(0.0%)
53(0.0%)
53(0.0%)
7168032(92.8%)
7728125 (100.0%) 0 (0.0%)
22 household_income [numeric]
Mean (sd) : 96580.6 (99391.3)
min ≤ med ≤ max:
-11563 ≤ 71103 ≤ 2399013
IQR (CV) : 81298 (1)
17142 distinct values 7168802 (92.8%) 559323 (7.2%)
23 vehicles [character]
1. \N
2. one
3. three_plus
4. two
5. unknown_num_vehicles
6. zero
559323(7.2%)
1992237(25.8%)
2015000(26.1%)
2814668(36.4%)
72455(0.9%)
274442(3.6%)
7728125 (100.0%) 0 (0.0%)
24 household_size [numeric]
Mean (sd) : 3.7 (2.4)
min ≤ med ≤ max:
1 ≤ 3 ≤ 20
IQR (CV) : 3 (0.7)
18 distinct values 7168802 (92.8%) 559323 (7.2%)
25 distance_miles [numeric]
Mean (sd) : 16.4 (59.2)
min ≤ med ≤ max:
0 ≤ 4.9 ≤ 2719
IQR (CV) : 13.7 (3.6)
14000 distinct values 7728125 (100.0%) 0 (0.0%)
26 duration_minutes [numeric]
Mean (sd) : 25.5 (88.4)
min ≤ med ≤ max:
0 ≤ 11 ≤ 1439
IQR (CV) : 19 (3.5)
1438 distinct values 7728125 (100.0%) 0 (0.0%)

Generated by summarytools 1.0.0 (R version 4.1.0)
2021-09-09

Trips Length by Purpose

travel_purpose mean_miles
COMMERCIAL 19.763888
EAT 14.055658
HOME 15.704749
LODGING 68.627651
MAINTENANCE 11.991294
OTHER_ACTIVITY_TYPE 18.879245
RECREATION 12.611446
REGION_DEPARTURE 232.759813
SCHOOL 8.803605
SHOP 9.259742
SOCIAL 17.594296
STAGE 392.538388
WORK 21.927157

  1. Renaissance Planning, ↩︎