ABCDE
1
Data Dictionary for listings.csv detailed file
2
3
File Namelistings.csv
4
Version4.3
5
Date IntroducedAugust, 2022
6
Description
7
8
FieldTypeCalculatedDescriptionReference
9
idintegerAirbnb's unique identifier for the listing
10
listing_urltexty
11
scrape_idbigintyInside Airbnb "Scrape" this was part of
12
last_scrapeddatetimeyUTC. The date and time this listing was "scraped".
13
sourcetextOne of "neighbourhood search" or "previous scrape". "neighbourhood search" means that the listing was found by searching the city, while "previous scrape" means that the listing was seen in another scrape performed in the last 65 days, and the listing was confirmed to be still available on the Airbnb site.
14
nametextName of the listing
15
descriptiontextDetailed description of the listing
16
neighborhood_overviewtextHost's description of the neighbourhood
17
picture_urltextURL to the Airbnb hosted regular sized image for the listing
18
host_idintegerAirbnb's unique identifier for the host/user
19
host_urltextyThe Airbnb page for the host
20
host_nametextName of the host. Usually just the first name(s).
21
host_sincedateThe date the host/user was created. For hosts that are Airbnb guests this could be the date they registered as a guest.
22
host_locationtextThe host's self reported location
23
host_abouttextDescription about the host
24
host_response_time
25
host_response_rate
26
host_acceptance_rateThat rate at which a host accepts booking requests.
27
host_is_superhost
boolean [t=true; f=false]
28
host_thumbnail_urltext
29
host_picture_urltext
30
host_neighbourhoodtext
31
host_listings_counttextThe number of listings the host has (per Airbnb calculations)
32
host_total_listings_counttextThe number of listings the host has (per Airbnb calculations)
33
host_verifications
34
host_has_profile_pic
boolean [t=true; f=false]
35
host_identity_verified
boolean [t=true; f=false]
36
neighbourhoodtext
37
neighbourhood_cleansedtextyThe neighbourhood as geocoded using the latitude and longitude against neighborhoods as defined by open or public digital shapefiles.
38
neighbourhood_group_cleansed
textyThe neighbourhood group as geocoded using the latitude and longitude against neighborhoods as defined by open or public digital shapefiles.
39
latitudenumericUses the World Geodetic System (WGS84) projection for latitude and longitude.
40
longitudenumericUses the World Geodetic System (WGS84) projection for latitude and longitude.
41
property_typetextSelf selected property type. Hotels and Bed and Breakfasts are described as such by their hosts in this field
42
room_typetext[Entire home/apt|Private room|Shared room|Hotel]

All homes are grouped into the following three room types:

Entire place
Private room
Shared room
Entire place
Entire places are best if you're seeking a home away from home. With an entire place, you'll have the whole space to yourself. This usually includes a bedroom, a bathroom, a kitchen, and a separate, dedicated entrance. Hosts should note in the description if they'll be on the property or not (ex: "Host occupies first floor of the home"), and provide further details on the listing.

Private rooms
Private rooms are great for when you prefer a little privacy, and still value a local connection. When you book a private room, you'll have your own private room for sleeping and may share some spaces with others. You might need to walk through indoor spaces that another host or guest may occupy to get to your room.

Shared rooms
Shared rooms are for when you don't mind sharing a space with others. When you book a shared room, you'll be sleeping in a space that is shared with others and share the entire space with other people. Shared rooms are popular among flexible travelers looking for new friends and budget-friendly stays.
https://www.airbnb.com/help/article/5/what-does-the-room-type-of-a-listing-mean
43
accommodatesintegerThe maximum capacity of the listing
44
bathroomsnumericThe number of bathrooms in the listing
45
bathrooms_textstringThe number of bathrooms in the listing.
On the Airbnb web-site, the bathrooms field has evolved from a number to a textual description. For older scrapes, bathrooms is used.
46
bedroomsintegerThe number of bedrooms
47
bedsintegerThe number of bed(s)
48
amenitiesjson
49
pricecurrencydaily price in local currency
50
minimum_nightsintegerminimum number of night stay for the listing (calendar rules may be different)
51
maximum_nightsintegermaximum number of night stay for the listing (calendar rules may be different)
52
minimum_minimum_nightsintegerythe smallest minimum_night value from the calender (looking 365 nights in the future)
53
maximum_minimum_nightsintegerythe largest minimum_night value from the calender (looking 365 nights in the future)
54
minimum_maximum_nightsintegerythe smallest maximum_night value from the calender (looking 365 nights in the future)
55
maximum_maximum_nightsintegerythe largest maximum_night value from the calender (looking 365 nights in the future)
56
minimum_nights_avg_ntmnumericythe average minimum_night value from the calender (looking 365 nights in the future)
57
maximum_nights_avg_ntmnumericythe average maximum_night value from the calender (looking 365 nights in the future)
58
calendar_updateddate
59
has_availabilityboolean[t=true; f=false]
60
availability_30integeryavaliability_x. The availability of the listing x days in the future as determined by the calendar. Note a listing may not be available because it has been booked by a guest or blocked by the host.
61
availability_60integeryavaliability_x. The availability of the listing x days in the future as determined by the calendar. Note a listing may not be available because it has been booked by a guest or blocked by the host.
62
availability_90integeryavaliability_x. The availability of the listing x days in the future as determined by the calendar. Note a listing may not be available because it has been booked by a guest or blocked by the host.
63
availability_365integeryavaliability_x. The availability of the listing x days in the future as determined by the calendar. Note a listing may not be available because it has been booked by a guest or blocked by the host.
64
calendar_last_scrapeddate
65
number_of_reviewsintegerThe number of reviews the listing has
66
number_of_reviews_ltmintegeryThe number of reviews the listing has (in the last 12 months)
67
number_of_reviews_l30dintegeryThe number of reviews the listing has (in the last 30 days)
68
first_reviewdateyThe date of the first/oldest review
69
last_reviewdateyThe date of the last/newest review
70
review_scores_rating
71
review_scores_accuracy
72
review_scores_cleanliness
73
review_scores_checkin
74
review_scores_communication
75
review_scores_location
76
review_scores_value
77
licensetextThe licence/permit/registration number
78
instant_bookableboolean[t=true; f=false]. Whether the guest can automatically book the listing without the host requiring to accept their booking request. An indicator of a commercial listing.
79
calculated_host_listings_count
integeryThe number of listings the host has in the current scrape, in the city/region geography.
80
calculated_host_listings_count_entire_homes
integeryThe number of Entire home/apt listings the host has in the current scrape, in the city/region geography
81
calculated_host_listings_count_private_rooms
integeryThe number of Private room listings the host has in the current scrape, in the city/region geography
82
calculated_host_listings_count_shared_rooms
integeryThe number of Shared room listings the host has in the current scrape, in the city/region geography
83
reviews_per_monthnumericyThe number of reviews the listing has over the lifetime of the listing
84
85
Change control
86
FieldChange
87
sourceAdded
88