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 (date), Messung_Timestamp (date)

Link rowid ID id_standort Zyklus Phase Messung_Datum Messung_Zeit V_Einfahrt V_Ausfahrt Messung_Timestamp ▲ V_Delta
2687254 2687254 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:39:25.000000 23 29 2024-10-17 04:39:25+02:00 6
2687253 2687253 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:39:18.000000 29 30 2024-10-17 04:39:18+02:00 1
2687252 2687252 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:38:48.000000 34 15 2024-10-17 04:38:48+02:00 -19
2687251 2687251 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:38:39.000000 33 34 2024-10-17 04:38:39+02:00 1
2687250 2687250 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:38:24.000000 28 31 2024-10-17 04:38:24+02:00 3
2687249 2687249 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:37:36.000000 29 31 2024-10-17 04:37:36+02:00 2
2687248 2687248 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:37:26.000000 33 27 2024-10-17 04:37:26+02:00 -6
2687247 2687247 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:37:23.000000 16 19 2024-10-17 04:37:23+02:00 3
2687246 2687246 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:37:05.000000 16 16 2024-10-17 04:37:05+02:00 0
2687245 2687245 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:36:47.000000 33 41 2024-10-17 04:36:47+02:00 8
2687244 2687244 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:35:47.000000 48 39 2024-10-17 04:35:47+02:00 -9
2687243 2687243 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:35:46.000000 36 34 2024-10-17 04:35:46+02:00 -2
2687242 2687242 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:34:35.000000 19 36 2024-10-17 04:34:35+02:00 17
2687241 2687241 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:33:57.000000 32 30 2024-10-17 04:33:57+02:00 -2
2687240 2687240 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:33:54.000000 27 25 2024-10-17 04:33:54+02:00 -2
2687239 2687239 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:33:03.000000 41 45 2024-10-17 04:33:03+02:00 4
2687238 2687238 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:32:42.000000 31 35 2024-10-17 04:32:42+02:00 4
2687237 2687237 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:31:39.000000 20 30 2024-10-17 04:31:39+02:00 10
2687236 2687236 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:30:32.000000 40 35 2024-10-17 04:30:32+02:00 -5
2687235 2687235 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:30:26.000000 34 36 2024-10-17 04:30:26+02:00 2
2687234 2687234 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:30:15.000000 27 29 2024-10-17 04:30:15+02:00 2
2687233 2687233 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:30:00.000000 45 53 2024-10-17 04:30:00+02:00 8
2687232 2687232 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:29:58.000000 33 44 2024-10-17 04:29:58+02:00 11
2687231 2687231 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:29:49.000000 25 31 2024-10-17 04:29:49+02:00 6
2687230 2687230 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:29:40.000000 24 28 2024-10-17 04:29:40+02:00 4
2687229 2687229 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:29:31.000000 25 29 2024-10-17 04:29:31+02:00 4
2687228 2687228 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:28:25.000000 33 38 2024-10-17 04:28:25+02:00 5
2687227 2687227 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:27:47.000000 31 33 2024-10-17 04:27:47+02:00 2
2687226 2687226 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:26:30.000000 45 35 2024-10-17 04:26:30+02:00 -10
2687225 2687225 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:26:24.000000 26 27 2024-10-17 04:26:24+02:00 1
2687224 2687224 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:25:24.000000 36 38 2024-10-17 04:25:24+02:00 2
2687223 2687223 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:25:16.000000 37 35 2024-10-17 04:25:16+02:00 -2
2687222 2687222 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:24:41.000000 24 37 2024-10-17 04:24:41+02:00 13
2687221 2687221 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:24:36.000000 39 44 2024-10-17 04:24:36+02:00 5
2687220 2687220 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:24:30.000000 37 30 2024-10-17 04:24:30+02:00 -7
2687219 2687219 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:24:20.000000 37 36 2024-10-17 04:24:20+02:00 -1
2687218 2687218 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:24:01.000000 37 33 2024-10-17 04:24:01+02:00 -4
2687217 2687217 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:23:33.000000 34 33 2024-10-17 04:23:33+02:00 -1
2687216 2687216 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:23:17.000000 45 39 2024-10-17 04:23:17+02:00 -6
2687215 2687215 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:22:03.000000 43 38 2024-10-17 04:22:03+02:00 -5
2687214 2687214 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:21:00.000000 26 19 2024-10-17 04:21:00+02:00 -7
2687213 2687213 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:20:37.000000 34 40 2024-10-17 04:20:37+02:00 6
2687212 2687212 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:20:29.000000 40 38 2024-10-17 04:20:29+02:00 -2
2687211 2687211 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:19:00.000000 38 41 2024-10-17 04:19:00+02:00 3
2687210 2687210 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:18:16.000000 36 43 2024-10-17 04:18:16+02:00 7
2687209 2687209 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:17:47.000000 14 10 2024-10-17 04:17:47+02:00 -4
2687207 2687207 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:17:27.000000 36 39 2024-10-17 04:17:27+02:00 3
2687208 2687208 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:17:27.000000 29 38 2024-10-17 04:17:27+02:00 9
2687206 2687206 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:16:53.000000 38 40 2024-10-17 04:16:53+02:00 2
2687205 2687205 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:16:08.000000 38 37 2024-10-17 04:16:08+02:00 -1
2687204 2687204 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:15:45.000000 33 37 2024-10-17 04:15:45+02:00 4
2687203 2687203 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:14:53.000000 38 40 2024-10-17 04:14:53+02:00 2
2687202 2687202 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:14:46.000000 41 34 2024-10-17 04:14:46+02:00 -7
2687201 2687201 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:13:48.000000 45 38 2024-10-17 04:13:48+02:00 -7
2687200 2687200 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:13:33.000000 15 32 2024-10-17 04:13:33+02:00 17
2687199 2687199 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:13:05.000000 37 40 2024-10-17 04:13:05+02:00 3
2687198 2687198 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:12:57.000000 34 36 2024-10-17 04:12:57+02:00 2
2687197 2687197 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:12:44.000000 35 33 2024-10-17 04:12:44+02:00 -2
2687196 2687196 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:12:14.000000 11 18 2024-10-17 04:12:14+02:00 7
2687195 2687195 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:11:43.000000 34 28 2024-10-17 04:11:43+02:00 -6
2687194 2687194 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:11:06.000000 39 38 2024-10-17 04:11:06+02:00 -1
2687193 2687193 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:09:32.000000 25 35 2024-10-17 04:09:32+02:00 10
2687192 2687192 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:07:57.000000 32 28 2024-10-17 04:07:57+02:00 -4
2687191 2687191 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:06:52.000000 11 20 2024-10-17 04:06:52+02:00 9
2687190 2687190 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:06:17.000000 39 41 2024-10-17 04:06:17+02:00 2
2687189 2687189 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:03:46.000000 19 24 2024-10-17 04:03:46+02:00 5
2687188 2687188 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:03:15.000000 30 29 2024-10-17 04:03:15+02:00 -1
2687187 2687187 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:02:20.000000 37 38 2024-10-17 04:02:20+02:00 1
2687186 2687186 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:02:04.000000 49 46 2024-10-17 04:02:04+02:00 -3
2687185 2687185 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:01:22.000000 23 29 2024-10-17 04:01:22+02:00 6
2687184 2687184 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:01:02.000000 27 37 2024-10-17 04:01:02+02:00 10
2687183 2687183 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:00:49.000000 23 38 2024-10-17 04:00:49+02:00 15
2687182 2687182 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:00:36.000000 9 22 2024-10-17 04:00:36+02:00 13
2687181 2687181 Auberg 4-58 58 4 Nachmessung 2024-10-17 04:00:29.000000 19 34 2024-10-17 04:00:29+02:00 15
2687179 2687179 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:59:21.000000 40 39 2024-10-17 03:59:21+02:00 -1
2687180 2687180 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:59:21.000000 37 33 2024-10-17 03:59:21+02:00 -4
2687178 2687178 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:56:54.000000 29 24 2024-10-17 03:56:54+02:00 -5
2687177 2687177 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:56:17.000000 46 37 2024-10-17 03:56:17+02:00 -9
2687176 2687176 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:54:30.000000 28 32 2024-10-17 03:54:30+02:00 4
2687175 2687175 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:54:14.000000 25 32 2024-10-17 03:54:14+02:00 7
2687174 2687174 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:53:53.000000 30 32 2024-10-17 03:53:53+02:00 2
2687173 2687173 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:53:10.000000 29 31 2024-10-17 03:53:10+02:00 2
2687172 2687172 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:52:51.000000 14 30 2024-10-17 03:52:51+02:00 16
2687171 2687171 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:52:15.000000 13 23 2024-10-17 03:52:15+02:00 10
2687170 2687170 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:51:43.000000 37 39 2024-10-17 03:51:43+02:00 2
2687169 2687169 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:51:07.000000 37 31 2024-10-17 03:51:07+02:00 -6
2687168 2687168 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:50:24.000000 14 28 2024-10-17 03:50:24+02:00 14
2687167 2687167 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:50:09.000000 30 34 2024-10-17 03:50:09+02:00 4
2687166 2687166 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:49:56.000000 39 40 2024-10-17 03:49:56+02:00 1
2687165 2687165 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:50.000000 56 52 2024-10-17 03:48:50+02:00 -4
2687164 2687164 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:40.000000 33 36 2024-10-17 03:48:40+02:00 3
2687163 2687163 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:34.000000 37 38 2024-10-17 03:48:34+02:00 1
2687162 2687162 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:29.000000 27 29 2024-10-17 03:48:29+02:00 2
2687161 2687161 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:26.000000 36 41 2024-10-17 03:48:26+02:00 5
2687160 2687160 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:48:19.000000 32 31 2024-10-17 03:48:19+02:00 -1
2687159 2687159 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:47:49.000000 36 37 2024-10-17 03:47:49+02:00 1
2687158 2687158 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:47:29.000000 38 37 2024-10-17 03:47:29+02:00 -1
2687157 2687157 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:46:40.000000 33 32 2024-10-17 03:46:40+02:00 -1
2687156 2687156 Auberg 4-58 58 4 Nachmessung 2024-10-17 03:46:17.000000 25 25 2024-10-17 03:46:17+02:00 0
2687155 2687155 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