tweets
12 rows where "created_at" is on date 2021-08-23 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, lang
user 2 ✖
- swyx 11
- Ben Thompson 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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]);