NYSgptData LibraryConnectPricing

Facility summaries

One row per facility with its compliance summary.

3.3MRecords
2Tables
143Fields
CurrentYears

Publisher: Environmental Protection Agency

Try it

This runs against the full table, free, with no key.

Tables
Fields in echo_echo_exporter
FieldTypeExample
registry_idstring110071310412
fac_namestring608577-117538 LUDLOW: EASTHAMPTON, MA - UNION STREET (ROUTE
fac_streetstring46 UNION ST
fac_citystringEASTHAMPTON
fac_statestringMA
fac_zipstring01027
fac_countystringHAMPSHIRE COUNTY
fac_fips_codestring25015
fac_epa_regionstring01
fac_indian_cntry_flgstringN
fac_federal_flgstringY
fac_us_mex_border_flgstringN
fac_chesapeake_bay_flgstringY
fac_naa_flagstringY
fac_latstring42.2686
fac_longstring-72.6713
fac_map_iconstringCWA-IC-MN-N.png
fac_collection_methodstringUNKNOWN
fac_reference_pointstringCENTER OF A FACILITY OR STATION
fac_accuracy_metersstring17430
fac_derived_tribesstringSeminole Tribe of Florida - 25 mile(s)
fac_derived_hucstring01080201
fac_derived_wbdstring010802010609
fac_derived_stcty_fipsstring25015
fac_derived_zipstring01027
fac_derived_cd113string01
fac_derived_cb2010string250158224022005
fac_percent_minoritystring9.095
fac_pop_denstring
fac_major_flagstringY
fac_active_flagstringY
fac_myrtk_universestringNNN
fac_inspection_countstring0
fac_date_last_inspectionstring01/03/2008
fac_days_last_inspectionstring6884
fac_informal_countstring0
fac_date_last_informal_actionstring07/20/2004
fac_formal_action_countstring0
fac_date_last_formal_actionstring10/27/2014
fac_total_penaltiesstring0
fac_penalty_countstring1
fac_date_last_penaltystring06/03/2021
fac_last_penalty_amtstring0
fac_qtrs_with_ncstring0
fac_programs_with_sncstring0
fac_compliance_statusstringNo Violation Identified
fac_snc_flgstringN
fac_3yr_compliance_historystring____________
air_flagstringN
npdes_flagstringY
sdwis_flagstringN
rcra_flagstringN
tri_flagstringN
ghg_flagstringN
air_idsstringMD0000002403300798
caa_permit_typesstringMinor Emissions
caa_naicsstring517110
caa_sicsstring4813
caa_evaluation_countstring1
caa_days_last_evaluationstring6344
caa_informal_countstring2
caa_formal_action_countstring1
caa_date_last_formal_actionstring06/20/2006
caa_penaltiesstring7000
caa_last_penalty_datestring06/20/2006
caa_last_penalty_amtstring39375
caa_qtrs_with_ncstring0
caa_compliance_statusstringNo Violation Identified
caa_hpv_flagstringN
caa_3yr_compl_qtrs_historystring____________
npdes_idsstringMAR10044S
cwa_permit_typesstringNon-M
cwa_compliance_trackingstringOn
cwa_naicsstring236115
cwa_sicsstring1521
cwa_inspection_countstring1
cwa_days_last_inspectionstring4495
cwa_informal_countstring1
cwa_formal_action_countstring1
cwa_date_last_formal_actionstring06/03/2021

53 more fields; select the table above to list them all.

Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

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.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

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