tweets

This is data scraped from swyx's timeline! See blog post

10 rows where "created_at" is on date 2021-09-22, is_quote_status = 0, retweeted = 0 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, retweet_count

user 1 ✖

source 1 ✖

  • Twitter Web App · 10 ✖

retweeted 1 ✖

is_quote_status 1 ✖

created_at (date) 1 ✖

  • 2021-09-22 · 10 ✖
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

CSV options: 

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]);