U.S. Airbnb Open Data

Airbnb listings and metrics of regions in the U.S.

@kaggle.kritikseth_us_airbnb_open_data

Table List

2 tables(27.73 MB)

Ab Us 2020

Ab Us 2023

Ab Us 2020

@kaggle.kritikseth_us_airbnb_open_data.ab_us_2020

13.4 MB
226030 rows
17 columns

id Id	name Name	host_id Host Id	host_name Host Name	neighbourhood_group Neighbourhood Group	neighbourhood Neighbourhood	latitude Latitude	longitude Longitude	room_type Room Type	price Price	minimum_nights Minimum Nights	number_of_reviews Number Of Reviews	last_review Last Review	reviews_per_month Reviews Per Month	calculated_host_listings_count Calculated Host Listings Count	availability_365 Availability 365	city City
38585	Charming Victorian home - twin beds + breakfast	165529	Evelyne	nan	28804	35.65146	-82.62792	Private room	60	1	138	16/02/20	1.14	1		Asheville
80905	French Chic Loft	427027	Celeste	nan	28801	35.59779	-82.5554	Entire home/apt	470	1	114	07/09/20	1.03	11	288	Asheville
108061	Walk to stores/parks/downtown. Fenced yard/Pets OK	320564	Lisa	nan	28801	35.6067	-82.55563	Entire home/apt	75	30	89	30/11/19	0.81	2	298	Asheville
155305	Cottage! BonPaul + Sharky's Hostel	746673	BonPaul	nan	28806	35.57864	-82.59578	Entire home/apt	90	1	267	22/09/20	2.39	5		Asheville
160594	Historic Grove Park	769252	Elizabeth	nan	28801	35.61442	-82.54127	Private room	125	30	58	19/10/15	0.52	1		Asheville
209068	Terrace Cottage	1029919	Kevin	nan	28804	35.61856	-82.55276	Entire home/apt	134	7	54	14/01/20	0.49	1	294	Asheville
213006	Blue Gate West	1098412	Susanne	nan	28806	35.58345	-82.59713	Private room	48	1	137	30/11/19	1.35	1		Asheville
246315	Asheville Dreamer's Cabin	1292070	Annie	nan	28805	35.59635	-82.50655	Private room	65	3	57	30/10/19	0.53	2	106	Asheville
259576	Private, peaceful, and free goat therapy	1362726	Julia	nan	28805	35.61929	-82.48114	Entire home/apt	71	28	537	05/04/20	5.01	1	207	Asheville
295496	The Fern Street Apt near Biltmore	1501882	Debbie	nan	28803	35.55537	-82.53539	Entire home/apt	50	90	31	14/06/19	0.29	1	339	Asheville


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