tweets
2 rows where "created_at" is on date 2021-09-01 and favorite_count = 8 sorted by lang descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1432902144139558917 | swyx 33521530 | 2021-09-01T03:04:27+00:00 | @mitchellh @JordiMonPMM if you’re interested i made an alternative query builder UI for Twitter: https://bettertwitter.netlify.app/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 120] | 1432769589516009472 | 12819682 | mitchellh | 0 | 0 | 8 | 0 | 0 | 0 | en | |||||||
1433117668156928004 | swyx 33521530 | 2021-09-01T17:20:52+00:00 | This is not to say that if you can’t figure it out, it’s not your fault: we are tremendously bad at documenting our code, and documenting our journeys. Seek out your dev community for help, and remember how this feels when its your turn to see newer devs struggling. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 267] | 1432977957388120064 | 33521530 | swyx | 0 | 1 | 8 | 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]);