Baselight
Sign In

Airbnb Occupancy Rate Data (ADR, Revenue, #Booking

Listings occupancy rate, daily rate, and revenue data

@kaggle.jaeseokanairbtics_airbnb_occupancy_rate_adr_revenue_booking

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
  • 629.46 KB
  • 24849 rows
  • 25 columns
Loading...
 

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_native" BIGINT,
  "number_of_reservation" BIGINT,
  "revenue_usd" BIGINT,
  "revenue_native" BIGINT
);

Joshuaperformancedata

@kaggle.jaeseokanairbtics_airbnb_occupancy_rate_adr_revenue_booking.joshuaperformancedata
  • 184.42 KB
  • 7494 rows
  • 25 columns
Loading...
 

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_native" BIGINT,
  "number_of_reservation" BIGINT,
  "revenue_usd" BIGINT,
  "revenue_native" BIGINT
);

Malibuperformancedata

@kaggle.jaeseokanairbtics_airbnb_occupancy_rate_adr_revenue_booking.malibuperformancedata
  • 86.76 KB
  • 2291 rows
  • 25 columns
Loading...
 

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_native" BIGINT,
  "number_of_reservation" BIGINT,
  "revenue_usd" BIGINT,
  "revenue_native" BIGINT
);