Facilities and their identifiers across programmes.
Publisher: Environmental Protection Agency
Runs against the full table. Enter your key; plans are below.
| Field | Type | Example |
|---|---|---|
| pgm_sys_acrnm | string | AIR |
| pgm_sys_id | string | MA0000002511903472 |
| registry_id | string | 110071356657 |
| primary_name | string | VARIAN SEMICONDUCTOR EQUIPMENT |
| location_address | string | 14-20 BLACKBURN CTR |
| supplemental_location | string | 0.5MI FROM MONTEGUT RD (LA HWY 55) |
| city_name | string | GLOUCESTER |
| county_name | string | JEFFERSON |
| fips_code | string | MA009 |
| state_code | string | MA |
| state_name | string | KENTUCKY |
| country_name | string | USA |
| postal_code | string | 01930 |
Settings, Connectors, Add custom connector. Paste this address with your key:
https://data.nysgpt.com/mcp?key=YOUR_KEY
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp --header "X-Api-Key: YOUR_KEY"
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.
$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.