matrices

Matrix Counts

This breaks down by the number of births, deaths and expansions by risk level, creating a table for all years

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	63981	0.12	93382	0.17	139196	0.26	239593	0.45	536152
Low	112188	0.20	100817	0.18	79781	0.14	269305	0.48	562091
Moderate	55558	0.14	120759	0.30	62719	0.16	157848	0.40	396884
Outside100	85846	0.14	106981	0.17	88148	0.14	330382	0.54	611357

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2013	High	12535	0.13	17065	0.17	23942	0.24	44923	0.46	98465
2013	Low	12643	0.22	9972	0.18	8186	0.15	25553	0.45	56354
2013	Moderate	8886	0.15	17838	0.29	9205	0.15	24993	0.41	60922
2013	Outside100	12703	0.15	15619	0.19	13249	0.16	42120	0.50	83691
2014	High	6894	0.12	10177	0.18	16240	0.28	24245	0.42	57556
2014	Low	9844	0.25	7065	0.18	5492	0.14	17024	0.43	39425
2014	Moderate	5881	0.14	13628	0.32	6038	0.14	16613	0.39	42160
2014	Outside100	8693	0.15	10776	0.18	8307	0.14	32022	0.54	59798
2015	High	6835	0.12	10047	0.18	14599	0.26	24091	0.43	55572
2015	Low	9131	0.23	6986	0.17	5961	0.15	18055	0.45	40133
2015	Moderate	6110	0.14	12307	0.29	6782	0.16	17189	0.41	42388
2015	Outside100	8567	0.14	10399	0.17	9112	0.15	31984	0.53	60062
2016	High	5348	0.11	7662	0.16	12530	0.27	21330	0.46	46870
2016	Low	7721	0.25	5591	0.18	4434	0.14	13721	0.44	31467
2016	Moderate	5824	0.14	12730	0.31	6899	0.17	15720	0.38	41173
2016	Outside100	7581	0.13	9329	0.16	7525	0.13	33276	0.58	57711
2017	High	5161	0.12	7466	0.18	10014	0.24	19592	0.46	42233
2017	Low	6577	0.19	6508	0.19	4696	0.14	16121	0.48	33902
2017	Moderate	3595	0.13	7539	0.28	4205	0.16	11596	0.43	26935
2017	Outside100	6259	0.14	8120	0.18	6376	0.14	23334	0.53	44089
2018	High	5539	0.12	8043	0.17	11982	0.26	21339	0.45	46903
2018	Low	7585	0.24	5727	0.18	4342	0.14	14461	0.45	32115
2018	Moderate	4304	0.13	9939	0.30	4880	0.15	14473	0.43	33596
2018	Outside100	7553	0.14	9559	0.17	7388	0.13	31154	0.56	55654
2019	High	5901	0.11	9088	0.17	13031	0.25	24820	0.47	52840
2019	Low	7810	0.24	5391	0.17	4356	0.14	14670	0.46	32227
2019	Moderate	4695	0.14	10884	0.32	5498	0.16	13187	0.38	34264
2019	Outside100	6526	0.14	8259	0.17	7111	0.15	25992	0.54	47888
2020	High	6009	0.12	9307	0.19	12323	0.25	22563	0.45	50202
2020	Low	19749	0.16	20235	0.17	16543	0.14	64578	0.53	121105
2020	Moderate	3982	0.13	9439	0.32	4435	0.15	12074	0.40	29930
2020	Outside100	10531	0.13	13775	0.17	11019	0.14	44523	0.56	79848
2021	High	3448	0.11	5021	0.16	9284	0.29	14372	0.45	32125
2021	Low	6605	0.28	3651	0.16	2887	0.12	10085	0.43	23228
2021	Moderate	2808	0.12	8312	0.37	3062	0.13	8584	0.38	22766
2021	Outside100	5773	0.13	6753	0.15	6073	0.14	25042	0.57	43641
2022	High	6311	0.12	9506	0.18	15251	0.29	22318	0.42	53386
2022	Low	24523	0.16	29691	0.20	22884	0.15	75037	0.49	152135
2022	Moderate	9473	0.15	18143	0.29	11715	0.19	23419	0.37	62750
2022	Outside100	11660	0.15	14392	0.18	11988	0.15	40935	0.52	78975

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	58132	0.13	84395	0.18	113125	0.25	205709	0.45	461361
Low	65342	0.21	54570	0.17	44652	0.14	147916	0.47	312480
Moderate	44158	0.14	88708	0.28	49200	0.16	134026	0.42	316092
Outside100	74891	0.15	92503	0.18	77553	0.15	267957	0.52	512904

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2012	High	6269	0.14	8402	0.18	10843	0.24	20383	0.44	45897
2012	Low	5402	0.23	4353	0.18	3472	0.15	10713	0.45	23940
2012	Moderate	3246	0.14	7341	0.31	3893	0.16	9513	0.40	23993
2012	Outside100	6609	0.15	8500	0.19	6899	0.16	21818	0.50	43826
2013	High	4761	0.13	7104	0.19	9633	0.25	16498	0.43	37996
2013	Low	5272	0.21	4594	0.18	3975	0.16	11757	0.46	25598
2013	Moderate	4064	0.15	7826	0.28	4629	0.17	11365	0.41	27884
2013	Outside100	6725	0.15	8249	0.19	7169	0.16	22379	0.50	44522
2014	High	5146	0.12	7514	0.18	10159	0.24	19104	0.46	41923
2014	Low	5667	0.21	4703	0.18	3986	0.15	12510	0.47	26866
2014	Moderate	4683	0.14	9123	0.27	5213	0.16	14173	0.43	33192
2014	Outside100	7829	0.15	10096	0.19	8332	0.16	27282	0.51	53539
2015	High	4897	0.12	7496	0.18	10154	0.25	18215	0.45	40762
2015	Low	6717	0.20	5699	0.17	4550	0.14	16710	0.50	33676
2015	Moderate	5216	0.14	10224	0.27	5862	0.15	16934	0.44	38236
2015	Outside100	7185	0.14	9129	0.18	7767	0.16	25960	0.52	50041
2016	High	6830	0.13	9677	0.18	13169	0.25	22792	0.43	52468
2016	Low	8070	0.22	6475	0.18	5140	0.14	17219	0.47	36904
2016	Moderate	5563	0.15	10759	0.28	5977	0.16	15995	0.42	38294
2016	Outside100	9707	0.15	11528	0.18	9476	0.15	32547	0.51	63258
2017	High	9711	0.13	13821	0.19	17825	0.24	32777	0.44	74134
2017	Low	8810	0.22	7300	0.18	5744	0.14	18235	0.45	40089
2017	Moderate	5745	0.14	11717	0.28	6528	0.16	17241	0.42	41231
2017	Outside100	10348	0.15	12509	0.18	10310	0.15	35675	0.52	68842
2018	High	5063	0.12	7975	0.18	10326	0.24	19757	0.46	43121
2018	Low	7218	0.22	5658	0.17	4488	0.14	15744	0.48	33108
2018	Moderate	4506	0.14	9438	0.28	5013	0.15	14188	0.43	33145
2018	Outside100	10407	0.14	12660	0.17	10253	0.14	39535	0.54	72855
2019	High	5454	0.12	7762	0.18	10893	0.25	20093	0.45	44202
2019	Low	6444	0.20	5712	0.18	4659	0.15	15127	0.47	31942
2019	Moderate	4426	0.14	8366	0.26	4760	0.15	14045	0.44	31597
2019	Outside100	6532	0.15	7836	0.18	6448	0.14	23828	0.53	44644
2020	High	4164	0.13	6104	0.18	8645	0.26	14112	0.43	33025
2020	Low	4196	0.21	3277	0.16	2845	0.14	9796	0.49	20114
2020	Moderate	2924	0.14	5889	0.28	3038	0.15	8967	0.43	20818
2020	Outside100	4102	0.13	5181	0.17	4684	0.15	16920	0.55	30887
2021	High	5837	0.12	8540	0.18	11478	0.24	21978	0.46	47833
2021	Low	7546	0.19	6799	0.17	5793	0.14	20105	0.50	40243
2021	Moderate	3785	0.14	8025	0.29	4287	0.15	11605	0.42	27702
2021	Outside100	5447	0.13	6815	0.17	6215	0.15	22013	0.54	40490

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	3343	0.13	4861	0.18	6970	0.26	11131	0.42	26305
Low	5331	0.21	4463	0.18	3412	0.14	11875	0.47	25081
Moderate	2857	0.14	5810	0.29	3049	0.15	8185	0.41	19901
Outside100	4421	0.15	5441	0.19	4497	0.15	14954	0.51	29313

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2013	High	678	0.13	1057	0.20	1356	0.26	2186	0.41	5277
2013	Low	673	0.19	630	0.18	558	0.16	1592	0.46	3453
2013	Moderate	570	0.15	986	0.26	657	0.18	1521	0.41	3734
2013	Outside100	952	0.16	1114	0.19	1028	0.18	2775	0.47	5869
2014	High	202	0.11	314	0.17	498	0.28	789	0.44	1803
2014	Low	237	0.26	177	0.19	138	0.15	360	0.39	912
2014	Moderate	205	0.14	453	0.31	237	0.16	576	0.39	1471
2014	Outside100	272	0.16	325	0.19	273	0.16	846	0.49	1716
2015	High	201	0.14	244	0.17	351	0.25	621	0.44	1417
2015	Low	355	0.19	297	0.16	214	0.11	1036	0.54	1902
2015	Moderate	173	0.14	398	0.32	169	0.14	494	0.40	1234
2015	Outside100	212	0.13	301	0.18	245	0.15	879	0.54	1637
2016	High	1014	0.12	1502	0.18	2282	0.28	3463	0.42	8261
2016	Low	1289	0.25	929	0.18	775	0.15	2083	0.41	5076
2016	Moderate	849	0.14	1763	0.29	929	0.15	2612	0.42	6153
2016	Outside100	1221	0.14	1622	0.19	1408	0.17	4214	0.50	8465
2017	High	230	0.13	321	0.18	449	0.26	742	0.43	1742
2017	Low	313	0.26	217	0.18	154	0.13	539	0.44	1223
2017	Moderate	172	0.14	390	0.32	176	0.14	483	0.40	1221
2017	Outside100	309	0.16	359	0.18	288	0.15	987	0.51	1943
2018	High	163	0.12	249	0.19	366	0.27	561	0.42	1339
2018	Low	250	0.25	183	0.18	135	0.13	451	0.44	1019
2018	Moderate	180	0.16	362	0.32	180	0.16	413	0.36	1135
2018	Outside100	408	0.17	490	0.20	341	0.14	1227	0.50	2466
2019	High	119	0.15	148	0.18	210	0.26	339	0.42	816
2019	Low	131	0.23	101	0.18	71	0.12	269	0.47	572
2019	Moderate	97	0.15	172	0.26	96	0.15	287	0.44	652
2019	Outside100	124	0.16	156	0.20	112	0.14	402	0.51	794
2020	High	107	0.12	173	0.20	238	0.28	341	0.40	859
2020	Low	155	0.22	126	0.18	104	0.15	309	0.45	694
2020	Moderate	79	0.14	158	0.29	80	0.15	231	0.42	548
2020	Outside100	120	0.16	153	0.20	106	0.14	388	0.51	767
2021	High	121	0.14	152	0.18	217	0.26	360	0.42	850
2021	Low	210	0.23	149	0.16	170	0.18	393	0.43	922
2021	Moderate	83	0.17	158	0.32	54	0.11	201	0.41	496
2021	Outside100	114	0.13	148	0.16	145	0.16	494	0.55	901
2022	High	508	0.13	701	0.18	1003	0.25	1729	0.44	3941
2022	Low	1718	0.18	1654	0.18	1093	0.12	4843	0.52	9308
2022	Moderate	449	0.14	970	0.30	471	0.14	1367	0.42	3257
2022	Outside100	689	0.14	773	0.16	551	0.12	2742	0.58	4755

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	3343	0.13	4861	0.18	6970	0.26	11131	0.42	26305
Low	5331	0.21	4463	0.18	3412	0.14	11875	0.47	25081
Moderate	2857	0.14	5810	0.29	3049	0.15	8185	0.41	19901
Outside100	4421	0.15	5441	0.19	4497	0.15	14954	0.51	29313

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+ yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2013	High	678	0.13	1057	0.20	1356	0.26	2186	0.41	5277
2013	Low	673	0.19	630	0.18	558	0.16	1592	0.46	3453
2013	Moderate	570	0.15	986	0.26	657	0.18	1521	0.41	3734
2013	Outside100	952	0.16	1114	0.19	1028	0.18	2775	0.47	5869
2014	High	202	0.11	314	0.17	498	0.28	789	0.44	1803
2014	Low	237	0.26	177	0.19	138	0.15	360	0.39	912
2014	Moderate	205	0.14	453	0.31	237	0.16	576	0.39	1471
2014	Outside100	272	0.16	325	0.19	273	0.16	846	0.49	1716
2015	High	201	0.14	244	0.17	351	0.25	621	0.44	1417
2015	Low	355	0.19	297	0.16	214	0.11	1036	0.54	1902
2015	Moderate	173	0.14	398	0.32	169	0.14	494	0.40	1234
2015	Outside100	212	0.13	301	0.18	245	0.15	879	0.54	1637
2016	High	1014	0.12	1502	0.18	2282	0.28	3463	0.42	8261
2016	Low	1289	0.25	929	0.18	775	0.15	2083	0.41	5076
2016	Moderate	849	0.14	1763	0.29	929	0.15	2612	0.42	6153
2016	Outside100	1221	0.14	1622	0.19	1408	0.17	4214	0.50	8465
2017	High	230	0.13	321	0.18	449	0.26	742	0.43	1742
2017	Low	313	0.26	217	0.18	154	0.13	539	0.44	1223
2017	Moderate	172	0.14	390	0.32	176	0.14	483	0.40	1221
2017	Outside100	309	0.16	359	0.18	288	0.15	987	0.51	1943
2018	High	163	0.12	249	0.19	366	0.27	561	0.42	1339
2018	Low	250	0.25	183	0.18	135	0.13	451	0.44	1019
2018	Moderate	180	0.16	362	0.32	180	0.16	413	0.36	1135
2018	Outside100	408	0.17	490	0.20	341	0.14	1227	0.50	2466
2019	High	119	0.15	148	0.18	210	0.26	339	0.42	816
2019	Low	131	0.23	101	0.18	71	0.12	269	0.47	572
2019	Moderate	97	0.15	172	0.26	96	0.15	287	0.44	652
2019	Outside100	124	0.16	156	0.20	112	0.14	402	0.51	794
2020	High	107	0.12	173	0.20	238	0.28	341	0.40	859
2020	Low	155	0.22	126	0.18	104	0.15	309	0.45	694
2020	Moderate	79	0.14	158	0.29	80	0.15	231	0.42	548
2020	Outside100	120	0.16	153	0.20	106	0.14	388	0.51	767
2021	High	121	0.14	152	0.18	217	0.26	360	0.42	850
2021	Low	210	0.23	149	0.16	170	0.18	393	0.43	922
2021	Moderate	83	0.17	158	0.32	54	0.11	201	0.41	496
2021	Outside100	114	0.13	148	0.16	145	0.16	494	0.55	901
2022	High	508	0.13	701	0.18	1003	0.25	1729	0.44	3941
2022	Low	1718	0.18	1654	0.18	1093	0.12	4843	0.52	9308
2022	Moderate	449	0.14	970	0.30	471	0.14	1367	0.42	3257
2022	Outside100	689	0.14	773	0.16	551	0.12	2742	0.58	4755

Matrix Yearly Charts

This breaks down by the number of births, deaths and expansions by risk level, creating a table for all years

table <- read_csv("matrix_births_yearly_base.csv") %>%
  gather(key="branch_risk",value="count",-archive_version_year,-avg_eal_tercile_parent) %>%
  rename(parent_risk=avg_eal_tercile_parent) %>%
  mutate(label=paste0(parent_risk,"(HQ) - ",branch_risk, "(Branch)"))

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

ggplot(table)+geom_density_ridges(alpha=0.5,bandwidth = 0.1,stat = "identity",aes(archive_version_year,label,height=count))+
  ggtitle("Births")

## Warning in geom_density_ridges(alpha = 0.5, bandwidth = 0.1, stat = "identity",
## : Ignoring unknown parameters: `bandwidth`

table <- read_csv("matrix_deaths_yearly_base.csv")%>%
  gather(key="branch_risk",value="count",-archive_version_year,-avg_eal_tercile_parent) %>%
  rename(parent_risk=avg_eal_tercile_parent) %>%
  mutate(label=paste0(parent_risk,"(HQ) - ",branch_risk, "(Branch)"))

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

ggplot(table)+geom_density_ridges(alpha=0.5,bandwidth = 0.1,stat = "identity",aes(archive_version_year,label,height=count))+
  ggtitle("Deaths")

## Warning in geom_density_ridges(alpha = 0.5, bandwidth = 0.1, stat = "identity",
## : Ignoring unknown parameters: `bandwidth`

table <- read_csv("matrix_expansion_yearly_base.csv")%>%
  gather(key="branch_risk",value="count",-archive_version_year,-avg_eal_tercile_parent) %>%
  rename(parent_risk=avg_eal_tercile_parent) %>%
  mutate(label=paste0(parent_risk,"(HQ) - ",branch_risk, "(Branch)"))

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

ggplot(table)+geom_density_ridges(alpha=0.5,bandwidth = 0.1,stat = "identity",aes(archive_version_year,label,height=count))+
  ggtitle("Expansions")

## Warning in geom_density_ridges(alpha = 0.5, bandwidth = 0.1, stat = "identity",
## : Ignoring unknown parameters: `bandwidth`

Matrix Critical Counts

This breaks down by the number of births, deaths and expansions by risk level, creating a table for all years

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	33226	0.11	48591	0.17	78006	0.27	130176	0.45	289999
Low	61473	0.23	46257	0.17	37520	0.14	124317	0.46	269567
Moderate	23925	0.13	63057	0.34	25624	0.14	71743	0.39	184349
Outside100	36059	0.14	44515	0.17	35494	0.13	150669	0.56	266737

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2013	High	5572	0.12	7937	0.17	11854	0.25	21588	0.46	46951
2013	Low	8876	0.23	6649	0.17	5446	0.14	17947	0.46	38918
2013	Moderate	4013	0.14	9290	0.32	3917	0.14	11595	0.40	28815
2013	Outside100	6811	0.15	8256	0.18	6985	0.15	23237	0.51	45289
2014	High	3307	0.11	4922	0.16	8710	0.29	13058	0.44	29997
2014	Low	6356	0.25	4429	0.18	3365	0.13	11060	0.44	25210
2014	Moderate	2567	0.12	7600	0.37	2637	0.13	7816	0.38	20620
2014	Outside100	3612	0.14	4275	0.16	3376	0.13	14660	0.57	25923
2015	High	3903	0.12	5565	0.17	8323	0.26	14396	0.45	32187
2015	Low	6028	0.25	4093	0.17	3497	0.14	10892	0.44	24510
2015	Moderate	3042	0.14	7112	0.32	3165	0.14	8868	0.40	22187
2015	Outside100	3871	0.14	4822	0.17	4000	0.14	15205	0.55	27898
2016	High	2736	0.11	3732	0.15	7378	0.29	11275	0.45	25121
2016	Low	5478	0.26	3684	0.17	2879	0.14	9163	0.43	21204
2016	Moderate	2814	0.14	7118	0.35	3012	0.15	7270	0.36	20214
2016	Outside100	3790	0.12	4442	0.14	3583	0.12	18907	0.62	30722
2017	High	2719	0.12	3956	0.17	5641	0.25	10451	0.46	22767
2017	Low	3793	0.22	3068	0.18	2309	0.14	7772	0.46	16942
2017	Moderate	1839	0.13	4211	0.30	1999	0.14	6105	0.43	14154
2017	Outside100	2567	0.14	3290	0.18	2585	0.14	10123	0.55	18565
2018	High	3113	0.12	4371	0.16	7173	0.27	12293	0.46	26950
2018	Low	5449	0.24	3854	0.17	2972	0.13	10113	0.45	22388
2018	Moderate	2155	0.12	5736	0.32	2373	0.13	7692	0.43	17956
2018	Outside100	4012	0.13	5179	0.17	3931	0.13	18020	0.58	31142
2019	High	2877	0.11	4426	0.16	7279	0.27	12260	0.46	26842
2019	Low	5121	0.26	3334	0.17	2770	0.14	8690	0.44	19915
2019	Moderate	2162	0.13	5871	0.35	2402	0.14	6146	0.37	16581
2019	Outside100	3281	0.13	4277	0.17	3576	0.14	13617	0.55	24751
2020	High	3339	0.12	5137	0.18	7063	0.25	12720	0.45	28259
2020	Low	11339	0.17	11406	0.17	9728	0.15	33233	0.51	65706
2020	Moderate	1864	0.13	5323	0.36	2044	0.14	5474	0.37	14705
2020	Outside100	2901	0.13	3602	0.17	2916	0.13	12273	0.57	21692
2021	High	1847	0.10	2623	0.15	5049	0.28	8332	0.47	17851
2021	Low	4210	0.27	2489	0.16	2025	0.13	7034	0.45	15758
2021	Moderate	1484	0.12	4684	0.38	1654	0.13	4488	0.36	12310
2021	Outside100	2108	0.13	2602	0.15	1935	0.12	10173	0.60	16818
2022	High	3813	0.12	5922	0.18	9536	0.29	13803	0.42	33074
2022	Low	4823	0.25	3251	0.17	2529	0.13	8413	0.44	19016
2022	Moderate	1985	0.12	6112	0.36	2421	0.14	6289	0.37	16807
2022	Outside100	3106	0.13	3770	0.16	2607	0.11	14454	0.60	23937

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	27088	0.12	40245	0.18	58590	0.26	103760	0.45	229683
Low	45313	0.21	35743	0.17	29370	0.14	103178	0.48	213604
Moderate	20028	0.13	46897	0.31	21203	0.14	62984	0.42	151112
Outside100	33106	0.14	41105	0.18	34086	0.15	125598	0.54	233895

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2012	High	2208	0.12	3154	0.17	4905	0.27	8236	0.45	18503
2012	Low	3530	0.22	2719	0.17	2219	0.14	7501	0.47	15969
2012	Moderate	1476	0.13	3951	0.34	1691	0.15	4528	0.39	11646
2012	Outside100	3130	0.14	4351	0.20	3321	0.15	10985	0.50	21787
2013	High	2452	0.12	3710	0.18	5172	0.25	9104	0.45	20438
2013	Low	3701	0.20	3129	0.17	2711	0.15	8531	0.47	18072
2013	Moderate	1769	0.14	3999	0.31	1900	0.15	5063	0.40	12731
2013	Outside100	2941	0.15	3752	0.19	3217	0.16	10164	0.51	20074
2014	High	2530	0.11	3702	0.17	5463	0.25	10383	0.47	22078
2014	Low	4049	0.21	3267	0.17	2737	0.14	9075	0.47	19128
2014	Moderate	1919	0.13	4507	0.31	1971	0.14	6024	0.42	14421
2014	Outside100	3306	0.14	4150	0.18	3425	0.15	12114	0.53	22995
2015	High	2670	0.12	3997	0.18	5568	0.24	10559	0.46	22794
2015	Low	5040	0.20	4107	0.16	3331	0.13	13255	0.52	25733
2015	Moderate	2203	0.13	5123	0.30	2363	0.14	7289	0.43	16978
2015	Outside100	3319	0.14	4251	0.18	3723	0.15	12942	0.53	24235
2016	High	3403	0.12	4849	0.17	7156	0.26	12354	0.44	27762
2016	Low	5902	0.22	4569	0.17	3545	0.13	12909	0.48	26925
2016	Moderate	2666	0.14	5794	0.31	2706	0.14	7815	0.41	18981
2016	Outside100	4371	0.15	5140	0.18	4303	0.15	15425	0.53	29239
2017	High	3745	0.12	5500	0.18	8186	0.26	13944	0.44	31375
2017	Low	6210	0.22	4939	0.17	3879	0.14	13233	0.47	28261
2017	Moderate	2767	0.13	6562	0.31	3051	0.14	8971	0.42	21351
2017	Outside100	4890	0.15	5751	0.17	4850	0.15	17386	0.53	32877
2018	High	2452	0.11	4137	0.19	5499	0.25	10181	0.46	22269
2018	Low	5319	0.21	4045	0.16	3361	0.13	12271	0.49	24996
2018	Moderate	1901	0.12	4881	0.32	2136	0.14	6434	0.42	15352
2018	Outside100	3185	0.13	3944	0.17	3160	0.13	13542	0.57	23831
2019	High	2840	0.12	4036	0.17	5856	0.25	10928	0.46	23660
2019	Low	3965	0.22	3178	0.17	2519	0.14	8714	0.47	18376
2019	Moderate	1995	0.13	4330	0.29	2041	0.14	6660	0.44	15026
2019	Outside100	3108	0.14	3681	0.17	3077	0.14	12061	0.55	21927
2020	High	1824	0.12	2761	0.18	4348	0.28	6659	0.43	15592
2020	Low	3001	0.21	2228	0.15	1872	0.13	7436	0.51	14537
2020	Moderate	1413	0.14	3186	0.31	1447	0.14	4321	0.42	10367
2020	Outside100	1990	0.13	2498	0.17	2054	0.14	8482	0.56	15024
2021	High	2964	0.12	4399	0.17	6437	0.26	11412	0.45	25212
2021	Low	4596	0.21	3562	0.16	3196	0.15	10253	0.47	21607
2021	Moderate	1919	0.13	4564	0.32	1897	0.13	5879	0.41	14259
2021	Outside100	2866	0.13	3587	0.16	2956	0.13	12497	0.57	21906

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	1852	0.12	2684	0.18	3900	0.26	6498	0.44	14934
Low	3973	0.21	3368	0.17	2560	0.13	9456	0.49	19357
Moderate	1433	0.14	3226	0.31	1373	0.13	4451	0.42	10483
Outside100	2195	0.14	2941	0.19	2281	0.15	7960	0.52	15377

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2013	High	337	0.12	516	0.19	708	0.26	1160	0.43	2721
2013	Low	467	0.19	448	0.18	372	0.15	1213	0.49	2500
2013	Moderate	259	0.14	517	0.28	263	0.14	793	0.43	1832
2013	Outside100	441	0.15	618	0.21	457	0.15	1454	0.49	2970
2014	High	117	0.12	170	0.17	258	0.26	449	0.45	994
2014	Low	156	0.25	126	0.20	91	0.14	260	0.41	633
2014	Moderate	84	0.14	226	0.38	72	0.12	208	0.35	590
2014	Outside100	140	0.16	167	0.19	122	0.14	443	0.51	872
2015	High	103	0.13	135	0.17	199	0.25	352	0.45	789
2015	Low	299	0.18	247	0.15	179	0.11	927	0.56	1652
2015	Moderate	91	0.16	210	0.36	68	0.12	209	0.36	578
2015	Outside100	110	0.12	159	0.18	126	0.14	507	0.56	902
2016	High	602	0.12	912	0.18	1373	0.27	2213	0.43	5100
2016	Low	888	0.27	578	0.17	470	0.14	1381	0.42	3317
2016	Moderate	479	0.13	1063	0.29	481	0.13	1702	0.46	3725
2016	Outside100	713	0.14	992	0.19	875	0.17	2622	0.50	5202
2017	High	125	0.13	146	0.16	246	0.27	410	0.44	927
2017	Low	190	0.24	138	0.17	103	0.13	360	0.46	791
2017	Moderate	92	0.14	239	0.35	82	0.12	266	0.39	679
2017	Outside100	144	0.16	173	0.19	140	0.15	465	0.50	922
2018	High	93	0.13	152	0.21	177	0.24	318	0.43	740
2018	Low	159	0.23	112	0.16	107	0.16	307	0.45	685
2018	Moderate	101	0.16	201	0.32	93	0.15	229	0.37	624
2018	Outside100	158	0.17	226	0.24	155	0.16	411	0.43	950
2019	High	68	0.14	81	0.16	122	0.25	223	0.45	494
2019	Low	72	0.21	57	0.17	41	0.12	172	0.50	342
2019	Moderate	50	0.14	102	0.29	48	0.14	151	0.43	351
2019	Outside100	57	0.13	92	0.21	63	0.14	236	0.53	448
2020	High	63	0.14	95	0.20	126	0.27	181	0.39	465
2020	Low	106	0.20	87	0.17	73	0.14	254	0.49	520
2020	Moderate	46	0.16	90	0.31	36	0.12	121	0.41	293
2020	Outside100	64	0.16	81	0.21	52	0.13	197	0.50	394
2021	High	73	0.15	95	0.19	123	0.25	206	0.41	497
2021	Low	177	0.22	124	0.16	153	0.19	334	0.42	788
2021	Moderate	47	0.17	88	0.32	31	0.11	113	0.41	279
2021	Outside100	58	0.13	70	0.15	57	0.13	267	0.59	452
2022	High	271	0.12	382	0.17	568	0.26	986	0.45	2207
2022	Low	1459	0.18	1451	0.18	971	0.12	4248	0.52	8129
2022	Moderate	184	0.12	490	0.32	199	0.13	659	0.43	1532
2022	Outside100	310	0.14	363	0.16	234	0.10	1358	0.60	2265

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	1852	0.12	2684	0.18	3900	0.26	6498	0.44	14934
Low	3973	0.21	3368	0.17	2560	0.13	9456	0.49	19357
Moderate	1433	0.14	3226	0.31	1373	0.13	4451	0.42	10483
Outside100	2195	0.14	2941	0.19	2281	0.15	7960	0.52	15377

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+ yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2013	High	337	0.12	516	0.19	708	0.26	1160	0.43	2721
2013	Low	467	0.19	448	0.18	372	0.15	1213	0.49	2500
2013	Moderate	259	0.14	517	0.28	263	0.14	793	0.43	1832
2013	Outside100	441	0.15	618	0.21	457	0.15	1454	0.49	2970
2014	High	117	0.12	170	0.17	258	0.26	449	0.45	994
2014	Low	156	0.25	126	0.20	91	0.14	260	0.41	633
2014	Moderate	84	0.14	226	0.38	72	0.12	208	0.35	590
2014	Outside100	140	0.16	167	0.19	122	0.14	443	0.51	872
2015	High	103	0.13	135	0.17	199	0.25	352	0.45	789
2015	Low	299	0.18	247	0.15	179	0.11	927	0.56	1652
2015	Moderate	91	0.16	210	0.36	68	0.12	209	0.36	578
2015	Outside100	110	0.12	159	0.18	126	0.14	507	0.56	902
2016	High	602	0.12	912	0.18	1373	0.27	2213	0.43	5100
2016	Low	888	0.27	578	0.17	470	0.14	1381	0.42	3317
2016	Moderate	479	0.13	1063	0.29	481	0.13	1702	0.46	3725
2016	Outside100	713	0.14	992	0.19	875	0.17	2622	0.50	5202
2017	High	125	0.13	146	0.16	246	0.27	410	0.44	927
2017	Low	190	0.24	138	0.17	103	0.13	360	0.46	791
2017	Moderate	92	0.14	239	0.35	82	0.12	266	0.39	679
2017	Outside100	144	0.16	173	0.19	140	0.15	465	0.50	922
2018	High	93	0.13	152	0.21	177	0.24	318	0.43	740
2018	Low	159	0.23	112	0.16	107	0.16	307	0.45	685
2018	Moderate	101	0.16	201	0.32	93	0.15	229	0.37	624
2018	Outside100	158	0.17	226	0.24	155	0.16	411	0.43	950
2019	High	68	0.14	81	0.16	122	0.25	223	0.45	494
2019	Low	72	0.21	57	0.17	41	0.12	172	0.50	342
2019	Moderate	50	0.14	102	0.29	48	0.14	151	0.43	351
2019	Outside100	57	0.13	92	0.21	63	0.14	236	0.53	448
2020	High	63	0.14	95	0.20	126	0.27	181	0.39	465
2020	Low	106	0.20	87	0.17	73	0.14	254	0.49	520
2020	Moderate	46	0.16	90	0.31	36	0.12	121	0.41	293
2020	Outside100	64	0.16	81	0.21	52	0.13	197	0.50	394
2021	High	73	0.15	95	0.19	123	0.25	206	0.41	497
2021	Low	177	0.22	124	0.16	153	0.19	334	0.42	788
2021	Moderate	47	0.17	88	0.32	31	0.11	113	0.41	279
2021	Outside100	58	0.13	70	0.15	57	0.13	267	0.59	452
2022	High	271	0.12	382	0.17	568	0.26	986	0.45	2207
2022	Low	1459	0.18	1451	0.18	971	0.12	4248	0.52	8129
2022	Moderate	184	0.12	490	0.32	199	0.13	659	0.43	1532
2022	Outside100	310	0.14	363	0.16	234	0.10	1358	0.60	2265

Matrix Non-Critical Counts

This breaks down by the number of births, deaths and expansions by risk level, creating a table for all years

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	30755	0.12	44791	0.18	61190	0.25	109417	0.44	246153
Low	50715	0.17	54560	0.19	42261	0.14	144988	0.50	292524
Moderate	31633	0.15	57702	0.27	37095	0.17	86105	0.41	212535
Outside100	49787	0.14	62466	0.18	52654	0.15	179713	0.52	344620

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2013	High	6963	0.14	9128	0.18	12088	0.23	23335	0.45	51514
2013	Low	3767	0.22	3323	0.19	2740	0.16	7606	0.44	17436
2013	Moderate	4873	0.15	8548	0.27	5288	0.16	13398	0.42	32107
2013	Outside100	5892	0.15	7363	0.19	6264	0.16	18883	0.49	38402
2014	High	3587	0.13	5255	0.19	7530	0.27	11187	0.41	27559
2014	Low	3488	0.25	2636	0.19	2127	0.15	5964	0.42	14215
2014	Moderate	3314	0.15	6028	0.28	3401	0.16	8797	0.41	21540
2014	Outside100	5081	0.15	6501	0.19	4931	0.15	17362	0.51	33875
2015	High	2932	0.13	4482	0.19	6276	0.27	9695	0.41	23385
2015	Low	3103	0.20	2893	0.19	2464	0.16	7163	0.46	15623
2015	Moderate	3068	0.15	5195	0.26	3617	0.18	8321	0.41	20201
2015	Outside100	4696	0.15	5577	0.17	5112	0.16	16779	0.52	32164
2016	High	2612	0.12	3930	0.18	5152	0.24	10055	0.46	21749
2016	Low	2243	0.22	1907	0.19	1555	0.15	4558	0.44	10263
2016	Moderate	3010	0.14	5612	0.27	3887	0.19	8450	0.40	20959
2016	Outside100	3791	0.14	4887	0.18	3942	0.15	14369	0.53	26989
2017	High	2442	0.13	3510	0.18	4373	0.22	9141	0.47	19466
2017	Low	2784	0.16	3440	0.20	2387	0.14	8349	0.49	16960
2017	Moderate	1756	0.14	3328	0.26	2206	0.17	5491	0.43	12781
2017	Outside100	3692	0.14	4830	0.19	3791	0.15	13211	0.52	25524
2018	High	2426	0.12	3672	0.18	4809	0.24	9046	0.45	19953
2018	Low	2136	0.22	1873	0.19	1370	0.14	4348	0.45	9727
2018	Moderate	2149	0.14	4203	0.27	2507	0.16	6781	0.43	15640
2018	Outside100	3541	0.14	4380	0.18	3457	0.14	13134	0.54	24512
2019	High	3024	0.12	4662	0.18	5752	0.22	12560	0.48	25998
2019	Low	2689	0.22	2057	0.17	1586	0.13	5980	0.49	12312
2019	Moderate	2533	0.14	5013	0.28	3096	0.18	7041	0.40	17683
2019	Outside100	3245	0.14	3982	0.17	3535	0.15	12375	0.53	23137
2020	High	2670	0.12	4170	0.19	5260	0.24	9843	0.45	21943
2020	Low	8410	0.15	8829	0.16	6815	0.12	31345	0.57	55399
2020	Moderate	2118	0.14	4116	0.27	2391	0.16	6600	0.43	15225
2020	Outside100	7630	0.13	10173	0.17	8103	0.14	32250	0.55	58156
2021	High	1601	0.11	2398	0.17	4235	0.30	6040	0.42	14274
2021	Low	2395	0.32	1162	0.16	862	0.12	3051	0.41	7470
2021	Moderate	1324	0.13	3628	0.35	1408	0.13	4096	0.39	10456
2021	Outside100	3665	0.14	4151	0.15	4138	0.15	14869	0.55	26823
2022	High	2498	0.12	3584	0.18	5715	0.28	8515	0.42	20312
2022	Low	19700	0.15	26440	0.20	20355	0.15	66624	0.50	133119
2022	Moderate	7488	0.16	12031	0.26	9294	0.20	17130	0.37	45943
2022	Outside100	8554	0.16	10622	0.19	9381	0.17	26481	0.48	55038

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	31044	0.13	44150	0.19	54535	0.24	101949	0.44	231678
Low	20029	0.20	18827	0.19	15282	0.15	44738	0.45	98876
Moderate	24130	0.15	41811	0.25	27997	0.17	71042	0.43	164980
Outside100	41785	0.15	51398	0.18	43467	0.16	142359	0.51	279009

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2012	High	4061	0.15	5248	0.19	5938	0.22	12147	0.44	27394
2012	Low	1872	0.23	1634	0.20	1253	0.16	3212	0.40	7971
2012	Moderate	1770	0.14	3390	0.27	2202	0.18	4985	0.40	12347
2012	Outside100	3479	0.16	4149	0.19	3578	0.16	10833	0.49	22039
2013	High	2309	0.13	3394	0.19	4461	0.25	7394	0.42	17558
2013	Low	1571	0.21	1465	0.19	1264	0.17	3226	0.43	7526
2013	Moderate	2295	0.15	3827	0.25	2729	0.18	6302	0.42	15153
2013	Outside100	3784	0.15	4497	0.18	3952	0.16	12215	0.50	24448
2014	High	2616	0.13	3812	0.19	4696	0.24	8721	0.44	19845
2014	Low	1618	0.21	1436	0.19	1249	0.16	3435	0.44	7738
2014	Moderate	2764	0.15	4616	0.25	3242	0.17	8149	0.43	18771
2014	Outside100	4523	0.15	5946	0.19	4907	0.16	15168	0.50	30544
2015	High	2227	0.12	3499	0.19	4586	0.26	7656	0.43	17968
2015	Low	1677	0.21	1592	0.20	1219	0.15	3455	0.43	7943
2015	Moderate	3013	0.14	5101	0.24	3499	0.16	9645	0.45	21258
2015	Outside100	3866	0.15	4878	0.19	4044	0.16	13018	0.50	25806
2016	High	3427	0.14	4828	0.20	6013	0.24	10438	0.42	24706
2016	Low	2168	0.22	1906	0.19	1595	0.16	4310	0.43	9979
2016	Moderate	2897	0.15	4965	0.26	3271	0.17	8180	0.42	19313
2016	Outside100	5336	0.16	6388	0.19	5173	0.15	17122	0.50	34019
2017	High	5966	0.14	8321	0.19	9639	0.23	18833	0.44	42759
2017	Low	2600	0.22	2361	0.20	1865	0.16	5002	0.42	11828
2017	Moderate	2978	0.15	5155	0.26	3477	0.17	8270	0.42	19880
2017	Outside100	5458	0.15	6758	0.19	5460	0.15	18289	0.51	35965
2018	High	2611	0.13	3838	0.18	4827	0.23	9576	0.46	20852
2018	Low	1899	0.23	1613	0.20	1127	0.14	3473	0.43	8112
2018	Moderate	2605	0.15	4557	0.26	2877	0.16	7754	0.44	17793
2018	Outside100	7222	0.15	8716	0.18	7093	0.14	25993	0.53	49024
2019	High	2614	0.13	3726	0.18	5037	0.25	9165	0.45	20542
2019	Low	2479	0.18	2534	0.19	2140	0.16	6413	0.47	13566
2019	Moderate	2431	0.15	4036	0.24	2719	0.16	7385	0.45	16571
2019	Outside100	3424	0.15	4155	0.18	3371	0.15	11767	0.52	22717
2020	High	2340	0.13	3343	0.19	4297	0.25	7453	0.43	17433
2020	Low	1195	0.21	1049	0.19	973	0.17	2360	0.42	5577
2020	Moderate	1511	0.14	2703	0.26	1591	0.15	4646	0.44	10451
2020	Outside100	2112	0.13	2683	0.17	2630	0.17	8438	0.53	15863
2021	High	2873	0.13	4141	0.18	5041	0.22	10566	0.47	22621
2021	Low	2950	0.16	3237	0.17	2597	0.14	9852	0.53	18636
2021	Moderate	1866	0.14	3461	0.26	2390	0.18	5726	0.43	13443
2021	Outside100	2581	0.14	3228	0.17	3259	0.18	9516	0.51	18584

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	1491	0.13	2177	0.19	3070	0.27	4633	0.41	11371
Low	1358	0.24	1095	0.19	852	0.15	2419	0.42	5724
Moderate	1424	0.15	2584	0.27	1676	0.18	3734	0.40	9418
Outside100	2226	0.16	2500	0.18	2216	0.16	6994	0.50	13936

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2013	High	341	0.13	541	0.21	648	0.25	1026	0.40	2556
2013	Low	206	0.22	182	0.19	186	0.20	379	0.40	953
2013	Moderate	311	0.16	469	0.25	394	0.21	728	0.38	1902
2013	Outside100	511	0.18	496	0.17	571	0.20	1321	0.46	2899
2014	High	85	0.11	144	0.18	240	0.30	340	0.42	809
2014	Low	81	0.29	51	0.18	47	0.17	100	0.36	279
2014	Moderate	121	0.14	227	0.26	165	0.19	368	0.42	881
2014	Outside100	132	0.16	158	0.19	151	0.18	403	0.48	844
2015	High	98	0.16	109	0.17	152	0.24	269	0.43	628
2015	Low	56	0.22	50	0.20	35	0.14	109	0.44	250
2015	Moderate	82	0.12	188	0.29	101	0.15	285	0.43	656
2015	Outside100	102	0.14	142	0.19	119	0.16	372	0.51	735
2016	High	412	0.13	590	0.19	909	0.29	1250	0.40	3161
2016	Low	401	0.23	351	0.20	305	0.17	702	0.40	1759
2016	Moderate	370	0.15	700	0.29	448	0.18	910	0.37	2428
2016	Outside100	508	0.16	630	0.19	533	0.16	1592	0.49	3263
2017	High	105	0.13	175	0.21	203	0.25	332	0.41	815
2017	Low	123	0.28	79	0.18	51	0.12	179	0.41	432
2017	Moderate	80	0.15	151	0.28	94	0.17	217	0.40	542
2017	Outside100	165	0.16	186	0.18	148	0.14	522	0.51	1021
2018	High	70	0.12	97	0.16	189	0.32	243	0.41	599
2018	Low	91	0.27	71	0.21	28	0.08	144	0.43	334
2018	Moderate	79	0.15	161	0.32	87	0.17	184	0.36	511
2018	Outside100	250	0.16	264	0.17	186	0.12	816	0.54	1516
2019	High	51	0.16	67	0.21	88	0.27	116	0.36	322
2019	Low	59	0.26	44	0.19	30	0.13	97	0.42	230
2019	Moderate	47	0.16	70	0.23	48	0.16	136	0.45	301
2019	Outside100	67	0.19	64	0.18	49	0.14	166	0.48	346
2020	High	44	0.11	78	0.20	112	0.28	160	0.41	394
2020	Low	49	0.28	39	0.22	31	0.18	55	0.32	174
2020	Moderate	33	0.13	68	0.27	44	0.17	110	0.43	255
2020	Outside100	56	0.15	72	0.19	54	0.14	191	0.51	373
2021	High	48	0.14	57	0.16	94	0.27	154	0.44	353
2021	Low	33	0.25	25	0.19	17	0.13	59	0.44	134
2021	Moderate	36	0.17	70	0.32	23	0.11	88	0.41	217
2021	Outside100	56	0.12	78	0.17	88	0.20	227	0.51	449
2022	High	237	0.14	319	0.18	435	0.25	743	0.43	1734
2022	Low	259	0.22	203	0.17	122	0.10	595	0.50	1179
2022	Moderate	265	0.15	480	0.28	272	0.16	708	0.41	1725
2022	Outside100	379	0.15	410	0.16	317	0.13	1384	0.56	2490

## Rows: 4 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
High	1491	0.13	2177	0.19	3070	0.27	4633	0.41	11371
Low	1358	0.24	1095	0.19	852	0.15	2419	0.42	5724
Moderate	1424	0.15	2584	0.27	1676	0.18	3734	0.40	9418
Outside100	2226	0.16	2500	0.18	2216	0.16	6994	0.50	13936

## Rows: 40 Columns: 6
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (5): archive_version_year, Low, Moderate, High, <NA>
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+ yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Outside100	Outside100_pct	Total
2013	High	341	0.13	541	0.21	648	0.25	1026	0.40	2556
2013	Low	206	0.22	182	0.19	186	0.20	379	0.40	953
2013	Moderate	311	0.16	469	0.25	394	0.21	728	0.38	1902
2013	Outside100	511	0.18	496	0.17	571	0.20	1321	0.46	2899
2014	High	85	0.11	144	0.18	240	0.30	340	0.42	809
2014	Low	81	0.29	51	0.18	47	0.17	100	0.36	279
2014	Moderate	121	0.14	227	0.26	165	0.19	368	0.42	881
2014	Outside100	132	0.16	158	0.19	151	0.18	403	0.48	844
2015	High	98	0.16	109	0.17	152	0.24	269	0.43	628
2015	Low	56	0.22	50	0.20	35	0.14	109	0.44	250
2015	Moderate	82	0.12	188	0.29	101	0.15	285	0.43	656
2015	Outside100	102	0.14	142	0.19	119	0.16	372	0.51	735
2016	High	412	0.13	590	0.19	909	0.29	1250	0.40	3161
2016	Low	401	0.23	351	0.20	305	0.17	702	0.40	1759
2016	Moderate	370	0.15	700	0.29	448	0.18	910	0.37	2428
2016	Outside100	508	0.16	630	0.19	533	0.16	1592	0.49	3263
2017	High	105	0.13	175	0.21	203	0.25	332	0.41	815
2017	Low	123	0.28	79	0.18	51	0.12	179	0.41	432
2017	Moderate	80	0.15	151	0.28	94	0.17	217	0.40	542
2017	Outside100	165	0.16	186	0.18	148	0.14	522	0.51	1021
2018	High	70	0.12	97	0.16	189	0.32	243	0.41	599
2018	Low	91	0.27	71	0.21	28	0.08	144	0.43	334
2018	Moderate	79	0.15	161	0.32	87	0.17	184	0.36	511
2018	Outside100	250	0.16	264	0.17	186	0.12	816	0.54	1516
2019	High	51	0.16	67	0.21	88	0.27	116	0.36	322
2019	Low	59	0.26	44	0.19	30	0.13	97	0.42	230
2019	Moderate	47	0.16	70	0.23	48	0.16	136	0.45	301
2019	Outside100	67	0.19	64	0.18	49	0.14	166	0.48	346
2020	High	44	0.11	78	0.20	112	0.28	160	0.41	394
2020	Low	49	0.28	39	0.22	31	0.18	55	0.32	174
2020	Moderate	33	0.13	68	0.27	44	0.17	110	0.43	255
2020	Outside100	56	0.15	72	0.19	54	0.14	191	0.51	373
2021	High	48	0.14	57	0.16	94	0.27	154	0.44	353
2021	Low	33	0.25	25	0.19	17	0.13	59	0.44	134
2021	Moderate	36	0.17	70	0.32	23	0.11	88	0.41	217
2021	Outside100	56	0.12	78	0.17	88	0.20	227	0.51	449
2022	High	237	0.14	319	0.18	435	0.25	743	0.43	1734
2022	Low	259	0.22	203	0.17	122	0.10	595	0.50	1179
2022	Moderate	265	0.15	480	0.28	272	0.16	708	0.41	1725
2022	Outside100	379	0.15	410	0.16	317	0.13	1384	0.56	2490

Matrix Pop Low Counts

This breaks down by the number of births, deaths and expansions by population level, creating a table for all years. The dataset is filtered for businesses with a CBSA population level that is low among the top 100.

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	12269	0.40	9159	0.30	8912	0.29	30340
Low	23116	0.57	10869	0.27	6685	0.16	40670
Moderate	10982	0.42	9912	0.38	5269	0.20	26163
Outside100	17534	0.47	11576	0.31	7924	0.21	37034

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	2382	0.41	1745	0.30	1721	0.29	5848
2013	Low	2342	0.56	1072	0.26	736	0.18	4150
2013	Moderate	1770	0.45	1384	0.35	773	0.20	3927
2013	Outside100	2428	0.46	1714	0.32	1144	0.22	5286
2014	High	1274	0.39	1067	0.32	968	0.29	3309
2014	Low	1820	0.58	818	0.26	476	0.15	3114
2014	Moderate	1126	0.39	1190	0.42	547	0.19	2863
2014	Outside100	1668	0.47	1174	0.33	709	0.20	3551
2015	High	1238	0.41	935	0.31	883	0.29	3056
2015	Low	1547	0.53	810	0.28	541	0.19	2898
2015	Moderate	1222	0.43	992	0.35	605	0.21	2819
2015	Outside100	1751	0.47	1142	0.31	796	0.22	3689
2016	High	1009	0.40	690	0.28	806	0.32	2505
2016	Low	1445	0.59	615	0.25	384	0.16	2444
2016	Moderate	1140	0.42	1108	0.41	451	0.17	2699
2016	Outside100	1639	0.50	1068	0.32	597	0.18	3304
2017	High	1004	0.44	703	0.31	578	0.25	2285
2017	Low	1319	0.55	633	0.26	464	0.19	2416
2017	Moderate	751	0.42	700	0.39	336	0.19	1787
2017	Outside100	1363	0.49	867	0.31	575	0.20	2805
2018	High	1027	0.40	735	0.29	809	0.31	2571
2018	Low	1392	0.56	629	0.25	452	0.18	2473
2018	Moderate	946	0.44	800	0.37	388	0.18	2134
2018	Outside100	1610	0.48	1032	0.31	715	0.21	3357
2019	High	1186	0.41	861	0.30	846	0.29	2893
2019	Low	1747	0.63	618	0.22	413	0.15	2778
2019	Moderate	937	0.41	898	0.39	468	0.20	2303
2019	Outside100	1197	0.46	849	0.32	579	0.22	2625
2020	High	1206	0.43	897	0.32	698	0.25	2801
2020	Low	4573	0.52	2456	0.28	1692	0.19	8721
2020	Moderate	851	0.45	634	0.34	405	0.21	1890
2020	Outside100	2247	0.44	1555	0.31	1270	0.25	5072
2021	High	703	0.38	546	0.30	594	0.32	1843
2021	Low	1248	0.64	420	0.22	278	0.14	1946
2021	Moderate	568	0.38	611	0.40	334	0.22	1513
2021	Outside100	1264	0.49	717	0.28	580	0.23	2561
2022	High	1240	0.38	980	0.30	1009	0.31	3229
2022	Low	5683	0.58	2798	0.29	1249	0.13	9730
2022	Moderate	1671	0.40	1595	0.38	962	0.23	4228
2022	Outside100	2367	0.49	1458	0.30	959	0.20	4784

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	10948	0.41	9059	0.34	6816	0.25	26823
Low	12521	0.55	6132	0.27	4043	0.18	22696
Moderate	8823	0.44	7478	0.37	3921	0.19	20222
Outside100	14747	0.47	10072	0.32	6353	0.20	31172

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2012	High	1062	0.37	969	0.34	805	0.28	2836
2012	Low	940	0.54	498	0.28	314	0.18	1752
2012	Moderate	605	0.40	575	0.38	329	0.22	1509
2012	Outside100	1153	0.42	914	0.34	647	0.24	2714
2013	High	874	0.40	747	0.34	579	0.26	2200
2013	Low	979	0.54	489	0.27	335	0.19	1803
2013	Moderate	816	0.43	692	0.36	393	0.21	1901
2013	Outside100	1269	0.46	867	0.32	608	0.22	2744
2014	High	918	0.41	728	0.32	610	0.27	2256
2014	Low	1014	0.54	517	0.28	347	0.18	1878
2014	Moderate	923	0.42	783	0.36	469	0.22	2175
2014	Outside100	1543	0.46	1107	0.33	701	0.21	3351
2015	High	932	0.43	680	0.31	571	0.26	2183
2015	Low	1332	0.56	615	0.26	419	0.18	2366
2015	Moderate	1076	0.46	841	0.36	439	0.19	2356
2015	Outside100	1486	0.48	959	0.31	652	0.21	3097
2016	High	1305	0.43	912	0.30	819	0.27	3036
2016	Low	1451	0.55	696	0.27	469	0.18	2616
2016	Moderate	1057	0.44	886	0.37	469	0.19	2412
2016	Outside100	1962	0.48	1322	0.32	815	0.20	4099
2017	High	1834	0.42	1426	0.33	1111	0.25	4371
2017	Low	1706	0.57	802	0.27	507	0.17	3015
2017	Moderate	1159	0.44	978	0.37	503	0.19	2640
2017	Outside100	2073	0.49	1353	0.32	783	0.19	4209
2018	High	990	0.37	1093	0.41	592	0.22	2675
2018	Low	1376	0.55	703	0.28	408	0.16	2487
2018	Moderate	954	0.45	817	0.38	365	0.17	2136
2018	Outside100	2044	0.49	1392	0.33	778	0.18	4214
2019	High	991	0.41	832	0.34	611	0.25	2434
2019	Low	1210	0.52	677	0.29	440	0.19	2327
2019	Moderate	853	0.44	711	0.37	359	0.19	1923
2019	Outside100	1291	0.48	869	0.33	511	0.19	2671
2020	High	805	0.43	607	0.32	473	0.25	1885
2020	Low	858	0.59	367	0.25	241	0.16	1466
2020	Moderate	630	0.47	499	0.37	216	0.16	1345
2020	Outside100	846	0.48	562	0.32	363	0.20	1771
2021	High	1237	0.42	1065	0.36	645	0.22	2947
2021	Low	1655	0.55	768	0.26	563	0.19	2986
2021	Moderate	750	0.41	696	0.38	379	0.21	1825
2021	Outside100	1080	0.47	727	0.32	495	0.22	2302

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	598	0.42	431	0.30	399	0.28	1428
Low	984	0.57	443	0.26	291	0.17	1718
Moderate	527	0.43	463	0.38	229	0.19	1219
Outside100	875	0.47	600	0.32	372	0.20	1847

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	127	0.44	87	0.30	73	0.25	287
2013	Low	135	0.55	65	0.27	45	0.18	245
2013	Moderate	103	0.45	92	0.40	36	0.16	231
2013	Outside100	200	0.48	138	0.33	83	0.20	421
2014	High	27	0.32	31	0.37	26	0.31	84
2014	Low	37	0.56	15	0.23	14	0.21	66
2014	Moderate	44	0.45	32	0.33	21	0.22	97
2014	Outside100	60	0.52	29	0.25	27	0.23	116
2015	High	37	0.54	19	0.28	12	0.18	68
2015	Low	71	0.54	36	0.27	24	0.18	131
2015	Moderate	41	0.54	24	0.32	11	0.14	76
2015	Outside100	46	0.52	28	0.32	14	0.16	88
2016	High	177	0.43	114	0.28	120	0.29	411
2016	Low	235	0.58	89	0.22	79	0.20	403
2016	Moderate	135	0.42	118	0.37	70	0.22	323
2016	Outside100	212	0.45	154	0.33	104	0.22	470
2017	High	37	0.44	22	0.26	25	0.30	84
2017	Low	58	0.64	17	0.19	16	0.18	91
2017	Moderate	33	0.39	41	0.49	10	0.12	84
2017	Outside100	69	0.47	54	0.37	23	0.16	146
2018	High	24	0.37	17	0.26	24	0.37	65
2018	Low	40	0.54	19	0.26	15	0.20	74
2018	Moderate	32	0.40	31	0.39	17	0.21	80
2018	Outside100	78	0.54	47	0.32	20	0.14	145
2019	High	22	0.46	14	0.29	12	0.25	48
2019	Low	23	0.53	12	0.28	8	0.19	43
2019	Moderate	18	0.38	20	0.43	9	0.19	47
2019	Outside100	26	0.46	21	0.38	9	0.16	56
2020	High	24	0.41	21	0.36	13	0.22	58
2020	Low	34	0.59	14	0.24	10	0.17	58
2020	Moderate	22	0.58	9	0.24	7	0.18	38
2020	Outside100	20	0.45	14	0.32	10	0.23	44
2021	High	25	0.42	20	0.34	14	0.24	59
2021	Low	36	0.54	14	0.21	17	0.25	67
2021	Moderate	13	0.38	17	0.50	4	0.12	34
2021	Outside100	22	0.36	25	0.41	14	0.23	61
2022	High	98	0.37	86	0.33	80	0.30	264
2022	Low	315	0.58	162	0.30	63	0.12	540
2022	Moderate	86	0.41	79	0.38	44	0.21	209
2022	Outside100	142	0.47	90	0.30	68	0.23	300

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	598	0.42	431	0.30	399	0.28	1428
Low	984	0.57	443	0.26	291	0.17	1718
Moderate	527	0.43	463	0.38	229	0.19	1219
Outside100	875	0.47	600	0.32	372	0.20	1847

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+ yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	127	0.44	87	0.30	73	0.25	287
2013	Low	135	0.55	65	0.27	45	0.18	245
2013	Moderate	103	0.45	92	0.40	36	0.16	231
2013	Outside100	200	0.48	138	0.33	83	0.20	421
2014	High	27	0.32	31	0.37	26	0.31	84
2014	Low	37	0.56	15	0.23	14	0.21	66
2014	Moderate	44	0.45	32	0.33	21	0.22	97
2014	Outside100	60	0.52	29	0.25	27	0.23	116
2015	High	37	0.54	19	0.28	12	0.18	68
2015	Low	71	0.54	36	0.27	24	0.18	131
2015	Moderate	41	0.54	24	0.32	11	0.14	76
2015	Outside100	46	0.52	28	0.32	14	0.16	88
2016	High	177	0.43	114	0.28	120	0.29	411
2016	Low	235	0.58	89	0.22	79	0.20	403
2016	Moderate	135	0.42	118	0.37	70	0.22	323
2016	Outside100	212	0.45	154	0.33	104	0.22	470
2017	High	37	0.44	22	0.26	25	0.30	84
2017	Low	58	0.64	17	0.19	16	0.18	91
2017	Moderate	33	0.39	41	0.49	10	0.12	84
2017	Outside100	69	0.47	54	0.37	23	0.16	146
2018	High	24	0.37	17	0.26	24	0.37	65
2018	Low	40	0.54	19	0.26	15	0.20	74
2018	Moderate	32	0.40	31	0.39	17	0.21	80
2018	Outside100	78	0.54	47	0.32	20	0.14	145
2019	High	22	0.46	14	0.29	12	0.25	48
2019	Low	23	0.53	12	0.28	8	0.19	43
2019	Moderate	18	0.38	20	0.43	9	0.19	47
2019	Outside100	26	0.46	21	0.38	9	0.16	56
2020	High	24	0.41	21	0.36	13	0.22	58
2020	Low	34	0.59	14	0.24	10	0.17	58
2020	Moderate	22	0.58	9	0.24	7	0.18	38
2020	Outside100	20	0.45	14	0.32	10	0.23	44
2021	High	25	0.42	20	0.34	14	0.24	59
2021	Low	36	0.54	14	0.21	17	0.25	67
2021	Moderate	13	0.38	17	0.50	4	0.12	34
2021	Outside100	22	0.36	25	0.41	14	0.23	61
2022	High	98	0.37	86	0.33	80	0.30	264
2022	Low	315	0.58	162	0.30	63	0.12	540
2022	Moderate	86	0.41	79	0.38	44	0.21	209
2022	Outside100	142	0.47	90	0.30	68	0.23	300

Matrix Pop Moderate Counts

This breaks down by the number of births, deaths and expansions by population level, creating a table for all years. The dataset is filtered for businesses with a CBSA population level that is moderate among the top 100.

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	17421	0.38	19803	0.43	9114	0.20	46338
Low	33605	0.53	24466	0.39	5280	0.08	63351
Moderate	15828	0.34	26258	0.56	4554	0.10	46640
Outside100	25022	0.45	24683	0.44	6169	0.11	55874

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	3386	0.41	3422	0.41	1511	0.18	8319
2013	Low	3761	0.56	2362	0.35	640	0.09	6763
2013	Moderate	2489	0.37	3672	0.54	650	0.10	6811
2013	Outside100	3651	0.46	3451	0.43	917	0.11	8019
2014	High	1859	0.38	1976	0.40	1063	0.22	4898
2014	Low	3039	0.59	1675	0.33	411	0.08	5125
2014	Moderate	1684	0.33	2961	0.58	457	0.09	5102
2014	Outside100	2434	0.46	2293	0.43	603	0.11	5330
2015	High	1894	0.40	1907	0.41	881	0.19	4682
2015	Low	2716	0.58	1531	0.33	445	0.09	4692
2015	Moderate	1857	0.39	2414	0.51	509	0.11	4780
2015	Outside100	2477	0.46	2300	0.43	625	0.12	5402
2016	High	1440	0.38	1609	0.43	713	0.19	3762
2016	Low	2328	0.60	1254	0.32	329	0.08	3911
2016	Moderate	1691	0.34	2686	0.54	591	0.12	4968
2016	Outside100	2193	0.45	2161	0.44	544	0.11	4898
2017	High	1402	0.37	1631	0.44	716	0.19	3749
2017	Low	1767	0.50	1360	0.39	377	0.11	3504
2017	Moderate	931	0.33	1551	0.55	359	0.13	2841
2017	Outside100	1931	0.45	1916	0.45	433	0.10	4280
2018	High	1514	0.37	1769	0.44	763	0.19	4046
2018	Low	2359	0.58	1384	0.34	310	0.08	4053
2018	Moderate	1277	0.32	2390	0.60	340	0.08	4007
2018	Outside100	2290	0.43	2388	0.45	594	0.11	5272
2019	High	1590	0.34	2130	0.45	1025	0.22	4745
2019	Low	2172	0.56	1407	0.37	266	0.07	3845
2019	Moderate	1458	0.32	2634	0.58	418	0.09	4510
2019	Outside100	1987	0.45	1983	0.44	487	0.11	4457
2020	High	1643	0.35	2181	0.47	835	0.18	4659
2020	Low	5873	0.46	5731	0.45	1153	0.09	12757
2020	Moderate	1078	0.30	2173	0.61	335	0.09	3586
2020	Outside100	3114	0.43	3247	0.45	923	0.13	7284
2021	High	916	0.35	1094	0.41	635	0.24	2645
2021	Low	2145	0.66	907	0.28	208	0.06	3260
2021	Moderate	803	0.27	1916	0.66	205	0.07	2924
2021	Outside100	1632	0.46	1589	0.44	351	0.10	3572
2022	High	1777	0.37	2084	0.43	972	0.20	4833
2022	Low	7445	0.48	6855	0.44	1141	0.07	15441
2022	Moderate	2560	0.36	3861	0.54	690	0.10	7111
2022	Outside100	3313	0.45	3355	0.46	692	0.09	7360

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	16101	0.39	17083	0.42	7642	0.19	40826
Low	19604	0.55	12871	0.36	3387	0.09	35862
Moderate	12749	0.36	19138	0.54	3608	0.10	35495
Outside100	22148	0.46	20728	0.43	5364	0.11	48240

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2012	High	1754	0.43	1722	0.42	613	0.15	4089
2012	Low	1593	0.56	972	0.34	263	0.09	2828
2012	Moderate	905	0.34	1478	0.56	270	0.10	2653
2012	Outside100	1972	0.47	1747	0.41	514	0.12	4233
2013	High	1345	0.40	1353	0.41	623	0.19	3321
2013	Low	1520	0.52	1104	0.38	302	0.10	2926
2013	Moderate	1117	0.37	1589	0.52	323	0.11	3029
2013	Outside100	1924	0.46	1805	0.43	452	0.11	4181
2014	High	1450	0.39	1543	0.42	725	0.19	3718
2014	Low	1639	0.54	1065	0.35	338	0.11	3042
2014	Moderate	1304	0.36	2012	0.55	349	0.10	3665
2014	Outside100	2188	0.44	2183	0.44	590	0.12	4961
2015	High	1336	0.39	1407	0.41	688	0.20	3431
2015	Low	1971	0.55	1284	0.36	324	0.09	3579
2015	Moderate	1453	0.36	2102	0.53	441	0.11	3996
2015	Outside100	2130	0.47	1924	0.42	504	0.11	4558
2016	High	1783	0.38	1955	0.42	903	0.19	4641
2016	Low	2413	0.55	1528	0.35	437	0.10	4378
2016	Moderate	1617	0.37	2294	0.53	436	0.10	4347
2016	Outside100	2919	0.47	2674	0.43	668	0.11	6261
2017	High	2748	0.41	2798	0.42	1173	0.17	6719
2017	Low	2685	0.55	1731	0.36	435	0.09	4851
2017	Moderate	1703	0.37	2489	0.53	461	0.10	4653
2017	Outside100	3017	0.46	2863	0.44	679	0.10	6559
2018	High	1462	0.39	1600	0.43	653	0.18	3715
2018	Low	2219	0.57	1361	0.35	337	0.09	3917
2018	Moderate	1370	0.36	2079	0.54	405	0.11	3854
2018	Outside100	3111	0.46	2887	0.43	738	0.11	6736
2019	High	1528	0.40	1615	0.42	698	0.18	3841
2019	Low	1935	0.54	1272	0.35	409	0.11	3616
2019	Moderate	1323	0.36	1955	0.54	371	0.10	3649
2019	Outside100	2003	0.46	1859	0.42	518	0.12	4380
2020	High	1130	0.37	1321	0.43	612	0.20	3063
2020	Low	1241	0.56	787	0.35	191	0.09	2219
2020	Moderate	843	0.35	1308	0.55	236	0.10	2387
2020	Outside100	1189	0.43	1251	0.45	320	0.12	2760
2021	High	1565	0.36	1769	0.41	954	0.22	4288
2021	Low	2388	0.53	1767	0.39	351	0.08	4506
2021	Moderate	1114	0.34	1832	0.56	316	0.10	3262
2021	Outside100	1695	0.47	1535	0.43	381	0.11	3611

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	882	0.38	954	0.41	493	0.21	2329
Low	1642	0.54	1085	0.36	309	0.10	3036
Moderate	794	0.36	1218	0.55	222	0.10	2234
Outside100	1267	0.46	1216	0.44	287	0.10	2770

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	181	0.39	194	0.42	91	0.20	466
2013	Low	200	0.50	145	0.37	52	0.13	397
2013	Moderate	148	0.37	202	0.51	46	0.12	396
2013	Outside100	242	0.45	236	0.44	56	0.10	534
2014	High	55	0.35	62	0.40	38	0.25	155
2014	Low	76	0.61	42	0.34	6	0.05	124
2014	Moderate	53	0.29	113	0.62	15	0.08	181
2014	Outside100	81	0.47	73	0.42	18	0.10	172
2015	High	47	0.44	37	0.35	23	0.21	107
2015	Low	108	0.53	78	0.38	19	0.09	205
2015	Moderate	43	0.34	75	0.59	9	0.07	127
2015	Outside100	66	0.47	60	0.43	13	0.09	139
2016	High	258	0.36	298	0.41	170	0.23	726
2016	Low	355	0.54	235	0.36	66	0.10	656
2016	Moderate	228	0.35	362	0.56	53	0.08	643
2016	Outside100	336	0.42	375	0.47	92	0.11	803
2017	High	59	0.38	66	0.42	31	0.20	156
2017	Low	87	0.58	51	0.34	13	0.09	151
2017	Moderate	53	0.35	84	0.56	13	0.09	150
2017	Outside100	96	0.48	78	0.39	24	0.12	198
2018	High	38	0.38	41	0.41	20	0.20	99
2018	Low	77	0.62	40	0.32	8	0.06	125
2018	Moderate	56	0.39	71	0.49	17	0.12	144
2018	Outside100	108	0.45	107	0.45	23	0.10	238
2019	High	34	0.45	25	0.33	16	0.21	75
2019	Low	41	0.62	21	0.32	4	0.06	66
2019	Moderate	33	0.48	27	0.39	9	0.13	69
2019	Outside100	38	0.51	32	0.43	5	0.07	75
2020	High	21	0.33	30	0.48	12	0.19	63
2020	Low	39	0.51	28	0.37	9	0.12	76
2020	Moderate	17	0.35	28	0.57	4	0.08	49
2020	Outside100	48	0.49	41	0.42	9	0.09	98
2021	High	36	0.39	42	0.45	15	0.16	93
2021	Low	74	0.63	39	0.33	5	0.04	118
2021	Moderate	28	0.44	30	0.48	5	0.08	63
2021	Outside100	38	0.48	33	0.42	8	0.10	79
2022	High	153	0.39	159	0.41	77	0.20	389
2022	Low	585	0.52	406	0.36	127	0.11	1118
2022	Moderate	135	0.33	226	0.55	51	0.12	412
2022	Outside100	214	0.49	181	0.42	39	0.09	434

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	882	0.38	954	0.41	493	0.21	2329
Low	1642	0.54	1085	0.36	309	0.10	3036
Moderate	794	0.36	1218	0.55	222	0.10	2234
Outside100	1267	0.46	1216	0.44	287	0.10	2770

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+ yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	181	0.39	194	0.42	91	0.20	466
2013	Low	200	0.50	145	0.37	52	0.13	397
2013	Moderate	148	0.37	202	0.51	46	0.12	396
2013	Outside100	242	0.45	236	0.44	56	0.10	534
2014	High	55	0.35	62	0.40	38	0.25	155
2014	Low	76	0.61	42	0.34	6	0.05	124
2014	Moderate	53	0.29	113	0.62	15	0.08	181
2014	Outside100	81	0.47	73	0.42	18	0.10	172
2015	High	47	0.44	37	0.35	23	0.21	107
2015	Low	108	0.53	78	0.38	19	0.09	205
2015	Moderate	43	0.34	75	0.59	9	0.07	127
2015	Outside100	66	0.47	60	0.43	13	0.09	139
2016	High	258	0.36	298	0.41	170	0.23	726
2016	Low	355	0.54	235	0.36	66	0.10	656
2016	Moderate	228	0.35	362	0.56	53	0.08	643
2016	Outside100	336	0.42	375	0.47	92	0.11	803
2017	High	59	0.38	66	0.42	31	0.20	156
2017	Low	87	0.58	51	0.34	13	0.09	151
2017	Moderate	53	0.35	84	0.56	13	0.09	150
2017	Outside100	96	0.48	78	0.39	24	0.12	198
2018	High	38	0.38	41	0.41	20	0.20	99
2018	Low	77	0.62	40	0.32	8	0.06	125
2018	Moderate	56	0.39	71	0.49	17	0.12	144
2018	Outside100	108	0.45	107	0.45	23	0.10	238
2019	High	34	0.45	25	0.33	16	0.21	75
2019	Low	41	0.62	21	0.32	4	0.06	66
2019	Moderate	33	0.48	27	0.39	9	0.13	69
2019	Outside100	38	0.51	32	0.43	5	0.07	75
2020	High	21	0.33	30	0.48	12	0.19	63
2020	Low	39	0.51	28	0.37	9	0.12	76
2020	Moderate	17	0.35	28	0.57	4	0.08	49
2020	Outside100	48	0.49	41	0.42	9	0.09	98
2021	High	36	0.39	42	0.45	15	0.16	93
2021	Low	74	0.63	39	0.33	5	0.04	118
2021	Moderate	28	0.44	30	0.48	5	0.08	63
2021	Outside100	38	0.48	33	0.42	8	0.10	79
2022	High	153	0.39	159	0.41	77	0.20	389
2022	Low	585	0.52	406	0.36	127	0.11	1118
2022	Moderate	135	0.33	226	0.55	51	0.12	412
2022	Outside100	214	0.49	181	0.42	39	0.09	434

Matrix Pop High Counts

This breaks down by the number of births, deaths and expansions by population level, creating a table for all years. The dataset is filtered for businesses with a CBSA population level that is high among the top 100.

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	34291	0.16	64420	0.29	121170	0.55	219881
Low	55467	0.29	65482	0.35	67816	0.36	188765
Moderate	28748	0.17	84589	0.51	52896	0.32	166233
Outside100	43290	0.23	70722	0.38	74055	0.39	188067

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	6767	0.17	11898	0.30	20710	0.53	39375
2013	Low	6540	0.33	6538	0.33	6810	0.34	19888
2013	Moderate	4627	0.18	12782	0.51	7782	0.31	25191
2013	Outside100	6624	0.23	10454	0.37	11188	0.40	28266
2014	High	3761	0.15	7134	0.28	14209	0.57	25104
2014	Low	4985	0.35	4572	0.32	4605	0.33	14162
2014	Moderate	3071	0.17	9477	0.54	5034	0.29	17582
2014	Outside100	4591	0.24	7309	0.39	6995	0.37	18895
2015	High	3703	0.16	7205	0.30	12835	0.54	23743
2015	Low	4868	0.34	4645	0.32	4975	0.34	14488
2015	Moderate	3031	0.17	8901	0.51	5668	0.32	17600
2015	Outside100	4339	0.23	6957	0.37	7691	0.41	18987
2016	High	2899	0.15	5363	0.28	11011	0.57	19273
2016	Low	3948	0.35	3722	0.33	3721	0.33	11391
2016	Moderate	2993	0.17	8936	0.50	5857	0.33	17786
2016	Outside100	3749	0.23	6100	0.38	6384	0.39	16233
2017	High	2755	0.17	5132	0.31	8720	0.53	16607
2017	Low	3491	0.29	4515	0.38	3855	0.33	11861
2017	Moderate	1913	0.18	5288	0.49	3510	0.33	10711
2017	Outside100	2965	0.22	5337	0.39	5368	0.39	13670
2018	High	2998	0.16	5539	0.29	10410	0.55	18947
2018	Low	3834	0.34	3714	0.33	3580	0.32	11128
2018	Moderate	2081	0.16	6749	0.52	4152	0.32	12982
2018	Outside100	3653	0.23	6139	0.39	6079	0.38	15871
2019	High	3125	0.15	6097	0.30	11160	0.55	20382
2019	Low	3891	0.36	3366	0.31	3677	0.34	10934
2019	Moderate	2300	0.16	7352	0.52	4612	0.32	14264
2019	Outside100	3342	0.23	5427	0.37	6045	0.41	14814
2020	High	3160	0.16	6229	0.31	10790	0.53	20179
2020	Low	9303	0.27	12048	0.34	13698	0.39	35049
2020	Moderate	2053	0.17	6632	0.54	3695	0.30	12380
2020	Outside100	5170	0.23	8973	0.39	8826	0.38	22969
2021	High	1829	0.14	3381	0.25	8055	0.61	13265
2021	Low	3212	0.40	2324	0.29	2401	0.30	7937
2021	Moderate	1437	0.15	5785	0.59	2523	0.26	9745
2021	Outside100	2877	0.23	4447	0.36	5142	0.41	12466
2022	High	3294	0.14	6442	0.28	13270	0.58	23006
2022	Low	11395	0.22	20038	0.39	20494	0.39	51927
2022	Moderate	5242	0.19	12687	0.45	10063	0.36	27992
2022	Outside100	5980	0.23	9579	0.37	10337	0.40	25896

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	31083	0.17	58253	0.31	98667	0.52	188003
Low	33217	0.31	35567	0.34	37222	0.35	106006
Moderate	22586	0.18	62092	0.49	41671	0.33	126349
Outside100	37996	0.23	61703	0.37	65836	0.40	165535

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2012	High	3453	0.19	5711	0.31	9425	0.51	18589
2012	Low	2869	0.33	2883	0.33	2895	0.33	8647
2012	Moderate	1736	0.17	5288	0.51	3294	0.32	10318
2012	Outside100	3484	0.23	5839	0.39	5738	0.38	15061
2013	High	2542	0.16	5004	0.31	8431	0.53	15977
2013	Low	2773	0.30	3001	0.33	3338	0.37	9112
2013	Moderate	2131	0.18	5545	0.48	3913	0.34	11589
2013	Outside100	3532	0.23	5577	0.37	6109	0.40	15218
2014	High	2778	0.16	5243	0.31	8824	0.52	16845
2014	Low	3014	0.32	3121	0.33	3301	0.35	9436
2014	Moderate	2456	0.19	6328	0.48	4395	0.33	13179
2014	Outside100	4098	0.23	6806	0.38	7041	0.39	17945
2015	High	2629	0.16	5409	0.32	8895	0.53	16933
2015	Low	3414	0.31	3800	0.34	3807	0.35	11021
2015	Moderate	2687	0.18	7281	0.49	4982	0.33	14950
2015	Outside100	3569	0.22	6246	0.38	6611	0.40	16426
2016	High	3742	0.17	6810	0.31	11447	0.52	21999
2016	Low	4206	0.33	4251	0.33	4234	0.33	12691
2016	Moderate	2889	0.19	7579	0.49	5072	0.33	15540
2016	Outside100	4826	0.24	7532	0.37	7993	0.39	20351
2017	High	5129	0.17	9597	0.32	15541	0.51	30267
2017	Low	4419	0.32	4767	0.34	4802	0.34	13988
2017	Moderate	2883	0.17	8250	0.49	5564	0.33	16697
2017	Outside100	5258	0.23	8293	0.37	8848	0.40	22399
2018	High	2611	0.15	5282	0.31	9081	0.53	16974
2018	Low	3623	0.33	3594	0.33	3743	0.34	10960
2018	Moderate	2182	0.17	6542	0.50	4243	0.33	12967
2018	Outside100	5252	0.23	8381	0.37	8737	0.39	22370
2019	High	2935	0.16	5315	0.30	9584	0.54	17834
2019	Low	3299	0.30	3763	0.35	3810	0.35	10872
2019	Moderate	2250	0.19	5700	0.48	4030	0.34	11980
2019	Outside100	3238	0.24	5108	0.37	5419	0.39	13765
2020	High	2229	0.16	4176	0.30	7560	0.54	13965
2020	Low	2097	0.32	2123	0.32	2413	0.36	6633
2020	Moderate	1451	0.18	4082	0.50	2586	0.32	8119
2020	Outside100	2067	0.22	3368	0.36	4001	0.42	9436
2021	High	3035	0.16	5706	0.31	9879	0.53	18620
2021	Low	3503	0.28	4264	0.34	4879	0.39	12646
2021	Moderate	1921	0.17	5497	0.50	3592	0.33	11010
2021	Outside100	2672	0.21	4553	0.36	5339	0.42	12564

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	1863	0.16	3476	0.30	6078	0.53	11417
Low	2705	0.32	2935	0.35	2812	0.33	8452
Moderate	1536	0.19	4129	0.50	2598	0.31	8263
Outside100	2279	0.23	3625	0.37	3838	0.39	9742

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	370	0.16	776	0.33	1192	0.51	2338
2013	Low	338	0.28	420	0.34	461	0.38	1219
2013	Moderate	319	0.20	692	0.44	575	0.36	1586
2013	Outside100	510	0.24	740	0.35	889	0.42	2139
2014	High	120	0.15	221	0.29	434	0.56	775
2014	Low	124	0.34	120	0.33	118	0.33	362
2014	Moderate	108	0.18	308	0.50	201	0.33	617
2014	Outside100	131	0.23	223	0.38	228	0.39	582
2015	High	117	0.19	188	0.30	316	0.51	621
2015	Low	176	0.33	183	0.35	171	0.32	530
2015	Moderate	89	0.17	299	0.56	149	0.28	537
2015	Outside100	100	0.19	213	0.40	218	0.41	531
2016	High	579	0.16	1090	0.30	1992	0.54	3661
2016	Low	699	0.36	605	0.31	630	0.33	1934
2016	Moderate	486	0.19	1283	0.50	806	0.31	2575
2016	Outside100	673	0.23	1093	0.37	1212	0.41	2978
2017	High	134	0.18	233	0.31	393	0.52	760
2017	Low	168	0.38	149	0.34	125	0.28	442
2017	Moderate	86	0.17	265	0.53	153	0.30	504
2017	Outside100	144	0.24	227	0.37	241	0.39	612
2018	High	101	0.16	191	0.31	322	0.52	614
2018	Low	133	0.36	124	0.34	112	0.30	369
2018	Moderate	92	0.18	260	0.52	146	0.29	498
2018	Outside100	222	0.26	336	0.39	298	0.35	856
2019	High	63	0.18	109	0.31	182	0.51	354
2019	Low	67	0.35	68	0.35	59	0.30	194
2019	Moderate	46	0.18	125	0.50	78	0.31	249
2019	Outside100	60	0.23	103	0.39	98	0.38	261
2020	High	62	0.16	122	0.31	213	0.54	397
2020	Low	82	0.33	84	0.33	85	0.34	251
2020	Moderate	40	0.17	121	0.53	69	0.30	230
2020	Outside100	52	0.22	98	0.41	87	0.37	237
2021	High	60	0.18	90	0.27	188	0.56	338
2021	Low	100	0.29	96	0.28	148	0.43	344
2021	Moderate	42	0.21	111	0.56	45	0.23	198
2021	Outside100	54	0.20	90	0.34	123	0.46	267
2022	High	257	0.16	456	0.29	846	0.54	1559
2022	Low	818	0.29	1086	0.39	903	0.32	2807
2022	Moderate	228	0.18	665	0.52	376	0.30	1269
2022	Outside100	333	0.26	502	0.39	444	0.35	1279

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	1863	0.16	3476	0.30	6078	0.53	11417
Low	2705	0.32	2935	0.35	2812	0.33	8452
Moderate	1536	0.19	4129	0.50	2598	0.31	8263
Outside100	2279	0.23	3625	0.37	3838	0.39	9742

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+ yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	370	0.16	776	0.33	1192	0.51	2338
2013	Low	338	0.28	420	0.34	461	0.38	1219
2013	Moderate	319	0.20	692	0.44	575	0.36	1586
2013	Outside100	510	0.24	740	0.35	889	0.42	2139
2014	High	120	0.15	221	0.29	434	0.56	775
2014	Low	124	0.34	120	0.33	118	0.33	362
2014	Moderate	108	0.18	308	0.50	201	0.33	617
2014	Outside100	131	0.23	223	0.38	228	0.39	582
2015	High	117	0.19	188	0.30	316	0.51	621
2015	Low	176	0.33	183	0.35	171	0.32	530
2015	Moderate	89	0.17	299	0.56	149	0.28	537
2015	Outside100	100	0.19	213	0.40	218	0.41	531
2016	High	579	0.16	1090	0.30	1992	0.54	3661
2016	Low	699	0.36	605	0.31	630	0.33	1934
2016	Moderate	486	0.19	1283	0.50	806	0.31	2575
2016	Outside100	673	0.23	1093	0.37	1212	0.41	2978
2017	High	134	0.18	233	0.31	393	0.52	760
2017	Low	168	0.38	149	0.34	125	0.28	442
2017	Moderate	86	0.17	265	0.53	153	0.30	504
2017	Outside100	144	0.24	227	0.37	241	0.39	612
2018	High	101	0.16	191	0.31	322	0.52	614
2018	Low	133	0.36	124	0.34	112	0.30	369
2018	Moderate	92	0.18	260	0.52	146	0.29	498
2018	Outside100	222	0.26	336	0.39	298	0.35	856
2019	High	63	0.18	109	0.31	182	0.51	354
2019	Low	67	0.35	68	0.35	59	0.30	194
2019	Moderate	46	0.18	125	0.50	78	0.31	249
2019	Outside100	60	0.23	103	0.39	98	0.38	261
2020	High	62	0.16	122	0.31	213	0.54	397
2020	Low	82	0.33	84	0.33	85	0.34	251
2020	Moderate	40	0.17	121	0.53	69	0.30	230
2020	Outside100	52	0.22	98	0.41	87	0.37	237
2021	High	60	0.18	90	0.27	188	0.56	338
2021	Low	100	0.29	96	0.28	148	0.43	344
2021	Moderate	42	0.21	111	0.56	45	0.23	198
2021	Outside100	54	0.20	90	0.34	123	0.46	267
2022	High	257	0.16	456	0.29	846	0.54	1559
2022	Low	818	0.29	1086	0.39	903	0.32	2807
2022	Moderate	228	0.18	665	0.52	376	0.30	1269
2022	Outside100	333	0.26	502	0.39	444	0.35	1279

Matrix Region (Proximate) Counts

This chunk shows the matrices for HQs and businesses within the same region

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	7771	0.09	9379	0.10	73386	0.81	90536
Low	54549	0.65	16596	0.20	13075	0.16	84220
Moderate	10915	0.13	64688	0.78	7650	0.09	83253

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	1379	0.10	1433	0.10	11526	0.80	14338
2013	Low	7208	0.65	2156	0.19	1759	0.16	11123
2013	Moderate	1919	0.15	9741	0.76	1167	0.09	12827
2014	High	904	0.08	1277	0.11	9190	0.81	11371
2014	Low	5721	0.69	1485	0.18	1118	0.13	8324
2014	Moderate	1245	0.12	8067	0.80	826	0.08	10138
2015	High	777	0.08	984	0.11	7540	0.81	9301
2015	Low	5258	0.68	1344	0.17	1119	0.14	7721
2015	Moderate	1232	0.14	6794	0.76	860	0.10	8886
2016	High	651	0.07	968	0.11	7123	0.81	8742
2016	Low	4713	0.69	1257	0.18	892	0.13	6862
2016	Moderate	1053	0.12	7171	0.78	913	0.10	9137
2017	High	612	0.09	839	0.13	5011	0.78	6462
2017	Low	3137	0.62	1281	0.25	612	0.12	5030
2017	Moderate	664	0.13	3819	0.77	476	0.10	4959
2018	High	619	0.08	797	0.11	6118	0.81	7534
2018	Low	4600	0.69	1224	0.18	800	0.12	6624
2018	Moderate	837	0.12	5492	0.80	544	0.08	6873
2019	High	721	0.09	830	0.10	6787	0.81	8338
2019	Low	4735	0.68	1158	0.17	1032	0.15	6925
2019	Moderate	877	0.12	5777	0.78	727	0.10	7381
2020	High	783	0.10	782	0.10	6214	0.80	7779
2020	Low	5096	0.61	1867	0.22	1440	0.17	8403
2020	Moderate	870	0.13	5110	0.77	623	0.09	6603
2021	High	470	0.07	576	0.09	5506	0.84	6552
2021	Low	4636	0.77	757	0.13	589	0.10	5982
2021	Moderate	796	0.11	5414	0.78	723	0.10	6933
2022	High	855	0.08	893	0.09	8371	0.83	10119
2022	Low	9445	0.55	4067	0.24	3714	0.22	17226
2022	Moderate	1422	0.15	7303	0.77	791	0.08	9516

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	7121	0.10	8416	0.12	55469	0.78	71006
Low	34853	0.63	11223	0.20	9236	0.17	55312
Moderate	9090	0.15	46034	0.76	5766	0.09	60890

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2012	High	559	0.09	650	0.10	5125	0.81	6334
2012	Low	3010	0.66	884	0.19	692	0.15	4586
2012	Moderate	704	0.13	4065	0.77	498	0.09	5267
2013	High	650	0.11	641	0.10	4859	0.79	6150
2013	Low	2778	0.61	929	0.20	875	0.19	4582
2013	Moderate	872	0.16	4111	0.75	508	0.09	5491
2014	High	651	0.10	726	0.11	5059	0.79	6436
2014	Low	3027	0.62	966	0.20	908	0.19	4901
2014	Moderate	947	0.16	4546	0.75	542	0.09	6035
2015	High	682	0.10	765	0.12	5053	0.78	6500
2015	Low	3571	0.62	1280	0.22	902	0.16	5753
2015	Moderate	1098	0.16	5106	0.74	730	0.11	6934
2016	High	895	0.11	946	0.12	6290	0.77	8131
2016	Low	4276	0.63	1402	0.21	1142	0.17	6820
2016	Moderate	1022	0.14	5561	0.76	770	0.10	7353
2017	High	1137	0.11	1090	0.10	8326	0.79	10553
2017	Low	4992	0.65	1556	0.20	1152	0.15	7700
2017	Moderate	1131	0.14	6174	0.77	695	0.09	8000
2018	High	595	0.09	1116	0.16	5284	0.76	6995
2018	Low	4051	0.63	1291	0.20	1041	0.16	6383
2018	Moderate	899	0.14	4919	0.78	499	0.08	6317
2019	High	580	0.08	828	0.12	5419	0.79	6827
2019	Low	3244	0.61	1127	0.21	904	0.17	5275
2019	Moderate	814	0.15	4018	0.76	469	0.09	5301
2020	High	511	0.10	684	0.13	4128	0.78	5323
2020	Low	2327	0.64	634	0.17	699	0.19	3660
2020	Moderate	608	0.15	3100	0.76	378	0.09	4086
2021	High	861	0.11	970	0.13	5926	0.76	7757
2021	Low	3577	0.63	1154	0.20	921	0.16	5652
2021	Moderate	995	0.16	4434	0.73	677	0.11	6106

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	387	0.09	493	0.11	3629	0.80	4509
Low	2554	0.65	749	0.19	654	0.17	3957
Moderate	554	0.14	3083	0.77	379	0.09	4016

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	84	0.10	95	0.11	652	0.78	831
2013	Low	341	0.60	119	0.21	110	0.19	570
2013	Moderate	93	0.15	454	0.73	73	0.12	620
2014	High	25	0.07	39	0.11	283	0.82	347
2014	Low	151	0.63	56	0.23	34	0.14	241
2014	Moderate	38	0.12	265	0.83	15	0.05	318
2015	High	18	0.07	26	0.11	200	0.82	244
2015	Low	182	0.61	62	0.21	54	0.18	298
2015	Moderate	35	0.12	234	0.81	20	0.07	289
2016	High	117	0.08	143	0.10	1164	0.82	1424
2016	Low	754	0.64	229	0.20	191	0.16	1174
2016	Moderate	168	0.14	936	0.75	139	0.11	1243
2017	High	23	0.08	18	0.06	249	0.86	290
2017	Low	175	0.71	32	0.13	40	0.16	247
2017	Moderate	33	0.13	219	0.84	10	0.04	262
2018	High	20	0.08	27	0.11	201	0.81	248
2018	Low	153	0.67	53	0.23	22	0.10	228
2018	Moderate	26	0.11	192	0.82	15	0.06	233
2019	High	11	0.08	15	0.11	107	0.80	133
2019	Low	77	0.69	18	0.16	17	0.15	112
2019	Moderate	18	0.14	95	0.75	14	0.11	127
2020	High	8	0.05	18	0.11	131	0.83	157
2020	Low	95	0.69	23	0.17	20	0.14	138
2020	Moderate	21	0.18	84	0.71	14	0.12	119
2021	High	18	0.11	19	0.12	121	0.77	158
2021	Low	93	0.67	17	0.12	28	0.20	138
2021	Moderate	23	0.19	91	0.75	8	0.07	122
2022	High	63	0.09	93	0.14	521	0.77	677
2022	Low	533	0.66	140	0.17	138	0.17	811
2022	Moderate	99	0.14	513	0.75	71	0.10	683

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	387	0.09	493	0.11	3629	0.80	4509
Low	2554	0.65	749	0.19	654	0.17	3957
Moderate	554	0.14	3083	0.77	379	0.09	4016

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+ yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	84	0.10	95	0.11	652	0.78	831
2013	Low	341	0.60	119	0.21	110	0.19	570
2013	Moderate	93	0.15	454	0.73	73	0.12	620
2014	High	25	0.07	39	0.11	283	0.82	347
2014	Low	151	0.63	56	0.23	34	0.14	241
2014	Moderate	38	0.12	265	0.83	15	0.05	318
2015	High	18	0.07	26	0.11	200	0.82	244
2015	Low	182	0.61	62	0.21	54	0.18	298
2015	Moderate	35	0.12	234	0.81	20	0.07	289
2016	High	117	0.08	143	0.10	1164	0.82	1424
2016	Low	754	0.64	229	0.20	191	0.16	1174
2016	Moderate	168	0.14	936	0.75	139	0.11	1243
2017	High	23	0.08	18	0.06	249	0.86	290
2017	Low	175	0.71	32	0.13	40	0.16	247
2017	Moderate	33	0.13	219	0.84	10	0.04	262
2018	High	20	0.08	27	0.11	201	0.81	248
2018	Low	153	0.67	53	0.23	22	0.10	228
2018	Moderate	26	0.11	192	0.82	15	0.06	233
2019	High	11	0.08	15	0.11	107	0.80	133
2019	Low	77	0.69	18	0.16	17	0.15	112
2019	Moderate	18	0.14	95	0.75	14	0.11	127
2020	High	8	0.05	18	0.11	131	0.83	157
2020	Low	95	0.69	23	0.17	20	0.14	138
2020	Moderate	21	0.18	84	0.71	14	0.12	119
2021	High	18	0.11	19	0.12	121	0.77	158
2021	Low	93	0.67	17	0.12	28	0.20	138
2021	Moderate	23	0.19	91	0.75	8	0.07	122
2022	High	63	0.09	93	0.14	521	0.77	677
2022	Low	533	0.66	140	0.17	138	0.17	811
2022	Moderate	99	0.14	513	0.75	71	0.10	683

Matrix Region (Proximate) Counts Top 100 Only

This chunk shows the matrices for HQs and businesses within the same region, if both are in the top 100 CBSAs by population

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	7771	0.09	9379	0.10	73386	0.81	90536
Low	54549	0.65	16596	0.20	13075	0.16	84220
Moderate	10915	0.13	64688	0.78	7650	0.09	83253

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	1379	0.10	1433	0.10	11526	0.80	14338
2013	Low	7208	0.65	2156	0.19	1759	0.16	11123
2013	Moderate	1919	0.15	9741	0.76	1167	0.09	12827
2014	High	904	0.08	1277	0.11	9190	0.81	11371
2014	Low	5721	0.69	1485	0.18	1118	0.13	8324
2014	Moderate	1245	0.12	8067	0.80	826	0.08	10138
2015	High	777	0.08	984	0.11	7540	0.81	9301
2015	Low	5258	0.68	1344	0.17	1119	0.14	7721
2015	Moderate	1232	0.14	6794	0.76	860	0.10	8886
2016	High	651	0.07	968	0.11	7123	0.81	8742
2016	Low	4713	0.69	1257	0.18	892	0.13	6862
2016	Moderate	1053	0.12	7171	0.78	913	0.10	9137
2017	High	612	0.09	839	0.13	5011	0.78	6462
2017	Low	3137	0.62	1281	0.25	612	0.12	5030
2017	Moderate	664	0.13	3819	0.77	476	0.10	4959
2018	High	619	0.08	797	0.11	6118	0.81	7534
2018	Low	4600	0.69	1224	0.18	800	0.12	6624
2018	Moderate	837	0.12	5492	0.80	544	0.08	6873
2019	High	721	0.09	830	0.10	6787	0.81	8338
2019	Low	4735	0.68	1158	0.17	1032	0.15	6925
2019	Moderate	877	0.12	5777	0.78	727	0.10	7381
2020	High	783	0.10	782	0.10	6214	0.80	7779
2020	Low	5096	0.61	1867	0.22	1440	0.17	8403
2020	Moderate	870	0.13	5110	0.77	623	0.09	6603
2021	High	470	0.07	576	0.09	5506	0.84	6552
2021	Low	4636	0.77	757	0.13	589	0.10	5982
2021	Moderate	796	0.11	5414	0.78	723	0.10	6933
2022	High	855	0.08	893	0.09	8371	0.83	10119
2022	Low	9445	0.55	4067	0.24	3714	0.22	17226
2022	Moderate	1422	0.15	7303	0.77	791	0.08	9516

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	7121	0.10	8416	0.12	55469	0.78	71006
Low	34853	0.63	11223	0.20	9236	0.17	55312
Moderate	9090	0.15	46034	0.76	5766	0.09	60890

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2012	High	559	0.09	650	0.10	5125	0.81	6334
2012	Low	3010	0.66	884	0.19	692	0.15	4586
2012	Moderate	704	0.13	4065	0.77	498	0.09	5267
2013	High	650	0.11	641	0.10	4859	0.79	6150
2013	Low	2778	0.61	929	0.20	875	0.19	4582
2013	Moderate	872	0.16	4111	0.75	508	0.09	5491
2014	High	651	0.10	726	0.11	5059	0.79	6436
2014	Low	3027	0.62	966	0.20	908	0.19	4901
2014	Moderate	947	0.16	4546	0.75	542	0.09	6035
2015	High	682	0.10	765	0.12	5053	0.78	6500
2015	Low	3571	0.62	1280	0.22	902	0.16	5753
2015	Moderate	1098	0.16	5106	0.74	730	0.11	6934
2016	High	895	0.11	946	0.12	6290	0.77	8131
2016	Low	4276	0.63	1402	0.21	1142	0.17	6820
2016	Moderate	1022	0.14	5561	0.76	770	0.10	7353
2017	High	1137	0.11	1090	0.10	8326	0.79	10553
2017	Low	4992	0.65	1556	0.20	1152	0.15	7700
2017	Moderate	1131	0.14	6174	0.77	695	0.09	8000
2018	High	595	0.09	1116	0.16	5284	0.76	6995
2018	Low	4051	0.63	1291	0.20	1041	0.16	6383
2018	Moderate	899	0.14	4919	0.78	499	0.08	6317
2019	High	580	0.08	828	0.12	5419	0.79	6827
2019	Low	3244	0.61	1127	0.21	904	0.17	5275
2019	Moderate	814	0.15	4018	0.76	469	0.09	5301
2020	High	511	0.10	684	0.13	4128	0.78	5323
2020	Low	2327	0.64	634	0.17	699	0.19	3660
2020	Moderate	608	0.15	3100	0.76	378	0.09	4086
2021	High	861	0.11	970	0.13	5926	0.76	7757
2021	Low	3577	0.63	1154	0.20	921	0.16	5652
2021	Moderate	995	0.16	4434	0.73	677	0.11	6106

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	387	0.09	493	0.11	3629	0.80	4509
Low	2554	0.65	749	0.19	654	0.17	3957
Moderate	554	0.14	3083	0.77	379	0.09	4016

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	84	0.10	95	0.11	652	0.78	831
2013	Low	341	0.60	119	0.21	110	0.19	570
2013	Moderate	93	0.15	454	0.73	73	0.12	620
2014	High	25	0.07	39	0.11	283	0.82	347
2014	Low	151	0.63	56	0.23	34	0.14	241
2014	Moderate	38	0.12	265	0.83	15	0.05	318
2015	High	18	0.07	26	0.11	200	0.82	244
2015	Low	182	0.61	62	0.21	54	0.18	298
2015	Moderate	35	0.12	234	0.81	20	0.07	289
2016	High	117	0.08	143	0.10	1164	0.82	1424
2016	Low	754	0.64	229	0.20	191	0.16	1174
2016	Moderate	168	0.14	936	0.75	139	0.11	1243
2017	High	23	0.08	18	0.06	249	0.86	290
2017	Low	175	0.71	32	0.13	40	0.16	247
2017	Moderate	33	0.13	219	0.84	10	0.04	262
2018	High	20	0.08	27	0.11	201	0.81	248
2018	Low	153	0.67	53	0.23	22	0.10	228
2018	Moderate	26	0.11	192	0.82	15	0.06	233
2019	High	11	0.08	15	0.11	107	0.80	133
2019	Low	77	0.69	18	0.16	17	0.15	112
2019	Moderate	18	0.14	95	0.75	14	0.11	127
2020	High	8	0.05	18	0.11	131	0.83	157
2020	Low	95	0.69	23	0.17	20	0.14	138
2020	Moderate	21	0.18	84	0.71	14	0.12	119
2021	High	18	0.11	19	0.12	121	0.77	158
2021	Low	93	0.67	17	0.12	28	0.20	138
2021	Moderate	23	0.19	91	0.75	8	0.07	122
2022	High	63	0.09	93	0.14	521	0.77	677
2022	Low	533	0.66	140	0.17	138	0.17	811
2022	Moderate	99	0.14	513	0.75	71	0.10	683

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	387	0.09	493	0.11	3629	0.80	4509
Low	2554	0.65	749	0.19	654	0.17	3957
Moderate	554	0.14	3083	0.77	379	0.09	4016

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+ yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	84	0.10	95	0.11	652	0.78	831
2013	Low	341	0.60	119	0.21	110	0.19	570
2013	Moderate	93	0.15	454	0.73	73	0.12	620
2014	High	25	0.07	39	0.11	283	0.82	347
2014	Low	151	0.63	56	0.23	34	0.14	241
2014	Moderate	38	0.12	265	0.83	15	0.05	318
2015	High	18	0.07	26	0.11	200	0.82	244
2015	Low	182	0.61	62	0.21	54	0.18	298
2015	Moderate	35	0.12	234	0.81	20	0.07	289
2016	High	117	0.08	143	0.10	1164	0.82	1424
2016	Low	754	0.64	229	0.20	191	0.16	1174
2016	Moderate	168	0.14	936	0.75	139	0.11	1243
2017	High	23	0.08	18	0.06	249	0.86	290
2017	Low	175	0.71	32	0.13	40	0.16	247
2017	Moderate	33	0.13	219	0.84	10	0.04	262
2018	High	20	0.08	27	0.11	201	0.81	248
2018	Low	153	0.67	53	0.23	22	0.10	228
2018	Moderate	26	0.11	192	0.82	15	0.06	233
2019	High	11	0.08	15	0.11	107	0.80	133
2019	Low	77	0.69	18	0.16	17	0.15	112
2019	Moderate	18	0.14	95	0.75	14	0.11	127
2020	High	8	0.05	18	0.11	131	0.83	157
2020	Low	95	0.69	23	0.17	20	0.14	138
2020	Moderate	21	0.18	84	0.71	14	0.12	119
2021	High	18	0.11	19	0.12	121	0.77	158
2021	Low	93	0.67	17	0.12	28	0.20	138
2021	Moderate	23	0.19	91	0.75	8	0.07	122
2022	High	63	0.09	93	0.14	521	0.77	677
2022	Low	533	0.66	140	0.17	138	0.17	811
2022	Moderate	99	0.14	513	0.75	71	0.10	683

Matrix Region (Out of Region) Counts

This chunk shows the matrices for HQs and businesses not in the same Census region

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	56210	0.27	84003	0.41	65810	0.32	206023
Low	57639	0.28	84221	0.40	66706	0.32	208566
Moderate	44643	0.29	56071	0.36	55069	0.35	155783
OutsideRegion	23190	0.33	27212	0.38	20927	0.29	71329

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	11156	0.28	15632	0.40	12416	0.32	39204
2013	Low	5435	0.28	7816	0.40	6427	0.33	19678
2013	Moderate	6967	0.30	8097	0.35	8038	0.35	23102
2013	OutsideRegion	3307	0.33	3720	0.37	2914	0.29	9941
2014	High	5990	0.27	8900	0.41	7050	0.32	21940
2014	Low	4123	0.29	5580	0.40	4374	0.31	14077
2014	Moderate	4636	0.30	5561	0.36	5212	0.34	15409
2014	OutsideRegion	2396	0.32	3011	0.40	2119	0.28	7526
2015	High	6058	0.27	9063	0.41	7059	0.32	22180
2015	Low	3873	0.27	5642	0.39	4842	0.34	14357
2015	Moderate	4878	0.30	5513	0.34	5922	0.36	16313
2015	OutsideRegion	2835	0.32	3433	0.38	2720	0.30	8988
2016	High	4697	0.28	6694	0.40	5407	0.32	16798
2016	Low	3008	0.28	4334	0.40	3542	0.33	10884
2016	Moderate	4771	0.29	5559	0.34	5986	0.37	16316
2016	OutsideRegion	2369	0.35	2525	0.37	1870	0.28	6764
2017	High	4549	0.28	6627	0.41	5003	0.31	16179
2017	Low	3440	0.27	5227	0.41	4084	0.32	12751
2017	Moderate	2931	0.28	3720	0.36	3729	0.36	10380
2017	OutsideRegion	1925	0.32	2285	0.38	1793	0.30	6003
2018	High	4920	0.27	7246	0.40	5864	0.33	18030
2018	Low	2985	0.27	4503	0.41	3542	0.32	11030
2018	Moderate	3467	0.28	4447	0.36	4336	0.35	12250
2018	OutsideRegion	2218	0.32	2632	0.38	2007	0.29	6857
2019	High	5180	0.26	8258	0.42	6244	0.32	19682
2019	Low	3075	0.29	4233	0.40	3324	0.31	10632
2019	Moderate	3818	0.28	5107	0.37	4771	0.35	13696
2019	OutsideRegion	2159	0.32	2491	0.37	2025	0.30	6675
2020	High	5226	0.26	8525	0.43	6109	0.31	19860
2020	Low	14653	0.30	18368	0.38	15103	0.31	48124
2020	Moderate	3112	0.28	4329	0.38	3812	0.34	11253
2020	OutsideRegion	2165	0.31	2674	0.39	2104	0.30	6943
2021	High	2978	0.27	4445	0.40	3778	0.34	11201
2021	Low	1969	0.27	2894	0.40	2298	0.32	7161
2021	Moderate	2012	0.28	2898	0.40	2339	0.32	7249
2021	OutsideRegion	1550	0.30	1993	0.38	1667	0.32	5210
2022	High	5456	0.26	8613	0.41	6880	0.33	20949
2022	Low	15078	0.25	25624	0.43	19170	0.32	59872
2022	Moderate	8051	0.27	10840	0.36	10924	0.37	29815
2022	OutsideRegion	2266	0.35	2448	0.38	1708	0.27	6422

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	51011	0.28	75979	0.41	57656	0.31	184646
Low	30489	0.28	43347	0.40	35416	0.32	109252
Moderate	35068	0.29	42674	0.35	43434	0.36	121176
OutsideRegion	19588	0.32	23044	0.38	18369	0.30	61001

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2012	High	5710	0.30	7752	0.40	5718	0.30	19180
2012	Low	2392	0.28	3469	0.40	2780	0.32	8641
2012	Moderate	2542	0.28	3276	0.36	3395	0.37	9213
2012	OutsideRegion	1350	0.31	1608	0.37	1361	0.32	4319
2013	High	4111	0.27	6463	0.42	4774	0.31	15348
2013	Low	2494	0.27	3665	0.40	3100	0.33	9259
2013	Moderate	3192	0.29	3715	0.34	4121	0.37	11028
2013	OutsideRegion	1479	0.31	1777	0.38	1462	0.31	4718
2014	High	4495	0.27	6788	0.41	5100	0.31	16383
2014	Low	2640	0.28	3737	0.40	3078	0.33	9455
2014	Moderate	3736	0.29	4577	0.35	4671	0.36	12984
2014	OutsideRegion	1652	0.32	1998	0.39	1501	0.29	5151
2015	High	4215	0.26	6731	0.42	5101	0.32	16047
2015	Low	3146	0.28	4419	0.39	3648	0.33	11213
2015	Moderate	4118	0.29	5118	0.36	5132	0.36	14368
2015	OutsideRegion	1924	0.32	2279	0.38	1796	0.30	5999
2016	High	5935	0.28	8731	0.41	6879	0.32	21545
2016	Low	3794	0.29	5073	0.39	3998	0.31	12865
2016	Moderate	4541	0.30	5198	0.35	5207	0.35	14946
2016	OutsideRegion	2476	0.33	2870	0.38	2119	0.28	7465
2017	High	8574	0.28	12731	0.41	9499	0.31	30804
2017	Low	3818	0.27	5744	0.41	4592	0.32	14154
2017	Moderate	4614	0.29	5543	0.35	5833	0.36	15990
2017	OutsideRegion	2729	0.32	3221	0.38	2531	0.30	8481
2018	High	4468	0.27	6859	0.42	5042	0.31	16369
2018	Low	3167	0.29	4367	0.40	3447	0.31	10981
2018	Moderate	3607	0.29	4519	0.36	4514	0.36	12640
2018	OutsideRegion	3180	0.31	3834	0.37	3312	0.32	10326
2019	High	4874	0.28	6934	0.40	5474	0.32	17282
2019	Low	3200	0.28	4585	0.40	3755	0.33	11540
2019	Moderate	3612	0.29	4348	0.35	4291	0.35	12251
2019	OutsideRegion	1823	0.34	1979	0.37	1559	0.29	5361
2020	High	3653	0.27	5420	0.40	4517	0.33	13590
2020	Low	1869	0.28	2643	0.40	2146	0.32	6658
2020	Moderate	2316	0.30	2789	0.36	2660	0.34	7765
2020	OutsideRegion	1286	0.32	1529	0.39	1148	0.29	3963
2021	High	4976	0.27	7570	0.42	5552	0.31	18098
2021	Low	3969	0.27	5645	0.39	4872	0.34	14486
2021	Moderate	2790	0.28	3591	0.36	3610	0.36	9991
2021	OutsideRegion	1689	0.32	1949	0.37	1580	0.30	5218

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	2956	0.28	4368	0.41	3341	0.31	10665
Low	2777	0.30	3714	0.40	2758	0.30	9249
Moderate	2303	0.30	2727	0.35	2670	0.35	7700
OutsideRegion	952	0.32	1124	0.38	905	0.30	2981

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	594	0.26	962	0.43	704	0.31	2260
2013	Low	332	0.26	511	0.40	448	0.35	1291
2013	Moderate	477	0.30	532	0.33	584	0.37	1593
2013	OutsideRegion	120	0.25	191	0.39	174	0.36	485
2014	High	177	0.27	275	0.41	215	0.32	667
2014	Low	86	0.28	121	0.39	104	0.33	311
2014	Moderate	167	0.29	188	0.33	222	0.38	577
2014	OutsideRegion	52	0.34	59	0.38	43	0.28	154
2015	High	183	0.33	218	0.39	151	0.27	552
2015	Low	173	0.30	235	0.41	160	0.28	568
2015	Moderate	138	0.31	164	0.36	149	0.33	451
2015	OutsideRegion	68	0.39	65	0.37	42	0.24	175
2016	High	897	0.27	1359	0.40	1118	0.33	3374
2016	Low	535	0.29	700	0.38	584	0.32	1819
2016	Moderate	681	0.30	827	0.36	790	0.34	2298
2016	OutsideRegion	286	0.31	346	0.38	289	0.31	921
2017	High	207	0.29	303	0.43	200	0.28	710
2017	Low	138	0.32	185	0.42	114	0.26	437
2017	Moderate	139	0.29	171	0.36	166	0.35	476
2017	OutsideRegion	93	0.37	75	0.30	82	0.33	250
2018	High	143	0.27	222	0.42	165	0.31	530
2018	Low	97	0.29	130	0.38	113	0.33	340
2018	Moderate	154	0.31	170	0.35	165	0.34	489
2018	OutsideRegion	56	0.28	72	0.36	71	0.36	199
2019	High	108	0.31	133	0.39	103	0.30	344
2019	Low	54	0.28	83	0.43	54	0.28	191
2019	Moderate	79	0.33	77	0.32	82	0.34	238
2019	OutsideRegion	28	0.30	35	0.38	30	0.32	93
2020	High	99	0.27	155	0.43	107	0.30	361
2020	Low	60	0.24	103	0.42	84	0.34	247
2020	Moderate	58	0.29	74	0.37	66	0.33	198
2020	OutsideRegion	27	0.29	38	0.41	28	0.30	93
2021	High	103	0.31	133	0.40	96	0.29	332
2021	Low	117	0.30	132	0.34	142	0.36	391
2021	Moderate	60	0.35	67	0.39	46	0.27	173
2021	OutsideRegion	27	0.33	28	0.35	26	0.32	81
2022	High	445	0.29	608	0.40	482	0.31	1535
2022	Low	1185	0.32	1514	0.41	955	0.26	3654
2022	Moderate	350	0.29	457	0.38	400	0.33	1207
2022	OutsideRegion	195	0.37	215	0.41	120	0.23	530

## Rows: 4 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	2956	0.28	4368	0.41	3341	0.31	10665
Low	2777	0.30	3714	0.40	2758	0.30	9249
Moderate	2303	0.30	2727	0.35	2670	0.35	7700
OutsideRegion	952	0.32	1124	0.38	905	0.30	2981

## Rows: 40 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+ yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	594	0.26	962	0.43	704	0.31	2260
2013	Low	332	0.26	511	0.40	448	0.35	1291
2013	Moderate	477	0.30	532	0.33	584	0.37	1593
2013	OutsideRegion	120	0.25	191	0.39	174	0.36	485
2014	High	177	0.27	275	0.41	215	0.32	667
2014	Low	86	0.28	121	0.39	104	0.33	311
2014	Moderate	167	0.29	188	0.33	222	0.38	577
2014	OutsideRegion	52	0.34	59	0.38	43	0.28	154
2015	High	183	0.33	218	0.39	151	0.27	552
2015	Low	173	0.30	235	0.41	160	0.28	568
2015	Moderate	138	0.31	164	0.36	149	0.33	451
2015	OutsideRegion	68	0.39	65	0.37	42	0.24	175
2016	High	897	0.27	1359	0.40	1118	0.33	3374
2016	Low	535	0.29	700	0.38	584	0.32	1819
2016	Moderate	681	0.30	827	0.36	790	0.34	2298
2016	OutsideRegion	286	0.31	346	0.38	289	0.31	921
2017	High	207	0.29	303	0.43	200	0.28	710
2017	Low	138	0.32	185	0.42	114	0.26	437
2017	Moderate	139	0.29	171	0.36	166	0.35	476
2017	OutsideRegion	93	0.37	75	0.30	82	0.33	250
2018	High	143	0.27	222	0.42	165	0.31	530
2018	Low	97	0.29	130	0.38	113	0.33	340
2018	Moderate	154	0.31	170	0.35	165	0.34	489
2018	OutsideRegion	56	0.28	72	0.36	71	0.36	199
2019	High	108	0.31	133	0.39	103	0.30	344
2019	Low	54	0.28	83	0.43	54	0.28	191
2019	Moderate	79	0.33	77	0.32	82	0.34	238
2019	OutsideRegion	28	0.30	35	0.38	30	0.32	93
2020	High	99	0.27	155	0.43	107	0.30	361
2020	Low	60	0.24	103	0.42	84	0.34	247
2020	Moderate	58	0.29	74	0.37	66	0.33	198
2020	OutsideRegion	27	0.29	38	0.41	28	0.30	93
2021	High	103	0.31	133	0.40	96	0.29	332
2021	Low	117	0.30	132	0.34	142	0.36	391
2021	Moderate	60	0.35	67	0.39	46	0.27	173
2021	OutsideRegion	27	0.33	28	0.35	26	0.32	81
2022	High	445	0.29	608	0.40	482	0.31	1535
2022	Low	1185	0.32	1514	0.41	955	0.26	3654
2022	Moderate	350	0.29	457	0.38	400	0.33	1207
2022	OutsideRegion	195	0.37	215	0.41	120	0.23	530

Matrix Region (Out of Region) Counts Top 100 only

This chunk shows the matrices for HQs and businesses not in the same Census region, if both are in the top 100 CBSAs by population

# All births
process_data("matrix_births_all_dif_region_top100only.csv", "Births, rows (hq), columns (branch)")

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	56210	0.27	84003	0.41	65810	0.32	206023
Low	57639	0.28	84221	0.40	66706	0.32	208566
Moderate	44643	0.29	56071	0.36	55069	0.35	155783

# Yearly births
process_data("matrix_births_yearly_dif_region_top100only.csv", "Births yearly, rows (hq), columns (branch)", TRUE)

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Births yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	11156	0.28	15632	0.40	12416	0.32	39204
2013	Low	5435	0.28	7816	0.40	6427	0.33	19678
2013	Moderate	6967	0.30	8097	0.35	8038	0.35	23102
2014	High	5990	0.27	8900	0.41	7050	0.32	21940
2014	Low	4123	0.29	5580	0.40	4374	0.31	14077
2014	Moderate	4636	0.30	5561	0.36	5212	0.34	15409
2015	High	6058	0.27	9063	0.41	7059	0.32	22180
2015	Low	3873	0.27	5642	0.39	4842	0.34	14357
2015	Moderate	4878	0.30	5513	0.34	5922	0.36	16313
2016	High	4697	0.28	6694	0.40	5407	0.32	16798
2016	Low	3008	0.28	4334	0.40	3542	0.33	10884
2016	Moderate	4771	0.29	5559	0.34	5986	0.37	16316
2017	High	4549	0.28	6627	0.41	5003	0.31	16179
2017	Low	3440	0.27	5227	0.41	4084	0.32	12751
2017	Moderate	2931	0.28	3720	0.36	3729	0.36	10380
2018	High	4920	0.27	7246	0.40	5864	0.33	18030
2018	Low	2985	0.27	4503	0.41	3542	0.32	11030
2018	Moderate	3467	0.28	4447	0.36	4336	0.35	12250
2019	High	5180	0.26	8258	0.42	6244	0.32	19682
2019	Low	3075	0.29	4233	0.40	3324	0.31	10632
2019	Moderate	3818	0.28	5107	0.37	4771	0.35	13696
2020	High	5226	0.26	8525	0.43	6109	0.31	19860
2020	Low	14653	0.30	18368	0.38	15103	0.31	48124
2020	Moderate	3112	0.28	4329	0.38	3812	0.34	11253
2021	High	2978	0.27	4445	0.40	3778	0.34	11201
2021	Low	1969	0.27	2894	0.40	2298	0.32	7161
2021	Moderate	2012	0.28	2898	0.40	2339	0.32	7249
2022	High	5456	0.26	8613	0.41	6880	0.33	20949
2022	Low	15078	0.25	25624	0.43	19170	0.32	59872
2022	Moderate	8051	0.27	10840	0.36	10924	0.37	29815

# All deaths
process_data("matrix_deaths_all_dif_region_top100only.csv", "Deaths, rows (hq), columns (branch)")

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	51011	0.28	75979	0.41	57656	0.31	184646
Low	30489	0.28	43347	0.40	35416	0.32	109252
Moderate	35068	0.29	42674	0.35	43434	0.36	121176

# Yearly deaths
process_data("matrix_deaths_yearly_dif_region_top100only.csv", "Deaths yearly, rows (hq), columns (branch)", TRUE)

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Deaths yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2012	High	5710	0.30	7752	0.40	5718	0.30	19180
2012	Low	2392	0.28	3469	0.40	2780	0.32	8641
2012	Moderate	2542	0.28	3276	0.36	3395	0.37	9213
2013	High	4111	0.27	6463	0.42	4774	0.31	15348
2013	Low	2494	0.27	3665	0.40	3100	0.33	9259
2013	Moderate	3192	0.29	3715	0.34	4121	0.37	11028
2014	High	4495	0.27	6788	0.41	5100	0.31	16383
2014	Low	2640	0.28	3737	0.40	3078	0.33	9455
2014	Moderate	3736	0.29	4577	0.35	4671	0.36	12984
2015	High	4215	0.26	6731	0.42	5101	0.32	16047
2015	Low	3146	0.28	4419	0.39	3648	0.33	11213
2015	Moderate	4118	0.29	5118	0.36	5132	0.36	14368
2016	High	5935	0.28	8731	0.41	6879	0.32	21545
2016	Low	3794	0.29	5073	0.39	3998	0.31	12865
2016	Moderate	4541	0.30	5198	0.35	5207	0.35	14946
2017	High	8574	0.28	12731	0.41	9499	0.31	30804
2017	Low	3818	0.27	5744	0.41	4592	0.32	14154
2017	Moderate	4614	0.29	5543	0.35	5833	0.36	15990
2018	High	4468	0.27	6859	0.42	5042	0.31	16369
2018	Low	3167	0.29	4367	0.40	3447	0.31	10981
2018	Moderate	3607	0.29	4519	0.36	4514	0.36	12640
2019	High	4874	0.28	6934	0.40	5474	0.32	17282
2019	Low	3200	0.28	4585	0.40	3755	0.33	11540
2019	Moderate	3612	0.29	4348	0.35	4291	0.35	12251
2020	High	3653	0.27	5420	0.40	4517	0.33	13590
2020	Low	1869	0.28	2643	0.40	2146	0.32	6658
2020	Moderate	2316	0.30	2789	0.36	2660	0.34	7765
2021	High	4976	0.27	7570	0.42	5552	0.31	18098
2021	Low	3969	0.27	5645	0.39	4872	0.34	14486
2021	Moderate	2790	0.28	3591	0.36	3610	0.36	9991

# All expansions
process_data("matrix_expansion_all_dif_region_top100only.csv", "Expansions, rows (hq), columns (branch)")

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	2956	0.28	4368	0.41	3341	0.31	10665
Low	2777	0.30	3714	0.40	2758	0.30	9249
Moderate	2303	0.30	2727	0.35	2670	0.35	7700

# Yearly expansions
process_data("matrix_expansion_yearly_dif_region_top100only.csv", "Expansions yearly, rows (hq), columns (branch)", TRUE)

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	594	0.26	962	0.43	704	0.31	2260
2013	Low	332	0.26	511	0.40	448	0.35	1291
2013	Moderate	477	0.30	532	0.33	584	0.37	1593
2014	High	177	0.27	275	0.41	215	0.32	667
2014	Low	86	0.28	121	0.39	104	0.33	311
2014	Moderate	167	0.29	188	0.33	222	0.38	577
2015	High	183	0.33	218	0.39	151	0.27	552
2015	Low	173	0.30	235	0.41	160	0.28	568
2015	Moderate	138	0.31	164	0.36	149	0.33	451
2016	High	897	0.27	1359	0.40	1118	0.33	3374
2016	Low	535	0.29	700	0.38	584	0.32	1819
2016	Moderate	681	0.30	827	0.36	790	0.34	2298
2017	High	207	0.29	303	0.43	200	0.28	710
2017	Low	138	0.32	185	0.42	114	0.26	437
2017	Moderate	139	0.29	171	0.36	166	0.35	476
2018	High	143	0.27	222	0.42	165	0.31	530
2018	Low	97	0.29	130	0.38	113	0.33	340
2018	Moderate	154	0.31	170	0.35	165	0.34	489
2019	High	108	0.31	133	0.39	103	0.30	344
2019	Low	54	0.28	83	0.43	54	0.28	191
2019	Moderate	79	0.33	77	0.32	82	0.34	238
2020	High	99	0.27	155	0.43	107	0.30	361
2020	Low	60	0.24	103	0.42	84	0.34	247
2020	Moderate	58	0.29	74	0.37	66	0.33	198
2021	High	103	0.31	133	0.40	96	0.29	332
2021	Low	117	0.30	132	0.34	142	0.36	391
2021	Moderate	60	0.35	67	0.39	46	0.27	173
2022	High	445	0.29	608	0.40	482	0.31	1535
2022	Low	1185	0.32	1514	0.41	955	0.26	3654
2022	Moderate	350	0.29	457	0.38	400	0.33	1207

# All expansions (10+)
process_data_no_outside("matrix_expansion_10_all_dif_region_top100only.csv", "Expansions 10+, rows (hq), columns (branch)")

## Rows: 3 Columns: 4
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (3): Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+, rows (hq), columns (branch)

avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
High	2956	0.28	4368	0.41	3341	0.31	10665
Low	2777	0.30	3714	0.40	2758	0.30	9249
Moderate	2303	0.30	2727	0.35	2670	0.35	7700

# Yearly expansions (10+)
process_data_no_outside("matrix_expansion_10_yearly_dif_region_top100only.csv", "Expansions 10+ yearly, rows (hq), columns (branch)", TRUE)

## Rows: 30 Columns: 5
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): avg_eal_tercile_parent
## dbl (4): archive_version_year, Low, Moderate, High
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Expansions 10+ yearly, rows (hq), columns (branch)

year	avg_eal_tercile_parent	Low	Low_pct	Moderate	Moderate_pct	High	High_pct	Total
2013	High	594	0.26	962	0.43	704	0.31	2260
2013	Low	332	0.26	511	0.40	448	0.35	1291
2013	Moderate	477	0.30	532	0.33	584	0.37	1593
2014	High	177	0.27	275	0.41	215	0.32	667
2014	Low	86	0.28	121	0.39	104	0.33	311
2014	Moderate	167	0.29	188	0.33	222	0.38	577
2015	High	183	0.33	218	0.39	151	0.27	552
2015	Low	173	0.30	235	0.41	160	0.28	568
2015	Moderate	138	0.31	164	0.36	149	0.33	451
2016	High	897	0.27	1359	0.40	1118	0.33	3374
2016	Low	535	0.29	700	0.38	584	0.32	1819
2016	Moderate	681	0.30	827	0.36	790	0.34	2298
2017	High	207	0.29	303	0.43	200	0.28	710
2017	Low	138	0.32	185	0.42	114	0.26	437
2017	Moderate	139	0.29	171	0.36	166	0.35	476
2018	High	143	0.27	222	0.42	165	0.31	530
2018	Low	97	0.29	130	0.38	113	0.33	340
2018	Moderate	154	0.31	170	0.35	165	0.34	489
2019	High	108	0.31	133	0.39	103	0.30	344
2019	Low	54	0.28	83	0.43	54	0.28	191
2019	Moderate	79	0.33	77	0.32	82	0.34	238
2020	High	99	0.27	155	0.43	107	0.30	361
2020	Low	60	0.24	103	0.42	84	0.34	247
2020	Moderate	58	0.29	74	0.37	66	0.33	198
2021	High	103	0.31	133	0.40	96	0.29	332
2021	Low	117	0.30	132	0.34	142	0.36	391
2021	Moderate	60	0.35	67	0.39	46	0.27	173
2022	High	445	0.29	608	0.40	482	0.31	1535
2022	Low	1185	0.32	1514	0.41	955	0.26	3654
2022	Moderate	350	0.29	457	0.38	400	0.33	1207