tweets

This is data scraped from swyx's timeline! See blog post

21 rows where favorite_count = 0, favorited = 0, is_quote_status = 1 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, retweeted

lang 2 ✖

source 1 ✖

  • Twitter Web App · 21 ✖

is_quote_status 1 ✖

favorited 1 ✖

favorite_count 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
1428402450839457800 swyx 33521530 2021-08-19T17:04:17+00:00 RT @beyang: Super happy that a lot of these efforts are now well under way. Especially excited about indexing the entire world of open sour… 1428402268550754304 1428402268550754304     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 4 0 0 1   en  
1430991697513619456 swyx 33521530 2021-08-26T20:33:01+00:00 apparently access points are a big bottleneck too! https://twitter.com/ForbesLindesay/status/1430989747829284865?s=20   1430989747829284865 1430989747829284865   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 74] 1428861510164520960 33521530 swyx       1 0 0 0 0 0 en  
1432864823654555652 swyx 33521530 2021-09-01T00:36:09+00:00 @paulbiggar tweeted as thread for comments if any :) https://twitter.com/swyx/status/1432864028842356736?s=20   1432864028842356736 1432864028842356736   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 76] 1432719949575905289 86938585 paulbiggar       1 0 0 0 0 0 en  
1433260750659731468 swyx 33521530 2021-09-02T02:49:26+00:00 @scmn 💪 Learn in Public! https://twitter.com/swyx/status/1009174159690264579?s=20   1009174159690264579 1009174159690264579   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 49] 1433258226125058050 21463169 scmn       1 0 0 0 0 0 en  
1438171474506907653 swyx 33521530 2021-09-15T16:02:54+00:00 @rasharm_ try it for yourself and see if a couple of CLI commands is remotely on the same planet https://twitter.com/swyx/status/1438164876975751178?s=20   1438164876975751178 1438164876975751178   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 120] 1438166345296666627 380739301 rasharm_       1 0 0 0 0 0 en  
1438226023720517633 swyx 33521530 2021-09-15T19:39:39+00:00 @PaulieScanlon @GatsbyJS @sveltejs i like it :) https://twitter.com/swyx/status/1221586490674696193?lang=en   1221586490674696193 1221586490674696193   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [35, 71] 1438225647340605447 470012453 PaulieScanlon       1 0 0 0 0 0 en  
1439026846549495812 swyx 33521530 2021-09-18T00:41:50+00:00 RT @swyx: How @Temporalio Works: 1. Write async code with SDK 2. Temporal Server handles queues, timers, retries, timeouts, heartbeats. Ch… 1438939235801653249 1438939235801653249     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 12 0 0 1   en  
1439942768017747969 swyx 33521530 2021-09-20T13:21:23+00:00 big spike in cases now. lets hope deaths curve stays flat. https://twitter.com/ianmSC/status/1439650247253233664?s=20   1439650247253233664 1439650247253233664   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 83] 1346232948392042498 33521530 swyx       1 0 0 0 0 0 en  
1439976474623234050 swyx 33521530 2021-09-20T15:35:19+00:00 RT @tannerlinsley: "GraphQL helps solve the overfetching problem. In practice, I think the importance of this is overhyped unless you are F… 1439976152995545090 1439976152995545090     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 29 0 0 1   en  
1440042154999435271 swyx 33521530 2021-09-20T19:56:19+00:00 Essay #1 published https://twitter.com/swyx/status/1439966955570618376   1439966955570618376 1439966955570618376   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 42] 1408321661946970112 33521530 swyx       1 0 0 0 0 0 en  
1441072853168840705 swyx 33521530 2021-09-23T16:11:56+00:00 RT @brianleroux: This in no way assuaged my overall skepticism but super appreciate the hype-free honesty of the current state of "web3". M… 1441062360811143175 1441062360811143175     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 3 0 0 1   en  
1445565723502264331 swyx 33521530 2021-10-06T01:45:00+00:00 RT @kristoferbaxter: Some of the best writing in our industry comes from @swyx. This is yet another great read. 1445564661965807617 1445564661965807617     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 111]             1 1 0 0 1   en  
1449105641797128192 swyx 33521530 2021-10-15T20:11:22+00:00 RT @ChibuzorObilom: I've always believed that the 80/20 rule is grossly misunderstood or misrepresented. There's nothing like doing only 2… 1449103297839763459 1449103297839763459     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 0 1   en  
1449117060265492481 swyx 33521530 2021-10-15T20:56:45+00:00 RT @threepointone: Really good talk. This is a great slide demonstrating their programming model; to do a recurring subscription, you liter… 1449112317917110276 1449112317917110276     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 0 1   en  
1450203732956758016 swyx 33521530 2021-10-18T20:54:48+00:00 RT @GatsbyJS: "The following is my conversation with @AbhiAiyer and @wardpeet, two lead engineers behind Gatsby Cloud and the recently anno… 1450202214664921088 1450202214664921088     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 5 0 0 1   en  
1450334616754147330 swyx 33521530 2021-10-19T05:34:53+00:00 @mxmzb @Cloudflare @pimterry @netlify analytics, they were kind enough to give me a lifetime alumni account so i shout them out whenever i can https://twitter.com/swyx/status/1262696057609187330   1262696057609187330 1262696057609187330   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [29, 166] 1450333793223467013 17230506 mxmzb       1 0 0 0 0 0 en  
1455699258531729411 swyx 33521530 2021-11-03T00:52:03+00:00 this is the only public recording of the Feature Mapping talk I referred to in this chat https://twitter.com/swyx/status/1453508738241814533   1453508738241814533 1453508738241814533   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 112] 1455612998265884678 33521530 swyx       1 0 0 0 0 0 en  
1468016622061326337 swyx 33521530 2021-12-07T00:36:51+00:00 @erikaybar_ @taniarascia @contentful @builderio @SplitSoftware @temporalio @tangramdotdev @supabase @Firebase i discussed @buckymoore's SDKs over APIs thesis here at the 27ish minute mark! https://twitter.com/swyx/status/1467978846150430724   1467978846150430724 1467978846150430724   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [110, 212] 1453020854757953543 33521530 swyx       1 0 0 0 0 0 en  
1473099096601034753 swyx 33521530 2021-12-21T01:12:48+00:00 @EssentialRandom if you care to go *even further* back, Jeff Barr initially called it "Muck", way back when: https://twitter.com/swyx/status/1374085674005983233 @mjasay can correct me but UHL as a term only came into vogue in the last 5ish years, dont know the exact origin   1374085674005983233 1374085674005983233   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [17, 246] 1473097945637552130 1069017063111282689 EssentialRandom       1 0 0 0 0 0 en  
1432796518281453570 swyx 33521530 2021-08-31T20:04:44+00:00 @CntrvaslDev it's @temporalio ! https://twitter.com/swyx/status/1417165270641045505   1417165270641045505 1417165270641045505   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 56] 1432791593396936704 930727203876364289 CntrvaslDev       1 0 0 0 0 0 und  
1473026177833275392 swyx 33521530 2021-12-20T20:23:02+00:00 @buildsghost @tmcw https://twitter.com/swyx/status/1142025639744008194   1142025639744008194 1142025639744008194   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 42] 1473025536419004416 1175464650395111424 buildsghost       1 0 0 0 0 0 und  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);