tweets
3 rows where "created_at" is on date 2021-10-11 and is_quote_status = 1 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, retweeted
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1447374493186285572 | swyx 33521530 | 2021-10-11T01:32:24+00:00 | great recap and podcast episode on Morris. Looking forward to the Jensen Huang episode @AcquiredFM !! https://twitter.com/dunkhippo33/status/1447291658739978243?s=21 | 1447291658739978243 1447291658739978243 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 126] | 1242543872326033408 | 33521530 | swyx | 1 | 0 | 5 | 0 | 0 | 0 | en | ||||||
1447414882081521665 | Patrick McKenzie 20844341 | 2021-10-11T04:12:54+00:00 | Understanding difference between O(N^2) vs. O(n) is indistinguishable from magic at least some of the time, like all good technologies. https://twitter.com/AriaaJaeger/status/1447173775548637189 | 1447173775548637189 1447173775548637189 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 135] | 1 | 145 | 1026 | 0 | 1 | 0 | en | |||||||||
1447688291818508296 | swyx 33521530 | 2021-10-11T22:19:20+00:00 | One of my favorite things at work is flipping low-trust situations into high-trust ones. Teams move at the speed of trust. I think it is one of the most critical things you can do early on in any job. RTing this bc first time I've seen Trust broken down to an equation! https://twitter.com/ryan_caldbeck/status/1013626221601738754 | 1013626221601738754 1013626221601738754 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 270] | 1 | 1 | 14 | 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]);