Inside AirBnB - Netherlands

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

@kaggle.konradb_inside_airbnb_netherlands

Table List

6 tables(67.86 MB)

Reviews

Listings

@kaggle.konradb_inside_airbnb_netherlands.listings

594.37 KB
6998 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	license License
2818	Quiet Garden View Room & Super Fast Wi-Fi	3159	Daniel	Oostelijk Havengebied - Indische Buurt	52.36435	4.94358	Private room	69	3	322	Tue Feb 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	1.9	1	44	37	0363 5F3A 5684 6750 D14D
20168	Studio with private bathroom in the centre 1	59484	Alexander	Centrum-Oost	52.36407	4.89393	Private room	106	1	339	Thu Apr 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2.14	2			0363 CBB3 2C10 0C2A 1E29
27886	Romantic, stylish B&B houseboat in canal district	97647	Flip	Centrum-West	52.38761	4.89188	Private room	143	3	248	Sun Feb 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	1.82	1	14	20	0363 974D 4986 7411 88D8
28871	Comfortable double room	124245	Edwin	Centrum-West	52.36775	4.89092	Private room	76	2	476	Tue Feb 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	3.12	2	79	97	0363 607B EA74 0BD8 2F6F
29051	Comfortable single room	124245	Edwin	Centrum-Oost	52.36584	4.89111	Private room	56	2	618	Fri Mar 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4.23	2	69	85	0363 607B EA74 0BD8 2F6F
44391	Quiet 2-bedroom Amsterdam city centre apartment	194779	Jan	Centrum-Oost	52.37168	4.91471	Entire home/apt	240	3	44	Sat Aug 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.29	1		3	0363 E76E F06A C1DD 172C
311124	historic centre bright canal view jordaan	1600010	Anke & Robert	Centrum-West	52.37104	4.87713	Entire home/apt	325	5	87	Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	0.66	1	346	3	0363 59D8 7D30 6CFA DC81
49552	Multatuli Luxury Guest Suite in top location	225987	Joanna & MP	Centrum-West	52.38028	4.89089	Entire home/apt	257	3	462	Thu Feb 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	3.07	1	134	64	0363 576A D827 5085 6B83
729260	Great location modern apartment	3788198	Martin	Centrum-West	52.38079	4.88536	Entire home/apt	200	2	109	Mon Aug 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	0.87	1	102		0363 F6EF 50E3 40EB 1CFB
50263	Cent Adam Lux 2bed(4p) apt 125 sqm	230246	Donald	Centrum-Oost	52.37118	4.93146	Entire home/apt	395	4	163	Tue May 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1.08	1	341		0363 7F3D 0BAE 28C8 C7D2


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
);