NYSgptData LibraryConnectPricing

Toxics Release Inventory

Releases and transfers of listed chemicals by facility and year.

3.2MRecords
1Tables
122Fields
CurrentYears

Publisher: Environmental Protection Agency

Try it

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

Tables
Fields in tri_basic
FieldTypeExample
_1_yearstring1989
_2_trifdstring54748MPNRTMAINS
_3_frs_idstring110000605934
_4_facility_namestringASSOCIATED MILK PRODUCERS INC.
_5_street_addressstring14193 COUNTY RD S
_6_citystringJIM FALLS
_7_countystringCHIPPEWA
_8_ststringWI
_9_zipstring54748
_10_biastring
_11_tribestring
_12_latitudestring45.047935
_13_longitudestring-91.273267
_14_horizontal_datumstring
_15_parent_co_namestringASSOCIATED MILK PRODUCERS INC
_16_parent_co_db_numstring043225507
_17_standard_parent_co_namestringASSOCIATED MILK PRODUCERS INC
_18_foreign_parent_co_namestringNA
_19_foreign_parent_co_db_numstringNA
_20_standard_foreign_parent_co_namestringNA
_21_federal_facilitystringNO
_22_industry_sector_codestring311
_23_industry_sectorstringFood
_24_primary_sicstring2022
_25_sic_2stringNA
_26_sic_3string3471
_27_sic_4stringNA
_28_sic_5string5169
_29_sic_6stringNA
_30_primary_naicsstring311513
_31_naics_2string
_32_naics_3string
_33_naics_4string
_34_naics_5string
_35_naics_6string
_36_doc_ctrl_numstring1389035091519
_37_chemicalstringNitric acid
_38_elemental_metal_includedstringNO
_39_tri_chemicalcompound_idstring0007697372
_40_casstring7697-37-2
_41_srs_idstring152686
_42_clean_air_act_chemicalstringNO
_43_classificationstringTRI
_44_metalstringNO
_45_metal_categorystringNon_Metal
_46_carcinogenstringNO
_47_pbtstringNO
_48_pfasstringNO
_49_form_typestringR
_50_unit_of_measurestringPounds
_51_51_fugitive_airstring0.000
_52_52_stack_airstring0.000
_53_53_waterstring0.000
_54_54_undergroundstring0.000
_55_541_underground_cl_istring0.000
_56_542_underground_c_iivstring0.000
_57_551_landfillsstring0.000
_58_551a_rcra_c_landfillstring0.000
_59_551b_other_landfillsstring0.000
_60_552_land_treatmentstring0.000
_61_553_surface_impndmntstring0.000
_62_553a_rcra_surface_imstring0.000
_63_553b_other_surface_istring0.000
_64_554_other_disposalstring0.000
_65_onsite_release_totalstring0.000
_66_61_potw_trns_rlsestring0.000
_67_61_potw_trns_trtstring0.000
_68_potw_total_transfersstring0.000
_69_62_m10string0.000
_70_62_m41string0.000
_71_62_m62string0.000
_72_62_m40_metalstring0.000
_73_62_m61_metalstring0.000
_74_62_m71string0.000
_75_62_m81string0.000
_76_62_m82string0.000
_77_62_m72string0.000
_78_62_m63string0.000
_79_62_m66string0.000
_80_62_m67string0.000

42 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