FormatsCSV / JSON / XLSX / PDF RefreshQuarterly review Version1.1 VerifiedSeptember 20, 2026

Regional comparisons fall apart when one row describes a city, another describes a county, and neither shows the denominator. This specification makes geography level and normalization part of the record.

The raw value remains beside the density calculation so another analyst can verify the math or use a different denominator.

Designed For

  • regional demand comparisons
  • market prioritization research
  • geographic normalization
  • location-based reporting

Coverage

Record unitOne topic and region observation
GeographyDeclared level required for every row
NormalizationPopulation or other denominator stored beside density
Time fieldMeasurement window and last verified date
Field Dictionary

Schema Preview

FieldTypeDescriptionExample
regionstringNamed geographic unitDuval County, Florida
geography_levelenumComparable region typecounty
raw_demanddecimalSource-specific demand value840
population_basisintegerDeclared normalization denominator1030000
demand_per_100kdecimalNormalized density measure81.55
Illustrative Rows

Illustrative Regional Density Records

regiongeography_levelraw_demandpopulation_basisdemand_per_100k
Duval County, Floridacounty840103000081.55
Orange County, Floridacounty1060147000072.11

Values are illustrative. A production density record requires the source, denominator year, topic, and time window.

Collection And Preparation

  • Record region name, geography level, and source identifier before calculating density.
  • Keep the raw demand value beside the normalized density value.
  • Store the denominator source and year with population-based calculations.
  • Compare regions only when topic, source, geography level, and time window match.

Known Limits

  • Density depends on the selected denominator and its source year.
  • Regions with different geography levels should not be compared directly.
  • Digital demand is not the same as purchases, population need, or service capacity.
  • Illustrative rows demonstrate structure only.

Useful Applications

  • normalize demand by population
  • compare matching geography levels
  • map regional topic density
  • document local data coverage

Change Log

  • Added normalization rules, field dictionary, illustrative rows, methods, and limits.