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
  • 4.13 MB
  • 13,560 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 (USD),
  "cleaning_fee_native" DOUBLE  -- Cleaning Fee (Native),
  "extra_people_fee_usd" DOUBLE  -- Extra People Fee (USD),
  "extra_people_fee_native" DOUBLE  -- Extra People Fee(Native),
  "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  -- Number Of Bookings LTM - Number Of Observed Month,
  "average_daily_rate_usd" BIGINT  -- Average Daily Rate (USD),
  "average_daily_rate_native" DOUBLE  -- Average Daily Rate (Native),
  "annual_revenue_ltm_usd" BIGINT  -- Annual Revenue LTM (USD),
  "annual_revenue_ltm_native" DOUBLE  -- Annual Revenue LTM (Native)
);

Ladata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.ladata
  • 4.21 MB
  • 12,837 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 (USD),
  "cleaning_fee_native" DOUBLE  -- Cleaning Fee (Native),
  "extra_people_fee_usd" DOUBLE  -- Extra People Fee (USD),
  "extra_people_fee_native" DOUBLE  -- Extra People Fee(Native),
  "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  -- Number Of Bookings LTM - Number Of Observed Month,
  "average_daily_rate_usd" BIGINT  -- Average Daily Rate (USD),
  "average_daily_rate_native" BIGINT  -- Average Daily Rate (Native),
  "annual_revenue_ltm_usd" BIGINT  -- Annual Revenue LTM (USD),
  "annual_revenue_ltm_native" BIGINT  -- Annual Revenue LTM (Native)
);

Londondata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.londondata
  • 13.02 MB
  • 43,580 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 (USD),
  "cleaning_fee_native" DOUBLE  -- Cleaning Fee (Native),
  "extra_people_fee_usd" DOUBLE  -- Extra People Fee (USD),
  "extra_people_fee_native" DOUBLE  -- Extra People Fee(Native),
  "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  -- Number Of Bookings LTM - Number Of Observed Month,
  "average_daily_rate_usd" BIGINT  -- Average Daily Rate (USD),
  "average_daily_rate_native" DOUBLE  -- Average Daily Rate (Native),
  "annual_revenue_ltm_usd" BIGINT  -- Annual Revenue LTM (USD),
  "annual_revenue_ltm_native" DOUBLE  -- Annual Revenue LTM (Native)
);

Miamidata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.miamidata
  • 3.29 MB
  • 10,205 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 (USD),
  "cleaning_fee_native" DOUBLE  -- Cleaning Fee (Native),
  "extra_people_fee_usd" DOUBLE  -- Extra People Fee (USD),
  "extra_people_fee_native" DOUBLE  -- Extra People Fee(Native),
  "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  -- Number Of Bookings LTM - Number Of Observed Month,
  "average_daily_rate_usd" BIGINT  -- Average Daily Rate (USD),
  "average_daily_rate_native" BIGINT  -- Average Daily Rate (Native),
  "annual_revenue_ltm_usd" BIGINT  -- Annual Revenue LTM (USD),
  "annual_revenue_ltm_native" BIGINT  -- Annual Revenue LTM (Native)
);

Nycdata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.nycdata
  • 12.73 MB
  • 40,343 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 (USD),
  "cleaning_fee_native" DOUBLE  -- Cleaning Fee (Native),
  "extra_people_fee_usd" DOUBLE  -- Extra People Fee (USD),
  "extra_people_fee_native" DOUBLE  -- Extra People Fee(Native),
  "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  -- Number Of Bookings LTM - Number Of Observed Month,
  "average_daily_rate_usd" BIGINT  -- Average Daily Rate (USD),
  "average_daily_rate_native" BIGINT  -- Average Daily Rate (Native),
  "annual_revenue_ltm_usd" BIGINT  -- Annual Revenue LTM (USD),
  "annual_revenue_ltm_native" BIGINT  -- Annual Revenue LTM (Native)
);

Sanfransiscodata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.sanfransiscodata
  • 1.24 MB
  • 3,801 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 (USD),
  "cleaning_fee_native" DOUBLE  -- Cleaning Fee (Native),
  "extra_people_fee_usd" DOUBLE  -- Extra People Fee (USD),
  "extra_people_fee_native" DOUBLE  -- Extra People Fee(Native),
  "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  -- Number Of Bookings LTM - Number Of Observed Month,
  "average_daily_rate_usd" BIGINT  -- Average Daily Rate (USD),
  "average_daily_rate_native" BIGINT  -- Average Daily Rate (Native),
  "annual_revenue_ltm_usd" BIGINT  -- Annual Revenue LTM (USD),
  "annual_revenue_ltm_native" BIGINT  -- Annual Revenue LTM (Native)
);

Sydneydata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.sydneydata
  • 1.98 MB
  • 5,938 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 (USD),
  "cleaning_fee_native" DOUBLE  -- Cleaning Fee (Native),
  "extra_people_fee_usd" DOUBLE  -- Extra People Fee (USD),
  "extra_people_fee_native" DOUBLE  -- Extra People Fee(Native),
  "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  -- Number Of Bookings LTM - Number Of Observed Month,
  "average_daily_rate_usd" BIGINT  -- Average Daily Rate (USD),
  "average_daily_rate_native" DOUBLE  -- Average Daily Rate (Native),
  "annual_revenue_ltm_usd" BIGINT  -- Annual Revenue LTM (USD),
  "annual_revenue_ltm_native" DOUBLE  -- Annual Revenue LTM (Native)
);

Tokyodata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.tokyodata
  • 2.86 MB
  • 9,661 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 (USD),
  "cleaning_fee_native" DOUBLE  -- Cleaning Fee (Native),
  "extra_people_fee_usd" DOUBLE  -- Extra People Fee (USD),
  "extra_people_fee_native" DOUBLE  -- Extra People Fee(Native),
  "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  -- Number Of Bookings LTM - Number Of Observed Month,
  "average_daily_rate_usd" BIGINT  -- Average Daily Rate (USD),
  "average_daily_rate_native" DOUBLE  -- Average Daily Rate (Native),
  "annual_revenue_ltm_usd" BIGINT  -- Annual Revenue LTM (USD),
  "annual_revenue_ltm_native" DOUBLE  -- Annual Revenue LTM (Native)
);

Torontodata

@kaggle.jaeseokanairbtics_airbnb_listings_scraped_global_top_10_cities.torontodata
  • 1.97 MB
  • 5,900 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 (USD),
  "cleaning_fee_native" DOUBLE  -- Cleaning Fee (Native),
  "extra_people_fee_usd" DOUBLE  -- Extra People Fee (USD),
  "extra_people_fee_native" DOUBLE  -- Extra People Fee(Native),
  "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  -- Number Of Bookings LTM - Number Of Observed Month,
  "average_daily_rate_usd" BIGINT  -- Average Daily Rate (USD),
  "average_daily_rate_native" DOUBLE  -- Average Daily Rate (Native),
  "annual_revenue_ltm_usd" BIGINT  -- Annual Revenue LTM (USD),
  "annual_revenue_ltm_native" DOUBLE  -- Annual Revenue LTM (Native)
);

Share link

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