cfpb_complaint_aggregations
Aggregate consumer complaint counts by product, company, state, or issue. Rank complaint volumes, identify top issues, or compare states using filters like date range and company.
Instructions
Get complaint counts grouped by a field (product, company, state, issue, etc.). Useful for ranking companies by complaint volume, identifying top issues, or comparing states. Aggregation fields: 'product', 'company', 'state', 'issue', 'company_response', 'timely', 'submitted_via', 'tags'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| field | Yes | Field to group by | |
| product | No | Filter by product: 'Mortgage', 'Debt collection', etc. | |
| company | No | Filter by company: 'Wells Fargo', 'Bank of America', etc. | |
| state | No | Filter by state: 'CA', 'TX', 'NY' | |
| issue | No | Filter by issue type | |
| date_received_min | No | Start date (YYYY-MM-DD) | |
| date_received_max | No | End date (YYYY-MM-DD) |