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-35" sorted by Messung_Timestamp descending
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 12361813 | 12361813 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:45:08.000000 | 25 | 23 | 2024-10-17 11:45:08+02:00 | -2 |
| 12361812 | 12361812 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:43:34.000000 | 28 | 17 | 2024-10-17 11:43:34+02:00 | -11 |
| 12361811 | 12361811 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:41:15.000000 | 25 | 24 | 2024-10-17 11:41:15+02:00 | -1 |
| 12361810 | 12361810 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:40:54.000000 | 36 | 32 | 2024-10-17 11:40:54+02:00 | -4 |
| 12361809 | 12361809 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:36:08.000000 | 29 | 31 | 2024-10-17 11:36:08+02:00 | 2 |
| 12361808 | 12361808 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:34:47.000000 | 12 | 13 | 2024-10-17 11:34:47+02:00 | 1 |
| 12361807 | 12361807 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:33:55.000000 | 18 | 17 | 2024-10-17 11:33:55+02:00 | -1 |
| 12361806 | 12361806 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:30:45.000000 | 31 | 23 | 2024-10-17 11:30:45+02:00 | -8 |
| 12361805 | 12361805 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:30:36.000000 | 16 | 18 | 2024-10-17 11:30:36+02:00 | 2 |
| 12361804 | 12361804 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:29:54.000000 | 43 | 34 | 2024-10-17 11:29:54+02:00 | -9 |
| 12361803 | 12361803 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:26:30.000000 | 27 | 30 | 2024-10-17 11:26:30+02:00 | 3 |
| 12361802 | 12361802 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:23:46.000000 | 28 | 28 | 2024-10-17 11:23:46+02:00 | 0 |
| 12361801 | 12361801 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:20:44.000000 | 27 | 20 | 2024-10-17 11:20:44+02:00 | -7 |
| 12361800 | 12361800 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:20:41.000000 | 35 | 31 | 2024-10-17 11:20:41+02:00 | -4 |
| 12361799 | 12361799 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:20:32.000000 | 30 | 27 | 2024-10-17 11:20:32+02:00 | -3 |
| 12361798 | 12361798 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:19:44.000000 | 19 | 27 | 2024-10-17 11:19:44+02:00 | 8 |
| 12361797 | 12361797 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:18:06.000000 | 24 | 22 | 2024-10-17 11:18:06+02:00 | -2 |
| 12361796 | 12361796 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:17:50.000000 | 26 | 22 | 2024-10-17 11:17:50+02:00 | -4 |
| 12361795 | 12361795 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:17:38.000000 | 26 | 25 | 2024-10-17 11:17:38+02:00 | -1 |
| 12361794 | 12361794 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:16:58.000000 | 32 | 29 | 2024-10-17 11:16:58+02:00 | -3 |
| 12361793 | 12361793 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:15:38.000000 | 28 | 26 | 2024-10-17 11:15:38+02:00 | -2 |
| 12361792 | 12361792 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:14:22.000000 | 34 | 33 | 2024-10-17 11:14:22+02:00 | -1 |
| 12361791 | 12361791 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:13:42.000000 | 30 | 29 | 2024-10-17 11:13:42+02:00 | -1 |
| 12361790 | 12361790 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:12:49.000000 | 32 | 26 | 2024-10-17 11:12:49+02:00 | -6 |
| 12361789 | 12361789 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:12:25.000000 | 32 | 39 | 2024-10-17 11:12:25+02:00 | 7 |
| 12361788 | 12361788 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:11:21.000000 | 25 | 22 | 2024-10-17 11:11:21+02:00 | -3 |
| 12361787 | 12361787 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:10:06.000000 | 31 | 27 | 2024-10-17 11:10:06+02:00 | -4 |
| 12361786 | 12361786 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:09:57.000000 | 26 | 30 | 2024-10-17 11:09:57+02:00 | 4 |
| 12361785 | 12361785 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:09:44.000000 | 30 | 24 | 2024-10-17 11:09:44+02:00 | -6 |
| 12361784 | 12361784 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:08:23.000000 | 20 | 26 | 2024-10-17 11:08:23+02:00 | 6 |
| 12361783 | 12361783 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:08:07.000000 | 25 | 20 | 2024-10-17 11:08:07+02:00 | -5 |
| 12361782 | 12361782 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:07:08.000000 | 23 | 26 | 2024-10-17 11:07:08+02:00 | 3 |
| 12361781 | 12361781 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:04:04.000000 | 15 | 24 | 2024-10-17 11:04:04+02:00 | 9 |
| 12361780 | 12361780 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:02:18.000000 | 17 | 30 | 2024-10-17 11:02:18+02:00 | 13 |
| 12361779 | 12361779 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 11:00:52.000000 | 20 | 25 | 2024-10-17 11:00:52+02:00 | 5 |
| 12361778 | 12361778 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:57:26.000000 | 35 | 33 | 2024-10-17 10:57:26+02:00 | -2 |
| 12361777 | 12361777 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:55:03.000000 | 20 | 26 | 2024-10-17 10:55:03+02:00 | 6 |
| 12361776 | 12361776 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:48:45.000000 | 19 | 25 | 2024-10-17 10:48:45+02:00 | 6 |
| 12361775 | 12361775 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:47:57.000000 | 32 | 29 | 2024-10-17 10:47:57+02:00 | -3 |
| 12361774 | 12361774 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:47:39.000000 | 23 | 24 | 2024-10-17 10:47:39+02:00 | 1 |
| 12361773 | 12361773 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:46:02.000000 | 27 | 30 | 2024-10-17 10:46:02+02:00 | 3 |
| 12361772 | 12361772 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:44:39.000000 | 29 | 28 | 2024-10-17 10:44:39+02:00 | -1 |
| 12361771 | 12361771 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:42:10.000000 | 31 | 26 | 2024-10-17 10:42:10+02:00 | -5 |
| 12361770 | 12361770 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:39:03.000000 | 31 | 25 | 2024-10-17 10:39:03+02:00 | -6 |
| 12361769 | 12361769 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:38:46.000000 | 31 | 28 | 2024-10-17 10:38:46+02:00 | -3 |
| 12361768 | 12361768 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:35:33.000000 | 18 | 22 | 2024-10-17 10:35:33+02:00 | 4 |
| 12361767 | 12361767 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:33:55.000000 | 20 | 27 | 2024-10-17 10:33:55+02:00 | 7 |
| 12361766 | 12361766 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:32:17.000000 | 24 | 27 | 2024-10-17 10:32:17+02:00 | 3 |
| 12361765 | 12361765 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:31:55.000000 | 28 | 20 | 2024-10-17 10:31:55+02:00 | -8 |
| 12361764 | 12361764 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:31:44.000000 | 23 | 27 | 2024-10-17 10:31:44+02:00 | 4 |
| 12361763 | 12361763 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:30:08.000000 | 24 | 24 | 2024-10-17 10:30:08+02:00 | 0 |
| 12361762 | 12361762 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:24:49.000000 | 25 | 29 | 2024-10-17 10:24:49+02:00 | 4 |
| 12361761 | 12361761 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:24:42.000000 | 23 | 28 | 2024-10-17 10:24:42+02:00 | 5 |
| 12361760 | 12361760 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:22:57.000000 | 33 | 23 | 2024-10-17 10:22:57+02:00 | -10 |
| 12361759 | 12361759 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:22:33.000000 | 33 | 31 | 2024-10-17 10:22:33+02:00 | -2 |
| 12361758 | 12361758 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:22:09.000000 | 14 | 18 | 2024-10-17 10:22:09+02:00 | 4 |
| 12361757 | 12361757 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:21:02.000000 | 19 | 27 | 2024-10-17 10:21:02+02:00 | 8 |
| 12361756 | 12361756 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:19:04.000000 | 25 | 19 | 2024-10-17 10:19:04+02:00 | -6 |
| 12361755 | 12361755 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:16:13.000000 | 23 | 25 | 2024-10-17 10:16:13+02:00 | 2 |
| 12361754 | 12361754 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:13:25.000000 | 31 | 27 | 2024-10-17 10:13:25+02:00 | -4 |
| 12361753 | 12361753 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:13:23.000000 | 23 | 24 | 2024-10-17 10:13:23+02:00 | 1 |
| 12361752 | 12361752 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:08:32.000000 | 24 | 23 | 2024-10-17 10:08:32+02:00 | -1 |
| 12361751 | 12361751 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:07:12.000000 | 28 | 23 | 2024-10-17 10:07:12+02:00 | -5 |
| 12361750 | 12361750 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:05:55.000000 | 27 | 28 | 2024-10-17 10:05:55+02:00 | 1 |
| 12361749 | 12361749 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:01:17.000000 | 23 | 22 | 2024-10-17 10:01:17+02:00 | -1 |
| 12361748 | 12361748 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:00:55.000000 | 19 | 14 | 2024-10-17 10:00:55+02:00 | -5 |
| 12361747 | 12361747 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 10:00:27.000000 | 28 | 25 | 2024-10-17 10:00:27+02:00 | -3 |
| 12361746 | 12361746 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:58:06.000000 | 24 | 20 | 2024-10-17 09:58:06+02:00 | -4 |
| 12361745 | 12361745 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:54:40.000000 | 20 | 32 | 2024-10-17 09:54:40+02:00 | 12 |
| 12361744 | 12361744 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:51:35.000000 | 28 | 25 | 2024-10-17 09:51:35+02:00 | -3 |
| 12361743 | 12361743 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:51:16.000000 | 25 | 24 | 2024-10-17 09:51:16+02:00 | -1 |
| 12361742 | 12361742 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:51:06.000000 | 32 | 27 | 2024-10-17 09:51:06+02:00 | -5 |
| 12361741 | 12361741 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:50:46.000000 | 16 | 20 | 2024-10-17 09:50:46+02:00 | 4 |
| 12361740 | 12361740 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:46:59.000000 | 28 | 29 | 2024-10-17 09:46:59+02:00 | 1 |
| 12361739 | 12361739 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:42:00.000000 | 26 | 22 | 2024-10-17 09:42:00+02:00 | -4 |
| 12361738 | 12361738 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:38:34.000000 | 38 | 36 | 2024-10-17 09:38:34+02:00 | -2 |
| 12361737 | 12361737 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:37:39.000000 | 18 | 29 | 2024-10-17 09:37:39+02:00 | 11 |
| 12361736 | 12361736 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:32:47.000000 | 12 | 33 | 2024-10-17 09:32:47+02:00 | 21 |
| 12361735 | 12361735 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:31:53.000000 | 25 | 26 | 2024-10-17 09:31:53+02:00 | 1 |
| 12361734 | 12361734 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:31:17.000000 | 26 | 26 | 2024-10-17 09:31:17+02:00 | 0 |
| 12361733 | 12361733 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:26:47.000000 | 29 | 25 | 2024-10-17 09:26:47+02:00 | -4 |
| 12361732 | 12361732 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:26:20.000000 | 25 | 23 | 2024-10-17 09:26:20+02:00 | -2 |
| 12361731 | 12361731 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:23:56.000000 | 32 | 34 | 2024-10-17 09:23:56+02:00 | 2 |
| 12361730 | 12361730 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:21:15.000000 | 25 | 27 | 2024-10-17 09:21:15+02:00 | 2 |
| 12361729 | 12361729 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:21:03.000000 | 23 | 24 | 2024-10-17 09:21:03+02:00 | 1 |
| 12361728 | 12361728 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:17:58.000000 | 20 | 26 | 2024-10-17 09:17:58+02:00 | 6 |
| 12361727 | 12361727 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:17:15.000000 | 25 | 24 | 2024-10-17 09:17:15+02:00 | -1 |
| 12361726 | 12361726 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:14:21.000000 | 26 | 18 | 2024-10-17 09:14:21+02:00 | -8 |
| 12361725 | 12361725 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:13:25.000000 | 28 | 22 | 2024-10-17 09:13:25+02:00 | -6 |
| 12361724 | 12361724 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:13:04.000000 | 25 | 24 | 2024-10-17 09:13:04+02:00 | -1 |
| 12361723 | 12361723 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:11:00.000000 | 28 | 29 | 2024-10-17 09:11:00+02:00 | 1 |
| 12361722 | 12361722 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:09:48.000000 | 30 | 31 | 2024-10-17 09:09:48+02:00 | 1 |
| 12361721 | 12361721 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:07:49.000000 | 23 | 33 | 2024-10-17 09:07:49+02:00 | 10 |
| 12361720 | 12361720 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:05:33.000000 | 24 | 23 | 2024-10-17 09:05:33+02:00 | -1 |
| 12361719 | 12361719 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:02:39.000000 | 25 | 26 | 2024-10-17 09:02:39+02:00 | 1 |
| 12361718 | 12361718 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:01:36.000000 | 14 | 29 | 2024-10-17 09:01:36+02:00 | 15 |
| 12361717 | 12361717 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 09:00:00.000000 | 29 | 26 | 2024-10-17 09:00:00+02:00 | -3 |
| 12361716 | 12361716 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 08:59:15.000000 | 27 | 26 | 2024-10-17 08:59:15+02:00 | -1 |
| 12361715 | 12361715 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 08:56:59.000000 | 31 | 28 | 2024-10-17 08:56:59+02:00 | -3 |
| 12361714 | 12361714 | Engelgasse 4-35 | 35 | 4 | Nachmessung | 2024-10-17 | 08:56:33.000000 | 20 | 25 | 2024-10-17 08:56:33+02:00 | 5 |
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");