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 = "4-7" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 18662874 | 18662874 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:47:15.000000 | 38 | 39 | 2024-10-17 07:47:15+02:00 | 1 |
| 18662873 | 18662873 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:47:12.000000 | 48 | 40 | 2024-10-17 07:47:12+02:00 | -8 |
| 18662872 | 18662872 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:47:07.000000 | 35 | 26 | 2024-10-17 07:47:07+02:00 | -9 |
| 18662871 | 18662871 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:46:59.000000 | 38 | 34 | 2024-10-17 07:46:59+02:00 | -4 |
| 18662870 | 18662870 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:46:54.000000 | 36 | 25 | 2024-10-17 07:46:54+02:00 | -11 |
| 18662869 | 18662869 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:46:45.000000 | 46 | 41 | 2024-10-17 07:46:45+02:00 | -5 |
| 18662868 | 18662868 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:46:13.000000 | 27 | 12 | 2024-10-17 07:46:13+02:00 | -15 |
| 18662867 | 18662867 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:46:02.000000 | 35 | 26 | 2024-10-17 07:46:02+02:00 | -9 |
| 18662866 | 18662866 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:45:54.000000 | 52 | 36 | 2024-10-17 07:45:54+02:00 | -16 |
| 18662865 | 18662865 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:44:48.000000 | 46 | 31 | 2024-10-17 07:44:48+02:00 | -15 |
| 18662864 | 18662864 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:44:42.000000 | 48 | 44 | 2024-10-17 07:44:42+02:00 | -4 |
| 18662863 | 18662863 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:43:20.000000 | 26 | 24 | 2024-10-17 07:43:20+02:00 | -2 |
| 18662862 | 18662862 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:43:15.000000 | 37 | 28 | 2024-10-17 07:43:15+02:00 | -9 |
| 18662861 | 18662861 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:42:08.000000 | 31 | 24 | 2024-10-17 07:42:08+02:00 | -7 |
| 18662860 | 18662860 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:58.000000 | 36 | 30 | 2024-10-17 07:41:58+02:00 | -6 |
| 18662859 | 18662859 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:53.000000 | 16 | 22 | 2024-10-17 07:41:53+02:00 | 6 |
| 18662858 | 18662858 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:37.000000 | 28 | 27 | 2024-10-17 07:41:37+02:00 | -1 |
| 18662857 | 18662857 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:28.000000 | 35 | 31 | 2024-10-17 07:41:28+02:00 | -4 |
| 18662856 | 18662856 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:25.000000 | 41 | 31 | 2024-10-17 07:41:25+02:00 | -10 |
| 18662855 | 18662855 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:41:15.000000 | 47 | 40 | 2024-10-17 07:41:15+02:00 | -7 |
| 18662854 | 18662854 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:40:29.000000 | 32 | 31 | 2024-10-17 07:40:29+02:00 | -1 |
| 18662853 | 18662853 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:40:17.000000 | 43 | 32 | 2024-10-17 07:40:17+02:00 | -11 |
| 18662852 | 18662852 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:40:13.000000 | 28 | 30 | 2024-10-17 07:40:13+02:00 | 2 |
| 18662851 | 18662851 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:58.000000 | 46 | 36 | 2024-10-17 07:39:58+02:00 | -10 |
| 18662850 | 18662850 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:51.000000 | 53 | 46 | 2024-10-17 07:39:51+02:00 | -7 |
| 18662849 | 18662849 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:49.000000 | 30 | 22 | 2024-10-17 07:39:49+02:00 | -8 |
| 18662848 | 18662848 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:39.000000 | 34 | 30 | 2024-10-17 07:39:39+02:00 | -4 |
| 18662847 | 18662847 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:24.000000 | 36 | 27 | 2024-10-17 07:39:24+02:00 | -9 |
| 18662846 | 18662846 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:16.000000 | 41 | 36 | 2024-10-17 07:39:16+02:00 | -5 |
| 18662845 | 18662845 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:39:06.000000 | 38 | 24 | 2024-10-17 07:39:06+02:00 | -14 |
| 18662844 | 18662844 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:38:42.000000 | 31 | 19 | 2024-10-17 07:38:42+02:00 | -12 |
| 18662843 | 18662843 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:38:32.000000 | 37 | 29 | 2024-10-17 07:38:32+02:00 | -8 |
| 18662842 | 18662842 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:37:43.000000 | 29 | 24 | 2024-10-17 07:37:43+02:00 | -5 |
| 18662841 | 18662841 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:37:13.000000 | 34 | 26 | 2024-10-17 07:37:13+02:00 | -8 |
| 18662840 | 18662840 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:37:04.000000 | 48 | 34 | 2024-10-17 07:37:04+02:00 | -14 |
| 18662839 | 18662839 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:36:32.000000 | 29 | 33 | 2024-10-17 07:36:32+02:00 | 4 |
| 18662838 | 18662838 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:36:24.000000 | 43 | 35 | 2024-10-17 07:36:24+02:00 | -8 |
| 18662837 | 18662837 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:36:17.000000 | 47 | 41 | 2024-10-17 07:36:17+02:00 | -6 |
| 18662836 | 18662836 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:46.000000 | 23 | 27 | 2024-10-17 07:35:46+02:00 | 4 |
| 18662835 | 18662835 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:43.000000 | 24 | 25 | 2024-10-17 07:35:43+02:00 | 1 |
| 18662834 | 18662834 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:33.000000 | 40 | 30 | 2024-10-17 07:35:33+02:00 | -10 |
| 18662833 | 18662833 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:27.000000 | 31 | 29 | 2024-10-17 07:35:27+02:00 | -2 |
| 18662832 | 18662832 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:13.000000 | 46 | 30 | 2024-10-17 07:35:13+02:00 | -16 |
| 18662831 | 18662831 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:06.000000 | 40 | 26 | 2024-10-17 07:35:06+02:00 | -14 |
| 18662830 | 18662830 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:35:05.000000 | 41 | 40 | 2024-10-17 07:35:05+02:00 | -1 |
| 18662829 | 18662829 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:34:58.000000 | 49 | 46 | 2024-10-17 07:34:58+02:00 | -3 |
| 18662828 | 18662828 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:34:50.000000 | 51 | 47 | 2024-10-17 07:34:50+02:00 | -4 |
| 18662827 | 18662827 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:34:03.000000 | 38 | 28 | 2024-10-17 07:34:03+02:00 | -10 |
| 18662826 | 18662826 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:33:56.000000 | 13 | 30 | 2024-10-17 07:33:56+02:00 | 17 |
| 18662825 | 18662825 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:33:55.000000 | 41 | 38 | 2024-10-17 07:33:55+02:00 | -3 |
| 18662824 | 18662824 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:33:09.000000 | 29 | 27 | 2024-10-17 07:33:09+02:00 | -2 |
| 18662823 | 18662823 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:59.000000 | 50 | 29 | 2024-10-17 07:32:59+02:00 | -21 |
| 18662822 | 18662822 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:53.000000 | 51 | 48 | 2024-10-17 07:32:53+02:00 | -3 |
| 18662821 | 18662821 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:46.000000 | 35 | 29 | 2024-10-17 07:32:46+02:00 | -6 |
| 18662820 | 18662820 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:29.000000 | 35 | 24 | 2024-10-17 07:32:29+02:00 | -11 |
| 18662819 | 18662819 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:24.000000 | 34 | 23 | 2024-10-17 07:32:24+02:00 | -11 |
| 18662818 | 18662818 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:32:01.000000 | 36 | 32 | 2024-10-17 07:32:01+02:00 | -4 |
| 18662817 | 18662817 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:31:29.000000 | 38 | 34 | 2024-10-17 07:31:29+02:00 | -4 |
| 18662816 | 18662816 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:30:41.000000 | 29 | 26 | 2024-10-17 07:30:41+02:00 | -3 |
| 18662815 | 18662815 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:30:05.000000 | 35 | 31 | 2024-10-17 07:30:05+02:00 | -4 |
| 18662814 | 18662814 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:29:57.000000 | 49 | 35 | 2024-10-17 07:29:57+02:00 | -14 |
| 18662813 | 18662813 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:29:26.000000 | 20 | 22 | 2024-10-17 07:29:26+02:00 | 2 |
| 18662812 | 18662812 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:28:43.000000 | 31 | 27 | 2024-10-17 07:28:43+02:00 | -4 |
| 18662811 | 18662811 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:28:33.000000 | 43 | 30 | 2024-10-17 07:28:33+02:00 | -13 |
| 18662810 | 18662810 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:28:26.000000 | 48 | 43 | 2024-10-17 07:28:26+02:00 | -5 |
| 18662809 | 18662809 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:27:27.000000 | 35 | 29 | 2024-10-17 07:27:27+02:00 | -6 |
| 18662808 | 18662808 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:27:02.000000 | 46 | 32 | 2024-10-17 07:27:02+02:00 | -14 |
| 18662807 | 18662807 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:26:58.000000 | 34 | 28 | 2024-10-17 07:26:58+02:00 | -6 |
| 18662806 | 18662806 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:26:52.000000 | 33 | 33 | 2024-10-17 07:26:52+02:00 | 0 |
| 18662805 | 18662805 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:26:47.000000 | 45 | 37 | 2024-10-17 07:26:47+02:00 | -8 |
| 18662804 | 18662804 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:26:43.000000 | 48 | 33 | 2024-10-17 07:26:43+02:00 | -15 |
| 18662803 | 18662803 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:24:34.000000 | 36 | 29 | 2024-10-17 07:24:34+02:00 | -7 |
| 18662802 | 18662802 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:24:25.000000 | 41 | 36 | 2024-10-17 07:24:25+02:00 | -5 |
| 18662801 | 18662801 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:24:22.000000 | 53 | 38 | 2024-10-17 07:24:22+02:00 | -15 |
| 18662800 | 18662800 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:24:08.000000 | 26 | 37 | 2024-10-17 07:24:08+02:00 | 11 |
| 18662799 | 18662799 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:23:13.000000 | 38 | 31 | 2024-10-17 07:23:13+02:00 | -7 |
| 18662798 | 18662798 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:22:26.000000 | 40 | 30 | 2024-10-17 07:22:26+02:00 | -10 |
| 18662797 | 18662797 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:22:21.000000 | 45 | 38 | 2024-10-17 07:22:21+02:00 | -7 |
| 18662796 | 18662796 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:21:22.000000 | 29 | 24 | 2024-10-17 07:21:22+02:00 | -5 |
| 18662795 | 18662795 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:21:11.000000 | 33 | 28 | 2024-10-17 07:21:11+02:00 | -5 |
| 18662794 | 18662794 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:21:02.000000 | 43 | 32 | 2024-10-17 07:21:02+02:00 | -11 |
| 18662793 | 18662793 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:19:31.000000 | 32 | 27 | 2024-10-17 07:19:31+02:00 | -5 |
| 18662792 | 18662792 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:19:21.000000 | 40 | 31 | 2024-10-17 07:19:21+02:00 | -9 |
| 18662791 | 18662791 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:18:49.000000 | 35 | 29 | 2024-10-17 07:18:49+02:00 | -6 |
| 18662790 | 18662790 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:18:43.000000 | 27 | 24 | 2024-10-17 07:18:43+02:00 | -3 |
| 18662788 | 18662788 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:18:32.000000 | 31 | 30 | 2024-10-17 07:18:32+02:00 | -1 |
| 18662789 | 18662789 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:18:32.000000 | 30 | 26 | 2024-10-17 07:18:32+02:00 | -4 |
| 18662787 | 18662787 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:18:22.000000 | 34 | 30 | 2024-10-17 07:18:22+02:00 | -4 |
| 18662786 | 18662786 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:17:34.000000 | 53 | 44 | 2024-10-17 07:17:34+02:00 | -9 |
| 18662785 | 18662785 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:17:26.000000 | 20 | 18 | 2024-10-17 07:17:26+02:00 | -2 |
| 18662784 | 18662784 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:16:53.000000 | 26 | 24 | 2024-10-17 07:16:53+02:00 | -2 |
| 18662783 | 18662783 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:16:50.000000 | 38 | 29 | 2024-10-17 07:16:50+02:00 | -9 |
| 18662782 | 18662782 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:16:43.000000 | 49 | 38 | 2024-10-17 07:16:43+02:00 | -11 |
| 18662781 | 18662781 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:16:33.000000 | 34 | 34 | 2024-10-17 07:16:33+02:00 | 0 |
| 18662780 | 18662780 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:16:14.000000 | 39 | 27 | 2024-10-17 07:16:14+02:00 | -12 |
| 18662779 | 18662779 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:15:56.000000 | 35 | 30 | 2024-10-17 07:15:56+02:00 | -5 |
| 18662778 | 18662778 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:15:15.000000 | 31 | 28 | 2024-10-17 07:15:15+02:00 | -3 |
| 18662777 | 18662777 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:14:44.000000 | 33 | 30 | 2024-10-17 07:14:44+02:00 | -3 |
| 18662776 | 18662776 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:14:04.000000 | 23 | 28 | 2024-10-17 07:14:04+02:00 | 5 |
| 18662775 | 18662775 | Weilstrasse 4-7 | 7 | 4 | Nachmessung | 2024-10-17 | 07:13:23.000000 | 33 | 30 | 2024-10-17 07:13:23+02:00 | -3 |
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");