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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17026732 | 17026732 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:50:12.000000 | 11 | 4 | 2024-05-06 08:50:12+02:00 | -7 |
| 17026731 | 17026731 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:49:25.000000 | 10 | 11 | 2024-05-06 08:49:25+02:00 | 1 |
| 17026730 | 17026730 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:48:22.000000 | 24 | 33 | 2024-05-06 08:48:22+02:00 | 9 |
| 17026729 | 17026729 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:44:06.000000 | 26 | 30 | 2024-05-06 08:44:06+02:00 | 4 |
| 17026728 | 17026728 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:42:19.000000 | 17 | 18 | 2024-05-06 08:42:19+02:00 | 1 |
| 17026727 | 17026727 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:39:49.000000 | 27 | 29 | 2024-05-06 08:39:49+02:00 | 2 |
| 17026726 | 17026726 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:39:19.000000 | 24 | 26 | 2024-05-06 08:39:19+02:00 | 2 |
| 17026725 | 17026725 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:26:05.000000 | 26 | 25 | 2024-05-06 08:26:05+02:00 | -1 |
| 17026724 | 17026724 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:23:58.000000 | 41 | 38 | 2024-05-06 08:23:58+02:00 | -3 |
| 17026723 | 17026723 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:14:16.000000 | 25 | 19 | 2024-05-06 08:14:16+02:00 | -6 |
| 17026722 | 17026722 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:14:04.000000 | 25 | 18 | 2024-05-06 08:14:04+02:00 | -7 |
| 17026721 | 17026721 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:12:49.000000 | 30 | 22 | 2024-05-06 08:12:49+02:00 | -8 |
| 17026720 | 17026720 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:11:30.000000 | 8 | 11 | 2024-05-06 08:11:30+02:00 | 3 |
| 17026719 | 17026719 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:06:04.000000 | 26 | 22 | 2024-05-06 08:06:04+02:00 | -4 |
| 17026718 | 17026718 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:04:36.000000 | 20 | 23 | 2024-05-06 08:04:36+02:00 | 3 |
| 17026717 | 17026717 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:57:37.000000 | 19 | 29 | 2024-05-06 07:57:37+02:00 | 10 |
| 17026716 | 17026716 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:51:22.000000 | 2 | 3 | 2024-05-06 07:51:22+02:00 | 1 |
| 17026715 | 17026715 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:49:18.000000 | 11 | 27 | 2024-05-06 07:49:18+02:00 | 16 |
| 17026714 | 17026714 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:48:04.000000 | 36 | 32 | 2024-05-06 07:48:04+02:00 | -4 |
| 17026713 | 17026713 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:46:57.000000 | 14 | 30 | 2024-05-06 07:46:57+02:00 | 16 |
| 17026712 | 17026712 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:45:19.000000 | 15 | 19 | 2024-05-06 07:45:19+02:00 | 4 |
| 17026711 | 17026711 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:44:06.000000 | 2 | 4 | 2024-05-06 07:44:06+02:00 | 2 |
| 17026710 | 17026710 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:42:01.000000 | 19 | 27 | 2024-05-06 07:42:01+02:00 | 8 |
| 17026709 | 17026709 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:39:09.000000 | 31 | 29 | 2024-05-06 07:39:09+02:00 | -2 |
| 17026708 | 17026708 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:38:17.000000 | 23 | 24 | 2024-05-06 07:38:17+02:00 | 1 |
| 17026707 | 17026707 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:36:45.000000 | 2 | 5 | 2024-05-06 07:36:45+02:00 | 3 |
| 17026706 | 17026706 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:34:31.000000 | 29 | 26 | 2024-05-06 07:34:31+02:00 | -3 |
| 17026705 | 17026705 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:34:16.000000 | 7 | 3 | 2024-05-06 07:34:16+02:00 | -4 |
| 17026704 | 17026704 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:32:57.000000 | 24 | 18 | 2024-05-06 07:32:57+02:00 | -6 |
| 17026703 | 17026703 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:30:15.000000 | 30 | 28 | 2024-05-06 07:30:15+02:00 | -2 |
| 17026702 | 17026702 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:30:05.000000 | 28 | 29 | 2024-05-06 07:30:05+02:00 | 1 |
| 17026701 | 17026701 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:29:54.000000 | 29 | 25 | 2024-05-06 07:29:54+02:00 | -4 |
| 17026700 | 17026700 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:27:06.000000 | 17 | 22 | 2024-05-06 07:27:06+02:00 | 5 |
| 17026699 | 17026699 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:24:57.000000 | 30 | 28 | 2024-05-06 07:24:57+02:00 | -2 |
| 17026698 | 17026698 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:24:37.000000 | 15 | 19 | 2024-05-06 07:24:37+02:00 | 4 |
| 17026697 | 17026697 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:20:49.000000 | 3 | 7 | 2024-05-06 07:20:49+02:00 | 4 |
| 17026696 | 17026696 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:16:27.000000 | 27 | 26 | 2024-05-06 07:16:27+02:00 | -1 |
| 17026695 | 17026695 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:16:16.000000 | 18 | 20 | 2024-05-06 07:16:16+02:00 | 2 |
| 17026694 | 17026694 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:16:07.000000 | 28 | 26 | 2024-05-06 07:16:07+02:00 | -2 |
| 17026693 | 17026693 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:13:24.000000 | 29 | 29 | 2024-05-06 07:13:24+02:00 | 0 |
| 17026692 | 17026692 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:12:59.000000 | 28 | 28 | 2024-05-06 07:12:59+02:00 | 0 |
| 17026691 | 17026691 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:11:25.000000 | 24 | 24 | 2024-05-06 07:11:25+02:00 | 0 |
| 17026690 | 17026690 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:11:04.000000 | 3 | 8 | 2024-05-06 07:11:04+02:00 | 5 |
| 17026689 | 17026689 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:09:08.000000 | 5 | 3 | 2024-05-06 07:09:08+02:00 | -2 |
| 17026688 | 17026688 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:08:06.000000 | 2 | 5 | 2024-05-06 07:08:06+02:00 | 3 |
| 17026687 | 17026687 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:06:21.000000 | 23 | 26 | 2024-05-06 07:06:21+02:00 | 3 |
| 17026686 | 17026686 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:56:52.000000 | 25 | 17 | 2024-05-06 06:56:52+02:00 | -8 |
| 17026685 | 17026685 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:54:57.000000 | 36 | 31 | 2024-05-06 06:54:57+02:00 | -5 |
| 17026684 | 17026684 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:54:12.000000 | 24 | 25 | 2024-05-06 06:54:12+02:00 | 1 |
| 17026683 | 17026683 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:54:07.000000 | 29 | 30 | 2024-05-06 06:54:07+02:00 | 1 |
| 17026682 | 17026682 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:50:02.000000 | 23 | 24 | 2024-05-06 06:50:02+02:00 | 1 |
| 17026681 | 17026681 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:49:57.000000 | 31 | 25 | 2024-05-06 06:49:57+02:00 | -6 |
| 17026680 | 17026680 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:49:16.000000 | 10 | 20 | 2024-05-06 06:49:16+02:00 | 10 |
| 17026679 | 17026679 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:48:23.000000 | 9 | 4 | 2024-05-06 06:48:23+02:00 | -5 |
| 17026678 | 17026678 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:45:31.000000 | 29 | 20 | 2024-05-06 06:45:31+02:00 | -9 |
| 17026677 | 17026677 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:41:27.000000 | 24 | 29 | 2024-05-06 06:41:27+02:00 | 5 |
| 17026676 | 17026676 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:35:14.000000 | 25 | 27 | 2024-05-06 06:35:14+02:00 | 2 |
| 17026675 | 17026675 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:33:56.000000 | 36 | 39 | 2024-05-06 06:33:56+02:00 | 3 |
| 17026674 | 17026674 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:31:44.000000 | 29 | 32 | 2024-05-06 06:31:44+02:00 | 3 |
| 17026673 | 17026673 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:27:12.000000 | 26 | 27 | 2024-05-06 06:27:12+02:00 | 1 |
| 17026672 | 17026672 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:27:01.000000 | 27 | 25 | 2024-05-06 06:27:01+02:00 | -2 |
| 17026671 | 17026671 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:26:32.000000 | 24 | 40 | 2024-05-06 06:26:32+02:00 | 16 |
| 17026670 | 17026670 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:23:44.000000 | 31 | 34 | 2024-05-06 06:23:44+02:00 | 3 |
| 17026669 | 17026669 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:22:19.000000 | 24 | 22 | 2024-05-06 06:22:19+02:00 | -2 |
| 17026668 | 17026668 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:18:23.000000 | 16 | 24 | 2024-05-06 06:18:23+02:00 | 8 |
| 17026667 | 17026667 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:17:45.000000 | 18 | 17 | 2024-05-06 06:17:45+02:00 | -1 |
| 17026666 | 17026666 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:17:16.000000 | 26 | 22 | 2024-05-06 06:17:16+02:00 | -4 |
| 17026665 | 17026665 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:11:20.000000 | 20 | 27 | 2024-05-06 06:11:20+02:00 | 7 |
| 17026664 | 17026664 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:05:50.000000 | 30 | 34 | 2024-05-06 06:05:50+02:00 | 4 |
| 17026663 | 17026663 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:04:22.000000 | 23 | 30 | 2024-05-06 06:04:22+02:00 | 7 |
| 17026662 | 17026662 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:02:56.000000 | 24 | 20 | 2024-05-06 06:02:56+02:00 | -4 |
| 17026661 | 17026661 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:00:56.000000 | 25 | 17 | 2024-05-06 06:00:56+02:00 | -8 |
| 17026660 | 17026660 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:58:58.000000 | 30 | 27 | 2024-05-06 05:58:58+02:00 | -3 |
| 17026659 | 17026659 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:56:30.000000 | 19 | 17 | 2024-05-06 05:56:30+02:00 | -2 |
| 17026658 | 17026658 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:55:43.000000 | 8 | 23 | 2024-05-06 05:55:43+02:00 | 15 |
| 17026657 | 17026657 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:55:18.000000 | 28 | 25 | 2024-05-06 05:55:18+02:00 | -3 |
| 17026656 | 17026656 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:52:14.000000 | 26 | 23 | 2024-05-06 05:52:14+02:00 | -3 |
| 17026655 | 17026655 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:48:46.000000 | 20 | 23 | 2024-05-06 05:48:46+02:00 | 3 |
| 17026654 | 17026654 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:36:46.000000 | 33 | 31 | 2024-05-06 05:36:46+02:00 | -2 |
| 17026653 | 17026653 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:35:15.000000 | 18 | 24 | 2024-05-06 05:35:15+02:00 | 6 |
| 17026652 | 17026652 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:34:17.000000 | 25 | 19 | 2024-05-06 05:34:17+02:00 | -6 |
| 17026651 | 17026651 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:32:24.000000 | 26 | 27 | 2024-05-06 05:32:24+02:00 | 1 |
| 17026650 | 17026650 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:32:03.000000 | 28 | 24 | 2024-05-06 05:32:03+02:00 | -4 |
| 17026649 | 17026649 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:25:59.000000 | 14 | 24 | 2024-05-06 05:25:59+02:00 | 10 |
| 17026648 | 17026648 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:25:15.000000 | 23 | 31 | 2024-05-06 05:25:15+02:00 | 8 |
| 17026647 | 17026647 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:25:09.000000 | 32 | 29 | 2024-05-06 05:25:09+02:00 | -3 |
| 17026646 | 17026646 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:22:00.000000 | 8 | 23 | 2024-05-06 05:22:00+02:00 | 15 |
| 17026645 | 17026645 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:20:55.000000 | 14 | 28 | 2024-05-06 05:20:55+02:00 | 14 |
| 17026644 | 17026644 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:20:31.000000 | 26 | 25 | 2024-05-06 05:20:31+02:00 | -1 |
| 17026643 | 17026643 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:19:13.000000 | 25 | 40 | 2024-05-06 05:19:13+02:00 | 15 |
| 17026642 | 17026642 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:18:26.000000 | 28 | 27 | 2024-05-06 05:18:26+02:00 | -1 |
| 17026641 | 17026641 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:15:57.000000 | 6 | 4 | 2024-05-06 05:15:57+02:00 | -2 |
| 17026640 | 17026640 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:12:27.000000 | 10 | 25 | 2024-05-06 05:12:27+02:00 | 15 |
| 17026639 | 17026639 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:58:23.000000 | 27 | 23 | 2024-05-06 04:58:23+02:00 | -4 |
| 17026638 | 17026638 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:58:07.000000 | 28 | 26 | 2024-05-06 04:58:07+02:00 | -2 |
| 17026637 | 17026637 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:50:41.000000 | 27 | 25 | 2024-05-06 04:50:41+02:00 | -2 |
| 17026636 | 17026636 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:50:02.000000 | 32 | 27 | 2024-05-06 04:50:02+02:00 | -5 |
| 17026635 | 17026635 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:44:31.000000 | 28 | 29 | 2024-05-06 04:44:31+02:00 | 1 |
| 17026634 | 17026634 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:38:45.000000 | 26 | 22 | 2024-05-06 04:38:45+02:00 | -4 |
| 17026633 | 17026633 | 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");