tweets

This is data scraped from swyx's timeline! See blog post

21 rows where "created_at" is on date 2021-10-15 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, is_quote_status, retweet_count, favorite_count, lang

created_at (date) 1 ✖

  • 2021-10-15 · 21 ✖
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  
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  
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

CSV options: 

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]);