google_activity_segments
4 rows where activity_type = "WALKING" sorted by end_location_longitude_e7
This data as json, CSV (advanced)
Suggested facets: confidence, created_at (date), updated_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4620 | 2021-03-01 19:29:19.228139+03:00 | 2021-03-01 19:29:19.228139+03:00 | WALKING | MEDIUM | 581 | 2021-01-06 09:35:51.321+03:00 | 2021-01-06 09:28:17.069+03:00 | 557625270 | 375645207 | 0 | 0 | 0 | 557629020 | 375726398 | ||||
4625 | 2021-03-01 19:29:19.233015+03:00 | 2021-03-01 19:29:19.233015+03:00 | WALKING | HIGH | 192 | 2021-01-07 10:03:59.022+03:00 | 2021-01-07 10:01:27.125+03:00 | 557636710 | 375686163 | 0 | 0 | 0 | 557633086 | 375716308 | ||||
4619 | 2021-03-01 19:29:19.22728+03:00 | 2021-03-01 19:29:19.22728+03:00 | WALKING | HIGH | 1082 | 2021-01-05 23:02:56+03:00 | 2021-01-05 22:45:46.527+03:00 | 557622000 | 375742787 | 0 | 0 | 0 | 557578858 | 375891744 | ||||
4618 | 2021-03-01 19:29:19.2264+03:00 | 2021-03-01 19:29:19.2264+03:00 | WALKING | MEDIUM | 297 | 2021-01-05 17:06:39.327+03:00 | 2021-01-05 17:01:22.649+03:00 | 557572203 | 375960796 | 0 | 0 | 0 | 557573184 | 376007713 |
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`);