Recorded supply
Rank geographies by distinct place IDs matching your category set. Larger places may naturally have more listings.
PUBLISHER & DATA TOOLS
Explore the full Foursquare taxonomy. Choose a branch, set your geography, and turn an idea into a clear research plan.
Published category reference · October 31, 2026
Full dictionary included. No topic selection.
Search checks original category names, IDs, and every parent level. Common word forms, punctuation, and spacing are handled on both sides. Typing a new search clears browse filters; filters can then narrow its results. Related-term matches are labeled. No place records or business counts are searched here.
Your words and catalog labels use the same matching rules for common singular/plural forms, accents, apostrophes, &/and, spaces, and hierarchy separators. Original category labels and IDs stay unchanged. Keyword fragments and reordered words can also match a path.
Every one of the 1,279 names, IDs, and full paths is checked automatically, along with word-form and punctuation cases. These checks verify known catalog retrieval; they do not prove every possible English phrase has a category match.
Related terms are limited to the mappings below. This is a category search, without general question answering, automatic typo correction, translation, or a live event calendar. A zero result means no category term matched your wording, not that a service or business does not exist.
PROJECT BUILDER
Your choices become a brief and a query template. The workbench does not run a database query.
Population rates require a compatible population source. A composite score requires a defined method.
FROM CATEGORY LABELS TO PLACE EVIDENCE
The category tree organizes questions. Returned place summaries supply the evidence.
Rank geographies by distinct place IDs matching your category set. Larger places may naturally have more listings.
Compare matching places as a share of all observed places in the same geography. Missing categories stay in the denominator.
Add a compatible geography and year population source for a per-person rate. Population is not part of the taxonomy.
Run the exported ranking query against your existing DuckDB, then import its CSV here. The workbench checks the project identity, counts, and denominator before displaying it.
No category-specific CSV loaded. The saved build summary above is a separate result.
Choose a category, run its saved-ranking lookup locally, and import the returned CSV here.
| Rank | Geography | ISO3 | Matching places | All places | Share |
|---|
REUSE WHAT YOU ALREADY BUILT
The workbench is self-contained. It does not need the large places database to help you plan.
1,279 original IDs and full paths across 11 major labels. Search, inspect, and export any branch.
Reference retrieved October 31, 2026. Exact vintage match to the August 18 places build remains unverified.
248 country profiles from your existing Commercial Diplomacy Index reference, with ISO3 identities where supplied.
Source build: August 18, 2026. Summary positions are existing country measures, not rankings for your selected category.
The Commercial Diplomacy Index code supports country search by category ID or label using its prepared online files.
This standalone app is not connected to the live place feed. Existing endpoint availability and cross-site access need verification.
Open existing directory ↗Your full build completed on October 31, 2026: 109,255,094 distinct places and 6,169,754 ranking rows. No rebuild is needed to query that snapshot.
This reusable builder reads every source geography and category from your existing global places DuckDB in read-only mode. It saves category counts, geography totals, and count/share ranks in F:\databases\Foursquare_Consumer_Intelligence.duckdb.
Temporary files, destination WAL, and reports use F:. The source stays at E:\NDS_DUCKDB\databases\Global_Human_Places_Foursquare_OS.duckdb. A narrow internal staging set contains only place IDs, geography labels, and category IDs. It is removed after success; the source database is not copied.
Execution starts when you run the downloaded script. A disk-capacity check runs before either database is opened. Defaults: 256 exact-count batches, 4 GB memory setting, 1 thread, 100 GB maximum temporary spill, and 140 GB required headroom on F: (an allowance, not a reservation). Named stages show completed batches and measured CPU/memory. Each completed batch is saved. Use -ResumeRun with that run’s folder to skip completed batches after a failure or timeout. Initial staging must finish before resume is available. For the completed build, select “Saved database ranking tables” and “Rank geographies”; those scripts default to the F: intelligence database. Independent category sets still require a source query to deduplicate overlapping places.
The geography and category selections travel in the project JSON and SQL. Keep source attribution and the snapshot with the output.
The build record says PLACES_ONLY_BASELINE and separate_category_hierarchy_materialized: false. Category IDs and labels were preserved on the place rows.
Your DuckDB also has country profile and rank-register tables. The full category hierarchy was a separate missing reference; it did not prevent later counts or rankings from the place records.
Foursquare category reference: FSQ Docs published dictionary. Nightlife Spot remains a separate source branch. Source row counts and category entries are different measures. No observed category coverage is certified by loading this dictionary. Category summaries describe recorded supply; they do not establish current operation, prices, quality, demand, preferences, or licensing.