tweets
19 rows where "created_at" is on date 2021-09-22, favorited = 0 and retweeted = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, favorite_count, lang
quoted_status 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1440513594207059983 | swyx 33521530 | 2021-09-22T03:09:38+00:00 | If you started a company right now where the entire pitch deck was “something something devtools” and the 🤷♂️ emoji for a logo, you’d probably be able to raise a $5m seed | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 171] | 0 | 7 | 282 | 0 | 0 | en | |||||||||||
1440514869715898376 | swyx 33521530 | 2021-09-22T03:14:43+00:00 | @TrungTPhan damn son is there such a thing as a QT ratio cuz you got ratioed hard https://twitter.com/i_zzzzzz/status/1440053089822601216?s=21 | 1440053089822601216 1440053089822601216 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 105] | 1403475948477976577 | 945817135816654848 | TrungTPhan | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1440545613267955712 | swyx 33521530 | 2021-09-22T05:16:52+00:00 | @daniel_levine 😝 im so unprepared i am still looking for a solution that is looking for a problem | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 97] | 1440534305436946437 | 14989226 | daniel_levine | 0 | 0 | 9 | 0 | 0 | en | ||||||||
1440550607299829769 | swyx 33521530 | 2021-09-22T05:36:43+00:00 | @JustJake its still yours tho there's a JSON on the block chain that says you have it | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 85] | 1440547747711492101 | 607528502 | JustJake | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1440550840947724293 | swyx 33521530 | 2021-09-22T05:37:39+00:00 | @AndaristRake @jmapping @typescript @replayio @KaaFury @lmatteis @_jonesian 42 minutes!!!👀👀 hey @replayio start a youtube already | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [76, 130] | 1440548253582323720 | 2587563212 | AndaristRake | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1440557824203919367 | swyx 33521530 | 2021-09-22T06:05:24+00:00 | behold my elevator pitch https://twitter.com/swyx/status/1426672482975551490 | 1426672482975551490 1426672482975551490 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 26] | 1440513594207059983 | 33521530 | swyx | 1 | 0 | 35 | 0 | 0 | 0 | en | ||||||
1440692266499145738 | swyx 33521530 | 2021-09-22T14:59:37+00:00 | @hsablonniere im not being precise to git tag dates, just rough guesstimate of when a project was "launched", mostly by googling "when was X launched/started" | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 158] | 1440690152842555392 | 131838592 | hsablonniere | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1440729799928938498 | swyx 33521530 | 2021-09-22T17:28:46+00:00 | @Codydearkland hey thank you for joining us!! let me know if any quotes resonated so I can make sure to repeat them in future haha and I'm sorry we didnt get around to answering all the questions, but I'd be happy to take them as blogpost fodder if you wanna shoot em here or in email! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 287] | 1440722987896827913 | 187678001 | Codydearkland | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1440729994058108931 | swyx 33521530 | 2021-09-22T17:29:32+00:00 | @HodGreeley haha yes people really like that line! thank you for joining us!! let me know if any other quotes resonated so I can make sure to repeat them in future haha let me know if you have other qtns as well btw | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 218] | 1440724829716369419 | 22571664 | HodGreeley | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1440731412538138626 | swyx 33521530 | 2021-09-22T17:35:10+00:00 | @HodGreeley yes @temporalio has a booth and we're hosting a happy hour too! instructions here https://docs.temporal.io/blog/temporal-transparency-update-12#kubecon | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 117] | 1440730801386131469 | 22571664 | HodGreeley | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1440737677909770240 | swyx 33521530 | 2021-09-22T18:00:04+00:00 | the "pls sign NDA so you don't steal my startup idea" to "how do I reach more people" pipeline | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 94] | 0 | 5 | 119 | 0 | 0 | en | |||||||||||
1440765132871651332 | swyx 33521530 | 2021-09-22T19:49:10+00:00 | @mcadonofrio these add up to 105%? is the average $100mm+ company at an operating loss? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 87] | 1440351903766888466 | 1045367135394922496 | mcadonofrio | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1440768215529914372 | swyx 33521530 | 2021-09-22T20:01:25+00:00 | @macrocephalopod @ConejoCapital wait isn't that buying, not selling skew | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [32, 72] | 1440736372185202690 | 1341087029048827904 | macrocephalopod | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1440770261825953796 | swyx 33521530 | 2021-09-22T20:09:33+00:00 | @mcadonofrio 😅 growth is expensive! thank you for these stats, very helpful. some data i'd like to track if u are keen in future - correlate behavior/activity with user count. aka what do various company profiles look like at 100, 1000, 100k, 1m active users | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 259] | 1440769609506848771 | 1045367135394922496 | mcadonofrio | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1440797518749601803 | swyx 33521530 | 2021-09-22T21:57:51+00:00 | Quite a few questions on Smart Servers so far. Coincidentally @chris_mccord just published about their path to Phoenix Liveview, which is worth a look for what the Smart Server paradigm can do https://fly.io/blog/how-we-got-to-liveview/ amazing scoop for @flydotio in hiring him!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 262] | 1439966955570618376 | 33521530 | swyx | 0 | 0 | 14 | 0 | 0 | 0 | en | |||||||
1440801054967287812 | swyx 33521530 | 2021-09-22T22:11:54+00:00 | @geddski join @SvelteSociety you know you want to | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 51] | 1440762195223089164 | 39607761 | geddski | 0 | 0 | 17 | 0 | 0 | en | ||||||||
1440801558996738052 | swyx 33521530 | 2021-09-22T22:13:55+00:00 | @Netlify @ascorbic whats the ruling on whether we are calling it DPR or DSG? any thoughts on how to reduce jargon overload? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [19, 123] | 1440772641778921474 | 2571501973 | Netlify | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1440820274820124674 | swyx 33521530 | 2021-09-22T23:28:17+00:00 | @adamwathan @coreyhainesco @theandreboso wow that took a dark turn | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [41, 66] | 1440815961393668096 | 716933677 | adamwathan | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1440561141688659970 | swyx 33521530 | 2021-09-22T06:18:35+00:00 | @robhope ❤️ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 11] | 1440245518513278976 | 14931736 | robhope | 0 | 0 | 1 | 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]);