tweets
5 rows where "created_at" is on date 2021-09-11 and in_reply_to_user_id = 229237555 sorted by coordinates
This data as json, CSV (advanced)
Suggested facets: user, source, is_quote_status, retweet_count, favorite_count
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1436708762115473411 | Alex Russell 229237555 | 2021-09-11T15:10:36+00:00 | @swyx <but_why.gif> https://twitter.com/slightlylate/status/1436708762115473411/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 25] | 1436707990933958657 | 229237555 | slightlylate | 0 | 3 | 38 | 0 | 0 | 0 | en | |||||||
1436709370457436162 | swyx 33521530 | 2021-09-11T15:13:01+00:00 | @slightlylate i was wondering how closely or casually this statement was made (usually its just the HIPPO) and if i can send them my brochure saying otherwise https://twitter.com/swyx/status/1317635707838496768?s=21 | 1317635707838496768 1317635707838496768 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 182] | 1436708762115473411 | 229237555 | slightlylate | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
1436714003997331457 | swyx 33521530 | 2021-09-11T15:31:26+00:00 | @slightlylate i can only imagine. you do perform an important public service when you do these so all i can say is thank you. im wondering if it is worth codifying in a “slightlylatehouse” tool where all your usual commentary is templatized. the green circles need a credible alternative. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 289] | 1436712687367426050 | 229237555 | slightlylate | 0 | 1 | 1 | 0 | 0 | en | ||||||||
1436718275585523730 | swyx 33521530 | 2021-09-11T15:48:24+00:00 | @slightlylate the reason i suggested templatizing, is your longform commentary on why X is bad and what could be done better is very valuable. webpagetest speaks to perf experts, but the rest of us have no idea what to do with all the info. maybe inject some humor to make it more appealing. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 291] | 1436716663013928961 | 229237555 | slightlylate | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1436724263919263747 | swyx 33521530 | 2021-09-11T16:12:12+00:00 | @slightlylate when i find an example from another field i'll double back and try to show instead of tell. i see these sorts of things in SEO assessment tools every now and then. but the gentle nudging humor is rare. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 215] | 1436722125025411078 | 229237555 | slightlylate | 0 | 0 | 1 | 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]);