{"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"]}},"/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_focus_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_focus_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_focus_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.focus"},{"$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/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.focus"},{"$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/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.focus"},{"$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/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":{"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_focus_distribution":{"description":"Derived, machine-owned: recomputed from public.companies by\nrecompute_investor_metrics on every companies write; never write directly.\nJSON array [{focus, companies}] over the closed twelve-value focus taxonomy,\nsorted by companies desc, ties alphabetical, null element last; sums to the\ninvestor's companies row count. The null element counts companies outside\nthe taxonomy and is a real published number. Share is computed by consumers,\nnever stored. The rows behind the counts: /companies?investor_id=eq.<id>.","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"],"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"},"focus":{"description":"Sector focus from the closed twelve-value taxonomy. Null means the company\nfalls outside the taxonomy, not \"unknown\".","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"}},"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_focus_distribution":{"name":"company_focus_distribution","description":"Derived, machine-owned: recomputed from public.companies by\nrecompute_investor_metrics on every companies write; never write directly.\nJSON array [{focus, companies}] over the closed twelve-value focus taxonomy,\nsorted by companies desc, ties alphabetical, null element last; sums to the\ninvestor's companies row count. The null element counts companies outside\nthe taxonomy and is a real published number. Share is computed by consumers,\nnever stored. The rows behind the counts: /companies?investor_id=eq.<id>.","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.focus":{"name":"focus","description":"Sector focus from the closed twelve-value taxonomy. Null means the company\nfalls outside the taxonomy, not \"unknown\".","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"}},"externalDocs":{"description":"PostgREST Documentation","url":"https://postgrest.org/en/v14/references/api.html"}}