Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

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 timeMissing share of umbrella_registration over time, 0% to 43%.
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 timeMissing share of street_2 over time, 0% to 100%.
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).

Histogram: 0 to 2608, 24,095; 2609 to 5216, 5; 5217 to 7824, 3; 7825 to 10432, 0; 10433 to 13040, 0; 13041 to 15648, 1; 15649 to 18256, 0; 18257 to 20864, 1
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 timeMissing share of legal_entity_identifier over time, 0% to 100%.
Distinct
4,544 · 98.2% of valid

notice_filed_states

integer

Number of US states where the adviser has made a notice filing.

Histogram: 0 to 6, 19,063; 7 to 13, 2,519; 14 to 20, 817; 21 to 26, 353; 27 to 33, 229; 34 to 40, 208; 41 to 47, 133; 48 to 53, 785
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).

Histogram: 0 to 5234, 17,252; 5235 to 10469, 14; 10470 to 15704, 2; 15705 to 20939, 3; 20940 to 26174, 0; 26175 to 31409, 2; 31410 to 36644, 2; 36645 to 41879, 1
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).

Histogram: 0 to 4535, 17,258; 4536 to 9070, 11; 9071 to 13605, 3; 13606 to 18140, 1; 18141 to 22675, 1; 22676 to 27210, 1; 27211 to 31745, 0; 31746 to 36280, 1
036280
Valid
17,276 · 71.7%
Missing
6,831 · 28.3%
Missing over timeMissing share of advisory_employees over time, 0% to 43%.
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).

Histogram: 0 to 4001, 17,255; 4002 to 8002, 10; 8003 to 12004, 3; 12005 to 16005, 1; 16006 to 20006, 3; 20007 to 24008, 0; 24009 to 28009, 3; 28010 to 32010, 1
032010
Valid
17,276 · 71.7%
Missing
6,831 · 28.3%
Missing over timeMissing share of broker_dealer_rep_employees over time, 0% to 43%.
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).

Histogram: 0 to 3264, 17,257; 3265 to 6528, 9; 6529 to 9792, 4; 9793 to 13056, 2; 13057 to 16320, 2; 16321 to 19584, 0; 19585 to 22848, 1; 22849 to 26112, 1
026112
Valid
17,276 · 71.7%
Missing
6,831 · 28.3%
Missing over timeMissing share of insurance_agent_employees over time, 0% to 43%.
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.

Histogram: 0 to 1386583138495, 16,892; 1386583138496 to 2773166276990, 10; 2773166276991 to 4159749415486, 2; 4159749415487 to 5546332553981, 2; 5546332553982 to 6932915692476, 1; 6932915692477 to 8319498830972, 0; 8319498830973 to 9706081969467, 1; 9706081969468 to 11092665107962, 1
011092665107962
Valid
16,909 · 70.1%
Missing
7,198 · 29.9%
Missing over timeMissing share of regulatory_aum_usd over time, 0% to 50%.
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).

Histogram: 0 to 1386583138495, 16,894; 1386583138496 to 2773166276990, 8; 2773166276991 to 4159749415486, 2; 4159749415487 to 5546332553981, 2; 5546332553982 to 6932915692476, 1; 6932915692477 to 8319498830972, 0; 8319498830973 to 9706081969467, 1; 9706081969468 to 11092665107962, 1
011092665107962
Valid
16,909 · 70.1%
Missing
7,198 · 29.9%
Missing over timeMissing share of discretionary_aum_usd over time, 0% to 50%.
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).

Histogram: 0 to 167533262540, 16,897; 167533262541 to 335066525080, 7; 335066525081 to 502599787621, 0; 502599787622 to 670133050161, 3; 670133050162 to 837666312702, 0; 837666312703 to 1005199575242, 1; 1005199575243 to 1172732837783, 0; 1172732837784 to 1340266100323, 1
01340266100323
Valid
16,909 · 70.1%
Missing
7,198 · 29.9%
Missing over timeMissing share of non_discretionary_aum_usd over time, 0% to 50%.
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).

Histogram: 0 to 703814, 16,884; 703815 to 1407629, 14; 1407630 to 2111444, 2; 2111445 to 2815258, 4; 2815259 to 3519073, 3; 3519074 to 4222888, 0; 4222889 to 4926703, 0; 4926704 to 5630517, 2
05630517
Valid
16,909 · 70.1%
Missing
7,198 · 29.9%
Missing over timeMissing share of total_accounts over time, 0% to 50%.
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).

Histogram: 0 to 615176, 16,888; 615177 to 1230352, 11; 1230353 to 1845529, 4; 1845530 to 2460705, 3; 2460706 to 3075882, 2; 3075883 to 3691058, 0; 3691059 to 4306235, 0; 4306236 to 4921411, 1
04921411
Valid
16,909 · 70.1%
Missing
7,198 · 29.9%
Missing over timeMissing share of discretionary_accounts over time, 0% to 50%.
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).

Histogram: 0 to 216334053305, 16,881; 216334053306 to 432668106610, 18; 432668106611 to 649002159916, 4; 649002159917 to 865336213221, 3; 865336213222 to 1081670266526, 0; 1081670266527 to 1298004319832, 0; 1298004319833 to 1514338373137, 0; 1514338373138 to 1730672426442, 1
01730672426442
Valid
16,907 · 70.1%
Missing
7,200 · 29.9%
Missing over timeMissing share of non_us_client_aum_usd over time, 0% to 50%.
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).

Histogram: 0 to 294558904, 17,274; 294558905 to 589117808, 0; 589117809 to 883676713, 0; 883676714 to 1178235617, 0; 1178235618 to 1472794522, 0; 1472794523 to 1767353426, 0; 1767353427 to 2061912331, 0; 2061912332 to 2356471235, 1
02356471235
Valid
17,275 · 71.7%
Missing
6,832 · 28.3%
Missing over timeMissing share of clients_without_aum over time, 0% to 43%.
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).

Histogram: 0 to 12, 13,989; 13 to 25, 491; 26 to 37, 372; 38 to 50, 571; 51 to 63, 289; 64 to 75, 436; 76 to 88, 296; 89 to 100, 832
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.

Histogram: 0 to 1019788, 11,284; 1019789 to 2039577, 6; 2039578 to 3059365, 2; 3059366 to 4079154, 1; 4079155 to 5098943, 0; 5098944 to 6118731, 0; 6118732 to 7138520, 0; 7138521 to 8158308, 1
08158308
Valid
11,294 · 46.8%
Missing
12,813 · 53.2%
Missing over timeMissing share of clients_individuals over time, 0% to 80%.
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).

Histogram: 0 to 155673552776, 11,105; 155673552777 to 311347105553, 7; 311347105554 to 467020658329, 2; 467020658330 to 622694211106, 1; 622694211107 to 778367763883, 0; 778367763884 to 934041316659, 0; 934041316660 to 1089714869436, 0; 1089714869437 to 1245388422212, 1
01245388422212
Valid
11,116 · 46.1%
Missing
12,991 · 53.9%
Missing over timeMissing share of aum_individuals_usd over time, 0% to 84%.
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.

Histogram: 0 to 106721, 11,734; 106722 to 213443, 3; 213444 to 320165, 2; 320166 to 426887, 3; 426888 to 533609, 1; 533610 to 640331, 0; 640332 to 747053, 3; 747054 to 853775, 1
0853775
Valid
11,747 · 48.7%
Missing
12,360 · 51.3%
Missing over timeMissing share of clients_hnw_individuals over time, 0% to 78%.
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).

Histogram: 0 to 153439373574, 11,623; 153439373575 to 306878747149, 11; 306878747150 to 460318120723, 5; 460318120724 to 613757494298, 3; 613757494299 to 767196867873, 2; 767196867874 to 920636241447, 0; 920636241448 to 1074075615022, 0; 1074075615023 to 1227514988596, 1
01227514988596
Valid
11,645 · 48.3%
Missing
12,462 · 51.7%
Missing over timeMissing share of aum_hnw_individuals_usd over time, 0% to 81%.
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.

Histogram: 0 to 532, 5,372; 533 to 1064, 2; 1065 to 1596, 1; 1597 to 2128, 0; 2129 to 2661, 0; 2662 to 3193, 0; 3194 to 3725, 0; 3726 to 4257, 1
04257
Valid
5,376 · 22.3%
Missing
18,731 · 77.7%
Missing over timeMissing share of clients_banks over time, 0% to 100%.
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).

Histogram: 0 to 9322380750, 4,990; 9322380751 to 18644761501, 12; 18644761502 to 27967142252, 4; 27967142253 to 37289523003, 1; 37289523004 to 46611903754, 0; 46611903755 to 55934284505, 2; 55934284506 to 65256665256, 0; 65256665257 to 74579046006, 2
074579046006
Valid
5,011 · 20.8%
Missing
19,096 · 79.2%
Missing over timeMissing share of aum_banks_usd over time, 0% to 100%.
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.

Histogram: 0 to 244, 6,340; 245 to 488, 7; 489 to 733, 2; 734 to 977, 0; 978 to 1221, 1; 1222 to 1466, 0; 1467 to 1710, 0; 1711 to 1954, 1
01954
Valid
6,351 · 26.3%
Missing
17,756 · 73.7%
Missing over timeMissing share of clients_investment_companies over time, 0% to 100%.
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).

Histogram: 0 to 1386583138495, 5,871; 1386583138496 to 2773166276990, 4; 2773166276991 to 4159749415486, 1; 4159749415487 to 5546332553981, 2; 5546332553982 to 6932915692476, 0; 6932915692477 to 8319498830972, 0; 8319498830973 to 9706081969467, 1; 9706081969468 to 11092665107962, 1
011092665107962
Valid
5,880 · 24.4%
Missing
18,227 · 75.6%
Missing over timeMissing share of aum_investment_companies_usd over time, 0% to 100%.
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.

Histogram: 0 to 2, 5,398; 3 to 4, 14; 5 to 7, 3; 8 to 9, 0; 10 to 12, 1; 13 to 14, 0; 15 to 17, 0; 18 to 19, 1
019
Valid
5,417 · 22.5%
Missing
18,690 · 77.5%
Missing over timeMissing share of clients_bdcs over time, 0% to 100%.
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).

Histogram: 0 to 12581077997, 4,877; 12581077998 to 25162155995, 3; 25162155996 to 37743233993, 4; 37743233994 to 50324311991, 0; 50324311992 to 62905389989, 2; 62905389990 to 75486467987, 0; 75486467988 to 88067545985, 0; 88067545986 to 100648623982, 1
0100648623982
Valid
4,887 · 20.3%
Missing
19,220 · 79.7%
Missing over timeMissing share of aum_bdcs_usd over time, 0% to 100%.
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.

Histogram: 0 to 730, 10,167; 731 to 1460, 7; 1461 to 2190, 1; 2191 to 2920, 1; 2921 to 3650, 0; 3651 to 4380, 0; 4381 to 5110, 0; 5111 to 5840, 1
05840
Valid
10,177 · 42.2%
Missing
13,930 · 57.8%
Missing over timeMissing share of clients_pooled_vehicles over time, 0% to 100%.
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).

Histogram: 0 to 177574126678, 9,865; 177574126679 to 355148253357, 30; 355148253358 to 532722380036, 4; 532722380037 to 710296506715, 4; 710296506716 to 887870633394, 2; 887870633395 to 1065444760073, 0; 1065444760074 to 1243018886752, 0; 1243018886753 to 1420593013430, 1
01420593013430
Valid
9,906 · 41.1%
Missing
14,201 · 58.9%
Missing over timeMissing share of aum_pooled_vehicles_usd over time, 0% to 100%.
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.

Histogram: 0 to 13846, 7,356; 13847 to 27693, 4; 27694 to 41540, 1; 41541 to 55386, 1; 55387 to 69233, 0; 69234 to 83080, 1; 83081 to 96927, 1; 96928 to 110773, 1
0110773
Valid
7,365 · 30.6%
Missing
16,742 · 69.4%
Missing over timeMissing share of clients_pension_plans over time, 0% to 100%.
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).

Histogram: 0 to 133950051324, 7,960; 133950051325 to 267900102649, 9; 267900102650 to 401850153974, 1; 401850153975 to 535800205298, 0; 535800205299 to 669750256623, 0; 669750256624 to 803700307948, 0; 803700307949 to 937650359273, 0; 937650359274 to 1071600410597, 1
01071600410597
Valid
7,971 · 33.1%
Missing
16,136 · 66.9%
Missing over timeMissing share of aum_pension_plans_usd over time, 0% to 85%.
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.

Histogram: 0 to 4968, 7,260; 4969 to 9937, 5; 9938 to 14906, 0; 14907 to 19875, 0; 19876 to 24844, 0; 24845 to 29813, 0; 29814 to 34782, 0; 34783 to 39751, 1
039751
Valid
7,266 · 30.1%
Missing
16,841 · 69.9%
Missing over timeMissing share of clients_charities over time, 0% to 83%.
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).

Histogram: 0 to 23247836498, 8,299; 23247836499 to 46495672997, 11; 46495672998 to 69743509496, 2; 69743509497 to 92991345995, 2; 92991345996 to 116239182494, 0; 116239182495 to 139487018993, 0; 139487018994 to 162734855492, 0; 162734855493 to 185982691991, 1
0185982691991
Valid
8,315 · 34.5%
Missing
15,792 · 65.5%
Missing over timeMissing share of aum_charities_usd over time, 0% to 84%.
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.

Histogram: 0 to 368, 5,612; 369 to 737, 5; 738 to 1105, 1; 1106 to 1474, 1; 1475 to 1843, 0; 1844 to 2211, 0; 2212 to 2580, 1; 2581 to 2948, 1
02948
Valid
5,621 · 23.3%
Missing
18,486 · 76.7%
Missing over timeMissing share of clients_governments over time, 0% to 100%.
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).

Histogram: 0 to 31147039191, 5,392; 31147039192 to 62294078383, 17; 62294078384 to 93441117575, 7; 93441117576 to 124588156767, 3; 124588156768 to 155735195959, 1; 155735195960 to 186882235151, 2; 186882235152 to 218029274343, 0; 218029274344 to 249176313534, 1
0249176313534
Valid
5,423 · 22.5%
Missing
18,684 · 77.5%
Missing over timeMissing share of aum_governments_usd over time, 0% to 100%.
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.

Histogram: 0 to 95849, 5,568; 95850 to 191699, 0; 191700 to 287548, 0; 287549 to 383398, 0; 383399 to 479248, 0; 479249 to 575097, 0; 575098 to 670947, 1; 670948 to 766796, 1
0766796
Valid
5,570 · 23.1%
Missing
18,537 · 76.9%
Missing over timeMissing share of clients_other_advisers over time, 0% to 100%.
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).

Histogram: 0 to 22614352108, 5,309; 22614352109 to 45228704216, 11; 45228704217 to 67843056324, 2; 67843056325 to 90457408432, 2; 90457408433 to 113071760541, 3; 113071760542 to 135686112649, 0; 135686112650 to 158300464757, 2; 158300464758 to 180914816865, 1
0180914816865
Valid
5,330 · 22.1%
Missing
18,777 · 77.9%
Missing over timeMissing share of aum_other_advisers_usd over time, 0% to 100%.
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.

Histogram: 0 to 173, 5,569; 174 to 346, 5; 347 to 520, 3; 521 to 693, 1; 694 to 867, 0; 868 to 1040, 0; 1041 to 1214, 0; 1215 to 1387, 1
01387
Valid
5,579 · 23.1%
Missing
18,528 · 76.9%
Missing over timeMissing share of clients_insurers over time, 0% to 100%.
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).

Histogram: 0 to 57205648192, 5,314; 57205648193 to 114411296384, 16; 114411296385 to 171616944577, 9; 171616944578 to 228822592769, 2; 228822592770 to 286028240961, 0; 286028240962 to 343233889154, 4; 343233889155 to 400439537346, 1; 400439537347 to 457645185538, 3
0457645185538
Valid
5,349 · 22.2%
Missing
18,758 · 77.8%
Missing over timeMissing share of aum_insurers_usd over time, 0% to 100%.
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.

Histogram: 0 to 13, 5,310; 14 to 26, 12; 27 to 39, 4; 40 to 52, 3; 53 to 65, 0; 66 to 78, 0; 79 to 91, 1; 92 to 104, 1
0104
Valid
5,331 · 22.1%
Missing
18,776 · 77.9%
Missing over timeMissing share of clients_sovereign_funds over time, 0% to 100%.
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).

Histogram: 0 to 28507083970, 4,948; 28507083971 to 57014167940, 8; 57014167941 to 85521251910, 4; 85521251911 to 114028335880, 1; 114028335881 to 142535419851, 0; 142535419852 to 171042503821, 1; 171042503822 to 199549587791, 0; 199549587792 to 228056671761, 1
0228056671761
Valid
4,963 · 20.6%
Missing
19,144 · 79.4%
Missing over timeMissing share of aum_sovereign_funds_usd over time, 0% to 100%.
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.

Histogram: 0 to 3436, 7,623; 3437 to 6872, 8; 6873 to 10309, 5; 10310 to 13745, 4; 13746 to 17181, 3; 17182 to 20618, 0; 20619 to 24054, 1; 24055 to 27490, 1
027490
Valid
7,645 · 31.7%
Missing
16,462 · 68.3%
Missing over timeMissing share of clients_corporations over time, 0% to 100%.
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).

Histogram: 0 to 28351890487, 8,421; 28351890488 to 56703780975, 12; 56703780976 to 85055671462, 3; 85055671463 to 113407561950, 3; 113407561951 to 141759452438, 1; 141759452439 to 170111342925, 0; 170111342926 to 198463233413, 1; 198463233414 to 226815123900, 1
0226815123900
Valid
8,442 · 35%
Missing
15,665 · 65%
Missing over timeMissing share of aum_corporations_usd over time, 0% to 100%.
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.

Histogram: 0 to 15782, 5,224; 15783 to 31564, 3; 31565 to 47346, 1; 47347 to 63128, 1; 63129 to 78910, 0; 78911 to 94692, 1; 94693 to 110474, 1; 110475 to 126256, 1
0126256
Valid
5,232 · 21.7%
Missing
18,875 · 78.3%
Missing over timeMissing share of clients_other_clients over time, 0% to 100%.
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).

Histogram: 0 to 17540363592, 5,138; 17540363593 to 35080727184, 12; 35080727185 to 52621090777, 4; 52621090778 to 70161454369, 0; 70161454370 to 87701817962, 2; 87701817963 to 105242181554, 0; 105242181555 to 122782545147, 0; 122782545148 to 140322908739, 1
0140322908739
Valid
5,157 · 21.4%
Missing
18,950 · 78.6%
Missing over timeMissing share of aum_other_clients_usd over time, 0% to 100%.
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.

Histogram: 1 to 1019792, 16,619; 1019793 to 2039583, 11; 2039584 to 3059374, 3; 3059375 to 4079165, 1; 4079166 to 5098956, 0; 5098957 to 6118747, 0; 6118748 to 7138538, 0; 7138539 to 8158329, 1
18158329
Valid
16,635 · 69%
Missing
7,472 · 31%
Missing over timeMissing share of total_clients over time, 0% to 53%.
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.

Histogram: 0 to 12.5, 6,590; 12.5 to 25, 275; 25 to 37.5, 239; 37.5 to 50, 243; 50 to 62.5, 303; 62.5 to 75, 523; 75 to 87.5, 988; 87.5 to 100, 7,439
0.0100.0
Valid
16,600 · 68.9%
Missing
7,507 · 31.1%
Missing over timeMissing share of pct_aum_individuals over time, 0% to 54%.
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.

Histogram: 0 to 12.5, 11,155; 12.5 to 25, 329; 25 to 37.5, 238; 37.5 to 50, 205; 50 to 62.5, 204; 62.5 to 75, 206; 75 to 87.5, 284; 87.5 to 100, 3,979
0.0100.0
Valid
16,600 · 68.9%
Missing
7,507 · 31.1%
Missing over timeMissing share of pct_aum_pooled_vehicles over time, 0% to 54%.
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.

Histogram: 0 to 12.5, 15,425; 12.5 to 25, 161; 25 to 37.5, 107; 37.5 to 50, 95; 50 to 62.5, 88; 62.5 to 75, 78; 75 to 87.5, 80; 87.5 to 100, 566
0.0100.0
Valid
16,600 · 68.9%
Missing
7,507 · 31.1%
Missing over timeMissing share of pct_aum_investment_companies over time, 0% to 54%.
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.

Histogram: 0 to 12.5, 13,243; 12.5 to 25, 1,181; 25 to 37.5, 589; 37.5 to 50, 361; 50 to 62.5, 237; 62.5 to 75, 212; 75 to 87.5, 236; 87.5 to 100, 541
0.0100.0
Valid
16,600 · 68.9%
Missing
7,507 · 31.1%
Missing over timeMissing share of pct_aum_institutions over time, 0% to 54%.
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.

Histogram: 0 to 12.5, 6,117; 12.5 to 25, 104; 25 to 37.5, 79; 37.5 to 50, 101; 50 to 62.5, 177; 62.5 to 75, 288; 75 to 87.5, 671; 87.5 to 100, 9,098
0.0100.0
Valid
16,635 · 69%
Missing
7,472 · 31%
Missing over timeMissing share of pct_clients_individuals over time, 0% to 53%.
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.

Histogram: 0 to 12.5, 7,959; 12.5 to 25, 1,845; 25 to 37.5, 1,828; 37.5 to 50, 1,605; 50 to 62.5, 1,225; 62.5 to 75, 881; 75 to 87.5, 566; 87.5 to 100, 726
0.0100.0
Valid
16,635 · 69%
Missing
7,472 · 31%
Missing over timeMissing share of pct_clients_hnw over time, 0% to 53%.
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 timeMissing share of financial_planning_clients over time, 0% to 100%.
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 timeMissing share of other_services_text over time, 0% to 100%.
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 timeMissing share of sponsors_wrap_fee_program over time, 0% to 43%.
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 timeMissing share of advises_investment_company over time, 0% to 43%.
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 timeMissing share of era_venture_capital_only over time, 57% to 100%.
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 timeMissing share of era_private_funds_under_150m over time, 57% to 100%.
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 timeMissing share of is_broker_dealer over time, 0% to 100%.
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 timeMissing share of is_commodity_pool_operator over time, 0% to 100%.
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 timeMissing share of is_insurance_broker over time, 0% to 100%.
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 timeMissing share of affiliated_with_broker_dealer over time, 0% to 100%.
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 timeMissing share of affiliated_fund_sponsor over time, 0% to 100%.
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).

Histogram: 0 to 251278919149, 9,166; 251278919150 to 502557838298, 9; 502557838299 to 753836757447, 3; 753836757448 to 1005115676596, 2; 1005115676597 to 1256394595745, 1; 1256394595746 to 1507673514894, 0; 1507673514895 to 1758952434043, 0; 1758952434044 to 2010231353192, 2
02010231353192
Valid
9,183 · 38.1%
Missing
14,924 · 61.9%
Missing over timeMissing share of custody_amount_usd over time, 0% to 100%.
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).

Histogram: 0 to 50560752, 9,187; 50560753 to 101121504, 1; 101121505 to 151682256, 0; 151682257 to 202243008, 0; 202243009 to 252803760, 0; 252803761 to 303364512, 0; 303364513 to 353925264, 0; 353925265 to 404486016, 1
0404486016
Valid
9,189 · 38.1%
Missing
14,918 · 61.9%
Missing over timeMissing share of custody_clients over time, 0% to 100%.
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).

Histogram: 0 to 171264645647, 5,744; 171264645648 to 342529291294, 25; 342529291295 to 513793936942, 5; 513793936943 to 685058582589, 4; 685058582590 to 856323228236, 0; 856323228237 to 1027587873884, 1; 1027587873885 to 1198852519531, 1; 1198852519532 to 1370117165178, 1
01370117165178
Valid
5,781 · 24%
Missing
18,326 · 76%
Missing over timeMissing share of related_person_custody_amount_usd over time, 0% to 100%.
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).

Histogram: 0 to 19, 11,799; 20 to 39, 169; 40 to 59, 42; 60 to 79, 13; 80 to 99, 6; 100 to 119, 4; 120 to 139, 0; 140 to 158, 3
0158
Valid
12,036 · 49.9%
Missing
12,071 · 50.1%
Missing over timeMissing share of qualified_custodians over time, 0% to 100%.
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 timeMissing share of adviser_type_rule over time, 0% to 71%.
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

PassedFreshnessLatest event 2 d before this version
WarningGaps14 empty years, 1942 to 1946, 1948 to 1950, 1952 to 1954 and 2 more
WarningAnomaliesSpike on 1940, 5 rows against about 0, and 6 more
PassedUnique keysEvery crd_number is unique
Rows per year
Rows per year, 87 buckets from 1 Jan 1940 to 1 Jan 2026, at most 2,573 rows, 14 empty, 7 marked as anomalies.3k1 Jan 1940: 5 rows, spike, about 0 expected1 Jan 1941: 1 row1 Jan 1942: 0 rows1 Jan 1943: 0 rows1 Jan 1944: 0 rows1 Jan 1945: 0 rows1 Jan 1946: 0 rows1 Jan 1947: 2 rows, spike, about 0 expected1 Jan 1948: 0 rows1 Jan 1949: 0 rows1 Jan 1950: 0 rows1 Jan 1951: 1 row1 Jan 1952: 0 rows1 Jan 1953: 0 rows1 Jan 1954: 0 rows, gap, about 1 expected1 Jan 1955: 2 rows1 Jan 1956: 0 rows, gap, about 1 expected1 Jan 1957: 0 rows, gap, about 2 expected1 Jan 1958: 2 rows1 Jan 1959: 2 rows1 Jan 1960: 2 rows1 Jan 1961: 2 rows1 Jan 1962: 0 rows, gap, about 2 expected1 Jan 1963: 2 rows1 Jan 1964: 2 rows1 Jan 1965: 1 row1 Jan 1966: 3 rows1 Jan 1967: 1 row1 Jan 1968: 5 rows1 Jan 1969: 8 rows1 Jan 1970: 8 rows1 Jan 1971: 24 rows1 Jan 1972: 13 rows1 Jan 1973: 9 rows1 Jan 1974: 11 rows1 Jan 1975: 22 rows1 Jan 1976: 23 rows1 Jan 1977: 21 rows1 Jan 1978: 23 rows1 Jan 1979: 19 rows1 Jan 1980: 29 rows1 Jan 1981: 24 rows1 Jan 1982: 40 rows1 Jan 1983: 72 rows1 Jan 1984: 59 rows1 Jan 1985: 51 rows1 Jan 1986: 62 rows1 Jan 1987: 70 rows1 Jan 1988: 72 rows1 Jan 1989: 57 rows1 Jan 1990: 72 rows1 Jan 1991: 87 rows1 Jan 1992: 77 rows1 Jan 1993: 71 rows1 Jan 1994: 88 rows1 Jan 1995: 97 rows1 Jan 1996: 81 rows1 Jan 1997: 75 rows1 Jan 1998: 104 rows1 Jan 1999: 144 rows1 Jan 2000: 166 rows1 Jan 2001: 170 rows1 Jan 2002: 153 rows1 Jan 2003: 176 rows1 Jan 2004: 221 rows1 Jan 2005: 210 rows1 Jan 2006: 317 rows1 Jan 2007: 231 rows1 Jan 2008: 221 rows1 Jan 2009: 229 rows1 Jan 2010: 255 rows1 Jan 2011: 279 rows1 Jan 2012: 1,579 rows, spike, about 400 expected1 Jan 2013: 483 rows1 Jan 2014: 658 rows1 Jan 2015: 683 rows1 Jan 2016: 691 rows1 Jan 2017: 911 rows1 Jan 2018: 1,144 rows1 Jan 2019: 1,012 rows1 Jan 2020: 1,218 rows1 Jan 2021: 1,714 rows1 Jan 2022: 1,648 rows1 Jan 2023: 1,355 rows1 Jan 2024: 1,866 rows1 Jan 2025: 2,298 rows1 Jan 2026: 2,573 rows194019501960197019801990200020102020

Support

Talk to Mostly Right

Loading chat…