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-56" 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
17135931 17135931 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 14:15:12.000000 23 30 2024-10-17 14:15:12+02:00 7
17135930 17135930 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 14:08:18.000000 25 23 2024-10-17 14:08:18+02:00 -2
17135929 17135929 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 14:01:52.000000 32 27 2024-10-17 14:01:52+02:00 -5
17135928 17135928 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:58:09.000000 23 26 2024-10-17 13:58:09+02:00 3
17135927 17135927 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:57:44.000000 26 28 2024-10-17 13:57:44+02:00 2
17135926 17135926 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:55:50.000000 20 27 2024-10-17 13:55:50+02:00 7
17135925 17135925 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:55:06.000000 24 20 2024-10-17 13:55:06+02:00 -4
17135924 17135924 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:53:04.000000 8 13 2024-10-17 13:53:04+02:00 5
17135923 17135923 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:51:34.000000 27 29 2024-10-17 13:51:34+02:00 2
17135922 17135922 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:51:19.000000 25 32 2024-10-17 13:51:19+02:00 7
17135921 17135921 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:50:18.000000 18 27 2024-10-17 13:50:18+02:00 9
17135920 17135920 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:43:32.000000 31 25 2024-10-17 13:43:32+02:00 -6
17135919 17135919 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:43:23.000000 14 26 2024-10-17 13:43:23+02:00 12
17135918 17135918 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:33:47.000000 30 28 2024-10-17 13:33:47+02:00 -2
17135917 17135917 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:30:51.000000 26 27 2024-10-17 13:30:51+02:00 1
17135916 17135916 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:22:25.000000 28 33 2024-10-17 13:22:25+02:00 5
17135915 17135915 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:17:13.000000 29 26 2024-10-17 13:17:13+02:00 -3
17135914 17135914 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:14:24.000000 33 29 2024-10-17 13:14:24+02:00 -4
17135913 17135913 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:14:04.000000 28 32 2024-10-17 13:14:04+02:00 4
17135912 17135912 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:10:57.000000 27 20 2024-10-17 13:10:57+02:00 -7
17135911 17135911 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:06:57.000000 25 28 2024-10-17 13:06:57+02:00 3
17135910 17135910 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:06:27.000000 25 29 2024-10-17 13:06:27+02:00 4
17135909 17135909 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:03:34.000000 23 34 2024-10-17 13:03:34+02:00 11
17135908 17135908 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 13:00:16.000000 39 38 2024-10-17 13:00:16+02:00 -1
17135907 17135907 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:51:01.000000 25 22 2024-10-17 12:51:01+02:00 -3
17135906 17135906 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:49:23.000000 26 24 2024-10-17 12:49:23+02:00 -2
17135905 17135905 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:47:20.000000 24 22 2024-10-17 12:47:20+02:00 -2
17135904 17135904 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:30:31.000000 31 27 2024-10-17 12:30:31+02:00 -4
17135903 17135903 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:26:33.000000 24 25 2024-10-17 12:26:33+02:00 1
17135902 17135902 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:21:06.000000 13 27 2024-10-17 12:21:06+02:00 14
17135901 17135901 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:19:50.000000 30 29 2024-10-17 12:19:50+02:00 -1
17135900 17135900 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:16:27.000000 19 22 2024-10-17 12:16:27+02:00 3
17135899 17135899 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:13:33.000000 30 28 2024-10-17 12:13:33+02:00 -2
17135898 17135898 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:09:10.000000 23 27 2024-10-17 12:09:10+02:00 4
17135897 17135897 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:02:43.000000 24 23 2024-10-17 12:02:43+02:00 -1
17135896 17135896 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 12:00:01.000000 33 29 2024-10-17 12:00:01+02:00 -4
17135895 17135895 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 11:51:48.000000 28 29 2024-10-17 11:51:48+02:00 1
17135894 17135894 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 11:47:30.000000 34 34 2024-10-17 11:47:30+02:00 0
17135893 17135893 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 11:41:17.000000 29 38 2024-10-17 11:41:17+02:00 9
17135892 17135892 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 11:29:43.000000 36 32 2024-10-17 11:29:43+02:00 -4
17135891 17135891 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 11:29:34.000000 25 28 2024-10-17 11:29:34+02:00 3
17135890 17135890 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 11:22:14.000000 29 26 2024-10-17 11:22:14+02:00 -3
17135889 17135889 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 11:03:58.000000 33 32 2024-10-17 11:03:58+02:00 -1
17135888 17135888 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 11:02:29.000000 25 27 2024-10-17 11:02:29+02:00 2
17135887 17135887 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:58:45.000000 35 36 2024-10-17 10:58:45+02:00 1
17135886 17135886 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:58:30.000000 28 28 2024-10-17 10:58:30+02:00 0
17135885 17135885 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:57:01.000000 28 30 2024-10-17 10:57:01+02:00 2
17135884 17135884 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:52:44.000000 30 34 2024-10-17 10:52:44+02:00 4
17135883 17135883 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:50:21.000000 23 23 2024-10-17 10:50:21+02:00 0
17135882 17135882 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:49:50.000000 18 23 2024-10-17 10:49:50+02:00 5
17135881 17135881 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:48:58.000000 31 24 2024-10-17 10:48:58+02:00 -7
17135880 17135880 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:36:35.000000 25 28 2024-10-17 10:36:35+02:00 3
17135879 17135879 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:34:13.000000 34 31 2024-10-17 10:34:13+02:00 -3
17135878 17135878 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:27:20.000000 34 29 2024-10-17 10:27:20+02:00 -5
17135877 17135877 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:26:46.000000 28 31 2024-10-17 10:26:46+02:00 3
17135876 17135876 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:26:36.000000 31 37 2024-10-17 10:26:36+02:00 6
17135875 17135875 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:25:43.000000 27 28 2024-10-17 10:25:43+02:00 1
17135874 17135874 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:07:52.000000 16 24 2024-10-17 10:07:52+02:00 8
17135873 17135873 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:05:53.000000 24 23 2024-10-17 10:05:53+02:00 -1
17135872 17135872 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:01:56.000000 29 29 2024-10-17 10:01:56+02:00 0
17135871 17135871 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 10:01:44.000000 36 35 2024-10-17 10:01:44+02:00 -1
17135870 17135870 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:56:28.000000 20 25 2024-10-17 09:56:28+02:00 5
17135869 17135869 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:54:23.000000 31 41 2024-10-17 09:54:23+02:00 10
17135868 17135868 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:38:24.000000 30 32 2024-10-17 09:38:24+02:00 2
17135867 17135867 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:37:54.000000 29 27 2024-10-17 09:37:54+02:00 -2
17135866 17135866 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:36:56.000000 25 28 2024-10-17 09:36:56+02:00 3
17135865 17135865 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:33:39.000000 31 25 2024-10-17 09:33:39+02:00 -6
17135864 17135864 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:30:07.000000 26 25 2024-10-17 09:30:07+02:00 -1
17135863 17135863 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:21:27.000000 35 28 2024-10-17 09:21:27+02:00 -7
17135862 17135862 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:20:18.000000 27 26 2024-10-17 09:20:18+02:00 -1
17135861 17135861 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:10:52.000000 28 25 2024-10-17 09:10:52+02:00 -3
17135860 17135860 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:10:20.000000 30 31 2024-10-17 09:10:20+02:00 1
17135859 17135859 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:06:10.000000 29 24 2024-10-17 09:06:10+02:00 -5
17135858 17135858 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 09:03:53.000000 26 27 2024-10-17 09:03:53+02:00 1
17135857 17135857 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:58:08.000000 25 20 2024-10-17 08:58:08+02:00 -5
17135856 17135856 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:56:26.000000 35 37 2024-10-17 08:56:26+02:00 2
17135855 17135855 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:49:45.000000 30 24 2024-10-17 08:49:45+02:00 -6
17135854 17135854 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:39:59.000000 19 28 2024-10-17 08:39:59+02:00 9
17135853 17135853 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:35:37.000000 26 26 2024-10-17 08:35:37+02:00 0
17135852 17135852 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:34:37.000000 36 36 2024-10-17 08:34:37+02:00 0
17135851 17135851 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:33:34.000000 31 29 2024-10-17 08:33:34+02:00 -2
17135850 17135850 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:33:07.000000 28 33 2024-10-17 08:33:07+02:00 5
17135849 17135849 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:28:24.000000 31 27 2024-10-17 08:28:24+02:00 -4
17135848 17135848 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:21:48.000000 29 31 2024-10-17 08:21:48+02:00 2
17135847 17135847 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:20:38.000000 34 34 2024-10-17 08:20:38+02:00 0
17135846 17135846 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:18:05.000000 28 27 2024-10-17 08:18:05+02:00 -1
17135845 17135845 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:09:02.000000 33 35 2024-10-17 08:09:02+02:00 2
17135844 17135844 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 08:01:06.000000 31 43 2024-10-17 08:01:06+02:00 12
17135843 17135843 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:53:27.000000 30 32 2024-10-17 07:53:27+02:00 2
17135842 17135842 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:51:26.000000 23 37 2024-10-17 07:51:26+02:00 14
17135841 17135841 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:50:05.000000 26 28 2024-10-17 07:50:05+02:00 2
17135840 17135840 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:46:39.000000 31 34 2024-10-17 07:46:39+02:00 3
17135839 17135839 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:46:36.000000 24 28 2024-10-17 07:46:36+02:00 4
17135838 17135838 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:43:14.000000 32 28 2024-10-17 07:43:14+02:00 -4
17135837 17135837 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:39:44.000000 32 37 2024-10-17 07:39:44+02:00 5
17135836 17135836 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:35:12.000000 26 22 2024-10-17 07:35:12+02:00 -4
17135835 17135835 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:33:58.000000 31 31 2024-10-17 07:33:58+02:00 0
17135834 17135834 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:33:48.000000 24 25 2024-10-17 07:33:48+02:00 1
17135833 17135833 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:33:30.000000 32 30 2024-10-17 07:33:30+02:00 -2
17135832 17135832 Oscar Frey-Strasse 4-56 56 4 Nachmessung 2024-10-17 07:27:50.000000 31 31 2024-10-17 07:27:50+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