NYSgptData LibraryConnectPricing

Drinking water

Public water systems, violations, enforcement and site visits under the Safe Drinking Water Act.

22.8MRecords
11Tables
187Fields
CurrentYears

Publisher: Environmental Protection Agency

Try it

Runs against the full table. Enter your key; plans are below.

Tables
Fields in echo_sdwa_violations_enforcement
FieldTypeExample
submissionyearquarterstring2026Q3
pwsidstringMT0004261
violation_idstring4739
facility_idstring20320
compl_per_begin_datestring01/01/2014
compl_per_end_datestring12/31/2016
non_compl_per_begin_datestring01/01/2014
non_compl_per_end_datestring12/31/2016
pws_deactivation_datestring06/02/2021
violation_codestring03
violation_category_codestringMR
is_health_based_indstringN
contaminant_codestring2037
viol_measurestring7.39
unit_of_measurestringPCI/L
federal_mclstring0.004 mg/L
state_mclstring5
is_major_viol_indstringY
severity_ind_cntstring2
calculated_rtc_datestring12/31/2016
violation_statusstringResolved
public_notification_tierstring3
calculated_pub_notif_tierstring3
viol_originator_codestringS
sample_result_idstringNM2595108
corrective_action_idstring
rule_codestring320
rule_group_codestring300
rule_family_codestring320
viol_first_reported_datestring03/30/2017
viol_last_reported_datestring02/15/2024
enforcement_idstring4056
enforcement_datestring06/19/2018
enforcement_action_type_codestringSO8
enf_action_categorystringInformal
enf_originator_codestringS
enf_first_reported_datestring08/03/2018
enf_last_reported_datestring09/24/2026
Connect

Claude

Settings, Connectors, Add custom connector. Paste this address with your key:

https://data.nysgpt.com/mcp?key=YOUR_KEY

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp --header "X-Api-Key: YOUR_KEY"

HTTP

curl -s https://data.nysgpt.com/query -H "X-Api-Key: YOUR_KEY" -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). Every call needs a key; plans are below.

Pricing

Samples

$0

20,000-row samples of ten datasets, as Parquet files on Hugging Face.

Open samples

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Environment