Cohort Component Model 1.0.0

Cohort Component Model 1.0.0

A Series 16 2025-2050 model run using the v25.1 2025 Annual Population, Housing, and Employment Estimates (see https://github.com/SANDAG/Estimates-Program/releases/tag/v1.2.3) has been loaded into the production database for internal review and development as [run_id]=1.

Major Updates

A new major version release was cut as large changes pushed in #183 changed naming conventions and database fields necessitating the use of a new data structure and production database. This release will also be the first-time data from the Cohort Component will be used in the development of production applications in SANDAG's Estimates & Forecasts team.

What's Changed

• [PULL REQUEST] Initial Input Modules Commit by @GregorSchroeder in #8
• [PULL REQUEST] Migration Input Module by @GregorSchroeder in #11
• [PULL REQUEST] HH/GQ Formation Input Module by @GregorSchroeder in #14
• [PULL REQUEST] Incorrect Module Setup for Base-Increment-Horizon Loop by @GregorSchroeder in #16
• [PULL REQUEST] Add SANDAG Estimates Controls by @GregorSchroeder in #17
• [PULL REQUEST] Formation Rate Summation Bug by @GregorSchroeder in #20
• [PULL REQUEST] Household Characteristics Input Module by @GregorSchroeder in #21
• [PULL REQUEST] Additional Birth Rate Years by @GregorSchroeder in #22
• [PULL REQUEST] Formation and Characteristics Rates Bugs by @GregorSchroeder in #25
• [PULL REQUEST] Enable Functional CCM Model by @GregorSchroeder in #33
• [PULL REQUEST] Missing Docstrings and README by @GregorSchroeder in #36
• [PULL REQUEST] NHPI Naming Convention by @GregorSchroeder in #39
• [PULL REQUEST] Add PR Template by @GregorSchroeder in #41
• [PULL REQUEST] Update DOF SQL data sources by @GregorSchroeder in #44
• [PULL REQUEST] YAML Migration by @GregorSchroeder in #47
• [PULL REQUEST] Update SQL files by @GregorSchroeder in #49
• [PULL REQUEST] Usability of Launch Year 2022 by @GregorSchroeder in #55
• [PULL REQUEST] Add smoothing function by @GregorSchroeder in #56
• [PULL REQUEST] Adding Social Security Actuarial Life Table by @KPHSANDAG in #60
• [PULL REQUEST] Logging Implementation by @GregorSchroeder in #62
• [PULL REQUEST] Fixing the incorrect data for the table by @KPHSANDAG in #64
• [PULL REQUEST] SQL Database Build #57 by @nivedya-mk in #65
• [PULL REQUEST] Bugs Associated with QA Run by @GregorSchroeder in #68
• [PULL REQUEST] ETL process and database diagram by @nivedya-mk in #71
• [PULL REQUEST] Add launch and horizon by @nivedya-mk in #76
• [PULL REQUEST] Update issue templates by @GregorSchroeder in #78
• [PULL REQUEST] Streamlit Report by @GregorSchroeder in #80
• [PULL REQUEST] Organize Streamlit code by @bryce-sandag in #82
• [PULL REQUEST] Add option to use database for Streamlit Report by @bryce-sandag in #84
• [PULL REQUEST] Life Expectancy Chart by @KPHSANDAG in #86
• [PULL REQUEST] use mermaidJS for database diagram by @bryce-sandag in #88
• [PULL REQUEST] Configuration for template sync by @Eric-Liu-SANDAG in #90
• [PULL REQUEST] Upstream merge template repository by @github-actions[bot] in #91
• [PULL REQUEST] Wiki to folder in this repository by @Eric-Liu-SANDAG in #93
• [PULL REQUEST] Fix broken link in wiki by @Eric-Liu-SANDAG in #94
• [PULL REQUEST] Upstream merge template repository by @github-actions[bot] in #96
• [PULL REQUEST] UV Package Manager by @GregorSchroeder in #100
• [PULL REQUEST] Implement 1d integerizer by @GregorSchroeder in #101
• [PULL REQUEST] Sort needed before integerize_1d function by @GregorSchroeder in #103
• [PULL REQUEST] Updated actions/checkout version by @Eric-Liu-SANDAG in #106
• [PULL REQUEST] Updating Mortality Calculations by @KPHSANDAG in #104
• [PULL REQUEST] Capping age to 99 by @KPHSANDAG in #109
• [PULL REQUEST] Upstream merge template repository by @github-actions[bot] in #113
• Bump scipy from 1.17.0 to 1.17.1 by @dependabot[bot] in #119
• Bump black from 26.1.0 to 26.3.1 by @dependabot[bot] in #117
• Bump sqlalchemy from 2.0.46 to 2.0.49 by @dependabot[bot] in #116
• Bump streamlit from 1.53.1 to 1.56.0 by @dependabot[bot] in #115
• Bump actions/checkout from 3 to 6 by @dependabot[bot] in #114
• Bump numpy from 2.4.2 to 2.4.4 by @dependabot[bot] in #122
• Bump plotly from 6.5.2 to 6.7.0 by @dependabot[bot] in #121
• Bump pymssql from 2.3.11 to 2.3.13 by @dependabot[bot] in #120
• [PULL REQUEST] Replacing SSALT with UN DESA by @KPHSANDAG in #111
• Bump streamlit from 1.56.0 to 1.57.0 by @dependabot[bot] in #123
• [PULL REQUEST] Updating mortality wiki by @KPHSANDAG in #124
• Bump numpy from 2.4.4 to 2.4.5 by @dependabot[bot] in #126
• Bump pandas from 2.3.3 to 3.0.3 by @dependabot[bot] in #125
• Fix for Unused import by @KPHSANDAG in #128
• Fix for Unused import by @KPHSANDAG in #127
• [PULL REQUEST] Changing variable assignment name by @KPHSANDAG in #132
• Fix for Unused import by @KPHSANDAG in #129
• Fix for Unused exception object by @KPHSANDAG in #133
• Fix for Except block handles 'BaseException' by @KPHSANDAG in #134
• Fix for Explicit returns mixed with implicit (fall through) returns by @KPHSANDAG in #135
• [PULL REQUEST] Upstream merge template repository by @github-actions[bot] in #139
• Fix for Unused local variable by @KPHSANDAG in #136
• Bump black from 26.3.1 to 26.5.1 by @dependabot[bot] in #138
• Bump numpy from 2.4.5 to 2.4.6 by @dependabot[bot] in #137
• Bump actions/checkout from 6 to 7 by @dependabot[bot] in #145
• [PULL REQUEST] Migration control totals by @bryce-sandag in #143
• [PULL REQUEST] Augment use of utilities by @GregorSchroeder in #150
• Bump sqlalchemy from 2.0.49 to 2.0.51 by @dependabot[bot] in #149
• Bump plotly from 6.7.0 to 6.8.0 by @dependabot[bot] in #144
• Bump streamlit from 1.57.0 to 1.58.0 by @dependabot[bot] in #142
• Bump scipy from 1.17.1 to 1.18.0 by @dependabot[bot] in #148
• [PULL REQUEST] Add Input Parser by @GregorSchroeder in #152
• [PULL REQUEST] Updating mortality scripts by @KPHSANDAG in #155
• Bump plotly from 6.8.0 to 6.9.0 by @dependabot[bot] in #157
• Bump streamlit from 1.58.0 to 1.61.1 by @dependabot[bot] in #165
• Bump pandas from 3.0.3 to 3.0.5 by @dependabot[bot] in #163
• Bump numpy from 2.4.6 to 2.5.1 by @dependabot[bot] in #158
• [PULL REQUEST] Updating fertility scripts by @KPHSANDAG in #162
• Bump sqlalchemy from 2.0.51 to 2.0.52 by @dependabot[bot] in #167
• Bump numpy from 2.5.1 to 2.5.2 by @dependabot[bot] in #166
• [PULL REQUEST] Upstream merge template repository by @github-actions[bot] in #168
• [PULL REQUEST] Create Mortality Assertions by @KPHSANDAG in #170
• Bump streamlit from 1.61.1 to 1.62.0 in the minor-and-patch-versions group by @dependabot[bot] in #171
• [PULL REQUEST] Create Fertility Assertions by @KPHSANDAG in #172
• [PULL REQUEST] Fix Streamlit Running Issue by @KPHSANDAG in #176
• Bump the minor-and-patch-versions group across 1 directory with 3 updates by @dependabot[bot] in #177
• [PULL REQUEST] Align with Estimates Program by @GregorSchroeder in #183
• Bump the minor-and-patch-versions group across 1 directory with 5 updates by @dependabot[bot] in #189
• [PULL REQUEST] Update Migration Rates module to use Estimates-style by @GregorSchroeder in #190
• [PULL REQUEST] Update Mortality and Fertility Modules to use Estimates-style by @KPHSANDAG in #191
• [PULL REQUEST] Update SQL and ETL process by @GregorSchroeder in #194
• Bump sqlalchemy from 2.0.54 to 2.1.1 in the minor-and-patch-versions group by @dependabot[bot] in #192
• [PULL REQUEST] Update Streamlit report to reflect updated outputs by @KPHSANDAG in #195
• [PULL REQUEST] Fix permissions role bug by @GregorSchroeder in #197
• [PULL REQUEST] Add release instructions by @GregorSchroeder in #199

New Contributors

• @GregorSchroeder made their first contribution in #8
• @KPHSANDAG made their first contribution in #60
• @nivedya-mk made their first contribution in #65
• @bryce-sandag made their first contribution in #82
• @Eric-Liu-SANDAG made their first contribution in #90
• @github-actions[bot] made their first contribution in #91
• @dependabot[bot] made their first contribution in #119

Full Changelog: https://github.com/SANDAG/Cohort-Component-Model/commits/1.0.0