ABCDE
1
Data Dictionary for listings.csv detailed file
2
3
File Namelistings.csv
4
Version4
5
Date IntroducedAugust, 2020
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
nametextName of the listing
14
descriptiontextDetailed description of the listing
15
neighborhood_overviewtextHost's description of the neighbourhood
16
picture_urltextURL to the Airbnb hosted regular sized image for the listing
17
host_idintegerAirbnb's unique identifier for the host/user
18
host_urltextyThe Airbnb page for the host
19
host_nametextName of the host. Usually just the first name(s).
20
host_sincedateThe date the host/user was created. For hosts that are Airbnb guests this could be the date they registered as a guest.
21
host_locationtextThe host's self reported location
22
host_abouttextDescription about the host
23
host_response_time
24
host_response_rate
25
host_acceptance_rateThat rate at which a host accepts booking requests.
26
host_is_superhost
boolean [t=true; f=false]
27
host_thumbnail_urltext
28
host_picture_urltext
29
host_neighbourhoodtext
30
host_listings_counttextThe number of listings the host has (per Airbnb calculations)
31
host_total_listings_counttextThe number of listings the host has (per Airbnb calculations)
32
host_verifications
33
host_has_profile_pic
boolean [t=true; f=false]
34
host_identity_verified
boolean [t=true; f=false]
35
neighbourhoodtext
36
neighbourhood_cleansedtextyThe neighbourhood as geocoded using the latitude and longitude against neighborhoods as defined by open or public digital shapefiles.
37
neighbourhood_group_cleansed
textyThe neighbourhood group as geocoded using the latitude and longitude against neighborhoods as defined by open or public digital shapefiles.
38
latitudenumericUses the World Geodetic System (WGS84) projection for latitude and longitude.
39
longitudenumericUses the World Geodetic System (WGS84) projection for latitude and longitude.
40
property_typetextSelf selected property type. Hotels and Bed and Breakfasts are described as such by their hosts in this field
41
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
42
accommodatesintegerThe maximum capacity of the listing
43
bathroomsnumericThe number of bathrooms in the listing
44
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.
45
bedroomsintegerThe number of bedrooms
46
bedsintegerThe number of bed(s)
47
amenitiesjson
48
pricecurrencydaily price in local currency
49
minimum_nightsintegerminimum number of night stay for the listing (calendar rules may be different)
50
maximum_nightsintegermaximum number of night stay for the listing (calendar rules may be different)
51
minimum_minimum_nightsintegerythe smallest minimum_night value from the calender (looking 365 nights in the future)
52
maximum_minimum_nights
integerythe largest minimum_night value from the calender (looking 365 nights in the future)
53
minimum_maximum_nights
integerythe smallest maximum_night value from the calender (looking 365 nights in the future)
54
maximum_maximum_nights
integerythe largest maximum_night value from the calender (looking 365 nights in the future)
55
minimum_nights_avg_ntmnumericythe average minimum_night value from the calender (looking 365 nights in the future)
56
maximum_nights_avg_ntmnumericythe average maximum_night value from the calender (looking 365 nights in the future)
57
calendar_updateddate
58
has_availabilityboolean[t=true; f=false]
59
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.
60
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.
61
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.
62
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.
63
calendar_last_scrapeddate
64
number_of_reviewsintegerThe number of reviews the listing has
65
number_of_reviews_ltmintegeryThe number of reviews the listing has (in the last 12 months)
66
number_of_reviews_l30dintegeryThe number of reviews the listing has (in the last 30 days)
67
first_reviewdateyThe date of the first/oldest review
68
last_reviewdateyThe date of the last/newest review
69
review_scores_rating
70
review_scores_accuracy
71
review_scores_cleanliness
72
review_scores_checkin
73
review_scores_communication
74
review_scores_location
75
review_scores_value
76
licensetextThe licence/permit/registration number
77
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.
78
calculated_host_listings_count
integeryThe number of listings the host has in the current scrape, in the city/region geography.
79
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
80
calculated_host_listings_count_private_rooms
integeryThe number of Private room listings the host has in the current scrape, in the city/region geography
81
calculated_host_listings_count_shared_rooms
integeryThe number of Shared room listings the host has in the current scrape, in the city/region geography
82
reviews_per_monthnumericyThe number of reviews the listing has over the lifetime of the listing
83
84
Change control
85
FieldChange
86
summaryRemoved
87
spaceRemoved
88
experiences_offeredRemoved
89
notesRemoved
90
transitRemoved
91
accessRemoved
92
interactionRemoved
93
house_rulesRemoved
94
thumbnail_urlRemoved
95
medium_urlRemoved
96
xl_picture_urlRemoved
97
streetRemoved
98
cityRemoved
99
stateRemoved
100
zipcodeRemoved