US House Prices (FHFA HPI)
The official U.S. house-price index in one clean Parquet - the redistributable answer to scraped Zillow / Redfin listing medians. All three FHFA repeat-sales House Price Index flavors - Purchase-only (the seasonally-adjusted headline, 1991Q1=100), All-transactions (adds refinance appraisals for history all the way back to 1975) and Expanded-data (blends in FHA/county records) - for the nation, the 9 Census divisions, all 50 states + DC, Puerto Rico and 400+ metropolitan areas. The national purchase-only index is monthly; everything else is quarterly (res_min carried honestly per row). Tracks every cycle - the 1970s-80s inflation, the 2000s boom, the 2008 crash, the 2012-22 run-up and the rate-shock cool-down - as transaction prices, not asking prices, down to the individual metro.
- Source
- U.S. FHFA
- Licence
- Redistributable open data
- Updates
- Quarterly
- Data through
- 2026-04-01
- Quality
- QC clean · 0 failures
- Format
- Apache Parquet + dictionary
Safe to train on
Built only from a named, redistributable official source under a documented open licence - not scraped web data. No copyright grey zone, no personal data. Ships machine-readable Croissant metadata (ML Commons - loads in Hugging Face / Kaggle / Google), an AI training-licence manifest documenting source, licence and provenance for your model's data governance, and a machine-readable data dictionary (drop it into an agent / RAG prompt so the model knows every column) - all inspectable before you buy.
What's included
- The official transaction-price index - not scraped listings; U.S. public domain, fully redistributable
- National + 9 Census divisions + 50 states + DC + Puerto Rico + 400+ metros (MSAs)
- 3 index flavors - Purchase-only (SA), All-transactions (back to 1975), Expanded-data
- Repeat-sales methodology on Fannie/Freddie mortgage records - consistent and revision-tracked
- One row per geography × flavor × period; joins to macro / rates / mortgage data
- Source: U.S. Federal Housing Finance Agency (FHFA) - public domain
Schema
| Column | Type | Description | Filled | Distinct |
|---|---|---|---|---|
| zone | str | US / Census division / 2-letter state / metro name / Puerto Rico | 100.0% | 472 |
| ts | timestamp (UTC) | First of the period (national purchase-only monthly, else quarterly) | 100.0% | 488 |
| measure | str | «Flavor» HPI (SA/NSA) - Purchase-only / All-transactions / Expanded-data | 100.0% | 3 |
| value | float | House price index level (base=100) | 100.0% | 41,819 |
| unit | str | Unit | 100.0% | 1 |
| res_min | int | Native resolution (43200 monthly / 129600 quarterly) | 100.0% | 2 |
Sample & preview
Every purchase ships as Apache Parquet with a data dictionary and the full QC report. A free sample (first rows + schema) is downloadable here - confirm fit before you buy. Source: U.S. FHFA (redistributable open data; attribution passes through - see our Licence).
Don't trust screenshots - drop the sample into your notebook right now.
import pandas as pd df = pd.read_parquet("us-house-prices_sample.parquet") df.info() # typed columns, gap-aware, ready to join⬇ Download free Parquet sample or CSV for Excel
Coverage: 472 zones
AK · AL · AR · AZ · Abilene, TX · Akron, OH · Albany, GA · Albany, OR · Albany-Schenectady-Troy, NY · Albuquerque, NM · Alexandria, LA · Allentown-Bethlehem-Easton, PA-NJ · Altoona, PA · Amarillo, TX · Ames, IA · Amherst Town-Northampton, MA · Anaheim-Santa Ana-Irvine, CA (MSAD) · Anchorage, AK · Ann Arbor, MI · Anniston-Oxford, AL · Appleton, WI · Arlington-Alexandria-Reston, VA-WV (MSAD) · Asheville, NC · Athens-Clarke County, GA · Atlanta-Sandy Springs-Roswell, GA (MSAD) · Atlantic City-Hammonton, NJ · Auburn-Opelika, AL · Augusta-Richmond County, GA-SC · Austin-Round Rock-San Marcos, TX · Bakersfield-Delano, CA · Baltimore-Columbia-Towson, MD · Bangor, ME · Barnstable Town, MA · Baton Rouge, LA · Battle Creek, MI · Bay City, MI · Beaumont-Port Arthur, TX · Beckley, WV · Bellingham, WA · Bend, OR · Billings, MT · Binghamton, NY · Birmingham, AL · Bismarck, ND · Blacksburg-Christiansburg-Radford, VA · Bloomington, IL · Bloomington, IN · Boise City, ID · Boston, MA (MSAD) · Boulder, CO · Bowling Green, KY · Bozeman, MT · Bremerton-Silverdale-Port Orchard, WA · Bridgeport-Stamford-Danbury, CT · Brownsville-Harlingen, TX · Brunswick-St. Simons, GA · Buffalo-Cheektowaga, NY · Burlington, NC · Burlington-South Burlington, VT · CA · CO · CT · Cambridge-Newton-Framingham, MA (MSAD) · Camden, NJ (MSAD) · Canton-Massillon, OH · Cape Coral-Fort Myers, FL · Cape Girardeau, MO-IL · Carson City, NV · Casper, WY · Cedar Rapids, IA · Chambersburg, PA · Champaign-Urbana, IL · Charleston, WV · Charleston-North Charleston, SC · Charlotte-Concord-Gastonia, NC-SC · Charlottesville, VA · Chattanooga, TN-GA · Cheyenne, WY · Chicago-Naperville-Schaumburg, IL (MSAD) · Chico, CA · Cincinnati, OH-KY-IN · Clarksville, TN-KY · Cleveland, OH · Cleveland, TN · Coeur d'Alene, ID · College Station-Bryan, TX · Colorado Springs, CO · Columbia, MO · Columbia, SC · Columbus, GA-AL · Columbus, IN · Columbus, OH · Corpus Christi, TX · Corvallis, OR · Crestview-Fort Walton Beach-Destin, FL · DC · DE · Dallas-Plano-Irving, TX (MSAD) · Dalton, GA · Daphne-Fairhope-Foley, AL · Davenport-Moline-Rock Island, IA-IL · Dayton-Kettering-Beavercreek, OH · Decatur, AL · Decatur, IL · Deltona-Daytona Beach-Ormond Beach, FL · Denver-Aurora-Centennial, CO · Des Moines-West Des Moines, IA · Detroit-Dearborn-Livonia, MI (MSAD) · Dothan, AL · Dover, DE · Dubuque, IA · Duluth, MN-WI · Durham-Chapel Hill, NC · East North Central Division · East South Central Division · Eau Claire, WI · El Centro, CA · El Paso, TX · Elgin, IL (MSAD) · Elizabethtown, KY · Elkhart-Goshen, IN · Elmira, NY · Enid, OK · Erie, PA · Eugene-Springfield, OR · Evansville, IN · Everett, WA (MSAD) · FL · Fairbanks-College, AK · Fargo, ND-MN · Farmington, NM · Fayetteville, NC · Fayetteville-Springdale-Rogers, AR · Flagstaff, AZ · Flint, MI · Florence, SC · Florence-Muscle Shoals, AL · Fond du Lac, WI · Fort Collins-Loveland, CO · Fort Lauderdale-Pompano Beach-Sunrise, FL (MSAD) · Fort Smith, AR-OK · Fort Wayne, IN · Fort Worth-Arlington-Grapevine, TX (MSAD) · Frederick-Gaithersburg-Bethesda, MD (MSAD) · Fresno, CA · GA · Gadsden, AL · Gainesville, FL · Gainesville, GA · Gettysburg, PA · Glens Falls, NY · Goldsboro, NC · Grand Forks, ND-MN · Grand Island, NE · Grand Junction, CO · Grand Rapids-Wyoming-Kentwood, MI · Grants Pass, OR · Great Falls, MT · Greeley, CO · Green Bay, WI · Greensboro-High Point, NC · Greenville, NC · Greenville-Anderson-Greer, SC · Gulfport-Biloxi, MS · HI · Hagerstown-Martinsburg, MD-WV · Hammond, LA · Hanford-Corcoran, CA · Harrisburg-Carlisle, PA · Harrisonburg, VA · Hartford-West Hartford-East Hartford, CT · Hattiesburg, MS · Helena, MT · Hickory-Lenoir-Morganton, NC · Hilton Head Island-Bluffton-Port Royal, SC · Hinesville, GA · Homosassa Springs, FL · Hot Springs, AR · Houma-Bayou Cane-Thibodaux, LA · Houston-Pasadena-The Woodlands, TX · Huntington-Ashland, WV-KY-OH · Huntsville, AL · IA · ID · IL · IN · Idaho Falls, ID · Indianapolis-Carmel-Greenwood, IN · Iowa City, IA · Ithaca, NY · Jackson, MI · Jackson, MS · Jackson, TN · Jacksonville, FL · Jacksonville, NC · Janesville-Beloit, WI · Jefferson City, MO · Johnson City, TN · Johnstown, PA · Jonesboro, AR · Joplin, MO-KS · KS · KY · Kahului-Wailuku, HI · Kalamazoo-Portage, MI · Kankakee, IL · Kansas City, MO-KS · Kennewick-Richland, WA · Kenosha, WI · Killeen-Temple, TX · Kingsport-Bristol, TN-VA · Kingston, NY · Kiryas Joel-Poughkeepsie-Newburgh, NY · Knoxville, TN · Kokomo, IN · LA · La Crosse-Onalaska, WI-MN · Lafayette, LA · Lafayette-West Lafayette, IN · Lake Charles, LA · Lake County, IL (MSAD) · Lake County-Porter County-Jasper County, IN (MSAD) · Lake Havasu City-Kingman, AZ · Lakeland-Winter Haven, FL · Lakewood-New Brunswick, NJ (MSAD) · Lancaster, PA · Lansing-East Lansing, MI · Laredo, TX · Las Cruces, NM · Las Vegas-Henderson-North Las Vegas, NV · Lawrence, KS · Lawton, OK · Lebanon, PA · Lewiston, ID-WA · Lewiston-Auburn, ME · Lexington Park, MD · Lexington-Fayette, KY · Lima, OH · Lincoln, NE · Little Rock-North Little Rock-Conway, AR · Logan, UT-ID · Longview, TX · Longview-Kelso, WA · Los Angeles-Long Beach-Glendale, CA (MSAD) · Louisville/Jefferson County, KY-IN · Lubbock, TX · Lynchburg, VA · MA · MD · ME · MI · MN · MO · MS · MT · Macon-Bibb County, GA · Madison, WI · Manchester-Nashua, NH · Manhattan, KS · Mankato, MN · Mansfield, OH · Marietta, GA (MSAD) · McAllen-Edinburg-Mission, TX · Medford, OR · Memphis, TN-MS-AR · Merced, CA · Miami-Miami Beach-Kendall, FL (MSAD) · Michigan City-La Porte, IN · Middle Atlantic Division · Midland, MI · Midland, TX · Milwaukee-Waukesha, WI · Minneapolis-St. Paul-Bloomington, MN-WI · Minot, ND · Missoula, MT · Mobile, AL · Modesto, CA · Monroe, LA · Monroe, MI · Montgomery County-Bucks County-Chester County, PA (MSAD) · Montgomery, AL · Morgantown, WV · Morristown, TN · Mount Vernon-Anacortes, WA · Mountain Division · Muncie, IN · Muskegon-Norton Shores, MI · Myrtle Beach-Conway-North Myrtle Beach, SC · NC · ND · NE · NH · NJ · NM · NV · NY · Napa, CA · Naples-Marco Island, FL · Nashville-Davidson--Murfreesboro--Franklin, TN · Nassau County-Suffolk County, NY (MSAD) · New England Division · New Haven, CT · New Orleans-Metairie, LA · New York-Jersey City-White Plains, NY-NJ (MSAD) · Newark, NJ (MSAD) · Niles, MI · North Port-Bradenton-Sarasota, FL · Norwich-New London-Willimantic, CT · OH · OK · OR · Oakland-Fremont-Berkeley, CA (MSAD) · Ocala, FL · Odessa, TX · Ogden, UT · Oklahoma City, OK · Olympia-Lacey-Tumwater, WA · Omaha, NE-IA · Orlando-Kissimmee-Sanford, FL · Oshkosh-Neenah, WI · Owensboro, KY · Oxnard-Thousand Oaks-Ventura, CA · PA · Pacific Division · Paducah, KY-IL · Palm Bay-Melbourne-Titusville, FL · Panama City-Panama City Beach, FL · Parkersburg-Vienna, WV · Pensacola-Ferry Pass-Brent, FL · Peoria, IL · Philadelphia, PA (MSAD) · Phoenix-Mesa-Chandler, AZ · Pinehurst-Southern Pines, NC · Pittsburgh, PA · Pittsfield, MA · Pocatello, ID · Port St. Lucie, FL · Portland-South Portland, ME · Portland-Vancouver-Hillsboro, OR-WA · Prescott Valley-Prescott, AZ · Providence-Warwick, RI-MA · Provo-Orem-Lehi, UT · Pueblo, CO · Puerto Rico · Punta Gorda, FL · RI · Racine-Mount Pleasant, WI · Raleigh-Cary, NC · Rapid City, SD · Reading, PA · Redding, CA · Reno, NV · Richmond, VA · Riverside-San Bernardino-Ontario, CA · Roanoke, VA · Rochester, MN · Rochester, NY · Rockford, IL · Rockingham County-Strafford County, NH (MSAD) · Rocky Mount, NC · Rome, GA · SC · SD · Sacramento-Roseville-Folsom, CA · Saginaw, MI · Salem, OR · Salinas, CA · Salisbury, MD · Salt Lake City-Murray, UT · San Angelo, TX · San Antonio-New Braunfels, TX · San Diego-Chula Vista-Carlsbad, CA · San Francisco-San Mateo-Redwood City, CA (MSAD) · San Jose-Sunnyvale-Santa Clara, CA · San Luis Obispo-Paso Robles, CA · San Rafael, CA (MSAD) · Sandusky, OH · Santa Cruz-Watsonville, CA · Santa Fe, NM · Santa Maria-Santa Barbara, CA · Santa Rosa-Petaluma, CA · Savannah, GA · Scranton--Wilkes-Barre, PA · Seattle-Bellevue-Kent, WA (MSAD) · Sebastian-Vero Beach-West Vero Corridor, FL · Sebring, FL · Sheboygan, WI · Sherman-Denison, TX · Shreveport-Bossier City, LA · Sierra Vista-Douglas, AZ · Sioux City, IA-NE-SD · Sioux Falls, SD-MN · Slidell-Mandeville-Covington, LA · South Atlantic Division · South Bend-Mishawaka, IN-MI · Spartanburg, SC · Spokane-Spokane Valley, WA · Springfield, IL · Springfield, MA · Springfield, MO · Springfield, OH · St. Cloud, MN · St. George, UT · St. Joseph, MO-KS · St. Louis, MO-IL · St. Petersburg-Clearwater-Largo, FL (MSAD) · State College, PA · Staunton-Stuarts Draft, VA · Stockton-Lodi, CA · Sumter, SC · Syracuse, NY · TN · TX · Tacoma-Lakewood, WA (MSAD) · Tallahassee, FL · Tampa, FL (MSAD) · Terre Haute, IN · Texarkana, TX-AR · Toledo, OH · Topeka, KS · Traverse City, MI · Trenton-Princeton, NJ · Tucson, AZ · Tulsa, OK · Tuscaloosa, AL · Twin Falls, ID · Tyler, TX · US · UT · Urban Honolulu, HI · Utica-Rome, NY · VA · VT · Valdosta, GA · Vallejo, CA · Victoria, TX · Vineland, NJ · Virginia Beach-Chesapeake-Norfolk, VA-NC · Visalia, CA · WA · WI · WV · WY · Waco, TX · Walla Walla, WA · Warner Robins, GA · Warren-Troy-Farmington Hills, MI (MSAD) · Washington, DC-MD (MSAD) · Waterbury-Shelton, CT · Waterloo-Cedar Falls, IA · Watertown-Fort Drum, NY · Wausau, WI · Weirton-Steubenville, WV-OH · Wenatchee-East Wenatchee, WA · West North Central Division · West Palm Beach-Boca Raton-Delray Beach, FL (MSAD) · West South Central Division · Wheeling, WV-OH · Wichita Falls, TX · Wichita, KS · Wildwood-The Villages, FL · Williamsport, PA · Wilmington, DE-MD-NJ (MSAD) · Wilmington, NC · Winchester, VA-WV · Winston-Salem, NC · Worcester, MA · Yakima, WA · York-Hanover, PA · Youngstown-Warren, OH · Yuba City, CA · Yuma, AZ
Related datasets
European Building Permits
The leading indicator of housing supply, in one clean Parquet: building permits lead completions by one to two years, so they tell you where the pipeline is filling or drying up long before the house-price and construction-output data move. Eurostat's permit index (sts_cobp_q, 2021=100, seasonally & calendar adjusted) for residential dwellings, residential floor area and non-residential floor area - quarterly, per country. The supply side our house-price, rent and affordability products imply but don't measure; developers, housing economists and REIT analysts read it to forecast the next turn in construction and prices.
European Construction Output
The building cycle in one clean Parquet: Eurostat's monthly construction production index (2021=100, seasonally adjusted) for every European country - total construction and the building vs civil-engineering split - one row per country × series × month since 2000. A leading read on housing supply, infrastructure spend and the construction economy; joins to house prices, macro and rates on country code.
European Construction Costs & Prices
The COST and PRICE side of European construction - the missing half of our construction-output (volume) product. Eurostat's construction cost index for new residential buildings (input costs: materials + labour) and the construction producer-price index (output prices), plus the annual inflation rate of each - quarterly, per country, one clean Parquet. Read alongside construction-output it separates a real building boom from pure cost inflation; developers use the cost-vs-price gap to model margin compression, and macro desks track it as a sticky component of core inflation. Captures the brutal 2021-23 materials-and-labour cost surge in full.