Firms Field Details

Detailed value distributions and statistics for each field in the firms endpoint.

`as_of_date`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	100.0%	24,616 of 24,616	22

Top Values

Value	Count	% of Total
2025-03-01	9,789	39.8%
2025-10-01	2,139	8.7%
2025-09-01	1,750	7.1%
2025-04-01	1,454	5.9%
2025-06-01	1,438	5.8%

`asset_classes`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
COMMODITIES	1,073	4.4%
CREDIT	7,974	32.4%
CRYPTO_ASSETS	450	1.8%
CURRENCIES	1,816	7.4%
DERIVATIVES	5,582	22.7%
FIXED_INCOME	8,276	33.6%
INFRASTRUCTURE	1,798	7.3%
MULTI_ASSET	1,735	7%
PRIVATE_EQUITY	4,651	18.9%
PUBLIC_EQUITIES	9,192	37.3%

`aum_total_usd`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	69.0%	16,992 of 24,616	-

Distribution

$0

1.9%

$10,000,000

0.0%

$100,000,000

0.0%

$160,000,000

0.0%

$400,000,000

0.0%

Top Values

Value	Count	% of Total
$0	477	1.9%
$10,000,000	6	-
$100,000,000	6	-
$160,000,000	6	-
$400,000,000	6	-

`aum_yoy_pct`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	44.8%	11,031 of 24,616	-

Distribution

0.%

0.4%

11.1%

0.2%

11.5%

0.2%

15.7%

0.2%

11.%

0.2%

Top Values

Value	Count	% of Total
0.%	91	0.4%
11.1%	50	0.2%
11.5%	45	0.2%
15.7%	45	0.2%
11.%	44	0.2%

`client_types`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
ENDOWMENTS	470	1.9%
FAMILY_OFFICES	5,832	23.7%
FOUNDATIONS	470	1.9%
HIGH_NET_WORTH	11,804	48%
INDIVIDUALS	7,316	29.7%
INSTITUTIONS	11,234	45.6%
PENSION_PLANS	480	1.9%
PRIVATE_FUNDS	484	2%
SOVEREIGN_WEALTH_FUNDS	436	1.8%

`employee_count`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	71.0%	17,471 of 24,616	-

Top Values

Value	Count	% of Total
3	1,556	6.3%
2	1,523	6.2%
4	1,438	5.8%
5	1,280	5.2%
1	1,155	4.7%

`esg_focus`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
FALSE	11,502	46.7%
TRUE	871	3.5%

`geographic_focus`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
AFRICA	236	1%
ASIA	408	1.7%
AUSTRALIA	260	1.1%
CANADA	454	1.8%
CHINA	330	1.3%
EASTERN_EUROPE	378	1.5%
EMERGING_MARKETS	1,100	4.5%
GLOBAL	7,142	29%
INDIA	1,275	5.2%
JAPAN	281	1.1%

`industry_focus`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
CLIMATE_TECH	709	2.9%
CONSUMER	1,935	7.9%
DIVERSIFIED	7,711	31.3%
ENERGY	2,476	10.1%
FINANCIAL_SERVICES	3,042	12.4%
HEALTHCARE	2,870	11.7%
INDUSTRIALS	1,653	6.7%
INFRASTRUCTURE	763	3.1%
MEDIA	1,009	4.1%
REAL_ESTATE	1,214	4.9%

`investment_approaches`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
ACTIVIST	2,430	9.9%
ARBITRAGE	4,299	17.5%
BUYOUT	2,504	10.2%
CREDIT_FOCUSED	2,304	9.4%
DISCRETIONARY	1,878	7.6%
DISTRESSED	3,671	14.9%
EVENT_DRIVEN	1,444	5.9%
FUNDAMENTAL	9,437	38.3%
GROWTH_EQUITY	3,344	13.6%
LONG_SHORT_EQUITY	3,297	13.4%

`investment_stage`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
BUYOUT	1,273	5.2%
DISTRESSED	36	0.1%
EARLY_STAGE	646	2.6%
GROWTH	6,143	25%
LATE_STAGE	4,390	17.8%
NOT_APPLICABLE	6,013	24.4%
OPPORTUNISTIC	17	0.1%
SECONDARY	15	0.1%
SEED	62	0.3%

`legal_name`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	100.0%	24,616 of 24,616	24,566

Top Values

Value	Count	% of Total
e.g. a16z Capital Management, L.L.C.	-	-

`private_fund_count`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.1%	12,323 of 24,616	-

Top Values

Value	Count	% of Total
1	4,107	16.7%
2	1,981	8%
3	1,146	4.7%
4	873	3.5%
5	615	2.5%

`private_fund_count_hedge`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.1%	12,323 of 24,616	-

Top Values

Value	Count	% of Total
0	8,232	33.4%
1	2,167	8.8%
2	800	3.2%
3	405	1.6%
4	178	0.7%

`private_fund_count_other`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	7.1%	1,741 of 24,616	-

Top Values

Value	Count	% of Total
1	754	3.1%
2	292	1.2%
3	171	0.7%
4	113	0.5%
5	83	0.3%

`private_fund_count_private_equity`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.1%	12,323 of 24,616	-

Top Values

Value	Count	% of Total
0	7,988	32.5%
1	1,211	4.9%
2	673	2.7%
3	386	1.6%
4	325	1.3%

`private_fund_count_real_estate`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	4.1%	998 of 24,616	-

Top Values

Value	Count	% of Total
1	304	1.2%
2	162	0.7%
3	96	0.4%
4	68	0.3%
5	63	0.3%

`private_fund_count_securitized`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	1.0%	250 of 24,616	-

Top Values

Value	Count	% of Total
1	60	0.2%
2	22	0.1%
4	17	0.1%
3	16	0.1%
6	14	0.1%

`private_fund_count_venture`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.1%	12,323 of 24,616	-

Top Values

Value	Count	% of Total
0	8,973	36.5%
1	1,004	4.1%
2	531	2.2%
3	314	1.3%
4	257	1%

`private_fund_gav_total_usd`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.1%	12,323 of 24,616	-

Distribution

$0

1.2%

$25,000,000

0.2%

$78,960,522

0.1%

$10,000,000

0.1%

$1,000,000

0.1%

Top Values

Value	Count	% of Total
$0	299	1.2%
$25,000,000	37	0.2%
$78,960,522	33	0.1%
$10,000,000	23	0.1%
$1,000,000	20	0.1%

`private_fund_gav_yoy_pct`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	32.6%	8,022 of 24,616	-

Distribution

0.%

2.5%

###.#%

0.2%

-.1%

0.1%

-3.1%

0.1%

.2%

0.1%

Top Values

Value	Count	% of Total
0.%	613	2.5%
###.#%	46	0.2%
-.1%	30	0.1%
-3.1%	27	0.1%
.2%	27	0.1%

`region`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	90.0%	22,163 of 24,616	12

Top Values

Value	Count	% of Total
Northeast	6,134	24.9%
West	4,483	18.2%
Southeast	3,635	14.8%
Midwest	2,854	11.6%
Southwest	1,767	7.2%

`sec_number`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	100.0%	24,605 of 24,616	24,605

Top Values

Value	Count	% of Total
e.g. 801-123456	-	-

`strategy_class_primary`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
CREDIT	76	0.3%
FUND_OF_FUNDS	58	0.2%
HEDGE_FUND	512	2.1%
INFRASTRUCTURE	29	0.1%
MULTI_STRATEGY	7,745	31.5%
OTHER	507	2.1%
PRIVATE_EQUITY	1,546	6.3%
REAL_ESTATE	405	1.6%
VENTURE_CAPITAL	91	0.4%
WEALTH_MANAGEMENT	1,535	6.2%

`strategy_class_secondary`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
CREDIT	183	0.7%
FUND_OF_FUNDS	21	0.1%
HEDGE_FUND	133	0.5%
INFRASTRUCTURE	23	0.1%
MULTI_STRATEGY	53	0.2%
OTHER	2,279	9.3%
PRIVATE_EQUITY	86	0.3%
REAL_ESTATE	107	0.4%
VENTURE_CAPITAL	95	0.4%
WEALTH_MANAGEMENT	6	-

`strategy_overview`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	12,357

Top Values

Value	Count	% of Total
Example: Opportunistic global credit & co-investments across PE/VC vehicles.	-	-

`uses_derivatives`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
FALSE	5,336	21.7%
TRUE	7,037	28.6%

`uses_leverage`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
FALSE	8,278	33.6%
TRUE	4,095	16.6%

`uses_short_selling`

Description	Data Type	Usage Notes	Fill Rate	Records	Distinct Values
Column %s from api.principals.	`text`	Example: ?%s=eq.<value>	50.3%	12,373 of 24,616	-

Top Values

Value	Count	% of Total
FALSE	8,561	34.8%
TRUE	3,812	15.5%