8-SCBOCC Experience Report Monitoring and HCC Florida Blue Medical 202309.xlsx

XLSX spreadsheet 131 KB Posted

Attached to
Group Medical Benefits
Solicitation number
2026-10
Issued by
Seminole County, Florida

About this file

Suwannee County Board of County Commissioners Group Medical Benefits Experience Report

This file is a Florida Blue medical experience report for the Suwannee County Board of County Commissioners (BOCC) group health insurance plan covering the 12-month period from October 2022 through September 2023. The report documents enrollment, premium payments, claims, utilization patterns, and medical loss ratios (MLR) for approximately 407 employee contracts covering 451 total members across multiple internal divisions. The plan is administered through Florida Blue as the health insurance carrier, with detailed breakdowns by division, monthly performance metrics, high-cost claims analysis, pharmacy utilization, and top diagnoses by inpatient, outpatient, and professional service categories. Key utilization metrics tracked include inpatient admissions and days, outpatient visits and emergency room usage, professional services, and pharmacy prescriptions. The report encompasses monitoring data by utilization and enrollment, division-level performance, key financial indicators, brand versus generic pharmacy utilization, high-cost claim summaries, and top provider type performance comparisons against the prior 12-month period.

The overall medical loss ratio for the plan year totaled 75.44%, with annual payments of $2,784,125.01 across all categories including inpatient facility ($647,098.77), outpatient facility ($826,022.04), professional services ($547,044.19), pharmacy ($733,354.54), and value-based programs ($11,513.64). Per member per year payments increased 6.74% from the prior year to $6,176.64, while per employee per year payments rose 5.39% to $6,846.12. Facility costs increased significantly by 28.39% year-over-year, while professional service costs declined 37.33%. Pharmacy costs increased 44.86%, driven by higher per-script costs ($130.18 compared to $90.25 prior year) and increased maintenance medication utilization. Generic medication penetration remained strong at 86.99% with 99.25% generic substitution rates. Enrollment remained relatively stable with a 3.43% increase in employees to 407 and 2.13% increase in members to 451. The report identifies top diagnoses and high-cost claimants, with sepsis, osteoarthritis, cardiac conditions, and genitourinary issues among the most prevalent conditions driving medical utilization and costs.

View the file

Other files

File Type Posted
24-0.3 Guarantee Ltr of Commit Guarantee From.pdf PDF
29-1.1 Summary Form.pdf PDF
22-0.1 Information Instructions.pdf PDF
9-SCBOCC Monitoring Report FB DEC 2025 (1).xlsx XLSX spreadsheet
30-0.2 Scope of Work.pdf PDF
4-SCBOCC Claims MARCH 2026.xlsx XLSX spreadsheet
20-Participants.xlsx XLSX spreadsheet
16-Suwannee Cert P03160 10-1-25.pdf PDF
17-SCBOCC SBC PLAN 03559 Florida Blue Medical 20251001.pdf PDF
21-0.0 Advertisement.jpg JPG image
6-SCBOCC Experience Report Monitoring and HCC Florida Blue Medical 202312.xlsx XLSX spreadsheet
10-SCBOCC SBC PLAN 60 Florida Blue Medical 20251001.pdf PDF
14-Suwannee Cert P60 10-1-25.pdf PDF
12-SCBOCC Experience Report HCC Florida Blue Medical 202312.xlsx XLSX spreadsheet
13-SCBOCC SBC PLAN 03160 Florida Blue Medical 20251001.pdf PDF
1-Suwannee County Medical Census 3.19.2026.xlsx XLSX spreadsheet
2-SCBOCC Experience Report Florida Blue Medical 202403.xlsx XLSX spreadsheet
25-1.4 Scope of Services Table.pdf PDF
28-1.3 Questionnaire.pdf PDF
18-SCBOCC SBC PLAN 03161 Florida Blue Medical 20251001.pdf PDF
19-Suwannee Renewal Negotiated Florida Blue Medical Final 20251001 (1).pdf PDF
23-0.4 Standard Contract Terms.pdf PDF
5-SCBOCC ExpRpt FMR BCBSFL Medical 2025.12 (1).pdf PDF
7-SCBOCC Experience Report Florida Blue Medical 202409.xlsx XLSX spreadsheet
3-Suwannee Cert P03559 10-1-25.pdf PDF
11-SCBOCC Monitoring Report Report July 2025.xlsx XLSX spreadsheet
26-1.5 Financial Response Forms.pdf PDF
15-Suwannee Cert P03161 10-1-25.pdf PDF
27-1.2 Required Forms.pdf PDF
Show all 29

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

S1 Monitoring by Utiliza Page1

Monitoring by Utilization and Enrollment - PAID
Company: SUWANNEE COUNTY BOCC TAX

Group: 15534 Current Paid Period: From 10/2022 to 09/2023

EnrollmentPremiumCapitationFee for Service Claims
Paid Year MonthContractsMembersPremiumPCPSpecialtyTotal CapitationValue Based
ProgramsInpatientOutpatientPhysicianOtherTotal MedicalPharmacyGrand TotalMLR
202210396447$302,155.24$0.00$1,503.48$1,503.48$2,900.31$281,436.90$87,822.94$29,997.17$22,821.27$422,078.28$38,094.07$464,576.14153.75%
202211407458$303,924.60$0.00$1,515.06$1,515.06$712.50$49,479.86$57,005.14$34,553.19$16,888.13$157,926.32$69,323.69$229,477.5775.50%
202212408454$316,065.24$0.00$1,598.74$1,598.74$715.50$30,483.09$62,264.75$29,373.03$25,252.07$147,372.94$52,037.18$201,724.3663.82%
202301409452$311,868.76$0.00$1,578.82$1,578.82$720.27$0.00$51,161.90$17,244.52$16,783.60$85,190.02$37,399.52$124,888.6340.05%
202302408451$307,656.98$0.00$1,574.47$1,574.47$720.27$0.00$78,021.26$19,371.60$13,760.25$111,153.11$50,188.65$163,636.5053.19%
202303405448$302,350.30$0.00$1,566.82$1,566.82$702.27$46,120.91$70,944.87$30,725.76$23,376.77$171,168.31$68,211.94$241,649.3479.92%
202304404447$301,164.35$0.00$1,573.75$1,573.75$781.47$8,300.47$182,444.01$32,615.82$21,360.72$244,721.02$41,474.48$288,550.7295.81%
202305406448$313,832.90$0.00$1,626.48$1,626.48$789.48$41,750.60$101,206.29$37,914.96$21,432.91$202,304.76$77,930.94$282,651.6690.06%
202306408449$307,694.62$0.00$1,670.06$1,670.06$849.60$0.00$39,089.98$24,749.18$14,252.09$78,091.25$64,729.82$145,340.7347.24%
202307407449$308,686.05$0.00$1,623.21$1,623.21$844.80$97,249.09$1,136.26$19,599.80$17,069.97$135,055.12$62,234.44$199,757.5764.71%
202308412454$304,641.55$0.00$1,639.93$1,639.93$864.00$39,457.73$33,917.48$21,104.08$16,082.23$110,561.52$109,823.60$222,889.0573.16%
202309410452$310,634.03$0.00$1,621.01$1,621.01$913.17$52,820.12$61,007.16$22,150.02$18,565.05$154,542.35$61,906.21$218,982.7470.50%
Total4,8805,409$3,690,674.62$0.00$19,091.83$19,091.83$11,513.64$647,098.77$826,022.04$319,399.13$227,645.06$2,020,165.00$733,354.54$2,784,125.0175.44%
Grouping Avg407451$307,556.22$0.00$1,590.99$1,590.99$959.47$53,924.90$68,835.17$26,616.59$18,970.42$168,347.08$61,112.88$232,010.4275.44%
Monthly Avg407451$307,556.22$0.00$1,590.99$1,590.99$959.47$53,924.90$68,835.17$26,616.59$18,970.42$168,347.08$61,112.88$232,010.4275.44%

Notes:

- Grand Total includes Medical FFS, Pharmacy FFS, Incentives and Capitation.

- Grouping Avg – Average of the distinct groupings chosen by the user.

- Monthly Avg – Average of a measure over Service/Paid time period.

- Enrollment is recast to reflect retroactive adjustments.

- FFS = Fee For Service.

- MLR = Medical Loss Ratio.

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 10/13/2023 2:44 PM Page 1 of 2

S2 Monitoring by Utiliza Page2

Monitoring by Utilization and Enrollment - PAID
Paid Year MonthEmployee
OnlyEmployee &
SpouseEmployee &
ChildrenFamilySpouse OnlySpouse &
ChildrenChildren OnlyTotal
ContractsTotal

Members

20221036812133000396447
20221137912133000407458
20221238211123000408454
20230138411122000409452
20230238311122000408451
20230338011122000405448
20230437911122000404447
20230538211103000406448
20230638510103000408449
20230738311103000407449
20230838811103000412454
20230938611103000410452
Total4,579133136320004,8805,409
Grouping Avg38211113000407451
Monthly Avg38211113000407451
Notes:

- Enrollment is recast to reflect retroactive adjustments.

- Grouping Avg – Average of the distinct groupings chosen by the user.

- Monthly Avg – Average of a measure over Service/Paid time period.

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 10/13/2023 2:44 PM Page 2 of 2

S3 High Cost Claims Summ Page1

High Cost Claims Summary - Rolling 12
Company: SUWANNEE COUNTY BOCC TAX

Group: 15534 Current Paid Period: From 10/2022 to 09/2023 Prior Paid Period: From 10/2021 to 09/2022 High Cost Claims Threshold: 50000

CURRENTInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1008SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; ALCOHOL INDUCED ACUTE PANCREATITIS WITHOUT NECROSIS OR INFECTION; PNEUMONIA, UNSPECIFIED ORGANISM592$282,436.9010$3,435.5459$7,085.1919$382.370$0.00$293,340.00$109,444.01
2011SUBSCRIBEROTHER SPECIFIED NONINFLAMMATORY DISORDERS OF VAGINA; PHARMACY RX; CALCULUS OF KIDNEY11$32,177.0019$31,980.84137$23,845.0585$28,221.880$0.00$116,224.77$665,930.86
3010SUBSCRIBERENCOUNTER FOR ANTINEOPLASTIC RADIATION THERAPY; ENCOUNTER FOR ANTINEOPLASTIC CHEMOTHERAPY; DYSPHONIA00$0.0049$94,950.1561$12,908.6023$137.080$0.00$107,995.83$285,283.30
4R08SUBSCRIBERUNILATERAL PRIMARY OSTEOARTHRITIS, RIGHT KNEE; UNILATERAL PRIMARY OSTEOARTHRITIS, LEFT KNEE; POLYP OF COLON00$0.0013$91,071.8474$14,933.6518$36.630$0.00$106,042.12$235,714.20
5012SUBSCRIBERPHARMACY RX; TYPE 2 DIABETES MELLITUS WITHOUT COMPLICATIONS; OTHER SPECIFIED DISORDERS OF TEETH AND SUPPORTING STRUCTURES00$0.001$640.8919$1,708.3140$91,491.350$0.00$93,840.55$130,974.17
6012SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; IRON DEFICIENCY ANEMIA, UNSPECIFIED; MALIGNANT NEOPLASM OF UPPER-INNER QUADRANT OF LEFT FEMALE BREAST63$60,746.760$0.00128$13,014.389$274.600$0.00$74,035.74$358,174.62
7011SUBSCRIBEROTHER SPONDYLOSIS WITH RADICULOPATHY, LUMBAR REGION; BENIGN PAROXYSMAL VERTIGO, UNSPECIFIED EAR; HYPERTENSIVE EMERGENCY52$16,883.824$27,805.0073$12,194.8835$8,095.880$0.00$64,979.58$236,957.83
8002SUBSCRIBERCALCULUS OF KIDNEY; ABRASION OF RIGHT INDEX FINGER, INITIAL ENCOUNTER; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON00$0.007$57,375.7627$6,154.8117$169.160$0.00$63,699.73$358,543.22
9007SUBSCRIBERPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; OBSTRUCTIVE SLEEP APNEA (ADULT) (PEDIATRIC)00$0.000$0.0020$1,227.08114$53,867.320$0.00$55,094.40$98,522.55
10012SPOUSEPHARMACY RX; OTHER RHEUMATOID ARTHRITIS WITH RHEUMATOID FACTOR OF MULTIPLE SITES; CONTACT WITH AND (SUSPECTED) EXPOSURE TO COVID-1900$0.000$0.009$557.4236$53,687.080$0.00$54,244.50$72,551.84
11011SUBSCRIBERATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSTABLE ANGINA PECTORIS; OCCLUSION AND STENOSIS OF BILATERAL CAROTID ARTERIES; ATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSPECIFIED ANGINA PECTORIS00$0.001$51,523.0914$1,363.8012$0.000$0.00$52,886.89$651,021.00
Total718$392,244.48104$358,783.11621$94,993.17408$236,363.350$0.00$1,082,384.11$3,203,117.60
PRIORInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1023SUBSCRIBERMALIGNANT NEOPLASM OF UPPER-OUTER QUADRANT OF LEFT FEMALE BREAST; ENCOUNTER FOR BREAST RECONSTRUCTION FOLLOWING MASTECTOMY; ENCOUNTER FOR THERAPEUTIC DRUG LEVEL MONITORING00$0.005$33,099.0499$95,620.2316$2,337.380$0.00$131,056.65$403,759.67
2011SUBSCRIBERPAROXYSMAL ATRIAL FIBRILLATION; COVID-19; PHARMACY RX82$110,300.883$1,367.4154$7,757.0426$3,469.120$0.00$122,894.45$288,912.99
3023SUBSCRIBERMALIGNANT MELANOMA OF RIGHT UPPER LIMB, INCLUDING SHOULDER; NEOPLASM OF UNCERTAIN BEHAVIOR OF SKIN; MALIGNANT MELANOMA OF LEFT LOWER EYELID, INCLUDING CANTHUS00$0.002$1,854.5350$107,643.3217$160.330$0.00$109,658.18$267,300.27
4012SUBSCRIBERPHARMACY RX; OTITIS MEDIA, UNSPECIFIED, LEFT EAR; COVID-1900$0.004$3,454.0134$3,582.6563$86,466.700$0.00$93,503.36$153,519.71
5011SUBSCRIBERDYSPHAGIA, UNSPECIFIED; CEREBRAL INFARCTION, UNSPECIFIED; CEREBRAL INFARCTION DUE TO UNSPECIFIED OCCLUSION OR STENOSIS OF RIGHT CEREBELLAR ARTERY305$68,015.240$0.0069$9,679.4723$2,511.820$0.00$80,206.53$573,333.95
6012SUBSCRIBERNONTRAUMATIC INTRACEREBRAL HEMORRHAGE, INTRAVENTRICULAR; CEREBRAL INFARCTION, UNSPECIFIED; NONTRAUMATIC INTRACEREBRAL HEMORRHAGE, UNSPECIFIED61$51,785.841$464.9845$27,628.840$0.000$0.00$79,879.66$508,008.78
7023SUBSCRIBERSPONDYLOLISTHESIS, LUMBAR REGION; PHARMACY RX; SPONDYLOSIS WITHOUT MYELOPATHY OR RADICULOPATHY, LUMBAR REGION51$51,426.621$232.0072$16,342.3566$8,306.600$0.00$76,307.57$326,625.48
8008SUBSCRIBERSPINAL STENOSIS, LUMBAR REGION WITHOUT NEUROGENIC CLAUDICATION; SEPSIS, UNSPECIFIED ORGANISM; OTHER CHRONIC PAIN00$0.008$38,351.48188$30,237.5734$390.800$0.00$68,979.85$1,382,217.77
9007SUBSCRIBERDIVERTICULITIS OF LARGE INTESTINE WITHOUT PERFORATION OR ABSCESS WITHOUT BLEEDING; GASTRO-ESOPHAGEAL REFLUX DISEASE WITH ESOPHAGITIS, WITHOUT BLEEDING; DIVERTICULOSIS OF LARGE INTESTINE WITHOUT PERFORATION OR ABSCESS WITH BLEEDING21$52,756.113$3,091.7122$7,812.428$63.960$0.00$63,724.20$253,831.81
10002SUBSCRIBERMATERNAL CARE FOR EXCESSIVE FETAL GROWTH, THIRD TRIMESTER, NOT APPLICABLE OR UNSPECIFIED; MATERNAL CARE FOR DISPROPORTION, UNSPECIFIED; SUPERVISION OF ELDERLY MULTIGRAVIDA, THIRD TRIMESTER42$45,735.912$3,966.4031$9,321.3613$123.630$0.00$59,147.30$224,153.10
11012SUBSCRIBERACUTE KIDNEY FAILURE, UNSPECIFIED; MALIGNANT NEOPLASM OF UPPER-INNER QUADRANT OF LEFT FEMALE BREAST; MALIGNANT NEOPLASM OF OVERLAPPING SITES OF LEFT FEMALE BREAST61$27,173.045$12,480.9280$17,532.2111$92.830$0.00$57,279.00$175,095.30
12007SUBSCRIBERPHARMACY RX; AGE-RELATED NUCLEAR CATARACT, RIGHT EYE; AGE-RELATED NUCLEAR CATARACT, LEFT EYE00$0.002$2,757.7824$2,788.50114$50,756.630$0.00$56,302.91$89,876.31
13005SUBSCRIBERATRIOVENTRICULAR BLOCK, COMPLETE; ENCOUNTER FOR ADJUSTMENT AND MANAGEMENT OF OTHER PART OF CARDIAC PACEMAKER; PHARMACY RX00$0.0018$25,831.0476$22,814.4845$6,382.090$0.00$55,027.61$155,763.61
14011SUBSCRIBERUNSPECIFIED ROTATOR CUFF TEAR OR RUPTURE OF RIGHT SHOULDER, NOT SPECIFIED AS TRAUMATIC; IMPINGEMENT SYNDROME OF RIGHT SHOULDER; COVID-1900$0.0017$36,273.0785$18,066.3054$417.370$0.00$54,756.74$377,200.92
15012SPOUSEPHARMACY RX; ANXIETY DISORDER DUE TO KNOWN PHYSIOLOGICAL CONDITION; OTHER RHEUMATOID ARTHRITIS WITH RHEUMATOID FACTOR OF MULTIPLE SITES00$0.000$0.0020$1,087.5845$49,694.890$0.00$50,782.47$69,208.34
Total6113$407,193.6471$163,224.37949$377,914.32535$211,174.150$0.00$1,159,506.48$5,248,808.01

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 10/13/2023 2:44 PM Page 1 of 1

S4 High Cost Claims Summ Page1

High Cost Claims Summary - Plan YTD
Company: SUWANNEE COUNTY BOCC TAX

Group: 15534 Current Paid Period: From 10/2021 to 09/2023 Prior Paid Period: From 10/2020 to 09/2021 High Cost Claims Threshold: 50000

CURRENTInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1008SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; SPINAL STENOSIS, LUMBAR REGION WITHOUT NEUROGENIC CLAUDICATION; ALCOHOL INDUCED ACUTE PANCREATITIS WITHOUT NECROSIS OR INFECTION592$282,436.9018$41,787.02247$37,322.7653$773.170$0.00$362,319.85$1,491,661.78
2011SUBSCRIBERPAROXYSMAL ATRIAL FIBRILLATION; COVID-19; OTHER SPONDYLOSIS WITH RADICULOPATHY, LUMBAR REGION134$127,184.707$29,172.41127$19,951.9261$11,565.000$0.00$187,874.03$525,870.82
3012SUBSCRIBERPHARMACY RX; OTITIS MEDIA, UNSPECIFIED, LEFT EAR; TYPE 2 DIABETES MELLITUS WITHOUT COMPLICATIONS00$0.005$4,094.9053$5,290.96103$177,958.050$0.00$187,343.91$284,493.88
4011SUBSCRIBERPHARMACY RX; OTHER SPECIFIED NONINFLAMMATORY DISORDERS OF VAGINA; CALCULUS OF KIDNEY11$32,177.0028$40,868.05219$31,647.33183$55,937.870$0.00$160,630.25$825,260.82
5023SUBSCRIBERMALIGNANT NEOPLASM OF UPPER-OUTER QUADRANT OF LEFT FEMALE BREAST; ENCOUNTER FOR BREAST RECONSTRUCTION FOLLOWING MASTECTOMY; ENCOUNTER FOR THERAPEUTIC DRUG LEVEL MONITORING00$0.006$44,155.06125$101,486.8623$3,010.410$0.00$148,652.33$464,052.59
6012SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; ACUTE KIDNEY FAILURE, UNSPECIFIED; MALIGNANT NEOPLASM OF UPPER-INNER QUADRANT OF LEFT FEMALE BREAST124$87,919.805$12,480.92208$30,546.5920$367.430$0.00$131,314.74$533,269.92
7010SUBSCRIBERENCOUNTER FOR ANTINEOPLASTIC RADIATION THERAPY; ENCOUNTER FOR ANTINEOPLASTIC CHEMOTHERAPY; DYSPHONIA00$0.0051$96,308.1580$15,001.9831$354.580$0.00$111,664.71$302,234.26
8007SUBSCRIBERPHARMACY RX; AGE-RELATED NUCLEAR CATARACT, RIGHT EYE; AGE-RELATED NUCLEAR CATARACT, LEFT EYE00$0.002$2,757.7844$4,015.58228$104,623.950$0.00$111,397.31$188,398.86
9023SUBSCRIBERMALIGNANT MELANOMA OF RIGHT UPPER LIMB, INCLUDING SHOULDER; NEOPLASM OF UNCERTAIN BEHAVIOR OF SKIN; MALIGNANT MELANOMA OF LEFT LOWER EYELID, INCLUDING CANTHUS00$0.002$1,854.5350$107,657.8417$160.330$0.00$109,672.70$267,300.27
10R08SUBSCRIBERUNILATERAL PRIMARY OSTEOARTHRITIS, RIGHT KNEE; UNILATERAL PRIMARY OSTEOARTHRITIS, LEFT KNEE; POLYP OF COLON00$0.0013$91,071.8477$15,539.6628$106.590$0.00$106,718.09$237,550.11
11012SPOUSEPHARMACY RX; OTHER RHEUMATOID ARTHRITIS WITH RHEUMATOID FACTOR OF MULTIPLE SITES; ANXIETY DISORDER DUE TO KNOWN PHYSIOLOGICAL CONDITION00$0.000$0.0029$1,645.0081$103,381.970$0.00$105,026.97$141,760.18
12011SUBSCRIBERATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSTABLE ANGINA PECTORIS; INCISIONAL HERNIA WITH OBSTRUCTION, WITHOUT GANGRENE; INCISIONAL HERNIA WITHOUT OBSTRUCTION OR GANGRENE00$0.002$77,767.4327$5,031.6325$90.910$0.00$82,889.97$749,171.10
13012SUBSCRIBERNONTRAUMATIC INTRACEREBRAL HEMORRHAGE, INTRAVENTRICULAR; CEREBRAL INFARCTION, UNSPECIFIED; NONTRAUMATIC INTRACEREBRAL HEMORRHAGE, UNSPECIFIED61$51,785.841$464.9845$27,631.640$0.000$0.00$79,882.46$508,008.78
14023SUBSCRIBERSPONDYLOLISTHESIS, LUMBAR REGION; PHARMACY RX; SPONDYLOSIS WITHOUT MYELOPATHY OR RADICULOPATHY, LUMBAR REGION51$51,426.629$631.20103$16,640.6286$11,000.890$0.00$79,699.33$340,255.15
15011SUBSCRIBERDYSPHAGIA, UNSPECIFIED; CEREBRAL INFARCTION, UNSPECIFIED; CEREBRAL INFARCTION DUE TO UNSPECIFIED OCCLUSION OR STENOSIS OF RIGHT CEREBELLAR ARTERY214$67,015.240$0.0069$9,679.4723$2,511.820$0.00$79,206.53$515,971.76
16002SUBSCRIBERCALCULUS OF KIDNEY; UNILATERAL INGUINAL HERNIA, WITHOUT OBSTRUCTION OR GANGRENE, NOT SPECIFIED AS RECURRENT; ABRASION OF RIGHT INDEX FINGER, INITIAL ENCOUNTER00$0.008$69,101.2335$9,138.1819$169.160$0.00$78,408.57$464,734.41
17004SUBSCRIBERPHARMACY RX; ENCOUNTER FOR SCREENING MAMMOGRAM FOR MALIGNANT NEOPLASM OF BREAST; TYPE 2 DIABETES MELLITUS WITH HYPERGLYCEMIA00$0.000$0.0016$1,053.1655$77,317.730$0.00$78,370.89$276,563.38
18011SUBSCRIBERUNSPECIFIED ROTATOR CUFF TEAR OR RUPTURE OF RIGHT SHOULDER, NOT SPECIFIED AS TRAUMATIC; IMPINGEMENT SYNDROME OF RIGHT SHOULDER; COVID-1900$0.0025$46,042.09183$26,107.0277$717.000$0.00$72,866.11$553,178.81
19007SUBSCRIBERDIVERTICULITIS OF LARGE INTESTINE WITHOUT PERFORATION OR ABSCESS WITHOUT BLEEDING; GASTRO-ESOPHAGEAL REFLUX DISEASE WITH ESOPHAGITIS, WITHOUT BLEEDING; DIVERTICULOSIS OF LARGE INTESTINE WITHOUT PERFORATION OR ABSCESS WITH BLEEDING21$52,756.113$3,091.7122$7,859.328$63.960$0.00$63,771.10$253,831.81
20005SUBSCRIBERATRIOVENTRICULAR BLOCK, COMPLETE; PHARMACY RX; ENCOUNTER FOR ADJUSTMENT AND MANAGEMENT OF OTHER PART OF CARDIAC PACEMAKER00$0.0018$25,831.0488$24,320.1276$13,413.630$0.00$63,564.79$170,973.46
21C23SUBSCRIBERNON-ST ELEVATION (NSTEMI) MYOCARDIAL INFARCTION; PHARMACY RX; OTHER CHEST PAIN21$22,492.3815$8,254.7284$7,672.41105$19,789.370$0.00$58,208.88$345,130.29
22008SUBSCRIBERACUTE APPENDICITIS WITH PERFORATION, LOCALIZED PERITONITIS, AND GANGRENE, WITHOUT ABSCESS; PHARMACY RX; UNSPECIFIED ACUTE APPENDICITIS11$26,288.233$4,212.0093$8,487.3155$16,487.960$0.00$55,475.50$261,909.17
23006SUBSCRIBERLOCALIZED ENLARGED LYMPH NODES; OTHER HAMMER TOE(S) (ACQUIRED), LEFT FOOT; HALLUX VALGUS (ACQUIRED), RIGHT FOOT00$0.0013$34,302.08127$18,978.2937$169.480$0.00$53,449.85$243,164.44
24007SUBSCRIBERDIVERTICULITIS OF LARGE INTESTINE WITHOUT PERFORATION OR ABSCESS WITHOUT BLEEDING; DIVERTICULITIS OF INTESTINE, PART UNSPECIFIED, WITHOUT PERFORATION OR ABSCESS WITHOUT BLEEDING; DIVERTICULITIS OF LARGE INTESTINE WITH PERFORATION AND ABSCESS WITHOUT BLEEDING42$28,083.2413$9,304.0173$14,982.8953$428.980$0.00$52,799.12$294,154.64
25019SUBSCRIBERPHARMACY RX; TYPE 1 DIABETES MELLITUS WITH UNSPECIFIED COMPLICATIONS; TYPE 1 DIABETES MELLITUS WITHOUT COMPLICATIONS00$0.000$0.00288$24,900.2577$27,175.370$0.00$52,075.62$216,516.21
Total12622$829,566.06247$643,553.152,512$572,588.791,524$627,575.610$0.00$2,673,283.61$10,455,416.90
PRIORInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1023SUBSCRIBERMALIGNANT NEOPLASM OF UPPER-OUTER QUADRANT OF LEFT FEMALE BREAST; ENCOUNTER FOR THERAPEUTIC DRUG LEVEL MONITORING; ENCOUNTER FOR ANTINEOPLASTIC CHEMOTHERAPY00$0.005$30,423.72296$174,679.2326$675.190$0.00$205,778.14$835,637.77
2008SUBSCRIBEROTHER CARDIOMYOPATHIES; NEOPLASM OF UNSPECIFIED BEHAVIOR OF LEFT KIDNEY; MALIGNANT NEOPLASM OF LEFT KIDNEY, EXCEPT RENAL PELVIS42$42,810.613$56,759.0355$11,994.9524$6,146.940$0.00$117,711.53$644,650.97
3007SUBSCRIBERST ELEVATION (STEMI) MYOCARDIAL INFARCTION INVOLVING OTHER CORONARY ARTERY OF INFERIOR WALL; HYPERTENSIVE HEART DISEASE WITH HEART FAILURE; ST ELEVATION (STEMI) MYOCARDIAL INFARCTION OF UNSPECIFIED SITE62$83,936.083$3,568.7598$12,813.9061$1,356.710$0.00$101,675.44$920,973.96
4020DEPENDENTPOISONING BY OTHER OPIOIDS, ACCIDENTAL (UNINTENTIONAL), INITIAL ENCOUNTER; OPIOID DEPENDENCE, UNCOMPLICATED; POISONING BY UNSPECIFIED NARCOTICS, ACCIDENTAL (UNINTENTIONAL), INITIAL ENCOUNTER11$37,007.9913$42,397.2260$6,664.0752$290.920$0.00$86,360.20$438,257.20
5012SUBSCRIBERCERVICAL DISC DISORDER AT C6-C7 LEVEL WITH RADICULOPATHY; DISPLACEMENT OF INTERNAL FIXATION DEVICE OF VERTEBRAE, INITIAL ENCOUNTER; SPONDYLOSIS WITHOUT MYELOPATHY OR RADICULOPATHY, CERVICAL REGION00$0.0012$64,758.6349$18,617.0227$97.900$0.00$83,473.55$444,121.93
6012SUBSCRIBERPHARMACY RX; TYPE 2 DIABETES MELLITUS WITHOUT COMPLICATIONS; CONTACT WITH AND (SUSPECTED) EXPOSURE TO COVID-1900$0.000$0.008$763.7452$79,384.870$0.00$80,148.61$119,217.49
7008SUBSCRIBERCARDIAC ARREST, CAUSE UNSPECIFIED; PNEUMONITIS DUE TO INHALATION OF FOOD AND VOMIT; PHARMACY RX22$61,881.020$0.0013$3,537.1353$7,462.500$0.00$72,880.65$317,327.21
8014SUBSCRIBERLEIOMYOMA OF UTERUS, UNSPECIFIED; EXCESSIVE AND FREQUENT MENSTRUATION WITH REGULAR CYCLE; ABNORMAL UTERINE AND VAGINAL BLEEDING, UNSPECIFIED31$6,090.893$54,508.8348$9,018.0016$51.520$0.00$69,669.24$247,754.58
9011SUBSCRIBERPHARMACY RX; CALCULUS OF KIDNEY; ATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSPECIFIED ANGINA PECTORIS00$0.0015$43,840.3387$9,618.0494$15,049.050$0.00$68,507.42$363,502.52
10005SUBSCRIBERATRIOVENTRICULAR BLOCK, COMPLETE; BRADYCARDIA, UNSPECIFIED; OTHER FATIGUE91$56,724.593$2,265.6229$2,210.5917$26.030$0.00$61,226.83$284,849.41
11020SPOUSEURGENCY OF URINATION; ENCOUNTER FOR ADJUSTMENT AND MANAGEMENT OF NEUROSTIMULATOR; CALCULUS OF KIDNEY00$0.0011$45,109.1375$10,685.41100$1,528.140$0.00$57,322.68$147,229.81
12019SUBSCRIBERPAROXYSMAL ATRIAL FIBRILLATION; PHARMACY RX; OTHER PERSISTENT ATRIAL FIBRILLATION00$0.001$48,642.5619$2,977.3315$3,412.630$0.00$55,032.52$261,794.55
13008SUBSCRIBERUNILATERAL PRIMARY OSTEOARTHRITIS, RIGHT KNEE; CELLULITIS OF RIGHT LOWER LIMB; OSTEOARTHRITIS OF KNEE, UNSPECIFIED11$17,200.0021$28,423.7342$7,597.5325$323.610$0.00$53,544.87$178,933.92
Total2610$305,651.1890$420,697.55879$271,176.94562$115,806.010$0.00$1,113,331.68$5,204,251.32

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 10/13/2023 2:44 PM Page 1 of 1

S5 Monitoring by Utiliza Page1

Monitoring by Utilization and Enrollment - By Division
Company: SUWANNEE COUNTY BOCC TAX

Group: 15534 Current Paid Period: From 10/2022 to 09/2023

EnrollmentPremiumCapitationFee for Service Claims
Paid Year MonthDiv NumContractsMembersPremiumPCPSpecialtyTotal CapitationValue Based
ProgramsInpatientOutpatientPhysicianOtherTotal MedicalPharmacyGrand TotalMLR
20221000144$3,019.20$0.00$5.72$5.72$4.75$0.00$0.00$0.00$308.51$308.51$36.06$355.0411.76%
0021010$7,670.20$0.00$65.80$65.80$19.00$0.00$0.00$421.10$231.69$652.79$40.87$778.4610.15%
00422$1,534.04$0.00$13.16$13.16$4.75$0.00$0.00$0.00$0.00$0.00$40.11$58.023.78%
00599$6,793.20$0.00$12.87$12.87$14.25$0.00$0.00$619.48$303.02$922.50$1,426.74$2,376.3634.98%
0061516$12,326.06$0.00$105.28$105.28$38.00$0.00$6,297.28$935.38$3,693.34$10,926.00$163.81$11,233.0991.13%
0073436$26,327.46$0.00$50.05$50.05$28.50$0.00$1,203.68$2,415.88$4,626.59$8,246.15$6,906.98$15,231.6857.85%
0084849$37,637.72$0.00$335.58$335.58$128.25$282,436.90$3,752.54$5,053.24$2,687.92$293,930.60$3,139.42$297,533.85790.52%
0101212$9,204.24$0.00$78.96$78.96$33.25$0.00$0.00$544.36$17.65$562.01$1,281.36$1,955.5821.25%
0115970$48,284.64$0.00$88.66$88.66$61.75($1,000.00)$20,675.06$2,259.66$1,767.31$23,702.03$5,563.48$29,415.9260.92%
0129495$72,920.64$0.00$625.10$625.10$251.75$0.00$11,486.41$6,757.25$3,097.80$21,341.46$13,748.46$35,966.7749.32%
01799$5,662.60$0.00$4.70$4.70$9.50$0.00$0.00$581.08$299.16$880.24$89.08$983.5217.37%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$0.00$331.54$331.54$7.73$340.2127.47%
0191616$9,060.16$0.00$7.05$7.05$14.25$0.00$0.00$546.71$1,064.28$1,610.99$2,232.88$3,865.1742.66%
020516$5,774.70$0.00$7.52$7.52$14.25$0.00$4,058.00$638.50$591.65$5,288.15$305.56$5,615.4897.24%
0235050$27,746.74$0.00$24.44$24.44$42.75$0.00$335.90$3,442.93$1,583.16$5,361.99$1,650.52$7,079.7025.52%
0241336$15,711.58$0.00$16.92$16.92$19.00$0.00$654.02$259.57$668.09$1,581.68$595.29$2,212.8914.08%
R0744$3,019.20$0.00$5.72$5.72$0.00$0.00$0.00$1,116.40$1,145.02$2,261.42$184.74$2,451.8881.21%
R0866$4,602.12$0.00$32.90$32.90$2,216.31$0.00$39,360.05$4,008.79$404.54$43,773.38$42.04$46,064.631000.94%
R1111$754.80$0.00$1.43$1.43$0.00$0.00$0.00$396.84$0.00$396.84$17.95$416.2255.14%
R1233$2,301.06$0.00$19.74$19.74$0.00$0.00$0.00$0.00$0.00$0.00$620.99$640.7327.84%
R1900$0.00$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.470.00%
R2311$566.26$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.470.08%
Total396447$302,155.24$0.00$1,503.48$1,503.48$2,900.31$281,436.90$87,822.94$29,997.17$22,821.27$422,078.28$38,094.07$464,576.14153.75%
Avg1820$13,734.33$0.00$68.34$68.34$131.83$12,792.59$3,991.95$1,363.51$1,037.33$19,185.38$1,731.55$21,117.10153.75%
20221100144$3,019.20$0.00$5.72$5.72$4.75$0.00$0.00$144.04$0.00$144.04$140.66$295.179.78%
0021111$8,437.22$0.00$72.38$72.38$19.00$0.00$1,442.00$81.10$288.24$1,811.34$3,121.21$5,023.9359.54%
00422$1,534.04$0.00$13.16$13.16$4.75$0.00$0.00$0.00$0.00$0.00$6,364.07$6,381.98416.02%
0051111$6,793.20$0.00$12.87$12.87$14.25$0.00$1,040.21$1,660.64$388.46$3,089.31$5,563.08$8,679.51127.77%
0061415$12,326.06$0.00$98.70$98.70$38.00$0.00$4,283.43$4,229.91$986.20$9,499.54$270.70$9,906.9480.37%
0073537$26,356.50$0.00$52.91$52.91$28.50$11,345.00$3,678.01$6,561.22$3,153.06$24,737.29$18,892.34$43,711.04165.85%
0085051$38,434.24$0.00$315.84$315.84$137.75$0.00$22,073.53$5,186.29$3,984.77$31,244.59$5,898.91$37,597.0997.82%
0101212$9,204.24$0.00$78.96$78.96$33.25$0.00$4,227.69$1,457.60$0.00$5,685.29$2,575.26$8,372.7690.97%
0116071$49,039.44$0.00$107.25$107.25$66.50$24,172.22$4,694.83$5,459.84$2,681.62$37,008.51$8,746.88$45,929.1493.66%
0129899$72,920.64$0.00$625.10$625.10$261.25$13,962.64$3,208.40$3,349.08$1,619.99$22,140.11$13,959.99$36,986.4550.72%
01799$5,662.60$0.00$4.70$4.70$9.50$0.00$1,131.75$317.73$356.59$1,806.07$34.78$1,855.0532.76%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$0.00$88.58$88.58$176.65$266.1721.49%
0191616$9,060.16$0.00$7.99$7.99$14.25$0.00$100.11$80.77$1,523.92$1,704.80$653.69$2,380.7326.28%
020516$5,762.94$0.00$7.52$7.52$14.25$0.00$3,804.75$811.36$626.40$5,242.51$611.69$5,875.97101.96%
0235151$27,180.48$0.00$21.15$21.15$42.75$0.00$3,033.56$2,782.71$504.68$6,320.95$491.16$6,876.0125.30%
0241336$15,711.58$0.00$16.92$16.92$19.00$0.00$975.61$1,338.20$183.81$2,497.62$557.43$3,090.9719.67%
R0744$3,019.20$0.00$5.72$5.72$0.00$0.00$159.00$208.34$91.14$458.48$122.90$587.1019.45%
R0866$4,602.12$0.00$46.06$46.06$4.75$0.00$1,694.26$391.50$410.67$2,496.43$308.98$2,856.2262.06%
R1111$754.80$0.00$1.43$1.43$0.00$0.00$1,458.00$492.86$0.00$1,950.86$19.62$1,971.91261.25%
R1233$2,301.06$0.00$19.74$19.74$0.00$0.00$0.00$0.00$0.00$0.00$772.17$791.9134.42%
R1900$0.00$0.00($0.47)($0.47)$0.00$0.00$0.00$0.00$0.00$0.00$0.00($0.47)0.00%
R2311$566.26$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$41.52$41.997.42%
Total407458$303,924.60$0.00$1,515.06$1,515.06$712.50$49,479.86$57,005.14$34,553.19$16,888.13$157,926.32$69,323.69$229,477.5775.50%
Avg1921$13,814.75$0.00$68.87$68.87$32.39$2,249.08$2,591.14$1,570.60$767.64$7,178.47$3,151.08$10,430.8075.50%
20221200144$3,019.20$0.00$5.72$5.72$4.77$0.00$0.00$0.00$36.18$36.18$537.38$584.0519.34%
0021010$8,437.22$0.00$72.38$72.38$23.85($24,081.00)$1,756.37$564.00$1,472.52($20,288.11)$3,400.85($16,791.03)-199.01%
00422$1,534.04$0.00$13.16$13.16$4.77$0.00$0.00$0.00$0.00$0.00$3,230.07$3,248.00211.73%
0051111$6,793.20$0.00$15.73$15.73$14.31$0.00$1,856.82$639.27$682.84$3,178.93$177.77$3,386.7449.85%
0061516$10,792.02$0.00$98.70$98.70$33.39$0.00$2,394.75$366.55$3,807.55$6,568.85($17.86)$6,683.0861.93%
0073537$27,082.26$0.00$52.91$52.91$28.62$0.00$10,524.00$3,005.26$1,406.11$14,935.37$5,686.89$20,703.7976.45%
0085152$40,705.80$0.00$348.74$348.74$133.56$0.00$5,159.00$2,345.84$1,617.16$9,122.00$5,478.72$15,083.0237.05%
0101212$9,204.24$0.00$78.96$78.96$33.39$0.00$980.28$2,992.25$451.54$4,424.07$370.59$4,907.0153.31%
0116168$51,303.84$0.00$105.82$105.82$66.78$0.00$3,191.72$6,943.15$4,305.17$14,440.04$8,029.17$22,641.8144.13%
01299100$79,056.80$0.00$677.74$677.74$262.35$54,564.09$6,356.29$5,043.21$5,302.89$71,266.48$16,443.08$88,649.65112.13%
01799$5,662.60$0.00$4.70$4.70$9.54$0.00$0.00$914.38$794.81$1,709.19$77.38$1,800.8131.80%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$0.00$88.58$88.58$22.22$111.749.02%
0191616$9,060.16$0.00$7.52$7.52$14.31$0.00$0.00$1,300.20$1,325.97$2,626.17$1,273.00$3,921.0043.28%
020516$5,774.70$0.00$7.52$7.52$14.31$0.00$14,181.23$143.92$293.41$14,618.56$551.83$15,192.22263.08%
0235151$29,445.52$0.00$24.44$24.44$47.70$0.00$12,781.81$3,678.33$1,575.96$18,036.10$3,891.93$22,000.1774.71%
0241234$15,711.58$0.00$16.92$16.92$19.08$0.00$764.94$86.82$738.57$1,590.33$667.20$2,293.5314.60%
R0744$3,019.20$0.00$5.72$5.72$0.00$0.00$0.00$349.35$209.19$558.54$56.65$620.9120.57%
R0855$4,602.12$0.00$39.48$39.48$4.77$0.00$859.54$1,000.50$1,105.40$2,965.44$6.04$3,015.7365.53%
R1111$754.80$0.00$1.43$1.43$0.00$0.00$1,458.00$0.00$0.00$1,458.00$39.25$1,498.68198.55%
R1233$2,301.06$0.00$19.74$19.74$0.00$0.00$0.00$0.00$38.22$38.22$2,115.02$2,172.9894.43%
R2311$566.26$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.470.08%
Total408454$316,065.24$0.00$1,598.74$1,598.74$715.50$30,483.09$62,264.75$29,373.03$25,252.07$147,372.94$52,037.18$201,724.3663.82%
Avg1922$15,050.73$0.00$76.13$76.13$34.07$1,451.58$2,964.99$1,398.72$1,202.48$7,017.76$2,477.96$9,605.9263.82%
20230100144$3,019.20$0.00$5.72$5.72$4.77$0.00$0.00$21.16$55.59$76.75$7.72$94.963.15%
0021010$7,670.20$0.00$60.82$60.82$23.85$0.00$1,442.00$741.75$737.17$2,920.92$3,334.55$6,340.1482.66%
00422$1,534.04$0.00$13.48$13.48$4.77$0.00$0.00$0.00$0.00$0.00$3,177.78$3,196.03208.34%
0051111$9,057.60$0.00$14.30$14.30$14.31$0.00$2,291.01$683.41$1,869.74$4,844.16$1,016.69$5,889.4665.02%
0061516$13,093.08$0.00$114.42$114.42$33.39$0.00$1,785.76$923.61$958.82$3,668.19$230.16$4,046.1630.90%
0073436$27,082.26$0.00$52.91$52.91$23.85$0.00$4,823.41$637.24$859.99$6,320.64$6,984.28$13,381.6849.41%
0085152$39,938.78$0.00$357.22$357.22$138.33$0.00$1,255.82$2,488.37$1,474.75$5,218.94$1,527.19$7,241.6818.13%
0101212$9,204.24$0.00$80.88$80.88$33.39$0.00$27,934.46$1,870.04$908.16$30,712.66$536.93$31,363.86340.75%
0116168$49,975.32$0.00$91.52$91.52$66.78$0.00$6,276.24$2,877.14$2,353.23$11,506.61$2,407.76$14,072.6728.16%
0129899$75,988.72$0.00$660.52$660.52$271.89$0.00$1,539.00$5,533.95$3,765.04$10,837.99$14,590.54$26,360.9434.69%
01799$3,397.56$0.00$2.82$2.82$9.54$0.00$227.84$3.28$108.15$339.27$66.31$417.9412.30%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.940.08%
0191717$9,626.42$0.00$7.99$7.99$9.54$0.00$0.00$98.71$0.00$98.71$1,538.67$1,654.9117.19%
020516$5,774.70$0.00$7.52$7.52$14.31$0.00$0.00$647.96$474.42$1,122.38$52.45$1,196.6620.72%
0235454$28,313.00$0.00$24.44$24.44$47.70$0.00$1,684.36$267.68$1,567.94$3,519.98($404.50)$3,187.6211.26%
0241130$15,711.58$0.00$15.04$15.04$19.08$0.00$1,902.00$113.44$676.58$2,692.02$46.99$2,773.1317.65%
R0744$3,019.20$0.00$5.72$5.72$0.00$0.00$0.00$100.05$3.39$103.44$224.27$333.4311.04%
R0855$4,602.12$0.00$40.44$40.44$4.77$0.00$0.00$88.21$524.00$612.21$0.00$657.4214.29%
R1111$754.80$0.00$1.43$1.43$0.00$0.00$0.00$13.05$253.98$267.03$0.58$269.0435.64%
R1233$2,301.06$0.00$20.22$20.22$0.00$0.00$0.00$133.99$172.81$306.80$2,060.15$2,387.17103.74%
R2311$566.26$0.00$0.47$0.47$0.00$0.00$0.00$1.48$19.84$21.32$1.00$22.794.02%
Total409452$311,868.76$0.00$1,578.82$1,578.82$720.27$0.00$51,161.90$17,244.52$16,783.60$85,190.02$37,399.52$124,888.6340.05%
Avg1922$14,850.89$0.00$75.18$75.18$34.30$0.00$2,436.28$821.17$799.22$4,056.67$1,780.93$5,947.0840.05%
20230200144$3,019.20$0.00$5.72$5.72$4.77$0.00$0.00$48.87$381.59$430.46$869.69$1,310.6443.41%
0021010$6,903.18$0.00$67.40$67.40$23.85$0.00$0.00$692.86$208.72$901.58$3,468.20$4,461.0364.62%
00422$1,534.04$0.00$13.48$13.48$4.77$0.00$0.00$0.00$171.29$171.29$3,999.55$4,189.09273.08%
0051111$7,548.00$0.00$14.30$14.30$14.31$0.00$0.00$607.01$654.70$1,261.71$1,810.84$3,101.1641.09%
0061516$12,326.06$0.00$107.84$107.84$23.85$0.00$2,584.00$1,607.18$141.10$4,332.28$28.31$4,492.2836.45%
0073436$26,327.46$0.00$50.05$50.05$23.85$0.00$4,550.77$1,042.15$855.47$6,448.39$6,340.45$12,862.7448.86%
0085051$40,705.80$0.00$337.00$337.00$138.33$0.00$110.00$2,209.27$818.24$3,137.51$7,048.23$10,661.0726.19%
0101212$9,204.24$0.00$80.88$80.88$33.39$0.00$37,124.32$723.02$1,856.31$39,703.65$2,520.02$42,337.94459.98%
0116168$49,129.98$0.00$97.24$97.24$66.78$0.00$25,031.56$5,581.52$1,787.41$32,400.49$6,465.54$39,030.0579.44%
01299100$75,988.72$0.00$694.06$694.06$276.66$0.00$4,701.52$2,574.86$2,695.50$9,971.88$15,284.80$26,227.4034.51%
01799$5,096.34$0.00$4.23$4.23$9.54$0.00$3,260.08$1,779.28$446.12$5,485.48$77.60$5,576.85109.43%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.940.08%
0191717$9,060.16$0.00$7.99$7.99$9.54$0.00$0.00$0.00$0.00$0.00$317.31$334.843.70%
020516$5,774.70$0.00$7.52$7.52$14.31$0.00$0.00$0.00$0.00$0.00$0.00$21.830.38%
0235353$32,276.82$0.00$25.38$25.38$52.47$0.00$219.06$102.83$2,334.38$2,656.27$9.79$2,743.918.50%
0241130$11,047.24$0.00$12.22$12.22$19.08$0.00$0.00$4.36$611.62$615.98$0.52$647.805.86%
R0744$3,019.20$0.00$5.72$5.72$0.00$0.00$0.00$1,722.54$69.80$1,792.34$144.63$1,942.6964.34%
R0855$3,835.10$0.00$20.38$20.38$4.77$0.00$0.00$249.95$524.00$773.95$330.62$1,129.7229.46%
R1111$754.80$0.00$1.43$1.43$0.00$0.00$0.00$133.25$0.00$133.25$0.58$135.2617.92%
R1233$2,301.06$0.00$20.22$20.22$0.00$0.00$439.95$292.65$204.00$936.60$1,471.97$2,428.79105.55%
R2311$566.26$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.470.08%
Total408451$307,656.98$0.00$1,574.47$1,574.47$720.27$0.00$78,021.26$19,371.60$13,760.25$111,153.11$50,188.65$163,636.5053.19%
Avg1921$14,650.33$0.00$74.97$74.97$34.30$0.00$3,715.30$922.46$655.25$5,293.01$2,389.94$7,792.2153.19%
20230300144$3,019.20$0.00$5.88$5.88$4.59$0.00$0.00$64.48$852.08$916.56$1,539.38$2,466.4181.69%
0021010$7,670.20$0.00$67.80$67.80$27.54$0.00$27,292.72$2,606.44$920.13$30,819.29$4,314.75$35,229.38459.30%
00422$1,534.04$0.00$13.56$13.56$4.59$0.00$0.00$0.00$0.00$0.00$4,018.64$4,036.79263.15%
0051111$7,548.00$0.00$14.70$14.70$13.77$0.00$0.00$424.54$407.61$832.15$2,209.71$3,070.3340.68%
0061516$12,326.06$0.00$108.48$108.48$27.54$0.00$0.00$893.06$1,252.54$2,145.60$459.27$2,740.8922.24%
0073436$26,327.46$0.00$52.92$52.92$18.36$0.00$1,519.00$2,042.42$1,204.47$4,765.89$8,029.45$12,866.6248.87%
0084950$38,404.74$0.00$345.78$345.78$142.29$0.00$2,790.00$2,329.74$1,400.36$6,520.10$6,615.69$13,623.8635.47%
0101212$9,204.24$0.00$81.36$81.36$22.95$0.00$4,047.67$964.24$263.26$5,275.17$399.07$5,778.5562.78%
0116067$49,884.78$0.00$98.49$98.49$68.85$9,854.00$18,891.45$11,940.55$9,269.72$49,955.72$13,188.21$63,311.27126.92%
012101102$76,755.74$0.00$657.98$657.98$266.22$36,266.91$7,428.88$4,581.36$3,508.61$51,785.76$22,939.28$75,649.2498.56%
01799$5,096.34$0.00$4.23$4.23$9.18$0.00$755.19$236.20$93.17$1,084.56$84.04$1,182.0123.19%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.940.08%
0191717$9,060.16$0.00$7.99$7.99$9.18$0.00$0.00$128.27$859.42$987.69$1,310.61$2,315.4725.56%
020516$5,774.70$0.00$7.52$7.52$13.77$0.00$0.00$2,169.47$0.00$2,169.47$0.00$2,190.7637.94%
0235252$28,313.00$0.00$23.50$23.50$50.49$0.00$2,167.25$812.46$580.09$3,559.80$666.37$4,300.1615.19%
0241130$10,282.86$0.00$14.10$14.10$13.77$0.00$5,157.64$891.69$1,129.68$7,179.01$347.40$7,554.2873.46%
R0744$3,019.20$0.00$5.88$5.88$0.00$0.00$0.00$87.03$100.92$187.95$329.04$522.8717.32%
R0855$3,835.10$0.00$33.90$33.90$9.18$0.00$290.48$297.14$400.82$988.44$0.00$1,031.5226.90%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$604.59$256.67$1,025.67$1,886.93$68.13$1,956.53259.21%
R1222$2,301.06$0.00$20.34$20.34$0.00$0.00$0.00$0.00$108.22$108.22$1,692.90$1,821.4679.16%
Total405448$302,350.30$0.00$1,566.82$1,566.82$702.27$46,120.91$70,944.87$30,725.76$23,376.77$171,168.31$68,211.94$241,649.3479.92%
Avg2022$15,117.52$0.00$78.34$78.34$35.11$2,306.05$3,547.24$1,536.29$1,168.84$8,558.42$3,410.60$12,082.4779.92%
20230400144$3,019.20$0.00$5.88$5.88$4.59$0.00$0.00$0.00$0.00$0.00$869.69$880.1629.15%
0021111$7,670.20$0.00$74.58$74.58$27.54$0.00$30,664.89$2,169.89$866.89$33,701.67$4,390.24$38,194.03497.95%
00422$1,534.04$0.00$13.56$13.56$4.59$0.00$0.00$0.00$184.15$184.15$3,416.43$3,618.73235.90%
0051111$7,548.00$0.00$14.70$14.70$30.88$0.00$0.00$1,339.54$1,505.60$2,845.14$106.92$2,997.6439.71%
0061516$12,326.06$0.00$108.48$108.48$27.54$0.00$2,021.22$1,052.46$925.86$3,999.54$127.67$4,263.2334.59%
0073335$24,817.86$0.00$51.45$51.45$18.36$0.00$0.00$1,432.32$158.52$1,590.84$6,784.22$8,444.8734.03%
0084748$36,853.43$0.00$325.44$325.44$151.47$0.00$17,234.10$4,712.62$2,032.48$23,979.20$3,579.69$28,035.8076.07%
0101212$9,204.24$0.00$81.36$81.36$32.13$0.00$1,363.92$967.46$402.61$2,733.99$884.57$3,732.0540.55%
0116067$49,884.78$0.00$99.96$99.96$68.85$8,300.47$61,257.67$6,954.41$5,251.94$81,764.49$5,364.16$87,297.46175.00%
012103104$76,755.74$0.00$691.56$691.56$302.94$0.00$25,834.73$7,407.71$3,339.00$36,581.44$11,876.45$49,452.3964.43%
01799$5,096.34$0.00$4.23$4.23$9.18$0.00$175.11$293.83$0.00$468.94$0.03$482.389.47%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$0.00$27.17$27.17$0.00$28.112.27%
0191717$10,758.94$0.00$7.99$7.99$9.18$0.00$125.68$1,029.52$1,076.05$2,231.25$1,473.10$3,721.5234.59%
020516$5,774.70$0.00$7.52$7.52$13.77$0.00$1,952.27$530.35$344.97$2,827.59$42.09$2,890.9750.06%
0235151$28,313.00$0.00$23.97$23.97$50.49$0.00$61.56$172.89$1,695.86$1,930.31$8.53$2,013.307.11%
0241130$12,760.10$0.00$14.10$14.10$20.78$0.00$0.00$14.77$498.54$513.31$1,390.28$1,938.4715.19%
R0744$3,019.20$0.00$5.88$5.88$0.00$0.00$0.00$0.00$3.39$3.39$24.59$33.861.12%
R0855$2,301.06$0.00$33.90$33.90$9.18$0.00$41,301.66$3,440.33$2,690.12$47,432.11$14.00$47,489.192063.80%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$451.20$974.27$233.12$1,658.59$0.58$1,660.64220.01%
R1222$1,534.04$0.00$6.78$6.78$0.00$0.00$0.00$0.00$124.45$124.45$1,121.24$1,252.4781.65%
R2300$0.00$0.00$0.00$0.00$0.00$0.00$0.00$123.45$0.00$123.45$0.00$123.450.00%
Total404447$301,164.35$0.00$1,573.75$1,573.75$781.47$8,300.47$182,444.01$32,615.82$21,360.72$244,721.02$41,474.48$288,550.7295.81%
Avg1921$14,341.16$0.00$74.94$74.94$37.21$395.26$8,687.81$1,553.13$1,017.18$11,653.38$1,974.98$13,740.5195.81%
20230500144$3,019.20$0.00$5.88$5.88$4.59$0.00$0.00$74.36$0.00$74.36$2,528.25$2,613.0886.55%
0021111$9,204.24$0.00$74.58$74.58$22.95$0.00$1,615.03$1,757.30$537.53$3,909.86$3,432.00$7,439.3980.83%
00422$1,534.04$0.00$13.56$13.56$4.59$0.00$0.00$0.00$0.00$0.00$3,371.35$3,389.50220.95%
0051111$7,548.00$0.00$20.54$20.54$13.77$0.00$0.00$741.87$555.84$1,297.71$4,931.76$6,263.7882.99%
0061516$12,326.06$0.00$108.48$108.48$36.72$0.00$5,289.01$4,009.44$2,691.91$11,990.36$93.21$12,228.7799.21%
0073335$25,572.66$0.00$51.45$51.45$27.54$0.00$950.69$617.54$482.09$2,050.32$12,723.52$14,852.8358.08%
0084849$36,103.68$0.00$318.66$318.66$156.06$0.00$5,247.11$8,734.32$2,812.60$16,794.03$5,822.83$23,091.5863.96%
0101212$9,204.24$0.00$81.36$81.36$32.13$0.00$3,651.16$966.11$1,306.31$5,923.58$1,580.41$7,617.4882.76%
0116168$47,620.38$0.00$92.65$92.65$73.44$32,177.00$65,263.17$8,356.22$7,828.28$113,624.67$11,489.69$125,280.45263.08%
012104105$85,959.98$0.00$745.76$745.76$312.12$9,573.60$3,682.91$8,759.37$3,545.98$25,561.86$23,996.78$50,616.5258.88%
01400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000.00%
01788$5,096.34$0.00$4.23$4.23$9.18$0.00$58.37$799.66$251.67$1,109.70$53.57$1,176.6823.09%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$464.37$398.05$0.00$862.42$50.29$913.6573.76%
0191717$9,626.42$0.00$7.99$7.99$9.18$0.00$0.00$0.00$711.28$711.28$3,082.34$3,810.7939.59%
020517$6,472.10$0.00$7.99$7.99$13.77$0.00$0.00$30.79$0.00$30.79$117.02$169.572.62%
0235151$33,409.34$0.00$25.85$25.85$50.49$0.00$7,686.78$1,563.53$294.61$9,544.92$107.36$9,728.6229.12%
0241027$11,521.48$0.00$11.75$11.75$13.77$0.00$0.00$443.06$1.80$444.86$1,788.19$2,258.5719.60%
R0744$3,019.20$0.00$5.88$5.88$0.00$0.00$0.00$0.00$41.37$41.37$53.35$100.603.33%
R0855$3,835.10$0.00$33.90$33.90$9.18$0.00$2,104.69$0.00$204.78$2,309.47$72.35$2,424.9063.23%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$5,193.00$435.94$115.55$5,744.49$67.55$5,813.51770.21%
R1233$767.02$0.00$13.56$13.56$0.00$0.00$0.00$227.40$51.31$278.71$2,569.12$2,861.39373.05%
Total406448$313,832.90$0.00$1,626.48$1,626.48$789.48$41,750.60$101,206.29$37,914.96$21,432.91$202,304.76$77,930.94$282,651.6690.06%
Avg1921$14,944.42$0.00$77.45$77.45$37.59$1,988.12$4,819.35$1,805.47$1,020.61$9,633.56$3,711.00$13,459.6090.06%
20230600144$3,019.20$0.00$5.88$5.88$4.80$0.00$0.00$0.00$184.06$184.06$13.43$208.176.89%
0021111$8,437.22$0.00$74.58$74.58$28.80$0.00$632.04$478.37$820.87$1,931.28$3,440.42$5,475.0864.89%
00422$1,534.04$0.00$13.56$13.56$4.80$0.00$0.00$144.07$0.00$144.07$5,960.20$6,122.63399.12%
0051111$13,586.40$0.00$16.17$16.17$19.20$0.00$1,520.00$745.34$141.88$2,407.22$1,824.67$4,267.2631.41%
0061516$12,326.06$0.00$108.48$108.48$38.40$0.00$240.76$501.51$69.28$811.55$161.27$1,119.709.08%
0073335$25,572.66$0.00$51.45$51.45$33.60$0.00$6,271.21$893.49$1,318.16$8,482.86$14,328.93$22,896.8489.54%
0084849$36,870.70$0.00$325.44$325.44$148.80$0.00$4,934.21$4,162.24$706.48$9,802.93$4,579.94$14,857.1140.30%
0101212$9,204.24$0.00$81.36$81.36$33.60$0.00$229.00$475.43$634.53$1,338.96$1,178.24$2,632.1628.60%
0116168$44,601.18$0.00$98.49$98.49$76.80$0.00$5,112.31$4,065.28$1,532.74$10,710.33$10,792.99$21,678.6148.61%
012105106$79,823.82$0.00$711.90$711.90$355.20$0.00$5,095.07$8,164.55$5,955.12$19,214.74$16,903.44$37,185.2846.58%
01400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$19.84$19.84$0.00$19.840.00%
01788$4,530.08$0.00$3.29$3.29$4.80$0.00$3,576.22$418.26$395.78$4,390.26$950.39$5,348.74118.07%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$696.55$969.88$479.06$2,145.49$4.39$2,150.82173.65%
0191717$9,626.42$0.00$37.45$37.45$4.80$0.00$289.37$6.62$427.35$723.34$1,482.28$2,247.8723.35%
020517$6,472.10$0.00$7.99$7.99$19.20$0.00$0.00$0.00$517.98$517.98$7.92$553.098.55%
0235252$28,879.26$0.00$52.96$52.96$52.80$0.00$9,186.08$1,328.08$782.61$11,296.77$694.00$12,096.5341.89%
024925$10,729.18$0.00$11.75$11.75$14.40$0.00$0.00$267.33$33.92$301.25$296.25$623.655.81%
C2311$566.26$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$5.37$5.370.95%
R0744$3,019.20$0.00$5.88$5.88$0.00$0.00$0.00$124.75$3.39$128.14$93.21$227.237.53%
R0855$3,835.10$0.00$33.90$33.90$4.80$0.00$1,307.16$47.61$229.04$1,583.81$25.99$1,648.5042.98%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$0.00$1,743.03$0.00$1,743.03$58.88$1,803.38238.92%
R1233$3,068.08$0.00$27.12$27.12$4.80$0.00$0.00$213.34$0.00$213.34$1,927.61$2,172.8770.82%
Total408449$307,694.62$0.00$1,670.06$1,670.06$849.60$0.00$39,089.98$24,749.18$14,252.09$78,091.25$64,729.82$145,340.7347.24%
Avg1920$13,986.12$0.00$75.91$75.91$38.62$0.00$1,776.82$1,124.96$647.82$3,549.60$2,942.26$6,606.4047.24%
20230700144$3,019.20$0.00$5.88$5.88$4.80$0.00$0.00$0.00$381.80$381.80$58.14$450.6214.93%
0021111$8,437.22$0.00$74.58$74.58$28.80$0.00$0.00$126.13$374.06$500.19$4,365.19$4,968.7658.89%
00422$1,534.04$0.00$13.56$13.56$4.80$0.00$0.00$0.00$77.57$77.57$3,377.78$3,473.71226.44%
0051213$8,302.80$0.00$16.17$16.17$19.20$0.00$0.00$132.43$340.87$473.30$581.63$1,090.3013.13%
0061617$12,326.06$0.00$108.48$108.48$33.60$0.00$117.84$680.38$437.24$1,235.46$17.05$1,394.5911.31%
0073335$25,572.66$0.00$51.45$51.45$38.40$0.00$10,458.68$1,844.24$1,973.35$14,276.27$9,934.77$24,300.8995.03%
0084950$36,870.70$0.00$332.22$332.22$153.60$0.00$6,364.77$1,615.19$4,181.20$12,161.16$10,205.08$22,852.0661.98%
0101212$9,204.24$0.00$81.36$81.36$33.60$0.00$9,665.52$2,159.51$494.98$12,320.01$1,074.16$13,509.13146.77%
0116067$49,129.98$0.00$101.43$101.43$72.00$8,583.35($39,504.84)$3,772.88$2,498.20($24,650.41)$6,840.67($17,636.31)-35.90%
012102103$83,658.92$0.00$718.68$718.68$355.20$27,244.67$12,129.18$4,867.79$1,444.20$45,685.84$13,697.76$60,457.4872.27%
01788$3,963.82$0.00$3.76$3.76$4.80$0.00$0.00$348.84$1,160.39$1,509.23$944.13$2,461.9262.11%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$58.18$777.13$835.31$199.67$1,035.9283.64%
0191616$9,060.16$0.00$7.52$7.52$4.80$0.00$0.01$480.18$833.28$1,313.47$2,282.17$3,607.9639.82%
020517$6,494.60$0.00$7.99$7.99$19.20$6,980.88$1,395.49$1,832.62$728.37$10,937.36$201.59$11,166.14171.93%
0235353$28,879.26$0.00$24.91$24.91$52.80$19,724.84$509.61$932.86$812.91$21,980.22$300.59$22,358.5277.42%
024925$10,506.02$0.00$11.75$11.75$9.60$0.00$0.00$8.09$199.81$207.90$732.53$961.789.15%
C2311$577.59$0.00$0.94$0.94$0.00$0.00$0.00$0.00$0.00$0.00$5,517.66$5,518.60955.45%
R0744$3,019.20$0.00$5.88$5.88$0.00$34,715.35$0.00$508.77$264.25$35,488.37$249.75$35,744.001183.89%
R0855$3,835.10$0.00$33.90$33.90$4.80$0.00$0.00$147.23$52.14$199.37$13.46$251.536.56%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$0.00$0.00$0.00$0.00$540.98$542.4571.87%
R1233$2,301.06$0.00$20.34$20.34$4.80$0.00$0.00$84.48$38.22$122.70$1,099.68$1,247.5254.22%
Total407449$308,686.05$0.00$1,623.21$1,623.21$844.80$97,249.09$1,136.26$19,599.80$17,069.97$135,055.12$62,234.44$199,757.5764.71%
Avg1921$14,699.34$0.00$77.30$77.30$40.23$4,630.91$54.11$933.32$812.86$6,431.20$2,963.54$9,512.2764.71%
20230800155$3,019.20$0.00$7.35$7.35$4.80$0.00$0.00$300.76$366.39$667.15$2,559.42$3,238.72107.27%
0021111$8,437.22$0.00$74.58$74.58$28.80$0.00$0.00$900.17$252.01$1,152.18$3,728.18$4,983.7459.07%
00422$1,534.04$0.00$13.56$13.56$4.80$0.00$0.00$0.00$0.00$0.00$5,912.72$5,931.08386.63%
0051213$8,302.80$0.00$22.05$22.05$24.00$0.00$0.00$795.04$638.76$1,433.80$3,765.70$5,245.5563.18%
0061617$12,326.06$0.00$122.04$122.04$33.60$0.00$1,630.00$971.68$1,115.77$3,717.45$478.77$4,351.8635.31%
0073436$25,572.66$0.00$51.45$51.45$38.40$0.00$2,703.61$2,945.04$1,034.61$6,683.26$15,940.74$22,713.8588.82%
0084849$36,870.70$0.00$325.44$325.44$148.80$26,288.23$5,395.86$3,299.15$2,514.05$37,497.29$10,568.44$48,539.97131.65%
0101212$9,204.24$0.00$81.36$81.36$33.60$0.00$1,021.00$1,582.53($35.35)$2,568.18$901.37$3,584.5138.94%
0116168$49,990.46$0.00$94.08$94.08$76.80$22,743.10$5,528.53$3,835.98$3,438.84$35,546.45$8,034.97$43,752.3087.52%
012103104$76,500.07$0.00$698.34$698.34$360.00($9,573.60)$3,616.69$2,686.55$2,585.76($684.60)$14,045.76$14,419.5018.85%
01788$4,530.08$0.00$3.76$3.76$4.80$0.00$304.80$173.40$595.93$1,074.13$944.13$2,026.8244.74%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$293.34$0.00$293.34$573.65$867.9370.07%
0191616$9,060.16$0.00$28.08$28.08$4.80$0.00$2,249.11$237.10$1,386.78$3,872.99$33,841.40$37,747.27416.63%
020517$6,472.10$0.00$7.99$7.99$19.20$0.00$3,692.00$544.11$901.56$5,137.67$771.84$5,936.7091.73%
0235353$30,578.04$0.00$27.85$27.85$52.80$0.00$7,535.88$1,721.95$494.56$9,752.39$253.57$10,086.6132.99%
024925$10,506.02$0.00$12.22$12.22$14.40$0.00$0.00$4.02$91.00$95.02$7.73$129.371.23%

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .