tweets
2 rows where possibly_sensitive = 0 and retweet_count = 56
This data as json, CSV (advanced)
Suggested facets: created_at (date)
id ▼ | user | created_at | full_text | retweeted_status | quoted_status | place | source | truncated | display_text_range | in_reply_to_status_id | in_reply_to_user_id | in_reply_to_screen_name | geo | coordinates | contributors | is_quote_status | retweet_count | favorite_count | favorited | retweeted | possibly_sensitive | lang | scopes |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1261851180881174529 | David Perell 240049622 | 2020-05-17T02:49:00+00:00 | Here are the skills you need to run an online course. They fall into four buckets: (1) business, (2) marketing, (3) entertainment, and (4) education. Traditional teachers are at a disadvantage in online education because they over-estimate the importance of teaching. https://twitter.com/david_perell/status/1261851180881174529/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 1261849798031798272 | 240049622 | david_perell | 0 | 56 | 355 | 0 | 0 | 0 | en | |||||||
1451287571481325569 | Mitchell Hashimoto 12819682 | 2021-10-21T20:41:35+00:00 | I love this “Willingness to look stupid” post. For me, I’d also flip this and say that people who go out of their way to be the smartest person in the room are a huge red flag. I’ve had an almost universally bad experience with those types of people. https://danluu.com/look-stupid/ | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 274] | 0 | 56 | 451 | 1 | 1 | 0 | en |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [tweets] ( [id] INTEGER PRIMARY KEY, [user] INTEGER REFERENCES [users]([id]), [created_at] TEXT, [full_text] TEXT, [retweeted_status] INTEGER, [quoted_status] INTEGER, [place] TEXT REFERENCES [places]([id]), [source] TEXT REFERENCES [sources]([id]), [truncated] INTEGER, [display_text_range] TEXT, [in_reply_to_status_id] INTEGER, [in_reply_to_user_id] INTEGER, [in_reply_to_screen_name] TEXT, [geo] TEXT, [coordinates] TEXT, [contributors] TEXT, [is_quote_status] INTEGER, [retweet_count] INTEGER, [favorite_count] INTEGER, [favorited] INTEGER, [retweeted] INTEGER, [possibly_sensitive] INTEGER, [lang] TEXT, [scopes] TEXT, FOREIGN KEY([retweeted_status]) REFERENCES [tweets]([id]), FOREIGN KEY([quoted_status]) REFERENCES [tweets]([id]) ); CREATE INDEX [idx_tweets_source] ON [tweets] ([source]);