8 rows

View and edit SQL

Suggested facets: created_at, updated_at, name, created_at (date)

updated_at (date)

id ▼ created_at updated_at deleted_at action_id name
2 2021-03-02 19:31:21.060933+03:00 2021-03-02 19:31:21.060933+03:00   Initiated a Takeout 3 From IP 83.220.236.197
26 2021-03-02 19:31:23.612424+03:00 2021-03-02 19:31:23.612424+03:00   Visited https://www.youtube.com/watch?v=YVYDz_coSfY 26715 From Google Ads
27 2021-03-02 19:31:23.612424+03:00 2021-03-02 19:31:23.612424+03:00   Visited Explore the Entire World--from the Comfort of Quarantine--with 4K ... 26716 From Google Ads
28 2021-03-02 19:31:23.612424+03:00 2021-03-02 19:31:23.612424+03:00   Displayed Gmail ads 26717 From Google Ads
29 2021-03-02 19:31:23.612424+03:00 2021-03-02 19:31:23.612424+03:00   Displayed Gmail ads 26718 From Google Ads
30 2021-03-02 19:31:23.612424+03:00 2021-03-02 19:31:23.612424+03:00   Displayed Gmail ads 26719 From Google Ads
31 2021-03-02 19:31:23.612424+03:00 2021-03-02 19:31:23.612424+03:00   Used com.chess.iphone 26720 From Google Ads
32 2021-03-02 19:31:23.612424+03:00 2021-03-02 19:31:23.612424+03:00   Displayed Gmail ads 26721 From Google Ads

Advanced export

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

CSV options:

CREATE TABLE `google_activity_details` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`action_id` integer,`name` text,PRIMARY KEY (`id`),CONSTRAINT `fk_google_activity_details_action` FOREIGN KEY (`action_id`) REFERENCES `google_activity`(`id`),CONSTRAINT `fk_google_activity_details` FOREIGN KEY (`action_id`) REFERENCES `google_activity`(`id`));
CREATE INDEX `idx_google_activity_details_deleted_at` ON `google_activity_details`(`deleted_at`);