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 = 17 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 34478750 | 34478750 | 54 | 23:06:58 | 11.01.20 | 1 | 4.9 | 17 17 | 11.01.20 23:06:58 | 2020-01-11 23:06:58+01:00 |
| 34464588 | 34464588 | 49 | 23:06:17 | 11.01.20 | 2 | 3.9 | 17 17 | 11.01.20 23:06:17 | 2020-01-11 23:06:17+01:00 |
| 34464587 | 34464587 | 47 | 23:06:14 | 11.01.20 | 2 | 4.6 | 17 17 | 11.01.20 23:06:14 | 2020-01-11 23:06:14+01:00 |
| 34478749 | 34478749 | 54 | 23:05:09 | 11.01.20 | 1 | 4.3 | 17 17 | 11.01.20 23:05:09 | 2020-01-11 23:05:09+01:00 |
| 34478748 | 34478748 | 60 | 23:05:02 | 11.01.20 | 1 | 3.5 | 17 17 | 11.01.20 23:05:02 | 2020-01-11 23:05:02+01:00 |
| 34464586 | 34464586 | 47 | 23:04:11 | 11.01.20 | 2 | 4.5 | 17 17 | 11.01.20 23:04:11 | 2020-01-11 23:04:11+01:00 |
| 34478747 | 34478747 | 37 | 23:03:14 | 11.01.20 | 1 | 3.8 | 17 17 | 11.01.20 23:03:14 | 2020-01-11 23:03:14+01:00 |
| 34464585 | 34464585 | 53 | 23:02:57 | 11.01.20 | 2 | 4.8 | 17 17 | 11.01.20 23:02:57 | 2020-01-11 23:02:57+01:00 |
| 34464584 | 34464584 | 48 | 23:00:23 | 11.01.20 | 2 | 4.5 | 17 17 | 11.01.20 23:00:23 | 2020-01-11 23:00:23+01:00 |
| 34464583 | 34464583 | 42 | 22:59:21 | 11.01.20 | 2 | 3.4 | 17 17 | 11.01.20 22:59:21 | 2020-01-11 22:59:21+01:00 |
| 34464582 | 34464582 | 48 | 22:58:21 | 11.01.20 | 2 | 5.4 | 17 17 | 11.01.20 22:58:21 | 2020-01-11 22:58:21+01:00 |
| 34478746 | 34478746 | 46 | 22:57:17 | 11.01.20 | 1 | 3.8 | 17 17 | 11.01.20 22:57:17 | 2020-01-11 22:57:17+01:00 |
| 34464581 | 34464581 | 37 | 22:57:13 | 11.01.20 | 2 | 14.2 | 17 17 | 11.01.20 22:57:13 | 2020-01-11 22:57:13+01:00 |
| 34478745 | 34478745 | 39 | 22:57:05 | 11.01.20 | 1 | 3.4 | 17 17 | 11.01.20 22:57:05 | 2020-01-11 22:57:05+01:00 |
| 34478744 | 34478744 | 41 | 22:57:04 | 11.01.20 | 1 | 3.8 | 17 17 | 11.01.20 22:57:04 | 2020-01-11 22:57:04+01:00 |
| 34464580 | 34464580 | 37 | 22:56:36 | 11.01.20 | 2 | 3.8 | 17 17 | 11.01.20 22:56:36 | 2020-01-11 22:56:36+01:00 |
| 34478743 | 34478743 | 50 | 22:55:58 | 11.01.20 | 1 | 4.5 | 17 17 | 11.01.20 22:55:58 | 2020-01-11 22:55:58+01:00 |
| 34464579 | 34464579 | 41 | 22:54:28 | 11.01.20 | 2 | 3.8 | 17 17 | 11.01.20 22:54:28 | 2020-01-11 22:54:28+01:00 |
| 34478742 | 34478742 | 45 | 22:53:59 | 11.01.20 | 1 | 4.6 | 17 17 | 11.01.20 22:53:59 | 2020-01-11 22:53:59+01:00 |
| 34478741 | 34478741 | 34 | 22:53:50 | 11.01.20 | 1 | 11.9 | 17 17 | 11.01.20 22:53:50 | 2020-01-11 22:53:50+01:00 |
| 34478740 | 34478740 | 54 | 22:52:59 | 11.01.20 | 1 | 4.3 | 17 17 | 11.01.20 22:52:59 | 2020-01-11 22:52:59+01:00 |
| 34478739 | 34478739 | 53 | 22:52:30 | 11.01.20 | 1 | 4.4 | 17 17 | 11.01.20 22:52:30 | 2020-01-11 22:52:30+01:00 |
| 34478738 | 34478738 | 45 | 22:51:47 | 11.01.20 | 1 | 7.5 | 17 17 | 11.01.20 22:51:47 | 2020-01-11 22:51:47+01:00 |
| 34478737 | 34478737 | 48 | 22:50:06 | 11.01.20 | 1 | 3.8 | 17 17 | 11.01.20 22:50:06 | 2020-01-11 22:50:06+01:00 |
| 34478736 | 34478736 | 50 | 22:49:03 | 11.01.20 | 1 | 3.5 | 17 17 | 11.01.20 22:49:03 | 2020-01-11 22:49:03+01:00 |
| 34478735 | 34478735 | 41 | 22:48:30 | 11.01.20 | 1 | 4.5 | 17 17 | 11.01.20 22:48:30 | 2020-01-11 22:48:30+01:00 |
| 34478734 | 34478734 | 53 | 22:47:53 | 11.01.20 | 1 | 4.4 | 17 17 | 11.01.20 22:47:53 | 2020-01-11 22:47:53+01:00 |
| 34464578 | 34464578 | 48 | 22:46:16 | 11.01.20 | 2 | 5.1 | 17 17 | 11.01.20 22:46:16 | 2020-01-11 22:46:16+01:00 |
| 34478733 | 34478733 | 43 | 22:46:13 | 11.01.20 | 1 | 4.5 | 17 17 | 11.01.20 22:46:13 | 2020-01-11 22:46:13+01:00 |
| 34464577 | 34464577 | 40 | 22:46:03 | 11.01.20 | 2 | 4.0 | 17 17 | 11.01.20 22:46:03 | 2020-01-11 22:46:03+01:00 |
| 34478732 | 34478732 | 55 | 22:45:58 | 11.01.20 | 1 | 4.5 | 17 17 | 11.01.20 22:45:58 | 2020-01-11 22:45:58+01:00 |
| 34478731 | 34478731 | 55 | 22:45:51 | 11.01.20 | 1 | 4.9 | 17 17 | 11.01.20 22:45:51 | 2020-01-11 22:45:51+01:00 |
| 34464576 | 34464576 | 53 | 22:44:40 | 11.01.20 | 2 | 1.2 | 17 17 | 11.01.20 22:44:40 | 2020-01-11 22:44:40+01:00 |
| 34478730 | 34478730 | 41 | 22:43:39 | 11.01.20 | 1 | 3.3 | 17 17 | 11.01.20 22:43:39 | 2020-01-11 22:43:39+01:00 |
| 34464575 | 34464575 | 44 | 22:42:39 | 11.01.20 | 2 | 4.3 | 17 17 | 11.01.20 22:42:39 | 2020-01-11 22:42:39+01:00 |
| 34464574 | 34464574 | 35 | 22:42:00 | 11.01.20 | 2 | 12.5 | 17 17 | 11.01.20 22:42:00 | 2020-01-11 22:42:00+01:00 |
| 34478729 | 34478729 | 63 | 22:41:35 | 11.01.20 | 1 | 4.4 | 17 17 | 11.01.20 22:41:35 | 2020-01-11 22:41:35+01:00 |
| 34478728 | 34478728 | 58 | 22:40:46 | 11.01.20 | 1 | 4.5 | 17 17 | 11.01.20 22:40:46 | 2020-01-11 22:40:46+01:00 |
| 34464573 | 34464573 | 37 | 22:40:19 | 11.01.20 | 2 | 3.8 | 17 17 | 11.01.20 22:40:19 | 2020-01-11 22:40:19+01:00 |
| 34478727 | 34478727 | 48 | 22:40:18 | 11.01.20 | 1 | 4.5 | 17 17 | 11.01.20 22:40:18 | 2020-01-11 22:40:18+01:00 |
| 34464572 | 34464572 | 41 | 22:40:14 | 11.01.20 | 2 | 6.8 | 17 17 | 11.01.20 22:40:14 | 2020-01-11 22:40:14+01:00 |
| 34478726 | 34478726 | 40 | 22:40:04 | 11.01.20 | 1 | 12.1 | 17 17 | 11.01.20 22:40:04 | 2020-01-11 22:40:04+01:00 |
| 34478725 | 34478725 | 56 | 22:39:01 | 11.01.20 | 1 | 5.2 | 17 17 | 11.01.20 22:39:01 | 2020-01-11 22:39:01+01:00 |
| 34478724 | 34478724 | 44 | 22:38:49 | 11.01.20 | 1 | 3.7 | 17 17 | 11.01.20 22:38:49 | 2020-01-11 22:38:49+01:00 |
| 34464571 | 34464571 | 44 | 22:38:39 | 11.01.20 | 2 | 3.8 | 17 17 | 11.01.20 22:38:39 | 2020-01-11 22:38:39+01:00 |
| 34478723 | 34478723 | 40 | 22:37:24 | 11.01.20 | 1 | 4.2 | 17 17 | 11.01.20 22:37:24 | 2020-01-11 22:37:24+01:00 |
| 34478722 | 34478722 | 51 | 22:37:10 | 11.01.20 | 1 | 4.1 | 17 17 | 11.01.20 22:37:10 | 2020-01-11 22:37:10+01:00 |
| 34478721 | 34478721 | 47 | 22:37:06 | 11.01.20 | 1 | 5.3 | 17 17 | 11.01.20 22:37:06 | 2020-01-11 22:37:06+01:00 |
| 34464570 | 34464570 | 45 | 22:36:54 | 11.01.20 | 2 | 4.1 | 17 17 | 11.01.20 22:36:54 | 2020-01-11 22:36:54+01:00 |
| 34464569 | 34464569 | 40 | 22:36:07 | 11.01.20 | 2 | 5.3 | 17 17 | 11.01.20 22:36:07 | 2020-01-11 22:36:07+01:00 |
| 34478720 | 34478720 | 49 | 22:35:29 | 11.01.20 | 1 | 5.1 | 17 17 | 11.01.20 22:35:29 | 2020-01-11 22:35:29+01:00 |
| 34464568 | 34464568 | 57 | 22:34:42 | 11.01.20 | 2 | 4.0 | 17 17 | 11.01.20 22:34:42 | 2020-01-11 22:34:42+01:00 |
| 34464567 | 34464567 | 47 | 22:34:37 | 11.01.20 | 2 | 4.7 | 17 17 | 11.01.20 22:34:37 | 2020-01-11 22:34:37+01:00 |
| 34464566 | 34464566 | 51 | 22:34:15 | 11.01.20 | 2 | 3.9 | 17 17 | 11.01.20 22:34:15 | 2020-01-11 22:34:15+01:00 |
| 34464565 | 34464565 | 45 | 22:34:09 | 11.01.20 | 2 | 5.1 | 17 17 | 11.01.20 22:34:09 | 2020-01-11 22:34:09+01:00 |
| 34478719 | 34478719 | 51 | 22:33:31 | 11.01.20 | 1 | 3.3 | 17 17 | 11.01.20 22:33:31 | 2020-01-11 22:33:31+01:00 |
| 34464564 | 34464564 | 45 | 22:33:20 | 11.01.20 | 2 | 4.0 | 17 17 | 11.01.20 22:33:20 | 2020-01-11 22:33:20+01:00 |
| 34464563 | 34464563 | 43 | 22:33:15 | 11.01.20 | 2 | 4.8 | 17 17 | 11.01.20 22:33:15 | 2020-01-11 22:33:15+01:00 |
| 34464562 | 34464562 | 52 | 22:32:25 | 11.01.20 | 2 | 5.1 | 17 17 | 11.01.20 22:32:25 | 2020-01-11 22:32:25+01:00 |
| 34478718 | 34478718 | 50 | 22:31:52 | 11.01.20 | 1 | 4.4 | 17 17 | 11.01.20 22:31:52 | 2020-01-11 22:31:52+01:00 |
| 34478717 | 34478717 | 52 | 22:31:43 | 11.01.20 | 1 | 3.8 | 17 17 | 11.01.20 22:31:43 | 2020-01-11 22:31:43+01:00 |
| 34478716 | 34478716 | 47 | 22:30:35 | 11.01.20 | 1 | 4.8 | 17 17 | 11.01.20 22:30:35 | 2020-01-11 22:30:35+01:00 |
| 34464561 | 34464561 | 45 | 22:29:04 | 11.01.20 | 2 | 5.2 | 17 17 | 11.01.20 22:29:04 | 2020-01-11 22:29:04+01:00 |
| 34478715 | 34478715 | 57 | 22:28:02 | 11.01.20 | 1 | 4.8 | 17 17 | 11.01.20 22:28:02 | 2020-01-11 22:28:02+01:00 |
| 34478714 | 34478714 | 22 | 22:27:36 | 11.01.20 | 1 | 3.3 | 17 17 | 11.01.20 22:27:36 | 2020-01-11 22:27:36+01:00 |
| 34464560 | 34464560 | 46 | 22:27:10 | 11.01.20 | 2 | 4.7 | 17 17 | 11.01.20 22:27:10 | 2020-01-11 22:27:10+01:00 |
| 34464559 | 34464559 | 43 | 22:26:43 | 11.01.20 | 2 | 14.2 | 17 17 | 11.01.20 22:26:43 | 2020-01-11 22:26:43+01:00 |
| 34464558 | 34464558 | 41 | 22:26:22 | 11.01.20 | 2 | 5.2 | 17 17 | 11.01.20 22:26:22 | 2020-01-11 22:26:22+01:00 |
| 34464557 | 34464557 | 40 | 22:25:00 | 11.01.20 | 2 | 4.9 | 17 17 | 11.01.20 22:25:00 | 2020-01-11 22:25:00+01:00 |
| 34464556 | 34464556 | 46 | 22:24:49 | 11.01.20 | 2 | 4.0 | 17 17 | 11.01.20 22:24:49 | 2020-01-11 22:24:49+01:00 |
| 34464555 | 34464555 | 40 | 22:24:46 | 11.01.20 | 2 | 5.0 | 17 17 | 11.01.20 22:24:46 | 2020-01-11 22:24:46+01:00 |
| 34464554 | 34464554 | 37 | 22:24:10 | 11.01.20 | 2 | 9.2 | 17 17 | 11.01.20 22:24:10 | 2020-01-11 22:24:10+01:00 |
| 34478713 | 34478713 | 40 | 22:24:06 | 11.01.20 | 1 | 12.1 | 17 17 | 11.01.20 22:24:06 | 2020-01-11 22:24:06+01:00 |
| 34478712 | 34478712 | 46 | 22:23:19 | 11.01.20 | 1 | 4.0 | 17 17 | 11.01.20 22:23:19 | 2020-01-11 22:23:19+01:00 |
| 34478711 | 34478711 | 47 | 22:23:17 | 11.01.20 | 1 | 3.5 | 17 17 | 11.01.20 22:23:17 | 2020-01-11 22:23:17+01:00 |
| 34478710 | 34478710 | 56 | 22:21:33 | 11.01.20 | 1 | 3.8 | 17 17 | 11.01.20 22:21:33 | 2020-01-11 22:21:33+01:00 |
| 34464553 | 34464553 | 50 | 22:21:17 | 11.01.20 | 2 | 4.3 | 17 17 | 11.01.20 22:21:17 | 2020-01-11 22:21:17+01:00 |
| 34478709 | 34478709 | 44 | 22:21:12 | 11.01.20 | 1 | 3.9 | 17 17 | 11.01.20 22:21:12 | 2020-01-11 22:21:12+01:00 |
| 34464552 | 34464552 | 37 | 22:21:11 | 11.01.20 | 2 | 5.4 | 17 17 | 11.01.20 22:21:11 | 2020-01-11 22:21:11+01:00 |
| 34478708 | 34478708 | 45 | 22:21:09 | 11.01.20 | 1 | 4.3 | 17 17 | 11.01.20 22:21:09 | 2020-01-11 22:21:09+01:00 |
| 34478707 | 34478707 | 49 | 22:20:33 | 11.01.20 | 1 | 4.2 | 17 17 | 11.01.20 22:20:33 | 2020-01-11 22:20:33+01:00 |
| 34464551 | 34464551 | 41 | 22:20:10 | 11.01.20 | 2 | 3.2 | 17 17 | 11.01.20 22:20:10 | 2020-01-11 22:20:10+01:00 |
| 34464550 | 34464550 | 38 | 22:20:08 | 11.01.20 | 2 | 4.3 | 17 17 | 11.01.20 22:20:08 | 2020-01-11 22:20:08+01:00 |
| 34478706 | 34478706 | 54 | 22:19:24 | 11.01.20 | 1 | 5.2 | 17 17 | 11.01.20 22:19:24 | 2020-01-11 22:19:24+01:00 |
| 34478705 | 34478705 | 47 | 22:19:14 | 11.01.20 | 1 | 4.5 | 17 17 | 11.01.20 22:19:14 | 2020-01-11 22:19:14+01:00 |
| 34464549 | 34464549 | 47 | 22:18:55 | 11.01.20 | 2 | 3.9 | 17 17 | 11.01.20 22:18:55 | 2020-01-11 22:18:55+01:00 |
| 34464548 | 34464548 | 52 | 22:18:33 | 11.01.20 | 2 | 4.3 | 17 17 | 11.01.20 22:18:33 | 2020-01-11 22:18:33+01:00 |
| 34478704 | 34478704 | 56 | 22:18:04 | 11.01.20 | 1 | 4.4 | 17 17 | 11.01.20 22:18:04 | 2020-01-11 22:18:04+01:00 |
| 34478703 | 34478703 | 45 | 22:15:24 | 11.01.20 | 1 | 4.9 | 17 17 | 11.01.20 22:15:24 | 2020-01-11 22:15:24+01:00 |
| 34464547 | 34464547 | 43 | 22:15:20 | 11.01.20 | 2 | 3.2 | 17 17 | 11.01.20 22:15:20 | 2020-01-11 22:15:20+01:00 |
| 34478702 | 34478702 | 47 | 22:14:26 | 11.01.20 | 1 | 4.2 | 17 17 | 11.01.20 22:14:26 | 2020-01-11 22:14:26+01:00 |
| 34464546 | 34464546 | 53 | 22:14:20 | 11.01.20 | 2 | 4.1 | 17 17 | 11.01.20 22:14:20 | 2020-01-11 22:14:20+01:00 |
| 34478701 | 34478701 | 55 | 22:12:12 | 11.01.20 | 1 | 3.7 | 17 17 | 11.01.20 22:12:12 | 2020-01-11 22:12:12+01:00 |
| 34464545 | 34464545 | 41 | 22:11:42 | 11.01.20 | 2 | 13.8 | 17 17 | 11.01.20 22:11:42 | 2020-01-11 22:11:42+01:00 |
| 34464544 | 34464544 | 50 | 22:10:48 | 11.01.20 | 2 | 3.9 | 17 17 | 11.01.20 22:10:48 | 2020-01-11 22:10:48+01:00 |
| 34478700 | 34478700 | 27 | 22:10:32 | 11.01.20 | 1 | 2.5 | 17 17 | 11.01.20 22:10:32 | 2020-01-11 22:10:32+01:00 |
| 34478699 | 34478699 | 54 | 22:10:05 | 11.01.20 | 1 | 4.4 | 17 17 | 11.01.20 22:10:05 | 2020-01-11 22:10:05+01:00 |
| 34478698 | 34478698 | 44 | 22:09:41 | 11.01.20 | 1 | 13.2 | 17 17 | 11.01.20 22:09:41 | 2020-01-11 22:09:41+01:00 |
| 34464543 | 34464543 | 49 | 22:09:02 | 11.01.20 | 2 | 3.2 | 17 17 | 11.01.20 22:09:02 | 2020-01-11 22:09:02+01:00 |
| 34464542 | 34464542 | 62 | 22:08:26 | 11.01.20 | 2 | 5.4 | 17 17 | 11.01.20 22:08:26 | 2020-01-11 22:08:26+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");