Dataset: Inside AirBnB - Netherlands

About this Dataset

Inside AirBnB - Netherlands

From the project website: http://insideairbnb.com/about/

Inside Airbnb is a mission driven project that provides data and advocacy about Airbnb's impact on residential communities.

We work towards a vision where data and information empower communities to understand, decide and control the role of renting residential homes to tourists.

File descriptions (applicable for each subfolder):

listings.csv: Detailed Listings data
calendar.csv: Detailed Calendar Data
reviews.csv: Detailed Review Data
listings.csv: Summary information and metrics for listings in Amsterdam (good for visualisations).
reviews.csv: Summary Review data and Listing ID (to facilitate time based analytics and visualisations linked to a listing).
neighbourhoods.csv Neighbourhood list for geo filter. Sourced from city or open source GIS files.
neighbourhoods.geojson GeoJSON file of neighbourhoods of the city.

Tables

Calendar

@kaggle.konradb_inside_airbnb_netherlands.calendar

1.87 MB
2554278 rows
7 columns


CREATE TABLE calendar (
  "listing_id" BIGINT,
  "date" TIMESTAMP,
  "available" VARCHAR,
  "price" VARCHAR,
  "adjusted_price" VARCHAR,
  "minimum_nights" DOUBLE,
  "maximum_nights" DOUBLE
);

Listings

@kaggle.konradb_inside_airbnb_netherlands.listings

594.37 KB
6998 rows
18 columns


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

Listings Detailed

@kaggle.konradb_inside_airbnb_netherlands.listings_detailed

6.67 MB
6998 rows
75 columns


CREATE TABLE listings_detailed (
  "id" BIGINT,
  "listing_url" VARCHAR,
  "scrape_id" BIGINT,
  "last_scraped" TIMESTAMP,
  "source" VARCHAR,
  "name" VARCHAR,
  "description" VARCHAR,
  "neighborhood_overview" VARCHAR,
  "picture_url" VARCHAR,
  "host_id" BIGINT,
  "host_url" VARCHAR,
  "host_name" VARCHAR,
  "host_since" TIMESTAMP,
  "host_location" VARCHAR,
  "host_about" VARCHAR,
  "host_response_time" VARCHAR,
  "host_response_rate" VARCHAR,
  "host_acceptance_rate" VARCHAR,
  "host_is_superhost" VARCHAR,
  "host_thumbnail_url" VARCHAR,
  "host_picture_url" VARCHAR,
  "host_neighbourhood" VARCHAR,
  "host_listings_count" BIGINT,
  "host_total_listings_count" BIGINT,
  "host_verifications" VARCHAR,
  "host_has_profile_pic" VARCHAR,
  "host_identity_verified" VARCHAR,
  "neighbourhood" VARCHAR,
  "neighbourhood_cleansed" VARCHAR,
  "neighbourhood_group_cleansed" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "property_type" VARCHAR,
  "room_type" VARCHAR,
  "accommodates" BIGINT,
  "bathrooms" VARCHAR,
  "bathrooms_text" VARCHAR,
  "bedrooms" DOUBLE,
  "beds" DOUBLE,
  "amenities" VARCHAR,
  "price" VARCHAR,
  "minimum_nights" BIGINT,
  "maximum_nights" BIGINT,
  "minimum_minimum_nights" BIGINT,
  "maximum_minimum_nights" BIGINT,
  "minimum_maximum_nights" BIGINT,
  "maximum_maximum_nights" BIGINT,
  "minimum_nights_avg_ntm" DOUBLE,
  "maximum_nights_avg_ntm" DOUBLE,
  "calendar_updated" VARCHAR,
  "has_availability" VARCHAR,
  "availability_30" BIGINT,
  "availability_60" BIGINT,
  "availability_90" BIGINT,
  "availability_365" BIGINT,
  "calendar_last_scraped" TIMESTAMP,
  "number_of_reviews" BIGINT,
  "number_of_reviews_ltm" BIGINT,
  "number_of_reviews_l30d" BIGINT,
  "first_review" TIMESTAMP,
  "last_review" TIMESTAMP,
  "review_scores_rating" DOUBLE,
  "review_scores_accuracy" DOUBLE,
  "review_scores_cleanliness" DOUBLE,
  "review_scores_checkin" DOUBLE,
  "review_scores_communication" DOUBLE,
  "review_scores_location" DOUBLE,
  "review_scores_value" DOUBLE,
  "license" VARCHAR,
  "instant_bookable" VARCHAR,
  "calculated_host_listings_count" BIGINT,
  "calculated_host_listings_count_entire_homes" BIGINT,
  "calculated_host_listings_count_private_rooms" BIGINT,
  "calculated_host_listings_count_shared_rooms" BIGINT,
  "reviews_per_month" DOUBLE
);

Neighbourhoods

@kaggle.konradb_inside_airbnb_netherlands.neighbourhoods

2.47 KB
22 rows
2 columns


CREATE TABLE neighbourhoods (
  "neighbourhood_group" VARCHAR,
  "neighbourhood" VARCHAR
);

Reviews

@kaggle.konradb_inside_airbnb_netherlands.reviews

659.08 KB
339805 rows
2 columns


CREATE TABLE reviews (
  "listing_id" BIGINT,
  "date" TIMESTAMP
);

Reviews Detailed

@kaggle.konradb_inside_airbnb_netherlands.reviews_detailed

58.11 MB
339805 rows
6 columns


CREATE TABLE reviews_detailed (
  "listing_id" BIGINT,
  "id" BIGINT,
  "date" TIMESTAMP,
  "reviewer_id" BIGINT,
  "reviewer_name" VARCHAR,
  "comments" VARCHAR
);