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 = "1-54" sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Messung_Datum, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
7406463 | 7406463 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:45:19.000000 | 28 | 30 | 2023-07-09 23:45:19+02:00 | 2 |
7406462 | 7406462 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:44:01.000000 | 36 | 19 | 2023-07-09 23:44:01+02:00 | -17 |
7406461 | 7406461 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:43:55.000000 | 39 | 37 | 2023-07-09 23:43:55+02:00 | -2 |
7406460 | 7406460 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:43:42.000000 | 48 | 47 | 2023-07-09 23:43:42+02:00 | -1 |
7406459 | 7406459 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:43:13.000000 | 46 | 43 | 2023-07-09 23:43:13+02:00 | -3 |
7406458 | 7406458 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:42:12.000000 | 26 | 32 | 2023-07-09 23:42:12+02:00 | 6 |
7406457 | 7406457 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:42:04.000000 | 35 | 30 | 2023-07-09 23:42:04+02:00 | -5 |
7406456 | 7406456 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:41:56.000000 | 45 | 43 | 2023-07-09 23:41:56+02:00 | -2 |
7406455 | 7406455 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:41:54.000000 | 55 | 45 | 2023-07-09 23:41:54+02:00 | -10 |
7406454 | 7406454 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:41:50.000000 | 49 | 55 | 2023-07-09 23:41:50+02:00 | 6 |
7406453 | 7406453 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:40:47.000000 | 25 | 19 | 2023-07-09 23:40:47+02:00 | -6 |
7406452 | 7406452 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:40:40.000000 | 37 | 32 | 2023-07-09 23:40:40+02:00 | -5 |
7406451 | 7406451 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:40:20.000000 | 18 | 19 | 2023-07-09 23:40:20+02:00 | 1 |
7406450 | 7406450 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:40:10.000000 | 29 | 22 | 2023-07-09 23:40:10+02:00 | -7 |
7406449 | 7406449 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:39:59.000000 | 29 | 28 | 2023-07-09 23:39:59+02:00 | -1 |
7406448 | 7406448 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:39:54.000000 | 38 | 30 | 2023-07-09 23:39:54+02:00 | -8 |
7406447 | 7406447 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:39:46.000000 | 28 | 36 | 2023-07-09 23:39:46+02:00 | 8 |
7406446 | 7406446 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:39:02.000000 | 37 | 23 | 2023-07-09 23:39:02+02:00 | -14 |
7406445 | 7406445 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:38:54.000000 | 35 | 36 | 2023-07-09 23:38:54+02:00 | 1 |
7406444 | 7406444 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:37:53.000000 | 38 | 35 | 2023-07-09 23:37:53+02:00 | -3 |
7406443 | 7406443 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:37:51.000000 | 45 | 35 | 2023-07-09 23:37:51+02:00 | -10 |
7406442 | 7406442 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:37:43.000000 | 46 | 44 | 2023-07-09 23:37:43+02:00 | -2 |
7406441 | 7406441 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:37:17.000000 | 47 | 46 | 2023-07-09 23:37:17+02:00 | -1 |
7406440 | 7406440 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:36:11.000000 | 28 | 26 | 2023-07-09 23:36:11+02:00 | -2 |
7406439 | 7406439 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:35:47.000000 | 28 | 28 | 2023-07-09 23:35:47+02:00 | 0 |
7406438 | 7406438 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:35:36.000000 | 29 | 27 | 2023-07-09 23:35:36+02:00 | -2 |
7406437 | 7406437 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:34:09.000000 | 41 | 33 | 2023-07-09 23:34:09+02:00 | -8 |
7406435 | 7406435 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:34:02.000000 | 45 | 45 | 2023-07-09 23:34:02+02:00 | 0 |
7406436 | 7406436 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:34:02.000000 | 39 | 33 | 2023-07-09 23:34:02+02:00 | -6 |
7406434 | 7406434 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:33:55.000000 | 43 | 43 | 2023-07-09 23:33:55+02:00 | 0 |
7406433 | 7406433 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:33:50.000000 | 25 | 29 | 2023-07-09 23:33:50+02:00 | 4 |
7406432 | 7406432 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:33:45.000000 | 46 | 32 | 2023-07-09 23:33:45+02:00 | -14 |
7406431 | 7406431 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:33:39.000000 | 35 | 30 | 2023-07-09 23:33:39+02:00 | -5 |
7406430 | 7406430 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:33:37.000000 | 43 | 47 | 2023-07-09 23:33:37+02:00 | 4 |
7406429 | 7406429 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:33:28.000000 | 36 | 34 | 2023-07-09 23:33:28+02:00 | -2 |
7406428 | 7406428 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:33:20.000000 | 38 | 34 | 2023-07-09 23:33:20+02:00 | -4 |
7406427 | 7406427 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:32:59.000000 | 39 | 29 | 2023-07-09 23:32:59+02:00 | -10 |
7406426 | 7406426 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:32:54.000000 | 46 | 43 | 2023-07-09 23:32:54+02:00 | -3 |
7406425 | 7406425 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:32:47.000000 | 54 | 47 | 2023-07-09 23:32:47+02:00 | -7 |
7406424 | 7406424 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:32:42.000000 | 36 | 32 | 2023-07-09 23:32:42+02:00 | -4 |
7406423 | 7406423 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:32:33.000000 | 41 | 38 | 2023-07-09 23:32:33+02:00 | -3 |
7406422 | 7406422 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:31:51.000000 | 39 | 32 | 2023-07-09 23:31:51+02:00 | -7 |
7406421 | 7406421 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:31:44.000000 | 40 | 38 | 2023-07-09 23:31:44+02:00 | -2 |
7406420 | 7406420 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:31:19.000000 | 40 | 29 | 2023-07-09 23:31:19+02:00 | -11 |
7406419 | 7406419 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:31:12.000000 | 40 | 40 | 2023-07-09 23:31:12+02:00 | 0 |
7406418 | 7406418 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:30:29.000000 | 50 | 32 | 2023-07-09 23:30:29+02:00 | -18 |
7406417 | 7406417 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:30:23.000000 | 51 | 48 | 2023-07-09 23:30:23+02:00 | -3 |
7406416 | 7406416 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:28:50.000000 | 52 | 46 | 2023-07-09 23:28:50+02:00 | -6 |
7406415 | 7406415 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:28:44.000000 | 52 | 50 | 2023-07-09 23:28:44+02:00 | -2 |
7406414 | 7406414 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:28:05.000000 | 41 | 33 | 2023-07-09 23:28:05+02:00 | -8 |
7406413 | 7406413 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:27:23.000000 | 30 | 31 | 2023-07-09 23:27:23+02:00 | 1 |
7406412 | 7406412 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:27:22.000000 | 31 | 32 | 2023-07-09 23:27:22+02:00 | 1 |
7406411 | 7406411 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:27:13.000000 | 30 | 35 | 2023-07-09 23:27:13+02:00 | 5 |
7406410 | 7406410 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:26:49.000000 | 31 | 27 | 2023-07-09 23:26:49+02:00 | -4 |
7406409 | 7406409 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:26:43.000000 | 37 | 34 | 2023-07-09 23:26:43+02:00 | -3 |
7406408 | 7406408 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:26:39.000000 | 36 | 26 | 2023-07-09 23:26:39+02:00 | -10 |
7406407 | 7406407 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:26:30.000000 | 47 | 35 | 2023-07-09 23:26:30+02:00 | -12 |
7406406 | 7406406 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:26:24.000000 | 40 | 44 | 2023-07-09 23:26:24+02:00 | 4 |
7406405 | 7406405 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:25:42.000000 | 46 | 41 | 2023-07-09 23:25:42+02:00 | -5 |
7406404 | 7406404 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:25:10.000000 | 33 | 24 | 2023-07-09 23:25:10+02:00 | -9 |
7406403 | 7406403 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:25:09.000000 | 43 | 31 | 2023-07-09 23:25:09+02:00 | -12 |
7406402 | 7406402 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:25:02.000000 | 36 | 47 | 2023-07-09 23:25:02+02:00 | 11 |
7406401 | 7406401 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:24:52.000000 | 40 | 35 | 2023-07-09 23:24:52+02:00 | -5 |
7406400 | 7406400 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:24:01.000000 | 43 | 30 | 2023-07-09 23:24:01+02:00 | -13 |
7406399 | 7406399 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:23:58.000000 | 49 | 43 | 2023-07-09 23:23:58+02:00 | -6 |
7406398 | 7406398 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:22:31.000000 | 30 | 25 | 2023-07-09 23:22:31+02:00 | -5 |
7406397 | 7406397 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:22:21.000000 | 40 | 29 | 2023-07-09 23:22:21+02:00 | -11 |
7406396 | 7406396 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:22:14.000000 | 39 | 40 | 2023-07-09 23:22:14+02:00 | 1 |
7406395 | 7406395 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:22:11.000000 | 46 | 43 | 2023-07-09 23:22:11+02:00 | -3 |
7406394 | 7406394 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:21:03.000000 | 35 | 40 | 2023-07-09 23:21:03+02:00 | 5 |
7406393 | 7406393 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:21:02.000000 | 43 | 43 | 2023-07-09 23:21:02+02:00 | 0 |
7406392 | 7406392 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:20:56.000000 | 38 | 47 | 2023-07-09 23:20:56+02:00 | 9 |
7406391 | 7406391 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:20:44.000000 | 38 | 36 | 2023-07-09 23:20:44+02:00 | -2 |
7406390 | 7406390 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:20:37.000000 | 46 | 37 | 2023-07-09 23:20:37+02:00 | -9 |
7406389 | 7406389 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:20:30.000000 | 34 | 45 | 2023-07-09 23:20:30+02:00 | 11 |
7406388 | 7406388 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:20:18.000000 | 37 | 33 | 2023-07-09 23:20:18+02:00 | -4 |
7406387 | 7406387 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:20:10.000000 | 39 | 36 | 2023-07-09 23:20:10+02:00 | -3 |
7406386 | 7406386 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:20:04.000000 | 43 | 41 | 2023-07-09 23:20:04+02:00 | -2 |
7406385 | 7406385 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:19:27.000000 | 39 | 38 | 2023-07-09 23:19:27+02:00 | -1 |
7406384 | 7406384 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:19:20.000000 | 35 | 43 | 2023-07-09 23:19:20+02:00 | 8 |
7406383 | 7406383 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:19:17.000000 | 54 | 45 | 2023-07-09 23:19:17+02:00 | -9 |
7406382 | 7406382 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:19:05.000000 | 50 | 43 | 2023-07-09 23:19:05+02:00 | -7 |
7406381 | 7406381 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:18:47.000000 | 47 | 49 | 2023-07-09 23:18:47+02:00 | 2 |
7406380 | 7406380 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:18:15.000000 | 40 | 35 | 2023-07-09 23:18:15+02:00 | -5 |
7406379 | 7406379 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:16:51.000000 | 34 | 31 | 2023-07-09 23:16:51+02:00 | -3 |
7406378 | 7406378 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:16:47.000000 | 41 | 38 | 2023-07-09 23:16:47+02:00 | -3 |
7406377 | 7406377 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:16:39.000000 | 41 | 41 | 2023-07-09 23:16:39+02:00 | 0 |
7406376 | 7406376 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:15:40.000000 | 35 | 34 | 2023-07-09 23:15:40+02:00 | -1 |
7406375 | 7406375 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:15:36.000000 | 45 | 44 | 2023-07-09 23:15:36+02:00 | -1 |
7406374 | 7406374 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:15:17.000000 | 35 | 34 | 2023-07-09 23:15:17+02:00 | -1 |
7406373 | 7406373 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:15:09.000000 | 35 | 36 | 2023-07-09 23:15:09+02:00 | 1 |
7406372 | 7406372 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:14:30.000000 | 37 | 35 | 2023-07-09 23:14:30+02:00 | -2 |
7406371 | 7406371 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:14:26.000000 | 46 | 37 | 2023-07-09 23:14:26+02:00 | -9 |
7406370 | 7406370 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:14:21.000000 | 43 | 36 | 2023-07-09 23:14:21+02:00 | -7 |
7406369 | 7406369 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:13:59.000000 | 45 | 37 | 2023-07-09 23:13:59+02:00 | -8 |
7406368 | 7406368 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:13:52.000000 | 45 | 43 | 2023-07-09 23:13:52+02:00 | -2 |
7406367 | 7406367 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:13:27.000000 | 38 | 35 | 2023-07-09 23:13:27+02:00 | -3 |
7406366 | 7406366 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:13:19.000000 | 38 | 37 | 2023-07-09 23:13:19+02:00 | -1 |
7406365 | 7406365 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:13:11.000000 | 46 | 38 | 2023-07-09 23:13:11+02:00 | -8 |
7406364 | 7406364 | Giornicostrasse 1-54 | 54 | 1 | Nachmessung | 2023-07-09 | 23:12:51.000000 | 23 | 36 | 2023-07-09 23:12:51+02:00 | 13 |
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");