NYSgptData LibraryConnectPricing

Monthly merchandise trade

Imports and exports by commodity, country, district and port, 2013 to 2026.

460MRecords
23Tables
329Fields
CurrentYears

Publisher: Census Bureau

Try it

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

Tables
Fields in census_imp_detl
FieldTypeExample
commoditystring8504408500
cty_codestring5570
cty_subcostring00
dist_entrystring39
dist_unladstring39
yearstring2013
monthstring04
cards_mostring21
con_qy1_mostring4401
con_qy2_mostring0
con_val_mostring70698
dut_val_mostring0
cal_dut_mostring0
con_cha_mostring3554
con_cif_mostring74252
gen_qy1_mostring4401
gen_qy2_mostring0
gen_val_mostring70698
gen_cha_mostring3554
gen_cif_mostring74252
air_val_mostring63668
air_wgt_mostring834
air_cha_mostring3167
ves_val_mostring0
ves_wgt_mostring0
ves_cha_mostring0
cnt_val_mostring0
cnt_wgt_mostring0
cnt_cha_mostring0
cards_yrstring52
con_qy1_yrstring9000
con_qy2_yrstring0
con_val_yrstring206895
dut_val_yrstring0
con_cha_yrstring8044
con_cif_yrstring214939
gen_qy1_yrstring9000
gen_qy2_yrstring0
gen_val_yrstring206895
gen_cha_yrstring8044
gen_cif_yrstring214939
air_val_yrstring199865
air_wgt_yrstring2015
air_cha_yrstring7657
ves_val_yrstring0
ves_wgt_yrstring0
ves_cha_yrstring0
cnt_val_yrstring0
cnt_wgt_yrstring0
cnt_cha_yrstring0
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.