Baselight
Sign In

Airbnb Data: Listings Scraped Global Top 10 Cities

Airbnb listings and metrics in London, Dubai, San Francisco, Tokyo, Sydney 2023

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities

Loading...
Loading...

About this Dataset

Airbnb Data: Listings Scraped Global Top 10 Cities

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 London, Dubai, San Francisco, Tokyo, Sydney, Miami, and Toronto 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 needed information to find out more about listings, hosts, geographical availability, necessary metrics, such as last twelve months occupancy rate, daily rate and revenue, to make predictions and draw conclusions.

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

How much does a typical 2-bedroom Airbnb listing make compared to a 3-bedroom in London?
What is the average occupancy rate of Airbnb listings in London?

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

Tables

Dubaidata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.dubaidata
  • 3.94 MB
  • 13560 rows
  • 53 columns
Loading... 

CREATE TABLE dubaidata (
  "listing_title" VARCHAR,
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "created_date" TIMESTAMP,
  "last_scraped_date" TIMESTAMP,
  "country" VARCHAR,
  "city" VARCHAR,
  "zipcode" BIGINT,
  "currency_native" VARCHAR,
  "number_of_reviews" BIGINT,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "max_guests" BIGINT,
  "airbnb_superhost" VARCHAR,
  "cancellation_policy" VARCHAR,
  "cleaning_fee_usd" DOUBLE,
  "cleaning_fee_native" DOUBLE,
  "extra_people_fee_usd" DOUBLE,
  "extra_people_fee_native" DOUBLE,
  "check_in_time" VARCHAR,
  "checkout_time" VARCHAR,
  "minimum_stay" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "exact_location" VARCHAR,
  "overall_rating" DOUBLE,
  "airbnb_communication_rating" DOUBLE,
  "airbnb_accuracy_rating" DOUBLE,
  "airbnb_cleanliness_rating" DOUBLE,
  "airbnb_checkin_rating" DOUBLE,
  "airbnb_location_rating" DOUBLE,
  "airbnb_value_rating" DOUBLE,
  "amenities" VARCHAR,
  "picture_url" VARCHAR,
  "license" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "host_listing_count" DOUBLE,
  "guest_controls" VARCHAR,
  "instant_bookable" DOUBLE,
  "pets_allowed" BOOLEAN,
  "listing_url" VARCHAR,
  "instantbook_enabled" BOOLEAN,
  "count_available_days_ltm" BIGINT,
  "count_blocked_days_ltm" BIGINT,
  "count_reservation_days_ltm" BIGINT,
  "occupancy_rate_ltm" BIGINT,
  "number_of_bookings_ltm" BIGINT,
  "number_of_bookings_ltm_number_of_observed_month" BIGINT,
  "average_daily_rate_usd" BIGINT,
  "average_daily_rate_native" DOUBLE,
  "annual_revenue_ltm_usd" BIGINT,
  "annual_revenue_ltm_native" DOUBLE
);

Ladata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.ladata
  • 4.02 MB
  • 12837 rows
  • 54 columns
Loading... 

CREATE TABLE ladata (
  "listing_title" VARCHAR,
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "created_date" TIMESTAMP,
  "last_scraped_date" TIMESTAMP,
  "country" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR,
  "zipcode" BIGINT,
  "currency_native" VARCHAR,
  "number_of_reviews" BIGINT,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "max_guests" BIGINT,
  "airbnb_superhost" VARCHAR,
  "cancellation_policy" VARCHAR,
  "cleaning_fee_usd" DOUBLE,
  "cleaning_fee_native" DOUBLE,
  "extra_people_fee_usd" DOUBLE,
  "extra_people_fee_native" DOUBLE,
  "check_in_time" VARCHAR,
  "checkout_time" VARCHAR,
  "minimum_stay" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "exact_location" VARCHAR,
  "overall_rating" DOUBLE,
  "airbnb_communication_rating" DOUBLE,
  "airbnb_accuracy_rating" DOUBLE,
  "airbnb_cleanliness_rating" DOUBLE,
  "airbnb_checkin_rating" DOUBLE,
  "airbnb_location_rating" DOUBLE,
  "airbnb_value_rating" DOUBLE,
  "amenities" VARCHAR,
  "picture_url" VARCHAR,
  "license" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "host_listing_count" DOUBLE,
  "guest_controls" VARCHAR,
  "instant_bookable" DOUBLE,
  "pets_allowed" BOOLEAN,
  "listing_url" VARCHAR,
  "instantbook_enabled" BOOLEAN,
  "count_available_days_ltm" BIGINT,
  "count_blocked_days_ltm" BIGINT,
  "count_reservation_days_ltm" BIGINT,
  "occupancy_rate_ltm" BIGINT,
  "number_of_bookings_ltm" BIGINT,
  "number_of_bookings_ltm_number_of_observed_month" BIGINT,
  "average_daily_rate_usd" BIGINT,
  "average_daily_rate_native" BIGINT,
  "annual_revenue_ltm_usd" BIGINT,
  "annual_revenue_ltm_native" BIGINT
);

Londondata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.londondata
  • 12.42 MB
  • 43580 rows
  • 54 columns
Loading... 

CREATE TABLE londondata (
  "listing_title" VARCHAR,
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "created_date" TIMESTAMP,
  "last_scraped_date" TIMESTAMP,
  "country" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR,
  "zipcode" VARCHAR,
  "currency_native" VARCHAR,
  "number_of_reviews" BIGINT,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "max_guests" BIGINT,
  "airbnb_superhost" VARCHAR,
  "cancellation_policy" VARCHAR,
  "cleaning_fee_usd" DOUBLE,
  "cleaning_fee_native" DOUBLE,
  "extra_people_fee_usd" DOUBLE,
  "extra_people_fee_native" DOUBLE,
  "check_in_time" VARCHAR,
  "checkout_time" VARCHAR,
  "minimum_stay" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "exact_location" VARCHAR,
  "overall_rating" DOUBLE,
  "airbnb_communication_rating" DOUBLE,
  "airbnb_accuracy_rating" DOUBLE,
  "airbnb_cleanliness_rating" DOUBLE,
  "airbnb_checkin_rating" DOUBLE,
  "airbnb_location_rating" DOUBLE,
  "airbnb_value_rating" DOUBLE,
  "amenities" VARCHAR,
  "picture_url" VARCHAR,
  "license" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "host_listing_count" DOUBLE,
  "guest_controls" VARCHAR,
  "instant_bookable" DOUBLE,
  "pets_allowed" BOOLEAN,
  "listing_url" VARCHAR,
  "instantbook_enabled" BOOLEAN,
  "count_available_days_ltm" BIGINT,
  "count_blocked_days_ltm" BIGINT,
  "count_reservation_days_ltm" BIGINT,
  "occupancy_rate_ltm" BIGINT,
  "number_of_bookings_ltm" BIGINT,
  "number_of_bookings_ltm_number_of_observed_month" BIGINT,
  "average_daily_rate_usd" BIGINT,
  "average_daily_rate_native" DOUBLE,
  "annual_revenue_ltm_usd" BIGINT,
  "annual_revenue_ltm_native" DOUBLE
);

Miamidata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.miamidata
  • 3.14 MB
  • 10205 rows
  • 57 columns
Loading... 

CREATE TABLE miamidata (
  "listing_title" VARCHAR,
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "created_date" TIMESTAMP,
  "last_scraped_date" TIMESTAMP,
  "last_host_count_updated_date" TIMESTAMP,
  "country" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR,
  "zipcode" BIGINT,
  "neighbourhood" VARCHAR,
  "metropolitan_statistical_area" VARCHAR,
  "currency_native" VARCHAR,
  "number_of_reviews" BIGINT,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "max_guests" BIGINT,
  "airbnb_superhost" VARCHAR,
  "cancellation_policy" VARCHAR,
  "cleaning_fee_usd" DOUBLE,
  "cleaning_fee_native" DOUBLE,
  "extra_people_fee_usd" DOUBLE,
  "extra_people_fee_native" DOUBLE,
  "check_in_time" VARCHAR,
  "checkout_time" VARCHAR,
  "minimum_stay" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "exact_location" VARCHAR,
  "overall_rating" DOUBLE,
  "airbnb_communication_rating" DOUBLE,
  "airbnb_accuracy_rating" DOUBLE,
  "airbnb_cleanliness_rating" DOUBLE,
  "airbnb_checkin_rating" DOUBLE,
  "airbnb_location_rating" DOUBLE,
  "airbnb_value_rating" DOUBLE,
  "amenities" VARCHAR,
  "picture_url" VARCHAR,
  "license" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "host_listing_count" DOUBLE,
  "guest_controls" VARCHAR,
  "instant_bookable" DOUBLE,
  "pets_allowed" BOOLEAN,
  "listing_url" VARCHAR,
  "instantbook_enabled" BOOLEAN,
  "count_available_days_ltm" BIGINT,
  "count_blocked_days_ltm" BIGINT,
  "count_reservation_days_ltm" BIGINT,
  "occupancy_rate_ltm" BIGINT,
  "number_of_bookings_ltm" BIGINT,
  "number_of_bookings_ltm_number_of_observed_month" BIGINT,
  "average_daily_rate_usd" BIGINT,
  "average_daily_rate_native" BIGINT,
  "annual_revenue_ltm_usd" BIGINT,
  "annual_revenue_ltm_native" BIGINT
);

Nycdata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.nycdata
  • 12.14 MB
  • 40343 rows
  • 54 columns
Loading... 

CREATE TABLE nycdata (
  "listing_title" VARCHAR,
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "created_date" TIMESTAMP,
  "last_scraped_date" TIMESTAMP,
  "country" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR,
  "zipcode" DOUBLE,
  "currency_native" VARCHAR,
  "number_of_reviews" BIGINT,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "max_guests" BIGINT,
  "airbnb_superhost" VARCHAR,
  "cancellation_policy" VARCHAR,
  "cleaning_fee_usd" DOUBLE,
  "cleaning_fee_native" DOUBLE,
  "extra_people_fee_usd" DOUBLE,
  "extra_people_fee_native" DOUBLE,
  "check_in_time" VARCHAR,
  "checkout_time" VARCHAR,
  "minimum_stay" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "exact_location" VARCHAR,
  "overall_rating" DOUBLE,
  "airbnb_communication_rating" DOUBLE,
  "airbnb_accuracy_rating" DOUBLE,
  "airbnb_cleanliness_rating" DOUBLE,
  "airbnb_checkin_rating" DOUBLE,
  "airbnb_location_rating" DOUBLE,
  "airbnb_value_rating" DOUBLE,
  "amenities" VARCHAR,
  "picture_url" VARCHAR,
  "license" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "host_listing_count" DOUBLE,
  "guest_controls" VARCHAR,
  "instant_bookable" DOUBLE,
  "pets_allowed" BOOLEAN,
  "listing_url" VARCHAR,
  "instantbook_enabled" BOOLEAN,
  "count_available_days_ltm" BIGINT,
  "count_blocked_days_ltm" BIGINT,
  "count_reservation_days_ltm" BIGINT,
  "occupancy_rate_ltm" BIGINT,
  "number_of_bookings_ltm" BIGINT,
  "number_of_bookings_ltm_number_of_observed_month" BIGINT,
  "average_daily_rate_usd" BIGINT,
  "average_daily_rate_native" BIGINT,
  "annual_revenue_ltm_usd" BIGINT,
  "annual_revenue_ltm_native" BIGINT
);

Sanfransiscodata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.sanfransiscodata
  • 1.18 MB
  • 3801 rows
  • 54 columns
Loading... 

CREATE TABLE sanfransiscodata (
  "listing_title" VARCHAR,
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "created_date" TIMESTAMP,
  "last_scraped_date" TIMESTAMP,
  "country" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR,
  "zipcode" DOUBLE,
  "currency_native" VARCHAR,
  "number_of_reviews" BIGINT,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "max_guests" BIGINT,
  "airbnb_superhost" VARCHAR,
  "cancellation_policy" VARCHAR,
  "cleaning_fee_usd" DOUBLE,
  "cleaning_fee_native" DOUBLE,
  "extra_people_fee_usd" DOUBLE,
  "extra_people_fee_native" DOUBLE,
  "check_in_time" VARCHAR,
  "checkout_time" VARCHAR,
  "minimum_stay" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "exact_location" VARCHAR,
  "overall_rating" DOUBLE,
  "airbnb_communication_rating" DOUBLE,
  "airbnb_accuracy_rating" DOUBLE,
  "airbnb_cleanliness_rating" DOUBLE,
  "airbnb_checkin_rating" DOUBLE,
  "airbnb_location_rating" DOUBLE,
  "airbnb_value_rating" DOUBLE,
  "amenities" VARCHAR,
  "picture_url" VARCHAR,
  "license" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "host_listing_count" DOUBLE,
  "guest_controls" VARCHAR,
  "instant_bookable" DOUBLE,
  "pets_allowed" BOOLEAN,
  "listing_url" VARCHAR,
  "instantbook_enabled" BOOLEAN,
  "count_available_days_ltm" BIGINT,
  "count_blocked_days_ltm" BIGINT,
  "count_reservation_days_ltm" BIGINT,
  "occupancy_rate_ltm" BIGINT,
  "number_of_bookings_ltm" BIGINT,
  "number_of_bookings_ltm_number_of_observed_month" BIGINT,
  "average_daily_rate_usd" BIGINT,
  "average_daily_rate_native" BIGINT,
  "annual_revenue_ltm_usd" BIGINT,
  "annual_revenue_ltm_native" BIGINT
);

Sydneydata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.sydneydata
  • 1.89 MB
  • 5938 rows
  • 54 columns
Loading... 

CREATE TABLE sydneydata (
  "listing_title" VARCHAR,
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "created_date" TIMESTAMP,
  "last_scraped_date" TIMESTAMP,
  "country" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR,
  "zipcode" DOUBLE,
  "currency_native" VARCHAR,
  "number_of_reviews" BIGINT,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "max_guests" BIGINT,
  "airbnb_superhost" VARCHAR,
  "cancellation_policy" VARCHAR,
  "cleaning_fee_usd" DOUBLE,
  "cleaning_fee_native" DOUBLE,
  "extra_people_fee_usd" DOUBLE,
  "extra_people_fee_native" DOUBLE,
  "check_in_time" VARCHAR,
  "checkout_time" VARCHAR,
  "minimum_stay" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "exact_location" VARCHAR,
  "overall_rating" DOUBLE,
  "airbnb_communication_rating" DOUBLE,
  "airbnb_accuracy_rating" DOUBLE,
  "airbnb_cleanliness_rating" DOUBLE,
  "airbnb_checkin_rating" DOUBLE,
  "airbnb_location_rating" DOUBLE,
  "airbnb_value_rating" DOUBLE,
  "amenities" VARCHAR,
  "picture_url" VARCHAR,
  "license" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "host_listing_count" DOUBLE,
  "guest_controls" VARCHAR,
  "instant_bookable" DOUBLE,
  "pets_allowed" BOOLEAN,
  "listing_url" VARCHAR,
  "instantbook_enabled" BOOLEAN,
  "count_available_days_ltm" BIGINT,
  "count_blocked_days_ltm" BIGINT,
  "count_reservation_days_ltm" BIGINT,
  "occupancy_rate_ltm" BIGINT,
  "number_of_bookings_ltm" BIGINT,
  "number_of_bookings_ltm_number_of_observed_month" BIGINT,
  "average_daily_rate_usd" BIGINT,
  "average_daily_rate_native" DOUBLE,
  "annual_revenue_ltm_usd" BIGINT,
  "annual_revenue_ltm_native" DOUBLE
);

Tokyodata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.tokyodata
  • 2.73 MB
  • 9661 rows
  • 54 columns
Loading... 

CREATE TABLE tokyodata (
  "listing_title" VARCHAR,
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "created_date" TIMESTAMP,
  "last_scraped_date" TIMESTAMP,
  "country" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR,
  "zipcode" VARCHAR,
  "currency_native" VARCHAR,
  "number_of_reviews" BIGINT,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "max_guests" BIGINT,
  "airbnb_superhost" VARCHAR,
  "cancellation_policy" VARCHAR,
  "cleaning_fee_usd" DOUBLE,
  "cleaning_fee_native" DOUBLE,
  "extra_people_fee_usd" DOUBLE,
  "extra_people_fee_native" DOUBLE,
  "check_in_time" VARCHAR,
  "checkout_time" VARCHAR,
  "minimum_stay" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "exact_location" VARCHAR,
  "overall_rating" DOUBLE,
  "airbnb_communication_rating" DOUBLE,
  "airbnb_accuracy_rating" DOUBLE,
  "airbnb_cleanliness_rating" DOUBLE,
  "airbnb_checkin_rating" DOUBLE,
  "airbnb_location_rating" DOUBLE,
  "airbnb_value_rating" DOUBLE,
  "amenities" VARCHAR,
  "picture_url" VARCHAR,
  "license" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "host_listing_count" DOUBLE,
  "guest_controls" VARCHAR,
  "instant_bookable" DOUBLE,
  "pets_allowed" BOOLEAN,
  "listing_url" VARCHAR,
  "instantbook_enabled" BOOLEAN,
  "count_available_days_ltm" BIGINT,
  "count_blocked_days_ltm" BIGINT,
  "count_reservation_days_ltm" BIGINT,
  "occupancy_rate_ltm" BIGINT,
  "number_of_bookings_ltm" BIGINT,
  "number_of_bookings_ltm_number_of_observed_month" BIGINT,
  "average_daily_rate_usd" BIGINT,
  "average_daily_rate_native" DOUBLE,
  "annual_revenue_ltm_usd" BIGINT,
  "annual_revenue_ltm_native" DOUBLE
);

Torontodata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.torontodata
  • 1.88 MB
  • 5900 rows
  • 53 columns
Loading... 

CREATE TABLE torontodata (
  "listing_title" VARCHAR,
  "property_type" VARCHAR,
  "listing_type" VARCHAR,
  "created_date" TIMESTAMP,
  "last_scraped_date" TIMESTAMP,
  "country" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR,
  "currency_native" VARCHAR,
  "number_of_reviews" BIGINT,
  "bedrooms" VARCHAR,
  "bathrooms" BIGINT,
  "max_guests" BIGINT,
  "airbnb_superhost" VARCHAR,
  "cancellation_policy" VARCHAR,
  "cleaning_fee_usd" DOUBLE,
  "cleaning_fee_native" DOUBLE,
  "extra_people_fee_usd" DOUBLE,
  "extra_people_fee_native" DOUBLE,
  "check_in_time" VARCHAR,
  "checkout_time" VARCHAR,
  "minimum_stay" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "exact_location" VARCHAR,
  "overall_rating" DOUBLE,
  "airbnb_communication_rating" DOUBLE,
  "airbnb_accuracy_rating" DOUBLE,
  "airbnb_cleanliness_rating" DOUBLE,
  "airbnb_checkin_rating" DOUBLE,
  "airbnb_location_rating" DOUBLE,
  "airbnb_value_rating" DOUBLE,
  "amenities" VARCHAR,
  "picture_url" VARCHAR,
  "license" VARCHAR,
  "airbnb_property_id" BIGINT,
  "airbnb_host_id" BIGINT,
  "host_listing_count" DOUBLE,
  "guest_controls" VARCHAR,
  "instant_bookable" DOUBLE,
  "pets_allowed" BOOLEAN,
  "listing_url" VARCHAR,
  "instantbook_enabled" BOOLEAN,
  "count_available_days_ltm" BIGINT,
  "count_blocked_days_ltm" BIGINT,
  "count_reservation_days_ltm" BIGINT,
  "occupancy_rate_ltm" BIGINT,
  "number_of_bookings_ltm" BIGINT,
  "number_of_bookings_ltm_number_of_observed_month" BIGINT,
  "average_daily_rate_usd" BIGINT,
  "average_daily_rate_native" DOUBLE,
  "annual_revenue_ltm_usd" BIGINT,
  "annual_revenue_ltm_native" DOUBLE
);

Share link

Anyone who has the link will be able to view this.