Dental-claims-children-by-county-2023_v2.xlsx

	B	C	D	E	F	G	H
1	Dental claims for fillings in children (17 years or younger), calendar 2023, by county*
2	Ranked in order of counties who had the least number of fillings per child
3	County	Total dental claims	Count of distinct persons with at least one dental claim	Count of distinct teeth filled	Count of distinct persons receiving fillings	Population estimate (aged 0-17)	Avg number of teeth filled per person (column E divided by column G)
4	Morgan	2719	1118	572	245	4,072	0.1404715128
5	Wasatch	8271	3438	1660	653	10,491	0.1582308646
6	Summit	7404	3333	1479	588	9,256	0.1597882455
7	Daggett	69	34	37	11	205	0.1804878049
8	Davis	82029	34065	20539	7701	110,208	0.1863657811
9	Box Elder	11130	4566	3547	1247	18,077	0.19621619
10	Cache	28073	11971	8030	3077	39,314	0.2042529379
11	Kane	1094	505	407	127	1,915	0.2125326371
12	Salt Lake	216785	93496	65407	22241	298,904	0.2188227658
13	San Juan	3242	1433	925	315	4,014	0.2304434479
14	Utah	158132	68293	53536	17953	222,554	0.2405528546
15	Washington	33163	14304	11107	3561	46,115	0.2408543858
16	Tooele	17258	7228	5761	1882	23,747	0.2425990651
17	Grand	1443	679	536	161	2,009	0.2667994027
18	Weber	51978	21608	18827	6177	69,890	0.269380455
19	Duchesne	4315	1862	1770	547	6,319	0.280107612
20	Rich	531	253	210	81	745	0.2818791946
21	Beaver	1149	530	612	201	2,092	0.292543021
22	Juab	2808	1245	1223	426	4,158	0.2941317941
23	Iron	10771	5012	5388	1671	17,459	0.3086087405
24	Uintah	8434	3452	3611	1045	11,059	0.3265213853
25	Emery	1963	937	945	304	2,703	0.3496115427
26	Wayne	456	198	203	77	579	0.3506044905
27	Carbon	3353	1489	1942	529	5,204	0.3731744812
28	Millard	2895	1203	1715	496	4,012	0.4274675972
29	Sanpete	7196	3029	3093	1013	7,226	0.4280376418
30	Sevier	5336	2178	2640	827	5,952	0.4435483871
31	Garfield	1064	450	662	190	1,128	0.5868794326
32	Piute	293	126	200	57	324	0.6172839506
33	TOTAL for Utah	673354	288035	216584	73403	929,731
34
35	* Data source: Milliman 16 version of the APCD; CDT procedure codes: D2300 through D2999 were used to identify tooth fillings.
36	* Population estimates taken from https://ibis.utah.gov/ibisph-view/query/builder/pop/PopKemG/Count.html
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100