[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_177":178,"_179":180},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_132":-5,"_20":133,"_22":134,"_135":136,"_137":138,"_26":139,"_24":140,"_141":142,"_143":144,"_145":48,"_146":147,"_148":65,"_149":-5,"_150":-5,"_151":152},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":-5,"_31":-5,"_32":-5},"handle","stevekrouse","name","yc_finder","branchName","main","version","path","main.tsx","project",{"_33":89,"_13":14,"_35":90,"_46":-5,"_91":65,"_49":50,"_92":50,"_93":-5,"_94":-5,"_95":96,"_97":58,"_98":65,"_99":-5,"_100":-5,"_101":102,"_52":53,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":108,"_109":108,"_110":111,"_112":111,"_113":111,"_114":108,"_115":108,"_116":117,"_118":119,"_120":121,"_47":48},"tree",[75,76],"file",{"_33":56,"_13":19,"_57":58,"_59":-5,"_60":61,"_62":63,"_64":65,"_35":66,"_17":67,"_68":69,"_70":71,"_72":48,"_73":-5,"_18":74},"contents",[],"upstream",{"_33":34,"_35":36,"_37":38,"_13":16,"_39":40,"_17":41,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":12,"_52":53,"_54":55},"pull","ahead","behind","id","9c06e95c-25f0-11f0-ad23-569c3dd06744","createdAt",["D",1746037578853],"updatedAt",["D",1732031240039],"projectId","9c06b676-25f0-11f0-ad23-569c3dd06744",18,"forkedBranchId","forkedBranchVersion","lockfileKey","1746049389286-esm.town_v_stevekrouse_yc_database@18-main","deletedAt","isOwned",false,"privacy","public","userHandle","orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","projectName","yc_database","a7ba6702-1bcc-11f0-ac7b-569c3dd06744","fileId","a7547014-1bcc-11f0-ac7b-569c3dd06744","parentId","branchId","a75204d2-1bcc-11f0-ac7b-569c3dd06744","branchVersion",23,"latest",true,["D",1732035300587],22,"fileType","http","content","/** @jsxImportSource https://esm.sh/react */\nimport { csvParse } from \"https://esm.sh/d3-dsv@3.0.1\";\nimport React, { useEffect, useState } from \"https://esm.sh/react\";\nimport { createRoot } from \"https://esm.sh/react-dom/client\";\n\ninterface YCCompany {\n Company: string;\n Website: string;\n Size: string;\n Sector: string;\n Batch: string;\n Status: string;\n Tags: string;\n}\n\nconst DEFAULT_CSV = `email,name\npatrick@stripe.com,Patrick Collison\nbrian@airbnb.com,Brian Chesky\ndrew@dropbox.com,Drew Houston\nsam@openai.com,Sam Altman\ntim@apple.com,Tim Cook\njeff@amazon.com,Jeff Bezos\n`;\n\nfunction Hero() {\n return (\n

YC Company Employee Finder

Discover Y Combinator company employees in your user list

\n );\n}\n\nfunction HowItWorks() {\n return (\n

How It Works

Upload your CSV file or paste CSV data containing user emails under a column named \"email\"
We extract email domains from your user list
\n We match these domains against our database of YC companies (sourced{\" \"}\n \n here\n \n , cached here)\n
You get a detailed report of matches, enriched with YC company data
This is done entirely client-side. None of your data hits our servers or is stored

\n );\n}\n\nfunction App() {\n const [ycCompanies, setYcCompanies] = useState([]);\n const [mergedData, setMergedData] = useState([]);\n const [debugInfo, setDebugInfo] = useState(\"\");\n const [isLoading, setIsLoading] = useState(false);\n const [showDebug, setShowDebug] = useState(false);\n const [csvText, setCsvText] = useState(DEFAULT_CSV);\n\n useEffect(() => {\n const fetchYCCompanies = async () => {\n const storedCompanies = localStorage.getItem(\"ycCompanies\");\n if (storedCompanies) {\n const companies = JSON.parse(storedCompanies);\n setYcCompanies(companies);\n setDebugInfo(prevInfo => prevInfo + `\\nLoaded ${companies.length} companies from localStorage`);\n } else {\n const response = await fetch(\"/companies.json\");\n const companies = await response.json();\n setYcCompanies(companies);\n localStorage.setItem(\"ycCompanies\", JSON.stringify(companies));\n setDebugInfo(prevInfo =>\n prevInfo + `\\nFetched ${companies.length} companies from server and stored in localStorage`\n );\n }\n };\n fetchYCCompanies();\n }, []);\n\n const handleFileUpload = (event: React.ChangeEvent) => {\n const file = event.target.files?.[0];\n if (file) {\n setIsLoading(true);\n setDebugInfo(prevInfo => prevInfo + `\\nFile selected: ${file.name}`);\n const reader = new FileReader();\n reader.onload = (e) => {\n const csv = e.target?.result as string;\n setCsvText(csv);\n setDebugInfo(prevInfo => prevInfo + `\\nCSV loaded, length: ${csv.length} characters`);\n };\n reader.readAsText(file);\n }\n };\n\n const handleSubmit = (event: React.FormEvent) => {\n event.preventDefault();\n setIsLoading(true);\n processCSV(csvText);\n };\n\n const processCSV = (csv: string) => {\n const records = csvParse(csv);\n setDebugInfo(prevInfo => prevInfo + `\\nParsed CSV, ${records.length} records found`);\n let matchCount = 0;\n const processedData = records.map((record: any) => {\n if (!record.email) {\n setDebugInfo(prevInfo => prevInfo + `\\nSkipped record: No email field`);\n return null;\n }\n const domain = extractDomain(record.email);\n setDebugInfo(prevInfo => prevInfo + `\\nProcessing email: ${record.email}, extracted domain: ${domain}`);\n const matchedCompany = findMatchingCompany(domain);\n if (matchedCompany) {\n matchCount++;\n setDebugInfo(prevInfo => prevInfo + `\\nMatched company: ${matchedCompany.Company}`);\n return { ...record, ...matchedCompany };\n }\n setDebugInfo(prevInfo => prevInfo + `\\nNo match found for domain: ${domain}`);\n return null;\n }).filter(Boolean);\n setDebugInfo(prevInfo =>\n prevInfo + `\\nProcessing complete. ${matchCount} matches found out of ${records.length} records`\n );\n setMergedData(processedData);\n setIsLoading(false);\n };\n\n const extractDomain = (email: string) => {\n const domain = email.split(\"@\")[1];\n return domain.replace(/^(https?:\\/\\/)?(www\\.)?/, \"\").replace(/\\/$/, \"\");\n };\n\n const findMatchingCompany = (domain: string) => {\n return ycCompanies.find(company => {\n const companyDomain = company.Website.replace(/^(https?:\\/\\/)?(www\\.)?/, \"\").replace(/\\/$/, \"\");\n return companyDomain === domain;\n });\n };\n\n const toggleDebug = () => {\n setShowDebug(!showDebug);\n };\n\n const debugButtonStyle = {\n position: \"fixed\" as const,\n bottom: \"20px\",\n right: \"20px\",\n zIndex: 1000,\n };\n\n return (\n

\n \n \n

Upload Your CSV or Paste CSV Data

\n\n {mergedData.length > 0 && (\n

Results

{mergedData.length} YC company employees found in your list!

\n \n \n \n {Object.keys(mergedData[0]).map(key => )}\n \n \n \n {mergedData.map((row, index) => (\n \n {Object.values(row).map((value: any, cellIndex) => )}\n \n ))}\n \n

{key}
{value}

\n )}\n\n \n\n

Debug Information

YC Companies Data (First 5 Rows)

{JSON.stringify(ycCompanies.slice(0, 5), null, 2)}

Processing Log

{debugInfo}

\n\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")!).render();\n}\n\nif (typeof document !== \"undefined\") {\n client();\n}\n\nexport default async function server(request: Request): Promise {\n const companies = await fetch(\"https://stevekrouse-yc_database.web.val.run\").then(res => res.json());\n const url = new URL(request.url);\n if (url.pathname === \"/companies.json\") {\n return new Response(JSON.stringify(companies), {\n headers: { \"content-type\": \"application/json\" },\n });\n }\n\n return new Response(\n `\n \n \n \n \n \n YC Company Employee Finder\n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"content-type\": \"text/html\" },\n },\n );\n}\n\nconst css = `\n:root {\n --primary-color: #ff6600;\n --secondary-color: #2c3e50;\n --background-color: #f8f9fa;\n --text-color: #333;\n}\n\nbody {\n font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\n line-height: 1.6;\n color: var(--text-color);\n background-color: var(--background-color);\n margin: 0;\n padding: 0;\n}\n\n.container {\n max-width: 1200px;\n margin: 0 auto;\n padding: 20px;\n}\n\n.hero {\n background-color: var(--primary-color);\n color: white;\n padding: 40px 20px;\n text-align: center;\n border-radius: 8px;\n margin-bottom: 30px;\n}\n\n.hero h1 {\n font-size: 2.5em;\n margin-bottom: 10px;\n}\n\n.hero p {\n font-size: 1.2em;\n max-width: 600px;\n margin: 0 auto;\n}\n\n.how-it-works {\n background-color: white;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n margin-bottom: 30px;\n}\n\n.how-it-works h2 {\n color: var(--secondary-color);\n margin-bottom: 20px;\n}\n\n.how-it-works ol {\n padding-left: 20px;\n}\n\n.how-it-works li {\n margin-bottom: 10px;\n}\n\n.upload-section {\n background-color: white;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n margin-bottom: 30px;\n}\n\n.upload-section h2 {\n color: var(--secondary-color);\n margin-bottom: 20px;\n}\n\ninput[type=\"file\"] {\n display: block;\n margin-bottom: 20px;\n padding: 10px;\n border: 2px solid var(--primary-color);\n border-radius: 4px;\n width: 100%;\n}\n\ntextarea {\n width: 100%;\n margin-bottom: 20px;\n padding: 10px;\n border: 2px solid var(--primary-color);\n border-radius: 4px;\n font-family: inherit;\n font-size: 14px;\n}\n\n.loader {\n text-align: center;\n font-weight: bold;\n color: var(--primary-color);\n margin-top: 20px;\n}\n\n.results-section {\n background-color: white;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n margin-bottom: 30px;\n overflow-x: auto;\n}\n\n.results-section h2 {\n color: var(--secondary-color);\n margin-bottom: 20px;\n}\n\ntable {\n width: 100%;\n border-collapse: collapse;\n margin-top: 20px;\n}\n\nth, td {\n border: 1px solid #ddd;\n padding: 12px;\n text-align: left;\n}\n\nth {\n background-color: var(--primary-color);\n color: white;\n}\n\ntr:nth-child(even) {\n background-color: #f2f2f2;\n transition: background-color 0.3s ease;\n}\n\n.debug-section {\n background-color: white;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n margin-top: 20px;\n margin-bottom: 30px;\n}\n\n.debug-section h2, .debug-section h3 {\n color: var(--secondary-color);\n margin-bottom: 20px;\n}\n\n.debug-content {\n max-height: 500px;\n overflow-y: auto;\n}\n\npre {\n background-color: #f0f0f0;\n padding: 15px;\n border-radius: 5px;\n white-space: pre-wrap;\n word-wrap: break-word;\n font-size: 14px;\n}\n\nfooter {\n text-align: center;\n margin-top: 30px;\n padding: 20px;\n background-color: var(--secondary-color);\n color: white;\n border-radius: 8px;\n}\n\nfooter a {\n color: var(--primary-color);\n text-decoration: none;\n}\n\nfooter a:hover {\n text-decoration: underline;\n}\n\nbutton {\n background-color: var(--secondary-color);\n color: white;\n border: none;\n padding: 10px 15px;\n border-radius: 5px;\n cursor: pointer;\n transition: background-color 0.3s ease;\n}\n\nbutton:hover {\n background-color: #34495e;\n}\n`;","deleted","label",[19],{"_33":81,"_13":82,"_57":83,"_59":-5,"_60":61,"_62":84,"_64":65,"_35":85,"_17":86,"_68":24,"_70":-5,"_72":48,"_73":-5,"_78":87,"_18":88},{"_33":56,"_13":19,"_57":58,"_59":-5,"_60":61,"_62":63,"_64":65,"_35":77,"_17":67,"_68":69,"_70":-5,"_72":48,"_73":-5,"_78":79,"_18":80},["D",1732035300587],"children",[],[19],"a7548e00-1bcc-11f0-ac7b-569c3dd06744","README.md","a7548eaa-1bcc-11f0-ac7b-569c3dd06744",1,["D",1732030414473],0,[],[82],"a751b4fa-1bcc-11f0-ac7b-569c3dd06744",["D",1744922624289],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",2,"tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_131":127},"org",{"_11":12,"_125":-5,"_126":127,"_95":96,"_128":129,"_130":48},"branch",{"_17":63,"_13":16,"_33":61,"_39":89,"_42":34,"_43":86,"_122":50,"_123":40,"_124":53,"_54":14,"_51":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":89,"_13":14,"_35":173,"_46":-5,"_91":65,"_49":50,"_92":50,"_93":-5,"_94":-5,"_95":96,"_97":58,"_98":65,"_99":-5,"_100":-5,"_101":102,"_52":53,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":108,"_109":108,"_110":111,"_112":111,"_113":111,"_114":108,"_115":108,"_116":174,"_118":175,"_120":176,"_47":48},[167,168],"files",[167,168],"counts",{"_157":86,"_158":86,"_159":86,"_160":161,"_162":163},[],{"_33":56,"_13":19,"_57":58,"_59":-5,"_60":61,"_62":63,"_64":65,"_35":66,"_17":67,"_68":69,"_70":71,"_72":48,"_73":-5,"_18":156},"upstreamProject",{"_33":40,"_13":55,"_93":-5,"_94":-5,"_49":50,"_116":155},"upstreamBranch",{"_33":34,"_35":153,"_37":154,"_13":16,"_39":40,"_17":41,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":12,"_52":53,"_54":55},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746037578853],["D",1732031240039],{"_11":12,"_131":127},[19],"pulls","branches","forks","envVars",{"_164":86,"_166":86},"connections",{"_164":86,"_165":86},"count","unfilledCount","emptyCount",{"_33":81,"_13":82,"_57":83,"_59":-5,"_60":61,"_62":84,"_64":65,"_35":85,"_17":86,"_68":24,"_70":-5,"_72":48,"_73":-5,"_78":171,"_18":172},{"_33":56,"_13":19,"_57":58,"_59":-5,"_60":61,"_62":63,"_64":65,"_35":77,"_17":67,"_68":69,"_70":-5,"_72":48,"_73":-5,"_78":169,"_18":170},[],[19],[],[82],["D",1744922624289],{"_11":12,"_131":127},{"_11":12,"_125":-5,"_126":127,"_95":96,"_128":129,"_130":48},{"_17":63,"_13":16,"_33":61,"_39":89,"_42":34,"_43":86,"_122":50,"_123":40,"_124":53,"_54":14,"_51":12},"ctx",{"_116":-5,"_210":211,"_150":212,"_213":214,"_215":216,"_217":48,"_218":48,"_219":48,"_220":65,"_221":-5,"_222":-7,"_223":-7,"_224":86,"_225":48,"_226":48,"_227":-5},"ENV",{"_181":182,"_183":184,"_185":16,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","db46cea2d909ccbd011cfec0e4ddfe291f419728","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","aiChatModels",[228,229,230,231,232],[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","navCollapsed","currentOrgId",{"_233":257,"_73":258,"_236":259,"_93":260,"_239":65,"_240":65,"_241":242,"_243":65},{"_233":252,"_73":253,"_236":254,"_93":255,"_239":65,"_240":48,"_241":256,"_243":48},{"_233":248,"_73":249,"_236":250,"_93":251,"_239":65,"_240":65,"_241":242,"_243":48},{"_233":244,"_73":245,"_236":246,"_93":247,"_239":65,"_240":65,"_241":242,"_243":48},{"_233":234,"_73":235,"_236":237,"_93":238,"_239":65,"_240":65,"_241":242,"_243":48},"value","fable","Claude Fable 5.1","shortLabel","Fable","Most capable; 2× Opus pricing","imageInput","thinking","contextWindowSize",1000000,"isDefault","opus55","Claude Opus 5.5","Opus","Highly capable for complex work","sonnet55","Claude Sonnet 5.5","Sonnet","Balanced speed and capability","haiku","Claude Haiku 4.5","Haiku","Fastest; best for simple edits",200000,"deepseekflash","DeepSeek V4.1 Flash","DeepSeek Flash","Smart and very cheap"]