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
6,911 rows where Messung-ID = 81 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 36856960 | 36856960 | 19 | 09:01:15 | 24.01.19 | 1 | 3.1 | 81 81 | 24.01.19 09:01:15 | 2019-01-24 09:01:15+01:00 |
| 36856959 | 36856959 | 24 | 09:01:05 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 09:01:05 | 2019-01-24 09:01:05+01:00 |
| 36856958 | 36856958 | 23 | 09:01:04 | 24.01.19 | 1 | 3.0 | 81 81 | 24.01.19 09:01:04 | 2019-01-24 09:01:04+01:00 |
| 36856957 | 36856957 | 25 | 09:01:00 | 24.01.19 | 1 | 3.1 | 81 81 | 24.01.19 09:01:00 | 2019-01-24 09:01:00+01:00 |
| 36856956 | 36856956 | 27 | 08:59:31 | 24.01.19 | 1 | 3.1 | 81 81 | 24.01.19 08:59:31 | 2019-01-24 08:59:31+01:00 |
| 36856955 | 36856955 | 17 | 08:58:11 | 24.01.19 | 1 | 3.1 | 81 81 | 24.01.19 08:58:11 | 2019-01-24 08:58:11+01:00 |
| 36856954 | 36856954 | 23 | 08:58:02 | 24.01.19 | 1 | 3.2 | 81 81 | 24.01.19 08:58:02 | 2019-01-24 08:58:02+01:00 |
| 36856953 | 36856953 | 24 | 08:56:29 | 24.01.19 | 1 | 2.8 | 81 81 | 24.01.19 08:56:29 | 2019-01-24 08:56:29+01:00 |
| 36856952 | 36856952 | 25 | 08:56:24 | 24.01.19 | 1 | 2.8 | 81 81 | 24.01.19 08:56:24 | 2019-01-24 08:56:24+01:00 |
| 36856951 | 36856951 | 18 | 08:55:12 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:55:12 | 2019-01-24 08:55:12+01:00 |
| 36856950 | 36856950 | 26 | 08:55:09 | 24.01.19 | 1 | 3.1 | 81 81 | 24.01.19 08:55:09 | 2019-01-24 08:55:09+01:00 |
| 36856949 | 36856949 | 24 | 08:55:05 | 24.01.19 | 1 | 3.2 | 81 81 | 24.01.19 08:55:05 | 2019-01-24 08:55:05+01:00 |
| 36856948 | 36856948 | 17 | 08:53:40 | 24.01.19 | 1 | 2.6 | 81 81 | 24.01.19 08:53:40 | 2019-01-24 08:53:40+01:00 |
| 36856947 | 36856947 | 20 | 08:53:36 | 24.01.19 | 1 | 3.1 | 81 81 | 24.01.19 08:53:36 | 2019-01-24 08:53:36+01:00 |
| 36856946 | 36856946 | 20 | 08:52:08 | 24.01.19 | 1 | 2.6 | 81 81 | 24.01.19 08:52:08 | 2019-01-24 08:52:08+01:00 |
| 36856945 | 36856945 | 21 | 08:52:04 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:52:04 | 2019-01-24 08:52:04+01:00 |
| 36856944 | 36856944 | 21 | 08:52:03 | 24.01.19 | 1 | 3.1 | 81 81 | 24.01.19 08:52:03 | 2019-01-24 08:52:03+01:00 |
| 36856943 | 36856943 | 19 | 08:50:37 | 24.01.19 | 1 | 3.8 | 81 81 | 24.01.19 08:50:37 | 2019-01-24 08:50:37+01:00 |
| 36856942 | 36856942 | 15 | 08:50:01 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:50:01 | 2019-01-24 08:50:01+01:00 |
| 36856941 | 36856941 | 18 | 08:49:05 | 24.01.19 | 1 | 3.0 | 81 81 | 24.01.19 08:49:05 | 2019-01-24 08:49:05+01:00 |
| 36856940 | 36856940 | 25 | 08:49:04 | 24.01.19 | 1 | 2.8 | 81 81 | 24.01.19 08:49:04 | 2019-01-24 08:49:04+01:00 |
| 36856939 | 36856939 | 34 | 08:48:58 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:48:58 | 2019-01-24 08:48:58+01:00 |
| 36856938 | 36856938 | 20 | 08:47:40 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:47:40 | 2019-01-24 08:47:40+01:00 |
| 36856937 | 36856937 | 21 | 08:46:07 | 24.01.19 | 1 | 3.6 | 81 81 | 24.01.19 08:46:07 | 2019-01-24 08:46:07+01:00 |
| 36856936 | 36856936 | 24 | 08:46:03 | 24.01.19 | 1 | 3.7 | 81 81 | 24.01.19 08:46:03 | 2019-01-24 08:46:03+01:00 |
| 36856935 | 36856935 | 26 | 08:45:59 | 24.01.19 | 1 | 3.7 | 81 81 | 24.01.19 08:45:59 | 2019-01-24 08:45:59+01:00 |
| 36856934 | 36856934 | 34 | 08:44:18 | 24.01.19 | 1 | 3.1 | 81 81 | 24.01.19 08:44:18 | 2019-01-24 08:44:18+01:00 |
| 36856933 | 36856933 | 24 | 08:44:02 | 24.01.19 | 1 | 3.9 | 81 81 | 24.01.19 08:44:02 | 2019-01-24 08:44:02+01:00 |
| 36856932 | 36856932 | 18 | 08:43:11 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:43:11 | 2019-01-24 08:43:11+01:00 |
| 36856931 | 36856931 | 23 | 08:43:09 | 24.01.19 | 1 | 3.5 | 81 81 | 24.01.19 08:43:09 | 2019-01-24 08:43:09+01:00 |
| 36856930 | 36856930 | 22 | 08:43:07 | 24.01.19 | 1 | 3.1 | 81 81 | 24.01.19 08:43:07 | 2019-01-24 08:43:07+01:00 |
| 36856929 | 36856929 | 27 | 08:43:03 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:43:03 | 2019-01-24 08:43:03+01:00 |
| 36856928 | 36856928 | 22 | 08:42:16 | 24.01.19 | 1 | 3.8 | 81 81 | 24.01.19 08:42:16 | 2019-01-24 08:42:16+01:00 |
| 36856927 | 36856927 | 22 | 08:41:33 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:41:33 | 2019-01-24 08:41:33+01:00 |
| 36856926 | 36856926 | 23 | 08:38:34 | 24.01.19 | 1 | 2.8 | 81 81 | 24.01.19 08:38:34 | 2019-01-24 08:38:34+01:00 |
| 36856925 | 36856925 | 21 | 08:38:02 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:38:02 | 2019-01-24 08:38:02+01:00 |
| 36856924 | 36856924 | 16 | 08:37:33 | 24.01.19 | 1 | 3.0 | 81 81 | 24.01.19 08:37:33 | 2019-01-24 08:37:33+01:00 |
| 36856923 | 36856923 | 16 | 08:35:41 | 24.01.19 | 1 | 2.7 | 81 81 | 24.01.19 08:35:41 | 2019-01-24 08:35:41+01:00 |
| 36856922 | 36856922 | 26 | 08:35:30 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:35:30 | 2019-01-24 08:35:30+01:00 |
| 36856921 | 36856921 | 20 | 08:34:13 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:34:13 | 2019-01-24 08:34:13+01:00 |
| 36856920 | 36856920 | 19 | 08:34:11 | 24.01.19 | 1 | 2.6 | 81 81 | 24.01.19 08:34:11 | 2019-01-24 08:34:11+01:00 |
| 36856919 | 36856919 | 18 | 08:34:09 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:34:09 | 2019-01-24 08:34:09+01:00 |
| 36856918 | 36856918 | 13 | 08:32:43 | 24.01.19 | 1 | 2.6 | 81 81 | 24.01.19 08:32:43 | 2019-01-24 08:32:43+01:00 |
| 36856917 | 36856917 | 26 | 08:32:15 | 24.01.19 | 1 | 3.5 | 81 81 | 24.01.19 08:32:15 | 2019-01-24 08:32:15+01:00 |
| 36856916 | 36856916 | 12 | 08:31:32 | 24.01.19 | 1 | 5.1 | 81 81 | 24.01.19 08:31:32 | 2019-01-24 08:31:32+01:00 |
| 36856915 | 36856915 | 17 | 08:31:21 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:31:21 | 2019-01-24 08:31:21+01:00 |
| 36856914 | 36856914 | 21 | 08:31:16 | 24.01.19 | 1 | 3.2 | 81 81 | 24.01.19 08:31:16 | 2019-01-24 08:31:16+01:00 |
| 36856913 | 36856913 | 24 | 08:31:13 | 24.01.19 | 1 | 3.1 | 81 81 | 24.01.19 08:31:13 | 2019-01-24 08:31:13+01:00 |
| 36856912 | 36856912 | 17 | 08:31:02 | 24.01.19 | 1 | 3.0 | 81 81 | 24.01.19 08:31:02 | 2019-01-24 08:31:02+01:00 |
| 36856911 | 36856911 | 14 | 08:30:47 | 24.01.19 | 1 | 4.1 | 81 81 | 24.01.19 08:30:47 | 2019-01-24 08:30:47+01:00 |
| 36856910 | 36856910 | 17 | 08:29:42 | 24.01.19 | 1 | 2.7 | 81 81 | 24.01.19 08:29:42 | 2019-01-24 08:29:42+01:00 |
| 36856909 | 36856909 | 18 | 08:29:41 | 24.01.19 | 1 | 3.2 | 81 81 | 24.01.19 08:29:41 | 2019-01-24 08:29:41+01:00 |
| 36856908 | 36856908 | 20 | 08:28:04 | 24.01.19 | 1 | 2.7 | 81 81 | 24.01.19 08:28:04 | 2019-01-24 08:28:04+01:00 |
| 36856907 | 36856907 | 20 | 08:26:39 | 24.01.19 | 1 | 2.3 | 81 81 | 24.01.19 08:26:39 | 2019-01-24 08:26:39+01:00 |
| 36856906 | 36856906 | 22 | 08:25:16 | 24.01.19 | 1 | 6.3 | 81 81 | 24.01.19 08:25:16 | 2019-01-24 08:25:16+01:00 |
| 36856905 | 36856905 | 22 | 08:25:10 | 24.01.19 | 1 | 3.6 | 81 81 | 24.01.19 08:25:10 | 2019-01-24 08:25:10+01:00 |
| 36856904 | 36856904 | 20 | 08:25:03 | 24.01.19 | 1 | 2.4 | 81 81 | 24.01.19 08:25:03 | 2019-01-24 08:25:03+01:00 |
| 36856903 | 36856903 | 20 | 08:23:39 | 24.01.19 | 1 | 2.8 | 81 81 | 24.01.19 08:23:39 | 2019-01-24 08:23:39+01:00 |
| 36856902 | 36856902 | 20 | 08:23:38 | 24.01.19 | 1 | 2.9 | 81 81 | 24.01.19 08:23:38 | 2019-01-24 08:23:38+01:00 |
| 36856901 | 36856901 | 20 | 08:23:37 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:23:37 | 2019-01-24 08:23:37+01:00 |
| 36856900 | 36856900 | 22 | 08:23:36 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:23:36 | 2019-01-24 08:23:36+01:00 |
| 36856899 | 36856899 | 21 | 08:23:35 | 24.01.19 | 1 | 4.3 | 81 81 | 24.01.19 08:23:35 | 2019-01-24 08:23:35+01:00 |
| 36856898 | 36856898 | 21 | 08:22:06 | 24.01.19 | 1 | 3.6 | 81 81 | 24.01.19 08:22:06 | 2019-01-24 08:22:06+01:00 |
| 36856897 | 36856897 | 23 | 08:22:05 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:22:05 | 2019-01-24 08:22:05+01:00 |
| 36856896 | 36856896 | 25 | 08:22:01 | 24.01.19 | 1 | 3.8 | 81 81 | 24.01.19 08:22:01 | 2019-01-24 08:22:01+01:00 |
| 36856895 | 36856895 | 19 | 08:21:35 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:21:35 | 2019-01-24 08:21:35+01:00 |
| 36856894 | 36856894 | 18 | 08:20:43 | 24.01.19 | 1 | 4.0 | 81 81 | 24.01.19 08:20:43 | 2019-01-24 08:20:43+01:00 |
| 36856893 | 36856893 | 23 | 08:20:39 | 24.01.19 | 1 | 3.2 | 81 81 | 24.01.19 08:20:39 | 2019-01-24 08:20:39+01:00 |
| 36856892 | 36856892 | 27 | 08:20:37 | 24.01.19 | 1 | 3.7 | 81 81 | 24.01.19 08:20:37 | 2019-01-24 08:20:37+01:00 |
| 36856891 | 36856891 | 19 | 08:19:02 | 24.01.19 | 1 | 2.3 | 81 81 | 24.01.19 08:19:02 | 2019-01-24 08:19:02+01:00 |
| 36856890 | 36856890 | 24 | 08:18:50 | 24.01.19 | 1 | 3.5 | 81 81 | 24.01.19 08:18:50 | 2019-01-24 08:18:50+01:00 |
| 36856889 | 36856889 | 18 | 08:18:44 | 24.01.19 | 1 | 4.6 | 81 81 | 24.01.19 08:18:44 | 2019-01-24 08:18:44+01:00 |
| 36856888 | 36856888 | 18 | 08:17:47 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:17:47 | 2019-01-24 08:17:47+01:00 |
| 36856887 | 36856887 | 22 | 08:17:42 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:17:42 | 2019-01-24 08:17:42+01:00 |
| 36856886 | 36856886 | 21 | 08:17:33 | 24.01.19 | 1 | 2.9 | 81 81 | 24.01.19 08:17:33 | 2019-01-24 08:17:33+01:00 |
| 36856885 | 36856885 | 22 | 08:17:32 | 24.01.19 | 1 | 3.5 | 81 81 | 24.01.19 08:17:32 | 2019-01-24 08:17:32+01:00 |
| 36856884 | 36856884 | 21 | 08:17:31 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:17:31 | 2019-01-24 08:17:31+01:00 |
| 36856883 | 36856883 | 24 | 08:16:01 | 24.01.19 | 1 | 2.7 | 81 81 | 24.01.19 08:16:01 | 2019-01-24 08:16:01+01:00 |
| 36856882 | 36856882 | 24 | 08:16:00 | 24.01.19 | 1 | 4.7 | 81 81 | 24.01.19 08:16:00 | 2019-01-24 08:16:00+01:00 |
| 36856881 | 36856881 | 21 | 08:14:37 | 24.01.19 | 1 | 3.2 | 81 81 | 24.01.19 08:14:37 | 2019-01-24 08:14:37+01:00 |
| 36856880 | 36856880 | 15 | 08:13:58 | 24.01.19 | 1 | 3.0 | 81 81 | 24.01.19 08:13:58 | 2019-01-24 08:13:58+01:00 |
| 36856879 | 36856879 | 22 | 08:13:03 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:13:03 | 2019-01-24 08:13:03+01:00 |
| 36856878 | 36856878 | 23 | 08:13:00 | 24.01.19 | 1 | 2.5 | 81 81 | 24.01.19 08:13:00 | 2019-01-24 08:13:00+01:00 |
| 36856877 | 36856877 | 19 | 08:08:51 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:08:51 | 2019-01-24 08:08:51+01:00 |
| 36856876 | 36856876 | 18 | 08:08:46 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:08:46 | 2019-01-24 08:08:46+01:00 |
| 36856875 | 36856875 | 18 | 08:08:45 | 24.01.19 | 1 | 3.6 | 81 81 | 24.01.19 08:08:45 | 2019-01-24 08:08:45+01:00 |
| 36856873 | 36856873 | 18 | 08:08:40 | 24.01.19 | 1 | 3.5 | 81 81 | 24.01.19 08:08:40 | 2019-01-24 08:08:40+01:00 |
| 36856874 | 36856874 | 20 | 08:08:40 | 24.01.19 | 1 | 2.8 | 81 81 | 24.01.19 08:08:40 | 2019-01-24 08:08:40+01:00 |
| 36856872 | 36856872 | 23 | 08:07:08 | 24.01.19 | 1 | 3.5 | 81 81 | 24.01.19 08:07:08 | 2019-01-24 08:07:08+01:00 |
| 36856871 | 36856871 | 23 | 08:07:04 | 24.01.19 | 1 | 3.4 | 81 81 | 24.01.19 08:07:04 | 2019-01-24 08:07:04+01:00 |
| 36856870 | 36856870 | 22 | 08:07:02 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:07:02 | 2019-01-24 08:07:02+01:00 |
| 36856869 | 36856869 | 25 | 08:05:35 | 24.01.19 | 1 | 2.8 | 81 81 | 24.01.19 08:05:35 | 2019-01-24 08:05:35+01:00 |
| 36856868 | 36856868 | 17 | 08:04:08 | 24.01.19 | 1 | 3.2 | 81 81 | 24.01.19 08:04:08 | 2019-01-24 08:04:08+01:00 |
| 36856867 | 36856867 | 24 | 08:03:58 | 24.01.19 | 1 | 3.5 | 81 81 | 24.01.19 08:03:58 | 2019-01-24 08:03:58+01:00 |
| 36856866 | 36856866 | 21 | 08:03:41 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:03:41 | 2019-01-24 08:03:41+01:00 |
| 36856865 | 36856865 | 15 | 08:01:21 | 24.01.19 | 1 | 3.7 | 81 81 | 24.01.19 08:01:21 | 2019-01-24 08:01:21+01:00 |
| 36856864 | 36856864 | 22 | 08:01:06 | 24.01.19 | 1 | 3.3 | 81 81 | 24.01.19 08:01:06 | 2019-01-24 08:01:06+01:00 |
| 36856863 | 36856863 | 18 | 08:01:04 | 24.01.19 | 1 | 2.8 | 81 81 | 24.01.19 08:01:04 | 2019-01-24 08:01:04+01:00 |
| 36856862 | 36856862 | 20 | 07:59:37 | 24.01.19 | 1 | 2.3 | 81 81 | 24.01.19 07:59:37 | 2019-01-24 07:59:37+01:00 |
| 36856861 | 36856861 | 25 | 07:59:36 | 24.01.19 | 1 | 3.7 | 81 81 | 24.01.19 07:59:36 | 2019-01-24 07:59:36+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");