home / Geschwindigkeitsmonitoring / Einzelmessungen

Menu
  • Sign in with GitHub

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 = 1033 sorted by Timestamp descending

✎ View and edit SQL

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 ▲
3957361 3957361 35 09:12:19 12.06.25 1 4.5 Schwarzwaldstrasse 1033 12.06.25 09:12:19 2025-06-12 09:12:19+02:00
3957360 3957360 39 09:12:17 12.06.25 1 3.8 Schwarzwaldstrasse 1033 12.06.25 09:12:17 2025-06-12 09:12:17+02:00
3957359 3957359 38 09:11:46 12.06.25 1 4.9 Schwarzwaldstrasse 1033 12.06.25 09:11:46 2025-06-12 09:11:46+02:00
3957358 3957358 38 09:11:43 12.06.25 1 4.2 Schwarzwaldstrasse 1033 12.06.25 09:11:43 2025-06-12 09:11:43+02:00
3957357 3957357 35 09:11:41 12.06.25 1 11.9 Schwarzwaldstrasse 1033 12.06.25 09:11:41 2025-06-12 09:11:41+02:00
3957356 3957356 36 09:11:35 12.06.25 1 4.3 Schwarzwaldstrasse 1033 12.06.25 09:11:35 2025-06-12 09:11:35+02:00
3957355 3957355 48 09:11:32 12.06.25 1 5.3 Schwarzwaldstrasse 1033 12.06.25 09:11:32 2025-06-12 09:11:32+02:00
3957354 3957354 49 09:11:26 12.06.25 1 4.1 Schwarzwaldstrasse 1033 12.06.25 09:11:26 2025-06-12 09:11:26+02:00
3957353 3957353 55 09:11:25 12.06.25 1 3.9 Schwarzwaldstrasse 1033 12.06.25 09:11:25 2025-06-12 09:11:25+02:00
3957352 3957352 44 09:11:02 12.06.25 1 4.1 Schwarzwaldstrasse 1033 12.06.25 09:11:02 2025-06-12 09:11:02+02:00
3957351 3957351 52 09:11:00 12.06.25 1 5.2 Schwarzwaldstrasse 1033 12.06.25 09:11:00 2025-06-12 09:11:00+02:00
3957350 3957350 51 09:10:43 12.06.25 1 4.6 Schwarzwaldstrasse 1033 12.06.25 09:10:43 2025-06-12 09:10:43+02:00
3957349 3957349 44 09:10:34 12.06.25 1 3.1 Schwarzwaldstrasse 1033 12.06.25 09:10:34 2025-06-12 09:10:34+02:00
3957348 3957348 41 09:10:33 12.06.25 1 4.1 Schwarzwaldstrasse 1033 12.06.25 09:10:33 2025-06-12 09:10:33+02:00
3957347 3957347 43 09:10:32 12.06.25 1 4.1 Schwarzwaldstrasse 1033 12.06.25 09:10:32 2025-06-12 09:10:32+02:00
3957346 3957346 45 09:10:23 12.06.25 1 4.5 Schwarzwaldstrasse 1033 12.06.25 09:10:23 2025-06-12 09:10:23+02:00
3957345 3957345 41 09:10:21 12.06.25 1 6.4 Schwarzwaldstrasse 1033 12.06.25 09:10:21 2025-06-12 09:10:21+02:00
3957344 3957344 42 09:10:19 12.06.25 1 4.9 Schwarzwaldstrasse 1033 12.06.25 09:10:19 2025-06-12 09:10:19+02:00
3957343 3957343 45 09:10:18 12.06.25 1 11.8 Schwarzwaldstrasse 1033 12.06.25 09:10:18 2025-06-12 09:10:18+02:00
3957342 3957342 39 09:10:06 12.06.25 1 4.5 Schwarzwaldstrasse 1033 12.06.25 09:10:06 2025-06-12 09:10:06+02:00
3957341 3957341 53 09:10:01 12.06.25 1 5.9 Schwarzwaldstrasse 1033 12.06.25 09:10:01 2025-06-12 09:10:01+02:00
3957340 3957340 48 09:09:58 12.06.25 1 3.8 Schwarzwaldstrasse 1033 12.06.25 09:09:58 2025-06-12 09:09:58+02:00
3957339 3957339 44 09:09:56 12.06.25 1 12.1 Schwarzwaldstrasse 1033 12.06.25 09:09:56 2025-06-12 09:09:56+02:00
3957338 3957338 46 09:09:51 12.06.25 1 5.2 Schwarzwaldstrasse 1033 12.06.25 09:09:51 2025-06-12 09:09:51+02:00
3957337 3957337 42 09:09:49 12.06.25 1 5.3 Schwarzwaldstrasse 1033 12.06.25 09:09:49 2025-06-12 09:09:49+02:00
3957336 3957336 53 09:09:41 12.06.25 1 5.3 Schwarzwaldstrasse 1033 12.06.25 09:09:41 2025-06-12 09:09:41+02:00
3957335 3957335 43 09:09:16 12.06.25 1 4.8 Schwarzwaldstrasse 1033 12.06.25 09:09:16 2025-06-12 09:09:16+02:00
3957334 3957334 44 09:09:15 12.06.25 1 5.6 Schwarzwaldstrasse 1033 12.06.25 09:09:15 2025-06-12 09:09:15+02:00
3957333 3957333 47 09:09:13 12.06.25 1 8.0 Schwarzwaldstrasse 1033 12.06.25 09:09:13 2025-06-12 09:09:13+02:00
3957332 3957332 49 09:09:00 12.06.25 1 4.3 Schwarzwaldstrasse 1033 12.06.25 09:09:00 2025-06-12 09:09:00+02:00
3957331 3957331 53 09:08:51 12.06.25 1 4.5 Schwarzwaldstrasse 1033 12.06.25 09:08:51 2025-06-12 09:08:51+02:00
3957330 3957330 46 09:08:48 12.06.25 1 5.1 Schwarzwaldstrasse 1033 12.06.25 09:08:48 2025-06-12 09:08:48+02:00
3957329 3957329 38 09:08:45 12.06.25 1 4.8 Schwarzwaldstrasse 1033 12.06.25 09:08:45 2025-06-12 09:08:45+02:00
3957328 3957328 37 09:08:43 12.06.25 1 4.7 Schwarzwaldstrasse 1033 12.06.25 09:08:43 2025-06-12 09:08:43+02:00
3957327 3957327 42 09:08:33 12.06.25 1 4.5 Schwarzwaldstrasse 1033 12.06.25 09:08:33 2025-06-12 09:08:33+02:00
3957326 3957326 42 09:08:19 12.06.25 1 4.0 Schwarzwaldstrasse 1033 12.06.25 09:08:19 2025-06-12 09:08:19+02:00
3957325 3957325 45 09:08:17 12.06.25 1 4.2 Schwarzwaldstrasse 1033 12.06.25 09:08:17 2025-06-12 09:08:17+02:00
3957324 3957324 47 09:08:04 12.06.25 1 5.4 Schwarzwaldstrasse 1033 12.06.25 09:08:04 2025-06-12 09:08:04+02:00
3957323 3957323 50 09:08:03 12.06.25 1 4.0 Schwarzwaldstrasse 1033 12.06.25 09:08:03 2025-06-12 09:08:03+02:00
3957322 3957322 48 09:08:00 12.06.25 1 3.4 Schwarzwaldstrasse 1033 12.06.25 09:08:00 2025-06-12 09:08:00+02:00
3957321 3957321 45 09:07:54 12.06.25 1 4.6 Schwarzwaldstrasse 1033 12.06.25 09:07:54 2025-06-12 09:07:54+02:00
3957320 3957320 51 09:07:53 12.06.25 1 8.2 Schwarzwaldstrasse 1033 12.06.25 09:07:53 2025-06-12 09:07:53+02:00
3957319 3957319 48 09:07:48 12.06.25 1 5.1 Schwarzwaldstrasse 1033 12.06.25 09:07:48 2025-06-12 09:07:48+02:00
3957318 3957318 47 09:07:44 12.06.25 1 6.2 Schwarzwaldstrasse 1033 12.06.25 09:07:44 2025-06-12 09:07:44+02:00
3957317 3957317 51 09:07:43 12.06.25 1 4.6 Schwarzwaldstrasse 1033 12.06.25 09:07:43 2025-06-12 09:07:43+02:00
3957316 3957316 43 09:07:25 12.06.25 1 10.8 Schwarzwaldstrasse 1033 12.06.25 09:07:25 2025-06-12 09:07:25+02:00
3957315 3957315 54 09:07:15 12.06.25 1 4.5 Schwarzwaldstrasse 1033 12.06.25 09:07:15 2025-06-12 09:07:15+02:00
3957314 3957314 50 09:07:09 12.06.25 1 4.2 Schwarzwaldstrasse 1033 12.06.25 09:07:09 2025-06-12 09:07:09+02:00
3957313 3957313 42 09:07:01 12.06.25 1 3.7 Schwarzwaldstrasse 1033 12.06.25 09:07:01 2025-06-12 09:07:01+02:00
3957312 3957312 48 09:06:45 12.06.25 1 4.2 Schwarzwaldstrasse 1033 12.06.25 09:06:45 2025-06-12 09:06:45+02:00
3957311 3957311 15 09:06:38 12.06.25 1 1.9 Schwarzwaldstrasse 1033 12.06.25 09:06:38 2025-06-12 09:06:38+02:00
3957310 3957310 17 09:06:37 12.06.25 1 4.7 Schwarzwaldstrasse 1033 12.06.25 09:06:37 2025-06-12 09:06:37+02:00
3957309 3957309 28 09:06:30 12.06.25 1 4.3 Schwarzwaldstrasse 1033 12.06.25 09:06:30 2025-06-12 09:06:30+02:00
3957308 3957308 23 09:06:25 12.06.25 1 3.9 Schwarzwaldstrasse 1033 12.06.25 09:06:25 2025-06-12 09:06:25+02:00
3957307 3957307 28 09:06:24 12.06.25 1 4.2 Schwarzwaldstrasse 1033 12.06.25 09:06:24 2025-06-12 09:06:24+02:00
3957306 3957306 37 09:06:19 12.06.25 1 4.1 Schwarzwaldstrasse 1033 12.06.25 09:06:19 2025-06-12 09:06:19+02:00
3957305 3957305 38 09:06:15 12.06.25 1 5.2 Schwarzwaldstrasse 1033 12.06.25 09:06:15 2025-06-12 09:06:15+02:00
3957304 3957304 38 09:06:14 12.06.25 1 4.7 Schwarzwaldstrasse 1033 12.06.25 09:06:14 2025-06-12 09:06:14+02:00
3957303 3957303 37 09:06:12 12.06.25 1 4.7 Schwarzwaldstrasse 1033 12.06.25 09:06:12 2025-06-12 09:06:12+02:00
3957302 3957302 35 09:06:09 12.06.25 1 4.1 Schwarzwaldstrasse 1033 12.06.25 09:06:09 2025-06-12 09:06:09+02:00
3957301 3957301 39 09:06:08 12.06.25 1 8.0 Schwarzwaldstrasse 1033 12.06.25 09:06:08 2025-06-12 09:06:08+02:00
3957300 3957300 32 09:06:02 12.06.25 1 11.7 Schwarzwaldstrasse 1033 12.06.25 09:06:02 2025-06-12 09:06:02+02:00
3957299 3957299 43 09:05:54 12.06.25 1 5.4 Schwarzwaldstrasse 1033 12.06.25 09:05:54 2025-06-12 09:05:54+02:00
3957298 3957298 45 09:05:53 12.06.25 1 6.5 Schwarzwaldstrasse 1033 12.06.25 09:05:53 2025-06-12 09:05:53+02:00
3957297 3957297 48 09:05:48 12.06.25 1 3.8 Schwarzwaldstrasse 1033 12.06.25 09:05:48 2025-06-12 09:05:48+02:00
3957296 3957296 53 09:05:46 12.06.25 1 5.5 Schwarzwaldstrasse 1033 12.06.25 09:05:46 2025-06-12 09:05:46+02:00
3957295 3957295 42 09:05:37 12.06.25 1 4.1 Schwarzwaldstrasse 1033 12.06.25 09:05:37 2025-06-12 09:05:37+02:00
3957294 3957294 45 09:05:35 12.06.25 1 4.1 Schwarzwaldstrasse 1033 12.06.25 09:05:35 2025-06-12 09:05:35+02:00
3957293 3957293 40 09:05:28 12.06.25 1 6.1 Schwarzwaldstrasse 1033 12.06.25 09:05:28 2025-06-12 09:05:28+02:00
3957292 3957292 48 09:05:24 12.06.25 1 12.2 Schwarzwaldstrasse 1033 12.06.25 09:05:24 2025-06-12 09:05:24+02:00
3957291 3957291 46 09:05:17 12.06.25 1 4.8 Schwarzwaldstrasse 1033 12.06.25 09:05:17 2025-06-12 09:05:17+02:00
3957290 3957290 48 09:05:15 12.06.25 1 5.2 Schwarzwaldstrasse 1033 12.06.25 09:05:15 2025-06-12 09:05:15+02:00
3957289 3957289 52 09:05:02 12.06.25 1 4.6 Schwarzwaldstrasse 1033 12.06.25 09:05:02 2025-06-12 09:05:02+02:00
3957288 3957288 51 09:05:01 12.06.25 1 4.5 Schwarzwaldstrasse 1033 12.06.25 09:05:01 2025-06-12 09:05:01+02:00
3957287 3957287 52 09:04:58 12.06.25 1 4.8 Schwarzwaldstrasse 1033 12.06.25 09:04:58 2025-06-12 09:04:58+02:00
3957286 3957286 46 09:04:57 12.06.25 1 4.3 Schwarzwaldstrasse 1033 12.06.25 09:04:57 2025-06-12 09:04:57+02:00
3957285 3957285 55 09:04:55 12.06.25 1 3.8 Schwarzwaldstrasse 1033 12.06.25 09:04:55 2025-06-12 09:04:55+02:00
3957284 3957284 48 09:04:50 12.06.25 1 4.0 Schwarzwaldstrasse 1033 12.06.25 09:04:50 2025-06-12 09:04:50+02:00
3957283 3957283 39 09:04:48 12.06.25 1 4.4 Schwarzwaldstrasse 1033 12.06.25 09:04:48 2025-06-12 09:04:48+02:00
3957282 3957282 52 09:04:42 12.06.25 1 4.5 Schwarzwaldstrasse 1033 12.06.25 09:04:42 2025-06-12 09:04:42+02:00
3957281 3957281 52 09:04:39 12.06.25 1 10.0 Schwarzwaldstrasse 1033 12.06.25 09:04:39 2025-06-12 09:04:39+02:00
3957280 3957280 55 09:04:33 12.06.25 1 4.8 Schwarzwaldstrasse 1033 12.06.25 09:04:33 2025-06-12 09:04:33+02:00
3957278 3957278 53 09:04:32 12.06.25 1 3.5 Schwarzwaldstrasse 1033 12.06.25 09:04:32 2025-06-12 09:04:32+02:00
3957279 3957279 55 09:04:32 12.06.25 1 4.1 Schwarzwaldstrasse 1033 12.06.25 09:04:32 2025-06-12 09:04:32+02:00
3957277 3957277 51 09:04:22 12.06.25 1 4.8 Schwarzwaldstrasse 1033 12.06.25 09:04:22 2025-06-12 09:04:22+02:00
3957276 3957276 46 09:04:20 12.06.25 1 4.8 Schwarzwaldstrasse 1033 12.06.25 09:04:20 2025-06-12 09:04:20+02:00
3957275 3957275 44 09:04:19 12.06.25 1 4.0 Schwarzwaldstrasse 1033 12.06.25 09:04:19 2025-06-12 09:04:19+02:00
3957274 3957274 45 09:04:17 12.06.25 1 10.6 Schwarzwaldstrasse 1033 12.06.25 09:04:17 2025-06-12 09:04:17+02:00
3957273 3957273 57 09:03:52 12.06.25 1 5.4 Schwarzwaldstrasse 1033 12.06.25 09:03:52 2025-06-12 09:03:52+02:00
3957272 3957272 62 09:03:48 12.06.25 1 5.6 Schwarzwaldstrasse 1033 12.06.25 09:03:48 2025-06-12 09:03:48+02:00
3957271 3957271 51 09:03:43 12.06.25 1 4.4 Schwarzwaldstrasse 1033 12.06.25 09:03:43 2025-06-12 09:03:43+02:00
3957270 3957270 47 09:03:40 12.06.25 1 4.9 Schwarzwaldstrasse 1033 12.06.25 09:03:40 2025-06-12 09:03:40+02:00
3957269 3957269 38 09:03:38 12.06.25 1 2.0 Schwarzwaldstrasse 1033 12.06.25 09:03:38 2025-06-12 09:03:38+02:00
3957268 3957268 50 09:03:36 12.06.25 1 3.3 Schwarzwaldstrasse 1033 12.06.25 09:03:36 2025-06-12 09:03:36+02:00
3957267 3957267 47 09:03:31 12.06.25 1 4.0 Schwarzwaldstrasse 1033 12.06.25 09:03:31 2025-06-12 09:03:31+02:00
3957266 3957266 46 09:03:30 12.06.25 1 4.5 Schwarzwaldstrasse 1033 12.06.25 09:03:30 2025-06-12 09:03:30+02:00
3957265 3957265 44 09:03:26 12.06.25 1 5.1 Schwarzwaldstrasse 1033 12.06.25 09:03:26 2025-06-12 09:03:26+02:00
3957264 3957264 44 09:03:24 12.06.25 1 4.0 Schwarzwaldstrasse 1033 12.06.25 09:03:24 2025-06-12 09:03:24+02:00
3957263 3957263 45 09:03:22 12.06.25 1 6.2 Schwarzwaldstrasse 1033 12.06.25 09:03:22 2025-06-12 09:03:22+02:00
3957262 3957262 52 09:03:11 12.06.25 1 3.5 Schwarzwaldstrasse 1033 12.06.25 09:03:11 2025-06-12 09:03:11+02:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Queries took 1.2ms