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
>10,000 rows count all where Messung-ID = 1069 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 15073826 | 15073826 | 32 | 00:16:50 | 30.08.25 | 1 | 4.6 | Claragraben 1069 | 30.08.25 00:16:50 | 2025-08-30 00:16:50+02:00 |
| 15073825 | 15073825 | 33 | 00:16:28 | 30.08.25 | 1 | 3.9 | Claragraben 1069 | 30.08.25 00:16:28 | 2025-08-30 00:16:28+02:00 |
| 15073824 | 15073824 | 34 | 00:16:26 | 30.08.25 | 1 | 3.3 | Claragraben 1069 | 30.08.25 00:16:26 | 2025-08-30 00:16:26+02:00 |
| 15073823 | 15073823 | 34 | 00:16:14 | 30.08.25 | 1 | 3.9 | Claragraben 1069 | 30.08.25 00:16:14 | 2025-08-30 00:16:14+02:00 |
| 15073822 | 15073822 | 21 | 00:15:57 | 30.08.25 | 1 | 4.9 | Claragraben 1069 | 30.08.25 00:15:57 | 2025-08-30 00:15:57+02:00 |
| 15073821 | 15073821 | 31 | 00:15:47 | 30.08.25 | 1 | 3.6 | Claragraben 1069 | 30.08.25 00:15:47 | 2025-08-30 00:15:47+02:00 |
| 15073820 | 15073820 | 18 | 00:15:40 | 30.08.25 | 1 | 3.9 | Claragraben 1069 | 30.08.25 00:15:40 | 2025-08-30 00:15:40+02:00 |
| 15073819 | 15073819 | 18 | 00:15:23 | 30.08.25 | 1 | 3.1 | Claragraben 1069 | 30.08.25 00:15:23 | 2025-08-30 00:15:23+02:00 |
| 15073818 | 15073818 | 30 | 00:14:54 | 30.08.25 | 1 | 4.3 | Claragraben 1069 | 30.08.25 00:14:54 | 2025-08-30 00:14:54+02:00 |
| 15073817 | 15073817 | 36 | 00:14:38 | 30.08.25 | 1 | 4.4 | Claragraben 1069 | 30.08.25 00:14:38 | 2025-08-30 00:14:38+02:00 |
| 15073816 | 15073816 | 44 | 00:13:56 | 30.08.25 | 1 | 4.2 | Claragraben 1069 | 30.08.25 00:13:56 | 2025-08-30 00:13:56+02:00 |
| 15073815 | 15073815 | 34 | 00:12:51 | 30.08.25 | 1 | 4.0 | Claragraben 1069 | 30.08.25 00:12:51 | 2025-08-30 00:12:51+02:00 |
| 15073814 | 15073814 | 32 | 00:12:01 | 30.08.25 | 1 | 4.1 | Claragraben 1069 | 30.08.25 00:12:01 | 2025-08-30 00:12:01+02:00 |
| 15073813 | 15073813 | 35 | 00:11:59 | 30.08.25 | 1 | 4.5 | Claragraben 1069 | 30.08.25 00:11:59 | 2025-08-30 00:11:59+02:00 |
| 15073812 | 15073812 | 38 | 00:11:54 | 30.08.25 | 1 | 5.2 | Claragraben 1069 | 30.08.25 00:11:54 | 2025-08-30 00:11:54+02:00 |
| 15073811 | 15073811 | 19 | 00:11:03 | 30.08.25 | 1 | 3.8 | Claragraben 1069 | 30.08.25 00:11:03 | 2025-08-30 00:11:03+02:00 |
| 15073810 | 15073810 | 25 | 00:10:54 | 30.08.25 | 1 | 3.8 | Claragraben 1069 | 30.08.25 00:10:54 | 2025-08-30 00:10:54+02:00 |
| 15073809 | 15073809 | 32 | 00:10:37 | 30.08.25 | 1 | 4.8 | Claragraben 1069 | 30.08.25 00:10:37 | 2025-08-30 00:10:37+02:00 |
| 15073808 | 15073808 | 33 | 00:10:23 | 30.08.25 | 1 | 4.3 | Claragraben 1069 | 30.08.25 00:10:23 | 2025-08-30 00:10:23+02:00 |
| 15073807 | 15073807 | 31 | 00:10:03 | 30.08.25 | 1 | 4.9 | Claragraben 1069 | 30.08.25 00:10:03 | 2025-08-30 00:10:03+02:00 |
| 15073806 | 15073806 | 32 | 00:09:51 | 30.08.25 | 1 | 3.7 | Claragraben 1069 | 30.08.25 00:09:51 | 2025-08-30 00:09:51+02:00 |
| 15073805 | 15073805 | 38 | 00:09:39 | 30.08.25 | 1 | 4.8 | Claragraben 1069 | 30.08.25 00:09:39 | 2025-08-30 00:09:39+02:00 |
| 15073804 | 15073804 | 16 | 00:09:22 | 30.08.25 | 1 | 3.7 | Claragraben 1069 | 30.08.25 00:09:22 | 2025-08-30 00:09:22+02:00 |
| 15073803 | 15073803 | 33 | 00:09:11 | 30.08.25 | 1 | 21.7 | Claragraben 1069 | 30.08.25 00:09:11 | 2025-08-30 00:09:11+02:00 |
| 15073802 | 15073802 | 33 | 00:08:47 | 30.08.25 | 1 | 5.5 | Claragraben 1069 | 30.08.25 00:08:47 | 2025-08-30 00:08:47+02:00 |
| 15073801 | 15073801 | 33 | 00:08:33 | 30.08.25 | 1 | 3.8 | Claragraben 1069 | 30.08.25 00:08:33 | 2025-08-30 00:08:33+02:00 |
| 15073800 | 15073800 | 31 | 00:08:29 | 30.08.25 | 1 | 4.2 | Claragraben 1069 | 30.08.25 00:08:29 | 2025-08-30 00:08:29+02:00 |
| 15073799 | 15073799 | 36 | 00:07:47 | 30.08.25 | 1 | 5.9 | Claragraben 1069 | 30.08.25 00:07:47 | 2025-08-30 00:07:47+02:00 |
| 15073798 | 15073798 | 34 | 00:07:18 | 30.08.25 | 1 | 4.7 | Claragraben 1069 | 30.08.25 00:07:18 | 2025-08-30 00:07:18+02:00 |
| 15073797 | 15073797 | 30 | 00:07:14 | 30.08.25 | 1 | 3.3 | Claragraben 1069 | 30.08.25 00:07:14 | 2025-08-30 00:07:14+02:00 |
| 15073796 | 15073796 | 35 | 00:07:05 | 30.08.25 | 1 | 4.9 | Claragraben 1069 | 30.08.25 00:07:05 | 2025-08-30 00:07:05+02:00 |
| 15073795 | 15073795 | 33 | 00:06:49 | 30.08.25 | 1 | 21.7 | Claragraben 1069 | 30.08.25 00:06:49 | 2025-08-30 00:06:49+02:00 |
| 15073794 | 15073794 | 40 | 00:05:08 | 30.08.25 | 1 | 4.1 | Claragraben 1069 | 30.08.25 00:05:08 | 2025-08-30 00:05:08+02:00 |
| 15073793 | 15073793 | 32 | 00:04:36 | 30.08.25 | 1 | 3.7 | Claragraben 1069 | 30.08.25 00:04:36 | 2025-08-30 00:04:36+02:00 |
| 15073792 | 15073792 | 27 | 00:04:33 | 30.08.25 | 1 | 4.3 | Claragraben 1069 | 30.08.25 00:04:33 | 2025-08-30 00:04:33+02:00 |
| 15073791 | 15073791 | 30 | 00:04:17 | 30.08.25 | 1 | 3.9 | Claragraben 1069 | 30.08.25 00:04:17 | 2025-08-30 00:04:17+02:00 |
| 15073790 | 15073790 | 37 | 00:04:09 | 30.08.25 | 1 | 5.2 | Claragraben 1069 | 30.08.25 00:04:09 | 2025-08-30 00:04:09+02:00 |
| 15073789 | 15073789 | 34 | 00:03:41 | 30.08.25 | 1 | 4.6 | Claragraben 1069 | 30.08.25 00:03:41 | 2025-08-30 00:03:41+02:00 |
| 15073788 | 15073788 | 30 | 00:03:38 | 30.08.25 | 1 | 3.8 | Claragraben 1069 | 30.08.25 00:03:38 | 2025-08-30 00:03:38+02:00 |
| 15073787 | 15073787 | 32 | 00:03:21 | 30.08.25 | 1 | 4.3 | Claragraben 1069 | 30.08.25 00:03:21 | 2025-08-30 00:03:21+02:00 |
| 15073786 | 15073786 | 32 | 00:03:17 | 30.08.25 | 1 | 4.2 | Claragraben 1069 | 30.08.25 00:03:17 | 2025-08-30 00:03:17+02:00 |
| 15073785 | 15073785 | 34 | 00:03:13 | 30.08.25 | 1 | 21.8 | Claragraben 1069 | 30.08.25 00:03:13 | 2025-08-30 00:03:13+02:00 |
| 15073784 | 15073784 | 27 | 00:02:22 | 30.08.25 | 1 | 3.7 | Claragraben 1069 | 30.08.25 00:02:22 | 2025-08-30 00:02:22+02:00 |
| 15073783 | 15073783 | 32 | 00:01:54 | 30.08.25 | 1 | 4.3 | Claragraben 1069 | 30.08.25 00:01:54 | 2025-08-30 00:01:54+02:00 |
| 15073782 | 15073782 | 32 | 00:01:51 | 30.08.25 | 1 | 4.0 | Claragraben 1069 | 30.08.25 00:01:51 | 2025-08-30 00:01:51+02:00 |
| 15073781 | 15073781 | 35 | 00:00:39 | 30.08.25 | 1 | 4.0 | Claragraben 1069 | 30.08.25 00:00:39 | 2025-08-30 00:00:39+02:00 |
| 15073780 | 15073780 | 35 | 00:00:25 | 30.08.25 | 1 | 4.7 | Claragraben 1069 | 30.08.25 00:00:25 | 2025-08-30 00:00:25+02:00 |
| 15073779 | 15073779 | 34 | 00:00:23 | 30.08.25 | 1 | 4.1 | Claragraben 1069 | 30.08.25 00:00:23 | 2025-08-30 00:00:23+02:00 |
| 15073778 | 15073778 | 25 | 23:59:54 | 29.08.25 | 1 | 4.8 | Claragraben 1069 | 29.08.25 23:59:54 | 2025-08-29 23:59:54+02:00 |
| 15073777 | 15073777 | 24 | 23:59:43 | 29.08.25 | 1 | 4.6 | Claragraben 1069 | 29.08.25 23:59:43 | 2025-08-29 23:59:43+02:00 |
| 15073776 | 15073776 | 29 | 23:59:33 | 29.08.25 | 1 | 5.0 | Claragraben 1069 | 29.08.25 23:59:33 | 2025-08-29 23:59:33+02:00 |
| 15073775 | 15073775 | 26 | 23:59:29 | 29.08.25 | 1 | 3.8 | Claragraben 1069 | 29.08.25 23:59:29 | 2025-08-29 23:59:29+02:00 |
| 15073774 | 15073774 | 28 | 23:59:00 | 29.08.25 | 1 | 3.7 | Claragraben 1069 | 29.08.25 23:59:00 | 2025-08-29 23:59:00+02:00 |
| 15073773 | 15073773 | 35 | 23:58:52 | 29.08.25 | 1 | 4.6 | Claragraben 1069 | 29.08.25 23:58:52 | 2025-08-29 23:58:52+02:00 |
| 15073772 | 15073772 | 38 | 23:58:39 | 29.08.25 | 1 | 4.6 | Claragraben 1069 | 29.08.25 23:58:39 | 2025-08-29 23:58:39+02:00 |
| 15073771 | 15073771 | 34 | 23:58:33 | 29.08.25 | 1 | 4.0 | Claragraben 1069 | 29.08.25 23:58:33 | 2025-08-29 23:58:33+02:00 |
| 15073770 | 15073770 | 27 | 23:57:48 | 29.08.25 | 1 | 4.7 | Claragraben 1069 | 29.08.25 23:57:48 | 2025-08-29 23:57:48+02:00 |
| 15073769 | 15073769 | 33 | 23:57:38 | 29.08.25 | 1 | 5.3 | Claragraben 1069 | 29.08.25 23:57:38 | 2025-08-29 23:57:38+02:00 |
| 15073768 | 15073768 | 33 | 23:57:35 | 29.08.25 | 1 | 4.6 | Claragraben 1069 | 29.08.25 23:57:35 | 2025-08-29 23:57:35+02:00 |
| 15073767 | 15073767 | 35 | 23:56:40 | 29.08.25 | 1 | 3.8 | Claragraben 1069 | 29.08.25 23:56:40 | 2025-08-29 23:56:40+02:00 |
| 15073766 | 15073766 | 29 | 23:55:55 | 29.08.25 | 1 | 5.4 | Claragraben 1069 | 29.08.25 23:55:55 | 2025-08-29 23:55:55+02:00 |
| 15073765 | 15073765 | 31 | 23:55:24 | 29.08.25 | 1 | 3.9 | Claragraben 1069 | 29.08.25 23:55:24 | 2025-08-29 23:55:24+02:00 |
| 15073764 | 15073764 | 34 | 23:55:07 | 29.08.25 | 1 | 4.5 | Claragraben 1069 | 29.08.25 23:55:07 | 2025-08-29 23:55:07+02:00 |
| 15073763 | 15073763 | 34 | 23:55:04 | 29.08.25 | 1 | 4.5 | Claragraben 1069 | 29.08.25 23:55:04 | 2025-08-29 23:55:04+02:00 |
| 15073762 | 15073762 | 38 | 23:54:53 | 29.08.25 | 1 | 4.6 | Claragraben 1069 | 29.08.25 23:54:53 | 2025-08-29 23:54:53+02:00 |
| 15073761 | 15073761 | 35 | 23:54:37 | 29.08.25 | 1 | 5.0 | Claragraben 1069 | 29.08.25 23:54:37 | 2025-08-29 23:54:37+02:00 |
| 15073760 | 15073760 | 36 | 23:54:28 | 29.08.25 | 1 | 3.8 | Claragraben 1069 | 29.08.25 23:54:28 | 2025-08-29 23:54:28+02:00 |
| 15073759 | 15073759 | 36 | 23:54:06 | 29.08.25 | 1 | 5.3 | Claragraben 1069 | 29.08.25 23:54:06 | 2025-08-29 23:54:06+02:00 |
| 15073758 | 15073758 | 30 | 23:53:44 | 29.08.25 | 1 | 4.0 | Claragraben 1069 | 29.08.25 23:53:44 | 2025-08-29 23:53:44+02:00 |
| 15073757 | 15073757 | 31 | 23:53:16 | 29.08.25 | 1 | 4.6 | Claragraben 1069 | 29.08.25 23:53:16 | 2025-08-29 23:53:16+02:00 |
| 15073756 | 15073756 | 30 | 23:53:14 | 29.08.25 | 1 | 3.4 | Claragraben 1069 | 29.08.25 23:53:14 | 2025-08-29 23:53:14+02:00 |
| 15073755 | 15073755 | 32 | 23:52:54 | 29.08.25 | 1 | 5.1 | Claragraben 1069 | 29.08.25 23:52:54 | 2025-08-29 23:52:54+02:00 |
| 15073754 | 15073754 | 34 | 23:52:46 | 29.08.25 | 1 | 3.9 | Claragraben 1069 | 29.08.25 23:52:46 | 2025-08-29 23:52:46+02:00 |
| 15073753 | 15073753 | 34 | 23:52:28 | 29.08.25 | 1 | 4.6 | Claragraben 1069 | 29.08.25 23:52:28 | 2025-08-29 23:52:28+02:00 |
| 15073752 | 15073752 | 30 | 23:51:58 | 29.08.25 | 1 | 4.2 | Claragraben 1069 | 29.08.25 23:51:58 | 2025-08-29 23:51:58+02:00 |
| 15073751 | 15073751 | 37 | 23:51:37 | 29.08.25 | 1 | 4.4 | Claragraben 1069 | 29.08.25 23:51:37 | 2025-08-29 23:51:37+02:00 |
| 15073750 | 15073750 | 36 | 23:51:32 | 29.08.25 | 1 | 23.1 | Claragraben 1069 | 29.08.25 23:51:32 | 2025-08-29 23:51:32+02:00 |
| 15073749 | 15073749 | 28 | 23:51:21 | 29.08.25 | 1 | 3.9 | Claragraben 1069 | 29.08.25 23:51:21 | 2025-08-29 23:51:21+02:00 |
| 15073748 | 15073748 | 30 | 23:51:15 | 29.08.25 | 1 | 4.4 | Claragraben 1069 | 29.08.25 23:51:15 | 2025-08-29 23:51:15+02:00 |
| 15073747 | 15073747 | 26 | 23:51:11 | 29.08.25 | 1 | 3.9 | Claragraben 1069 | 29.08.25 23:51:11 | 2025-08-29 23:51:11+02:00 |
| 15011676 | 15011676 | 9 | 23:50:45 | 29.08.25 | 2 | 2.2 | Claragraben 1069 | 29.08.25 23:50:45 | 2025-08-29 23:50:45+02:00 |
| 15011677 | 15011677 | 8 | 23:50:45 | 29.08.25 | 2 | 1.6 | Claragraben 1069 | 29.08.25 23:50:45 | 2025-08-29 23:50:45+02:00 |
| 15073746 | 15073746 | 30 | 23:49:53 | 29.08.25 | 1 | 5.3 | Claragraben 1069 | 29.08.25 23:49:53 | 2025-08-29 23:49:53+02:00 |
| 15073745 | 15073745 | 32 | 23:48:26 | 29.08.25 | 1 | 5.0 | Claragraben 1069 | 29.08.25 23:48:26 | 2025-08-29 23:48:26+02:00 |
| 15073744 | 15073744 | 31 | 23:48:09 | 29.08.25 | 1 | 5.3 | Claragraben 1069 | 29.08.25 23:48:09 | 2025-08-29 23:48:09+02:00 |
| 15073743 | 15073743 | 32 | 23:47:51 | 29.08.25 | 1 | 14.4 | Claragraben 1069 | 29.08.25 23:47:51 | 2025-08-29 23:47:51+02:00 |
| 15073742 | 15073742 | 29 | 23:47:40 | 29.08.25 | 1 | 1.0 | Claragraben 1069 | 29.08.25 23:47:40 | 2025-08-29 23:47:40+02:00 |
| 15073741 | 15073741 | 33 | 23:47:38 | 29.08.25 | 1 | 5.0 | Claragraben 1069 | 29.08.25 23:47:38 | 2025-08-29 23:47:38+02:00 |
| 15073740 | 15073740 | 30 | 23:47:23 | 29.08.25 | 1 | 5.1 | Claragraben 1069 | 29.08.25 23:47:23 | 2025-08-29 23:47:23+02:00 |
| 15073739 | 15073739 | 32 | 23:47:03 | 29.08.25 | 1 | 4.5 | Claragraben 1069 | 29.08.25 23:47:03 | 2025-08-29 23:47:03+02:00 |
| 15073738 | 15073738 | 30 | 23:46:53 | 29.08.25 | 1 | 5.3 | Claragraben 1069 | 29.08.25 23:46:53 | 2025-08-29 23:46:53+02:00 |
| 15073737 | 15073737 | 26 | 23:46:29 | 29.08.25 | 1 | 4.0 | Claragraben 1069 | 29.08.25 23:46:29 | 2025-08-29 23:46:29+02:00 |
| 15073736 | 15073736 | 33 | 23:46:23 | 29.08.25 | 1 | 4.5 | Claragraben 1069 | 29.08.25 23:46:23 | 2025-08-29 23:46:23+02:00 |
| 15073735 | 15073735 | 35 | 23:45:21 | 29.08.25 | 1 | 4.5 | Claragraben 1069 | 29.08.25 23:45:21 | 2025-08-29 23:45:21+02:00 |
| 15073734 | 15073734 | 26 | 23:44:57 | 29.08.25 | 1 | 4.3 | Claragraben 1069 | 29.08.25 23:44:57 | 2025-08-29 23:44:57+02:00 |
| 15073733 | 15073733 | 33 | 23:44:52 | 29.08.25 | 1 | 4.2 | Claragraben 1069 | 29.08.25 23:44:52 | 2025-08-29 23:44:52+02:00 |
| 15073732 | 15073732 | 29 | 23:44:25 | 29.08.25 | 1 | 3.8 | Claragraben 1069 | 29.08.25 23:44:25 | 2025-08-29 23:44:25+02:00 |
| 15073731 | 15073731 | 34 | 23:44:23 | 29.08.25 | 1 | 5.8 | Claragraben 1069 | 29.08.25 23:44:23 | 2025-08-29 23:44:23+02:00 |
| 15073730 | 15073730 | 36 | 23:44:11 | 29.08.25 | 1 | 4.9 | Claragraben 1069 | 29.08.25 23:44:11 | 2025-08-29 23:44:11+02:00 |
| 15073729 | 15073729 | 33 | 23:44:07 | 29.08.25 | 1 | 4.3 | Claragraben 1069 | 29.08.25 23:44:07 | 2025-08-29 23:44:07+02: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");