Public water systems, violations, enforcement and site visits under the Safe Drinking Water Act.
Publisher: Environmental Protection Agency
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| submissionyearquarter | string | 2026Q3 |
| pwsid | string | MT0004261 |
| violation_id | string | 4739 |
| facility_id | string | 20320 |
| compl_per_begin_date | string | 01/01/2014 |
| compl_per_end_date | string | 12/31/2016 |
| non_compl_per_begin_date | string | 01/01/2014 |
| non_compl_per_end_date | string | 12/31/2016 |
| pws_deactivation_date | string | 06/02/2021 |
| violation_code | string | 03 |
| violation_category_code | string | MR |
| is_health_based_ind | string | N |
| contaminant_code | string | 2037 |
| viol_measure | string | 7.39 |
| unit_of_measure | string | PCI/L |
| federal_mcl | string | 0.004 mg/L |
| state_mcl | string | 5 |
| is_major_viol_ind | string | Y |
| severity_ind_cnt | string | 2 |
| calculated_rtc_date | string | 12/31/2016 |
| violation_status | string | Resolved |
| public_notification_tier | string | 3 |
| calculated_pub_notif_tier | string | 3 |
| viol_originator_code | string | S |
| sample_result_id | string | NM2595108 |
| corrective_action_id | string | |
| rule_code | string | 320 |
| rule_group_code | string | 300 |
| rule_family_code | string | 320 |
| viol_first_reported_date | string | 03/30/2017 |
| viol_last_reported_date | string | 02/15/2024 |
| enforcement_id | string | 4056 |
| enforcement_date | string | 06/19/2018 |
| enforcement_action_type_code | string | SO8 |
| enf_action_category | string | Informal |
| enf_originator_code | string | S |
| enf_first_reported_date | string | 08/03/2018 |
| enf_last_reported_date | string | 09/24/2026 |
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.