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
8,966 rows where ID = "2-25" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 863337 | 863337 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:46:13.000000 | 23 | 29 | 2023-09-01 08:46:13+02:00 | 6 |
| 863336 | 863336 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:43:07.000000 | 19 | 22 | 2023-09-01 08:43:07+02:00 | 3 |
| 863335 | 863335 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:35:57.000000 | 25 | 22 | 2023-09-01 08:35:57+02:00 | -3 |
| 863334 | 863334 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:29:01.000000 | 18 | 19 | 2023-09-01 08:29:01+02:00 | 1 |
| 863333 | 863333 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:28:02.000000 | 13 | 20 | 2023-09-01 08:28:02+02:00 | 7 |
| 863332 | 863332 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:27:11.000000 | 24 | 27 | 2023-09-01 08:27:11+02:00 | 3 |
| 863331 | 863331 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:24:23.000000 | 16 | 13 | 2023-09-01 08:24:23+02:00 | -3 |
| 863330 | 863330 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:24:14.000000 | 28 | 15 | 2023-09-01 08:24:14+02:00 | -13 |
| 863329 | 863329 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:15:06.000000 | 15 | 20 | 2023-09-01 08:15:06+02:00 | 5 |
| 863328 | 863328 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 08:14:55.000000 | 24 | 24 | 2023-09-01 08:14:55+02:00 | 0 |
| 863327 | 863327 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:56:14.000000 | 16 | 14 | 2023-09-01 07:56:14+02:00 | -2 |
| 863326 | 863326 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:49:32.000000 | 15 | 19 | 2023-09-01 07:49:32+02:00 | 4 |
| 863325 | 863325 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:39:46.000000 | 19 | 17 | 2023-09-01 07:39:46+02:00 | -2 |
| 863324 | 863324 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:30:59.000000 | 16 | 18 | 2023-09-01 07:30:59+02:00 | 2 |
| 863323 | 863323 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:30:48.000000 | 27 | 28 | 2023-09-01 07:30:48+02:00 | 1 |
| 863322 | 863322 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:30:24.000000 | 27 | 26 | 2023-09-01 07:30:24+02:00 | -1 |
| 863321 | 863321 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:29:04.000000 | 14 | 12 | 2023-09-01 07:29:04+02:00 | -2 |
| 863320 | 863320 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:26:41.000000 | 33 | 27 | 2023-09-01 07:26:41+02:00 | -6 |
| 863319 | 863319 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:18:06.000000 | 23 | 20 | 2023-09-01 07:18:06+02:00 | -3 |
| 863318 | 863318 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:11:31.000000 | 16 | 18 | 2023-09-01 07:11:31+02:00 | 2 |
| 863317 | 863317 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:06:06.000000 | 12 | 20 | 2023-09-01 07:06:06+02:00 | 8 |
| 863316 | 863316 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 07:00:28.000000 | 17 | 13 | 2023-09-01 07:00:28+02:00 | -4 |
| 863315 | 863315 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:45:12.000000 | 16 | 17 | 2023-09-01 06:45:12+02:00 | 1 |
| 863314 | 863314 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:38:13.000000 | 31 | 24 | 2023-09-01 06:38:13+02:00 | -7 |
| 863313 | 863313 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:31:37.000000 | 15 | 20 | 2023-09-01 06:31:37+02:00 | 5 |
| 863312 | 863312 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:30:03.000000 | 16 | 17 | 2023-09-01 06:30:03+02:00 | 1 |
| 863311 | 863311 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:27:23.000000 | 26 | 22 | 2023-09-01 06:27:23+02:00 | -4 |
| 863310 | 863310 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:27:17.000000 | 14 | 12 | 2023-09-01 06:27:17+02:00 | -2 |
| 863309 | 863309 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:26:56.000000 | 3 | 3 | 2023-09-01 06:26:56+02:00 | 0 |
| 863308 | 863308 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:26:40.000000 | 11 | 13 | 2023-09-01 06:26:40+02:00 | 2 |
| 863307 | 863307 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:25:45.000000 | 28 | 20 | 2023-09-01 06:25:45+02:00 | -8 |
| 863306 | 863306 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:22:48.000000 | 11 | 17 | 2023-09-01 06:22:48+02:00 | 6 |
| 863305 | 863305 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:17:37.000000 | 15 | 20 | 2023-09-01 06:17:37+02:00 | 5 |
| 863304 | 863304 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:17:36.000000 | 25 | 22 | 2023-09-01 06:17:36+02:00 | -3 |
| 863303 | 863303 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:17:13.000000 | 25 | 20 | 2023-09-01 06:17:13+02:00 | -5 |
| 863302 | 863302 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:13:36.000000 | 31 | 27 | 2023-09-01 06:13:36+02:00 | -4 |
| 863301 | 863301 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:12:13.000000 | 16 | 18 | 2023-09-01 06:12:13+02:00 | 2 |
| 863300 | 863300 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:12:00.000000 | 24 | 25 | 2023-09-01 06:12:00+02:00 | 1 |
| 863299 | 863299 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 06:06:33.000000 | 26 | 22 | 2023-09-01 06:06:33+02:00 | -4 |
| 863298 | 863298 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:45:00.000000 | 17 | 17 | 2023-09-01 05:45:00+02:00 | 0 |
| 863297 | 863297 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:43:58.000000 | 20 | 19 | 2023-09-01 05:43:58+02:00 | -1 |
| 863296 | 863296 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:39:44.000000 | 24 | 25 | 2023-09-01 05:39:44+02:00 | 1 |
| 863295 | 863295 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:36:40.000000 | 29 | 24 | 2023-09-01 05:36:40+02:00 | -5 |
| 863294 | 863294 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:35:14.000000 | 17 | 19 | 2023-09-01 05:35:14+02:00 | 2 |
| 863293 | 863293 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:31:47.000000 | 19 | 16 | 2023-09-01 05:31:47+02:00 | -3 |
| 863292 | 863292 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:28:57.000000 | 17 | 10 | 2023-09-01 05:28:57+02:00 | -7 |
| 863291 | 863291 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:28:38.000000 | 24 | 22 | 2023-09-01 05:28:38+02:00 | -2 |
| 863290 | 863290 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:26:04.000000 | 29 | 22 | 2023-09-01 05:26:04+02:00 | -7 |
| 863289 | 863289 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:25:43.000000 | 16 | 15 | 2023-09-01 05:25:43+02:00 | -1 |
| 863288 | 863288 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:24:50.000000 | 14 | 14 | 2023-09-01 05:24:50+02:00 | 0 |
| 863287 | 863287 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:22:31.000000 | 20 | 19 | 2023-09-01 05:22:31+02:00 | -1 |
| 863286 | 863286 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:18:05.000000 | 26 | 27 | 2023-09-01 05:18:05+02:00 | 1 |
| 863285 | 863285 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:15:21.000000 | 30 | 26 | 2023-09-01 05:15:21+02:00 | -4 |
| 863284 | 863284 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:13:24.000000 | 20 | 17 | 2023-09-01 05:13:24+02:00 | -3 |
| 863283 | 863283 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:08:00.000000 | 18 | 22 | 2023-09-01 05:08:00+02:00 | 4 |
| 863282 | 863282 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:07:06.000000 | 31 | 27 | 2023-09-01 05:07:06+02:00 | -4 |
| 863281 | 863281 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:03:55.000000 | 26 | 20 | 2023-09-01 05:03:55+02:00 | -6 |
| 863280 | 863280 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:03:33.000000 | 26 | 25 | 2023-09-01 05:03:33+02:00 | -1 |
| 863279 | 863279 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:00:42.000000 | 17 | 17 | 2023-09-01 05:00:42+02:00 | 0 |
| 863278 | 863278 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 05:00:24.000000 | 23 | 20 | 2023-09-01 05:00:24+02:00 | -3 |
| 863277 | 863277 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:57:28.000000 | 24 | 17 | 2023-09-01 04:57:28+02:00 | -7 |
| 863276 | 863276 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:45:21.000000 | 14 | 17 | 2023-09-01 04:45:21+02:00 | 3 |
| 863275 | 863275 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:41:01.000000 | 11 | 13 | 2023-09-01 04:41:01+02:00 | 2 |
| 863274 | 863274 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:07:28.000000 | 28 | 23 | 2023-09-01 04:07:28+02:00 | -5 |
| 863273 | 863273 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 04:02:46.000000 | 26 | 24 | 2023-09-01 04:02:46+02:00 | -2 |
| 863272 | 863272 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 03:57:28.000000 | 25 | 15 | 2023-09-01 03:57:28+02:00 | -10 |
| 863271 | 863271 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 03:51:23.000000 | 12 | 18 | 2023-09-01 03:51:23+02:00 | 6 |
| 863270 | 863270 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 03:41:35.000000 | 23 | 22 | 2023-09-01 03:41:35+02:00 | -1 |
| 863269 | 863269 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-09-01 | 02:55:41.000000 | 26 | 22 | 2023-09-01 02:55:41+02:00 | -4 |
| 859946 | 859946 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 23:06:04.000000 | 17 | 22 | 2023-08-31 23:06:04+02:00 | 5 |
| 859945 | 859945 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:42:01.000000 | 25 | 18 | 2023-08-31 22:42:01+02:00 | -7 |
| 859944 | 859944 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:27:36.000000 | 18 | 17 | 2023-08-31 22:27:36+02:00 | -1 |
| 859943 | 859943 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:27:26.000000 | 23 | 22 | 2023-08-31 22:27:26+02:00 | -1 |
| 859942 | 859942 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:10:51.000000 | 23 | 20 | 2023-08-31 22:10:51+02:00 | -3 |
| 859941 | 859941 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:04:59.000000 | 28 | 16 | 2023-08-31 22:04:59+02:00 | -12 |
| 859940 | 859940 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 22:02:58.000000 | 20 | 23 | 2023-08-31 22:02:58+02:00 | 3 |
| 859939 | 859939 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:54:34.000000 | 37 | 31 | 2023-08-31 21:54:34+02:00 | -6 |
| 859938 | 859938 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:50:35.000000 | 12 | 20 | 2023-08-31 21:50:35+02:00 | 8 |
| 859937 | 859937 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:46:19.000000 | 17 | 18 | 2023-08-31 21:46:19+02:00 | 1 |
| 859936 | 859936 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:45:45.000000 | 17 | 24 | 2023-08-31 21:45:45+02:00 | 7 |
| 859935 | 859935 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:39:14.000000 | 17 | 17 | 2023-08-31 21:39:14+02:00 | 0 |
| 859934 | 859934 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:31:16.000000 | 24 | 22 | 2023-08-31 21:31:16+02:00 | -2 |
| 859933 | 859933 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:25:45.000000 | 17 | 16 | 2023-08-31 21:25:45+02:00 | -1 |
| 859932 | 859932 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:07:51.000000 | 17 | 12 | 2023-08-31 21:07:51+02:00 | -5 |
| 859931 | 859931 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 21:07:34.000000 | 19 | 17 | 2023-08-31 21:07:34+02:00 | -2 |
| 859930 | 859930 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:58:00.000000 | 19 | 11 | 2023-08-31 20:58:00+02:00 | -8 |
| 859929 | 859929 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:37:29.000000 | 33 | 29 | 2023-08-31 20:37:29+02:00 | -4 |
| 859928 | 859928 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:37:27.000000 | 37 | 29 | 2023-08-31 20:37:27+02:00 | -8 |
| 859927 | 859927 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:36:59.000000 | 24 | 29 | 2023-08-31 20:36:59+02:00 | 5 |
| 859926 | 859926 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:28:09.000000 | 26 | 25 | 2023-08-31 20:28:09+02:00 | -1 |
| 859925 | 859925 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:20:03.000000 | 26 | 19 | 2023-08-31 20:20:03+02:00 | -7 |
| 859924 | 859924 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 20:04:46.000000 | 32 | 25 | 2023-08-31 20:04:46+02:00 | -7 |
| 859923 | 859923 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:55:16.000000 | 28 | 24 | 2023-08-31 19:55:16+02:00 | -4 |
| 859922 | 859922 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:37:42.000000 | 14 | 14 | 2023-08-31 19:37:42+02:00 | 0 |
| 859921 | 859921 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:36:39.000000 | 10 | 17 | 2023-08-31 19:36:39+02:00 | 7 |
| 859920 | 859920 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:34:05.000000 | 32 | 35 | 2023-08-31 19:34:05+02:00 | 3 |
| 859919 | 859919 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:11:28.000000 | 20 | 20 | 2023-08-31 19:11:28+02:00 | 0 |
| 859918 | 859918 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 19:09:01.000000 | 24 | 28 | 2023-08-31 19:09:01+02:00 | 4 |
| 859917 | 859917 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 18:51:41.000000 | 23 | 18 | 2023-08-31 18:51:41+02:00 | -5 |
| 859916 | 859916 | Tangentenweg 2-25 | 25 | 2 | Betrieb | 2023-08-31 | 18:43:12.000000 | 11 | 10 | 2023-08-31 18:43:12+02:00 | -1 |
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");