tweets
10 rows where "created_at" is on date 2021-09-22, is_quote_status = 0, retweeted = 0 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, retweet_count, favorite_count
in_reply_to_screen_name 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
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 |
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]);