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 = 56 sorted by Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Timestamp (date)
| Link | rowid | Geschwindigkeit | Zeit | Datum | Richtung ID | Fahrzeuglänge | Messung-ID | Datum_Zeit | Timestamp ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 34951676 | 34951676 | 37 | 09:04:13 | 28.10.19 | 2 | 5.0 | 56 56 | 28.10.19 09:04:13 | 2019-10-28 09:04:13+01:00 |
| 34951675 | 34951675 | 28 | 09:03:58 | 28.10.19 | 2 | 2.2 | 56 56 | 28.10.19 09:03:58 | 2019-10-28 09:03:58+01:00 |
| 34951674 | 34951674 | 24 | 09:03:50 | 28.10.19 | 2 | 8.1 | 56 56 | 28.10.19 09:03:50 | 2019-10-28 09:03:50+01:00 |
| 34951673 | 34951673 | 32 | 09:02:53 | 28.10.19 | 2 | 4.3 | 56 56 | 28.10.19 09:02:53 | 2019-10-28 09:02:53+01:00 |
| 34951672 | 34951672 | 26 | 09:02:48 | 28.10.19 | 2 | 5.2 | 56 56 | 28.10.19 09:02:48 | 2019-10-28 09:02:48+01:00 |
| 34951671 | 34951671 | 24 | 09:02:45 | 28.10.19 | 2 | 4.2 | 56 56 | 28.10.19 09:02:45 | 2019-10-28 09:02:45+01:00 |
| 34951670 | 34951670 | 30 | 09:02:37 | 28.10.19 | 2 | 4.1 | 56 56 | 28.10.19 09:02:37 | 2019-10-28 09:02:37+01:00 |
| 34951669 | 34951669 | 30 | 09:02:28 | 28.10.19 | 2 | 4.9 | 56 56 | 28.10.19 09:02:28 | 2019-10-28 09:02:28+01:00 |
| 34962361 | 34962361 | 25 | 09:02:20 | 28.10.19 | 1 | 0.9 | 56 56 | 28.10.19 09:02:20 | 2019-10-28 09:02:20+01:00 |
| 34951668 | 34951668 | 30 | 09:02:17 | 28.10.19 | 2 | 4.5 | 56 56 | 28.10.19 09:02:17 | 2019-10-28 09:02:17+01:00 |
| 34951667 | 34951667 | 35 | 09:02:12 | 28.10.19 | 2 | 4.3 | 56 56 | 28.10.19 09:02:12 | 2019-10-28 09:02:12+01:00 |
| 34951666 | 34951666 | 28 | 09:02:00 | 28.10.19 | 2 | 3.6 | 56 56 | 28.10.19 09:02:00 | 2019-10-28 09:02:00+01:00 |
| 34951665 | 34951665 | 27 | 09:01:58 | 28.10.19 | 2 | 4.2 | 56 56 | 28.10.19 09:01:58 | 2019-10-28 09:01:58+01:00 |
| 34951664 | 34951664 | 37 | 09:01:34 | 28.10.19 | 2 | 2.8 | 56 56 | 28.10.19 09:01:34 | 2019-10-28 09:01:34+01:00 |
| 34962360 | 34962360 | 31 | 09:01:22 | 28.10.19 | 1 | 4.0 | 56 56 | 28.10.19 09:01:22 | 2019-10-28 09:01:22+01:00 |
| 34951663 | 34951663 | 27 | 09:01:11 | 28.10.19 | 2 | 4.4 | 56 56 | 28.10.19 09:01:11 | 2019-10-28 09:01:11+01:00 |
| 34951662 | 34951662 | 34 | 09:01:07 | 28.10.19 | 2 | 4.6 | 56 56 | 28.10.19 09:01:07 | 2019-10-28 09:01:07+01:00 |
| 34951661 | 34951661 | 34 | 09:01:01 | 28.10.19 | 2 | 4.5 | 56 56 | 28.10.19 09:01:01 | 2019-10-28 09:01:01+01:00 |
| 34962359 | 34962359 | 22 | 09:00:54 | 28.10.19 | 1 | 1.0 | 56 56 | 28.10.19 09:00:54 | 2019-10-28 09:00:54+01:00 |
| 34951660 | 34951660 | 30 | 09:00:50 | 28.10.19 | 2 | 5.4 | 56 56 | 28.10.19 09:00:50 | 2019-10-28 09:00:50+01:00 |
| 34951659 | 34951659 | 34 | 09:00:44 | 28.10.19 | 2 | 4.4 | 56 56 | 28.10.19 09:00:44 | 2019-10-28 09:00:44+01:00 |
| 34951658 | 34951658 | 28 | 09:00:40 | 28.10.19 | 2 | 4.0 | 56 56 | 28.10.19 09:00:40 | 2019-10-28 09:00:40+01:00 |
| 34951657 | 34951657 | 30 | 09:00:38 | 28.10.19 | 2 | 4.4 | 56 56 | 28.10.19 09:00:38 | 2019-10-28 09:00:38+01:00 |
| 34951656 | 34951656 | 31 | 09:00:21 | 28.10.19 | 2 | 3.7 | 56 56 | 28.10.19 09:00:21 | 2019-10-28 09:00:21+01:00 |
| 34962358 | 34962358 | 14 | 09:00:17 | 28.10.19 | 1 | 1.3 | 56 56 | 28.10.19 09:00:17 | 2019-10-28 09:00:17+01:00 |
| 34951655 | 34951655 | 32 | 09:00:15 | 28.10.19 | 2 | 4.1 | 56 56 | 28.10.19 09:00:15 | 2019-10-28 09:00:15+01:00 |
| 34951654 | 34951654 | 30 | 09:00:03 | 28.10.19 | 2 | 4.6 | 56 56 | 28.10.19 09:00:03 | 2019-10-28 09:00:03+01:00 |
| 34951653 | 34951653 | 34 | 08:59:53 | 28.10.19 | 2 | 4.8 | 56 56 | 28.10.19 08:59:53 | 2019-10-28 08:59:53+01:00 |
| 34962357 | 34962357 | 33 | 08:59:53 | 28.10.19 | 1 | 3.1 | 56 56 | 28.10.19 08:59:53 | 2019-10-28 08:59:53+01:00 |
| 34951652 | 34951652 | 23 | 08:59:38 | 28.10.19 | 2 | 3.8 | 56 56 | 28.10.19 08:59:38 | 2019-10-28 08:59:38+01:00 |
| 34962356 | 34962356 | 20 | 08:59:35 | 28.10.19 | 1 | 0.8 | 56 56 | 28.10.19 08:59:35 | 2019-10-28 08:59:35+01:00 |
| 34951651 | 34951651 | 37 | 08:59:28 | 28.10.19 | 2 | 5.1 | 56 56 | 28.10.19 08:59:28 | 2019-10-28 08:59:28+01:00 |
| 34951650 | 34951650 | 33 | 08:59:25 | 28.10.19 | 2 | 4.0 | 56 56 | 28.10.19 08:59:25 | 2019-10-28 08:59:25+01:00 |
| 34951649 | 34951649 | 31 | 08:59:21 | 28.10.19 | 2 | 4.3 | 56 56 | 28.10.19 08:59:21 | 2019-10-28 08:59:21+01:00 |
| 34951648 | 34951648 | 31 | 08:59:17 | 28.10.19 | 2 | 4.7 | 56 56 | 28.10.19 08:59:17 | 2019-10-28 08:59:17+01:00 |
| 34951647 | 34951647 | 35 | 08:59:11 | 28.10.19 | 2 | 0.9 | 56 56 | 28.10.19 08:59:11 | 2019-10-28 08:59:11+01:00 |
| 34951646 | 34951646 | 37 | 08:59:03 | 28.10.19 | 2 | 5.2 | 56 56 | 28.10.19 08:59:03 | 2019-10-28 08:59:03+01:00 |
| 34951645 | 34951645 | 44 | 08:58:52 | 28.10.19 | 2 | 5.3 | 56 56 | 28.10.19 08:58:52 | 2019-10-28 08:58:52+01:00 |
| 34951644 | 34951644 | 39 | 08:58:49 | 28.10.19 | 2 | 4.3 | 56 56 | 28.10.19 08:58:49 | 2019-10-28 08:58:49+01:00 |
| 34962355 | 34962355 | 23 | 08:58:47 | 28.10.19 | 1 | 5.1 | 56 56 | 28.10.19 08:58:47 | 2019-10-28 08:58:47+01:00 |
| 34962354 | 34962354 | 26 | 08:58:43 | 28.10.19 | 1 | 4.2 | 56 56 | 28.10.19 08:58:43 | 2019-10-28 08:58:43+01:00 |
| 34951643 | 34951643 | 29 | 08:58:42 | 28.10.19 | 2 | 4.4 | 56 56 | 28.10.19 08:58:42 | 2019-10-28 08:58:42+01:00 |
| 34951642 | 34951642 | 26 | 08:58:33 | 28.10.19 | 2 | 4.7 | 56 56 | 28.10.19 08:58:33 | 2019-10-28 08:58:33+01:00 |
| 34951641 | 34951641 | 27 | 08:58:30 | 28.10.19 | 2 | 5.6 | 56 56 | 28.10.19 08:58:30 | 2019-10-28 08:58:30+01:00 |
| 34951640 | 34951640 | 23 | 08:58:13 | 28.10.19 | 2 | 2.7 | 56 56 | 28.10.19 08:58:13 | 2019-10-28 08:58:13+01:00 |
| 34951639 | 34951639 | 29 | 08:58:08 | 28.10.19 | 2 | 4.5 | 56 56 | 28.10.19 08:58:08 | 2019-10-28 08:58:08+01:00 |
| 34962353 | 34962353 | 24 | 08:58:05 | 28.10.19 | 1 | 3.2 | 56 56 | 28.10.19 08:58:05 | 2019-10-28 08:58:05+01:00 |
| 34951638 | 34951638 | 29 | 08:58:04 | 28.10.19 | 2 | 5.2 | 56 56 | 28.10.19 08:58:04 | 2019-10-28 08:58:04+01:00 |
| 34951637 | 34951637 | 33 | 08:58:01 | 28.10.19 | 2 | 5.1 | 56 56 | 28.10.19 08:58:01 | 2019-10-28 08:58:01+01:00 |
| 34951636 | 34951636 | 32 | 08:57:51 | 28.10.19 | 2 | 2.9 | 56 56 | 28.10.19 08:57:51 | 2019-10-28 08:57:51+01:00 |
| 34962352 | 34962352 | 25 | 08:57:46 | 28.10.19 | 1 | 0.7 | 56 56 | 28.10.19 08:57:46 | 2019-10-28 08:57:46+01:00 |
| 34951635 | 34951635 | 33 | 08:57:42 | 28.10.19 | 2 | 5.3 | 56 56 | 28.10.19 08:57:42 | 2019-10-28 08:57:42+01:00 |
| 34951634 | 34951634 | 24 | 08:57:35 | 28.10.19 | 2 | 5.3 | 56 56 | 28.10.19 08:57:35 | 2019-10-28 08:57:35+01:00 |
| 34951633 | 34951633 | 33 | 08:57:24 | 28.10.19 | 2 | 2.9 | 56 56 | 28.10.19 08:57:24 | 2019-10-28 08:57:24+01:00 |
| 34951632 | 34951632 | 31 | 08:57:03 | 28.10.19 | 2 | 4.9 | 56 56 | 28.10.19 08:57:03 | 2019-10-28 08:57:03+01:00 |
| 34951631 | 34951631 | 31 | 08:56:59 | 28.10.19 | 2 | 3.3 | 56 56 | 28.10.19 08:56:59 | 2019-10-28 08:56:59+01:00 |
| 34962351 | 34962351 | 24 | 08:56:52 | 28.10.19 | 1 | 4.2 | 56 56 | 28.10.19 08:56:52 | 2019-10-28 08:56:52+01:00 |
| 34951630 | 34951630 | 37 | 08:56:48 | 28.10.19 | 2 | 2.0 | 56 56 | 28.10.19 08:56:48 | 2019-10-28 08:56:48+01:00 |
| 34951629 | 34951629 | 25 | 08:56:41 | 28.10.19 | 2 | 4.4 | 56 56 | 28.10.19 08:56:41 | 2019-10-28 08:56:41+01:00 |
| 34951628 | 34951628 | 27 | 08:56:36 | 28.10.19 | 2 | 3.4 | 56 56 | 28.10.19 08:56:36 | 2019-10-28 08:56:36+01:00 |
| 34962350 | 34962350 | 14 | 08:56:32 | 28.10.19 | 1 | 4.7 | 56 56 | 28.10.19 08:56:32 | 2019-10-28 08:56:32+01:00 |
| 34962349 | 34962349 | 23 | 08:56:28 | 28.10.19 | 1 | 4.1 | 56 56 | 28.10.19 08:56:28 | 2019-10-28 08:56:28+01:00 |
| 34951627 | 34951627 | 34 | 08:56:13 | 28.10.19 | 2 | 4.1 | 56 56 | 28.10.19 08:56:13 | 2019-10-28 08:56:13+01:00 |
| 34951626 | 34951626 | 29 | 08:56:03 | 28.10.19 | 2 | 4.2 | 56 56 | 28.10.19 08:56:03 | 2019-10-28 08:56:03+01:00 |
| 34951625 | 34951625 | 30 | 08:56:01 | 28.10.19 | 2 | 5.6 | 56 56 | 28.10.19 08:56:01 | 2019-10-28 08:56:01+01:00 |
| 34962348 | 34962348 | 30 | 08:55:45 | 28.10.19 | 1 | 3.3 | 56 56 | 28.10.19 08:55:45 | 2019-10-28 08:55:45+01:00 |
| 34951624 | 34951624 | 33 | 08:55:40 | 28.10.19 | 2 | 3.3 | 56 56 | 28.10.19 08:55:40 | 2019-10-28 08:55:40+01:00 |
| 34962347 | 34962347 | 17 | 08:55:37 | 28.10.19 | 1 | 4.6 | 56 56 | 28.10.19 08:55:37 | 2019-10-28 08:55:37+01:00 |
| 34962346 | 34962346 | 18 | 08:55:33 | 28.10.19 | 1 | 0.7 | 56 56 | 28.10.19 08:55:33 | 2019-10-28 08:55:33+01:00 |
| 34951623 | 34951623 | 26 | 08:55:29 | 28.10.19 | 2 | 13.5 | 56 56 | 28.10.19 08:55:29 | 2019-10-28 08:55:29+01:00 |
| 34951622 | 34951622 | 25 | 08:55:24 | 28.10.19 | 2 | 4.0 | 56 56 | 28.10.19 08:55:24 | 2019-10-28 08:55:24+01:00 |
| 34951621 | 34951621 | 24 | 08:55:22 | 28.10.19 | 2 | 2.9 | 56 56 | 28.10.19 08:55:22 | 2019-10-28 08:55:22+01:00 |
| 34962345 | 34962345 | 18 | 08:55:19 | 28.10.19 | 1 | 4.3 | 56 56 | 28.10.19 08:55:19 | 2019-10-28 08:55:19+01:00 |
| 34951620 | 34951620 | 23 | 08:55:13 | 28.10.19 | 2 | 4.7 | 56 56 | 28.10.19 08:55:13 | 2019-10-28 08:55:13+01:00 |
| 34951619 | 34951619 | 23 | 08:55:09 | 28.10.19 | 2 | 6.1 | 56 56 | 28.10.19 08:55:09 | 2019-10-28 08:55:09+01:00 |
| 34951618 | 34951618 | 24 | 08:55:04 | 28.10.19 | 2 | 7.3 | 56 56 | 28.10.19 08:55:04 | 2019-10-28 08:55:04+01:00 |
| 34951617 | 34951617 | 31 | 08:54:51 | 28.10.19 | 2 | 3.5 | 56 56 | 28.10.19 08:54:51 | 2019-10-28 08:54:51+01:00 |
| 34951616 | 34951616 | 30 | 08:54:46 | 28.10.19 | 2 | 4.6 | 56 56 | 28.10.19 08:54:46 | 2019-10-28 08:54:46+01:00 |
| 34962344 | 34962344 | 15 | 08:54:43 | 28.10.19 | 1 | 2.3 | 56 56 | 28.10.19 08:54:43 | 2019-10-28 08:54:43+01:00 |
| 34951615 | 34951615 | 31 | 08:54:39 | 28.10.19 | 2 | 3.8 | 56 56 | 28.10.19 08:54:39 | 2019-10-28 08:54:39+01:00 |
| 34962343 | 34962343 | 26 | 08:54:39 | 28.10.19 | 1 | 0.9 | 56 56 | 28.10.19 08:54:39 | 2019-10-28 08:54:39+01:00 |
| 34962342 | 34962342 | 25 | 08:54:28 | 28.10.19 | 1 | 3.6 | 56 56 | 28.10.19 08:54:28 | 2019-10-28 08:54:28+01:00 |
| 34951614 | 34951614 | 24 | 08:54:24 | 28.10.19 | 2 | 4.2 | 56 56 | 28.10.19 08:54:24 | 2019-10-28 08:54:24+01:00 |
| 34951613 | 34951613 | 33 | 08:54:16 | 28.10.19 | 2 | 4.7 | 56 56 | 28.10.19 08:54:16 | 2019-10-28 08:54:16+01:00 |
| 34951612 | 34951612 | 23 | 08:54:02 | 28.10.19 | 2 | 3.8 | 56 56 | 28.10.19 08:54:02 | 2019-10-28 08:54:02+01:00 |
| 34951611 | 34951611 | 25 | 08:53:41 | 28.10.19 | 2 | 4.3 | 56 56 | 28.10.19 08:53:41 | 2019-10-28 08:53:41+01:00 |
| 34951610 | 34951610 | 27 | 08:53:38 | 28.10.19 | 2 | 3.9 | 56 56 | 28.10.19 08:53:38 | 2019-10-28 08:53:38+01:00 |
| 34962341 | 34962341 | 17 | 08:53:25 | 28.10.19 | 1 | 4.7 | 56 56 | 28.10.19 08:53:25 | 2019-10-28 08:53:25+01:00 |
| 34951609 | 34951609 | 18 | 08:53:15 | 28.10.19 | 2 | 5.0 | 56 56 | 28.10.19 08:53:15 | 2019-10-28 08:53:15+01:00 |
| 34951608 | 34951608 | 24 | 08:53:07 | 28.10.19 | 2 | 4.4 | 56 56 | 28.10.19 08:53:07 | 2019-10-28 08:53:07+01:00 |
| 34951607 | 34951607 | 34 | 08:52:43 | 28.10.19 | 2 | 4.9 | 56 56 | 28.10.19 08:52:43 | 2019-10-28 08:52:43+01:00 |
| 34951606 | 34951606 | 31 | 08:52:35 | 28.10.19 | 2 | 3.8 | 56 56 | 28.10.19 08:52:35 | 2019-10-28 08:52:35+01:00 |
| 34951605 | 34951605 | 32 | 08:52:31 | 28.10.19 | 2 | 4.0 | 56 56 | 28.10.19 08:52:31 | 2019-10-28 08:52:31+01:00 |
| 34951604 | 34951604 | 32 | 08:52:23 | 28.10.19 | 2 | 5.1 | 56 56 | 28.10.19 08:52:23 | 2019-10-28 08:52:23+01:00 |
| 34951603 | 34951603 | 39 | 08:52:15 | 28.10.19 | 2 | 4.7 | 56 56 | 28.10.19 08:52:15 | 2019-10-28 08:52:15+01:00 |
| 34951602 | 34951602 | 32 | 08:52:08 | 28.10.19 | 2 | 4.6 | 56 56 | 28.10.19 08:52:08 | 2019-10-28 08:52:08+01:00 |
| 34951601 | 34951601 | 28 | 08:52:05 | 28.10.19 | 2 | 4.6 | 56 56 | 28.10.19 08:52:05 | 2019-10-28 08:52:05+01:00 |
| 34951600 | 34951600 | 30 | 08:52:02 | 28.10.19 | 2 | 5.4 | 56 56 | 28.10.19 08:52:02 | 2019-10-28 08:52:02+01:00 |
| 34951599 | 34951599 | 28 | 08:52:00 | 28.10.19 | 2 | 2.8 | 56 56 | 28.10.19 08:52:00 | 2019-10-28 08:52:00+01:00 |
| 34951598 | 34951598 | 26 | 08:51:50 | 28.10.19 | 2 | 4.8 | 56 56 | 28.10.19 08:51:50 | 2019-10-28 08:51:50+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");