tweets

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

27 rows where "created_at" is on date 2021-12-24 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, favorite_count, favorited, retweeted, lang

is_quote_status 2 ✖

  • 0 25
  • 1 2

created_at (date) 1 ✖

  • 2021-12-24 · 27 ✖
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
1474222314095005701 swyx 33521530 2021-12-24T03:36:04+00:00 @mscccc recommended resources? just docs? good blogposts and videos?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 68] 1474106394504843266 99121168 mscccc       0 0 1 0 0   en  
1474222541191499779 swyx 33521530 2021-12-24T03:36:58+00:00 RT @swyx: Updating @KentBeck's law of Software Development: Make it work Make it right Make it fast Make it low-code* *configurable, exte… 1474082755550257152 1474082755550257152     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 8 0 1 1   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  
1474249859490521089 swyx 33521530 2021-12-24T05:25:31+00:00 Great article by @brandonbyars on when to go declarative/low code, and when to go imperative/general purpose https://martinfowler.com/articles/cant-buy-integration.html from Shannon on the @temporalio slack       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 172]             0 2 33 0 0 0 en  
1474267015334752257 swyx 33521530 2021-12-24T06:33:41+00:00 Embarrassed to learn about the :target pseudoselector so late in my webdev journey. I've written JS code to implement this exact feature when I could've just #useThePlatform'ed it 🤦🏽‍♂️ https://twitter.com/css/status/1354887812676546560 https://twitter.com/swyx/status/1474267015334752257/photo/1   1354887812676546560 1354887812676546560   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 209]             1 23 255 1 0 0 en  
1474269022195634176 swyx 33521530 2021-12-24T06:41:40+00:00 @Rich_Harris @united is this a web 3 sub tweet       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 46] 1474196154221047808 19487837 Rich_Harris       0 0 29 0 0   en  
1474271524110491649 swyx 33521530 2021-12-24T06:51:36+00:00 Strong Opinions on heading tags in HTML (h1, h2, h3, etc): - should all have id’s set - should all have discoverable anchor links (see: github markdown, or my blogposts) - (when appropriate) highlight link target, eg when one item in a multiple column layout (using :target)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 275] 1474267015334752257 33521530 swyx       0 2 25 1 0   en  
1474271770567843842 swyx 33521530 2021-12-24T06:52:35+00:00 @BenLesh ayy i made the cut       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 27] 1474180010525310990 23795212 BenLesh       0 0 1 0 0   en  
1474272125338804228 swyx 33521530 2021-12-24T06:53:59+00:00 @t3dotgg why am i everybody’s outer circle       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 42] 1474108080547786757 786375418685165568 t3dotgg       0 0 2 0 0   en  
1474273233750814725 swyx 33521530 2021-12-24T06:58:24+00:00 @t3dotgg spaces are a great twitter growth hack but a terrible listener experience and an even worse speaker experience :) respect to you for hosting them       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 154] 1474272430625411072 786375418685165568 t3dotgg       0 0 0 0 0   en  
1474275047271706626 swyx 33521530 2021-12-24T07:05:36+00:00 example of what i mean by the target/js code i wrote source: https://github.com/sw-yx/codingcareer.com/blob/master/src/components/FAQ.svelte#L101-L110 see it in action as an FAQ: https://www.learninpublic.org/#team-pricing       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 137] 1474271524110491649 33521530 swyx       0 1 9 0 0 0 en  
1474316991645245441 Gwen (Chen) Shapira 9462812 2021-12-24T09:52:16+00:00 “Your North Star metric is ‘monthly active developers’”. https://pocket.co/xhme3G ⁦@swyx⁩ is laying down the law for DevRel. Love the bold clarity.       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 146]             0 17 84 1 1 0 en  
1474324452234072064 swyx 33521530 2021-12-24T10:21:55+00:00 RT @gwenshap: “Your North Star metric is ‘monthly active developers’”. https://pocket.co/xhme3G ⁦@swyx⁩ is laying down the law for DevRel. L… 1474316991645245441 1474316991645245441     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 17 0 1 1 0 en  
1474324670329409543 swyx 33521530 2021-12-24T10:22:47+00:00 @gwenshap wow very kind words! continually humbled by the response, literally word vomited this stuff just for friends like @jkup who were about to enter devrel for the first time 😅       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 181] 1474316991645245441 9462812 gwenshap       0 0 3 0 0   en  
1474330055467667461 swyx 33521530 2021-12-24T10:44:11+00:00 @gwenshap @jkup followup questions very welcome.. need to be pushed to write this stuff since i dont like to pretend i am an expert, so i much rather try to just write something with a specific person’s question in mind and then generalize       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 239] 1474329561697599526 9462812 gwenshap       0 0 2 0 0   en  
1474349637943238657 swyx 33521530 2021-12-24T12:02:00+00:00 Free startup idea / Request for startup: Google, but with up/downvote and block buttons for domains that are low quality SEO bait.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 131]             0 27 670 0 0   en  
1474359647658147843 swyx 33521530 2021-12-24T12:41:46+00:00 @gwenshap @jkup concentric circles out. have a good product, then make content to show it off, then groom a community around your early adopters. it’s an infinite game so this is a continuous cycle but you can imagine a 80/15/5 split for early stage companies and 5/35/60 for mature ones       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 287] 1474356324213399595 9462812 gwenshap       0 0 4 0 0   en  
1474432353602732035 swyx 33521530 2021-12-24T17:30:41+00:00 @darinwf @Neeva havent, its on my todo list. hows the quality of results overall?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 81] 1474409789249646599 29407210 darinwf       0 0 0 0 0   en  
1474433287909036037 swyx 33521530 2021-12-24T17:34:24+00:00 @leewarrickjr pure css lightbox! 🤯       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 34] 1474379655490715678 15953440 leewarrickjr       0 0 7 0 0   en  
1474447132513878017 swyx 33521530 2021-12-24T18:29:24+00:00 @erikras @floydophone what if you could do it in friend groups tho       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 66] 1474429483251863571 7618412 erikras       0 0 4 0 0   en  
1474458850686160896 swyx 33521530 2021-12-24T19:15:58+00:00 @simonw trading volume != market value but yeah. 🦗       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 50] 1474222983417794562 12497 simonw       0 0 1 0 0   en  
1474432675645513738 swyx 33521530 2021-12-24T17:31:58+00:00 @rememberlenny @temporalio @ANTStorm ah super cool!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [37, 51] 1474395515513184263 1003869794 rememberlenny       0 0 1 0 0   fr  
1474297110598422530 swyx 33521530 2021-12-24T08:33:16+00:00 @mxstbr @calcsam @magicbell_io @ClerkDev @liveblocks #MaxStack       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [53, 62] 1474295510777409536 2451223458 mxstbr       0 0 3 0 0   und  
1474432139449958400 swyx 33521530 2021-12-24T17:29:50+00:00 @trun222 https://twitter.com/swyx/status/1210295490853490688?s=21   1210295490853490688 1210295490853490688   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 32] 1474412488435253249 3080674485 trun222       1 0 2 0 0 0 und  
1474433436400033794 swyx 33521530 2021-12-24T17:34:59+00:00 @vcarl_ 🔥       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 9] 1474373249848983592 72621018 vcarl_       0 0 1 0 0   und  
1474446755521466368 swyx 33521530 2021-12-24T18:27:55+00:00 @jim_ej @BrandonByars @temporalio 💯       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [34, 35] 1474444594234499072 65615053 jim_ej       0 0 0 0 0   und  
1474447267004174336 swyx 33521530 2021-12-24T18:29:57+00:00 @lewisvrobinson til!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 20] 1474366604368482305 413206572 lewisvrobinson       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]);