Dataset: Airbnb Lisbon [2023]

About this Dataset

Airbnb Lisbon [2023]

The data provided by Inside Airbnb for the city of Lisbon contains detailed information about the accommodation listings available on the Airbnb platform in that region. Below is an explanation of the main columns included in the data:

id: The unique identifier of the Airbnb listing.
host_id: The unique identifier of the host responsible for the listing.
host_name: The name of the host.
host_since: The date the host registered on the Airbnb platform.
host_location: The location of the host.
host_total_listings_count: The total number of listings the host has.
neighborhood: The neighborhood where the property is located.
neighborhood_group: The neighborhood group to which the neighborhood belongs.
latitude: The latitude of the property's location.
longitude: The longitude of the property's location.
room_type: The type of room offered in the listing (e.g., entire house/apartment, private room, shared room).
bathrooms_text: The description of the bathrooms available on the property.
bedrooms: The number of bedrooms in the property.
price: The price per night for the listing.
minimum_nights: The minimum number of nights required to book the property.
maximum_nights: The maximum number of nights allowed to book the property.
has_availability: Indicates whether the property is available.
availability_365: The number of days the property can book over a year.
number_of_reviews_ltm: The number of reviews received in the last 12 months.
review_scores_rating: The average score of reviews received by the property.
license: The license or registration of the property, if applicable.
calculated_host_listings_count: The number of listings the host has in total.
calculated_host_listings_count_entire_homes: The host owns the number of entire listings (entire house/apartment).
reviews_per_month: The average number of reviews the property receives per month.

These columns provide a comprehensive view of the characteristics of available accommodation listings in Lisbon during the period in which the data was collected. This is a valuable data source for exploratory analysis, predictive modeling, and research related to the shared hosting industry in Lisbon. It provides a detailed look at listing features, including information about hosts, property locations, room type, pricing, availability, and reviews received.

Tables

Lisboa Data

@kaggle.crisleyoliveira_airbnb_lisbon_2023.lisboa_data

1.02 MB
21337 rows
24 columns


CREATE TABLE lisboa_data (
  "id" DOUBLE,
  "host_id" BIGINT,
  "host_name" VARCHAR,
  "host_since" VARCHAR,
  "host_location" VARCHAR,
  "host_total_listings_count" BIGINT,
  "neighbourhood" VARCHAR,
  "neighbourhood_group" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "room_type" VARCHAR,
  "bathrooms_text" VARCHAR,
  "bedrooms" DOUBLE,
  "price" BIGINT,
  "minimum_nights" BIGINT,
  "maximum_nights" BIGINT,
  "has_availability" VARCHAR,
  "availability_365" BIGINT,
  "number_of_reviews_ltm" BIGINT,
  "review_scores_rating" DOUBLE,
  "license" VARCHAR,
  "calculated_host_listings_count" BIGINT,
  "calculated_host_listings_count_entire_homes" BIGINT,
  "reviews_per_month" DOUBLE
);