Visits

Column	Type	Description	Example
persistent_id	string	A unique identifier for a user across all of a user's visits	b953fd9304c947431b8ec183bbe3d26a485a073aa684dc5a89d74db8ca79b845
venue_id	string	Foursquare’s unique identifier for a particular venue/location; displayed as a 24-character string	5c6b234e037be1002ce54dda
utc_date	string	Date of the visit in UTC time (YYYY-MM-DD)	2019-07-24
utc_hour	number	Hour of the visit in UTC time	10
local_date	string	Date of the visit in local time (YYYY-MM-DD)	2019-07-24
local_hour	number	Hour of the visit in local hour	11
gender	string	Modeled gender of the visitor	Male or female
age	string	Modeled age cohort of the visitor	20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84
full_panel_reweighted_sag_score	number	Normalization score assigned to visit, based on the user's state, age & gender (e.g. this 1 visit should be weighted as 87.6813336 visits, to derive insights representative of the overall US population)	87.6813336
dwell	number	Number of seconds a user is in a venue (difference between start and end time)	193
home_zip	number	Home zip code of user, for zips with >1k in population	10016
home_cbg (US only)	string	Indicates the census block group in which the visitor lives if the cbg is >600 in population	482012231001
work_cbg (US only)	string	Indicates the census block group in which the visitor works if the cbg is >600 in population	482012231001

Places Mapping File

Column	Type	Description	Example
venue_id	string	Foursquare’s unique identifier for a particular venue/location; displayed as a 24-character string	5c6b234e037be1002ce54dda
venue_name	string	Name of the venue	Old Navy
address	string	Address of the venue	1217 Rockville Pike
city	string	City the venue is located in	Rockville
dma	string	DMA the venue is located in	Washington, DC
zip	string	Zip code the venue is located in	20852
state	string	Two letter state code	MD
country	string	The ISO 3166 2 letter country code	US
geo_lat	number	Latitude coordinates of the venue	39.054581
geo_long	number	Longitude coordinates of the venue	-77.11638
category_id	string	Foursquare's unique identifier for a category; displayed as a 24-character string	5f2c3f6b5b4c177b9a6dc388
category_name	string	Bottom-level category of the venue	Korean BBQ Restaurants
category_id_level1	string	Foursquare's unique identifier for a category level; displayed as a 24-character string	63be6904847c3692a84b9bb5
category_name_level1	string	Name of the primary (top-level) category level of the venue	Dining and Drinking
category_id_level2	string	Foursquare's unique identifier for a category level; displayed as a 24-character string	4d4b7105d754a06374d81259
category_name_level2	string	Name of the secondary category level of the venue	Restaurants
category_id_level3	string	Foursquare's unique identifier for a category level; displayed as a 24-character string	4bf58dd8d48988d108951735
category_name_level3	string	Name of the tertiary category level of the venue	Asian Restaurants
category_id_level4		Foursquare's unique identifier for a category level; displayed as a 24-character string	4bf58dd8d48988d113941735
category_name_level4		Name of the fourth category level of the venue	Korean Restaurants
category_id_level5		Foursquare's unique identifier for a category level; displayed as a 24-character string	5f2c3f6b5b4c177b9a6dc388
category_name_level5		Name of the fifth category level of the venue	Korean BBQ Restaurants
chain_id	string	Foursquare’s unique identifier for a particular chain; displayed as a 24-character string	556d1d36aceaff43eb0a9e60
chain_name	string	Name of the chain	Old Navy
parent_venue_id	string	The ID of the parent venue if this venue is located in an airport, shopping centre, etc.	4eb0307f6c250ddebea09895