4 rows where activity_type = "IN_SUBWAY"

View and edit SQL

Suggested facets: confidence, distance, start_location_latitude_e7, start_location_longitude_e7, transit_path_hex_rgb_color, created_at (date), updated_at (date), duration_end_timestamp_ms (date), duration_start_timestamp_ms (date)

transit_path_name

activity_type

  • IN_SUBWAY · 4
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

CSV options:

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`);