Places Flat File
Overview
Places data brings together firmographic venue details from authoritative third-party sources and billions of user-generated photos, tips, and reviews from our decade of experience crowd-sourcing consumer feedback.
- Core data and rich data
- Enrich your existing venue database with rich, user-generated content
- Download fresh, up-to-date venue content verified by humans, software and third parties
- Customize data to your business needs:
- Delivered daily, weekly or monthly
- Available via JSON or TSV
Package Types
Determine which Places flat file package is right for you by following a simple three-step process:
- Select the countries or regions you’re interested in
- Decide if you’d like to add on any rich attribute packages
- Decide if you need data on specific categories based on your business needs
Available Countries & Regions
Countries
- US
- Canada
- Mexico
- Australia
- Brazil
- France
- UK
- Italy
- Germany
- Japan
Regions
- LATAM
- Western Europe
- Eastern Europe
- MEA
- Pacific (Australia & NZ)
- SouthEast Asia (Sg/MY/TH/ID/PH/VN)
- South Asia (India)
- North Asia (Cn/TW/HK)
Standard Package
The Standard Package includes the following Core Attributes:
- Venue ID
- Venue Name
- Latitude
- Longitude
- Address
- City
- DMA
- State
- Postal Code
- Country Code
- Date Created
- Primary Category ID
- Primary Category
- Secondary Category ID
- Secondary Category
- Chain ID
- Chain Name
- Parent Chain ID
- Parent ID
- Total Subvenues
Add On Options
Rich Attributes
- Ratings, Hours, Social Media
- Hours
- Popular Hours
- Total Tips
- Phone Number
- URL
- Facebook ID
- Instagram Handle
- Twitter Name
- Rating
- Description
- Price
- Reviews, Tips, Tastes & Menus
- Total Photos
- vrr.photo1
- Tip1...Tip25
- Taste1...Taste25
- (Reviews, Tips, Menus, Tastes, Best Photo)
- Best Photos
- Total Photos
- Photo1
- Photo2
- Photo3
- Photo4
- Photo5
- (Best Photo, Top 5 Photos, Photo Captions)
- Calculated Scores
- Score Popularity Foot Traffic (country or geo level)
- Venue Reality Score
- Score Open Close
- All Extended Attributes
- All packages above +
- Date Approximate Closed
- Score Open Close
- All packages above +
Category Packages
- Restaurants/Food & Nightlife
- All Attributes
- Retail/Shops & Services
- All Attributes
- Travel & Transport
- All Attributes
Delivery
Determine which Places flat file delivery cadence fits your business needs.
Cadence
- Daily
- Weekly
- Monthly
- Quarterly
Format
- Delivered as a TSV file with GZIP compression via Amazon S3. For assistance on how to obtain your user ARN or how to use S3, read this guide or contact your technical account manager at Foursquare.
- Provided in compressed, tab-delimited files, one file per country.
- The format and the standard filename convention is as follows:
s3://fsq-partner-orgId/client/DeliveryName/dt=scheduledDeliveryDate/places_countrycode.tsv.gz
Where orgId is a 25-character string unique to your organization.
- Compression is gzip format -- it can be opened with most Windows, Linux, and Mac compression utilities.
Updated 5 months ago