tweets
18 rows where retweet_count = 8 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by coordinates
This data as json, CSV (advanced)
Suggested facets: user, display_text_range, is_quote_status, favorite_count, favorited, retweeted, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1281842370602889216 | Ethan 3315647862 | 2020-07-11T06:46:51+00:00 | The Coding Career Handbook by @swyx has been such a great resource for coders at the beginning of their journey such as myself. I highly recommend the book to all software engineers especially those early in their careers. Things I like about the book- | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 253] | 0 | 8 | 35 | 0 | 1 | en | |||||||||||
| 1326509989347921925 | swyx 33521530 | 2020-11-11T13:00:01+00:00 | API Economy in five words: Turn non-core features into products. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 65] | 0 | 8 | 165 | 0 | 1 | en | |||||||||||
| 1431829714671476737 | 𝚂𝚆𝙸𝙽𝙳𝙻𝙴𝙳 877551680451162112 | 2021-08-29T04:03:00+00:00 | S05E09: The Scheme (Bernie Madoff) // A Wall Street tycoon's money management firm is revealed to be the world's largest Ponzi scheme. Listen: https://swindledpodcast.com/podcasts/season-5/69-the-scheme/ https://twitter.com/SwindledPodcast/status/1431829714671476737/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 167] | 0 | 8 | 65 | 0 | 0 | 0 | en | ||||||||||
| 1435269040323321858 | swyx 33521530 | 2021-09-07T15:49:39+00:00 | RT @CompuIves: It's still pretty crazy that for a normal devenv you have the linter, typechecker, editor and bundler all generating the sam… | 1435258964242059268 1435258964242059268 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 8 | 0 | 0 | 1 | en | ||||||||||
| 1445252192877694983 | swyx 33521530 | 2021-10-05T04:59:08+00:00 | @jdan this is a fkin masterpiece. the circular pfp crop. the missing pfp in the second message. the inconsistent spacing. the missing timestamps. and ofc, the Pièce de résistance, that last line. Let's see Paul Allen's DMs. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 224] | 1445186388270452740 | 23481558 | jdan | 0 | 8 | 590 | 0 | 0 | en | ||||||||
| 1449069225704714246 | swyx 33521530 | 2021-10-15T17:46:40+00:00 | Temporal: React for the Backend (🌩️ talk) https://youtu.be/WRYozSljSpw Just posted last night's @cascadiajs lightning talk on my channel! • Explaining @temporalio in <10mins • First public demo of our @TypeScript SDK! • Lots of docs updates merged this week | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 258] | 0 | 8 | 110 | 0 | 1 | 0 | en | ||||||||||
| 1449526697242468359 | swyx 33521530 | 2021-10-17T00:04:30+00:00 | RT @swyx: Temporal: React for the Backend (🌩️ talk) https://youtu.be/WRYozSljSpw Just posted last night's @cascadiajs lightning talk on my cha… | 1449069225704714246 1449069225704714246 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 8 | 0 | 0 | 1 | 0 | en | |||||||||
| 1450992549141704704 | swyx 33521530 | 2021-10-21T01:09:16+00:00 | Devtools space is absolutely on fire. If you have a dream, and a credible plan, someone somewhere will pay you to do it full time, make you a paper millionaire, and you get a roll of the dice to make it reality. Can't imagine a better gig on Earth tbh. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 254] | 0 | 8 | 275 | 0 | 0 | en | |||||||||||
| 1458876998491664405 | swyx 33521530 | 2021-11-11T19:19:15+00:00 | RT @swyx: API Economy in five words: Turn non-core features into products. | 1326509989347921925 1326509989347921925 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 75] | 0 | 8 | 0 | 0 | 1 | en | ||||||||||
| 1460615907139411970 | Ron Au 🦆 18333169 | 2021-11-16T14:29:03+00:00 | Keen on developer productivity and wellbeing? r/webdev + r/web_design are officially running a 6-week talk series on exactly that 🙌 Kindly sponsored by @Reddit, the theme is "Ingenious ways to work smarter, faster and healthier" and we begin next week! https://redditweb.dev | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 0 | 8 | 36 | 1 | 1 | 0 | en | ||||||||||
| 1460703767066656768 | swyx 33521530 | 2021-11-16T20:18:11+00:00 | RT @ronvoluted: Keen on developer productivity and wellbeing? r/webdev + r/web_design are officially running a 6-week talk series on exact… | 1460615907139411970 1460615907139411970 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 8 | 0 | 1 | 1 | en | ||||||||||
| 1461043514641305600 | swyx 33521530 | 2021-11-17T18:48:13+00:00 | 🦄 @Netlify was the first unicorn I ever worked at in more ways than one: It remains the only company I've been at that has an active Alumni slack. I can ping old coworkers and it's like I never left. If you can build a strong culture, you can do anything. :netlilove: | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 271] | 0 | 8 | 354 | 0 | 0 | en | |||||||||||
| 1464316615453986818 | Adam Wathan 716933677 | 2021-11-26T19:34:21+00:00 | Execute Program is way too under the radar for how good it is. If they have a course on something, it is the best way to learn that thing on the entire internet. @garybernhardt's standards for quality and attention to detail are the highest in the industry, huge inspiration. https://twitter.com/exec_prog/status/1464293076948635655 | 1464293076948635655 1464293076948635655 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 276] | 1 | 8 | 92 | 1 | 1 | 0 | en | |||||||||
| 1464320734533017600 | swyx 33521530 | 2021-11-26T19:50:43+00:00 | RT @adamwathan: Execute Program is way too under the radar for how good it is. If they have a course on something, it is the best way to le… | 1464316615453986818 1464316615453986818 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 8 | 0 | 1 | 1 | en | ||||||||||
| 1465601156449804290 | Thomas Paul Mann 3322693991 | 2021-11-30T08:38:39+00:00 | Today is a big day for @raycastapp! We're thrilled to announce our $15m Series A and release our Extensions Store and API. Read more about it here: https://www.raycast.com/blog/series-a/ Also, we're on @ProductHunt today: https://www.producthunt.com/posts/raycast-api-and-store https://twitter.com/raycastapp/status/1465599554913550340 | 1465599554913550340 1465599554913550340 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 231] | 1 | 8 | 190 | 1 | 1 | 0 | en | |||||||||
| 1465823027497607171 | swyx 33521530 | 2021-11-30T23:20:18+00:00 | RT @thomaspaulmann: Today is a big day for @raycastapp! We're thrilled to announce our $15m Series A and release our Extensions Store and A… | 1465601156449804290 1465601156449804290 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 8 | 0 | 1 | 1 | en | ||||||||||
| 1473218830210330627 | swyx 33521530 | 2021-12-21T09:08:34+00:00 | If Web3 merely stood for "yes we accept all cookies from now til the end of time" it would have been adopted yesterday | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 118] | 0 | 8 | 177 | 0 | 0 | en | |||||||||||
| 1474082755550257152 | swyx 33521530 | 2021-12-23T18:21:30+00:00 | Updating @KentBeck's law of Software Development: Make it work Make it right Make it fast Make it low-code* *configurable, extensible, and programmable by end users, whether or not they are developers | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 202] | 0 | 8 | 76 | 1 | 1 | 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]);