Name: Airbnb Occupancy Rate Data (ADR, Revenue, #Booking
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Airbnb Occupancy Rate Data (ADR, Revenue, #Booking

Context

Since 2008, guests and hosts have used Airbnb to expand on traveling possibilities and present more unique, personalized way of experiencing the world. This dataset describes the listing activity and metrics in Malibu, Jousha Tree, Brighton (UK) in 2023. The data is owned by Airbtics.

Airbtics is a short-term rental data & analytics company monitoring 20 million listings from various short-term rental booking sites.

Content

This data file includes all the needed information to find out the exact performance of Airbnb listings. You can find out how many nights were booked in a specific month, and average daily rate.

Acknowledgements

This public dataset is part of Airbnb, and the original source can be found on this website. The data was processed by Airbtics.

Inspiration

What is the occupancy rate of listing X in January 2023?
What is the average daily rate of a listing Y in January 2023?
How many bookings did a listing Z receive in January 2023?

To find more granular data in other cities, visit Airbtics.com

Tables

Brightonperformancedata

@kaggle.jaeseokanairbtics_airbnb_occupancy_rate_adr_revenue_booking.brightonperformancedata

644.56 kB
24,849 rows
25 columns

CREATE TABLE brightonperformancedata (
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "country_code" VARCHAR,
  "city" VARCHAR,
  "zipcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "currency_native" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "last_seen" TIMESTAMP,
  "cleaning_fee" DOUBLE,
  "reporting_month" TIMESTAMP,
  "blocked_days" BIGINT,
  "available_days" BIGINT,
  "scraped_during_month" BOOLEAN,
  "occupancy_rate" DOUBLE,
  "reservation_days" BIGINT,
  "adr_usd" BIGINT  -- ADR (USD),
  "adr_native" BIGINT  -- ADR (Native),
  "number_of_reservation" BIGINT,
  "revenue_usd" BIGINT  -- Revenue (USD),
  "revenue_native" BIGINT  -- Revenue (Native)
);

Joshuaperformancedata

@kaggle.jaeseokanairbtics_airbnb_occupancy_rate_adr_revenue_booking.joshuaperformancedata

188.84 kB
7,494 rows
25 columns

CREATE TABLE joshuaperformancedata (
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "country_code" VARCHAR,
  "city" VARCHAR,
  "zipcode" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "currency_native" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "last_seen" TIMESTAMP,
  "cleaning_fee" DOUBLE,
  "reporting_month" TIMESTAMP,
  "blocked_days" BIGINT,
  "available_days" BIGINT,
  "scraped_during_month" BOOLEAN,
  "occupancy_rate" DOUBLE,
  "reservation_days" BIGINT,
  "adr_usd" BIGINT  -- ADR (USD),
  "adr_native" BIGINT  -- ADR (Native),
  "number_of_reservation" BIGINT,
  "revenue_usd" BIGINT  -- Revenue (USD),
  "revenue_native" BIGINT  -- Revenue (Native)
);

Malibuperformancedata

@kaggle.jaeseokanairbtics_airbnb_occupancy_rate_adr_revenue_booking.malibuperformancedata

88.84 kB
2,291 rows
25 columns

CREATE TABLE malibuperformancedata (
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "country_code" VARCHAR,
  "city" VARCHAR,
  "zipcode" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "currency_native" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "last_seen" TIMESTAMP,
  "cleaning_fee" DOUBLE,
  "reporting_month" TIMESTAMP,
  "blocked_days" BIGINT,
  "available_days" BIGINT,
  "scraped_during_month" BOOLEAN,
  "occupancy_rate" DOUBLE,
  "reservation_days" BIGINT,
  "adr_usd" BIGINT  -- ADR (USD),
  "adr_native" BIGINT  -- ADR (Native),
  "number_of_reservation" BIGINT,
  "revenue_usd" BIGINT  -- Revenue (USD),
  "revenue_native" BIGINT  -- Revenue (Native)
);