tweets
11 rows where "created_at" is on date 2021-08-19 and favorite_count = 1 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, source, in_reply_to_user_id, is_quote_status, lang
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1428222649721712646 | swyx 33521530 | 2021-08-19T05:09:49+00:00 | @farzad_yz @ReactRally haha on the livestream? amazing. thank you 🙏🏽 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [23, 68] | 1428216444450390022 | 304289713 | farzad_yz | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1428236014082924548 | swyx 33521530 | 2021-08-19T06:02:55+00:00 | @KajetanSw @ReactRally good luck! dont rush like i did, make sure to grab attention when starting (have high energy, joke, poll, video clip, story, whatever), slow down your words (because of nervousness) and, if presenting code, ENLARGE THE FONT! if prerecorded, tips here https://twitter.com/swyx/status/1363110323268374530 | 1363110323268374530 1363110323268374530 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [23, 298] | 1428234170812321802 | 1069315566375264261 | KajetanSw | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
1428242133710934018 | Kajetan Świątek 1069315566375264261 | 2021-08-19T06:27:14+00:00 | @swyx @ReactRally Thanks! Those are perfect tips. Rushing is definitely something I do when I'm nervous. I'll try to mitigate that when rehearsing. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [18, 148] | 1428236014082924548 | 33521530 | swyx | 0 | 0 | 1 | 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 | ||||||||
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 | ||||||||
1428412406909136897 | swyx 33521530 | 2021-08-19T17:43:51+00:00 | @acemarke @beyang @github i do wonder at the logistics of essentially scraping github/gitlab.. seems inefficient, I hope you can do a deal with them to get all this data directly @beyang | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [26, 186] | 1428403711936798723 | 727704217012604928 | acemarke | 0 | 0 | 1 | 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 | ||||||||
1428409475229118468 | swyx 33521530 | 2021-08-19T17:32:12+00:00 | @JustGage @sotak 🙏 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 18] | 1428409299953274882 | 17006530 | JustGage | 0 | 0 | 1 | 0 | 0 | und |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);