5 rows sorted by timestamp

View and edit SQL

Suggested facets: user_id, created_at (date), timestamp (date)

updated_at (date)

id created_at updated_at deleted_at target user_id text timestamp ▼
18 2021-03-04 17:13:18.328833+03:00 2021-03-04 17:13:18.328833+03:00   media 16 16 @sof_titova в кругосветку 2020-04-11 17:48:55+00:00
13 2021-03-04 17:13:18.326728+03:00 2021-03-04 17:13:18.326728+03:00   media 4 4 @juliomexica я тоже с тобой! очень давно не виделись! 2020-07-24 20:07:42+00:00
6 2021-03-04 17:13:18.325084+03:00 2021-03-04 17:13:18.325084+03:00   media 4 4 @dilidilidon да, там качели, скамейки, вода, танцы, люди и все это 2020-08-17 12:22:45+00:00
5 2021-03-04 17:13:18.324639+03:00 2021-03-04 17:13:18.324639+03:00   media 4 4 @goshaginyan пока Донер42 не открыли, да, лучшее 2020-08-17 13:11:47+00:00
1 2021-03-04 17:13:18.321517+03:00 2021-03-04 17:13:18.321517+03:00   media 1 1 No one when they meet aliens: Lex Fridman: “What is the meaning of life?” 2020-12-08 17:50:15+00:00

Advanced export

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

CSV options:

CREATE TABLE `instagram_comments` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`target` text,`user_id` integer,`text` text,`timestamp` datetime,PRIMARY KEY (`id`),CONSTRAINT `fk_instagram_comments_user` FOREIGN KEY (`user_id`) REFERENCES `instagram_users`(`id`));
CREATE UNIQUE INDEX `instagram_comments_key` ON `instagram_comments`(`target`,`user_id`,`text`,`timestamp`);
CREATE INDEX `idx_instagram_comments_deleted_at` ON `instagram_comments`(`deleted_at`);