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-11" sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3347190 | 3347190 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:10:18.000000 | 45 | 43 | 2024-10-17 06:10:18+02:00 | -2 |
| 3347189 | 3347189 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:09:54.000000 | 50 | 43 | 2024-10-17 06:09:54+02:00 | -7 |
| 3347188 | 3347188 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:09:34.000000 | 47 | 48 | 2024-10-17 06:09:34+02:00 | 1 |
| 3347187 | 3347187 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:09:27.000000 | 48 | 41 | 2024-10-17 06:09:27+02:00 | -7 |
| 3347186 | 3347186 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:09:20.000000 | 43 | 47 | 2024-10-17 06:09:20+02:00 | 4 |
| 3347185 | 3347185 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:08:39.000000 | 47 | 47 | 2024-10-17 06:08:39+02:00 | 0 |
| 3347184 | 3347184 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:08:33.000000 | 38 | 45 | 2024-10-17 06:08:33+02:00 | 7 |
| 3347183 | 3347183 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:08:22.000000 | 48 | 43 | 2024-10-17 06:08:22+02:00 | -5 |
| 3347182 | 3347182 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:08:09.000000 | 48 | 47 | 2024-10-17 06:08:09+02:00 | -1 |
| 3347181 | 3347181 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:08:02.000000 | 46 | 47 | 2024-10-17 06:08:02+02:00 | 1 |
| 3347180 | 3347180 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:07:56.000000 | 45 | 44 | 2024-10-17 06:07:56+02:00 | -1 |
| 3347179 | 3347179 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:07:13.000000 | 30 | 10 | 2024-10-17 06:07:13+02:00 | -20 |
| 3347178 | 3347178 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:07:09.000000 | 40 | 30 | 2024-10-17 06:07:09+02:00 | -10 |
| 3347177 | 3347177 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:07:06.000000 | 47 | 41 | 2024-10-17 06:07:06+02:00 | -6 |
| 3347176 | 3347176 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:07:01.000000 | 47 | 39 | 2024-10-17 06:07:01+02:00 | -8 |
| 3347175 | 3347175 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:06:53.000000 | 23 | 45 | 2024-10-17 06:06:53+02:00 | 22 |
| 3347174 | 3347174 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:06:14.000000 | 50 | 41 | 2024-10-17 06:06:14+02:00 | -9 |
| 3347173 | 3347173 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:06:07.000000 | 46 | 48 | 2024-10-17 06:06:07+02:00 | 2 |
| 3347172 | 3347172 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:48.000000 | 39 | 40 | 2024-10-17 06:05:48+02:00 | 1 |
| 3347171 | 3347171 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:41.000000 | 45 | 44 | 2024-10-17 06:05:41+02:00 | -1 |
| 3347170 | 3347170 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:34.000000 | 30 | 43 | 2024-10-17 06:05:34+02:00 | 13 |
| 3347169 | 3347169 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:31.000000 | 39 | 41 | 2024-10-17 06:05:31+02:00 | 2 |
| 3347168 | 3347168 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:24.000000 | 45 | 43 | 2024-10-17 06:05:24+02:00 | -2 |
| 3347167 | 3347167 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:17.000000 | 24 | 41 | 2024-10-17 06:05:17+02:00 | 17 |
| 3347166 | 3347166 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:15.000000 | 47 | 45 | 2024-10-17 06:05:15+02:00 | -2 |
| 3347165 | 3347165 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:08.000000 | 41 | 46 | 2024-10-17 06:05:08+02:00 | 5 |
| 3347164 | 3347164 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:05.000000 | 45 | 44 | 2024-10-17 06:05:05+02:00 | -1 |
| 3347163 | 3347163 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:58.000000 | 46 | 43 | 2024-10-17 06:04:58+02:00 | -3 |
| 3347162 | 3347162 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:56.000000 | 50 | 47 | 2024-10-17 06:04:56+02:00 | -3 |
| 3347161 | 3347161 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:50.000000 | 55 | 49 | 2024-10-17 06:04:50+02:00 | -6 |
| 3347160 | 3347160 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:45.000000 | 40 | 54 | 2024-10-17 06:04:45+02:00 | 14 |
| 3347159 | 3347159 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:37.000000 | 47 | 43 | 2024-10-17 06:04:37+02:00 | -4 |
| 3347158 | 3347158 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:31.000000 | 29 | 45 | 2024-10-17 06:04:31+02:00 | 16 |
| 3347157 | 3347157 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:29.000000 | 43 | 44 | 2024-10-17 06:04:29+02:00 | 1 |
| 3347155 | 3347155 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:21.000000 | 38 | 41 | 2024-10-17 06:04:21+02:00 | 3 |
| 3347156 | 3347156 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:21.000000 | 39 | 43 | 2024-10-17 06:04:21+02:00 | 4 |
| 3347154 | 3347154 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:15.000000 | 51 | 46 | 2024-10-17 06:04:15+02:00 | -5 |
| 3347153 | 3347153 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:09.000000 | 39 | 50 | 2024-10-17 06:04:09+02:00 | 11 |
| 3347152 | 3347152 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:06.000000 | 50 | 50 | 2024-10-17 06:04:06+02:00 | 0 |
| 3347151 | 3347151 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:03:45.000000 | 15 | 10 | 2024-10-17 06:03:45+02:00 | -5 |
| 3347150 | 3347150 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:02:47.000000 | 50 | 51 | 2024-10-17 06:02:47+02:00 | 1 |
| 3347148 | 3347148 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:02:35.000000 | 49 | 50 | 2024-10-17 06:02:35+02:00 | 1 |
| 3347149 | 3347149 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:02:35.000000 | 48 | 48 | 2024-10-17 06:02:35+02:00 | 0 |
| 3347147 | 3347147 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:02:06.000000 | 53 | 51 | 2024-10-17 06:02:06+02:00 | -2 |
| 3347146 | 3347146 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:02:01.000000 | 48 | 46 | 2024-10-17 06:02:01+02:00 | -2 |
| 3347145 | 3347145 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:01:54.000000 | 43 | 46 | 2024-10-17 06:01:54+02:00 | 3 |
| 3347144 | 3347144 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:01:00.000000 | 43 | 45 | 2024-10-17 06:01:00+02:00 | 2 |
| 3347143 | 3347143 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:00:30.000000 | 57 | 41 | 2024-10-17 06:00:30+02:00 | -16 |
| 3347142 | 3347142 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:00:20.000000 | 46 | 55 | 2024-10-17 06:00:20+02:00 | 9 |
| 3347141 | 3347141 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:59:43.000000 | 36 | 33 | 2024-10-17 05:59:43+02:00 | -3 |
| 3347140 | 3347140 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:59:35.000000 | 26 | 35 | 2024-10-17 05:59:35+02:00 | 9 |
| 3347139 | 3347139 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:59:26.000000 | 43 | 36 | 2024-10-17 05:59:26+02:00 | -7 |
| 3347138 | 3347138 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:59:19.000000 | 47 | 41 | 2024-10-17 05:59:19+02:00 | -6 |
| 3347137 | 3347137 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:59:17.000000 | 30 | 41 | 2024-10-17 05:59:17+02:00 | 11 |
| 3347136 | 3347136 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:58:51.000000 | 48 | 41 | 2024-10-17 05:58:51+02:00 | -7 |
| 3347135 | 3347135 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:58:43.000000 | 38 | 46 | 2024-10-17 05:58:43+02:00 | 8 |
| 3347134 | 3347134 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:58:32.000000 | 53 | 47 | 2024-10-17 05:58:32+02:00 | -6 |
| 3347133 | 3347133 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:58:26.000000 | 46 | 52 | 2024-10-17 05:58:26+02:00 | 6 |
| 3347132 | 3347132 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:58:06.000000 | 51 | 43 | 2024-10-17 05:58:06+02:00 | -8 |
| 3347131 | 3347131 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:57:57.000000 | 50 | 50 | 2024-10-17 05:57:57+02:00 | 0 |
| 3347130 | 3347130 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:57:40.000000 | 47 | 43 | 2024-10-17 05:57:40+02:00 | -4 |
| 3347129 | 3347129 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:57:27.000000 | 48 | 46 | 2024-10-17 05:57:27+02:00 | -2 |
| 3347128 | 3347128 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:57:07.000000 | 55 | 50 | 2024-10-17 05:57:07+02:00 | -5 |
| 3347127 | 3347127 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:57:02.000000 | 52 | 52 | 2024-10-17 05:57:02+02:00 | 0 |
| 3347126 | 3347126 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:56.000000 | 53 | 50 | 2024-10-17 05:56:56+02:00 | -3 |
| 3347125 | 3347125 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:36.000000 | 40 | 31 | 2024-10-17 05:56:36+02:00 | -9 |
| 3347124 | 3347124 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:34.000000 | 53 | 47 | 2024-10-17 05:56:34+02:00 | -6 |
| 3347123 | 3347123 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:28.000000 | 56 | 50 | 2024-10-17 05:56:28+02:00 | -6 |
| 3347122 | 3347122 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:23.000000 | 57 | 54 | 2024-10-17 05:56:23+02:00 | -3 |
| 3347121 | 3347121 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:09.000000 | 34 | 56 | 2024-10-17 05:56:09+02:00 | 22 |
| 3347120 | 3347120 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:55:26.000000 | 48 | 48 | 2024-10-17 05:55:26+02:00 | 0 |
| 3347119 | 3347119 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:55:21.000000 | 49 | 56 | 2024-10-17 05:55:21+02:00 | 7 |
| 3347118 | 3347118 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:55:15.000000 | 51 | 46 | 2024-10-17 05:55:15+02:00 | -5 |
| 3347117 | 3347117 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:55:07.000000 | 45 | 49 | 2024-10-17 05:55:07+02:00 | 4 |
| 3347116 | 3347116 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:54:49.000000 | 49 | 39 | 2024-10-17 05:54:49+02:00 | -10 |
| 3347115 | 3347115 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:54:43.000000 | 46 | 47 | 2024-10-17 05:54:43+02:00 | 1 |
| 3347114 | 3347114 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:54:27.000000 | 38 | 45 | 2024-10-17 05:54:27+02:00 | 7 |
| 3347113 | 3347113 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:54:21.000000 | 46 | 51 | 2024-10-17 05:54:21+02:00 | 5 |
| 3347112 | 3347112 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:53:44.000000 | 51 | 47 | 2024-10-17 05:53:44+02:00 | -4 |
| 3347111 | 3347111 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:53:06.000000 | 51 | 44 | 2024-10-17 05:53:06+02:00 | -7 |
| 3347110 | 3347110 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:53:00.000000 | 46 | 50 | 2024-10-17 05:53:00+02:00 | 4 |
| 3347109 | 3347109 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:45.000000 | 52 | 46 | 2024-10-17 05:52:45+02:00 | -6 |
| 3347108 | 3347108 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:39.000000 | 54 | 51 | 2024-10-17 05:52:39+02:00 | -3 |
| 3347107 | 3347107 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:35.000000 | 41 | 49 | 2024-10-17 05:52:35+02:00 | 8 |
| 3347106 | 3347106 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:14.000000 | 46 | 47 | 2024-10-17 05:52:14+02:00 | 1 |
| 3347105 | 3347105 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:12.000000 | 50 | 49 | 2024-10-17 05:52:12+02:00 | -1 |
| 3347104 | 3347104 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:06.000000 | 48 | 48 | 2024-10-17 05:52:06+02:00 | 0 |
| 3347103 | 3347103 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:03.000000 | 45 | 38 | 2024-10-17 05:52:03+02:00 | -7 |
| 3347102 | 3347102 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:56.000000 | 46 | 43 | 2024-10-17 05:51:56+02:00 | -3 |
| 3347101 | 3347101 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:44.000000 | 49 | 45 | 2024-10-17 05:51:44+02:00 | -4 |
| 3347100 | 3347100 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:36.000000 | 49 | 46 | 2024-10-17 05:51:36+02:00 | -3 |
| 3347099 | 3347099 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:21.000000 | 48 | 43 | 2024-10-17 05:51:21+02:00 | -5 |
| 3347098 | 3347098 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:12.000000 | 41 | 46 | 2024-10-17 05:51:12+02:00 | 5 |
| 3347097 | 3347097 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:04.000000 | 37 | 40 | 2024-10-17 05:51:04+02:00 | 3 |
| 3347096 | 3347096 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:56.000000 | 31 | 36 | 2024-10-17 05:50:56+02:00 | 5 |
| 3347095 | 3347095 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:51.000000 | 47 | 47 | 2024-10-17 05:50:51+02:00 | 0 |
| 3347094 | 3347094 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:45.000000 | 48 | 45 | 2024-10-17 05:50:45+02:00 | -3 |
| 3347093 | 3347093 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:38.000000 | 46 | 46 | 2024-10-17 05:50:38+02:00 | 0 |
| 3347092 | 3347092 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:22.000000 | 37 | 39 | 2024-10-17 05:50:22+02:00 | 2 |
| 3347091 | 3347091 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:14.000000 | 16 | 36 | 2024-10-17 05:50:14+02:00 | 20 |
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");