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 = 20 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 34396604 | 34396604 | 55 | 13:19:44 | 13.01.20 | 1 | 4.3 | 20 20 | 13.01.20 13:19:44 | 2020-01-13 13:19:44+01:00 |
| 34379697 | 34379697 | 49 | 13:19:39 | 13.01.20 | 2 | 2.7 | 20 20 | 13.01.20 13:19:39 | 2020-01-13 13:19:39+01:00 |
| 34396603 | 34396603 | 53 | 13:19:39 | 13.01.20 | 1 | 4.2 | 20 20 | 13.01.20 13:19:39 | 2020-01-13 13:19:39+01:00 |
| 34379696 | 34379696 | 87 | 13:19:08 | 13.01.20 | 2 | 4.4 | 20 20 | 13.01.20 13:19:08 | 2020-01-13 13:19:08+01:00 |
| 34396602 | 34396602 | 48 | 13:18:54 | 13.01.20 | 1 | 3.8 | 20 20 | 13.01.20 13:18:54 | 2020-01-13 13:18:54+01:00 |
| 34396601 | 34396601 | 48 | 13:18:53 | 13.01.20 | 1 | 5.2 | 20 20 | 13.01.20 13:18:53 | 2020-01-13 13:18:53+01:00 |
| 34396600 | 34396600 | 49 | 13:18:51 | 13.01.20 | 1 | 4.7 | 20 20 | 13.01.20 13:18:51 | 2020-01-13 13:18:51+01:00 |
| 34379695 | 34379695 | 48 | 13:18:39 | 13.01.20 | 2 | 4.8 | 20 20 | 13.01.20 13:18:39 | 2020-01-13 13:18:39+01:00 |
| 34396599 | 34396599 | 45 | 13:18:37 | 13.01.20 | 1 | 3.6 | 20 20 | 13.01.20 13:18:37 | 2020-01-13 13:18:37+01:00 |
| 34379694 | 34379694 | 46 | 13:18:22 | 13.01.20 | 2 | 3.9 | 20 20 | 13.01.20 13:18:22 | 2020-01-13 13:18:22+01:00 |
| 34379693 | 34379693 | 53 | 13:18:06 | 13.01.20 | 2 | 4.4 | 20 20 | 13.01.20 13:18:06 | 2020-01-13 13:18:06+01:00 |
| 34379692 | 34379692 | 41 | 13:17:38 | 13.01.20 | 2 | 4.5 | 20 20 | 13.01.20 13:17:38 | 2020-01-13 13:17:38+01:00 |
| 34379691 | 34379691 | 23 | 13:17:27 | 13.01.20 | 2 | 2.6 | 20 20 | 13.01.20 13:17:27 | 2020-01-13 13:17:27+01:00 |
| 34396598 | 34396598 | 51 | 13:17:11 | 13.01.20 | 1 | 4.4 | 20 20 | 13.01.20 13:17:11 | 2020-01-13 13:17:11+01:00 |
| 34379690 | 34379690 | 51 | 13:16:22 | 13.01.20 | 2 | 4.7 | 20 20 | 13.01.20 13:16:22 | 2020-01-13 13:16:22+01:00 |
| 34379689 | 34379689 | 54 | 13:16:16 | 13.01.20 | 2 | 5.6 | 20 20 | 13.01.20 13:16:16 | 2020-01-13 13:16:16+01:00 |
| 34396597 | 34396597 | 53 | 13:16:15 | 13.01.20 | 1 | 3.5 | 20 20 | 13.01.20 13:16:15 | 2020-01-13 13:16:15+01:00 |
| 34379688 | 34379688 | 48 | 13:16:13 | 13.01.20 | 2 | 4.9 | 20 20 | 13.01.20 13:16:13 | 2020-01-13 13:16:13+01:00 |
| 34396596 | 34396596 | 53 | 13:16:03 | 13.01.20 | 1 | 5.0 | 20 20 | 13.01.20 13:16:03 | 2020-01-13 13:16:03+01:00 |
| 34396595 | 34396595 | 55 | 13:16:00 | 13.01.20 | 1 | 4.4 | 20 20 | 13.01.20 13:16:00 | 2020-01-13 13:16:00+01:00 |
| 34396594 | 34396594 | 46 | 13:15:14 | 13.01.20 | 1 | 5.5 | 20 20 | 13.01.20 13:15:14 | 2020-01-13 13:15:14+01:00 |
| 34396593 | 34396593 | 43 | 13:15:12 | 13.01.20 | 1 | 4.8 | 20 20 | 13.01.20 13:15:12 | 2020-01-13 13:15:12+01:00 |
| 34379687 | 34379687 | 52 | 13:14:59 | 13.01.20 | 2 | 5.9 | 20 20 | 13.01.20 13:14:59 | 2020-01-13 13:14:59+01:00 |
| 34396592 | 34396592 | 46 | 13:14:38 | 13.01.20 | 1 | 7.2 | 20 20 | 13.01.20 13:14:38 | 2020-01-13 13:14:38+01:00 |
| 34396591 | 34396591 | 47 | 13:14:10 | 13.01.20 | 1 | 4.3 | 20 20 | 13.01.20 13:14:10 | 2020-01-13 13:14:10+01:00 |
| 34396590 | 34396590 | 45 | 13:14:09 | 13.01.20 | 1 | 3.8 | 20 20 | 13.01.20 13:14:09 | 2020-01-13 13:14:09+01:00 |
| 34379686 | 34379686 | 36 | 13:13:54 | 13.01.20 | 2 | 5.6 | 20 20 | 13.01.20 13:13:54 | 2020-01-13 13:13:54+01:00 |
| 34379685 | 34379685 | 50 | 13:13:40 | 13.01.20 | 2 | 5.6 | 20 20 | 13.01.20 13:13:40 | 2020-01-13 13:13:40+01:00 |
| 34396589 | 34396589 | 41 | 13:13:32 | 13.01.20 | 1 | 1.5 | 20 20 | 13.01.20 13:13:32 | 2020-01-13 13:13:32+01:00 |
| 34379684 | 34379684 | 51 | 13:13:07 | 13.01.20 | 2 | 3.7 | 20 20 | 13.01.20 13:13:07 | 2020-01-13 13:13:07+01:00 |
| 34396588 | 34396588 | 50 | 13:12:52 | 13.01.20 | 1 | 4.1 | 20 20 | 13.01.20 13:12:52 | 2020-01-13 13:12:52+01:00 |
| 34379683 | 34379683 | 46 | 13:12:41 | 13.01.20 | 2 | 5.0 | 20 20 | 13.01.20 13:12:41 | 2020-01-13 13:12:41+01:00 |
| 34379682 | 34379682 | 59 | 13:12:35 | 13.01.20 | 2 | 4.7 | 20 20 | 13.01.20 13:12:35 | 2020-01-13 13:12:35+01:00 |
| 34379681 | 34379681 | 52 | 13:12:24 | 13.01.20 | 2 | 4.1 | 20 20 | 13.01.20 13:12:24 | 2020-01-13 13:12:24+01:00 |
| 34379680 | 34379680 | 41 | 13:12:18 | 13.01.20 | 2 | 4.4 | 20 20 | 13.01.20 13:12:18 | 2020-01-13 13:12:18+01:00 |
| 34379679 | 34379679 | 38 | 13:12:16 | 13.01.20 | 2 | 11.7 | 20 20 | 13.01.20 13:12:16 | 2020-01-13 13:12:16+01:00 |
| 34396587 | 34396587 | 57 | 13:12:09 | 13.01.20 | 1 | 3.7 | 20 20 | 13.01.20 13:12:09 | 2020-01-13 13:12:09+01:00 |
| 34396586 | 34396586 | 41 | 13:12:04 | 13.01.20 | 1 | 5.5 | 20 20 | 13.01.20 13:12:04 | 2020-01-13 13:12:04+01:00 |
| 34379678 | 34379678 | 55 | 13:10:55 | 13.01.20 | 2 | 5.5 | 20 20 | 13.01.20 13:10:55 | 2020-01-13 13:10:55+01:00 |
| 34396585 | 34396585 | 51 | 13:10:34 | 13.01.20 | 1 | 5.6 | 20 20 | 13.01.20 13:10:34 | 2020-01-13 13:10:34+01:00 |
| 34379677 | 34379677 | 47 | 13:10:31 | 13.01.20 | 2 | 5.5 | 20 20 | 13.01.20 13:10:31 | 2020-01-13 13:10:31+01:00 |
| 34379676 | 34379676 | 41 | 13:10:30 | 13.01.20 | 2 | 5.4 | 20 20 | 13.01.20 13:10:30 | 2020-01-13 13:10:30+01:00 |
| 34396583 | 34396583 | 46 | 13:10:30 | 13.01.20 | 1 | 5.9 | 20 20 | 13.01.20 13:10:30 | 2020-01-13 13:10:30+01:00 |
| 34396584 | 34396584 | 43 | 13:10:30 | 13.01.20 | 1 | 2.9 | 20 20 | 13.01.20 13:10:30 | 2020-01-13 13:10:30+01:00 |
| 34379675 | 34379675 | 43 | 13:10:22 | 13.01.20 | 2 | 5.2 | 20 20 | 13.01.20 13:10:22 | 2020-01-13 13:10:22+01:00 |
| 34396582 | 34396582 | 44 | 13:10:16 | 13.01.20 | 1 | 3.9 | 20 20 | 13.01.20 13:10:16 | 2020-01-13 13:10:16+01:00 |
| 34379674 | 34379674 | 48 | 13:09:46 | 13.01.20 | 2 | 5.7 | 20 20 | 13.01.20 13:09:46 | 2020-01-13 13:09:46+01:00 |
| 34379673 | 34379673 | 48 | 13:09:44 | 13.01.20 | 2 | 4.8 | 20 20 | 13.01.20 13:09:44 | 2020-01-13 13:09:44+01:00 |
| 34396581 | 34396581 | 47 | 13:09:40 | 13.01.20 | 1 | 5.4 | 20 20 | 13.01.20 13:09:40 | 2020-01-13 13:09:40+01:00 |
| 34396580 | 34396580 | 57 | 13:09:19 | 13.01.20 | 1 | 3.4 | 20 20 | 13.01.20 13:09:19 | 2020-01-13 13:09:19+01:00 |
| 34379672 | 34379672 | 47 | 13:09:05 | 13.01.20 | 2 | 4.8 | 20 20 | 13.01.20 13:09:05 | 2020-01-13 13:09:05+01:00 |
| 34396579 | 34396579 | 46 | 13:08:54 | 13.01.20 | 1 | 4.9 | 20 20 | 13.01.20 13:08:54 | 2020-01-13 13:08:54+01:00 |
| 34396578 | 34396578 | 52 | 13:08:45 | 13.01.20 | 1 | 5.4 | 20 20 | 13.01.20 13:08:45 | 2020-01-13 13:08:45+01:00 |
| 34396577 | 34396577 | 53 | 13:08:43 | 13.01.20 | 1 | 5.3 | 20 20 | 13.01.20 13:08:43 | 2020-01-13 13:08:43+01:00 |
| 34396576 | 34396576 | 49 | 13:08:31 | 13.01.20 | 1 | 5.2 | 20 20 | 13.01.20 13:08:31 | 2020-01-13 13:08:31+01:00 |
| 34396575 | 34396575 | 52 | 13:08:24 | 13.01.20 | 1 | 5.4 | 20 20 | 13.01.20 13:08:24 | 2020-01-13 13:08:24+01:00 |
| 34379671 | 34379671 | 51 | 13:08:19 | 13.01.20 | 2 | 7.5 | 20 20 | 13.01.20 13:08:19 | 2020-01-13 13:08:19+01:00 |
| 34379670 | 34379670 | 60 | 13:08:10 | 13.01.20 | 2 | 4.5 | 20 20 | 13.01.20 13:08:10 | 2020-01-13 13:08:10+01:00 |
| 34379669 | 34379669 | 49 | 13:08:04 | 13.01.20 | 2 | 4.2 | 20 20 | 13.01.20 13:08:04 | 2020-01-13 13:08:04+01:00 |
| 34379668 | 34379668 | 48 | 13:08:01 | 13.01.20 | 2 | 5.2 | 20 20 | 13.01.20 13:08:01 | 2020-01-13 13:08:01+01:00 |
| 34379667 | 34379667 | 47 | 13:07:39 | 13.01.20 | 2 | 1.0 | 20 20 | 13.01.20 13:07:39 | 2020-01-13 13:07:39+01:00 |
| 34379666 | 34379666 | 48 | 13:07:30 | 13.01.20 | 2 | 4.6 | 20 20 | 13.01.20 13:07:30 | 2020-01-13 13:07:30+01:00 |
| 34396574 | 34396574 | 51 | 13:06:58 | 13.01.20 | 1 | 4.5 | 20 20 | 13.01.20 13:06:58 | 2020-01-13 13:06:58+01:00 |
| 34379665 | 34379665 | 47 | 13:06:25 | 13.01.20 | 2 | 6.2 | 20 20 | 13.01.20 13:06:25 | 2020-01-13 13:06:25+01:00 |
| 34379664 | 34379664 | 53 | 13:05:26 | 13.01.20 | 2 | 5.3 | 20 20 | 13.01.20 13:05:26 | 2020-01-13 13:05:26+01:00 |
| 34379663 | 34379663 | 40 | 13:04:53 | 13.01.20 | 2 | 5.3 | 20 20 | 13.01.20 13:04:53 | 2020-01-13 13:04:53+01:00 |
| 34379662 | 34379662 | 43 | 13:04:37 | 13.01.20 | 2 | 6.1 | 20 20 | 13.01.20 13:04:37 | 2020-01-13 13:04:37+01:00 |
| 34396573 | 34396573 | 43 | 13:04:36 | 13.01.20 | 1 | 4.3 | 20 20 | 13.01.20 13:04:36 | 2020-01-13 13:04:36+01:00 |
| 34379661 | 34379661 | 52 | 13:04:02 | 13.01.20 | 2 | 4.9 | 20 20 | 13.01.20 13:04:02 | 2020-01-13 13:04:02+01:00 |
| 34379660 | 34379660 | 49 | 13:03:37 | 13.01.20 | 2 | 3.9 | 20 20 | 13.01.20 13:03:37 | 2020-01-13 13:03:37+01:00 |
| 34396572 | 34396572 | 48 | 13:03:26 | 13.01.20 | 1 | 4.0 | 20 20 | 13.01.20 13:03:26 | 2020-01-13 13:03:26+01:00 |
| 34396571 | 34396571 | 52 | 13:03:25 | 13.01.20 | 1 | 7.9 | 20 20 | 13.01.20 13:03:25 | 2020-01-13 13:03:25+01:00 |
| 34379659 | 34379659 | 52 | 13:03:00 | 13.01.20 | 2 | 5.2 | 20 20 | 13.01.20 13:03:00 | 2020-01-13 13:03:00+01:00 |
| 34396570 | 34396570 | 49 | 13:02:38 | 13.01.20 | 1 | 3.6 | 20 20 | 13.01.20 13:02:38 | 2020-01-13 13:02:38+01:00 |
| 34396569 | 34396569 | 51 | 13:02:37 | 13.01.20 | 1 | 4.7 | 20 20 | 13.01.20 13:02:37 | 2020-01-13 13:02:37+01:00 |
| 34379658 | 34379658 | 46 | 13:02:29 | 13.01.20 | 2 | 1.4 | 20 20 | 13.01.20 13:02:29 | 2020-01-13 13:02:29+01:00 |
| 34379657 | 34379657 | 61 | 13:02:21 | 13.01.20 | 2 | 5.0 | 20 20 | 13.01.20 13:02:21 | 2020-01-13 13:02:21+01:00 |
| 34396568 | 34396568 | 55 | 13:02:07 | 13.01.20 | 1 | 4.9 | 20 20 | 13.01.20 13:02:07 | 2020-01-13 13:02:07+01:00 |
| 34379656 | 34379656 | 53 | 13:01:57 | 13.01.20 | 2 | 4.7 | 20 20 | 13.01.20 13:01:57 | 2020-01-13 13:01:57+01:00 |
| 34379655 | 34379655 | 48 | 13:00:55 | 13.01.20 | 2 | 4.7 | 20 20 | 13.01.20 13:00:55 | 2020-01-13 13:00:55+01:00 |
| 34396567 | 34396567 | 50 | 13:00:33 | 13.01.20 | 1 | 4.3 | 20 20 | 13.01.20 13:00:33 | 2020-01-13 13:00:33+01:00 |
| 34379654 | 34379654 | 46 | 13:00:13 | 13.01.20 | 2 | 4.7 | 20 20 | 13.01.20 13:00:13 | 2020-01-13 13:00:13+01:00 |
| 34379653 | 34379653 | 48 | 13:00:11 | 13.01.20 | 2 | 4.3 | 20 20 | 13.01.20 13:00:11 | 2020-01-13 13:00:11+01:00 |
| 34396566 | 34396566 | 46 | 13:00:09 | 13.01.20 | 1 | 5.3 | 20 20 | 13.01.20 13:00:09 | 2020-01-13 13:00:09+01:00 |
| 34379652 | 34379652 | 55 | 13:00:00 | 13.01.20 | 2 | 3.9 | 20 20 | 13.01.20 13:00:00 | 2020-01-13 13:00:00+01:00 |
| 34396565 | 34396565 | 51 | 12:59:45 | 13.01.20 | 1 | 4.5 | 20 20 | 13.01.20 12:59:45 | 2020-01-13 12:59:45+01:00 |
| 34379651 | 34379651 | 45 | 12:59:17 | 13.01.20 | 2 | 6.4 | 20 20 | 13.01.20 12:59:17 | 2020-01-13 12:59:17+01:00 |
| 34396564 | 34396564 | 54 | 12:59:04 | 13.01.20 | 1 | 4.3 | 20 20 | 13.01.20 12:59:04 | 2020-01-13 12:59:04+01:00 |
| 34379650 | 34379650 | 44 | 12:59:01 | 13.01.20 | 2 | 3.8 | 20 20 | 13.01.20 12:59:01 | 2020-01-13 12:59:01+01:00 |
| 34396563 | 34396563 | 55 | 12:58:46 | 13.01.20 | 1 | 3.4 | 20 20 | 13.01.20 12:58:46 | 2020-01-13 12:58:46+01:00 |
| 34379649 | 34379649 | 51 | 12:58:40 | 13.01.20 | 2 | 4.5 | 20 20 | 13.01.20 12:58:40 | 2020-01-13 12:58:40+01:00 |
| 34379648 | 34379648 | 55 | 12:58:39 | 13.01.20 | 2 | 3.9 | 20 20 | 13.01.20 12:58:39 | 2020-01-13 12:58:39+01:00 |
| 34396562 | 34396562 | 48 | 12:58:35 | 13.01.20 | 1 | 4.5 | 20 20 | 13.01.20 12:58:35 | 2020-01-13 12:58:35+01:00 |
| 34396561 | 34396561 | 49 | 12:58:32 | 13.01.20 | 1 | 3.9 | 20 20 | 13.01.20 12:58:32 | 2020-01-13 12:58:32+01:00 |
| 34379647 | 34379647 | 55 | 12:58:00 | 13.01.20 | 2 | 5.3 | 20 20 | 13.01.20 12:58:00 | 2020-01-13 12:58:00+01:00 |
| 34396560 | 34396560 | 58 | 12:57:43 | 13.01.20 | 1 | 7.7 | 20 20 | 13.01.20 12:57:43 | 2020-01-13 12:57:43+01:00 |
| 34396559 | 34396559 | 55 | 12:57:32 | 13.01.20 | 1 | 4.6 | 20 20 | 13.01.20 12:57:32 | 2020-01-13 12:57:32+01:00 |
| 34396558 | 34396558 | 51 | 12:57:30 | 13.01.20 | 1 | 5.3 | 20 20 | 13.01.20 12:57:30 | 2020-01-13 12:57:30+01:00 |
| 34379646 | 34379646 | 50 | 12:56:59 | 13.01.20 | 2 | 4.4 | 20 20 | 13.01.20 12:56:59 | 2020-01-13 12:56:59+01:00 |
| 34396557 | 34396557 | 51 | 12:56:55 | 13.01.20 | 1 | 7.0 | 20 20 | 13.01.20 12:56:55 | 2020-01-13 12:56:55+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");