Foursquare Database

Foursquare’s Places Flat File is available for delivery in either JSON and TSV format. Get access to:

  • 60M+ commercial POI including restaurants, shops & services, and more
  • 941 Venue Categories (full list available here), updated quarterly
  • 1M+ fresh* Tips
  • 18.5M+ fresh* Photos
  • 1M+ Tastes, popular search terms generated by our consumer app users
  • 23K+ Chains, including top QSRs, retailers, auto dealerships, and more
  • 7.6M+ Venues with popular hours
  • *Added within the past six months

Explore Our Packages and Schema

Core Data

Column Name Type Description Example
venueid String The unique identifier of a Foursquare venue. Use this ID to view a venue at foursquare.com by visiting: http://www.foursquare.com/v/{Foursquare ID} 4b3e40f7f964a520379a25e3
venuename String User-entered name of a venue as seen on Foursquare City Guide. Key West International Airport (EYW)
translatedvenuenames Array(String) User-entered translated name(s) of a venue. The translated name will also include a ISO 639-1 language code and follows the following format: [Translated Venue Name,language code(en for English, ja for Japanese, etc)]. Note that most POIs will not include a translated name. Generally, this attribute will only exist for very popular POIs. [[ニューヨーク マリオット マーキス, ja,,], [New York Marriott Marquis, en,,]]
latitude String(Float) Foursquare latitudes/longitudes are derived by a combination of a centroid generated using latitude/longitude from check-ins from our Swarm and City Guide apps, as well as direct input of precise latitude/longitude (a pin drop) from our Superuser corrections, and also during initial user venue creation. 24.55376008
longitude String(Float) Foursquare latitudes/longitudes are derived by a combination of a centroid generated using latitude/longitude from check-ins from our Swarm and City Guide apps, as well as direct input of precise latitude/longitude (a pin drop) from our Superuser corrections, and also during initial user venue creation. -81.75512391
address String User-entered street address of the venue 3471 S Roosevelt Blvd
city String City the venue is located in. Key West
dma String DMA ( Designated Market Area, as defined by Nielsen) the venue is located in. This signifies a region where the population can receive similar TV and radio offerings in the USA. There are 210 DMAs in the United States. Miami-Fort Lauderdale, FL
state String String representing the state or province that this venue is located in. Derived by geocoding the user-entered city/state name. Florida
postalcode String Postal code of the venue. Derived by normalizing the user-entered postal code. Format will be localized based on country (i.e. 5-digit number for US postal code) 33040
countrycode String A two character string representing the country the venue is located in. US
date_created Date The date the venue entered our database. This does not necessarily mean the venue actually opened on this date. 2010-01-01
date_approximateclosed Date The date the venue was marked as closed in our database. This does not necessarily mean the venue actually closed on this date. 2010-01-02
score_openclose String Probability that a venue is closed (Low, High, Very High). Low indicates: not
likely closed. High indicates: likely closed. Very High indicates: the venue is marked as closed in our database. Null value indicates: not
confident enough to make a judgement. To calculate High and Low confidence, Foursquare uses a
statistical model that looks at the rate of change of check-ins and
unique visitors to a venue, as follows:
(a) only consider venues with a minimum threshold of check-ins
and unique visitors; (b) identify venues with significant drops
in check-ins and unique visitors; (c) measure the persistence of
those drops; and (d) venues that meet statistical significance on
the above tests will be flagged as High Confidence of close, while
venues with lower statistical significance will be marked as
Low confidence
High
category_primaryid String The primary category ID of a venue as inputted into Foursquare City Guide. 4bf58dd8d48988d1e5931735
category_primary String The name of the primary category of a venue. Music Venues
category_secondaryid String The secondary category ID of a venue as inputted into Foursquare City Guide. 4bf58dd8d48988d1e5937362
category_secondary String The secondary category of a venue. This venue category is not a sub-category of the primary venue category. Event Spaces
phonenumber String Phone number of the venue 5552221111
chainid String The Foursquare chain ID of a venue. Use in conjunction with chainname. 556ca462a7c87f63786aa4d8
chainname String Standardized chain name of a venue. Use in conjunction with chainid. IKEA
totalsubvenues String If a venue is a super-venue (a venue with child venues, e.g. a mall), total sub-venues will indicate how many venues this venue is a parent of (how many stores are in this mall) 10

Rich Data

Column Name Type Description Example
rating String(Float) The rating of a venue (0-10) based on user votes as well as an internal score aggregated by likes /dislikes, tips,and visit traffic 8.02
price String A description of the price of a venue's offerings on the following scale: Cheap, Moderate, Expensive, Very Expensive. On Foursquare City Guide this is portrayed as $,$$,$$$,$$$$ Expensive
url String URL to the venue’s (or the chain’s) publicly available website http://website.com
hours List of lists This attribute describes the hours that the venue is open for business. It is available as a list of lists.

In each list, there are the following values: day, starttime, endtime. Day may have a value between 1 and 7, with 1 representing Monday and 7 representing Sunday. Starttime and endtime are integers that when divided by 60 yield the hour and minutes in military time:

For example: [1,660,1320,] would convert to Monday: open starting at 660 == 11am, and closed at 1320 == 10pm.
[[1, 990, 1320,], [2, 990, 1320,], [3, 990, 1320,], [4, 990, 1380,],
[5, 690, 1440,], [6, 1050, 1440,], [7, 1050, 1320,]]
hours_popular List of lists Hours of the week when people typically visit a venue.Foursquare’s popular hours algorithm is calculated in the following way: Calculate a histogram of check-ins per time bin. There are 168 time bins, one for each hour of the week. Find time bins that have a specified percentage more check-ins than the average time bin and label these as popular. Fill in any one hour gaps with the rule: if the hour before is popular and the hour after is popular, then the hour in the middle is also popular. A venue must have a minimum number of check-ins to be considered for the calculation. The format for popular hours is as follows: day of the week (1 = monday, 7 = sunday), begin (24-hour time), end(24-hour time) 3,1200,1400;3,1700,2200;4,1200,1500;4,1700,2200;5,1200,2300;6,1000,2300;7,1000,2100;1,1200,1400;1,1800,2100;2,1700,2200
facebookid String This venue's Facebook ID, if available 17440921489
instagramhandle String This venue's Instagram handle, if available choptsalad
twittername String This venue's Twitter handle, if available chopt
description String General description of a venue - this is a free form box. If the venue is "verified" (claimed by the owner) the owner will update this field, otherwise this is typically managed/edited by Superusers Art's Cafe is a family owned diner located in the heart of the Sunset District in San Francisco. Our menu offers a broad array of traditional American breakfast items, lunches and Korean cuisine.
photo String A url that links to the photos submitted by our users. They are ranked by the TrueSkill algorithm and marked in the following way: photo1, photo2, photo3, et cetera. http://ir.4sqi.net/img/general/original/photo.jpg
taste String Tastes are nouns or noun-phrases that signify unique qualities of the venue. These are extracted using NLP from tips and shouts from Foursquare apps. Tastes are ranked using a combination of affinity and frequency, and are marked in the following way: taste1 (most frequent/positive noun/noun-phrase associated with the venue), taste2, taste3, etc. chocolate cream pie
tip List of Strings Recommendations (or warnings) posted by our users on our site and in our apps. This is an open text box. the format is as follows : [TipID, TipText] . Tips are ranked by the amount of times a tip was liked, and they are marked in the following way: tip1(most liked), tip2, tip3, etc. ["519feb3c498e034cc2c2ec0e","One of L.A.'s greatest culinary legacies is the California lunchroom burger, the multi-layered composition of iceberg lettuce, pickles and slightly underripe tomatoes."]
parentid String The Foursquare ID of a venue’s parent venue. Foursquare maintains parent/child relationships for venues located inside venues (e.g. stores in malls. 4b04db31f964a520cb5622e3
totaltips String Total number of tips users have submitted for a particular venue (all-time) 65
totalphotos String Total number of photos users have submitted for a particular venue (all-time) 15
popularity_score String Measure of a venue’s popularity by foot traffic. This score is on a 0 to 1 scale and uses a 6-month span of venue visits for a given geographic area. The most popular venue in the geographic area is assigned the score .9999. This score can also be calculated for various geographic classifications such as country, state, city, zip, and DMA. .6571
score_venuereality String This attribute represents how “real” Foursquare believes a venue to be. As venues can be submitted directly by users, Foursquare uses a proprietary algorithm to assess real venues (public places like a popular restaurant, store, concert venue, etc) vs a private or nonexistent venue. Foursquare’s VRS algorithm uses a combination of explicit and implicit signals (examples include number of searches on Foursquare, number of photos/tips submitted, number of check-ins, etc) to bucket venues with an output of Low, Medium, High, Very High Very High
atm String(t/f) This attribute denotes whether a venue has an ATM available. May be "t" or "f" (True or False) t
beer String(t/f) This attribute denotes whether a venue has beer available. May be "t" or "f" (True or False) t
barservice String(t/f) This attribute denotes whether a venue has bar service available. May be "t" or "f" (True or False) t
businessmeeting String This attribute denotes whether a venue is fit for hosting a business meeting on a scale like the following: Poor, Average,Great Great
byo String(t/f) This attribute denotes whether a venue allows for bringing your own beverages. May be "t" or "f" (True or False) f
clean String This attribute denotes whether a venue is considered clean on a scale like the following: Poor, Average,Great Great
coatcheck String(t/n) This attribute denotes whether a venue has coat check available. May be "t" or "n" (True or False) n
cocktails String(t/f) This attribute denotes whether a venue has cocktails available. May be "t" or "f" (True or False) t
crowded String This attribute denotes whether a venue is considered crowded on a scale like the following: Poor, Average,Great Poor
datespopular String This attribute denotes whether a venue is considered popular to go to on dates on. This is measured on a scale like the following: Poor, Average, Great Great
delivery String(t/f) This attribute denotes whether a venue delivers food or drink. May be "t" or "f" (True or False) t
dressy String This attribute denotes whether a venue is considered dressy on a scale like the following: Poor, Average,Great Great
drivethrough String(t/f) This attribute denotes whether a venue has a drivethrough. May be "t" or "f" (True or False) t
essentialreservations String(t/f) This attribute denotes whether a venue requires reservations for attending. May be "t" or "f" (True or False) t
familiespopular String This attribute denotes whether a venue is considered popular for families on a scale like the following: Poor, Average,Great Great
fullbar String(t/f) This attribute denotes whether a venue has a full bar available. May be "t" or "f" (True or False) f
glutenfreediet String This attribute denotes whether a venue accomodates for a gluten free diet on a scale like the following: Poor, Average,Great Great
goodfordogs String This attribute denotes whether a venue is good to bring your dog to on a scale like the following: Poor, Average,Great Great
groupsonlyreservations String(t/f) This attribute denotes whether a venue requires a reservation for groups. May be "t" or "f" (True or False) t
groupspopular String This attribute denotes whether a venue is considered popular for groups on a scale like the following: Poor, Average,Great Great
hasmusic String(t/f) This attribute denotes whether a venue has music (live or jukebox). May be "t" or "f" (True or False) t
hasparking String(t/f) This attribute denotes whether a venue has parking. May be "t" or "f" (True or False) t
healthydiet ? ? ?
jukeboxmusic String(t/f) This attribute denotes whether a venue has a jukebox to play music. May be "t" or "f" (True or False) t
latenight String This attribute denotes whether a venue is considered popular for late nights on a scale like the following: Poor, Average, Great Great
livemusic String(t/f) This attribute denotes whether a venue has live music. May be "t" or "f" (True or False) t
noisy String This attribute denotes whether a venue is considered noisy on a scale like the following: Poor, Average, Great Average
onlinereservations String(t/f) This attribute denotes whether a venue offers the option to make reservations online. May be "t" or "f" (True or False) t
outdoorseating String(t/f) This attribute denotes whether a venue offers outdoor seating. May be "t" or "f" (True or False) t
privatelot String(t/f) This attribute denotes whether a venue has a private parking lot. May be "t" or "f" (True or False) t
privateroom String(t/f) This attribute denotes whether a venue offers private rooms (for dining or parties). May be "t" or "f" (True or False) t
publiclot String(t/f) This attribute denotes whether a venue has a public parking lot. May be "t" or "f" (True or False) t
quickbite String This attribute denotes whether a venue is considered good for a quick bite of food on a scale like the following: Poor, Average, Great Poor
reservations String(t/f) This attribute denotes whether a venue offers reservations. May be "t" or "f" (True or False) t
restroom String(t/f) This attribute denotes whether a venue has restrooms. May be "t" or "f" (True or False) t
romantic String This attribute denotes whether a venue is considered good for a romantic occasion on a scale like the following: Poor, Average, Great Great
servesbarsnacks String(t/f) This attribute denotes whether a venue serves bar snacks. May be "t" or "f" (True or False) t
servesbreakfast String(t/f) This attribute denotes whether a venue serves breakfast. May be "t" or "f" (True or False) t
servesbrunch String(t/f) This attribute denotes whether a venue serves brunch. May be "t" or "f" (True or False) t
servesdessert String(t/f) This attribute denotes whether a venue serves dessert. May be "t" or "f" (True or False) t
servesdinner String(t/f) This attribute denotes whether a venue serves dinner. May be "t" or "f" (True or False) t
serveshappyhour String(t/f) This attribute denotes whether a venue has a happy hour. May be "t" or "f" (True or False) t
serveslunch String(t/f) This attribute denotes whether a venue serves serves lunch. May be "t" or "f" (True or False) t
servestastingmenu String(t/f) This attribute denotes whether a venue has a tasting menu. May be "t" or "f" (True or False) t
servicequality String This attribute describes the quality of service at a venue on a scale like the following: Poor, Average, Great Poor
singlespopular String This attribute denotes whether a venue is considered popular among singles on a scale like the following: Poor, Average, Great Average
sitdowndining String(t/f) This attribute denotes whether a venue offers sit-down dining. May be "t" or "f" (True or False) t
smoking String(t/f) This attribute denotes whether a venue allows smoking. May be "t" or "f" (True or False) t
specialoccasion String This attribute denotes whether a venue is considered popular for special occasions on a scale like the following: Poor, Average, Great Poor
streetparking String(t/f) This attribute denotes whether a venue offers street parking. May be "t" or "f" (True or False) t
takeout String(t/f) This attribute denotes whether a venue offers takeout. May be "t" or "f" (True or False) t
takesamex String(t/f) This attribute denotes whether a venue takes American Express. May be "t" or "f" (True or False) t
takescreditcards String(t/f) This attribute denotes whether a venue takes credit cards. May be "t" or "f" (True or False) t
takesdinersclub String(t/f) This attribute denotes whether a venue takes Diner's Club. May be "t" or "f" (True or False) t
takesdiscover String(t/f) This attribute denotes whether a venue takes Discover Card. May be "t" or "f" (True or False) t
takesmastercard String(t/f) This attribute denotes whether a venue takes MasterCard. May be "t" or "f" (True or False) t
takesnfc String(t/f) This attribute denotes whether a venue takes NFC (phone or chipcard) payment. May be "t" or "f" (True or False) t
takesunionpay String(t/f) This attribute denotes whether a venue takes UnionPay. May be "t" or "f" (True or False) t
takesvisa String(t/f) This attribute denotes whether a venue takes Visa. May be "t" or "f" (True or False) t
trendy String This attribute denotes whether a venue is considered trendy on a scale like the following: Poor, Average, Great Great
tvs String(t/f) This attribute denotes whether a venue has TVs. May be "t" or "f" (True or False) t
valetparking String(t/f) This attribute denotes whether a venue offers valet parking. May be "t" or "f" (True or False) f
valueformoney String This attribute denotes whether a venue is considered as providing good value for money spent on a scale like the following: Poor, Average, Great Average
vegandiet String This attribute denotes whether a venue provides vegan options on a scale like the following: Poor, Average, Great Great
vegetariandiet String This attribute denotes whether a venue provides vegetarian options on a scale like the following: Poor, Average, Great Poor
wheelchairaccessible String(t/f) This attribute denotes whether a venue is wheelchair accessible. May be "t" or "f" (True or False) t
wifi String(t/f) This attribute denotes whether a venue has WiFi. May be "t","f","p","n", or "fp" (true, free, paid, no wifi, free or paid) f
wine String(t/f) This attribute denotes whether a venue offers wine. May be "t" or "f" (True or False) t

Sample File

For a sample file, please check out our New York City and Washington DC venue data on Amazon’s Data Exchange here.


Did this page help you?