tweets
15 rows where favorite_count = 18 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorited, lang
created_at (date) 13 ✖
- 2021-10-26 2
- 2021-11-29 2
- 2021-04-22 1
- 2021-08-04 1
- 2021-08-15 1
- 2021-09-26 1
- 2021-09-30 1
- 2021-10-08 1
- 2021-10-21 1
- 2021-10-27 1
- 2021-11-10 1
- 2021-12-03 1
- 2021-12-10 1
user 3 ✖
- swyx 13
- CoRecursive Podcast 1
- Common Room 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1385354953468772356 | swyx 33521530 | 2021-04-22T22:08:54+00:00 | 19. Pick Up What They Put Down Guarantee feedback by giving feedback. https://www.swyx.io/PUWTPD | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 97] | 1385354853816307722 | 33521530 | swyx | 0 | 1 | 18 | 0 | 0 | 0 | en | |||||||
1423027201276928000 | swyx 33521530 | 2021-08-04T21:04:58+00:00 | @brianleroux (for the record i agree its just funny to slap logos on all the things) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 84] | 1423026484877332483 | 676363 | brianleroux | 0 | 0 | 18 | 0 | 0 | en | ||||||||
1427008742797709312 | swyx 33521530 | 2021-08-15T20:46:11+00:00 | All metrics have exceptions but you can roughly break up startups into stages by employee count: 2 founders 20 employees 200 employees 2,000 employees <- probably a unicorn 20k employees 200k employees All advice has a relevance interval and it's possible to learn the tells. https://twitter.com/hnshah/status/1426972669468045318 | 1426972669468045318 1426972669468045318 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 281] | 1 | 0 | 18 | 0 | 0 | 0 | en | |||||||||
1441945464794845191 | swyx 33521530 | 2021-09-26T01:59:23+00:00 | When writing instructors teach you to write, they talk about Grammar and Punctuation and Active Voice. When bloggers get together they mouthblog the long list of great ideas they haven't written up yet. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 204] | 0 | 2 | 18 | 0 | 0 | en | |||||||||||
1443467407352205312 | swyx 33521530 | 2021-09-30T06:47:02+00:00 | It really is a tall order to retell the Apple origin story in an engaging way, when so much of it is well known. So I really mean it when I say @pkafka has done the best ~40 minute recap of the story from Homebrew to iPhone I've ever heard. Recommend. https://www.listennotes.com/podcasts/land-of-the-giants/how-apple-got-its-groove-back-vTYLIF5XaSD/ https://twitter.com/waltmossberg/status/1443242219650142209 | 1443242219650142209 1443242219650142209 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 1 | 3 | 18 | 0 | 0 | 0 | en | |||||||||
1446268135078699012 | Common Room 1331053779341348864 | 2021-10-08T00:16:08+00:00 | It's @swyx! Head of Developer Experience at @temporalio and tech meetup connoisseur. We asked Shawn everything from his favorite part of working in community (it's an "infinite game") to advice he'd give now, and none of the answers disappoint. https://www.commonroom.io/uncommon/blog/the-rise-of-the-community-leader-meet-shawn-wang/?utm_medium=social&utm_source=twitter&utm_campaign=TL&utm_content=rise-of-the-community-leader | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 0 | 5 | 18 | 0 | 1 | 0 | en | ||||||||||
1451097894455431169 | swyx 33521530 | 2021-10-21T08:07:52+00:00 | huge thank you to @calcsam @dkimot @rani_horev for incredibly helpful feedback. i’m learning just how much i have to improve at video tutorials! just took a second crack at this and it took 6 hours for a 40 min video. idk how fulltimers like @aniakubow or @thecodercoder do it 🤯 https://twitter.com/swyx/status/1450650773805670405 | 1450650773805670405 1450650773805670405 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 279] | 1 | 0 | 18 | 0 | 0 | 0 | en | |||||||||
1452798905159016448 | swyx 33521530 | 2021-10-26T00:47:05+00:00 | screw it… heres my list of blogpost ideas, warning its messy like my brain http://simp.ly/publish/6vbwzR | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 98] | 1452745670071250944 | 33521530 | swyx | 0 | 1 | 18 | 0 | 0 | 0 | en | |||||||
1453141294251794436 | swyx 33521530 | 2021-10-26T23:27:37+00:00 | @leeerob @goncy @vercel @okbel @luis_fades @steventey @pacocoursey *looks at Pacos site* *looks at my site* *deletes site* | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [67, 124] | 1453139977441849348 | 81712767 | leeerob | 0 | 0 | 18 | 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 | ||||||||||
1465239261783810050 | swyx 33521530 | 2021-11-29T08:40:37+00:00 | A great brief history of the humble Command Palette here: https://capiche.com/e/consumer-dev-tools-command-palette | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 81] | 1453408357935583234 | 33521530 | swyx | 0 | 4 | 18 | 0 | 0 | 0 | en | |||||||
1466846573078487043 | CoRecursive Podcast 947150325424803840 | 2021-12-03T19:07:30+00:00 | A great list to be a part of! 🏆 https://twitter.com/swyx/status/1466447829149237249 | 1466447829149237249 1466447829149237249 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 31] | 1 | 3 | 18 | 1 | 1 | 0 | en | |||||||||
1469163411531513857 | swyx 33521530 | 2021-12-10T04:33:47+00:00 | And Todolists. We're much better at making Todolists than doing Todos on our Todolists 😂 @huxpro delivering the surprise announcement of #ReactConf in this talk - the sufficiently smart compiler is real — and maybe not so impossible! React Forget 👀 https://youtu.be/lGEMwh32soc https://twitter.com/swyx/status/1469163411531513857/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 1469145149162676224 | 33521530 | swyx | 0 | 0 | 18 | 0 | 0 | 0 | en | |||||||
1453163333234802693 | swyx 33521530 | 2021-10-27T00:55:11+00:00 | @BrendanFalk https://github.com/sw-yx/swyxdotio/issues/5 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 36] | 1453128792851968001 | 1562956159 | BrendanFalk | 0 | 0 | 18 | 0 | 0 | 0 | und | |||||||
1465445638724751365 | swyx 33521530 | 2021-11-29T22:20:41+00:00 | @iam_preethi https://twitter.com/swyx/status/1456706638010667012?s=21 | 1456706638010667012 1456706638010667012 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 36] | 1465380610923540495 | 1478433775 | iam_preethi | 1 | 0 | 18 | 0 | 0 | 0 | und |
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]);