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 = "3-12" sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
2440478 | 2440478 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:20:38.000000 | 19 | 23 | 2024-05-06 08:20:38+02:00 | 4 |
2440477 | 2440477 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:20:19.000000 | 27 | 24 | 2024-05-06 08:20:19+02:00 | -3 |
2440476 | 2440476 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:20:06.000000 | 27 | 26 | 2024-05-06 08:20:06+02:00 | -1 |
2440475 | 2440475 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:16:41.000000 | 30 | 28 | 2024-05-06 08:16:41+02:00 | -2 |
2440474 | 2440474 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:14:54.000000 | 26 | 26 | 2024-05-06 08:14:54+02:00 | 0 |
2440473 | 2440473 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:13:53.000000 | 27 | 28 | 2024-05-06 08:13:53+02:00 | 1 |
2440472 | 2440472 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:11:41.000000 | 30 | 31 | 2024-05-06 08:11:41+02:00 | 1 |
2440471 | 2440471 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:10:51.000000 | 28 | 27 | 2024-05-06 08:10:51+02:00 | -1 |
2440470 | 2440470 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:10:37.000000 | 11 | 27 | 2024-05-06 08:10:37+02:00 | 16 |
2440469 | 2440469 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:10:02.000000 | 36 | 34 | 2024-05-06 08:10:02+02:00 | -2 |
2440468 | 2440468 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:09:50.000000 | 33 | 34 | 2024-05-06 08:09:50+02:00 | 1 |
2440467 | 2440467 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:05:01.000000 | 29 | 28 | 2024-05-06 08:05:01+02:00 | -1 |
2440466 | 2440466 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 08:00:31.000000 | 17 | 30 | 2024-05-06 08:00:31+02:00 | 13 |
2440465 | 2440465 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:53:47.000000 | 32 | 25 | 2024-05-06 07:53:47+02:00 | -7 |
2440464 | 2440464 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:50:48.000000 | 16 | 27 | 2024-05-06 07:50:48+02:00 | 11 |
2440463 | 2440463 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:49:28.000000 | 26 | 22 | 2024-05-06 07:49:28+02:00 | -4 |
2440462 | 2440462 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:49:16.000000 | 25 | 22 | 2024-05-06 07:49:16+02:00 | -3 |
2440461 | 2440461 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:49:04.000000 | 24 | 23 | 2024-05-06 07:49:04+02:00 | -1 |
2440460 | 2440460 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:35:47.000000 | 33 | 30 | 2024-05-06 07:35:47+02:00 | -3 |
2440459 | 2440459 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:35:37.000000 | 33 | 33 | 2024-05-06 07:35:37+02:00 | 0 |
2440458 | 2440458 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:34:47.000000 | 30 | 30 | 2024-05-06 07:34:47+02:00 | 0 |
2440457 | 2440457 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:34:31.000000 | 30 | 30 | 2024-05-06 07:34:31+02:00 | 0 |
2440456 | 2440456 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:32:48.000000 | 26 | 24 | 2024-05-06 07:32:48+02:00 | -2 |
2440455 | 2440455 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:32:09.000000 | 26 | 26 | 2024-05-06 07:32:09+02:00 | 0 |
2440454 | 2440454 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:31:33.000000 | 17 | 25 | 2024-05-06 07:31:33+02:00 | 8 |
2440453 | 2440453 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:31:09.000000 | 27 | 25 | 2024-05-06 07:31:09+02:00 | -2 |
2440452 | 2440452 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:30:55.000000 | 27 | 27 | 2024-05-06 07:30:55+02:00 | 0 |
2440451 | 2440451 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:28:58.000000 | 19 | 12 | 2024-05-06 07:28:58+02:00 | -7 |
2440450 | 2440450 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:28:40.000000 | 19 | 24 | 2024-05-06 07:28:40+02:00 | 5 |
2440449 | 2440449 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:27:08.000000 | 38 | 30 | 2024-05-06 07:27:08+02:00 | -8 |
2440448 | 2440448 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:26:56.000000 | 31 | 30 | 2024-05-06 07:26:56+02:00 | -1 |
2440447 | 2440447 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:26:44.000000 | 35 | 30 | 2024-05-06 07:26:44+02:00 | -5 |
2440446 | 2440446 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:17:05.000000 | 25 | 25 | 2024-05-06 07:17:05+02:00 | 0 |
2440445 | 2440445 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:16:53.000000 | 29 | 29 | 2024-05-06 07:16:53+02:00 | 0 |
2440444 | 2440444 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:16:39.000000 | 29 | 31 | 2024-05-06 07:16:39+02:00 | 2 |
2440443 | 2440443 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:14:42.000000 | 30 | 35 | 2024-05-06 07:14:42+02:00 | 5 |
2440442 | 2440442 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:14:32.000000 | 34 | 29 | 2024-05-06 07:14:32+02:00 | -5 |
2440441 | 2440441 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:14:06.000000 | 34 | 30 | 2024-05-06 07:14:06+02:00 | -4 |
2440440 | 2440440 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:13:58.000000 | 39 | 33 | 2024-05-06 07:13:58+02:00 | -6 |
2440439 | 2440439 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:12:11.000000 | 32 | 29 | 2024-05-06 07:12:11+02:00 | -3 |
2440438 | 2440438 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:08:41.000000 | 26 | 25 | 2024-05-06 07:08:41+02:00 | -1 |
2440437 | 2440437 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:08:40.000000 | 28 | 27 | 2024-05-06 07:08:40+02:00 | -1 |
2440436 | 2440436 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:08:29.000000 | 32 | 34 | 2024-05-06 07:08:29+02:00 | 2 |
2440435 | 2440435 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:07:20.000000 | 33 | 40 | 2024-05-06 07:07:20+02:00 | 7 |
2440434 | 2440434 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:07:11.000000 | 27 | 32 | 2024-05-06 07:07:11+02:00 | 5 |
2440433 | 2440433 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:05:04.000000 | 30 | 20 | 2024-05-06 07:05:04+02:00 | -10 |
2440432 | 2440432 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:04:52.000000 | 29 | 28 | 2024-05-06 07:04:52+02:00 | -1 |
2440431 | 2440431 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:04:28.000000 | 28 | 19 | 2024-05-06 07:04:28+02:00 | -9 |
2440430 | 2440430 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:04:21.000000 | 31 | 22 | 2024-05-06 07:04:21+02:00 | -9 |
2440429 | 2440429 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:03:56.000000 | 26 | 30 | 2024-05-06 07:03:56+02:00 | 4 |
2440428 | 2440428 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:01:39.000000 | 37 | 37 | 2024-05-06 07:01:39+02:00 | 0 |
2440427 | 2440427 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:01:38.000000 | 38 | 38 | 2024-05-06 07:01:38+02:00 | 0 |
2440426 | 2440426 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:00:24.000000 | 31 | 14 | 2024-05-06 07:00:24+02:00 | -17 |
2440425 | 2440425 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:00:13.000000 | 34 | 31 | 2024-05-06 07:00:13+02:00 | -3 |
2440424 | 2440424 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 07:00:04.000000 | 16 | 33 | 2024-05-06 07:00:04+02:00 | 17 |
2440423 | 2440423 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:57:51.000000 | 26 | 28 | 2024-05-06 06:57:51+02:00 | 2 |
2440422 | 2440422 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:57:39.000000 | 26 | 25 | 2024-05-06 06:57:39+02:00 | -1 |
2440421 | 2440421 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:56:46.000000 | 20 | 27 | 2024-05-06 06:56:46+02:00 | 7 |
2440420 | 2440420 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:56:43.000000 | 18 | 27 | 2024-05-06 06:56:43+02:00 | 9 |
2440419 | 2440419 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:55:57.000000 | 33 | 29 | 2024-05-06 06:55:57+02:00 | -4 |
2440418 | 2440418 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:55:53.000000 | 25 | 27 | 2024-05-06 06:55:53+02:00 | 2 |
2440417 | 2440417 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:55:48.000000 | 12 | 11 | 2024-05-06 06:55:48+02:00 | -1 |
2440416 | 2440416 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:54:59.000000 | 31 | 26 | 2024-05-06 06:54:59+02:00 | -5 |
2440415 | 2440415 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:54:49.000000 | 39 | 30 | 2024-05-06 06:54:49+02:00 | -9 |
2440414 | 2440414 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:53:50.000000 | 37 | 33 | 2024-05-06 06:53:50+02:00 | -4 |
2440413 | 2440413 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:51:52.000000 | 27 | 19 | 2024-05-06 06:51:52+02:00 | -8 |
2440412 | 2440412 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:51:02.000000 | 27 | 24 | 2024-05-06 06:51:02+02:00 | -3 |
2440411 | 2440411 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:50:51.000000 | 27 | 26 | 2024-05-06 06:50:51+02:00 | -1 |
2440410 | 2440410 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:50:39.000000 | 20 | 26 | 2024-05-06 06:50:39+02:00 | 6 |
2440409 | 2440409 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:50:34.000000 | 34 | 37 | 2024-05-06 06:50:34+02:00 | 3 |
2440408 | 2440408 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:50:25.000000 | 40 | 33 | 2024-05-06 06:50:25+02:00 | -7 |
2440406 | 2440406 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:50:19.000000 | 18 | 24 | 2024-05-06 06:50:19+02:00 | 6 |
2440407 | 2440407 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:50:19.000000 | 18 | 16 | 2024-05-06 06:50:19+02:00 | -2 |
2440405 | 2440405 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:50:06.000000 | 34 | 31 | 2024-05-06 06:50:06+02:00 | -3 |
2440404 | 2440404 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:49:57.000000 | 32 | 33 | 2024-05-06 06:49:57+02:00 | 1 |
2440403 | 2440403 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:49:52.000000 | 25 | 35 | 2024-05-06 06:49:52+02:00 | 10 |
2440402 | 2440402 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:46:18.000000 | 15 | 22 | 2024-05-06 06:46:18+02:00 | 7 |
2440401 | 2440401 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:44:24.000000 | 31 | 33 | 2024-05-06 06:44:24+02:00 | 2 |
2440400 | 2440400 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:43:00.000000 | 14 | 29 | 2024-05-06 06:43:00+02:00 | 15 |
2440399 | 2440399 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:42:50.000000 | 18 | 24 | 2024-05-06 06:42:50+02:00 | 6 |
2440398 | 2440398 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:40:46.000000 | 18 | 14 | 2024-05-06 06:40:46+02:00 | -4 |
2440397 | 2440397 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:40:26.000000 | 32 | 26 | 2024-05-06 06:40:26+02:00 | -6 |
2440396 | 2440396 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:40:17.000000 | 27 | 32 | 2024-05-06 06:40:17+02:00 | 5 |
2440395 | 2440395 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:39:48.000000 | 8 | 24 | 2024-05-06 06:39:48+02:00 | 16 |
2440394 | 2440394 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:39:30.000000 | 30 | 29 | 2024-05-06 06:39:30+02:00 | -1 |
2440393 | 2440393 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:38:12.000000 | 19 | 27 | 2024-05-06 06:38:12+02:00 | 8 |
2440392 | 2440392 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:37:49.000000 | 19 | 22 | 2024-05-06 06:37:49+02:00 | 3 |
2440391 | 2440391 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:36:20.000000 | 32 | 29 | 2024-05-06 06:36:20+02:00 | -3 |
2440390 | 2440390 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:36:11.000000 | 18 | 18 | 2024-05-06 06:36:11+02:00 | 0 |
2440389 | 2440389 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:35:14.000000 | 19 | 15 | 2024-05-06 06:35:14+02:00 | -4 |
2440388 | 2440388 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:34:55.000000 | 18 | 26 | 2024-05-06 06:34:55+02:00 | 8 |
2440387 | 2440387 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:34:54.000000 | 15 | 27 | 2024-05-06 06:34:54+02:00 | 12 |
2440386 | 2440386 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:31:42.000000 | 35 | 35 | 2024-05-06 06:31:42+02:00 | 0 |
2440385 | 2440385 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:31:34.000000 | 40 | 34 | 2024-05-06 06:31:34+02:00 | -6 |
2440384 | 2440384 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:30:08.000000 | 24 | 19 | 2024-05-06 06:30:08+02:00 | -5 |
2440383 | 2440383 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:29:50.000000 | 33 | 24 | 2024-05-06 06:29:50+02:00 | -9 |
2440382 | 2440382 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:29:29.000000 | 19 | 24 | 2024-05-06 06:29:29+02:00 | 5 |
2440381 | 2440381 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:28:16.000000 | 20 | 20 | 2024-05-06 06:28:16+02:00 | 0 |
2440380 | 2440380 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:28:05.000000 | 34 | 23 | 2024-05-06 06:28:05+02:00 | -11 |
2440379 | 2440379 | Allmendstrasse 3-12 | 12 | 3 | Nachmessung | 2024-05-06 | 06:26:47.000000 | 33 | 30 | 2024-05-06 06:26:47+02:00 | -3 |
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");