Venues Schema Mapping

For legacy Foursquare customers migrating to our new, integrated dataset

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 Foursquare Venues dataset. Please note that the Seasonal Hours data delivery is being deprecated. The new Foursquare Places has its own robust Extended Attribute Packages that are available for licensing, these include: Ratings, Hours & Social Media (RHSM); Tips & Tastes; Best Photos; Calculated Scores; and Tags.

To use this guide, refer to the Legacy Foursquare Attribute column to lookup the replacement attribute in the New Places Attribute column. 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 Foursquare Data Migration Guide for more details.

Core Data

Legacy Foursquare AttributeNew Places AttributeNew Attribute PackageData Type ChangedFormat Changed
venueidfsq_idCoreNoNo
venuenamenameCoreNoNo
translatedvenuenamesname_translatedCoreYesYes
latitudelatitudeCoreYesNo
longitudelongitudeCoreYesNo
addressaddressCoreNoNo
citylocalityCoreNoNo
dmadmaCoreNoNo
stateregionCoreNoYes
postalcodepostcodeCoreNoNo
countrycodecountryCoreNoYes
date_createddate_createdCoreNoNo
date_approximatecloseddate_closedCalculated ScoresNoNo
score_opencloseclosed_bucketCalculated ScoresNoYes
category_primary_id *fsq_category_idsCoreYesYes
category_primary *fsq_category_labelsCoreYesYes
category_secondary_id *fsq_category_idsCoreYesYes
cateogry_secondary *fsq_category_labelsCoreYesYes
phonenumbertelRHSMNoNo
chainid *fsq_chain_idCoreYesYes
chainname *fsq_chain_nameCoreYesYes
totalsubvenuessubvenue_countCoreNoNo

* 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.

Rich Data

Legacy Foursquare AttributeNew Places AttributeAttribute PackageData Type ChangedFormat Changed
ratingratingRHSMNoNo
pricepriceRHSMNoNo
urlwebsiteRHSMNoNo
hourshoursRHSMYesYes
hours_popularhours_popularRHSMNoNo
facebookidfacebook_idRHSMNoNo
instagramhandleinstagramRHSMNoNo
twitternametwitterRHSMNoNo
descriptiondescriptionRHSMNoNo
photo1, photo2, ...photosBest PhotosYesYes
taste1, taste2, ...tastesTips & TastesYesYes
tip1, tip2, ...tipsTips & TastesYesYes
parentidparentidCoreNoNo
totaltipstotal_tipsTips & TastesNoNo
totalphotostotal_photosBest PhotosNoNo
popularity_scorepopularityCalculated ScoresNoNo
score_venuerealityvenue_reality_bucketCalculated ScoresNoNo
atmatmTagsYesNo
beerbeerTagsYesNo
barservicebarserviceTagsYesNo
businessmeetingbusinessmeetingTagsNoNo
byobyoTagsYesNo
cleancleanTagsNoNo
coatcheckcoatcheckTagsYesNo
cocktailscocktailsTagsYesNo
crowdedcrowdedTagsNoNo
datespopulardatespopularTagsNoNo
deliverydeliveryTagsYesNo
dressydressyTagsNoNo
drivethroughdrivethroughTagsYesNo
essentialreservationsessentialreservationsTagsYesNo
familiespopularfamiliespopularTagsNoNo
fullbarfullbarTagsYesNo
glutenfreedietglutenfreedietTagsNoNo
goodfordogsgoodfordogsTagsNoNo
groupsonlyreservationsgroupsonlyreservationsTagsYesNo
groupspopulargroupspopularTagsNoNo
hasmusichasmusicTagsNoNo
hasparkinghasparkingTagsYesNo
healthydiethealthydietTagsNoNo
jukeboxmusicjukeboxmusicTagsYesNo
latenightlatenightTagsNoNo
livemusiclivemusicTagsYesNo
noisynoisyTagsNoNo
onlinereservationsonlinereservationsTagsYesNo
outdoorseatingoutdoorseatingTagsYesNo
privatelotprivatelotTagsYesNo
privateroomprivateroomTagsYesNo
publiclotpubliclotTagsYesNo
quickbitequickbiteTagsNoNo
reservationsreservationsTagsYesNo
restroomrestroomTagsYesNo
romanticromanticTagsNoNo
servesbarsnacksservesbarsnacksTagsYesNo
servesbreakfastservesbreakfastTagsYesNo
servesbrunchservesbrunchTagsYesNo
servesdessertservesdessertTagsYesNo
servesdinnerservesdinnerTagsYesNo
serveshappyhourserveshappyhourTagsYesNo
serveslunchserveslunchTagsYesNo
servestastingmenuservestastingmenuTagsYesNo
servicequalityservicequalityTagsNoNo
singlespopularsinglespopularTagsNoNo
sitdowndiningsitdowndiningTagsYesNo
smokingsmokingTagsYesNo
specialoccasionspecialoccasionTagsNoNo
streetparkingstreetparkingTagsYesNo
takeouttakeoutTagsYesNo
takesamextakesamexTagsYesNo
takescreditcardstakescreditcardsTagsYesNo
takesdinersclubtakesdinersclubTagsYesNo
takesdiscovertakesdiscoverTagsYesNo
takesmastercardtakesmastercardTagsYesNo
takesnfctakesnfcTagsYesNo
takesunionpaytakesunionpayTagsYesNo
takesvisatakesvisaTagsYesNo
trendytrendyTagsNoNo
tvstvsTagsYesNo
valetparkingvaletparkingTagsNoNo
valueformoneyvalueformoneyTagsNoNo
vegandietvegandietTagsNoNo
vegetariandietvegetariandietTagsNoNo
wheelchairaccessiblewheelchairaccessibleTagsYesNo
wifiwifiTagsNoNo
winewineTagsYesNo

Seasonal Hours

Legacy Foursquare AttributeNew Places Attribute
seasonal_hoursDeprecated

Did this page help you?