{"swagger":"2.0","info":{"description":"","title":"standard public schema","version":"14.5"},"host":"meritcapit.al","basePath":"/data","schemes":["https"],"consumes":["application/json","application/vnd.pgrst.object+json;nulls=stripped","application/vnd.pgrst.object+json","text/csv"],"produces":["application/json","application/vnd.pgrst.object+json;nulls=stripped","application/vnd.pgrst.object+json","text/csv"],"paths":{"/":{"get":{"produces":["application/openapi+json","application/json"],"responses":{"200":{"description":"OK"}},"summary":"OpenAPI description (this document)","tags":["Introspection"]}},"/investor_requests":{"get":{"description":"filed through the form on the index page. The email column is not readable,\nso name the columns you read: ?select=id,created_at,investor_name. A request\nwithout select asks for every column and is refused. Rows are written by the\nform only.","parameters":[{"$ref":"#/parameters/rowFilter.investor_requests.id"},{"$ref":"#/parameters/rowFilter.investor_requests.created_at"},{"$ref":"#/parameters/rowFilter.investor_requests.investor_name"},{"$ref":"#/parameters/rowFilter.investor_requests.email"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/order"},{"$ref":"#/parameters/range"},{"$ref":"#/parameters/rangeUnit"},{"$ref":"#/parameters/offset"},{"$ref":"#/parameters/limit"},{"$ref":"#/parameters/preferCount"}],"responses":{"200":{"description":"OK","schema":{"items":{"$ref":"#/definitions/investor_requests"},"type":"array"}},"206":{"description":"Partial Content"}},"summary":"Requests from visitors to add an investor to the index, one row per request,","tags":["investor_requests"]},"post":{"description":"filed through the form on the index page. The email column is not readable,\nso name the columns you read: ?select=id,created_at,investor_name. A request\nwithout select asks for every column and is refused. Rows are written by the\nform only.","parameters":[{"$ref":"#/parameters/body.investor_requests"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/preferPost"}],"responses":{"201":{"description":"Created"}},"summary":"Requests from visitors to add an investor to the index, one row per request,","tags":["investor_requests"]},"delete":{"description":"filed through the form on the index page. The email column is not readable,\nso name the columns you read: ?select=id,created_at,investor_name. A request\nwithout select asks for every column and is refused. Rows are written by the\nform only.","parameters":[{"$ref":"#/parameters/rowFilter.investor_requests.id"},{"$ref":"#/parameters/rowFilter.investor_requests.created_at"},{"$ref":"#/parameters/rowFilter.investor_requests.investor_name"},{"$ref":"#/parameters/rowFilter.investor_requests.email"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}},"summary":"Requests from visitors to add an investor to the index, one row per request,","tags":["investor_requests"]},"patch":{"description":"filed through the form on the index page. The email column is not readable,\nso name the columns you read: ?select=id,created_at,investor_name. A request\nwithout select asks for every column and is refused. Rows are written by the\nform only.","parameters":[{"$ref":"#/parameters/rowFilter.investor_requests.id"},{"$ref":"#/parameters/rowFilter.investor_requests.created_at"},{"$ref":"#/parameters/rowFilter.investor_requests.investor_name"},{"$ref":"#/parameters/rowFilter.investor_requests.email"},{"$ref":"#/parameters/body.investor_requests"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}},"summary":"Requests from visitors to add an investor to the index, one row per request,","tags":["investor_requests"]}},"/investors":{"get":{"description":"base profile fields; the institutional fields (aum, funds, individuals,\nfounding_year) and the individual field (affiliation) are populated depending\non investor_type, with the non-applicable side null.","parameters":[{"$ref":"#/parameters/rowFilter.investors.id"},{"$ref":"#/parameters/rowFilter.investors.name"},{"$ref":"#/parameters/rowFilter.investors.slug"},{"$ref":"#/parameters/rowFilter.investors.icon_url"},{"$ref":"#/parameters/rowFilter.investors.hq_location"},{"$ref":"#/parameters/rowFilter.investors.investment_stage"},{"$ref":"#/parameters/rowFilter.investors.investment_geo"},{"$ref":"#/parameters/rowFilter.investors.history"},{"$ref":"#/parameters/rowFilter.investors.investment_concept"},{"$ref":"#/parameters/rowFilter.investors.notable_investments"},{"$ref":"#/parameters/rowFilter.investors.investor_type"},{"$ref":"#/parameters/rowFilter.investors.created_at"},{"$ref":"#/parameters/rowFilter.investors.updated_at"},{"$ref":"#/parameters/rowFilter.investors.investment_scope"},{"$ref":"#/parameters/rowFilter.investors.investment_range"},{"$ref":"#/parameters/rowFilter.investors.graduation_rate"},{"$ref":"#/parameters/rowFilter.investors.track_record"},{"$ref":"#/parameters/rowFilter.investors.website"},{"$ref":"#/parameters/rowFilter.investors.affiliation"},{"$ref":"#/parameters/rowFilter.investors.aum"},{"$ref":"#/parameters/rowFilter.investors.funds"},{"$ref":"#/parameters/rowFilter.investors.individuals"},{"$ref":"#/parameters/rowFilter.investors.founding_year"},{"$ref":"#/parameters/rowFilter.investors.company_stage_distribution"},{"$ref":"#/parameters/rowFilter.investors.company_geo_distribution"},{"$ref":"#/parameters/rowFilter.investors.company_category_distribution"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/order"},{"$ref":"#/parameters/range"},{"$ref":"#/parameters/rangeUnit"},{"$ref":"#/parameters/offset"},{"$ref":"#/parameters/limit"},{"$ref":"#/parameters/preferCount"}],"responses":{"200":{"description":"OK","schema":{"items":{"$ref":"#/definitions/investors"},"type":"array"}},"206":{"description":"Partial Content"}},"summary":"All venture investors, one row each: institutions and individuals share the","tags":["investors"]},"post":{"description":"base profile fields; the institutional fields (aum, funds, individuals,\nfounding_year) and the individual field (affiliation) are populated depending\non investor_type, with the non-applicable side null.","parameters":[{"$ref":"#/parameters/body.investors"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/preferPost"}],"responses":{"201":{"description":"Created"}},"summary":"All venture investors, one row each: institutions and individuals share the","tags":["investors"]},"delete":{"description":"base profile fields; the institutional fields (aum, funds, individuals,\nfounding_year) and the individual field (affiliation) are populated depending\non investor_type, with the non-applicable side null.","parameters":[{"$ref":"#/parameters/rowFilter.investors.id"},{"$ref":"#/parameters/rowFilter.investors.name"},{"$ref":"#/parameters/rowFilter.investors.slug"},{"$ref":"#/parameters/rowFilter.investors.icon_url"},{"$ref":"#/parameters/rowFilter.investors.hq_location"},{"$ref":"#/parameters/rowFilter.investors.investment_stage"},{"$ref":"#/parameters/rowFilter.investors.investment_geo"},{"$ref":"#/parameters/rowFilter.investors.history"},{"$ref":"#/parameters/rowFilter.investors.investment_concept"},{"$ref":"#/parameters/rowFilter.investors.notable_investments"},{"$ref":"#/parameters/rowFilter.investors.investor_type"},{"$ref":"#/parameters/rowFilter.investors.created_at"},{"$ref":"#/parameters/rowFilter.investors.updated_at"},{"$ref":"#/parameters/rowFilter.investors.investment_scope"},{"$ref":"#/parameters/rowFilter.investors.investment_range"},{"$ref":"#/parameters/rowFilter.investors.graduation_rate"},{"$ref":"#/parameters/rowFilter.investors.track_record"},{"$ref":"#/parameters/rowFilter.investors.website"},{"$ref":"#/parameters/rowFilter.investors.affiliation"},{"$ref":"#/parameters/rowFilter.investors.aum"},{"$ref":"#/parameters/rowFilter.investors.funds"},{"$ref":"#/parameters/rowFilter.investors.individuals"},{"$ref":"#/parameters/rowFilter.investors.founding_year"},{"$ref":"#/parameters/rowFilter.investors.company_stage_distribution"},{"$ref":"#/parameters/rowFilter.investors.company_geo_distribution"},{"$ref":"#/parameters/rowFilter.investors.company_category_distribution"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}},"summary":"All venture investors, one row each: institutions and individuals share the","tags":["investors"]},"patch":{"description":"base profile fields; the institutional fields (aum, funds, individuals,\nfounding_year) and the individual field (affiliation) are populated depending\non investor_type, with the non-applicable side null.","parameters":[{"$ref":"#/parameters/rowFilter.investors.id"},{"$ref":"#/parameters/rowFilter.investors.name"},{"$ref":"#/parameters/rowFilter.investors.slug"},{"$ref":"#/parameters/rowFilter.investors.icon_url"},{"$ref":"#/parameters/rowFilter.investors.hq_location"},{"$ref":"#/parameters/rowFilter.investors.investment_stage"},{"$ref":"#/parameters/rowFilter.investors.investment_geo"},{"$ref":"#/parameters/rowFilter.investors.history"},{"$ref":"#/parameters/rowFilter.investors.investment_concept"},{"$ref":"#/parameters/rowFilter.investors.notable_investments"},{"$ref":"#/parameters/rowFilter.investors.investor_type"},{"$ref":"#/parameters/rowFilter.investors.created_at"},{"$ref":"#/parameters/rowFilter.investors.updated_at"},{"$ref":"#/parameters/rowFilter.investors.investment_scope"},{"$ref":"#/parameters/rowFilter.investors.investment_range"},{"$ref":"#/parameters/rowFilter.investors.graduation_rate"},{"$ref":"#/parameters/rowFilter.investors.track_record"},{"$ref":"#/parameters/rowFilter.investors.website"},{"$ref":"#/parameters/rowFilter.investors.affiliation"},{"$ref":"#/parameters/rowFilter.investors.aum"},{"$ref":"#/parameters/rowFilter.investors.funds"},{"$ref":"#/parameters/rowFilter.investors.individuals"},{"$ref":"#/parameters/rowFilter.investors.founding_year"},{"$ref":"#/parameters/rowFilter.investors.company_stage_distribution"},{"$ref":"#/parameters/rowFilter.investors.company_geo_distribution"},{"$ref":"#/parameters/rowFilter.investors.company_category_distribution"},{"$ref":"#/parameters/body.investors"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}},"summary":"All venture investors, one row each: institutions and individuals share the","tags":["investors"]}},"/companies":{"get":{"description":"(investor, company) pair. A company backed by two investors appears twice.\nAlso the derivation source for the investor-level metrics:\nrecompute_investor_metrics aggregates these rows into investors.track_record,\ngraduation_rate and the three company_*_distribution columns on every write\nto this table. Filter one portfolio by investor_id, or by slug through an\nembedded filter: ?select=*,investors!inner(slug)&investors.slug=eq.<slug>.\nEmbedding investors<->companies works in both directions, but embedded lists\ncarry no Content-Range; paginate on this endpoint, never inside an embed.","parameters":[{"$ref":"#/parameters/rowFilter.companies.id"},{"$ref":"#/parameters/rowFilter.companies.investor_id"},{"$ref":"#/parameters/rowFilter.companies.name"},{"$ref":"#/parameters/rowFilter.companies.hq_city"},{"$ref":"#/parameters/rowFilter.companies.hq_country"},{"$ref":"#/parameters/rowFilter.companies.entry_stage"},{"$ref":"#/parameters/rowFilter.companies.status"},{"$ref":"#/parameters/rowFilter.companies.valuation_range"},{"$ref":"#/parameters/rowFilter.companies.valuation_usd"},{"$ref":"#/parameters/rowFilter.companies.valuation_asof"},{"$ref":"#/parameters/rowFilter.companies.seed_to_a_graduation"},{"$ref":"#/parameters/rowFilter.companies.created_at"},{"$ref":"#/parameters/rowFilter.companies.updated_at"},{"$ref":"#/parameters/rowFilter.companies.company_key"},{"$ref":"#/parameters/rowFilter.companies.categories"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/order"},{"$ref":"#/parameters/range"},{"$ref":"#/parameters/rangeUnit"},{"$ref":"#/parameters/offset"},{"$ref":"#/parameters/limit"},{"$ref":"#/parameters/preferCount"}],"responses":{"200":{"description":"OK","schema":{"items":{"$ref":"#/definitions/companies"},"type":"array"}},"206":{"description":"Partial Content"}},"summary":"Portfolio companies as classified by the outcome pipeline, one row per","tags":["companies"]},"post":{"description":"(investor, company) pair. A company backed by two investors appears twice.\nAlso the derivation source for the investor-level metrics:\nrecompute_investor_metrics aggregates these rows into investors.track_record,\ngraduation_rate and the three company_*_distribution columns on every write\nto this table. Filter one portfolio by investor_id, or by slug through an\nembedded filter: ?select=*,investors!inner(slug)&investors.slug=eq.<slug>.\nEmbedding investors<->companies works in both directions, but embedded lists\ncarry no Content-Range; paginate on this endpoint, never inside an embed.","parameters":[{"$ref":"#/parameters/body.companies"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/preferPost"}],"responses":{"201":{"description":"Created"}},"summary":"Portfolio companies as classified by the outcome pipeline, one row per","tags":["companies"]},"delete":{"description":"(investor, company) pair. A company backed by two investors appears twice.\nAlso the derivation source for the investor-level metrics:\nrecompute_investor_metrics aggregates these rows into investors.track_record,\ngraduation_rate and the three company_*_distribution columns on every write\nto this table. Filter one portfolio by investor_id, or by slug through an\nembedded filter: ?select=*,investors!inner(slug)&investors.slug=eq.<slug>.\nEmbedding investors<->companies works in both directions, but embedded lists\ncarry no Content-Range; paginate on this endpoint, never inside an embed.","parameters":[{"$ref":"#/parameters/rowFilter.companies.id"},{"$ref":"#/parameters/rowFilter.companies.investor_id"},{"$ref":"#/parameters/rowFilter.companies.name"},{"$ref":"#/parameters/rowFilter.companies.hq_city"},{"$ref":"#/parameters/rowFilter.companies.hq_country"},{"$ref":"#/parameters/rowFilter.companies.entry_stage"},{"$ref":"#/parameters/rowFilter.companies.status"},{"$ref":"#/parameters/rowFilter.companies.valuation_range"},{"$ref":"#/parameters/rowFilter.companies.valuation_usd"},{"$ref":"#/parameters/rowFilter.companies.valuation_asof"},{"$ref":"#/parameters/rowFilter.companies.seed_to_a_graduation"},{"$ref":"#/parameters/rowFilter.companies.created_at"},{"$ref":"#/parameters/rowFilter.companies.updated_at"},{"$ref":"#/parameters/rowFilter.companies.company_key"},{"$ref":"#/parameters/rowFilter.companies.categories"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}},"summary":"Portfolio companies as classified by the outcome pipeline, one row per","tags":["companies"]},"patch":{"description":"(investor, company) pair. A company backed by two investors appears twice.\nAlso the derivation source for the investor-level metrics:\nrecompute_investor_metrics aggregates these rows into investors.track_record,\ngraduation_rate and the three company_*_distribution columns on every write\nto this table. Filter one portfolio by investor_id, or by slug through an\nembedded filter: ?select=*,investors!inner(slug)&investors.slug=eq.<slug>.\nEmbedding investors<->companies works in both directions, but embedded lists\ncarry no Content-Range; paginate on this endpoint, never inside an embed.","parameters":[{"$ref":"#/parameters/rowFilter.companies.id"},{"$ref":"#/parameters/rowFilter.companies.investor_id"},{"$ref":"#/parameters/rowFilter.companies.name"},{"$ref":"#/parameters/rowFilter.companies.hq_city"},{"$ref":"#/parameters/rowFilter.companies.hq_country"},{"$ref":"#/parameters/rowFilter.companies.entry_stage"},{"$ref":"#/parameters/rowFilter.companies.status"},{"$ref":"#/parameters/rowFilter.companies.valuation_range"},{"$ref":"#/parameters/rowFilter.companies.valuation_usd"},{"$ref":"#/parameters/rowFilter.companies.valuation_asof"},{"$ref":"#/parameters/rowFilter.companies.seed_to_a_graduation"},{"$ref":"#/parameters/rowFilter.companies.created_at"},{"$ref":"#/parameters/rowFilter.companies.updated_at"},{"$ref":"#/parameters/rowFilter.companies.company_key"},{"$ref":"#/parameters/rowFilter.companies.categories"},{"$ref":"#/parameters/body.companies"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}},"summary":"Portfolio companies as classified by the outcome pipeline, one row per","tags":["companies"]}}},"definitions":{"investor_requests":{"description":"Requests from visitors to add an investor to the index, one row per request,\nfiled through the form on the index page. The email column is not readable,\nso name the columns you read: ?select=id,created_at,investor_name. A request\nwithout select asks for every column and is refused. Rows are written by the\nform only.","required":["id","created_at","investor_name","email"],"properties":{"id":{"default":"gen_random_uuid()","description":"Stable unique identifier (uuid).\n\nNote:\nThis is a Primary Key.<pk/>","format":"uuid","type":"string"},"created_at":{"default":"now()","description":"When the request was filed.","format":"timestamp with time zone","type":"string"},"investor_name":{"description":"The investor the visitor asked for, as typed, at most 40 characters. Visitor input, not checked.","format":"text","type":"string"},"email":{"description":"Not readable: the requester's email address, kept private and used only to answer the request. Selecting it is refused.","format":"text","type":"string"}},"type":"object"},"investors":{"description":"All venture investors, one row each: institutions and individuals share the\nbase profile fields; the institutional fields (aum, funds, individuals,\nfounding_year) and the individual field (affiliation) are populated depending\non investor_type, with the non-applicable side null.","required":["id","name","slug","investor_type","created_at","updated_at"],"properties":{"id":{"default":"(gen_random_uuid())","description":"Stable unique identifier (text).\n\nNote:\nThis is a Primary Key.<pk/>","format":"text","type":"string"},"name":{"description":"Display name of the investor.","format":"text","type":"string"},"slug":{"description":"URL-friendly unique identifier. Use for lookups, e.g. investors?slug=eq.sequoia-capital.","format":"text","type":"string"},"icon_url":{"description":"URL of the investor's logo/icon image.","format":"text","type":"string"},"hq_location":{"description":"Headquarters location as free text.","format":"text","type":"string"},"investment_stage":{"description":"JSON array of stages, e.g. [\"Seed\",\"Series A\"].","format":"jsonb"},"investment_geo":{"description":"JSON {core: string[], other: string[]} geographic focus.","format":"jsonb"},"history":{"description":"Narrative history of the investor.","format":"text","type":"string"},"investment_concept":{"description":"Investment philosophy / thesis description.","format":"text","type":"string"},"notable_investments":{"description":"JSON array of notable portfolio company names.","format":"jsonb"},"investor_type":{"default":"Institutional","description":"\"Institutional\" or \"Individual\". Determines whether aum/funds/individuals/founding_year (institutional) or affiliation (individual) are populated.","enum":["Institutional","Individual"],"format":"public.\"InvestorType\"","type":"string"},"created_at":{"default":"CURRENT_TIMESTAMP","description":"Row creation timestamp.","format":"timestamp without time zone","type":"string"},"updated_at":{"description":"Last write timestamp; doubles as last-verified under the verify-then-ingest playbook.","format":"timestamp without time zone","type":"string"},"investment_scope":{"description":"JSON {type: \"Generalist\"|\"Specialist\", focus: string[]}.","format":"jsonb"},"investment_range":{"description":"Check size USD JSON {lower_limit, upper_limit, median}; null where the\ninvestor's check size is not known.","format":"jsonb"},"graduation_rate":{"description":"Derived, machine-owned: recomputed from public.companies by\nrecompute_investor_metrics on every companies write; never write directly.\nJSON {seed_to_series_a: {rate_percent, graduated, sample_size, seed_entries,\ncensored}}; null when the investor has no Seed-stage entry. seed_entries counts\nevery Seed-stage entry, each of them decided; censored are too young to count\n(entered under 24 months ago); sample_size is the rest, the cohort, every one\nof them graduated or not_graduated; rate_percent is graduated / sample_size,\nnull when the cohort is empty. Coverage of the cohort is complete by\nconstruction: a Seed entry past the 24-month clock with no evidence of a later\nround is counted as not graduated rather than left out. The rows behind the\ncounts: /companies?investor_id=eq.<id>&entry_stage=eq.Seed.","format":"jsonb"},"track_record":{"description":"Derived, machine-owned: recomputed from public.companies by\nrecompute_investor_metrics on every companies write; never write directly.\nJSON {total_companies_invested, investing_start_year, one_b_companies |\nten_b_companies | hundred_b_companies | ipo_companies: {amount, names[]}}.\nCumulative: a $50B public company appears in one_b, ten_b and ipo.\nipo_companies counts companies currently public (status = public), not\never-IPOed. investing_start_year is the investor's founding_year, not derived\nfrom companies. total_companies_invested counts companies carrying a determined\noutcome; rows whose company could not be identified are excluded.","format":"jsonb"},"website":{"description":"Official website URL.","format":"text","type":"string"},"affiliation":{"description":"Individual investors only: JSON {current: [...], past: [...]} affiliations with roles and years. Null for institutions.","format":"jsonb"},"aum":{"description":"Institutions only: USD JSON range {bottom, top}. Null for individuals or when undisclosed.","format":"jsonb"},"funds":{"description":"Institutions only: JSON wrapper object {funds: [{name, size (USD number),\nvintage (year)}]}. The array sits under the \"funds\" key, not at the top\nlevel. Null for individuals or when undisclosed.","format":"jsonb"},"individuals":{"description":"Institutions only: JSON array of the people at the firm, elements shaped\n{name, position, socials: {linkedin_url, x_url}}; position and either social\nURL may be null. Null for individuals.","format":"jsonb"},"founding_year":{"description":"Institutions only: year the firm was founded.","format":"integer","type":"integer"},"company_stage_distribution":{"description":"Derived, machine-owned: recomputed from public.companies by\nrecompute_investor_metrics on every companies write; never write directly.\nJSON array [{stage, companies}] sorted by companies desc, ties alphabetical;\nsums to the investor's companies row count. Stage vocabulary is\ncompanies.entry_stage. Share is computed by consumers, never stored. The rows\nbehind the counts: /companies?investor_id=eq.<id>.","format":"jsonb"},"company_geo_distribution":{"description":"Derived, machine-owned: recomputed from public.companies by\nrecompute_investor_metrics on every companies write; never write directly.\nJSON {country: [{country, companies}], city: [{city, companies}]}; each\nsub-array sums to the investor's companies row count and sorts by companies\ndesc, ties alphabetical, null element last. A null-keyed element is a real\ncount: null city means the HQ is unresolved. Countries are ISO 3166-1\nalpha-2; cities are bare municipalities. Share is computed by consumers,\nnever stored. The rows behind the counts: /companies?investor_id=eq.<id>.","format":"jsonb"},"company_category_distribution":{"description":"JSON array [{category, companies}] counting the investor's companies that\ncarry each category, sorted by companies desc; a company carries up to three\ncategories, so the counts add up to more than the company rows. The null\nelement counts the companies with no category. Shares are computed by\nconsumers over the company rows, never stored.","format":"jsonb"}},"type":"object"},"companies":{"description":"Portfolio companies as classified by the outcome pipeline, one row per\n(investor, company) pair. A company backed by two investors appears twice.\nAlso the derivation source for the investor-level metrics:\nrecompute_investor_metrics aggregates these rows into investors.track_record,\ngraduation_rate and the three company_*_distribution columns on every write\nto this table. Filter one portfolio by investor_id, or by slug through an\nembedded filter: ?select=*,investors!inner(slug)&investors.slug=eq.<slug>.\nEmbedding investors<->companies works in both directions, but embedded lists\ncarry no Content-Range; paginate on this endpoint, never inside an embed.","required":["id","investor_id","name","entry_stage","status","valuation_range","created_at","updated_at","categories"],"properties":{"id":{"default":"gen_random_uuid()","description":"Surrogate key, minted by the database on insert. Ingest never sends it.\n\nNote:\nThis is a Primary Key.<pk/>","format":"uuid","type":"string"},"investor_id":{"description":"The investor whose portfolio this row belongs to; references investors.id.\n\nNote:\nThis is a Foreign Key to `investors.id`.<fk table='investors' column='id'/>","format":"text","type":"string"},"name":{"description":"Company name as the investor's portfolio renders it. Unique per investor;\nthe ingest conflict key.","format":"text","type":"string"},"hq_city":{"description":"Headquarters city, free text, bare municipality (\"Palo Alto\", never\n\"Palo Alto, CA\"). Null means unresolved, not \"no HQ\".","format":"text","type":"string"},"hq_country":{"description":"Headquarters country, ISO 3166-1 alpha-2 code (US, IL, ...).","format":"text","type":"string"},"entry_stage":{"description":"The stage label of the round in which the investor first put fund money in:\nPre-Seed, Seed, Series A, Growth, or `undetermined` where the record does not\ngive the round. `undetermined` excludes the row from the stage distribution and\nfrom the seed-to-A cohort, and from nothing else — an unknown ROUND is not an\nunknown COMPANY, so the row keeps its band, its status, its country and its\nplace in the track record. A row that carries `undetermined` because the company\nitself could not be identified reads `undetermined` in valuation_range too, and\nthat is what takes it out of every metric.","format":"text","type":"string"},"status":{"description":"Current company state: private, public, acquired, defunct or unknown.","format":"text","type":"string"},"valuation_range":{"description":"Cumulative valuation bucket: below_1b, 1b_plus, 10b_plus, 100b_plus.\n`undetermined` means the company could not be valued, which is always true\nwhen it could not be identified and can also be true on its own: a Form D\nsequence or a programme's standard terms give an entry stage for a company\nnobody can name, and such a row carries a stage with no band. A row with any\nundetermined column carries no valuation_usd and is excluded from every\nderived metric. A bucket is a judgment, unlike the measured valuation_usd.","format":"text","type":"string"},"valuation_usd":{"description":"Exact current valuation in USD, source-gated. Null means no sourced figure,\nnot zero.","format":"bigint","type":"integer"},"valuation_asof":{"description":"Date the valuation_usd figure was current; always read the two together.","format":"date","type":"string"},"seed_to_a_graduation":{"description":"Seed-to-Series-A graduation of a Seed-stage entry, as a status, and every Seed\nentry carries one. graduated: a later priced round, cited or present in the\ncompany's own Form D sequence; a later round named Series A or later counts\nwhatever its size. not_graduated: no later round, established by a dated search\nof named surfaces (the firm's own archive, the company's Form D sequence where\nit files in the US, and at least two publisher surfaces) at least 24 months\nafter entry, by Form D absence, or by a cited acquisition or shutdown.\ncensored: entered less than 24 months ago, too young to count. undetermined\nappears only on a row whose entry_stage is undetermined too: a company that\ncould not be identified, or a token-funded position with no priced round to\ngraduate from; neither is a Seed entry. Null wherever else the column does not\napply, a non-Seed entry. Every graduated or not_graduated row is verified (a\ncitation, the filings, or the recorded search) before it is ingested.","enum":["graduated","not_graduated","censored","undetermined"],"format":"public.graduation_status","type":"string"},"created_at":{"default":"now()","description":"Row creation time.","format":"timestamp with time zone","type":"string"},"updated_at":{"default":"now()","description":"Last ingest touch; a re-run that changes nothing else still bumps this.","format":"timestamp with time zone","type":"string"},"company_key":{"description":"Key of the company across investors: cik:<SEC CIK>, domain:<web domain> or\nname:<normalised name>. Rows of different investors with the same key are\none company, and their categories are judged together.","format":"text","type":"string"},"categories":{"description":"Investment categories of the company, up to three from the closed list of\n25 (market or product, technology, customer, business model), the market\ncategory first. Judged once per company across every investor, so two\ninvestors holding one company carry the same categories; an empty array is a\ncompany that fits no category. The list is data/taxonomy/category.json in the\nrepository.","format":"text[]","items":{"type":"string"},"type":"array"}},"type":"object"}},"parameters":{"preferParams":{"name":"Prefer","description":"Preference","required":false,"in":"header","type":"string"},"preferReturn":{"name":"Prefer","description":"Preference","required":false,"enum":["return=representation","return=minimal","return=none"],"in":"header","type":"string"},"preferCount":{"name":"Prefer","description":"Preference","required":false,"enum":["count=none"],"in":"header","type":"string"},"preferPost":{"name":"Prefer","description":"Preference","required":false,"enum":["return=representation","return=minimal","return=none","resolution=ignore-duplicates","resolution=merge-duplicates"],"in":"header","type":"string"},"select":{"name":"select","description":"Filtering Columns","required":false,"in":"query","type":"string"},"on_conflict":{"name":"on_conflict","description":"On Conflict","required":false,"in":"query","type":"string"},"order":{"name":"order","description":"Ordering","required":false,"in":"query","type":"string"},"range":{"name":"Range","description":"Limiting and Pagination","required":false,"in":"header","type":"string"},"rangeUnit":{"name":"Range-Unit","description":"Limiting and Pagination","required":false,"default":"items","in":"header","type":"string"},"offset":{"name":"offset","description":"Limiting and Pagination","required":false,"in":"query","type":"string"},"limit":{"name":"limit","description":"Limiting and Pagination","required":false,"in":"query","type":"string"},"body.investor_requests":{"name":"investor_requests","description":"investor_requests","required":false,"in":"body","schema":{"$ref":"#/definitions/investor_requests"}},"rowFilter.investor_requests.id":{"name":"id","description":"Stable unique identifier (uuid).","required":false,"in":"query","type":"string"},"rowFilter.investor_requests.created_at":{"name":"created_at","description":"When the request was filed.","required":false,"in":"query","type":"string"},"rowFilter.investor_requests.investor_name":{"name":"investor_name","description":"The investor the visitor asked for, as typed, at most 40 characters. Visitor input, not checked.","required":false,"in":"query","type":"string"},"rowFilter.investor_requests.email":{"name":"email","description":"Not readable: the requester's email address, kept private and used only to answer the request. Selecting it is refused.","required":false,"in":"query","type":"string"},"body.investors":{"name":"investors","description":"investors","required":false,"in":"body","schema":{"$ref":"#/definitions/investors"}},"rowFilter.investors.id":{"name":"id","description":"Stable unique identifier (text).","required":false,"in":"query","type":"string"},"rowFilter.investors.name":{"name":"name","description":"Display name of the investor.","required":false,"in":"query","type":"string"},"rowFilter.investors.slug":{"name":"slug","description":"URL-friendly unique identifier. Use for lookups, e.g. investors?slug=eq.sequoia-capital.","required":false,"in":"query","type":"string"},"rowFilter.investors.icon_url":{"name":"icon_url","description":"URL of the investor's logo/icon image.","required":false,"in":"query","type":"string"},"rowFilter.investors.hq_location":{"name":"hq_location","description":"Headquarters location as free text.","required":false,"in":"query","type":"string"},"rowFilter.investors.investment_stage":{"name":"investment_stage","description":"JSON array of stages, e.g. [\"Seed\",\"Series A\"].","required":false,"in":"query","type":"string"},"rowFilter.investors.investment_geo":{"name":"investment_geo","description":"JSON {core: string[], other: string[]} geographic focus.","required":false,"in":"query","type":"string"},"rowFilter.investors.history":{"name":"history","description":"Narrative history of the investor.","required":false,"in":"query","type":"string"},"rowFilter.investors.investment_concept":{"name":"investment_concept","description":"Investment philosophy / thesis description.","required":false,"in":"query","type":"string"},"rowFilter.investors.notable_investments":{"name":"notable_investments","description":"JSON array of notable portfolio company names.","required":false,"in":"query","type":"string"},"rowFilter.investors.investor_type":{"name":"investor_type","description":"\"Institutional\" or \"Individual\". Determines whether aum/funds/individuals/founding_year (institutional) or affiliation (individual) are populated.","required":false,"in":"query","type":"string"},"rowFilter.investors.created_at":{"name":"created_at","description":"Row creation timestamp.","required":false,"in":"query","type":"string"},"rowFilter.investors.updated_at":{"name":"updated_at","description":"Last write timestamp; doubles as last-verified under the verify-then-ingest playbook.","required":false,"in":"query","type":"string"},"rowFilter.investors.investment_scope":{"name":"investment_scope","description":"JSON {type: \"Generalist\"|\"Specialist\", focus: string[]}.","required":false,"in":"query","type":"string"},"rowFilter.investors.investment_range":{"name":"investment_range","description":"Check size USD JSON {lower_limit, upper_limit, median}; null where the\ninvestor's check size is not known.","required":false,"in":"query","type":"string"},"rowFilter.investors.graduation_rate":{"name":"graduation_rate","description":"Derived, machine-owned: recomputed from public.companies by\nrecompute_investor_metrics on every companies write; never write directly.\nJSON {seed_to_series_a: {rate_percent, graduated, sample_size, seed_entries,\ncensored}}; null when the investor has no Seed-stage entry. seed_entries counts\nevery Seed-stage entry, each of them decided; censored are too young to count\n(entered under 24 months ago); sample_size is the rest, the cohort, every one\nof them graduated or not_graduated; rate_percent is graduated / sample_size,\nnull when the cohort is empty. Coverage of the cohort is complete by\nconstruction: a Seed entry past the 24-month clock with no evidence of a later\nround is counted as not graduated rather than left out. The rows behind the\ncounts: /companies?investor_id=eq.<id>&entry_stage=eq.Seed.","required":false,"in":"query","type":"string"},"rowFilter.investors.track_record":{"name":"track_record","description":"Derived, machine-owned: recomputed from public.companies by\nrecompute_investor_metrics on every companies write; never write directly.\nJSON {total_companies_invested, investing_start_year, one_b_companies |\nten_b_companies | hundred_b_companies | ipo_companies: {amount, names[]}}.\nCumulative: a $50B public company appears in one_b, ten_b and ipo.\nipo_companies counts companies currently public (status = public), not\never-IPOed. investing_start_year is the investor's founding_year, not derived\nfrom companies. total_companies_invested counts companies carrying a determined\noutcome; rows whose company could not be identified are excluded.","required":false,"in":"query","type":"string"},"rowFilter.investors.website":{"name":"website","description":"Official website URL.","required":false,"in":"query","type":"string"},"rowFilter.investors.affiliation":{"name":"affiliation","description":"Individual investors only: JSON {current: [...], past: [...]} affiliations with roles and years. Null for institutions.","required":false,"in":"query","type":"string"},"rowFilter.investors.aum":{"name":"aum","description":"Institutions only: USD JSON range {bottom, top}. Null for individuals or when undisclosed.","required":false,"in":"query","type":"string"},"rowFilter.investors.funds":{"name":"funds","description":"Institutions only: JSON wrapper object {funds: [{name, size (USD number),\nvintage (year)}]}. The array sits under the \"funds\" key, not at the top\nlevel. Null for individuals or when undisclosed.","required":false,"in":"query","type":"string"},"rowFilter.investors.individuals":{"name":"individuals","description":"Institutions only: JSON array of the people at the firm, elements shaped\n{name, position, socials: {linkedin_url, x_url}}; position and either social\nURL may be null. Null for individuals.","required":false,"in":"query","type":"string"},"rowFilter.investors.founding_year":{"name":"founding_year","description":"Institutions only: year the firm was founded.","required":false,"in":"query","type":"string"},"rowFilter.investors.company_stage_distribution":{"name":"company_stage_distribution","description":"Derived, machine-owned: recomputed from public.companies by\nrecompute_investor_metrics on every companies write; never write directly.\nJSON array [{stage, companies}] sorted by companies desc, ties alphabetical;\nsums to the investor's companies row count. Stage vocabulary is\ncompanies.entry_stage. Share is computed by consumers, never stored. The rows\nbehind the counts: /companies?investor_id=eq.<id>.","required":false,"in":"query","type":"string"},"rowFilter.investors.company_geo_distribution":{"name":"company_geo_distribution","description":"Derived, machine-owned: recomputed from public.companies by\nrecompute_investor_metrics on every companies write; never write directly.\nJSON {country: [{country, companies}], city: [{city, companies}]}; each\nsub-array sums to the investor's companies row count and sorts by companies\ndesc, ties alphabetical, null element last. A null-keyed element is a real\ncount: null city means the HQ is unresolved. Countries are ISO 3166-1\nalpha-2; cities are bare municipalities. Share is computed by consumers,\nnever stored. The rows behind the counts: /companies?investor_id=eq.<id>.","required":false,"in":"query","type":"string"},"rowFilter.investors.company_category_distribution":{"name":"company_category_distribution","description":"JSON array [{category, companies}] counting the investor's companies that\ncarry each category, sorted by companies desc; a company carries up to three\ncategories, so the counts add up to more than the company rows. The null\nelement counts the companies with no category. Shares are computed by\nconsumers over the company rows, never stored.","required":false,"in":"query","type":"string"},"body.companies":{"name":"companies","description":"companies","required":false,"in":"body","schema":{"$ref":"#/definitions/companies"}},"rowFilter.companies.id":{"name":"id","description":"Surrogate key, minted by the database on insert. Ingest never sends it.","required":false,"in":"query","type":"string"},"rowFilter.companies.investor_id":{"name":"investor_id","description":"The investor whose portfolio this row belongs to; references investors.id.","required":false,"in":"query","type":"string"},"rowFilter.companies.name":{"name":"name","description":"Company name as the investor's portfolio renders it. Unique per investor;\nthe ingest conflict key.","required":false,"in":"query","type":"string"},"rowFilter.companies.hq_city":{"name":"hq_city","description":"Headquarters city, free text, bare municipality (\"Palo Alto\", never\n\"Palo Alto, CA\"). Null means unresolved, not \"no HQ\".","required":false,"in":"query","type":"string"},"rowFilter.companies.hq_country":{"name":"hq_country","description":"Headquarters country, ISO 3166-1 alpha-2 code (US, IL, ...).","required":false,"in":"query","type":"string"},"rowFilter.companies.entry_stage":{"name":"entry_stage","description":"The stage label of the round in which the investor first put fund money in:\nPre-Seed, Seed, Series A, Growth, or `undetermined` where the record does not\ngive the round. `undetermined` excludes the row from the stage distribution and\nfrom the seed-to-A cohort, and from nothing else — an unknown ROUND is not an\nunknown COMPANY, so the row keeps its band, its status, its country and its\nplace in the track record. A row that carries `undetermined` because the company\nitself could not be identified reads `undetermined` in valuation_range too, and\nthat is what takes it out of every metric.","required":false,"in":"query","type":"string"},"rowFilter.companies.status":{"name":"status","description":"Current company state: private, public, acquired, defunct or unknown.","required":false,"in":"query","type":"string"},"rowFilter.companies.valuation_range":{"name":"valuation_range","description":"Cumulative valuation bucket: below_1b, 1b_plus, 10b_plus, 100b_plus.\n`undetermined` means the company could not be valued, which is always true\nwhen it could not be identified and can also be true on its own: a Form D\nsequence or a programme's standard terms give an entry stage for a company\nnobody can name, and such a row carries a stage with no band. A row with any\nundetermined column carries no valuation_usd and is excluded from every\nderived metric. A bucket is a judgment, unlike the measured valuation_usd.","required":false,"in":"query","type":"string"},"rowFilter.companies.valuation_usd":{"name":"valuation_usd","description":"Exact current valuation in USD, source-gated. Null means no sourced figure,\nnot zero.","required":false,"in":"query","type":"string"},"rowFilter.companies.valuation_asof":{"name":"valuation_asof","description":"Date the valuation_usd figure was current; always read the two together.","required":false,"in":"query","type":"string"},"rowFilter.companies.seed_to_a_graduation":{"name":"seed_to_a_graduation","description":"Seed-to-Series-A graduation of a Seed-stage entry, as a status, and every Seed\nentry carries one. graduated: a later priced round, cited or present in the\ncompany's own Form D sequence; a later round named Series A or later counts\nwhatever its size. not_graduated: no later round, established by a dated search\nof named surfaces (the firm's own archive, the company's Form D sequence where\nit files in the US, and at least two publisher surfaces) at least 24 months\nafter entry, by Form D absence, or by a cited acquisition or shutdown.\ncensored: entered less than 24 months ago, too young to count. undetermined\nappears only on a row whose entry_stage is undetermined too: a company that\ncould not be identified, or a token-funded position with no priced round to\ngraduate from; neither is a Seed entry. Null wherever else the column does not\napply, a non-Seed entry. Every graduated or not_graduated row is verified (a\ncitation, the filings, or the recorded search) before it is ingested.","required":false,"in":"query","type":"string"},"rowFilter.companies.created_at":{"name":"created_at","description":"Row creation time.","required":false,"in":"query","type":"string"},"rowFilter.companies.updated_at":{"name":"updated_at","description":"Last ingest touch; a re-run that changes nothing else still bumps this.","required":false,"in":"query","type":"string"},"rowFilter.companies.company_key":{"name":"company_key","description":"Key of the company across investors: cik:<SEC CIK>, domain:<web domain> or\nname:<normalised name>. Rows of different investors with the same key are\none company, and their categories are judged together.","required":false,"in":"query","type":"string"},"rowFilter.companies.categories":{"name":"categories","description":"Investment categories of the company, up to three from the closed list of\n25 (market or product, technology, customer, business model), the market\ncategory first. Judged once per company across every investor, so two\ninvestors holding one company carry the same categories; an empty array is a\ncompany that fits no category. The list is data/taxonomy/category.json in the\nrepository.","required":false,"in":"query","type":"string"}},"externalDocs":{"description":"PostgREST Documentation","url":"https://postgrest.org/en/v14/references/api.html"}}