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

Local business datasets look simple until locations, service areas, categories, and review dates start disagreeing. The schema keeps those differences visible instead of flattening them into one vague local field.

That makes the records more useful for regional research and easier to refresh later.

Designed For

  • local market mapping
  • service category research
  • directory enrichment
  • regional coverage comparisons

Coverage

Record unitOne service business and locality observation
GeographyCity, state, postal code, and service area when available
Source requirementPublic source stored per row
Review fieldsSource-specific and date-stamped
Field Dictionary

Schema Preview

FieldTypeDescriptionExample
business_namestringPublished business nameExample Home Services
service_categorystringNormalized service typeroofing
localitystringCity or named marketJacksonville
review_countintegerSource-specific public review count128
last_verifieddateDate the listing was checked2026-09-20
Illustrative Rows

Illustrative Local Service Records

business_nameservice_categorylocalityreview_countlast_verified
Example Home ServicesroofingJacksonville1282026-09-20
Sample Property CarelandscapingOrlando742026-09-20

Names are illustrative. Public review values require their original source and collection date.

Collection And Preparation

  • Collect public business and service-area records with source notes.
  • Normalize service categories without deleting the original category wording.
  • Keep review counts and ratings tied to their source and collection date.
  • Distinguish physical locations from service areas when the source supports it.

Known Limits

  • A service area does not prove a staffed office in every listed city.
  • Review values change and require a collection date.
  • Category normalization can group businesses differently from the source platform.
  • Illustrative rows do not identify real businesses.

Useful Applications

  • compare service coverage
  • map businesses by city
  • normalize category labels
  • audit public listing freshness

Change Log

  • Added field dictionary, locality rules, sample records, methods, and limits.