U.S. Airbnb Open Data
Airbnb listings and metrics of regions in the U.S.
@kaggle.kritikseth_us_airbnb_open_data
Ab Us 2020
@kaggle.kritikseth_us_airbnb_open_data.ab_us_2020
- 13.4 MB
- 226030 rows
- 17 columns
idId | nameName | host_idHost Id | host_nameHost Name | neighbourhood_groupNeighbourhood Group | neighbourhoodNeighbourhood | latitudeLatitude | longitudeLongitude | room_typeRoom Type | pricePrice | minimum_nightsMinimum Nights | number_of_reviewsNumber Of Reviews | last_reviewLast Review | reviews_per_monthReviews Per Month | calculated_host_listings_countCalculated Host Listings Count | availability_365Availability 365 | cityCity |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
);