Public API

Merit Capital Data API

This API contains the full database powering Merit Capital, queryable without authentication.

OpenAPI spec for agents
/data
Machine-readable; regenerated on every schema change.

Example queries

Filtering, ordering, column selection, and pagination follow the PostgREST query syntax, including resource embedding between investors and companies in both directions.

/data/investor_requests

Reference

Generated live from the database schema. Long column descriptions are shortened here; agents get the full text at /data.

GET/data/investors

All venture investors, one row each: institutions and individuals share the base profile fields; the institutional fields (aum, funds, individuals, founding_year) and the individual field (affiliation) are populated depending on investor_type, with the non-applicable side null.

Identity

id
text
primary keyStable unique identifier (text).
name
text
Display name of the investor.
slug
text
URL-friendly unique identifier. Use for lookups, e.g. investors?slug=eq.sequoia-capital.
icon_url
text
URL of the investor's logo/icon image.
website
text
Official website URL.
hq_location
text
Headquarters location as free text.

Investment thesis

investment_concept
text
Investment philosophy / thesis description.
history
text
Narrative history of the investor.
investment_stage
json
JSON array of stages, e.g. ["Seed","Series A"].
investment_geo
json
JSON {core: string[], other: string[]} geographic focus.
investment_scope
json
JSON {type: "Generalist"|"Specialist", focus: string[]}.
investment_range
json
Check size USD JSON {lower_limit, upper_limit, median}; null where the investor's check size is not known.
notable_investments
json
JSON array of notable portfolio company names.

Performance

track_record
json
derived from companiesread-onlyJSON {total_companies_invested, investing_start_year, one_b_companies | ten_b_companies | hundred_b_companies | ipo_companies: {amount, names[]}}. The bands are cumulative, ipo_companies counts companies public today, and total_companies_invested counts companies with a determined outcome.
graduation_rate
json
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. rate_percent is graduated over sample_size, which leaves out the censored entries, those under 24 months old.

Portfolio distributions

company_stage_distribution
json
derived from companiesread-onlyJSON array [{stage, companies}] sorted by companies desc, summing to the investor's company rows; the stage vocabulary is companies.entry_stage. Shares are computed by consumers, never stored.
company_geo_distribution
json
derived from companiesread-onlyJSON {country: [{country, companies}], city: [{city, companies}]}, each sorted by companies desc and summing to the investor's company rows. Countries are ISO 3166-1 alpha-2, cities bare municipalities, and a null key is a real count of unresolved headquarters.
company_category_distribution
json
JSON array [{category, companies}] counting the investor's companies that carry each of the 25 categories, sorted by companies desc; a company carries up to three categories, so the counts add up to more than the company rows. The null element counts the companies with no category.

Investor Details

aum
json
USD JSON range {bottom, top}. Null when undisclosed.
funds
json
JSON wrapper object {funds: [{name, size (USD number), vintage (year)}]}; the array sits under the "funds" key, not at the top level. Null when undisclosed.
individuals
json
JSON array of the people at the firm, elements shaped {name, position, socials: {linkedin_url, x_url}}; position and either social URL may be null.
founding_year
number
Year the firm was founded.

Metadata

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

GET/data/companies

Portfolio companies as classified by the outcome pipeline, one row per (investor, company) pair. A company backed by two investors appears twice. Also the derivation source for the investor-level metrics: recompute_investor_metrics aggregates these rows into investors.track_record, graduation_rate and the three company_*_distribution columns on every write to this table. Filter one portfolio by investor_id, or by slug through an embedded filter: ?select=*,investors!inner(slug)&investors.slug=eq.<slug>. Embedding investors<->companies works in both directions, but embedded lists carry no Content-Range; paginate on this endpoint, never inside an embed.

Identity

id
uuid
primary keySurrogate key, minted by the database on insert. Ingest never sends it.
investor_id
text
The investor whose portfolio this row belongs to; references investors.id.
name
text
Company name as the investor's portfolio renders it. Unique per investor; the ingest conflict key.

Classification

hq_city
text
Headquarters city, free text, bare municipality ("Palo Alto", never "Palo Alto, CA"). Null means unresolved, not "no HQ".
hq_country
text
Headquarters country, ISO 3166-1 alpha-2 code (US, IL, ...).
categories
text[]
Investment categories of the company, up to three from the closed list of 25 (market or product, technology, customer, business model), the market category first. Judged once per company across every investor, so two investors holding one company carry the same categories; an empty array is a company that fits no category.
company_key
text
Key of the company across investors: cik:<SEC CIK>, domain:<web domain> or name:<normalised name>. Rows of different investors with the same key are one company, and their categories are judged together.
entry_stage
text
The stage 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. An undetermined round leaves the row out of the stage distribution and the seed-to-A cohort only; it keeps its band, status, country and place in the track record.

Outcome

status
text
Current company state: private, public, acquired, defunct or unknown.
valuation_range
text
Cumulative valuation bucket: below_1b, 1b_plus, 10b_plus, 100b_plus, or undetermined where the company could not be valued. A row with any undetermined column carries no valuation_usd and is excluded from every derived metric.
valuation_usd
number
Exact current valuation in USD, source-gated. Null means no sourced figure, not zero.
valuation_asof
date
Date the valuation_usd figure was current; always read the two together.
seed_to_a_graduation
enum
Seed-to-Series-A graduation of a Seed-stage entry: graduated (a later priced round, cited or in the company's Form D sequence), not_graduated (no later round found at least 24 months after entry, or an acquisition or shutdown), censored (entered under 24 months ago), or undetermined (the entry stage is undetermined too). Null on a non-Seed entry.

Metadata

created_at
timestamp
Row creation time.
updated_at
timestamp
Last ingest touch; a re-run that changes nothing else still bumps this.

GET/data/investor_requests

Requests from visitors to add an investor to the index, one row per request, filed through the form on the index page. The email column is not readable, so name the columns you read: ?select=id,created_at,investor_name. A request without select asks for every column and is refused. Rows are written by the form only.

Request

id
uuid
primary keyStable unique identifier (uuid).
investor_name
text
The investor the visitor asked for, as typed, at most 40 characters. Visitor input, not checked.
email
text
not readableThe requester's email address, kept private and used only to answer the request. Selecting it is refused.

Metadata

created_at
timestamp
When the request was filed.