tweets

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

9 rows where favorited = 0, in_reply_to_user_id = 40663578 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, is_quote_status, favorite_count, lang, created_at (date)

source 1 ✖

  • Twitter for iPhone · 9 ✖

in_reply_to_user_id 1 ✖

  • 40663578 · 9 ✖

favorited 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
1428266802174332930 swyx 33521530 2021-08-19T08:05:16+00:00 @sebastienlorber @docusaurus thank you!! yeah the real challenge is TWO WAY linking… (aka destination page also gets a list of pages that link to it) i think it is possible but need to hack into the classic theme even further. in gatsby this is easy bc of the data pipeline but here im less familiar       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [29, 299] 1428265486274514947 40663578 sebastienlorber       0 0 1 0 0   en  
1428267482867933191 swyx 33521530 2021-08-19T08:07:58+00:00 @sebastienlorber @reactjs @docusaurus code is here! https://github.com/sw-yx/demo-docusaurus-mdx-preview-poc/blob/ec326366710577162500b78ced31a4734b47b101/src/theme/MDXComponents/index.js#L63 idk if its possible to enable by default, it requires the weird importing and extra metadata for rendering the short description. but i’d love to see if u have ideas.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 243] 1428266511580508164 40663578 sebastienlorber       0 0 2 0 0 0 en  
1428267871528919042 swyx 33521530 2021-08-19T08:09:31+00:00 @sebastienlorber @reactjs @docusaurus ah makes sense. perhaps worth inserting a “you may not need to swizzle! try wrapping instead!” when someone uses the swizzle —danger flag       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 175] 1428267010291601408 40663578 sebastienlorber       0 0 1 0 0   en  
1428268334257037313 swyx 33521530 2021-08-19T08:11:21+00:00 @sebastienlorber @reactjs @docusaurus got u. my thinking on this one is someday i might want to display an excerpt derived from the markdown itself so i can offer rich text in the preview. but no idea how to cut it off automatically/manually.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 243] 1428267246477090820 40663578 sebastienlorber       0 0 1 0 0   en  
1428269886883581952 swyx 33521530 2021-08-19T08:17:31+00:00 @sebastienlorber @docusaurus 🔥 one nuance to handle here is you may also want to track which section links to the page, so in the backlink you can use the #anchor tag to send readers directly to the linked text. mad science bonus goal: include surrounding text       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [29, 264] 1428268180972216323 40663578 sebastienlorber       0 0 1 0 0   en  
1428270697105612802 swyx 33521530 2021-08-19T08:20:44+00:00 @sebastienlorber @reactjs @docusaurus i think also would be no problem rendering iframe since same origin, no screenshot needed. yeah ok so we’ll just go with simple metadata for now ♥️       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 187] 1428269843199971332 40663578 sebastienlorber       0 0 1 0 0   en  
1451410441012273155 swyx 33521530 2021-10-22T04:49:49+00:00 @sebastienlorber honestly miss getting excited about stuff like this. love that react continues to innovate. 💜       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 110] 1451216514779172867 40663578 sebastienlorber       0 0 12 0 0   en  
1451458652750057473 swyx 33521530 2021-10-22T08:01:24+00:00 @sebastienlorber @Abdullah_Mzaien some hints here :) https://twitter.com/swyx/status/1439702355553886211   1439702355553886211 1439702355553886211   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [34, 52] 1451225120752783367 40663578 sebastienlorber       1 0 1 0 0 0 en  
1453290745906057219 swyx 33521530 2021-10-27T09:21:29+00:00 @sebastienlorber 🎉       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 18] 1453262895912005639 40663578 sebastienlorber       0 0 2 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]);