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-16" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 450661 | 450661 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:27:13.000000 | 24 | 17 | 2024-10-17 09:27:13+02:00 | -7 |
| 450660 | 450660 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:26:34.000000 | 9 | 11 | 2024-10-17 09:26:34+02:00 | 2 |
| 450659 | 450659 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:19:58.000000 | 20 | 19 | 2024-10-17 09:19:58+02:00 | -1 |
| 450658 | 450658 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:18:01.000000 | 23 | 22 | 2024-10-17 09:18:01+02:00 | -1 |
| 450657 | 450657 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:14:58.000000 | 30 | 22 | 2024-10-17 09:14:58+02:00 | -8 |
| 450656 | 450656 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:11:01.000000 | 32 | 25 | 2024-10-17 09:11:01+02:00 | -7 |
| 450655 | 450655 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:10:41.000000 | 20 | 19 | 2024-10-17 09:10:41+02:00 | -1 |
| 450654 | 450654 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:06:01.000000 | 13 | 10 | 2024-10-17 09:06:01+02:00 | -3 |
| 450653 | 450653 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:05:50.000000 | 19 | 14 | 2024-10-17 09:05:50+02:00 | -5 |
| 450652 | 450652 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:03:42.000000 | 32 | 25 | 2024-10-17 09:03:42+02:00 | -7 |
| 450651 | 450651 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:03:10.000000 | 17 | 24 | 2024-10-17 09:03:10+02:00 | 7 |
| 450650 | 450650 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 09:01:41.000000 | 26 | 19 | 2024-10-17 09:01:41+02:00 | -7 |
| 450649 | 450649 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 08:59:06.000000 | 18 | 18 | 2024-10-17 08:59:06+02:00 | 0 |
| 450648 | 450648 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 08:53:12.000000 | 25 | 18 | 2024-10-17 08:53:12+02:00 | -7 |
| 450647 | 450647 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 08:45:14.000000 | 19 | 14 | 2024-10-17 08:45:14+02:00 | -5 |
| 450646 | 450646 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 08:42:30.000000 | 25 | 20 | 2024-10-17 08:42:30+02:00 | -5 |
| 450645 | 450645 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 08:36:44.000000 | 29 | 23 | 2024-10-17 08:36:44+02:00 | -6 |
| 450644 | 450644 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 08:34:48.000000 | 28 | 19 | 2024-10-17 08:34:48+02:00 | -9 |
| 450643 | 450643 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 08:27:11.000000 | 20 | 18 | 2024-10-17 08:27:11+02:00 | -2 |
| 450642 | 450642 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 08:21:12.000000 | 19 | 15 | 2024-10-17 08:21:12+02:00 | -4 |
| 450641 | 450641 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 08:06:44.000000 | 20 | 24 | 2024-10-17 08:06:44+02:00 | 4 |
| 450640 | 450640 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:52:43.000000 | 29 | 26 | 2024-10-17 07:52:43+02:00 | -3 |
| 450639 | 450639 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:52:28.000000 | 27 | 27 | 2024-10-17 07:52:28+02:00 | 0 |
| 450638 | 450638 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:34:53.000000 | 17 | 12 | 2024-10-17 07:34:53+02:00 | -5 |
| 450637 | 450637 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:33:19.000000 | 30 | 20 | 2024-10-17 07:33:19+02:00 | -10 |
| 450636 | 450636 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:33:11.000000 | 31 | 25 | 2024-10-17 07:33:11+02:00 | -6 |
| 450635 | 450635 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:32:40.000000 | 29 | 25 | 2024-10-17 07:32:40+02:00 | -4 |
| 450634 | 450634 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:32:32.000000 | 15 | 18 | 2024-10-17 07:32:32+02:00 | 3 |
| 450633 | 450633 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:32:12.000000 | 20 | 22 | 2024-10-17 07:32:12+02:00 | 2 |
| 450632 | 450632 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:30:54.000000 | 28 | 22 | 2024-10-17 07:30:54+02:00 | -6 |
| 450631 | 450631 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:30:32.000000 | 10 | 15 | 2024-10-17 07:30:32+02:00 | 5 |
| 450630 | 450630 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:18:16.000000 | 29 | 27 | 2024-10-17 07:18:16+02:00 | -2 |
| 450629 | 450629 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:14:06.000000 | 28 | 33 | 2024-10-17 07:14:06+02:00 | 5 |
| 450628 | 450628 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 07:06:15.000000 | 28 | 19 | 2024-10-17 07:06:15+02:00 | -9 |
| 450627 | 450627 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:52:11.000000 | 24 | 17 | 2024-10-17 06:52:11+02:00 | -7 |
| 450626 | 450626 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:47:22.000000 | 27 | 26 | 2024-10-17 06:47:22+02:00 | -1 |
| 450625 | 450625 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:47:11.000000 | 31 | 25 | 2024-10-17 06:47:11+02:00 | -6 |
| 450624 | 450624 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:43:24.000000 | 29 | 23 | 2024-10-17 06:43:24+02:00 | -6 |
| 450623 | 450623 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:33:59.000000 | 13 | 14 | 2024-10-17 06:33:59+02:00 | 1 |
| 450622 | 450622 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:33:36.000000 | 20 | 19 | 2024-10-17 06:33:36+02:00 | -1 |
| 450621 | 450621 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:31:47.000000 | 19 | 13 | 2024-10-17 06:31:47+02:00 | -6 |
| 450620 | 450620 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:23:56.000000 | 27 | 24 | 2024-10-17 06:23:56+02:00 | -3 |
| 450619 | 450619 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:20:07.000000 | 18 | 24 | 2024-10-17 06:20:07+02:00 | 6 |
| 450618 | 450618 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:15:40.000000 | 12 | 15 | 2024-10-17 06:15:40+02:00 | 3 |
| 450617 | 450617 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:12:29.000000 | 26 | 22 | 2024-10-17 06:12:29+02:00 | -4 |
| 450616 | 450616 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:09:35.000000 | 25 | 24 | 2024-10-17 06:09:35+02:00 | -1 |
| 450615 | 450615 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:08:48.000000 | 30 | 29 | 2024-10-17 06:08:48+02:00 | -1 |
| 450614 | 450614 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:04:26.000000 | 24 | 15 | 2024-10-17 06:04:26+02:00 | -9 |
| 450613 | 450613 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 06:01:07.000000 | 18 | 12 | 2024-10-17 06:01:07+02:00 | -6 |
| 450612 | 450612 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 05:59:43.000000 | 23 | 25 | 2024-10-17 05:59:43+02:00 | 2 |
| 450611 | 450611 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 05:56:36.000000 | 40 | 27 | 2024-10-17 05:56:36+02:00 | -13 |
| 450610 | 450610 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 05:44:46.000000 | 25 | 23 | 2024-10-17 05:44:46+02:00 | -2 |
| 450609 | 450609 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 05:41:33.000000 | 17 | 25 | 2024-10-17 05:41:33+02:00 | 8 |
| 450608 | 450608 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 05:36:12.000000 | 37 | 32 | 2024-10-17 05:36:12+02:00 | -5 |
| 450607 | 450607 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 05:29:09.000000 | 25 | 24 | 2024-10-17 05:29:09+02:00 | -1 |
| 450606 | 450606 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 05:23:50.000000 | 29 | 30 | 2024-10-17 05:23:50+02:00 | 1 |
| 450605 | 450605 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 04:52:05.000000 | 37 | 29 | 2024-10-17 04:52:05+02:00 | -8 |
| 450604 | 450604 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 03:17:54.000000 | 29 | 25 | 2024-10-17 03:17:54+02:00 | -4 |
| 450603 | 450603 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-17 | 01:26:12.000000 | 34 | 25 | 2024-10-17 01:26:12+02:00 | -9 |
| 483629 | 483629 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 23:38:43.000000 | 34 | 32 | 2024-10-16 23:38:43+02:00 | -2 |
| 483628 | 483628 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 22:37:07.000000 | 2 | 3 | 2024-10-16 22:37:07+02:00 | 1 |
| 483627 | 483627 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 22:26:50.000000 | 33 | 25 | 2024-10-16 22:26:50+02:00 | -8 |
| 483626 | 483626 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 22:25:50.000000 | 38 | 26 | 2024-10-16 22:25:50+02:00 | -12 |
| 483625 | 483625 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 22:03:15.000000 | 24 | 18 | 2024-10-16 22:03:15+02:00 | -6 |
| 483624 | 483624 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 21:59:34.000000 | 15 | 11 | 2024-10-16 21:59:34+02:00 | -4 |
| 483623 | 483623 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 21:20:55.000000 | 23 | 17 | 2024-10-16 21:20:55+02:00 | -6 |
| 483622 | 483622 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 21:20:12.000000 | 31 | 23 | 2024-10-16 21:20:12+02:00 | -8 |
| 483621 | 483621 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 21:10:01.000000 | 26 | 20 | 2024-10-16 21:10:01+02:00 | -6 |
| 483620 | 483620 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 20:58:37.000000 | 25 | 24 | 2024-10-16 20:58:37+02:00 | -1 |
| 483619 | 483619 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 20:38:55.000000 | 4 | 4 | 2024-10-16 20:38:55+02:00 | 0 |
| 483618 | 483618 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 20:31:43.000000 | 29 | 22 | 2024-10-16 20:31:43+02:00 | -7 |
| 483617 | 483617 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 20:23:21.000000 | 14 | 5 | 2024-10-16 20:23:21+02:00 | -9 |
| 483616 | 483616 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 20:21:42.000000 | 33 | 24 | 2024-10-16 20:21:42+02:00 | -9 |
| 483615 | 483615 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 20:15:25.000000 | 2 | 4 | 2024-10-16 20:15:25+02:00 | 2 |
| 483614 | 483614 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 20:11:11.000000 | 8 | 3 | 2024-10-16 20:11:11+02:00 | -5 |
| 483613 | 483613 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:57:20.000000 | 23 | 13 | 2024-10-16 19:57:20+02:00 | -10 |
| 483612 | 483612 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:57:04.000000 | 26 | 19 | 2024-10-16 19:57:04+02:00 | -7 |
| 483611 | 483611 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:57:00.000000 | 24 | 11 | 2024-10-16 19:57:00+02:00 | -13 |
| 483610 | 483610 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:55:10.000000 | 28 | 17 | 2024-10-16 19:55:10+02:00 | -11 |
| 483609 | 483609 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:51:34.000000 | 16 | 13 | 2024-10-16 19:51:34+02:00 | -3 |
| 483608 | 483608 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:46:02.000000 | 37 | 27 | 2024-10-16 19:46:02+02:00 | -10 |
| 483607 | 483607 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:45:10.000000 | 4 | 3 | 2024-10-16 19:45:10+02:00 | -1 |
| 483606 | 483606 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:42:56.000000 | 24 | 19 | 2024-10-16 19:42:56+02:00 | -5 |
| 483605 | 483605 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:29:31.000000 | 25 | 15 | 2024-10-16 19:29:31+02:00 | -10 |
| 483604 | 483604 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:13:21.000000 | 29 | 22 | 2024-10-16 19:13:21+02:00 | -7 |
| 483603 | 483603 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:12:39.000000 | 5 | 8 | 2024-10-16 19:12:39+02:00 | 3 |
| 483602 | 483602 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:10:13.000000 | 24 | 20 | 2024-10-16 19:10:13+02:00 | -4 |
| 483601 | 483601 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 19:00:00.000000 | 29 | 26 | 2024-10-16 19:00:00+02:00 | -3 |
| 483600 | 483600 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:53:14.000000 | 20 | 22 | 2024-10-16 18:53:14+02:00 | 2 |
| 483599 | 483599 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:42:28.000000 | 8 | 8 | 2024-10-16 18:42:28+02:00 | 0 |
| 483598 | 483598 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:40:09.000000 | 14 | 17 | 2024-10-16 18:40:09+02:00 | 3 |
| 483597 | 483597 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:38:35.000000 | 19 | 11 | 2024-10-16 18:38:35+02:00 | -8 |
| 483596 | 483596 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:32:20.000000 | 20 | 15 | 2024-10-16 18:32:20+02:00 | -5 |
| 483595 | 483595 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:27:07.000000 | 31 | 27 | 2024-10-16 18:27:07+02:00 | -4 |
| 483594 | 483594 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:26:41.000000 | 36 | 30 | 2024-10-16 18:26:41+02:00 | -6 |
| 483593 | 483593 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:21:20.000000 | 18 | 26 | 2024-10-16 18:21:20+02:00 | 8 |
| 483592 | 483592 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:17:59.000000 | 18 | 18 | 2024-10-16 18:17:59+02:00 | 0 |
| 483591 | 483591 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:16:34.000000 | 33 | 22 | 2024-10-16 18:16:34+02:00 | -11 |
| 483590 | 483590 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:16:24.000000 | 34 | 37 | 2024-10-16 18:16:24+02:00 | 3 |
| 483589 | 483589 | Sperrstrasse 4-16 | 16 | 4 | Nachmessung | 2024-10-16 | 18:14:37.000000 | 12 | 11 | 2024-10-16 18:14:37+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");