Georefrenced Spain Housing

Detailed information on around 180,000 houses in Madrid, Barcelona and Valencia

@kaggle.tomstravis_georefrenced_spain_housing

Table List

6 tables(15.09 MB)

Madrid Sale

@kaggle.tomstravis_georefrenced_spain_housing.madrid_sale

7.63 MB
94815 rows
41 columns

assetid ASSETID	period PERIOD	price PRICE	unitprice UNITPRICE	constructedarea CONSTRUCTEDAREA	roomnumber ROOMNUMBER	bathnumber BATHNUMBER	hasterrace HASTERRACE	haslift HASLIFT	hasairconditioning HASAIRCONDITIONING	amenityid AMENITYID	hasparkingspace HASPARKINGSPACE	isparkingspaceincludedinprice ISPARKINGSPACEINCLUDEDINPRICE	parkingspaceprice PARKINGSPACEPRICE	hasnorthorientation HASNORTHORIENTATION	hassouthorientation HASSOUTHORIENTATION	haseastorientation HASEASTORIENTATION	haswestorientation HASWESTORIENTATION	hasboxroom HASBOXROOM	haswardrobe HASWARDROBE	hasswimmingpool HASSWIMMINGPOOL	hasdoorman HASDOORMAN	hasgarden HASGARDEN	isstudio ISSTUDIO	constructionyear CONSTRUCTIONYEAR	floorclean FLOORCLEAN	flatlocationid FLATLOCATIONID	cadconstructionyear CADCONSTRUCTIONYEAR	cadmaxbuildingfloor CADMAXBUILDINGFLOOR	caddwellingcount CADDWELLINGCOUNT	cadastralqualityid CADASTRALQUALITYID	builttypeid_2 BUILTTYPEID 2	builttypeid_3 BUILTTYPEID 3	distance_to_city_center DISTANCE TO CITY CENTER	distance_to_metro DISTANCE TO METRO	distance_to_castellana DISTANCE TO CASTELLANA	longitude LONGITUDE	latitude LATITUDE
A15019136831406238029	201803	126000	2680.85106382979	47	1	1		1	1	3			1					1	1	1	1	1		2005	1	1	2005	7	319	3	1		8.05842930382943	0.872074570635774	6.86867674837114	-3.76693282740492	40.3624847687389
A6677225905472065344	201803	235000	4351.85185185185	54	1	1				3			1						1						1	2	1900	5	11	3		1	0.876369328603725	0.116382135656689	1.54412483623946	-3.71072465730388	40.4224298907482
A13341979748618524775	201803	373000	4973.33333333333	75	2	1			1	3			1		1			1	1						3	1	1915	6	26	3		1	0.907479301492356	0.13910883332602	1.60844405383313	-3.711570866261	40.4221904507903
A4775182175615276542	201803	284000	5916.66666666667	48	1	1		1	1	3			1												1	2	1947	9	15	5		1	0.845462206506526	0.144298951314765	1.51616582062852	-3.71043986942694	40.4222514604856
A2492087730711701973	201803	228000	4560	50		1				3			1										1	1930		1	1930	5	19	7		1	1.25023128196269	0.337098240935828	1.7941363317581	-3.71434022421324	40.4087408924555
A18372428154681111419	201803	498000	3921.25984251969	127	3	2		1		3			1												3	1	1900	5	18	3	1		0.541772705541838	0.161436288874913	1.16812585255795	-3.70752185145011	40.4126386908556
A4705946410795464036	201803	225000	6428.57142857143	35		1		1		3			1										1		2	2	1942	6	15	3		1	0.859565204741198	0.126994527122258	1.51743701997353	-3.71039480572019	40.4224499360928
A8243762537477781718	201803	365000	3650	100	2	1	1	1		3			1								1				4	1	1960	6	26	6		1	1.34611525711211	0.263445178087304	1.76292171310271	-3.71412579045626	40.4074088773041
A9587449507628658013	201803	425000	6071.42857142857	70	1	1		1		1	1	1	1				1							1900	2	1	1900	5	16	1		1	0.753574573731844	0.437190556099461	1.54831025544978	-3.71238952690619	40.4148700711265
A3694300518337702967	201803	3187000	8852.77777777778	360	4	3	1	1	1	3	1	1	1	1	1	1	1	1	1		1				9	1	1972	7	15	3		1	0.779228478003283	0.312615658883269	1.60946587969881	-3.71294489805374	40.4172360255127


CREATE TABLE madrid_sale (
  "assetid" VARCHAR,
  "period" BIGINT,
  "price" DOUBLE,
  "unitprice" DOUBLE,
  "constructedarea" BIGINT,
  "roomnumber" BIGINT,
  "bathnumber" BIGINT,
  "hasterrace" BIGINT,
  "haslift" BIGINT,
  "hasairconditioning" BIGINT,
  "amenityid" BIGINT,
  "hasparkingspace" BIGINT,
  "isparkingspaceincludedinprice" BIGINT,
  "parkingspaceprice" BIGINT,
  "hasnorthorientation" BIGINT,
  "hassouthorientation" BIGINT,
  "haseastorientation" BIGINT,
  "haswestorientation" BIGINT,
  "hasboxroom" BIGINT,
  "haswardrobe" BIGINT,
  "hasswimmingpool" BIGINT,
  "hasdoorman" BIGINT,
  "hasgarden" BIGINT,
  "isduplex" BIGINT,
  "isstudio" BIGINT,
  "isintopfloor" BIGINT,
  "constructionyear" DOUBLE,
  "floorclean" DOUBLE,
  "flatlocationid" DOUBLE,
  "cadconstructionyear" BIGINT,
  "cadmaxbuildingfloor" BIGINT,
  "caddwellingcount" BIGINT,
  "cadastralqualityid" DOUBLE,
  "builttypeid_1" BIGINT,
  "builttypeid_2" BIGINT,
  "builttypeid_3" BIGINT,
  "distance_to_city_center" DOUBLE,
  "distance_to_metro" DOUBLE,
  "distance_to_castellana" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);