tweets
2 rows where favorite_count = 80, retweeted = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
created_at (date) 2 ✖
- 2021-09-11 1
- 2021-09-12 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1436594934002458626 | swyx 33521530 | 2021-09-11T07:38:17+00:00 | I’d really love to hear behind the scenes on GitHub’s decision to launch this shortcut. The obvious downside: launching an expensive action on a single keypress may negatively surprise users. The upside: the barrier to using Codespaces can’t be lower. I use it once a day now. https://twitter.com/github/status/1425505817827151872 | 1425505817827151872 1425505817827151872 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 278] | 1 | 1 | 80 | 0 | 0 | 0 | en | |||||||||
1436973708304863238 | swyx 33521530 | 2021-09-12T08:43:24+00:00 | Lifechanging travel tip I am only learning too late in life: You can travel in shorts! Nothing in the flight rules that say you have to be in tight jeans or nice shoes. And most airports require waaay too much walking. (yes, looking at you, @Airport_FRA!) https://twitter.com/swyx/status/1436973708304863238/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 256] | 0 | 4 | 80 | 0 | 0 | 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]);