tweets
5 rows where "created_at" is on date 2021-10-28 and favorite_count = 2 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, is_quote_status, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1453516525172715530 | swyx 33521530 | 2021-10-28T00:18:39+00:00 | @lorendsr @stubailo @stolinski i think this is where I plug the food delivery app that Loren has been working on while he's been contracting with us on our TS SDK :) https://github.com/lorensr/food-delivery/blob/main/pages/api/orders/index.ts this is all that is needed to kick off an order | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [31, 239] | 1453501197609054215 | 215488966 | lorendsr | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1453532106563338241 | swyx 33521530 | 2021-10-28T01:20:34+00:00 | @anildash honestly out of the possible range of things to emerge from before you were famous, this has got to be up there in terms of “makes you relatable and even more endearing” | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 179] | 1453368190763929602 | 36823 | anildash | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1453560383306809350 | swyx 33521530 | 2021-10-28T03:12:55+00:00 | @robwalling started very strong! loved the meta discussion about what makes it a good podcast and then the joke about “sooo what have you built” 😂 got a good lol out of me | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 171] | 1453523669322539012 | 86174269 | robwalling | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1453793577364905984 | swyx 33521530 | 2021-10-28T18:39:33+00:00 | got a really nice note from a mixtape listener today :) :) i joined @jerodsanto and @adamstac on the @changelog podcast yesterday (episode coming up next week!) and we were really excited about the mixtape format: - short clips - with commentary - eclectic lootbox of curation https://twitter.com/swyx/status/1398108861354057728 https://twitter.com/swyx/status/1453793577364905984/photo/1 | 1398108861354057728 1398108861354057728 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 303] | 1 | 0 | 2 | 0 | 0 | 0 | en | |||||||||
1453537742986493955 | swyx 33521530 | 2021-10-28T01:42:58+00:00 | @ken_wheeler hahahahhaa omg unintentional burns | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 47] | 1453532433895276545 | 167193309 | ken_wheeler | 0 | 0 | 2 | 0 | 0 | nl |
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]);