instagram_comments
1 row where user_id = 1
This data as json, CSV (advanced)
Suggested facets: updated_at (date), timestamp (date)
created_at (date) ✖
id ▼ | created_at | updated_at | deleted_at | target | user_id | text | timestamp |
---|---|---|---|---|---|---|---|
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`);
user_id ✖