Individual Data Processor

It is often the case that your data is collected at the individual level. These data will be need to be aggregated to the region (and age group, for age standardized rates) for rate calculations within the Rate Stabilizing Tool. This tool was developed to make that process easier!

Parameters

Age Stratified : checkbox

Should the output table be stratified by age group?

Input Individual Data : table path

Table with one record for individual event. Each record must contain a Region ID and, if Age Stratified is checked, Age.

Input Individual Data Fields

Region ID : field name

Name of column which uniquely identifies each region.

Age : field name

Name of column which specifies the age of the individual the event occurred to.

Input Population Data : table path

Table with one record for each Region ID OR one record for each Region ID and Age Group combination. Table must an additional column which specifies the Population Count for each Region ID OR Region ID and Age Group combination.

Table can easily be generated using the Census Data Retriever.

Input Population Data Fields

Region ID : field name

Name of column which uniquely identifies each region.

Population Count : field name

Name of column which contains the population of each region OR region-age group combination.

Age Group : string

Name of column which specifies age groups.
The following are valid age groups: “0-4”, “5-14”, “15-24”, “25-34”, “35-44”, “45-54”, “55-64”, “65-74”, “75-84”, “85up”.

Input Feature : feature path

Boundary file which contains one record for each Region ID.

Input Feature Fields

Region ID : field name

Name of column which uniquely identifies each region.

Output Table : table path

Path of the output table which contains the combined population and aggregated event data.

Examples

Scenario 1: I want to generate crude rates for some Michigan event data I have. I first need to aggregate this data (MI_mort_indiv within data.gdb) and combine it with population data from Census Data Retriever (MI_pop within data.gdb).

  • Age Stratified: Unchecked
  • Input Individual Data: data.gdb/mi_event_indiv
  • Input Individual Data Fields:
    • Region ID: GEOID
  • Input Population Data: data.gdb/mi_pop
  • Input Population Data Fields:
    • Region ID: GEOID
    • Population Count: PopulationCount
  • Input Feature: data.gdb/mi_carto
  • Input Feature Fields:
    • Region ID: GEOID
  • Output Table: some_project.gdb/MI_mort_pop

Scenario 2: I want to generate age-adjusted rates for some Michigan event data I have. I first need to aggregate this data (MI_mort_indiv within data.gdb) and combine it with population data from Census Data Retriever (MI_pop_grouped within data.gdb).

  • Age Stratified: Checked
  • Input Individual Data: data.gdb/mi_event_indiv
  • Input Individual Data Fields:
    • Region ID: GEOID
    • Age: Age
  • Input Population Data: data.gdb/mi_pop_strat
  • Input Population Data Fields:
    • Region ID: GEOID
    • Population Count: PopulationCount
    • Age Group: AgeGroup
  • Input Feature: data.gdb/mi_carto
  • Input Feature Fields:
    • Region ID: GEOID
  • Output Table: some_project.gdb/MI_mort_pop