San Diego Airbnb Listings by Kaggle | Ecommerce and Consumer Trends

About this Dataset

San Diego Airbnb Listings

Location, Amenities and Reviews

By Ali Sanne [source]

About this dataset

This dataset provides a comprehensive look at all active Airbnb listings in San Diego. It includes detailed information such as host information, location details, amenities offered, and reviews from past guests. With this dataset you can explore the list of Airbnb properties close to you, assess their suitability for staycations or business trips alike and understand the local market trends in a matter of minutes. Get an inside peek into each listing's features such as transportation options nearby, access to digital conveniences like guest profile pictures and phone verification requirement if any; property amenities including bed type, bathrooms and bedrooms; local neighborhood overviews; house rules; review scores rating from previous guests on different aspects like accuracy and communication etc.; security deposits or cleaning fees required by hosts, among others. With the data points provided here you can answer questions about your upcoming stays or become an informed owner/host in this dynamic sharing economy space. The listings dataset includes columns such as: listing_url ,name ,summary ,space ,description ,neighborhood_overview ,notes ,transit ,access interaction house_rules thumbnail_url host_url host_name host_since host_location host_about host_response time host response rate host acceptance rate host is super host host neighbourhood hosting listings count hosting total listings count hosting has profile pic street neighbourhoods cleansed city state zip code market smart location country code latitude longitude is location exact property type room type accommodates bathrooms bedrooms beds bed types amenities square feet nightly price price per stay security deposit cleaning fees guest included extra people minimum nights maximum nights number of reviews number of stays first review last review review scores rating review scores accuracy review scores cleanliness trial scores check-in trailed scores communications trailed score locations trial score values requires license instant bookable is business travel ready cancellation policy require guess profile picture require guess phone verifications

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset provides a comprehensive look at all the Airbnb listings in San Diego, California. It contains detailed information about each Airbnb listing, including host name and contact details, location and amenities, and reviews. With this data, users can get an accurate picture of the state of the San Diego Airbnb market and analyze trends in the data to make more informed decisions on how to use their resources.

Research Ideas

Creating targeted marketing campaigns based on the demographics of Airbnb hosts and renters in San Diego. This would involve analyzing the various data points related to host information and location, as well as guest preferences such as amenities and reviews, to identify potential target segments for businesses interested in advertising in San Diego.

Developing an accurate pricing algorithm for Airbnb listings by taking into account factors like property type, room type, square footage, amenities offered and other relevant characteristics like cleanliness and responsiveness ratings from the reviews of previous guests that can affect pricing decisions.

Using artificial intelligence (AI) algorithms to help predict whether a listing will be successful or not based on past trends of certain characteristics such listing location, ratings from previous guests etc., thus helping hosts make informed decisions about list pricing and marketing activities needed to build more successful listings over time.

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: listings (6).csv

Column name	Description
listing_url	URL of the Airbnb listing. (String)
name	Name of the Airbnb listing. (String)
summary	Summary of the Airbnb listing. (String)
space	Description of the space of the Airbnb listing. (String)
description	Detailed description of the Airbnb listing. (String)
neighborhood_overview	Overview of the neighborhood of the Airbnb listing. (String)
notes	Notes about the Airbnb listing. (String)
transit	Description of the transit options near the Airbnb listing. (String)
access	Description of the access to the Airbnb listing. (String)
interaction	Description of the interaction with the host of the Airbnb listing. (String)
house_rules	Description of the house rules of the Airbnb listing. (String)
thumbnail_url	URL of the thumbnail image of the Airbnb listing. (String)
host_url	URL of the host of the Airbnb listing. (String)
host_name	Name of the host of the Airbnb listing. (String)
host_since	Date the host joined Airbnb. (Date)
host_location	Location of the host of the Airbnb listing. (String)
host_about	Description of the host of the Airbnb listing. (String)
host_response_time	Response time of the host of the Airbnb listing. (String)
host_response_rate	Response rate of the host of the Airbnb listing. (Float)
host_acceptance_rate	Acceptance rate of the host of the Airbnb listing. (Float)
host_is_superhost	Indicates whether the host is a superhost or not. (Boolean)
host_neighbourhood	The neighbourhood of the host. (String)
host_listings_count	The number of listings the host has. (Integer)
host_total_listings_count	The total number of listings the host has. (Integer)
host_has_profile_pic	Indicates whether the host has a profile picture or not. (Boolean)
street	The street address of the Airbnb listing. (String)
neighbourhood_cleansed	The neighbourhood of the Airbnb listing, cleaned. (String)
city	The city of the Airbnb listing. (String)
state	The state of the Airbnb listing. (String)
zipcode	The zipcode of the Airbnb listing. (String)
market	The market of the Airbnb listing. (String)
smart_location	The smart location of the Airbnb listing. (String)
country_code	The country code of the Airbnb listing. (String)
latitude	The latitude of the Airbnb listing. (Float)
longitude	The longitude of the Airbnb listing. (Float)
is_location_exact	Indicates whether the location is exact or not. (Boolean)
property_type	The type of property of the Airbnb listing. (String)
room_type	The type of room of the Airbnb listing. (String)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit Ali Sanne.

Tables

Listings 6

@kaggle.thedevastator_san_diego_airbnb_listings_august_2019.listings_6

21.11 MB
13052 rows
76 columns


CREATE TABLE listings_6 (
  "index" BIGINT,
  "id" VARCHAR,
  "listing_url" VARCHAR,
  "name" VARCHAR,
  "summary" VARCHAR,
  "space" VARCHAR,
  "description" VARCHAR,
  "neighborhood_overview" VARCHAR,
  "notes" VARCHAR,
  "transit" VARCHAR,
  "access" VARCHAR,
  "interaction" VARCHAR,
  "house_rules" VARCHAR,
  "thumbnail_url" VARCHAR,
  "host_id" VARCHAR,
  "host_url" VARCHAR,
  "host_name" VARCHAR,
  "host_since" VARCHAR,
  "host_location" VARCHAR,
  "host_about" VARCHAR,
  "host_response_time" VARCHAR,
  "host_response_rate" VARCHAR,
  "host_acceptance_rate" DOUBLE,
  "host_is_superhost" VARCHAR,
  "host_neighbourhood" VARCHAR,
  "host_listings_count" VARCHAR,
  "host_total_listings_count" DOUBLE,
  "host_has_profile_pic" VARCHAR,
  "host_identity_verified" VARCHAR,
  "street" VARCHAR,
  "neighbourhood" VARCHAR,
  "neighbourhood_cleansed" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR,
  "market" VARCHAR,
  "smart_location" VARCHAR,
  "country_code" VARCHAR,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "is_location_exact" VARCHAR,
  "property_type" VARCHAR,
  "room_type" VARCHAR,
  "accommodates" VARCHAR,
  "bathrooms" DOUBLE,
  "bedrooms" DOUBLE,
  "beds" DOUBLE,
  "bed_type" VARCHAR,
  "amenities" VARCHAR,
  "square_feet" DOUBLE,
  "nightly_price" VARCHAR,
  "price_per_stay" VARCHAR,
  "security_deposit" VARCHAR,
  "cleaning_fee" VARCHAR,
  "guests_included" VARCHAR,
  "extra_people" VARCHAR,
  "minimum_nights" VARCHAR,
  "maximum_nights" DOUBLE,
  "number_of_reviews" DOUBLE,
  "number_of_stays" DOUBLE,
  "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,
  "instant_bookable" VARCHAR,
  "is_business_travel_ready" VARCHAR,
  "cancellation_policy" VARCHAR,
  "require_guest_profile_picture" VARCHAR,
  "require_guest_phone_verification" VARCHAR
);