Consumer complaints, do-not-call complaints and product recalls.
Publisher: FCC; FTC; CPSC
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| ticket_id | string | 2760951 |
| ticket_created | string | 09/10/2018 04:53:02 PM |
| date_created | string | 09/10/2018 |
| date_of_issue | string | 09/03/2018 |
| time_of_issue | string | 12:00 am |
| form | string | Phone |
| method | string | Wireless (cell phone/other mobile device) |
| issue | string | Unwanted Calls |
| caller_id_number | string | 141-020-0513 |
| type_of_call_or_messge | string | Text Message |
| advertiser_business_number | string | 141-020-0513 |
| city | string | San Mateo |
| state | string | CA |
| zip | string | 94403 |
| location_center_point_of_the_zip_code | string | CA 94403 (37.538901, -122.302625) |
| type_of_property_goods_or_services | string |
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.