Loading dataset

Description

See who manages money in the United States and what the largest managers hold. This dataset joins SEC Form ADV answers for 24,107 investment advisers with the Form 13F stock holdings that institutional managers report each quarter. Compare advisers by assets, clients, staff and disciplinary history, then follow a manager's positions from one quarter to the next.

The tables hold 45,407 filings and 9,560,928 holdings, and 6,941 advisers are matched to a 13F filer. Each adviser carries a type: hedge fund, private equity or venture, wealth manager, mutual fund manager, robo-adviser, family office or other. A rule on Form ADV answers sets the type for 13,014 advisers. A classification model reads a summary of the filing for the other 11,093, and its label is a judgement with a probability, not a reported fact.

Coverage

  • Advisers: every SEC-registered adviser (17,277) and exempt reporting adviser (6,830) in the SEC adviser feed of 12 November 2026.
  • Holdings: Form 13F reports for the quarter ends 30 September 2025, 31 December 2025, 31 March 2026 and 30 June 2026, from about 8,900 managers a quarter.
  • Position changes: quarter ends 31 December 2025, 31 March 2026 and 30 June 2026, each against the quarter before.
  • Grain: advisers has one row per adviser. filings_13f has one row per filing. holdings_13f and position_changes_13f have one row per manager, security, option side and quarter end.
  • Cadence: a fixed snapshot. The SEC posts a new 13F file each quarter and a new adviser feed each day.

Columns

  • crd_number, sec_number, cik: the adviser's CRD number, SEC file number and, where it files Form 13F, its Central Index Key.
  • adviser_type, adviser_type_source, adviser_type_probability: the adviser type, whether a rule or the model set it, and the model's probability.
  • regulatory_aum_usd, discretionary_aum_usd, total_accounts: regulatory assets under management in US dollars and account counts.
  • clients_*, aum_*_usd, pct_aum_*: client counts and assets for each of the 14 Form ADV client types, and the share held by individuals, pooled vehicles, registered funds and institutions.
  • total_employees, advisory_employees: staff counts.
  • city, state, country, postal_code: the main office.
  • has_custody, custody_amount_usd: whether the adviser holds client assets, and how much.
  • has_disciplinary_disclosure, has_criminal_disclosure, has_regulatory_action_disclosure, has_civil_judicial_disclosure: Form ADV Item 11 answers.
  • filer_cik, report_period, cusip, put_call: the key of a holding.
  • shares, principal_amount, value_usd, pct_of_portfolio: the size of a holding in shares, principal, US dollars and share of the manager's reported portfolio.
  • ticker, exchange, security_type, issuer_cik: the ticker for the CUSIP and its current US listing.
  • change_type, share_change, share_change_pct, value_change_usd: new, increased, decreased, unchanged, exited or first_report, with the change in shares and value.

Missing values

Exempt reporting advisers do not report assets, clients or staff on Form ADV, so those columns are empty for them. A client count is empty when the adviser reported fewer than five. cik is empty for advisers that matched no 13F filer. ticker is empty when the CUSIP did not appear in the SEC fails-to-deliver lists.

Suitable for

  • Ranking and screening advisers by assets, client mix, location or disclosures.
  • Finding which managers hold a stock and how their positions changed.
  • Comparing an adviser's reported assets with its 13F portfolio.

Source and rights

Form ADV answers come from the SEC Investment Adviser Public Disclosure compilation feed. Holdings come from the SEC Form 13F data sets. Tickers come from the SEC fails-to-deliver lists and the Nasdaq Trader listing directory. SEC publications are US government works in the public domain.

Tables5

  • Table healthStatus unavailable
    advisers
    Table overviewPublished rows24,107Columns123 rows1 Nov 1940 to 11 Nov 2026 · latest event 2 d before refresh · 6 anomalies
    Status unavailable
  • Table healthStatus unavailable
    filings_13f
    Table overviewPublished rows45,407Columns20 rows30 Sept 2001 to 30 Jun 2026 · latest event 136 d before refresh · 50 anomalies
    Status unavailable
  • Table healthStatus unavailable
    holdings_13f
    Table overviewPublished rows9,560,928Columns24 rows30 Sept 2025 to 30 Jun 2026 · latest event 136 d before refresh · 4 anomalies
    Status unavailable
  • Table healthStatus unavailable
    position_changes_13f
    Table overviewPublished rows8,152,670Columns17 rows31 Dec 2025 to 30 Jun 2026 · latest event 136 d before refresh · 3 anomalies
    Status unavailable
  • Table healthStatus unavailable
    source_advisers
    Table overviewPublished rows24,107Columns115 rows1 Nov 1940 to 11 Nov 2026 · latest event 2 d before refresh · 6 anomalies
    Status unavailable

Sources

TablePermission asserted.2 endpoints
Usage rights
Permission asserted.
Collection
2 requests across 2 endpoints

Collected endpoints

SEC Form ADV Part 1A answers for every SEC-registered and exempt reporting investment adviser, parsed from the SEC's adviser compilation feed.adv1 request
The 13F filings table of this dataset, which carries each filing manager's CIK, CRD number and SEC file number.filings1 request
gemini-decisionsServed by generativelanguage.googleapis.com1 endpoint
Usage rights
Public domain asserted.
Collection
1 request across 1 endpoint
Providers

Collected endpoints

A small classification model's reading of each adviser's Form ADV summary, labelling the adviser type.typed1 collectionAll 11,093 pages fetched

Details

Contents
5 tables · 17,807,219 rows · 299 columns
Category
Finance
Updated
Published
Version
v1
License
Not stated
Visibility
Public
Publisher
Mostly Right

Activity

Views318+318 in the last 30 days
Likes0+0 in the last 30 days
Uses8+8 in the last 30 days

Support

Talk to Mostly Right

Loading chat…