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-12" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
2336300 | 2336300 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:31:56.000000 | 27 | 18 | 2023-07-10 12:31:56+02:00 | -9 |
2336299 | 2336299 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:29:18.000000 | 26 | 27 | 2023-07-10 12:29:18+02:00 | 1 |
2336298 | 2336298 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:28:59.000000 | 31 | 31 | 2023-07-10 12:28:59+02:00 | 0 |
2336297 | 2336297 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:28:54.000000 | 41 | 31 | 2023-07-10 12:28:54+02:00 | -10 |
2336296 | 2336296 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:26:23.000000 | 23 | 26 | 2023-07-10 12:26:23+02:00 | 3 |
2336295 | 2336295 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:26:05.000000 | 26 | 26 | 2023-07-10 12:26:05+02:00 | 0 |
2336294 | 2336294 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:24:36.000000 | 13 | 17 | 2023-07-10 12:24:36+02:00 | 4 |
2336293 | 2336293 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:24:18.000000 | 24 | 24 | 2023-07-10 12:24:18+02:00 | 0 |
2336292 | 2336292 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:23:28.000000 | 23 | 33 | 2023-07-10 12:23:28+02:00 | 10 |
2336291 | 2336291 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:22:27.000000 | 30 | 26 | 2023-07-10 12:22:27+02:00 | -4 |
2336290 | 2336290 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:18:26.000000 | 29 | 23 | 2023-07-10 12:18:26+02:00 | -6 |
2336289 | 2336289 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:18:09.000000 | 24 | 38 | 2023-07-10 12:18:09+02:00 | 14 |
2336288 | 2336288 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:16:23.000000 | 26 | 27 | 2023-07-10 12:16:23+02:00 | 1 |
2336287 | 2336287 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:14:52.000000 | 19 | 24 | 2023-07-10 12:14:52+02:00 | 5 |
2336286 | 2336286 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:14:37.000000 | 20 | 22 | 2023-07-10 12:14:37+02:00 | 2 |
2336285 | 2336285 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:13:55.000000 | 24 | 28 | 2023-07-10 12:13:55+02:00 | 4 |
2336284 | 2336284 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:13:50.000000 | 28 | 27 | 2023-07-10 12:13:50+02:00 | -1 |
2336283 | 2336283 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:08:06.000000 | 16 | 31 | 2023-07-10 12:08:06+02:00 | 15 |
2336282 | 2336282 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:05:17.000000 | 28 | 24 | 2023-07-10 12:05:17+02:00 | -4 |
2336281 | 2336281 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:04:47.000000 | 24 | 24 | 2023-07-10 12:04:47+02:00 | 0 |
2336280 | 2336280 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:03:35.000000 | 28 | 8 | 2023-07-10 12:03:35+02:00 | -20 |
2336279 | 2336279 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:03:00.000000 | 28 | 34 | 2023-07-10 12:03:00+02:00 | 6 |
2336278 | 2336278 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:02:46.000000 | 20 | 10 | 2023-07-10 12:02:46+02:00 | -10 |
2336277 | 2336277 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:02:19.000000 | 9 | 22 | 2023-07-10 12:02:19+02:00 | 13 |
2336276 | 2336276 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:02:16.000000 | 16 | 28 | 2023-07-10 12:02:16+02:00 | 12 |
2336275 | 2336275 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 12:01:52.000000 | 14 | 18 | 2023-07-10 12:01:52+02:00 | 4 |
2336274 | 2336274 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:57:52.000000 | 20 | 24 | 2023-07-10 11:57:52+02:00 | 4 |
2336273 | 2336273 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:57:14.000000 | 11 | 22 | 2023-07-10 11:57:14+02:00 | 11 |
2336272 | 2336272 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:55:06.000000 | 32 | 40 | 2023-07-10 11:55:06+02:00 | 8 |
2336271 | 2336271 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:54:11.000000 | 10 | 28 | 2023-07-10 11:54:11+02:00 | 18 |
2336270 | 2336270 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:54:00.000000 | 26 | 30 | 2023-07-10 11:54:00+02:00 | 4 |
2336269 | 2336269 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:53:48.000000 | 24 | 26 | 2023-07-10 11:53:48+02:00 | 2 |
2336268 | 2336268 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:53:06.000000 | 30 | 29 | 2023-07-10 11:53:06+02:00 | -1 |
2336267 | 2336267 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:52:44.000000 | 33 | 29 | 2023-07-10 11:52:44+02:00 | -4 |
2336266 | 2336266 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:50:36.000000 | 28 | 29 | 2023-07-10 11:50:36+02:00 | 1 |
2336265 | 2336265 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:48:11.000000 | 9 | 18 | 2023-07-10 11:48:11+02:00 | 9 |
2336264 | 2336264 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:47:22.000000 | 26 | 24 | 2023-07-10 11:47:22+02:00 | -2 |
2336263 | 2336263 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:47:08.000000 | 24 | 26 | 2023-07-10 11:47:08+02:00 | 2 |
2336262 | 2336262 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:47:03.000000 | 43 | 27 | 2023-07-10 11:47:03+02:00 | -16 |
2336261 | 2336261 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:45:56.000000 | 26 | 24 | 2023-07-10 11:45:56+02:00 | -2 |
2336260 | 2336260 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:45:41.000000 | 27 | 25 | 2023-07-10 11:45:41+02:00 | -2 |
2336259 | 2336259 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:42:41.000000 | 34 | 33 | 2023-07-10 11:42:41+02:00 | -1 |
2336258 | 2336258 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:42:32.000000 | 38 | 33 | 2023-07-10 11:42:32+02:00 | -5 |
2336257 | 2336257 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:41:13.000000 | 30 | 25 | 2023-07-10 11:41:13+02:00 | -5 |
2336256 | 2336256 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:40:21.000000 | 19 | 29 | 2023-07-10 11:40:21+02:00 | 10 |
2336255 | 2336255 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:37:48.000000 | 40 | 37 | 2023-07-10 11:37:48+02:00 | -3 |
2336254 | 2336254 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:36:59.000000 | 32 | 28 | 2023-07-10 11:36:59+02:00 | -4 |
2336253 | 2336253 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:36:50.000000 | 24 | 31 | 2023-07-10 11:36:50+02:00 | 7 |
2336252 | 2336252 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:35:21.000000 | 28 | 29 | 2023-07-10 11:35:21+02:00 | 1 |
2336251 | 2336251 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:33:48.000000 | 28 | 30 | 2023-07-10 11:33:48+02:00 | 2 |
2336250 | 2336250 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:33:37.000000 | 31 | 27 | 2023-07-10 11:33:37+02:00 | -4 |
2336249 | 2336249 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:29:29.000000 | 24 | 22 | 2023-07-10 11:29:29+02:00 | -2 |
2336248 | 2336248 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:28:25.000000 | 10 | 19 | 2023-07-10 11:28:25+02:00 | 9 |
2336247 | 2336247 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:26:47.000000 | 24 | 26 | 2023-07-10 11:26:47+02:00 | 2 |
2336246 | 2336246 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:26:39.000000 | 19 | 26 | 2023-07-10 11:26:39+02:00 | 7 |
2336245 | 2336245 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:26:28.000000 | 25 | 38 | 2023-07-10 11:26:28+02:00 | 13 |
2336244 | 2336244 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:24:36.000000 | 16 | 27 | 2023-07-10 11:24:36+02:00 | 11 |
2336243 | 2336243 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:23:44.000000 | 30 | 23 | 2023-07-10 11:23:44+02:00 | -7 |
2336242 | 2336242 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:23:34.000000 | 25 | 29 | 2023-07-10 11:23:34+02:00 | 4 |
2336241 | 2336241 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:23:27.000000 | 37 | 32 | 2023-07-10 11:23:27+02:00 | -5 |
2336240 | 2336240 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:21:35.000000 | 30 | 24 | 2023-07-10 11:21:35+02:00 | -6 |
2336239 | 2336239 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:21:10.000000 | 37 | 31 | 2023-07-10 11:21:10+02:00 | -6 |
2336237 | 2336237 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:20:59.000000 | 35 | 35 | 2023-07-10 11:20:59+02:00 | 0 |
2336238 | 2336238 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:20:59.000000 | 28 | 36 | 2023-07-10 11:20:59+02:00 | 8 |
2336236 | 2336236 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:20:03.000000 | 23 | 25 | 2023-07-10 11:20:03+02:00 | 2 |
2336235 | 2336235 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:19:55.000000 | 18 | 27 | 2023-07-10 11:19:55+02:00 | 9 |
2336234 | 2336234 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:19:52.000000 | 29 | 28 | 2023-07-10 11:19:52+02:00 | -1 |
2336233 | 2336233 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:17:37.000000 | 25 | 26 | 2023-07-10 11:17:37+02:00 | 1 |
2336232 | 2336232 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:17:22.000000 | 26 | 25 | 2023-07-10 11:17:22+02:00 | -1 |
2336231 | 2336231 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:14:01.000000 | 27 | 27 | 2023-07-10 11:14:01+02:00 | 0 |
2336230 | 2336230 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:13:50.000000 | 30 | 26 | 2023-07-10 11:13:50+02:00 | -4 |
2336229 | 2336229 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:13:40.000000 | 26 | 30 | 2023-07-10 11:13:40+02:00 | 4 |
2336228 | 2336228 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:13:29.000000 | 30 | 25 | 2023-07-10 11:13:29+02:00 | -5 |
2336227 | 2336227 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:13:19.000000 | 30 | 29 | 2023-07-10 11:13:19+02:00 | -1 |
2336226 | 2336226 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:12:19.000000 | 30 | 27 | 2023-07-10 11:12:19+02:00 | -3 |
2336225 | 2336225 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:12:08.000000 | 34 | 30 | 2023-07-10 11:12:08+02:00 | -4 |
2336224 | 2336224 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:12:07.000000 | 9 | 27 | 2023-07-10 11:12:07+02:00 | 18 |
2336223 | 2336223 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:09:54.000000 | 24 | 27 | 2023-07-10 11:09:54+02:00 | 3 |
2336222 | 2336222 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:09:43.000000 | 19 | 27 | 2023-07-10 11:09:43+02:00 | 8 |
2336221 | 2336221 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:09:31.000000 | 23 | 30 | 2023-07-10 11:09:31+02:00 | 7 |
2336220 | 2336220 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:09:30.000000 | 29 | 30 | 2023-07-10 11:09:30+02:00 | 1 |
2336219 | 2336219 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:09:23.000000 | 29 | 26 | 2023-07-10 11:09:23+02:00 | -3 |
2336218 | 2336218 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:08:54.000000 | 30 | 30 | 2023-07-10 11:08:54+02:00 | 0 |
2336217 | 2336217 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:08:44.000000 | 13 | 29 | 2023-07-10 11:08:44+02:00 | 16 |
2336216 | 2336216 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:08:27.000000 | 19 | 25 | 2023-07-10 11:08:27+02:00 | 6 |
2336215 | 2336215 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:08:20.000000 | 25 | 26 | 2023-07-10 11:08:20+02:00 | 1 |
2336214 | 2336214 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:01:55.000000 | 23 | 19 | 2023-07-10 11:01:55+02:00 | -4 |
2336213 | 2336213 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:01:13.000000 | 27 | 28 | 2023-07-10 11:01:13+02:00 | 1 |
2336212 | 2336212 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 11:01:09.000000 | 30 | 29 | 2023-07-10 11:01:09+02:00 | -1 |
2336211 | 2336211 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:59:49.000000 | 26 | 30 | 2023-07-10 10:59:49+02:00 | 4 |
2336210 | 2336210 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:59:45.000000 | 30 | 28 | 2023-07-10 10:59:45+02:00 | -2 |
2336209 | 2336209 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:59:23.000000 | 29 | 31 | 2023-07-10 10:59:23+02:00 | 2 |
2336208 | 2336208 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:55:52.000000 | 29 | 27 | 2023-07-10 10:55:52+02:00 | -2 |
2336207 | 2336207 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:55:37.000000 | 30 | 28 | 2023-07-10 10:55:37+02:00 | -2 |
2336206 | 2336206 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:54:54.000000 | 30 | 17 | 2023-07-10 10:54:54+02:00 | -13 |
2336205 | 2336205 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:54:44.000000 | 30 | 29 | 2023-07-10 10:54:44+02:00 | -1 |
2336204 | 2336204 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:54:34.000000 | 30 | 29 | 2023-07-10 10:54:34+02:00 | -1 |
2336203 | 2336203 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:51:20.000000 | 16 | 22 | 2023-07-10 10:51:20+02:00 | 6 |
2336202 | 2336202 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:50:05.000000 | 38 | 33 | 2023-07-10 10:50:05+02:00 | -5 |
2336201 | 2336201 | Allmendstrasse 1-12 | 12 | 1 | Nach Ende | 2023-07-10 | 10:49:55.000000 | 33 | 37 | 2023-07-10 10:49:55+02:00 | 4 |
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");