2 rows where source = "Based on your past activity" sorted by deleted_at descending

View and edit SQL

Suggested facets: created_at (date)

updated_at (date)

source

  • Based on your past activity · 2
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&center=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&center=55.768445,37.580154&zoom=10 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`);