Texas rate filings and complaints, Connecticut complaints, New York automobile complaint rankings.
Publisher: State insurance departments
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| complaint_number | string | 1 |
| complaint_filed_against | string | METROPOLITAN LIFE INSURANCE COMPANY |
| complaint_filed_by | string | Relative |
| reason_complaint_filed | string | Cust Service Claim Handling |
| confirmed_complaint | string | No |
| how_resolved | string | Other |
| received_date | string | 06/12/2012 |
| closed_date | string | 07/25/2012 |
| complaint_type | string | Life, Accident and Health |
| coverage_type | string | Life & Annuity |
| coverage_level | string | Individual Life |
| others_involved | string | Insured |
| respondent_id | string | 13191 |
| respondent_role | string | Ins Co - Licensed/Active |
| respondent_type | string | Organization |
| complainant_type | string | INDV |
| keywords | string | 2012 NORTH TEXAS TORNADOES; ADJUSTER'S HANDLING; DAMAGE DISP |
Settings, Connectors, Add custom connector. Paste this address:
https://data.nysgpt.com/mcp
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp
curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
-d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.
$1,500/month
20,000 queries and 1 TB scanned a day, for a lab, department or team.
SubscribePayment is by card through Stripe. The key appears on screen as soon as payment completes.