6-SCBOCC Experience Report Monitoring and HCC Florida Blue Medical 202312.xlsx

XLSX spreadsheet 149 KB Posted

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

About this file

This file contains an experience report monitoring and health care cost analysis for Suwannee County Board of County Commissioners (BOCC) employee group medical benefits through Florida Blue for the 12-month period from January 2023 through December 2023. The report provides comprehensive enrollment and utilization data, claims paid analysis, high-cost claims summaries, and pharmacy benefit information across multiple service categories and divisions within the organization.

The report demonstrates significant health care utilization patterns and cost metrics for an average enrollment of 408 employee contracts covering 452 total members. Key performance indicators show total medical and pharmacy payments of $2,601,034.59 for the year, with a medical loss ratio of 69.10 percent. Inpatient facility costs totaled $405,885.70 (representing a 54.38 percent decrease from the prior year), outpatient facility costs were $785,089.70 (an 11.09 percent increase), professional services reached $576,756.03 (a 31.60 percent decrease), and pharmacy costs totaled $804,840.06 (a 41.30 percent increase). The plan maintained a per-member-per-year cost of $5,756.52 and a per-member-per-month cost of $479.71. High-cost claims analysis identified specific members with significant utilization across multiple service categories, with the top claimant accounting for $122,578.74 in paid claims. The pharmacy benefit component showed 86.11 percent generic utilization with 99.13 percent generic substitution rates, and 96.87 percent formulary compliance, indicating strong cost management in pharmaceutical spending.

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
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
8-SCBOCC Experience Report Monitoring and HCC Florida Blue Medical 202309.xlsx XLSX spreadsheet
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 01/2023 to 12/2023

EnrollmentPremiumCapitationFee for Service Claims
Paid Year MonthContractsMembersPremiumPCPSpecialtyTotal CapitationValue Based
ProgramsInpatientOutpatientPhysicianOtherTotal MedicalPharmacyGrand TotalMLR
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%
202310404447$339,143.98$0.00$1,687.82$1,687.82$888.22$0.00$54,893.07$37,314.45$48,053.49$140,261.01$72,301.87$215,138.9263.44%
202311411462$326,908.39$0.00$1,667.24$1,667.24$868.26$8,026.86$34,611.05$36,449.69$17,070.34$96,157.94$85,276.14$183,969.5856.28%
202312412463$329,710.34$0.00$1,691.68$1,691.68$0.00$112,159.92$76,656.37$33,200.41$16,508.32$238,525.02$73,362.45$313,579.1595.11%
Total4,8965,422$3,764,292.25$0.00$19,521.29$19,521.29$8,941.81$405,885.70$785,089.70$332,440.29$244,315.74$1,767,731.43$804,840.06$2,601,034.5969.10%
Grouping Avg408452$313,691.02$0.00$1,626.77$1,626.77$745.15$33,823.81$65,424.14$27,703.36$20,359.65$147,310.95$67,070.01$216,752.8869.10%
Monthly Avg408452$313,691.02$0.00$1,626.77$1,626.77$745.15$33,823.81$65,424.14$27,703.36$20,359.65$147,310.95$67,070.01$216,752.8869.10%

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: 01/17/2024 11:19 AM 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

20230138411122000409452
20230238311122000408451
20230338011122000405448
20230437911122000404447
20230538211103000406448
20230638510103000408449
20230738311103000407449
20230838811103000412454
20230938611103000410452
20231038011103000404447
20231138611104000411462
20231238711104000412463
Total4,603131128340004,8965,422
Grouping Avg38411113000408452
Monthly Avg38411113000408452
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: 01/17/2024 11:19 AM 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 01/2023 to 12/2023 Prior Paid Period: From 01/2022 to 12/2022 High Cost Claims Threshold: 50000

CURRENTInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1011SUBSCRIBEROTHER SPECIFIED NONINFLAMMATORY DISORDERS OF VAGINA; PHARMACY RX; CALCULUS OF KIDNEY11$32,177.0022$35,999.84123$22,997.0987$31,404.810$0.00$122,578.74$665,697.84
2010SUBSCRIBERENCOUNTER FOR ANTINEOPLASTIC RADIATION THERAPY; ENCOUNTER FOR ANTINEOPLASTIC CHEMOTHERAPY; LOCALIZED ENLARGED LYMPH NODES00$0.0049$99,097.5353$13,414.978$73.490$0.00$112,585.99$300,937.79
3012SUBSCRIBERPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; OTHER DISEASES OF STOMACH AND DUODENUM00$0.002$1,165.1820$2,477.8137$99,695.880$0.00$103,338.87$145,236.15
4011SUBSCRIBEROTHER SPONDYLOSIS WITH RADICULOPATHY, LUMBAR REGION; PHARMACY RX; HYPERTENSIVE EMERGENCY52$16,883.826$31,548.0086$14,109.4437$11,441.500$0.00$73,982.76$794,238.88
5R08SUBSCRIBERUNILATERAL PRIMARY OSTEOARTHRITIS, LEFT KNEE; POLYP OF COLON; CONTRACTURE, LEFT KNEE00$0.009$49,570.9989$10,789.9921$231.660$0.00$60,592.64$141,724.80
6002SUBSCRIBERCALCULUS OF KIDNEY; URINARY TRACT INFECTION, SITE NOT SPECIFIED; PRESENCE OF UROGENITAL IMPLANTS00$0.005$55,469.3921$4,869.8716$168.120$0.00$60,507.38$358,668.43
7019SUBSCRIBERPHARMACY RX; PILONIDAL CYST WITH ABSCESS; CELLULITIS OF BACK [ANY PART EXCEPT BUTTOCK]00$0.002$2,249.1116$454.419$57,359.190$0.00$60,062.71$148,143.24
8011SUBSCRIBERFRACTURE OF VAULT OF SKULL, INITIAL ENCOUNTER FOR CLOSED FRACTURE; TYPE 2 DIABETES MELLITUS WITH HYPERGLYCEMIA; LOCALIZATION-RELATED (FOCAL) (PARTIAL) SYMPTOMATIC EPILEPSY AND EPILEPTIC SYNDROMES WITH COMPLEX PARTIAL SEIZURES, NOT INTRACTABLE, WITHOUT STATUS EPI22$21,129.752$3,309.0148$27,464.1543$6,163.450$0.00$58,066.36$320,096.17
9011SUBSCRIBERATHEROSCLEROTIC 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$52,077.5724$1,594.8919$0.000$0.00$53,672.46$1,084,695.01
Total85$70,190.5798$330,486.62480$98,172.62277$206,538.100$0.00$705,387.91$3,959,438.31
PRIORInpatientOutpatientProfessionalPharmacyOther
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; OTHER MALAISE592$282,436.9015$9,910.78243$34,039.5845$397.390$0.00$326,784.65$1,412,737.97
2012SUBSCRIBERSEPSIS, UNSPECIFIED ORGANISM; ACUTE KIDNEY FAILURE, UNSPECIFIED; MALIGNANT NEOPLASM OF UPPER-INNER QUADRANT OF LEFT FEMALE BREAST124$87,919.804$11,543.61188$26,934.1218$327.430$0.00$126,724.96$516,266.51
3011SUBSCRIBERPAROXYSMAL ATRIAL FIBRILLATION; COVID-19; PHARMACY RX82$110,300.883$1,367.4162$9,206.2834$4,706.220$0.00$125,580.79$313,543.42
4023SUBSCRIBERMALIGNANT 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.5345$107,629.1211$127.590$0.00$109,611.24$265,876.20
5012SUBSCRIBERPHARMACY RX; OTITIS MEDIA, UNSPECIFIED, LEFT EAR; SUPRAVENTRICULAR TACHYCARDIA00$0.002$1,979.8921$2,592.2159$95,600.330$0.00$100,172.43$158,418.28
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
7023SUBSCRIBERMALIGNANT NEOPLASM OF UPPER-OUTER QUADRANT OF LEFT FEMALE BREAST; ENCOUNTER FOR BREAST RECONSTRUCTION FOLLOWING MASTECTOMY; ENCOUNTER FOR ADJUSTMENT OR REMOVAL OF LEFT BREAST IMPLANT00$0.004$30,729.4060$46,198.6512$2,607.760$0.00$79,535.81$240,434.32
8011SUBSCRIBERDYSPHAGIA, UNSPECIFIED; CEREBRAL INFARCTION, UNSPECIFIED; CEREBRAL INFARCTION DUE TO UNSPECIFIED OCCLUSION OR STENOSIS OF RIGHT CEREBELLAR ARTERY214$67,015.240$0.0069$9,679.4721$2,438.610$0.00$79,133.32$515,894.88
9023SUBSCRIBERSPONDYLOLISTHESIS, LUMBAR REGION; PHARMACY RX; SPONDYLOSIS WITHOUT MYELOPATHY OR RADICULOPATHY, LUMBAR REGION51$51,426.6210$863.2070$15,243.1767$9,763.910$0.00$77,296.90$321,686.50
10012SPOUSEPHARMACY RX; ANXIETY DISORDER DUE TO KNOWN PHYSIOLOGICAL CONDITION; ESSENTIAL (PRIMARY) HYPERTENSION00$0.000$0.0017$848.4845$66,242.920$0.00$67,091.40$90,073.02
11007SUBSCRIBERDIVERTICULITIS 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.7117$7,545.658$63.960$0.00$63,457.43$250,189.81
12011SUBSCRIBERUNSPECIFIED ROTATOR CUFF TEAR OR RUPTURE OF RIGHT SHOULDER, NOT SPECIFIED AS TRAUMATIC; IMPINGEMENT SYNDROME OF RIGHT SHOULDER; COVID-1900$0.0019$38,493.90142$23,518.9853$397.400$0.00$62,410.28$410,184.21
13007SUBSCRIBERPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; OBSTRUCTIVE SLEEP APNEA (ADULT) (PEDIATRIC)00$0.000$0.0021$1,497.16110$54,191.890$0.00$55,689.05$79,478.71
Total11315$703,641.3963$100,299.411,000$312,561.71483$236,865.410$0.00$1,353,367.92$5,082,792.61

&"Arial,Regular"&8 This Florida Blue report is proprietary and confidential. Report Run: 01/17/2024 11:19 AM 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 12/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.02254$37,914.4553$773.170$0.00$362,911.54$1,492,268.77
2012SUBSCRIBERPHARMACY RX; OTITIS MEDIA, UNSPECIFIED, LEFT EAR; TYPE 2 DIABETES MELLITUS WITHOUT COMPLICATIONS00$0.006$4,619.1962$6,799.15114$208,113.230$0.00$219,531.57$332,621.52
3011SUBSCRIBERPAROXYSMAL ATRIAL FIBRILLATION; COVID-19; OTHER SPONDYLOSIS WITH RADICULOPATHY, LUMBAR REGION134$127,184.709$32,915.41148$23,315.7271$16,147.720$0.00$199,563.55$1,107,782.30
4011SUBSCRIBERPHARMACY RX; OTHER SPECIFIED NONINFLAMMATORY DISORDERS OF VAGINA; CALCULUS OF KIDNEY11$32,177.0032$46,491.05238$33,290.30206$66,950.320$0.00$178,908.67$864,357.51
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.06141$109,301.3928$3,463.380$0.00$156,919.83$490,169.70
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; LOCALIZED ENLARGED LYMPH NODES00$0.0054$104,972.1597$19,539.0633$417.810$0.00$124,929.02$345,321.04
8007SUBSCRIBERPHARMACY RX; AGE-RELATED NUCLEAR CATARACT, RIGHT EYE; AGE-RELATED NUCLEAR CATARACT, LEFT EYE00$0.004$4,847.7858$5,214.09254$113,402.970$0.00$123,464.84$1,071,206.75
9012SPOUSEPHARMACY RX; OTHER RHEUMATOID ARTHRITIS WITH RHEUMATOID FACTOR OF MULTIPLE SITES; ANXIETY DISORDER DUE TO KNOWN PHYSIOLOGICAL CONDITION00$0.000$0.0034$2,035.4488$115,346.490$0.00$117,381.93$159,407.62
10023SUBSCRIBERMALIGNANT 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
11R08SUBSCRIBERUNILATERAL PRIMARY OSTEOARTHRITIS, RIGHT KNEE; UNILATERAL PRIMARY OSTEOARTHRITIS, LEFT KNEE; POLYP OF COLON00$0.0014$91,484.84111$17,703.5636$302.760$0.00$109,491.16$249,125.49
12004SUBSCRIBERPHARMACY RX; ENCOUNTER FOR SCREENING MAMMOGRAM FOR MALIGNANT NEOPLASM OF BREAST; MULTIPLE SCLEROSIS00$0.000$0.0018$1,231.4261$88,458.050$0.00$89,689.47$302,909.89
13011SUBSCRIBERATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSTABLE ANGINA PECTORIS; INCISIONAL HERNIA WITH OBSTRUCTION, WITHOUT GANGRENE; INCISIONAL HERNIA WITHOUT OBSTRUCTION OR GANGRENE00$0.002$78,321.9137$5,356.9732$90.910$0.00$83,769.79$1,184,051.11
14012SUBSCRIBERNONTRAUMATIC 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
15023SUBSCRIBERSPONDYLOLISTHESIS, LUMBAR REGION; PHARMACY RX; SPONDYLOSIS WITHOUT MYELOPATHY OR RADICULOPATHY, LUMBAR REGION51$51,426.629$631.20104$16,640.6287$11,000.890$0.00$79,699.33$340,821.14
16011SUBSCRIBERDYSPHAGIA, 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
17002SUBSCRIBERCALCULUS 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.1822$208.960$0.00$78,448.37$473,714.38
18011SUBSCRIBERUNSPECIFIED ROTATOR CUFF TEAR OR RUPTURE OF RIGHT SHOULDER, NOT SPECIFIED AS TRAUMATIC; IMPINGEMENT SYNDROME OF RIGHT SHOULDER; COVID-1900$0.0024$45,304.39199$27,617.0789$1,150.370$0.00$74,071.83$595,761.97
19011SUBSCRIBERFRACTURE OF VAULT OF SKULL, INITIAL ENCOUNTER FOR CLOSED FRACTURE; PHARMACY RX; TYPE 2 DIABETES MELLITUS WITH HYPERGLYCEMIA22$21,129.753$3,309.0163$28,019.44119$20,399.610$0.00$72,857.81$359,871.73
20C23SUBSCRIBERPHARMACY RX; NON-ST ELEVATION (NSTEMI) MYOCARDIAL INFARCTION; OTHER CHEST PAIN21$22,492.3815$8,254.7293$7,968.30115$29,477.900$0.00$68,193.30$1,020,833.10
21005SUBSCRIBERATRIOVENTRICULAR BLOCK, COMPLETE; PHARMACY RX; ENCOUNTER FOR ADJUSTMENT AND MANAGEMENT OF OTHER PART OF CARDIAC PACEMAKER00$0.0018$25,831.0489$24,371.7883$15,254.490$0.00$65,457.31$173,754.45
22007SUBSCRIBERDIVERTICULITIS 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
23008SUBSCRIBERACUTE APPENDICITIS WITH PERFORATION, LOCALIZED PERITONITIS, AND GANGRENE, WITHOUT ABSCESS; PHARMACY RX; UNSPECIFIED ACUTE APPENDICITIS11$26,288.233$4,212.00106$11,648.3265$20,184.660$0.00$62,333.21$273,372.19
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.2416$12,753.5489$19,740.2665$1,081.860$0.00$61,658.90$466,283.63
25019SUBSCRIBERPHARMACY RX; TYPE 1 DIABETES MELLITUS WITHOUT COMPLICATIONS; TYPE 1 DIABETES MELLITUS WITH UNSPECIFIED COMPLICATIONS00$0.000$0.00314$27,235.8895$34,061.250$0.00$61,297.13$328,158.35
26019SUBSCRIBERPHARMACY RX; PILONIDAL CYST WITH ABSCESS; CELLULITIS OF BACK [ANY PART EXCEPT BUTTOCK]00$0.002$2,249.1116$454.419$57,359.190$0.00$60,062.71$148,143.24
27006SUBSCRIBERLOCALIZED ENLARGED LYMPH NODES; OTHER HAMMER TOE(S) (ACQUIRED), LEFT FOOT; HALLUX VALGUS (ACQUIRED), RIGHT FOOT00$0.0013$34,302.08140$22,874.0350$431.900$0.00$57,608.01$332,055.31
28011SUBSCRIBERPHARMACY RX; TYPE 2 DIABETES MELLITUS WITH HYPERGLYCEMIA; MAJOR DEPRESSIVE DISORDER, RECURRENT, MODERATE00$0.000$0.0031$5,363.35180$47,857.030$0.00$53,220.38$106,077.41
Total12824$850,695.81267$673,434.872,871$646,148.052,023$855,038.460$0.00$3,025,317.19$14,296,451.14
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: 01/17/2024 11:19 AM 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 01/2023 to 12/2023

EnrollmentPremiumCapitationFee for Service Claims
Paid Year MonthDiv NumContractsMembersPremiumPCPSpecialtyTotal CapitationValue Based
ProgramsInpatientOutpatientPhysicianOtherTotal MedicalPharmacyGrand TotalMLR
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%
00433$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%
012102103$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%
C2311$588.92$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$4,069.58$4,070.05691.10%
R0755$3,019.20$0.00$5.88$5.88$0.00$0.00$0.00$636.59$182.41$819.00$86.12$911.0030.17%
R0866$3,835.10$0.00$40.68$40.68$4.80$0.00$240.00$149.37$519.15$908.52$67.48$1,021.4826.64%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$0.00$27.30$0.00$27.30$557.54$586.3177.68%
R1233$2,301.06$0.00$20.34$20.34$9.60$0.00$0.00$0.00$0.00$0.00$2,714.49$2,744.43119.27%
Total412454$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%
Avg2022$14,506.74$0.00$78.09$78.09$41.14$1,878.94$1,615.12$1,004.96$765.82$5,264.83$5,229.70$10,613.7673.16%
20230900155$4,528.80$0.00$7.35$7.35$4.99$0.00$0.00$0.00$0.00$0.00$58.98$71.321.57%
0021111$8,437.22$0.00$74.58$74.58$34.93$0.00$0.00($218.45)$371.45$153.00$3,829.40$4,091.9148.50%
00433$1,534.04$0.00$13.56$13.56$4.99$0.00$0.00$0.00$384.78$384.78$3,377.78$3,781.11246.48%
0051213$12,990.12$0.00$19.11$19.11$24.95$0.00$0.00$421.52$1,041.77$1,463.29$1,599.97$3,107.3223.92%
0061617$14,627.12$0.00$115.26$115.26$34.93$0.00$16,876.94$490.75$572.81$17,940.50$106.07$18,196.76124.40%
0073335$25,572.66$0.00$47.04$47.04$39.92$0.00($708.64)$1,906.14$787.56$1,985.06$7,916.46$9,988.4839.06%
0084950$36,870.70$0.00$325.44$325.44$154.69$0.00$2,758.00$891.87$2,101.34$5,751.21$8,418.20$14,649.5439.73%
0101212$9,204.24$0.00$81.36$81.36$34.93$0.00$10,524.00$1,951.55$1,013.86$13,489.41$242.53$13,848.23150.45%
0116067$46,005.10$0.00$95.55$95.55$84.83$21,129.75$12,029.44$5,730.60$4,903.61$43,793.40$9,422.88$53,396.66116.07%
01299100$77,036.98$0.00$664.44$664.44$384.23$9,573.60$9,626.86$4,185.71$1,100.57$24,486.74$2,932.35$28,467.7636.95%
01788$4,530.08$0.00$3.76$3.76$4.99$0.00$119.12$1,284.35$1,378.03$2,781.50$2,761.65$5,551.90122.56%
01812$1,238.62$0.00$0.94$0.94$0.00$0.00$0.00$0.00$295.38$295.38$0.42$296.7423.96%
0191616$9,060.16$0.00$54.72$54.72$4.99$0.00$0.00$172.16$825.92$998.08$15,355.93$16,413.72181.16%
020517$6,458.60$0.00$7.99$7.99$9.98$0.00$273.75$292.62$262.80$829.17$1,358.07$2,205.2134.14%
0235454$30,011.78$0.00$24.91$24.91$54.89$22,116.77$5,474.69$2,906.96$2,190.37$32,688.79$1,029.49$33,798.08112.62%
024925$10,506.02$0.00$11.75$11.75$14.97$0.00$0.00$568.19$713.57$1,281.76$368.61$1,677.0915.96%
C2311$577.59$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$874.23$874.70151.44%
R0766$3,019.20$0.00$10.29$10.29$4.99$0.00$0.00$276.54$306.14$582.68$143.57$741.5324.56%
R0866$5,369.14$0.00$40.68$40.68$4.99$0.00$4,033.00$1,181.19$315.09$5,529.28$116.68$5,691.63106.01%
R1111$754.80$0.00$1.47$1.47$0.00$0.00$0.00$108.32$0.00$108.32$572.39$682.1890.38%
R1233$2,301.06$0.00$20.34$20.34$9.98$0.00$0.00$0.00$0.00$0.00$1,420.55$1,450.8763.05%
Total410452$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%
Avg2022$14,792.10$0.00$77.19$77.19$43.48$2,515.24$2,905.10$1,054.76$884.05$7,359.16$2,947.91$10,427.7570.50%
20231000155$3,962.70$0.00$7.35$7.35$4.99$0.00$0.00$163.69$56.18$219.87$32.98$265.196.69%
0021111$8,859.18$0.00$74.58$74.58$34.93$0.00$249.00$232.10$461.49$942.59$3,495.79$4,547.8951.34%
00433$1,610.76$0.00$13.56$13.56$4.99$0.00$0.00$100.69$156.09$256.78$3,408.00$3,683.33228.67%
0051212$9,510.48$0.00$19.11$19.11$24.95$0.00$1,749.52$1,868.83$373.06$3,991.41$100.78$4,136.2543.49%
0061617$13,747.88$0.00$115.26$115.26$34.93$0.00$820.00$3,752.87$1,272.91$5,845.78$259.36$6,255.3345.50%
0073335$27,606.10$0.00$57.33$57.33$39.92$0.00$1,634.48$2,726.44$1,674.39$6,035.31$9,794.52$15,927.0857.69%
0084751$44,830.92$0.00$379.68$379.68$154.69$0.00$3,916.32$4,716.02$8,593.89$17,226.23$9,562.95$27,323.5560.95%
0101111$9,664.56$0.00$81.36$81.36$34.93$0.00$2,041.00$930.48$554.15$3,525.63$244.97$3,886.8940.22%
0116471$54,718.90$0.00$104.37$104.37$79.84$0.00$19,941.29$6,913.28$24,870.01$51,724.58$9,595.13$61,503.92112.40%
0129394$81,284.72$0.00$671.22$671.22$364.27$0.00$5,641.81$4,927.18$2,482.25$13,051.24$10,992.28$25,079.0130.85%
01788$4,756.64$0.00$3.76$3.76$4.99$0.00$243.94$1,017.96$669.68$1,931.58$823.44$2,763.7758.10%
01812$1,300.56$0.00$0.94$0.94$0.00$0.00$1,419.21$303.02$558.07$2,280.30$2,704.36$4,985.60383.34%
0191717$10,107.86$0.00$41.87$41.87$4.99$0.00$109.25$750.39$338.32$1,197.96$15,236.51$16,481.33163.05%
020517$6,795.72$0.00$7.99$7.99$9.98$0.00$0.00$79.80$477.73$557.53($465.56)$109.941.62%
0235151$32,673.58$0.00$25.38$25.38$54.89$0.00$16,526.29$6,865.28$3,039.46$26,431.03$94.45$26,605.7581.43%
024924$11,265.70$0.00$10.81$10.81$14.97$0.00$600.96$1.87$1,290.19$1,893.02$482.30$2,401.1021.31%
C2311$594.58$0.00$0.47$0.47$0.00$0.00$0.00$141.61$69.71$211.32$3,196.99$3,408.78573.31%
R0777$7,812.18$0.00$10.29$10.29$4.99$0.00$0.00$402.92$191.52$594.44$434.29$1,044.0113.36%
R0866$4,832.28$0.00$40.68$40.68$4.99$0.00$0.00$1,287.54$924.39$2,211.93$81.29$2,338.8948.40%
R1111$792.54$0.00$1.47$1.47$0.00$0.00$0.00$0.00$0.00$0.00$540.40$541.8768.37%
R1233$2,416.14$0.00$20.34$20.34$9.98$0.00$0.00$132.48$0.00$132.48$1,686.64$1,849.4476.55%
Total404447$339,143.98$0.00$1,687.82$1,687.82$888.22$0.00$54,893.07$37,314.45$48,053.49$140,261.01$72,301.87$215,138.9263.44%
Avg1921$16,149.71$0.00$80.37$80.37$42.30$0.00$2,613.96$1,776.88$2,288.26$6,679.10$3,442.95$10,244.7163.44%
20231100144$3,962.70$0.00$7.35$7.35$4.99$0.00$0.00$72.06$73.98$146.04$965.24$1,123.6228.35%
0021111$8,859.18$0.00$74.58$74.58$34.93$0.00$1,430.00$323.81$1,415.36$3,169.17($344.13)$2,934.5533.12%
00433$1,610.76$0.00$40.68$40.68$4.99$0.00$0.00$0.00$0.00$0.00$5,373.42$5,419.09336.43%
0051212$9,510.48$0.00$16.17$16.17$24.95$0.00$2,117.00$1,649.31$672.75$4,439.06$3,795.86$8,276.0487.02%
0061617$13,747.88$0.00$115.26$115.26$34.93$0.00$439.95$580.21$292.40$1,312.56$133.13$1,595.8811.61%
0073537$28,436.38$0.00$54.39$54.39$34.93$0.00$5,846.00$5,979.93$1,057.84$12,883.77$14,562.50$27,535.5996.83%
0084953$41,839.56$0.00$352.56$352.56$144.71$0.00$3,109.00$2,434.54$2,795.62$8,339.16$5,626.97$14,463.4034.57%
0101111$9,664.56$0.00$67.80$67.80$34.93$0.00$0.00$448.06$390.57$838.63$1,404.86$2,346.2224.28%
0116572$53,964.10$0.00$102.90$102.90$84.83$0.00$3,218.83$7,974.65$2,984.70$14,178.18$10,540.79$24,906.7046.15%
01296105$76,567.52$0.00$664.44$664.44$334.33$8,026.86$6,593.97$7,135.82$2,540.64$24,297.29$26,717.24$52,013.3067.93%
01788$4,756.64$0.00$3.76$3.76$4.99$0.00$7.06$80.43$88.36$175.85$321.47$506.0710.64%
01812$1,300.56$0.00$0.94$0.94$0.00$0.00$0.00$0.00$0.00$0.00$566.77$567.7143.65%
0191515$10,107.86$0.00$50.86$50.86$9.98$0.00$0.00$405.73$637.99$1,043.72$3,007.67$4,112.2340.68%
020517$6,795.72$0.00$7.99$7.99$9.98$0.00$8,334.96$1,995.39$1,150.54$11,480.89$1,530.08$13,028.94191.72%
0235353$30,323.58$0.00$22.56$22.56$64.87$0.00$2,082.67$6,303.54$1,604.66$9,990.87$2,509.13$12,587.4341.51%
024924$11,265.70$0.00$11.75$11.75$14.97$0.00$0.00$6.68$375.57$382.25$995.27$1,404.2412.46%
C2311$606.47$0.00$0.47$0.47$0.00$0.00$0.00$0.00$0.00$0.00$3,196.99$3,197.46527.22%
R0777$5,547.78$0.00$10.29$10.29$9.98$0.00$1,018.61$329.80$741.56$2,089.97$2,543.31$4,653.5583.88%
R0866$4,832.28$0.00$40.68$40.68$4.99$0.00$413.00$194.31$164.88$772.19$180.78$998.6420.67%
R1111$792.54$0.00$1.47$1.47$0.00$0.00$0.00$485.02$0.00$485.02$556.95$1,043.44131.66%
R1233$2,416.14$0.00$20.34$20.34$9.98$0.00$0.00$50.40$82.92$133.32$1,091.84$1,255.4851.96%

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 .