tweets
30 rows where favorite_count = 19
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, retweet_count, retweeted, possibly_sensitive, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1422694051283828741 | swyx 33521530 | 2021-08-03T23:01:08+00:00 | @pablankley @brianleroux (and yes the change-redeploy “dev cycle” is freaking brutal and i didnt figure out a workaround before i left AWS) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 139] | 1422680823086542848 | 1148790367862632448 | pablankley | 0 | 0 | 19 | 0 | 0 | en | ||||||||
| 1422946955630612483 | Supabase 1219566488325017602 | 2021-08-04T15:46:05+00:00 | You still have until 23.59 PDT Friday 6th August to make a submission for the @supabase #hackathon We have incredible judges lined up including @swyx @themarcusbattle and @cassidoo plus limited edition Supa-Swag 🤯 More info in our blog👇 https://supabase.io/blog/2021/07/30/1-the-supabase-hackathon https://twitter.com/supabase/status/1422946955630612483/photo/1 | Planable 2e73a3957e015e43fed0cf0e8d8d9f8d0a61af7e | 0 | [0, 266] | 0 | 3 | 19 | 0 | 1 | 0 | en | ||||||||||
| 1424608160355024900 | swyx 33521530 | 2021-08-09T05:47:08+00:00 | @thecodercoder can you do this but put a big WASTED gta style and fade to black | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 79] | 1424370059342802947 | 881161050011430912 | thecodercoder | 0 | 0 | 19 | 0 | 0 | en | ||||||||
| 1425707553929908238 | swyx 33521530 | 2021-08-12T06:35:43+00:00 | @boop oh so you make product demo videos? Name a background musical instrument that isn't the ukelele | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 101] | 1425565963986952193 | 14782048 | boop | 0 | 0 | 19 | 0 | 0 | en | ||||||||
| 1428048895850942471 | swyx 33521530 | 2021-08-18T17:39:23+00:00 | Advice for coworker new to @savvycal_: There's an unspoken etiquette to scheduling links. It can seem rude as it requires the other side to fit to your schedule Preempt it: “I’d be happy to book a meeting if you have a calendar link, or I can send you mine” and link if hypertext | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 19 | 0 | 0 | en | |||||||||||
| 1429649362594852868 | swyx 33521530 | 2021-08-23T03:39:04+00:00 | I am in Denver for the week! Thinking of organizing a social dinner on Friday. anyone in? any other events going on this week? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 127] | 0 | 0 | 19 | 0 | 0 | en | |||||||||||
| 1431486611296964611 | swyx 33521530 | 2021-08-28T05:19:38+00:00 | When I first found @benthompson’s writing I was madly inspired. Stratechery is 90% just talking about FAAMNG, surely there was room for midcap strategy? I made two mistakes: not trying it, and not going small enough. @packym is everything I wanted to be. https://www.notboring.co/p/ramps-double-unicorn-rounds-behind | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 0 | 1 | 19 | 0 | 0 | 0 | en | ||||||||||
| 1432042759901245443 | swyx 33521530 | 2021-08-29T18:09:34+00:00 | “Faced with the choice between changing one’s mind and proving that there is no need to do so, almost everyone gets busy on the proof.” — John Kenneth Galbraith | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 161] | 0 | 0 | 19 | 0 | 0 | en | |||||||||||
| 1432341565028978694 | 𝚙𝚛𝚊𝚝𝚑𝚎𝚎𝚔.𝚎𝚝𝚑 (🐶,🐶) 65827039 | 2021-08-30T13:56:55+00:00 | Concurrent React from Scratch by @swyx (lesson on @eggheadio) https://egghead.io/lessons/react-concurrent-react-from-scratch Watch 1/20 Maybe. Will probably need to rewatch it again and again. Haven't come across any material which got me close to the internals as this one. Amazing🎉 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 246] | 0 | 2 | 19 | 0 | 1 | 1 | en | ||||||||||
| 1432583994441297924 | swyx 33521530 | 2021-08-31T06:00:15+00:00 | Added a new question to my @savvycal_ - Can I record our conversation? Stealing a page from @sytses, I want to share as many of my conversations as possible and it's awkward to ask "can I record this" at the start of the convo. This way, open-minded people can opt in. https://twitter.com/swyx/status/1432583994441297924/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 271] | 0 | 1 | 19 | 0 | 0 | 0 | en | ||||||||||
| 1433173737692704768 | swyx 33521530 | 2021-09-01T21:03:40+00:00 | @colinhacks @flybayer @blitz_js @rudiyardley @rbzhu i've come to term these "Heresy talks", after @QuinnyPig's excellent example https://www.youtube.com/watch?v=RB6MvSEaMKI i think every conf should have a brave soul pour water on things and enrage people enough to go make it better | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [52, 264] | 1433166882757042178 | 888220718 | colinhacks | 0 | 4 | 19 | 0 | 0 | 0 | en | |||||||
| 1433218630745948160 | swyx 33521530 | 2021-09-02T00:02:04+00:00 | @TkDodo yes! illustrated: https://twitter.com/swyx/status/1010922550912802816?s=20 | 1010922550912802816 1010922550912802816 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 49] | 1433096271443775494 | 44217212 | TkDodo | 1 | 2 | 19 | 0 | 0 | 0 | en | ||||||
| 1435232963600556041 | swyx 33521530 | 2021-09-07T13:26:18+00:00 | 34 days until I saw my own meme on a conference stage in person! enjoying this talk by @tlakomy about executing untrusted code atop a fullstack @typescript + AWS stack! however there is a surprising lack of jQuery, unclear if real @tlakomy was kidnapped https://twitter.com/tlakomy/status/1434969999572094983 https://twitter.com/swyx/status/1435232963600556041/photo/1 | 1434969999572094983 1434969999572094983 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 278] | 1426638568714227712 | 33521530 | swyx | 1 | 1 | 19 | 0 | 0 | 0 | en | ||||||
| 1436697907453779968 | swyx 33521530 | 2021-09-11T14:27:28+00:00 | @leeerob i was -very- excited about RSCs in December 2020 now just kinda confused until it ships and further cements Next.js’ position as the only logical React metaframework to bet on Nextjs’ platform capture both up and down the stack is just amazing to watch | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 264] | 1436695781172551684 | 81712767 | leeerob | 0 | 1 | 19 | 0 | 0 | en | ||||||||
| 1437951953389117449 | swyx 33521530 | 2021-09-15T01:30:36+00:00 | @seldo oh dear i didnt realize that 😬 why did they ever discontinue the Pebble; that thing was perfect 💔 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 106] | 1437950946626002944 | 15453 | seldo | 0 | 0 | 19 | 0 | 0 | en | ||||||||
| 1443997699208933380 | swyx 33521530 | 2021-10-01T17:54:14+00:00 | @_developit @acemarke @alexandereardon i gotta say i really admire the "nobody reads blogposts, lets make up a big number for everyone else to compete" approach to web advocacy | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [39, 176] | 1443988884782784514 | 16495353 | _developit | 0 | 0 | 19 | 0 | 0 | en | ||||||||
| 1445306861545160710 | swyx 33521530 | 2021-10-05T08:36:22+00:00 | @monicalent @lesley_pizza @laxmariappan @aaditsh @mijustin https://twitter.com/swyx/status/1445306861545160710/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [58, 58] | 1445301744565735424 | 1158897613 | monicalent | 0 | 0 | 19 | 0 | 0 | 0 | und | |||||||
| 1445817426558402561 | swyx 33521530 | 2021-10-06T18:25:11+00:00 | Congrats to the @FlutterFlow team for launching on Product Hunt! Excited to be an early investor in the team that is changing how mobile applications are built. Their email product updates are some of the best emails I get. Check them out on PH 👇 https://www.producthunt.com/posts/flutterflow-2-0 https://twitter.com/flutterflow/status/1445765439993171972 https://twitter.com/swyx/status/1445817426558402561/video/1 | 1445765439993171972 1445765439993171972 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 295] | 1 | 0 | 19 | 0 | 0 | 0 | en | |||||||||
| 1447312315485810691 | swyx 33521530 | 2021-10-10T21:25:20+00:00 | APIs that have memory, that collaborate with you on your intent, are so much more human than cold-blooded pass/fail machines. The only reason we don’t do it is because our platforms make it hard to casually provision state and pause/resume logic. @temporalio literally fixes this | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1447312313426460672 | 33521530 | swyx | 0 | 3 | 19 | 0 | 0 | en | ||||||||
| 1449066344918372356 | swyx 33521530 | 2021-10-15T17:35:13+00:00 | I love and respect Jim, but this is bullshit. There are a lot of Twitter thinkfluencers saying Twitter is worth more than OLD_WAY_OF_LEARNING. Keep in mind they have a vested interest in convincing you that you can learn everything just following them. https://twitter.com/swyx/status/1387487111964626945 https://twitter.com/swyx/status/1449066344918372356/photo/1 | 1387487111964626945 1387487111964626945 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 1 | 0 | 19 | 0 | 0 | 0 | en | |||||||||
| 1450174724672311305 | Supabase 1219566488325017602 | 2021-10-18T18:59:31+00:00 | 🏆 Presenting our #Hacktoberfest Hackathon winners in more detail, starting with the runner up for "Best Project": 🥈 @jnnksbrt's og:supa, a snazzy site allowing you to generate og:images for your posts to make empty link previews a thing of the past ✨ https://www.dropbox.com/s/zu4jvo0jklaq9st/supabase-ogsupa.mp4?dl=0 | Planable 2e73a3957e015e43fed0cf0e8d8d9f8d0a61af7e | 0 | [0, 276] | 0 | 2 | 19 | 0 | 1 | 0 | en | ||||||||||
| 1454251874849202185 | swyx 33521530 | 2021-10-30T01:00:40+00:00 | Cloudflare rounding up the Jobs to Be Done of Cloud (i have a separate post on that) https://twitter.com/cloudflaredev/status/1454092772177235972 | 1454092772177235972 1454092772177235972 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 109] | 1450539279973699586 | 33521530 | swyx | 1 | 2 | 19 | 0 | 0 | 0 | en | ||||||
| 1455950301228199936 | swyx 33521530 | 2021-11-03T17:29:36+00:00 | @mjackson 👀 Quicktime with its default no microphone setting hidden away | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 72] | 1455917443960872961 | 734903 | mjackson | 0 | 0 | 19 | 0 | 0 | en | ||||||||
| 1458876201884270596 | swyx 33521530 | 2021-11-11T19:16:05+00:00 | @levelsio my fave video on a topic https://www.youtube.com/watch?v=oAHbLRjF0vo that said.. i think the 2hrs includes cleaning and unloading luggage | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 128] | 1458871024141815845 | 1577241403 | levelsio | 0 | 0 | 19 | 0 | 0 | 0 | en | |||||||
| 1459227112577986561 | swyx 33521530 | 2021-11-12T18:30:29+00:00 | "Red is about to be mine again, but it has always been ours." Scooter Braun becomes the dictionary definition of what happens when you try to NFT an artist against their will. Streaming #RedTaylorsVersion now and forever. https://twitter.com/taylorswift13/status/1459023801480474632 | 1459023801480474632 1459023801480474632 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 222] | 1 | 1 | 19 | 0 | 0 | 0 | en | |||||||||
| 1459327954794647556 | swyx 33521530 | 2021-11-13T01:11:12+00:00 | Huge shout out @BrittneyPostma for #FollowFriday! On top of running a podcast, blog, merch, and her own freelance dev/design business, she's led the creation of @SvelteSirens and galvanized the @SvelteSociety in a whole new way with her talents. Follow @BrittneyPostma!! https://twitter.com/BrittneyPostma/status/1412032180465831939 https://twitter.com/swyx/status/1459327954794647556/photo/1 | 1412032180465831939 1412032180465831939 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 296] | 1 | 2 | 19 | 0 | 0 | 0 | en | |||||||||
| 1461420430137257986 | swyx 33521530 | 2021-11-18T19:45:57+00:00 | @jkup tried it, for me its just not worth it unless you are literally not paying attention to the stream. standard twitch streaming is full of interruptions, because naturally viewers want to interact with you live for it to be a good stream, but its terrible for focus | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 269] | 1461403751516971008 | 255634108 | jkup | 0 | 0 | 19 | 0 | 0 | en | ||||||||
| 1465917129954234371 | swyx 33521530 | 2021-12-01T05:34:13+00:00 | Ok I finally made a private alt: @swyxio If you want the no-filter firehose from me, that's gonna be the outlet. No need to be mutuals just be a non-crazy person with an open mind. profile pic is from my fraternity days when i used to be fun https://twitter.com/qoouep/status/1465237879693590532 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 243] | 1 | 1 | 19 | 0 | 0 | 0 | en | ||||||||||
| 1466616760228974598 | swyx 33521530 | 2021-12-03T03:54:18+00:00 | @jordienr @AntWilson @fig @vercel @supabase dammit. you may have just nerd sniped me into making one | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [44, 100] | 1466482441636429838 | 2340086665 | jordienr | 0 | 0 | 19 | 0 | 0 | en | ||||||||
| 1473914907665993728 | swyx 33521530 | 2021-12-23T07:14:32+00:00 | @levelsio being blocked by pmarca is the new verified | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 53] | 1473750845585977344 | 1577241403 | levelsio | 0 | 0 | 19 | 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]);