Einzelmessungen
- Datum
- Datum
- Datum_Zeit
- Datum und Uhrzeit als Text
- Fahrzeuglänge
- Vom Radar gemessene Fahrzeuglänge
- Geschwindigkeit
- Geschwindigkeit in km/h
- Messung-ID
- Laufnummer der Messung; eine Messung beinhaltet alle Fahrten eines Messgeräts an einem Standort
- Richtung ID
- ID der Richtung; In einer Messung werden i.d.R. Fahrten in zwei Richtungen gemessen.
- Timestamp
- Datum und Uhrzeit
- Zeit
- Uhrzeit (hh:mm:ss) der gemessenen Fahrt
8,838 rows where Messung-ID = 1096 sorted by Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Datum, Timestamp (date)
| Link | rowid | Geschwindigkeit | Zeit | Datum | Richtung ID | Fahrzeuglänge | Messung-ID | Datum_Zeit | Timestamp ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 2710857 | 2710857 | 19 | 22:50:52 | 30.10.25 | 1 | 5.4 | Burgunderstrasse 1096 | 30.10.25 22:50:52 | 2025-10-30 22:50:52+01:00 |
| 2710856 | 2710856 | 25 | 22:41:39 | 30.10.25 | 1 | 5.2 | Burgunderstrasse 1096 | 30.10.25 22:41:39 | 2025-10-30 22:41:39+01:00 |
| 2710855 | 2710855 | 25 | 22:40:20 | 30.10.25 | 1 | 5.0 | Burgunderstrasse 1096 | 30.10.25 22:40:20 | 2025-10-30 22:40:20+01:00 |
| 2710854 | 2710854 | 26 | 22:39:37 | 30.10.25 | 1 | 5.2 | Burgunderstrasse 1096 | 30.10.25 22:39:37 | 2025-10-30 22:39:37+01:00 |
| 2710853 | 2710853 | 22 | 22:36:19 | 30.10.25 | 1 | 4.6 | Burgunderstrasse 1096 | 30.10.25 22:36:19 | 2025-10-30 22:36:19+01:00 |
| 2710852 | 2710852 | 23 | 22:35:24 | 30.10.25 | 1 | 4.3 | Burgunderstrasse 1096 | 30.10.25 22:35:24 | 2025-10-30 22:35:24+01:00 |
| 2710851 | 2710851 | 24 | 22:32:49 | 30.10.25 | 1 | 5.1 | Burgunderstrasse 1096 | 30.10.25 22:32:49 | 2025-10-30 22:32:49+01:00 |
| 2710850 | 2710850 | 20 | 22:26:47 | 30.10.25 | 1 | 5.4 | Burgunderstrasse 1096 | 30.10.25 22:26:47 | 2025-10-30 22:26:47+01:00 |
| 2710849 | 2710849 | 18 | 22:26:28 | 30.10.25 | 1 | 3.8 | Burgunderstrasse 1096 | 30.10.25 22:26:28 | 2025-10-30 22:26:28+01:00 |
| 2710848 | 2710848 | 24 | 22:24:51 | 30.10.25 | 1 | 5.2 | Burgunderstrasse 1096 | 30.10.25 22:24:51 | 2025-10-30 22:24:51+01:00 |
| 2710847 | 2710847 | 17 | 22:22:59 | 30.10.25 | 1 | 4.8 | Burgunderstrasse 1096 | 30.10.25 22:22:59 | 2025-10-30 22:22:59+01:00 |
| 2710846 | 2710846 | 9 | 22:18:40 | 30.10.25 | 1 | 4.7 | Burgunderstrasse 1096 | 30.10.25 22:18:40 | 2025-10-30 22:18:40+01:00 |
| 2710845 | 2710845 | 18 | 22:13:39 | 30.10.25 | 1 | 4.7 | Burgunderstrasse 1096 | 30.10.25 22:13:39 | 2025-10-30 22:13:39+01:00 |
| 2710844 | 2710844 | 30 | 22:12:55 | 30.10.25 | 1 | 4.7 | Burgunderstrasse 1096 | 30.10.25 22:12:55 | 2025-10-30 22:12:55+01:00 |
| 2710843 | 2710843 | 24 | 22:10:02 | 30.10.25 | 1 | 6.1 | Burgunderstrasse 1096 | 30.10.25 22:10:02 | 2025-10-30 22:10:02+01:00 |
| 2710842 | 2710842 | 19 | 22:07:29 | 30.10.25 | 1 | 4.7 | Burgunderstrasse 1096 | 30.10.25 22:07:29 | 2025-10-30 22:07:29+01:00 |
| 2710841 | 2710841 | 21 | 22:05:19 | 30.10.25 | 1 | 4.2 | Burgunderstrasse 1096 | 30.10.25 22:05:19 | 2025-10-30 22:05:19+01:00 |
| 2710840 | 2710840 | 22 | 22:04:56 | 30.10.25 | 1 | 4.4 | Burgunderstrasse 1096 | 30.10.25 22:04:56 | 2025-10-30 22:04:56+01:00 |
| 2710839 | 2710839 | 14 | 22:03:15 | 30.10.25 | 1 | 5.8 | Burgunderstrasse 1096 | 30.10.25 22:03:15 | 2025-10-30 22:03:15+01:00 |
| 2710838 | 2710838 | 11 | 22:03:11 | 30.10.25 | 1 | 3.9 | Burgunderstrasse 1096 | 30.10.25 22:03:11 | 2025-10-30 22:03:11+01:00 |
| 2710837 | 2710837 | 31 | 22:01:55 | 30.10.25 | 1 | 5.4 | Burgunderstrasse 1096 | 30.10.25 22:01:55 | 2025-10-30 22:01:55+01:00 |
| 2710836 | 2710836 | 30 | 22:01:53 | 30.10.25 | 1 | 5.0 | Burgunderstrasse 1096 | 30.10.25 22:01:53 | 2025-10-30 22:01:53+01:00 |
| 2710835 | 2710835 | 16 | 22:00:18 | 30.10.25 | 1 | 4.1 | Burgunderstrasse 1096 | 30.10.25 22:00:18 | 2025-10-30 22:00:18+01:00 |
| 2710834 | 2710834 | 27 | 21:56:33 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 21:56:33 | 2025-10-30 21:56:33+01:00 |
| 2710833 | 2710833 | 19 | 21:55:03 | 30.10.25 | 1 | 0.6 | Burgunderstrasse 1096 | 30.10.25 21:55:03 | 2025-10-30 21:55:03+01:00 |
| 2710832 | 2710832 | 14 | 21:53:58 | 30.10.25 | 1 | 4.7 | Burgunderstrasse 1096 | 30.10.25 21:53:58 | 2025-10-30 21:53:58+01:00 |
| 2710831 | 2710831 | 29 | 21:52:19 | 30.10.25 | 1 | 4.9 | Burgunderstrasse 1096 | 30.10.25 21:52:19 | 2025-10-30 21:52:19+01:00 |
| 2710830 | 2710830 | 29 | 21:52:13 | 30.10.25 | 1 | 4.9 | Burgunderstrasse 1096 | 30.10.25 21:52:13 | 2025-10-30 21:52:13+01:00 |
| 2710829 | 2710829 | 23 | 21:51:38 | 30.10.25 | 1 | 4.1 | Burgunderstrasse 1096 | 30.10.25 21:51:38 | 2025-10-30 21:51:38+01:00 |
| 2710828 | 2710828 | 26 | 21:50:35 | 30.10.25 | 1 | 5.7 | Burgunderstrasse 1096 | 30.10.25 21:50:35 | 2025-10-30 21:50:35+01:00 |
| 2710827 | 2710827 | 31 | 21:49:30 | 30.10.25 | 1 | 4.9 | Burgunderstrasse 1096 | 30.10.25 21:49:30 | 2025-10-30 21:49:30+01:00 |
| 2710826 | 2710826 | 27 | 21:48:39 | 30.10.25 | 1 | 4.6 | Burgunderstrasse 1096 | 30.10.25 21:48:39 | 2025-10-30 21:48:39+01:00 |
| 2710825 | 2710825 | 34 | 21:47:17 | 30.10.25 | 1 | 4.6 | Burgunderstrasse 1096 | 30.10.25 21:47:17 | 2025-10-30 21:47:17+01:00 |
| 2710824 | 2710824 | 24 | 21:45:45 | 30.10.25 | 1 | 4.8 | Burgunderstrasse 1096 | 30.10.25 21:45:45 | 2025-10-30 21:45:45+01:00 |
| 2710823 | 2710823 | 13 | 21:43:32 | 30.10.25 | 1 | 4.6 | Burgunderstrasse 1096 | 30.10.25 21:43:32 | 2025-10-30 21:43:32+01:00 |
| 2710822 | 2710822 | 41 | 21:38:10 | 30.10.25 | 1 | 5.1 | Burgunderstrasse 1096 | 30.10.25 21:38:10 | 2025-10-30 21:38:10+01:00 |
| 2710821 | 2710821 | 25 | 21:36:57 | 30.10.25 | 1 | 4.1 | Burgunderstrasse 1096 | 30.10.25 21:36:57 | 2025-10-30 21:36:57+01:00 |
| 2710820 | 2710820 | 20 | 21:35:33 | 30.10.25 | 1 | 4.9 | Burgunderstrasse 1096 | 30.10.25 21:35:33 | 2025-10-30 21:35:33+01:00 |
| 2710819 | 2710819 | 26 | 21:27:24 | 30.10.25 | 1 | 5.2 | Burgunderstrasse 1096 | 30.10.25 21:27:24 | 2025-10-30 21:27:24+01:00 |
| 2710818 | 2710818 | 16 | 21:21:51 | 30.10.25 | 1 | 4.8 | Burgunderstrasse 1096 | 30.10.25 21:21:51 | 2025-10-30 21:21:51+01:00 |
| 2710817 | 2710817 | 22 | 21:18:30 | 30.10.25 | 1 | 3.3 | Burgunderstrasse 1096 | 30.10.25 21:18:30 | 2025-10-30 21:18:30+01:00 |
| 2710816 | 2710816 | 27 | 21:15:07 | 30.10.25 | 1 | 4.6 | Burgunderstrasse 1096 | 30.10.25 21:15:07 | 2025-10-30 21:15:07+01:00 |
| 2710815 | 2710815 | 27 | 21:13:35 | 30.10.25 | 1 | 4.2 | Burgunderstrasse 1096 | 30.10.25 21:13:35 | 2025-10-30 21:13:35+01:00 |
| 2710814 | 2710814 | 28 | 21:13:25 | 30.10.25 | 1 | 1.8 | Burgunderstrasse 1096 | 30.10.25 21:13:25 | 2025-10-30 21:13:25+01:00 |
| 2710813 | 2710813 | 21 | 21:12:59 | 30.10.25 | 1 | 4.9 | Burgunderstrasse 1096 | 30.10.25 21:12:59 | 2025-10-30 21:12:59+01:00 |
| 2710812 | 2710812 | 16 | 21:11:48 | 30.10.25 | 1 | 4.6 | Burgunderstrasse 1096 | 30.10.25 21:11:48 | 2025-10-30 21:11:48+01:00 |
| 2710811 | 2710811 | 37 | 21:10:45 | 30.10.25 | 1 | 5.0 | Burgunderstrasse 1096 | 30.10.25 21:10:45 | 2025-10-30 21:10:45+01:00 |
| 2710810 | 2710810 | 16 | 21:09:25 | 30.10.25 | 1 | 2.0 | Burgunderstrasse 1096 | 30.10.25 21:09:25 | 2025-10-30 21:09:25+01:00 |
| 2710809 | 2710809 | 19 | 21:08:57 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 21:08:57 | 2025-10-30 21:08:57+01:00 |
| 2710808 | 2710808 | 31 | 21:08:29 | 30.10.25 | 1 | 5.3 | Burgunderstrasse 1096 | 30.10.25 21:08:29 | 2025-10-30 21:08:29+01:00 |
| 2710807 | 2710807 | 25 | 21:08:21 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 21:08:21 | 2025-10-30 21:08:21+01:00 |
| 2710806 | 2710806 | 23 | 21:05:31 | 30.10.25 | 1 | 4.6 | Burgunderstrasse 1096 | 30.10.25 21:05:31 | 2025-10-30 21:05:31+01:00 |
| 2710805 | 2710805 | 24 | 21:04:23 | 30.10.25 | 1 | 4.1 | Burgunderstrasse 1096 | 30.10.25 21:04:23 | 2025-10-30 21:04:23+01:00 |
| 2710804 | 2710804 | 23 | 21:02:48 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 21:02:48 | 2025-10-30 21:02:48+01:00 |
| 2710803 | 2710803 | 31 | 21:02:38 | 30.10.25 | 1 | 4.6 | Burgunderstrasse 1096 | 30.10.25 21:02:38 | 2025-10-30 21:02:38+01:00 |
| 2710802 | 2710802 | 17 | 21:01:47 | 30.10.25 | 1 | 4.8 | Burgunderstrasse 1096 | 30.10.25 21:01:47 | 2025-10-30 21:01:47+01:00 |
| 2710801 | 2710801 | 21 | 21:00:40 | 30.10.25 | 1 | 4.8 | Burgunderstrasse 1096 | 30.10.25 21:00:40 | 2025-10-30 21:00:40+01:00 |
| 2710800 | 2710800 | 11 | 20:59:45 | 30.10.25 | 1 | 2.7 | Burgunderstrasse 1096 | 30.10.25 20:59:45 | 2025-10-30 20:59:45+01:00 |
| 2710799 | 2710799 | 21 | 20:55:33 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 20:55:33 | 2025-10-30 20:55:33+01:00 |
| 2710798 | 2710798 | 24 | 20:55:30 | 30.10.25 | 1 | 5.0 | Burgunderstrasse 1096 | 30.10.25 20:55:30 | 2025-10-30 20:55:30+01:00 |
| 2710797 | 2710797 | 15 | 20:54:26 | 30.10.25 | 1 | 4.9 | Burgunderstrasse 1096 | 30.10.25 20:54:26 | 2025-10-30 20:54:26+01:00 |
| 2710796 | 2710796 | 23 | 20:53:37 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 20:53:37 | 2025-10-30 20:53:37+01:00 |
| 2710795 | 2710795 | 28 | 20:53:03 | 30.10.25 | 1 | 4.4 | Burgunderstrasse 1096 | 30.10.25 20:53:03 | 2025-10-30 20:53:03+01:00 |
| 2710794 | 2710794 | 20 | 20:51:41 | 30.10.25 | 1 | 4.4 | Burgunderstrasse 1096 | 30.10.25 20:51:41 | 2025-10-30 20:51:41+01:00 |
| 2710793 | 2710793 | 15 | 20:49:33 | 30.10.25 | 1 | 4.9 | Burgunderstrasse 1096 | 30.10.25 20:49:33 | 2025-10-30 20:49:33+01:00 |
| 2710792 | 2710792 | 21 | 20:49:04 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 20:49:04 | 2025-10-30 20:49:04+01:00 |
| 2710791 | 2710791 | 23 | 20:48:38 | 30.10.25 | 1 | 1.0 | Burgunderstrasse 1096 | 30.10.25 20:48:38 | 2025-10-30 20:48:38+01:00 |
| 2710790 | 2710790 | 14 | 20:45:37 | 30.10.25 | 1 | 3.6 | Burgunderstrasse 1096 | 30.10.25 20:45:37 | 2025-10-30 20:45:37+01:00 |
| 2710789 | 2710789 | 11 | 20:42:02 | 30.10.25 | 1 | 5.0 | Burgunderstrasse 1096 | 30.10.25 20:42:02 | 2025-10-30 20:42:02+01:00 |
| 2710788 | 2710788 | 22 | 20:41:14 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 20:41:14 | 2025-10-30 20:41:14+01:00 |
| 2710787 | 2710787 | 21 | 20:40:53 | 30.10.25 | 1 | 4.8 | Burgunderstrasse 1096 | 30.10.25 20:40:53 | 2025-10-30 20:40:53+01:00 |
| 2710786 | 2710786 | 13 | 20:39:50 | 30.10.25 | 1 | 3.2 | Burgunderstrasse 1096 | 30.10.25 20:39:50 | 2025-10-30 20:39:50+01:00 |
| 2710785 | 2710785 | 12 | 20:36:20 | 30.10.25 | 1 | 2.7 | Burgunderstrasse 1096 | 30.10.25 20:36:20 | 2025-10-30 20:36:20+01:00 |
| 2710784 | 2710784 | 21 | 20:33:35 | 30.10.25 | 1 | 4.2 | Burgunderstrasse 1096 | 30.10.25 20:33:35 | 2025-10-30 20:33:35+01:00 |
| 2710783 | 2710783 | 19 | 20:33:30 | 30.10.25 | 1 | 1.5 | Burgunderstrasse 1096 | 30.10.25 20:33:30 | 2025-10-30 20:33:30+01:00 |
| 2710782 | 2710782 | 29 | 20:31:34 | 30.10.25 | 1 | 5.2 | Burgunderstrasse 1096 | 30.10.25 20:31:34 | 2025-10-30 20:31:34+01:00 |
| 2710781 | 2710781 | 29 | 20:31:09 | 30.10.25 | 1 | 4.6 | Burgunderstrasse 1096 | 30.10.25 20:31:09 | 2025-10-30 20:31:09+01:00 |
| 2710780 | 2710780 | 33 | 20:30:55 | 30.10.25 | 1 | 5.3 | Burgunderstrasse 1096 | 30.10.25 20:30:55 | 2025-10-30 20:30:55+01:00 |
| 2710779 | 2710779 | 25 | 20:30:28 | 30.10.25 | 1 | 5.3 | Burgunderstrasse 1096 | 30.10.25 20:30:28 | 2025-10-30 20:30:28+01:00 |
| 2710778 | 2710778 | 12 | 20:29:24 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 20:29:24 | 2025-10-30 20:29:24+01:00 |
| 2710777 | 2710777 | 19 | 20:22:18 | 30.10.25 | 1 | 4.2 | Burgunderstrasse 1096 | 30.10.25 20:22:18 | 2025-10-30 20:22:18+01:00 |
| 2710776 | 2710776 | 24 | 20:21:49 | 30.10.25 | 1 | 5.2 | Burgunderstrasse 1096 | 30.10.25 20:21:49 | 2025-10-30 20:21:49+01:00 |
| 2710775 | 2710775 | 25 | 20:21:42 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 20:21:42 | 2025-10-30 20:21:42+01:00 |
| 2710774 | 2710774 | 33 | 20:20:53 | 30.10.25 | 1 | 5.6 | Burgunderstrasse 1096 | 30.10.25 20:20:53 | 2025-10-30 20:20:53+01:00 |
| 2710773 | 2710773 | 28 | 20:20:35 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 20:20:35 | 2025-10-30 20:20:35+01:00 |
| 2710772 | 2710772 | 34 | 20:18:51 | 30.10.25 | 1 | 5.0 | Burgunderstrasse 1096 | 30.10.25 20:18:51 | 2025-10-30 20:18:51+01:00 |
| 2710771 | 2710771 | 33 | 20:17:43 | 30.10.25 | 1 | 4.9 | Burgunderstrasse 1096 | 30.10.25 20:17:43 | 2025-10-30 20:17:43+01:00 |
| 2710770 | 2710770 | 22 | 20:16:58 | 30.10.25 | 1 | 4.6 | Burgunderstrasse 1096 | 30.10.25 20:16:58 | 2025-10-30 20:16:58+01:00 |
| 2710769 | 2710769 | 32 | 20:16:53 | 30.10.25 | 1 | 1.0 | Burgunderstrasse 1096 | 30.10.25 20:16:53 | 2025-10-30 20:16:53+01:00 |
| 2710768 | 2710768 | 30 | 20:16:34 | 30.10.25 | 1 | 4.3 | Burgunderstrasse 1096 | 30.10.25 20:16:34 | 2025-10-30 20:16:34+01:00 |
| 2710767 | 2710767 | 19 | 20:14:52 | 30.10.25 | 1 | 5.4 | Burgunderstrasse 1096 | 30.10.25 20:14:52 | 2025-10-30 20:14:52+01:00 |
| 2710766 | 2710766 | 8 | 20:14:24 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 20:14:24 | 2025-10-30 20:14:24+01:00 |
| 2710765 | 2710765 | 24 | 20:12:50 | 30.10.25 | 1 | 3.9 | Burgunderstrasse 1096 | 30.10.25 20:12:50 | 2025-10-30 20:12:50+01:00 |
| 2710764 | 2710764 | 15 | 20:12:07 | 30.10.25 | 1 | 4.5 | Burgunderstrasse 1096 | 30.10.25 20:12:07 | 2025-10-30 20:12:07+01:00 |
| 2710763 | 2710763 | 18 | 20:10:37 | 30.10.25 | 1 | 5.6 | Burgunderstrasse 1096 | 30.10.25 20:10:37 | 2025-10-30 20:10:37+01:00 |
| 2710762 | 2710762 | 18 | 20:09:05 | 30.10.25 | 1 | 4.8 | Burgunderstrasse 1096 | 30.10.25 20:09:05 | 2025-10-30 20:09:05+01:00 |
| 2710761 | 2710761 | 12 | 20:05:41 | 30.10.25 | 1 | 0.7 | Burgunderstrasse 1096 | 30.10.25 20:05:41 | 2025-10-30 20:05:41+01:00 |
| 2710760 | 2710760 | 21 | 20:04:31 | 30.10.25 | 1 | 4.8 | Burgunderstrasse 1096 | 30.10.25 20:04:31 | 2025-10-30 20:04:31+01:00 |
| 2710759 | 2710759 | 26 | 20:03:35 | 30.10.25 | 1 | 5.7 | Burgunderstrasse 1096 | 30.10.25 20:03:35 | 2025-10-30 20:03:35+01:00 |
| 2710758 | 2710758 | 23 | 20:03:28 | 30.10.25 | 1 | 5.7 | Burgunderstrasse 1096 | 30.10.25 20:03:28 | 2025-10-30 20:03:28+01:00 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE Einzelmessungen (
Geschwindigkeit INTEGER,
Zeit TEXT,
Datum TEXT,
"Richtung ID" INTEGER,
Fahrzeuglänge REAL,
"Messung-ID" INTEGER,
Datum_Zeit TEXT,
Timestamp TEXT,
FOREIGN KEY("Messung-ID") REFERENCES Kennzahlen_pro_Standort("ID")
ON UPDATE CASCADE ON DELETE CASCADE
);
CREATE INDEX idx_Einzelmessungen_timestamp ON "Einzelmessungen" ("Timestamp");
CREATE INDEX idx_Einzelmessungen_richtung_id ON "Einzelmessungen" ("Richtung ID");
CREATE INDEX idx_Einzelmessungen_messung_id ON "Einzelmessungen" ("Messung-ID");
CREATE INDEX idx_Einzelmessungen_datum ON "Einzelmessungen" ("Datum");
CREATE INDEX idx_Einzelmessungen_geschwindigkeit ON "Einzelmessungen" ("Geschwindigkeit");