2 rows

View and edit SQL

Suggested facets: 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

CSV options:

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`);