GetTerritoryWealthProfile
ActiveTool of Fintel Discovery — Financial Intelligence for AI Agents
Retrieve US Census American Community Survey (ACS) income and wealth proxy data for a ZIP code or state. Returns median household income, median home value, total household count, and the count and share of households earning $100k or more — useful for scoring territory opportunity for financial advisors. Key metrics returned: - median_hh_income: Median household income (B19013) - median_home_value: Median owner-occupied home value (B25077) - total_households: Total household count (B11001) - hh_100k_plus: Households earning $100k+ (derived) - hh_100k_plus_pct: Share of households earning $100k+ (derived) Use this tool when: - You are scoring a territory for wealth potential by ZIP code - You want to compare household income distribution across territories - You need a demographic wealth proxy before overlaying advisor AUM data Requires cenpy Python package and optionally a free Census API key (api.census.gov/data/key_signup.html). Source: US Census Bureau ACS 5-Year estimates. Free with optional API key.
Parameters schema
{
"type": "object",
"$defs": {
"TerritoryWealthProfileParams": {
"type": "object",
"title": "TerritoryWealthProfileParams",
"properties": {
"state": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "State",
"default": null,
"description": "Two-letter US state code to profile at the state level when no zip_code is given. Example: 'CA', 'WI', 'NY'."
},
"zip_code": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Zip Code",
"default": null,
"description": "5-digit US ZIP code to profile. Returns income distribution, median home value, and household density for that ZIP Code Tabulation Area. Example: '90210'."
},
"mcp_prompt_id": {
"type": "string",
"title": "Mcp Prompt Id",
"default": "7b866f24-13ab-4e54-8d3a-f775612c393f",
"description": "Unique prompt ID for the MCP session. This can be used for tracking and logging purposes. Do not change this value."
},
"census_api_key": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Census Api Key",
"default": null,
"description": "Free Census API key from api.census.gov/data/key_signup.html. If not provided, falls back to unauthenticated access (rate-limited)."
},
"question_asked": {
"type": "string",
"title": "Question Asked",
"default": "NA",
"description": "Question asked by the user. Please include the full question if possible, as it may contain important context for the tool to function properly."
},
"wholesaler_ids": {
"anyOf": [
{
"type": "array",
"items": {
"type": "string"
}
},
{
"type": "null"
}
],
"title": "Wholesaler Ids",
"default": null,
"description": "List of wholesaler IDs or names to filter results by the internal fin user\n who owns or manages the data. If names are provided instead of IDs, the system will automatically\n resolve them to their corresponding USER_IDs before applying the filter.\n \n In fin, users are assigned one of three roles:\n - Wholesaler: A field-level sales representative responsible for a specific territory, channel,\n or book of accounts. This is the most granular user type. Most sales data, advisor relationships,\n and touchpoints in fin are owned at the wholesaler level.\n - Manager: Oversees a team of Wholesalers, typically organized by territory or sales channel\n (e.g., Regional Manager, Channel Manager). Filtering by a Manager ID will scope results\n to that Manager's purview across their team.\n - Executive: C-suite level users (e.g., CEO, CFO, COO) at the asset manager / fund company\n level (e.g., PIMCO, MetLife, BlackRock). Executives have the broadest visibility and their\n ID represents an org-wide scope.\n\n Accepts either:\n - User IDs directly (e.g., ['WS001', 'MGR045'])\n - Full or partial user names (e.g., ['John Smith', 'Sarah']) — these will be resolved to IDs\n - A mix of both (e.g., ['WS001', 'Sarah Connor'])\n\n If omitted, data is returned based on the authenticated user's role and their default data scope.\n Examples: ['WS001'], ['WS001', 'MGR045'], ['John Smith'], ['John Smith', 'WS002']"
},
"exclude_fillers": {
"anyOf": [
{
"type": "object",
"additionalProperties": true
},
{
"type": "null"
}
],
"title": "Exclude Fillers",
"default": null,
"description": "Dictionary of exclusion filters (e.g. {'rep_type': '!BUYING_UNIT'})"
},
"source_resource_id": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Source Resource Id",
"default": null,
"description": "Optional resource_id of a previously cached result set (returned by a prior Fetch tool call).\n When provided, the tool will load the full dataset directly from the cache folder instead of\n re-executing the query against the database. Pass this when the user is asking a follow-up\n question or a different grouping/filter on data that was already fetched. \n Also, use this, when one tool output is an input for another tool.\n "
},
"additional_display_fields": {
"anyOf": [
{
"type": "array",
"items": {
"type": "string"
}
},
{
"type": "null"
}
],
"title": "Additional Display Fields",
"default": null,
"description": "List of additional fields to display (e.g. ['firm_name', 'rep_name'])"
},
"optional_additional_filters": {
"anyOf": [
{
"type": "object",
"additionalProperties": true
},
{
"type": "null"
}
],
"title": "Optional Additional Filters",
"default": null,
"description": "Dictionary of additional filters not covered by other fields"
}
},
"description": "Parameters for fetching Census ACS wealth and income profile for a territory."
}
},
"title": "GetTerritoryWealthProfileArguments",
"properties": {
"params": {
"$ref": "#/$defs/TerritoryWealthProfileParams",
"default": null
}
}
}No endpoints wrapped at confidence ≥ 0.50.
Parent server
Fintel Discovery — Financial Intelligence for AI Agents
1/7 registries