Geschwindigkeitsmonitoring: Einzelmessungen: 10,001 rows where Messung-ID = 23 sorted by Timestamp descending

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 = 23 sorted by Timestamp descending

descending

This data as json, copyable, CSV (advanced)

Link	rowid	Geschwindigkeit	Zeit	Datum	Richtung ID	Fahrzeuglänge	Messung-ID	Datum_Zeit	Timestamp ▲
36057716	36057716	10	10:45:32	24.10.17	1	1.7	23 23	24.10.17 10:45:32	2017-10-24 10:45:32+02:00
36065183	36065183	25	06:15:38	23.10.17	2	11.6	23 23	23.10.17 06:15:38	2017-10-23 06:15:38+02:00
36065184	36065184	28	06:15:38	23.10.17	2	4.4	23 23	23.10.17 06:15:38	2017-10-23 06:15:38+02:00
36057715	36057715	22	06:13:40	23.10.17	1	6.0	23 23	23.10.17 06:13:40	2017-10-23 06:13:40+02:00
36057714	36057714	22	06:12:10	23.10.17	1	4.1	23 23	23.10.17 06:12:10	2017-10-23 06:12:10+02:00
36057713	36057713	25	06:05:43	23.10.17	1	10.1	23 23	23.10.17 06:05:43	2017-10-23 06:05:43+02:00
36057712	36057712	30	06:05:03	23.10.17	1	6.2	23 23	23.10.17 06:05:03	2017-10-23 06:05:03+02:00
36065182	36065182	19	06:02:39	23.10.17	2	13.4	23 23	23.10.17 06:02:39	2017-10-23 06:02:39+02:00
36065181	36065181	28	06:01:07	23.10.17	2	4.4	23 23	23.10.17 06:01:07	2017-10-23 06:01:07+02:00
36057711	36057711	7	05:59:16	23.10.17	1	3.2	23 23	23.10.17 05:59:16	2017-10-23 05:59:16+02:00
36057710	36057710	26	05:55:42	23.10.17	1	5.6	23 23	23.10.17 05:55:42	2017-10-23 05:55:42+02:00
36057709	36057709	23	05:55:07	23.10.17	1	9.2	23 23	23.10.17 05:55:07	2017-10-23 05:55:07+02:00
36057708	36057708	38	05:54:17	23.10.17	1	9.2	23 23	23.10.17 05:54:17	2017-10-23 05:54:17+02:00
36065180	36065180	33	05:47:08	23.10.17	2	7.6	23 23	23.10.17 05:47:08	2017-10-23 05:47:08+02:00
36065179	36065179	25	05:42:54	23.10.17	2	14.6	23 23	23.10.17 05:42:54	2017-10-23 05:42:54+02:00
36065178	36065178	32	05:25:03	23.10.17	2	8.0	23 23	23.10.17 05:25:03	2017-10-23 05:25:03+02:00
36065177	36065177	28	05:22:12	23.10.17	2	15.1	23 23	23.10.17 05:22:12	2017-10-23 05:22:12+02:00
36057707	36057707	22	05:02:30	23.10.17	1	6.1	23 23	23.10.17 05:02:30	2017-10-23 05:02:30+02:00
36057706	36057706	34	04:24:03	23.10.17	1	10.1	23 23	23.10.17 04:24:03	2017-10-23 04:24:03+02:00
36065176	36065176	43	04:06:29	23.10.17	2	8.8	23 23	23.10.17 04:06:29	2017-10-23 04:06:29+02:00
36057705	36057705	26	03:05:21	23.10.17	1	6.8	23 23	23.10.17 03:05:21	2017-10-23 03:05:21+02:00
36057704	36057704	30	03:05:20	23.10.17	1	3.9	23 23	23.10.17 03:05:20	2017-10-23 03:05:20+02:00
36057703	36057703	32	01:06:41	23.10.17	1	9.6	23 23	23.10.17 01:06:41	2017-10-23 01:06:41+02:00
36065175	36065175	30	01:04:14	23.10.17	2	4.3	23 23	23.10.17 01:04:14	2017-10-23 01:04:14+02:00
36065174	36065174	27	01:04:13	23.10.17	2	1.8	23 23	23.10.17 01:04:13	2017-10-23 01:04:13+02:00
36065173	36065173	31	00:41:19	23.10.17	2	10.5	23 23	23.10.17 00:41:19	2017-10-23 00:41:19+02:00
36065172	36065172	22	00:26:22	23.10.17	2	10.4	23 23	23.10.17 00:26:22	2017-10-23 00:26:22+02:00
36065171	36065171	32	00:11:36	23.10.17	2	11.3	23 23	23.10.17 00:11:36	2017-10-23 00:11:36+02:00
36065170	36065170	26	23:56:14	22.10.17	2	12.5	23 23	22.10.17 23:56:14	2017-10-22 23:56:14+02:00
36065169	36065169	18	23:51:41	22.10.17	2	3.7	23 23	22.10.17 23:51:41	2017-10-22 23:51:41+02:00
36065168	36065168	18	23:51:40	22.10.17	2	0.7	23 23	22.10.17 23:51:40	2017-10-22 23:51:40+02:00
36065167	36065167	34	23:41:19	22.10.17	2	12.1	23 23	22.10.17 23:41:19	2017-10-22 23:41:19+02:00
36065166	36065166	26	23:38:43	22.10.17	2	8.9	23 23	22.10.17 23:38:43	2017-10-22 23:38:43+02:00
36057702	36057702	34	23:37:11	22.10.17	1	10.1	23 23	22.10.17 23:37:11	2017-10-22 23:37:11+02:00
36065165	36065165	27	23:28:35	22.10.17	2	12.0	23 23	22.10.17 23:28:35	2017-10-22 23:28:35+02:00
36065164	36065164	35	23:18:18	22.10.17	2	9.2	23 23	22.10.17 23:18:18	2017-10-22 23:18:18+02:00
36065163	36065163	29	23:11:43	22.10.17	2	10.7	23 23	22.10.17 23:11:43	2017-10-22 23:11:43+02:00
36065162	36065162	23	22:55:42	22.10.17	2	10.2	23 23	22.10.17 22:55:42	2017-10-22 22:55:42+02:00
36065161	36065161	31	22:43:16	22.10.17	2	7.2	23 23	22.10.17 22:43:16	2017-10-22 22:43:16+02:00
36065160	36065160	31	22:41:13	22.10.17	2	12.2	23 23	22.10.17 22:41:13	2017-10-22 22:41:13+02:00
36057701	36057701	7	22:28:00	22.10.17	1	3.2	23 23	22.10.17 22:28:00	2017-10-22 22:28:00+02:00
36065159	36065159	8	22:27:43	22.10.17	2	2.1	23 23	22.10.17 22:27:43	2017-10-22 22:27:43+02:00
36065158	36065158	29	22:27:23	22.10.17	2	11.9	23 23	22.10.17 22:27:23	2017-10-22 22:27:23+02:00
36057700	36057700	25	22:26:34	22.10.17	1	4.2	23 23	22.10.17 22:26:34	2017-10-22 22:26:34+02:00
36065157	36065157	23	22:23:17	22.10.17	2	3.8	23 23	22.10.17 22:23:17	2017-10-22 22:23:17+02:00
36065156	36065156	28	22:21:40	22.10.17	2	1.1	23 23	22.10.17 22:21:40	2017-10-22 22:21:40+02:00
36057699	36057699	31	22:14:44	22.10.17	1	9.8	23 23	22.10.17 22:14:44	2017-10-22 22:14:44+02:00
36065155	36065155	31	22:11:21	22.10.17	2	10.4	23 23	22.10.17 22:11:21	2017-10-22 22:11:21+02:00
36065154	36065154	34	22:08:55	22.10.17	2	8.4	23 23	22.10.17 22:08:55	2017-10-22 22:08:55+02:00
36065153	36065153	28	22:08:49	22.10.17	2	8.5	23 23	22.10.17 22:08:49	2017-10-22 22:08:49+02:00
36065152	36065152	31	22:05:38	22.10.17	2	1.9	23 23	22.10.17 22:05:38	2017-10-22 22:05:38+02:00
36065151	36065151	26	21:58:03	22.10.17	2	11.5	23 23	22.10.17 21:58:03	2017-10-22 21:58:03+02:00
36065150	36065150	29	21:44:35	22.10.17	2	4.3	23 23	22.10.17 21:44:35	2017-10-22 21:44:35+02:00
36065149	36065149	31	21:43:09	22.10.17	2	8.4	23 23	22.10.17 21:43:09	2017-10-22 21:43:09+02:00
36065148	36065148	31	21:41:51	22.10.17	2	10.4	23 23	22.10.17 21:41:51	2017-10-22 21:41:51+02:00
36065147	36065147	35	21:41:39	22.10.17	2	7.5	23 23	22.10.17 21:41:39	2017-10-22 21:41:39+02:00
36057698	36057698	23	21:40:14	22.10.17	1	6.2	23 23	22.10.17 21:40:14	2017-10-22 21:40:14+02:00
36065146	36065146	30	21:37:36	22.10.17	2	9.0	23 23	22.10.17 21:37:36	2017-10-22 21:37:36+02:00
36057697	36057697	7	21:35:10	22.10.17	1	3.8	23 23	22.10.17 21:35:10	2017-10-22 21:35:10+02:00
36057696	36057696	14	21:34:10	22.10.17	1	8.0	23 23	22.10.17 21:34:10	2017-10-22 21:34:10+02:00
36057695	36057695	16	21:33:29	22.10.17	1	7.3	23 23	22.10.17 21:33:29	2017-10-22 21:33:29+02:00
36065145	36065145	26	21:32:10	22.10.17	2	8.6	23 23	22.10.17 21:32:10	2017-10-22 21:32:10+02:00
36065144	36065144	18	21:32:04	22.10.17	2	4.8	23 23	22.10.17 21:32:04	2017-10-22 21:32:04+02:00
36065143	36065143	29	21:27:32	22.10.17	2	11.4	23 23	22.10.17 21:27:32	2017-10-22 21:27:32+02:00
36065142	36065142	35	21:27:02	22.10.17	2	9.7	23 23	22.10.17 21:27:02	2017-10-22 21:27:02+02:00
36057694	36057694	20	21:23:32	22.10.17	1	5.9	23 23	22.10.17 21:23:32	2017-10-22 21:23:32+02:00
36057693	36057693	33	21:14:32	22.10.17	1	3.9	23 23	22.10.17 21:14:32	2017-10-22 21:14:32+02:00
36057692	36057692	35	21:14:31	22.10.17	1	4.3	23 23	22.10.17 21:14:31	2017-10-22 21:14:31+02:00
36065141	36065141	27	21:13:16	22.10.17	2	5.4	23 23	22.10.17 21:13:16	2017-10-22 21:13:16+02:00
36065140	36065140	28	21:11:40	22.10.17	2	8.7	23 23	22.10.17 21:11:40	2017-10-22 21:11:40+02:00
36065139	36065139	22	21:10:37	22.10.17	2	3.5	23 23	22.10.17 21:10:37	2017-10-22 21:10:37+02:00
36065138	36065138	35	21:04:37	22.10.17	2	8.1	23 23	22.10.17 21:04:37	2017-10-22 21:04:37+02:00
36065137	36065137	19	21:02:30	22.10.17	2	4.3	23 23	22.10.17 21:02:30	2017-10-22 21:02:30+02:00
36065136	36065136	27	20:56:51	22.10.17	2	11.1	23 23	22.10.17 20:56:51	2017-10-22 20:56:51+02:00
36065135	36065135	27	20:51:03	22.10.17	2	0.9	23 23	22.10.17 20:51:03	2017-10-22 20:51:03+02:00
36057691	36057691	20	20:45:58	22.10.17	1	5.9	23 23	22.10.17 20:45:58	2017-10-22 20:45:58+02:00
36057690	36057690	19	20:45:56	22.10.17	1	4.3	23 23	22.10.17 20:45:56	2017-10-22 20:45:56+02:00
36065134	36065134	23	20:43:09	22.10.17	2	3.7	23 23	22.10.17 20:43:09	2017-10-22 20:43:09+02:00
36065133	36065133	22	20:43:02	22.10.17	2	1.0	23 23	22.10.17 20:43:02	2017-10-22 20:43:02+02:00
36065132	36065132	30	20:41:31	22.10.17	2	11.6	23 23	22.10.17 20:41:31	2017-10-22 20:41:31+02:00
36065131	36065131	24	20:35:49	22.10.17	2	4.8	23 23	22.10.17 20:35:49	2017-10-22 20:35:49+02:00
36065130	36065130	41	20:32:59	22.10.17	2	4.3	23 23	22.10.17 20:32:59	2017-10-22 20:32:59+02:00
36057689	36057689	28	20:31:24	22.10.17	1	7.8	23 23	22.10.17 20:31:24	2017-10-22 20:31:24+02:00
36057688	36057688	29	20:31:23	22.10.17	1	4.3	23 23	22.10.17 20:31:23	2017-10-22 20:31:23+02:00
36065129	36065129	23	20:26:36	22.10.17	2	9.9	23 23	22.10.17 20:26:36	2017-10-22 20:26:36+02:00
36065128	36065128	30	20:21:40	22.10.17	2	8.4	23 23	22.10.17 20:21:40	2017-10-22 20:21:40+02:00
36065127	36065127	27	20:18:22	22.10.17	2	5.0	23 23	22.10.17 20:18:22	2017-10-22 20:18:22+02:00
36057687	36057687	28	20:17:30	22.10.17	1	7.7	23 23	22.10.17 20:17:30	2017-10-22 20:17:30+02:00
36065126	36065126	36	20:15:37	22.10.17	2	7.9	23 23	22.10.17 20:15:37	2017-10-22 20:15:37+02:00
36065125	36065125	29	20:12:54	22.10.17	2	9.3	23 23	22.10.17 20:12:54	2017-10-22 20:12:54+02:00
36065124	36065124	30	20:11:00	22.10.17	2	11.8	23 23	22.10.17 20:11:00	2017-10-22 20:11:00+02:00
36065123	36065123	33	20:09:09	22.10.17	2	5.1	23 23	22.10.17 20:09:09	2017-10-22 20:09:09+02:00
36065122	36065122	28	20:08:04	22.10.17	2	8.8	23 23	22.10.17 20:08:04	2017-10-22 20:08:04+02:00
36065121	36065121	28	20:05:10	22.10.17	2	8.0	23 23	22.10.17 20:05:10	2017-10-22 20:05:10+02:00
36057686	36057686	26	20:00:54	22.10.17	1	9.1	23 23	22.10.17 20:00:54	2017-10-22 20:00:54+02:00
36065120	36065120	22	19:57:48	22.10.17	2	8.3	23 23	22.10.17 19:57:48	2017-10-22 19:57:48+02:00
36057685	36057685	28	19:54:16	22.10.17	1	11.0	23 23	22.10.17 19:54:16	2017-10-22 19:54:16+02:00
36065119	36065119	21	19:53:17	22.10.17	2	1.4	23 23	22.10.17 19:53:17	2017-10-22 19:53:17+02:00
36065118	36065118	24	19:53:01	22.10.17	2	7.6	23 23	22.10.17 19:53:01	2017-10-22 19:53:01+02:00
36065117	36065117	40	19:51:07	22.10.17	2	9.8	23 23	22.10.17 19:51:07	2017-10-22 19:51: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");