tweets
6 rows where favorite_count = 36 and user = 33521530 sorted by lang
This data as json, CSV (advanced)
Suggested facets: is_quote_status, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1437938458786471938 | swyx 33521530 | 2021-09-15T00:36:58+00:00 | @youyuxi i’m 1000% sure this tweet is being pasted in a dozen internal slack rooms right now haha | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 97] | 1437865824690319366 | 182821975 | youyuxi | 0 | 0 | 36 | 0 | 0 | en | ||||||||
1439740066415321089 | swyx 33521530 | 2021-09-19T23:55:55+00:00 | Every time Pomp opens his mouth I lose 10 IQ points https://twitter.com/swyx/status/1439740066415321089/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 51] | 0 | 1 | 36 | 0 | 0 | 0 | en | ||||||||||
1454871289643032580 | swyx 33521530 | 2021-10-31T18:02:00+00:00 | Surprising consensus from the smartest devtools people I talk to: San Francisco is still the place to be. You’d think that this group is the most inclined to remote life and distributed companies. None of them have offices anymore. But enough is IRL they have no hesitation. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 0 | 36 | 0 | 0 | en | |||||||||||
1455340970053013508 | swyx 33521530 | 2021-11-02T01:08:20+00:00 | There’s nothing more wince inducing than listening to podcasters honestly review a product you worked on 3 years after launch and having them call out obviously bad ideas that should’ve never seen the light of day 😬☠️ my defense is i didnt know better!! now i do!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 265] | 0 | 0 | 36 | 0 | 0 | en | |||||||||||
1456718364252934147 | swyx 33521530 | 2021-11-05T20:21:37+00:00 | @amacarthur @BrendanEich i was reminded of the move back to JS by @jeanqasaur and @Rich_Harris's livestream today https://twitter.com/swyx/status/1350427690814251010 | 1350427690814251010 1350427690814251010 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [25, 137] | 1456713650962673672 | 30416123 | amacarthur | 1 | 4 | 36 | 0 | 0 | 0 | en | ||||||
1458221287428427778 | swyx 33521530 | 2021-11-09T23:53:42+00:00 | Give all @TwitterBlue users a blue checkmark and your revenue 2x's overnight, just sayin, @Twitter | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 98] | 1458219955539742724 | 33521530 | swyx | 0 | 0 | 36 | 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]);