tweets

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

17 rows where "created_at" is on date 2021-11-07 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, favorited, lang

created_at (date) 1 ✖

  • 2021-11-07 · 17 ✖
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
1457158423313674241 swyx 33521530 2021-11-07T01:30:15+00:00 @robhope @OnePageLove @uxlove @EmailLove_ keep the 3 branch ones as dedicated feeds with automated posts @robhope as the superfeed with manual RTs and QTs of significant news from each gives people the “subscribe to as many or as little newsletters from us as you like” option in twitter native format       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [42, 303] 1456606745472688131 14931736 robhope       0 0 1 0 0   en  
1457158536064995332 swyx 33521530 2021-11-07T01:30:42+00:00 @johnny_reilly @orta @typescript queued up to watch, appreciate the rec       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [33, 71] 1456894278404354052 261582708 johnny_reilly       0 0 2 0 0   en  
1457181314776371200 swyx 33521530 2021-11-07T03:01:13+00:00 @httpJunkie @leeerob @reactjs @Cloudflare @vercel @remix_run thank you Eric! yeah feels like the reception for this was super strong for a friday drop!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [61, 151] 1457020052855685122 1594100137 httpJunkie       0 0 0 0 0   en  
1457256545343840258 swyx 33521530 2021-11-07T08:00:09+00:00 @ejames_c i actually dont find the inability to predict a good thing. people really want predictions. personal outcomes really depend on weighting probabilities right. its not enough to sit back and say “ah look everything is so complex it all depends”. you have to *do something*.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 282] 1457002379258204165 14243237 ejames_c       0 0 1 0 0   en  
1457353577819746321 Ryan Hoover 14417215 2021-11-07T14:25:43+00:00 Why so many people with a startup idea never ship https://twitter.com/rrhoover/status/1457353577819746321/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 49]             0 3179 18350 0 0 0 en  
1457412996733423616 swyx 33521530 2021-11-07T18:21:50+00:00 @dejavucoder @audacitus @BrandonHexsel ship more tends to humble you very very quickly       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [39, 87] 1457412337212669954 1446445479068241923 dejavucoder       0 0 1 0 0   en  
1457444013556916228 swyx 33521530 2021-11-07T20:25:05+00:00 @floydophone @buildsghost @sebmck help us, you're our only hope       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 63] 1457420445678915586 14521411 floydophone       0 0 2 0 0   en  
1457444573601431552 swyx 33521530 2021-11-07T20:27:19+00:00 @tylertringas no but it is not your fault; the kind of people that want to deploy a lot of money want to deploy a lot of money fast and return a lot of money fast, that tends to lead to frenzied companies or conversely, frenzied companies are more likely to promise to deploy fast/return fast       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 293] 1457439574020530182 33353061 tylertringas       0 0 1 0 0   en  
1457445123462090759 swyx 33521530 2021-11-07T20:29:30+00:00 Sometimes you learn a concept like "center of gravity" and you think "thats a cute mental model that helps humans simplify things, Nature isn't really like that but it's close enough" then Nature says: No, it really do be like that https://twitter.com/swyx/status/1457445123462090759/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 232]             0 108 478 0 0 0 en  
1457460664230834176 swyx 33521530 2021-11-07T21:31:15+00:00 @buildsghost @floydophone @sebmck even the thing about checked-in source is controversial - i saw a thoughtleader™ on here a month or so ago passionately arguing for only publishing dist (not src) files because something something size of node modules       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [34, 251] 1457448799928926212 1175464650395111424 buildsghost       0 0 1 0 0   en  
1457461436460900357 swyx 33521530 2021-11-07T21:34:19+00:00 @stephsmithio you always find a way to make your point in less words :) my overly verbose take on this https://twitter.com/swyx/status/1455632170312089601   1455632170312089601 1455632170312089601   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 127] 1457063415080370179 626691391 stephsmithio       1 0 2 0 0 0 en  
1457466032365445120 Zev Averbach 38199764 2021-11-07T21:52:35+00:00 gratitude to @swyx for his excellent, usually bite-sized podcast: https://swyx.transistor.fm/ always amazed by his prolificity, but the value he crams into these 10-minute episodes is 🔥       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 183]             0 2 13 1 1 0 en  
1457471762258546691 swyx 33521530 2021-11-07T22:15:21+00:00 RT @zevav: gratitude to @swyx for his excellent, usually bite-sized podcast: https://swyx.transistor.fm/ always amazed by his prolificity, bu… 1457466032365445120 1457466032365445120     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 2 0 1 1 0 en  
1457471843107889158 swyx 33521530 2021-11-07T22:15:40+00:00 @zevav hey glad you are enjoying it!! :) :)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [7, 43] 1457466032365445120 38199764 zevav       0 0 1 0 0   en  
1457478823172214787 swyx 33521530 2021-11-07T22:43:24+00:00 @stolinski i like it! wondering why it has to be Svelte specific.. just because of the svelte store? Svelte stores can be used in non Svelte projects fwiw       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 154] 1456705970659278851 18727585 stolinski       0 0 5 0 0   en  
1457493259647782912 swyx 33521530 2021-11-07T23:40:46+00:00 sidenote: the "science educators" community must have a "Real Book" of these fun quick demos because i see them all the time, i think the dev advocate community should take a leaf from the science (and jazz) community       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 217] 1457445123462090759 33521530 swyx       0 0 20 0 0   en  
1457411078372020229 swyx 33521530 2021-11-07T18:14:13+00:00 https://twitter.com/rrhoover/status/1457353577819746321?s=20   1457353577819746321 1457353577819746321   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 23] 1416526365172506624 33521530 swyx       1 0 11 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]);