3 rows sorted by action_id

View and edit SQL

Suggested facets: source, source_url, created_at (date), updated_at (date)

id created_at updated_at deleted_at action_id ▼ name url source source_url
4243 2021-03-02 19:31:30.209026+03:00 2021-03-02 19:31:30.209026+03:00   Visited Home · Patrick Collison 74458 At this general area https://www.google.com/maps/@?api=1&map_action=map&center=55.768445,37.580154&zoom=10 Based on your past activity  
4244 2021-03-02 19:31:30.209026+03:00 2021-03-02 19:31:30.209026+03:00   Searched for 15000 * 0.75 74460 At this general area https://www.google.com/maps/@?api=1&map_action=map&center=55.745126,37.645189&zoom=11 From your Location History https://www.google.com/maps/timeline
4245 2021-03-02 19:31:30.209026+03:00 2021-03-02 19:31:30.209026+03:00   Searched for amsterdam london train 74461 At this general area https://www.google.com/maps/@?api=1&map_action=map&center=55.744922,37.643878&zoom=9 Based on your past activity  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE `google_activity_location_infos` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`action_id` integer,`name` text,`url` text,`source` text,`source_url` text,PRIMARY KEY (`id`),CONSTRAINT `fk_google_activity_location_infos_action` FOREIGN KEY (`action_id`) REFERENCES `google_activity`(`id`),CONSTRAINT `fk_google_activity_location_infos` FOREIGN KEY (`action_id`) REFERENCES `google_activity`(`id`));
CREATE INDEX `idx_google_activity_location_infos_deleted_at` ON `google_activity_location_infos`(`deleted_at`);