Reassign subgroup for subgroup_type"all" as “All instead of "NA"
The subgroup for subgroup_type "age" ended up being numbers (1014and 1517) instead of the labels: “Age 10 to 14” and “Age 15 to 17”
The subgrouplabels don't match what we expect. The labels should be capitalized, and the labels for race-ethnicitysubgroup_type should be: All, Black; Hispanic; Other Races and Ethnicities; White, Non-Hispanic.
The variable order is off. It should be: year, state, county, subgroup_type, subgroup, rate_juv_arrest, rate_juv_arrest_quality
subgroup_type"all" as “All instead of "NA"subgroup_type"age" ended up being numbers (1014and1517) instead of the labels: “Age 10 to 14” and “Age 15 to 17”subgrouplabels don't match what we expect. The labels should be capitalized, and the labels forrace-ethnicitysubgroup_typeshould be:All,Black;Hispanic;Other Races and Ethnicities;White, Non-Hispanic.year,state,county,subgroup_type,subgroup,rate_juv_arrest,rate_juv_arrest_quality