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 = 86 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 34264209 | 34264209 | 36 | 14:07:53 | 10.02.20 | 1 | 5.1 | 86 86 | 10.02.20 14:07:53 | 2020-02-10 14:07:53+01:00 |
| 34264208 | 34264208 | 33 | 14:07:16 | 10.02.20 | 1 | 2.2 | 86 86 | 10.02.20 14:07:16 | 2020-02-10 14:07:16+01:00 |
| 34264207 | 34264207 | 35 | 14:06:28 | 10.02.20 | 1 | 4.1 | 86 86 | 10.02.20 14:06:28 | 2020-02-10 14:06:28+01:00 |
| 34264206 | 34264206 | 35 | 14:06:26 | 10.02.20 | 1 | 7.3 | 86 86 | 10.02.20 14:06:26 | 2020-02-10 14:06:26+01:00 |
| 34264205 | 34264205 | 39 | 14:06:24 | 10.02.20 | 1 | 11.2 | 86 86 | 10.02.20 14:06:24 | 2020-02-10 14:06:24+01:00 |
| 34264204 | 34264204 | 41 | 14:06:21 | 10.02.20 | 1 | 4.0 | 86 86 | 10.02.20 14:06:21 | 2020-02-10 14:06:21+01:00 |
| 34264203 | 34264203 | 44 | 14:06:17 | 10.02.20 | 1 | 7.3 | 86 86 | 10.02.20 14:06:17 | 2020-02-10 14:06:17+01:00 |
| 34264202 | 34264202 | 46 | 14:06:13 | 10.02.20 | 1 | 3.8 | 86 86 | 10.02.20 14:06:13 | 2020-02-10 14:06:13+01:00 |
| 34264201 | 34264201 | 48 | 14:06:09 | 10.02.20 | 1 | 4.0 | 86 86 | 10.02.20 14:06:09 | 2020-02-10 14:06:09+01:00 |
| 34264200 | 34264200 | 33 | 14:05:21 | 10.02.20 | 1 | 4.5 | 86 86 | 10.02.20 14:05:21 | 2020-02-10 14:05:21+01:00 |
| 34264199 | 34264199 | 35 | 14:05:18 | 10.02.20 | 1 | 3.7 | 86 86 | 10.02.20 14:05:18 | 2020-02-10 14:05:18+01:00 |
| 34264198 | 34264198 | 37 | 14:05:17 | 10.02.20 | 1 | 6.8 | 86 86 | 10.02.20 14:05:17 | 2020-02-10 14:05:17+01:00 |
| 34264197 | 34264197 | 47 | 14:05:04 | 10.02.20 | 1 | 7.0 | 86 86 | 10.02.20 14:05:04 | 2020-02-10 14:05:04+01:00 |
| 34264196 | 34264196 | 42 | 14:05:02 | 10.02.20 | 1 | 6.0 | 86 86 | 10.02.20 14:05:02 | 2020-02-10 14:05:02+01:00 |
| 34264195 | 34264195 | 45 | 14:05:01 | 10.02.20 | 1 | 4.3 | 86 86 | 10.02.20 14:05:01 | 2020-02-10 14:05:01+01:00 |
| 34264194 | 34264194 | 44 | 14:04:39 | 10.02.20 | 1 | 5.8 | 86 86 | 10.02.20 14:04:39 | 2020-02-10 14:04:39+01:00 |
| 34264193 | 34264193 | 44 | 14:04:11 | 10.02.20 | 1 | 4.6 | 86 86 | 10.02.20 14:04:11 | 2020-02-10 14:04:11+01:00 |
| 34264192 | 34264192 | 40 | 14:03:58 | 10.02.20 | 1 | 4.2 | 86 86 | 10.02.20 14:03:58 | 2020-02-10 14:03:58+01:00 |
| 34264191 | 34264191 | 45 | 14:03:53 | 10.02.20 | 1 | 5.1 | 86 86 | 10.02.20 14:03:53 | 2020-02-10 14:03:53+01:00 |
| 34264190 | 34264190 | 39 | 14:03:42 | 10.02.20 | 1 | 6.1 | 86 86 | 10.02.20 14:03:42 | 2020-02-10 14:03:42+01:00 |
| 34264189 | 34264189 | 41 | 14:03:24 | 10.02.20 | 1 | 4.1 | 86 86 | 10.02.20 14:03:24 | 2020-02-10 14:03:24+01:00 |
| 34264188 | 34264188 | 40 | 14:03:15 | 10.02.20 | 1 | 4.2 | 86 86 | 10.02.20 14:03:15 | 2020-02-10 14:03:15+01:00 |
| 34264187 | 34264187 | 44 | 14:03:10 | 10.02.20 | 1 | 5.3 | 86 86 | 10.02.20 14:03:10 | 2020-02-10 14:03:10+01:00 |
| 34264186 | 34264186 | 44 | 14:03:07 | 10.02.20 | 1 | 7.7 | 86 86 | 10.02.20 14:03:07 | 2020-02-10 14:03:07+01:00 |
| 34264185 | 34264185 | 42 | 14:03:03 | 10.02.20 | 1 | 3.8 | 86 86 | 10.02.20 14:03:03 | 2020-02-10 14:03:03+01:00 |
| 34264184 | 34264184 | 33 | 14:02:58 | 10.02.20 | 1 | 7.0 | 86 86 | 10.02.20 14:02:58 | 2020-02-10 14:02:58+01:00 |
| 34264183 | 34264183 | 48 | 14:02:47 | 10.02.20 | 1 | 4.9 | 86 86 | 10.02.20 14:02:47 | 2020-02-10 14:02:47+01:00 |
| 34264182 | 34264182 | 39 | 14:02:10 | 10.02.20 | 1 | 3.1 | 86 86 | 10.02.20 14:02:10 | 2020-02-10 14:02:10+01:00 |
| 34264181 | 34264181 | 40 | 14:02:06 | 10.02.20 | 1 | 5.9 | 86 86 | 10.02.20 14:02:06 | 2020-02-10 14:02:06+01:00 |
| 34264180 | 34264180 | 41 | 14:02:04 | 10.02.20 | 1 | 7.4 | 86 86 | 10.02.20 14:02:04 | 2020-02-10 14:02:04+01:00 |
| 34264179 | 34264179 | 42 | 14:02:01 | 10.02.20 | 1 | 7.2 | 86 86 | 10.02.20 14:02:01 | 2020-02-10 14:02:01+01:00 |
| 34264178 | 34264178 | 44 | 14:01:59 | 10.02.20 | 1 | 4.6 | 86 86 | 10.02.20 14:01:59 | 2020-02-10 14:01:59+01:00 |
| 34264177 | 34264177 | 43 | 14:01:58 | 10.02.20 | 1 | 4.6 | 86 86 | 10.02.20 14:01:58 | 2020-02-10 14:01:58+01:00 |
| 34264176 | 34264176 | 34 | 14:01:34 | 10.02.20 | 1 | 20.1 | 86 86 | 10.02.20 14:01:34 | 2020-02-10 14:01:34+01:00 |
| 34264175 | 34264175 | 54 | 14:01:03 | 10.02.20 | 1 | 3.1 | 86 86 | 10.02.20 14:01:03 | 2020-02-10 14:01:03+01:00 |
| 34264174 | 34264174 | 43 | 14:00:57 | 10.02.20 | 1 | 3.2 | 86 86 | 10.02.20 14:00:57 | 2020-02-10 14:00:57+01:00 |
| 34264173 | 34264173 | 39 | 14:00:19 | 10.02.20 | 1 | 4.4 | 86 86 | 10.02.20 14:00:19 | 2020-02-10 14:00:19+01:00 |
| 34264172 | 34264172 | 36 | 14:00:16 | 10.02.20 | 1 | 6.5 | 86 86 | 10.02.20 14:00:16 | 2020-02-10 14:00:16+01:00 |
| 34264171 | 34264171 | 33 | 14:00:15 | 10.02.20 | 1 | 6.1 | 86 86 | 10.02.20 14:00:15 | 2020-02-10 14:00:15+01:00 |
| 34264170 | 34264170 | 35 | 14:00:13 | 10.02.20 | 1 | 4.2 | 86 86 | 10.02.20 14:00:13 | 2020-02-10 14:00:13+01:00 |
| 34264169 | 34264169 | 37 | 14:00:10 | 10.02.20 | 1 | 4.2 | 86 86 | 10.02.20 14:00:10 | 2020-02-10 14:00:10+01:00 |
| 34264168 | 34264168 | 38 | 14:00:08 | 10.02.20 | 1 | 9.5 | 86 86 | 10.02.20 14:00:08 | 2020-02-10 14:00:08+01:00 |
| 34264167 | 34264167 | 36 | 14:00:04 | 10.02.20 | 1 | 4.0 | 86 86 | 10.02.20 14:00:04 | 2020-02-10 14:00:04+01:00 |
| 34264166 | 34264166 | 38 | 14:00:03 | 10.02.20 | 1 | 4.8 | 86 86 | 10.02.20 14:00:03 | 2020-02-10 14:00:03+01:00 |
| 34264165 | 34264165 | 41 | 14:00:00 | 10.02.20 | 1 | 4.1 | 86 86 | 10.02.20 14:00:00 | 2020-02-10 14:00:00+01:00 |
| 34264164 | 34264164 | 36 | 13:59:12 | 10.02.20 | 1 | 5.6 | 86 86 | 10.02.20 13:59:12 | 2020-02-10 13:59:12+01:00 |
| 34264163 | 34264163 | 37 | 13:59:10 | 10.02.20 | 1 | 10.0 | 86 86 | 10.02.20 13:59:10 | 2020-02-10 13:59:10+01:00 |
| 34264162 | 34264162 | 35 | 13:59:08 | 10.02.20 | 1 | 3.5 | 86 86 | 10.02.20 13:59:08 | 2020-02-10 13:59:08+01:00 |
| 34264161 | 34264161 | 39 | 13:59:06 | 10.02.20 | 1 | 6.4 | 86 86 | 10.02.20 13:59:06 | 2020-02-10 13:59:06+01:00 |
| 34264160 | 34264160 | 44 | 13:59:02 | 10.02.20 | 1 | 7.3 | 86 86 | 10.02.20 13:59:02 | 2020-02-10 13:59:02+01:00 |
| 34264159 | 34264159 | 44 | 13:59:01 | 10.02.20 | 1 | 7.2 | 86 86 | 10.02.20 13:59:01 | 2020-02-10 13:59:01+01:00 |
| 34264158 | 34264158 | 47 | 13:58:59 | 10.02.20 | 1 | 6.6 | 86 86 | 10.02.20 13:58:59 | 2020-02-10 13:58:59+01:00 |
| 34264157 | 34264157 | 53 | 13:58:55 | 10.02.20 | 1 | 6.5 | 86 86 | 10.02.20 13:58:55 | 2020-02-10 13:58:55+01:00 |
| 34264156 | 34264156 | 44 | 13:58:50 | 10.02.20 | 1 | 8.0 | 86 86 | 10.02.20 13:58:50 | 2020-02-10 13:58:50+01:00 |
| 34264155 | 34264155 | 41 | 13:58:37 | 10.02.20 | 1 | 4.7 | 86 86 | 10.02.20 13:58:37 | 2020-02-10 13:58:37+01:00 |
| 34264154 | 34264154 | 45 | 13:58:20 | 10.02.20 | 1 | 5.7 | 86 86 | 10.02.20 13:58:20 | 2020-02-10 13:58:20+01:00 |
| 34264153 | 34264153 | 43 | 13:58:14 | 10.02.20 | 1 | 4.4 | 86 86 | 10.02.20 13:58:14 | 2020-02-10 13:58:14+01:00 |
| 34264152 | 34264152 | 43 | 13:57:32 | 10.02.20 | 1 | 6.4 | 86 86 | 10.02.20 13:57:32 | 2020-02-10 13:57:32+01:00 |
| 34264151 | 34264151 | 40 | 13:57:30 | 10.02.20 | 1 | 6.8 | 86 86 | 10.02.20 13:57:30 | 2020-02-10 13:57:30+01:00 |
| 34264150 | 34264150 | 42 | 13:57:29 | 10.02.20 | 1 | 8.9 | 86 86 | 10.02.20 13:57:29 | 2020-02-10 13:57:29+01:00 |
| 34264149 | 34264149 | 43 | 13:57:25 | 10.02.20 | 1 | 5.4 | 86 86 | 10.02.20 13:57:25 | 2020-02-10 13:57:25+01:00 |
| 34264148 | 34264148 | 25 | 13:56:11 | 10.02.20 | 1 | 9.3 | 86 86 | 10.02.20 13:56:11 | 2020-02-10 13:56:11+01:00 |
| 34264147 | 34264147 | 41 | 13:56:05 | 10.02.20 | 1 | 4.4 | 86 86 | 10.02.20 13:56:05 | 2020-02-10 13:56:05+01:00 |
| 34264146 | 34264146 | 43 | 13:56:03 | 10.02.20 | 1 | 4.8 | 86 86 | 10.02.20 13:56:03 | 2020-02-10 13:56:03+01:00 |
| 34264145 | 34264145 | 42 | 13:56:02 | 10.02.20 | 1 | 4.2 | 86 86 | 10.02.20 13:56:02 | 2020-02-10 13:56:02+01:00 |
| 34264144 | 34264144 | 44 | 13:56:00 | 10.02.20 | 1 | 6.8 | 86 86 | 10.02.20 13:56:00 | 2020-02-10 13:56:00+01:00 |
| 34264143 | 34264143 | 45 | 13:55:57 | 10.02.20 | 1 | 1.5 | 86 86 | 10.02.20 13:55:57 | 2020-02-10 13:55:57+01:00 |
| 34264142 | 34264142 | 47 | 13:55:43 | 10.02.20 | 1 | 6.8 | 86 86 | 10.02.20 13:55:43 | 2020-02-10 13:55:43+01:00 |
| 34264141 | 34264141 | 42 | 13:55:17 | 10.02.20 | 1 | 3.4 | 86 86 | 10.02.20 13:55:17 | 2020-02-10 13:55:17+01:00 |
| 34264140 | 34264140 | 47 | 13:55:10 | 10.02.20 | 1 | 4.4 | 86 86 | 10.02.20 13:55:10 | 2020-02-10 13:55:10+01:00 |
| 34264139 | 34264139 | 40 | 13:55:06 | 10.02.20 | 1 | 7.3 | 86 86 | 10.02.20 13:55:06 | 2020-02-10 13:55:06+01:00 |
| 34264138 | 34264138 | 43 | 13:55:03 | 10.02.20 | 1 | 4.8 | 86 86 | 10.02.20 13:55:03 | 2020-02-10 13:55:03+01:00 |
| 34264137 | 34264137 | 45 | 13:55:01 | 10.02.20 | 1 | 3.7 | 86 86 | 10.02.20 13:55:01 | 2020-02-10 13:55:01+01:00 |
| 34264136 | 34264136 | 58 | 13:54:41 | 10.02.20 | 1 | 3.7 | 86 86 | 10.02.20 13:54:41 | 2020-02-10 13:54:41+01:00 |
| 34264135 | 34264135 | 30 | 13:54:12 | 10.02.20 | 1 | 3.9 | 86 86 | 10.02.20 13:54:12 | 2020-02-10 13:54:12+01:00 |
| 34264134 | 34264134 | 29 | 13:54:11 | 10.02.20 | 1 | 3.8 | 86 86 | 10.02.20 13:54:11 | 2020-02-10 13:54:11+01:00 |
| 34264133 | 34264133 | 32 | 13:54:09 | 10.02.20 | 1 | 20.5 | 86 86 | 10.02.20 13:54:09 | 2020-02-10 13:54:09+01:00 |
| 34264132 | 34264132 | 47 | 13:52:57 | 10.02.20 | 1 | 6.4 | 86 86 | 10.02.20 13:52:57 | 2020-02-10 13:52:57+01:00 |
| 34264131 | 34264131 | 46 | 13:52:45 | 10.02.20 | 1 | 4.1 | 86 86 | 10.02.20 13:52:45 | 2020-02-10 13:52:45+01:00 |
| 34264130 | 34264130 | 46 | 13:52:44 | 10.02.20 | 1 | 6.9 | 86 86 | 10.02.20 13:52:44 | 2020-02-10 13:52:44+01:00 |
| 34264129 | 34264129 | 49 | 13:52:24 | 10.02.20 | 1 | 4.4 | 86 86 | 10.02.20 13:52:24 | 2020-02-10 13:52:24+01:00 |
| 34264128 | 34264128 | 48 | 13:51:39 | 10.02.20 | 1 | 4.0 | 86 86 | 10.02.20 13:51:39 | 2020-02-10 13:51:39+01:00 |
| 34264127 | 34264127 | 35 | 13:50:38 | 10.02.20 | 1 | 4.3 | 86 86 | 10.02.20 13:50:38 | 2020-02-10 13:50:38+01:00 |
| 34264126 | 34264126 | 37 | 13:50:36 | 10.02.20 | 1 | 4.8 | 86 86 | 10.02.20 13:50:36 | 2020-02-10 13:50:36+01:00 |
| 34264125 | 34264125 | 39 | 13:50:32 | 10.02.20 | 1 | 4.3 | 86 86 | 10.02.20 13:50:32 | 2020-02-10 13:50:32+01:00 |
| 34264124 | 34264124 | 44 | 13:50:29 | 10.02.20 | 1 | 7.4 | 86 86 | 10.02.20 13:50:29 | 2020-02-10 13:50:29+01:00 |
| 34264123 | 34264123 | 45 | 13:50:26 | 10.02.20 | 1 | 10.6 | 86 86 | 10.02.20 13:50:26 | 2020-02-10 13:50:26+01:00 |
| 34264122 | 34264122 | 30 | 13:49:10 | 10.02.20 | 1 | 1.9 | 86 86 | 10.02.20 13:49:10 | 2020-02-10 13:49:10+01:00 |
| 34264121 | 34264121 | 41 | 13:49:04 | 10.02.20 | 1 | 4.4 | 86 86 | 10.02.20 13:49:04 | 2020-02-10 13:49:04+01:00 |
| 34264120 | 34264120 | 44 | 13:49:01 | 10.02.20 | 1 | 3.6 | 86 86 | 10.02.20 13:49:01 | 2020-02-10 13:49:01+01:00 |
| 34264119 | 34264119 | 45 | 13:48:15 | 10.02.20 | 1 | 4.2 | 86 86 | 10.02.20 13:48:15 | 2020-02-10 13:48:15+01:00 |
| 34264118 | 34264118 | 42 | 13:48:06 | 10.02.20 | 1 | 4.3 | 86 86 | 10.02.20 13:48:06 | 2020-02-10 13:48:06+01:00 |
| 34264117 | 34264117 | 44 | 13:48:04 | 10.02.20 | 1 | 8.2 | 86 86 | 10.02.20 13:48:04 | 2020-02-10 13:48:04+01:00 |
| 34264116 | 34264116 | 42 | 13:48:01 | 10.02.20 | 1 | 9.0 | 86 86 | 10.02.20 13:48:01 | 2020-02-10 13:48:01+01:00 |
| 34264115 | 34264115 | 46 | 13:47:57 | 10.02.20 | 1 | 4.6 | 86 86 | 10.02.20 13:47:57 | 2020-02-10 13:47:57+01:00 |
| 34264114 | 34264114 | 44 | 13:47:56 | 10.02.20 | 1 | 6.5 | 86 86 | 10.02.20 13:47:56 | 2020-02-10 13:47:56+01:00 |
| 34264113 | 34264113 | 32 | 13:47:35 | 10.02.20 | 1 | 20.4 | 86 86 | 10.02.20 13:47:35 | 2020-02-10 13:47:35+01:00 |
| 34264112 | 34264112 | 38 | 13:47:16 | 10.02.20 | 1 | 4.0 | 86 86 | 10.02.20 13:47:16 | 2020-02-10 13:47:16+01:00 |
| 34264110 | 34264110 | 40 | 13:47:12 | 10.02.20 | 1 | 6.2 | 86 86 | 10.02.20 13:47:12 | 2020-02-10 13:47:12+01:00 |
| 34264111 | 34264111 | 40 | 13:47:12 | 10.02.20 | 1 | 0.9 | 86 86 | 10.02.20 13:47:12 | 2020-02-10 13:47:12+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");