NYSgptData LibraryConnectPricing

Housing need and subsidized households

Housing need by tract, and subsidized households by project, authority and place.

17.2MRecords
30Tables
6,325Fields
CurrentYears

Publisher: Department of Housing and Urban Development

Try it

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

Tables
Fields in hud_chas_table
FieldTypeExample
sourcestring2016thru2020
sumlevelstring140
geoidstring1400000US01001020100
namestringCensus Tract 201, Autauga County, Alabama
ststring01
cntystring001
tractstring020100
t1_est1string
t1_est2string
t1_est3string
t1_est4string
t1_est5string
t1_est6string
t1_est7string
t1_est8string
t1_est9string
t1_est10string
t1_est11string
t1_est12string
t1_est13string
t1_est14string
t1_est15string
t1_est16string
t1_est17string
t1_est18string
t1_est19string
t1_est20string
t1_est21string
t1_est22string
t1_est23string
t1_est24string
t1_est25string
t1_est26string
t1_est27string
t1_est28string
t1_est29string
t1_est30string
t1_est31string
t1_est32string
t1_est33string
t1_est34string
t1_est35string
t1_est36string
t1_est37string
t1_est38string
t1_est39string
t1_est40string
t1_est41string
t1_est42string
t1_est43string
t1_est44string
t1_est45string
t1_est46string
t1_est47string
t1_est48string
t1_est49string
t1_est50string
t1_est51string
t1_est52string
t1_est53string
t1_est54string
t1_est55string
t1_est56string
t1_est57string
t1_est58string
t1_est59string
t1_est60string
t1_est61string
t1_est62string
t1_est63string
t1_est64string
t1_est65string
t1_est66string
t1_est67string
t1_est68string
t1_est69string
t1_est70string
t1_est71string
t1_est72string
t1_est73string

3,229 more fields; select the table above to list them all.

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 Housing