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-59" 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
9209469 9209469 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:44:03.000000 33 29 2023-07-11 10:44:03+02:00 -4
9209468 9209468 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:42:22.000000 27 27 2023-07-11 10:42:22+02:00 0
9209467 9209467 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:42:04.000000 37 37 2023-07-11 10:42:04+02:00 0
9209466 9209466 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:41:00.000000 26 19 2023-07-11 10:41:00+02:00 -7
9209465 9209465 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:39:30.000000 18 18 2023-07-11 10:39:30+02:00 0
9209464 9209464 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:38:29.000000 37 33 2023-07-11 10:38:29+02:00 -4
9209463 9209463 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:38:04.000000 25 32 2023-07-11 10:38:04+02:00 7
9209462 9209462 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:37:38.000000 11 28 2023-07-11 10:37:38+02:00 17
9209461 9209461 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:36:00.000000 24 28 2023-07-11 10:36:00+02:00 4
9209460 9209460 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:35:46.000000 27 25 2023-07-11 10:35:46+02:00 -2
9209459 9209459 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:33:45.000000 25 32 2023-07-11 10:33:45+02:00 7
9209458 9209458 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:33:25.000000 26 30 2023-07-11 10:33:25+02:00 4
9209457 9209457 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:32:37.000000 14 27 2023-07-11 10:32:37+02:00 13
9209456 9209456 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:29:46.000000 26 27 2023-07-11 10:29:46+02:00 1
9209455 9209455 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:26:44.000000 19 19 2023-07-11 10:26:44+02:00 0
9209454 9209454 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:26:28.000000 26 7 2023-07-11 10:26:28+02:00 -19
9209453 9209453 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:26:07.000000 17 25 2023-07-11 10:26:07+02:00 8
9209452 9209452 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:25:29.000000 28 23 2023-07-11 10:25:29+02:00 -5
9209451 9209451 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:25:01.000000 26 25 2023-07-11 10:25:01+02:00 -1
9209450 9209450 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:19:36.000000 30 16 2023-07-11 10:19:36+02:00 -14
9209449 9209449 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:09:25.000000 29 25 2023-07-11 10:09:25+02:00 -4
9209448 9209448 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:08:53.000000 20 28 2023-07-11 10:08:53+02:00 8
9209447 9209447 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:08:37.000000 19 28 2023-07-11 10:08:37+02:00 9
9209446 9209446 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:05:15.000000 25 30 2023-07-11 10:05:15+02:00 5
9209445 9209445 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:01:12.000000 17 13 2023-07-11 10:01:12+02:00 -4
9209444 9209444 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 10:00:57.000000 20 23 2023-07-11 10:00:57+02:00 3
9209443 9209443 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:58:09.000000 14 25 2023-07-11 09:58:09+02:00 11
9209442 9209442 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:57:33.000000 20 29 2023-07-11 09:57:33+02:00 9
9209441 9209441 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:49:15.000000 18 23 2023-07-11 09:49:15+02:00 5
9209440 9209440 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:48:33.000000 12 23 2023-07-11 09:48:33+02:00 11
9209439 9209439 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:46:44.000000 31 28 2023-07-11 09:46:44+02:00 -3
9209438 9209438 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:46:35.000000 25 30 2023-07-11 09:46:35+02:00 5
9209437 9209437 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:43:08.000000 18 28 2023-07-11 09:43:08+02:00 10
9209436 9209436 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:36:23.000000 29 24 2023-07-11 09:36:23+02:00 -5
9209435 9209435 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:34:52.000000 24 27 2023-07-11 09:34:52+02:00 3
9209434 9209434 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:29:07.000000 39 34 2023-07-11 09:29:07+02:00 -5
9209433 9209433 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:29:06.000000 37 33 2023-07-11 09:29:06+02:00 -4
9209432 9209432 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:26:56.000000 27 33 2023-07-11 09:26:56+02:00 6
9209431 9209431 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:20:14.000000 13 22 2023-07-11 09:20:14+02:00 9
9209430 9209430 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:19:57.000000 26 29 2023-07-11 09:19:57+02:00 3
9209429 9209429 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:17:08.000000 26 31 2023-07-11 09:17:08+02:00 5
9209428 9209428 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:16:46.000000 23 29 2023-07-11 09:16:46+02:00 6
9209427 9209427 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:14:59.000000 20 31 2023-07-11 09:14:59+02:00 11
9209426 9209426 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:13:32.000000 18 23 2023-07-11 09:13:32+02:00 5
9209425 9209425 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:10:59.000000 24 28 2023-07-11 09:10:59+02:00 4
9209424 9209424 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:08:59.000000 17 22 2023-07-11 09:08:59+02:00 5
9209423 9209423 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:02:56.000000 11 19 2023-07-11 09:02:56+02:00 8
9209422 9209422 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:02:09.000000 25 15 2023-07-11 09:02:09+02:00 -10
9209421 9209421 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:01:55.000000 28 29 2023-07-11 09:01:55+02:00 1
9209420 9209420 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 09:00:03.000000 27 38 2023-07-11 09:00:03+02:00 11
9209419 9209419 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:56:05.000000 28 31 2023-07-11 08:56:05+02:00 3
9209418 9209418 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:54:24.000000 26 34 2023-07-11 08:54:24+02:00 8
9209417 9209417 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:53:29.000000 30 32 2023-07-11 08:53:29+02:00 2
9209416 9209416 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:52:07.000000 25 25 2023-07-11 08:52:07+02:00 0
9209415 9209415 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:50:38.000000 29 27 2023-07-11 08:50:38+02:00 -2
9209414 9209414 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:49:50.000000 17 23 2023-07-11 08:49:50+02:00 6
9209413 9209413 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:41:35.000000 28 33 2023-07-11 08:41:35+02:00 5
9209412 9209412 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:41:28.000000 23 29 2023-07-11 08:41:28+02:00 6
9209411 9209411 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:40:22.000000 19 25 2023-07-11 08:40:22+02:00 6
9209410 9209410 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:36:25.000000 35 37 2023-07-11 08:36:25+02:00 2
9209409 9209409 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:36:16.000000 29 34 2023-07-11 08:36:16+02:00 5
9209408 9209408 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:34:16.000000 19 24 2023-07-11 08:34:16+02:00 5
9209407 9209407 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:33:42.000000 27 25 2023-07-11 08:33:42+02:00 -2
9209406 9209406 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:33:19.000000 19 26 2023-07-11 08:33:19+02:00 7
9209405 9209405 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:32:22.000000 15 26 2023-07-11 08:32:22+02:00 11
9209404 9209404 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:31:28.000000 10 23 2023-07-11 08:31:28+02:00 13
9209403 9209403 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:29:15.000000 19 22 2023-07-11 08:29:15+02:00 3
9209402 9209402 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:27:53.000000 29 25 2023-07-11 08:27:53+02:00 -4
9209401 9209401 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:26:11.000000 28 29 2023-07-11 08:26:11+02:00 1
9209400 9209400 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:26:03.000000 23 26 2023-07-11 08:26:03+02:00 3
9209399 9209399 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:24:13.000000 19 25 2023-07-11 08:24:13+02:00 6
9209398 9209398 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:13:48.000000 7 14 2023-07-11 08:13:48+02:00 7
9209397 9209397 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:12:30.000000 4 5 2023-07-11 08:12:30+02:00 1
9209396 9209396 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:10:11.000000 23 28 2023-07-11 08:10:11+02:00 5
9209395 9209395 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:09:12.000000 24 23 2023-07-11 08:09:12+02:00 -1
9209394 9209394 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:09:06.000000 23 27 2023-07-11 08:09:06+02:00 4
9209393 9209393 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:07:28.000000 20 19 2023-07-11 08:07:28+02:00 -1
9209392 9209392 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:05:12.000000 15 27 2023-07-11 08:05:12+02:00 12
9209391 9209391 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:05:03.000000 25 28 2023-07-11 08:05:03+02:00 3
9209390 9209390 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:02:38.000000 28 29 2023-07-11 08:02:38+02:00 1
9209389 9209389 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 08:02:24.000000 26 27 2023-07-11 08:02:24+02:00 1
9209388 9209388 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:58:01.000000 16 13 2023-07-11 07:58:01+02:00 -3
9209387 9209387 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:56:15.000000 33 31 2023-07-11 07:56:15+02:00 -2
9209386 9209386 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:55:07.000000 28 26 2023-07-11 07:55:07+02:00 -2
9209385 9209385 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:54:43.000000 20 25 2023-07-11 07:54:43+02:00 5
9209384 9209384 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:54:34.000000 27 24 2023-07-11 07:54:34+02:00 -3
9209383 9209383 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:52:01.000000 25 32 2023-07-11 07:52:01+02:00 7
9209382 9209382 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:48:40.000000 27 34 2023-07-11 07:48:40+02:00 7
9209381 9209381 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:47:28.000000 24 34 2023-07-11 07:47:28+02:00 10
9209380 9209380 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:45:49.000000 23 25 2023-07-11 07:45:49+02:00 2
9209379 9209379 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:45:48.000000 26 28 2023-07-11 07:45:48+02:00 2
9209378 9209378 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:45:34.000000 27 23 2023-07-11 07:45:34+02:00 -4
9209377 9209377 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:44:11.000000 26 27 2023-07-11 07:44:11+02:00 1
9209376 9209376 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:44:00.000000 17 25 2023-07-11 07:44:00+02:00 8
9209375 9209375 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:43:05.000000 33 26 2023-07-11 07:43:05+02:00 -7
9209373 9209373 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:42:30.000000 20 20 2023-07-11 07:42:30+02:00 0
9209374 9209374 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:42:30.000000 28 23 2023-07-11 07:42:30+02:00 -5
9209372 9209372 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:42:12.000000 19 28 2023-07-11 07:42:12+02:00 9
9209371 9209371 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:41:49.000000 19 27 2023-07-11 07:41:49+02:00 8
9209370 9209370 Birsigstrasse 1-59 59 1 Nachmessung 2023-07-11 07:40:29.000000 25 26 2023-07-11 07:40:29+02:00 1

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