NYSgptData LibraryConnectPricing

Home Mortgage Disclosure Act

Loan application records, transmittal sheets and the reporter panel, 2007 to 2024.

312MRecords
6Tables
280Fields
CurrentYears

Publisher: Consumer Financial Protection Bureau; Federal Financial Institutions Examination Council

Try it

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

Tables
Fields in hmda_lar_2007_2017
FieldTypeExample
as_of_yearstring2012
respondent_idstring0000146672
agency_codestring9
loan_typestring2
property_typestring1
loan_purposestring1
owner_occupancystring1
loan_amount_000sstring00299
preapprovalstring3
action_takenstring1
msamdstring35004
state_codestring36
county_codestring103
census_tract_numberstring1461.03
applicant_ethnicitystring2
co_applicant_ethnicitystring2
applicant_race_1string5
applicant_race_2string
applicant_race_3string
applicant_race_4string
applicant_race_5string
co_applicant_race_1string5
co_applicant_race_2string
co_applicant_race_3string
co_applicant_race_4string
co_applicant_race_5string
applicant_sexstring1
co_applicant_sexstring1
applicant_income_000sstring0114
purchaser_typestring2
denial_reason_1string
denial_reason_2string
denial_reason_3string
rate_spreadstringNA
hoepa_statusstring2
lien_statusstring1
edit_statusstring6
sequence_numberstring0093510
populationstring00004122
minority_populationstring027.03
hud_median_family_incomestring00107500
tract_to_msamd_incomestring105.09
number_of_owner_occupied_unitsstring00001249
number_of_1_to_4_family_unitsstring00001276
application_date_indicatorstring0
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 Mortgage Lending and Banks