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-37" sorted by Messung_Timestamp descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
11013896 | 11013896 | Adlerstrasse 1-37 | 37 | 1 | Nach Ende | 2023-07-10 | 09:02:34.000000 | 26 | 25 | 2023-07-10 09:02:34+02:00 | -1 |
11013895 | 11013895 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 09:01:13.000000 | 40 | 36 | 2023-07-10 09:01:13+02:00 | -4 |
11013894 | 11013894 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:59:27.000000 | 32 | 30 | 2023-07-10 08:59:27+02:00 | -2 |
11013893 | 11013893 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:58:41.000000 | 46 | 38 | 2023-07-10 08:58:41+02:00 | -8 |
11013892 | 11013892 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:58:29.000000 | 49 | 34 | 2023-07-10 08:58:29+02:00 | -15 |
11013891 | 11013891 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:58:23.000000 | 39 | 43 | 2023-07-10 08:58:23+02:00 | 4 |
11013890 | 11013890 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:58:13.000000 | 36 | 30 | 2023-07-10 08:58:13+02:00 | -6 |
11013889 | 11013889 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:58:04.000000 | 32 | 35 | 2023-07-10 08:58:04+02:00 | 3 |
11013888 | 11013888 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:57:53.000000 | 34 | 30 | 2023-07-10 08:57:53+02:00 | -4 |
11013887 | 11013887 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:57:25.000000 | 54 | 43 | 2023-07-10 08:57:25+02:00 | -11 |
11013886 | 11013886 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:56:33.000000 | 45 | 43 | 2023-07-10 08:56:33+02:00 | -2 |
11013885 | 11013885 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:56:25.000000 | 39 | 43 | 2023-07-10 08:56:25+02:00 | 4 |
11013884 | 11013884 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:56:20.000000 | 23 | 17 | 2023-07-10 08:56:20+02:00 | -6 |
11013883 | 11013883 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:55:04.000000 | 19 | 24 | 2023-07-10 08:55:04+02:00 | 5 |
11013882 | 11013882 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:54:50.000000 | 32 | 35 | 2023-07-10 08:54:50+02:00 | 3 |
11013881 | 11013881 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:54:01.000000 | 31 | 27 | 2023-07-10 08:54:01+02:00 | -4 |
11013880 | 11013880 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:53:59.000000 | 29 | 26 | 2023-07-10 08:53:59+02:00 | -3 |
11013879 | 11013879 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:53:49.000000 | 29 | 28 | 2023-07-10 08:53:49+02:00 | -1 |
11013878 | 11013878 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:53:47.000000 | 17 | 29 | 2023-07-10 08:53:47+02:00 | 12 |
11013877 | 11013877 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:52:56.000000 | 34 | 29 | 2023-07-10 08:52:56+02:00 | -5 |
11013876 | 11013876 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:52:43.000000 | 33 | 33 | 2023-07-10 08:52:43+02:00 | 0 |
11013875 | 11013875 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:52:06.000000 | 38 | 40 | 2023-07-10 08:52:06+02:00 | 2 |
11013874 | 11013874 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:49:41.000000 | 43 | 43 | 2023-07-10 08:49:41+02:00 | 0 |
11013873 | 11013873 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:49:37.000000 | 47 | 46 | 2023-07-10 08:49:37+02:00 | -1 |
11013872 | 11013872 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:49:34.000000 | 38 | 41 | 2023-07-10 08:49:34+02:00 | 3 |
11013871 | 11013871 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:49:28.000000 | 38 | 43 | 2023-07-10 08:49:28+02:00 | 5 |
11013870 | 11013870 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:48:57.000000 | 27 | 29 | 2023-07-10 08:48:57+02:00 | 2 |
11013869 | 11013869 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:48:56.000000 | 30 | 30 | 2023-07-10 08:48:56+02:00 | 0 |
11013868 | 11013868 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:48:45.000000 | 30 | 28 | 2023-07-10 08:48:45+02:00 | -2 |
11013867 | 11013867 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:48:35.000000 | 27 | 30 | 2023-07-10 08:48:35+02:00 | 3 |
11013866 | 11013866 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:47:56.000000 | 47 | 38 | 2023-07-10 08:47:56+02:00 | -9 |
11013865 | 11013865 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:45:53.000000 | 41 | 48 | 2023-07-10 08:45:53+02:00 | 7 |
11013864 | 11013864 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:45:44.000000 | 40 | 34 | 2023-07-10 08:45:44+02:00 | -6 |
11013863 | 11013863 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:45:32.000000 | 32 | 37 | 2023-07-10 08:45:32+02:00 | 5 |
11013862 | 11013862 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:45:28.000000 | 45 | 45 | 2023-07-10 08:45:28+02:00 | 0 |
11013861 | 11013861 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:44:47.000000 | 36 | 32 | 2023-07-10 08:44:47+02:00 | -4 |
11013860 | 11013860 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:44:42.000000 | 27 | 33 | 2023-07-10 08:44:42+02:00 | 6 |
11013858 | 11013858 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:40:10.000000 | 30 | 33 | 2023-07-10 08:40:10+02:00 | 3 |
11013859 | 11013859 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:40:10.000000 | 35 | 36 | 2023-07-10 08:40:10+02:00 | 1 |
11013857 | 11013857 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:39:25.000000 | 33 | 29 | 2023-07-10 08:39:25+02:00 | -4 |
11013856 | 11013856 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:39:05.000000 | 29 | 23 | 2023-07-10 08:39:05+02:00 | -6 |
11013855 | 11013855 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:38:59.000000 | 30 | 24 | 2023-07-10 08:38:59+02:00 | -6 |
11013854 | 11013854 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:38:49.000000 | 28 | 29 | 2023-07-10 08:38:49+02:00 | 1 |
11013853 | 11013853 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:38:48.000000 | 34 | 30 | 2023-07-10 08:38:48+02:00 | -4 |
11013852 | 11013852 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:38:38.000000 | 29 | 29 | 2023-07-10 08:38:38+02:00 | 0 |
11013851 | 11013851 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:38:32.000000 | 30 | 28 | 2023-07-10 08:38:32+02:00 | -2 |
11013850 | 11013850 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:38:27.000000 | 24 | 24 | 2023-07-10 08:38:27+02:00 | 0 |
11013849 | 11013849 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:37:30.000000 | 16 | 32 | 2023-07-10 08:37:30+02:00 | 16 |
11013848 | 11013848 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:36:32.000000 | 33 | 29 | 2023-07-10 08:36:32+02:00 | -4 |
11013847 | 11013847 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:36:23.000000 | 26 | 31 | 2023-07-10 08:36:23+02:00 | 5 |
11013846 | 11013846 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:36:12.000000 | 39 | 34 | 2023-07-10 08:36:12+02:00 | -5 |
11013845 | 11013845 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:35:35.000000 | 26 | 37 | 2023-07-10 08:35:35+02:00 | 11 |
11013844 | 11013844 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:34:35.000000 | 32 | 34 | 2023-07-10 08:34:35+02:00 | 2 |
11013843 | 11013843 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:33:49.000000 | 38 | 35 | 2023-07-10 08:33:49+02:00 | -3 |
11013842 | 11013842 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:33:39.000000 | 35 | 38 | 2023-07-10 08:33:39+02:00 | 3 |
11013841 | 11013841 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:32:55.000000 | 40 | 38 | 2023-07-10 08:32:55+02:00 | -2 |
11013840 | 11013840 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:32:51.000000 | 37 | 41 | 2023-07-10 08:32:51+02:00 | 4 |
11013839 | 11013839 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:32:41.000000 | 38 | 33 | 2023-07-10 08:32:41+02:00 | -5 |
11013838 | 11013838 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:31:22.000000 | 38 | 28 | 2023-07-10 08:31:22+02:00 | -10 |
11013837 | 11013837 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:31:18.000000 | 32 | 22 | 2023-07-10 08:31:18+02:00 | -10 |
11013836 | 11013836 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:31:09.000000 | 23 | 28 | 2023-07-10 08:31:09+02:00 | 5 |
11013835 | 11013835 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:31:08.000000 | 29 | 31 | 2023-07-10 08:31:08+02:00 | 2 |
11013834 | 11013834 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:30:58.000000 | 19 | 28 | 2023-07-10 08:30:58+02:00 | 9 |
11013833 | 11013833 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:30:02.000000 | 26 | 22 | 2023-07-10 08:30:02+02:00 | -4 |
11013832 | 11013832 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:28:22.000000 | 17 | 30 | 2023-07-10 08:28:22+02:00 | 13 |
11013831 | 11013831 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:27:31.000000 | 30 | 32 | 2023-07-10 08:27:31+02:00 | 2 |
11013830 | 11013830 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:27:27.000000 | 29 | 37 | 2023-07-10 08:27:27+02:00 | 8 |
11013829 | 11013829 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:27:18.000000 | 40 | 39 | 2023-07-10 08:27:18+02:00 | -1 |
11013828 | 11013828 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:27:16.000000 | 45 | 43 | 2023-07-10 08:27:16+02:00 | -2 |
11013826 | 11013826 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:26:40.000000 | 37 | 43 | 2023-07-10 08:26:40+02:00 | 6 |
11013827 | 11013827 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:26:40.000000 | 36 | 39 | 2023-07-10 08:26:40+02:00 | 3 |
11013825 | 11013825 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:24:48.000000 | 47 | 40 | 2023-07-10 08:24:48+02:00 | -7 |
11013824 | 11013824 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:24:47.000000 | 35 | 33 | 2023-07-10 08:24:47+02:00 | -2 |
11013823 | 11013823 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:24:38.000000 | 31 | 35 | 2023-07-10 08:24:38+02:00 | 4 |
11013822 | 11013822 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:21:58.000000 | 37 | 43 | 2023-07-10 08:21:58+02:00 | 6 |
11013821 | 11013821 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:21:43.000000 | 46 | 41 | 2023-07-10 08:21:43+02:00 | -5 |
11013820 | 11013820 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:21:26.000000 | 51 | 43 | 2023-07-10 08:21:26+02:00 | -8 |
11013819 | 11013819 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:21:19.000000 | 53 | 49 | 2023-07-10 08:21:19+02:00 | -4 |
11013818 | 11013818 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:20:55.000000 | 55 | 46 | 2023-07-10 08:20:55+02:00 | -9 |
11013817 | 11013817 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:20:49.000000 | 57 | 53 | 2023-07-10 08:20:49+02:00 | -4 |
11013816 | 11013816 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:20:43.000000 | 36 | 35 | 2023-07-10 08:20:43+02:00 | -1 |
11013815 | 11013815 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:20:28.000000 | 19 | 16 | 2023-07-10 08:20:28+02:00 | -3 |
11013814 | 11013814 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:19:52.000000 | 34 | 35 | 2023-07-10 08:19:52+02:00 | 1 |
11013813 | 11013813 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:18:34.000000 | 35 | 38 | 2023-07-10 08:18:34+02:00 | 3 |
11013812 | 11013812 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:17:28.000000 | 35 | 33 | 2023-07-10 08:17:28+02:00 | -2 |
11013811 | 11013811 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:17:18.000000 | 29 | 33 | 2023-07-10 08:17:18+02:00 | 4 |
11013810 | 11013810 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:15:19.000000 | 45 | 43 | 2023-07-10 08:15:19+02:00 | -2 |
11013809 | 11013809 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:14:56.000000 | 39 | 36 | 2023-07-10 08:14:56+02:00 | -3 |
11013808 | 11013808 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:14:48.000000 | 38 | 39 | 2023-07-10 08:14:48+02:00 | 1 |
11013807 | 11013807 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:14:18.000000 | 26 | 22 | 2023-07-10 08:14:18+02:00 | -4 |
11013806 | 11013806 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:13:49.000000 | 46 | 40 | 2023-07-10 08:13:49+02:00 | -6 |
11013805 | 11013805 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:13:42.000000 | 41 | 41 | 2023-07-10 08:13:42+02:00 | 0 |
11013804 | 11013804 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:13:01.000000 | 41 | 39 | 2023-07-10 08:13:01+02:00 | -2 |
11013803 | 11013803 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:10:43.000000 | 45 | 37 | 2023-07-10 08:10:43+02:00 | -8 |
11013802 | 11013802 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:10:01.000000 | 43 | 36 | 2023-07-10 08:10:01+02:00 | -7 |
11013801 | 11013801 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:09:56.000000 | 43 | 33 | 2023-07-10 08:09:56+02:00 | -10 |
11013800 | 11013800 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:09:25.000000 | 33 | 24 | 2023-07-10 08:09:25+02:00 | -9 |
11013799 | 11013799 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:09:15.000000 | 35 | 32 | 2023-07-10 08:09:15+02:00 | -3 |
11013798 | 11013798 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:08:29.000000 | 37 | 33 | 2023-07-10 08:08:29+02:00 | -4 |
11013797 | 11013797 | Adlerstrasse 1-37 | 37 | 1 | Nachmessung | 2023-07-10 | 08:08:22.000000 | 45 | 44 | 2023-07-10 08:08:22+02:00 | -1 |
Advanced export
JSON shape: default, array, newline-delimited
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");