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
- Korea
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
- Translated Venue Name
- Latitude/Longitude
- Geocodes
- Address
- Address Extended
- DMA
- Region
- Admin Region
- Postal Code
- Post Town
- Neighborhood
- PO Box
- Country Code
- Locality
- Date Created
- Date Refreshed
- FSQ Category IDs
- FSQ Category Labels
- FSQ Chain ID
- FSQ Chain Name
- Parent ID
- Subvenue Count
- Census Block ID
- Closed Bucket
For more details, please see the Core Attributes descriptions.
Add On Options
Rich Attributes
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 2 months ago