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.
| 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 |
Updated 10 months ago