tweets
4 rows where favorite_count = 79 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1221129594146840577 | swyx 33521530 | 2020-01-25T17:55:57+00:00 | Looking for: "the best" - obsessing over benchmarks - caring what influencers think - keeping up with new releases "good enough" - what YOU need done - what YOU know well - what YOU enjoy The more reversible the decision, the faster you should move. https://fs.blog/2018/04/reversible-irreversible-decisions/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 276] | 1221125270989692928 | 33521530 | swyx | 0 | 12 | 79 | 0 | 0 | 0 | en | |||||||
1353067401093410824 | swyx 33521530 | 2021-01-23T19:49:41+00:00 | Periodic reminder to go through your Twitter app permissions and revoke old apps. https://twitter.com/settings/connected_apps Twitter permissions never expire, so that one joke app from 2011 you tried out still has the permissions to read and create and delete your tweets, maybe DMs and follows. https://twitter.com/swyx/status/1353067401093410824/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 0 | 19 | 79 | 0 | 0 | 0 | en | ||||||||||
1445254807241912324 | swyx 33521530 | 2021-10-05T05:09:32+00:00 | One of life's best joys: take the effort to show genuine appreciation for creators whose work you enjoyed. Be specific about what you liked, and how it impacted you, in ways that cannot be faked. Authenticity shines through because it is scarce. Proof of Love > Proof of Work | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 281] | 0 | 2 | 79 | 0 | 0 | en | |||||||||||
1454261201207054339 | swyx 33521530 | 2021-10-30T01:37:43+00:00 | Soft shipped the new https://docs.temporal.io/ Many thanks to @thisismahmoud_, @flossypurse, @taillogs and others, and built with @docusaurus and now @tailwindcss Shipped fearlessly on Friday afternoon thanks to @Netlify immutable deploys 💪 https://twitter.com/swyx/status/1454261201207054339/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 240] | 0 | 7 | 79 | 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]);