tweets

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

18 rows where "created_at" is on date 2021-08-15, favorited = 0 and retweeted = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, favorite_count, lang

retweet_count 4 ✖

is_quote_status 2 ✖

  • 0 17
  • 1 1

retweeted 1 ✖

quoted_status 1 ✖

created_at (date) 1 ✖

  • 2021-08-15 · 18 ✖
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
1426711010291847170 swyx 33521530 2021-08-15T01:03:06+00:00 anonymized DM https://twitter.com/swyx/status/1426711010291847170/photo/1       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 13] 1426672482975551490 33521530 swyx       0 0 109 0 0 0 en  
1426715351446736899 swyx 33521530 2021-08-15T01:20:21+00:00 @Julian @amandanat @jwmares @DruRly @Backlinko @fadeke_adegbuyi @lennysan @packyM @ali_montag @MorningBrew @theskimm @JamesClear @scottsflights wait what? james clear is link roundups? did you mean to tag someone else? his newsletter is just quotes       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [144, 248] 1426614458495901700 293815131 Julian       0 0 2 0 0   en  
1426720722940960776 swyx 33521530 2021-08-15T01:41:42+00:00 @Julian @amandanat @jwmares @DruRly @Backlinko @fadeke_adegbuyi @lennysan @packyM @ali_montag @MorningBrew @theskimm @JamesClear @scottsflights i mean i can think of dozens of link roundup letters but nothing with james comes to mind haha i’ll throw in a free plug for @litcapital’s letter. its the kind of daily financial markets link roundup i used to get from sellside brokers. very good for skimming thru datapoints.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [144, 421] 1426716246813200391 293815131 Julian       0 0 1 0 0   en  
1426723425565876230 swyx 33521530 2021-08-15T01:52:26+00:00 @iansu glad you got it haha       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [7, 27] 1426722986782969857 15755614 iansu       0 0 1 0 0   en  
1426729722319282182 swyx 33521530 2021-08-15T02:17:27+00:00 @Mike_Andreuzza saw you are shutting down TUF. looking fwd to whats next, pls send major updates on email       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [16, 105] 1426428704884994054 953420111305760769 Mike_Andreuzza       0 0 2 0 0   en  
1426749508524797952 swyx 33521530 2021-08-15T03:36:05+00:00 Random idea: “Information Dietician” Studies the difference between what you consume and what you want to produce and gives you a plan for diet change, with weekly group checkins.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 180]             0 3 74 0 0   en  
1426918866052132870 Big Tech Alert 1042038539800731650 2021-08-15T14:49:03+00:00 👥 @uber is now following @ponyheadson       Stuff F e5f554c6214aad6e1c1eda8f85df8098e77da7c3 0 [0, 37]             0 0 3 0 0   en  
1426949687714598919 swyx 33521530 2021-08-15T16:51:31+00:00 @shreyas Most people are presented with ladders and their entire goal in life is to climb to the next rung. Smart people make the ladders.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 139] 1426946595677872133 2048741 shreyas       0 9 78 0 0   en  
1426955362507231232 swyx 33521530 2021-08-15T17:14:04+00:00 @kevinakwok I've been trying to articulate a "Dunbar Limit of Giving a Crap" - below which, people feel overall ownership of the product - above which, agency is separated from execution to the point that "if it doesnt impact a metric it doesn't matter"       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 256] 1426953742377701377 169791252 kevinakwok       0 0 2 0 0   en  
1426955859238608897 swyx 33521530 2021-08-15T17:16:03+00:00 @rosiesherry @patrickjwoods i really really like this one       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 57] 1423625567820083203 2204961 rosiesherry       0 0 2 0 0   en  
1426972669468045318 hiten.eth 3382 2021-08-15T18:22:50+00:00 Every piece of business advice should have a label that includes what stage of a startup it’s applicable for. Since these labels don’t exist today, your job is to filter the advice against whether it’s relevant at your current stage and for your startup. This is learned by doing.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280] 1426971885628116994 3382 hnshah       0 20 223 0 0   en  
1427006487503597568 swyx 33521530 2021-08-15T20:37:13+00:00 @VinnyLingham i see it's A/B testing day https://twitter.com/swyx/status/1427006487503597568/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 40] 1426998497237094403 1854401 VinnyLingham       0 0 23 0 0 0 en  
1427008742797709312 swyx 33521530 2021-08-15T20:46:11+00:00 All metrics have exceptions but you can roughly break up startups into stages by employee count: 2 founders 20 employees 200 employees 2,000 employees <- probably a unicorn 20k employees 200k employees All advice has a relevance interval and it's possible to learn the tells. https://twitter.com/hnshah/status/1426972669468045318   1426972669468045318 1426972669468045318   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 281]             1 0 18 0 0 0 en  
1427008893784236033 swyx 33521530 2021-08-15T20:46:47+00:00 @abhhnv honestly i was just subtweeting like 10 people at once i didnt think that this would register on the Twitter "startups" topic lol       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 137] 1426817785242345473 1135196462772416513 abhhnv       0 0 2 0 0   en  
1427011360383115266 swyx 33521530 2021-08-15T20:56:35+00:00 @spitleaf should have posed on the right, then it would say "leet coder"       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 72] 1427008273274843141 357427736 spitleaf       0 0 2 0 0   en  
1427011786331484161 swyx 33521530 2021-08-15T20:58:17+00:00 @jmj wow am i really the first person to suggest the OG collectibles stamps coins comic books rare books treasure maps on the back of the Declaration of Independence       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [5, 166] 1427007636004773890 11922492 jmj       0 0 8 0 0   en  
1427019802430754819 swyx 33521530 2021-08-15T21:30:08+00:00 This week's newsletter will have a preview of my next post: "Measuring Developer Relations" https://www.swyx.io/subscribe/ I started out writing an "Advice for New Devrels" article for @willjohnsonio, @jkup, @kevmodrome, @Nutlope and others but it just blew up into a whole series 😅 https://twitter.com/swyx/status/1427019802430754819/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 3 27 0 0 0 en  
1426951029052956673 swyx 33521530 2021-08-15T16:56:51+00:00 @stefanjudis https://twitter.com/swyx/status/1426951029052956673/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 12] 1426950409629937669 380616577 stefanjudis       0 0 22 0 0 0 und  

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