tweets

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

29 rows where "created_at" is on date 2021-11-02, favorited = 0 and retweeted = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, lang

retweet_count 6 ✖

user 2 ✖

is_quote_status 2 ✖

  • 0 27
  • 1 2

retweeted 1 ✖

created_at (date) 1 ✖

  • 2021-11-02 · 29 ✖
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
1455330889118806016 swyx 33521530 2021-11-02T00:28:17+00:00 @geddski that sounds like d&d loot       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 38] 1455325249306693636 39607761 geddski       0 0 3 0 0   en  
1455331430175625218 swyx 33521530 2021-11-02T00:30:26+00:00 @dabit3 @WebSummit @CccLisbon @SolanaConf @graphprotocol @theklineventure @reemisradd @martint holy shit, what a week 😍😍😍 jealous!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [95, 130] 1455250001202929681 17189394 dabit3       0 0 3 0 0   en  
1455331557489602560 swyx 33521530 2021-11-02T00:30:56+00:00 @kevinakwok is that where you make soft unintelligible noises munching on computer chips       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 88] 1454987970365345793 169791252 kevinakwok       0 0 1 0 0   en  
1455339517532008448 swyx 33521530 2021-11-02T01:02:34+00:00 Couple more PAGNIs here, love the security tips im probably not going to remember until i have actually bled over them https://twitter.com/spookylukey/status/1455278246816362499   1455278246816362499 1455278246816362499   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 118] 1414743878838611969 33521530 swyx       1 0 0 0 0 0 en  
1455340970053013508 swyx 33521530 2021-11-02T01:08:20+00:00 There’s nothing more wince inducing than listening to podcasters honestly review a product you worked on 3 years after launch and having them call out obviously bad ideas that should’ve never seen the light of day 😬☠️ my defense is i didnt know better!! now i do!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 265]             0 0 36 0 0   en  
1455367423134101509 swyx 33521530 2021-11-02T02:53:27+00:00 @dabit3 @WebSummit @CccLisbon @SolanaConf @graphprotocol @theklineventure @reemisradd @martint honestly at this point maybe just buy a second home in croatia or lisbon and make it your winter base       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [95, 196] 1455359529357565952 17189394 dabit3       0 0 5 0 0   en  
1455379479614812160 swyx 33521530 2021-11-02T03:41:22+00:00 @samjulien @auth0 ayy its official! congrats Sam!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 49] 1455185783518728193 14228668 samjulien       0 0 2 0 0   en  
1455394539271643137 swyx 33521530 2021-11-02T04:41:12+00:00 @katrmeil @rothgar @clare_liguori @forrestbrazeal you weren’t thaaat far off, all things considered       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [50, 99] 1455390655010639879 241147060 katrmeil       0 0 2 0 0   en  
1455399711054065665 swyx 33521530 2021-11-02T05:01:45+00:00 Got an @elgato stream deck from the lovely folks at @GitHub and immediately set it up with meme soundboard clips because i’m 12 https://twitter.com/swyx/status/1455399711054065665/video/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 127]             0 0 126 0 0 0 en  
1455399715047043074 swyx 33521530 2021-11-02T05:01:46+00:00 @threehourcoffee @elgato @github i dont understand. the elgato is for memes and memes alone (deleted original tweet bc i decided to do video instead)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [33, 150] 1455398924114485250 28257675 threehourcoffee       0 0 1 0 0   en  
1455400611273273348 swyx 33521530 2021-11-02T05:05:20+00:00 @threehourcoffee @elgato @github for srs tho im only using this because i got it free, i’d have to really take streaming seriously to pay 150 for LED buttons       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [33, 157] 1455399914721079298 28257675 threehourcoffee       0 0 1 0 0   en  
1455403410358870019 swyx 33521530 2021-11-02T05:16:27+00:00 @marcelfahle @elgato @github right now yes but im told Loopback is the main way to do it right (paid app and requires setup, but high production value memery is worth it)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [29, 170] 1455402366111469572 5408192 marcelfahle       0 0 2 0 0   en  
1455410157970616324 swyx 33521530 2021-11-02T05:43:16+00:00 @ajcwebdev @elgato @github every now and then my non-american upbringing shows: i never got into goldeneye!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 107] 1455404487015755778 30723962 ajcwebdev       0 0 1 0 0   en  
1455427803097145347 swyx 33521530 2021-11-02T06:53:23+00:00 @Idered @elgato @github ah nice call. but i associate it with sped up video..       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [24, 77] 1455423950524194818 49586611 Idered       0 0 0 0 0   en  
1455430112967495685 swyx 33521530 2021-11-02T07:02:34+00:00 @GergelyOrosz one of mine that people seemed to like recently https://twitter.com/swyx/status/1451309430830612495   1451309430830612495 1451309430830612495   Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [14, 61] 1454444182068768769 30192824 GergelyOrosz       1 0 12 0 0 0 en  
1455464347992424451 swyx 33521530 2021-11-02T09:18:36+00:00 @kevmodrome @elgato @github sure why not       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [28, 40] 1455441598200913921 37845634 kevmodrome       0 0 0 0 0   en  
1455535930660564995 Orbit 💜 1012355031549513728 2021-11-02T14:03:03+00:00 We are excited to release the first-ever Constellation Report: State of Community Tools 2021 📡 We surveyed community builders & #cmgr about the tools they use daily to gain insights on how teams are making community happen 💪🏽 https://orbit.love/constellation-report-state-of-community-tools-2021 https://twitter.com/OrbitModel/status/1455535930660564995/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 255]             0 34 72 0 0 0 en  
1455604646186086405 swyx 33521530 2021-11-02T18:36:06+00:00 @samjulien @auth0 the dinner to promo pipeline!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 47] 1455596900715876354 14228668 samjulien       0 0 2 0 0   en  
1455609835509092353 swyx 33521530 2021-11-02T18:56:43+00:00 @BenLesh @ApayRus this sold me on rxjs in 2018 but i'm still waiting for the rest of the js world to care about it honestly :(       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 126] 1455598001272016902 23795212 BenLesh       0 0 15 0 0   en  
1455612998265884678 swyx 33521530 2021-11-02T19:09:17+00:00 Finally published our most recent @temporalio meetup video featuring: 💰 How @StripeDev uses Temporal 🗺️ How we clarified our DX with Feature Maps 🎉 Our 2nd Year Anniversary! https://www.youtube.com/watch?v=xwJHaGRw9mA&feature=youtu.be       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 199]             0 1 16 0 0 0 en  
1455614172205486080 swyx 33521530 2021-11-02T19:13:57+00:00 @BenLesh @ApayRus honestly that part i had the least problem with. i kinda view Rx as a "language" that should be the same in all languages       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 139] 1455612554408075268 23795212 BenLesh       0 0 10 0 0   en  
1455625614711353345 swyx 33521530 2021-11-02T19:59:25+00:00 @AdamTuttle @sveltejs @SvelteSociety @Rich_Harris @stolinski, @BrittneyPostma, @Wattenberger, @askRodney, @onlyspaceghost, @h_i_g_s_c_h and many more! we keep an informal list of "Svelte Teachers" here https://twitter.com/i/lists/1449103461321035778?s=20       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [50, 226] 1455614810922553350 9686352 AdamTuttle       0 3 17 0 0 0 en  
1455632170312089601 swyx 33521530 2021-11-02T20:25:28+00:00 Talent is not the scarcest resource for startups. Anyone can throw money at a superstar who ends up becoming a dud — because they don't *care*. The scarcest resource is ownership mentality. And it is a raw material: still needs to be nurtured, shaped, mined, supported.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 270]             0 70 659 0 0   en  
1455641481276887040 swyx 33521530 2021-11-02T21:02:28+00:00 @seldo also they seem to have a creepy CEO who goes around buying up influencers' domains and squatting on them to try to get them onto his platform 🤮       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [7, 150] 1455640706786099203 15453 seldo       0 0 15 0 0   en  
1455642088092024833 swyx 33521530 2021-11-02T21:04:52+00:00 @mateusjatenee i agree that key employees do not get enough equity as a general rule of how startup capitalism works. however there is such a thing as "career capital" and it is possible to cash it in       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 200] 1455636492336959488 192739407 mateusjatenee       0 0 16 0 0   en  
1455646029416566787 swyx 33521530 2021-11-02T21:20:32+00:00 @JessTelford @ceteio the text is irrelevant to me compared to giving me suggestions for the textbox instead of making me think https://twitter.com/swyx/status/1455646029416566787/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 126] 1455503402079637511 54400793 JessTelford       0 0 2 0 0 0 en  
1455648587459612674 swyx 33521530 2021-11-02T21:30:42+00:00 *and REWARDED. Reward aligned ownership please! can't believe i left that out 🤦‍♂️ also i am somewhat making fun of myself because my weakness really *is* that I care too much i guess what i'm saying is @paparoach has a standing offer to work with us https://www.youtube.com/watch?v=eHbNU9WuVgw       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1455632170312089601 33521530 swyx       0 2 33 0 0 0 en  
1455650024562429957 swyx 33521530 2021-11-02T21:36:25+00:00 @aontaneda @matteocollina agree that market rate for early employees doesnt accurately reflect their value add. but as long as the terms are clear and promises are kept, then consenting adults should be able to make that trade, including for speculative/non monetary motivations       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 278] 1455648043215245317 126809336 aontaneda       0 0 3 0 0   en  
1455681172218859520 swyx 33521530 2021-11-02T23:40:11+00:00 @samjulien @CascadiaJS 🙌       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 24] 1455678832115994629 14228668 samjulien       0 0 3 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]);