NYSgptData LibraryConnectPricing

Geographic relationship files

Overlap between pairs of geographies in 2020, with shared area and population.

26.2MRecords
65Tables
1,216Fields
CurrentYears

Publisher: Census Bureau

Try it

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

Tables
rel2020_tab_tab12.7Mrel2020_tab20_zcta520_tabblock208.2Mrel2020_tab20_blkgrp20_blkgrp10675Krel2020_tab20_sldl_20_tract20433Krel2020_tab20_sldu_20_tract20390Krel2020_tab20_tract20_tract10253Krel2020_tab20_sldl_20_zcta520232Krel2020_tab20_sldu_20_zcta520194Krel2020_tab20_cd11920_tract20181Krel2020_tab20_cd11820_tract20181Krel2020_tab20_sldl_20_cousub20179Krel2020_tab20_zcta520_tract20171Krel2020_tab20_sldl_20_place20168Krel2020_tab20_sldu_20_cousub20163Krel2020_tab20_sldu_20_place20149Krel2020_tab20_zcta510_zcta520138Krel2020_tab20_cousub20_cousub10126Krel2020_tab20_place20_place10124Krel2020_tab20_zcta520_cousub20113Krel2020_tab20_sldl_20_sdcombo2098Krel2020_tab20_aiannh20_tract2087.3Krel2020_census_tract_to_puma85.5Krel2020_tab20_zcta520_place2082.9Krel2020_tab20_cd11920_zcta52080.8Krel2020_tab20_cd11820_zcta52080.6Krel2020_tab20_sldu_20_sdcombo2078.1Krel2020_tab20_cd11820_cousub2076Krel2020_tab20_cd11920_cousub2074.4Krel2020_tab20_cd11920_place2068.1Krel2020_tab20_cd11820_place2068.1Krel2020_tab20_ua20_cousub2047.9Krel2020_tab20_zcta520_county2047.9Krel2020_tab20_puma520_zcta52047.8Krel2020_tab20_sldl_20_ua2045.2Krel2020_tab20_ua20_zcta52044.9Krel2020_tab20_ua20_place2043.5Krel2020_tab20_puma520_cousub2038.9Krel2020_tab20_aiannh20_cousub2038.3Krel2020_tab20_sldl_20_county2034Krel2020_tab20_cd11920_sdcombo2031.4Krel2020_tab20_cd11820_sdcombo2031.4Krel2020_tab20_sldu_20_ua2026.1Krel2020_tab20_sldl_20_aiannh2023.9Krel2020_tab20_sldu_20_county2022.2Krel2020_tab20_sldu_20_aiannh2011.9Krel2020_sldl_ur_poparea9.8Krel2020_tab20_ua10_ua209.1Krel2020_tab20_cd11920_ua207.7Krel2020_tab20_cd11920_county207.7Krel2020_tab20_cd11820_county207.7Krel2020_tab20_cd11820_ua207.6Krel2020_tab20_puma520_ua207.1Krel2020_tab20_puma520_puma5107Krel2020_tab20_ua20_county207Krel2020_tab20_aiannh20_county204.3Krel2020_acs23_ua20_cbsa234Krel2020_sldu_ur_poparea3.9Krel2020_tab20_cd11920_aiannh202.5Krel2020_tab20_cd11820_aiannh202.5Krel2020_acs23_cbsa20_cbsa231.2Krel2020_acs23_necta20_cbsa231Krel2020_cd118_landarea429rel2020_cd118_ur_poparea429rel2020_cd119_landarea429rel2020_cd119_ur_poparea429
Fields in rel2020_tab_tab
FieldTypeExample
state_2010string09
county_2010string011
tract_2010string705200
blk_2010string3000
blksf_2010string
arealand_2010string594
areawater_2010string1237702
block_part_flag_ostringp
state_2020string44
county_2020string009
tract_2020string051000
blk_2020string1039
blksf_2020string
arealand_2020string134157
areawater_2020string0
block_part_flag_rstringp
arealand_intstring594
areawater_intstring0
source_filestringlake/v1/census/raw/census-rel2020/2026-11-14/t10t20/TAB2010_
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 Census and Geography