instagram_comments
1 row where "timestamp" is on date 2020-04-11 sorted by timestamp
This data as json, CSV (advanced)
Suggested facets: 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 |
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) ✖