1 row where "created_at" is on date 2021-03-02, source = "From your Location History" and "updated_at" is on date 2021-03-02 sorted by deleted_at

View and edit SQL

updated_at (date)

  • 2021-03-02 · 1

created_at (date)

  • 2021-03-02 · 1
id created_at updated_at deleted_at ▼ action_id name url source source_url
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

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