tweets
4 rows where "created_at" is on date 2021-10-03, possibly_sensitive = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: is_quote_status, retweet_count, favorite_count, retweeted, lang
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1444498121854124035 | swyx 33521530 | 2021-10-03T03:02:44+00:00 | this is a worthwhile talk (direct link https://youtu.be/hV3dJur69SU) We are dealing w/ similar issues at @temporalio: how to guide someone to learn your system and be able to find the answer to every important question in the shortest time? Docs, like the SDLC, should be nonlinear. https://twitter.com/editingemily/status/1443381760935534592 | 1443381760935534592 1443381760935534592 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 0 | 5 | 0 | 0 | 0 | en | |||||||||
1444513081564930052 | swyx 33521530 | 2021-10-03T04:02:11+00:00 | RT @1scrummymummy: I love this kid. She’s got it absolutely figured out. Emma aged 8 ❤️ https://twitter.com/1scrummymummy/status/1444024564921638917/photo/1 | 1444024564921638917 1444024564921638917 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 111] | 0 | 20929 | 0 | 0 | 1 | 0 | en | |||||||||
1444477575401590787 | swyx 33521530 | 2021-10-03T01:41:05+00:00 | @suiteasdesign yup http://swyx.transistor.fm | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 42] | 1444475505638449157 | 1223050713674027008 | suiteasdesign | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
1444500886546305033 | swyx 33521530 | 2021-10-03T03:13:43+00:00 | @flybayer @cohix @planetscaledata @Cloudflare @CivoCloud @PulumiCorp @SuborbitalDev @Flightcontrolhq @temporalio https://twitter.com/swyx/status/1444500886546305033/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [112, 112] | 1444313802162454532 | 2826554209 | flybayer | 0 | 0 | 1 | 0 | 0 | 0 | und |
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]);