id | name | population |
---|---|---|
1 | New York | 8419000 |
2 | Los Angeles | 3792600 |
3 | Chicago | 2693910 |
4 | Houston | 2209945 |
5 | Phoenix | 1660273 |
6 | Philadelphia | 1526000 |
id | mode |
---|---|
1 | Buses |
2 | Trains |
3 | Taxis |
4 | Cycling |
5 | Walking |
id | road_id | city_id | length |
---|---|---|---|
(→ City.id) | |||
1 | 1 | 1 | 10.0 |
2 | 2 | 1 | 15.0 |
3 | 3 | 2 | 20.0 |
4 | 4 | 2 | 25.0 |
5 | 5 | 3 | 30.0 |
6 | 6 | 3 | 35.0 |
7 | 7 | 4 | 40.0 |
8 | 8 | 4 | 45.0 |
9 | 9 | 5 | 50.0 |
10 | 10 | 5 | 55.0 |
id | volume | road_id | timestamp |
---|---|---|---|
(→ Roads.id) | |||
1 | 1000 | 1 | 2024-01-30 18:39:55 |
2 | 1500 | 2 | 2024-01-30 18:39:55 |
3 | 2000 | 3 | 2024-01-30 18:39:55 |
4 | 2500 | 4 | 2024-01-30 18:39:55 |
5 | 3000 | 5 | 2024-01-30 18:39:55 |
6 | 3500 | 6 | 2024-01-30 18:39:55 |
7 | 4000 | 7 | 2024-01-30 18:39:55 |
8 | 4500 | 8 | 2024-01-30 18:39:55 |
9 | 5000 | 9 | 2024-01-30 18:39:55 |
10 | 5500 | 10 | 2024-01-30 18:39:55 |
id | accident_type | severity | road_id | timestamp |
---|---|---|---|---|
(→ Roads.id) | ||||
1 | Fender Bender | Minor | 1 | 2024-01-30 18:39:55 |
2 | Hit and Run | Moderate | 2 | 2024-01-30 18:39:55 |
3 | Head-on Collision | Major | 3 | 2024-01-30 18:39:55 |
4 | Multi Vehicle Pileup | Catastrophic | 4 | 2024-01-30 18:39:55 |
5 | DUI Accident | Serious | 5 | 2024-01-30 18:39:55 |
6 | Distracted Driver Accident | Moderate | 6 | 2024-01-30 18:39:55 |
7 | Speeding Ticket | Minor | 7 | 2024-01-30 18:39:55 |
8 | Reckless Driving | Major | 8 | 2024-01-30 18:39:55 |
9 | Texting While Driving | Minor | 9 | 2024-01-30 18:39:55 |
10 | Red Light Running | Serious | 10 | 2024-01-30 18:39:55 |
city_id | transportation_mode_id |
---|---|
(→ City.id) | (→ Transportation_Mode.id) |
1 | 1 |
1 | 2 |
2 | 1 |
2 | 2 |
3 | 1 |
3 | 3 |
4 | 1 |
4 | 4 |
5 | 1 |
5 | 5 |
6 | 1 |