tweets

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

11 rows where favorite_count = 15, retweet_count = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, is_quote_status, created_at (date)

lang 2 ✖

retweeted 1 ✖

  • 0 11

favorite_count 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
1425716946977185793 swyx 33521530 2021-08-12T07:13:03+00:00 Every few months I marvel at the perfect timing of the releases of AWS Lambda (max lock in) and Kubernetes (min lock in) and how they make total sense given each cloud’s position. Behind the scenes tech strategists are playing a giant game of 4D chess and we are the pawns.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 274]             0 0 15 0 0   en  
1425924327027838977 swyx 33521530 2021-08-12T20:57:06+00:00 @_developit @jlongster when i grow up i want to be half as cool as jlongster       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [23, 76] 1425880247799517189 16495353 _developit       0 0 15 0 0   en  
1429607755770331140 swyx 33521530 2021-08-23T00:53:44+00:00 of course it was from @benthompson: https://stratechery.com/2018/techs-two-philosophies/ (thanks to @jtao_) he identifies a few other points: - the Jobs school is older - platforms skew Jobsian, aggregators skew Zuckerist - the business model follows (paid vs ads) - they aren’t at odds; we need both https://twitter.com/swyx/status/1429607755770331140/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 273] 1429536652196651012 33521530 swyx       0 0 15 0 0 0 en  
1430949617928048646 swyx 33521530 2021-08-26T17:45:49+00:00 There are exceptions to every rule, a synthesis to be drawn from every dialectic. I think founders who can blend the strategy of scale and the tactics of scrappiness do very well. People like @callmevlad, @agazdecki, the @supabase team, everyone in the @tylertringas portfolio.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 279] 1430949616371961862 33521530 swyx       0 0 15 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  
1434429326036983811 swyx 33521530 2021-09-05T08:12:56+00:00 @supabase live footage of Supabase team knocking out milestones https://twitter.com/swyx/status/1434429326036983811/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 63] 1434420702677913608 1219566488325017602 supabase       0 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  
1443034568978620419 swyx 33521530 2021-09-29T02:07:06+00:00 @samselikoff most annoying thing about create react app (i think) is it validates package json making you scared to do stuff like this when thats not its job       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 157] 1443031859663937541 131941348 samselikoff       0 0 15 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  
1474225956504031235 swyx 33521530 2021-12-24T03:50:32+00:00 @dan_abramov 🥲 i promise i still really do love React       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 53] 1473699470307217413 70345946 dan_abramov       0 0 15 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  

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