tweets
4 rows where "created_at" is on date 2021-09-12 and retweet_count = 1 sorted by lang
This data as json, CSV (advanced)
Suggested facets: is_quote_status, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1436960825005252610 | swyx 33521530 | 2021-09-12T07:52:12+00:00 | @maninak_ 43mb! i hope they were building photoshop or something. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 65] | 1436959270285815809 | 1408407818558918666 | maninak_ | 0 | 1 | 5 | 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 | ||||||
| 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]);