tweets
33 rows where "created_at" is on date 2021-10-15 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, source, is_quote_status, retweet_count, favorite_count, retweeted, lang
in_reply_to_user_id 21 ✖
- 33521530 2
- 2475601 1
- 2496511 1
- 5676102 1
- 14361975 1
- 14782048 1
- 17189394 1
- 39607761 1
- 101354595 1
- 175934436 1
- 221658618 1
- 244965762 1
- 255634108 1
- 431968702 1
- 608298095 1
- 1577241403 1
- 1903060381 1
- 2606183113 1
- 3092104835 1
- 727704217012604928 1
- 1315999090925281280 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1448819207689310220 | swyx 33521530 | 2021-10-15T01:13:11+00:00 | Invest in your network. People you actually know and talk to, not blindly chasing raw follower count. Absolutely amazing the kind of news, opportunities, support (and dirt! 👀) that you get from building relationships and giving more than you get. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 248] | 0 | 4 | 78 | 0 | 0 | en | |||||||||||
1448826049102376963 | swyx 33521530 | 2021-10-15T01:40:22+00:00 | @PaulYacoubian @shreyas stunning, yet also completely not surprised. congrats!!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 80] | 1448696042770337798 | 175934436 | PaulYacoubian | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1448858023724609541 | swyx 33521530 | 2021-10-15T03:47:25+00:00 | America’s digital divide is never more apparent than today. On the one hand, GitLab, an open source, massively distributed company just IPOed at 2x the valuation of GitHub. On the other, the governor of Missouri just ruled that viewing HTML is criminal hacking. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 263] | 0 | 358 | 2516 | 0 | 0 | en | |||||||||||
1448893200588951553 | swyx 33521530 | 2021-10-15T06:07:12+00:00 | @zahrakhadijha this is a wonderful way to test your learning :) good luck, im sure @acemarke and many webdevs will be here for you if you get stuck! you got this! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 162] | 1448806283272916993 | 2606183113 | zahrakhadijha | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1448893892816871425 | swyx 33521530 | 2021-10-15T06:09:57+00:00 | @geddski *puts down pitchfork* good. gooooood | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 45] | 1448777252015992844 | 39607761 | geddski | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1448894109716922373 | swyx 33521530 | 2021-10-15T06:10:49+00:00 | @ASpittel ALI HAVE YOU TRIED `GH PR CHECKOUT` IT IS AMAZING | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 59] | 1448752696371015681 | 3092104835 | ASpittel | 0 | 0 | 17 | 0 | 0 | en | ||||||||
1448894705912086540 | swyx 33521530 | 2021-10-15T06:13:11+00:00 | @shanselman he DOES have beautiful hair you speak no lies | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 57] | 1448778431110389760 | 5676102 | shanselman | 0 | 0 | 23 | 0 | 0 | en | ||||||||
1448895918518898690 | swyx 33521530 | 2021-10-15T06:18:00+00:00 | @rickhanlonii - step three: look up to the skies | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 48] | 1448801459278073859 | 244965762 | rickhanlonii | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1448896200132812801 | swyx 33521530 | 2021-10-15T06:19:07+00:00 | @MarkLeuchter i feel like @david_perell would have something to say to your students! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 85] | 1448429055557218309 | 1315999090925281280 | MarkLeuchter | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1448896630153904131 | swyx 33521530 | 2021-10-15T06:20:50+00:00 | @geoffreylitt blue green refactor | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 33] | 1448768703185788930 | 221658618 | geoffreylitt | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1449005963734753284 | swyx 33521530 | 2021-10-15T13:35:17+00:00 | RT @fakebaldur: I just published "The Single-Page-App Morality Play" https://www.baldurbjarnason.com/2021/single-page-app-morality-play/ | 1434873556903636996 1434873556903636996 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 92] | 0 | 19 | 0 | 0 | 1 | 0 | en | |||||||||
1449012418621833227 | swyx 33521530 | 2021-10-15T14:00:56+00:00 | @boop seriously i JUST quit my AWS job in Feb and y’all are making me think i missed out on the crazy hot hiring market | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 119] | 1448829597764636675 | 14782048 | boop | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1449013481580105732 | swyx 33521530 | 2021-10-15T14:05:10+00:00 | This became my second conference talk ever, given at @forwardJS way back when! just linking up the talk video https://twitter.com/mweststrate/status/1108746837685501953 | 1108746837685501953 1108746837685501953 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 109] | 1330494937486397440 | 33521530 | swyx | 1 | 0 | 2 | 0 | 0 | 0 | en | ||||||
1449013555257217028 | swyx 33521530 | 2021-10-15T14:05:27+00:00 | @acemarke Immer explained! https://twitter.com/swyx/status/1039903000511143936?s=21 | 1039903000511143936 1039903000511143936 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 50] | 1448696463496605697 | 727704217012604928 | acemarke | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
1449013954345259011 | swyx 33521530 | 2021-10-15T14:07:02+00:00 | @tlakomy you wouldnt want me to be familiar with your entire body | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 65] | 1448978911422042118 | 1903060381 | tlakomy | 0 | 0 | 8 | 0 | 0 | en | ||||||||
1449014942493917187 | swyx 33521530 | 2021-10-15T14:10:58+00:00 | @levelsio i feel like people who voted for #2 have no idea how attractive @stolinski is when he busts a move https://twitter.com/swyx/status/1449014942493917187/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 108] | 1448927903635279875 | 1577241403 | levelsio | 0 | 0 | 13 | 0 | 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 | |||||||||
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 | ||||||||||
1449102336035459073 | swyx 33521530 | 2021-10-15T19:58:14+00:00 | @t_blom Sounds like Germany needs the good ole @FrancisSuarez makeover 👀 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 72] | 1449007004371009536 | 431968702 | t_blom | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1449103297839763459 | Chi is 🈺 47987794 | 2021-10-15T20:02:03+00:00 | I've always believed that the 80/20 rule is grossly misunderstood or misrepresented. There's nothing like doing only 20% of the work to get 80% results as is often opined. 100% of the work (and more) is required. Thanks for this article @swyx https://twitter.com/swyx/status/1387487111964626945 | 1387487111964626945 1387487111964626945 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 245] | 1 | 1 | 5 | 0 | 1 | 0 | en | |||||||||
1449105261705138176 | swyx 33521530 | 2021-10-15T20:09:52+00:00 | wow, some amazing visualizations here inspired by my talk! https://twitter.com/ryanatkn/status/1434918776462585856?s=20 | 1434918776462585856 1434918776462585856 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 82] | 1251211815498833922 | 33521530 | swyx | 1 | 0 | 2 | 0 | 0 | 0 | en | ||||||
1449105641797128192 | swyx 33521530 | 2021-10-15T20:11:22+00:00 | RT @ChibuzorObilom: I've always believed that the 80/20 rule is grossly misunderstood or misrepresented. There's nothing like doing only 2… | 1449103297839763459 1449103297839763459 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 1 | 0 | 0 | 1 | en | ||||||||||
1449112317917110276 | sunil pai, inc. 1593171 | 2021-10-15T20:37:54+00:00 | Really good talk. This is a great slide demonstrating their programming model; to do a recurring subscription, you literally do: while(true){ charge(); sleep(30 days); } That's awesome. https://twitter.com/swyx/status/1449069225704714246 https://twitter.com/threepointone/status/1449112317917110276/photo/1 | 1449069225704714246 1449069225704714246 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 212] | 1 | 1 | 50 | 0 | 1 | 0 | en | |||||||||
1449117060265492481 | swyx 33521530 | 2021-10-15T20:56:45+00:00 | RT @threepointone: Really good talk. This is a great slide demonstrating their programming model; to do a recurring subscription, you liter… | 1449112317917110276 1449112317917110276 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 1 | 0 | 0 | 1 | en | ||||||||||
1449119734058741763 | swyx 33521530 | 2021-10-15T21:07:22+00:00 | @ShaanVP @stephsmithio @chaibizi i feel a podcast episode coming on | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [33, 67] | 1449118631816667137 | 101354595 | ShaanVP | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1449120277393117185 | swyx 33521530 | 2021-10-15T21:09:32+00:00 | @HorusGoul @CascadiaJS @temporalio @typescript currently you need some devops skill to self host Temporal Server and your own Workers, since it was designed for backend devs who are used to doing these things. However there are ongoing projects to make it run in a single binary + hosting Workers for you in future :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [47, 318] | 1449118387016278018 | 608298095 | HorusGoul | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1449129896387616771 | MachinePix 2444425802 | 2021-10-15T21:47:45+00:00 | Time-lapse of ship locks at the Three Gorges Dam. https://twitter.com/MachinePix/status/1449129896387616771/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 49] | 0 | 607 | 2957 | 0 | 1 | 0 | en | ||||||||||
1449140817814167557 | swyx 33521530 | 2021-10-15T22:31:09+00:00 | German word for when an app, that was perfectly fine as it was, completely changes its logo/design/UX wrecking your daily workflow | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 130] | 0 | 1 | 40 | 0 | 0 | en | |||||||||||
1449142794988048386 | swyx 33521530 | 2021-10-15T22:39:00+00:00 | @rothgar it isnt over yet we are still presenting our last talk!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 65] | 1449140640479002629 | 14361975 | rothgar | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1449143399659892736 | swyx 33521530 | 2021-10-15T22:41:24+00:00 | @jkup @Cloudflare ah love it when good ideas get great execution https://twitter.com/netlify/status/1115638145725403136?s=21 | 1115638145725403136 1115638145725403136 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 88] | 1448790326215389190 | 255634108 | jkup | 1 | 0 | 5 | 0 | 0 | 0 | en | ||||||
1449162952251043842 | swyx 33521530 | 2021-10-15T23:59:06+00:00 | @masylum @sugarpirate_ every release somehow 70% faster than the last | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 69] | 1449153824539783169 | 2475601 | masylum | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1448827354306867200 | swyx 33521530 | 2021-10-15T01:45:33+00:00 | @RobAWilkinson @ken_wheeler https://youtu.be/3_ee6aZObyI | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [28, 51] | 1448782623212462080 | 2496511 | RobAWilkinson | 0 | 0 | 0 | 0 | 0 | 0 | und | |||||||
1448832401858170883 | swyx 33521530 | 2021-10-15T02:05:37+00:00 | @dabit3 https://youtu.be/mwq-T2CrJRU | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 31] | 1448645926327783443 | 17189394 | dabit3 | 0 | 0 | 1 | 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]);