tweets

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

7 rows where favorite_count = 50 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_quote_status, retweet_count

user 2 ✖

retweeted 2 ✖

favorite_count 1 ✖

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
1197199873331757056 swyx 33521530 2019-11-20T17:07:47+00:00 I think one of the best non-invasive (aka no surveying needed) metrics of company morale is employee referrals. If referrals are consistent and/or going up, you're doing great. If they're going down or nonexistent, look out. Even applies on a per employee basis.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 264]             0 4 50 0 0   en  
1441190031939420174 swyx 33521530 2021-09-23T23:57:34+00:00 Seeking opinions - when should a startup hire its first "data person"? (not data scientist; just someone who gets data fed into one place, proactively find insights, and make it easy for others to dig up their own) whats a good milestone? B round? # employees? # "data sources"?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 1 50 0 0   en  
1441836267092709382 swyx 33521530 2021-09-25T18:45:28+00:00 Recorded next podcast with @mhevery 🔥 its a banger We talked: - @BuilderIO vs #Jamstack CMSes - @adamdbradley's Partytown - @QwikDev - Lessons from @Angular - Metabolic Health! so grateful to @ivanburazin for connecting us at @InfobipShift! Subscribe: http://youtube.com/swyxTV       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 7 50 0 0 0 en  
1448337156057882627 swyx 33521530 2021-10-13T17:17:41+00:00 Serverless Cloud follows @begin’s footsteps in full stack serverless DX. Why have @netlify and @vercel waited so long to add datastore and scheduled functions? #Jamstack space is heating up 🔥 when I wrote Self Provisioning Runtimes I had no idea people were way ahead of me 👏 https://twitter.com/goserverless/status/1448313005331005443   1448313005331005443 1448313005331005443   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 276]             1 5 50 0 0 0 en  
1449112317917110276 sunil pai, inc. 1593171 2021-10-15T20:37:54+00:00 Really good talk. This is a great slide demonstrating their programming model; to do a recurring subscription, you literally do: while(true){ charge(); sleep(30 days); } That's awesome. https://twitter.com/swyx/status/1449069225704714246 https://twitter.com/threepointone/status/1449112317917110276/photo/1   1449069225704714246 1449069225704714246   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 212]             1 1 50 0 1 0 en  
1453522590094413825 swyx 33521530 2021-10-28T00:42:45+00:00 😍 Just heard back from someone in the @Coding_Career community that they got promoted to Senior! I think that's my 3rd this year. Yeah sex is great, but, have you tried mentoring complete strangers looking for help?? and have them actually follow through your advice?? 👩‍🍳😘       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 275]             0 3 50 0 0   en  
1465793834739068932 swyx 33521530 2021-11-30T21:24:17+00:00 ✅ Achievement unlocked: led a 2 hour @temporalio live code workshop for 80 people and did not crash and burn 😹 If you're interested in our @typescript SDK, slides here and I'll post up video later this week https://docs.google.com/presentation/d/1mAPYXNmRdDKepXylB91F2uqFyHm8rG12K2PMRHxoUfM/edit?usp=sharing       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 232]             0 4 50 0 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]);