tweets
6 rows where favorite_count = 13 and retweeted = 1
This data as json, CSV (advanced)
Suggested facets: source, retweet_count, favorited, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1435258266729205762 | Gil Tayar 8373052 | 2021-09-07T15:06:51+00:00 | VCs are coming to Javascript tooling. Worrying or great for the ecosystem? Good question from @swyx. Lots of good takes on the directions js should go. https://twitter.com/giltayar/status/1435258266729205762/photo/1 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 153] | 0 | 2 | 13 | 0 | 1 | 0 | en | ||||||||||
1435324306238619649 | Brian LeRoux 676363 | 2021-09-07T19:29:16+00:00 | I've been thinking about @swyx's 'self provisioning runtime' thought experiment a bunch. while I do think 'self provisioning' is a nice concept but believe we would want this to be explicit, not implicit. 1/? https://www.swyx.io/self-provisioning-runtime/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 233] | 0 | 2 | 13 | 0 | 1 | 0 | en | ||||||||||
1440666213382717453 | Sean C Davis 23583938 | 2021-09-22T13:16:06+00:00 | I really this article from @swyx because it reframes the GraphQL vs REST debate. There's much more nuance to the conversation on how data is passed between the client and the server, and this essay summarizes it well. https://www.swyx.io/client-server-battle/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 242] | 0 | 2 | 13 | 0 | 1 | 0 | en | ||||||||||
1445463239475621898 | Randall 206918128 | 2021-10-05T18:57:46+00:00 | Today at 2pm PT! And it’s actually my very first Twitter space. https://twitter.com/i/spaces/1rmGPgLvlgmKN https://twitter.com/RandallKanna/status/1445463239475621898/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 88] | 0 | 1 | 13 | 0 | 1 | 0 | en | ||||||||||
1457466032365445120 | Zev Averbach 38199764 | 2021-11-07T21:52:35+00:00 | gratitude to @swyx for his excellent, usually bite-sized podcast: https://swyx.transistor.fm/ always amazed by his prolificity, but the value he crams into these 10-minute episodes is 🔥 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 183] | 0 | 2 | 13 | 1 | 1 | 0 | en | ||||||||||
1465439478269493258 | Temporal 1204202807298969600 | 2021-11-29T21:56:12+00:00 | Ever find a race condition bug and then look again, only to see that it is gone? 😱 This exact thing happened to @christoomey of the @_bikeshed recently, and we recorded a great followup discussion with Sidekiq and Temporal experts! ft. @ANTstorm @mfateev https://www.youtube.com/watch?v=Rr4DnHmy6eE | Agorapulse app 86e9766d5e36b5847fe04f82904117b15d8fde9c | 0 | [0, 279] | 0 | 4 | 13 | 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]);