google_activity_location_infos
2 rows where source = "Based on your past activity" sorted by id descending
This data as json, CSV (advanced)
Suggested facets: created_at (date)
updated_at (date) ✖
id ▲ | created_at | updated_at | deleted_at | action_id | name | url | source | source_url |
---|---|---|---|---|---|---|---|---|
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¢er=55.744922,37.643878&zoom=9 | Based on your past activity | ||
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¢er=55.768445,37.580154&zoom=10 | Based on your past activity |
Advanced export
JSON shape: default, array, newline-delimited, object
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`);