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-26" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 8322089 | 8322089 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 09:00:11.000000 | 20 | 25 | 2024-10-17 09:00:11+02:00 | 5 |
| 8322088 | 8322088 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:59:40.000000 | 14 | 19 | 2024-10-17 08:59:40+02:00 | 5 |
| 8322087 | 8322087 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:58:39.000000 | 23 | 22 | 2024-10-17 08:58:39+02:00 | -1 |
| 8322086 | 8322086 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:58:21.000000 | 12 | 15 | 2024-10-17 08:58:21+02:00 | 3 |
| 8322085 | 8322085 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:42:40.000000 | 18 | 36 | 2024-10-17 08:42:40+02:00 | 18 |
| 8322084 | 8322084 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:33:15.000000 | 36 | 22 | 2024-10-17 08:33:15+02:00 | -14 |
| 8322083 | 8322083 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:32:10.000000 | 18 | 17 | 2024-10-17 08:32:10+02:00 | -1 |
| 8322082 | 8322082 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:31:23.000000 | 26 | 27 | 2024-10-17 08:31:23+02:00 | 1 |
| 8322081 | 8322081 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:30:23.000000 | 19 | 12 | 2024-10-17 08:30:23+02:00 | -7 |
| 8322080 | 8322080 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:20:17.000000 | 18 | 12 | 2024-10-17 08:20:17+02:00 | -6 |
| 8322079 | 8322079 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:20:04.000000 | 25 | 27 | 2024-10-17 08:20:04+02:00 | 2 |
| 8322078 | 8322078 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:18:12.000000 | 15 | 12 | 2024-10-17 08:18:12+02:00 | -3 |
| 8322077 | 8322077 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:18:03.000000 | 23 | 18 | 2024-10-17 08:18:03+02:00 | -5 |
| 8322076 | 8322076 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:17:44.000000 | 11 | 25 | 2024-10-17 08:17:44+02:00 | 14 |
| 8322075 | 8322075 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:14:49.000000 | 18 | 19 | 2024-10-17 08:14:49+02:00 | 1 |
| 8322074 | 8322074 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:06:13.000000 | 16 | 8 | 2024-10-17 08:06:13+02:00 | -8 |
| 8322073 | 8322073 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 08:05:42.000000 | 23 | 16 | 2024-10-17 08:05:42+02:00 | -7 |
| 8322072 | 8322072 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:55:41.000000 | 18 | 20 | 2024-10-17 07:55:41+02:00 | 2 |
| 8322071 | 8322071 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:42:07.000000 | 26 | 12 | 2024-10-17 07:42:07+02:00 | -14 |
| 8322070 | 8322070 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:42:01.000000 | 20 | 29 | 2024-10-17 07:42:01+02:00 | 9 |
| 8322069 | 8322069 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:41:25.000000 | 26 | 22 | 2024-10-17 07:41:25+02:00 | -4 |
| 8322068 | 8322068 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:40:06.000000 | 30 | 28 | 2024-10-17 07:40:06+02:00 | -2 |
| 8322067 | 8322067 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:38:49.000000 | 23 | 24 | 2024-10-17 07:38:49+02:00 | 1 |
| 8322066 | 8322066 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:32:53.000000 | 10 | 11 | 2024-10-17 07:32:53+02:00 | 1 |
| 8322065 | 8322065 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:30:31.000000 | 25 | 22 | 2024-10-17 07:30:31+02:00 | -3 |
| 8322063 | 8322063 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:28:38.000000 | 20 | 22 | 2024-10-17 07:28:38+02:00 | 2 |
| 8322064 | 8322064 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:28:38.000000 | 17 | 18 | 2024-10-17 07:28:38+02:00 | 1 |
| 8322062 | 8322062 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:24:53.000000 | 18 | 11 | 2024-10-17 07:24:53+02:00 | -7 |
| 8322061 | 8322061 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:24:38.000000 | 14 | 9 | 2024-10-17 07:24:38+02:00 | -5 |
| 8322060 | 8322060 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:22:03.000000 | 17 | 22 | 2024-10-17 07:22:03+02:00 | 5 |
| 8322059 | 8322059 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:18:26.000000 | 34 | 29 | 2024-10-17 07:18:26+02:00 | -5 |
| 8322058 | 8322058 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:12:48.000000 | 20 | 18 | 2024-10-17 07:12:48+02:00 | -2 |
| 8322057 | 8322057 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:10:39.000000 | 19 | 17 | 2024-10-17 07:10:39+02:00 | -2 |
| 8322056 | 8322056 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:07:43.000000 | 9 | 15 | 2024-10-17 07:07:43+02:00 | 6 |
| 8322055 | 8322055 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:07:24.000000 | 15 | 13 | 2024-10-17 07:07:24+02:00 | -2 |
| 8322054 | 8322054 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:07:07.000000 | 15 | 20 | 2024-10-17 07:07:07+02:00 | 5 |
| 8322053 | 8322053 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:05:52.000000 | 20 | 13 | 2024-10-17 07:05:52+02:00 | -7 |
| 8322052 | 8322052 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:05:16.000000 | 18 | 17 | 2024-10-17 07:05:16+02:00 | -1 |
| 8322051 | 8322051 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 07:00:37.000000 | 33 | 29 | 2024-10-17 07:00:37+02:00 | -4 |
| 8322050 | 8322050 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:54:30.000000 | 25 | 20 | 2024-10-17 06:54:30+02:00 | -5 |
| 8322049 | 8322049 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:54:22.000000 | 25 | 25 | 2024-10-17 06:54:22+02:00 | 0 |
| 8322048 | 8322048 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:54:18.000000 | 30 | 34 | 2024-10-17 06:54:18+02:00 | 4 |
| 8322047 | 8322047 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:52:14.000000 | 15 | 22 | 2024-10-17 06:52:14+02:00 | 7 |
| 8322046 | 8322046 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:46:26.000000 | 15 | 14 | 2024-10-17 06:46:26+02:00 | -1 |
| 8322045 | 8322045 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:46:10.000000 | 17 | 9 | 2024-10-17 06:46:10+02:00 | -8 |
| 8322044 | 8322044 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:45:53.000000 | 15 | 17 | 2024-10-17 06:45:53+02:00 | 2 |
| 8322043 | 8322043 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:45:25.000000 | 26 | 22 | 2024-10-17 06:45:25+02:00 | -4 |
| 8322042 | 8322042 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:44:08.000000 | 13 | 10 | 2024-10-17 06:44:08+02:00 | -3 |
| 8322041 | 8322041 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:41:32.000000 | 13 | 23 | 2024-10-17 06:41:32+02:00 | 10 |
| 8322040 | 8322040 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:40:28.000000 | 17 | 11 | 2024-10-17 06:40:28+02:00 | -6 |
| 8322039 | 8322039 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:37:05.000000 | 12 | 9 | 2024-10-17 06:37:05+02:00 | -3 |
| 8322038 | 8322038 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:35:15.000000 | 19 | 26 | 2024-10-17 06:35:15+02:00 | 7 |
| 8322037 | 8322037 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:34:31.000000 | 8 | 15 | 2024-10-17 06:34:31+02:00 | 7 |
| 8322036 | 8322036 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:33:42.000000 | 23 | 17 | 2024-10-17 06:33:42+02:00 | -6 |
| 8322035 | 8322035 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:31:08.000000 | 23 | 8 | 2024-10-17 06:31:08+02:00 | -15 |
| 8322034 | 8322034 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:28:23.000000 | 11 | 10 | 2024-10-17 06:28:23+02:00 | -1 |
| 8322033 | 8322033 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:26:17.000000 | 17 | 13 | 2024-10-17 06:26:17+02:00 | -4 |
| 8322032 | 8322032 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:25:48.000000 | 10 | 10 | 2024-10-17 06:25:48+02:00 | 0 |
| 8322031 | 8322031 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:21:20.000000 | 16 | 20 | 2024-10-17 06:21:20+02:00 | 4 |
| 8322030 | 8322030 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:20:01.000000 | 24 | 27 | 2024-10-17 06:20:01+02:00 | 3 |
| 8322029 | 8322029 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:18:53.000000 | 26 | 28 | 2024-10-17 06:18:53+02:00 | 2 |
| 8322028 | 8322028 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:07:45.000000 | 13 | 15 | 2024-10-17 06:07:45+02:00 | 2 |
| 8322027 | 8322027 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 06:03:04.000000 | 24 | 22 | 2024-10-17 06:03:04+02:00 | -2 |
| 8322026 | 8322026 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:57:23.000000 | 19 | 30 | 2024-10-17 05:57:23+02:00 | 11 |
| 8322025 | 8322025 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:56:25.000000 | 16 | 24 | 2024-10-17 05:56:25+02:00 | 8 |
| 8322024 | 8322024 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:51:54.000000 | 18 | 22 | 2024-10-17 05:51:54+02:00 | 4 |
| 8322023 | 8322023 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:51:38.000000 | 19 | 17 | 2024-10-17 05:51:38+02:00 | -2 |
| 8322022 | 8322022 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:51:23.000000 | 25 | 28 | 2024-10-17 05:51:23+02:00 | 3 |
| 8322021 | 8322021 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:51:10.000000 | 19 | 23 | 2024-10-17 05:51:10+02:00 | 4 |
| 8322020 | 8322020 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:46:18.000000 | 24 | 23 | 2024-10-17 05:46:18+02:00 | -1 |
| 8322019 | 8322019 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:43:40.000000 | 24 | 9 | 2024-10-17 05:43:40+02:00 | -15 |
| 8322018 | 8322018 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:42:00.000000 | 20 | 18 | 2024-10-17 05:42:00+02:00 | -2 |
| 8322017 | 8322017 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:40:53.000000 | 19 | 22 | 2024-10-17 05:40:53+02:00 | 3 |
| 8322016 | 8322016 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:38:57.000000 | 19 | 19 | 2024-10-17 05:38:57+02:00 | 0 |
| 8322015 | 8322015 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:36:16.000000 | 27 | 24 | 2024-10-17 05:36:16+02:00 | -3 |
| 8322014 | 8322014 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:35:32.000000 | 23 | 15 | 2024-10-17 05:35:32+02:00 | -8 |
| 8322013 | 8322013 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:35:22.000000 | 23 | 18 | 2024-10-17 05:35:22+02:00 | -5 |
| 8322012 | 8322012 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:25:04.000000 | 28 | 22 | 2024-10-17 05:25:04+02:00 | -6 |
| 8322011 | 8322011 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:22:44.000000 | 27 | 25 | 2024-10-17 05:22:44+02:00 | -2 |
| 8322010 | 8322010 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:20:21.000000 | 23 | 24 | 2024-10-17 05:20:21+02:00 | 1 |
| 8322009 | 8322009 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:17:48.000000 | 23 | 17 | 2024-10-17 05:17:48+02:00 | -6 |
| 8322008 | 8322008 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 05:15:28.000000 | 15 | 24 | 2024-10-17 05:15:28+02:00 | 9 |
| 8322007 | 8322007 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 04:57:53.000000 | 23 | 18 | 2024-10-17 04:57:53+02:00 | -5 |
| 8322006 | 8322006 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 04:49:32.000000 | 30 | 36 | 2024-10-17 04:49:32+02:00 | 6 |
| 8322005 | 8322005 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 01:37:02.000000 | 17 | 16 | 2024-10-17 01:37:02+02:00 | -1 |
| 8322004 | 8322004 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 00:22:17.000000 | 26 | 20 | 2024-10-17 00:22:17+02:00 | -6 |
| 8322003 | 8322003 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-17 | 00:06:15.000000 | 14 | 20 | 2024-10-17 00:06:15+02:00 | 6 |
| 8322002 | 8322002 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 23:41:13.000000 | 23 | 37 | 2024-10-16 23:41:13+02:00 | 14 |
| 8322001 | 8322001 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 23:40:13.000000 | 17 | 14 | 2024-10-16 23:40:13+02:00 | -3 |
| 8322000 | 8322000 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 22:55:00.000000 | 28 | 33 | 2024-10-16 22:55:00+02:00 | 5 |
| 8321999 | 8321999 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 22:50:27.000000 | 2 | 5 | 2024-10-16 22:50:27+02:00 | 3 |
| 8321998 | 8321998 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 22:49:31.000000 | 3 | 7 | 2024-10-16 22:49:31+02:00 | 4 |
| 8321996 | 8321996 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 22:13:18.000000 | 28 | 27 | 2024-10-16 22:13:18+02:00 | -1 |
| 8321997 | 8321997 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 22:13:18.000000 | 19 | 22 | 2024-10-16 22:13:18+02:00 | 3 |
| 8321995 | 8321995 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 22:13:00.000000 | 19 | 22 | 2024-10-16 22:13:00+02:00 | 3 |
| 8321994 | 8321994 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 22:01:58.000000 | 25 | 34 | 2024-10-16 22:01:58+02:00 | 9 |
| 8321993 | 8321993 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 21:58:29.000000 | 23 | 22 | 2024-10-16 21:58:29+02:00 | -1 |
| 8321992 | 8321992 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 21:54:46.000000 | 17 | 29 | 2024-10-16 21:54:46+02:00 | 12 |
| 8321991 | 8321991 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 21:52:15.000000 | 18 | 32 | 2024-10-16 21:52:15+02:00 | 14 |
| 8321990 | 8321990 | Tangentenweg 4-26 | 26 | 4 | Nachmessung | 2024-10-16 | 21:48:36.000000 | 19 | 24 | 2024-10-16 21:48:36+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");