US Block Groups DMA Reference

As a reference for users, Motionworks provides this cross-reference to allow users to understand how data reported at the United States Census Block Groups may be aggregated to describe the Designated Market Area (DMA).

The universal geography_id is used and can be referenced back to the core Geography Reference Datasets.

Schema

Motionworks delivers Geography via Snowflake or can be delivered using a compressed flat file output (csv.gz) via cloud storage. The following describes the schema.

NameDescriptionTypeExample
geography_idUnique identifier for the block group geography across years.stringUS2020XXBG090010202001
dma_geography_idUnique identifier for the DMA across yearsstringUS2020XDMA501
dma_idUnique identifier DMAstring501
dma_nameName of the DMA.stringNew York, NY