tweets
15 rows where "created_at" is on date 2021-08-14 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1426398256494366724 | swyx 33521530 | 2021-08-14T04:20:20+00:00 | @cunrakes @FinJoTheGreat @cherthedev @eerac solution to problem shouldnt exist because problem shouldnt exist | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [44, 109] | 1426318578282909696 | 50191852 | cunrakes | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1426404062916878338 | swyx 33521530 | 2021-08-14T04:43:24+00:00 | @remix_run woww some movement again! congrats team! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 51] | 1426293872972361735 | 1250847387062419456 | remix_run | 0 | 0 | 8 | 0 | 0 | en | ||||||||
1426405785832095749 | Charity Majors 90488576 | 2021-08-14T04:50:15+00:00 | Ever wondered what columnar databases are, or peered skeptically at my claim that you basically can't have observability without one? Read this piece, and wonder no more. (Also HOLY SHIT this blew my mind and is my favorite article of 2021 to date! Five stars ⭐⭐⭐⭐⭐) 🤣 https://twitter.com/honeycombio/status/1425853831775129601 | 1425853831775129601 1425853831775129601 | San Francisco 5a110d312052166f | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 269] | 1 | 43 | 243 | 0 | 1 | 0 | en | ||||||||
1426410836784861187 | swyx 33521530 | 2021-08-14T05:10:19+00:00 | @anothercohen doing this with devtools if anyone else browsing this is a developer https://twitter.com/swyx/status/1357105644810063873 | 1357105644810063873 1357105644810063873 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 82] | 1426397577218457602 | 557440724 | anothercohen | 1 | 0 | 2 | 0 | 0 | 0 | en | ||||||
1426606285269602308 | swyx 33521530 | 2021-08-14T18:06:58+00:00 | RT @mipsytipsy: Ever wondered what columnar databases are, or peered skeptically at my claim that you basically can't have observability wi… | 1426405785832095749 1426405785832095749 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1 | 43 | 0 | 0 | 1 | en | ||||||||||
1426628337137459200 | swyx 33521530 | 2021-08-14T19:34:35+00:00 | @earthlingworks white guy gets opportunity he is completely unqualified for and gains acceptance anyway with hokey aphorisms and faith in humanity. i enjoy it but totally get that escapist fantasy is a reason for its popularity. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 228] | 1426379951830224900 | 15554773 | earthlingworks | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1426638568714227712 | swyx 33521530 | 2021-08-14T20:15:15+00:00 | i was wondering how long until i saw my meme in the wild. https://twitter.com/sparkleops/status/1426401808814018563?s=21 10 days. it took 10 days | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 108] | 1423025792783568899 | 33521530 | swyx | 1 | 0 | 17 | 0 | 0 | 0 | en | |||||||
1426641493784096770 | swyx 33521530 | 2021-08-14T20:26:52+00:00 | @theshteves only if it gets more and more deep fried each time preferably with people taking photos of their screens with phone camera and bad lighting | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 151] | 1426641076086087682 | 805074422 | theshteves | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1426652916534845441 | swyx 33521530 | 2021-08-14T21:12:15+00:00 | @rishmishra ok i will have to give it another go again. first few episodes i got confused with all the locations and names and never really got invested in the story | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 165] | 1426636171665461249 | 331639736 | rishmishra | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1426653705567277060 | swyx 33521530 | 2021-08-14T21:15:24+00:00 | @joshnuss @stolinski this is the serverless version of Jamstack 👍 started with the “just static files” stuff but as serverless becomes more commoditized it is spreading out. commercial incentives to tie to proprietary features are very high but Sveltekit is the first independent implementation. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [21, 297] | 1426379638788534274 | 14144788 | joshnuss | 0 | 0 | 8 | 0 | 0 | en | ||||||||
1426668827585118208 | swyx 33521530 | 2021-08-14T22:15:29+00:00 | @rishmishra @tonycassara2 new aspiration: be so rich i can rescue my favorite shows | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 83] | 1426668464828256265 | 331639736 | rishmishra | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1426670450613002241 | swyx 33521530 | 2021-08-14T22:21:56+00:00 | @simonw @rachelnabors the economist’s explanation is underrated: you can decompose an economy’s total output into a mix of capital and labor multiplied by technology as a dev your labor (code) can harness capital (computers) far more than anyone bar financiers, plus a % chance of improving technology | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 302] | 1426632495957561345 | 12497 | simonw | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1426672482975551490 | swyx 33521530 | 2021-08-14T22:30:00+00:00 | Passwordless no code low code creator economy cohort based buy now pay later mRNA CRISPR lab grown space blockchain | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 115] | 0 | 40 | 522 | 0 | 0 | en | |||||||||||
1426605467829039104 | swyx 33521530 | 2021-08-14T18:03:43+00:00 | @mtliendo @hashnode excellent choice | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [20, 36] | 1426274840529494017 | 749995687 | mtliendo | 0 | 0 | 2 | 0 | 0 | fr | ||||||||
1426651460901642242 | swyx 33521530 | 2021-08-14T21:06:28+00:00 | @theshteves https://knowyourmeme.com/memes/deep-fried-memes | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 35] | 1426642548492222465 | 805074422 | theshteves | 0 | 0 | 0 | 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]);