Apartment Prices In Poland
Pricing of apartments in 15 largest polish cities
@kaggle.krzysztofjamroz_apartment_prices_in_poland
Pricing of apartments in 15 largest polish cities
@kaggle.krzysztofjamroz_apartment_prices_in_poland
The dataset contains apartment sales and rent offers from the 15 largest cities in Poland (Warsaw, Lodz, Krakow, Wroclaw, Poznan, Gdansk, Szczecin, Bydgoszcz, Lublin, Katowice, Bialystok, Czestochowa). The data comes from local websites with apartments for sale. To fully capture the neighborhood of each apartment better, each offer was extended by data from the Open Street Map with distances to points of interest (POI). The data is collected monthly and covers a timespan between August 2023 and June 2024
apartments_pl_YYYY_MM.csv - monthly snapshot of sell offersapartments_rent_pl_YYYY_MM.csv - a monthly snapshot of rent offerscity - the name of the city where the property is locatedtype - type of the buildingsquareMeters - the size of the apartment in square metersrooms - number of rooms in the apartmentfloor / floorCount - the floor where the apartment is located and the total number of floors in the buildingbuildYear - the year when the building was builtlatitude, longitude - geo coordinate of the propertycentreDistance - distance from the city centre in kmpoiCount - number of points of interest in 500m range from the apartment (schools, clinics, post offices, kindergartens, restaurants, colleges, pharmacies)[poiName]Distance - distance to the nearest point of interest (schools, clinics, post offices, kindergartens, restaurants, colleges, pharmacies)ownership - the type of property ownershipcondition - the condition of the apartmenthas[features] - whether the property has key features such as assigned parking space, balcony, elevator, security, storage roomprice - offer price in Polish Zlotyapartments_pl_YYYY_MM.csv: sale priceapartments_rent_pl_YYYY_MM.csv: monthly rentCREATE TABLE apartments_pl_2023_08 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_pl_2023_09 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_pl_2023_10 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_pl_2023_11 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_pl_2023_12 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_pl_2024_01 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_pl_2024_02 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_pl_2024_03 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_pl_2024_04 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_pl_2024_05 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_pl_2024_06 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_rent_pl_2023_11 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_rent_pl_2023_12 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_rent_pl_2024_01 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_rent_pl_2024_02 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_rent_pl_2024_03 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_rent_pl_2024_04 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_rent_pl_2024_05 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);CREATE TABLE apartments_rent_pl_2024_06 (
"id" VARCHAR,
"city" VARCHAR,
"type" VARCHAR,
"squaremeters" DOUBLE,
"rooms" DOUBLE,
"floor" DOUBLE,
"floorcount" DOUBLE,
"buildyear" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"centredistance" DOUBLE,
"poicount" DOUBLE,
"schooldistance" DOUBLE,
"clinicdistance" DOUBLE,
"postofficedistance" DOUBLE,
"kindergartendistance" DOUBLE,
"restaurantdistance" DOUBLE,
"collegedistance" DOUBLE,
"pharmacydistance" DOUBLE,
"ownership" VARCHAR,
"buildingmaterial" VARCHAR,
"condition" VARCHAR,
"hasparkingspace" VARCHAR,
"hasbalcony" VARCHAR,
"haselevator" VARCHAR,
"hassecurity" VARCHAR,
"hasstorageroom" VARCHAR,
"price" BIGINT
);Anyone who has the link will be able to view this.