Places Schema Mapping

The new Foursquare Places dataset combines the best of Factual's data collection methods with Foursquare's user generated content. Below is a schema mapping to assist migrating from a Legacy Factual Places dataset. Please note that all Legacy Factual Extended attributes are being deprecated, but many individual attributes are carried over in new Extended Attribute Packages. These are available to be licensed in addition to the Core attributes and include: Ratings, Hours & Social Media (RHSM); Tips & Tastes; Best Photos; Calculated Scores; and Tags.

To use this guide, please refer to the Legacy Factual Attribute column to look up the replacement attribute in the New Foursquare Places Attribute column. If an attribute has a blank row ( "-" ) then it has been deprecated. For more information about a specific Foursquare Places Attribute, please refer to our Schema Documentation. Several replacement attributes consist of either a Data Type Change, and/or a Format Change. Please use the table below to check for these circumstances and refer to the Legacy Factual Data Migration Guide where details of the changes will be organized by Attribute Package for easy reference.

Core Attributes

Legacy Factual AttributeNew Foursquare Places AttributeNew Attribute PackageData Type ChangedFormat Changed
factual_id *----
namenameCoreNoNo
addressaddressCoreNoNo
address_extendedaddress_extendedCoreNoNo
po_boxpo_boxCoreNoNo
localitylocalityCoreNoNo
regionregionCoreNoNo
post_townpost_townCoreNoNo
admin_regionadmin_regionCoreNoNo
postcodepostcodeCoreNoNo
countrycountryCoreNoNo
teltelRHSMNoNo
faxfaxRHSMNoNo
latitudelatitudeCoreNoNo
longitudelongitudeCoreNoNo
neighborhoodneighborhoodCoreNoNo
websitewebsiteRHSMNoNo
emailemailRHSMNoNo
category_ids *fsq_category_idsCoreNoYes
category_labels *fsq_category_labelsCoreNoYes
chain_name *fsq_chain_nameCoreYesYes
chain_id *fsq_chain_idCoreYesYes
hourshoursRHSMNoNo
hours_displayhours_displayRHSMNoNo
existence *closed_bucket and/or venue_reality_bucketCaclulated ScoresYesYes

* These legacy attributes will be included in the first several flat file deliveries appended to the end of the column order to assist in migration.

Extended Attributes

Restaurants

Legacy Factual AttributeIntegrated Places AttributeAttribute PackageDataType ChangedFormat Changed
cuisine----
pricepriceRHSMYesYes
ratingratingRHSMYesYes
payment_cashonlytakescreditcardsTagsNoYes
reservationsreservationsTagsNoNo
open_24hrs----
founded----
attire----
attire_required----
attire_prohibited----
parkinghasparkingTagsNoNo
parking_valetvaletparkingTagsNoNo
parking_garage----
parking_streetstreetparkingTagsNoNo
parking_lotpubliclotTagsNoNo
parking_validated----
parking_free----
smokingsmokingTagsNoNo
meal_breakfastservesbreakfastTagsNoNo
meal_lunchserveslunchTagsNoNo
meal_dinnerservesdinnerTagsNoNo
meal_deliverydeliveryTagsNoNo
meal_takeouttakeoutTagsNoNo
meal_cater----
alcohol----
alcohol_barbarservice and/or fullbarTagsNoNo
alcohol_beer_winebeer and/or wineTagsNoNo
alcohol_byobbeerTagsNoNo
kids_goodfor----
kids_menu----
groups_goodforgroupspopularTagsYesNo
accessible_wheelchairwheelchairaccessibleTagsNoNo
seating_outdooroutdoorseatingTagsNoNo
wifiwifiTagsYesNo
owner----
room_private----
options_vegetarianvegetariandietTagsYesNo
options_veganvegandietTagsYesNo
options_glutenfreeglutenfreedietTagsNoNo
options_lowfat----
options_organic----
options_healthyhealthydietTagsYesNo

Hotels

Legacy Factual AttributeIntegrated Places AttributeAttribute PackageDataType ChangedFormat Changed
air_conditioning----
complimentary_breakfast----
lowest_pricepriceRHSMYesYes
highest_pricepriceRHSMYesYes
deposit----
room_count----
stars----
petsgoodfordogsTagsYesYes
non_smoking_rooms----
smokingsmokingTagsNoNo
internetwifiTagsYesYes
pool----
fitness_facilities----
check_in----
check_out----
business_center----
express_check_in----
express_check_out----
laundry_service----
cable_tv----
room_service----
accessibility----
spa_services----
cribs----
restaurant----
concierge----
barbarservice and/or fullbarTagsNoNo
twentyfour_hour_front_desk----
meeting_rooms----
banquet_facilities----
event_catering----
complimentary_newspapers----
review_count----
ratingratingRHSMYesYes
type----
roll_out_beds----
parking_details----

Healthcare Providers

Legacy Factual AttributeIntegrated Places AttributeAttribute PackageDataType ChangedFormat Changed
degrees----
education----
gender----
affiliations----
years_experience----
insurances----
npi_id----
languages----

Placerank

Legacy Factual AttributeIntegrated Places AttributeAttribute PackageDataType ChangedFormat Changed
placerankpopularityCalculated ScoresYesYes

Crosswalk

Legacy Factual AttributeIntegrated Places AttributeAttribute PackageDataType ChangedFormat Changed
crosswalk_id_facebookfacebook_idRHSMYesNo
crosswalk_url_facebook----
crosswalk_id_foursquarefsq_idCoreNoNo
crosswalk_url_foursquare----
crosswalk_url_grubhub----
crosswalk_id_instagram----
crosswalk_url_instagraminstagramRHSMNoYes
crosswalk_url_lonelyplanet----
crosswalk_url_opentable----
crosswalk_id_opentable----
crosswalk_url_singleplatform----
crosswalk_url_stubhub----
crosswalk_id_tripadvisor----
crosswalk_url_tripadvisor----
crosswalk_id_twittertwitterRHSMNoNo
crosswalk_url_twitter----
crosswalk_url_wikipedia----
crosswalk_id_yelp----
crosswalk_url_yelp----
crosswalk_url_zagat----

Sign In