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-35" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9409905 | 9409905 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:45:08.000000 | 25 | 23 | 2024-10-17 11:45:08+02:00 | -2 |
| 9409904 | 9409904 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:43:34.000000 | 28 | 17 | 2024-10-17 11:43:34+02:00 | -11 |
| 9409903 | 9409903 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:41:15.000000 | 25 | 24 | 2024-10-17 11:41:15+02:00 | -1 |
| 9409902 | 9409902 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:40:54.000000 | 36 | 32 | 2024-10-17 11:40:54+02:00 | -4 |
| 9409901 | 9409901 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:36:08.000000 | 29 | 31 | 2024-10-17 11:36:08+02:00 | 2 |
| 9409900 | 9409900 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:34:47.000000 | 12 | 13 | 2024-10-17 11:34:47+02:00 | 1 |
| 9409899 | 9409899 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:33:55.000000 | 18 | 17 | 2024-10-17 11:33:55+02:00 | -1 |
| 9409898 | 9409898 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:30:45.000000 | 31 | 23 | 2024-10-17 11:30:45+02:00 | -8 |
| 9409897 | 9409897 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:30:36.000000 | 16 | 18 | 2024-10-17 11:30:36+02:00 | 2 |
| 9409896 | 9409896 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:29:54.000000 | 43 | 34 | 2024-10-17 11:29:54+02:00 | -9 |
| 9409895 | 9409895 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:26:30.000000 | 27 | 30 | 2024-10-17 11:26:30+02:00 | 3 |
| 9409894 | 9409894 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:23:46.000000 | 28 | 28 | 2024-10-17 11:23:46+02:00 | 0 |
| 9409893 | 9409893 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:20:44.000000 | 27 | 20 | 2024-10-17 11:20:44+02:00 | -7 |
| 9409892 | 9409892 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:20:41.000000 | 35 | 31 | 2024-10-17 11:20:41+02:00 | -4 |
| 9409891 | 9409891 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:20:32.000000 | 30 | 27 | 2024-10-17 11:20:32+02:00 | -3 |
| 9409890 | 9409890 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:19:44.000000 | 19 | 27 | 2024-10-17 11:19:44+02:00 | 8 |
| 9409889 | 9409889 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:18:06.000000 | 24 | 22 | 2024-10-17 11:18:06+02:00 | -2 |
| 9409888 | 9409888 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:17:50.000000 | 26 | 22 | 2024-10-17 11:17:50+02:00 | -4 |
| 9409887 | 9409887 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:17:38.000000 | 26 | 25 | 2024-10-17 11:17:38+02:00 | -1 |
| 9409886 | 9409886 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:16:58.000000 | 32 | 29 | 2024-10-17 11:16:58+02:00 | -3 |
| 9409885 | 9409885 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:15:38.000000 | 28 | 26 | 2024-10-17 11:15:38+02:00 | -2 |
| 9409884 | 9409884 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:14:22.000000 | 34 | 33 | 2024-10-17 11:14:22+02:00 | -1 |
| 9409883 | 9409883 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:13:42.000000 | 30 | 29 | 2024-10-17 11:13:42+02:00 | -1 |
| 9409882 | 9409882 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:12:49.000000 | 32 | 26 | 2024-10-17 11:12:49+02:00 | -6 |
| 9409881 | 9409881 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:12:25.000000 | 32 | 39 | 2024-10-17 11:12:25+02:00 | 7 |
| 9409880 | 9409880 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:11:21.000000 | 25 | 22 | 2024-10-17 11:11:21+02:00 | -3 |
| 9409879 | 9409879 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:10:06.000000 | 31 | 27 | 2024-10-17 11:10:06+02:00 | -4 |
| 9409878 | 9409878 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:09:57.000000 | 26 | 30 | 2024-10-17 11:09:57+02:00 | 4 |
| 9409877 | 9409877 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:09:44.000000 | 30 | 24 | 2024-10-17 11:09:44+02:00 | -6 |
| 9409876 | 9409876 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:08:23.000000 | 20 | 26 | 2024-10-17 11:08:23+02:00 | 6 |
| 9409875 | 9409875 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:08:07.000000 | 25 | 20 | 2024-10-17 11:08:07+02:00 | -5 |
| 9409874 | 9409874 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:07:08.000000 | 23 | 26 | 2024-10-17 11:07:08+02:00 | 3 |
| 9409873 | 9409873 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:04:04.000000 | 15 | 24 | 2024-10-17 11:04:04+02:00 | 9 |
| 9409872 | 9409872 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:02:18.000000 | 17 | 30 | 2024-10-17 11:02:18+02:00 | 13 |
| 9409871 | 9409871 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:00:52.000000 | 20 | 25 | 2024-10-17 11:00:52+02:00 | 5 |
| 9409870 | 9409870 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:57:26.000000 | 35 | 33 | 2024-10-17 10:57:26+02:00 | -2 |
| 9409869 | 9409869 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:55:03.000000 | 20 | 26 | 2024-10-17 10:55:03+02:00 | 6 |
| 9409868 | 9409868 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:48:45.000000 | 19 | 25 | 2024-10-17 10:48:45+02:00 | 6 |
| 9409867 | 9409867 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:47:57.000000 | 32 | 29 | 2024-10-17 10:47:57+02:00 | -3 |
| 9409866 | 9409866 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:47:39.000000 | 23 | 24 | 2024-10-17 10:47:39+02:00 | 1 |
| 9409865 | 9409865 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:46:02.000000 | 27 | 30 | 2024-10-17 10:46:02+02:00 | 3 |
| 9409864 | 9409864 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:44:39.000000 | 29 | 28 | 2024-10-17 10:44:39+02:00 | -1 |
| 9409863 | 9409863 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:42:10.000000 | 31 | 26 | 2024-10-17 10:42:10+02:00 | -5 |
| 9409862 | 9409862 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:39:03.000000 | 31 | 25 | 2024-10-17 10:39:03+02:00 | -6 |
| 9409861 | 9409861 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:38:46.000000 | 31 | 28 | 2024-10-17 10:38:46+02:00 | -3 |
| 9409860 | 9409860 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:35:33.000000 | 18 | 22 | 2024-10-17 10:35:33+02:00 | 4 |
| 9409859 | 9409859 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:33:55.000000 | 20 | 27 | 2024-10-17 10:33:55+02:00 | 7 |
| 9409858 | 9409858 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:32:17.000000 | 24 | 27 | 2024-10-17 10:32:17+02:00 | 3 |
| 9409857 | 9409857 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:31:55.000000 | 28 | 20 | 2024-10-17 10:31:55+02:00 | -8 |
| 9409856 | 9409856 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:31:44.000000 | 23 | 27 | 2024-10-17 10:31:44+02:00 | 4 |
| 9409855 | 9409855 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:30:08.000000 | 24 | 24 | 2024-10-17 10:30:08+02:00 | 0 |
| 9409854 | 9409854 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:24:49.000000 | 25 | 29 | 2024-10-17 10:24:49+02:00 | 4 |
| 9409853 | 9409853 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:24:42.000000 | 23 | 28 | 2024-10-17 10:24:42+02:00 | 5 |
| 9409852 | 9409852 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:22:57.000000 | 33 | 23 | 2024-10-17 10:22:57+02:00 | -10 |
| 9409851 | 9409851 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:22:33.000000 | 33 | 31 | 2024-10-17 10:22:33+02:00 | -2 |
| 9409850 | 9409850 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:22:09.000000 | 14 | 18 | 2024-10-17 10:22:09+02:00 | 4 |
| 9409849 | 9409849 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:21:02.000000 | 19 | 27 | 2024-10-17 10:21:02+02:00 | 8 |
| 9409848 | 9409848 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:19:04.000000 | 25 | 19 | 2024-10-17 10:19:04+02:00 | -6 |
| 9409847 | 9409847 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:16:13.000000 | 23 | 25 | 2024-10-17 10:16:13+02:00 | 2 |
| 9409846 | 9409846 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:13:25.000000 | 31 | 27 | 2024-10-17 10:13:25+02:00 | -4 |
| 9409845 | 9409845 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:13:23.000000 | 23 | 24 | 2024-10-17 10:13:23+02:00 | 1 |
| 9409844 | 9409844 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:08:32.000000 | 24 | 23 | 2024-10-17 10:08:32+02:00 | -1 |
| 9409843 | 9409843 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:07:12.000000 | 28 | 23 | 2024-10-17 10:07:12+02:00 | -5 |
| 9409842 | 9409842 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:05:55.000000 | 27 | 28 | 2024-10-17 10:05:55+02:00 | 1 |
| 9409841 | 9409841 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:01:17.000000 | 23 | 22 | 2024-10-17 10:01:17+02:00 | -1 |
| 9409840 | 9409840 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:00:55.000000 | 19 | 14 | 2024-10-17 10:00:55+02:00 | -5 |
| 9409839 | 9409839 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:00:27.000000 | 28 | 25 | 2024-10-17 10:00:27+02:00 | -3 |
| 9409838 | 9409838 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:58:06.000000 | 24 | 20 | 2024-10-17 09:58:06+02:00 | -4 |
| 9409837 | 9409837 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:54:40.000000 | 20 | 32 | 2024-10-17 09:54:40+02:00 | 12 |
| 9409836 | 9409836 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:51:35.000000 | 28 | 25 | 2024-10-17 09:51:35+02:00 | -3 |
| 9409835 | 9409835 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:51:16.000000 | 25 | 24 | 2024-10-17 09:51:16+02:00 | -1 |
| 9409834 | 9409834 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:51:06.000000 | 32 | 27 | 2024-10-17 09:51:06+02:00 | -5 |
| 9409833 | 9409833 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:50:46.000000 | 16 | 20 | 2024-10-17 09:50:46+02:00 | 4 |
| 9409832 | 9409832 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:46:59.000000 | 28 | 29 | 2024-10-17 09:46:59+02:00 | 1 |
| 9409831 | 9409831 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:42:00.000000 | 26 | 22 | 2024-10-17 09:42:00+02:00 | -4 |
| 9409830 | 9409830 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:38:34.000000 | 38 | 36 | 2024-10-17 09:38:34+02:00 | -2 |
| 9409829 | 9409829 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:37:39.000000 | 18 | 29 | 2024-10-17 09:37:39+02:00 | 11 |
| 9409828 | 9409828 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:32:47.000000 | 12 | 33 | 2024-10-17 09:32:47+02:00 | 21 |
| 9409827 | 9409827 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:31:53.000000 | 25 | 26 | 2024-10-17 09:31:53+02:00 | 1 |
| 9409826 | 9409826 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:31:17.000000 | 26 | 26 | 2024-10-17 09:31:17+02:00 | 0 |
| 9409825 | 9409825 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:26:47.000000 | 29 | 25 | 2024-10-17 09:26:47+02:00 | -4 |
| 9409824 | 9409824 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:26:20.000000 | 25 | 23 | 2024-10-17 09:26:20+02:00 | -2 |
| 9409823 | 9409823 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:23:56.000000 | 32 | 34 | 2024-10-17 09:23:56+02:00 | 2 |
| 9409822 | 9409822 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:21:15.000000 | 25 | 27 | 2024-10-17 09:21:15+02:00 | 2 |
| 9409821 | 9409821 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:21:03.000000 | 23 | 24 | 2024-10-17 09:21:03+02:00 | 1 |
| 9409820 | 9409820 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:17:58.000000 | 20 | 26 | 2024-10-17 09:17:58+02:00 | 6 |
| 9409819 | 9409819 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:17:15.000000 | 25 | 24 | 2024-10-17 09:17:15+02:00 | -1 |
| 9409818 | 9409818 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:14:21.000000 | 26 | 18 | 2024-10-17 09:14:21+02:00 | -8 |
| 9409817 | 9409817 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:13:25.000000 | 28 | 22 | 2024-10-17 09:13:25+02:00 | -6 |
| 9409816 | 9409816 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:13:04.000000 | 25 | 24 | 2024-10-17 09:13:04+02:00 | -1 |
| 9409815 | 9409815 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:11:00.000000 | 28 | 29 | 2024-10-17 09:11:00+02:00 | 1 |
| 9409814 | 9409814 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:09:48.000000 | 30 | 31 | 2024-10-17 09:09:48+02:00 | 1 |
| 9409813 | 9409813 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:07:49.000000 | 23 | 33 | 2024-10-17 09:07:49+02:00 | 10 |
| 9409812 | 9409812 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:05:33.000000 | 24 | 23 | 2024-10-17 09:05:33+02:00 | -1 |
| 9409811 | 9409811 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:02:39.000000 | 25 | 26 | 2024-10-17 09:02:39+02:00 | 1 |
| 9409810 | 9409810 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:01:36.000000 | 14 | 29 | 2024-10-17 09:01:36+02:00 | 15 |
| 9409809 | 9409809 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:00:00.000000 | 29 | 26 | 2024-10-17 09:00:00+02:00 | -3 |
| 9409808 | 9409808 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 08:59:15.000000 | 27 | 26 | 2024-10-17 08:59:15+02:00 | -1 |
| 9409807 | 9409807 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 08:56:59.000000 | 31 | 28 | 2024-10-17 08:56:59+02:00 | -3 |
| 9409806 | 9409806 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 08:56:33.000000 | 20 | 25 | 2024-10-17 08:56:33+02: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");