tweets

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

21 rows where "created_at" is on date 2021-09-09, is_quote_status = 0 and retweeted = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at, source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorite_count

user 3 ✖

retweeted 1 ✖

is_quote_status 1 ✖

favorited 1 ✖

  • 0 21

created_at (date) 1 ✖

  • 2021-09-09 · 21 ✖
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
1435759393396641798 swyx 33521530 2021-09-09T00:18:09+00:00 @DotProto @timdorr yeah so lets say ownership has two levels, L1: Account owns Extension (trackable), and L2: Person/Company owns Account (not trackable). You will have notification of L1 ownership changes.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 206] 1435755027004416002 380741910 dotproto       0 0 0 0 0   en  
1435759523722113024 swyx 33521530 2021-09-09T00:18:40+00:00 @DotProto @timdorr as for L2, basically nothing short of periodic security review and Manifest v3 will do; maybe also crowdsourced (perhaps partnership) with bug bounty providers like @Hacker0x01       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 195] 1435759393396641798 33521530 swyx       0 0 0 0 0   en  
1435762052807659521 swyx 33521530 2021-09-09T00:28:43+00:00 @Nutlope @lauren_n_roth aww thanks man :) ironically #LearnInPublic is a form of engagement game... one that values quality/relationships, over quantity/short lived gratification       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 179] 1435751113223917574 3246815913 Nutlope       0 1 1 0 0   en  
1435768792395681796 swyx 33521530 2021-09-09T00:55:30+00:00 @DannPetty @designfulltime hey Dann idk if this is still in the 24 hour limit — i assume it has expired — but down here it still says $179! https://twitter.com/swyx/status/1435768792395681796/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 139] 1435377045404635138 22708585 DannPetty       0 0 3 0 0 0 en  
1435793597870321674 swyx 33521530 2021-09-09T02:34:04+00:00 Today' clip: React Native's Near Death Experience, according to @Vjeux! https://share.transistor.fm/s/ee467824 I was surprised to learn on the @sourcegraph podcast that the initial impl of Facebook Photos with RN flopped! Sometimes entire industries pivot by the decisions of a few key people.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280] 1435387866079694849 33521530 swyx       0 1 7 0 0 0 en  
1435796785323200516 swyx 33521530 2021-09-09T02:46:44+00:00 @TikTokInvestors he said he was just gonna check the price, ended up levering up at the highs, he done fucked up. intervention time IMO       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 135] 1435746451347234816 1295428909538906115 TikTokInvestors       0 0 2 0 0   en  
1435801431978635267 swyx 33521530 2021-09-09T03:05:11+00:00 1/ I'm excited to announce a new learning experience I’m launching today with @chapter_HQ. My 4 week long “chapter” includes curated content, in-depth discussion and private Q&A for your own #LearnInPublic journey! https://getchapter.app/@swyx/learn       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 243]             0 12 72 0 0 0 en  
1435801433253695491 swyx 33521530 2021-09-09T03:05:12+00:00 2/ I’ll be guiding you through all the best ideas I’ve found from the #LearnInPublic movement. My goal is to make this a community experience and inspire you to start your own blog, newsletter, meetup, YouTube, Twitch, etc.       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 223] 1435801431978635267 33521530 swyx       0 1 6 0 0   en  
1435801439331241987 swyx 33521530 2021-09-09T03:05:13+00:00 3/ I’ve handpicked 4 weeks of content, and you can expect about 90 mins/week in total. The interactions are asynchronous, which allows me to answer more of your questions. I’d love for you to join me! https://twitter.com/swyx/status/1435801439331241987/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 200] 1435801433253695491 33521530 swyx       0 0 5 0 0 0 en  
1435801440929427456 swyx 33521530 2021-09-09T03:05:14+00:00 4/ I've enjoyed working with Chapter to set this up. @KyleLadewig and @stflory have an admirable mission to make learning more accessible...chapters are 99% cheaper than other premium online cohort based courses.       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 212] 1435801439331241987 33521530 swyx       0 0 3 0 0   en  
1435801442145554443 swyx 33521530 2021-09-09T03:05:14+00:00 5/ If you like the work I do, I’d appreciate a retweet of this thread. Again, here is the invite link to register: https://getchapter.app/@swyx/learn Looking forward to seeing you in my chapter!       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 185] 1435801440929427456 33521530 swyx       0 1 4 0 0 0 en  
1435871588495286272 swyx 33521530 2021-09-09T07:43:58+00:00 @GeoffreyHuntley @gitpod hey Geoff very nice!! i realize you are focused on internal DX, whereas i do external facing DX. quite some overlaps, of course!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 153] 1435857873620197381 14961859 GeoffreyHuntley       0 0 0 0 0   en  
1435970058921066497 swyx 33521530 2021-09-09T14:15:15+00:00 @CraigCav @koop @jlongster @SlexAxton @stripe whoa amazing!! well deserved, congrats!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [46, 85] 1435741761255653384 70438825 CraigCav       0 0 2 0 0   en  
1435971765000417281 swyx 33521530 2021-09-09T14:22:02+00:00 @livelovegeek @gurlcode doesnt get enough love for the sheer amount of storytelling work that goes into her talks https://youtu.be/U_ABIfnsVU4       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 137] 1435725632319606786 119275747 livelovegeek       0 0 13 0 0 0 en  
1435996032748429318 swyx 33521530 2021-09-09T15:58:28+00:00 @danciupuliga @eggheadio thanks for the shoutout!! i was expecting that this would be super niche (who builds CLIs that often?), but i keep getting nice shoutouts from folks like you that it is really encouraging :)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 215] 1435995667516821505 12036572 danciupuliga       0 0 1 0 0   en  
1436011709865603075 TechCrunch 816653 2021-09-09T17:00:46+00:00 Open source backend-as-a-service startup Supabase raises $30M https://tcrn.ch/2YLJkEJ by @grg       SocialFlow 99073d76dd39fa0b448b0d78765cf615980271d1 0 [0, 93]             0 96 529 0 0 0 en  
1436016314158616581 swyx 33521530 2021-09-09T17:19:03+00:00 I saw the best minds of my generation destroyed by FOMO shallow, excitable, distracted feverishly refreshing at dawn looking for the next hotness angel-investing hipsters swapping universe for metaverse creation for metacreation social for parasocial       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 256]             0 5 110 0 0   en  
1436022859797782528 swyx 33521530 2021-09-09T17:45:04+00:00 @TechCrunch @supabase @Grg huge congrats team!! still Day 1.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [27, 60] 1436011709865603075 816653 TechCrunch       0 0 8 0 0   en  
1436033040938147843 swyx 33521530 2021-09-09T18:25:31+00:00 @millertime802_ @VictorPontis @LumaHQ same here. on ios safari.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 63] 1436021436439842819 341898673 millertime802_       0 0 0 0 0   en  
1436065787408633857 Lee Edwards 14829286 2021-09-09T20:35:39+00:00 Probably would straight up invest $1-2M in any Developer Experience (DX) or Devrel expert starting a devtools company with a strong engineering cofounder in a space that’s 1) big, 2) not crowded to the point of being commoditized. That’s probably all I’d need to see. Just saying.     San Francisco 5a110d312052166f Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             0 15 139 0 0   en  
1435934910125158407 swyx 33521530 2021-09-09T11:55:35+00:00 gm https://twitter.com/swyx/status/1435934910125158407/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 2]             0 0 151 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]);