cfpb_complaint_aggregations
Analyze consumer complaint data by grouping counts across categories like product, company, state, or issue to identify trends and patterns.
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
TableJSON 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) |