Opnames Delta

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	Y	Z	AA	AC
1	agegroup	number_in_group	sanquin_factor	rivm_cases	Sanquin_cases									zero_protection_sanquin	zero_protection_rivm	90p_protection	90p_suseptible	vacc_coverage	currecntly_protected	currently_suseptible	chance_hospitalisation	vacc_reduc_chance
2	0-9	1757453	26	60488	456938												1757453	0	0	1757453		0.02
3	10-19	1986013	26	232833	516363									0	0	0	1986013	0	0	1986013		0.02
4	20-29	2240428	26	302950	582511									0	0	0	2240428	10	0	2240428		0.02
5	30-39	2180575	17	238348	370698									0	0	0	2180575	10	0	2180575		0.02
6	40-49	2166062	21	250221	454873									0	0	0	2166062	20	0	2166062		0.02
7	50-59	2549688	15	282238	382453									0	0	0	2549688	40	0	2549688		0.02
8	60-69	2141439	14	160222	299801									0	0	0	2141439	80	0	2141439		0.02
9	70-79	1615096	9	92747	145359									0	0	0	1615096	85	0	1615096		0.02
10	80-89	706932	9	54755	63624									0	0	0	706932	85	0	706932		0.02
11	90+	131729	9	18032	11856									0	0	0	131729	90	0	131729		0.02
12														0	0	0
13
14	agegroup	Kans RIVM	Kans Sanquin
15	20-	0.45%	0.14%																	agegroup	dashboard_pred
16	20-29	0.39%	0.20%								agegroup	Geen immuniteit								20-	505
17	30-39	1.00%	0.64%								20-	5,054								20-29	448
18	40-49	1.78%	0.98%								20-29	4,488								30-39	1,396
19	50-59	3.52%	2.59%								30-39	14,053								40-49	1,365
20	60-69	7.12%	3.80%								40-49	21,200								50-59	3,222
21	70-79	16.09%	10.27%								50-59	66,153								60-69	2,351
22	80-89	19.68%	16.94%								60-69	81,457								70-79	2,976
23	90+	10.13%	10.13%								70-79	165,833								80-89	1,989
24											80-89	119,744								90+	240
25	tot	3.44%	1.77%								90+	13,339
26
27
28
29
30
31
32
33
34	agegroup	number_in_agegroup	rivm_cases	rivm_infected_per_group	hospitalized	rivm_chance	Zero_protect		agegroup	number_in_agegroup	Zero_protect
35	20-	3743466	293321	7.84%	1314	0.45%	16,770		20-	3743466	16,770
36	20-29	2240428	302950	13.52%	1167	0.39%	8,630		20-29	2240428	8,630
37	30-39	2180575	238348	10.93%	2389	1.00%	21,856		30-39	2180575	21,856
38	40-49	2166062	250221	11.55%	4452	1.78%	38,539		40-49	2166062	38,539
39	50-59	2549688	282238	11.07%	9923	3.52%	89,643		50-59	2549688	89,643
40	60-69	2141439	160222	7.48%	11404	7.12%	152,420		60-69	2141439	152,420
41	70-79	1615096	92747	5.74%	14925	16.09%	259,904		70-79	1615096	259,904
42	80-89	706932	54755	7.75%	10777	19.68%	139,140		80-89	706932	139,140
43	90+	131729	18032	13.69%	1826	10.13%	13,339		90+	131729	13,339
44					58177		740,241
45
46	agegroup	number_in_agegroup	sanquin_factor	sanq_cases	hospitalized	sanq_chance	Zero_protect		agegroup	number_in_agegroup	Zero_protect		RIVM	protected	not_protected	dashboard_pred	protected_hosp	93p_prot	total		agegroup	gevaccineerd	onbeschermd	agegroup	Sanquin kans op opname	Israel data Kans na vaccinatie
47	20-	3743466	26	973301	1314	0.14%	5,054		20-	3,738,412	5,054		90	3,364,571	373,841	505	4,542	318	823		20-	318	505	20-	0.14%	0.01%	10582
48	20-29	2240428	26	582511	1167	0.20%	4,488		20-29	2,235,940	4,488		90	2,012,346	223,594	448	4,032	282	730		20-29	282	448	20-29	0.20%	0.01%	7131
49	30-39	2180575	17	370698	2389	0.64%	14,053		30-39	2,166,522	14,053		90	1,949,870	216,652	1,396	12,566	880	2,276		30-39	880	1396	30-39	0.64%	0.05%	2217
50	40-49	2166062	21	454873	4452	0.98%	21,200		40-49	2,144,862	21,200		93.5	2,005,446	139,416	1,365	19,628	1374	2,738		40-49	1374	1365	40-49	0.98%	0.07%	1460
51	50-59	2549688	15	382453	9923	2.59%	66,153		50-59	2,483,535	66,153		95	2,359,358	124,177	3,222	61,215	4285	7,507		50-59	4285	3222	50-59	2.59%	0.18%	551
52	60-69	2141439	14	299801	11404	3.80%	81,457		60-69	2,059,982	81,457		97	1,998,182	61,799	2,351	76,008	5321	7,671		60-69	5321	2351	60-69	3.80%	0.27%	376
53	70-79	1615096	9	145359	14925	10.27%	165,833		70-79	1,449,263	165,833		98	1,420,277	28,985	2,976	145,830	10208	13,184		70-79	10208	2976	70-79	10.27%	0.72%	139
54	80-89	706932	9	63624	10777	16.94%	119,744		80-89	587,188	119,744		98	575,444	11,744	1,989	97,472	6823	8,812		80-89	6823	1989	80-89	16.94%	1.19%	84
55	90+	131729	9	18032	1826	10.13%	13,339		90+	118,390	13,339		98	116,022	2,368	240	11,749	822	1,062		90+	822	240	90+	10.13%	0.71%	141
56							491,323									14,491	433,042	30,313	44,804
57
58	agegroup	Voor vaccinatie	Na vaccinatie
59	20-	741	10,582
60	20-29	499	7,131
61	30-39	155	2,217
62	40-49	102	1,460
63	50-59	39	551
64	60-69	26	376
65	70-79	10	139
66	80-89	6	84
67	90+	10	141
68
69
70
71
72
73
74
75
76
77	agegroup	sanq_chance	Besmettingen gisteren	verwachtte opnames	2x verdubbelen	verwachtte opnames		90			122
78	20-	0.14%	2,560	3.46	10,240	13.8		2688	2778		2438	2560
79	20-29	0.20%	4,984	9.98	19,936	39.9		5863	5863		4984	4984
80	30-39	0.64%	803	5.18	3,212	20.7		825	825		803	803
81	40-49	0.98%	401	3.92	1,604	15.7		351	351		401	401
82	50-59	2.59%	417	10.82	1,668	43.3		333	333		417	417
83	60-69	3.80%	103	3.92	412	15.7		98	98		103	103
84	70-79	10.27%	32	3.29	128	13.1		23	23		32	32
85	80-89	16.94%	15	2.54	60	10.2		12	12		15	15
86	90+	10.13%	3	0.30	12	1.2		0	0		3	3
87			9,318	43.41	37,272	173.6
88
89
90	agegroup	sanq_chance	Besmettingen afgelopen week	hospital.expect
91	20-	0.14%	2711	3.66
92	20-29	0.20%	3485	6.98
93	30-39	0.64%	936	6.03
94	40-49	0.98%	563	5.51
95	50-59	2.59%	528	13.70
96	60-69	3.80%	162	6.16
97	70-79	10.27%	45	4.62
98	80-89	16.94%	26	4.40
99	90+	10.13%	12	1.22
100			8468	52.29