Context Demographics is compiled using two inputs: Precisely boundary polygons and demographic data inputs. Precisely boundary polygons are refreshed on a quarterly basis. Demographic data inputs are updated yearly as data is made available by the US Census Bureau.
The structure of the Context Demographics data schema workbook changed in this release. Changes include renaming and re-ordering existing columns, as well as the addition of several new columns. Additionally, all CHAR and VARCHAR data types are now represented as TEXT, and data type and field length are represented in two separate columns.
The following columns were added to the schema workbook:
- product_table_name
- index
- primary_key
- type_code
- table_name
- grouping
Refer to the Notices tab in the schema workbook for additional information.
The following column name changes were made in the schema workbook:
| Former Column Name | New Column Name |
| Table Name | table_friendly_name |
| Seq. | sequence_number |
| Field Name | field_name |
| Field Value Key Reference | field_value_key_reference |
| Description | description |