google_activity_segments
4 rows where activity_type = "IN_SUBWAY" and "updated_at" is on date 2021-03-01 sorted by duration_start_timestamp_ms
This data as json, CSV (advanced)
Suggested facets: confidence, distance, start_location_latitude_e7, start_location_longitude_e7, transit_path_hex_rgb_color, transit_path_name, created_at (date), duration_end_timestamp_ms (date), duration_start_timestamp_ms (date)
id | created_at | updated_at | deleted_at | activity_type | confidence | distance | duration_end_timestamp_ms | duration_start_timestamp_ms ▼ | end_location_latitude_e7 | end_location_longitude_e7 | parking_event_location_accuracy_metres | parking_event_location_latitude_e7 | parking_event_location_longitude_e7 | parking_event_timestamp_ms | start_location_latitude_e7 | start_location_longitude_e7 | transit_path_hex_rgb_color | transit_path_name |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4621 | 2021-03-01 19:29:19.229032+03:00 | 2021-03-01 19:29:19.229032+03:00 | IN_SUBWAY | MEDIUM | 3226 | 2021-01-06 10:41:20.039+03:00 | 2021-01-06 10:12:21.558+03:00 | 557460988 | 376264853 | 0 | 0 | 0 | 557649280 | 375613770 | 953C8F | 7 | ||
4622 | 2021-03-01 19:29:19.230155+03:00 | 2021-03-01 19:29:19.230155+03:00 | IN_SUBWAY | LOW | 2754 | 2021-01-06 17:02:15.557+03:00 | 2021-01-06 16:44:10.514+03:00 | 557605820 | 376149646 | 0 | 0 | 0 | 557484488 | 376251530 | E42325 | 1 | ||
4626 | 2021-03-01 19:29:19.233893+03:00 | 2021-03-01 19:29:19.233893+03:00 | IN_SUBWAY | MEDIUM | 3226 | 2021-01-07 10:52:45.584+03:00 | 2021-01-07 10:40:36.509+03:00 | 557654730 | 376072860 | 0 | 0 | 0 | 557649280 | 375613770 | 953C8F | 7 | ||
4627 | 2021-03-01 19:29:19.234739+03:00 | 2021-03-01 19:29:19.234739+03:00 | IN_SUBWAY | MEDIUM | 3077 | 2021-01-07 11:06:20.62+03:00 | 2021-01-07 10:52:45.584+03:00 | 557412930 | 376292900 | 0 | 0 | 0 | 557647530 | 376066570 | 4DAF4A | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE `google_activity_segments` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`activity_type` text,`confidence` text,`distance` integer,`duration_end_timestamp_ms` datetime,`duration_start_timestamp_ms` datetime,`end_location_latitude_e7` integer,`end_location_longitude_e7` integer,`parking_event_location_accuracy_metres` integer,`parking_event_location_latitude_e7` integer,`parking_event_location_longitude_e7` integer,`parking_event_timestamp_ms` datetime,`start_location_latitude_e7` integer,`start_location_longitude_e7` integer,`transit_path_hex_rgb_color` text,`transit_path_name` text,PRIMARY KEY (`id`)); CREATE UNIQUE INDEX `google_activity_segments_key` ON `google_activity_segments`(`duration_end_timestamp_ms`,`duration_start_timestamp_ms`); CREATE INDEX `idx_google_activity_segments_deleted_at` ON `google_activity_segments`(`deleted_at`);