2 rows sorted by created_at

View and edit SQL

Suggested facets: updated_at (date), timestamp (date)

created_at (date)

id created_at ▼ updated_at deleted_at target user_id timestamp
4 2021-03-04 17:13:18.616884+03:00 2021-03-04 17:13:18.616884+03:00   media 51 51 2021-01-05 13:20:39+00:00
5 2021-03-04 17:13:18.616884+03:00 2021-03-04 17:13:18.616884+03:00   media 53 53 2021-01-05 12:49:42+00:00

Advanced export

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

CSV options:

CREATE TABLE `instagram_likes` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`target` text,`user_id` integer,`timestamp` datetime,PRIMARY KEY (`id`),CONSTRAINT `fk_instagram_likes_user` FOREIGN KEY (`user_id`) REFERENCES `instagram_users`(`id`));
CREATE UNIQUE INDEX `instagram_likes_key` ON `instagram_likes`(`target`,`user_id`,`timestamp`);
CREATE INDEX `idx_instagram_likes_deleted_at` ON `instagram_likes`(`deleted_at`);