Einzelmessungen
- Datum
- Datum
- Datum_Zeit
- Datum und Uhrzeit als Text
- Fahrzeuglänge
- Vom Radar gemessene Fahrzeuglänge
- Geschwindigkeit
- Geschwindigkeit in km/h
- Messung-ID
- Laufnummer der Messung; eine Messung beinhaltet alle Fahrten eines Messgeräts an einem Standort
- Richtung ID
- ID der Richtung; In einer Messung werden i.d.R. Fahrten in zwei Richtungen gemessen.
- Timestamp
- Datum und Uhrzeit
- Zeit
- Uhrzeit (hh:mm:ss) der gemessenen Fahrt
>10,000 rows count all where Messung-ID = 72 sorted by Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Timestamp (date)
| Link | rowid | Geschwindigkeit | Zeit | Datum | Richtung ID | Fahrzeuglänge | Messung-ID | Datum_Zeit | Timestamp ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 36169270 | 36169270 | 30 | 03:02:26 | 23.03.19 | 1 | 4.8 | 72 72 | 23.03.19 03:02:26 | 2019-03-23 03:02:26+01:00 |
| 36169269 | 36169269 | 36 | 02:59:26 | 23.03.19 | 1 | 4.8 | 72 72 | 23.03.19 02:59:26 | 2019-03-23 02:59:26+01:00 |
| 36169268 | 36169268 | 39 | 02:58:13 | 23.03.19 | 1 | 3.0 | 72 72 | 23.03.19 02:58:13 | 2019-03-23 02:58:13+01:00 |
| 36169267 | 36169267 | 34 | 02:54:34 | 23.03.19 | 1 | 4.1 | 72 72 | 23.03.19 02:54:34 | 2019-03-23 02:54:34+01:00 |
| 36169266 | 36169266 | 34 | 02:53:57 | 23.03.19 | 1 | 4.4 | 72 72 | 23.03.19 02:53:57 | 2019-03-23 02:53:57+01:00 |
| 36169265 | 36169265 | 29 | 02:52:29 | 23.03.19 | 1 | 4.6 | 72 72 | 23.03.19 02:52:29 | 2019-03-23 02:52:29+01:00 |
| 36169264 | 36169264 | 39 | 02:48:43 | 23.03.19 | 1 | 4.4 | 72 72 | 23.03.19 02:48:43 | 2019-03-23 02:48:43+01:00 |
| 36169263 | 36169263 | 41 | 02:40:17 | 23.03.19 | 1 | 4.1 | 72 72 | 23.03.19 02:40:17 | 2019-03-23 02:40:17+01:00 |
| 36169262 | 36169262 | 29 | 02:37:41 | 23.03.19 | 1 | 5.0 | 72 72 | 23.03.19 02:37:41 | 2019-03-23 02:37:41+01:00 |
| 36169261 | 36169261 | 34 | 02:37:10 | 23.03.19 | 1 | 4.8 | 72 72 | 23.03.19 02:37:10 | 2019-03-23 02:37:10+01:00 |
| 36169260 | 36169260 | 28 | 02:35:28 | 23.03.19 | 1 | 4.5 | 72 72 | 23.03.19 02:35:28 | 2019-03-23 02:35:28+01:00 |
| 36169259 | 36169259 | 37 | 02:27:09 | 23.03.19 | 1 | 5.0 | 72 72 | 23.03.19 02:27:09 | 2019-03-23 02:27:09+01:00 |
| 36169258 | 36169258 | 36 | 02:24:59 | 23.03.19 | 1 | 4.1 | 72 72 | 23.03.19 02:24:59 | 2019-03-23 02:24:59+01:00 |
| 36169257 | 36169257 | 30 | 02:16:57 | 23.03.19 | 1 | 4.7 | 72 72 | 23.03.19 02:16:57 | 2019-03-23 02:16:57+01:00 |
| 36169256 | 36169256 | 33 | 02:15:37 | 23.03.19 | 1 | 4.2 | 72 72 | 23.03.19 02:15:37 | 2019-03-23 02:15:37+01:00 |
| 36169255 | 36169255 | 28 | 02:15:31 | 23.03.19 | 1 | 4.7 | 72 72 | 23.03.19 02:15:31 | 2019-03-23 02:15:31+01:00 |
| 36169254 | 36169254 | 21 | 02:15:03 | 23.03.19 | 1 | 7.9 | 72 72 | 23.03.19 02:15:03 | 2019-03-23 02:15:03+01:00 |
| 36169253 | 36169253 | 40 | 02:13:17 | 23.03.19 | 1 | 5.7 | 72 72 | 23.03.19 02:13:17 | 2019-03-23 02:13:17+01:00 |
| 36169252 | 36169252 | 23 | 02:06:13 | 23.03.19 | 1 | 4.3 | 72 72 | 23.03.19 02:06:13 | 2019-03-23 02:06:13+01:00 |
| 36169251 | 36169251 | 28 | 02:05:45 | 23.03.19 | 1 | 4.6 | 72 72 | 23.03.19 02:05:45 | 2019-03-23 02:05:45+01:00 |
| 36169250 | 36169250 | 24 | 02:04:56 | 23.03.19 | 1 | 4.2 | 72 72 | 23.03.19 02:04:56 | 2019-03-23 02:04:56+01:00 |
| 36169249 | 36169249 | 21 | 02:04:53 | 23.03.19 | 1 | 4.2 | 72 72 | 23.03.19 02:04:53 | 2019-03-23 02:04:53+01:00 |
| 36169248 | 36169248 | 34 | 02:03:16 | 23.03.19 | 1 | 4.0 | 72 72 | 23.03.19 02:03:16 | 2019-03-23 02:03:16+01:00 |
| 36169247 | 36169247 | 28 | 02:03:10 | 23.03.19 | 1 | 4.7 | 72 72 | 23.03.19 02:03:10 | 2019-03-23 02:03:10+01:00 |
| 36169246 | 36169246 | 41 | 01:59:52 | 23.03.19 | 1 | 5.3 | 72 72 | 23.03.19 01:59:52 | 2019-03-23 01:59:52+01:00 |
| 36169245 | 36169245 | 31 | 01:56:27 | 23.03.19 | 1 | 3.5 | 72 72 | 23.03.19 01:56:27 | 2019-03-23 01:56:27+01:00 |
| 36169244 | 36169244 | 17 | 01:54:37 | 23.03.19 | 1 | 1.7 | 72 72 | 23.03.19 01:54:37 | 2019-03-23 01:54:37+01:00 |
| 36169243 | 36169243 | 37 | 01:54:10 | 23.03.19 | 1 | 4.7 | 72 72 | 23.03.19 01:54:10 | 2019-03-23 01:54:10+01:00 |
| 36169242 | 36169242 | 38 | 01:46:11 | 23.03.19 | 1 | 4.9 | 72 72 | 23.03.19 01:46:11 | 2019-03-23 01:46:11+01:00 |
| 36169241 | 36169241 | 32 | 01:45:10 | 23.03.19 | 1 | 5.4 | 72 72 | 23.03.19 01:45:10 | 2019-03-23 01:45:10+01:00 |
| 36169240 | 36169240 | 27 | 01:41:41 | 23.03.19 | 1 | 5.6 | 72 72 | 23.03.19 01:41:41 | 2019-03-23 01:41:41+01:00 |
| 36169239 | 36169239 | 14 | 01:39:53 | 23.03.19 | 1 | 2.6 | 72 72 | 23.03.19 01:39:53 | 2019-03-23 01:39:53+01:00 |
| 36169238 | 36169238 | 27 | 01:36:30 | 23.03.19 | 1 | 4.5 | 72 72 | 23.03.19 01:36:30 | 2019-03-23 01:36:30+01:00 |
| 36169237 | 36169237 | 31 | 01:36:10 | 23.03.19 | 1 | 4.7 | 72 72 | 23.03.19 01:36:10 | 2019-03-23 01:36:10+01:00 |
| 36169236 | 36169236 | 29 | 01:35:38 | 23.03.19 | 1 | 4.8 | 72 72 | 23.03.19 01:35:38 | 2019-03-23 01:35:38+01:00 |
| 36169235 | 36169235 | 33 | 01:34:41 | 23.03.19 | 1 | 4.5 | 72 72 | 23.03.19 01:34:41 | 2019-03-23 01:34:41+01:00 |
| 36169234 | 36169234 | 35 | 01:34:25 | 23.03.19 | 1 | 6.4 | 72 72 | 23.03.19 01:34:25 | 2019-03-23 01:34:25+01:00 |
| 36169233 | 36169233 | 34 | 01:31:03 | 23.03.19 | 1 | 5.0 | 72 72 | 23.03.19 01:31:03 | 2019-03-23 01:31:03+01:00 |
| 36169232 | 36169232 | 24 | 01:30:41 | 23.03.19 | 1 | 4.0 | 72 72 | 23.03.19 01:30:41 | 2019-03-23 01:30:41+01:00 |
| 36169231 | 36169231 | 19 | 01:28:09 | 23.03.19 | 1 | 1.6 | 72 72 | 23.03.19 01:28:09 | 2019-03-23 01:28:09+01:00 |
| 36169230 | 36169230 | 22 | 01:26:07 | 23.03.19 | 1 | 4.2 | 72 72 | 23.03.19 01:26:07 | 2019-03-23 01:26:07+01:00 |
| 36169229 | 36169229 | 41 | 01:23:27 | 23.03.19 | 1 | 3.8 | 72 72 | 23.03.19 01:23:27 | 2019-03-23 01:23:27+01:00 |
| 36169228 | 36169228 | 29 | 01:20:51 | 23.03.19 | 1 | 4.9 | 72 72 | 23.03.19 01:20:51 | 2019-03-23 01:20:51+01:00 |
| 36169227 | 36169227 | 34 | 01:16:11 | 23.03.19 | 1 | 4.2 | 72 72 | 23.03.19 01:16:11 | 2019-03-23 01:16:11+01:00 |
| 36169226 | 36169226 | 31 | 01:11:29 | 23.03.19 | 1 | 5.2 | 72 72 | 23.03.19 01:11:29 | 2019-03-23 01:11:29+01:00 |
| 36169225 | 36169225 | 29 | 01:11:13 | 23.03.19 | 1 | 4.9 | 72 72 | 23.03.19 01:11:13 | 2019-03-23 01:11:13+01:00 |
| 36169224 | 36169224 | 26 | 01:11:09 | 23.03.19 | 1 | 2.9 | 72 72 | 23.03.19 01:11:09 | 2019-03-23 01:11:09+01:00 |
| 36169223 | 36169223 | 10 | 01:10:54 | 23.03.19 | 1 | 1.5 | 72 72 | 23.03.19 01:10:54 | 2019-03-23 01:10:54+01:00 |
| 36169222 | 36169222 | 44 | 01:08:02 | 23.03.19 | 1 | 4.7 | 72 72 | 23.03.19 01:08:02 | 2019-03-23 01:08:02+01:00 |
| 36169221 | 36169221 | 25 | 01:07:44 | 23.03.19 | 1 | 3.8 | 72 72 | 23.03.19 01:07:44 | 2019-03-23 01:07:44+01:00 |
| 36169220 | 36169220 | 30 | 01:07:22 | 23.03.19 | 1 | 4.6 | 72 72 | 23.03.19 01:07:22 | 2019-03-23 01:07:22+01:00 |
| 36169219 | 36169219 | 26 | 01:04:41 | 23.03.19 | 1 | 4.2 | 72 72 | 23.03.19 01:04:41 | 2019-03-23 01:04:41+01:00 |
| 36169218 | 36169218 | 28 | 01:01:40 | 23.03.19 | 1 | 4.5 | 72 72 | 23.03.19 01:01:40 | 2019-03-23 01:01:40+01:00 |
| 36169217 | 36169217 | 39 | 01:01:07 | 23.03.19 | 1 | 5.6 | 72 72 | 23.03.19 01:01:07 | 2019-03-23 01:01:07+01:00 |
| 36169216 | 36169216 | 29 | 00:59:40 | 23.03.19 | 1 | 4.7 | 72 72 | 23.03.19 00:59:40 | 2019-03-23 00:59:40+01:00 |
| 36169215 | 36169215 | 10 | 00:53:49 | 23.03.19 | 1 | 1.1 | 72 72 | 23.03.19 00:53:49 | 2019-03-23 00:53:49+01:00 |
| 36169214 | 36169214 | 29 | 00:53:27 | 23.03.19 | 1 | 4.7 | 72 72 | 23.03.19 00:53:27 | 2019-03-23 00:53:27+01:00 |
| 36169213 | 36169213 | 35 | 00:51:31 | 23.03.19 | 1 | 4.4 | 72 72 | 23.03.19 00:51:31 | 2019-03-23 00:51:31+01:00 |
| 36169212 | 36169212 | 36 | 00:51:28 | 23.03.19 | 1 | 5.0 | 72 72 | 23.03.19 00:51:28 | 2019-03-23 00:51:28+01:00 |
| 36169211 | 36169211 | 23 | 00:50:45 | 23.03.19 | 1 | 4.9 | 72 72 | 23.03.19 00:50:45 | 2019-03-23 00:50:45+01:00 |
| 36169210 | 36169210 | 36 | 00:50:29 | 23.03.19 | 1 | 6.3 | 72 72 | 23.03.19 00:50:29 | 2019-03-23 00:50:29+01:00 |
| 36169209 | 36169209 | 29 | 00:50:26 | 23.03.19 | 1 | 5.5 | 72 72 | 23.03.19 00:50:26 | 2019-03-23 00:50:26+01:00 |
| 36169208 | 36169208 | 31 | 00:50:01 | 23.03.19 | 1 | 4.3 | 72 72 | 23.03.19 00:50:01 | 2019-03-23 00:50:01+01:00 |
| 36169207 | 36169207 | 29 | 00:47:24 | 23.03.19 | 1 | 4.9 | 72 72 | 23.03.19 00:47:24 | 2019-03-23 00:47:24+01:00 |
| 36169206 | 36169206 | 37 | 00:40:57 | 23.03.19 | 1 | 4.2 | 72 72 | 23.03.19 00:40:57 | 2019-03-23 00:40:57+01:00 |
| 36169205 | 36169205 | 34 | 00:39:39 | 23.03.19 | 1 | 4.5 | 72 72 | 23.03.19 00:39:39 | 2019-03-23 00:39:39+01:00 |
| 36169204 | 36169204 | 32 | 00:36:33 | 23.03.19 | 1 | 5.3 | 72 72 | 23.03.19 00:36:33 | 2019-03-23 00:36:33+01:00 |
| 36169203 | 36169203 | 25 | 00:35:08 | 23.03.19 | 1 | 4.2 | 72 72 | 23.03.19 00:35:08 | 2019-03-23 00:35:08+01:00 |
| 36169202 | 36169202 | 28 | 00:24:58 | 23.03.19 | 1 | 4.2 | 72 72 | 23.03.19 00:24:58 | 2019-03-23 00:24:58+01:00 |
| 36169201 | 36169201 | 28 | 00:24:55 | 23.03.19 | 1 | 4.9 | 72 72 | 23.03.19 00:24:55 | 2019-03-23 00:24:55+01:00 |
| 36169200 | 36169200 | 32 | 00:21:58 | 23.03.19 | 1 | 4.1 | 72 72 | 23.03.19 00:21:58 | 2019-03-23 00:21:58+01:00 |
| 36169199 | 36169199 | 21 | 00:20:37 | 23.03.19 | 1 | 5.3 | 72 72 | 23.03.19 00:20:37 | 2019-03-23 00:20:37+01:00 |
| 36169198 | 36169198 | 38 | 00:16:54 | 23.03.19 | 1 | 4.0 | 72 72 | 23.03.19 00:16:54 | 2019-03-23 00:16:54+01:00 |
| 36169197 | 36169197 | 33 | 00:16:28 | 23.03.19 | 1 | 4.4 | 72 72 | 23.03.19 00:16:28 | 2019-03-23 00:16:28+01:00 |
| 36169196 | 36169196 | 29 | 00:15:51 | 23.03.19 | 1 | 3.9 | 72 72 | 23.03.19 00:15:51 | 2019-03-23 00:15:51+01:00 |
| 36169195 | 36169195 | 17 | 00:15:02 | 23.03.19 | 1 | 2.3 | 72 72 | 23.03.19 00:15:02 | 2019-03-23 00:15:02+01:00 |
| 36169194 | 36169194 | 18 | 00:15:00 | 23.03.19 | 1 | 3.3 | 72 72 | 23.03.19 00:15:00 | 2019-03-23 00:15:00+01:00 |
| 36169193 | 36169193 | 31 | 00:10:33 | 23.03.19 | 1 | 4.9 | 72 72 | 23.03.19 00:10:33 | 2019-03-23 00:10:33+01:00 |
| 36169192 | 36169192 | 26 | 00:09:30 | 23.03.19 | 1 | 4.1 | 72 72 | 23.03.19 00:09:30 | 2019-03-23 00:09:30+01:00 |
| 36169191 | 36169191 | 26 | 00:09:23 | 23.03.19 | 1 | 4.2 | 72 72 | 23.03.19 00:09:23 | 2019-03-23 00:09:23+01:00 |
| 36169190 | 36169190 | 37 | 00:06:17 | 23.03.19 | 1 | 4.8 | 72 72 | 23.03.19 00:06:17 | 2019-03-23 00:06:17+01:00 |
| 36169189 | 36169189 | 22 | 00:05:49 | 23.03.19 | 1 | 3.8 | 72 72 | 23.03.19 00:05:49 | 2019-03-23 00:05:49+01:00 |
| 36169188 | 36169188 | 18 | 00:05:47 | 23.03.19 | 1 | 1.1 | 72 72 | 23.03.19 00:05:47 | 2019-03-23 00:05:47+01:00 |
| 36169187 | 36169187 | 32 | 00:01:28 | 23.03.19 | 1 | 5.7 | 72 72 | 23.03.19 00:01:28 | 2019-03-23 00:01:28+01:00 |
| 36169186 | 36169186 | 29 | 00:01:21 | 23.03.19 | 1 | 5.5 | 72 72 | 23.03.19 00:01:21 | 2019-03-23 00:01:21+01:00 |
| 36169185 | 36169185 | 21 | 00:01:16 | 23.03.19 | 1 | 5.4 | 72 72 | 23.03.19 00:01:16 | 2019-03-23 00:01:16+01:00 |
| 36169184 | 36169184 | 33 | 00:01:00 | 23.03.19 | 1 | 4.7 | 72 72 | 23.03.19 00:01:00 | 2019-03-23 00:01:00+01:00 |
| 36169183 | 36169183 | 27 | 00:00:04 | 23.03.19 | 1 | 5.3 | 72 72 | 23.03.19 00:00:04 | 2019-03-23 00:00:04+01:00 |
| 36169182 | 36169182 | 31 | 23:58:13 | 22.03.19 | 1 | 4.2 | 72 72 | 22.03.19 23:58:13 | 2019-03-22 23:58:13+01:00 |
| 36169181 | 36169181 | 22 | 23:57:58 | 22.03.19 | 1 | 3.7 | 72 72 | 22.03.19 23:57:58 | 2019-03-22 23:57:58+01:00 |
| 36169180 | 36169180 | 22 | 23:56:51 | 22.03.19 | 1 | 3.9 | 72 72 | 22.03.19 23:56:51 | 2019-03-22 23:56:51+01:00 |
| 36169179 | 36169179 | 24 | 23:51:07 | 22.03.19 | 1 | 3.7 | 72 72 | 22.03.19 23:51:07 | 2019-03-22 23:51:07+01:00 |
| 36169178 | 36169178 | 26 | 23:51:04 | 22.03.19 | 1 | 4.0 | 72 72 | 22.03.19 23:51:04 | 2019-03-22 23:51:04+01:00 |
| 36169177 | 36169177 | 22 | 23:50:23 | 22.03.19 | 1 | 4.2 | 72 72 | 22.03.19 23:50:23 | 2019-03-22 23:50:23+01:00 |
| 36169176 | 36169176 | 34 | 23:50:10 | 22.03.19 | 1 | 4.3 | 72 72 | 22.03.19 23:50:10 | 2019-03-22 23:50:10+01:00 |
| 36169175 | 36169175 | 28 | 23:48:01 | 22.03.19 | 1 | 4.2 | 72 72 | 22.03.19 23:48:01 | 2019-03-22 23:48:01+01:00 |
| 36169174 | 36169174 | 32 | 23:46:29 | 22.03.19 | 1 | 4.3 | 72 72 | 22.03.19 23:46:29 | 2019-03-22 23:46:29+01:00 |
| 36169173 | 36169173 | 20 | 23:45:35 | 22.03.19 | 1 | 0.8 | 72 72 | 22.03.19 23:45:35 | 2019-03-22 23:45:35+01:00 |
| 36169172 | 36169172 | 31 | 23:42:23 | 22.03.19 | 1 | 4.8 | 72 72 | 22.03.19 23:42:23 | 2019-03-22 23:42:23+01:00 |
| 36169171 | 36169171 | 34 | 23:40:44 | 22.03.19 | 1 | 5.6 | 72 72 | 22.03.19 23:40:44 | 2019-03-22 23:40:44+01:00 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE Einzelmessungen (
Geschwindigkeit INTEGER,
Zeit TEXT,
Datum TEXT,
"Richtung ID" INTEGER,
Fahrzeuglänge REAL,
"Messung-ID" INTEGER,
Datum_Zeit TEXT,
Timestamp TEXT,
FOREIGN KEY("Messung-ID") REFERENCES Kennzahlen_pro_Standort("ID")
ON UPDATE CASCADE ON DELETE CASCADE
);
CREATE INDEX idx_Einzelmessungen_timestamp ON "Einzelmessungen" ("Timestamp");
CREATE INDEX idx_Einzelmessungen_richtung_id ON "Einzelmessungen" ("Richtung ID");
CREATE INDEX idx_Einzelmessungen_messung_id ON "Einzelmessungen" ("Messung-ID");
CREATE INDEX idx_Einzelmessungen_datum ON "Einzelmessungen" ("Datum");
CREATE INDEX idx_Einzelmessungen_geschwindigkeit ON "Einzelmessungen" ("Geschwindigkeit");