Datadory notebook
Form Adv Investment Adviser Database Data: Dataset Structure and Field Coverage
Datadory delivers form adv investment adviser database data covering comprehensive field definitions, entity mappings, and historical time series — structured for direct analytics and delivered on demand.
1,744 datasets. Pick your catch.
What is the form ADV investment adviser database?
It is SEC Investment Adviser Public Disclosure (IAPD) - the SEC/FINRA-run disclosure system at adviserinfo.sec.gov for firms regulated by the SEC and/or state securities regulators. The front end is an Angular single-page app backed by an Elasticsearch-style JSON service at api.adviserinfo.sec.gov, and every record keys to a firm, not to a filing document. That grain distinction matters: [SEC EDGAR Full-Text Search API (EFTS)](#efts), the slice's other SEC dataset at quality 10, indexes the full text of filing documents back to 2001; IAPD answers "which adviser firms exist, how big are they, what do they charge, and who has disclosed discipline?"
Scale sits in the tens of thousands: about 15k-plus SEC-registered RIAs and exempt reporting advisers (ERAs) plus state-registered firms. Datadory scores it 8 out of 10 on its rubric - above the 7.81 catalog-wide average across the 1,744 datasets Datadory catalogs - and tracks 12 named fields for it, all with verified definitions. It is also the only SEC/FINRA entry among the 19 primary diversified-financial-services datasets, which makes it the single entity-level registry in an otherwise statistics-heavy slice.
Which fields does the IAPD firm search return?
A firm-search hit already carries the identifiers most pipelines join on:
| Field | What it holds | Verified example |
|---|---|---|
firm_source_id | IAPD internal numeric firm ID | 160675 |
firm_name / firm_other_names | Registered legal name plus alternate or prior names | BERKSHIRE PARTNERS LLC; KEMMERER & COMPANY FINANCIAL SERVICES |
firm_ia_full_sec_number | Full 801-series SEC registration number | 801-73336 |
firm_ia_scope | ACTIVE or INACTIVE registration status | ACTIVE |
firm_ia_disclosure_fl | Disciplinary disclosure flag | N |
firm_branches_count | Registered branch offices | 1 |
firm_ia_address_details | JSON blob: officeAddress street1, city, state, country, postalCode | 200 Clarendon Street, Boston MA |
Enrichment goes deeper. A detail call returns the full iacontent document: basicInformation (firmId, firmName, iaScope, isIAFirm, advFilingDate, iaSECNumber, iaSECNumberType, CRS file reference), accountantSurpriseExams, compilationData editions, registrationStatus, noticeFilings, exemptReportingAdvisers and brochures. Regulatory assets under management, fee schedules, client types, custody arrangements, related-person affiliations and disciplinary history live in the published documents themselves - the site links Form ADV Parts 1 and 2A brochures and Client Relationship Summary (Form CRS) PDFs next to each structured record.
Who builds on the form ADV adviser registry?
Six Datadory personas tag this dataset at relevance 2 or higher, ranked by recorded relevance:
For the diligence workflow specifically, IAPD pairs naturally with FINRA BrokerCheck - FINRA's separate index of roughly 274,000 individual broker records and about 31,715 firms, served through its own keyless JSON search at api.brokercheck.finra.org - which covers the broker-dealer side of the same regulators' remit when an organization is dual-registered.
How does IAPD compare with adjacent compliance datasets?
Ranked by how often an adviser-focused workflow reaches for them alongside IAPD:
Within the industry slice these five plus IAPD span the whole regulatory surface - the 19 primary diversified-financial-services datasets average 8.37 on Datadory's rubric against that 7.81 catalog-wide mean, and three of the catalog's 145 perfect scores land here.
| Field | Definition | Example |
|---|---|---|
| firm_source_id | IAPD internal numeric identifier for the adviser firm | 160675 |
| firm_name | Registered legal name of the adviser firm | BERKSHIRE PARTNERS LLC |
| firm_other_names | Array of alternate or prior names used by the firm | KEMMERER & COMPANY FINANCIAL SERVICES |
| firm_ia_sec_number / firm_ia_full_sec_number | SEC file number and full 801-series registration number | 73336 / 801-73336 |
| firm_ia_scope | Current registration status of the adviser | ACTIVE |
| firm_ia_disclosure_fl | Flag for disciplinary disclosure events on file | N |
| firm_branches_count | Number of registered branch offices | 1 |
| firm_ia_address_details | JSON-encoded principal office address (street1, city, state, country, postalCode) | 200 Clarendon Street, Boston MA |
| iacontent | Full Form ADV detail document: basicInformation, registrationStatus, noticeFilings, accountantSurpriseExams, exemptReportingAdvisers, brochures | advFilingDate 02/10/2026 |
Pick up where this leaves off
Every one of these ships with sample rows before you commit to anything.
SEC EDGAR Full-Text Search API (EFTS)
OpenSanctions Dataset
FDIC Bank Data & Statistics
FINRA Data Catalog and API
SEC Investment Adviser Public Disclosure (IAPD)
FINRA BrokerCheck
ind_source_id
Want rows instead of a pitch? Name the datasets.
API, files, or your warehouse. Daily, weekly, or hourly.
Get a sample