Dataset: Housing Price Index Using Crime Rate Data

About this Dataset

Housing Price Index Using Crime Rate Data

Context

This dataset was actually made to check the correlations between a housing price index and its crime rate. Rise and fall of housing prices can be due to various factors with obvious reasons being the facilities of the house and its neighborhood. Think of a place like Detroit where there are hoodlums and you don't want to end up buying a house in the wrong place. This data set will serve as historical data for crime rate data and this in turn can be used to predict whether the housing price will rise or fall. Rise in housing price will suggest decrease in crime rate over the years and vice versa.

Content

The headers are self explanatory. index_nsa is the housing price non seasonal index.

Acknowledgements

Thank you to my team who helped in achieving this.

Inspiration

https://www.kaggle.com/marshallproject/crime-rates
https://catalog.data.gov/dataset/fhfa-house-price-indexes-hpis
Data was collected from these 2 sources and merged to get the resulting dataset.

Tables

Merged Dataset

@kaggle.sandeep04201988_housing_price_index_using_crime_rate_data.merged_dataset

67.18 KB
3477 rows
9 columns


CREATE TABLE merged_dataset (
  "year" DOUBLE,
  "index_nsa" DOUBLE,
  "city_state" VARCHAR,
  "population" DOUBLE,
  "violent_crimes" DOUBLE,
  "homicides" DOUBLE,
  "rapes" DOUBLE,
  "assaults" DOUBLE,
  "robberies" DOUBLE
);