tweets
12 rows where favorite_count = 42 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, retweeted
created_at (date) 12 ✖
- 2021-07-30 1
- 2021-08-04 1
- 2021-08-31 1
- 2021-09-20 1
- 2021-09-23 1
- 2021-09-29 1
- 2021-10-19 1
- 2021-11-06 1
- 2021-11-11 1
- 2021-11-15 1
- 2021-11-30 1
- 2021-12-02 1
source 3 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1421180194384084995 | swyx 33521530 | 2021-07-30T18:45:37+00:00 | Non obvious thing I picked up from @reactjs — keep a set of fixtures to help you repro bugs! Instead of starting from a blank file or deleting from a real project, fixtures are the middle way — a starting point that implements all the APIs or pushes them to known limits. https://twitter.com/b0rk/status/1421141801407291398 | 1421141801407291398 1421141801407291398 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 272] | 1 | 0 | 42 | 0 | 0 | 0 | en | |||||||||
| 1422811409683914752 | swyx 33521530 | 2021-08-04T06:47:29+00:00 | an AMAZING answer to this from someone in our @Coding_Career Circle - @jeanqasaur's epic breakdown of why developers don't buy "luxury goods": https://www.akitasoftware.com/blog-posts/why-arent-there-more-programming-languages-startups This is REQUIRED READING for anyone working in dev tools. Hot damn. https://twitter.com/swyx/status/1422811409683914752/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 235] | 1418696471113658371 | 33521530 | swyx | 0 | 4 | 42 | 0 | 0 | 0 | en | |||||||
| 1432760330883514369 | Magic 1221344704811241472 | 2021-08-31T17:40:56+00:00 | 🍿 Awesome ppl to follow to learn about @sveltejs: 🔸 @lihautan, Svelte maintainer & youtuber. 🔸 @swyx, speaks & write about Svelte. 🔸 @steph_dietz_, new Svelte fan & youtuber. 🔸 @spences10, writes about Svelte. 🔸 @Wattenberger, uses Svelte for data visualization. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 13 | 42 | 0 | 1 | en | |||||||||||
| 1439954828067803137 | swyx 33521530 | 2021-09-20T14:09:18+00:00 | I've been trying to figure out my preferred podcast style all year and I think "@LexFridman for developers" has a nice ring to it. Just need to be a much much better interviewer lol Who should I talk to next? https://twitter.com/swyx/status/1439702355553886211 | 1439702355553886211 1439702355553886211 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 210] | 1 | 0 | 42 | 0 | 0 | 0 | en | |||||||||
| 1441154688418783233 | swyx 33521530 | 2021-09-23T21:37:07+00:00 | If you enjoyed this thread, I'll be teaching a 4 week class with @chapter_HQ (90 min reading each week) all about career growth and Learning in Public, starting Sep 27. Open to all. Sign up at link below https://getchapter.app/@swyx/learn | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 232] | 1369347682465091587 | 33521530 | swyx | 0 | 3 | 42 | 0 | 0 | 0 | en | |||||||
| 1443024483170729989 | swyx 33521530 | 2021-09-29T01:27:01+00:00 | Just saw a demo of @Serverless Cloud from @jeremy_daly on @mavi888uy's channel: - API routing + serverless - @DynamoDB storage + querying (incl/ GSIs) - scheduled functions - data streams no YAML, no CDK, no IaC.... JUST BUSINESS LOGIC. https://www.youtube.com/watch?v=1TKedWps7nU https://twitter.com/swyx/status/1443024483170729989/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 263] | 1435471481266388993 | 33521530 | swyx | 0 | 9 | 42 | 0 | 0 | 0 | en | |||||||
| 1450355145917677569 | swyx 33521530 | 2021-10-19T06:56:27+00:00 | @AdamRackis xstate isn’t popular enough to be hated yet | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 55] | 1450299212319580163 | 68567860 | AdamRackis | 0 | 2 | 42 | 0 | 0 | en | ||||||||
| 1456866520395509765 | swyx 33521530 | 2021-11-06T06:10:20+00:00 | Apparently the line is 10 years and 1.5 months old so it was impossible to believe in it earlier unless you literally made the language haha https://twitter.com/BrendanEich/status/1456758350419480580 | 1456758350419480580 1456758350419480580 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1456706638010667012 | 33521530 | swyx | 1 | 4 | 42 | 0 | 0 | 0 | en | ||||||
| 1458684981954244608 | swyx 33521530 | 2021-11-11T06:36:15+00:00 | Devtools pride is seeing users casually taking our API designs, docs, and error messages for granted having no idea how much *worse* they used to be | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 148] | 1458682064908161027 | 33521530 | swyx | 0 | 2 | 42 | 0 | 0 | en | ||||||||
| 1460168187530530818 | swyx 33521530 | 2021-11-15T08:49:59+00:00 | Reviewing all the #SvelteSummit submissions now. So impressed by all the creativity/talent/passion of @SvelteSociety! Saturday's Summit is going to be amazing 🧡 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 161] | 0 | 1 | 42 | 0 | 0 | en | |||||||||||
| 1465635073319849985 | swyx 33521530 | 2021-11-30T10:53:26+00:00 | @johnspurlock @eastdakota @QuinnyPig just caught up with this now. audibly LOLed at the idea that the cheapest way to get data out of AWS is to sue them and then get it through discovery 😹 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [37, 188] | 1462473358944186370 | 12961272 | johnspurlock | 0 | 11 | 42 | 0 | 0 | en | ||||||||
| 1466447829149237249 | swyx 33521530 | 2021-12-02T16:43:02+00:00 | 🏆 Best Tech Podcast Finds of 2021 - @CoRecursive by @adamgordonbell - @Sourcegraph by @beyang - Stevey's Tech Talk by @Steve_Yegge - @Podrocketpod by @LogRocket - @DevToolsFM by @Zephraph @hipstersmoothie https://twitter.com/swyx/status/1466447829149237249/photo/1 | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 207] | 1466447823801491458 | 33521530 | swyx | 0 | 7 | 42 | 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]);