Austin Airbnb Listings by Kaggle | Finance and Economics

About this Dataset

Austin Airbnb Listings

Properties, Reviews, and Prices

By Jon Loyens [source]

About this dataset

This AirBNB dataset provides a comprehensive look at the listings available in Austin, Texas. With over 100 columns of data, this dataset contains information about listing locations and hosts, amenities offered, listing requirements such as license and profile pictures, detailed review scores on different criteria such as cleanliness and communication effectiveness as well as prices for nightly costs. With full access to dates of first reviews and last scrapes of the calendar for availability planning purposes for guests looking to book their stay or hosts managing their space; this offers an impressive set of insights into what AirBNB experience entails in Austin. Get ready to explore all the wonderful possibilities that are hidden inside AirBNB Austin!

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset is perfect for understanding the Airbnb market in Austin, Texas. Some of the data points include hosts, amenities, and neighborhood information. Here are a few ideas on how to use this dataset:

Analyze Hosts - Use the host columns to analyze hosts in Austin. See who's renting out their properties and how active they are as hosts by looking at total listings count, response rate, and acceptance rate.

Research Amenities - What amenities do different neighborhoods offer? Look for correlations between area amenities like security deposits or square footage with different locations or property types around Austin.

Compare Neighborhoods - Use coordinates to compare the availability of listings in different areas over time by analyzing data like last scraped dates and availability periods per listing per month/year/etc., as well as other criteria specific to neighborhoods like weather or access to public transportation options within walking distance from each listing's location

Research Ideas

Analyzing the correlation between property location and review scores in order to identify higher-rated AirBnB locations for potential investors.

Analysing the various amenities offered by different properties to identify amenities and services that result in higher review scores.

Analyzing the prices of AirBnB properties in different neighborhoods and identifying any potential disparities in pricing along demographic lines

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: reviews_summary.csv

Column name	Description
date	The date of the listing. (Date)

File: listings.csv

Column name	Description
listing_url	URL of the listing. (String)
last_scraped	Date the listing was last scraped. (Date)
name	Name of the listing. (String)
summary	Brief summary of the listing. (String)
space	Description of the space available. (String)
description	Detailed description of the listing. (String)
experiences_offered	Description of experiences offered. (String)
neighborhood_overview	Overview of the neighborhood. (String)
notes	Notes about the listing. (String)
transit	Description of transit options nearby. (String)
thumbnail_url	URL for a small-sized image representing the property. (String)
medium_url	URL for a medium-sized image representing the property. (String)
picture_url	URL for a large-sized image representing the property. (String)
xl_picture_url	URL for an extra-large-sized image representing the property. (String)
host_url	URL of the host. (String)
host_name	Name of the host. (String)
host_since	Date the host joined AirBNB. (Date)
host_location	Location of the host. (String)
host_about	Description of the host. (String)
host_response_time	Average response time of the host. (String)
host_response_rate	Percentage of inquiries that the host responds to. (Float)
host_acceptance_rate	Percentage of requests that the host accepts. (Float)
host_is_superhost	Whether or not the host is a superhost. (Boolean)
host_thumbnail_url	URL for a small-sized image of the host. (String)
host_picture_url	URL for a large-sized image of the host. (String)
host_neighbourhood	Neighborhood of the host. (String)
host_listings_count	Number of listings
host_total_listings_count	Number of listings the host has. (Integer)
host_verifications	Verifications the host has completed. (String)
host_has_profile_pic	Whether or not the host has a profile picture. (Boolean)
street	Street address of the listing. (String)
neighbourhood_cleansed	Neighborhood of the listing. (String)
neighbourhood_group_cleansed	Group of neighborhoods the listing is in. (String)
city	City of the listing. (String)
state	State of the listing. (String)
zipcode	Zipcode of the listing. (String)
market	Market the listing is in. (String)
smart_location	Smart location of the listing. (String)
country_code	Country code of the listing. (String)
latitude	Latitude of the listing. (Float)
longitude	Longitude of the listing. (Float)
is_location_exact	Whether or not the location is exact. (Boolean)
property_type	Type of property. (String)
room_type	Type of room. (String)
accommodates	Number of people the listing can accommodate. (Integer)
bathrooms	Number of bathrooms in the listing. (Float)
bedrooms	Number of bedrooms in the listing. (Integer)
beds	Number of beds in the listing. (Integer)
bed_type	Type of bed in the listing. (String)
amenities	Amenities offered in the listing. (String)
square_feet	Square footage of the listing. (Integer)
price	Price of the listing. (Float)
weekly_price	Weekly price of the listing. (Float)
monthly_price	Monthly price of the listing. (Float)
security_deposit	Security deposit of the listing. (Float)
cleaning_fee	Cleaning fee of the listing. (Float)
guests_included	Number of guests included in the price. (Integer)
extra_people	Additional cost for extra people. (Float)
minimum_nights	Minimum number of nights required for booking. (Integer)
maximum_nights	Maximum number of nights allowed for booking. (Integer)
calendar_updated	Date the calendar was last updated. (Date)
has_availability	Whether or not the listing has availability. (Boolean)
availability_30	Number of days available in the next 30 days. (Integer)
availability_60	Number of days available in the next 60 days. (Integer)
availability_90	Number of days available in the next 90 days. (Integer)
availability_365	Number of days available in the next 365 days. (Integer)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit Jon Loyens.

Tables

Calendar

@kaggle.thedevastator_exploring_airbnb_in_austin_hosts_amenities_and_n.calendar

9.8 MB
2129775 rows
5 columns


CREATE TABLE calendar (
  "index" BIGINT,
  "listing_id" BIGINT,
  "date" TIMESTAMP,
  "available" VARCHAR,
  "price" VARCHAR
);

Listings

@kaggle.thedevastator_exploring_airbnb_in_austin_hosts_amenities_and_n.listings

8.09 MB
5835 rows
93 columns


CREATE TABLE listings (
  "index" BIGINT,
  "id" BIGINT,
  "listing_url" VARCHAR,
  "scrape_id" BIGINT,
  "last_scraped" TIMESTAMP,
  "name" VARCHAR,
  "summary" VARCHAR,
  "space" VARCHAR,
  "description" VARCHAR,
  "experiences_offered" VARCHAR,
  "neighborhood_overview" VARCHAR,
  "notes" VARCHAR,
  "transit" VARCHAR,
  "thumbnail_url" VARCHAR,
  "medium_url" VARCHAR,
  "picture_url" VARCHAR,
  "xl_picture_url" VARCHAR,
  "host_id" BIGINT,
  "host_url" VARCHAR,
  "host_name" VARCHAR,
  "host_since" TIMESTAMP,
  "host_location" VARCHAR,
  "host_about" VARCHAR,
  "host_response_time" VARCHAR,
  "host_response_rate" VARCHAR,
  "host_acceptance_rate" VARCHAR,
  "host_is_superhost" VARCHAR,
  "host_thumbnail_url" VARCHAR,
  "host_picture_url" VARCHAR,
  "host_neighbourhood" VARCHAR,
  "host_listings_count" DOUBLE,
  "host_total_listings_count" DOUBLE,
  "host_verifications" VARCHAR,
  "host_has_profile_pic" VARCHAR,
  "host_identity_verified" VARCHAR,
  "street" VARCHAR,
  "neighbourhood" VARCHAR,
  "neighbourhood_cleansed" BIGINT,
  "neighbourhood_group_cleansed" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" DOUBLE,
  "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" BIGINT,
  "bathrooms" DOUBLE,
  "bedrooms" DOUBLE,
  "beds" DOUBLE,
  "bed_type" VARCHAR,
  "amenities" VARCHAR,
  "square_feet" DOUBLE,
  "price" VARCHAR,
  "weekly_price" VARCHAR,
  "monthly_price" VARCHAR,
  "security_deposit" VARCHAR,
  "cleaning_fee" VARCHAR,
  "guests_included" BIGINT,
  "extra_people" VARCHAR,
  "minimum_nights" BIGINT,
  "maximum_nights" BIGINT,
  "calendar_updated" VARCHAR,
  "has_availability" VARCHAR,
  "availability_30" BIGINT,
  "availability_60" BIGINT,
  "availability_90" BIGINT,
  "availability_365" BIGINT,
  "calendar_last_scraped" TIMESTAMP,
  "number_of_reviews" BIGINT,
  "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,
  "license" DOUBLE,
  "jurisdiction_names" VARCHAR,
  "instant_bookable" VARCHAR,
  "cancellation_policy" VARCHAR,
  "require_guest_profile_picture" VARCHAR,
  "require_guest_phone_verification" VARCHAR,
  "calculated_host_listings_count" BIGINT,
  "reviews_per_month" DOUBLE
);

Listings Summary

@kaggle.thedevastator_exploring_airbnb_in_austin_hosts_amenities_and_n.listings_summary

402.53 KB
5835 rows
17 columns


CREATE TABLE listings_summary (
  "index" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "host_id" BIGINT,
  "host_name" VARCHAR,
  "neighbourhood_group" VARCHAR,
  "neighbourhood" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "room_type" VARCHAR,
  "price" BIGINT,
  "minimum_nights" BIGINT,
  "number_of_reviews" BIGINT,
  "last_review" TIMESTAMP,
  "reviews_per_month" DOUBLE,
  "calculated_host_listings_count" BIGINT,
  "availability_365" BIGINT
);

Neighbourhoods

@kaggle.thedevastator_exploring_airbnb_in_austin_hosts_amenities_and_n.neighbourhoods

3.21 KB
44 rows
3 columns


CREATE TABLE neighbourhoods (
  "index" BIGINT,
  "neighbourhood_group" VARCHAR,
  "neighbourhood" BIGINT
);

Reviews

@kaggle.thedevastator_exploring_airbnb_in_austin_hosts_amenities_and_n.reviews

13.58 MB
62976 rows
7 columns


CREATE TABLE reviews (
  "index" BIGINT,
  "listing_id" BIGINT,
  "id" BIGINT,
  "date" TIMESTAMP,
  "reviewer_id" BIGINT,
  "reviewer_name" VARCHAR,
  "comments" VARCHAR
);

Reviews Summary

@kaggle.thedevastator_exploring_airbnb_in_austin_hosts_amenities_and_n.reviews_summary

507.4 KB
62976 rows
3 columns


CREATE TABLE reviews_summary (
  "index" BIGINT,
  "listing_id" BIGINT,
  "date" TIMESTAMP
);