tweets
18 rows where "created_at" is on date 2021-11-10 sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorite_count, lang
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
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]);