tweets
2 rows where "created_at" is on date 2021-09-06 and retweet_count = 1 sorted by lang
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
1434966467909402629 | swyx 33521530 | 2021-09-06T19:47:20+00:00 | i go through big crashes in confidence with my writing so comments like these really make my day 😊 for those who want more tips on writing process, I have a little trilogy! starting with Mise en Place Writing: https://twitter.com/swyx/status/1241858255195865090 https://twitter.com/swyx/status/1434966467909402629/photo/1 | 1241858255195865090 1241858255195865090 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 235] | 1 | 1 | 31 | 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]);