tweets

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

10 rows where favorite_count = 11 and retweet_count = 1 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorited, retweeted

retweet_count 1 ✖

favorite_count 1 ✖

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
1427353055519920136 swyx 33521530 2021-08-16T19:34:22+00:00 Ultimately I hope for more intellectual honesty in this industry between merely "justifying your existence" and enabling creative risktaking and building multi-year relationships that don't fit in OKR review cycles. You can read more here: https://www.swyx.io/measuring-devrel/ https://twitter.com/swyx/status/1427353055519920136/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 264] 1427351643985629212 33521530 swyx       0 1 11 0 0 0 en  
1438972757862191106 Hillel 397782926 2021-09-17T21:06:54+00:00 Audiences also have different *purposes*. The docs for a software package change if the reader's purpose is to: * Use it on a new project * Understand its use in an existing project * Write plugins for it * Teach others how to use it * Port it to a different language       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 268] 1438972755848880133 397782926 hillelogram       0 1 11 0 0   en  
1451461828819652612 swyx 33521530 2021-10-22T08:14:01+00:00 @AntWilson try to make more friends outside of work. #learninpublic. force myself to date more. recognize that i was really freaking good at coding compared to most people and believe that i could change careers despite not having a degree. learn guitar/piano. buy bitcoin.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 273] 1451460743459577862 22399680 AntWilson       0 1 11 0 0   en  
1452490390871822342 swyx 33521530 2021-10-25T04:21:09+00:00 @dr IMO Ikigai is overrated. People often exoticize Ikigai as the ultimate solution to life, the universe and everything. But long tail creator economy has collapsed “What the world needs” with “What you can be paid for.” And you will come to love what you are good at. KISS.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [4, 279] 1452476597076783106 5264 dr       0 1 11 0 0   en  
1457501358102249474 swyx 33521530 2021-11-08T00:12:57+00:00 Sending out next newsletter soon! https://www.getrevue.co/profile/swyx?via=twitter-profile-webview Something I've been thinking about for a while - why getting good at events is so important for devrel/marketing/community/whatever https://twitter.com/swyx/status/1457501358102249474/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 191]             0 1 11 0 0 0 en  
1459274455583281160 Jakub Neander (Zaiste) 112849341 2021-11-12T21:38:36+00:00 Tomorrow (Nov 13) at 11am PT / 8pm CET together with @swyx we will be discussing React Server Components in Next.js 12 (a feature currently in alpha) along with a coding session ➝ re-doing the official notes demo from the React.js team See you! https://www.youtube.com/watch?v=qIPWzRvPSxk       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 270]             0 1 11 1 1 0 en  
1465589050652303363 swyx 33521530 2021-11-30T07:50:33+00:00 The production quality on this one is epic. I don’t think i’ve seen a better conference opener in the last 10 years. congrats @webflow and seriously @mcguirebrannon is a *superstar* 🤯 https://twitter.com/webflow/status/1461052708400549891   1461052708400549891 1461052708400549891   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 184]             1 1 11 0 0 0 en  
1466447833154740227 swyx 33521530 2021-12-02T16:43:03+00:00 🏆 Best Business/Crypto Podcast Finds of 2021 - Business Breakdowns by @jspujji @joincolossus - The @BreakdownNLW by @NLW - Not Boring by @packym - @BanklessHQ https://twitter.com/swyx/status/1466447833154740227/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 159] 1466447829149237249 33521530 swyx       0 1 11 0 0 0 en  
1466447837193854979 swyx 33521530 2021-12-02T16:43:04+00:00 🏆 Best Creator Podcast Finds of 2021 - Creator Lab by @bzaidi - Masters of Community by @DavidSpinks - Talking Too Loud by @csavage - Brains by @csallen @julian - Not Overthinking by @AliAbdaal @taimurabdaal https://twitter.com/swyx/status/1466447837193854979/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 208] 1466447833154740227 33521530 swyx       0 1 11 0 0 0 en  
1466996913153007617 swyx 33521530 2021-12-04T05:04:54+00:00 Relay compiler has been completely rewritten in Rust. “TL;DR: The main goal was drastically improve the speed of the build step.” https://twitter.com/RelayFramework/status/1466875921818861577   1466875921818861577 1466875921818861577   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 130] 1458910483176517632 33521530 swyx       1 1 11 0 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]);