Inside AirBnB - Belgium

Data and advocacy about Airbnb's impact on residential communities.

@kaggle.konradb_inside_airbnb_belgium

Table List

6 tables(15.25 MB)

Reviews

Listings

@kaggle.konradb_inside_airbnb_belgium.listings

171.96 KB
2441 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
50904	aplace/antwerp: cosy suite - fashion district	234077	Karin	Historisch Centrum	51.218575	4.398631	Hotel room	179	2	3	Sun May 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.03	4	237	1
116134	Spacious apartment nearby Mas	586942	Gina	Eilandje	51.23051	4.40593	Entire home/apt	180	2	147	Sun Feb 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	1.09	1	9	25
224682	APARTMENT ROSCAM - OLD CENTRE ANTWERP	1263933	Kristien	Sint-Andries	51.21722	4.3979	Entire home/apt	125	2	471	Tue Mar 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	3.48	1	310	95
345959	Marleen's home in Antwerp city	1754396	Marleen	Markgrave	51.19935	4.40154	Entire home/apt	65	3	84	Sun Dec 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.63	1	272	13
366252	ROOM IN FAMILY HOME near C. Station	1820186	Godelieve	Borgerhout Intra Muros Noord	51.21601	4.43432	Private room	39	1	135	Sun Mar 19 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	1.01	4	348	22
522693	Ahome Awayfromhome	2562294	Ahome	Historisch Centrum	51.22001	4.39813	Entire home/apt	282	2	2	Fri Oct 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	0.02	1	365
603545	Perfect for a Longer Stay \| Trendy \| City center	2987880	Cédric	Harmonie	51.20753	4.40589	Entire home/apt	100	2	27	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	0.22	1	346	2
636664	sunny rooftop apartment, sleeps 2-5	462975	Els	Borgerhout Intra Muros Zuid	51.21618	4.43037	Entire home/apt	130	2	111	Mon Mar 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	0.86	1	343	15
772842	Loft style designers place with beautiful views	4050173	Daisy	Linkeroever	51.21775	4.38434	Entire home/apt	148	2	75	Sun Mar 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	0.6	1	269	5
778043	cosy & beautiful apartment Antwerp	1735092	Marc & Elizabeth	Stadspark	51.20399	4.41249	Entire home/apt	84	2	81	Fri Sep 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.65	1	244	4


CREATE TABLE listings (
  "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
);