bgruswitz
commented
2 years ago @mmolta thanks for these changes!
- Just so you know, this may need some revision to the source csv before launching, but it will still be 2019 data. And we'll have a new table for char 3 before pushing this to production this (hopefully by August/September).
- I forgot to have you change the y axis label in the first and second chart to "Dollars (2019)"
- Remind me if there's something we can do to have the lines continue straight to the next year with a value when we have null values in some years.
General request
In 4 of the 5 charts on this page, we want to add to the sum of aggregate minority groups (People of Color and/or Latinx) some of the disaggregated groups that comprise these totals. Consequently, the prior tables with geography names for field names will now have further descriptions concatenated to them, and those that had a geography + descriptive concatenation for a field name will have more fields added.
We’re adding trending lines for
Note: we have field for “Other” but the groups aren’t consistently significant enough across the region to avoid suppression. We’ll continue to collect the data, and if we start getting more consistently reported groups across the region, we may add this in the future. For now, you’ll ignore displaying the data.
The trendlines for these new groups will be off by default. The existing trendlines will be on by default.
Here’s a table of all the drop-down menu names and the first characters of the field names, containing the geography portion of the concatenation.
Chart 1: Median Income Gap between People of Color & Latinx Populations vs. White, non-Latinx Population
Title Change: Median Income Gap Relative to Households with White, non-Latinx Householder
Label Changes
Default On:
Default Off:
Field Names (examples) from G:\Shared drives\Long Range Plan\Data & Indicators\Tracking Progress\Web\Data\Racial & Ethnic Disparities\medincGapRace.csv
People of Color & Latinx:
Burlington_NonWht,Camden_NonWht, … Black, non-Latinx:Burlington_Black,Camden_Black, … Asian, non-Latinx:Burlington_Asian,Camden_Asian, … Latinx:Burlington_Latinx,Camden_Latinx, …Chart 2: Median Income by People of Color & Latinx Populations vs. White, non-Latinx Population
Title Change: Median Household Income by Householder’s Major Race or Ethnic Group
Label Changes
Default On:
Default Off:
Field Names (examples) from G:\Shared drives\Long Range Plan\Data & Indicators\Tracking Progress\Web\Data\Racial & Ethnic Disparities\medincRace.csv
People of Color & Latinx:
Burlington_NonWht,Camden_NonWht, … White, non-Latinx:Burlington_White,Camden_White, … Black, non-Latinx:Burlington_Black,Camden_Black, … Asian, non-Latinx:Burlington_Asian,Camden_Asian, … Latinx:Burlington_Latinx,Camden_Latinx, …Chart 3: Racial/Ethnic Segregation Index
No changes
Chart 4: Labor Force Participation Gap Relative to Whites
Title Change: Labor Force Participation Gap Relative to White Participation Rate
Label Changes
Default On:
Default Off:
Field Names (examples) from G:\Shared drives\Long Range Plan\Data & Indicators\Tracking Progress\Web\Data\Racial & Ethnic Disparities\labForceByRace_gap.csv
People of Color:
Burlington_NonWht,Camden_NonWht, … Black, non-Latinx:Burlington_Black,Camden_Black, … Asian, non-Latinx:Burlington_Asian,Camden_Asian, …Chart 5: Labor Force Participation by People of Color & Whites
Title Change: Labor Force Participation by Race
Label Changes
Default On:
Default Off:
Field Names (examples) from G:\Shared drives\Long Range Plan\Data & Indicators\Tracking Progress\Web\Data\Racial & Ethnic Disparities\labForceByRace.csv
People of Color:
Burlington_NonWht,Camden_NonWht, … White:Burlington_White,Camden_White, … Black:Burlington_Black,Camden_Black, … Asian:Burlington_Asian,Camden_Asian, …