tweets

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

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, in_reply_to_user_id, in_reply_to_screen_name, favorite_count

created_at (date) 1 ✖

  • 2021-08-19 · 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
1428263984755396624 swyx 33521530 2021-08-19T07:54:04+00:00 @petersuhm @savvycal_ yknow i may be weird but i never use the personalize feature. people im friends with dont need it, and people who are distant i do the “ask for their link and heres mine” trick anyway. i wonder if @derrickreimer has stats on how much it’s ACTUALLY used in practice.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 287] 1428260724942549001 21908850 petersuhm       0 0 2 0 0   en  
1428264197998092293 swyx 33521530 2021-08-19T07:54:55+00:00 @mxstbr @sjwhitworth may also want to check out @louisnicholls_ sales for founders course       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 89] 1428259621257494532 2451223458 mxstbr       0 0 3 0 0   en  
1428264391317721093 swyx 33521530 2021-08-19T07:55:41+00:00 @NadavKeyson amazing. @kevmodrome worth checking out?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 53] 1428254746704551936 146781335 NadavKeyson       0 0 2 0 0   en  
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  
1428270277956231169 swyx 33521530 2021-08-19T08:19:04+00:00 @andrewingram @docusaurus yes that was my plan originally. but i think i will want to add options in future. much cleaner to just use a special tag throughout so i can clearly search n replace in future if need be       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 213] 1428268895006298112 9164512 andrewingram       0 0 0 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  
1428450239392804868 swyx 33521530 2021-08-19T20:14:11+00:00 @nbashaw i was quite disappointed to hear about their plans post their new fundraising round from @brianmcc’s pod. they are trying so hard to “go straight” to justify their growth projections but i think they will just end up killing their golden goose.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 255] 1428444015465308166 17424947 nbashaw       0 0 7 0 0   en  
1428452075231342592 swyx 33521530 2021-08-19T20:21:28+00:00 @brianmcc @nbashaw the fun of being a daily tech journalist on east coast time :)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [19, 81] 1428451737313099777 1502 brianmcc       0 0 1 0 0   en  

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