tweets
12 rows where favorite_count = 18 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorited, lang
These facets timed out: source
created_at (date) 12 ✖
- 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-26 1
- 2021-10-27 1
- 2021-11-10 1
- 2021-11-29 1
- 2021-12-03 1
- 2021-12-10 1
user 3 ✖
- swyx 10
- 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 | ||||||||||
| 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 |
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]);