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 = "5-59" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
8480546 | 8480546 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:42:14.000000 | 15 | 23 | 2025-03-20 13:42:14+01:00 | 8 |
8480545 | 8480545 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:34:18.000000 | 27 | 23 | 2025-03-20 13:34:18+01:00 | -4 |
8480544 | 8480544 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:34:05.000000 | 29 | 29 | 2025-03-20 13:34:05+01:00 | 0 |
8480543 | 8480543 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:32:55.000000 | 29 | 24 | 2025-03-20 13:32:55+01:00 | -5 |
8480542 | 8480542 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:31:52.000000 | 23 | 27 | 2025-03-20 13:31:52+01:00 | 4 |
8480541 | 8480541 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:31:15.000000 | 23 | 22 | 2025-03-20 13:31:15+01:00 | -1 |
8480540 | 8480540 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:30:14.000000 | 20 | 25 | 2025-03-20 13:30:14+01:00 | 5 |
8480539 | 8480539 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:29:04.000000 | 24 | 22 | 2025-03-20 13:29:04+01:00 | -2 |
8480538 | 8480538 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:28:12.000000 | 23 | 26 | 2025-03-20 13:28:12+01:00 | 3 |
8480537 | 8480537 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:27:35.000000 | 12 | 20 | 2025-03-20 13:27:35+01:00 | 8 |
8480536 | 8480536 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:23:37.000000 | 10 | 29 | 2025-03-20 13:23:37+01:00 | 19 |
8480535 | 8480535 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:22:14.000000 | 20 | 20 | 2025-03-20 13:22:14+01:00 | 0 |
8480534 | 8480534 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:21:33.000000 | 11 | 17 | 2025-03-20 13:21:33+01:00 | 6 |
8480533 | 8480533 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:19:46.000000 | 18 | 13 | 2025-03-20 13:19:46+01:00 | -5 |
8480532 | 8480532 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:19:19.000000 | 17 | 16 | 2025-03-20 13:19:19+01:00 | -1 |
8480531 | 8480531 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:18:05.000000 | 18 | 22 | 2025-03-20 13:18:05+01:00 | 4 |
8480530 | 8480530 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:16:49.000000 | 13 | 15 | 2025-03-20 13:16:49+01:00 | 2 |
8480529 | 8480529 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:10:43.000000 | 16 | 26 | 2025-03-20 13:10:43+01:00 | 10 |
8480528 | 8480528 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:10:37.000000 | 27 | 27 | 2025-03-20 13:10:37+01:00 | 0 |
8480527 | 8480527 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:09:09.000000 | 20 | 26 | 2025-03-20 13:09:09+01:00 | 6 |
8480526 | 8480526 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:08:40.000000 | 17 | 27 | 2025-03-20 13:08:40+01:00 | 10 |
8480525 | 8480525 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:06:44.000000 | 18 | 23 | 2025-03-20 13:06:44+01:00 | 5 |
8480524 | 8480524 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:06:24.000000 | 24 | 27 | 2025-03-20 13:06:24+01:00 | 3 |
8480523 | 8480523 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:05:50.000000 | 11 | 14 | 2025-03-20 13:05:50+01:00 | 3 |
8480522 | 8480522 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:03:30.000000 | 19 | 19 | 2025-03-20 13:03:30+01:00 | 0 |
8480521 | 8480521 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 13:02:23.000000 | 17 | 13 | 2025-03-20 13:02:23+01:00 | -4 |
8480520 | 8480520 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:59:55.000000 | 25 | 20 | 2025-03-20 12:59:55+01:00 | -5 |
8480519 | 8480519 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:56:24.000000 | 20 | 19 | 2025-03-20 12:56:24+01:00 | -1 |
8480518 | 8480518 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:53:50.000000 | 24 | 30 | 2025-03-20 12:53:50+01:00 | 6 |
8480517 | 8480517 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:52:25.000000 | 26 | 23 | 2025-03-20 12:52:25+01:00 | -3 |
8480516 | 8480516 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:52:14.000000 | 24 | 25 | 2025-03-20 12:52:14+01:00 | 1 |
8480515 | 8480515 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:49:27.000000 | 24 | 25 | 2025-03-20 12:49:27+01:00 | 1 |
8480514 | 8480514 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:47:26.000000 | 19 | 26 | 2025-03-20 12:47:26+01:00 | 7 |
8480513 | 8480513 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:46:18.000000 | 26 | 23 | 2025-03-20 12:46:18+01:00 | -3 |
8480512 | 8480512 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:43:48.000000 | 16 | 14 | 2025-03-20 12:43:48+01:00 | -2 |
8480511 | 8480511 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:43:27.000000 | 23 | 18 | 2025-03-20 12:43:27+01:00 | -5 |
8480510 | 8480510 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:42:21.000000 | 13 | 22 | 2025-03-20 12:42:21+01:00 | 9 |
8480509 | 8480509 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:41:58.000000 | 29 | 26 | 2025-03-20 12:41:58+01:00 | -3 |
8480508 | 8480508 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:39:20.000000 | 14 | 28 | 2025-03-20 12:39:20+01:00 | 14 |
8480507 | 8480507 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:38:56.000000 | 20 | 30 | 2025-03-20 12:38:56+01:00 | 10 |
8480506 | 8480506 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:36:17.000000 | 28 | 22 | 2025-03-20 12:36:17+01:00 | -6 |
8480505 | 8480505 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:36:07.000000 | 19 | 22 | 2025-03-20 12:36:07+01:00 | 3 |
8480504 | 8480504 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:34:33.000000 | 31 | 35 | 2025-03-20 12:34:33+01:00 | 4 |
8480503 | 8480503 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:30:39.000000 | 20 | 26 | 2025-03-20 12:30:39+01:00 | 6 |
8480502 | 8480502 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:30:11.000000 | 28 | 15 | 2025-03-20 12:30:11+01:00 | -13 |
8480501 | 8480501 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:23:58.000000 | 24 | 26 | 2025-03-20 12:23:58+01:00 | 2 |
8480500 | 8480500 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:23:48.000000 | 18 | 26 | 2025-03-20 12:23:48+01:00 | 8 |
8480499 | 8480499 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:22:35.000000 | 17 | 23 | 2025-03-20 12:22:35+01:00 | 6 |
8480498 | 8480498 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:20:18.000000 | 20 | 20 | 2025-03-20 12:20:18+01:00 | 0 |
8480497 | 8480497 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:19:07.000000 | 27 | 23 | 2025-03-20 12:19:07+01:00 | -4 |
8480496 | 8480496 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:18:53.000000 | 17 | 29 | 2025-03-20 12:18:53+01:00 | 12 |
8480495 | 8480495 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:18:28.000000 | 17 | 8 | 2025-03-20 12:18:28+01:00 | -9 |
8480494 | 8480494 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:18:04.000000 | 23 | 23 | 2025-03-20 12:18:04+01:00 | 0 |
8480493 | 8480493 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:16:01.000000 | 25 | 25 | 2025-03-20 12:16:01+01:00 | 0 |
8480492 | 8480492 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:15:36.000000 | 30 | 24 | 2025-03-20 12:15:36+01:00 | -6 |
8480491 | 8480491 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:15:06.000000 | 33 | 29 | 2025-03-20 12:15:06+01:00 | -4 |
8480490 | 8480490 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:12:02.000000 | 23 | 12 | 2025-03-20 12:12:02+01:00 | -11 |
8480489 | 8480489 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:09:06.000000 | 18 | 24 | 2025-03-20 12:09:06+01:00 | 6 |
8480488 | 8480488 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:07:13.000000 | 23 | 29 | 2025-03-20 12:07:13+01:00 | 6 |
8480487 | 8480487 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:07:12.000000 | 24 | 30 | 2025-03-20 12:07:12+01:00 | 6 |
8480486 | 8480486 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:05:34.000000 | 25 | 25 | 2025-03-20 12:05:34+01:00 | 0 |
8480485 | 8480485 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:04:55.000000 | 17 | 24 | 2025-03-20 12:04:55+01:00 | 7 |
8480484 | 8480484 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:04:43.000000 | 25 | 27 | 2025-03-20 12:04:43+01:00 | 2 |
8480483 | 8480483 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:04:01.000000 | 19 | 26 | 2025-03-20 12:04:01+01:00 | 7 |
8480482 | 8480482 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:03:00.000000 | 17 | 27 | 2025-03-20 12:03:00+01:00 | 10 |
8480481 | 8480481 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:02:53.000000 | 30 | 25 | 2025-03-20 12:02:53+01:00 | -5 |
8480480 | 8480480 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:02:27.000000 | 30 | 30 | 2025-03-20 12:02:27+01:00 | 0 |
8480479 | 8480479 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:01:36.000000 | 16 | 20 | 2025-03-20 12:01:36+01:00 | 4 |
8480478 | 8480478 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 12:00:08.000000 | 20 | 24 | 2025-03-20 12:00:08+01:00 | 4 |
8480477 | 8480477 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:57:43.000000 | 10 | 29 | 2025-03-20 11:57:43+01:00 | 19 |
8480476 | 8480476 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:56:35.000000 | 26 | 17 | 2025-03-20 11:56:35+01:00 | -9 |
8480475 | 8480475 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:55:33.000000 | 27 | 26 | 2025-03-20 11:55:33+01:00 | -1 |
8480474 | 8480474 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:54:22.000000 | 25 | 24 | 2025-03-20 11:54:22+01:00 | -1 |
8480473 | 8480473 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:53:51.000000 | 15 | 19 | 2025-03-20 11:53:51+01:00 | 4 |
8480472 | 8480472 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:52:31.000000 | 20 | 29 | 2025-03-20 11:52:31+01:00 | 9 |
8480471 | 8480471 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:51:52.000000 | 26 | 24 | 2025-03-20 11:51:52+01:00 | -2 |
8480470 | 8480470 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:51:17.000000 | 37 | 37 | 2025-03-20 11:51:17+01:00 | 0 |
8480469 | 8480469 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:47:57.000000 | 25 | 26 | 2025-03-20 11:47:57+01:00 | 1 |
8480468 | 8480468 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:47:27.000000 | 20 | 29 | 2025-03-20 11:47:27+01:00 | 9 |
8480467 | 8480467 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:46:15.000000 | 17 | 28 | 2025-03-20 11:46:15+01:00 | 11 |
8480466 | 8480466 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:41:38.000000 | 19 | 22 | 2025-03-20 11:41:38+01:00 | 3 |
8480465 | 8480465 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:36:44.000000 | 18 | 27 | 2025-03-20 11:36:44+01:00 | 9 |
8480464 | 8480464 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:34:01.000000 | 24 | 22 | 2025-03-20 11:34:01+01:00 | -2 |
8480463 | 8480463 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:33:46.000000 | 32 | 31 | 2025-03-20 11:33:46+01:00 | -1 |
8480462 | 8480462 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:33:18.000000 | 25 | 25 | 2025-03-20 11:33:18+01:00 | 0 |
8480461 | 8480461 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:31:48.000000 | 14 | 24 | 2025-03-20 11:31:48+01:00 | 10 |
8480460 | 8480460 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:30:29.000000 | 25 | 25 | 2025-03-20 11:30:29+01:00 | 0 |
8480459 | 8480459 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:26:56.000000 | 27 | 26 | 2025-03-20 11:26:56+01:00 | -1 |
8480458 | 8480458 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:21:15.000000 | 31 | 26 | 2025-03-20 11:21:15+01:00 | -5 |
8480457 | 8480457 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:19:42.000000 | 27 | 15 | 2025-03-20 11:19:42+01:00 | -12 |
8480456 | 8480456 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:18:59.000000 | 25 | 30 | 2025-03-20 11:18:59+01:00 | 5 |
8480455 | 8480455 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:18:47.000000 | 23 | 23 | 2025-03-20 11:18:47+01:00 | 0 |
8480454 | 8480454 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:17:35.000000 | 17 | 25 | 2025-03-20 11:17:35+01:00 | 8 |
8480453 | 8480453 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:16:21.000000 | 12 | 18 | 2025-03-20 11:16:21+01:00 | 6 |
8480452 | 8480452 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:15:46.000000 | 24 | 17 | 2025-03-20 11:15:46+01:00 | -7 |
8480451 | 8480451 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:10:08.000000 | 17 | 20 | 2025-03-20 11:10:08+01:00 | 3 |
8480450 | 8480450 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:09:21.000000 | 12 | 30 | 2025-03-20 11:09:21+01:00 | 18 |
8480449 | 8480449 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:08:50.000000 | 12 | 18 | 2025-03-20 11:08:50+01:00 | 6 |
8480448 | 8480448 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:01:30.000000 | 18 | 24 | 2025-03-20 11:01:30+01:00 | 6 |
8480447 | 8480447 | Birsigstrasse 5-59 | 59 | 5 | Nachmessung | 2025-03-20 | 11:01:04.000000 | 25 | 30 | 2025-03-20 11:01:04+01:00 | 5 |
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");