Properties Database

Properties

This is the primary properties database. It contains all the content needed to display properties on your site with the exception of images, which are included in a separate file. There are approximately 700k properties included in this file. 

An updated version is uploaded on a weekly basis. 

https://travel-win-databases.s3.us-east-2.amazonaws.com/properties.csv

Field	Data Type	Details
propertyID	int	unique property ID
propertyName	String	property name
brandCode	String	Brand Code. For full list see here: https://www.ccra.com/hotel-companies/
address1	String	Street Address 1
address2	String	Street Address 2
locationID	int	“Primary” location ID. A hotel may fall in the bounding box of multiple locations (Malibu and Los Angeles, for example), but this attempts to map the hotel to a primary location
city	String	City
stateCode	String	State/Province code
postal	String	Postal / Zip Code
countryCode	String	2 character Country Code
latitude	float	hotel latitude
longitude	float	hotel longitude
priceClassID	int	General classification of how expensive the hotel is (this is not star rating)
areasServed	String	Description of areas the hotel serves
searchWeight	int	A weighting of demand for the hotel. This can be used in sorting the listings or in typeahead sort. The higher the number, the more popular the hotel is.
locationDescription	String	A description of the hotel location.
imageThumbnail	String	Hotel thumbnail URL as hosted on TravelWin CMS
propertyTypeID	int	Property Segment: 13|All Inclusive Resort 9|Bed & Breakfast 11|Boutique 12|Condo/Vacation Rental 8|Extended Stay Hotel 10|Guest Ranch 14|Hostel 2|Hotel – Full Service 1|Hotel – Limited Service 4|Hotel/Casino 3|Hotel/Conference Center 7|Inn & Suites 5|Motel 6|Resort 15|Weekly Rentals
numFloors	int	number of floors
numRooms	int	number of rooms
yearBuilt	int	year hotel was first built
yearOfLastRenov	int	year of last renovation
propertyPhone	String	hotel phone number
mobilStarRating	int	Star Rating (1-5 with no half stars)
description	String	Hotel Description
cancellationPolicy	String	General Hotel Cancellation Policy – This may vary based on the room/rate offered, so we recommend only showing policy at the rate level, which comes from the rate API call
checkinTime	String	Hotel Check in time
checkoutTime	String	Hotel Check out time
featuredAmenities	String	Comma separated list of “featured amenities”, which can be used for filtering and prominent display.   113 – Beach 61 – Outdoor Pool 9000259 – Local Shuttle Service 9001104 – pets allowed (contact hotel) 9000206 – Airport Shuttle 9000505 – Complimentary Breakfast 132 – Fitness Center 119 – Business Center 130 – Golf Course 9000527 – Restaurant on site
maxPrice	float	Max price for the hotel seen in the TravelWin system in last 30 days
minPrice	float	Min price for the hotel seen in the TravelWin system in last 30 days
medianPrice	float	Median price for the hotel seen in the TravelWin system in last 30 days
avgRebate	float	Average Rebate for the hotel seen in the TravelWin system in last 30 days
lastUpdate	Datetime	timestamp of the last data update (usually modifying min/max/median pricing)