0% found this document useful (0 votes)
11 views6 pages

Comprehensive Neighborhood Listing Guide

This document describes the schema for a dataset containing 95 attributes with information about listings, hosts, reviews, and other properties. The attributes include fields like listing details, host profile information, amenities, pricing, calendar availability, review scores, and more. They are mostly textual descriptions, integers, dates, or true/false values. There is also a separate section describing the schema for reviews with attributes like listing ID, reviewer ID, date, comments, and more.

Uploaded by

Samin Afnan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
11 views6 pages

Comprehensive Neighborhood Listing Guide

This document describes the schema for a dataset containing 95 attributes with information about listings, hosts, reviews, and other properties. The attributes include fields like listing details, host profile information, amenities, pricing, calendar availability, review scores, and more. They are mostly textual descriptions, integers, dates, or true/false values. There is also a separate section describing the schema for reviews with attributes like listing ID, reviewer ID, date, comments, and more.

Uploaded by

Samin Afnan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

neighborhood_overview 10 description of

neighborhoods in textual
form
notes 11 textual description of
various facilities i.e.
whether the listing can be
rented for long term,
whether pet is allowed or
not
transit 12 textual description of how
the listing can be accessed
from well-known joints and
the time to traverse in
different routes
access 13 textual description of which
part of the listing i.e.
bathrooms, garden are
accessible and for how long
interaction 14 textual description of how
host can interact and at
what extend i.e. through
text or help to guide in local
area
house_rules 15 textual description of
whether smoking is allowed
or not, and at what extend
noise will be tolerated, and
emphasis on respecting
other people living there
thumbnail_url 16 thumbnail picture of the
listing
medium_url 17 medium picture of the
listing
picture_url 18 normal picture of the listing
xl_picture_url 19 large picture of the listing
host_id 20 unique identifier for each
host
host_url 21 url of host profile
host_name 22 host name probably pseudo
name
host_since 23 date since hosting
host_location 24 location of the host put by
host
host_about 25 about me written by host
host_response_time 26 in descriptive form i.e.
within an hour, a few days
or more, within a day,
N/A
host_response_rate 27 100%, 50%, 83%, N/A
etc.
host_acceptance_rate 28 N/A so far I have seen
host_is_superhost 29 t or f (true or false
maybe)
host_thumbnail_url 30 url for thumbnail size
picture of host
host_picture_url 31 url for medium size picture
of host
host_neighbourhood 32 neighborhood name of host
host_listings_count 33 number of listings hosted
by this particular host
host_total_listings_count 34 same as
host_listings_count, so far I
didnt see any difference
host_verifications 35 list of ways host is verified
i.e. through email, phone,
reviews, and so on
host_has_profile_pic 36 t or f
host_identity_verified 37 t of f
street 38 street name of the listing
neighbourhood 39
neighbourhood_cleansed 40
neighbourhood_group_clean 41
sed
city 42 city name of the listing
state 43 state of the listing
zipcode 44 zip code of the listing
market 45
smart_location 46
country_code 47 GB, BD, etc.
country 48 country name
latitude 49 numeric value of latitude
longitude 50 numeric value of longitude
is_location_exact 51 t or f
property_type 52 House, Apartment, Bed
& Breakfast,
Condominium, Loft,
Entire Floor, Boat,
Cabin, Other
room_type 53 Entire Home/Apt, Private
Room, Shared Room
accommodates 54 integers, denoting possible
number of people can be
accommodated
bathrooms 55 integers, denoting number
of bathrooms
bedrooms 56 integers, denoting number
of bedrooms
beds 57 integers, denoting number
of beds
bed_type 58 Real Bed, Pull-out Sofa,
Fotun
amenities 59 list of amenities i.e. TV,
kitchen, Wi-Fi, dryer,
washer, shampoo, heating
and so on
square_feet 60 number denoting area in
sqft of the listing, mostly
empty
price 61 price per night (day) in
dollar
weekly_price 62 price per week in dollar, for
some listing empty
monthly_price 63 price per month in dollar,
for some listing empty
security_deposit 64 amount need to be
deposited in dollar, for
some listing none
cleaning_fee 65 for some listing none,
others include a fee in
dollar
guests_included 66 number of guest allowed
extra_people 67 charge need to be paid for
extra people in dollar
minimum_nights 68 minimum number of nights
for which the listing can be
booked
maximum_nights 69 maximum number of nights
for which the listing can be
booked
calendar_updated 70 in descriptive from when
was calendar info updated
last time, i.e. 2 days ago
has_availability 71 empty, havent seen
anything so far for this
attribute
availability_30 72 integer, denoting how many
days in a 30 days span the
listing is available
availability_60 73 integer, denoting how many
days in a 60 days span the
listing is available
availability_90 74 integer, denoting how many
days in a 90 days span the
listing is available
availability_365 75 integer, denoting how many
days in a year the listing is
available
calendar_last_scraped 76 date, when the calendar
data for this listing was last
collected
number_of_reviews 77 Integer, denoting number of
times this listing is reviewed
first_review 78 date, when this listing has
got its first review
last_review 79 date, when this listing has
got its last review
review_scores_rating 80 integer
review_scores_accuracy 81 integer
review_scores_cleanliness 82 integer
review_scores_checkin 83 integer
review_scores_communicati 84 integer
on
review_scores_location 85 integer
review_scores_value 86 integer
requires_license 87 t or f
license 88 empty, so far
jurisdiction_names 89 empty, so far
instant_bookable 90 t or f
cancellation_policy 91 flexible, strict, moderate
require_guest_profile_pictur 92 t or f
e
require_guest_phone_verific 93 t or f
ation
calculated_host_listings_cou 94 integer
nt
reviews_per_month 95 average number of reviews
per month, or
number_of_reviews divide
by total number of months
between first_review and
last_review

review

This schema is a structure to hold information regarding reviews


of all the listings.

Attribute Seria Description


l
listing_id 1 id of the listing, for a single listing all review
information are found in a date wise
consecutive manner
id 2 unique identifier for this particular review
date 3 the date when review was generated
reviewer_id 4 unique identifier of the reviewer
reviewer_na 5 name of the reviewer, probably pseudo name
me
comments 6 the textual descriptive review

You might also like