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.

Name	Description	Type	Example
geography_id	Unique identifier for the block group geography across years.	string	US2020XXBG090010202001
dma_geography_id	Unique identifier for the DMA across years	string	US2020XDMA501
dma_id	Unique identifier DMA	string	501
dma_name	Name of the DMA.	string	New York, NY