City

idnamepopulation
1New York8419000
2Los Angeles3792600
3Chicago2693910
4Houston2209945
5Phoenix1660273
6Philadelphia1526000

Transportation_Mode

idmode
1Buses
2Trains
3Taxis
4Cycling
5Walking

Roads

idroad_idcity_idlength
(→ City.id)
11110.0
22115.0
33220.0
44225.0
55330.0
66335.0
77440.0
88445.0
99550.0
1010555.0

Traffic_Volume

idvolumeroad_idtimestamp
(→ Roads.id)
1100012024-01-30 18:39:55
2150022024-01-30 18:39:55
3200032024-01-30 18:39:55
4250042024-01-30 18:39:55
5300052024-01-30 18:39:55
6350062024-01-30 18:39:55
7400072024-01-30 18:39:55
8450082024-01-30 18:39:55
9500092024-01-30 18:39:55
105500102024-01-30 18:39:55

Accidents

idaccident_typeseverityroad_idtimestamp
(→ Roads.id)
1Fender BenderMinor12024-01-30 18:39:55
2Hit and RunModerate22024-01-30 18:39:55
3Head-on CollisionMajor32024-01-30 18:39:55
4Multi Vehicle PileupCatastrophic42024-01-30 18:39:55
5DUI AccidentSerious52024-01-30 18:39:55
6Distracted Driver AccidentModerate62024-01-30 18:39:55
7Speeding TicketMinor72024-01-30 18:39:55
8Reckless DrivingMajor82024-01-30 18:39:55
9Texting While DrivingMinor92024-01-30 18:39:55
10Red Light RunningSerious102024-01-30 18:39:55

City_Transportation_Mode

city_idtransportation_mode_id
(→ City.id)(→ Transportation_Mode.id)
11
12
21
22
31
33
41
44
51
55
61