2 rows where "created_at" is on date 2021-03-02 and source = "Based on your past activity" sorted by source descending

View and edit SQL

Suggested facets: updated_at (date)


  • Based on your past activity · 2

created_at (date)

  • 2021-03-02 · 2
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  
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`);