tweets
5 rows where display_text_range = "[0, 209]" sorted by in_reply_to_screen_name
This data as json, CSV (advanced)
Suggested facets: user, source, is_quote_status, favorited, retweeted
created_at (date) 5 ✖
- 2021-05-17 1
- 2021-08-12 1
- 2021-09-06 1
- 2021-09-29 1
- 2021-12-24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1394332453892984835 | Dana Jones 5994002 | 2021-05-17T16:42:17+00:00 | Enough folks were interested that I have written up my thoughts on Identifying Checkout Behavior: recognizing signs of when an employee might be considering a breakup with your company. http://danabrit.blogspot.com/2021/05/identifying-checkout-behavior.html https://twitter.com/danabrit/status/1392515208611041283 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 209] | 1 | 1 | 37 | 0 | 0 | 0 | en | ||||||||||
1425825714788503552 | James Long 14615235 | 2021-08-12T14:25:15+00:00 | 🎉 It's finally ready! I've been hacking on something for the past couple months and it's absurdly great. It's time for more powerful web apps. Announcing "A future for SQL on the web": https://jlongster.com/future-sql-web | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 209] | 0 | 566 | 2316 | 0 | 1 | 0 | en | ||||||||||
1443289480606015490 | Joe Previte 1567529924 | 2021-09-29T19:00:01+00:00 | Indie Hacking Resources 📚 If you're new to indie hacking, these are a couple resources I'd start with: - https://www.indiehackers.com/start - https://joeprevite.com/launching-first-product - https://github.com/sw-yx/launch-cheatsheet - https://www.indiehackers.com/growth-bites | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 209] | 0 | 6 | 13 | 0 | 0 | 0 | en | ||||||||||
1474267015334752257 | swyx 33521530 | 2021-12-24T06:33:41+00:00 | Embarrassed to learn about the :target pseudoselector so late in my webdev journey. I've written JS code to implement this exact feature when I could've just #useThePlatform'ed it 🤦🏽♂️ https://twitter.com/css/status/1354887812676546560 https://twitter.com/swyx/status/1474267015334752257/photo/1 | 1354887812676546560 1354887812676546560 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 209] | 1 | 23 | 255 | 1 | 0 | 0 | en | |||||||||
1434818980439592966 | swyx 33521530 | 2021-09-06T10:01:17+00:00 | GPTs contrasted with “Management Technologies”, like the assembly line, and possibly software? Software internally has GPTs too, though i am not very convinced by the ones listed here. https://twitter.com/Vernon3Austin/status/1425462308105564168 https://twitter.com/swyx/status/1434818980439592966/photo/1 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 209] | 1362333935322075139 | 33521530 | swyx | 1 | 0 | 3 | 0 | 0 | 0 | en |
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]);