instagram_comments
2 rows where "timestamp" is on date 2020-08-17
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 |
|---|---|---|---|---|---|---|---|
| 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 | |
| 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 |
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) ✖