London UK Airbnb Open Data

Airbnb listings and metrics in London UK 2022

@kaggle.whenamancodes_london_uk_airbnb_open_data

Table List

1 table(3.97 MB)

Listingss

@kaggle.whenamancodes_london_uk_airbnb_open_data.listingss

3.97 MB
69351 rows
18 columns

id Id	name Name	host_id Host Id	host_name Host Name	neighbourhood Neighbourhood	latitude Latitude	longitude Longitude	room_type Room Type	price Price	minimum_nights Minimum Nights	number_of_reviews Number Of Reviews	last_review Last Review	reviews_per_month Reviews Per Month	calculated_host_listings_count Calculated Host Listings Count	availability_365 Availability 365	number_of_reviews_ltm Number Of Reviews Ltm
106332	Lovely large room, Bethnal Green	264345	Susie	Tower Hamlets	51.52874	-0.05396	Private room	55	3	65	Fri Jun 10 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	0.47	1	74
13913	Holiday London DB Room Let-on going	54730	Alina	Islington	51.56861	-0.1127	Private room	50	1	30	Fri Jul 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.2	2	343	9
284532	COSY STUDIO-FLAT WITH A GREAT VIEW	1481412	Luca	Tower Hamlets	51.52851	-0.07426	Entire home/apt	90	5	42	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.34	1	222	1
107048	A Luxury Studio Suite in Clerkenwell	259088	Simon	Islington	51.52478	-0.10484	Private room	180	4	493	Fri Sep 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3.59	5	236	20
284603	Notting Hill church stay in Heaven!	1481851	Tania	Kensington and Chelsea	51.51464	-0.20004	Entire home/apt	297	14	6	Mon Jul 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.05	1	180	2
15400	Bright Chelsea Apartment. Chelsea!	60302	Philippa	Kensington and Chelsea	51.4878	-0.16813	Entire home/apt	75	3	89	Mon Mar 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	0.57	1	70
107051	JESSIE the narrowboat in Little Venice	554519	Meg	Westminster	51.52055	-0.18317	Entire home/apt	204	2	581	Fri Sep 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	4.26	1	193	66
17402	Superb 3-Bed/2 Bath & Wifi: Trendy W1	67564	Liz	Westminster	51.52195	-0.14094	Entire home/apt	379	4	51	Tue Sep 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.36	5	249	8
286675	APARTMENT IN NORTH WEST LONDON	1491611	Nora	Harrow	51.57982	-0.37539	Entire home/apt	90	3	104	Mon Aug 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.86	1	318	4
116268	DOUBLE ROOM NEAR CENTRAL LONDON	586671	Joe	Enfield	51.61137	-0.11888	Private room	30	7	32	Thu Sep 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.29	1	251	4


CREATE TABLE listingss (
  "id" BIGINT,
  "name" VARCHAR,
  "host_id" BIGINT,
  "host_name" VARCHAR,
  "neighbourhood_group" VARCHAR,
  "neighbourhood" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "room_type" VARCHAR,
  "price" BIGINT,
  "minimum_nights" BIGINT,
  "number_of_reviews" BIGINT,
  "last_review" TIMESTAMP,
  "reviews_per_month" DOUBLE,
  "calculated_host_listings_count" BIGINT,
  "availability_365" BIGINT,
  "number_of_reviews_ltm" BIGINT,
  "license" VARCHAR
);