tweets
13 rows where favorite_count = 10 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_screen_name, is_quote_status, retweet_count, lang
created_at (date) 13 ✖
- 2021-08-03 1
- 2021-08-08 1
- 2021-08-10 1
- 2021-08-17 1
- 2021-09-05 1
- 2021-09-07 1
- 2021-09-22 1
- 2021-11-03 1
- 2021-11-23 1
- 2021-11-24 1
- 2021-11-28 1
- 2021-12-16 1
- 2021-12-19 1
user 2 ✖
- swyx 12
- Lucas Bernalte 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1422642885162242048 | swyx 33521530 | 2021-08-03T19:37:49+00:00 | Holy shit. @Sveltejs rocketed to the top of the @StackOverflow survey this year (and I wasnt even aware of the survey so I didnt vote/promote it) https://twitter.com/SvelteSociety/status/1422372693827985409 | 1422372693827985409 1422372693827985409 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 145] | 1414617653386178563 | 33521530 | swyx | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
1424199362024931328 | swyx 33521530 | 2021-08-08T02:42:42+00:00 | i really like the “Name Evaluation” and “Happy Idiot” sections of this guide. https://twitter.com/swyx/status/1424198548720029698 https://twitter.com/swyx/status/1424199362024931328/photo/1 | 1424198548720029698 1424198548720029698 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 101] | 1383881255264034820 | 33521530 | swyx | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
1427547450735165440 | swyx 33521530 | 2021-08-17T08:26:49+00:00 | @Nutlope i fear not the man who has read 1000 books. i fear the man who has read 1 book 1000 times. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 99] | 1427470046343925760 | 3246815913 | Nutlope | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1434409635444887554 | swyx 33521530 | 2021-09-05T06:54:41+00:00 | @patrickjwoods argues here that Community is not Marketing: https://future.a16z.com/community-%E2%89%A0-marketing-why-we-need-go-to-community-not-just-go-to-market/ and elaborates the many ways in which community can do more than product — starting with why people should even show up | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 204] | 1367520242415542273 | 33521530 | swyx | 0 | 0 | 10 | 0 | 0 | 0 | en | |||||||
1435142250820931590 | swyx 33521530 | 2021-09-07T07:25:50+00:00 | @sdand are you really working on something new if you dont post “working on something new” in your bio | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 102] | 1435097575087091718 | 800117847774986240 | sdand | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1440741221236764674 | Lucas Bernalte 174750936 | 2021-09-22T18:14:09+00:00 | I just read about the Four Gears of Learning in Public by @swyx and it clicked. I have only been trying to use the Connector gear and skipped the “previous” two. The Coding Career Handbook is so good 👏 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 201] | 0 | 1 | 10 | 0 | 1 | en | |||||||||||
1456007668196274177 | swyx 33521530 | 2021-11-03T21:17:34+00:00 | My absolute favorite thing about sign language interpreters is how they universally emote with their full face and body even though they could get by with just hands 👏 whoever is doing this at @cascadiajs https://twitter.com/swyx/status/1456007668196274177/video/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 205] | 0 | 0 | 10 | 0 | 0 | 0 | en | ||||||||||
1463009631635050498 | swyx 33521530 | 2021-11-23T05:00:52+00:00 | Stych reaches 🦄 valuation with 25 people: https://techcrunch.com/2021/11/18/stytch-api-passwordless-unicorn/ That’s $40m valuation per head. 🤯 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 100] | 1450992549141704704 | 33521530 | swyx | 0 | 1 | 10 | 0 | 0 | 0 | en | |||||||
1463329430919548931 | swyx 33521530 | 2021-11-24T02:11:38+00:00 | @devongovett @jkup yeah i hear you. good on you for knowing what you want, getting it, and not getting greedy. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [19, 110] | 1463323583380340737 | 15687937 | devongovett | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1465098064411037699 | swyx 33521530 | 2021-11-28T23:19:33+00:00 | @lennysan for the skeptics, i spent some time looking into drivers of “optimal overhead” https://twitter.com/swyx/status/1348027297912082433?s=21 | 1348027297912082433 1348027297912082433 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 112] | 1465019740905107456 | 7958322 | lennysan | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
1471580713946214402 | swyx 33521530 | 2021-12-16T20:39:17+00:00 | an unqualified, low effort “it depends” isn’t wisdom. it’s lazy and nihilistic. here’s how to give a great “it depends”: https://twitter.com/swyx/status/1100275989622505472 | 1100275989622505472 1100275989622505472 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 121] | 1202207460292988929 | 33521530 | swyx | 1 | 2 | 10 | 0 | 0 | 0 | en | ||||||
1472451038569394176 | swyx 33521530 | 2021-12-19T06:17:39+00:00 | @joeDmarti @chriscoyier the other half is telling your coworker their Notion doc is still private | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 97] | 1471310626723008517 | 19720110 | joeDmarti | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1424932215624962049 | swyx 33521530 | 2021-08-10T03:14:48+00:00 | @jsjoeio https://github.com/sw-yx/spark-joy#sound | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 32] | 1424914603885006850 | 1567529924 | jsjoeio | 0 | 0 | 10 | 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]);