instagram_comments
5 rows sorted by timestamp
This data as json, CSV (advanced)
Suggested facets: user_id, created_at (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
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`);
timestamp (date) ✖