tweets

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

18 rows where "created_at" is on date 2021-11-10 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, is_quote_status, retweet_count, lang

created_at (date) 1 ✖

  • 2021-11-10 · 18 ✖
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
1458222966760624128 swyx 33521530 2021-11-10T00:00:22+00:00 @jdan @TwitterBlue @stripe stripe checkout, not all stripe       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 58] 1458222162595225600 23481558 jdan       0 0 1 0 0   en  
1458230355731779589 swyx 33521530 2021-11-10T00:29:44+00:00 @daniellexo @angieidunno wow.. sounds like this is a more common practice than i thought!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 89] 1458229974335324161 13234492 daniellexo       0 0 2 0 0   en  
1458241442883653641 swyx 33521530 2021-11-10T01:13:47+00:00 Excellent read as usual by @Eugenewei: https://www.eugenewei.com/blog/2021/9/29/and-you-will-know-us-by-the-company-we-keep Elements of Offensive Graph Design - Social capital vs Entertainment vs Utility: Pick 2 - Social network to solve cold start - Interest network to solve churn - To build: pruners, filters, recommenders, collaboration https://twitter.com/swyx/status/1458241442883653641/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 0 17 0 0 0 en  
1458243441746350080 swyx 33521530 2021-11-10T01:21:44+00:00 @eugenewei Graph design feels like a one way door. Dimensions to consider: - Self-reinforcing intial perception (Pinterest) - 1:1 vs Broadcast as core interaction? - Create vs Consume ratio? - Gather by Social, Interest, Org, Geo? - Trust system? - Content sources? - Subgroups (Reed's law) https://twitter.com/swyx/status/1458243441746350080/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 291] 1458241442883653641 33521530 swyx       0 0 3 0 0 0 en  
1458248502941609986 swyx 33521530 2021-11-10T01:41:50+00:00 @Nutlope @alexdgus you're allowed to change it, just change it everywhere and make it mean something (joining nextjs is a pretty good reason)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 141] 1458247942029160454 3246815913 Nutlope       0 0 2 0 0   en  
1458248761906368519 swyx 33521530 2021-11-10T01:42:52+00:00 @brianleroux @seldo @trevnorris @andrestaltz ruined js promises for me forever https://staltz.com/promises-are-not-neutral-enough.html       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [32, 102] 1458248186611441667 676363 brianleroux       0 0 9 0 0 0 en  
1458249896792772609 swyx 33521530 2021-11-10T01:47:23+00:00 @ken_wheeler just make an alt like @threepointone and go ham, you need an outlet       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 80] 1458249683831336963 167193309 ken_wheeler       0 0 5 0 0   en  
1458293478618660871 swyx 33521530 2021-11-10T04:40:33+00:00 @rmoh01 @AndrewSweet ew bring back OPIM!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 40] 1458252241454862338 805937038109396992 rmoh01       0 0 0 0 0   en  
1458484635952836612 swyx 33521530 2021-11-10T17:20:09+00:00 @florinpop1705 you'll only keep at it if you would do it without anyone reading anyway       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 86] 1458482517967843331 861320851 florinpop1705       0 1 32 0 0   en  
1458498453948960769 swyx 33521530 2021-11-10T18:15:03+00:00 @theSamParr this message needs the @ShaanVP hollywood treatment to catch on!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 76] 1458497180050890753 625733783 theSamParr       0 0 4 0 0   en  
1458501680601784323 swyx 33521530 2021-11-10T18:27:52+00:00 @jbrancha haha this was my original @temporalio pitch to @kentcdodds, fast forward ~3 months and we still havent done it yet but its coming (it was a bad pitch.. mocking time is only a small part of what we do, but i thought it was a good idea at the time)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 257] 1458497441876090884 190881605 jbrancha       0 0 1 0 0   en  
1458510625332600836 swyx 33521530 2021-11-10T19:03:25+00:00 Thrilled for @temporalio to make @theinformation's Most Promising Startups list! https://www.theinformation.com/ti50 As an open source devtools company is near impossible to get mainstream media interest in us compared to consumer, crypto, fintech, and AI startups wagmi https://twitter.com/swyx/status/1458510625332600836/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 262]             0 4 18 0 0 0 en  
1458517377671307270 swyx 33521530 2021-11-10T19:30:15+00:00 @dabit3 @jake_burden_ @seldo 🙋‍♂️ prefer zoom over spaces because less need to react to audience       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [29, 96] 1458501299289346048 17189394 dabit3       0 0 2 0 0   en  
1458525897103851523 swyx 33521530 2021-11-10T20:04:06+00:00 @adamwathan ah my biweekly dose of "did i accidentally send my newsletter twice?" self doubt       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 92] 1458522772691423234 716933677 adamwathan       0 0 4 0 0   en  
1458556310396420109 swyx 33521530 2021-11-10T22:04:57+00:00 @philnash @TwitterBlue @stripe v1s are often like that. i wasn't expecting to be blown away and indeed i found quite a few bugs. and have already unsubscribed. but it was worth the $3 just to poke around and have an informed opinion       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [31, 232] 1458554607148232712 9152632 philnash       0 0 1 0 0   en  
1458556941316149251 swyx 33521530 2021-11-10T22:07:28+00:00 @chadwhitacre_ @getsentry congrats!! what does "head of open source" entail at Sentry? i enjoyed this perspective on the job from @cdibona recently: https://twitter.com/cdibona/status/1457887975115612164   1457887975115612164 1457887975115612164   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 172] 1458553600104411147 34175404 chadwhitacre_       1 1 1 0 0 0 en  
1458579427055398912 swyx 33521530 2021-11-10T23:36:49+00:00 I played around with Redux Toolkit's new `condition` API and it's great! See for yourself: https://codesandbox.io/s/redux-toolkit-action-listener-middleware-demo-react-tailwind-98brh?file=/src/App.tsx:2045-2052 I was able to build a Tweet undo button in minutes. How do you like them apples, @TwitterBlue? https://twitter.com/acemarke/status/1457535446674718725 https://twitter.com/swyx/status/1458579427055398912/video/1   1457535446674718725 1457535446674718725   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 234]             1 5 59 0 0 0 en  
1458453691493597184 swyx 33521530 2021-11-10T15:17:11+00:00 Calendar Morghulis       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 18] 1458156097622007809 33521530 swyx       0 1 9 0 0   in  

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