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 = "3-13" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3733224 | 3733224 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:50:12.000000 | 11 | 4 | 2024-05-06 08:50:12+02:00 | -7 |
| 3733223 | 3733223 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:49:25.000000 | 10 | 11 | 2024-05-06 08:49:25+02:00 | 1 |
| 3733222 | 3733222 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:48:22.000000 | 24 | 33 | 2024-05-06 08:48:22+02:00 | 9 |
| 3733221 | 3733221 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:44:06.000000 | 26 | 30 | 2024-05-06 08:44:06+02:00 | 4 |
| 3733220 | 3733220 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:42:19.000000 | 17 | 18 | 2024-05-06 08:42:19+02:00 | 1 |
| 3733219 | 3733219 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:39:49.000000 | 27 | 29 | 2024-05-06 08:39:49+02:00 | 2 |
| 3733218 | 3733218 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:39:19.000000 | 24 | 26 | 2024-05-06 08:39:19+02:00 | 2 |
| 3733217 | 3733217 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:26:05.000000 | 26 | 25 | 2024-05-06 08:26:05+02:00 | -1 |
| 3733216 | 3733216 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:23:58.000000 | 41 | 38 | 2024-05-06 08:23:58+02:00 | -3 |
| 3733215 | 3733215 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:14:16.000000 | 25 | 19 | 2024-05-06 08:14:16+02:00 | -6 |
| 3733214 | 3733214 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:14:04.000000 | 25 | 18 | 2024-05-06 08:14:04+02:00 | -7 |
| 3733213 | 3733213 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:12:49.000000 | 30 | 22 | 2024-05-06 08:12:49+02:00 | -8 |
| 3733212 | 3733212 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:11:30.000000 | 8 | 11 | 2024-05-06 08:11:30+02:00 | 3 |
| 3733211 | 3733211 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:06:04.000000 | 26 | 22 | 2024-05-06 08:06:04+02:00 | -4 |
| 3733210 | 3733210 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 08:04:36.000000 | 20 | 23 | 2024-05-06 08:04:36+02:00 | 3 |
| 3733209 | 3733209 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:57:37.000000 | 19 | 29 | 2024-05-06 07:57:37+02:00 | 10 |
| 3733208 | 3733208 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:51:22.000000 | 2 | 3 | 2024-05-06 07:51:22+02:00 | 1 |
| 3733207 | 3733207 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:49:18.000000 | 11 | 27 | 2024-05-06 07:49:18+02:00 | 16 |
| 3733206 | 3733206 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:48:04.000000 | 36 | 32 | 2024-05-06 07:48:04+02:00 | -4 |
| 3733205 | 3733205 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:46:57.000000 | 14 | 30 | 2024-05-06 07:46:57+02:00 | 16 |
| 3733204 | 3733204 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:45:19.000000 | 15 | 19 | 2024-05-06 07:45:19+02:00 | 4 |
| 3733203 | 3733203 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:44:06.000000 | 2 | 4 | 2024-05-06 07:44:06+02:00 | 2 |
| 3733202 | 3733202 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:42:01.000000 | 19 | 27 | 2024-05-06 07:42:01+02:00 | 8 |
| 3733201 | 3733201 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:39:09.000000 | 31 | 29 | 2024-05-06 07:39:09+02:00 | -2 |
| 3733200 | 3733200 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:38:17.000000 | 23 | 24 | 2024-05-06 07:38:17+02:00 | 1 |
| 3733199 | 3733199 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:36:45.000000 | 2 | 5 | 2024-05-06 07:36:45+02:00 | 3 |
| 3733198 | 3733198 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:34:31.000000 | 29 | 26 | 2024-05-06 07:34:31+02:00 | -3 |
| 3733197 | 3733197 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:34:16.000000 | 7 | 3 | 2024-05-06 07:34:16+02:00 | -4 |
| 3733196 | 3733196 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:32:57.000000 | 24 | 18 | 2024-05-06 07:32:57+02:00 | -6 |
| 3733195 | 3733195 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:30:15.000000 | 30 | 28 | 2024-05-06 07:30:15+02:00 | -2 |
| 3733194 | 3733194 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:30:05.000000 | 28 | 29 | 2024-05-06 07:30:05+02:00 | 1 |
| 3733193 | 3733193 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:29:54.000000 | 29 | 25 | 2024-05-06 07:29:54+02:00 | -4 |
| 3733192 | 3733192 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:27:06.000000 | 17 | 22 | 2024-05-06 07:27:06+02:00 | 5 |
| 3733191 | 3733191 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:24:57.000000 | 30 | 28 | 2024-05-06 07:24:57+02:00 | -2 |
| 3733190 | 3733190 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:24:37.000000 | 15 | 19 | 2024-05-06 07:24:37+02:00 | 4 |
| 3733189 | 3733189 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:20:49.000000 | 3 | 7 | 2024-05-06 07:20:49+02:00 | 4 |
| 3733188 | 3733188 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:16:27.000000 | 27 | 26 | 2024-05-06 07:16:27+02:00 | -1 |
| 3733187 | 3733187 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:16:16.000000 | 18 | 20 | 2024-05-06 07:16:16+02:00 | 2 |
| 3733186 | 3733186 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:16:07.000000 | 28 | 26 | 2024-05-06 07:16:07+02:00 | -2 |
| 3733185 | 3733185 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:13:24.000000 | 29 | 29 | 2024-05-06 07:13:24+02:00 | 0 |
| 3733184 | 3733184 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:12:59.000000 | 28 | 28 | 2024-05-06 07:12:59+02:00 | 0 |
| 3733183 | 3733183 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:11:25.000000 | 24 | 24 | 2024-05-06 07:11:25+02:00 | 0 |
| 3733182 | 3733182 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:11:04.000000 | 3 | 8 | 2024-05-06 07:11:04+02:00 | 5 |
| 3733181 | 3733181 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:09:08.000000 | 5 | 3 | 2024-05-06 07:09:08+02:00 | -2 |
| 3733180 | 3733180 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:08:06.000000 | 2 | 5 | 2024-05-06 07:08:06+02:00 | 3 |
| 3733179 | 3733179 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 07:06:21.000000 | 23 | 26 | 2024-05-06 07:06:21+02:00 | 3 |
| 3733178 | 3733178 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:56:52.000000 | 25 | 17 | 2024-05-06 06:56:52+02:00 | -8 |
| 3733177 | 3733177 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:54:57.000000 | 36 | 31 | 2024-05-06 06:54:57+02:00 | -5 |
| 3733176 | 3733176 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:54:12.000000 | 24 | 25 | 2024-05-06 06:54:12+02:00 | 1 |
| 3733175 | 3733175 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:54:07.000000 | 29 | 30 | 2024-05-06 06:54:07+02:00 | 1 |
| 3733174 | 3733174 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:50:02.000000 | 23 | 24 | 2024-05-06 06:50:02+02:00 | 1 |
| 3733173 | 3733173 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:49:57.000000 | 31 | 25 | 2024-05-06 06:49:57+02:00 | -6 |
| 3733172 | 3733172 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:49:16.000000 | 10 | 20 | 2024-05-06 06:49:16+02:00 | 10 |
| 3733171 | 3733171 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:48:23.000000 | 9 | 4 | 2024-05-06 06:48:23+02:00 | -5 |
| 3733170 | 3733170 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:45:31.000000 | 29 | 20 | 2024-05-06 06:45:31+02:00 | -9 |
| 3733169 | 3733169 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:41:27.000000 | 24 | 29 | 2024-05-06 06:41:27+02:00 | 5 |
| 3733168 | 3733168 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:35:14.000000 | 25 | 27 | 2024-05-06 06:35:14+02:00 | 2 |
| 3733167 | 3733167 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:33:56.000000 | 36 | 39 | 2024-05-06 06:33:56+02:00 | 3 |
| 3733166 | 3733166 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:31:44.000000 | 29 | 32 | 2024-05-06 06:31:44+02:00 | 3 |
| 3733165 | 3733165 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:27:12.000000 | 26 | 27 | 2024-05-06 06:27:12+02:00 | 1 |
| 3733164 | 3733164 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:27:01.000000 | 27 | 25 | 2024-05-06 06:27:01+02:00 | -2 |
| 3733163 | 3733163 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:26:32.000000 | 24 | 40 | 2024-05-06 06:26:32+02:00 | 16 |
| 3733162 | 3733162 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:23:44.000000 | 31 | 34 | 2024-05-06 06:23:44+02:00 | 3 |
| 3733161 | 3733161 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:22:19.000000 | 24 | 22 | 2024-05-06 06:22:19+02:00 | -2 |
| 3733160 | 3733160 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:18:23.000000 | 16 | 24 | 2024-05-06 06:18:23+02:00 | 8 |
| 3733159 | 3733159 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:17:45.000000 | 18 | 17 | 2024-05-06 06:17:45+02:00 | -1 |
| 3733158 | 3733158 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:17:16.000000 | 26 | 22 | 2024-05-06 06:17:16+02:00 | -4 |
| 3733157 | 3733157 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:11:20.000000 | 20 | 27 | 2024-05-06 06:11:20+02:00 | 7 |
| 3733156 | 3733156 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:05:50.000000 | 30 | 34 | 2024-05-06 06:05:50+02:00 | 4 |
| 3733155 | 3733155 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:04:22.000000 | 23 | 30 | 2024-05-06 06:04:22+02:00 | 7 |
| 3733154 | 3733154 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:02:56.000000 | 24 | 20 | 2024-05-06 06:02:56+02:00 | -4 |
| 3733153 | 3733153 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 06:00:56.000000 | 25 | 17 | 2024-05-06 06:00:56+02:00 | -8 |
| 3733152 | 3733152 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:58:58.000000 | 30 | 27 | 2024-05-06 05:58:58+02:00 | -3 |
| 3733151 | 3733151 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:56:30.000000 | 19 | 17 | 2024-05-06 05:56:30+02:00 | -2 |
| 3733150 | 3733150 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:55:43.000000 | 8 | 23 | 2024-05-06 05:55:43+02:00 | 15 |
| 3733149 | 3733149 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:55:18.000000 | 28 | 25 | 2024-05-06 05:55:18+02:00 | -3 |
| 3733148 | 3733148 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:52:14.000000 | 26 | 23 | 2024-05-06 05:52:14+02:00 | -3 |
| 3733147 | 3733147 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:48:46.000000 | 20 | 23 | 2024-05-06 05:48:46+02:00 | 3 |
| 3733146 | 3733146 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:36:46.000000 | 33 | 31 | 2024-05-06 05:36:46+02:00 | -2 |
| 3733145 | 3733145 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:35:15.000000 | 18 | 24 | 2024-05-06 05:35:15+02:00 | 6 |
| 3733144 | 3733144 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:34:17.000000 | 25 | 19 | 2024-05-06 05:34:17+02:00 | -6 |
| 3733143 | 3733143 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:32:24.000000 | 26 | 27 | 2024-05-06 05:32:24+02:00 | 1 |
| 3733142 | 3733142 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:32:03.000000 | 28 | 24 | 2024-05-06 05:32:03+02:00 | -4 |
| 3733141 | 3733141 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:25:59.000000 | 14 | 24 | 2024-05-06 05:25:59+02:00 | 10 |
| 3733140 | 3733140 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:25:15.000000 | 23 | 31 | 2024-05-06 05:25:15+02:00 | 8 |
| 3733139 | 3733139 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:25:09.000000 | 32 | 29 | 2024-05-06 05:25:09+02:00 | -3 |
| 3733138 | 3733138 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:22:00.000000 | 8 | 23 | 2024-05-06 05:22:00+02:00 | 15 |
| 3733137 | 3733137 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:20:55.000000 | 14 | 28 | 2024-05-06 05:20:55+02:00 | 14 |
| 3733136 | 3733136 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:20:31.000000 | 26 | 25 | 2024-05-06 05:20:31+02:00 | -1 |
| 3733135 | 3733135 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:19:13.000000 | 25 | 40 | 2024-05-06 05:19:13+02:00 | 15 |
| 3733134 | 3733134 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:18:26.000000 | 28 | 27 | 2024-05-06 05:18:26+02:00 | -1 |
| 3733133 | 3733133 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:15:57.000000 | 6 | 4 | 2024-05-06 05:15:57+02:00 | -2 |
| 3733132 | 3733132 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 05:12:27.000000 | 10 | 25 | 2024-05-06 05:12:27+02:00 | 15 |
| 3733131 | 3733131 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:58:23.000000 | 27 | 23 | 2024-05-06 04:58:23+02:00 | -4 |
| 3733130 | 3733130 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:58:07.000000 | 28 | 26 | 2024-05-06 04:58:07+02:00 | -2 |
| 3733129 | 3733129 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:50:41.000000 | 27 | 25 | 2024-05-06 04:50:41+02:00 | -2 |
| 3733128 | 3733128 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:50:02.000000 | 32 | 27 | 2024-05-06 04:50:02+02:00 | -5 |
| 3733127 | 3733127 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:44:31.000000 | 28 | 29 | 2024-05-06 04:44:31+02:00 | 1 |
| 3733126 | 3733126 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:38:45.000000 | 26 | 22 | 2024-05-06 04:38:45+02:00 | -4 |
| 3733125 | 3733125 | Schorenweg 3-13 | 13 | 3 | Nachmessung | 2024-05-06 | 04:32:41.000000 | 31 | 31 | 2024-05-06 04:32:41+02:00 | 0 |
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");