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)

Barcelona Sale

@kaggle.tomstravis_georefrenced_spain_housing.barcelona_sale

4.79 MB
61486 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	parkingspaceprice PARKINGSPACEPRICE	haseastorientation HASEASTORIENTATION	haswestorientation HASWESTORIENTATION	hasboxroom HASBOXROOM	haswardrobe HASWARDROBE	hasdoorman HASDOORMAN	hasgarden HASGARDEN	isduplex ISDUPLEX	isintopfloor ISINTOPFLOOR	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_diagonal DISTANCE TO DIAGONAL	longitude LONGITUDE	latitude LATITUDE
A11898131848556022319	201803	323000	3845.2380952381	84	4	1	1	1	1	3	1									1972	4	1	1972	9	13	4		1	1.87628963169325	0.354004481386202	1.47526404365988	2.14956619166374	41.3800265682207
A18099432772155664747	201803	217000	2583.33333333333	84	3	2		1	1	3	1						1	1				1	1930	4	11	4		1	2.11859542698165	0.284371502480583	1.19426135130306	2.14568874106743	41.381631973155
A2003099089407882787	201803	114000	1407.40740740741	81	2	1		1	1	3	1			1						1940		1	1940	5	11	5	1		4.12709897162273	0.261573987773516	2.50498202855588	2.17389124058542	41.4239294816682
A1010373782315301134	201803	378000	4784.81012658228	79	2	1		1		3	1									2016	2	1	2016	10	32	3		1	2.23811318263384	0.158526790068569	0.795605451277823	2.14337871391529	41.384922607889
A12978912200216838006	201803	434000	3909.90990990991	111	4	2	1	1	1	3	1									1970	2		1970	8	60	2		1	2.33306609286668	0.101568176661845	1.20026507064684	2.14323019628654	41.3810759548507
A10446606541222668172	201803	298000	3204.30107526882	93	2	2	1	1	1	3	1		1	1	1	1			1	1997	5	1	1997	6	19	3		1	1.96724286570794	0.150534869126472	0.73833358261821	2.14649968525014	41.3862952032645
A18346635821534899934	201803	228000	3931.03448275862	58	3	1	1	1		3	1										5	1	1930	5	12	4		1	1.94204712873796	0.312577703478529	1.40530757440285	2.1485169054037	41.380361743505
A4447810556012248308	201803	888000	5842.1052631579	152	4	2	1	1		3	1									1940	8		1940	9	22	3		1	1.06226687777258	0.377037247526191	1.06127885513554	2.15738815958399	41.3859684419439
A7871597847739838783	201803	291000	3637.5	80	3	2		1		3	1	1									1	1	1966	10	27	3	1		1.67188454794392	0.0641202263000488	0.554998319402156	2.15022632019791	41.389126034387
A2742411997661424963	201803	786000	5240	150	3	2		1		3	1										3	1	1940	6	24	3		1	0.798844638647308	0.194565039854956	1.29224743496845	2.16095832239192	41.3847095714378


CREATE TABLE barcelona_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" DOUBLE,
  "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" BIGINT,
  "builttypeid_1" BIGINT,
  "builttypeid_2" BIGINT,
  "builttypeid_3" BIGINT,
  "distance_to_city_center" DOUBLE,
  "distance_to_metro" DOUBLE,
  "distance_to_diagonal" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);