CityPropStats: Property statistics by building age (1910-2020) for 795 core-based statistical areas in the United States

CityPropStats provides aggregated property statistics for 795 cities and towns (i.e., Metropolitan and Micropolitan statistical areas) in the conterminous United States. These statistics include sum, mean, median, Gini index and entropy of residential floor space, cadastral parcel size, floor-area ratio, and property value, approximately for the reference year 2020, aggregated by building construction year in decadal steps (cumulative and incremental) from 1910 to 2020.Cumulative statistics: CBSA_Property_Statistics_1910-2020_cumulative.csvDecadal time slices statistics: CBSA_Property_Statistics_1910-2020_decadal_slices.csvData source: Zillow Transaction and Assessment Dataset (ZTRAX), provided to University of Colorado Boulder via a data share agreement (2016-2023).CityPropStats is a supplementary dataset to:Ortman, Scott G., Amy Bogaard, Jessica Munson, Dan Lawrence, Adam S. Green, Gary M. Feinman, Shadreck Chirikure, Johannes H. Uhl, and Stefan Leyk. "Changes in agglomeration and productivity are poor predictors of inequality across the archaeological record." Proceedings of the National Academy of Sciences 122, no. 16 (2025): e2400693122. https://doi.org/10.1073/pnas.2400693122Column description:cbsa_idCBSA GEOIDcbsa_nameFull namecbsa_typeCBSA type (metro vs micropolitan statistical area)year_fromEarliest year for selection interval of properties based on their construction yearyear_toLatest year for selection interval of properties based on their construction yearcbsa_popCBSA population or population change (US Census)tot_res_propsTotal residential propertiestot_res_area_sqkmTotal indoor area of residential properties in sqkmavg_res_area_sqmAverage indoor area of residential properties in sqmmedian_res_area_sqmMedian indoor area of residential properties in sqmq25_res_area_sqm25th percentile of indoor area of residential properties in sqmq75_res_area_sqm75th percentile of indoor area of residential properties in sqmgini_res_areaGini index of residential property indoor areatot_prop_value_usdTotal residential property value in USDmedian_prop_value_usdMedian residential property value in USDq25_prop_value_usd25th percentile of residential property values in USDq75_prop_value_usd75th percentile of residential property values in USDgini_prop_valueGini index of residential property valuestot_lot_area_sqkmTotal lot (cadastral parcel) area in sqkmavg_lot_area_sqmMean lot area in sqmmedian_lot_area_sqmMedian lot area in sqmq25_lot_area_sqm25th percentile of lot area in sqmq75_lot_area_sqm75th percentile of lot area in sqmgini_lot_areaGini index of lot areaavg_farMean floor-area-ratio (FAR), with FAR being the ratio of building indoor area and lot area, based on residential propertiesmedian_farMedian floor-area-ratio (FAR), with FAR being the ratio of building indoor area and lot area, based on residential propertiesq25_far25th percentile of floor-area-ratio (FAR), with FAR being the ratio of building indoor area and lot area, based on residential propertiesq75_far75th percentile of floor-area-ratio (FAR), with FAR being the ratio of building indoor area and lot area, based on residential propertiesentropy_res_areaShannon entropy of the indoor area of residential properties, based on propertiesentropy_prop_valueShannon entropy of the property value of residential properties, based on propertiesentropy_lot_areaShannon entropy of the lot size of residential properties, based on propertiesarea_completenessRatio of properties with a valid indoor area attribute [0,1]value_completenessRatio of properties with a valid property value attribute [0,1]lotsize_completenessRatio of properties with a valid indoor area, property value, and lot size attribute [0,1]area_value_completenessRatio of properties with a valid lot size attribute [0,1]area_value_lotsize_completenessRatio of properties with both a valid indoor area and property value attribute [0,1]