tweets

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

10 rows where "created_at" is on date 2021-09-11, is_quote_status = 0, retweeted = 0 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" 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, favorite_count

user 2 ✖

source 1 ✖

  • Twitter Web App · 10 ✖

is_quote_status 1 ✖

created_at (date) 1 ✖

  • 2021-09-11 · 10 ✖
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
1436628297039982592 swyx 33521530 2021-09-11T09:50:51+00:00 Incredible discussion of platform economics and YouTube optimization by @veritasium: https://www.youtube.com/watch?v=S2xHZPH5Sng Non-obvious conflict: subscriptions (follows) vs recommendations (feed). Every ad supported platform wants to maximize time on site, which means the feed eventually wins.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 3 29 0 0 0 en  
1436628890978500609 swyx 33521530 2021-09-11T09:53:13+00:00 @AgentConf @nikgraf 😍 one of my bucket list conferences!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [20, 56] 1436616592612380676 765634822857453568 AgentConf       0 2 7 0 0   en  
1436643604085235714 swyx 33521530 2021-09-11T10:51:41+00:00 @smc90 tries to get @BillCarr89 to defend "Are Right A Lot" in this podcast/blogpost on Future dot com and i'm sorry but blaming your direct reports for letting you ignore them is pretty damn toxic wtf https://future.a16z.com/podcasts/working-backwards-amazon-bezos-memos-releases-narratives/ https://twitter.com/swyx/status/1436643604085235714/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 226] 1390439828571922432 33521530 swyx       0 0 11 0 0 0 en  
1436704692868993034 swyx 33521530 2021-09-11T14:54:26+00:00 @therealboone progress is progress! what were the remaining things you couldn't take out?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 89] 1436703800442634244 35840006 therealboone       0 0 3 0 0   en  
1436708762115473411 Alex Russell 229237555 2021-09-11T15:10:36+00:00 @swyx <but_why.gif> https://twitter.com/slightlylate/status/1436708762115473411/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 25] 1436707990933958657 229237555 slightlylate       0 3 38 0 0 0 en  
1436716757436321799 swyx 33521530 2021-09-11T15:42:22+00:00 @rauchg @leeerob yeah i don't doubt that switching from CSR to SSR was the unmitigated win here. Still they have characterized it as "initial required JS", sounds like you would have phrased it differently. also no way Nextjs takes up 800kb, something else is going on that they couldnt rip out       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [17, 294] 1436710278494707719 15540222 rauchg       0 0 8 0 0   en  
1436718275585523730 swyx 33521530 2021-09-11T15:48:24+00:00 @slightlylate the reason i suggested templatizing, is your longform commentary on why X is bad and what could be done better is very valuable. webpagetest speaks to perf experts, but the rest of us have no idea what to do with all the info. maybe inject some humor to make it more appealing.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 291] 1436716663013928961 229237555 slightlylate       0 0 3 0 0   en  
1436721365495783425 swyx 33521530 2021-09-11T16:00:41+00:00 @jbeeko @k_cieslak oh! thats a great shoutout, thank you! 1:5 is aggressive; did he base it on any data or just vague intuition?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 128] 1436721086075310084 551307316 jbeeko       0 0 0 0 0   en  
1436723434659237894 swyx 33521530 2021-09-11T16:08:54+00:00 @NHeinDev twitter search :) https://twitter.com/search?q=from%3Aswyx%20narrow%20interests&src=typed_query       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 51] 1436721662704107522 1333059155154907138 NHeinDev       0 0 1 0 0 0 en  
1436724263919263747 swyx 33521530 2021-09-11T16:12:12+00:00 @slightlylate when i find an example from another field i'll double back and try to show instead of tell. i see these sorts of things in SEO assessment tools every now and then. but the gentle nudging humor is rare.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 215] 1436722125025411078 229237555 slightlylate       0 0 1 0 0   en  

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