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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15431198 | 15431198 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:10:18.000000 | 45 | 43 | 2024-10-17 06:10:18+02:00 | -2 |
| 15431197 | 15431197 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:09:54.000000 | 50 | 43 | 2024-10-17 06:09:54+02:00 | -7 |
| 15431196 | 15431196 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:09:34.000000 | 47 | 48 | 2024-10-17 06:09:34+02:00 | 1 |
| 15431195 | 15431195 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:09:27.000000 | 48 | 41 | 2024-10-17 06:09:27+02:00 | -7 |
| 15431194 | 15431194 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:09:20.000000 | 43 | 47 | 2024-10-17 06:09:20+02:00 | 4 |
| 15431193 | 15431193 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:08:39.000000 | 47 | 47 | 2024-10-17 06:08:39+02:00 | 0 |
| 15431192 | 15431192 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:08:33.000000 | 38 | 45 | 2024-10-17 06:08:33+02:00 | 7 |
| 15431191 | 15431191 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:08:22.000000 | 48 | 43 | 2024-10-17 06:08:22+02:00 | -5 |
| 15431190 | 15431190 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:08:09.000000 | 48 | 47 | 2024-10-17 06:08:09+02:00 | -1 |
| 15431189 | 15431189 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:08:02.000000 | 46 | 47 | 2024-10-17 06:08:02+02:00 | 1 |
| 15431188 | 15431188 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:07:56.000000 | 45 | 44 | 2024-10-17 06:07:56+02:00 | -1 |
| 15431187 | 15431187 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:07:13.000000 | 30 | 10 | 2024-10-17 06:07:13+02:00 | -20 |
| 15431186 | 15431186 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:07:09.000000 | 40 | 30 | 2024-10-17 06:07:09+02:00 | -10 |
| 15431185 | 15431185 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:07:06.000000 | 47 | 41 | 2024-10-17 06:07:06+02:00 | -6 |
| 15431184 | 15431184 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:07:01.000000 | 47 | 39 | 2024-10-17 06:07:01+02:00 | -8 |
| 15431183 | 15431183 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:06:53.000000 | 23 | 45 | 2024-10-17 06:06:53+02:00 | 22 |
| 15431182 | 15431182 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:06:14.000000 | 50 | 41 | 2024-10-17 06:06:14+02:00 | -9 |
| 15431181 | 15431181 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:06:07.000000 | 46 | 48 | 2024-10-17 06:06:07+02:00 | 2 |
| 15431180 | 15431180 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:48.000000 | 39 | 40 | 2024-10-17 06:05:48+02:00 | 1 |
| 15431179 | 15431179 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:41.000000 | 45 | 44 | 2024-10-17 06:05:41+02:00 | -1 |
| 15431178 | 15431178 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:34.000000 | 30 | 43 | 2024-10-17 06:05:34+02:00 | 13 |
| 15431177 | 15431177 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:31.000000 | 39 | 41 | 2024-10-17 06:05:31+02:00 | 2 |
| 15431176 | 15431176 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:24.000000 | 45 | 43 | 2024-10-17 06:05:24+02:00 | -2 |
| 15431175 | 15431175 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:17.000000 | 24 | 41 | 2024-10-17 06:05:17+02:00 | 17 |
| 15431174 | 15431174 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:15.000000 | 47 | 45 | 2024-10-17 06:05:15+02:00 | -2 |
| 15431173 | 15431173 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:08.000000 | 41 | 46 | 2024-10-17 06:05:08+02:00 | 5 |
| 15431172 | 15431172 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:05:05.000000 | 45 | 44 | 2024-10-17 06:05:05+02:00 | -1 |
| 15431171 | 15431171 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:58.000000 | 46 | 43 | 2024-10-17 06:04:58+02:00 | -3 |
| 15431170 | 15431170 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:56.000000 | 50 | 47 | 2024-10-17 06:04:56+02:00 | -3 |
| 15431169 | 15431169 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:50.000000 | 55 | 49 | 2024-10-17 06:04:50+02:00 | -6 |
| 15431168 | 15431168 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:45.000000 | 40 | 54 | 2024-10-17 06:04:45+02:00 | 14 |
| 15431167 | 15431167 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:37.000000 | 47 | 43 | 2024-10-17 06:04:37+02:00 | -4 |
| 15431166 | 15431166 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:31.000000 | 29 | 45 | 2024-10-17 06:04:31+02:00 | 16 |
| 15431165 | 15431165 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:29.000000 | 43 | 44 | 2024-10-17 06:04:29+02:00 | 1 |
| 15431163 | 15431163 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:21.000000 | 38 | 41 | 2024-10-17 06:04:21+02:00 | 3 |
| 15431164 | 15431164 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:21.000000 | 39 | 43 | 2024-10-17 06:04:21+02:00 | 4 |
| 15431162 | 15431162 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:15.000000 | 51 | 46 | 2024-10-17 06:04:15+02:00 | -5 |
| 15431161 | 15431161 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:09.000000 | 39 | 50 | 2024-10-17 06:04:09+02:00 | 11 |
| 15431160 | 15431160 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:04:06.000000 | 50 | 50 | 2024-10-17 06:04:06+02:00 | 0 |
| 15431159 | 15431159 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:03:45.000000 | 15 | 10 | 2024-10-17 06:03:45+02:00 | -5 |
| 15431158 | 15431158 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:02:47.000000 | 50 | 51 | 2024-10-17 06:02:47+02:00 | 1 |
| 15431156 | 15431156 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:02:35.000000 | 49 | 50 | 2024-10-17 06:02:35+02:00 | 1 |
| 15431157 | 15431157 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:02:35.000000 | 48 | 48 | 2024-10-17 06:02:35+02:00 | 0 |
| 15431155 | 15431155 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:02:06.000000 | 53 | 51 | 2024-10-17 06:02:06+02:00 | -2 |
| 15431154 | 15431154 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:02:01.000000 | 48 | 46 | 2024-10-17 06:02:01+02:00 | -2 |
| 15431153 | 15431153 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:01:54.000000 | 43 | 46 | 2024-10-17 06:01:54+02:00 | 3 |
| 15431152 | 15431152 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:01:00.000000 | 43 | 45 | 2024-10-17 06:01:00+02:00 | 2 |
| 15431151 | 15431151 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:00:30.000000 | 57 | 41 | 2024-10-17 06:00:30+02:00 | -16 |
| 15431150 | 15431150 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 06:00:20.000000 | 46 | 55 | 2024-10-17 06:00:20+02:00 | 9 |
| 15431149 | 15431149 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:59:43.000000 | 36 | 33 | 2024-10-17 05:59:43+02:00 | -3 |
| 15431148 | 15431148 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:59:35.000000 | 26 | 35 | 2024-10-17 05:59:35+02:00 | 9 |
| 15431147 | 15431147 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:59:26.000000 | 43 | 36 | 2024-10-17 05:59:26+02:00 | -7 |
| 15431146 | 15431146 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:59:19.000000 | 47 | 41 | 2024-10-17 05:59:19+02:00 | -6 |
| 15431145 | 15431145 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:59:17.000000 | 30 | 41 | 2024-10-17 05:59:17+02:00 | 11 |
| 15431144 | 15431144 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:58:51.000000 | 48 | 41 | 2024-10-17 05:58:51+02:00 | -7 |
| 15431143 | 15431143 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:58:43.000000 | 38 | 46 | 2024-10-17 05:58:43+02:00 | 8 |
| 15431142 | 15431142 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:58:32.000000 | 53 | 47 | 2024-10-17 05:58:32+02:00 | -6 |
| 15431141 | 15431141 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:58:26.000000 | 46 | 52 | 2024-10-17 05:58:26+02:00 | 6 |
| 15431140 | 15431140 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:58:06.000000 | 51 | 43 | 2024-10-17 05:58:06+02:00 | -8 |
| 15431139 | 15431139 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:57:57.000000 | 50 | 50 | 2024-10-17 05:57:57+02:00 | 0 |
| 15431138 | 15431138 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:57:40.000000 | 47 | 43 | 2024-10-17 05:57:40+02:00 | -4 |
| 15431137 | 15431137 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:57:27.000000 | 48 | 46 | 2024-10-17 05:57:27+02:00 | -2 |
| 15431136 | 15431136 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:57:07.000000 | 55 | 50 | 2024-10-17 05:57:07+02:00 | -5 |
| 15431135 | 15431135 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:57:02.000000 | 52 | 52 | 2024-10-17 05:57:02+02:00 | 0 |
| 15431134 | 15431134 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:56.000000 | 53 | 50 | 2024-10-17 05:56:56+02:00 | -3 |
| 15431133 | 15431133 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:36.000000 | 40 | 31 | 2024-10-17 05:56:36+02:00 | -9 |
| 15431132 | 15431132 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:34.000000 | 53 | 47 | 2024-10-17 05:56:34+02:00 | -6 |
| 15431131 | 15431131 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:28.000000 | 56 | 50 | 2024-10-17 05:56:28+02:00 | -6 |
| 15431130 | 15431130 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:23.000000 | 57 | 54 | 2024-10-17 05:56:23+02:00 | -3 |
| 15431129 | 15431129 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:56:09.000000 | 34 | 56 | 2024-10-17 05:56:09+02:00 | 22 |
| 15431128 | 15431128 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:55:26.000000 | 48 | 48 | 2024-10-17 05:55:26+02:00 | 0 |
| 15431127 | 15431127 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:55:21.000000 | 49 | 56 | 2024-10-17 05:55:21+02:00 | 7 |
| 15431126 | 15431126 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:55:15.000000 | 51 | 46 | 2024-10-17 05:55:15+02:00 | -5 |
| 15431125 | 15431125 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:55:07.000000 | 45 | 49 | 2024-10-17 05:55:07+02:00 | 4 |
| 15431124 | 15431124 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:54:49.000000 | 49 | 39 | 2024-10-17 05:54:49+02:00 | -10 |
| 15431123 | 15431123 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:54:43.000000 | 46 | 47 | 2024-10-17 05:54:43+02:00 | 1 |
| 15431122 | 15431122 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:54:27.000000 | 38 | 45 | 2024-10-17 05:54:27+02:00 | 7 |
| 15431121 | 15431121 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:54:21.000000 | 46 | 51 | 2024-10-17 05:54:21+02:00 | 5 |
| 15431120 | 15431120 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:53:44.000000 | 51 | 47 | 2024-10-17 05:53:44+02:00 | -4 |
| 15431119 | 15431119 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:53:06.000000 | 51 | 44 | 2024-10-17 05:53:06+02:00 | -7 |
| 15431118 | 15431118 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:53:00.000000 | 46 | 50 | 2024-10-17 05:53:00+02:00 | 4 |
| 15431117 | 15431117 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:45.000000 | 52 | 46 | 2024-10-17 05:52:45+02:00 | -6 |
| 15431116 | 15431116 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:39.000000 | 54 | 51 | 2024-10-17 05:52:39+02:00 | -3 |
| 15431115 | 15431115 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:35.000000 | 41 | 49 | 2024-10-17 05:52:35+02:00 | 8 |
| 15431114 | 15431114 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:14.000000 | 46 | 47 | 2024-10-17 05:52:14+02:00 | 1 |
| 15431113 | 15431113 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:12.000000 | 50 | 49 | 2024-10-17 05:52:12+02:00 | -1 |
| 15431112 | 15431112 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:06.000000 | 48 | 48 | 2024-10-17 05:52:06+02:00 | 0 |
| 15431111 | 15431111 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:52:03.000000 | 45 | 38 | 2024-10-17 05:52:03+02:00 | -7 |
| 15431110 | 15431110 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:56.000000 | 46 | 43 | 2024-10-17 05:51:56+02:00 | -3 |
| 15431109 | 15431109 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:44.000000 | 49 | 45 | 2024-10-17 05:51:44+02:00 | -4 |
| 15431108 | 15431108 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:36.000000 | 49 | 46 | 2024-10-17 05:51:36+02:00 | -3 |
| 15431107 | 15431107 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:21.000000 | 48 | 43 | 2024-10-17 05:51:21+02:00 | -5 |
| 15431106 | 15431106 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:12.000000 | 41 | 46 | 2024-10-17 05:51:12+02:00 | 5 |
| 15431105 | 15431105 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:51:04.000000 | 37 | 40 | 2024-10-17 05:51:04+02:00 | 3 |
| 15431104 | 15431104 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:56.000000 | 31 | 36 | 2024-10-17 05:50:56+02:00 | 5 |
| 15431103 | 15431103 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:51.000000 | 47 | 47 | 2024-10-17 05:50:51+02:00 | 0 |
| 15431102 | 15431102 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:45.000000 | 48 | 45 | 2024-10-17 05:50:45+02:00 | -3 |
| 15431101 | 15431101 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:38.000000 | 46 | 46 | 2024-10-17 05:50:38+02:00 | 0 |
| 15431100 | 15431100 | Kohlistieg 4-11 | 11 | 4 | Nachmessung | 2024-10-17 | 05:50:22.000000 | 37 | 39 | 2024-10-17 05:50:22+02:00 | 2 |
| 15431099 | 15431099 | 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");