twitter_likes
2 rows
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
| id ▼ | created_at | updated_at | deleted_at | tweet_id | full_text | expanded_url |
|---|---|---|---|---|---|---|
| 1 | 2021-02-22 22:06:09.005761+03:00 | 2021-02-22 22:06:09.005761+03:00 | 1327267779129401346 1327267779129401346 | How it started: 3 Asian-American guys delivering falafels at Stanford. How it’s going: https://t.co/RCX0C5LaPF | https://twitter.com/i/web/status/1327267779129401346 | |
| 2 | 2021-02-22 22:06:09.005761+03:00 | 2021-02-22 22:06:09.005761+03:00 | 1329459812464209920 1329459812464209920 | My professor is absolutely too pure for this world😢❤️ https://t.co/jrXRifFnp8 | https://twitter.com/i/web/status/1329459812464209920 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE `twitter_likes` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`tweet_id` integer UNIQUE,`full_text` text,`expanded_url` text,PRIMARY KEY (`id`),CONSTRAINT `fk_twitter_likes_tweet` FOREIGN KEY (`tweet_id`) REFERENCES `twitter_tweets`(`id`)); CREATE INDEX `idx_twitter_likes_deleted_at` ON `twitter_likes`(`deleted_at`);