Merit Capital Data API

primary keyStable unique identifier (text).

Display name of the investor.

URL-friendly unique identifier. Use for lookups, e.g. investors?slug=eq.sequoia-capital.

"Institutional" or "Individual". Determines whether aum/funds/individuals/founding_year (institutional) or affiliation (individual) are populated.

URL of the investor's logo/icon image.

Official website URL.

Headquarters location as free text.

Investment philosophy / thesis description.

Narrative history of the investor.

JSON array of stages, e.g. ["Seed","Series A"].

JSON {core: string[], other: string[]} geographic focus.

JSON {type: "Generalist"|"Specialist", focus: string[]}.

Check size USD JSON {lower_limit, upper_limit, median}; null where the investor's check size is not known.

JSON array of notable portfolio company names.

derived from companiesread-onlyJSON {total_companies_invested, investing_start_year, one_b_companies | ten_b_companies | hundred_b_companies | ipo_companies: {amount, names[]}}. Cumulative: a $50B public company appears in one_b, ten_b and ipo. ipo_companies counts companies currently public (status = public), not ever-IPOed. investing_start_year is the investor's founding_year, not derived from companies. total_companies_invested counts companies carrying a determined outcome; rows whose company could not be identified are excluded.

derived from companiesread-onlyJSON {seed_to_series_a: {rate_percent, graduated, sample_size, seed_entries, censored}}; null when the investor has no Seed-stage entry. seed_entries counts every Seed-stage entry, each of them decided; censored are too young to count (entered under 24 months ago); sample_size is the rest, the cohort, every one of them graduated or not_graduated; rate_percent is graduated / sample_size, null when the cohort is empty. Coverage of the cohort is complete by construction: a Seed entry past the 24-month clock with no evidence of a later round is counted as not graduated rather than left out. The rows behind the counts: /companies?investor_id=eq.<id>&entry_stage=eq.Seed.

derived from companiesread-onlyJSON array [{stage, companies}] sorted by companies desc, ties alphabetical; sums to the investor's companies row count. Stage vocabulary is companies.entry_stage. Share is computed by consumers, never stored. The rows behind the counts: /companies?investor_id=eq.<id>.

derived from companiesread-onlyJSON {country: [{country, companies}], city: [{city, companies}]}; each sub-array sums to the investor's companies row count and sorts by companies desc, ties alphabetical, null element last. A null-keyed element is a real count: null city means the HQ is unresolved. Countries are ISO 3166-1 alpha-2; cities are bare municipalities. Share is computed by consumers, never stored. The rows behind the counts: /companies?investor_id=eq.<id>.

derived from companiesread-onlyJSON array [{focus, companies}] over the closed twelve-value focus taxonomy, sorted by companies desc, ties alphabetical, null element last; sums to the investor's companies row count. The null element counts companies outside the taxonomy and is a real published number. Share is computed by consumers, never stored. The rows behind the counts: /companies?investor_id=eq.<id>.

institutions onlyUSD JSON range {bottom, top}. Null for individuals or when undisclosed.

institutions onlyJSON wrapper object {funds: [{name, size (USD number), vintage (year)}]}. The array sits under the "funds" key, not at the top level. Null for individuals or when undisclosed.

institutions onlyJSON array of the people at the firm, elements shaped {name, position, socials: {linkedin_url, x_url}}; position and either social URL may be null. Null for individuals.

institutions onlyyear the firm was founded.

individuals onlyJSON {current: [...], past: [...]} affiliations with roles and years. Null for institutions.

Row creation timestamp.

Last write timestamp; doubles as last-verified under the verify-then-ingest playbook.

primary keySurrogate key, minted by the database on insert. Ingest never sends it.

The investor whose portfolio this row belongs to; references investors.id.

Company name as the investor's portfolio renders it. Unique per investor; the ingest conflict key.

Headquarters city, free text, bare municipality ("Palo Alto", never "Palo Alto, CA"). Null means unresolved, not "no HQ".

Headquarters country, ISO 3166-1 alpha-2 code (US, IL, ...).

Sector focus from the closed twelve-value taxonomy. Null means the company falls outside the taxonomy, not "unknown".

The stage label of the round in which the investor first put fund money in: Pre-Seed, Seed, Series A, Growth, or `undetermined` where the record does not give the round. `undetermined` excludes the row from the stage distribution and from the seed-to-A cohort, and from nothing else — an unknown ROUND is not an unknown COMPANY, so the row keeps its band, its status, its country and its place in the track record. A row that carries `undetermined` because the company itself could not be identified reads `undetermined` in valuation_range too, and that is what takes it out of every metric.

Current company state: private, public, acquired, defunct or unknown.

Cumulative valuation bucket: below_1b, 1b_plus, 10b_plus, 100b_plus. `undetermined` means the company could not be valued, which is always true when it could not be identified and can also be true on its own: a Form D sequence or a programme's standard terms give an entry stage for a company nobody can name, and such a row carries a stage with no band. A row with any undetermined column carries no valuation_usd and is excluded from every derived metric. A bucket is a judgment, unlike the measured valuation_usd.

Exact current valuation in USD, source-gated. Null means no sourced figure, not zero.

Date the valuation_usd figure was current; always read the two together.

Seed-to-Series-A graduation of a Seed-stage entry, as a status, and every Seed entry carries one. graduated: a later priced round, cited or present in the company's own Form D sequence; a later round named Series A or later counts whatever its size. not_graduated: no later round, established by a dated search of named surfaces (the firm's own archive, the company's Form D sequence where it files in the US, and at least two publisher surfaces) at least 24 months after entry, by Form D absence, or by a cited acquisition or shutdown. censored: entered less than 24 months ago, too young to count. undetermined appears only on a row whose entry_stage is undetermined too: a company that could not be identified, or a token-funded position with no priced round to graduate from; neither is a Seed entry. Null wherever else the column does not apply, a non-Seed entry. Every graduated or not_graduated row is verified (a citation, the filings, or the recorded search) before it is ingested.

Row creation time.

Last ingest touch; a re-run that changes nothing else still bumps this.