Dataset: Melbourne Airbnb Open Data

About this Dataset

Melbourne Airbnb Open Data

Context

Melbourne was announced as 6th on the list of top ten cities for users globally in 2016 and has been one of the top cities for listings globally since then. As part of the InsideAirbnb initiative, this dataset describes the listing activity of homestays in Melbourne, VIC, Australia. The dataset was compiled on 07 Dec 2018.

Content

The following Airbnb activity is included in this Melbourne Airbnb dataset:

Listings: detailed listings data including full descriptions and average review score;
Calendar: detailed calendar data for listings, including listing id and the price and availability for that day;
Reviews, detailed review data for listings including unique id for each reviewer and detailed comments;
Listings-Summary: summary information and metrics for listings (good for visualisations);
Reviews-Summary: summary Review data and Listing ID (to facilitate time based analytics and visualisations linked to a listing);
Neigborhoods: neighborhood list for geo filter. Sourced from city or open source GIS files;

Inspiration

How is Airbnb really being used in and affecting your neighborhoods?
Can you describe the vibe of each Melbourne neighborhood using listing descriptions?
What are the busiest times of the year to visit Melbourne?By how much do prices spike?
Is there a general upward trend of both new Airbnb listings and total Airbnb visitors to
Melbourne?

Acknowledgements

This dataset is part of InsideAirbnb, and the original source can be found here.

Tables

Calendar Dec18

@kaggle.tylerx_melbourne_airbnb_open_data.calendar_dec18

4.11 MB
8356675 rows
4 columns


CREATE TABLE calendar_dec18 (
  "listing_id" BIGINT,
  "date" TIMESTAMP,
  "available" VARCHAR,
  "price" VARCHAR
);

Cleansed Listings Dec18

@kaggle.tylerx_melbourne_airbnb_open_data.cleansed_listings_dec18

38.08 MB
22895 rows
84 columns


CREATE TABLE cleansed_listings_dec18 (
  "id" BIGINT,
  "listing_url" VARCHAR,
  "scrape_id" DOUBLE,
  "last_scraped" TIMESTAMP,
  "name" VARCHAR,
  "summary" VARCHAR,
  "space" VARCHAR,
  "description" VARCHAR,
  "neighborhood_overview" VARCHAR,
  "notes" VARCHAR,
  "transit" VARCHAR,
  "access" VARCHAR,
  "interaction" VARCHAR,
  "house_rules" 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_is_superhost" VARCHAR,
  "host_thumbnail_url" VARCHAR,
  "host_picture_url" VARCHAR,
  "host_neighborhood" VARCHAR,
  "host_verifications" VARCHAR,
  "host_has_profile_pic" VARCHAR,
  "host_identity_verified" VARCHAR,
  "street" VARCHAR,
  "neighborhood" VARCHAR,
  "city" VARCHAR,
  "suburb" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR,
  "smart_location" VARCHAR,
  "country_code" VARCHAR,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "is_location_exact" VARCHAR,
  "property_type" VARCHAR,
  "room_type" VARCHAR,
  "accommodates" BIGINT,
  "bathrooms" DOUBLE,
  "bedrooms" DOUBLE,
  "beds" DOUBLE,
  "bed_type" VARCHAR,
  "amenities" VARCHAR,
  "price" BIGINT,
  "weekly_price" DOUBLE,
  "monthly_price" DOUBLE,
  "security_deposit" DOUBLE,
  "cleaning_fee" DOUBLE,
  "guests_included" BIGINT,
  "extra_people" BIGINT,
  "minimum_nights" BIGINT,
  "maximum_nights" BIGINT,
  "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,
  "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,
  "requires_license" VARCHAR,
  "license" VARCHAR,
  "instant_bookable" VARCHAR,
  "cancellation_policy" VARCHAR,
  "require_guest_profile_picture" VARCHAR,
  "require_guest_phone_verification" VARCHAR,
  "calculated_host_listings_count" BIGINT,
  "reviews_per_month" DOUBLE
);

Listings Summary Dec18

@kaggle.tylerx_melbourne_airbnb_open_data.listings_summary_dec18

1.52 MB
22895 rows
16 columns


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

Neighbourhoods

@kaggle.tylerx_melbourne_airbnb_open_data.neighbourhoods

2.47 KB
30 rows
2 columns


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

Reviews Dec18

@kaggle.tylerx_melbourne_airbnb_open_data.reviews_dec18

69.86 MB
486920 rows
6 columns


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

Reviews Summary Dec18

@kaggle.tylerx_melbourne_airbnb_open_data.reviews_summary_dec18

933.38 KB
486920 rows
2 columns


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