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
CREATE 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.