datasets_housing_markets_search
Search US housing market statistics by region and property type to find monthly prices, sales, inventory, and affordability metrics like price-to-income ratio.
Instructions
Search the US housing markets dataset. Searches monthly Redfin housing-market statistics per region and property type since 2012, joined to Census ACS income for affordability metrics. region_type enum: national, metro, county, city, zip. property_type enum: All Residential, Single Family Residential, Condo/Co-op, Townhouse, Multi-Family (2-4 Unit), Single Units Only. Sort enum: relevance, price_desc, price_asc, list_price_desc, list_price_asc, price_to_income_desc, price_to_income_asc, salary_to_buy_desc, salary_to_buy_asc, dom_asc, dom_desc, inventory_desc, homes_sold_desc, period_desc. Use latest=true for the most recent period per region series.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| q | No | Full-text query over region name and city, max 256 characters | |
| page | No | Page number, defaults to 1 | |
| sort | No | Sort enum: relevance, price_desc, price_asc, list_price_desc, list_price_asc, price_to_income_desc, price_to_income_asc, salary_to_buy_desc, salary_to_buy_asc, dom_asc, dom_desc, inventory_desc, homes_sold_desc, period_desc | |
| latest | No | Filter for the most recent period per region and property type | |
| period | No | Exact period start date filter, YYYY-MM-DD | |
| zip_code | No | Exact zip code filter (zip-level rows only), e.g. 60616 | |
| page_size | No | Page size, defaults to 20 and maxes at 100; page * page_size must be <= 10000 | |
| state_code | No | Exact two-letter state code filter, e.g. CA | |
| region_type | No | Region level enum: national, metro, county, city, zip | |
| max_inventory | No | Maximum active inventory | |
| min_inventory | No | Minimum active inventory | |
| property_type | No | Property type enum: All Residential, Single Family Residential, Condo/Co-op, Townhouse, Multi-Family (2-4 Unit), Single Units Only | |
| max_median_dom | No | Maximum median days on market | |
| min_homes_sold | No | Minimum homes sold in the period | |
| min_median_dom | No | Minimum median days on market | |
| max_salary_to_buy | No | Maximum salary needed to buy in USD per year | |
| min_salary_to_buy | No | Minimum salary needed to buy in USD per year | |
| parent_metro_code | No | Exact parent metro (CBSA) code filter, e.g. 16980 | |
| max_price_to_income | No | Maximum price-to-income ratio | |
| min_price_to_income | No | Minimum price-to-income ratio | |
| max_median_list_price | No | Maximum median list price in USD | |
| max_median_sale_price | No | Maximum median sale price in USD | |
| min_median_list_price | No | Minimum median list price in USD | |
| min_median_sale_price | No | Minimum median sale price in USD |