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-54" 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
7406463 7406463 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:45:19.000000 28 30 2023-07-09 23:45:19+02:00 2
7406462 7406462 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:44:01.000000 36 19 2023-07-09 23:44:01+02:00 -17
7406461 7406461 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:43:55.000000 39 37 2023-07-09 23:43:55+02:00 -2
7406460 7406460 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:43:42.000000 48 47 2023-07-09 23:43:42+02:00 -1
7406459 7406459 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:43:13.000000 46 43 2023-07-09 23:43:13+02:00 -3
7406458 7406458 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:42:12.000000 26 32 2023-07-09 23:42:12+02:00 6
7406457 7406457 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:42:04.000000 35 30 2023-07-09 23:42:04+02:00 -5
7406456 7406456 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:41:56.000000 45 43 2023-07-09 23:41:56+02:00 -2
7406455 7406455 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:41:54.000000 55 45 2023-07-09 23:41:54+02:00 -10
7406454 7406454 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:41:50.000000 49 55 2023-07-09 23:41:50+02:00 6
7406453 7406453 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:40:47.000000 25 19 2023-07-09 23:40:47+02:00 -6
7406452 7406452 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:40:40.000000 37 32 2023-07-09 23:40:40+02:00 -5
7406451 7406451 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:40:20.000000 18 19 2023-07-09 23:40:20+02:00 1
7406450 7406450 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:40:10.000000 29 22 2023-07-09 23:40:10+02:00 -7
7406449 7406449 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:39:59.000000 29 28 2023-07-09 23:39:59+02:00 -1
7406448 7406448 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:39:54.000000 38 30 2023-07-09 23:39:54+02:00 -8
7406447 7406447 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:39:46.000000 28 36 2023-07-09 23:39:46+02:00 8
7406446 7406446 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:39:02.000000 37 23 2023-07-09 23:39:02+02:00 -14
7406445 7406445 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:38:54.000000 35 36 2023-07-09 23:38:54+02:00 1
7406444 7406444 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:37:53.000000 38 35 2023-07-09 23:37:53+02:00 -3
7406443 7406443 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:37:51.000000 45 35 2023-07-09 23:37:51+02:00 -10
7406442 7406442 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:37:43.000000 46 44 2023-07-09 23:37:43+02:00 -2
7406441 7406441 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:37:17.000000 47 46 2023-07-09 23:37:17+02:00 -1
7406440 7406440 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:36:11.000000 28 26 2023-07-09 23:36:11+02:00 -2
7406439 7406439 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:35:47.000000 28 28 2023-07-09 23:35:47+02:00 0
7406438 7406438 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:35:36.000000 29 27 2023-07-09 23:35:36+02:00 -2
7406437 7406437 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:34:09.000000 41 33 2023-07-09 23:34:09+02:00 -8
7406435 7406435 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:34:02.000000 45 45 2023-07-09 23:34:02+02:00 0
7406436 7406436 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:34:02.000000 39 33 2023-07-09 23:34:02+02:00 -6
7406434 7406434 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:33:55.000000 43 43 2023-07-09 23:33:55+02:00 0
7406433 7406433 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:33:50.000000 25 29 2023-07-09 23:33:50+02:00 4
7406432 7406432 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:33:45.000000 46 32 2023-07-09 23:33:45+02:00 -14
7406431 7406431 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:33:39.000000 35 30 2023-07-09 23:33:39+02:00 -5
7406430 7406430 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:33:37.000000 43 47 2023-07-09 23:33:37+02:00 4
7406429 7406429 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:33:28.000000 36 34 2023-07-09 23:33:28+02:00 -2
7406428 7406428 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:33:20.000000 38 34 2023-07-09 23:33:20+02:00 -4
7406427 7406427 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:32:59.000000 39 29 2023-07-09 23:32:59+02:00 -10
7406426 7406426 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:32:54.000000 46 43 2023-07-09 23:32:54+02:00 -3
7406425 7406425 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:32:47.000000 54 47 2023-07-09 23:32:47+02:00 -7
7406424 7406424 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:32:42.000000 36 32 2023-07-09 23:32:42+02:00 -4
7406423 7406423 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:32:33.000000 41 38 2023-07-09 23:32:33+02:00 -3
7406422 7406422 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:31:51.000000 39 32 2023-07-09 23:31:51+02:00 -7
7406421 7406421 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:31:44.000000 40 38 2023-07-09 23:31:44+02:00 -2
7406420 7406420 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:31:19.000000 40 29 2023-07-09 23:31:19+02:00 -11
7406419 7406419 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:31:12.000000 40 40 2023-07-09 23:31:12+02:00 0
7406418 7406418 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:30:29.000000 50 32 2023-07-09 23:30:29+02:00 -18
7406417 7406417 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:30:23.000000 51 48 2023-07-09 23:30:23+02:00 -3
7406416 7406416 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:28:50.000000 52 46 2023-07-09 23:28:50+02:00 -6
7406415 7406415 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:28:44.000000 52 50 2023-07-09 23:28:44+02:00 -2
7406414 7406414 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:28:05.000000 41 33 2023-07-09 23:28:05+02:00 -8
7406413 7406413 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:27:23.000000 30 31 2023-07-09 23:27:23+02:00 1
7406412 7406412 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:27:22.000000 31 32 2023-07-09 23:27:22+02:00 1
7406411 7406411 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:27:13.000000 30 35 2023-07-09 23:27:13+02:00 5
7406410 7406410 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:26:49.000000 31 27 2023-07-09 23:26:49+02:00 -4
7406409 7406409 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:26:43.000000 37 34 2023-07-09 23:26:43+02:00 -3
7406408 7406408 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:26:39.000000 36 26 2023-07-09 23:26:39+02:00 -10
7406407 7406407 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:26:30.000000 47 35 2023-07-09 23:26:30+02:00 -12
7406406 7406406 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:26:24.000000 40 44 2023-07-09 23:26:24+02:00 4
7406405 7406405 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:25:42.000000 46 41 2023-07-09 23:25:42+02:00 -5
7406404 7406404 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:25:10.000000 33 24 2023-07-09 23:25:10+02:00 -9
7406403 7406403 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:25:09.000000 43 31 2023-07-09 23:25:09+02:00 -12
7406402 7406402 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:25:02.000000 36 47 2023-07-09 23:25:02+02:00 11
7406401 7406401 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:24:52.000000 40 35 2023-07-09 23:24:52+02:00 -5
7406400 7406400 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:24:01.000000 43 30 2023-07-09 23:24:01+02:00 -13
7406399 7406399 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:23:58.000000 49 43 2023-07-09 23:23:58+02:00 -6
7406398 7406398 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:22:31.000000 30 25 2023-07-09 23:22:31+02:00 -5
7406397 7406397 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:22:21.000000 40 29 2023-07-09 23:22:21+02:00 -11
7406396 7406396 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:22:14.000000 39 40 2023-07-09 23:22:14+02:00 1
7406395 7406395 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:22:11.000000 46 43 2023-07-09 23:22:11+02:00 -3
7406394 7406394 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:21:03.000000 35 40 2023-07-09 23:21:03+02:00 5
7406393 7406393 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:21:02.000000 43 43 2023-07-09 23:21:02+02:00 0
7406392 7406392 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:20:56.000000 38 47 2023-07-09 23:20:56+02:00 9
7406391 7406391 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:20:44.000000 38 36 2023-07-09 23:20:44+02:00 -2
7406390 7406390 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:20:37.000000 46 37 2023-07-09 23:20:37+02:00 -9
7406389 7406389 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:20:30.000000 34 45 2023-07-09 23:20:30+02:00 11
7406388 7406388 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:20:18.000000 37 33 2023-07-09 23:20:18+02:00 -4
7406387 7406387 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:20:10.000000 39 36 2023-07-09 23:20:10+02:00 -3
7406386 7406386 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:20:04.000000 43 41 2023-07-09 23:20:04+02:00 -2
7406385 7406385 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:19:27.000000 39 38 2023-07-09 23:19:27+02:00 -1
7406384 7406384 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:19:20.000000 35 43 2023-07-09 23:19:20+02:00 8
7406383 7406383 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:19:17.000000 54 45 2023-07-09 23:19:17+02:00 -9
7406382 7406382 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:19:05.000000 50 43 2023-07-09 23:19:05+02:00 -7
7406381 7406381 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:18:47.000000 47 49 2023-07-09 23:18:47+02:00 2
7406380 7406380 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:18:15.000000 40 35 2023-07-09 23:18:15+02:00 -5
7406379 7406379 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:16:51.000000 34 31 2023-07-09 23:16:51+02:00 -3
7406378 7406378 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:16:47.000000 41 38 2023-07-09 23:16:47+02:00 -3
7406377 7406377 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:16:39.000000 41 41 2023-07-09 23:16:39+02:00 0
7406376 7406376 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:15:40.000000 35 34 2023-07-09 23:15:40+02:00 -1
7406375 7406375 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:15:36.000000 45 44 2023-07-09 23:15:36+02:00 -1
7406374 7406374 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:15:17.000000 35 34 2023-07-09 23:15:17+02:00 -1
7406373 7406373 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:15:09.000000 35 36 2023-07-09 23:15:09+02:00 1
7406372 7406372 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:14:30.000000 37 35 2023-07-09 23:14:30+02:00 -2
7406371 7406371 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:14:26.000000 46 37 2023-07-09 23:14:26+02:00 -9
7406370 7406370 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:14:21.000000 43 36 2023-07-09 23:14:21+02:00 -7
7406369 7406369 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:13:59.000000 45 37 2023-07-09 23:13:59+02:00 -8
7406368 7406368 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:13:52.000000 45 43 2023-07-09 23:13:52+02:00 -2
7406367 7406367 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:13:27.000000 38 35 2023-07-09 23:13:27+02:00 -3
7406366 7406366 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:13:19.000000 38 37 2023-07-09 23:13:19+02:00 -1
7406365 7406365 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:13:11.000000 46 38 2023-07-09 23:13:11+02:00 -8
7406364 7406364 Giornicostrasse 1-54 54 1 Nachmessung 2023-07-09 23:12:51.000000 23 36 2023-07-09 23:12:51+02:00 13

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