tweets
3 rows where "created_at" is on date 2021-09-15 and favorite_count = 2 sorted by geo
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1437993424045711365 | swyx 33521530 | 2021-09-15T04:15:23+00:00 | @simonw yes your data collection stuff is incredible!! feel like im fine with it just being on my phone though, i just never go anywhere without the phone | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 154] | 1437983950526246912 | 12497 | simonw | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1438096638405394432 | swyx 33521530 | 2021-09-15T11:05:31+00:00 | @manuelhe that’s a built in feature now ! https://twitter.com/swyx/status/1438096638405394432/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 41] | 1438003104029372419 | 17699280 | manuelhe | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1438096989653188609 | swyx 33521530 | 2021-09-15T11:06:55+00:00 | @kpk i actually changed my mind on bubble view… tried the list view and it sucked bc of aforementioned list of useless apps… with bubble view at least you can use spatial memory | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [5, 177] | 1437999771852034051 | 22915745 | kpk | 0 | 0 | 2 | 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]);