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-30" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
847863 | 847863 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-11 | 10:07:06.000000 | 20 | 28 | 2023-07-11 10:07:06+02:00 | 8 |
847862 | 847862 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-11 | 10:06:08.000000 | 16 | 19 | 2023-07-11 10:06:08+02:00 | 3 |
847861 | 847861 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-11 | 08:53:27.000000 | 26 | 26 | 2023-07-11 08:53:27+02:00 | 0 |
847860 | 847860 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-11 | 08:43:24.000000 | 32 | 33 | 2023-07-11 08:43:24+02:00 | 1 |
847859 | 847859 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-11 | 08:34:01.000000 | 23 | 28 | 2023-07-11 08:34:01+02:00 | 5 |
847858 | 847858 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-11 | 08:08:14.000000 | 31 | 25 | 2023-07-11 08:08:14+02:00 | -6 |
847857 | 847857 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-11 | 07:19:40.000000 | 13 | 16 | 2023-07-11 07:19:40+02:00 | 3 |
847856 | 847856 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-11 | 06:09:57.000000 | 13 | 19 | 2023-07-11 06:09:57+02:00 | 6 |
847855 | 847855 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-11 | 02:00:29.000000 | 39 | 17 | 2023-07-11 02:00:29+02:00 | -22 |
854591 | 854591 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 23:07:58.000000 | 20 | 17 | 2023-07-10 23:07:58+02:00 | -3 |
854590 | 854590 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 22:44:20.000000 | 5 | 7 | 2023-07-10 22:44:20+02:00 | 2 |
854589 | 854589 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 22:32:38.000000 | 11 | 17 | 2023-07-10 22:32:38+02:00 | 6 |
854588 | 854588 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 22:32:25.000000 | 25 | 22 | 2023-07-10 22:32:25+02:00 | -3 |
854587 | 854587 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 22:17:05.000000 | 17 | 17 | 2023-07-10 22:17:05+02:00 | 0 |
854586 | 854586 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 21:59:57.000000 | 14 | 17 | 2023-07-10 21:59:57+02:00 | 3 |
854585 | 854585 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 21:59:50.000000 | 23 | 23 | 2023-07-10 21:59:50+02:00 | 0 |
854584 | 854584 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 21:31:36.000000 | 17 | 17 | 2023-07-10 21:31:36+02:00 | 0 |
854583 | 854583 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 21:03:54.000000 | 10 | 12 | 2023-07-10 21:03:54+02:00 | 2 |
854582 | 854582 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 20:48:44.000000 | 20 | 22 | 2023-07-10 20:48:44+02:00 | 2 |
854581 | 854581 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 20:36:35.000000 | 32 | 35 | 2023-07-10 20:36:35+02:00 | 3 |
854580 | 854580 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 20:34:45.000000 | 28 | 25 | 2023-07-10 20:34:45+02:00 | -3 |
854579 | 854579 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 19:16:43.000000 | 26 | 25 | 2023-07-10 19:16:43+02:00 | -1 |
854578 | 854578 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 19:14:57.000000 | 17 | 12 | 2023-07-10 19:14:57+02:00 | -5 |
854577 | 854577 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 19:04:32.000000 | 30 | 22 | 2023-07-10 19:04:32+02:00 | -8 |
854576 | 854576 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 18:58:25.000000 | 10 | 7 | 2023-07-10 18:58:25+02:00 | -3 |
854575 | 854575 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 17:43:10.000000 | 16 | 28 | 2023-07-10 17:43:10+02:00 | 12 |
854574 | 854574 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 17:06:35.000000 | 14 | 17 | 2023-07-10 17:06:35+02:00 | 3 |
854573 | 854573 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 16:48:57.000000 | 16 | 19 | 2023-07-10 16:48:57+02:00 | 3 |
854572 | 854572 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 16:37:12.000000 | 18 | 17 | 2023-07-10 16:37:12+02:00 | -1 |
854571 | 854571 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 16:03:50.000000 | 27 | 27 | 2023-07-10 16:03:50+02:00 | 0 |
854570 | 854570 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 15:36:54.000000 | 24 | 24 | 2023-07-10 15:36:54+02:00 | 0 |
854569 | 854569 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 15:31:23.000000 | 20 | 23 | 2023-07-10 15:31:23+02:00 | 3 |
854568 | 854568 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 14:25:05.000000 | 20 | 13 | 2023-07-10 14:25:05+02:00 | -7 |
854567 | 854567 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 14:20:38.000000 | 23 | 22 | 2023-07-10 14:20:38+02:00 | -1 |
854566 | 854566 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 13:41:19.000000 | 20 | 14 | 2023-07-10 13:41:19+02:00 | -6 |
854565 | 854565 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 13:20:01.000000 | 17 | 23 | 2023-07-10 13:20:01+02:00 | 6 |
854564 | 854564 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 13:16:30.000000 | 9 | 26 | 2023-07-10 13:16:30+02:00 | 17 |
854563 | 854563 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 13:09:19.000000 | 26 | 12 | 2023-07-10 13:09:19+02:00 | -14 |
854562 | 854562 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 12:35:01.000000 | 18 | 16 | 2023-07-10 12:35:01+02:00 | -2 |
854561 | 854561 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 12:19:33.000000 | 14 | 13 | 2023-07-10 12:19:33+02:00 | -1 |
854560 | 854560 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 10:59:45.000000 | 31 | 24 | 2023-07-10 10:59:45+02:00 | -7 |
854559 | 854559 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 10:59:11.000000 | 15 | 23 | 2023-07-10 10:59:11+02:00 | 8 |
854558 | 854558 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 10:42:20.000000 | 18 | 31 | 2023-07-10 10:42:20+02:00 | 13 |
854557 | 854557 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 09:53:50.000000 | 28 | 19 | 2023-07-10 09:53:50+02:00 | -9 |
854556 | 854556 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 08:07:29.000000 | 16 | 15 | 2023-07-10 08:07:29+02:00 | -1 |
854555 | 854555 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 08:02:49.000000 | 13 | 14 | 2023-07-10 08:02:49+02:00 | 1 |
854554 | 854554 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 07:56:35.000000 | 18 | 26 | 2023-07-10 07:56:35+02:00 | 8 |
854553 | 854553 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 07:36:12.000000 | 18 | 10 | 2023-07-10 07:36:12+02:00 | -8 |
854552 | 854552 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 07:01:46.000000 | 15 | 25 | 2023-07-10 07:01:46+02:00 | 10 |
854551 | 854551 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 06:51:01.000000 | 17 | 24 | 2023-07-10 06:51:01+02:00 | 7 |
854550 | 854550 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 06:38:32.000000 | 24 | 29 | 2023-07-10 06:38:32+02:00 | 5 |
854549 | 854549 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 06:25:09.000000 | 19 | 24 | 2023-07-10 06:25:09+02:00 | 5 |
854548 | 854548 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 05:31:25.000000 | 17 | 23 | 2023-07-10 05:31:25+02:00 | 6 |
854547 | 854547 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 05:22:37.000000 | 18 | 20 | 2023-07-10 05:22:37+02:00 | 2 |
854546 | 854546 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-10 | 03:08:44.000000 | 25 | 18 | 2023-07-10 03:08:44+02:00 | -7 |
854680 | 854680 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 23:27:38.000000 | 13 | 26 | 2023-07-09 23:27:38+02:00 | 13 |
854679 | 854679 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 23:04:31.000000 | 23 | 27 | 2023-07-09 23:04:31+02:00 | 4 |
854678 | 854678 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 22:48:42.000000 | 25 | 18 | 2023-07-09 22:48:42+02:00 | -7 |
854677 | 854677 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 22:30:37.000000 | 7 | 22 | 2023-07-09 22:30:37+02:00 | 15 |
854676 | 854676 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 22:24:18.000000 | 17 | 23 | 2023-07-09 22:24:18+02:00 | 6 |
854675 | 854675 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 20:50:02.000000 | 4 | 6 | 2023-07-09 20:50:02+02:00 | 2 |
854674 | 854674 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 20:27:12.000000 | 11 | 16 | 2023-07-09 20:27:12+02:00 | 5 |
854673 | 854673 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 20:26:12.000000 | 13 | 19 | 2023-07-09 20:26:12+02:00 | 6 |
854672 | 854672 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 20:17:14.000000 | 18 | 24 | 2023-07-09 20:17:14+02:00 | 6 |
854671 | 854671 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 20:10:44.000000 | 16 | 15 | 2023-07-09 20:10:44+02:00 | -1 |
854670 | 854670 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 19:54:17.000000 | 4 | 9 | 2023-07-09 19:54:17+02:00 | 5 |
854669 | 854669 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 19:44:51.000000 | 30 | 31 | 2023-07-09 19:44:51+02:00 | 1 |
854668 | 854668 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 19:28:34.000000 | 3 | 22 | 2023-07-09 19:28:34+02:00 | 19 |
854667 | 854667 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 19:15:40.000000 | 24 | 20 | 2023-07-09 19:15:40+02:00 | -4 |
854666 | 854666 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 18:41:18.000000 | 20 | 10 | 2023-07-09 18:41:18+02:00 | -10 |
854665 | 854665 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 18:39:49.000000 | 4 | 6 | 2023-07-09 18:39:49+02:00 | 2 |
854664 | 854664 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 18:33:39.000000 | 24 | 24 | 2023-07-09 18:33:39+02:00 | 0 |
854663 | 854663 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 16:40:34.000000 | 18 | 20 | 2023-07-09 16:40:34+02:00 | 2 |
854662 | 854662 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 16:02:39.000000 | 15 | 16 | 2023-07-09 16:02:39+02:00 | 1 |
854661 | 854661 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 15:44:35.000000 | 23 | 23 | 2023-07-09 15:44:35+02:00 | 0 |
854660 | 854660 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 15:34:09.000000 | 12 | 22 | 2023-07-09 15:34:09+02:00 | 10 |
854659 | 854659 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 13:59:28.000000 | 29 | 25 | 2023-07-09 13:59:28+02:00 | -4 |
854658 | 854658 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 13:54:22.000000 | 33 | 30 | 2023-07-09 13:54:22+02:00 | -3 |
854657 | 854657 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 13:45:26.000000 | 28 | 27 | 2023-07-09 13:45:26+02:00 | -1 |
854656 | 854656 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 13:26:24.000000 | 26 | 28 | 2023-07-09 13:26:24+02:00 | 2 |
854655 | 854655 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 12:18:53.000000 | 15 | 17 | 2023-07-09 12:18:53+02:00 | 2 |
854654 | 854654 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 12:14:14.000000 | 9 | 12 | 2023-07-09 12:14:14+02:00 | 3 |
854653 | 854653 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 12:09:45.000000 | 24 | 25 | 2023-07-09 12:09:45+02:00 | 1 |
854652 | 854652 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 11:43:30.000000 | 27 | 25 | 2023-07-09 11:43:30+02:00 | -2 |
854651 | 854651 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 10:52:49.000000 | 20 | 24 | 2023-07-09 10:52:49+02:00 | 4 |
854650 | 854650 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 10:28:02.000000 | 18 | 30 | 2023-07-09 10:28:02+02:00 | 12 |
854649 | 854649 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 10:20:05.000000 | 13 | 22 | 2023-07-09 10:20:05+02:00 | 9 |
854648 | 854648 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 09:52:42.000000 | 27 | 19 | 2023-07-09 09:52:42+02:00 | -8 |
854647 | 854647 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 09:04:47.000000 | 25 | 17 | 2023-07-09 09:04:47+02:00 | -8 |
854646 | 854646 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 08:51:32.000000 | 8 | 10 | 2023-07-09 08:51:32+02:00 | 2 |
854645 | 854645 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 08:08:13.000000 | 23 | 31 | 2023-07-09 08:08:13+02:00 | 8 |
854644 | 854644 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 07:47:44.000000 | 28 | 26 | 2023-07-09 07:47:44+02:00 | -2 |
854643 | 854643 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 04:16:59.000000 | 18 | 30 | 2023-07-09 04:16:59+02:00 | 12 |
854642 | 854642 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 04:04:18.000000 | 15 | 7 | 2023-07-09 04:04:18+02:00 | -8 |
854641 | 854641 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 00:11:55.000000 | 20 | 19 | 2023-07-09 00:11:55+02:00 | -1 |
854640 | 854640 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-09 | 00:01:35.000000 | 27 | 30 | 2023-07-09 00:01:35+02:00 | 3 |
852232 | 852232 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-08 | 22:40:01.000000 | 25 | 24 | 2023-07-08 22:40:01+02:00 | -1 |
852231 | 852231 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-08 | 22:39:32.000000 | 32 | 13 | 2023-07-08 22:39:32+02:00 | -19 |
852230 | 852230 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-08 | 21:31:27.000000 | 20 | 20 | 2023-07-08 21:31:27+02:00 | 0 |
852229 | 852229 | Marschalkenstrasse 1-30 | 30 | 1 | Nachmessung | 2023-07-08 | 21:24:46.000000 | 25 | 28 | 2023-07-08 21:24:46+02:00 | 3 |
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");