# US investment advisers and 13F holdings, 2025-2026

**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…

US investment advisers and 13F holdings, 2025-2026 is an open, machine-readable dataset published on Mostly Right as immutable Parquet versions, with a documented column schema, a JSON query API and a direct download. Its first rows are free to read and it is open to AI agents.

## Facts

- Slug: `us-investment-advisers-and-13f-holdings-2025-2026`
- Canonical page: https://mostlyright.md/datasets/us-investment-advisers-and-13f-holdings-2025-2026
- Publisher: mostlyrightmd (https://mostlyright.md/publishers/mostlyrightmd)
- Published: 2026-11-13T14:15:14.229Z
- Tables: 5
- Formats: Apache Parquet (download), JSON (query and sample)
- Cost: the first 500 rows of each table are free to everyone; querying and downloading need a free account and count against a monthly free allowance unless the workspace is subscribed
- Metadata API: `GET https://mostlyright.md/api/v2/public/datasets/us-investment-advisers-and-13f-holdings-2025-2026`
- Topics: investment advisers, form adv, 13f holdings, institutional investors, hedge funds, sec edgar, assets under management, wealth managers

## Table directory

Tables follow the publisher's curated order. Display labels do not change table identifiers.

Start here: advisers — table id: 74596d7f-cc43-4242-89a4-612ecbe1bc4d

- advisers — table id: 74596d7f-cc43-4242-89a4-612ecbe1bc4d; published name: advisers; https://mostlyright.md/datasets/us-investment-advisers-and-13f-holdings-2025-2026/tables?table=advisers
- position_changes_13f — table id: 0e78e983-147a-4a16-aead-52831fff5cf7; published name: position_changes_13f; https://mostlyright.md/datasets/us-investment-advisers-and-13f-holdings-2025-2026/tables?table=position-changes-13f
- holdings_13f — table id: 93e2d75b-a6be-4810-bb2a-a1005ee940db; published name: holdings_13f; https://mostlyright.md/datasets/us-investment-advisers-and-13f-holdings-2025-2026/tables?table=holdings-13f
- filings_13f — table id: f30e04aa-916b-45ca-b942-cfba31799299; published name: filings_13f; https://mostlyright.md/datasets/us-investment-advisers-and-13f-holdings-2025-2026/tables?table=filings-13f
- source_advisers — table id: 83fa8364-3008-4f61-a868-d6763d3bafe2; published name: source_advisers; https://mostlyright.md/datasets/us-investment-advisers-and-13f-holdings-2025-2026/tables?table=source-advisers

## How to use it

1. Read a table's schema — no account needed.
2. Fetch its published sample rows — no account needed.
   The first 500 rows of every table, in stored order, are free to everyone, with or without an account. Without an account you get that sample and ranked row search on public tables (search_table). An empty search query pages through a table in stored order. There is no filter, sort or download without an account.
3. Log in at https://mostlyright.md/login, connect this dataset to a workspace on its page, and create an `mr_use_` key.
4. Query bounded JSON, or download the complete Parquet snapshot and read it locally.
   A free workspace may read 100,000 rows and run 1,000 queries a UTC month past the sample. The allowance is shared by everyone in the workspace, and a free workspace may have any number of members. Reads count against the workspace whose data or key they use. A subscribed workspace is never counted, for anyone working in it.

Agents can do all of this over MCP at `https://mostlyright.md/api/mcp` — searching, reading schemas and sampling rows work with no credential at all.

## Table: advisers

- Table id: `74596d7f-cc43-4242-89a4-612ecbe1bc4d`
- Slug: `advisers`
- Immutable version: `8df65671-476c-5a27-9f6a-60c3dc3b8337`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/74596d7f-cc43-4242-89a4-612ecbe1bc4d/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/74596d7f-cc43-4242-89a4-612ecbe1bc4d/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/74596d7f-cc43-4242-89a4-612ecbe1bc4d/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/74596d7f-cc43-4242-89a4-612ecbe1bc4d/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (123)

| Column | Type | Description |
| --- | --- | --- |
| `crd_number` | integer | The adviser's CRD number, the identifier FINRA and the SEC assign to each advisory firm (Form ADV Item 1.E). |
| `sec_number` | string | The adviser's SEC file number, 801- for a registered adviser and 802- for an exempt reporting adviser. |
| `business_name` | string | The name the adviser does business under (Form ADV Item 1.B). |
| `legal_name` | string | The adviser's full legal name (Form ADV Item 1.A). |
| `adviser_type` | string | The kind of adviser: hedge fund, private equity or venture, wealth manager, mutual fund manager, robo-adviser, family office or other. A Form ADV rule decides… |
| `adviser_type_source` | string | form adv rule when a rule on Form ADV answers set the type, model when the classification model set it, unclassified when neither did and the type defaults to… |
| `adviser_type_probability` | decimal | The model's probability for the label it chose. Empty when a rule set the type. |
| `adviser_type_second_choice` | string | The model's second most likely label. Empty when a rule set the type. |
| `registration_type` | string | sec_registered for an adviser registered with the SEC, exempt_reporting for a private fund adviser that reports but is not registered. |
| `registration_status` | string | The SEC registration status in the feed, such as APPROVED or ACTIVE. |
| `registration_date` | date | The date the current SEC registration or exempt report status took effect. |
| `latest_filing_date` | date | The date of the latest Form ADV filing the feed reflects. |
| `sec_region` | string | The SEC regional office code that oversees the adviser, such as NYRO or CHRO. |
| `umbrella_registration` | boolean | True when the filing is an umbrella registration that covers relying advisers. |
| `street_1` | string | Main office street address, first line. |
| `street_2` | string | Main office street address, second line. |
| `city` | string | Main office city. |
| `state` | string | Main office US state or territory, two-letter code. Empty for offices outside the United States. |
| `country` | string | Main office country. |
| `postal_code` | string | Main office postal code. |
| `phone` | string | Main office phone number. |
| `websites` | string | The adviser's website addresses from Form ADV Item 1.I, separated by a vertical bar. |
| `other_offices` | integer | Number of offices other than the main office (Form ADV Item 1.F). |
| `organization_form` | string | Legal form of the firm, such as Limited Liability Company or Corporation (Item 3.A). |
| `organized_in_state` | string | US state under whose law the firm is organised (Item 3.C). |
| `organized_in_country` | string | Country under whose law the firm is organised (Item 3.C). |
| `fiscal_year_end_month` | string | Month the firm's fiscal year ends (Item 3.B). |
| `is_public_reporting_company` | boolean | True when the adviser is itself a public reporting company under the Exchange Act (Item 1.N). |
| `has_assets_over_1bn` | boolean | True when the adviser's own balance sheet assets were 1 billion US dollars or more (Item 1.O). |
| `legal_entity_identifier` | string | The adviser's Legal Entity Identifier where it has one (Item 1.P). |
| `notice_filed_states` | integer | Number of US states where the adviser has made a notice filing. |
| `total_employees` | integer | Total employees, full and part time, excluding clerical workers (Item 5.A). |
| `advisory_employees` | integer | Employees who perform investment advisory functions, including research (Item 5.B.1). |
| `broker_dealer_rep_employees` | integer | Employees who are registered representatives of a broker-dealer (Item 5.B.2). |
| `insurance_agent_employees` | integer | Employees who are licensed insurance agents (Item 5.B.5). |
| `regulatory_aum_usd` | integer | Total regulatory assets under management in US dollars (Item 5.F.2.c). Empty for exempt reporting advisers, who do not report it here. |
| `discretionary_aum_usd` | integer | Regulatory assets under management the adviser manages with discretion, in US dollars (Item 5.F.2.a). |
| `non_discretionary_aum_usd` | integer | Regulatory assets under management without discretion, in US dollars (Item 5.F.2.b). |
| `total_accounts` | integer | Total number of accounts under management (Item 5.F.2.f). |
| `discretionary_accounts` | integer | Number of discretionary accounts (Item 5.F.2.d). |
| `non_us_client_aum_usd` | integer | Regulatory assets under management attributable to non-US clients, in US dollars (Item 5.F.3). |
| `clients_without_aum` | integer | Approximate number of clients the adviser serves without managing their assets (Item 5.C.1). |
| `non_us_client_pct` | integer | Approximate percentage of clients that are non-US persons (Item 5.C.2). |
| `clients_individuals` | integer | Number of clients that are individuals other than high net worth individuals (Item 5.D row a, column 1). Empty when the adviser reported fewer than five or non… |
| `aum_individuals_usd` | integer | Regulatory assets under management for clients that are individuals other than high net worth individuals, in US dollars (Item 5.D row a, column 3). |
| `clients_hnw_individuals` | integer | Number of clients that are high net worth individuals (Item 5.D row b, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_hnw_individuals_usd` | integer | Regulatory assets under management for clients that are high net worth individuals, in US dollars (Item 5.D row b, column 3). |
| `clients_banks` | integer | Number of clients that are banking or thrift institutions (Item 5.D row c, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_banks_usd` | integer | Regulatory assets under management for clients that are banking or thrift institutions, in US dollars (Item 5.D row c, column 3). |
| `clients_investment_companies` | integer | Number of clients that are registered investment companies such as mutual funds and ETFs (Item 5.D row d, column 1). Empty when the adviser reported fewer than… |
| `aum_investment_companies_usd` | integer | Regulatory assets under management for clients that are registered investment companies such as mutual funds and ETFs, in US dollars (Item 5.D row d, column 3). |
| `clients_bdcs` | integer | Number of clients that are business development companies (Item 5.D row e, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_bdcs_usd` | integer | Regulatory assets under management for clients that are business development companies, in US dollars (Item 5.D row e, column 3). |
| `clients_pooled_vehicles` | integer | Number of clients that are pooled investment vehicles such as hedge funds and private equity funds (Item 5.D row f, column 1). Empty when the adviser reported… |
| `aum_pooled_vehicles_usd` | integer | Regulatory assets under management for clients that are pooled investment vehicles such as hedge funds and private equity funds, in US dollars (Item 5.D row f,… |
| `clients_pension_plans` | integer | Number of clients that are pension and profit sharing plans (Item 5.D row g, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_pension_plans_usd` | integer | Regulatory assets under management for clients that are pension and profit sharing plans, in US dollars (Item 5.D row g, column 3). |
| `clients_charities` | integer | Number of clients that are charitable organizations (Item 5.D row h, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_charities_usd` | integer | Regulatory assets under management for clients that are charitable organizations, in US dollars (Item 5.D row h, column 3). |
| `clients_governments` | integer | Number of clients that are state or municipal government entities (Item 5.D row i, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_governments_usd` | integer | Regulatory assets under management for clients that are state or municipal government entities, in US dollars (Item 5.D row i, column 3). |
| `clients_other_advisers` | integer | Number of clients that are other investment advisers (Item 5.D row j, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_other_advisers_usd` | integer | Regulatory assets under management for clients that are other investment advisers, in US dollars (Item 5.D row j, column 3). |
| `clients_insurers` | integer | Number of clients that are insurance companies (Item 5.D row k, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_insurers_usd` | integer | Regulatory assets under management for clients that are insurance companies, in US dollars (Item 5.D row k, column 3). |
| `clients_sovereign_funds` | integer | Number of clients that are sovereign wealth funds and foreign official institutions (Item 5.D row l, column 1). Empty when the adviser reported fewer than five… |
| `aum_sovereign_funds_usd` | integer | Regulatory assets under management for clients that are sovereign wealth funds and foreign official institutions, in US dollars (Item 5.D row l, column 3). |
| `clients_corporations` | integer | Number of clients that are corporations or other businesses (Item 5.D row m, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_corporations_usd` | integer | Regulatory assets under management for clients that are corporations or other businesses, in US dollars (Item 5.D row m, column 3). |
| `clients_other_clients` | integer | Number of clients that are client types not listed elsewhere (Item 5.D row n, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_other_clients_usd` | integer | Regulatory assets under management for clients that are client types not listed elsewhere, in US dollars (Item 5.D row n, column 3). |
| `total_clients` | integer | Total number of clients across all Item 5.D client types. Client types reported as fewer than five count as zero. |
| `pct_aum_individuals` | decimal | Share of client assets held for individuals, high net worth or not, as a percentage of all Item 5.D assets. |
| `pct_aum_pooled_vehicles` | decimal | Share of client assets held for pooled investment vehicles such as hedge funds and private equity funds, as a percentage of all Item 5.D assets. |
| `pct_aum_investment_companies` | decimal | Share of client assets held for registered investment companies and business development companies, as a percentage of all Item 5.D assets. |
| `pct_aum_institutions` | decimal | Share of client assets held for banks, pension plans, charities, governments, insurers, sovereign funds and corporations, as a percentage of all Item 5.D asset… |
| `pct_clients_individuals` | decimal | Share of the adviser's clients that are individuals, as a percentage of all Item 5.D client counts. |
| `pct_clients_hnw` | decimal | Share of the adviser's clients that are high net worth individuals, as a percentage of all Item 5.D client counts. |
| `financial_planning_clients` | string | Band for the number of financial planning clients in the last fiscal year, such as 1-10 or More than 500 (Item 5.H). |
| `offers_financial_planning` | boolean | True when the adviser offers financial planning (Item 5.G.1). |
| `offers_portfolio_mgmt_individuals` | boolean | True when the adviser offers portfolio management for individuals and small businesses (Item 5.G.2). |
| `offers_portfolio_mgmt_investment_companies` | boolean | True when the adviser offers portfolio management for registered investment companies (Item 5.G.3). |
| `offers_portfolio_mgmt_pooled_vehicles` | boolean | True when the adviser offers portfolio management for pooled investment vehicles (Item 5.G.4). |
| `offers_portfolio_mgmt_institutions` | boolean | True when the adviser offers portfolio management for businesses and institutional clients (Item 5.G.5). |
| `offers_pension_consulting` | boolean | True when the adviser offers pension consulting (Item 5.G.6). |
| `offers_selects_other_advisers` | boolean | True when the adviser offers selection of other advisers (Item 5.G.7). |
| `other_services_text` | string | The adviser's own description of other advisory services it offers (Item 5.G.12). |
| `charges_pct_of_aum` | boolean | True when the adviser is paid a percentage of assets under management (Item 5.E.1). |
| `charges_hourly` | boolean | True when the adviser charges hourly fees (Item 5.E.2). |
| `charges_subscription` | boolean | True when the adviser charges subscription fees for a newsletter or periodical (Item 5.E.3). |
| `charges_fixed_fees` | boolean | True when the adviser charges fixed fees (Item 5.E.4). |
| `charges_commissions` | boolean | True when the adviser is paid commissions (Item 5.E.5). |
| `charges_performance_fees` | boolean | True when the adviser charges performance-based fees (Item 5.E.6). |
| `sponsors_wrap_fee_program` | boolean | True when the adviser participates in a wrap fee program (Item 5.I.1). |
| `advises_private_funds` | boolean | True when the adviser advises at least one private fund (Item 7.B). |
| `is_internet_adviser` | boolean | True when the adviser registers with the SEC under the internet adviser exemption (Item 2.A.11). |
| `advises_investment_company` | boolean | True when the adviser registers as an adviser to a registered investment company (Item 2.A.5). |
| `era_venture_capital_only` | boolean | True when an exempt reporting adviser relies on the exemption for advisers solely to venture capital funds (Item 2.B.1). |
| `era_private_funds_under_150m` | boolean | True when an exempt reporting adviser relies on the exemption for private fund advisers with under 150 million US dollars in the United States (Item 2.B.2). |
| `is_broker_dealer` | boolean | True when the adviser is also a registered broker-dealer (Item 6.A.1). |
| `is_commodity_pool_operator` | boolean | True when the adviser is also a commodity pool operator or commodity trading advisor (Item 6.A.3). |
| `is_insurance_broker` | boolean | True when the adviser is also an insurance broker or agent (Item 6.A.6). |
| `is_bank_or_trust_company` | boolean | True when the adviser is also a bank or a trust company (Items 6.A.7 and 6.A.8). |
| `affiliated_with_broker_dealer` | boolean | True when a related person is a broker-dealer (Item 7.A.1). |
| `affiliated_fund_sponsor` | boolean | True when a related person is a sponsor, general partner or managing member of pooled investment vehicles (Item 7.A.16). |
| `has_custody` | boolean | True when the adviser has custody of client cash or securities (Item 9.A.1). |
| `custody_amount_usd` | integer | Client funds and securities the adviser has custody of, in US dollars (Item 9.A.2.a). |
| `custody_clients` | integer | Number of clients whose assets the adviser has custody of (Item 9.A.2.b). |
| `related_person_has_custody` | boolean | True when a related person has custody of the adviser's client assets (Item 9.B.1). |
| `related_person_custody_amount_usd` | integer | Client funds and securities a related person has custody of, in US dollars (Item 9.B.2.a). |
| `qualified_custodians` | integer | Number of persons acting as qualified custodians for the adviser's clients (Item 9.F). |
| `has_disciplinary_disclosure` | boolean | True when the adviser answered yes to any Item 11 disciplinary question (11.A to 11.H) about the firm or its advisory affiliates. |
| `disclosure_involves_firm_or_staff` | boolean | True when the adviser said a reported disciplinary event involves the firm itself or its supervised persons, not only an affiliate (Item 11 lead question). |
| `has_criminal_disclosure` | boolean | True when the adviser reported a felony or investment-related misdemeanor conviction or charge in the past ten years (Items 11.A and 11.B). |
| `has_regulatory_action_disclosure` | boolean | True when the adviser reported a finding, order or pending proceeding by the SEC, CFTC, another regulator or a self-regulatory organization (Items 11.C to 11.G… |
| `has_civil_judicial_disclosure` | boolean | True when the adviser reported a court injunction, finding or pending civil proceeding tied to investment activity (Item 11.H). |
| `files_13f` | boolean | True when the adviser matched a Form 13F filing manager in the filings table. |
| `cik` | integer | The adviser's SEC Central Index Key, taken from its matched Form 13F filings. Empty when the adviser matched no 13F filer. Joins to filer_cik in the holdings t… |
| `cik_match_method` | string | How the adviser was matched to a 13F filer: crd number or sec file number as stated on the 13F cover page, or exact name when the legal name, stripped of punct… |
| `filer_13f_name` | string | The matched manager's name on its latest 13F cover page. |
| `latest_13f_period` | date | The quarter end of the matched manager's latest counted 13F report. |
| `latest_13f_value_usd` | integer | Total value of holdings on that latest 13F report, in US dollars. |
| `latest_13f_positions` | integer | Number of holdings lines on that latest 13F report. |

## Table: position_changes_13f

- Table id: `0e78e983-147a-4a16-aead-52831fff5cf7`
- Slug: `position-changes-13f`
- Immutable version: `6870546e-dc3f-598a-9ac6-47d9e9d365c3`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/0e78e983-147a-4a16-aead-52831fff5cf7/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/0e78e983-147a-4a16-aead-52831fff5cf7/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/0e78e983-147a-4a16-aead-52831fff5cf7/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/0e78e983-147a-4a16-aead-52831fff5cf7/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (17)

| Column | Type | Description |
| --- | --- | --- |
| `filer_cik` | integer | The filing manager's SEC Central Index Key (CIK). |
| `report_period` | date | The quarter end the change runs to, and the column the table partitions on. |
| `cusip` | string | The nine-character CUSIP of the security. |
| `put_call` | string | none for a direct holding, put or call for an option position. |
| `prior_period` | date | The previous quarter end the position is compared with. |
| `filer_name` | string | The filing manager's name. |
| `filer_crd_number` | integer | The manager's CRD number, which joins to the advisers table. |
| `issuer_name` | string | The issuer name as the manager wrote it. |
| `ticker` | string | The ticker symbol for the CUSIP, where the holdings table has one. |
| `change_type` | string | new when the manager reported the security this quarter and not the last, exited when it dropped out, increased, decreased or unchanged by quantity held, and f… |
| `shares` | integer | Shares held at the quarter end. Zero for an exited position. |
| `prior_shares` | integer | Shares held at the previous quarter end. Empty when there was no prior position. |
| `share_change` | integer | Shares held now minus shares held at the previous quarter end. |
| `share_change_pct` | decimal | The change in shares as a percentage of the prior shares. Empty for new positions and first reports. |
| `value_usd` | integer | Market value at the quarter end in US dollars. Zero for an exited position. |
| `prior_value_usd` | integer | Market value at the previous quarter end in US dollars. |
| `value_change_usd` | integer | Market value now minus market value at the previous quarter end, in US dollars. It mixes price moves with trading. |

## Table: holdings_13f

- Table id: `93e2d75b-a6be-4810-bb2a-a1005ee940db`
- Slug: `holdings-13f`
- Immutable version: `9cb162a4-c602-5fb2-8bd0-03117c58ef42`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/93e2d75b-a6be-4810-bb2a-a1005ee940db/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/93e2d75b-a6be-4810-bb2a-a1005ee940db/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/93e2d75b-a6be-4810-bb2a-a1005ee940db/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/93e2d75b-a6be-4810-bb2a-a1005ee940db/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (24)

| Column | Type | Description |
| --- | --- | --- |
| `filer_cik` | integer | The filing manager's SEC Central Index Key (CIK). |
| `report_period` | date | The calendar quarter end the holdings are reported as of, and the column the table partitions on. |
| `cusip` | string | The nine-character CUSIP of the security held. |
| `put_call` | string | none for a direct holding, put or call for an option position on the security. |
| `filer_name` | string | The filing manager's name as written on the 13F cover page. |
| `filer_crd_number` | integer | The manager's CRD number from the cover page, which joins to the advisers table. Empty when the manager gave none. |
| `issuer_name` | string | The issuer name as the manager wrote it. |
| `title_of_class` | string | The class of security as the manager wrote it, such as COM or SPONSORED ADR. |
| `figi` | string | The Financial Instrument Global Identifier, where the manager gave one. |
| `ticker` | string | The ticker symbol for the CUSIP, from the SEC fails-to-deliver lists of June to October 2026. Empty when the CUSIP did not appear there. |
| `security_description` | string | The security description the SEC fails-to-deliver list gives for the CUSIP. |
| `listed_security_name` | string | The security's listed name from the US stocks and ETFs listing, where the ticker is listed today. |
| `exchange` | string | The listing exchange of the ticker, where it is listed today. |
| `security_type` | string | Kind of listed security, such as common stock, etf or adr, where the ticker is listed today. |
| `issuer_cik` | integer | The issuer's SEC Central Index Key, where the SEC ticker list has one for the ticker. |
| `shares` | integer | Number of shares held, summed over the manager's reported lines for the security. Empty when the position is reported as a principal amount. |
| `principal_amount` | integer | Principal amount held for debt securities, summed over the manager's reported lines. Empty for share positions. |
| `value_usd` | integer | Market value of the position at the quarter end in US dollars, summed over the manager's reported lines. |
| `pct_of_portfolio` | decimal | The position's share of the manager's total reported 13F value that quarter, as a percentage. |
| `voting_sole` | integer | Shares over which the manager has sole voting authority. |
| `voting_shared` | integer | Shares over which the manager shares voting authority. |
| `voting_none` | integer | Shares over which the manager has no voting authority. |
| `reported_lines` | integer | Number of lines in the manager's information table that were summed into this row. |
| `filing_date` | date | The latest filing date among the filings the row was built from. |

## Table: filings_13f

- Table id: `f30e04aa-916b-45ca-b942-cfba31799299`
- Slug: `filings-13f`
- Immutable version: `a779b1d2-09fd-5b6e-ba0f-7362b44f7e3f`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/f30e04aa-916b-45ca-b942-cfba31799299/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/f30e04aa-916b-45ca-b942-cfba31799299/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/f30e04aa-916b-45ca-b942-cfba31799299/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/f30e04aa-916b-45ca-b942-cfba31799299/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (20)

| Column | Type | Description |
| --- | --- | --- |
| `accession_number` | string | The EDGAR accession number that identifies one 13F filing. |
| `filer_cik` | integer | The filing manager's SEC Central Index Key (CIK). |
| `filer_name` | string | The filing manager's name as written on the 13F cover page. |
| `report_period` | date | The calendar quarter end the report covers. |
| `filing_date` | date | The date the filing was submitted to the SEC. |
| `form_type` | string | The form type: 13F-HR for a holdings report, 13F-NT for a notice, with /A for an amendment. |
| `report_type` | string | 13F HOLDINGS REPORT, 13F NOTICE (holdings are reported by another manager) or 13F COMBINATION REPORT. |
| `is_amendment` | boolean | True when the filing amends an earlier report for the same period. |
| `amendment_number` | integer | The amendment's sequence number, when the filing is an amendment. |
| `amendment_type` | string | RESTATEMENT when the amendment replaces the earlier report, NEW HOLDINGS when it adds positions to it. |
| `form_13f_file_number` | string | The manager's Form 13F file number, which starts with 028-. |
| `filer_crd_number` | integer | The manager's CRD number as stated on the cover page, the key to the adviser table. Empty when the manager gave none. |
| `filer_sec_file_number` | string | The manager's SEC adviser file number (801-) as stated on the cover page. Empty when the manager gave none. |
| `filer_city` | string | City of the filing manager's address. |
| `filer_state_or_country` | string | State or country code of the filing manager's address. |
| `other_managers_count` | integer | Number of other managers whose holdings the report includes. |
| `table_entry_total` | integer | Number of holdings rows the manager states on the summary page. |
| `table_value_total_usd` | integer | Total market value of the reported holdings in US dollars, as stated on the summary page. |
| `counts_toward_holdings` | boolean | True for the filings the holdings table is built from: the latest original or restatement per manager and quarter, plus amendments that add new holdings. |
| `data_set` | string | Which SEC quarterly data set file the filing was read from, named by the quarter it mostly covers. |

## Table: source_advisers

- Table id: `83fa8364-3008-4f61-a868-d6763d3bafe2`
- Slug: `source-advisers`
- Immutable version: `524b87aa-caf4-5daa-879a-11a8b875eb2b`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/83fa8364-3008-4f61-a868-d6763d3bafe2/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/83fa8364-3008-4f61-a868-d6763d3bafe2/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/83fa8364-3008-4f61-a868-d6763d3bafe2/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/83fa8364-3008-4f61-a868-d6763d3bafe2/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (115)

| Column | Type | Description |
| --- | --- | --- |
| `crd_number` | integer | The adviser's CRD number, the identifier FINRA and the SEC assign to each advisory firm (Form ADV Item 1.E). |
| `sec_number` | string | The adviser's SEC file number, 801- for a registered adviser and 802- for an exempt reporting adviser. |
| `business_name` | string | The name the adviser does business under (Form ADV Item 1.B). |
| `legal_name` | string | The adviser's full legal name (Form ADV Item 1.A). |
| `registration_type` | string | sec_registered for an adviser registered with the SEC, exempt_reporting for a private fund adviser that reports but is not registered. |
| `registration_status` | string | The SEC registration status in the feed, such as APPROVED or ACTIVE. |
| `registration_date` | date | The date the current SEC registration or exempt report status took effect. |
| `latest_filing_date` | date | The date of the latest Form ADV filing the feed reflects. |
| `sec_region` | string | The SEC regional office code that oversees the adviser, such as NYRO or CHRO. |
| `umbrella_registration` | boolean | True when the filing is an umbrella registration that covers relying advisers. |
| `street_1` | string | Main office street address, first line. |
| `street_2` | string | Main office street address, second line. |
| `city` | string | Main office city. |
| `state` | string | Main office US state or territory, two-letter code. Empty for offices outside the United States. |
| `country` | string | Main office country. |
| `postal_code` | string | Main office postal code. |
| `phone` | string | Main office phone number. |
| `websites` | string | The adviser's website addresses from Form ADV Item 1.I, separated by a vertical bar. |
| `other_offices` | integer | Number of offices other than the main office (Form ADV Item 1.F). |
| `organization_form` | string | Legal form of the firm, such as Limited Liability Company or Corporation (Item 3.A). |
| `organized_in_state` | string | US state under whose law the firm is organised (Item 3.C). |
| `organized_in_country` | string | Country under whose law the firm is organised (Item 3.C). |
| `fiscal_year_end_month` | string | Month the firm's fiscal year ends (Item 3.B). |
| `is_public_reporting_company` | boolean | True when the adviser is itself a public reporting company under the Exchange Act (Item 1.N). |
| `has_assets_over_1bn` | boolean | True when the adviser's own balance sheet assets were 1 billion US dollars or more (Item 1.O). |
| `legal_entity_identifier` | string | The adviser's Legal Entity Identifier where it has one (Item 1.P). |
| `notice_filed_states` | integer | Number of US states where the adviser has made a notice filing. |
| `total_employees` | integer | Total employees, full and part time, excluding clerical workers (Item 5.A). |
| `advisory_employees` | integer | Employees who perform investment advisory functions, including research (Item 5.B.1). |
| `broker_dealer_rep_employees` | integer | Employees who are registered representatives of a broker-dealer (Item 5.B.2). |
| `insurance_agent_employees` | integer | Employees who are licensed insurance agents (Item 5.B.5). |
| `regulatory_aum_usd` | integer | Total regulatory assets under management in US dollars (Item 5.F.2.c). Empty for exempt reporting advisers, who do not report it here. |
| `discretionary_aum_usd` | integer | Regulatory assets under management the adviser manages with discretion, in US dollars (Item 5.F.2.a). |
| `non_discretionary_aum_usd` | integer | Regulatory assets under management without discretion, in US dollars (Item 5.F.2.b). |
| `total_accounts` | integer | Total number of accounts under management (Item 5.F.2.f). |
| `discretionary_accounts` | integer | Number of discretionary accounts (Item 5.F.2.d). |
| `non_us_client_aum_usd` | integer | Regulatory assets under management attributable to non-US clients, in US dollars (Item 5.F.3). |
| `clients_without_aum` | integer | Approximate number of clients the adviser serves without managing their assets (Item 5.C.1). |
| `non_us_client_pct` | integer | Approximate percentage of clients that are non-US persons (Item 5.C.2). |
| `clients_individuals` | integer | Number of clients that are individuals other than high net worth individuals (Item 5.D row a, column 1). Empty when the adviser reported fewer than five or non… |
| `aum_individuals_usd` | integer | Regulatory assets under management for clients that are individuals other than high net worth individuals, in US dollars (Item 5.D row a, column 3). |
| `clients_hnw_individuals` | integer | Number of clients that are high net worth individuals (Item 5.D row b, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_hnw_individuals_usd` | integer | Regulatory assets under management for clients that are high net worth individuals, in US dollars (Item 5.D row b, column 3). |
| `clients_banks` | integer | Number of clients that are banking or thrift institutions (Item 5.D row c, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_banks_usd` | integer | Regulatory assets under management for clients that are banking or thrift institutions, in US dollars (Item 5.D row c, column 3). |
| `clients_investment_companies` | integer | Number of clients that are registered investment companies such as mutual funds and ETFs (Item 5.D row d, column 1). Empty when the adviser reported fewer than… |
| `aum_investment_companies_usd` | integer | Regulatory assets under management for clients that are registered investment companies such as mutual funds and ETFs, in US dollars (Item 5.D row d, column 3). |
| `clients_bdcs` | integer | Number of clients that are business development companies (Item 5.D row e, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_bdcs_usd` | integer | Regulatory assets under management for clients that are business development companies, in US dollars (Item 5.D row e, column 3). |
| `clients_pooled_vehicles` | integer | Number of clients that are pooled investment vehicles such as hedge funds and private equity funds (Item 5.D row f, column 1). Empty when the adviser reported… |
| `aum_pooled_vehicles_usd` | integer | Regulatory assets under management for clients that are pooled investment vehicles such as hedge funds and private equity funds, in US dollars (Item 5.D row f,… |
| `clients_pension_plans` | integer | Number of clients that are pension and profit sharing plans (Item 5.D row g, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_pension_plans_usd` | integer | Regulatory assets under management for clients that are pension and profit sharing plans, in US dollars (Item 5.D row g, column 3). |
| `clients_charities` | integer | Number of clients that are charitable organizations (Item 5.D row h, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_charities_usd` | integer | Regulatory assets under management for clients that are charitable organizations, in US dollars (Item 5.D row h, column 3). |
| `clients_governments` | integer | Number of clients that are state or municipal government entities (Item 5.D row i, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_governments_usd` | integer | Regulatory assets under management for clients that are state or municipal government entities, in US dollars (Item 5.D row i, column 3). |
| `clients_other_advisers` | integer | Number of clients that are other investment advisers (Item 5.D row j, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_other_advisers_usd` | integer | Regulatory assets under management for clients that are other investment advisers, in US dollars (Item 5.D row j, column 3). |
| `clients_insurers` | integer | Number of clients that are insurance companies (Item 5.D row k, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_insurers_usd` | integer | Regulatory assets under management for clients that are insurance companies, in US dollars (Item 5.D row k, column 3). |
| `clients_sovereign_funds` | integer | Number of clients that are sovereign wealth funds and foreign official institutions (Item 5.D row l, column 1). Empty when the adviser reported fewer than five… |
| `aum_sovereign_funds_usd` | integer | Regulatory assets under management for clients that are sovereign wealth funds and foreign official institutions, in US dollars (Item 5.D row l, column 3). |
| `clients_corporations` | integer | Number of clients that are corporations or other businesses (Item 5.D row m, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_corporations_usd` | integer | Regulatory assets under management for clients that are corporations or other businesses, in US dollars (Item 5.D row m, column 3). |
| `clients_other_clients` | integer | Number of clients that are client types not listed elsewhere (Item 5.D row n, column 1). Empty when the adviser reported fewer than five or none. |
| `aum_other_clients_usd` | integer | Regulatory assets under management for clients that are client types not listed elsewhere, in US dollars (Item 5.D row n, column 3). |
| `total_clients` | integer | Total number of clients across all Item 5.D client types. Client types reported as fewer than five count as zero. |
| `pct_aum_individuals` | decimal | Share of client assets held for individuals, high net worth or not, as a percentage of all Item 5.D assets. |
| `pct_aum_pooled_vehicles` | decimal | Share of client assets held for pooled investment vehicles such as hedge funds and private equity funds, as a percentage of all Item 5.D assets. |
| `pct_aum_investment_companies` | decimal | Share of client assets held for registered investment companies and business development companies, as a percentage of all Item 5.D assets. |
| `pct_aum_institutions` | decimal | Share of client assets held for banks, pension plans, charities, governments, insurers, sovereign funds and corporations, as a percentage of all Item 5.D asset… |
| `pct_clients_individuals` | decimal | Share of the adviser's clients that are individuals, as a percentage of all Item 5.D client counts. |
| `pct_clients_hnw` | decimal | Share of the adviser's clients that are high net worth individuals, as a percentage of all Item 5.D client counts. |
| `financial_planning_clients` | string | Band for the number of financial planning clients in the last fiscal year, such as 1-10 or More than 500 (Item 5.H). |
| `offers_financial_planning` | boolean | True when the adviser offers financial planning (Item 5.G.1). |
| `offers_portfolio_mgmt_individuals` | boolean | True when the adviser offers portfolio management for individuals and small businesses (Item 5.G.2). |
| `offers_portfolio_mgmt_investment_companies` | boolean | True when the adviser offers portfolio management for registered investment companies (Item 5.G.3). |
| `offers_portfolio_mgmt_pooled_vehicles` | boolean | True when the adviser offers portfolio management for pooled investment vehicles (Item 5.G.4). |
| `offers_portfolio_mgmt_institutions` | boolean | True when the adviser offers portfolio management for businesses and institutional clients (Item 5.G.5). |
| `offers_pension_consulting` | boolean | True when the adviser offers pension consulting (Item 5.G.6). |
| `offers_selects_other_advisers` | boolean | True when the adviser offers selection of other advisers (Item 5.G.7). |
| `other_services_text` | string | The adviser's own description of other advisory services it offers (Item 5.G.12). |
| `charges_pct_of_aum` | boolean | True when the adviser is paid a percentage of assets under management (Item 5.E.1). |
| `charges_hourly` | boolean | True when the adviser charges hourly fees (Item 5.E.2). |
| `charges_subscription` | boolean | True when the adviser charges subscription fees for a newsletter or periodical (Item 5.E.3). |
| `charges_fixed_fees` | boolean | True when the adviser charges fixed fees (Item 5.E.4). |
| `charges_commissions` | boolean | True when the adviser is paid commissions (Item 5.E.5). |
| `charges_performance_fees` | boolean | True when the adviser charges performance-based fees (Item 5.E.6). |
| `sponsors_wrap_fee_program` | boolean | True when the adviser participates in a wrap fee program (Item 5.I.1). |
| `advises_private_funds` | boolean | True when the adviser advises at least one private fund (Item 7.B). |
| `is_internet_adviser` | boolean | True when the adviser registers with the SEC under the internet adviser exemption (Item 2.A.11). |
| `advises_investment_company` | boolean | True when the adviser registers as an adviser to a registered investment company (Item 2.A.5). |
| `era_venture_capital_only` | boolean | True when an exempt reporting adviser relies on the exemption for advisers solely to venture capital funds (Item 2.B.1). |
| `era_private_funds_under_150m` | boolean | True when an exempt reporting adviser relies on the exemption for private fund advisers with under 150 million US dollars in the United States (Item 2.B.2). |
| `is_broker_dealer` | boolean | True when the adviser is also a registered broker-dealer (Item 6.A.1). |
| `is_commodity_pool_operator` | boolean | True when the adviser is also a commodity pool operator or commodity trading advisor (Item 6.A.3). |
| `is_insurance_broker` | boolean | True when the adviser is also an insurance broker or agent (Item 6.A.6). |
| `is_bank_or_trust_company` | boolean | True when the adviser is also a bank or a trust company (Items 6.A.7 and 6.A.8). |
| `affiliated_with_broker_dealer` | boolean | True when a related person is a broker-dealer (Item 7.A.1). |
| `affiliated_fund_sponsor` | boolean | True when a related person is a sponsor, general partner or managing member of pooled investment vehicles (Item 7.A.16). |
| `has_custody` | boolean | True when the adviser has custody of client cash or securities (Item 9.A.1). |
| `custody_amount_usd` | integer | Client funds and securities the adviser has custody of, in US dollars (Item 9.A.2.a). |
| `custody_clients` | integer | Number of clients whose assets the adviser has custody of (Item 9.A.2.b). |
| `related_person_has_custody` | boolean | True when a related person has custody of the adviser's client assets (Item 9.B.1). |
| `related_person_custody_amount_usd` | integer | Client funds and securities a related person has custody of, in US dollars (Item 9.B.2.a). |
| `qualified_custodians` | integer | Number of persons acting as qualified custodians for the adviser's clients (Item 9.F). |
| `has_disciplinary_disclosure` | boolean | True when the adviser answered yes to any Item 11 disciplinary question (11.A to 11.H) about the firm or its advisory affiliates. |
| `disclosure_involves_firm_or_staff` | boolean | True when the adviser said a reported disciplinary event involves the firm itself or its supervised persons, not only an affiliate (Item 11 lead question). |
| `has_criminal_disclosure` | boolean | True when the adviser reported a felony or investment-related misdemeanor conviction or charge in the past ten years (Items 11.A and 11.B). |
| `has_regulatory_action_disclosure` | boolean | True when the adviser reported a finding, order or pending proceeding by the SEC, CFTC, another regulator or a self-regulatory organization (Items 11.C to 11.G… |
| `has_civil_judicial_disclosure` | boolean | True when the adviser reported a court injunction, finding or pending civil proceeding tied to investment activity (Item 11.H). |
| `info_lines_in_record` | integer | Number of identity lines the parser found inside the adviser's record in the feed. Always 1 when the feed was read in order. |
| `adviser_type_rule` | string | Adviser type where a Form ADV rule decides it: robo-adviser for internet advisers, family office by name, private equity or venture for venture-only exempt adv… |
| `classify_text` | string | A plain-language summary of the adviser's Form ADV answers that the classification model reads. Empty when a rule already decided the adviser type. |

## Citing this dataset

Cite the dataset by name and canonical URL (https://mostlyright.md/datasets/us-investment-advisers-and-13f-holdings-2025-2026), the table, and the immutable `version_id` the rows came from. A query response carries `table.version_id` and `table.content_digest`; a download carries a strong ETag and a `Content-Digest` header.
