Property Sales England Datasetš”: Zoopla (2023/24)
Recent Zoopla Property Sales from England
@kaggle.kanchana1990_property_sales_uk_dataset_zoopla_2023_2024
Recent Zoopla Property Sales from England
@kaggle.kanchana1990_property_sales_uk_dataset_zoopla_2023_2024
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
);
Anyone who has the link will be able to view this.