tweets
10 rows where favorite_count = 18 and is_quote_status = 0
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, retweet_count, retweeted, lang, created_at (date)
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 | ||||||||
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 | |||||||||||
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 | ||||||||||
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 | ||||||||
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 | |||||||
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 | |||||||
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 |
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]);