One row per facility with its compliance summary.
Publisher: Environmental Protection Agency
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| registry_id | string | 110071310412 |
| fac_name | string | 608577-117538 LUDLOW: EASTHAMPTON, MA - UNION STREET (ROUTE |
| fac_street | string | 46 UNION ST |
| fac_city | string | EASTHAMPTON |
| fac_state | string | MA |
| fac_zip | string | 01027 |
| fac_county | string | HAMPSHIRE COUNTY |
| fac_fips_code | string | 25015 |
| fac_epa_region | string | 01 |
| fac_indian_cntry_flg | string | N |
| fac_federal_flg | string | Y |
| fac_us_mex_border_flg | string | N |
| fac_chesapeake_bay_flg | string | Y |
| fac_naa_flag | string | Y |
| fac_lat | string | 42.2686 |
| fac_long | string | -72.6713 |
| fac_map_icon | string | CWA-IC-MN-N.png |
| fac_collection_method | string | UNKNOWN |
| fac_reference_point | string | CENTER OF A FACILITY OR STATION |
| fac_accuracy_meters | string | 17430 |
| fac_derived_tribes | string | Seminole Tribe of Florida - 25 mile(s) |
| fac_derived_huc | string | 01080201 |
| fac_derived_wbd | string | 010802010609 |
| fac_derived_stcty_fips | string | 25015 |
| fac_derived_zip | string | 01027 |
| fac_derived_cd113 | string | 01 |
| fac_derived_cb2010 | string | 250158224022005 |
| fac_percent_minority | string | 9.095 |
| fac_pop_den | string | |
| fac_major_flag | string | Y |
| fac_active_flag | string | Y |
| fac_myrtk_universe | string | NNN |
| fac_inspection_count | string | 0 |
| fac_date_last_inspection | string | 01/03/2008 |
| fac_days_last_inspection | string | 6884 |
| fac_informal_count | string | 0 |
| fac_date_last_informal_action | string | 07/20/2004 |
| fac_formal_action_count | string | 0 |
| fac_date_last_formal_action | string | 10/27/2014 |
| fac_total_penalties | string | 0 |
| fac_penalty_count | string | 1 |
| fac_date_last_penalty | string | 06/03/2021 |
| fac_last_penalty_amt | string | 0 |
| fac_qtrs_with_nc | string | 0 |
| fac_programs_with_snc | string | 0 |
| fac_compliance_status | string | No Violation Identified |
| fac_snc_flg | string | N |
| fac_3yr_compliance_history | string | ____________ |
| air_flag | string | N |
| npdes_flag | string | Y |
| sdwis_flag | string | N |
| rcra_flag | string | N |
| tri_flag | string | N |
| ghg_flag | string | N |
| air_ids | string | MD0000002403300798 |
| caa_permit_types | string | Minor Emissions |
| caa_naics | string | 517110 |
| caa_sics | string | 4813 |
| caa_evaluation_count | string | 1 |
| caa_days_last_evaluation | string | 6344 |
| caa_informal_count | string | 2 |
| caa_formal_action_count | string | 1 |
| caa_date_last_formal_action | string | 06/20/2006 |
| caa_penalties | string | 7000 |
| caa_last_penalty_date | string | 06/20/2006 |
| caa_last_penalty_amt | string | 39375 |
| caa_qtrs_with_nc | string | 0 |
| caa_compliance_status | string | No Violation Identified |
| caa_hpv_flag | string | N |
| caa_3yr_compl_qtrs_history | string | ____________ |
| npdes_ids | string | MAR10044S |
| cwa_permit_types | string | Non-M |
| cwa_compliance_tracking | string | On |
| cwa_naics | string | 236115 |
| cwa_sics | string | 1521 |
| cwa_inspection_count | string | 1 |
| cwa_days_last_inspection | string | 4495 |
| cwa_informal_count | string | 1 |
| cwa_formal_action_count | string | 1 |
| cwa_date_last_formal_action | string | 06/03/2021 |
53 more fields; select the table above to list them all.
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.