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-41" 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
11139533 11139533 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:57:36.000000 20 14 2024-10-17 11:57:36+02:00 -6
11139532 11139532 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:57:05.000000 26 23 2024-10-17 11:57:05+02:00 -3
11139531 11139531 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:56:58.000000 34 28 2024-10-17 11:56:58+02:00 -6
11139530 11139530 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:56:20.000000 24 27 2024-10-17 11:56:20+02:00 3
11139529 11139529 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:56:13.000000 30 34 2024-10-17 11:56:13+02:00 4
11139528 11139528 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:56:10.000000 37 32 2024-10-17 11:56:10+02:00 -5
11139527 11139527 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:53:06.000000 27 23 2024-10-17 11:53:06+02:00 -4
11139526 11139526 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:52:04.000000 30 30 2024-10-17 11:52:04+02:00 0
11139524 11139524 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:45:47.000000 27 31 2024-10-17 11:45:47+02:00 4
11139525 11139525 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:45:47.000000 26 20 2024-10-17 11:45:47+02:00 -6
11139523 11139523 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:43:44.000000 36 33 2024-10-17 11:43:44+02:00 -3
11139522 11139522 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:43:41.000000 31 27 2024-10-17 11:43:41+02:00 -4
11139521 11139521 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:42:57.000000 27 22 2024-10-17 11:42:57+02:00 -5
11139520 11139520 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:42:22.000000 31 27 2024-10-17 11:42:22+02:00 -4
11139519 11139519 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:38:14.000000 26 23 2024-10-17 11:38:14+02:00 -3
11139518 11139518 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:38:08.000000 32 20 2024-10-17 11:38:08+02:00 -12
11139517 11139517 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:37:20.000000 24 26 2024-10-17 11:37:20+02:00 2
11139516 11139516 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:34:28.000000 25 32 2024-10-17 11:34:28+02:00 7
11139515 11139515 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:31:59.000000 35 26 2024-10-17 11:31:59+02:00 -9
11139514 11139514 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:29:54.000000 31 27 2024-10-17 11:29:54+02:00 -4
11139513 11139513 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:29:49.000000 30 25 2024-10-17 11:29:49+02:00 -5
11139512 11139512 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:29:31.000000 23 23 2024-10-17 11:29:31+02:00 0
11139511 11139511 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:29:15.000000 30 23 2024-10-17 11:29:15+02:00 -7
11139510 11139510 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:25:28.000000 30 25 2024-10-17 11:25:28+02:00 -5
11139509 11139509 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:25:08.000000 31 26 2024-10-17 11:25:08+02:00 -5
11139508 11139508 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:24:01.000000 31 31 2024-10-17 11:24:01+02:00 0
11139507 11139507 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:23:41.000000 36 30 2024-10-17 11:23:41+02:00 -6
11139506 11139506 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:21:56.000000 36 30 2024-10-17 11:21:56+02:00 -6
11139505 11139505 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:21:42.000000 30 25 2024-10-17 11:21:42+02:00 -5
11139504 11139504 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:21:14.000000 31 29 2024-10-17 11:21:14+02:00 -2
11139503 11139503 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:19:01.000000 30 31 2024-10-17 11:19:01+02:00 1
11139502 11139502 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:18:42.000000 41 28 2024-10-17 11:18:42+02:00 -13
11139501 11139501 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:18:16.000000 24 22 2024-10-17 11:18:16+02:00 -2
11139500 11139500 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:17:57.000000 19 18 2024-10-17 11:17:57+02:00 -1
11139499 11139499 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:17:49.000000 23 18 2024-10-17 11:17:49+02:00 -5
11139498 11139498 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:16:27.000000 25 22 2024-10-17 11:16:27+02:00 -3
11139497 11139497 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:15:42.000000 34 23 2024-10-17 11:15:42+02:00 -11
11139496 11139496 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:15:15.000000 28 27 2024-10-17 11:15:15+02:00 -1
11139495 11139495 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:15:08.000000 20 22 2024-10-17 11:15:08+02:00 2
11139494 11139494 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:15:02.000000 40 32 2024-10-17 11:15:02+02:00 -8
11139493 11139493 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:13:58.000000 33 29 2024-10-17 11:13:58+02:00 -4
11139492 11139492 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:13:51.000000 27 23 2024-10-17 11:13:51+02:00 -4
11139491 11139491 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:12:31.000000 29 16 2024-10-17 11:12:31+02:00 -13
11139490 11139490 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:10:37.000000 30 17 2024-10-17 11:10:37+02:00 -13
11139489 11139489 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:10:24.000000 24 20 2024-10-17 11:10:24+02:00 -4
11139488 11139488 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:09:50.000000 15 11 2024-10-17 11:09:50+02:00 -4
11139487 11139487 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:08:55.000000 32 28 2024-10-17 11:08:55+02:00 -4
11139486 11139486 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:08:46.000000 31 26 2024-10-17 11:08:46+02:00 -5
11139485 11139485 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:07:28.000000 20 22 2024-10-17 11:07:28+02:00 2
11139484 11139484 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:06:55.000000 33 28 2024-10-17 11:06:55+02:00 -5
11139483 11139483 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:05:28.000000 28 27 2024-10-17 11:05:28+02:00 -1
11139482 11139482 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:04:53.000000 33 27 2024-10-17 11:04:53+02:00 -6
11139481 11139481 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:04:26.000000 48 33 2024-10-17 11:04:26+02:00 -15
11139480 11139480 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:04:12.000000 27 17 2024-10-17 11:04:12+02:00 -10
11139479 11139479 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:02:57.000000 31 30 2024-10-17 11:02:57+02:00 -1
11139478 11139478 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:01:35.000000 31 22 2024-10-17 11:01:35+02:00 -9
11139477 11139477 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 11:01:01.000000 28 25 2024-10-17 11:01:01+02:00 -3
11139476 11139476 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:59:23.000000 30 23 2024-10-17 10:59:23+02:00 -7
11139475 11139475 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:59:05.000000 29 22 2024-10-17 10:59:05+02:00 -7
11139474 11139474 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:58:20.000000 35 28 2024-10-17 10:58:20+02:00 -7
11139473 11139473 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:58:15.000000 31 27 2024-10-17 10:58:15+02:00 -4
11139472 11139472 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:57:57.000000 35 25 2024-10-17 10:57:57+02:00 -10
11139471 11139471 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:57:24.000000 29 8 2024-10-17 10:57:24+02:00 -21
11139470 11139470 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:56:38.000000 29 29 2024-10-17 10:56:38+02:00 0
11139469 11139469 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:53:22.000000 30 26 2024-10-17 10:53:22+02:00 -4
11139468 11139468 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:51:42.000000 33 26 2024-10-17 10:51:42+02:00 -7
11139467 11139467 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:51:09.000000 38 35 2024-10-17 10:51:09+02:00 -3
11139466 11139466 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:50:47.000000 25 22 2024-10-17 10:50:47+02:00 -3
11139465 11139465 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:50:03.000000 37 28 2024-10-17 10:50:03+02:00 -9
11139464 11139464 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:49:37.000000 28 20 2024-10-17 10:49:37+02:00 -8
11139463 11139463 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:46:50.000000 34 28 2024-10-17 10:46:50+02:00 -6
11139462 11139462 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:46:11.000000 33 23 2024-10-17 10:46:11+02:00 -10
11139461 11139461 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:46:07.000000 33 23 2024-10-17 10:46:07+02:00 -10
11139460 11139460 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:45:50.000000 30 34 2024-10-17 10:45:50+02:00 4
11139459 11139459 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:45:37.000000 32 25 2024-10-17 10:45:37+02:00 -7
11139458 11139458 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:43:17.000000 13 28 2024-10-17 10:43:17+02:00 15
11139457 11139457 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:42:24.000000 28 28 2024-10-17 10:42:24+02:00 0
11139456 11139456 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:41:54.000000 31 27 2024-10-17 10:41:54+02:00 -4
11139455 11139455 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:40:50.000000 36 30 2024-10-17 10:40:50+02:00 -6
11139454 11139454 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:38:54.000000 33 30 2024-10-17 10:38:54+02:00 -3
11139453 11139453 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:37:17.000000 37 31 2024-10-17 10:37:17+02:00 -6
11139452 11139452 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:37:12.000000 33 27 2024-10-17 10:37:12+02:00 -6
11139451 11139451 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:36:55.000000 27 22 2024-10-17 10:36:55+02:00 -5
11139450 11139450 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:36:12.000000 25 9 2024-10-17 10:36:12+02:00 -16
11139449 11139449 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:36:00.000000 27 24 2024-10-17 10:36:00+02:00 -3
11139448 11139448 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:35:31.000000 31 24 2024-10-17 10:35:31+02:00 -7
11139447 11139447 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:34:24.000000 37 27 2024-10-17 10:34:24+02:00 -10
11139446 11139446 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:33:45.000000 25 13 2024-10-17 10:33:45+02:00 -12
11139445 11139445 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:33:11.000000 31 31 2024-10-17 10:33:11+02:00 0
11139444 11139444 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:31:18.000000 34 31 2024-10-17 10:31:18+02:00 -3
11139443 11139443 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:30:50.000000 33 26 2024-10-17 10:30:50+02:00 -7
11139442 11139442 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:26:28.000000 28 26 2024-10-17 10:26:28+02:00 -2
11139441 11139441 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:26:04.000000 24 22 2024-10-17 10:26:04+02:00 -2
11139440 11139440 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:25:25.000000 35 27 2024-10-17 10:25:25+02:00 -8
11139439 11139439 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:24:55.000000 33 23 2024-10-17 10:24:55+02:00 -10
11139438 11139438 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:24:14.000000 3 9 2024-10-17 10:24:14+02:00 6
11139437 11139437 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:23:22.000000 23 29 2024-10-17 10:23:22+02:00 6
11139436 11139436 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:20:32.000000 17 33 2024-10-17 10:20:32+02:00 16
11139435 11139435 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:19:47.000000 55 45 2024-10-17 10:19:47+02:00 -10
11139434 11139434 Gellertstrasse  4-41 41 4 Nachmessung 2024-10-17 10:17:56.000000 36 29 2024-10-17 10:17:56+02:00 -7

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