tweets
6 rows where "created_at" is on date 2021-12-13 and favorited = 1 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, source, display_text_range, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1470330844896059394 | Dan Luu 18275645 | 2021-12-13T09:52:45+00:00 | How I think about writing https://danluu.com/writing-non-advice/ https://twitter.com/danluu/status/1470330844896059394/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 50] | 0 | 39 | 259 | 1 | 1 | 0 | en | ||||||||||
| 1470335838349238272 | swyx 33521530 | 2021-12-13T10:12:36+00:00 | RT @danluu: How I think about writing https://danluu.com/writing-non-advice/ https://twitter.com/danluu/status/1470330844896059394/photo/1 | 1470330844896059394 1470330844896059394 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 86] | 0 | 39 | 0 | 1 | 1 | 0 | en | |||||||||
| 1470487534132154378 | Jason Laster 312750384 | 2021-12-13T20:15:23+00:00 | This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It doesn't matter if you're technically support, success, product, qa, leadership, or dev, if you care about quality, we want to talk to you! 🐛👋 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 260] | 0 | 2 | 4 | 1 | 1 | 0 | en | ||||||||||
| 1470487931332792324 | swyx 33521530 | 2021-12-13T20:16:57+00:00 | RT @jasonlaster11: This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It d… | 1470487534132154378 1470487534132154378 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | 0 | en | |||||||||
| 1470489155725578262 | Arthur Wu 🍊 2477624389 | 2021-12-13T20:21:49+00:00 | What makes Gmail performant is different than what makes Instagram performant. In "Application Holotypes", @_developit made a starting taxonomy of web app types and good architecture traits for each one. Many cite it as an impt read, and I've made it more visual 🧵: https://twitter.com/arthurwuhoo/status/1470489155725578262/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 0 | 15 | 69 | 1 | 1 | 0 | en | ||||||||||
| 1470489620639006721 | swyx 33521530 | 2021-12-13T20:23:40+00:00 | RT @arthurwuhoo: What makes Gmail performant is different than what makes Instagram performant. In "Application Holotypes", @_developit m… | 1470489155725578262 1470489155725578262 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 15 | 0 | 1 | 1 | 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]);