Sale prices of residential property in Madrid in 2018.
Madrid_Sale.RdA dataset containing information about 156,016 real estate listings on idealista in Madrid during 2018.
Usage
data(Madrid_Sale)
Madrid_SaleFormat
An object of class `sf` (inherits from `data.frame`) with 156,016 rows and 57 variables:
- ASSETID
Unique identifier of the asset
- PERIOD
Date YYYYMM, indicates the quarter when the ad was extracted we used YYYY03 for the 1st Q, YYYY06 the 2nd, YYYY09 for the 3rd and YYYY12 for the 4th
- PRICE
Price at idealista expressed in euros
- UNITPRICE
Price in euros per square meter
- CONSTRUCTEDAREA
Home built area in sq.m
- ROOMNUMBER
Number of bedrooms
- BATHNUMBER
Number of bathrooms
- HASTERRACE
Dummy variable for terrace (takes 1 if there is a terrace, 0 otherwise)
- HASLIFT
Dummy variable for lift (takes 1 if there is a lift in the building, 0 otherwise)
- HASAIRCONDITIONING
Dummy variable for AA (takes 1 if there is a AA, 0 otherwise)
- AMENITYID
Indicates the amenities included (1 - no furniture, no kitchen amenities, 2 - kitchen amenities, no furniture, 3 - kitchen amenities, furniture)
- HASPARKINGSPACE
Dummy variable for parking (takes 1 if parking is included in the Ad, 0 otherwise)
- ISPARKINGSPACEINCLUDEDINPRICE
Dummy variable for parking (takes 1 if parking is included in the Ad, 0 otherwise)
- PARKINGSPACEPRICE
Price of parking Space in euros
- HASNORTHORIENTATION
Dummy variable for orientation (takes 1 if orientation is North in the Ad, 0 otherwise) - Important note: orientation features are not orthogonal features, a house oriented to the north can be also oriented to the east
- HASSOUTHORIENTATION
Dummy variable for orientation (takes 1 if orientation is South in the Ad, 0 otherwise) - Important note: orientation features are not orthogonal features, a house oriented to the north can be also oriented to the east
- HASEASTORIENTATION
Dummy variable for orientation (takes 1 if orientation is East in the Ad, 0 otherwise) - Important note: orientation features are not orthogonal features, a house oriented to the north can be also oriented to the east
- HASWESTORIENTATION
Dummy variable for orientation (takes 1 if orientation is West in the Ad, 0 otherwise) - Important note: orientation features are not orthogonal features, a house oriented to the north can be also oriented to the east
- HASBOXROOM
Dummy variable for boxroom (takes 1 if boxroom is included in the Ad, 0 otherwise)
- HASWARDROBE
Dummy variable for wardrobe (takes 1 if wardrobe is included in the Ad, 0 otherwise)
- HASSWIMMINGPOOL
Dummy variable for swimming pool (takes 1 if swimming pool is included in the Ad, 0 otherwise)
- HASDOORMAN
Dummy variable for doorman (takes 1 if there is a doorman in the building, 0 otherwise)
- HASGARDEN
Dummy variable for garden (takes 1 if there is a garden in the building, 0 otherwise)
- ISDUPLEX
Dummy variable for duplex (takes 1 if it is a duplex, 0 otherwise)
- ISSTUDIO
Dummy variable for bachelor apartment (studio in Spanish) (takes 1 if it is a single-person apartment, 0 otherwise)
- ISINTOPFLOOR
Dummy variable indicating if the apartment is located in the top floor (takes 1 on the top floor 0 otherwise)
- CONSTRUCTIONYEAR
Construction year (source: advertiser)
- FLOORCLEAN
Indicates flat floornumber starting from the 0 value for groung floor (source: advertiser)
- FLATLOCATIONID
Indicates the kind of views the flat has (1 - external, 2 - internal)
- CADCONSTRUCTIONYEAR
Construction year as of cadastral source (source: cadastre), note this figure can differ from the one given by the advertiser
- CADMAXBUILDINGFLOOR
Max building floor (source: cadastre)
- CADDWELLINGCOUNT
Dwelling count in the building (source: cadastre)
- CADASTRALQUALITYID
Cadastral quality (source: cadastre)
- BUILTTYPEID_1
Dummy value for flat condition: 1 new development 0 otherwise (source: advertiser))
- BUILTTYPEID_2
Dummy value for flat condition: 1 second hand to be restored 0 otherwise (source: advertiser))
- BUILTTYPEID_3
Dummy value for flat condition: 1 second hand in good condition 0 otherwise (source: advertiser))
#'
- DISTANCE_TO_CITY_CENTER
Distance to center of city in km
- DISTANCE_TO_CASTELLANA
Distance to Paseo de la Castellana in km; la Castellana is a major street that cuts across the city from South to North
- geometry
geometry of simple features
An object of class sf (inherits from data.frame) with 94815 rows and 42 columns.
Examples
library(idealista18)
data(Madrid_Sale)
summary(Madrid_Sale$PRICE)
#> Min. 1st Qu. Median Mean 3rd Qu. Max.
#> 21000 160000 262000 396110 467000 8133000