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 sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Messung_Datum (date), Messung_Timestamp (date)
id_standort >30
- 11.0 1,344,787
- 15.0 1,142,009
- 9.0 822,024
- 51.0 818,715
- 47.0 813,338
- 7.0 769,748
- 42.0 736,309
- 19.0 712,938
- 54.0 704,276
- 43.0 631,358
- 17.0 569,973
- 46.0 489,220
- 1.0 482,979
- 36.0 477,260
- 4.0 425,699
- 117.0 352,645
- 58.0 325,259
- 34.0 316,829
- 12.0 313,436
- 37.0 289,960
- 60.0 284,816
- 29.0 280,087
- 116.0 278,273
- 104.0 270,469
- 41.0 266,316
- 18.0 245,202
- 23.0 221,126
- 101.0 210,287
- 2.0 207,984
- 50.0 179,533
- …
Phase 4
- Betrieb 10,160,079
- Nachmessung 4,251,688
- Vormessung 3,088,678
- Nach Ende 17,969
| Link | rowid | id_standort | Zyklus | Phase | Messung_Datum | Messung_Zeit | V_Einfahrt | V_Ausfahrt | Messung_Timestamp ▲ | V_Delta |
|---|---|---|---|---|---|---|---|---|---|---|
| 8480546 | 8480546 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:42:14.000000 | 15 | 23 | 2025-03-20 13:42:14+01:00 | 8 |
| 8480545 | 8480545 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:34:18.000000 | 27 | 23 | 2025-03-20 13:34:18+01:00 | -4 |
| 8480544 | 8480544 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:34:05.000000 | 29 | 29 | 2025-03-20 13:34:05+01:00 | 0 |
| 8480543 | 8480543 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:32:55.000000 | 29 | 24 | 2025-03-20 13:32:55+01:00 | -5 |
| 8480542 | 8480542 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:31:52.000000 | 23 | 27 | 2025-03-20 13:31:52+01:00 | 4 |
| 8480541 | 8480541 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:31:15.000000 | 23 | 22 | 2025-03-20 13:31:15+01:00 | -1 |
| 8480540 | 8480540 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:30:14.000000 | 20 | 25 | 2025-03-20 13:30:14+01:00 | 5 |
| 8480539 | 8480539 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:29:04.000000 | 24 | 22 | 2025-03-20 13:29:04+01:00 | -2 |
| 8480538 | 8480538 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:28:12.000000 | 23 | 26 | 2025-03-20 13:28:12+01:00 | 3 |
| 8480537 | 8480537 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:27:35.000000 | 12 | 20 | 2025-03-20 13:27:35+01:00 | 8 |
| 8480536 | 8480536 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:23:37.000000 | 10 | 29 | 2025-03-20 13:23:37+01:00 | 19 |
| 8480535 | 8480535 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:22:14.000000 | 20 | 20 | 2025-03-20 13:22:14+01:00 | 0 |
| 8480534 | 8480534 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:21:33.000000 | 11 | 17 | 2025-03-20 13:21:33+01:00 | 6 |
| 8480533 | 8480533 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:19:46.000000 | 18 | 13 | 2025-03-20 13:19:46+01:00 | -5 |
| 8480532 | 8480532 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:19:19.000000 | 17 | 16 | 2025-03-20 13:19:19+01:00 | -1 |
| 8480531 | 8480531 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:18:05.000000 | 18 | 22 | 2025-03-20 13:18:05+01:00 | 4 |
| 8480530 | 8480530 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:16:49.000000 | 13 | 15 | 2025-03-20 13:16:49+01:00 | 2 |
| 8480529 | 8480529 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:10:43.000000 | 16 | 26 | 2025-03-20 13:10:43+01:00 | 10 |
| 8480528 | 8480528 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:10:37.000000 | 27 | 27 | 2025-03-20 13:10:37+01:00 | 0 |
| 8480527 | 8480527 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:09:09.000000 | 20 | 26 | 2025-03-20 13:09:09+01:00 | 6 |
| 8480526 | 8480526 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:08:40.000000 | 17 | 27 | 2025-03-20 13:08:40+01:00 | 10 |
| 8480525 | 8480525 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:06:44.000000 | 18 | 23 | 2025-03-20 13:06:44+01:00 | 5 |
| 8480524 | 8480524 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:06:24.000000 | 24 | 27 | 2025-03-20 13:06:24+01:00 | 3 |
| 8480523 | 8480523 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:05:50.000000 | 11 | 14 | 2025-03-20 13:05:50+01:00 | 3 |
| 8480522 | 8480522 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:03:30.000000 | 19 | 19 | 2025-03-20 13:03:30+01:00 | 0 |
| 8480521 | 8480521 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 13:02:23.000000 | 17 | 13 | 2025-03-20 13:02:23+01:00 | -4 |
| 8480520 | 8480520 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:59:55.000000 | 25 | 20 | 2025-03-20 12:59:55+01:00 | -5 |
| 8480519 | 8480519 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:56:24.000000 | 20 | 19 | 2025-03-20 12:56:24+01:00 | -1 |
| 8480518 | 8480518 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:53:50.000000 | 24 | 30 | 2025-03-20 12:53:50+01:00 | 6 |
| 8480517 | 8480517 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:52:25.000000 | 26 | 23 | 2025-03-20 12:52:25+01:00 | -3 |
| 8480516 | 8480516 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:52:14.000000 | 24 | 25 | 2025-03-20 12:52:14+01:00 | 1 |
| 8480515 | 8480515 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:49:27.000000 | 24 | 25 | 2025-03-20 12:49:27+01:00 | 1 |
| 8480514 | 8480514 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:47:26.000000 | 19 | 26 | 2025-03-20 12:47:26+01:00 | 7 |
| 8480513 | 8480513 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:46:18.000000 | 26 | 23 | 2025-03-20 12:46:18+01:00 | -3 |
| 8480512 | 8480512 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:43:48.000000 | 16 | 14 | 2025-03-20 12:43:48+01:00 | -2 |
| 8480511 | 8480511 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:43:27.000000 | 23 | 18 | 2025-03-20 12:43:27+01:00 | -5 |
| 8480510 | 8480510 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:42:21.000000 | 13 | 22 | 2025-03-20 12:42:21+01:00 | 9 |
| 8480509 | 8480509 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:41:58.000000 | 29 | 26 | 2025-03-20 12:41:58+01:00 | -3 |
| 8480508 | 8480508 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:39:20.000000 | 14 | 28 | 2025-03-20 12:39:20+01:00 | 14 |
| 8480507 | 8480507 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:38:56.000000 | 20 | 30 | 2025-03-20 12:38:56+01:00 | 10 |
| 8480506 | 8480506 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:36:17.000000 | 28 | 22 | 2025-03-20 12:36:17+01:00 | -6 |
| 8480505 | 8480505 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:36:07.000000 | 19 | 22 | 2025-03-20 12:36:07+01:00 | 3 |
| 8480504 | 8480504 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:34:33.000000 | 31 | 35 | 2025-03-20 12:34:33+01:00 | 4 |
| 8480503 | 8480503 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:30:39.000000 | 20 | 26 | 2025-03-20 12:30:39+01:00 | 6 |
| 8480502 | 8480502 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:30:11.000000 | 28 | 15 | 2025-03-20 12:30:11+01:00 | -13 |
| 8480501 | 8480501 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:23:58.000000 | 24 | 26 | 2025-03-20 12:23:58+01:00 | 2 |
| 8480500 | 8480500 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:23:48.000000 | 18 | 26 | 2025-03-20 12:23:48+01:00 | 8 |
| 8480499 | 8480499 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:22:35.000000 | 17 | 23 | 2025-03-20 12:22:35+01:00 | 6 |
| 8480498 | 8480498 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:20:18.000000 | 20 | 20 | 2025-03-20 12:20:18+01:00 | 0 |
| 8480497 | 8480497 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:19:07.000000 | 27 | 23 | 2025-03-20 12:19:07+01:00 | -4 |
| 8480496 | 8480496 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:18:53.000000 | 17 | 29 | 2025-03-20 12:18:53+01:00 | 12 |
| 8480495 | 8480495 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:18:28.000000 | 17 | 8 | 2025-03-20 12:18:28+01:00 | -9 |
| 8480494 | 8480494 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:18:04.000000 | 23 | 23 | 2025-03-20 12:18:04+01:00 | 0 |
| 8480493 | 8480493 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:16:01.000000 | 25 | 25 | 2025-03-20 12:16:01+01:00 | 0 |
| 8480492 | 8480492 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:15:36.000000 | 30 | 24 | 2025-03-20 12:15:36+01:00 | -6 |
| 8480491 | 8480491 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:15:06.000000 | 33 | 29 | 2025-03-20 12:15:06+01:00 | -4 |
| 8480490 | 8480490 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:12:02.000000 | 23 | 12 | 2025-03-20 12:12:02+01:00 | -11 |
| 8480489 | 8480489 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:09:06.000000 | 18 | 24 | 2025-03-20 12:09:06+01:00 | 6 |
| 8480488 | 8480488 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:07:13.000000 | 23 | 29 | 2025-03-20 12:07:13+01:00 | 6 |
| 8480487 | 8480487 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:07:12.000000 | 24 | 30 | 2025-03-20 12:07:12+01:00 | 6 |
| 8480486 | 8480486 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:05:34.000000 | 25 | 25 | 2025-03-20 12:05:34+01:00 | 0 |
| 8480485 | 8480485 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:04:55.000000 | 17 | 24 | 2025-03-20 12:04:55+01:00 | 7 |
| 8480484 | 8480484 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:04:43.000000 | 25 | 27 | 2025-03-20 12:04:43+01:00 | 2 |
| 8480483 | 8480483 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:04:01.000000 | 19 | 26 | 2025-03-20 12:04:01+01:00 | 7 |
| 8480482 | 8480482 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:03:00.000000 | 17 | 27 | 2025-03-20 12:03:00+01:00 | 10 |
| 8480481 | 8480481 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:02:53.000000 | 30 | 25 | 2025-03-20 12:02:53+01:00 | -5 |
| 8480480 | 8480480 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:02:27.000000 | 30 | 30 | 2025-03-20 12:02:27+01:00 | 0 |
| 8480479 | 8480479 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:01:36.000000 | 16 | 20 | 2025-03-20 12:01:36+01:00 | 4 |
| 8480478 | 8480478 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 12:00:08.000000 | 20 | 24 | 2025-03-20 12:00:08+01:00 | 4 |
| 8480477 | 8480477 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:57:43.000000 | 10 | 29 | 2025-03-20 11:57:43+01:00 | 19 |
| 8480476 | 8480476 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:56:35.000000 | 26 | 17 | 2025-03-20 11:56:35+01:00 | -9 |
| 8480475 | 8480475 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:55:33.000000 | 27 | 26 | 2025-03-20 11:55:33+01:00 | -1 |
| 8480474 | 8480474 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:54:22.000000 | 25 | 24 | 2025-03-20 11:54:22+01:00 | -1 |
| 8480473 | 8480473 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:53:51.000000 | 15 | 19 | 2025-03-20 11:53:51+01:00 | 4 |
| 8480472 | 8480472 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:52:31.000000 | 20 | 29 | 2025-03-20 11:52:31+01:00 | 9 |
| 8480471 | 8480471 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:51:52.000000 | 26 | 24 | 2025-03-20 11:51:52+01:00 | -2 |
| 8480470 | 8480470 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:51:17.000000 | 37 | 37 | 2025-03-20 11:51:17+01:00 | 0 |
| 8480469 | 8480469 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:47:57.000000 | 25 | 26 | 2025-03-20 11:47:57+01:00 | 1 |
| 8480468 | 8480468 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:47:27.000000 | 20 | 29 | 2025-03-20 11:47:27+01:00 | 9 |
| 8480467 | 8480467 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:46:15.000000 | 17 | 28 | 2025-03-20 11:46:15+01:00 | 11 |
| 8480466 | 8480466 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:41:38.000000 | 19 | 22 | 2025-03-20 11:41:38+01:00 | 3 |
| 4091133 | 4091133 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:38:23.000000 | 14 | 22 | 2025-03-20 11:38:23+01:00 | 8 |
| 8480465 | 8480465 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:36:44.000000 | 18 | 27 | 2025-03-20 11:36:44+01:00 | 9 |
| 4091132 | 4091132 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:36:25.000000 | 32 | 30 | 2025-03-20 11:36:25+01:00 | -2 |
| 4091131 | 4091131 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:36:15.000000 | 24 | 30 | 2025-03-20 11:36:15+01:00 | 6 |
| 4091130 | 4091130 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:34:57.000000 | 12 | 17 | 2025-03-20 11:34:57+01:00 | 5 |
| 8480464 | 8480464 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:34:01.000000 | 24 | 22 | 2025-03-20 11:34:01+01:00 | -2 |
| 8480463 | 8480463 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:33:46.000000 | 32 | 31 | 2025-03-20 11:33:46+01:00 | -1 |
| 8480462 | 8480462 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:33:18.000000 | 25 | 25 | 2025-03-20 11:33:18+01:00 | 0 |
| 4091129 | 4091129 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:33:08.000000 | 35 | 36 | 2025-03-20 11:33:08+01:00 | 1 |
| 8480461 | 8480461 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:31:48.000000 | 14 | 24 | 2025-03-20 11:31:48+01:00 | 10 |
| 8480460 | 8480460 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:30:29.000000 | 25 | 25 | 2025-03-20 11:30:29+01:00 | 0 |
| 4091128 | 4091128 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:30:20.000000 | 23 | 27 | 2025-03-20 11:30:20+01:00 | 4 |
| 4091127 | 4091127 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:30:07.000000 | 23 | 22 | 2025-03-20 11:30:07+01:00 | -1 |
| 8480459 | 8480459 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:26:56.000000 | 27 | 26 | 2025-03-20 11:26:56+01:00 | -1 |
| 4091126 | 4091126 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:26:21.000000 | 27 | 20 | 2025-03-20 11:26:21+01:00 | -7 |
| 4091125 | 4091125 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:26:02.000000 | 2 | 13 | 2025-03-20 11:26:02+01:00 | 11 |
| 4091124 | 4091124 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:21:16.000000 | 4 | 7 | 2025-03-20 11:21:16+01:00 | 3 |
| 8480458 | 8480458 | 59.0 | 5.0 | Nachmessung | 2025-03-20 | 11:21:15.000000 | 31 | 26 | 2025-03-20 11:21:15+01:00 | -5 |
| 4091123 | 4091123 | 49.0 | 5.0 | Nachmessung | 2025-03-20 | 11:20:45.000000 | 3 | 3 | 2025-03-20 11:20:45+01:00 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "Einzelmessungen" (
"id_standort" REAL,
"Zyklus" REAL,
"Phase" TEXT,
"Messung_Datum" DATE,
"Messung_Zeit" TIME,
"V_Einfahrt" INTEGER,
"V_Ausfahrt" INTEGER,
"Messung_Timestamp" TIMESTAMP,
"V_Delta" INTEGER
);
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");