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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Datum, Timestamp (date)

Link rowid Geschwindigkeit Zeit Datum Richtung ID Fahrzeuglänge Messung-ID Datum_Zeit Timestamp ▲
3667042 3667042 18 04:42:13 03.10.25 1 1.0 G. Wenk-Strasse 1083 03.10.25 04:42:13 2025-10-03 04:42:13+02:00
3657094 3657094 23 04:40:39 03.10.25 2 3.3 G. Wenk-Strasse 1083 03.10.25 04:40:39 2025-10-03 04:40:39+02:00
3667041 3667041 22 04:31:42 03.10.25 1 3.5 G. Wenk-Strasse 1083 03.10.25 04:31:42 2025-10-03 04:31:42+02:00
3667040 3667040 20 04:29:57 03.10.25 1 1.8 G. Wenk-Strasse 1083 03.10.25 04:29:57 2025-10-03 04:29:57+02:00
3667039 3667039 18 04:05:16 03.10.25 1 0.5 G. Wenk-Strasse 1083 03.10.25 04:05:16 2025-10-03 04:05:16+02:00
3657093 3657093 26 04:03:50 03.10.25 2 3.8 G. Wenk-Strasse 1083 03.10.25 04:03:50 2025-10-03 04:03:50+02:00
3667038 3667038 13 04:01:27 03.10.25 1 5.2 G. Wenk-Strasse 1083 03.10.25 04:01:27 2025-10-03 04:01:27+02:00
3657092 3657092 16 02:43:53 03.10.25 2 3.2 G. Wenk-Strasse 1083 03.10.25 02:43:53 2025-10-03 02:43:53+02:00
3667037 3667037 18 02:41:36 03.10.25 1 4.3 G. Wenk-Strasse 1083 03.10.25 02:41:36 2025-10-03 02:41:36+02:00
3667036 3667036 22 02:41:33 03.10.25 1 4.4 G. Wenk-Strasse 1083 03.10.25 02:41:33 2025-10-03 02:41:33+02:00
3657091 3657091 14 02:35:09 03.10.25 2 5.1 G. Wenk-Strasse 1083 03.10.25 02:35:09 2025-10-03 02:35:09+02:00
3667035 3667035 10 01:52:24 03.10.25 1 4.9 G. Wenk-Strasse 1083 03.10.25 01:52:24 2025-10-03 01:52:24+02:00
3657090 3657090 20 01:21:09 03.10.25 2 3.9 G. Wenk-Strasse 1083 03.10.25 01:21:09 2025-10-03 01:21:09+02:00
3657089 3657089 36 01:20:39 03.10.25 2 3.6 G. Wenk-Strasse 1083 03.10.25 01:20:39 2025-10-03 01:20:39+02:00
3667034 3667034 21 01:10:28 03.10.25 1 3.2 G. Wenk-Strasse 1083 03.10.25 01:10:28 2025-10-03 01:10:28+02:00
3657088 3657088 16 01:05:38 03.10.25 2 3.8 G. Wenk-Strasse 1083 03.10.25 01:05:38 2025-10-03 01:05:38+02:00
3667033 3667033 21 00:59:01 03.10.25 1 3.9 G. Wenk-Strasse 1083 03.10.25 00:59:01 2025-10-03 00:59:01+02:00
3667032 3667032 21 00:47:01 03.10.25 1 4.3 G. Wenk-Strasse 1083 03.10.25 00:47:01 2025-10-03 00:47:01+02:00
3667031 3667031 34 00:45:49 03.10.25 1 3.6 G. Wenk-Strasse 1083 03.10.25 00:45:49 2025-10-03 00:45:49+02:00
3667030 3667030 16 00:43:10 03.10.25 1 5.4 G. Wenk-Strasse 1083 03.10.25 00:43:10 2025-10-03 00:43:10+02:00
3667029 3667029 28 00:42:02 03.10.25 1 4.6 G. Wenk-Strasse 1083 03.10.25 00:42:02 2025-10-03 00:42:02+02:00
3667028 3667028 23 00:39:43 03.10.25 1 4.2 G. Wenk-Strasse 1083 03.10.25 00:39:43 2025-10-03 00:39:43+02:00
3667027 3667027 25 00:18:52 03.10.25 1 4.1 G. Wenk-Strasse 1083 03.10.25 00:18:52 2025-10-03 00:18:52+02:00
3657087 3657087 22 00:15:34 03.10.25 2 5.1 G. Wenk-Strasse 1083 03.10.25 00:15:34 2025-10-03 00:15:34+02:00
3667026 3667026 24 23:51:33 02.10.25 1 5.5 G. Wenk-Strasse 1083 02.10.25 23:51:33 2025-10-02 23:51:33+02:00
3667025 3667025 22 23:49:14 02.10.25 1 4.1 G. Wenk-Strasse 1083 02.10.25 23:49:14 2025-10-02 23:49:14+02:00
3667024 3667024 26 23:48:16 02.10.25 1 4.1 G. Wenk-Strasse 1083 02.10.25 23:48:16 2025-10-02 23:48:16+02:00
3667023 3667023 20 23:47:43 02.10.25 1 1.0 G. Wenk-Strasse 1083 02.10.25 23:47:43 2025-10-02 23:47:43+02:00
3657086 3657086 25 23:42:35 02.10.25 2 4.2 G. Wenk-Strasse 1083 02.10.25 23:42:35 2025-10-02 23:42:35+02:00
3667022 3667022 31 23:37:26 02.10.25 1 4.6 G. Wenk-Strasse 1083 02.10.25 23:37:26 2025-10-02 23:37:26+02:00
3667021 3667021 36 23:37:18 02.10.25 1 4.2 G. Wenk-Strasse 1083 02.10.25 23:37:18 2025-10-02 23:37:18+02:00
3667020 3667020 20 23:33:30 02.10.25 1 4.6 G. Wenk-Strasse 1083 02.10.25 23:33:30 2025-10-02 23:33:30+02:00
3657085 3657085 15 23:29:16 02.10.25 2 3.4 G. Wenk-Strasse 1083 02.10.25 23:29:16 2025-10-02 23:29:16+02:00
3667019 3667019 23 23:28:59 02.10.25 1 5.0 G. Wenk-Strasse 1083 02.10.25 23:28:59 2025-10-02 23:28:59+02:00
3667018 3667018 25 23:28:58 02.10.25 1 0.5 G. Wenk-Strasse 1083 02.10.25 23:28:58 2025-10-02 23:28:58+02:00
3657084 3657084 19 23:27:32 02.10.25 2 3.5 G. Wenk-Strasse 1083 02.10.25 23:27:32 2025-10-02 23:27:32+02:00
3657083 3657083 22 23:27:23 02.10.25 2 3.3 G. Wenk-Strasse 1083 02.10.25 23:27:23 2025-10-02 23:27:23+02:00
3667017 3667017 18 23:26:59 02.10.25 1 5.0 G. Wenk-Strasse 1083 02.10.25 23:26:59 2025-10-02 23:26:59+02:00
3657082 3657082 21 23:18:31 02.10.25 2 3.9 G. Wenk-Strasse 1083 02.10.25 23:18:31 2025-10-02 23:18:31+02:00
3667016 3667016 25 23:15:45 02.10.25 1 4.2 G. Wenk-Strasse 1083 02.10.25 23:15:45 2025-10-02 23:15:45+02:00
3667015 3667015 21 23:10:21 02.10.25 1 5.2 G. Wenk-Strasse 1083 02.10.25 23:10:21 2025-10-02 23:10:21+02:00
3667014 3667014 30 23:09:14 02.10.25 1 4.8 G. Wenk-Strasse 1083 02.10.25 23:09:14 2025-10-02 23:09:14+02:00
3667013 3667013 17 23:03:07 02.10.25 1 4.7 G. Wenk-Strasse 1083 02.10.25 23:03:07 2025-10-02 23:03:07+02:00
3667012 3667012 19 22:48:01 02.10.25 1 1.3 G. Wenk-Strasse 1083 02.10.25 22:48:01 2025-10-02 22:48:01+02:00
3667011 3667011 22 22:46:28 02.10.25 1 4.7 G. Wenk-Strasse 1083 02.10.25 22:46:28 2025-10-02 22:46:28+02:00
3667010 3667010 28 22:45:33 02.10.25 1 4.7 G. Wenk-Strasse 1083 02.10.25 22:45:33 2025-10-02 22:45:33+02:00
3667009 3667009 24 22:35:20 02.10.25 1 4.2 G. Wenk-Strasse 1083 02.10.25 22:35:20 2025-10-02 22:35:20+02:00
3667008 3667008 25 22:33:27 02.10.25 1 4.1 G. Wenk-Strasse 1083 02.10.25 22:33:27 2025-10-02 22:33:27+02:00
3667007 3667007 23 22:30:52 02.10.25 1 0.9 G. Wenk-Strasse 1083 02.10.25 22:30:52 2025-10-02 22:30:52+02:00
3667006 3667006 26 22:25:20 02.10.25 1 5.1 G. Wenk-Strasse 1083 02.10.25 22:25:20 2025-10-02 22:25:20+02:00
3667005 3667005 20 22:23:45 02.10.25 1 5.6 G. Wenk-Strasse 1083 02.10.25 22:23:45 2025-10-02 22:23:45+02:00
3667004 3667004 23 22:20:58 02.10.25 1 4.3 G. Wenk-Strasse 1083 02.10.25 22:20:58 2025-10-02 22:20:58+02:00
3667003 3667003 26 22:17:59 02.10.25 1 3.7 G. Wenk-Strasse 1083 02.10.25 22:17:59 2025-10-02 22:17:59+02:00
3667002 3667002 20 22:17:56 02.10.25 1 4.9 G. Wenk-Strasse 1083 02.10.25 22:17:56 2025-10-02 22:17:56+02:00
3667001 3667001 23 22:16:09 02.10.25 1 1.4 G. Wenk-Strasse 1083 02.10.25 22:16:09 2025-10-02 22:16:09+02:00
3657081 3657081 19 22:07:39 02.10.25 2 5.0 G. Wenk-Strasse 1083 02.10.25 22:07:39 2025-10-02 22:07:39+02:00
3667000 3667000 28 22:05:05 02.10.25 1 4.3 G. Wenk-Strasse 1083 02.10.25 22:05:05 2025-10-02 22:05:05+02:00
3666999 3666999 25 22:05:01 02.10.25 1 4.3 G. Wenk-Strasse 1083 02.10.25 22:05:01 2025-10-02 22:05:01+02:00
3657080 3657080 14 22:04:40 02.10.25 2 3.5 G. Wenk-Strasse 1083 02.10.25 22:04:40 2025-10-02 22:04:40+02:00
3666998 3666998 24 22:03:41 02.10.25 1 3.3 G. Wenk-Strasse 1083 02.10.25 22:03:41 2025-10-02 22:03:41+02:00
3666997 3666997 23 22:02:50 02.10.25 1 4.4 G. Wenk-Strasse 1083 02.10.25 22:02:50 2025-10-02 22:02:50+02:00
3666996 3666996 27 22:02:15 02.10.25 1 4.4 G. Wenk-Strasse 1083 02.10.25 22:02:15 2025-10-02 22:02:15+02:00
3657079 3657079 25 22:00:57 02.10.25 2 3.9 G. Wenk-Strasse 1083 02.10.25 22:00:57 2025-10-02 22:00:57+02:00
3666995 3666995 24 21:51:42 02.10.25 1 0.8 G. Wenk-Strasse 1083 02.10.25 21:51:42 2025-10-02 21:51:42+02:00
3666994 3666994 24 21:46:49 02.10.25 1 4.3 G. Wenk-Strasse 1083 02.10.25 21:46:49 2025-10-02 21:46:49+02:00
3657078 3657078 17 21:44:39 02.10.25 2 5.0 G. Wenk-Strasse 1083 02.10.25 21:44:39 2025-10-02 21:44:39+02:00
3666993 3666993 27 21:41:06 02.10.25 1 1.2 G. Wenk-Strasse 1083 02.10.25 21:41:06 2025-10-02 21:41:06+02:00
3666992 3666992 25 21:41:04 02.10.25 1 0.6 G. Wenk-Strasse 1083 02.10.25 21:41:04 2025-10-02 21:41:04+02:00
3657077 3657077 16 21:34:38 02.10.25 2 5.0 G. Wenk-Strasse 1083 02.10.25 21:34:38 2025-10-02 21:34:38+02:00
3666991 3666991 22 21:34:09 02.10.25 1 0.9 G. Wenk-Strasse 1083 02.10.25 21:34:09 2025-10-02 21:34:09+02:00
3666990 3666990 28 21:33:02 02.10.25 1 5.0 G. Wenk-Strasse 1083 02.10.25 21:33:02 2025-10-02 21:33:02+02:00
3666989 3666989 20 21:30:19 02.10.25 1 5.2 G. Wenk-Strasse 1083 02.10.25 21:30:19 2025-10-02 21:30:19+02:00
3657076 3657076 22 21:29:16 02.10.25 2 3.7 G. Wenk-Strasse 1083 02.10.25 21:29:16 2025-10-02 21:29:16+02:00
3666988 3666988 24 21:28:44 02.10.25 1 0.9 G. Wenk-Strasse 1083 02.10.25 21:28:44 2025-10-02 21:28:44+02:00
3666987 3666987 20 21:23:57 02.10.25 1 4.1 G. Wenk-Strasse 1083 02.10.25 21:23:57 2025-10-02 21:23:57+02:00
3657075 3657075 11 21:23:50 02.10.25 2 2.6 G. Wenk-Strasse 1083 02.10.25 21:23:50 2025-10-02 21:23:50+02:00
3657074 3657074 22 21:23:32 02.10.25 2 4.8 G. Wenk-Strasse 1083 02.10.25 21:23:32 2025-10-02 21:23:32+02:00
3666986 3666986 23 21:23:27 02.10.25 1 3.8 G. Wenk-Strasse 1083 02.10.25 21:23:27 2025-10-02 21:23:27+02:00
3666985 3666985 25 21:22:00 02.10.25 1 4.1 G. Wenk-Strasse 1083 02.10.25 21:22:00 2025-10-02 21:22:00+02:00
3666984 3666984 15 21:19:18 02.10.25 1 4.9 G. Wenk-Strasse 1083 02.10.25 21:19:18 2025-10-02 21:19:18+02:00
3657073 3657073 18 21:18:52 02.10.25 2 3.7 G. Wenk-Strasse 1083 02.10.25 21:18:52 2025-10-02 21:18:52+02:00
3666983 3666983 20 21:18:19 02.10.25 1 1.0 G. Wenk-Strasse 1083 02.10.25 21:18:19 2025-10-02 21:18:19+02:00
3666982 3666982 21 21:16:15 02.10.25 1 4.8 G. Wenk-Strasse 1083 02.10.25 21:16:15 2025-10-02 21:16:15+02:00
3666981 3666981 31 21:15:34 02.10.25 1 4.6 G. Wenk-Strasse 1083 02.10.25 21:15:34 2025-10-02 21:15:34+02:00
3666980 3666980 25 21:14:28 02.10.25 1 4.1 G. Wenk-Strasse 1083 02.10.25 21:14:28 2025-10-02 21:14:28+02:00
3666979 3666979 18 21:07:21 02.10.25 1 0.8 G. Wenk-Strasse 1083 02.10.25 21:07:21 2025-10-02 21:07:21+02:00
3666978 3666978 25 21:07:12 02.10.25 1 5.1 G. Wenk-Strasse 1083 02.10.25 21:07:12 2025-10-02 21:07:12+02:00
3657072 3657072 18 21:06:19 02.10.25 2 3.1 G. Wenk-Strasse 1083 02.10.25 21:06:19 2025-10-02 21:06:19+02:00
3666977 3666977 20 21:02:36 02.10.25 1 5.6 G. Wenk-Strasse 1083 02.10.25 21:02:36 2025-10-02 21:02:36+02:00
3666976 3666976 19 21:02:27 02.10.25 1 1.0 G. Wenk-Strasse 1083 02.10.25 21:02:27 2025-10-02 21:02:27+02:00
3666975 3666975 12 21:00:15 02.10.25 1 1.7 G. Wenk-Strasse 1083 02.10.25 21:00:15 2025-10-02 21:00:15+02:00
3666974 3666974 12 21:00:13 02.10.25 1 5.4 G. Wenk-Strasse 1083 02.10.25 21:00:13 2025-10-02 21:00:13+02:00
3666973 3666973 30 20:57:21 02.10.25 1 4.0 G. Wenk-Strasse 1083 02.10.25 20:57:21 2025-10-02 20:57:21+02:00
3657071 3657071 17 20:56:09 02.10.25 2 4.9 G. Wenk-Strasse 1083 02.10.25 20:56:09 2025-10-02 20:56:09+02:00
3666972 3666972 36 20:54:09 02.10.25 1 4.6 G. Wenk-Strasse 1083 02.10.25 20:54:09 2025-10-02 20:54:09+02:00
3666971 3666971 24 20:53:44 02.10.25 1 1.0 G. Wenk-Strasse 1083 02.10.25 20:53:44 2025-10-02 20:53:44+02:00
3657070 3657070 23 20:53:27 02.10.25 2 4.9 G. Wenk-Strasse 1083 02.10.25 20:53:27 2025-10-02 20:53:27+02:00
3657069 3657069 22 20:53:26 02.10.25 2 4.9 G. Wenk-Strasse 1083 02.10.25 20:53:26 2025-10-02 20:53:26+02:00
3666970 3666970 30 20:50:31 02.10.25 1 1.5 G. Wenk-Strasse 1083 02.10.25 20:50:31 2025-10-02 20:50:31+02:00
3657068 3657068 17 20:47:06 02.10.25 2 3.5 G. Wenk-Strasse 1083 02.10.25 20:47:06 2025-10-02 20:47:06+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