Skip to content

Update to use sex column instead of gender column #686

@ageiduschek

Description

@ageiduschek

Context

The recidiviz-data backend has added a new sex column to public dashboard views. The existing gender column is now a backwards-compatible alias that will be removed in the future.

Task

Update the public-dashboard frontend to reference the sex column instead of gender for all data fetched from the following BigQuery views:

  • public_dashboard_views.incarceration_lengths_by_demographics
  • public_dashboard_views.incarceration_population_by_admission_reason
  • public_dashboard_views.incarceration_population_by_month_by_demographics
  • public_dashboard_views.incarceration_releases_by_type_by_period
  • public_dashboard_views.population_by_facility_by_demographics (template-based view)
  • public_dashboard_views.recidivism_rates_by_cohort_by_year
  • public_dashboard_views.sentence_type_by_district_by_demographics
  • public_dashboard_views.supervision_population_by_district_by_demographics
  • public_dashboard_views.supervision_population_by_month_by_demographics
  • public_dashboard_views.supervision_revocations_by_period_by_type_by_demographics
  • public_dashboard_views.supervision_terminations_by_period_by_demographics

Testing

Verify that all visualizations and data displays continue to work correctly after the column name change.

Follow-up

Once this is deployed, notify the Data Platform team so they can remove the backwards-compatible gender column (tracked in Recidiviz/recidiviz-data#51944).

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions