Einzelmessungen
- Messung_Datum
- Datum der Messung
- Messung_Timestamp
- Zeitpunkt der Messung
- Messung_Zeit
- Uhrzeit der Messung
- Phase
- Phase der Messung (Vormessung, Betrieb, Nachmessung oder nach Ende)
- V_Ausfahrt
- Ausfahrtsgeschwindigkeit in km/h
- V_Delta
- Differenz zwischen Einfahrts- und Ausfahrtsgeschwindigkeit in km/h
- V_Einfahrt
- Einfahrtsgeschwindigkeit in km/h
- Zyklus
- Messzyklus
- id_standort
- Eindeutige Standortkennung
>10,000 rows count all where ID = "1-20" sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Phase, Messung_Datum, Messung_Datum (date), Messung_Timestamp (date)
Link | rowid | ID | id_standort | Zyklus | Phase | Messung_Datum | Messung_Zeit | V_Einfahrt | V_Ausfahrt | Messung_Timestamp ▲ | V_Delta |
---|---|---|---|---|---|---|---|---|---|---|---|
11551545 | 11551545 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:20:56.000000 | 19 | 18 | 2023-07-10 10:20:56+02:00 | -1 |
11551544 | 11551544 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:19:44.000000 | 26 | 10 | 2023-07-10 10:19:44+02:00 | -16 |
11551543 | 11551543 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:19:39.000000 | 19 | 27 | 2023-07-10 10:19:39+02:00 | 8 |
11551542 | 11551542 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:18:35.000000 | 33 | 30 | 2023-07-10 10:18:35+02:00 | -3 |
11551541 | 11551541 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:18:27.000000 | 19 | 30 | 2023-07-10 10:18:27+02:00 | 11 |
11551540 | 11551540 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:13:11.000000 | 29 | 26 | 2023-07-10 10:13:11+02:00 | -3 |
11551539 | 11551539 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:12:12.000000 | 32 | 27 | 2023-07-10 10:12:12+02:00 | -5 |
11551538 | 11551538 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:10:45.000000 | 24 | 24 | 2023-07-10 10:10:45+02:00 | 0 |
11551537 | 11551537 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:10:14.000000 | 20 | 17 | 2023-07-10 10:10:14+02:00 | -3 |
11551536 | 11551536 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:09:16.000000 | 12 | 17 | 2023-07-10 10:09:16+02:00 | 5 |
11551535 | 11551535 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:07:10.000000 | 25 | 25 | 2023-07-10 10:07:10+02:00 | 0 |
11551534 | 11551534 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:06:32.000000 | 20 | 19 | 2023-07-10 10:06:32+02:00 | -1 |
11551533 | 11551533 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:05:33.000000 | 23 | 31 | 2023-07-10 10:05:33+02:00 | 8 |
11551532 | 11551532 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:02:55.000000 | 27 | 28 | 2023-07-10 10:02:55+02:00 | 1 |
11551531 | 11551531 | Wettsteinallee 1-20 | 20 | 1 | Nach Ende | 2023-07-10 | 10:00:54.000000 | 28 | 22 | 2023-07-10 10:00:54+02:00 | -6 |
11551530 | 11551530 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:57:11.000000 | 24 | 27 | 2023-07-10 09:57:11+02:00 | 3 |
11551529 | 11551529 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:56:23.000000 | 25 | 25 | 2023-07-10 09:56:23+02:00 | 0 |
11551528 | 11551528 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:54:54.000000 | 29 | 26 | 2023-07-10 09:54:54+02:00 | -3 |
11551527 | 11551527 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:54:27.000000 | 25 | 27 | 2023-07-10 09:54:27+02:00 | 2 |
11551526 | 11551526 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:54:20.000000 | 19 | 20 | 2023-07-10 09:54:20+02:00 | 1 |
11551525 | 11551525 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:54:00.000000 | 33 | 34 | 2023-07-10 09:54:00+02:00 | 1 |
11551524 | 11551524 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:53:03.000000 | 17 | 22 | 2023-07-10 09:53:03+02:00 | 5 |
11551523 | 11551523 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:51:21.000000 | 23 | 23 | 2023-07-10 09:51:21+02:00 | 0 |
11551522 | 11551522 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:49:39.000000 | 26 | 27 | 2023-07-10 09:49:39+02:00 | 1 |
11551521 | 11551521 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:47:06.000000 | 16 | 19 | 2023-07-10 09:47:06+02:00 | 3 |
11551520 | 11551520 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:45:48.000000 | 18 | 31 | 2023-07-10 09:45:48+02:00 | 13 |
11551519 | 11551519 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:44:01.000000 | 23 | 20 | 2023-07-10 09:44:01+02:00 | -3 |
11551518 | 11551518 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:43:42.000000 | 18 | 15 | 2023-07-10 09:43:42+02:00 | -3 |
11551517 | 11551517 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:39:58.000000 | 27 | 23 | 2023-07-10 09:39:58+02:00 | -4 |
11551516 | 11551516 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:39:47.000000 | 25 | 9 | 2023-07-10 09:39:47+02:00 | -16 |
11551515 | 11551515 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:37:58.000000 | 16 | 24 | 2023-07-10 09:37:58+02:00 | 8 |
11551514 | 11551514 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:36:10.000000 | 29 | 27 | 2023-07-10 09:36:10+02:00 | -2 |
11551513 | 11551513 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:27:34.000000 | 32 | 30 | 2023-07-10 09:27:34+02:00 | -2 |
11551512 | 11551512 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:25:10.000000 | 19 | 16 | 2023-07-10 09:25:10+02:00 | -3 |
11551511 | 11551511 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:23:17.000000 | 23 | 25 | 2023-07-10 09:23:17+02:00 | 2 |
11551510 | 11551510 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:22:44.000000 | 20 | 28 | 2023-07-10 09:22:44+02:00 | 8 |
11551509 | 11551509 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:22:07.000000 | 20 | 23 | 2023-07-10 09:22:07+02:00 | 3 |
11551508 | 11551508 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:21:29.000000 | 25 | 29 | 2023-07-10 09:21:29+02:00 | 4 |
11551507 | 11551507 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:21:23.000000 | 25 | 22 | 2023-07-10 09:21:23+02:00 | -3 |
11551506 | 11551506 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:20:59.000000 | 24 | 27 | 2023-07-10 09:20:59+02:00 | 3 |
11551505 | 11551505 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:18:41.000000 | 30 | 27 | 2023-07-10 09:18:41+02:00 | -3 |
11551504 | 11551504 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:15:03.000000 | 25 | 24 | 2023-07-10 09:15:03+02:00 | -1 |
11551503 | 11551503 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:14:41.000000 | 32 | 26 | 2023-07-10 09:14:41+02:00 | -6 |
11551502 | 11551502 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:13:36.000000 | 24 | 20 | 2023-07-10 09:13:36+02:00 | -4 |
11551501 | 11551501 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:10:24.000000 | 26 | 25 | 2023-07-10 09:10:24+02:00 | -1 |
11551500 | 11551500 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:09:39.000000 | 6 | 16 | 2023-07-10 09:09:39+02:00 | 10 |
11551499 | 11551499 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:07:57.000000 | 14 | 17 | 2023-07-10 09:07:57+02:00 | 3 |
11551498 | 11551498 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:07:33.000000 | 17 | 23 | 2023-07-10 09:07:33+02:00 | 6 |
11551497 | 11551497 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:07:30.000000 | 14 | 24 | 2023-07-10 09:07:30+02:00 | 10 |
11551496 | 11551496 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:06:11.000000 | 13 | 25 | 2023-07-10 09:06:11+02:00 | 12 |
11551495 | 11551495 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:05:52.000000 | 24 | 24 | 2023-07-10 09:05:52+02:00 | 0 |
11551494 | 11551494 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:05:31.000000 | 26 | 28 | 2023-07-10 09:05:31+02:00 | 2 |
11551493 | 11551493 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:04:07.000000 | 26 | 30 | 2023-07-10 09:04:07+02:00 | 4 |
11551492 | 11551492 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:02:23.000000 | 18 | 27 | 2023-07-10 09:02:23+02:00 | 9 |
11551491 | 11551491 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:01:33.000000 | 19 | 22 | 2023-07-10 09:01:33+02:00 | 3 |
11551490 | 11551490 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:01:11.000000 | 30 | 19 | 2023-07-10 09:01:11+02:00 | -11 |
11551489 | 11551489 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 09:00:15.000000 | 25 | 27 | 2023-07-10 09:00:15+02:00 | 2 |
11551488 | 11551488 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:58:19.000000 | 19 | 25 | 2023-07-10 08:58:19+02:00 | 6 |
11551487 | 11551487 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:55:50.000000 | 18 | 22 | 2023-07-10 08:55:50+02:00 | 4 |
11551486 | 11551486 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:55:42.000000 | 20 | 23 | 2023-07-10 08:55:42+02:00 | 3 |
11551485 | 11551485 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:55:22.000000 | 19 | 23 | 2023-07-10 08:55:22+02:00 | 4 |
11551484 | 11551484 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:54:25.000000 | 27 | 23 | 2023-07-10 08:54:25+02:00 | -4 |
11551483 | 11551483 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:52:42.000000 | 23 | 23 | 2023-07-10 08:52:42+02:00 | 0 |
11551482 | 11551482 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:51:47.000000 | 20 | 27 | 2023-07-10 08:51:47+02:00 | 7 |
11551481 | 11551481 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:51:44.000000 | 29 | 30 | 2023-07-10 08:51:44+02:00 | 1 |
11551480 | 11551480 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:51:33.000000 | 32 | 27 | 2023-07-10 08:51:33+02:00 | -5 |
11551479 | 11551479 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:51:29.000000 | 31 | 37 | 2023-07-10 08:51:29+02:00 | 6 |
11551478 | 11551478 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:49:09.000000 | 31 | 30 | 2023-07-10 08:49:09+02:00 | -1 |
11551477 | 11551477 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:47:02.000000 | 18 | 13 | 2023-07-10 08:47:02+02:00 | -5 |
11551476 | 11551476 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:46:14.000000 | 26 | 29 | 2023-07-10 08:46:14+02:00 | 3 |
11551475 | 11551475 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:44:18.000000 | 19 | 26 | 2023-07-10 08:44:18+02:00 | 7 |
11551474 | 11551474 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:43:17.000000 | 34 | 25 | 2023-07-10 08:43:17+02:00 | -9 |
11551473 | 11551473 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:43:13.000000 | 20 | 29 | 2023-07-10 08:43:13+02:00 | 9 |
11551472 | 11551472 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:41:55.000000 | 20 | 17 | 2023-07-10 08:41:55+02:00 | -3 |
11551471 | 11551471 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:40:21.000000 | 30 | 24 | 2023-07-10 08:40:21+02:00 | -6 |
11551470 | 11551470 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:39:21.000000 | 25 | 24 | 2023-07-10 08:39:21+02:00 | -1 |
11551469 | 11551469 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:37:14.000000 | 25 | 23 | 2023-07-10 08:37:14+02:00 | -2 |
11551468 | 11551468 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:36:29.000000 | 23 | 24 | 2023-07-10 08:36:29+02:00 | 1 |
11551467 | 11551467 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:30:41.000000 | 27 | 26 | 2023-07-10 08:30:41+02:00 | -1 |
11551466 | 11551466 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:30:20.000000 | 18 | 25 | 2023-07-10 08:30:20+02:00 | 7 |
11551465 | 11551465 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:29:11.000000 | 26 | 26 | 2023-07-10 08:29:11+02:00 | 0 |
11551464 | 11551464 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:28:45.000000 | 25 | 26 | 2023-07-10 08:28:45+02:00 | 1 |
11551463 | 11551463 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:28:24.000000 | 17 | 29 | 2023-07-10 08:28:24+02:00 | 12 |
11551462 | 11551462 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:26:27.000000 | 28 | 28 | 2023-07-10 08:26:27+02:00 | 0 |
11551461 | 11551461 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:26:16.000000 | 18 | 27 | 2023-07-10 08:26:16+02:00 | 9 |
11551460 | 11551460 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:25:25.000000 | 19 | 28 | 2023-07-10 08:25:25+02:00 | 9 |
11551459 | 11551459 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:24:33.000000 | 36 | 32 | 2023-07-10 08:24:33+02:00 | -4 |
11551458 | 11551458 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:24:21.000000 | 25 | 33 | 2023-07-10 08:24:21+02:00 | 8 |
11551457 | 11551457 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:19:23.000000 | 29 | 26 | 2023-07-10 08:19:23+02:00 | -3 |
11551456 | 11551456 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:18:44.000000 | 11 | 29 | 2023-07-10 08:18:44+02:00 | 18 |
11551455 | 11551455 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:17:31.000000 | 17 | 18 | 2023-07-10 08:17:31+02:00 | 1 |
11551454 | 11551454 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:16:20.000000 | 14 | 14 | 2023-07-10 08:16:20+02:00 | 0 |
11551453 | 11551453 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:16:03.000000 | 25 | 32 | 2023-07-10 08:16:03+02:00 | 7 |
11551452 | 11551452 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:15:34.000000 | 26 | 25 | 2023-07-10 08:15:34+02:00 | -1 |
11551451 | 11551451 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:15:29.000000 | 31 | 27 | 2023-07-10 08:15:29+02:00 | -4 |
11551450 | 11551450 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:12:47.000000 | 14 | 13 | 2023-07-10 08:12:47+02:00 | -1 |
11551449 | 11551449 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:12:10.000000 | 20 | 33 | 2023-07-10 08:12:10+02:00 | 13 |
11551448 | 11551448 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:09:33.000000 | 33 | 27 | 2023-07-10 08:09:33+02:00 | -6 |
11551447 | 11551447 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:09:13.000000 | 30 | 31 | 2023-07-10 08:09:13+02:00 | 1 |
11551446 | 11551446 | Wettsteinallee 1-20 | 20 | 1 | Nachmessung | 2023-07-10 | 08:08:54.000000 | 19 | 17 | 2023-07-10 08:08:54+02:00 | -2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE Einzelmessungen ( ID TEXT, id_standort INTEGER, Zyklus INTEGER, Phase TEXT, Messung_Datum TEXT, Messung_Zeit TEXT, V_Einfahrt INTEGER, V_Ausfahrt INTEGER, Messung_Timestamp TEXT, V_Delta INTEGER, FOREIGN KEY (ID) REFERENCES Einsatzplan (ID) ON DELETE CASCADE ); CREATE INDEX idx_Einzelmessungen_id ON "Einzelmessungen" ("ID"); CREATE INDEX idx_Einzelmessungen_id_standort ON "Einzelmessungen" ("id_standort"); CREATE INDEX idx_Einzelmessungen_zyklus ON "Einzelmessungen" ("Zyklus"); CREATE INDEX idx_Einzelmessungen_phase ON "Einzelmessungen" ("Phase"); CREATE INDEX idx_Einzelmessungen_messung_datum ON "Einzelmessungen" ("Messung_Datum"); CREATE INDEX idx_Einzelmessungen_messung_timestamp ON "Einzelmessungen" ("Messung_Timestamp");