Dataset: House Data

About this Dataset

House Data

Content

The dataset consists of Price of Houses in King County , Washington from sales between May 2014 and May 2015. Along with house price it consists of information on 18 house features, date of sale and ID of sale.

Attribute information

id - Unique id for each home sold
date - Date of the home saled
price - Price of each home sold
bedrooms - Number of bedrooms
bathrooms - Number of bathrooms
sqft _ living - Square footage of the apartments interior living space
sqft _ lot - Square footage of the land space
floors - Number of floors
waterfront - A dummy variable for whether the apartment was overlooking the waterfront or not
view - An index from 0 to 4 of how good the view of the property was
condition - an index from 1 to 5 on the condition of the apartment
grade - An index from 1 to 13 , where 1-3falls short of building construction and design, 7 has an average level of construction and design , and 11-13 have a high quality level of construction and design
sqft _ above - the square footage of the interior housing space that is above ground level
sqft _ basement - the square footage of the inerior housing space that is below ground level
yr _ built - The year of the house was initially built
yr _ renovated - The year of the house's last renovation
zipcode - What zipcode area the house is in
lat - Lattitude
long - Longitude
sqft _ living15 - The square footage of inerior housing living space for the nearest nearest 15 neighbours
sqft _ lot15 - the square footage of the land lots of the nearest 15 neighbours

Tables

House Data

@kaggle.arathipraj_house_data.house_data

712.5 KB
21613 rows
21 columns


CREATE TABLE house_data (
  "id" BIGINT,
  "date" TIMESTAMP,
  "price" BIGINT,
  "bedrooms" BIGINT,
  "bathrooms" DOUBLE,
  "sqft_living" BIGINT,
  "sqft_lot" BIGINT,
  "floors" DOUBLE,
  "waterfront" BIGINT,
  "view" BIGINT,
  "condition" BIGINT,
  "grade" BIGINT,
  "sqft_above" BIGINT,
  "sqft_basement" BIGINT,
  "yr_built" BIGINT,
  "yr_renovated" BIGINT,
  "zipcode" BIGINT,
  "lat" DOUBLE,
  "long" DOUBLE,
  "sqft_living15" BIGINT,
  "sqft_lot15" BIGINT
);