tweets

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

20 rows where favorite_count = 1 and source = "574fe4fa937eeb131136f7e3678f32d4ff3078d5" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

lang 2 ✖

is_quote_status 2 ✖

  • 0 19
  • 1 1

source 1 ✖

  • Twitter for iPad · 20 ✖

favorited 1 ✖

  • 0 20

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
1422853864328372228 swyx 33521530 2021-08-04T09:36:11+00:00 @kageman not really, these are still kinda vaguely defined in my mind so not much insight to offer yet       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [9, 102] 1422853322663358466 9496932 kageman       0 0 1 0 0   en  
1423138071415980034 swyx 33521530 2021-08-05T04:25:31+00:00 @ryanmichela i think about this video alot now as a PM working on open source distsys       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [13, 85] 1423121750116560898 226766731 ryanmichela       0 0 1 0 0   en  
1423156238062276609 swyx 33521530 2021-08-05T05:37:42+00:00 @scarypockets @drh3 this song isnt about how sweet a watermelon is??       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [20, 68] 1423153448652972032 854801089954185218 scarypockets       0 0 1 0 0   en  
1424444934476599296 swyx 33521530 2021-08-08T18:58:31+00:00 @bravelyjake devto and my site are one and the same. i didn’t particularly care about direct traffic for this one o didnt bother with the build time https://twitter.com/swyx/status/1231493665144688647   1231493665144688647 1231493665144688647   Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [13, 148] 1424431422727626757 1050397340056444928 bravelyjake       1 0 1 0 0 0 en  
1425166770273284098 swyx 33521530 2021-08-10T18:46:51+00:00 @leeb delicious and delightful!       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [6, 31] 1425164338344517632 14904098 leeb       0 0 1 0 0   en  
1425224399121117186 swyx 33521530 2021-08-10T22:35:50+00:00 @venkey_ariv retries and timeouts are our bread and butter @temporalio       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [13, 70] 1425221481076723712 1010918910 venkey_ariv       0 0 1 0 0   en  
1425224645771362309 swyx 33521530 2021-08-10T22:36:49+00:00 @evntdrvn excellent thank you! you didnt use it personally?       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [10, 59] 1425222470739582977 23587474 evntdrvn       0 0 1 0 0   en  
1426655419611508736 swyx 33521530 2021-08-14T21:22:12+00:00 @rishmishra makes sense! had to be more patient i guess. very used to wow-moment-it-all-clicks-together pilot episodes       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [12, 118] 1426653814174756866 331639736 rishmishra       0 0 1 0 0   en  
1427157733887807492 swyx 33521530 2021-08-16T06:38:13+00:00 @biiishal few understand this       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [10, 29] 1427152675812962304 1515425070 biiishal       0 0 1 0 0   en  
1427783827120816132 swyx 33521530 2021-08-18T00:06:05+00:00 @EugeneNg_VCap nice save :)       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [15, 27] 1427782927715209226 915576521129041920 EugeneNg_VCap       0 0 1 0 0   en  
1428020323098656769 swyx 33521530 2021-08-18T15:45:51+00:00 @oliviamdh @zkwentz haha thanks and hi! i mostly write for developers but also in developer marketing.       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [20, 102] 1428012113973452800 64942879 oliviamdh       0 0 1 0 0   en  
1434683689670225929 swyx 33521530 2021-09-06T01:03:41+00:00 @geoffrich_ @FredKSchott exactly       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [25, 32] 1434665721879941120 886958568427077632 geoffrich_       0 0 1 0 0   en  
1434832515378843654 swyx 33521530 2021-09-06T10:55:04+00:00 @fakebaldur ha! didnt know that! all great speeches cherry-pick for the story they tell i guess.       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [12, 96] 1434830446764961793 805850 fakebaldur       0 0 1 0 0   en  
1435361598428823558 swyx 33521530 2021-09-07T21:57:27+00:00 @jeanqasaur oh i love it when that happens! ultimate compliment from a reader!       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [12, 78] 1435347391591460869 271516623 jeanqasaur       0 0 1 0 0   en  
1436366499040608256 swyx 33521530 2021-09-10T16:30:34+00:00 @danshipper @JamesClear love how grounded he is about having one of the biggest books of the decade. writing process is eye opening in how chaotic/messy it is but it obviously works! lastly: appreciated the peek into how the “you dont rise/you fall” quote was created. something i’d like to practice!       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [24, 302] 1436348728193978369 19829693 danshipper       0 0 1 0 0   en  
1442904924493279232 swyx 33521530 2021-09-28T17:31:56+00:00 @protsaq thank you, really appreciate it! yeah when i set out to do this i felt like understanding the layers was a MAJOR breakthrough in understanding how different devs’ experiences differ!       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [9, 192] 1442885004284026893 1428836868129439752 afadadolar       0 0 1 0 0   en  
1445549625805475846 swyx 33521530 2021-10-06T00:41:02+00:00 @FoolAllTheTime oo haha you know i used to work for @sentieo right? lost the “new bloomberg” sheen a long while ago       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [16, 115] 1445539531449503752 986801772676157440 FoolAllTheTime       0 0 1 0 0   en  
1451546087366352903 swyx 33521530 2021-10-22T13:48:50+00:00 @youngwt trading hours were between 9 to 4, there was literally nothing to do at work after hours even if i wanted to       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [9, 117] 1451466578755735553 130184816 youngwt       0 0 1 0 0   en  
1460040851778785282 swyx 33521530 2021-11-15T00:23:59+00:00 @httpJunkie @ossia @thechangelog thanks Eric! 😊       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [33, 47] 1460036991781769217 1594100137 httpJunkie       0 0 1 0 0   en  
1426102164544397312 swyx 33521530 2021-08-13T08:43:46+00:00 @hhg2288 gracias Horacio!       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [9, 25] 1426100657799548931 24702345 hhg2288       0 0 1 0 0   es  

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