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 = "1-41" sorted by Messung_Timestamp descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Phase, 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
1979153 1979153 Gellertstrasse 1-41 41 1 Nach Ende 2023-07-10 09:26:02.000000 26 14 2023-07-10 09:26:02+02:00 -12
1979152 1979152 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:25:34.000000 13 18 2023-07-10 09:25:34+02:00 5
1979151 1979151 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:25:23.000000 28 22 2023-07-10 09:25:23+02:00 -6
1979150 1979150 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:25:20.000000 35 26 2023-07-10 09:25:20+02:00 -9
1979149 1979149 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:24:20.000000 33 27 2023-07-10 09:24:20+02:00 -6
1979148 1979148 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:23:36.000000 24 16 2023-07-10 09:23:36+02:00 -8
1979147 1979147 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:22:55.000000 29 23 2023-07-10 09:22:55+02:00 -6
1979146 1979146 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:22:52.000000 24 23 2023-07-10 09:22:52+02:00 -1
1979145 1979145 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:20:28.000000 18 26 2023-07-10 09:20:28+02:00 8
1979144 1979144 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:19:08.000000 34 34 2023-07-10 09:19:08+02:00 0
1979143 1979143 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:18:49.000000 30 24 2023-07-10 09:18:49+02:00 -6
1979142 1979142 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:17:44.000000 37 33 2023-07-10 09:17:44+02:00 -4
1979141 1979141 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:15:52.000000 40 31 2023-07-10 09:15:52+02:00 -9
1979140 1979140 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:15:49.000000 36 30 2023-07-10 09:15:49+02:00 -6
1979139 1979139 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:14:16.000000 24 25 2023-07-10 09:14:16+02:00 1
1979138 1979138 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:14:04.000000 32 25 2023-07-10 09:14:04+02:00 -7
1979137 1979137 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:13:28.000000 37 18 2023-07-10 09:13:28+02:00 -19
1979136 1979136 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:06:16.000000 17 24 2023-07-10 09:06:16+02:00 7
1979135 1979135 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:04:09.000000 34 29 2023-07-10 09:04:09+02:00 -5
1979134 1979134 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:03:36.000000 35 27 2023-07-10 09:03:36+02:00 -8
1979133 1979133 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:01:49.000000 35 34 2023-07-10 09:01:49+02:00 -1
1979132 1979132 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 09:00:39.000000 37 31 2023-07-10 09:00:39+02:00 -6
1979131 1979131 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:59:34.000000 27 29 2023-07-10 08:59:34+02:00 2
1979130 1979130 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:58:53.000000 27 18 2023-07-10 08:58:53+02:00 -9
1979129 1979129 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:58:16.000000 40 32 2023-07-10 08:58:16+02:00 -8
1979128 1979128 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:55:51.000000 33 22 2023-07-10 08:55:51+02:00 -11
1979127 1979127 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:54:58.000000 25 22 2023-07-10 08:54:58+02:00 -3
1979126 1979126 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:54:26.000000 25 28 2023-07-10 08:54:26+02:00 3
1979125 1979125 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:50:19.000000 28 32 2023-07-10 08:50:19+02:00 4
1979124 1979124 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:46:58.000000 32 15 2023-07-10 08:46:58+02:00 -17
1979123 1979123 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:44:09.000000 27 20 2023-07-10 08:44:09+02:00 -7
1979122 1979122 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:43:51.000000 31 32 2023-07-10 08:43:51+02:00 1
1979121 1979121 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:43:30.000000 45 32 2023-07-10 08:43:30+02:00 -13
1979120 1979120 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:41:09.000000 31 30 2023-07-10 08:41:09+02:00 -1
1979119 1979119 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:38:37.000000 37 32 2023-07-10 08:38:37+02:00 -5
1979118 1979118 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:36:14.000000 25 15 2023-07-10 08:36:14+02:00 -10
1979117 1979117 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:30:53.000000 35 34 2023-07-10 08:30:53+02:00 -1
1979116 1979116 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:30:32.000000 30 29 2023-07-10 08:30:32+02:00 -1
1979115 1979115 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:30:27.000000 17 17 2023-07-10 08:30:27+02:00 0
1979114 1979114 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:28:38.000000 35 31 2023-07-10 08:28:38+02:00 -4
1979113 1979113 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:28:24.000000 32 29 2023-07-10 08:28:24+02:00 -3
1979112 1979112 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:27:53.000000 28 23 2023-07-10 08:27:53+02:00 -5
1979111 1979111 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:27:08.000000 28 16 2023-07-10 08:27:08+02:00 -12
1979110 1979110 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:26:02.000000 31 27 2023-07-10 08:26:02+02:00 -4
1979109 1979109 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:24:37.000000 38 27 2023-07-10 08:24:37+02:00 -11
1979108 1979108 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:24:32.000000 31 28 2023-07-10 08:24:32+02:00 -3
1979107 1979107 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:20:29.000000 26 23 2023-07-10 08:20:29+02:00 -3
1979106 1979106 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:18:16.000000 29 30 2023-07-10 08:18:16+02:00 1
1979105 1979105 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:17:16.000000 35 24 2023-07-10 08:17:16+02:00 -11
1979104 1979104 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:16:46.000000 43 33 2023-07-10 08:16:46+02:00 -10
1979103 1979103 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:16:33.000000 23 13 2023-07-10 08:16:33+02:00 -10
1979102 1979102 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:15:41.000000 15 15 2023-07-10 08:15:41+02:00 0
1979101 1979101 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:13:38.000000 35 26 2023-07-10 08:13:38+02:00 -9
1979100 1979100 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:11:30.000000 28 28 2023-07-10 08:11:30+02:00 0
1979099 1979099 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:10:47.000000 43 39 2023-07-10 08:10:47+02:00 -4
1979098 1979098 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:06:11.000000 17 25 2023-07-10 08:06:11+02:00 8
1979097 1979097 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:05:45.000000 35 33 2023-07-10 08:05:45+02:00 -2
1979096 1979096 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:04:45.000000 31 27 2023-07-10 08:04:45+02:00 -4
1979095 1979095 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:03:09.000000 26 16 2023-07-10 08:03:09+02:00 -10
1979094 1979094 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:02:30.000000 33 27 2023-07-10 08:02:30+02:00 -6
1979093 1979093 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 08:02:21.000000 36 29 2023-07-10 08:02:21+02:00 -7
1979092 1979092 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:55:05.000000 25 25 2023-07-10 07:55:05+02:00 0
1979091 1979091 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:54:03.000000 33 37 2023-07-10 07:54:03+02:00 4
1979090 1979090 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:51:27.000000 33 29 2023-07-10 07:51:27+02:00 -4
1979089 1979089 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:49:54.000000 32 20 2023-07-10 07:49:54+02:00 -12
1979088 1979088 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:49:41.000000 34 31 2023-07-10 07:49:41+02:00 -3
1979087 1979087 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:49:36.000000 26 24 2023-07-10 07:49:36+02:00 -2
1979086 1979086 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:49:02.000000 39 32 2023-07-10 07:49:02+02:00 -7
1979085 1979085 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:47:38.000000 15 13 2023-07-10 07:47:38+02:00 -2
1979084 1979084 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:47:02.000000 24 23 2023-07-10 07:47:02+02:00 -1
1979083 1979083 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:46:22.000000 27 27 2023-07-10 07:46:22+02:00 0
1979082 1979082 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:45:19.000000 29 25 2023-07-10 07:45:19+02:00 -4
1979081 1979081 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:42:09.000000 28 30 2023-07-10 07:42:09+02:00 2
1979080 1979080 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:40:34.000000 26 26 2023-07-10 07:40:34+02:00 0
1979079 1979079 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:39:18.000000 25 28 2023-07-10 07:39:18+02:00 3
1979078 1979078 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:37:28.000000 30 28 2023-07-10 07:37:28+02:00 -2
1979077 1979077 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:36:55.000000 30 29 2023-07-10 07:36:55+02:00 -1
1979076 1979076 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:35:43.000000 37 34 2023-07-10 07:35:43+02:00 -3
1979075 1979075 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:34:10.000000 36 31 2023-07-10 07:34:10+02:00 -5
1979074 1979074 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:32:18.000000 36 37 2023-07-10 07:32:18+02:00 1
1979073 1979073 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:21:31.000000 33 28 2023-07-10 07:21:31+02:00 -5
1979072 1979072 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:20:33.000000 38 31 2023-07-10 07:20:33+02:00 -7
1979071 1979071 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:20:20.000000 26 28 2023-07-10 07:20:20+02:00 2
1979070 1979070 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:20:02.000000 27 25 2023-07-10 07:20:02+02:00 -2
1979069 1979069 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:19:18.000000 35 26 2023-07-10 07:19:18+02:00 -9
1979068 1979068 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:17:11.000000 34 35 2023-07-10 07:17:11+02:00 1
1979067 1979067 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:13:00.000000 31 38 2023-07-10 07:13:00+02:00 7
1979066 1979066 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:11:21.000000 35 28 2023-07-10 07:11:21+02:00 -7
1979065 1979065 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:07:58.000000 34 28 2023-07-10 07:07:58+02:00 -6
1979064 1979064 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:07:07.000000 37 31 2023-07-10 07:07:07+02:00 -6
1979063 1979063 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 07:05:25.000000 30 26 2023-07-10 07:05:25+02:00 -4
1979062 1979062 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 06:56:32.000000 34 34 2023-07-10 06:56:32+02:00 0
1979061 1979061 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 06:53:35.000000 30 23 2023-07-10 06:53:35+02:00 -7
1979060 1979060 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 06:49:57.000000 50 33 2023-07-10 06:49:57+02:00 -17
1979059 1979059 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 06:49:32.000000 28 31 2023-07-10 06:49:32+02:00 3
1979058 1979058 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 06:49:04.000000 37 27 2023-07-10 06:49:04+02:00 -10
1979057 1979057 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 06:47:38.000000 34 28 2023-07-10 06:47:38+02:00 -6
1979056 1979056 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 06:43:19.000000 38 27 2023-07-10 06:43:19+02:00 -11
1979055 1979055 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 06:43:03.000000 39 24 2023-07-10 06:43:03+02:00 -15
1979054 1979054 Gellertstrasse 1-41 41 1 Nachmessung 2023-07-10 06:40:54.000000 30 25 2023-07-10 06:40:54+02:00 -5

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