tweets
18 rows where retweet_count = 10 sorted by lang
This data as json, CSV (advanced)
Suggested facets: display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorite_count, favorited, retweeted
created_at (date) 16 ✖
- 2021-08-14 2
- 2021-10-18 2
- 2020-07-27 1
- 2021-08-01 1
- 2021-08-04 1
- 2021-09-11 1
- 2021-09-16 1
- 2021-09-17 1
- 2021-09-22 1
- 2021-09-23 1
- 2021-10-12 1
- 2021-10-21 1
- 2021-11-11 1
- 2021-11-18 1
- 2021-12-07 1
- 2021-12-11 1
user 7 ✖
- swyx 11
- Gergely Orosz 2
- Jason Laster 1
- Kent C. Dodds πΏπ΄ 1
- Domitrius 1
- Supabase 1
- Rajat Gupta 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1287798586651049985 | Gergely Orosz 30192824 | 2020-07-27T17:14:43+00:00 | Mind blown on how well-read @swyx is in the Coding Career Handbook (https://www.learninpublic.org/?a=uguka). He mentions almost all sources I would - like @Lethain on systems thinking or @mipsytipsy on tech risk profiles. I'm also learning tons of new dev stories (e.g. the "MooTools mafia"). https://twitter.com/GergelyOrosz/status/1287798586651049985/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 0 | 10 | 111 | 0 | 0 | 0 | en | ||||||||||
| 1421937582099759104 | swyx 33521530 | 2021-08-01T20:55:12+00:00 | @Madisonkanna if your company is doubling every year then your company is majority staffed by people who have been around less than a year. So take care to give context, document mistakes, and be intentional about culture building. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 231] | 1421875179873923077 | 1087957969915006976 | Madisonkanna | 0 | 10 | 201 | 0 | 0 | en | ||||||||
| 1422798331437228032 | swyx 33521530 | 2021-08-04T05:55:31+00:00 | I need 48 hours in a day to do everything I want to do wtf | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 58] | 0 | 10 | 192 | 0 | 0 | en | |||||||||||
| 1426537001868685314 | Rajat Gupta 1297539457696980994 | 2021-08-14T13:31:39+00:00 | If you mugged up the rules of React Hooks like me - watch this. Great explanation of the internals by @swyx https://youtu.be/KJP1E-Y-xyo | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 133] | 0 | 10 | 49 | 0 | 1 | 0 | en | ||||||||||
| 1426600484773662724 | swyx 33521530 | 2021-08-14T17:43:55+00:00 | RT @rajatetc: If you mugged up the rules of React Hooks like me - watch this. Great explanation of the internals by @swyx https://t.co/ix⦠| 1426537001868685314 1426537001868685314 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 10 | 0 | 0 | 1 | en | ||||||||||
| 1436720513049669632 | swyx 33521530 | 2021-09-11T15:57:17+00:00 | I'm no perf expert or perf shamer (let he who is without sin...) But here's what I do believe: 1. local Lighthouse runs are not credible. Use webpagetest or http://web.dev/measure. 2. you do NOT have to use the same tech for app and site! :) https://twitter.com/swyx/status/1317635707838496768?lang=en | 1317635707838496768 1317635707838496768 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 1436689311315890177 | 33521530 | swyx | 1 | 10 | 159 | 0 | 0 | 0 | en | ||||||
| 1438643952710717440 | Supabase 1219566488325017602 | 2021-09-16T23:20:21+00:00 | We get a lot of #developers asking about row-level security @_dijonmusters explains how #Auth works using RLS in @supabase in the short video below Give the video a like & leave a comment if you find this useful or if we can make some improvements π https://www.youtube.com/watch?v=Ow_Uzedfohk | Planable 2e73a3957e015e43fed0cf0e8d8d9f8d0a61af7e | 0 | [0, 282] | 0 | 10 | 70 | 0 | 1 | 0 | en | ||||||||||
| 1438785162985328641 | swyx 33521530 | 2021-09-17T08:41:28+00:00 | RT @supabase: We get a lot of #developers asking about row-level security @_dijonmusters explains how #Auth works using RLS in @supabase i⦠| 1438643952710717440 1438643952710717440 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 10 | 0 | 0 | 1 | en | ||||||||||
| 1440684812885315597 | Kent C. Dodds πΏπ΄ 389681470 | 2021-09-22T14:30:00+00:00 | I spent most of yesterday on my @RideOnewheel and listening to @swyx's audio reading of The @Coding_Career Handbook (https://www.learninpublic.org/). It's phenomenal. On my short-list of recommendations. Practical, actionable, and (based on my own experience) terrific advise. πππ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 273] | 0 | 10 | 82 | 0 | 1 | 0 | en | ||||||||||
| 1440867912089161728 | swyx 33521530 | 2021-09-23T02:37:34+00:00 | RT @kentcdodds: I spent most of yesterday on my @RideOnewheel and listening to @swyx's audio reading of The @Coding_Career Handbook (https:β¦ | 1440684812885315597 1440684812885315597 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 10 | 0 | 0 | 1 | en | ||||||||||
| 1447988170293923841 | Domitrius 857629786650357761 | 2021-10-12T18:10:56+00:00 | Iβm so proud to announce Iβve accepted a role with the absolutely mind blowing team that is @Netlify π Iβve received the honor to take over the Jamstack ecosystem as the new Jamstack Community Engineer π As of Monday expect to see much more of me π | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 250] | 0 | 10 | 620 | 0 | 0 | en | |||||||||||
| 1449977842004074500 | Gergely Orosz 30192824 | 2021-10-18T05:57:11+00:00 | The sensible approach is not to delete one or the other. To maximize your "luck surface area" so opportunities find you, use both. They are very different networks. And one more on creating luck from @swyx: https://www.swyx.io/create-luck/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 231] | 1449976861967147011 | 30192824 | GergelyOrosz | 0 | 10 | 71 | 0 | 1 | 0 | en | |||||||
| 1449993680903761926 | swyx 33521530 | 2021-10-18T07:00:07+00:00 | RT @GergelyOrosz: The sensible approach is not to delete one or the other. To maximize your "luck surface area" so opportunities find you,β¦ | 1449977842004074500 1449977842004074500 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 139] | 0 | 10 | 0 | 0 | 1 | en | ||||||||||
| 1451309430830612495 | swyx 33521530 | 2021-10-21T22:08:26+00:00 | Nice alternative to "What's your greatest weakness?": "What is one skill you would like to work on, that would make you much more effective at work?" | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 150] | 0 | 10 | 138 | 1 | 0 | en | |||||||||||
| 1458910483176517632 | swyx 33521530 | 2021-11-11T21:32:19+00:00 | The emerging consensus is that Rust has won out over Go as the preferred language for "Systems Core, Scripting Shell". Key reason: JS interop, Performance, WASM potential, Community https://twitter.com/leeerob/status/1458878573532651527?s=20 https://twitter.com/swyx/status/1458910483176517632/photo/1 | 1458878573532651527 1458878573532651527 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 207] | 1441486732516544513 | 33521530 | swyx | 1 | 10 | 56 | 0 | 0 | 0 | en | ||||||
| 1461155566311542786 | swyx 33521530 | 2021-11-18T02:13:28+00:00 | Why I obsess over asking the right questions: You can give a bad answer to a good question, but itβs impossible to give a good answer to a bad question. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 153] | 0 | 10 | 60 | 0 | 0 | en | |||||||||||
| 1468330375881510916 | Jason Laster 312750384 | 2021-12-07T21:23:36+00:00 | http://Replay.io is shipping Network Monitor V0.5 today. Itβs not quite V1, but itβs definitely not V0 π If you see any bugs, send us a replay! https://twitter.com/jasonlaster11/status/1468330375881510916/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 151] | 0 | 10 | 68 | 0 | 0 | 0 | en | ||||||||||
| 1469466620812619776 | swyx 33521530 | 2021-12-11T00:38:38+00:00 | Hot take time: Is Vite is becoming Rome faster than Rome can become Vite? πΏ https://twitter.com/vitest_dev/status/1469430669126287365 | 1469430669126287365 1469430669126287365 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 76] | 1 | 10 | 171 | 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]);