tweets

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

12 rows where "created_at" is on date 2021-08-23 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, display_text_range, in_reply_to_user_id, is_quote_status, retweet_count, favorite_count, retweeted, lang

created_at (date) 1 ✖

  • 2021-08-23 · 12 ✖
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
1429600879582138370 swyx 33521530 2021-08-23T00:26:25+00:00 @jtao_ it WAS. thank you! tweeted it in a vague hope someone with a better memory would come along and you did 🙏       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [7, 112] 1429552509102743559 18482891 jtao_       0 0 2 0 0   en  
1429607755770331140 swyx 33521530 2021-08-23T00:53:44+00:00 of course it was from @benthompson: https://stratechery.com/2018/techs-two-philosophies/ (thanks to @jtao_) he identifies a few other points: - the Jobs school is older - platforms skew Jobsian, aggregators skew Zuckerist - the business model follows (paid vs ads) - they aren’t at odds; we need both https://twitter.com/swyx/status/1429607755770331140/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 273] 1429536652196651012 33521530 swyx       0 0 15 0 0 0 en  
1429608015057981446 Ben Thompson 40273 2021-08-23T00:54:46+00:00 If I could convince everyone in the world to read and understand one article about COVID it would be this one. FWIW it very closely tracks the understanding I’ve developed over many months now, and explains all of the twists and turns to date. https://cspicenter.org/blog/waronscience/why-covid-19-is-here-to-stay-and-why-you-shouldnt-worry-about-it/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 269]             0 295 1430 0 1 0 en  
1429649362594852868 swyx 33521530 2021-08-23T03:39:04+00:00 I am in Denver for the week! Thinking of organizing a social dinner on Friday. anyone in? any other events going on this week?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 127]             0 0 19 0 0   en  
1429649523769372676 swyx 33521530 2021-08-23T03:39:42+00:00 RT @benthompson: If I could convince everyone in the world to read and understand one article about COVID it would be this one. FWIW it ver… 1429608015057981446 1429608015057981446     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 295 0 0 1   en  
1429658207228547079 swyx 33521530 2021-08-23T04:14:13+00:00 @stolinski will DM!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 19] 1429652280744288257 18727585 stolinski       0 0 0 0 0   en  
1429660908414857223 swyx 33521530 2021-08-23T04:24:57+00:00 @lucasandrad__ thanks Lucas! its amazing how many people have resonated with it, its got over a million readers at this point 😱       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 127] 1429656270739476480 1115629672870506496 lucasandrad__       0 0 2 0 0   en  
1429689406516908032 swyx 33521530 2021-08-23T06:18:11+00:00 @alexandereardon everyone switched to @sveltejs! https://twitter.com/chantastic/status/1426318522242588675?s=21   1426318522242588675 1426318522242588675   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 72] 1429590851966046217 37125581 alexandereardon       1 0 13 0 0 0 en  
1429690271881519113 swyx 33521530 2021-08-23T06:21:37+00:00 @alexandereardon @farazamiruddin @eveningkid checked out that video, then his flutter video. earned my subscribe 🔥       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [45, 114] 1429595527516098568 37125581 alexandereardon       0 0 4 0 0   en  
1429727373503524864 swyx 33521530 2021-08-23T08:49:03+00:00 RT @CookieDuster_N: Another awesome read from @swyx https://www.swyx.io/measuring-devrel/ Best bit: Traditional marketing advice says people have to hea… 1429725966335713281 1429725966335713281     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 1 0 0 1 0 en  
1429818702820741120 swyx 33521530 2021-08-23T14:51:58+00:00 @dan_abramov @chantastic @alexandereardon @sveltejs ya i was relying on everyone here knowing that 😅 for the record i dont feel thaaat strongly about this one, its just like a 2 out of 10 persistent background annoyance. also i guess we could use class for html elements and className for components but havent thought it through       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [52, 330] 1429816463850942472 70345946 dan_abramov       0 0 1 0 0   en  
1429673075054768130 swyx 33521530 2021-08-23T05:13:17+00:00 @DavidWells 😍       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 13] 1429555410487312389 13638932 DavidWells       0 0 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]);