tweets

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

11 rows where favorite_count = 15, is_quote_status = 1 and retweeted = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, retweet_count

lang 3 ✖

retweeted 1 ✖

is_quote_status 1 ✖

place 0 ✖

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
1419836176681213952 swyx 33521530 2021-07-27T01:44:58+00:00 Suddenly reminded of this @bcantrill talk: https://youtu.be/30jNsCVLpAE and I think I have my answer - If it takes you 2 days to chase down an intermittent bug, perhaps that *IS* the bug. Even though this talk is 4 years old but feels like @mipsytipsy is beating the same drum today. https://twitter.com/swyx/status/1419434119319093250   1419434119319093250 1419434119319093250   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 3 15 0 0 0 en  
1425512518437330944 swyx 33521530 2021-08-11T17:40:43+00:00 Proud to be joining a conference that is taking measured Covid precautions. If you're in the East Coast, come see my first ever talk on @temporalio and the *amazing* list of other speakers at @renderATL! https://www.renderatl.com/speakers https://twitter.com/ThugDebugger/status/1425477419524308994   1425477419524308994 1425477419524308994   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 228]             1 2 15 0 0 0 en  
1433919002355507201 swyx 33521530 2021-09-03T22:25:05+00:00 casual reminder that extrinsic motivation isn’t harmless, nice to have, or ignorable. They *actively destroy* intrinsic drive. https://twitter.com/swyx/status/968688836468453376?s=21   968688836468453376 968688836468453376   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 151] 1433918146348343297 33521530 swyx       1 0 15 0 0 0 en  
1436232321271746561 swyx 33521530 2021-09-10T07:37:23+00:00 First time founders obsess about product. Second time founders obsess about distribution. Great cofounder pairs bundle both. https://twitter.com/terronk/status/1436065787408633857   1436065787408633857 1436065787408633857   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 126]             1 0 15 0 0 0 en  
1448047600318365697 swyx 33521530 2021-10-12T22:07:05+00:00 @temporalio The rest of OSS startup moat I reckon comes down to 2 things: - Sweat the DX: Intuitive, honest docs. Treating onboarding like game design. Handling exceptions (https://twitter.com/swyx/status/1294689838872981506?lang=en). Build a media company around domain, then build community. Mindshare -> market share.   1294689838872981506 1294689838872981506   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 289] 1448044941679022083 33521530 swyx       1 4 15 0 0 0 en  
1452039338619899913 swyx 33521530 2021-10-23T22:28:50+00:00 @ChopFitzroy @kyleshevlin here https://twitter.com/swyx/status/1420211877276049408   1420211877276049408 1420211877276049408   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 30] 1452034379446816768 955233524587483136 ChopFitzroy       1 0 15 0 0 0 en  
1455820522915127299 swyx 33521530 2021-11-03T08:53:55+00:00 Hard to read but handy report for Community Builders. Some picks: - Typical community spans 6 platforms - Community builders use 13 tools, try 3, no integration - @circleapp has 19% market share!? 🤯 - Chat > Social media > Email > Events Dark horses: Affiliates, QoTD, Advocacy https://twitter.com/OrbitModel/status/1455535930660564995 https://twitter.com/swyx/status/1455820522915127299/photo/1   1455535930660564995 1455535930660564995   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 311]             1 1 15 0 0 0 en  
1462975159548088332 swyx 33521530 2021-11-23T02:43:53+00:00 P.S. if you want to see the latest in JS reinvention come join the @temporalio meetup tomorrow where we are launching our new TypeScript SDK in beta! https://twitter.com/temporalio/status/1462970544379162627   1462970544379162627 1462970544379162627   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 149] 1462923803189645315 33521530 swyx       1 2 15 0 0 0 en  
1463266140847677454 swyx 33521530 2021-11-23T22:00:08+00:00 And now @SvelteSociety gets its own fulltime Technical Community Builder in @kevmodrome! https://twitter.com/kevmodrome/status/1463151477174714373?s=20   1463151477174714373 1463151477174714373   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 113] 1458693704764383241 33521530 swyx       1 1 15 0 0 0 en  
1465448848285835265 swyx 33521530 2021-11-29T22:33:26+00:00 Rich Harris vs Nouveau Riche Harris https://twitter.com/iltimasdoha/status/1462478790509182984       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 35] 1462141656916967426 33521530 swyx       1 0 15 0 0 0 fr  
1432931687441133568 swyx 33521530 2021-09-01T05:01:51+00:00 @chantastic https://twitter.com/swyx/status/1372013877731368961?s=20   1372013877731368961 1372013877731368961   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 35] 1432930900325535750 12745092 chantastic       1 0 15 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]);