Property Sales:Melbourne City

Exploring the Melbourne Housing Market: A Comprehensive Dataset of Property Sale

@kaggle.amalab182_property_salesmelbourne_city

Table List

1 table(712.17 KB)

Property Sales Of Melbourne City

@kaggle.amalab182_property_salesmelbourne_city.property_sales_of_melbourne_city

712.17 KB
18396 rows
22 columns

unnamed_0 Unnamed: 0	suburb Suburb	address Address	rooms Rooms	type Type	price Price	method Method	sellerg SellerG	date Date	distance Distance	postcode Postcode	bedroom2 Bedroom2	bathroom Bathroom	car Car	landsize Landsize	buildingarea BuildingArea	yearbuilt YearBuilt	councilarea CouncilArea	lattitude Lattitude	longtitude Longtitude	regionname Regionname	propertycount Propertycount
1	Abbotsford	85 Turner St	2	h	1480000	S	Biggin	Sat Dec 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2.5	3067	2	1	1	202			Yarra	-37.7996	144.9984	Northern Metropolitan	4019
2	Abbotsford	25 Bloomburg St	2	h	1035000	S	Biggin	Thu Feb 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2.5	3067	2	1		156	79	1900	Yarra	-37.8079	144.9934	Northern Metropolitan	4019
4	Abbotsford	5 Charles St	3	h	1465000	SP	Biggin	Sat Mar 04 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2.5	3067	3	2		134	150	1900	Yarra	-37.8093	144.9944	Northern Metropolitan	4019
5	Abbotsford	40 Federation La	3	h	850000	PI	Biggin	Sat Mar 04 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2.5	3067	3	2	1	94			Yarra	-37.7969	144.9969	Northern Metropolitan	4019
6	Abbotsford	55a Park St	4	h	1600000	VB	Nelson	Sat Jun 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2.5	3067	3	1	2	120	142	2014	Yarra	-37.8072	144.9941	Northern Metropolitan	4019
10	Abbotsford	129 Charles St	2	h	941000	S	Jellis	Sat May 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2.5	3067	2	1		181			Yarra	-37.8041	144.9953	Northern Metropolitan	4019
11	Abbotsford	124 Yarra St	3	h	1876000	S	Nelson	Sat May 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2.5	3067	4	2		245	210	1910	Yarra	-37.8024	144.9993	Northern Metropolitan	4019
14	Abbotsford	98 Charles St	2	h	1636000	S	Nelson	Sat Oct 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2.5	3067	2	1	2	256	107	1890	Yarra	-37.806	144.9954	Northern Metropolitan	4019
15	Abbotsford	217 Langridge St	3	h	1000000	S	Jellis	Sat Oct 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2.5	3067							nan			Northern Metropolitan	4019
16	Abbotsford	18a Mollison St	2	t	745000	S	Jellis	Sat Oct 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2.5	3067							nan			Northern Metropolitan	4019


CREATE TABLE property_sales_of_melbourne_city (
  "unnamed_0" BIGINT,
  "suburb" VARCHAR,
  "address" VARCHAR,
  "rooms" BIGINT,
  "type" VARCHAR,
  "price" BIGINT,
  "method" VARCHAR,
  "sellerg" VARCHAR,
  "date" TIMESTAMP,
  "distance" DOUBLE,
  "postcode" DOUBLE,
  "bedroom2" DOUBLE,
  "bathroom" DOUBLE,
  "car" DOUBLE,
  "landsize" DOUBLE,
  "buildingarea" DOUBLE,
  "yearbuilt" DOUBLE,
  "councilarea" VARCHAR,
  "lattitude" DOUBLE,
  "longtitude" DOUBLE,
  "regionname" VARCHAR,
  "propertycount" DOUBLE
);