EPB script and data
收藏资源简介：
Python script used to examine how the marketing of properties explains neighborhood racial and income change using historical public remarks in real estate listings from Multiple Listing Services (MLS) collected and curated by CoreLogic.The primary dataset used for this research consists of 158,253 geocoded real estate listings for single-family homes in Mecklenburg County, North Carolina between 2001 and 2020. The historical MLS data which include public remarks is <b>proprietary</b> and can be obtained through purchase agreement with <b>CoreLogic</b>. The MLS is not publicly available and only available for members of the National Association of Realtors. Public remarks for homes currently listed for sale can be collected from online real estate websites such as Zillow, Trulia, Realtor.com, Redfin, and others.Since we cannot share this data, users need to, before running the script provided here, run the script provided by Nilsson and Delmelle (2023) which can be accessed here: https://doi.org/10.6084/m9.figshare.20493012.v1. This in order to get a fabricated/mock dataset of classified listings called classes_mock.csv. The article associated with Nilsson and Delmelle's (2023) script can be accessed here: https://www.tandfonline.com/doi/abs/10.1080/13658816.2023.2209803<br>The user can then run the code together with the data provided here to estimate the threshold models together with data derived from the publicly available HMDA data. To compile a historical data set of loan/application records (LAR) for the user's own study are, the user will need to download data from the following websites:https://ffiec.cfpb.gov/data-publication/snapshot-national-loan-level-dataset/2022 (2017-forward)https://www.ffiec.gov/hmda/hmdaproducts.htm (2007-2016)https://catalog.archives.gov/search-within/2456161?limit=20&levelOfDescription=fileUnit&sort=naId:asc (for data prior to 2007)
本Python脚本旨在通过CoreLogic收集整理的多重上市服务（Multiple Listing Services, MLS）系统中的房地产挂牌历史公开备注，探究房地产营销如何解释社区种族结构与收入水平的变化。 本研究使用的核心数据集涵盖2001年至2020年间北卡罗来纳州梅克伦堡县的158253条经地理编码的独栋住宅房地产挂牌数据。 包含公开备注的历史MLS数据为专有数据，需通过与CoreLogic签订采购协议方可获取。MLS数据不对外开放，仅对美国全国房地产经纪人协会（National Association of Realtors）会员开放。当前在售住宅的公开备注可从Zillow、Trulia、Realtor.com、Redfin等在线房地产平台获取。 由于我们无法共享该数据集，使用者需在运行本脚本前，先运行Nilsson与Delmelle（2023）提供的脚本，该脚本可通过以下链接获取：https://doi.org/10.6084/m9.figshare.20493012.v1，以此获取名为classes_mock.csv的分类挂牌模拟数据集。 与Nilsson和Delmelle（2023）的脚本相关的研究论文可通过以下链接查阅：https://www.tandfonline.com/doi/abs/10.1080/13658816.2023.2209803 使用者随后可将本脚本与本次提供的数据相结合，并结合公开可得的住房抵押贷款披露法案（Home Mortgage Disclosure Act, HMDA）数据，对阈值模型进行估计。 若使用者需为自身研究构建贷款/申请记录（Loan/Application Records, LAR）历史数据集，则需从以下网站下载相关数据： https://ffiec.cfpb.gov/data-publication/snapshot-national-loan-level-dataset/2022（2017年及以后数据） https://www.ffiec.gov/hmda/hmdaproducts.htm（2007年至2016年数据） https://catalog.archives.gov/search-within/2456161?limit=20&levelOfDescription=fileUnit&sort=naId:asc（2007年以前的数据）
