ZIP areas to counties, tracts and districts; one row per county.
Publisher: Census Bureau relationship files
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| zcta | string | 72701 |
| geo_type | string | tabblock20 |
| geo_id | string | 051430101102010 |
| geo_name | string | Block 2010 |
| area_land_part | double | 69383.0 |
| share_of_zcta_land | double | 2.1263088308400962E-4 |
| share_of_geo_land | double | 1.0 |
| source_table | string | govblock_census.rel2020_tab20_zcta520_tabblock20 |
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.