tweets
13 rows where favorite_count = 28
This data as json, CSV (advanced)
Suggested facets: user, source, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorited, retweeted, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1165416075028246528 | swyx 33521530 | 2019-08-25T00:10:19+00:00 | Who are your favorite developer @Instagram follows? just found @thecodercoder via the @IndieHackers podcast. and ofc @lydiahallie is a superstar everywhere she goes. Who else? I feel so out of touch on insta 😂 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 213] | 0 | 1 | 28 | 0 | 0 | en | |||||||||||
| 1287893745103286272 | swyx 33521530 | 2020-07-27T23:32:51+00:00 | @patel0phone @eriktorenberg @kevinakwok More in the "Let Non-X do X" category @Canva lets non-graphics designers do graphic design https://twitter.com/swyx/status/1176494529807028224?s=20 @webflow lets non-web-developers develop websites Why stick to B2C: @awscloud lets non-infra companies spin-up infra @uipath lets non-automation-coders automate | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [40, 320] | 1287514624523411456 | 375437722 | patel0phone | 1 | 0 | 28 | 0 | 0 | 0 | en | |||||||
| 1316808667925082112 | Guillermo Rauch 15540222 | 2020-10-15T18:30:26+00:00 | Temporal's engine is quite complex, much like React's, but the surface exposed to the developer is a beautiful "render()" function to organize your backend workflows. Check it out: https://docs.temporal.io | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 205] | 1316808667304390657 | 15540222 | rauchg | 0 | 1 | 28 | 0 | 0 | 0 | en | |||||||
| 1417165280522821632 | swyx 33521530 | 2021-07-19T16:51:47+00:00 | Why Orchestration: Every time you cross service boundaries, the probability of network or system failure increases. Instead of having every team write their own retries and timeouts and provisioning infrastructure, give them "reliability on rails". https://twitter.com/swyx/status/1417165280522821632/photo/1 | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 251] | 1417165272008433682 | 33521530 | swyx | 0 | 4 | 28 | 0 | 0 | 0 | en | |||||||
| 1424154174778843136 | swyx 33521530 | 2021-08-07T23:43:09+00:00 | TLDR of @cloudflare's solution: - introduce intuitive "locking" behavior on in-/out-bound messages based on storage operations - in-memory cache for speed and coalescing multiple writes - opt-outs for latency/memory efficiency - no breaking changes detailed yet accessible read! https://twitter.com/KentonVarda/status/1422553148099645451 | 1422553148099645451 1422553148099645451 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1 | 1 | 28 | 0 | 0 | 0 | en | |||||||||
| 1432682080912084998 | swyx 33521530 | 2021-08-31T12:30:00+00:00 | So excited to be presenting my latest talk, the Third Age of JavaScript at the @InfobipShift Conference! It will be Europe’s largest Developer conference in 2021 - hope to see you there! Learn more at https://shift.infobip.com/#devconf https://twitter.com/swyx/status/1263123032328925186 https://twitter.com/swyx/status/1432682080912084998/photo/1 | 1263123032328925186 1263123032328925186 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 249] | 1 | 3 | 28 | 0 | 0 | 0 | en | |||||||||
| 1434281732833005570 | swyx 33521530 | 2021-09-04T22:26:27+00:00 | for what its worth: I ask because I'm on my 2nd or 3rd "last job". I'm enjoying it, paycheck is addictive as heroin, but also working for/with others diffuses responsibility and there's some strange psychological block to my creativity when anyone can veto me | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [0, 259] | 1434278725210841095 | 33521530 | swyx | 0 | 0 | 28 | 0 | 0 | en | ||||||||
| 1440267058340634624 | swyx 33521530 | 2021-09-21T10:50:00+00:00 | TIL about the "DeWitt Clause": https://en.wikipedia.org/wiki/David_DeWitt#DeWitt_Clause Has there ever been a pettier mofo in tech than Larry Ellison? https://twitter.com/swyx/status/1440267058340634624/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 118] | 0 | 6 | 28 | 0 | 0 | 0 | en | ||||||||||
| 1448493065165963267 | swyx 33521530 | 2021-10-14T03:37:13+00:00 | @alex_frantic @Replit what FB internal tooling you miss the most! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 65] | 1448393410587414528 | 27622013 | alex_frantic | 0 | 0 | 28 | 0 | 0 | en | ||||||||
| 1450740609656901639 | swyx 33521530 | 2021-10-20T08:28:09+00:00 | Signal boost to the interesting work that Nicole and team are doing at Chrome with http://open-ui.org! imagine having alll these built in to the browser, its like Christmas morning https://twitter.com/stubbornella/status/1450702539347750917?s=21 https://twitter.com/swyx/status/1450740609656901639/photo/1 | 1450702539347750917 1450702539347750917 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 210] | 1450406508559101959 | 33521530 | swyx | 1 | 6 | 28 | 0 | 0 | 0 | en | ||||||
| 1462142750296530956 | Gen Ashley 32330308 | 2021-11-20T19:36:11+00:00 | #SvelteSummit Watch Party in Brooklyn, New York @SvelteSociety @SvelteSirens @sveltejs #svelte #sveltejs #javascript #typescript #webdevelopment https://twitter.com/coderinheels/status/1462142750296530956/video/1 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 145] | 1462130634835513367 | 32330308 | coderinheels | 0 | 11 | 28 | 1 | 1 | 0 | en | |||||||
| 1465604651076644868 | swyx 33521530 | 2021-11-30T08:52:33+00:00 | @anothercohen literally every single time i hear naval talking about how web3 enables composability | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 99] | 1465492222040629248 | 557440724 | anothercohen | 0 | 1 | 28 | 0 | 0 | en | ||||||||
| 1467217765727543299 | swyx 33521530 | 2021-12-04T19:42:29+00:00 | @adamwathan oh wow finally someone is saying this! So. Many. TypeScript. Debates. could just disappear if people ran tsc -w | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 123] | 1467196301238542340 | 716933677 | adamwathan | 0 | 0 | 28 | 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]);