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-30" 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
879570 879570 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-11 10:07:06.000000 20 28 2023-07-11 10:07:06+02:00 8
879569 879569 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-11 10:06:08.000000 16 19 2023-07-11 10:06:08+02:00 3
879568 879568 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-11 08:53:27.000000 26 26 2023-07-11 08:53:27+02:00 0
879567 879567 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-11 08:43:24.000000 32 33 2023-07-11 08:43:24+02:00 1
879566 879566 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-11 08:34:01.000000 23 28 2023-07-11 08:34:01+02:00 5
879565 879565 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-11 08:08:14.000000 31 25 2023-07-11 08:08:14+02:00 -6
879564 879564 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-11 07:19:40.000000 13 16 2023-07-11 07:19:40+02:00 3
879563 879563 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-11 06:09:57.000000 13 19 2023-07-11 06:09:57+02:00 6
879562 879562 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-11 02:00:29.000000 39 17 2023-07-11 02:00:29+02:00 -22
886298 886298 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 23:07:58.000000 20 17 2023-07-10 23:07:58+02:00 -3
886297 886297 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 22:44:20.000000 5 7 2023-07-10 22:44:20+02:00 2
886296 886296 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 22:32:38.000000 11 17 2023-07-10 22:32:38+02:00 6
886295 886295 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 22:32:25.000000 25 22 2023-07-10 22:32:25+02:00 -3
886294 886294 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 22:17:05.000000 17 17 2023-07-10 22:17:05+02:00 0
886293 886293 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 21:59:57.000000 14 17 2023-07-10 21:59:57+02:00 3
886292 886292 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 21:59:50.000000 23 23 2023-07-10 21:59:50+02:00 0
886291 886291 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 21:31:36.000000 17 17 2023-07-10 21:31:36+02:00 0
886290 886290 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 21:03:54.000000 10 12 2023-07-10 21:03:54+02:00 2
886289 886289 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 20:48:44.000000 20 22 2023-07-10 20:48:44+02:00 2
886288 886288 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 20:36:35.000000 32 35 2023-07-10 20:36:35+02:00 3
886287 886287 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 20:34:45.000000 28 25 2023-07-10 20:34:45+02:00 -3
886286 886286 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 19:16:43.000000 26 25 2023-07-10 19:16:43+02:00 -1
886285 886285 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 19:14:57.000000 17 12 2023-07-10 19:14:57+02:00 -5
886284 886284 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 19:04:32.000000 30 22 2023-07-10 19:04:32+02:00 -8
886283 886283 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 18:58:25.000000 10 7 2023-07-10 18:58:25+02:00 -3
886282 886282 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 17:43:10.000000 16 28 2023-07-10 17:43:10+02:00 12
886281 886281 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 17:06:35.000000 14 17 2023-07-10 17:06:35+02:00 3
886280 886280 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 16:48:57.000000 16 19 2023-07-10 16:48:57+02:00 3
886279 886279 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 16:37:12.000000 18 17 2023-07-10 16:37:12+02:00 -1
886278 886278 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 16:03:50.000000 27 27 2023-07-10 16:03:50+02:00 0
886277 886277 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 15:36:54.000000 24 24 2023-07-10 15:36:54+02:00 0
886276 886276 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 15:31:23.000000 20 23 2023-07-10 15:31:23+02:00 3
886275 886275 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 14:25:05.000000 20 13 2023-07-10 14:25:05+02:00 -7
886274 886274 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 14:20:38.000000 23 22 2023-07-10 14:20:38+02:00 -1
886273 886273 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 13:41:19.000000 20 14 2023-07-10 13:41:19+02:00 -6
886272 886272 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 13:20:01.000000 17 23 2023-07-10 13:20:01+02:00 6
886271 886271 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 13:16:30.000000 9 26 2023-07-10 13:16:30+02:00 17
886270 886270 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 13:09:19.000000 26 12 2023-07-10 13:09:19+02:00 -14
886269 886269 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 12:35:01.000000 18 16 2023-07-10 12:35:01+02:00 -2
886268 886268 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 12:19:33.000000 14 13 2023-07-10 12:19:33+02:00 -1
886267 886267 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 10:59:45.000000 31 24 2023-07-10 10:59:45+02:00 -7
886266 886266 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 10:59:11.000000 15 23 2023-07-10 10:59:11+02:00 8
886265 886265 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 10:42:20.000000 18 31 2023-07-10 10:42:20+02:00 13
886264 886264 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 09:53:50.000000 28 19 2023-07-10 09:53:50+02:00 -9
886263 886263 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 08:07:29.000000 16 15 2023-07-10 08:07:29+02:00 -1
886262 886262 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 08:02:49.000000 13 14 2023-07-10 08:02:49+02:00 1
886261 886261 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 07:56:35.000000 18 26 2023-07-10 07:56:35+02:00 8
886260 886260 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 07:36:12.000000 18 10 2023-07-10 07:36:12+02:00 -8
886259 886259 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 07:01:46.000000 15 25 2023-07-10 07:01:46+02:00 10
886258 886258 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 06:51:01.000000 17 24 2023-07-10 06:51:01+02:00 7
886257 886257 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 06:38:32.000000 24 29 2023-07-10 06:38:32+02:00 5
886256 886256 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 06:25:09.000000 19 24 2023-07-10 06:25:09+02:00 5
886255 886255 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 05:31:25.000000 17 23 2023-07-10 05:31:25+02:00 6
886254 886254 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 05:22:37.000000 18 20 2023-07-10 05:22:37+02:00 2
886253 886253 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-10 03:08:44.000000 25 18 2023-07-10 03:08:44+02:00 -7
886387 886387 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 23:27:38.000000 13 26 2023-07-09 23:27:38+02:00 13
886386 886386 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 23:04:31.000000 23 27 2023-07-09 23:04:31+02:00 4
886385 886385 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 22:48:42.000000 25 18 2023-07-09 22:48:42+02:00 -7
886384 886384 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 22:30:37.000000 7 22 2023-07-09 22:30:37+02:00 15
886383 886383 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 22:24:18.000000 17 23 2023-07-09 22:24:18+02:00 6
886382 886382 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 20:50:02.000000 4 6 2023-07-09 20:50:02+02:00 2
886381 886381 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 20:27:12.000000 11 16 2023-07-09 20:27:12+02:00 5
886380 886380 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 20:26:12.000000 13 19 2023-07-09 20:26:12+02:00 6
886379 886379 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 20:17:14.000000 18 24 2023-07-09 20:17:14+02:00 6
886378 886378 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 20:10:44.000000 16 15 2023-07-09 20:10:44+02:00 -1
886377 886377 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 19:54:17.000000 4 9 2023-07-09 19:54:17+02:00 5
886376 886376 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 19:44:51.000000 30 31 2023-07-09 19:44:51+02:00 1
886375 886375 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 19:28:34.000000 3 22 2023-07-09 19:28:34+02:00 19
886374 886374 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 19:15:40.000000 24 20 2023-07-09 19:15:40+02:00 -4
886373 886373 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 18:41:18.000000 20 10 2023-07-09 18:41:18+02:00 -10
886372 886372 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 18:39:49.000000 4 6 2023-07-09 18:39:49+02:00 2
886371 886371 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 18:33:39.000000 24 24 2023-07-09 18:33:39+02:00 0
886370 886370 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 16:40:34.000000 18 20 2023-07-09 16:40:34+02:00 2
886369 886369 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 16:02:39.000000 15 16 2023-07-09 16:02:39+02:00 1
886368 886368 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 15:44:35.000000 23 23 2023-07-09 15:44:35+02:00 0
886367 886367 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 15:34:09.000000 12 22 2023-07-09 15:34:09+02:00 10
886366 886366 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 13:59:28.000000 29 25 2023-07-09 13:59:28+02:00 -4
886365 886365 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 13:54:22.000000 33 30 2023-07-09 13:54:22+02:00 -3
886364 886364 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 13:45:26.000000 28 27 2023-07-09 13:45:26+02:00 -1
886363 886363 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 13:26:24.000000 26 28 2023-07-09 13:26:24+02:00 2
886362 886362 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 12:18:53.000000 15 17 2023-07-09 12:18:53+02:00 2
886361 886361 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 12:14:14.000000 9 12 2023-07-09 12:14:14+02:00 3
886360 886360 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 12:09:45.000000 24 25 2023-07-09 12:09:45+02:00 1
886359 886359 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 11:43:30.000000 27 25 2023-07-09 11:43:30+02:00 -2
886358 886358 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 10:52:49.000000 20 24 2023-07-09 10:52:49+02:00 4
886357 886357 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 10:28:02.000000 18 30 2023-07-09 10:28:02+02:00 12
886356 886356 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 10:20:05.000000 13 22 2023-07-09 10:20:05+02:00 9
886355 886355 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 09:52:42.000000 27 19 2023-07-09 09:52:42+02:00 -8
886354 886354 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 09:04:47.000000 25 17 2023-07-09 09:04:47+02:00 -8
886353 886353 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 08:51:32.000000 8 10 2023-07-09 08:51:32+02:00 2
886352 886352 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 08:08:13.000000 23 31 2023-07-09 08:08:13+02:00 8
886351 886351 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 07:47:44.000000 28 26 2023-07-09 07:47:44+02:00 -2
886350 886350 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 04:16:59.000000 18 30 2023-07-09 04:16:59+02:00 12
886349 886349 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 04:04:18.000000 15 7 2023-07-09 04:04:18+02:00 -8
886348 886348 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 00:11:55.000000 20 19 2023-07-09 00:11:55+02:00 -1
886347 886347 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-09 00:01:35.000000 27 30 2023-07-09 00:01:35+02:00 3
883939 883939 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-08 22:40:01.000000 25 24 2023-07-08 22:40:01+02:00 -1
883938 883938 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-08 22:39:32.000000 32 13 2023-07-08 22:39:32+02:00 -19
883937 883937 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-08 21:31:27.000000 20 20 2023-07-08 21:31:27+02:00 0
883936 883936 Marschalkenstrasse 1-30 30 1 Nachmessung 2023-07-08 21:24:46.000000 25 28 2023-07-08 21:24:46+02:00 3

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