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-5" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 862167 | 862167 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 07:10:29.000000 | 33 | 36 | 2024-10-17 07:10:29+02:00 | 3 |
| 862166 | 862166 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 07:09:55.000000 | 26 | 20 | 2024-10-17 07:09:55+02:00 | -6 |
| 862165 | 862165 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 06:53:01.000000 | 5 | 16 | 2024-10-17 06:53:01+02:00 | 11 |
| 862164 | 862164 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 06:45:49.000000 | 23 | 18 | 2024-10-17 06:45:49+02:00 | -5 |
| 862163 | 862163 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 06:38:16.000000 | 31 | 26 | 2024-10-17 06:38:16+02:00 | -5 |
| 862162 | 862162 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 06:36:06.000000 | 32 | 30 | 2024-10-17 06:36:06+02:00 | -2 |
| 862161 | 862161 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 06:34:01.000000 | 13 | 18 | 2024-10-17 06:34:01+02:00 | 5 |
| 862160 | 862160 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 06:15:17.000000 | 23 | 24 | 2024-10-17 06:15:17+02:00 | 1 |
| 862159 | 862159 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 06:14:17.000000 | 25 | 9 | 2024-10-17 06:14:17+02:00 | -16 |
| 862158 | 862158 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 05:13:10.000000 | 15 | 19 | 2024-10-17 05:13:10+02:00 | 4 |
| 862157 | 862157 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 04:57:19.000000 | 27 | 23 | 2024-10-17 04:57:19+02:00 | -4 |
| 862156 | 862156 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-17 | 04:02:55.000000 | 33 | 30 | 2024-10-17 04:02:55+02:00 | -3 |
| 866723 | 866723 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 21:47:40.000000 | 28 | 29 | 2024-10-16 21:47:40+02:00 | 1 |
| 866722 | 866722 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 21:23:09.000000 | 23 | 19 | 2024-10-16 21:23:09+02:00 | -4 |
| 866721 | 866721 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 21:08:04.000000 | 24 | 31 | 2024-10-16 21:08:04+02:00 | 7 |
| 866720 | 866720 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 20:15:40.000000 | 28 | 27 | 2024-10-16 20:15:40+02:00 | -1 |
| 866719 | 866719 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 19:56:12.000000 | 23 | 27 | 2024-10-16 19:56:12+02:00 | 4 |
| 866718 | 866718 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 19:07:57.000000 | 37 | 43 | 2024-10-16 19:07:57+02:00 | 6 |
| 866717 | 866717 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 18:58:26.000000 | 15 | 24 | 2024-10-16 18:58:26+02:00 | 9 |
| 866716 | 866716 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 18:54:37.000000 | 23 | 23 | 2024-10-16 18:54:37+02:00 | 0 |
| 866715 | 866715 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 18:54:29.000000 | 30 | 29 | 2024-10-16 18:54:29+02:00 | -1 |
| 866714 | 866714 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 18:31:56.000000 | 26 | 28 | 2024-10-16 18:31:56+02:00 | 2 |
| 866713 | 866713 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 18:25:11.000000 | 32 | 24 | 2024-10-16 18:25:11+02:00 | -8 |
| 866712 | 866712 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 18:21:32.000000 | 23 | 25 | 2024-10-16 18:21:32+02:00 | 2 |
| 866711 | 866711 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 18:14:04.000000 | 27 | 20 | 2024-10-16 18:14:04+02:00 | -7 |
| 866710 | 866710 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 18:04:14.000000 | 29 | 30 | 2024-10-16 18:04:14+02:00 | 1 |
| 866709 | 866709 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 18:00:45.000000 | 28 | 22 | 2024-10-16 18:00:45+02:00 | -6 |
| 866708 | 866708 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 17:54:05.000000 | 23 | 26 | 2024-10-16 17:54:05+02:00 | 3 |
| 866707 | 866707 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 17:44:47.000000 | 23 | 28 | 2024-10-16 17:44:47+02:00 | 5 |
| 866706 | 866706 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 17:17:42.000000 | 23 | 22 | 2024-10-16 17:17:42+02:00 | -1 |
| 866705 | 866705 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 16:58:15.000000 | 16 | 25 | 2024-10-16 16:58:15+02:00 | 9 |
| 866704 | 866704 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 16:57:26.000000 | 17 | 27 | 2024-10-16 16:57:26+02:00 | 10 |
| 866703 | 866703 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 16:53:00.000000 | 33 | 26 | 2024-10-16 16:53:00+02:00 | -7 |
| 866702 | 866702 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 16:46:29.000000 | 19 | 19 | 2024-10-16 16:46:29+02:00 | 0 |
| 866701 | 866701 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 16:38:18.000000 | 23 | 20 | 2024-10-16 16:38:18+02:00 | -3 |
| 866700 | 866700 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 16:28:00.000000 | 27 | 24 | 2024-10-16 16:28:00+02:00 | -3 |
| 866699 | 866699 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 16:12:53.000000 | 13 | 14 | 2024-10-16 16:12:53+02:00 | 1 |
| 866698 | 866698 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 16:09:03.000000 | 25 | 28 | 2024-10-16 16:09:03+02:00 | 3 |
| 866697 | 866697 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 16:00:06.000000 | 17 | 28 | 2024-10-16 16:00:06+02:00 | 11 |
| 866696 | 866696 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:51:44.000000 | 18 | 29 | 2024-10-16 15:51:44+02:00 | 11 |
| 866695 | 866695 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:48:59.000000 | 18 | 19 | 2024-10-16 15:48:59+02:00 | 1 |
| 866694 | 866694 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:47:44.000000 | 24 | 31 | 2024-10-16 15:47:44+02:00 | 7 |
| 866693 | 866693 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:40:22.000000 | 30 | 26 | 2024-10-16 15:40:22+02:00 | -4 |
| 866692 | 866692 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:30:00.000000 | 19 | 26 | 2024-10-16 15:30:00+02:00 | 7 |
| 866691 | 866691 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:29:09.000000 | 26 | 27 | 2024-10-16 15:29:09+02:00 | 1 |
| 866690 | 866690 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:28:55.000000 | 23 | 23 | 2024-10-16 15:28:55+02:00 | 0 |
| 866689 | 866689 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:26:11.000000 | 23 | 16 | 2024-10-16 15:26:11+02:00 | -7 |
| 866688 | 866688 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:18:59.000000 | 16 | 19 | 2024-10-16 15:18:59+02:00 | 3 |
| 866687 | 866687 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:14:24.000000 | 20 | 19 | 2024-10-16 15:14:24+02:00 | -1 |
| 866686 | 866686 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:06:22.000000 | 28 | 24 | 2024-10-16 15:06:22+02:00 | -4 |
| 866685 | 866685 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 15:03:29.000000 | 26 | 23 | 2024-10-16 15:03:29+02:00 | -3 |
| 866684 | 866684 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 14:34:04.000000 | 32 | 29 | 2024-10-16 14:34:04+02:00 | -3 |
| 866683 | 866683 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 14:29:52.000000 | 26 | 24 | 2024-10-16 14:29:52+02:00 | -2 |
| 866682 | 866682 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 14:28:49.000000 | 14 | 31 | 2024-10-16 14:28:49+02:00 | 17 |
| 866681 | 866681 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 14:25:23.000000 | 30 | 26 | 2024-10-16 14:25:23+02:00 | -4 |
| 866680 | 866680 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 14:16:15.000000 | 33 | 27 | 2024-10-16 14:16:15+02:00 | -6 |
| 866679 | 866679 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 14:15:07.000000 | 27 | 28 | 2024-10-16 14:15:07+02:00 | 1 |
| 866678 | 866678 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 13:54:33.000000 | 26 | 32 | 2024-10-16 13:54:33+02:00 | 6 |
| 866677 | 866677 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 13:39:42.000000 | 27 | 24 | 2024-10-16 13:39:42+02:00 | -3 |
| 866676 | 866676 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 13:13:45.000000 | 18 | 15 | 2024-10-16 13:13:45+02:00 | -3 |
| 866675 | 866675 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 13:10:21.000000 | 25 | 22 | 2024-10-16 13:10:21+02:00 | -3 |
| 866674 | 866674 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 12:53:11.000000 | 27 | 25 | 2024-10-16 12:53:11+02:00 | -2 |
| 866673 | 866673 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 12:31:04.000000 | 26 | 22 | 2024-10-16 12:31:04+02:00 | -4 |
| 866672 | 866672 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 12:17:27.000000 | 28 | 23 | 2024-10-16 12:17:27+02:00 | -5 |
| 866671 | 866671 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 12:05:54.000000 | 23 | 25 | 2024-10-16 12:05:54+02:00 | 2 |
| 866670 | 866670 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 12:04:36.000000 | 26 | 31 | 2024-10-16 12:04:36+02:00 | 5 |
| 866669 | 866669 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 11:56:15.000000 | 26 | 31 | 2024-10-16 11:56:15+02:00 | 5 |
| 866668 | 866668 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 11:55:44.000000 | 23 | 20 | 2024-10-16 11:55:44+02:00 | -3 |
| 866667 | 866667 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 11:45:39.000000 | 30 | 25 | 2024-10-16 11:45:39+02:00 | -5 |
| 866666 | 866666 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 11:29:56.000000 | 16 | 22 | 2024-10-16 11:29:56+02:00 | 6 |
| 866665 | 866665 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 11:25:26.000000 | 17 | 13 | 2024-10-16 11:25:26+02:00 | -4 |
| 866664 | 866664 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 11:15:10.000000 | 24 | 9 | 2024-10-16 11:15:10+02:00 | -15 |
| 866663 | 866663 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 11:12:51.000000 | 30 | 24 | 2024-10-16 11:12:51+02:00 | -6 |
| 866662 | 866662 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 11:09:44.000000 | 25 | 24 | 2024-10-16 11:09:44+02:00 | -1 |
| 866661 | 866661 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 11:00:01.000000 | 14 | 24 | 2024-10-16 11:00:01+02:00 | 10 |
| 866660 | 866660 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 10:59:38.000000 | 9 | 10 | 2024-10-16 10:59:38+02:00 | 1 |
| 866659 | 866659 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 10:56:09.000000 | 26 | 18 | 2024-10-16 10:56:09+02:00 | -8 |
| 866658 | 866658 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 10:51:29.000000 | 20 | 33 | 2024-10-16 10:51:29+02:00 | 13 |
| 866657 | 866657 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 10:49:34.000000 | 28 | 28 | 2024-10-16 10:49:34+02:00 | 0 |
| 866656 | 866656 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 10:45:02.000000 | 18 | 27 | 2024-10-16 10:45:02+02:00 | 9 |
| 866655 | 866655 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 10:40:58.000000 | 28 | 22 | 2024-10-16 10:40:58+02:00 | -6 |
| 866654 | 866654 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 10:03:19.000000 | 25 | 23 | 2024-10-16 10:03:19+02:00 | -2 |
| 866653 | 866653 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 09:55:11.000000 | 30 | 30 | 2024-10-16 09:55:11+02:00 | 0 |
| 866652 | 866652 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 09:02:36.000000 | 24 | 28 | 2024-10-16 09:02:36+02:00 | 4 |
| 866651 | 866651 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 08:32:06.000000 | 31 | 28 | 2024-10-16 08:32:06+02:00 | -3 |
| 866650 | 866650 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 08:13:51.000000 | 19 | 23 | 2024-10-16 08:13:51+02:00 | 4 |
| 866649 | 866649 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 08:11:23.000000 | 35 | 26 | 2024-10-16 08:11:23+02:00 | -9 |
| 866648 | 866648 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 08:00:56.000000 | 32 | 25 | 2024-10-16 08:00:56+02:00 | -7 |
| 866647 | 866647 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 07:51:34.000000 | 31 | 26 | 2024-10-16 07:51:34+02:00 | -5 |
| 866646 | 866646 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 07:48:14.000000 | 19 | 27 | 2024-10-16 07:48:14+02:00 | 8 |
| 866645 | 866645 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 07:43:13.000000 | 25 | 28 | 2024-10-16 07:43:13+02:00 | 3 |
| 866644 | 866644 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 07:29:42.000000 | 28 | 27 | 2024-10-16 07:29:42+02:00 | -1 |
| 866643 | 866643 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 07:19:27.000000 | 25 | 23 | 2024-10-16 07:19:27+02:00 | -2 |
| 866642 | 866642 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 07:19:06.000000 | 23 | 24 | 2024-10-16 07:19:06+02:00 | 1 |
| 866641 | 866641 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 07:13:39.000000 | 19 | 19 | 2024-10-16 07:13:39+02:00 | 0 |
| 866640 | 866640 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 07:06:14.000000 | 17 | 9 | 2024-10-16 07:06:14+02:00 | -8 |
| 866639 | 866639 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 06:58:15.000000 | 18 | 17 | 2024-10-16 06:58:15+02:00 | -1 |
| 866638 | 866638 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 06:48:07.000000 | 26 | 19 | 2024-10-16 06:48:07+02:00 | -7 |
| 866637 | 866637 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 06:44:56.000000 | 8 | 7 | 2024-10-16 06:44:56+02:00 | -1 |
| 866636 | 866636 | Steingrubenweg 4-5 | 5 | 4 | Nachmessung | 2024-10-16 | 06:14:23.000000 | 19 | 30 | 2024-10-16 06:14:23+02:00 | 11 |
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");