Dataset: Property Sales England Dataset🏡: Zoopla (2023/24)

About this Dataset

Property Sales England Dataset🏡: Zoopla (2023/24)

***Overview:
Dataset contains recent properties sold in England from Zoopla listings.

***Data Science Applications and tasks possible

Analyse average pricing and trends
Geo- Spatial analysis
Feature extraction/Engineering
*Data Cleaning

***Ethically mined data
Data has been mined ethically using API for Publicly available data only.

***Main Data Columns:
bathrooms ,bedrooms ,country ,currentEnergyRating ,floorAreaSqM ,fullAddress ,historicListings/0/date ,historicListings/0/price historicListings/1/date ,historicListings/1/price ... .saleEstimate/ingestedAt ,saleEstimate/lowerPrice ,saleEstimate/upperPrice .saleEstimate/valueChange/numericChange ,saleEstimate/valueChange/percentageChange ,saleEstimate/valueChange/saleDate , soldPricesDataSource ,tenure ,uprn .

***Note
---(Requires Data Cleaning to remove unwanted columns)

Tables

Zp1

@kaggle.kanchana1990_property_sales_uk_dataset_zoopla_2023_2024.zp1

692.91 KB
1000 rows
629 columns


CREATE TABLE zp1 (
  "bathrooms" DOUBLE,
  "bedrooms" DOUBLE,
  "country" VARCHAR,
  "currentenergyrating" VARCHAR,
  "floorareasqm" DOUBLE,
  "fulladdress" VARCHAR,
  "historiclistings_0_date" TIMESTAMP,
  "historiclistings_0_price" DOUBLE,
  "historiclistings_1_date" TIMESTAMP,
  "historiclistings_1_price" DOUBLE,
  "historiclistings_2_date" TIMESTAMP,
  "historiclistings_2_price" DOUBLE,
  "historiclistings_3_date" TIMESTAMP,
  "historiclistings_3_price" DOUBLE,
  "historiclistings_4_date" TIMESTAMP,
  "historiclistings_4_price" DOUBLE,
  "historiclistings_5_date" TIMESTAMP,
  "historiclistings_5_price" DOUBLE,
  "historiclistings_6_date" TIMESTAMP,
  "historiclistings_6_price" DOUBLE,
  "historiclistings_7_date" TIMESTAMP,
  "historiclistings_7_price" DOUBLE,
  "historiclistings_8_date" TIMESTAMP,
  "historiclistings_8_price" DOUBLE,
  "historiclistings_9_date" TIMESTAMP,
  "historiclistings_9_price" DOUBLE,
  "historicsales_0_date" TIMESTAMP,
  "historicsales_0_numericchange" DOUBLE,
  "historicsales_0_percentagechange" DOUBLE,
  "historicsales_0_price" BIGINT,
  "historicsales_1_date" TIMESTAMP,
  "historicsales_1_numericchange" DOUBLE,
  "historicsales_1_percentagechange" DOUBLE,
  "historicsales_1_price" DOUBLE,
  "historicsales_2_date" TIMESTAMP,
  "historicsales_2_numericchange" DOUBLE,
  "historicsales_2_percentagechange" DOUBLE,
  "historicsales_2_price" DOUBLE,
  "historicsales_3_date" TIMESTAMP,
  "historicsales_3_numericchange" DOUBLE,
  "historicsales_3_percentagechange" DOUBLE,
  "historicsales_3_price" DOUBLE,
  "historicsales_4_date" TIMESTAMP,
  "historicsales_4_numericchange" DOUBLE,
  "historicsales_4_percentagechange" DOUBLE,
  "historicsales_4_price" DOUBLE,
  "historicsales_5_date" TIMESTAMP,
  "historicsales_5_numericchange" DOUBLE,
  "historicsales_5_percentagechange" DOUBLE,
  "historicsales_5_price" DOUBLE,
  "historicsales_6_date" TIMESTAMP,
  "historicsales_6_numericchange" DOUBLE,
  "historicsales_6_percentagechange" DOUBLE,
  "historicsales_6_price" DOUBLE,
  "historicsales_7_date" TIMESTAMP,
  "historicsales_7_numericchange" DOUBLE,
  "historicsales_7_percentagechange" DOUBLE,
  "historicsales_7_price" DOUBLE,
  "historicsales_8_date" TIMESTAMP,
  "historicsales_8_numericchange" DOUBLE,
  "historicsales_8_percentagechange" DOUBLE,
  "historicsales_8_price" DOUBLE,
  "historicsales_9_date" TIMESTAMP,
  "historicsales_9_numericchange" DOUBLE,
  "historicsales_9_percentagechange" DOUBLE,
  "historicsales_9_price" DOUBLE,
  "historicsales_10_date" TIMESTAMP,
  "historicsales_10_numericchange" DOUBLE,
  "historicsales_10_percentagechange" DOUBLE,
  "historicsales_10_price" DOUBLE,
  "historicsales_11_date" TIMESTAMP,
  "historicsales_11_numericchange" DOUBLE,
  "historicsales_11_percentagechange" DOUBLE,
  "historicsales_11_price" DOUBLE,
  "historicsales_12_date" TIMESTAMP,
  "historicsales_12_numericchange" DOUBLE,
  "historicsales_12_percentagechange" DOUBLE,
  "historicsales_12_price" DOUBLE,
  "historicsales_13_date" TIMESTAMP,
  "historicsales_13_numericchange" DOUBLE,
  "historicsales_13_percentagechange" DOUBLE,
  "historicsales_13_price" DOUBLE,
  "historicsales_14_date" TIMESTAMP,
  "historicsales_14_numericchange" DOUBLE,
  "historicsales_14_percentagechange" DOUBLE,
  "historicsales_14_price" DOUBLE,
  "historicsales_15_date" TIMESTAMP,
  "historicsales_15_numericchange" DOUBLE,
  "historicsales_15_percentagechange" DOUBLE,
  "historicsales_15_price" DOUBLE,
  "historicsales_16_date" TIMESTAMP,
  "historicsales_16_numericchange" DOUBLE,
  "historicsales_16_percentagechange" DOUBLE,
  "historicsales_16_price" DOUBLE,
  "historicsales_17_date" TIMESTAMP,
  "historicsales_17_numericchange" DOUBLE,
  "historicsales_17_percentagechange" DOUBLE,
  "historicsales_17_price" DOUBLE,
  "historicsales_18_date" TIMESTAMP,
  "historicsales_18_numericchange" DOUBLE
);