tweets
6 rows where "created_at" is on date 2021-09-12, is_quote_status = 1 and lang = "en"
This data as json, CSV (advanced)
Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, favorite_count, created_at (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1436966057563013120 | swyx 33521530 | 2021-09-12T08:13:00+00:00 | @PCurell not exact answer but heres my research https://twitter.com/swyx/status/1239756967423467522 | 1239756967423467522 1239756967423467522 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 47] | 1436731423663267843 | 375232562 | PCurell | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
| 1437026369163124740 | swyx 33521530 | 2021-09-12T12:12:39+00:00 | @QuinnyPig @awscloud @AWScwoud this was an absolute mangled mess lmao https://twitter.com/awscwoud/status/1436520685778530307?s=21 | 1436520685778530307 1436520685778530307 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [31, 94] | 1436524584681963522 | 97114171 | QuinnyPig | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
| 1437048380958679042 | swyx 33521530 | 2021-09-12T13:40:07+00:00 | Valuable peek into what it is like to debate syntax inside @TC39, from someone who was actively involved but no longer is. This sort of thing is above my paygrade, but standards work affects us all, and I’m glad people this passionate have a voice in the future of JavaScript. https://twitter.com/BenLesh/status/1436890184449236994 | 1436890184449236994 1436890184449236994 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 277] | 1 | 1 | 33 | 0 | 0 | 0 | en | |||||||||
| 1437095732436258816 | swyx 33521530 | 2021-09-12T16:48:17+00:00 | @jamonholmgren yes! I call this Lampshading. Ignorance can be Power, when wielded correctly. https://twitter.com/swyx/status/1238321393374298112 | 1238321393374298112 1238321393374298112 | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [15, 117] | 1437089665018826754 | 30273948 | jamonholmgren | 1 | 1 | 4 | 0 | 0 | 0 | en | ||||||
| 1437132448798806017 | swyx 33521530 | 2021-09-12T19:14:11+00:00 | Another mindchanger on Tailwind! https://twitter.com/thamasky/status/1437039454967975938 | 1437039454967975938 1437039454967975938 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 32] | 1413018688077238273 | 33521530 | swyx | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
| 1437132718928695301 | swyx 33521530 | 2021-09-12T19:15:15+00:00 | expanded in a blogpost: https://twitter.com/swyx/status/1312603851581652994?s=21 | 1312603851581652994 1312603851581652994 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 47] | 1253303455961079810 | 33521530 | swyx | 1 | 1 | 4 | 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]);