Housing need by tract, and subsidized households by project, authority and place.
Publisher: Department of Housing and Urban Development
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| source | string | 2016thru2020 |
| sumlevel | string | 140 |
| geoid | string | 1400000US01001020100 |
| name | string | Census Tract 201, Autauga County, Alabama |
| st | string | 01 |
| cnty | string | 001 |
| tract | string | 020100 |
| t1_est1 | string | |
| t1_est2 | string | |
| t1_est3 | string | |
| t1_est4 | string | |
| t1_est5 | string | |
| t1_est6 | string | |
| t1_est7 | string | |
| t1_est8 | string | |
| t1_est9 | string | |
| t1_est10 | string | |
| t1_est11 | string | |
| t1_est12 | string | |
| t1_est13 | string | |
| t1_est14 | string | |
| t1_est15 | string | |
| t1_est16 | string | |
| t1_est17 | string | |
| t1_est18 | string | |
| t1_est19 | string | |
| t1_est20 | string | |
| t1_est21 | string | |
| t1_est22 | string | |
| t1_est23 | string | |
| t1_est24 | string | |
| t1_est25 | string | |
| t1_est26 | string | |
| t1_est27 | string | |
| t1_est28 | string | |
| t1_est29 | string | |
| t1_est30 | string | |
| t1_est31 | string | |
| t1_est32 | string | |
| t1_est33 | string | |
| t1_est34 | string | |
| t1_est35 | string | |
| t1_est36 | string | |
| t1_est37 | string | |
| t1_est38 | string | |
| t1_est39 | string | |
| t1_est40 | string | |
| t1_est41 | string | |
| t1_est42 | string | |
| t1_est43 | string | |
| t1_est44 | string | |
| t1_est45 | string | |
| t1_est46 | string | |
| t1_est47 | string | |
| t1_est48 | string | |
| t1_est49 | string | |
| t1_est50 | string | |
| t1_est51 | string | |
| t1_est52 | string | |
| t1_est53 | string | |
| t1_est54 | string | |
| t1_est55 | string | |
| t1_est56 | string | |
| t1_est57 | string | |
| t1_est58 | string | |
| t1_est59 | string | |
| t1_est60 | string | |
| t1_est61 | string | |
| t1_est62 | string | |
| t1_est63 | string | |
| t1_est64 | string | |
| t1_est65 | string | |
| t1_est66 | string | |
| t1_est67 | string | |
| t1_est68 | string | |
| t1_est69 | string | |
| t1_est70 | string | |
| t1_est71 | string | |
| t1_est72 | string | |
| t1_est73 | string |
3,229 more fields; select the table above to list them all.
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.