Einzelmessungen
- Messung_Datum
- Datum der Messung
- Messung_Timestamp
- Zeitpunkt der Messung
- Messung_Zeit
- Uhrzeit der Messung
- Phase
- Phase der Messung (Vormessung, Betrieb, Nachmessung oder nach Ende)
- V_Ausfahrt
- Ausfahrtsgeschwindigkeit in km/h
- V_Delta
- Differenz zwischen Einfahrts- und Ausfahrtsgeschwindigkeit in km/h
- V_Einfahrt
- Einfahrtsgeschwindigkeit in km/h
- Zyklus
- Messzyklus
- id_standort
- Eindeutige Standortkennung
>10,000 rows count all where ID = "4-117" sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Messung_Datum (date), Messung_Timestamp (date)
Link | rowid | ID | id_standort | Zyklus | Phase | Messung_Datum | Messung_Zeit | V_Einfahrt | V_Ausfahrt | Messung_Timestamp ▲ | V_Delta |
---|---|---|---|---|---|---|---|---|---|---|---|
12071392 | 12071392 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:49:14.000000 | 29 | 18 | 2024-10-17 06:49:14+02:00 | -11 |
12071391 | 12071391 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:48:42.000000 | 34 | 15 | 2024-10-17 06:48:42+02:00 | -19 |
12071390 | 12071390 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:48:18.000000 | 11 | 16 | 2024-10-17 06:48:18+02:00 | 5 |
12071389 | 12071389 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:47:43.000000 | 30 | 23 | 2024-10-17 06:47:43+02:00 | -7 |
12071388 | 12071388 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:47:08.000000 | 7 | 11 | 2024-10-17 06:47:08+02:00 | 4 |
12071387 | 12071387 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:46:33.000000 | 12 | 20 | 2024-10-17 06:46:33+02:00 | 8 |
12071386 | 12071386 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:46:11.000000 | 24 | 22 | 2024-10-17 06:46:11+02:00 | -2 |
12071385 | 12071385 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:45:58.000000 | 25 | 17 | 2024-10-17 06:45:58+02:00 | -8 |
12071384 | 12071384 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:45:44.000000 | 16 | 5 | 2024-10-17 06:45:44+02:00 | -11 |
12071383 | 12071383 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:45:08.000000 | 28 | 23 | 2024-10-17 06:45:08+02:00 | -5 |
12071382 | 12071382 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:44:57.000000 | 23 | 27 | 2024-10-17 06:44:57+02:00 | 4 |
12071381 | 12071381 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:44:50.000000 | 24 | 15 | 2024-10-17 06:44:50+02:00 | -9 |
12071380 | 12071380 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:44:30.000000 | 33 | 28 | 2024-10-17 06:44:30+02:00 | -5 |
12071379 | 12071379 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:44:23.000000 | 17 | 10 | 2024-10-17 06:44:23+02:00 | -7 |
12071378 | 12071378 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:44:04.000000 | 20 | 19 | 2024-10-17 06:44:04+02:00 | -1 |
12071377 | 12071377 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:43:34.000000 | 26 | 20 | 2024-10-17 06:43:34+02:00 | -6 |
12071376 | 12071376 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:43:21.000000 | 19 | 22 | 2024-10-17 06:43:21+02:00 | 3 |
12071375 | 12071375 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:42:41.000000 | 32 | 17 | 2024-10-17 06:42:41+02:00 | -15 |
12071374 | 12071374 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:42:35.000000 | 15 | 18 | 2024-10-17 06:42:35+02:00 | 3 |
12071373 | 12071373 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:42:16.000000 | 25 | 15 | 2024-10-17 06:42:16+02:00 | -10 |
12071372 | 12071372 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:42:11.000000 | 23 | 19 | 2024-10-17 06:42:11+02:00 | -4 |
12071371 | 12071371 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:41:56.000000 | 29 | 25 | 2024-10-17 06:41:56+02:00 | -4 |
12071370 | 12071370 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:41:46.000000 | 29 | 28 | 2024-10-17 06:41:46+02:00 | -1 |
12071369 | 12071369 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:41:39.000000 | 19 | 19 | 2024-10-17 06:41:39+02:00 | 0 |
12071368 | 12071368 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:41:30.000000 | 29 | 24 | 2024-10-17 06:41:30+02:00 | -5 |
12071367 | 12071367 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:41:19.000000 | 28 | 22 | 2024-10-17 06:41:19+02:00 | -6 |
12071366 | 12071366 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:41:06.000000 | 27 | 17 | 2024-10-17 06:41:06+02:00 | -10 |
12071365 | 12071365 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:40:56.000000 | 30 | 28 | 2024-10-17 06:40:56+02:00 | -2 |
12071364 | 12071364 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:40:45.000000 | 27 | 22 | 2024-10-17 06:40:45+02:00 | -5 |
12071363 | 12071363 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:40:36.000000 | 43 | 40 | 2024-10-17 06:40:36+02:00 | -3 |
12071362 | 12071362 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:40:26.000000 | 31 | 23 | 2024-10-17 06:40:26+02:00 | -8 |
12071361 | 12071361 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:40:20.000000 | 24 | 27 | 2024-10-17 06:40:20+02:00 | 3 |
12071360 | 12071360 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:40:09.000000 | 24 | 13 | 2024-10-17 06:40:09+02:00 | -11 |
12071359 | 12071359 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:39:56.000000 | 27 | 25 | 2024-10-17 06:39:56+02:00 | -2 |
12071358 | 12071358 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:39:42.000000 | 35 | 26 | 2024-10-17 06:39:42+02:00 | -9 |
12071357 | 12071357 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:39:30.000000 | 24 | 9 | 2024-10-17 06:39:30+02:00 | -15 |
12071356 | 12071356 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:39:18.000000 | 24 | 23 | 2024-10-17 06:39:18+02:00 | -1 |
12071355 | 12071355 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:39:08.000000 | 30 | 27 | 2024-10-17 06:39:08+02:00 | -3 |
12071354 | 12071354 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:38:58.000000 | 35 | 29 | 2024-10-17 06:38:58+02:00 | -6 |
12071353 | 12071353 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:38:50.000000 | 34 | 34 | 2024-10-17 06:38:50+02:00 | 0 |
12071352 | 12071352 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:38:34.000000 | 29 | 28 | 2024-10-17 06:38:34+02:00 | -1 |
12071351 | 12071351 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:38:24.000000 | 24 | 28 | 2024-10-17 06:38:24+02:00 | 4 |
12071350 | 12071350 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:37:33.000000 | 25 | 19 | 2024-10-17 06:37:33+02:00 | -6 |
12071349 | 12071349 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:37:20.000000 | 27 | 17 | 2024-10-17 06:37:20+02:00 | -10 |
12071348 | 12071348 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:37:02.000000 | 29 | 22 | 2024-10-17 06:37:02+02:00 | -7 |
12071347 | 12071347 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:36:45.000000 | 25 | 19 | 2024-10-17 06:36:45+02:00 | -6 |
12071346 | 12071346 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:36:37.000000 | 17 | 16 | 2024-10-17 06:36:37+02:00 | -1 |
12071345 | 12071345 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:36:36.000000 | 33 | 31 | 2024-10-17 06:36:36+02:00 | -2 |
12071343 | 12071343 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:36:15.000000 | 33 | 27 | 2024-10-17 06:36:15+02:00 | -6 |
12071344 | 12071344 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:36:15.000000 | 29 | 26 | 2024-10-17 06:36:15+02:00 | -3 |
12071342 | 12071342 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:36:04.000000 | 24 | 22 | 2024-10-17 06:36:04+02:00 | -2 |
12071341 | 12071341 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:35:49.000000 | 28 | 23 | 2024-10-17 06:35:49+02:00 | -5 |
12071340 | 12071340 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:35:24.000000 | 15 | 17 | 2024-10-17 06:35:24+02:00 | 2 |
12071339 | 12071339 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:34:58.000000 | 2 | 15 | 2024-10-17 06:34:58+02:00 | 13 |
12071338 | 12071338 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:34:19.000000 | 33 | 28 | 2024-10-17 06:34:19+02:00 | -5 |
12071337 | 12071337 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:33:47.000000 | 26 | 14 | 2024-10-17 06:33:47+02:00 | -12 |
12071336 | 12071336 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:33:35.000000 | 26 | 25 | 2024-10-17 06:33:35+02:00 | -1 |
12071335 | 12071335 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:33:16.000000 | 32 | 26 | 2024-10-17 06:33:16+02:00 | -6 |
12071334 | 12071334 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:33:05.000000 | 20 | 30 | 2024-10-17 06:33:05+02:00 | 10 |
12071333 | 12071333 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:32:12.000000 | 28 | 30 | 2024-10-17 06:32:12+02:00 | 2 |
12071332 | 12071332 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:32:03.000000 | 32 | 33 | 2024-10-17 06:32:03+02:00 | 1 |
12071331 | 12071331 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:31:58.000000 | 27 | 23 | 2024-10-17 06:31:58+02:00 | -4 |
12071330 | 12071330 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:31:40.000000 | 24 | 24 | 2024-10-17 06:31:40+02:00 | 0 |
12071329 | 12071329 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:31:39.000000 | 30 | 25 | 2024-10-17 06:31:39+02:00 | -5 |
12071328 | 12071328 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:31:34.000000 | 25 | 18 | 2024-10-17 06:31:34+02:00 | -7 |
12071327 | 12071327 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:31:30.000000 | 18 | 15 | 2024-10-17 06:31:30+02:00 | -3 |
12071326 | 12071326 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:31:22.000000 | 25 | 24 | 2024-10-17 06:31:22+02:00 | -1 |
12071325 | 12071325 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:30:40.000000 | 28 | 24 | 2024-10-17 06:30:40+02:00 | -4 |
12071324 | 12071324 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:30:30.000000 | 32 | 18 | 2024-10-17 06:30:30+02:00 | -14 |
12071323 | 12071323 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:30:06.000000 | 30 | 23 | 2024-10-17 06:30:06+02:00 | -7 |
12071322 | 12071322 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:29:34.000000 | 28 | 24 | 2024-10-17 06:29:34+02:00 | -4 |
12071321 | 12071321 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:29:18.000000 | 32 | 27 | 2024-10-17 06:29:18+02:00 | -5 |
12071320 | 12071320 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:28:57.000000 | 30 | 26 | 2024-10-17 06:28:57+02:00 | -4 |
12071319 | 12071319 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:28:39.000000 | 34 | 29 | 2024-10-17 06:28:39+02:00 | -5 |
12071318 | 12071318 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:27:30.000000 | 23 | 13 | 2024-10-17 06:27:30+02:00 | -10 |
12071317 | 12071317 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:27:17.000000 | 29 | 22 | 2024-10-17 06:27:17+02:00 | -7 |
12071316 | 12071316 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:27:07.000000 | 25 | 12 | 2024-10-17 06:27:07+02:00 | -13 |
12071315 | 12071315 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:26:55.000000 | 31 | 24 | 2024-10-17 06:26:55+02:00 | -7 |
12071314 | 12071314 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:26:38.000000 | 28 | 18 | 2024-10-17 06:26:38+02:00 | -10 |
12071313 | 12071313 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:24:30.000000 | 30 | 25 | 2024-10-17 06:24:30+02:00 | -5 |
12071312 | 12071312 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:24:12.000000 | 27 | 19 | 2024-10-17 06:24:12+02:00 | -8 |
12071311 | 12071311 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:23:54.000000 | 28 | 27 | 2024-10-17 06:23:54+02:00 | -1 |
12071310 | 12071310 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:23:47.000000 | 17 | 20 | 2024-10-17 06:23:47+02:00 | 3 |
12071309 | 12071309 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:23:16.000000 | 20 | 22 | 2024-10-17 06:23:16+02:00 | 2 |
12071308 | 12071308 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:22:57.000000 | 31 | 28 | 2024-10-17 06:22:57+02:00 | -3 |
12071307 | 12071307 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:22:14.000000 | 29 | 26 | 2024-10-17 06:22:14+02:00 | -3 |
12071306 | 12071306 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:22:04.000000 | 26 | 23 | 2024-10-17 06:22:04+02:00 | -3 |
12071305 | 12071305 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:21:50.000000 | 26 | 25 | 2024-10-17 06:21:50+02:00 | -1 |
12071304 | 12071304 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:21:43.000000 | 32 | 29 | 2024-10-17 06:21:43+02:00 | -3 |
12071303 | 12071303 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:21:37.000000 | 28 | 31 | 2024-10-17 06:21:37+02:00 | 3 |
12071302 | 12071302 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:21:20.000000 | 26 | 17 | 2024-10-17 06:21:20+02:00 | -9 |
12071301 | 12071301 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:21:04.000000 | 25 | 23 | 2024-10-17 06:21:04+02:00 | -2 |
12071300 | 12071300 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:20:57.000000 | 28 | 24 | 2024-10-17 06:20:57+02:00 | -4 |
12071299 | 12071299 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:20:46.000000 | 31 | 28 | 2024-10-17 06:20:46+02:00 | -3 |
12071298 | 12071298 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:20:42.000000 | 28 | 26 | 2024-10-17 06:20:42+02:00 | -2 |
12071297 | 12071297 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:20:29.000000 | 31 | 27 | 2024-10-17 06:20:29+02:00 | -4 |
12071296 | 12071296 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:20:24.000000 | 31 | 26 | 2024-10-17 06:20:24+02:00 | -5 |
12071295 | 12071295 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:20:21.000000 | 16 | 19 | 2024-10-17 06:20:21+02:00 | 3 |
12071294 | 12071294 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:20:14.000000 | 32 | 30 | 2024-10-17 06:20:14+02:00 | -2 |
12071293 | 12071293 | Gellertstrasse 4-117 | 117 | 4 | Nachmessung | 2024-10-17 | 06:20:08.000000 | 19 | 11 | 2024-10-17 06:20:08+02:00 | -8 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE Einzelmessungen ( ID TEXT, id_standort INTEGER, Zyklus INTEGER, Phase TEXT, Messung_Datum TEXT, Messung_Zeit TEXT, V_Einfahrt INTEGER, V_Ausfahrt INTEGER, Messung_Timestamp TEXT, V_Delta INTEGER, FOREIGN KEY (ID) REFERENCES Einsatzplan (ID) ON DELETE CASCADE ); CREATE INDEX idx_Einzelmessungen_id ON "Einzelmessungen" ("ID"); CREATE INDEX idx_Einzelmessungen_id_standort ON "Einzelmessungen" ("id_standort"); CREATE INDEX idx_Einzelmessungen_zyklus ON "Einzelmessungen" ("Zyklus"); CREATE INDEX idx_Einzelmessungen_phase ON "Einzelmessungen" ("Phase"); CREATE INDEX idx_Einzelmessungen_messung_datum ON "Einzelmessungen" ("Messung_Datum"); CREATE INDEX idx_Einzelmessungen_messung_timestamp ON "Einzelmessungen" ("Messung_Timestamp");