События (1000000)
1 000 000
событий в базе
23
полей в событии: 10 измерений + 11 метрик + id и время
55.5 МБ
на диске (сжато, 71.6 МБ без сжатия)
≈ 548.4 МБ
экспорт в JSON: 1 000 000 строк × 575 Б
— в 9.9× больше, чем на диске
| event_time | event_type | vehicle_id | driver_id | route_id | region | speed_kmh | fuel_consumption_l100 |
|---|---|---|---|---|---|---|---|
| 2026-07-16 00:47:01 | gps_ping | V-040 | D-02 | R-10 | latgale | 41.1 | 30 |
| 2026-07-16 00:47:01 | harsh_braking | V-036 | D-18 | R-01 | kurzeme | 39.6 | 30.1 |
| 2026-07-16 00:46:59 | gps_ping | V-028 | D-03 | R-14 | latgale | 55.6 | 35.4 |
| 2026-07-16 00:46:54 | engine_fault | V-004 | D-18 | R-04 | vidzeme | 10.2 | 31.3 |
| 2026-07-16 00:46:48 | gps_ping | V-016 | D-01 | R-10 | latgale | 72.3 | 32.5 |
| 2026-07-16 00:46:46 | trip_start | V-048 | D-10 | R-15 | riga | 76.2 | 21.9 |
| 2026-07-16 00:46:46 | harsh_braking | V-021 | D-05 | R-12 | kurzeme | 13.9 | 34.8 |
| 2026-07-16 00:46:45 | gps_ping | V-001 | D-07 | R-10 | latgale | 79.6 | 27.7 |
| 2026-07-16 00:46:41 | gps_ping | V-013 | D-16 | R-11 | vidzeme | 47.9 | 13.3 |
| 2026-07-16 00:46:36 | gps_ping | V-010 | D-05 | R-07 | riga | 75.6 | 29.6 |
| 2026-07-16 00:46:34 | gps_ping | V-028 | D-04 | R-04 | vidzeme | 56.2 | 37.1 |
| 2026-07-16 00:46:29 | gps_ping | V-011 | D-01 | R-01 | kurzeme | 35.5 | 13.5 |
| 2026-07-16 00:46:29 | gps_ping | V-022 | D-24 | R-09 | riga | 39 | 33.3 |
| 2026-07-16 00:46:23 | gps_ping | V-049 | D-06 | R-03 | kurzeme | 93.5 | 31 |
| 2026-07-16 00:46:19 | gps_ping | V-020 | D-07 | R-06 | vidzeme | 48.2 | 25.3 |
| 2026-07-16 00:46:17 | speeding | V-042 | D-09 | R-01 | kurzeme | 80.8 | 30.3 |
| 2026-07-16 00:46:16 | refuel | V-045 | D-13 | R-02 | kurzeme | 0 | 10.7 |
| 2026-07-16 00:46:14 | gps_ping | V-020 | D-11 | R-11 | vidzeme | 24.7 | 26 |
| 2026-07-16 00:46:11 | speeding | V-024 | D-17 | R-07 | riga | 23.8 | 12.8 |
| 2026-07-16 00:46:02 | gps_ping | V-019 | D-22 | R-03 | kurzeme | 23.2 | 26 |
| 2026-07-16 00:46:01 | gps_ping | V-001 | D-17 | R-12 | kurzeme | 57.8 | 29.7 |
| 2026-07-16 00:46:01 | harsh_braking | V-003 | D-02 | R-06 | vidzeme | 71.5 | 21 |
| 2026-07-16 00:45:56 | trip_end | V-006 | D-12 | R-15 | riga | 28.5 | 28.2 |
| 2026-07-16 00:45:52 | gps_ping | V-050 | D-28 | R-11 | vidzeme | 49.7 | 35.6 |
| 2026-07-16 00:45:49 | gps_ping | V-045 | D-27 | R-15 | riga | 64.8 | 12.1 |
| 2026-07-16 00:45:44 | gps_ping | V-044 | D-16 | R-10 | latgale | 43.8 | 30 |
| 2026-07-16 00:45:35 | trip_start | V-015 | D-15 | R-02 | kurzeme | 53.9 | 26.7 |
| 2026-07-16 00:45:34 | trip_end | V-043 | D-12 | R-01 | kurzeme | 76.4 | 27.1 |
| 2026-07-16 00:45:32 | gps_ping | V-040 | D-05 | R-15 | riga | 62.6 | 31.3 |
| 2026-07-16 00:45:24 | trip_end | V-042 | D-06 | R-01 | kurzeme | 93.1 | 33.4 |
| 2026-07-16 00:45:19 | gps_ping | V-022 | D-07 | R-07 | riga | 35 | 30.3 |
| 2026-07-16 00:45:12 | speeding | V-031 | D-14 | R-07 | riga | 18.5 | 27.9 |
| 2026-07-16 00:45:11 | trip_end | V-006 | D-17 | R-06 | vidzeme | 73 | 29.2 |
| 2026-07-16 00:45:02 | speeding | V-002 | D-30 | R-12 | kurzeme | 77.7 | 31.2 |
| 2026-07-16 00:45:02 | engine_fault | V-011 | D-07 | R-15 | riga | 37.2 | 15.7 |
| 2026-07-16 00:45:02 | trip_end | V-020 | D-30 | R-06 | vidzeme | 62.5 | 25.2 |
| 2026-07-16 00:44:57 | trip_end | V-031 | D-18 | R-03 | kurzeme | 63.3 | 34 |
| 2026-07-16 00:44:51 | gps_ping | V-040 | D-07 | R-04 | vidzeme | 23.7 | 37.8 |
| 2026-07-16 00:44:51 | gps_ping | V-014 | D-20 | R-07 | riga | 32.8 | 33.2 |
| 2026-07-16 00:44:50 | gps_ping | V-011 | D-05 | R-08 | latgale | 18 | 12 |
| 2026-07-16 00:44:46 | gps_ping | V-024 | D-20 | R-09 | riga | 54.2 | 11.3 |
| 2026-07-16 00:44:41 | gps_ping | V-020 | D-05 | R-01 | kurzeme | 62.7 | 28.1 |
| 2026-07-16 00:44:38 | gps_ping | V-010 | D-30 | R-09 | riga | 59.2 | 27.4 |
| 2026-07-16 00:44:38 | gps_ping | V-044 | D-01 | R-15 | riga | 74.6 | 29.5 |
| 2026-07-16 00:44:32 | harsh_braking | V-015 | D-12 | R-09 | riga | 59 | 27.9 |
| 2026-07-16 00:44:28 | engine_fault | V-043 | D-01 | R-01 | kurzeme | 49.8 | 27.9 |
| 2026-07-16 00:44:27 | gps_ping | V-032 | D-23 | R-02 | kurzeme | 26.7 | 16.4 |
| 2026-07-16 00:44:26 | gps_ping | V-023 | D-17 | R-02 | kurzeme | 68.1 | 36.1 |
| 2026-07-16 00:44:23 | gps_ping | V-020 | D-22 | R-03 | kurzeme | 93.5 | 27.2 |
| 2026-07-16 00:44:20 | gps_ping | V-009 | D-12 | R-13 | latgale | 26.6 | 34 |