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 = "1-41" sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Phase, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
1979153 | 1979153 | Gellertstrasse 1-41 | 41 | 1 | Nach Ende | 2023-07-10 | 09:26:02.000000 | 26 | 14 | 2023-07-10 09:26:02+02:00 | -12 |
1979152 | 1979152 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:25:34.000000 | 13 | 18 | 2023-07-10 09:25:34+02:00 | 5 |
1979151 | 1979151 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:25:23.000000 | 28 | 22 | 2023-07-10 09:25:23+02:00 | -6 |
1979150 | 1979150 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:25:20.000000 | 35 | 26 | 2023-07-10 09:25:20+02:00 | -9 |
1979149 | 1979149 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:24:20.000000 | 33 | 27 | 2023-07-10 09:24:20+02:00 | -6 |
1979148 | 1979148 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:23:36.000000 | 24 | 16 | 2023-07-10 09:23:36+02:00 | -8 |
1979147 | 1979147 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:22:55.000000 | 29 | 23 | 2023-07-10 09:22:55+02:00 | -6 |
1979146 | 1979146 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:22:52.000000 | 24 | 23 | 2023-07-10 09:22:52+02:00 | -1 |
1979145 | 1979145 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:20:28.000000 | 18 | 26 | 2023-07-10 09:20:28+02:00 | 8 |
1979144 | 1979144 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:19:08.000000 | 34 | 34 | 2023-07-10 09:19:08+02:00 | 0 |
1979143 | 1979143 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:18:49.000000 | 30 | 24 | 2023-07-10 09:18:49+02:00 | -6 |
1979142 | 1979142 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:17:44.000000 | 37 | 33 | 2023-07-10 09:17:44+02:00 | -4 |
1979141 | 1979141 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:15:52.000000 | 40 | 31 | 2023-07-10 09:15:52+02:00 | -9 |
1979140 | 1979140 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:15:49.000000 | 36 | 30 | 2023-07-10 09:15:49+02:00 | -6 |
1979139 | 1979139 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:14:16.000000 | 24 | 25 | 2023-07-10 09:14:16+02:00 | 1 |
1979138 | 1979138 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:14:04.000000 | 32 | 25 | 2023-07-10 09:14:04+02:00 | -7 |
1979137 | 1979137 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:13:28.000000 | 37 | 18 | 2023-07-10 09:13:28+02:00 | -19 |
1979136 | 1979136 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:06:16.000000 | 17 | 24 | 2023-07-10 09:06:16+02:00 | 7 |
1979135 | 1979135 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:04:09.000000 | 34 | 29 | 2023-07-10 09:04:09+02:00 | -5 |
1979134 | 1979134 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:03:36.000000 | 35 | 27 | 2023-07-10 09:03:36+02:00 | -8 |
1979133 | 1979133 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:01:49.000000 | 35 | 34 | 2023-07-10 09:01:49+02:00 | -1 |
1979132 | 1979132 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 09:00:39.000000 | 37 | 31 | 2023-07-10 09:00:39+02:00 | -6 |
1979131 | 1979131 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:59:34.000000 | 27 | 29 | 2023-07-10 08:59:34+02:00 | 2 |
1979130 | 1979130 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:58:53.000000 | 27 | 18 | 2023-07-10 08:58:53+02:00 | -9 |
1979129 | 1979129 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:58:16.000000 | 40 | 32 | 2023-07-10 08:58:16+02:00 | -8 |
1979128 | 1979128 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:55:51.000000 | 33 | 22 | 2023-07-10 08:55:51+02:00 | -11 |
1979127 | 1979127 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:54:58.000000 | 25 | 22 | 2023-07-10 08:54:58+02:00 | -3 |
1979126 | 1979126 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:54:26.000000 | 25 | 28 | 2023-07-10 08:54:26+02:00 | 3 |
1979125 | 1979125 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:50:19.000000 | 28 | 32 | 2023-07-10 08:50:19+02:00 | 4 |
1979124 | 1979124 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:46:58.000000 | 32 | 15 | 2023-07-10 08:46:58+02:00 | -17 |
1979123 | 1979123 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:44:09.000000 | 27 | 20 | 2023-07-10 08:44:09+02:00 | -7 |
1979122 | 1979122 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:43:51.000000 | 31 | 32 | 2023-07-10 08:43:51+02:00 | 1 |
1979121 | 1979121 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:43:30.000000 | 45 | 32 | 2023-07-10 08:43:30+02:00 | -13 |
1979120 | 1979120 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:41:09.000000 | 31 | 30 | 2023-07-10 08:41:09+02:00 | -1 |
1979119 | 1979119 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:38:37.000000 | 37 | 32 | 2023-07-10 08:38:37+02:00 | -5 |
1979118 | 1979118 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:36:14.000000 | 25 | 15 | 2023-07-10 08:36:14+02:00 | -10 |
1979117 | 1979117 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:30:53.000000 | 35 | 34 | 2023-07-10 08:30:53+02:00 | -1 |
1979116 | 1979116 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:30:32.000000 | 30 | 29 | 2023-07-10 08:30:32+02:00 | -1 |
1979115 | 1979115 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:30:27.000000 | 17 | 17 | 2023-07-10 08:30:27+02:00 | 0 |
1979114 | 1979114 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:28:38.000000 | 35 | 31 | 2023-07-10 08:28:38+02:00 | -4 |
1979113 | 1979113 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:28:24.000000 | 32 | 29 | 2023-07-10 08:28:24+02:00 | -3 |
1979112 | 1979112 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:27:53.000000 | 28 | 23 | 2023-07-10 08:27:53+02:00 | -5 |
1979111 | 1979111 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:27:08.000000 | 28 | 16 | 2023-07-10 08:27:08+02:00 | -12 |
1979110 | 1979110 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:26:02.000000 | 31 | 27 | 2023-07-10 08:26:02+02:00 | -4 |
1979109 | 1979109 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:24:37.000000 | 38 | 27 | 2023-07-10 08:24:37+02:00 | -11 |
1979108 | 1979108 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:24:32.000000 | 31 | 28 | 2023-07-10 08:24:32+02:00 | -3 |
1979107 | 1979107 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:20:29.000000 | 26 | 23 | 2023-07-10 08:20:29+02:00 | -3 |
1979106 | 1979106 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:18:16.000000 | 29 | 30 | 2023-07-10 08:18:16+02:00 | 1 |
1979105 | 1979105 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:17:16.000000 | 35 | 24 | 2023-07-10 08:17:16+02:00 | -11 |
1979104 | 1979104 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:16:46.000000 | 43 | 33 | 2023-07-10 08:16:46+02:00 | -10 |
1979103 | 1979103 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:16:33.000000 | 23 | 13 | 2023-07-10 08:16:33+02:00 | -10 |
1979102 | 1979102 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:15:41.000000 | 15 | 15 | 2023-07-10 08:15:41+02:00 | 0 |
1979101 | 1979101 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:13:38.000000 | 35 | 26 | 2023-07-10 08:13:38+02:00 | -9 |
1979100 | 1979100 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:11:30.000000 | 28 | 28 | 2023-07-10 08:11:30+02:00 | 0 |
1979099 | 1979099 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:10:47.000000 | 43 | 39 | 2023-07-10 08:10:47+02:00 | -4 |
1979098 | 1979098 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:06:11.000000 | 17 | 25 | 2023-07-10 08:06:11+02:00 | 8 |
1979097 | 1979097 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:05:45.000000 | 35 | 33 | 2023-07-10 08:05:45+02:00 | -2 |
1979096 | 1979096 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:04:45.000000 | 31 | 27 | 2023-07-10 08:04:45+02:00 | -4 |
1979095 | 1979095 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:03:09.000000 | 26 | 16 | 2023-07-10 08:03:09+02:00 | -10 |
1979094 | 1979094 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:02:30.000000 | 33 | 27 | 2023-07-10 08:02:30+02:00 | -6 |
1979093 | 1979093 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 08:02:21.000000 | 36 | 29 | 2023-07-10 08:02:21+02:00 | -7 |
1979092 | 1979092 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:55:05.000000 | 25 | 25 | 2023-07-10 07:55:05+02:00 | 0 |
1979091 | 1979091 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:54:03.000000 | 33 | 37 | 2023-07-10 07:54:03+02:00 | 4 |
1979090 | 1979090 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:51:27.000000 | 33 | 29 | 2023-07-10 07:51:27+02:00 | -4 |
1979089 | 1979089 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:49:54.000000 | 32 | 20 | 2023-07-10 07:49:54+02:00 | -12 |
1979088 | 1979088 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:49:41.000000 | 34 | 31 | 2023-07-10 07:49:41+02:00 | -3 |
1979087 | 1979087 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:49:36.000000 | 26 | 24 | 2023-07-10 07:49:36+02:00 | -2 |
1979086 | 1979086 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:49:02.000000 | 39 | 32 | 2023-07-10 07:49:02+02:00 | -7 |
1979085 | 1979085 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:47:38.000000 | 15 | 13 | 2023-07-10 07:47:38+02:00 | -2 |
1979084 | 1979084 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:47:02.000000 | 24 | 23 | 2023-07-10 07:47:02+02:00 | -1 |
1979083 | 1979083 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:46:22.000000 | 27 | 27 | 2023-07-10 07:46:22+02:00 | 0 |
1979082 | 1979082 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:45:19.000000 | 29 | 25 | 2023-07-10 07:45:19+02:00 | -4 |
1979081 | 1979081 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:42:09.000000 | 28 | 30 | 2023-07-10 07:42:09+02:00 | 2 |
1979080 | 1979080 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:40:34.000000 | 26 | 26 | 2023-07-10 07:40:34+02:00 | 0 |
1979079 | 1979079 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:39:18.000000 | 25 | 28 | 2023-07-10 07:39:18+02:00 | 3 |
1979078 | 1979078 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:37:28.000000 | 30 | 28 | 2023-07-10 07:37:28+02:00 | -2 |
1979077 | 1979077 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:36:55.000000 | 30 | 29 | 2023-07-10 07:36:55+02:00 | -1 |
1979076 | 1979076 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:35:43.000000 | 37 | 34 | 2023-07-10 07:35:43+02:00 | -3 |
1979075 | 1979075 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:34:10.000000 | 36 | 31 | 2023-07-10 07:34:10+02:00 | -5 |
1979074 | 1979074 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:32:18.000000 | 36 | 37 | 2023-07-10 07:32:18+02:00 | 1 |
1979073 | 1979073 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:21:31.000000 | 33 | 28 | 2023-07-10 07:21:31+02:00 | -5 |
1979072 | 1979072 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:20:33.000000 | 38 | 31 | 2023-07-10 07:20:33+02:00 | -7 |
1979071 | 1979071 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:20:20.000000 | 26 | 28 | 2023-07-10 07:20:20+02:00 | 2 |
1979070 | 1979070 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:20:02.000000 | 27 | 25 | 2023-07-10 07:20:02+02:00 | -2 |
1979069 | 1979069 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:19:18.000000 | 35 | 26 | 2023-07-10 07:19:18+02:00 | -9 |
1979068 | 1979068 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:17:11.000000 | 34 | 35 | 2023-07-10 07:17:11+02:00 | 1 |
1979067 | 1979067 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:13:00.000000 | 31 | 38 | 2023-07-10 07:13:00+02:00 | 7 |
1979066 | 1979066 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:11:21.000000 | 35 | 28 | 2023-07-10 07:11:21+02:00 | -7 |
1979065 | 1979065 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:07:58.000000 | 34 | 28 | 2023-07-10 07:07:58+02:00 | -6 |
1979064 | 1979064 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:07:07.000000 | 37 | 31 | 2023-07-10 07:07:07+02:00 | -6 |
1979063 | 1979063 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 07:05:25.000000 | 30 | 26 | 2023-07-10 07:05:25+02:00 | -4 |
1979062 | 1979062 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 06:56:32.000000 | 34 | 34 | 2023-07-10 06:56:32+02:00 | 0 |
1979061 | 1979061 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 06:53:35.000000 | 30 | 23 | 2023-07-10 06:53:35+02:00 | -7 |
1979060 | 1979060 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 06:49:57.000000 | 50 | 33 | 2023-07-10 06:49:57+02:00 | -17 |
1979059 | 1979059 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 06:49:32.000000 | 28 | 31 | 2023-07-10 06:49:32+02:00 | 3 |
1979058 | 1979058 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 06:49:04.000000 | 37 | 27 | 2023-07-10 06:49:04+02:00 | -10 |
1979057 | 1979057 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 06:47:38.000000 | 34 | 28 | 2023-07-10 06:47:38+02:00 | -6 |
1979056 | 1979056 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 06:43:19.000000 | 38 | 27 | 2023-07-10 06:43:19+02:00 | -11 |
1979055 | 1979055 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 06:43:03.000000 | 39 | 24 | 2023-07-10 06:43:03+02:00 | -15 |
1979054 | 1979054 | Gellertstrasse 1-41 | 41 | 1 | Nachmessung | 2023-07-10 | 06:40:54.000000 | 30 | 25 | 2023-07-10 06:40:54+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");