Motionworks provides much of its data referenced to standard units of geography like Census Block Groups in the United States or Statistics Canada Dissemination Areas. As a reference for users, Motionworks provides the versions of these geographic references with additional attributes allowing users to:

• Show the geographies on a map.
• Analyze the data geospatially.
• Cross-reference between geography types
• Understanding how geographies are changing through time

In addition to the basic geography definitions shown here, the following supplemental tabulations are available:

• United States Census Block Groups cross-reference from 2010 publication to other years
• United States Census Block Groups cross-reference to larger Regional Areas (including MSAs and CBSAs)
• United States Census Block Groups cross-reference to DMAs
• United States Census Block Groups cross-reference to Postal Zip Codes

Available Geography

  <th>
    Geographies Available
  </th>

  <th>
    Frequency
  </th>
</tr>

  <td>
    <ul><li>Local Government Areas</li><li>Localities</li><li>Postal Areas</li><li>States and Territories</li><li>Statistical Area 1</li><li>Statistical Area 2</li><li>Statistical Area 3</li><li>Statistical Area 4</li></ul>
  </td>

  <td>
    2021
  </td>
</tr>

<tr>
  <td>
    Canada
  </td>

  <td>
    <ul><li>Census Division</li><li>Census Subdivision</li><li>Census Tracts</li><li>Dissemination Areas</li><li>Economic Regions</li><li>Metropolitan Areas</li><li>Provinces and Territories</li></ul>
  </td>

  <td>
    2016
  </td>
</tr>

<tr>
  <td>
    United States
  </td>

  <td>
    <ul><li>Block Groups</li><li>Counties</li><li>Metro Divisions</li><li>Metropolitan Statistical Areas</li><li>Micropolitan Statistical Areas</li><li>States</li><li>ZIP Code Tabulation Areas</li></ul>
  </td>

  <td>
    2010\
    2020
  </td>
</tr>

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 geography across the country, year, geography type, and national identifier.	string	US2020STCO36061
country_code	Two-letter ISO-3166 country code for which country this geography applies.	string	US
year	Year for which this record is relevant.	integer	2020
geography_type	A description of the geography type. See available Available Geography above.	string	stco (county)
national_id	The unique identifier for the geography within the country of origin. Usually unique to the year and geography_type.	string	36061
geography_name	The common name, if applicable, for the geography.	string	New York County
geography	The Well-Known-Text (WKT) spatial representation of the geography.	string	POLYGON((-81.849327 38.422626, -81.84939 38.422903,...))