tweets
2 rows where "created_at" is on date 2021-10-03 and display_text_range = "[0, 280]" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||
1444560899797176321 | swyx 33521530 | 2021-10-03T07:12:11+00:00 | Unsolicited compliment: I am enjoying watching along how @9ranty is building his Loom competitor in public. Lots of little gems and the video result looks great! Worth checking out http://tella.tv Am not a regular user yet but #BuildInPublic updates keep me interested. https://twitter.com/TellaHQ/status/1443129037854019589 | 1443129037854019589 1443129037854019589 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1 | 0 | 14 | 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]);