Overlap between pairs of geographies in 2020, with shared area and population.
Publisher: Census Bureau
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| state_2010 | string | 09 |
| county_2010 | string | 011 |
| tract_2010 | string | 705200 |
| blk_2010 | string | 3000 |
| blksf_2010 | string | |
| arealand_2010 | string | 594 |
| areawater_2010 | string | 1237702 |
| block_part_flag_o | string | p |
| state_2020 | string | 44 |
| county_2020 | string | 009 |
| tract_2020 | string | 051000 |
| blk_2020 | string | 1039 |
| blksf_2020 | string | |
| arealand_2020 | string | 134157 |
| areawater_2020 | string | 0 |
| block_part_flag_r | string | p |
| arealand_int | string | 594 |
| areawater_int | string | 0 |
| source_file | string | lake/v1/census/raw/census-rel2020/2026-11-14/t10t20/TAB2010_ |
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.