WORLD CONSUMER INTELLIGENCE — CONNECTED EDITION V2.0.0
A Foursquare Publishing Workbench powered by National Data System.

NORMAL USE
Open the hosted website. Choose a business type, country or US ZIP to see recorded counts, shares, country/ZIP rankings, hierarchy comparisons and evidence briefings. No scripts, exports or CSV imports are required for this included snapshot.

DEPLOY TO NETLIFY
Extract this ZIP and deploy the entire extracted folder, with index.html at its root. No build command, server database, API credentials or DuckDB installation is required. Keep all matrix-data files and JavaScript/CSS assets beside the pages. The site reads selected categories on demand; it does not download or query the raw places database.

PAGES
index.html — Explore the consumer economy.
countries.html — Every observed country label, with names, ISO identities and source totals.
zips.html — Search and compare observed five-digit US postal ZIP labels.
categories.html — Search every Category ID and all six hierarchy levels, including unresolved source IDs.
matrix.html — The eight-question intelligence matrix, connected to real results.
methods.html — Source, counting method, coverage and unresolved identities.
tools.html — Optional technical category planning, SQL/PowerShell and publishing tools.
matrix-technical.html — Optional detailed matrix, package validation and local-folder loading.

INCLUDED DATA
Build b20261031214202896_498e5f68 / PASS. 109,255,094 source rows and distinct usable place IDs; zero missing IDs. 6,169,754 positive category/geography observations. 1,668 Category IDs (1,279 reference entries plus 389 unresolved source IDs). 254 country labels, including six without an authority match. 43,302 observed US ZIP labels.

VALIDATION
All 1,670 declared files were checked against their exact SHA256 hashes and byte lengths. All 6,169,754 count pairs were checked for uniqueness and denominator bounds. Global and country totals reconcile. ZIP counts do not exceed the corresponding US country count. Every mapped parent contains each child's count at each geography. Every selected category file is checked again in the browser before its results are displayed.

WINDOWS PACKAGE COMPATIBILITY
The one-record Windows PowerShell metadata wrapper and ZIP path separators were normalized during integration. Original declared data-file bytes, hashes, place counts, Category IDs and geography identities were preserved. No raw database was read or rebuilt during website integration.

INTERPRETATION
Counts describe source-recorded supply in the August 2026 source snapshot, including closed records. They do not establish current operation, complete real-world coverage, business quality, population-adjusted access, consumer preferences, demand or future event dates. Parent/child categories overlap and must not be summed. Observed zeros differ from absent geographies. Unknown country identities retain counts without country ranks. Ties share dense-rank positions. Six-level hierarchy mappings are only assigned where the reference supplies them; 389 unresolved source IDs retain their own counts.
Nightlife Spot reports 2 places in that exact mapped branch and needs category-identity review before publication. This is not a count of all nightlife worldwide. Natural display aliases such as South Korea and Events remain linked to original country/category identities.

LOCAL FILE USE
The connected site needs HTTP/HTTPS because browsers restrict fetching neighboring JSON from file:// pages. Use the hosted site or a local static server. The self-contained technical catalog at tools.html still works directly from a local file. A local-folder loader remains available at matrix-technical.html.

EXPORTS AND BRIEFINGS
CSV downloads use saved summary data and include source build and category identity. Compare mode downloads the selected pair of countries. Copy briefing produces source-backed text; browser Print can save the current report as PDF. Original source counts are not modified by these controls.

TECHNICAL TOOLS
The included builders/exporters are for maintaining future snapshots. Do not rerun the whole-database builder merely to use this completed release. The saved database remains on the owner's F: drive; this website contains the compact exported summaries only.

GEOGRAPHIC DRILL-DOWN CLARIFICATION
Business-type depth is independent of geographic depth. A category ending at Level 2 still supports country and US ZIP counts. Geography controls are visible in every result view, with a direct five-digit ZIP field and country/ZIP actions on leaf-category screens. US ZIP views show how many US records have usable postal labels and how many remain unassigned. Example: Night Club has 42,375 US records; 34,494 carry usable US ZIP labels across 9,133 observed ZIPs, while 7,881 remain only in the country total. City/locality totals are not included in this saved summary layer.

ZIP CITY AND STATE LABELS
The owner's existing zip_state_city_county.csv reference adds city/state labels to 38,366 of 43,302 source ZIP labels, covering 22,209,605 of 22,221,442 ZIP-linked place records (99.95%). Repeated county rows collapse only when city/state agree. Missing labels remain explicitly unavailable; no ZIPs, counts, or ranks were removed or inferred. City labels describe postal ZIPs rather than municipal boundaries. Original reference vintage is unspecified. The labels appear in result headings, ZIP rankings, city/state search, matrix results, briefings, and CSV city/state columns.
