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:

FieldWhat it holdsVerified example
firm_source_idIAPD internal numeric firm ID160675
firm_name / firm_other_namesRegistered legal name plus alternate or prior namesBERKSHIRE PARTNERS LLC; KEMMERER & COMPANY FINANCIAL SERVICES
firm_ia_full_sec_numberFull 801-series SEC registration number801-73336
firm_ia_scopeACTIVE or INACTIVE registration statusACTIVE
firm_ia_disclosure_flDisciplinary disclosure flagN
firm_branches_countRegistered branch offices1
firm_ia_address_detailsJSON blob: officeAddress street1, city, state, country, postalCode200 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.

Fields returned by the IAPD firm search API (verified August 2026)
FieldDefinitionExample
firm_source_idIAPD internal numeric identifier for the adviser firm160675
firm_nameRegistered legal name of the adviser firmBERKSHIRE PARTNERS LLC
firm_other_namesArray of alternate or prior names used by the firmKEMMERER & COMPANY FINANCIAL SERVICES
firm_ia_sec_number / firm_ia_full_sec_numberSEC file number and full 801-series registration number73336 / 801-73336
firm_ia_scopeCurrent registration status of the adviserACTIVE
firm_ia_disclosure_flFlag for disciplinary disclosure events on fileN
firm_branches_countNumber of registered branch offices1
firm_ia_address_detailsJSON-encoded principal office address (street1, city, state, country, postalCode)200 Clarendon Street, Boston MA
iacontentFull Form ADV detail document: basicInformation, registrationStatus, noticeFilings, accountantSurpriseExams, exemptReportingAdvisers, brochuresadvFilingDate 02/10/2026

Pick up where this leaves off

Every one of these ships with sample rows before you commit to anything.

Diversified Financial Services All domestic and foreign private issuers filing with the SEC -…

SEC EDGAR Full-Text Search API (EFTS)

Diversified Financial Services Global - 476 upstream sources spanning US OFAC

OpenSanctions Dataset

Diversified Financial Services United States - all fifty states

FDIC Bank Data & Statistics

Diversified Financial Services United States - all FINRA-member broker-dealer activity in…

FINRA Data Catalog and API

Diversified Financial Services United States - SEC-registered advisers nationwide plus…

SEC Investment Adviser Public Disclosure (IAPD)

Investment Banking & Brokerage United States - every FINRA-registered broker-dealer firm and…

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