4.5 MB across 1 part, newest sealed 12 November 2026 at 21:43 UTC. The first build wrote 1 part and 24,107 rows.
All 3 checks passed.
One row per adviser passed.
Adviser count passed.
Feed read in order passed.
crd_number
integer
The adviser's CRD number, the identifier FINRA and the SEC assign to each advisory firm (Form ADV Item 1.E).
24,107 distinct values, no chart
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
24,107 · 100% of valid
Min
38
25%
155131
Median
287859
75%
321104
Max
345447
sec_number
string
The adviser's SEC file number, 801- for a registered adviser and 802- for an exempt reporting adviser.
24,107 distinct values, no chart
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
24,107 · 100% of valid
business_name
string
The name the adviser does business under (Form ADV Item 1.B).
24,008 distinct values, no chart
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
24,008 · 99.6% of valid
legal_name
string
The adviser's full legal name (Form ADV Item 1.A).
24,067 distinct values, no chart
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
24,067 · 99.8% of valid
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.
sec_registered72%
exempt_reporting28%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
registration_status
string
The SEC registration status in the feed, such as APPROVED or ACTIVE.
APPROVED71%
ACTIVE28%
APPROVED-1201%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid
registration_date
date
The date the current SEC registration or exempt report status took effect.
6,473 distinct values, no chart
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
6,473 · 26.9% of valid
latest_filing_date
date
The date of the latest Form ADV filing the feed reflects.
564 distinct values, no chart
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
564 · 2.3% of valid
sec_region
string
The SEC regional office code that oversees the adviser, such as NYRO or CHRO.
NYRO17%
HQ15%
CHRO12%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
11 · 0% of valid
umbrella_registration
boolean
True when the filing is an umbrella registration that covers relying advisers.
false94%
true6%
Valid
17,259 · 71.6%
Missing
6,848 · 28.4%
Missing over time
Distinct
2 · 0% of valid
street_1
string
Main office street address, first line.
17,191 distinct values, no chart
Valid
21,702 · 90%
Missing
2,405 · 10%
Distinct
17,191 · 79.2% of valid
street_2
string
Main office street address, second line.
4,348 distinct values, no chart
Valid
14,739 · 61.1%
Missing
9,368 · 38.9%
Missing over time
Distinct
4,348 · 29.5% of valid
city
string
Main office city.
NEW YORK12%
LONDON3%
SAN FRANCISCO3%
Other (2,537)
Valid
21,702 · 90%
Missing
2,405 · 10%
Distinct
2,549 · 11.7% of valid
state
string
Main office US state or territory, two-letter code. Empty for offices outside the United States.
NY18%
CA15%
TX7%
Other (41)
Valid
18,271 · 75.8%
Missing
5,836 · 24.2%
Distinct
53 · 0.3% of valid
country
string
Main office country.
United States84%
United Kingdom4%
Hong Kong1%
Other (75)
Valid
21,702 · 90%
Missing
2,405 · 10%
Distinct
87 · 0.4% of valid
postal_code
string
Main office postal code.
6,490 distinct values, no chart
Valid
21,335 · 88.5%
Missing
2,772 · 11.5%
Distinct
6,490 · 30.4% of valid
phone
string
Main office phone number.
22,874 distinct values, no chart
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
22,874 · 94.9% of valid
websites
string
The adviser's website addresses from Form ADV Item 1.I, separated by a vertical bar.
20,875 distinct values, no chart
Valid
21,225 · 88%
Missing
2,882 · 12%
Distinct
20,875 · 98.4% of valid
other_offices
integer
Number of offices other than the main office (Form ADV Item 1.F).
020864
Valid
24,105 · 100%
Missing
2 · 0%
Distinct
195 · 0.8% of valid
Min
0
25%
0
Median
0
75%
1
Max
20864
organization_form
string
Legal form of the firm, such as Limited Liability Company or Corporation (Item 3.A).
Limited Liability Company63%
Corporation22%
Limited Partnership8%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
7 · 0% of valid
organized_in_state
string
US state under whose law the firm is organised (Item 3.C).
DE48%
CA6%
TX4%
Other (41)
Valid
20,770 · 86.2%
Missing
3,337 · 13.8%
Distinct
53 · 0.3% of valid
organized_in_country
string
Country under whose law the firm is organised (Item 3.C).
United States86%
United Kingdom3%
Cayman Islands1%
Other (59)
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
71 · 0.3% of valid
fiscal_year_end_month
string
Month the firm's fiscal year ends (Item 3.B).
DECEMBER94%
MARCH3%
JUNE1%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
12 · 0% of valid
is_public_reporting_company
boolean
True when the adviser is itself a public reporting company under the Exchange Act (Item 1.N).
false100%
true0%
Valid
24,106 · 100%
Missing
1 · 0%
Distinct
2 · 0% of valid
has_assets_over_1bn
boolean
True when the adviser's own balance sheet assets were 1 billion US dollars or more (Item 1.O).
false97%
true3%
Valid
24,106 · 100%
Missing
1 · 0%
Distinct
2 · 0% of valid
legal_entity_identifier
string
The adviser's Legal Entity Identifier where it has one (Item 1.P).
4,544 distinct values, no chart
Valid
4,627 · 19.2%
Missing
19,480 · 80.8%
Missing over time
Distinct
4,544 · 98.2% of valid
notice_filed_states
integer
Number of US states where the adviser has made a notice filing.
053
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
54 · 0.2% of valid
Min
0
25%
0
Median
1
75%
5
Max
53
total_employees
integer
Total employees, full and part time, excluding clerical workers (Item 5.A).
041879
Valid
17,276 · 71.7%
Missing
6,831 · 28.3%
Distinct
612 · 3.5% of valid
Min
0
25%
4
Median
8
75%
19
Max
41879
advisory_employees
integer
Employees who perform investment advisory functions, including research (Item 5.B.1).
036280
Valid
17,276 · 71.7%
Missing
6,831 · 28.3%
Missing over time
Distinct
405 · 2.3% of valid
Min
0
25%
2
Median
5
75%
11
Max
36280
broker_dealer_rep_employees
integer
Employees who are registered representatives of a broker-dealer (Item 5.B.2).
032010
Valid
17,276 · 71.7%
Missing
6,831 · 28.3%
Missing over time
Distinct
307 · 1.8% of valid
Min
0
25%
0
Median
0
75%
0
Max
32010
insurance_agent_employees
integer
Employees who are licensed insurance agents (Item 5.B.5).
026112
Valid
17,276 · 71.7%
Missing
6,831 · 28.3%
Missing over time
Distinct
228 · 1.3% of valid
Min
0
25%
0
Median
0
75%
1
Max
26112
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.
011092665107962
Valid
16,909 · 70.1%
Missing
7,198 · 29.9%
Missing over time
Distinct
16,433 · 97.2% of valid
Min
0
25%
184036686
Median
433266156
75%
1518044632
Max
11092665107962
discretionary_aum_usd
integer
Regulatory assets under management the adviser manages with discretion, in US dollars (Item 5.F.2.a).
011092665107962
Valid
16,909 · 70.1%
Missing
7,198 · 29.9%
Missing over time
Distinct
15,894 · 94% of valid
Min
0
25%
154861510
Median
376943321
75%
1322841602
Max
11092665107962
non_discretionary_aum_usd
integer
Regulatory assets under management without discretion, in US dollars (Item 5.F.2.b).
01340266100323
Valid
16,909 · 70.1%
Missing
7,198 · 29.9%
Missing over time
Distinct
6,455 · 38.2% of valid
Min
0
25%
0
Median
0
75%
19109720
Max
1340266100323
total_accounts
integer
Total number of accounts under management (Item 5.F.2.f).
05630517
Valid
16,909 · 70.1%
Missing
7,198 · 29.9%
Missing over time
Distinct
3,339 · 19.7% of valid
Min
0
25%
11
Median
199
75%
783
Max
5630517
discretionary_accounts
integer
Number of discretionary accounts (Item 5.F.2.d).
04921411
Valid
16,909 · 70.1%
Missing
7,198 · 29.9%
Missing over time
Distinct
3,197 · 18.9% of valid
Min
0
25%
8
Median
153
75%
715
Max
4921411
non_us_client_aum_usd
integer
Regulatory assets under management attributable to non-US clients, in US dollars (Item 5.F.3).
01730672426442
Valid
16,907 · 70.1%
Missing
7,200 · 29.9%
Missing over time
Distinct
5,750 · 34% of valid
Min
0
25%
0
Median
0
75%
8700000
Max
1730672426442
clients_without_aum
integer
Approximate number of clients the adviser serves without managing their assets (Item 5.C.1).
02356471235
Valid
17,275 · 71.7%
Missing
6,832 · 28.3%
Missing over time
Distinct
530 · 3.1% of valid
Min
0
25%
0
Median
0
75%
1
Max
2356471235
non_us_client_pct
integer
Approximate percentage of clients that are non-US persons (Item 5.C.2).
0100
Valid
17,276 · 71.7%
Missing
6,831 · 28.3%
Distinct
101 · 0.6% of valid
Min
0
25%
0
Median
0
75%
1
Max
100
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 none.
08158308
Valid
11,294 · 46.8%
Missing
12,813 · 53.2%
Missing over time
Distinct
1,871 · 16.6% of valid
Min
0
25%
20
Median
112
75%
330
Max
8158308
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).
01245388422212
Valid
11,116 · 46.1%
Missing
12,991 · 53.9%
Missing over time
Distinct
9,469 · 85.2% of valid
Min
0
25%
7639922
Median
39871504
75%
104375033
Max
1245388422212
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.
0853775
Valid
11,747 · 48.7%
Missing
12,360 · 51.3%
Missing over time
Distinct
1,118 · 9.5% of valid
Min
0
25%
22
Median
59
75%
139
Max
853775
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).
01227514988596
Valid
11,645 · 48.3%
Missing
12,462 · 51.7%
Missing over time
Distinct
10,242 · 88% of valid
Min
0
25%
68500000
Median
165985377
75%
434212997
Max
1227514988596
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.
04257
Valid
5,376 · 22.3%
Missing
18,731 · 77.7%
Missing over time
Distinct
55 · 1% of valid
Min
0
25%
0
Median
0
75%
0
Max
4257
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).
074579046006
Valid
5,011 · 20.8%
Missing
19,096 · 79.2%
Missing over time
Distinct
374 · 7.5% of valid
Min
0
25%
0
Median
0
75%
0
Max
74579046006
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 five or none.
01954
Valid
6,351 · 26.3%
Missing
17,756 · 73.7%
Missing over time
Distinct
122 · 1.9% of valid
Min
0
25%
0
Median
0
75%
1
Max
1954
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).
011092665107962
Valid
5,880 · 24.4%
Missing
18,227 · 75.6%
Missing over time
Distinct
1,571 · 26.7% of valid
Min
0
25%
0
Median
0
75%
12060771
Max
11092665107962
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.
019
Valid
5,417 · 22.5%
Missing
18,690 · 77.5%
Missing over time
Distinct
9 · 0.2% of valid
Min
0
25%
0
Median
0
75%
0
Max
19
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).
0100648623982
Valid
4,887 · 20.3%
Missing
19,220 · 79.7%
Missing over time
Distinct
129 · 2.6% of valid
Min
0
25%
0
Median
0
75%
0
Max
100648623982
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 fewer than five or none.
05840
Valid
10,177 · 42.2%
Missing
13,930 · 57.8%
Missing over time
Distinct
214 · 2.1% of valid
Min
0
25%
0
Median
2
75%
8
Max
5840
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, column 3).
01420593013430
Valid
9,906 · 41.1%
Missing
14,201 · 58.9%
Missing over time
Distinct
6,369 · 64.3% of valid
Min
0
25%
0
Median
168147525
75%
1198312942
Max
1420593013430
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.
0110773
Valid
7,365 · 30.6%
Missing
16,742 · 69.4%
Missing over time
Distinct
361 · 4.9% of valid
Min
0
25%
0
Median
1
75%
11
Max
110773
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).
01071600410597
Valid
7,971 · 33.1%
Missing
16,136 · 66.9%
Missing over time
Distinct
5,092 · 63.9% of valid
Min
0
25%
0
Median
3922773
75%
36664432
Max
1071600410597
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.
039751
Valid
7,266 · 30.1%
Missing
16,841 · 69.9%
Missing over time
Distinct
236 · 3.2% of valid
Min
0
25%
0
Median
1
75%
6
Max
39751
aum_charities_usd
integer
Regulatory assets under management for clients that are charitable organizations, in US dollars (Item 5.D row h, column 3).
0185982691991
Valid
8,315 · 34.5%
Missing
15,792 · 65.5%
Missing over time
Distinct
5,468 · 65.8% of valid
Min
0
25%
0
Median
1600000
75%
20729150
Max
185982691991
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.
02948
Valid
5,621 · 23.3%
Missing
18,486 · 76.7%
Missing over time
Distinct
108 · 1.9% of valid
Min
0
25%
0
Median
0
75%
0
Max
2948
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).
0249176313534
Valid
5,423 · 22.5%
Missing
18,684 · 77.5%
Missing over time
Distinct
1,160 · 21.4% of valid
Min
0
25%
0
Median
0
75%
0
Max
249176313534
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.
0766796
Valid
5,570 · 23.1%
Missing
18,537 · 76.9%
Missing over time
Distinct
99 · 1.8% of valid
Min
0
25%
0
Median
0
75%
0
Max
766796
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).
0180914816865
Valid
5,330 · 22.1%
Missing
18,777 · 77.9%
Missing over time
Distinct
821 · 15.4% of valid
Min
0
25%
0
Median
0
75%
0
Max
180914816865
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.
01387
Valid
5,579 · 23.1%
Missing
18,528 · 76.9%
Missing over time
Distinct
91 · 1.6% of valid
Min
0
25%
0
Median
0
75%
0
Max
1387
aum_insurers_usd
integer
Regulatory assets under management for clients that are insurance companies, in US dollars (Item 5.D row k, column 3).
0457645185538
Valid
5,349 · 22.2%
Missing
18,758 · 77.8%
Missing over time
Distinct
982 · 18.4% of valid
Min
0
25%
0
Median
0
75%
0
Max
457645185538
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 or none.
0104
Valid
5,331 · 22.1%
Missing
18,776 · 77.9%
Missing over time
Distinct
32 · 0.6% of valid
Min
0
25%
0
Median
0
75%
0
Max
104
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).
0228056671761
Valid
4,963 · 20.6%
Missing
19,144 · 79.4%
Missing over time
Distinct
348 · 7% of valid
Min
0
25%
0
Median
0
75%
0
Max
228056671761
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.
027490
Valid
7,645 · 31.7%
Missing
16,462 · 68.3%
Missing over time
Distinct
357 · 4.7% of valid
Min
0
25%
0
Median
2
75%
9
Max
27490
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).
0226815123900
Valid
8,442 · 35%
Missing
15,665 · 65%
Missing over time
Distinct
5,712 · 67.7% of valid
Min
0
25%
0
Median
2525198
75%
32534000
Max
226815123900
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.
0126256
Valid
5,232 · 21.7%
Missing
18,875 · 78.3%
Missing over time
Distinct
174 · 3.3% of valid
Min
0
25%
0
Median
0
75%
0
Max
126256
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).
0140322908739
Valid
5,157 · 21.4%
Missing
18,950 · 78.6%
Missing over time
Distinct
1,327 · 25.7% of valid
Min
0
25%
0
Median
0
75%
117220
Max
140322908739
total_clients
integer
Total number of clients across all Item 5.D client types. Client types reported as fewer than five count as zero.
18158329
Valid
16,635 · 69%
Missing
7,472 · 31%
Missing over time
Distinct
2,307 · 13.9% of valid
Min
1
25%
11
Median
102
75%
344
Max
8158329
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.
0.0100.0
Valid
16,600 · 68.9%
Missing
7,507 · 31.1%
Missing over time
Distinct
935 · 5.6% of valid
Min
0.0
25%
0.0
Median
77.2
75%
98.5
Max
100.0
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.
0.0100.0
Valid
16,600 · 68.9%
Missing
7,507 · 31.1%
Missing over time
Distinct
874 · 5.3% of valid
Min
0.0
25%
0.0
Median
0.0
75%
80.6
Max
100.0
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.
0.0100.0
Valid
16,600 · 68.9%
Missing
7,507 · 31.1%
Missing over time
Distinct
595 · 3.6% of valid
Min
0.0
25%
0.0
Median
0.0
75%
0.0
Max
100.0
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 assets.
0.0100.0
Valid
16,600 · 68.9%
Missing
7,507 · 31.1%
Missing over time
Distinct
904 · 5.4% of valid
Min
0.0
25%
0.0
Median
0.5
75%
8.2
Max
100.0
pct_clients_individuals
decimal
Share of the adviser's clients that are individuals, as a percentage of all Item 5.D client counts.
0.0100.0
Valid
16,635 · 69%
Missing
7,472 · 31%
Missing over time
Distinct
669 · 4% of valid
Min
0.0
25%
0.0
Median
92.4
75%
99.4
Max
100.0
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.
0.0100.0
Valid
16,635 · 69%
Missing
7,472 · 31%
Missing over time
Distinct
986 · 5.9% of valid
Min
0.0
25%
0.0
Median
14.8
75%
43.6
Max
100.0
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).
037%
1-1015%
101-25012%
Valid
10,024 · 41.6%
Missing
14,083 · 58.4%
Missing over time
Distinct
8 · 0.1% of valid
offers_financial_planning
boolean
True when the adviser offers financial planning (Item 5.G.1).
false54%
true46%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
offers_portfolio_mgmt_individuals
boolean
True when the adviser offers portfolio management for individuals and small businesses (Item 5.G.2).
true65%
false35%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
offers_portfolio_mgmt_investment_companies
boolean
True when the adviser offers portfolio management for registered investment companies (Item 5.G.3).
false91%
true9%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
offers_portfolio_mgmt_pooled_vehicles
boolean
True when the adviser offers portfolio management for pooled investment vehicles (Item 5.G.4).
false61%
true39%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
offers_portfolio_mgmt_institutions
boolean
True when the adviser offers portfolio management for businesses and institutional clients (Item 5.G.5).
false63%
true37%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
offers_pension_consulting
boolean
True when the adviser offers pension consulting (Item 5.G.6).
false79%
true21%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
offers_selects_other_advisers
boolean
True when the adviser offers selection of other advisers (Item 5.G.7).
false70%
true30%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
other_services_text
string
The adviser's own description of other advisory services it offers (Item 5.G.12).
1,707 distinct values, no chart
Valid
2,557 · 10.6%
Missing
21,550 · 89.4%
Missing over time
Distinct
1,707 · 66.8% of valid
charges_pct_of_aum
boolean
True when the adviser is paid a percentage of assets under management (Item 5.E.1).
true95%
false5%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
charges_hourly
boolean
True when the adviser charges hourly fees (Item 5.E.2).
false71%
true29%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
charges_subscription
boolean
True when the adviser charges subscription fees for a newsletter or periodical (Item 5.E.3).
false99%
true1%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
charges_fixed_fees
boolean
True when the adviser charges fixed fees (Item 5.E.4).
false55%
true45%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
charges_commissions
boolean
True when the adviser is paid commissions (Item 5.E.5).
false98%
true2%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
charges_performance_fees
boolean
True when the adviser charges performance-based fees (Item 5.E.6).
false64%
true36%
Valid
17,277 · 71.7%
Missing
6,830 · 28.3%
Distinct
2 · 0% of valid
sponsors_wrap_fee_program
boolean
True when the adviser participates in a wrap fee program (Item 5.I.1).
false88%
true12%
Valid
17,275 · 71.7%
Missing
6,832 · 28.3%
Missing over time
Distinct
2 · 0% of valid
advises_private_funds
boolean
True when the adviser advises at least one private fund (Item 7.B).
true54%
false46%
Valid
24,106 · 100%
Missing
1 · 0%
Distinct
2 · 0% of valid
is_internet_adviser
boolean
True when the adviser registers with the SEC under the internet adviser exemption (Item 2.A.11).
false99%
true1%
Valid
17,276 · 71.7%
Missing
6,831 · 28.3%
Distinct
2 · 0% of valid
advises_investment_company
boolean
True when the adviser registers as an adviser to a registered investment company (Item 2.A.5).
false93%
true7%
Valid
17,276 · 71.7%
Missing
6,831 · 28.3%
Missing over time
Distinct
2 · 0% of valid
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).
false66%
true34%
Valid
6,830 · 28.3%
Missing
17,277 · 71.7%
Missing over time
Distinct
2 · 0% of valid
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).
true72%
false28%
Valid
6,830 · 28.3%
Missing
17,277 · 71.7%
Missing over time
Distinct
2 · 0% of valid
is_broker_dealer
boolean
True when the adviser is also a registered broker-dealer (Item 6.A.1).
false92%
true8%
Valid
5,620 · 23.3%
Missing
18,487 · 76.7%
Missing over time
Distinct
2 · 0% of valid
is_commodity_pool_operator
boolean
True when the adviser is also a commodity pool operator or commodity trading advisor (Item 6.A.3).
true58%
false42%
Valid
5,620 · 23.3%
Missing
18,487 · 76.7%
Missing over time
Distinct
2 · 0% of valid
is_insurance_broker
boolean
True when the adviser is also an insurance broker or agent (Item 6.A.6).
false74%
true26%
Valid
5,620 · 23.3%
Missing
18,487 · 76.7%
Missing over time
Distinct
2 · 0% of valid
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).
false100%
true0%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
affiliated_with_broker_dealer
boolean
True when a related person is a broker-dealer (Item 7.A.1).
false82%
true18%
Valid
15,993 · 66.3%
Missing
8,114 · 33.7%
Missing over time
Distinct
2 · 0% of valid
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).
true70%
false30%
Valid
15,993 · 66.3%
Missing
8,114 · 33.7%
Missing over time
Distinct
2 · 0% of valid
has_custody
boolean
True when the adviser has custody of client cash or securities (Item 9.A.1).
false64%
true36%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
custody_amount_usd
integer
Client funds and securities the adviser has custody of, in US dollars (Item 9.A.2.a).
02010231353192
Valid
9,183 · 38.1%
Missing
14,924 · 61.9%
Missing over time
Distinct
7,705 · 83.9% of valid
Min
0
25%
13028436
Median
118694860
75%
513906913
Max
2010231353192
custody_clients
integer
Number of clients whose assets the adviser has custody of (Item 9.A.2.b).
0404486016
Valid
9,189 · 38.1%
Missing
14,918 · 61.9%
Missing over time
Distinct
1,040 · 11.3% of valid
Min
0
25%
2
Median
14
75%
102
Max
404486016
related_person_has_custody
boolean
True when a related person has custody of the adviser's client assets (Item 9.B.1).
false78%
true22%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
related_person_custody_amount_usd
integer
Client funds and securities a related person has custody of, in US dollars (Item 9.B.2.a).
01370117165178
Valid
5,781 · 24%
Missing
18,326 · 76%
Missing over time
Distinct
5,137 · 88.9% of valid
Min
0
25%
37507073
Median
329490823
75%
1571562227
Max
1370117165178
qualified_custodians
integer
Number of persons acting as qualified custodians for the adviser's clients (Item 9.F).
0158
Valid
12,036 · 49.9%
Missing
12,071 · 50.1%
Missing over time
Distinct
82 · 0.7% of valid
Min
0
25%
1
Median
2
75%
3
Max
158
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.
false90%
true10%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
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).
false96%
true4%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
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).
false99%
true1%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
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).
false91%
true9%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
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).
false99%
true1%
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
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.
1 distinct value, no chart
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
1 · 0% of valid
Min
1
25%
1
Median
1
75%
1
Max
1
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 advisers and private fund advisers named as such, mutual fund manager or wealth manager when that client group holds at least half of client assets. Empty when no rule decides.
wealth manager70%
private equity or venture22%
mutual fund manager6%
Valid
13,014 · 54%
Missing
11,093 · 46%
Missing over time
Distinct
5 · 0% of valid
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.
11,094 distinct values, no chart
Valid
24,107 · 100%
Missing
0 · 0%
Distinct
11,094 · 46% of valid
Table profile
Profile of the served version, all rows, computed 16 Nov 2026, 17:07 UTC
Passed
Freshness
Latest event 2 d before this version
Warning
Gaps
14 empty years, 1942 to 1946, 1948 to 1950, 1952 to 1954 and 2 more