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

Recent Zoopla Property Sales from England

@kaggle.kanchana1990_property_sales_uk_dataset_zoopla_2023_2024

Table List

1 table(692.91 KB)

Zp1

@kaggle.kanchana1990_property_sales_uk_dataset_zoopla_2023_2024.zp1

692.91 KB
1000 rows
629 columns
Only the first 100 columns are shown

bathrooms Bathrooms	bedrooms Bedrooms	country Country	currentenergyrating CurrentEnergyRating	floorareasqm FloorAreaSqM	fulladdress FullAddress	historiclistings_0_date HistoricListings/0/date	historiclistings_0_price HistoricListings/0/price	historiclistings_1_date HistoricListings/1/date	historiclistings_1_price HistoricListings/1/price	historiclistings_2_date HistoricListings/2/date	historiclistings_2_price HistoricListings/2/price	historicsales_0_date HistoricSales/0/date	historicsales_0_numericchange HistoricSales/0/numericChange	historicsales_0_percentagechange HistoricSales/0/percentageChange	historicsales_0_price HistoricSales/0/price	historicsales_1_date HistoricSales/1/date	historicsales_1_numericchange HistoricSales/1/numericChange	historicsales_1_percentagechange HistoricSales/1/percentageChange	historicsales_1_price HistoricSales/1/price	historicsales_2_date HistoricSales/2/date	historicsales_2_numericchange HistoricSales/2/numericChange	historicsales_2_percentagechange HistoricSales/2/percentageChange	historicsales_2_price HistoricSales/2/price	historicsales_3_date HistoricSales/3/date	historicsales_3_price HistoricSales/3/price
	2	England	nan		22 Rushmere House, Fontley Way, London, SW15 4LZ							Wed Dec 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	131000	335.8974358974359	170000	Fri May 29 1998 00:00:00 GMT+0000 (Coordinated Universal Time)			39000
1	3	England	nan		18 Baxter Close, Uxbridge, UB10 0DE							Wed Dec 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	467000	326.57342657342656	610000	Mon Jul 05 1999 00:00:00 GMT+0000 (Coordinated Universal Time)			143000
		England	B	77	Flat 29, Somerset Place, 10 Brixton Hill, London, SW2 1EG							Wed Dec 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	60000	10	660000	Tue Mar 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)			600000
	4	England	nan	139	196 Brampton Road, Bexleyheath, DA7 4SY							Wed Dec 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	41000	15.24163568773234	310000	Wed Mar 08 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	4000	1.509433962264151	269000	Fri Oct 24 2003 00:00:00 GMT+0000 (Coordinated Universal Time)			265000
2	3	England	D	103	110 Augustus Road, London, SW19 6ER	Tue Feb 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	650000	Tue Sep 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	699950			Wed Dec 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	177000	47.45308310991957	550000	Wed Nov 15 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	83000	28.620689655172416	373000	Tue Nov 04 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	40000	16	290000	Mon Jan 15 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	250000
2	3	England	nan	102	97 Whittington Avenue, Hayes, UB4 0AE	Fri Jan 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	30000	Thu Jul 13 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	450000	Mon Jan 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	475000	Thu Dec 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	277050	208.3866115080857	410000	Wed Jun 28 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			132950
1	3	England	D	93	62 Hamilton Road, London, N2 0SW	Wed Nov 22 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	675000					Thu Dec 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	436500	173.90438247011951	687500	Mon Oct 25 2004 00:00:00 GMT+0000 (Coordinated Universal Time)			251000
		England	B	85	Flat 1308, Bagshaw Building, 1 Wards Place, London, E14 9DA							Thu Dec 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	-24800	-2.935606060606061	820000	Wed Nov 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)			844800
2	3	England	D	118	44A Church Street, Twickenham, TW1 3NR							Thu Dec 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	-519000	-74.2489270386266	180000	Thu Jan 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	124000	21.565217391304348	699000	Fri Sep 05 2014 00:00:00 GMT+0000 (Coordinated Universal Time)			575000
2	4	England	D	109	10 Meadfield, Edgware, HA8 8XW	Wed Aug 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	550000	Sun Sep 30 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	299000	Sun Sep 30 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	299000	Thu Dec 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	250000	86.20689655172413	540000	Fri Aug 06 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	53000	22.36286919831224	290000	Fri Jun 27 2003 00:00:00 GMT+0000 (Coordinated Universal Time)			237000


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
);