instagram_likes
2 rows sorted by id descending
This data as json, CSV (advanced)
Suggested facets: updated_at (date)
created_at (date) ✖
id ▲ | created_at | updated_at | deleted_at | target | user_id | timestamp |
---|---|---|---|---|---|---|
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 | |
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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`);