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 = "3-13" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15247486 | 15247486 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:50:12.000000 | 11 | 4 | 2024-05-06 08:50:12+02:00 | -7 |
| 15247485 | 15247485 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:49:25.000000 | 10 | 11 | 2024-05-06 08:49:25+02:00 | 1 |
| 15247484 | 15247484 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:48:22.000000 | 24 | 33 | 2024-05-06 08:48:22+02:00 | 9 |
| 15247483 | 15247483 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:44:06.000000 | 26 | 30 | 2024-05-06 08:44:06+02:00 | 4 |
| 15247482 | 15247482 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:42:19.000000 | 17 | 18 | 2024-05-06 08:42:19+02:00 | 1 |
| 15247481 | 15247481 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:39:49.000000 | 27 | 29 | 2024-05-06 08:39:49+02:00 | 2 |
| 15247480 | 15247480 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:39:19.000000 | 24 | 26 | 2024-05-06 08:39:19+02:00 | 2 |
| 15247479 | 15247479 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:26:05.000000 | 26 | 25 | 2024-05-06 08:26:05+02:00 | -1 |
| 15247478 | 15247478 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:23:58.000000 | 41 | 38 | 2024-05-06 08:23:58+02:00 | -3 |
| 15247477 | 15247477 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:14:16.000000 | 25 | 19 | 2024-05-06 08:14:16+02:00 | -6 |
| 15247476 | 15247476 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:14:04.000000 | 25 | 18 | 2024-05-06 08:14:04+02:00 | -7 |
| 15247475 | 15247475 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:12:49.000000 | 30 | 22 | 2024-05-06 08:12:49+02:00 | -8 |
| 15247474 | 15247474 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:11:30.000000 | 8 | 11 | 2024-05-06 08:11:30+02:00 | 3 |
| 15247473 | 15247473 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:06:04.000000 | 26 | 22 | 2024-05-06 08:06:04+02:00 | -4 |
| 15247472 | 15247472 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:04:36.000000 | 20 | 23 | 2024-05-06 08:04:36+02:00 | 3 |
| 15247471 | 15247471 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:57:37.000000 | 19 | 29 | 2024-05-06 07:57:37+02:00 | 10 |
| 15247470 | 15247470 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:51:22.000000 | 2 | 3 | 2024-05-06 07:51:22+02:00 | 1 |
| 15247469 | 15247469 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:49:18.000000 | 11 | 27 | 2024-05-06 07:49:18+02:00 | 16 |
| 15247468 | 15247468 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:48:04.000000 | 36 | 32 | 2024-05-06 07:48:04+02:00 | -4 |
| 15247467 | 15247467 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:46:57.000000 | 14 | 30 | 2024-05-06 07:46:57+02:00 | 16 |
| 15247466 | 15247466 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:45:19.000000 | 15 | 19 | 2024-05-06 07:45:19+02:00 | 4 |
| 15247465 | 15247465 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:44:06.000000 | 2 | 4 | 2024-05-06 07:44:06+02:00 | 2 |
| 15247464 | 15247464 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:42:01.000000 | 19 | 27 | 2024-05-06 07:42:01+02:00 | 8 |
| 15247463 | 15247463 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:39:09.000000 | 31 | 29 | 2024-05-06 07:39:09+02:00 | -2 |
| 15247462 | 15247462 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:38:17.000000 | 23 | 24 | 2024-05-06 07:38:17+02:00 | 1 |
| 15247461 | 15247461 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:36:45.000000 | 2 | 5 | 2024-05-06 07:36:45+02:00 | 3 |
| 15247460 | 15247460 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:34:31.000000 | 29 | 26 | 2024-05-06 07:34:31+02:00 | -3 |
| 15247459 | 15247459 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:34:16.000000 | 7 | 3 | 2024-05-06 07:34:16+02:00 | -4 |
| 15247458 | 15247458 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:32:57.000000 | 24 | 18 | 2024-05-06 07:32:57+02:00 | -6 |
| 15247457 | 15247457 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:30:15.000000 | 30 | 28 | 2024-05-06 07:30:15+02:00 | -2 |
| 15247456 | 15247456 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:30:05.000000 | 28 | 29 | 2024-05-06 07:30:05+02:00 | 1 |
| 15247455 | 15247455 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:29:54.000000 | 29 | 25 | 2024-05-06 07:29:54+02:00 | -4 |
| 15247454 | 15247454 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:27:06.000000 | 17 | 22 | 2024-05-06 07:27:06+02:00 | 5 |
| 15247453 | 15247453 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:24:57.000000 | 30 | 28 | 2024-05-06 07:24:57+02:00 | -2 |
| 15247452 | 15247452 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:24:37.000000 | 15 | 19 | 2024-05-06 07:24:37+02:00 | 4 |
| 15247451 | 15247451 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:20:49.000000 | 3 | 7 | 2024-05-06 07:20:49+02:00 | 4 |
| 15247450 | 15247450 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:16:27.000000 | 27 | 26 | 2024-05-06 07:16:27+02:00 | -1 |
| 15247449 | 15247449 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:16:16.000000 | 18 | 20 | 2024-05-06 07:16:16+02:00 | 2 |
| 15247448 | 15247448 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:16:07.000000 | 28 | 26 | 2024-05-06 07:16:07+02:00 | -2 |
| 15247447 | 15247447 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:13:24.000000 | 29 | 29 | 2024-05-06 07:13:24+02:00 | 0 |
| 15247446 | 15247446 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:12:59.000000 | 28 | 28 | 2024-05-06 07:12:59+02:00 | 0 |
| 15247445 | 15247445 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:11:25.000000 | 24 | 24 | 2024-05-06 07:11:25+02:00 | 0 |
| 15247444 | 15247444 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:11:04.000000 | 3 | 8 | 2024-05-06 07:11:04+02:00 | 5 |
| 15247443 | 15247443 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:09:08.000000 | 5 | 3 | 2024-05-06 07:09:08+02:00 | -2 |
| 15247442 | 15247442 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:08:06.000000 | 2 | 5 | 2024-05-06 07:08:06+02:00 | 3 |
| 15247441 | 15247441 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:06:21.000000 | 23 | 26 | 2024-05-06 07:06:21+02:00 | 3 |
| 15247440 | 15247440 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:56:52.000000 | 25 | 17 | 2024-05-06 06:56:52+02:00 | -8 |
| 15247439 | 15247439 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:54:57.000000 | 36 | 31 | 2024-05-06 06:54:57+02:00 | -5 |
| 15247438 | 15247438 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:54:12.000000 | 24 | 25 | 2024-05-06 06:54:12+02:00 | 1 |
| 15247437 | 15247437 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:54:07.000000 | 29 | 30 | 2024-05-06 06:54:07+02:00 | 1 |
| 15247436 | 15247436 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:50:02.000000 | 23 | 24 | 2024-05-06 06:50:02+02:00 | 1 |
| 15247435 | 15247435 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:49:57.000000 | 31 | 25 | 2024-05-06 06:49:57+02:00 | -6 |
| 15247434 | 15247434 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:49:16.000000 | 10 | 20 | 2024-05-06 06:49:16+02:00 | 10 |
| 15247433 | 15247433 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:48:23.000000 | 9 | 4 | 2024-05-06 06:48:23+02:00 | -5 |
| 15247432 | 15247432 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:45:31.000000 | 29 | 20 | 2024-05-06 06:45:31+02:00 | -9 |
| 15247431 | 15247431 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:41:27.000000 | 24 | 29 | 2024-05-06 06:41:27+02:00 | 5 |
| 15247430 | 15247430 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:35:14.000000 | 25 | 27 | 2024-05-06 06:35:14+02:00 | 2 |
| 15247429 | 15247429 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:33:56.000000 | 36 | 39 | 2024-05-06 06:33:56+02:00 | 3 |
| 15247428 | 15247428 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:31:44.000000 | 29 | 32 | 2024-05-06 06:31:44+02:00 | 3 |
| 15247427 | 15247427 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:27:12.000000 | 26 | 27 | 2024-05-06 06:27:12+02:00 | 1 |
| 15247426 | 15247426 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:27:01.000000 | 27 | 25 | 2024-05-06 06:27:01+02:00 | -2 |
| 15247425 | 15247425 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:26:32.000000 | 24 | 40 | 2024-05-06 06:26:32+02:00 | 16 |
| 15247424 | 15247424 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:23:44.000000 | 31 | 34 | 2024-05-06 06:23:44+02:00 | 3 |
| 15247423 | 15247423 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:22:19.000000 | 24 | 22 | 2024-05-06 06:22:19+02:00 | -2 |
| 15247422 | 15247422 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:18:23.000000 | 16 | 24 | 2024-05-06 06:18:23+02:00 | 8 |
| 15247421 | 15247421 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:17:45.000000 | 18 | 17 | 2024-05-06 06:17:45+02:00 | -1 |
| 15247420 | 15247420 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:17:16.000000 | 26 | 22 | 2024-05-06 06:17:16+02:00 | -4 |
| 15247419 | 15247419 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:11:20.000000 | 20 | 27 | 2024-05-06 06:11:20+02:00 | 7 |
| 15247418 | 15247418 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:05:50.000000 | 30 | 34 | 2024-05-06 06:05:50+02:00 | 4 |
| 15247417 | 15247417 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:04:22.000000 | 23 | 30 | 2024-05-06 06:04:22+02:00 | 7 |
| 15247416 | 15247416 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:02:56.000000 | 24 | 20 | 2024-05-06 06:02:56+02:00 | -4 |
| 15247415 | 15247415 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:00:56.000000 | 25 | 17 | 2024-05-06 06:00:56+02:00 | -8 |
| 15247414 | 15247414 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:58:58.000000 | 30 | 27 | 2024-05-06 05:58:58+02:00 | -3 |
| 15247413 | 15247413 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:56:30.000000 | 19 | 17 | 2024-05-06 05:56:30+02:00 | -2 |
| 15247412 | 15247412 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:55:43.000000 | 8 | 23 | 2024-05-06 05:55:43+02:00 | 15 |
| 15247411 | 15247411 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:55:18.000000 | 28 | 25 | 2024-05-06 05:55:18+02:00 | -3 |
| 15247410 | 15247410 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:52:14.000000 | 26 | 23 | 2024-05-06 05:52:14+02:00 | -3 |
| 15247409 | 15247409 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:48:46.000000 | 20 | 23 | 2024-05-06 05:48:46+02:00 | 3 |
| 15247408 | 15247408 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:36:46.000000 | 33 | 31 | 2024-05-06 05:36:46+02:00 | -2 |
| 15247407 | 15247407 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:35:15.000000 | 18 | 24 | 2024-05-06 05:35:15+02:00 | 6 |
| 15247406 | 15247406 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:34:17.000000 | 25 | 19 | 2024-05-06 05:34:17+02:00 | -6 |
| 15247405 | 15247405 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:32:24.000000 | 26 | 27 | 2024-05-06 05:32:24+02:00 | 1 |
| 15247404 | 15247404 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:32:03.000000 | 28 | 24 | 2024-05-06 05:32:03+02:00 | -4 |
| 15247403 | 15247403 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:25:59.000000 | 14 | 24 | 2024-05-06 05:25:59+02:00 | 10 |
| 15247402 | 15247402 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:25:15.000000 | 23 | 31 | 2024-05-06 05:25:15+02:00 | 8 |
| 15247401 | 15247401 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:25:09.000000 | 32 | 29 | 2024-05-06 05:25:09+02:00 | -3 |
| 15247400 | 15247400 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:22:00.000000 | 8 | 23 | 2024-05-06 05:22:00+02:00 | 15 |
| 15247399 | 15247399 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:20:55.000000 | 14 | 28 | 2024-05-06 05:20:55+02:00 | 14 |
| 15247398 | 15247398 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:20:31.000000 | 26 | 25 | 2024-05-06 05:20:31+02:00 | -1 |
| 15247397 | 15247397 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:19:13.000000 | 25 | 40 | 2024-05-06 05:19:13+02:00 | 15 |
| 15247396 | 15247396 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:18:26.000000 | 28 | 27 | 2024-05-06 05:18:26+02:00 | -1 |
| 15247395 | 15247395 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:15:57.000000 | 6 | 4 | 2024-05-06 05:15:57+02:00 | -2 |
| 15247394 | 15247394 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:12:27.000000 | 10 | 25 | 2024-05-06 05:12:27+02:00 | 15 |
| 15247393 | 15247393 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:58:23.000000 | 27 | 23 | 2024-05-06 04:58:23+02:00 | -4 |
| 15247392 | 15247392 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:58:07.000000 | 28 | 26 | 2024-05-06 04:58:07+02:00 | -2 |
| 15247391 | 15247391 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:50:41.000000 | 27 | 25 | 2024-05-06 04:50:41+02:00 | -2 |
| 15247390 | 15247390 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:50:02.000000 | 32 | 27 | 2024-05-06 04:50:02+02:00 | -5 |
| 15247389 | 15247389 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:44:31.000000 | 28 | 29 | 2024-05-06 04:44:31+02:00 | 1 |
| 15247388 | 15247388 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:38:45.000000 | 26 | 22 | 2024-05-06 04:38:45+02:00 | -4 |
| 15247387 | 15247387 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:32:41.000000 | 31 | 31 | 2024-05-06 04:32:41+02:00 | 0 |
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");