tweets

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

13 rows where "created_at" is on date 2021-08-19, 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, lang

user 2 ✖

source 1 ✖

  • Twitter Web App · 13 ✖

retweeted 1 ✖

is_quote_status 1 ✖

created_at (date) 1 ✖

  • 2021-08-19 · 13 ✖
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
1428149223850012673 swyx 33521530 2021-08-19T00:18:03+00:00 ⚛️ Using MDX to progressively upgrade Docs Links with @reactjs https://youtu.be/LbC4WZoyinI Perhaps a fun @docusaurus hack - you can swizzle MDX components and write your own custom HTML elements that enhance user experience. #extendThePlatform?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 242]             0 2 24 0 0 0 en  
1428222649721712646 swyx 33521530 2021-08-19T05:09:49+00:00 @farzad_yz @ReactRally haha on the livestream? amazing. thank you 🙏🏽       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 68] 1428216444450390022 304289713 farzad_yz       0 0 1 0 0   en  
1428241827862257664 swyx 33521530 2021-08-19T06:26:01+00:00 @jakub_smetanka @Coding_Career oh awesome news!! I'd love to read more about what really resonated with you!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [31, 108] 1428025214588366848 757480803307753472 smetankajakub_       0 0 2 0 0   en  
1428242133710934018 Kajetan Świątek 1069315566375264261 2021-08-19T06:27:14+00:00 @swyx @ReactRally Thanks! Those are perfect tips. Rushing is definitely something I do when I'm nervous. I'll try to mitigate that when rehearsing.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 148] 1428236014082924548 33521530 swyx       0 0 1 0 0   en  
1428254686138621953 swyx 33521530 2021-08-19T07:17:07+00:00 @stephsmithio @RobertCialdini Today's clip follows up to this with a much more underappreciated principle: Consistency and Commitment! https://share.transistor.fm/s/434ac6e2       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 159] 1427862892976611333 33521530 swyx       0 0 0 0 0 0 en  
1428397753827172353 swyx 33521530 2021-08-19T16:45:37+00:00 @samseely @knocklabs @WorkOS nice!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [29, 35] 1428396736259702798 29101388 samseely       0 0 2 0 0   en  
1428398804932259852 swyx 33521530 2021-08-19T16:49:48+00:00 @fortelabs checks out (chinese names often work best in groups of 4, i might market test 打造二脑 to see how people react. 打造外脑 might be more self evident at the cost of compromising "Second" for "External") https://twitter.com/swyx/status/1428398804932259852/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 204] 1428397878154698752 1909232666 fortelabs       0 0 2 0 0 0 en  
1428403597717368833 swyx 33521530 2021-08-19T17:08:50+00:00 @slightlylate I genuinely struggle with how much to care about standards. Standards are obviously extremely important. but 99.999% of us will never even be involved, much less have meta opinions on the process of rulemaking. yet we (and eventually our users) are all impacted eventually.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 287] 1428401349574623235 229237555 slightlylate       0 0 10 0 0   en  
1428412406909136897 swyx 33521530 2021-08-19T17:43:51+00:00 @acemarke @beyang @github i do wonder at the logistics of essentially scraping github/gitlab.. seems inefficient, I hope you can do a deal with them to get all this data directly @beyang       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 186] 1428403711936798723 727704217012604928 acemarke       0 0 1 0 0   en  
1428431255196995586 swyx 33521530 2021-08-19T18:58:44+00:00 For those who missed my Twitter Spaces chat on @temporalio with @jadenguitarman, here's a recording for posterity! (audio only) Temporal: Not So Temporary https://youtu.be/ErO9Ujccwds       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 179] 1417227355165102081 33521530 swyx       0 0 7 0 0 0 en  
1428470214522408962 swyx 33521530 2021-08-19T21:33:33+00:00 @brianleroux @DasSurma @jaffathecake not me getting distracted by Surma's calves hot damn he does not skip leg day https://twitter.com/swyx/status/1428470214522408962/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [37, 114] 1428461614827720705 676363 brianleroux       0 0 4 0 0 0 en  
1428472408139132961 swyx 33521530 2021-08-19T21:42:16+00:00 It pisses me off how poorly developers are taught to validate/parse inputs. Bad assumptions -> bad errors -> bad UX. That simple. If every dev spent 1 hour learning how to validate/parse their inputs properly we'd have dramatically more usable software for the rest of our lives       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 286]             0 22 292 0 0   en  
1428409475229118468 swyx 33521530 2021-08-19T17:32:12+00:00 @JustGage @sotak 🙏       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [17, 18] 1428409299953274882 17006530 JustGage       0 0 1 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]);