home / Smiley-Geschwindigkeitsmessungen / Einzelmessungen

Menu
  • Sign in with GitHub

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 = "4-58" sorted by Messung_Timestamp descending

✎ View and edit SQL

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
17506083 17506083 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:39:25.000000 23 29 2024-10-17 04:39:25+02:00 6
17506082 17506082 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:39:18.000000 29 30 2024-10-17 04:39:18+02:00 1
17506081 17506081 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:38:48.000000 34 15 2024-10-17 04:38:48+02:00 -19
17506080 17506080 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:38:39.000000 33 34 2024-10-17 04:38:39+02:00 1
17506079 17506079 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:38:24.000000 28 31 2024-10-17 04:38:24+02:00 3
17506078 17506078 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:37:36.000000 29 31 2024-10-17 04:37:36+02:00 2
17506077 17506077 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:37:26.000000 33 27 2024-10-17 04:37:26+02:00 -6
17506076 17506076 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:37:23.000000 16 19 2024-10-17 04:37:23+02:00 3
17506075 17506075 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:37:05.000000 16 16 2024-10-17 04:37:05+02:00 0
17506074 17506074 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:36:47.000000 33 41 2024-10-17 04:36:47+02:00 8
17506073 17506073 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:35:47.000000 48 39 2024-10-17 04:35:47+02:00 -9
17506072 17506072 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:35:46.000000 36 34 2024-10-17 04:35:46+02:00 -2
17506071 17506071 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:34:35.000000 19 36 2024-10-17 04:34:35+02:00 17
17506070 17506070 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:33:57.000000 32 30 2024-10-17 04:33:57+02:00 -2
17506069 17506069 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:33:54.000000 27 25 2024-10-17 04:33:54+02:00 -2
17506068 17506068 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:33:03.000000 41 45 2024-10-17 04:33:03+02:00 4
17506067 17506067 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:32:42.000000 31 35 2024-10-17 04:32:42+02:00 4
17506066 17506066 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:31:39.000000 20 30 2024-10-17 04:31:39+02:00 10
17506065 17506065 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:30:32.000000 40 35 2024-10-17 04:30:32+02:00 -5
17506064 17506064 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:30:26.000000 34 36 2024-10-17 04:30:26+02:00 2
17506063 17506063 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:30:15.000000 27 29 2024-10-17 04:30:15+02:00 2
17506062 17506062 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:30:00.000000 45 53 2024-10-17 04:30:00+02:00 8
17506061 17506061 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:29:58.000000 33 44 2024-10-17 04:29:58+02:00 11
17506060 17506060 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:29:49.000000 25 31 2024-10-17 04:29:49+02:00 6
17506059 17506059 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:29:40.000000 24 28 2024-10-17 04:29:40+02:00 4
17506058 17506058 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:29:31.000000 25 29 2024-10-17 04:29:31+02:00 4
17506057 17506057 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:28:25.000000 33 38 2024-10-17 04:28:25+02:00 5
17506056 17506056 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:27:47.000000 31 33 2024-10-17 04:27:47+02:00 2
17506055 17506055 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:26:30.000000 45 35 2024-10-17 04:26:30+02:00 -10
17506054 17506054 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:26:24.000000 26 27 2024-10-17 04:26:24+02:00 1
17506053 17506053 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:25:24.000000 36 38 2024-10-17 04:25:24+02:00 2
17506052 17506052 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:25:16.000000 37 35 2024-10-17 04:25:16+02:00 -2
17506051 17506051 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:24:41.000000 24 37 2024-10-17 04:24:41+02:00 13
17506050 17506050 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:24:36.000000 39 44 2024-10-17 04:24:36+02:00 5
17506049 17506049 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:24:30.000000 37 30 2024-10-17 04:24:30+02:00 -7
17506048 17506048 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:24:20.000000 37 36 2024-10-17 04:24:20+02:00 -1
17506047 17506047 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:24:01.000000 37 33 2024-10-17 04:24:01+02:00 -4
17506046 17506046 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:23:33.000000 34 33 2024-10-17 04:23:33+02:00 -1
17506045 17506045 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:23:17.000000 45 39 2024-10-17 04:23:17+02:00 -6
17506044 17506044 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:22:03.000000 43 38 2024-10-17 04:22:03+02:00 -5
17506043 17506043 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:21:00.000000 26 19 2024-10-17 04:21:00+02:00 -7
17506042 17506042 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:20:37.000000 34 40 2024-10-17 04:20:37+02:00 6
17506041 17506041 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:20:29.000000 40 38 2024-10-17 04:20:29+02:00 -2
17506040 17506040 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:19:00.000000 38 41 2024-10-17 04:19:00+02:00 3
17506039 17506039 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:18:16.000000 36 43 2024-10-17 04:18:16+02:00 7
17506038 17506038 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:17:47.000000 14 10 2024-10-17 04:17:47+02:00 -4
17506036 17506036 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:17:27.000000 36 39 2024-10-17 04:17:27+02:00 3
17506037 17506037 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:17:27.000000 29 38 2024-10-17 04:17:27+02:00 9
17506035 17506035 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:16:53.000000 38 40 2024-10-17 04:16:53+02:00 2
17506034 17506034 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:16:08.000000 38 37 2024-10-17 04:16:08+02:00 -1
17506033 17506033 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:15:45.000000 33 37 2024-10-17 04:15:45+02:00 4
17506032 17506032 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:14:53.000000 38 40 2024-10-17 04:14:53+02:00 2
17506031 17506031 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:14:46.000000 41 34 2024-10-17 04:14:46+02:00 -7
17506030 17506030 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:13:48.000000 45 38 2024-10-17 04:13:48+02:00 -7
17506029 17506029 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:13:33.000000 15 32 2024-10-17 04:13:33+02:00 17
17506028 17506028 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:13:05.000000 37 40 2024-10-17 04:13:05+02:00 3
17506027 17506027 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:12:57.000000 34 36 2024-10-17 04:12:57+02:00 2
17506026 17506026 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:12:44.000000 35 33 2024-10-17 04:12:44+02:00 -2
17506025 17506025 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:12:14.000000 11 18 2024-10-17 04:12:14+02:00 7
17506024 17506024 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:11:43.000000 34 28 2024-10-17 04:11:43+02:00 -6
17506023 17506023 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:11:06.000000 39 38 2024-10-17 04:11:06+02:00 -1
17506022 17506022 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:09:32.000000 25 35 2024-10-17 04:09:32+02:00 10
17506021 17506021 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:07:57.000000 32 28 2024-10-17 04:07:57+02:00 -4
17506020 17506020 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:06:52.000000 11 20 2024-10-17 04:06:52+02:00 9
17506019 17506019 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:06:17.000000 39 41 2024-10-17 04:06:17+02:00 2
17506018 17506018 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:03:46.000000 19 24 2024-10-17 04:03:46+02:00 5
17506017 17506017 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:03:15.000000 30 29 2024-10-17 04:03:15+02:00 -1
17506016 17506016 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:02:20.000000 37 38 2024-10-17 04:02:20+02:00 1
17506015 17506015 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:02:04.000000 49 46 2024-10-17 04:02:04+02:00 -3
17506014 17506014 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:01:22.000000 23 29 2024-10-17 04:01:22+02:00 6
17506013 17506013 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:01:02.000000 27 37 2024-10-17 04:01:02+02:00 10
17506012 17506012 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:00:49.000000 23 38 2024-10-17 04:00:49+02:00 15
17506011 17506011 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:00:36.000000 9 22 2024-10-17 04:00:36+02:00 13
17506010 17506010 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:00:29.000000 19 34 2024-10-17 04:00:29+02:00 15
17506008 17506008 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:59:21.000000 40 39 2024-10-17 03:59:21+02:00 -1
17506009 17506009 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:59:21.000000 37 33 2024-10-17 03:59:21+02:00 -4
17506007 17506007 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:56:54.000000 29 24 2024-10-17 03:56:54+02:00 -5
17506006 17506006 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:56:17.000000 46 37 2024-10-17 03:56:17+02:00 -9
17506005 17506005 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:54:30.000000 28 32 2024-10-17 03:54:30+02:00 4
17506004 17506004 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:54:14.000000 25 32 2024-10-17 03:54:14+02:00 7
17506003 17506003 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:53:53.000000 30 32 2024-10-17 03:53:53+02:00 2
17506002 17506002 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:53:10.000000 29 31 2024-10-17 03:53:10+02:00 2
17506001 17506001 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:52:51.000000 14 30 2024-10-17 03:52:51+02:00 16
17506000 17506000 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:52:15.000000 13 23 2024-10-17 03:52:15+02:00 10
17505999 17505999 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:51:43.000000 37 39 2024-10-17 03:51:43+02:00 2
17505998 17505998 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:51:07.000000 37 31 2024-10-17 03:51:07+02:00 -6
17505997 17505997 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:50:24.000000 14 28 2024-10-17 03:50:24+02:00 14
17505996 17505996 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:50:09.000000 30 34 2024-10-17 03:50:09+02:00 4
17505995 17505995 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:49:56.000000 39 40 2024-10-17 03:49:56+02:00 1
17505994 17505994 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:50.000000 56 52 2024-10-17 03:48:50+02:00 -4
17505993 17505993 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:40.000000 33 36 2024-10-17 03:48:40+02:00 3
17505992 17505992 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:34.000000 37 38 2024-10-17 03:48:34+02:00 1
17505991 17505991 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:29.000000 27 29 2024-10-17 03:48:29+02:00 2
17505990 17505990 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:26.000000 36 41 2024-10-17 03:48:26+02:00 5
17505989 17505989 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:19.000000 32 31 2024-10-17 03:48:19+02:00 -1
17505988 17505988 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:47:49.000000 36 37 2024-10-17 03:47:49+02:00 1
17505987 17505987 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:47:29.000000 38 37 2024-10-17 03:47:29+02:00 -1
17505986 17505986 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:46:40.000000 33 32 2024-10-17 03:46:40+02:00 -1
17505985 17505985 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:46:17.000000 25 25 2024-10-17 03:46:17+02:00 0
17505984 17505984 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:46:04.000000 34 34 2024-10-17 03:46:04+02:00 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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