Releases and transfers of listed chemicals by facility and year.
Publisher: Environmental Protection Agency
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| _1_year | string | 1989 |
| _2_trifd | string | 54748MPNRTMAINS |
| _3_frs_id | string | 110000605934 |
| _4_facility_name | string | ASSOCIATED MILK PRODUCERS INC. |
| _5_street_address | string | 14193 COUNTY RD S |
| _6_city | string | JIM FALLS |
| _7_county | string | CHIPPEWA |
| _8_st | string | WI |
| _9_zip | string | 54748 |
| _10_bia | string | |
| _11_tribe | string | |
| _12_latitude | string | 45.047935 |
| _13_longitude | string | -91.273267 |
| _14_horizontal_datum | string | |
| _15_parent_co_name | string | ASSOCIATED MILK PRODUCERS INC |
| _16_parent_co_db_num | string | 043225507 |
| _17_standard_parent_co_name | string | ASSOCIATED MILK PRODUCERS INC |
| _18_foreign_parent_co_name | string | NA |
| _19_foreign_parent_co_db_num | string | NA |
| _20_standard_foreign_parent_co_name | string | NA |
| _21_federal_facility | string | NO |
| _22_industry_sector_code | string | 311 |
| _23_industry_sector | string | Food |
| _24_primary_sic | string | 2022 |
| _25_sic_2 | string | NA |
| _26_sic_3 | string | 3471 |
| _27_sic_4 | string | NA |
| _28_sic_5 | string | 5169 |
| _29_sic_6 | string | NA |
| _30_primary_naics | string | 311513 |
| _31_naics_2 | string | |
| _32_naics_3 | string | |
| _33_naics_4 | string | |
| _34_naics_5 | string | |
| _35_naics_6 | string | |
| _36_doc_ctrl_num | string | 1389035091519 |
| _37_chemical | string | Nitric acid |
| _38_elemental_metal_included | string | NO |
| _39_tri_chemicalcompound_id | string | 0007697372 |
| _40_cas | string | 7697-37-2 |
| _41_srs_id | string | 152686 |
| _42_clean_air_act_chemical | string | NO |
| _43_classification | string | TRI |
| _44_metal | string | NO |
| _45_metal_category | string | Non_Metal |
| _46_carcinogen | string | NO |
| _47_pbt | string | NO |
| _48_pfas | string | NO |
| _49_form_type | string | R |
| _50_unit_of_measure | string | Pounds |
| _51_51_fugitive_air | string | 0.000 |
| _52_52_stack_air | string | 0.000 |
| _53_53_water | string | 0.000 |
| _54_54_underground | string | 0.000 |
| _55_541_underground_cl_i | string | 0.000 |
| _56_542_underground_c_iiv | string | 0.000 |
| _57_551_landfills | string | 0.000 |
| _58_551a_rcra_c_landfill | string | 0.000 |
| _59_551b_other_landfills | string | 0.000 |
| _60_552_land_treatment | string | 0.000 |
| _61_553_surface_impndmnt | string | 0.000 |
| _62_553a_rcra_surface_im | string | 0.000 |
| _63_553b_other_surface_i | string | 0.000 |
| _64_554_other_disposal | string | 0.000 |
| _65_onsite_release_total | string | 0.000 |
| _66_61_potw_trns_rlse | string | 0.000 |
| _67_61_potw_trns_trt | string | 0.000 |
| _68_potw_total_transfers | string | 0.000 |
| _69_62_m10 | string | 0.000 |
| _70_62_m41 | string | 0.000 |
| _71_62_m62 | string | 0.000 |
| _72_62_m40_metal | string | 0.000 |
| _73_62_m61_metal | string | 0.000 |
| _74_62_m71 | string | 0.000 |
| _75_62_m81 | string | 0.000 |
| _76_62_m82 | string | 0.000 |
| _77_62_m72 | string | 0.000 |
| _78_62_m63 | string | 0.000 |
| _79_62_m66 | string | 0.000 |
| _80_62_m67 | string | 0.000 |
42 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.