Imports and exports by commodity, country, district and port, 2013 to 2026.
Publisher: Census Bureau
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| commodity | string | 8504408500 |
| cty_code | string | 5570 |
| cty_subco | string | 00 |
| dist_entry | string | 39 |
| dist_unlad | string | 39 |
| year | string | 2013 |
| month | string | 04 |
| cards_mo | string | 21 |
| con_qy1_mo | string | 4401 |
| con_qy2_mo | string | 0 |
| con_val_mo | string | 70698 |
| dut_val_mo | string | 0 |
| cal_dut_mo | string | 0 |
| con_cha_mo | string | 3554 |
| con_cif_mo | string | 74252 |
| gen_qy1_mo | string | 4401 |
| gen_qy2_mo | string | 0 |
| gen_val_mo | string | 70698 |
| gen_cha_mo | string | 3554 |
| gen_cif_mo | string | 74252 |
| air_val_mo | string | 63668 |
| air_wgt_mo | string | 834 |
| air_cha_mo | string | 3167 |
| ves_val_mo | string | 0 |
| ves_wgt_mo | string | 0 |
| ves_cha_mo | string | 0 |
| cnt_val_mo | string | 0 |
| cnt_wgt_mo | string | 0 |
| cnt_cha_mo | string | 0 |
| cards_yr | string | 52 |
| con_qy1_yr | string | 9000 |
| con_qy2_yr | string | 0 |
| con_val_yr | string | 206895 |
| dut_val_yr | string | 0 |
| con_cha_yr | string | 8044 |
| con_cif_yr | string | 214939 |
| gen_qy1_yr | string | 9000 |
| gen_qy2_yr | string | 0 |
| gen_val_yr | string | 206895 |
| gen_cha_yr | string | 8044 |
| gen_cif_yr | string | 214939 |
| air_val_yr | string | 199865 |
| air_wgt_yr | string | 2015 |
| air_cha_yr | string | 7657 |
| ves_val_yr | string | 0 |
| ves_wgt_yr | string | 0 |
| ves_cha_yr | string | 0 |
| cnt_val_yr | string | 0 |
| cnt_wgt_yr | string | 0 |
| cnt_cha_yr | string | 0 |
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.