tweets
2 rows where "created_at" is on date 2021-09-06 and in_reply_to_user_id = 257765996 sorted by id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1434792862047215616 | swyx 33521530 | 2021-09-06T08:17:30+00:00 | @markdalgleish @seekjobs end of an era! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 39] | 1434675478070104066 | 257765996 | markdalgleish | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1434809253152362496 | swyx 33521530 | 2021-09-06T09:22:38+00:00 | @markdalgleish @rainbowdotme congrats! if you get the time i’d really love a good ol’ blogpost on what specifically draws you to crypto in general, and Rainbow in particular. this space is full of hucksters so always meaningful to have perspectives from “real” folks | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [29, 266] | 1434677066692116483 | 257765996 | markdalgleish | 0 | 1 | 26 | 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]);