Baselight
Sign In

Spanish Housing Dataset: Location, Size, Price,

Now with 100% More Fun!

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and

Loading...
Loading...

About this Dataset

Spanish Housing Dataset: Location, Size, Price,

Spanish Housing Dataset: Location, Size, Price, and More!

Now with 100% More Fun!

By [source]

About this dataset

Looking for a place to live in Spain? This dataset contains information about houses in various Spanish provinces that will help you with your search! The data includes information about the houses such as location, size, price, amenities, and more. With this dataset, you can study the housing market in Spain, compare prices and styles of houses across different provinces, or learn more about the features of houses in different parts of the country. So whether you're looking for your dream home or just curious about Spanish real estate, this dataset is a great place to start!

More Datasets

For more datasets, click here.

Featured Notebooks

  • 🚨 Your notebook can be here! 🚨!

How to use the dataset

The Spanish Housing Dataset contains information about houses in various Spanish provinces. The data includes information about the houses such as location, size, price, amenities, and so on. This dataset can be used to study the housing market in Spain, to compare prices and styles of houses in different provinces, or to find out more about the features of houses in different parts of

Research Ideas

  • To study the housing market in Spain and compare prices and styles of houses in different provinces
  • To find out more about the features of houses in different parts of the country
  • To compare prices and styles of houses in different parts of the province

Acknowledgements

If you use this dataset in your research, please credit the original authors.

Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: addinfo.csv

Column name Description
poblacion The population of the city where the house is located. (Numeric)
source The source of the data. (Categorical)

File: links.csv

Column name Description
link The URL of the listing. (String)
num_link The listing's unique identifier. (String)
obtention_date The date on which the listing was collected. (String)

File: rentas_PV.csv

File: rentas_espanya.csv

Column name Description
Número de declaraciones The number of tax declarations. (Numeric)

File: zones.csv

Column name Description
type The type of the house. (Categorical)

File: houses_alava.csv

Column name Description
obtention_date The date on which the listing was collected. (String)
ad_description A description of the house. (String)
ad_last_update The date of the last update to the listing. (String)
air_conditioner A indicator of whether or not the house has air conditioning. (Boolean)
balcony A indicator of whether or not the house has a balcony. (Boolean)
bath_num The number of bathrooms in the house. (Integer)
built_in_wardrobe A indicator of whether or not the house has a built in wardrobe. (Boolean)
chimney A indicator of whether or not the house has a chimney. (Boolean)
construct_date The date the house was constructed. (String)
energetic_certif The energetic certification of the house. (String)
floor The floor on which the house is located. (Integer)
garage A indicator of whether or not the house has a garage. (Boolean)
garden A indicator of whether or not the house has a garden. (Boolean)
ground_size The size of the house in square meters. (Integer)
heating The type of heating in the house. (String)
house_type The type of house. (String)
kitchen A indicator of whether or not the house has a kitchen. (Boolean)
lift A indicator of whether or not the house has a lift. (Boolean)
loc_city The city in which the house is located. (String)
loc_district The district in which the house is located. (String)
loc_full The full address of the house. (String)
loc_neigh The neighborhood in which the house is located. (String)
loc_street The street on which the house is located. (String)
loc_zone The zone in which the house is located. (String)
m2_real
m2_useful The size of the house in square meters. (Integer)
orientation The orientation of the house. (String)
price The price of the house. (Integer)
reduced_mobility A indicator of whether or not the house is suitable for reduced mobility. (Boolean)
room_num The number of rooms in the house. (Integer)
storage_room A indicator of whether or not the house has a storage room. (Boolean)
swimming_pool A indicator of whether or not the house has a swimming pool. (Boolean)
terrace A indicator of whether or not the house has a terrace. (Boolean)

File: houses_albacete.csv

Column name Description
ad_description A description of the house. (String)
ad_last_update The date of the last update to the listing. (String)
air_conditioner A indicator of whether or not the house has air conditioning. (Boolean)
balcony A indicator of whether or not the house has a balcony. (Boolean)
bath_num The number of bathrooms in the house. (Integer)
built_in_wardrobe A indicator of whether or not the house has a built in wardrobe. (Boolean)
chimney A indicator of whether or not the house has a chimney. (Boolean)
construct_date The date the house was constructed. (String)
energetic_certif The energetic certification of the house. (String)
floor The floor on which the house is located. (Integer)
garage A indicator of whether or not the house has a garage. (Boolean)
garden A indicator of whether or not the house has a garden. (Boolean)
ground_size The size of the house in square meters. (Integer)
heating The type of heating in the house. (String)
house_type The type of house. (String)
kitchen A indicator of whether or not the house has a kitchen. (Boolean)
lift A indicator of whether or not the house has a lift. (Boolean)
loc_city The city in which the house is located. (String)
loc_district The district in which the house is located. (String)
loc_full The full address of the house. (String)
loc_neigh The neighborhood in which the house is located. (String)
loc_street The street on which the house is located. (String)
loc_zone The zone in which the house is located. (String)
m2_real
m2_useful The size of the house in square meters. (Integer)
obtention_date The date on which the listing was collected. (String)
orientation The orientation of the house. (String)
price The price of the house. (Integer)
reduced_mobility A indicator of whether or not the house is suitable for reduced mobility. (Boolean)
room_num The number of rooms in the house. (Integer)
storage_room A indicator of whether or not the house has a storage room. (Boolean)
swimming_pool A indicator of whether or not the house has a swimming pool. (Boolean)
terrace A indicator of whether or not the house has a terrace. (Boolean)

File: houses_alicante.csv

Column name Description
ad_description A description of the house. (String)
ad_last_update The date of the last update to the listing. (String)
air_conditioner A indicator of whether or not the house has air conditioning. (Boolean)
balcony A indicator of whether or not the house has a balcony. (Boolean)
bath_num The number of bathrooms in the house. (Integer)
built_in_wardrobe A indicator of whether or not the house has a built in wardrobe. (Boolean)
chimney A indicator of whether or not the house has a chimney. (Boolean)
construct_date The date the house was constructed. (String)
energetic_certif The energetic certification of the house. (String)
floor The floor on which the house is located. (Integer)
garage A indicator of whether or not the house has a garage. (Boolean)
garden A indicator of whether or not the house has a garden. (Boolean)
ground_size The size of the house in square meters. (Integer)
heating The type of heating in the house. (String)
house_type The type of house. (String)
kitchen A indicator of whether or not the house has a kitchen. (Boolean)
lift A indicator of whether or not the house has a lift. (Boolean)
loc_city The city in which the house is located. (String)
loc_district The district in which the house is located. (String)
loc_full The full address of the house. (String)
loc_neigh The neighborhood in which the house is located. (String)
loc_street The street on which the house is located. (String)
loc_zone The zone in which the house is located. (String)
m2_real
m2_useful The size of the house in square meters. (Integer)
obtention_date The date on which the listing was collected. (String)
orientation The orientation of the house. (String)
price The price of the house. (Integer)
reduced_mobility A indicator of whether or not the house is suitable for reduced mobility. (Boolean)
room_num The number of rooms in the house. (Integer)
storage_room A indicator of whether or not the house has a storage room. (Boolean)
swimming_pool A indicator of whether or not the house has a swimming pool. (Boolean)
terrace A indicator of whether or not the house has a terrace. (Boolean)

File: houses_balears.csv

Column name Description
ad_description A description of the house. (String)
ad_last_update The date of the last update to the listing. (String)
air_conditioner A indicator of whether or not the house has air conditioning. (Boolean)
balcony A indicator of whether or not the house has a balcony. (Boolean)
bath_num The number of bathrooms in the house. (Integer)
built_in_wardrobe A indicator of whether or not the house has a built in wardrobe. (Boolean)
chimney A indicator of whether or not the house has a chimney. (Boolean)
construct_date The date the house was constructed. (String)
energetic_certif The energetic certification of the house. (String)
floor The floor on which the house is located. (Integer)
garage A indicator of whether or not the house has a garage. (Boolean)
garden A indicator of whether or not the house has a garden. (Boolean)
ground_size The size of the house in square meters. (Integer)
heating The type of heating in the house. (String)
house_type The type of house. (String)
kitchen A indicator of whether or not the house has a kitchen. (Boolean)
lift A indicator of whether or not the house has a lift. (Boolean)
loc_city The city in which the house is located. (String)
loc_district The district in which the house is located. (String)
loc_full The full address of the house. (String)
loc_neigh The neighborhood in which the house is located. (String)
loc_street The street on which the house is located. (String)
loc_zone The zone in which the house is located. (String)
m2_real
m2_useful The size of the house in square meters. (Integer)
obtention_date The date on which the listing was collected. (String)
orientation The orientation of the house. (String)
price The price of the house. (Integer)
reduced_mobility A indicator of whether or not the house is suitable for reduced mobility. (Boolean)
room_num The number of rooms in the house. (Integer)
storage_room A indicator of whether or not the house has a storage room. (Boolean)
swimming_pool A indicator of whether or not the house has a swimming pool. (Boolean)
terrace A indicator of whether or not the house has a terrace. (Boolean)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Addinfo

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.addinfo
  • 4.42 KB
  • 106 rows
  • 3 columns
Loading... 

CREATE TABLE addinfo (
  "poblacion" VARCHAR,
  "source" VARCHAR,
  "valor" VARCHAR
);

Houses Alava

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_alava
  • 986.62 KB
  • 3806 rows
  • 36 columns
Loading... 

CREATE TABLE houses_alava (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" BIGINT,
  "balcony" BIGINT,
  "bath_num" VARCHAR,
  "built_in_wardrobe" BIGINT,
  "chimney" BIGINT,
  "condition" VARCHAR,
  "construct_date" DOUBLE,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" BIGINT,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" BIGINT,
  "house_type" VARCHAR,
  "kitchen" DOUBLE,
  "lift" DOUBLE,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" BIGINT,
  "m2_useful" DOUBLE,
  "obtention_date" TIMESTAMP,
  "orientation" VARCHAR,
  "price" BIGINT,
  "reduced_mobility" BIGINT,
  "room_num" VARCHAR,
  "storage_room" BIGINT,
  "swimming_pool" BIGINT,
  "terrace" BIGINT,
  "unfurnished" DOUBLE
);

Houses Albacete

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_albacete
  • 978.18 KB
  • 4469 rows
  • 36 columns
Loading... 

CREATE TABLE houses_albacete (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Alicante

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_alicante
  • 433.12 KB
  • 1946 rows
  • 36 columns
Loading... 

CREATE TABLE houses_alicante (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Balears

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_balears
  • 10.26 MB
  • 24880 rows
  • 36 columns
Loading... 

CREATE TABLE houses_balears (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Barcelona

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_barcelona
  • 239.76 KB
  • 885 rows
  • 36 columns
Loading... 

CREATE TABLE houses_barcelona (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" BIGINT,
  "balcony" BIGINT,
  "bath_num" VARCHAR,
  "built_in_wardrobe" BIGINT,
  "chimney" BIGINT,
  "condition" VARCHAR,
  "construct_date" DOUBLE,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" BIGINT,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" BIGINT,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" DOUBLE,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" BIGINT,
  "m2_useful" DOUBLE,
  "obtention_date" TIMESTAMP,
  "orientation" VARCHAR,
  "price" BIGINT,
  "reduced_mobility" BIGINT,
  "room_num" VARCHAR,
  "storage_room" BIGINT,
  "swimming_pool" BIGINT,
  "terrace" BIGINT,
  "unfurnished" VARCHAR
);

Houses Bizkaia

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_bizkaia
  • 6.55 MB
  • 23197 rows
  • 36 columns
Loading... 

CREATE TABLE houses_bizkaia (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" BIGINT,
  "balcony" BIGINT,
  "bath_num" VARCHAR,
  "built_in_wardrobe" BIGINT,
  "chimney" BIGINT,
  "condition" VARCHAR,
  "construct_date" DOUBLE,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" BIGINT,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" BIGINT,
  "house_type" VARCHAR,
  "kitchen" DOUBLE,
  "lift" DOUBLE,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" BIGINT,
  "m2_useful" DOUBLE,
  "obtention_date" TIMESTAMP,
  "orientation" VARCHAR,
  "price" BIGINT,
  "reduced_mobility" BIGINT,
  "room_num" VARCHAR,
  "storage_room" BIGINT,
  "swimming_pool" BIGINT,
  "terrace" BIGINT,
  "unfurnished" DOUBLE
);

Houses Cadiz

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_cadiz
  • 126.94 KB
  • 787 rows
  • 36 columns
Loading... 

CREATE TABLE houses_cadiz (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" BIGINT,
  "balcony" BIGINT,
  "bath_num" VARCHAR,
  "built_in_wardrobe" BIGINT,
  "chimney" BIGINT,
  "condition" VARCHAR,
  "construct_date" DOUBLE,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" BIGINT,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" BIGINT,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" DOUBLE,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" BIGINT,
  "m2_useful" DOUBLE,
  "obtention_date" TIMESTAMP,
  "orientation" VARCHAR,
  "price" BIGINT,
  "reduced_mobility" BIGINT,
  "room_num" VARCHAR,
  "storage_room" BIGINT,
  "swimming_pool" BIGINT,
  "terrace" BIGINT,
  "unfurnished" VARCHAR
);

Houses Ciudad Real

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_ciudad_real
  • 452.45 KB
  • 1819 rows
  • 36 columns
Loading... 

CREATE TABLE houses_ciudad_real (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Coruna

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_coruna
  • 2.58 MB
  • 8341 rows
  • 36 columns
Loading... 

CREATE TABLE houses_coruna (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Gipuzkoa

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_gipuzkoa
  • 2.4 MB
  • 7705 rows
  • 36 columns
Loading... 

CREATE TABLE houses_gipuzkoa (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Girona

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_girona
  • 503.83 KB
  • 1811 rows
  • 36 columns
Loading... 

CREATE TABLE houses_girona (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Huelva

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_huelva
  • 151.87 KB
  • 658 rows
  • 36 columns
Loading... 

CREATE TABLE houses_huelva (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Madrid

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_madrid
  • 2.35 MB
  • 5255 rows
  • 36 columns
Loading... 

CREATE TABLE houses_madrid (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Santa Cruz De Tenerife

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_santa_cruz_de_tenerife
  • 600.05 KB
  • 1222 rows
  • 36 columns
Loading... 

CREATE TABLE houses_santa_cruz_de_tenerife (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Segovia

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_segovia
  • 527.29 KB
  • 1529 rows
  • 36 columns
Loading... 

CREATE TABLE houses_segovia (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Sevilla

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_sevilla
  • 978.65 KB
  • 2867 rows
  • 36 columns
Loading... 

CREATE TABLE houses_sevilla (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Soria

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_soria
  • 372.31 KB
  • 1373 rows
  • 36 columns
Loading... 

CREATE TABLE houses_soria (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Valencia

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_valencia
  • 466.84 KB
  • 1404 rows
  • 36 columns
Loading... 

CREATE TABLE houses_valencia (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Valladolid

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_valladolid
  • 887.46 KB
  • 2652 rows
  • 36 columns
Loading... 

CREATE TABLE houses_valladolid (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Houses Zamora

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.houses_zamora
  • 715.05 KB
  • 3394 rows
  • 36 columns
Loading... 

CREATE TABLE houses_zamora (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR
);

Links

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.links
  • 52.69 KB
  • 2477 rows
  • 4 columns
Loading... 

CREATE TABLE links (
  "link" VARCHAR,
  "num_link" BIGINT,
  "obtention_date" TIMESTAMP,
  "province" VARCHAR
);

Rentas Espanya

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.rentas_espanya
  • 12.29 KB
  • 33 rows
  • 10 columns
Loading... 

CREATE TABLE rentas_espanya (
  "unnamed_0" VARCHAR,
  "n_mero_de_declaraciones" VARCHAR,
  "renta_bruta_media" DOUBLE,
  "renta_disponible_media" DOUBLE,
  "rentas_del_trabajo" VARCHAR,
  "rentas_exentas" VARCHAR,
  "renta_bruta" VARCHAR,
  "cotizaciones_sociales_a_la_ss" VARCHAR,
  "cuota_resultante_de_autoliquidaci_n" VARCHAR,
  "renta_disponible" VARCHAR
);

Rentas Pv

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.rentas_pv
  • 17.56 KB
  • 1925 rows
  • 4 columns
Loading... 

CREATE TABLE rentas_pv (
  "ambitos_territoriales" VARCHAR,
  "tipo_de_renta" VARCHAR,
  "sexo" VARCHAR,
  "n_2016" BIGINT
);

Spanish Houses

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.spanish_houses
  • 32.24 MB
  • 100000 rows
  • 41 columns
Loading... 

CREATE TABLE spanish_houses (
  "ad_description" VARCHAR,
  "ad_last_update" VARCHAR,
  "air_conditioner" VARCHAR,
  "balcony" VARCHAR,
  "bath_num" VARCHAR,
  "built_in_wardrobe" VARCHAR,
  "chimney" VARCHAR,
  "condition" VARCHAR,
  "construct_date" VARCHAR,
  "energetic_certif" VARCHAR,
  "floor" VARCHAR,
  "garage" VARCHAR,
  "garden" VARCHAR,
  "ground_size" VARCHAR,
  "heating" VARCHAR,
  "house_id" VARCHAR,
  "house_type" VARCHAR,
  "kitchen" VARCHAR,
  "lift" VARCHAR,
  "loc_city" VARCHAR,
  "loc_district" VARCHAR,
  "loc_full" VARCHAR,
  "loc_neigh" VARCHAR,
  "loc_street" VARCHAR,
  "loc_zone" VARCHAR,
  "m2_real" VARCHAR,
  "m2_useful" VARCHAR,
  "obtention_date" VARCHAR,
  "orientation" VARCHAR,
  "price" VARCHAR,
  "reduced_mobility" VARCHAR,
  "room_num" VARCHAR,
  "storage_room" VARCHAR,
  "swimming_pool" VARCHAR,
  "terrace" VARCHAR,
  "unfurnished" VARCHAR,
  "number_of_companies_prov" BIGINT,
  "population_prov" BIGINT,
  "companies_prov_vs_national" DOUBLE,
  "population_prov_vs_national" DOUBLE,
  "renta_media_prov" DOUBLE
);

Zones

@kaggle.thedevastator_spanish_housing_dataset_location_size_price_and.zones
  • 3.51 KB
  • 110 rows
  • 2 columns
Loading... 

CREATE TABLE zones (
  "type" VARCHAR,
  "zone" VARCHAR
);

Share link

Anyone who has the link will be able to view this.