Loan application records, transmittal sheets and the reporter panel, 2007 to 2024.
Publisher: Consumer Financial Protection Bureau; Federal Financial Institutions Examination Council
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| as_of_year | string | 2012 |
| respondent_id | string | 0000146672 |
| agency_code | string | 9 |
| loan_type | string | 2 |
| property_type | string | 1 |
| loan_purpose | string | 1 |
| owner_occupancy | string | 1 |
| loan_amount_000s | string | 00299 |
| preapproval | string | 3 |
| action_taken | string | 1 |
| msamd | string | 35004 |
| state_code | string | 36 |
| county_code | string | 103 |
| census_tract_number | string | 1461.03 |
| applicant_ethnicity | string | 2 |
| co_applicant_ethnicity | string | 2 |
| applicant_race_1 | string | 5 |
| applicant_race_2 | string | |
| applicant_race_3 | string | |
| applicant_race_4 | string | |
| applicant_race_5 | string | |
| co_applicant_race_1 | string | 5 |
| co_applicant_race_2 | string | |
| co_applicant_race_3 | string | |
| co_applicant_race_4 | string | |
| co_applicant_race_5 | string | |
| applicant_sex | string | 1 |
| co_applicant_sex | string | 1 |
| applicant_income_000s | string | 0114 |
| purchaser_type | string | 2 |
| denial_reason_1 | string | |
| denial_reason_2 | string | |
| denial_reason_3 | string | |
| rate_spread | string | NA |
| hoepa_status | string | 2 |
| lien_status | string | 1 |
| edit_status | string | 6 |
| sequence_number | string | 0093510 |
| population | string | 00004122 |
| minority_population | string | 027.03 |
| hud_median_family_income | string | 00107500 |
| tract_to_msamd_income | string | 105.09 |
| number_of_owner_occupied_units | string | 00001249 |
| number_of_1_to_4_family_units | string | 00001276 |
| application_date_indicator | string | 0 |
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.