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-11" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2595422 | 2595422 | Kohlistieg 1-11 | 11 | 1 | Nach Ende | 2023-07-11 | 06:36:06.000000 | 53 | 45 | 2023-07-11 06:36:06+02:00 | -8 |
| 2595421 | 2595421 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:35:51.000000 | 49 | 41 | 2023-07-11 06:35:51+02:00 | -8 |
| 2595420 | 2595420 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:35:44.000000 | 49 | 39 | 2023-07-11 06:35:44+02:00 | -10 |
| 2595419 | 2595419 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:35:15.000000 | 52 | 43 | 2023-07-11 06:35:15+02:00 | -9 |
| 2595418 | 2595418 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:35:05.000000 | 46 | 50 | 2023-07-11 06:35:05+02:00 | 4 |
| 2595417 | 2595417 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:34:36.000000 | 48 | 35 | 2023-07-11 06:34:36+02:00 | -13 |
| 2595416 | 2595416 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:34:34.000000 | 18 | 16 | 2023-07-11 06:34:34+02:00 | -2 |
| 2595415 | 2595415 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:33:56.000000 | 57 | 51 | 2023-07-11 06:33:56+02:00 | -6 |
| 2595414 | 2595414 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:33:35.000000 | 25 | 35 | 2023-07-11 06:33:35+02:00 | 10 |
| 2595413 | 2595413 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:33:16.000000 | 49 | 41 | 2023-07-11 06:33:16+02:00 | -8 |
| 2595412 | 2595412 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:33:13.000000 | 45 | 33 | 2023-07-11 06:33:13+02:00 | -12 |
| 2595411 | 2595411 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:32:59.000000 | 33 | 31 | 2023-07-11 06:32:59+02:00 | -2 |
| 2595410 | 2595410 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:32:52.000000 | 43 | 44 | 2023-07-11 06:32:52+02:00 | 1 |
| 2595409 | 2595409 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:32:45.000000 | 31 | 43 | 2023-07-11 06:32:45+02:00 | 12 |
| 2595408 | 2595408 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:31:59.000000 | 55 | 41 | 2023-07-11 06:31:59+02:00 | -14 |
| 2595407 | 2595407 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:31:05.000000 | 48 | 23 | 2023-07-11 06:31:05+02:00 | -25 |
| 2595406 | 2595406 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:30:57.000000 | 20 | 25 | 2023-07-11 06:30:57+02:00 | 5 |
| 2595405 | 2595405 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:30:20.000000 | 48 | 41 | 2023-07-11 06:30:20+02:00 | -7 |
| 2595404 | 2595404 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:29:36.000000 | 57 | 39 | 2023-07-11 06:29:36+02:00 | -18 |
| 2595403 | 2595403 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:29:31.000000 | 53 | 54 | 2023-07-11 06:29:31+02:00 | 1 |
| 2595402 | 2595402 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:27:53.000000 | 50 | 40 | 2023-07-11 06:27:53+02:00 | -10 |
| 2595401 | 2595401 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:26:18.000000 | 39 | 34 | 2023-07-11 06:26:18+02:00 | -5 |
| 2595400 | 2595400 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:26:12.000000 | 52 | 41 | 2023-07-11 06:26:12+02:00 | -11 |
| 2595399 | 2595399 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:26:10.000000 | 47 | 38 | 2023-07-11 06:26:10+02:00 | -9 |
| 2595398 | 2595398 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:26:02.000000 | 55 | 47 | 2023-07-11 06:26:02+02:00 | -8 |
| 2595397 | 2595397 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:25:55.000000 | 50 | 44 | 2023-07-11 06:25:55+02:00 | -6 |
| 2595396 | 2595396 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:25:50.000000 | 43 | 39 | 2023-07-11 06:25:50+02:00 | -4 |
| 2595395 | 2595395 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:25:36.000000 | 41 | 41 | 2023-07-11 06:25:36+02:00 | 0 |
| 2595394 | 2595394 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:25:33.000000 | 45 | 44 | 2023-07-11 06:25:33+02:00 | -1 |
| 2595393 | 2595393 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:25:26.000000 | 43 | 43 | 2023-07-11 06:25:26+02:00 | 0 |
| 2595392 | 2595392 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:25:19.000000 | 41 | 41 | 2023-07-11 06:25:19+02:00 | 0 |
| 2595391 | 2595391 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:24:58.000000 | 54 | 44 | 2023-07-11 06:24:58+02:00 | -10 |
| 2595390 | 2595390 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:24:38.000000 | 55 | 53 | 2023-07-11 06:24:38+02:00 | -2 |
| 2595389 | 2595389 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:24:34.000000 | 33 | 46 | 2023-07-11 06:24:34+02:00 | 13 |
| 2595388 | 2595388 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:24:27.000000 | 33 | 47 | 2023-07-11 06:24:27+02:00 | 14 |
| 2595387 | 2595387 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:23:56.000000 | 45 | 39 | 2023-07-11 06:23:56+02:00 | -6 |
| 2595386 | 2595386 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:23:31.000000 | 52 | 43 | 2023-07-11 06:23:31+02:00 | -9 |
| 2595385 | 2595385 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:23:10.000000 | 49 | 40 | 2023-07-11 06:23:10+02:00 | -9 |
| 2595384 | 2595384 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:21:34.000000 | 41 | 37 | 2023-07-11 06:21:34+02:00 | -4 |
| 2595383 | 2595383 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:21:28.000000 | 41 | 45 | 2023-07-11 06:21:28+02:00 | 4 |
| 2595382 | 2595382 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:21:20.000000 | 49 | 40 | 2023-07-11 06:21:20+02:00 | -9 |
| 2595381 | 2595381 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:21:09.000000 | 51 | 46 | 2023-07-11 06:21:09+02:00 | -5 |
| 2595380 | 2595380 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:21:03.000000 | 47 | 49 | 2023-07-11 06:21:03+02:00 | 2 |
| 2595379 | 2595379 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:20:34.000000 | 55 | 39 | 2023-07-11 06:20:34+02:00 | -16 |
| 2595378 | 2595378 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:19:03.000000 | 41 | 34 | 2023-07-11 06:19:03+02:00 | -7 |
| 2595377 | 2595377 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:18:55.000000 | 57 | 49 | 2023-07-11 06:18:55+02:00 | -8 |
| 2595376 | 2595376 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:18:44.000000 | 39 | 54 | 2023-07-11 06:18:44+02:00 | 15 |
| 2595375 | 2595375 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:17:01.000000 | 54 | 43 | 2023-07-11 06:17:01+02:00 | -11 |
| 2595374 | 2595374 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:15:48.000000 | 48 | 44 | 2023-07-11 06:15:48+02:00 | -4 |
| 2595373 | 2595373 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:15:42.000000 | 47 | 46 | 2023-07-11 06:15:42+02:00 | -1 |
| 2595372 | 2595372 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:15:21.000000 | 51 | 43 | 2023-07-11 06:15:21+02:00 | -8 |
| 2595371 | 2595371 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:15:14.000000 | 43 | 46 | 2023-07-11 06:15:14+02:00 | 3 |
| 2595370 | 2595370 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:15:09.000000 | 49 | 48 | 2023-07-11 06:15:09+02:00 | -1 |
| 2595369 | 2595369 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:15:03.000000 | 53 | 50 | 2023-07-11 06:15:03+02:00 | -3 |
| 2595368 | 2595368 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:14:58.000000 | 46 | 46 | 2023-07-11 06:14:58+02:00 | 0 |
| 2595367 | 2595367 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:14:57.000000 | 51 | 51 | 2023-07-11 06:14:57+02:00 | 0 |
| 2595366 | 2595366 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:14:53.000000 | 48 | 35 | 2023-07-11 06:14:53+02:00 | -13 |
| 2595365 | 2595365 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:14:43.000000 | 43 | 46 | 2023-07-11 06:14:43+02:00 | 3 |
| 2595364 | 2595364 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:14:14.000000 | 56 | 41 | 2023-07-11 06:14:14+02:00 | -15 |
| 2595363 | 2595363 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:14:12.000000 | 55 | 49 | 2023-07-11 06:14:12+02:00 | -6 |
| 2595362 | 2595362 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:13:15.000000 | 50 | 39 | 2023-07-11 06:13:15+02:00 | -11 |
| 2595361 | 2595361 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:12:44.000000 | 49 | 40 | 2023-07-11 06:12:44+02:00 | -9 |
| 2595360 | 2595360 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:12:29.000000 | 49 | 38 | 2023-07-11 06:12:29+02:00 | -11 |
| 2595359 | 2595359 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:12:23.000000 | 41 | 46 | 2023-07-11 06:12:23+02:00 | 5 |
| 2595358 | 2595358 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:12:11.000000 | 38 | 35 | 2023-07-11 06:12:11+02:00 | -3 |
| 2595357 | 2595357 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:11:56.000000 | 29 | 37 | 2023-07-11 06:11:56+02:00 | 8 |
| 2595356 | 2595356 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:11:38.000000 | 51 | 48 | 2023-07-11 06:11:38+02:00 | -3 |
| 2595355 | 2595355 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:11:31.000000 | 51 | 49 | 2023-07-11 06:11:31+02:00 | -2 |
| 2595354 | 2595354 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:10:46.000000 | 53 | 48 | 2023-07-11 06:10:46+02:00 | -5 |
| 2595353 | 2595353 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:10:11.000000 | 36 | 38 | 2023-07-11 06:10:11+02:00 | 2 |
| 2595352 | 2595352 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:10:08.000000 | 47 | 40 | 2023-07-11 06:10:08+02:00 | -7 |
| 2595351 | 2595351 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:09:59.000000 | 38 | 47 | 2023-07-11 06:09:59+02:00 | 9 |
| 2595350 | 2595350 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:09:36.000000 | 58 | 48 | 2023-07-11 06:09:36+02:00 | -10 |
| 2595349 | 2595349 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:09:27.000000 | 52 | 56 | 2023-07-11 06:09:27+02:00 | 4 |
| 2595348 | 2595348 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:08:59.000000 | 56 | 41 | 2023-07-11 06:08:59+02:00 | -15 |
| 2595347 | 2595347 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:08:55.000000 | 36 | 32 | 2023-07-11 06:08:55+02:00 | -4 |
| 2595346 | 2595346 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:08:53.000000 | 43 | 55 | 2023-07-11 06:08:53+02:00 | 12 |
| 2595345 | 2595345 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:08:42.000000 | 64 | 55 | 2023-07-11 06:08:42+02:00 | -9 |
| 2595344 | 2595344 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:08:37.000000 | 38 | 39 | 2023-07-11 06:08:37+02:00 | 1 |
| 2595343 | 2595343 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:08:32.000000 | 48 | 52 | 2023-07-11 06:08:32+02:00 | 4 |
| 2595342 | 2595342 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:07:50.000000 | 50 | 41 | 2023-07-11 06:07:50+02:00 | -9 |
| 2595341 | 2595341 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:07:14.000000 | 49 | 43 | 2023-07-11 06:07:14+02:00 | -6 |
| 2595340 | 2595340 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:07:04.000000 | 50 | 39 | 2023-07-11 06:07:04+02:00 | -11 |
| 2595339 | 2595339 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:06:37.000000 | 49 | 40 | 2023-07-11 06:06:37+02:00 | -9 |
| 2595338 | 2595338 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:06:03.000000 | 43 | 47 | 2023-07-11 06:06:03+02:00 | 4 |
| 2595337 | 2595337 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:05:26.000000 | 55 | 53 | 2023-07-11 06:05:26+02:00 | -2 |
| 2595336 | 2595336 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:05:20.000000 | 53 | 53 | 2023-07-11 06:05:20+02:00 | 0 |
| 2595335 | 2595335 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:05:08.000000 | 51 | 44 | 2023-07-11 06:05:08+02:00 | -7 |
| 2595334 | 2595334 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:04:49.000000 | 52 | 46 | 2023-07-11 06:04:49+02:00 | -6 |
| 2595333 | 2595333 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:04:44.000000 | 49 | 40 | 2023-07-11 06:04:44+02:00 | -9 |
| 2595332 | 2595332 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:04:36.000000 | 47 | 39 | 2023-07-11 06:04:36+02:00 | -8 |
| 2595331 | 2595331 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:04:30.000000 | 41 | 45 | 2023-07-11 06:04:30+02:00 | 4 |
| 2595330 | 2595330 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:02:50.000000 | 43 | 44 | 2023-07-11 06:02:50+02:00 | 1 |
| 2595329 | 2595329 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:02:00.000000 | 48 | 51 | 2023-07-11 06:02:00+02:00 | 3 |
| 2595328 | 2595328 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:01:38.000000 | 48 | 41 | 2023-07-11 06:01:38+02:00 | -7 |
| 2595327 | 2595327 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:01:30.000000 | 38 | 45 | 2023-07-11 06:01:30+02:00 | 7 |
| 2595326 | 2595326 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:01:10.000000 | 51 | 43 | 2023-07-11 06:01:10+02:00 | -8 |
| 2595325 | 2595325 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:01:02.000000 | 48 | 43 | 2023-07-11 06:01:02+02:00 | -5 |
| 2595324 | 2595324 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:00:55.000000 | 47 | 43 | 2023-07-11 06:00:55+02:00 | -4 |
| 2595323 | 2595323 | Kohlistieg 1-11 | 11 | 1 | Nachmessung | 2023-07-11 | 06:00:10.000000 | 53 | 45 | 2023-07-11 06:00:10+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");