tweets
4 rows where "created_at" is on date 2021-08-23, is_quote_status = 0 and retweeted = 1 sorted by lang
This data as json, CSV (advanced)
Suggested facets: display_text_range, retweet_count, favorite_count
user 3 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||||
| 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 | ||||||||||
| 1429725966335713281 | Nebojsa (Cookie Duster) 1055736485830451200 | 2021-08-23T08:43:28+00:00 | Another awesome read from @swyx https://www.swyx.io/measuring-devrel/ Best bit: Traditional marketing advice says people have to hear about you at least 7 times before they decide to buy; for developer tools, Matt Biilmann from Netlify says it's more like 14. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 246] | 0 | 1 | 9 | 0 | 1 | 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 |
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]);