4-SCBOCC Claims MARCH 2026.xlsx

XLSX spreadsheet 119 KB Posted

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

About this file

Summary of Suwannee County Board of County Commissioners - Group Medical Benefits Claims Report

This document is a comprehensive claims and utilization monitoring report for the Suwannee County Board of County Commissioners' (BOCC) group medical benefits program administered by Florida Blue, covering the period from April 2025 through March 2026. The program serves employees and eligible retirees of Suwannee County BOCC and related constitutional offices, including the Sheriff, Tax Collector, Property Appraiser, Clerk of Courts, and Supervisor of Elections. The report provides detailed analysis of enrollment trends, claims processing, medical loss ratios, high-cost claims, pharmacy utilization, provider performance, and diagnosis-based payment metrics across 4,951 total contracts representing 5,330 members. Data is presented through multiple monitoring dashboards that track payment patterns by division, contract type, utilization rates, and key performance indicators on both monthly and rolling twelve-month bases.

The document reveals that total medical and pharmacy claims paid during the reporting period equaled $4,047,433.44 against $4,279,462.21 in premiums collected, resulting in a weighted medical loss ratio of 94.58 percent. Claims payments averaged $337,286.12 monthly and $9,112.32 per member annually, with inpatient facility costs declining 14.78 percent year-over-year to $966,159.38, while professional services increased 29.49 percent to $1,109,530.00. Pharmacy claims totaled $1,011,011.34 with a generic substitution rate of 98.68 percent and generic utilization of 85.83 percent. High-cost claims exceeding $50,000 represented significant concentration in oncology-related diagnoses and circulatory system disorders, with the top individual claim totaling $561,289.09 for laryngeal stenosis and malignant neoplasm treatment. The report identifies leading inpatient providers including Shands Jacksonville Medical Center ($404,479.46), HCA Florida North Florida Hospital ($248,191.21), and Mayo Clinic Florida Hospital ($96,978.01), while outpatient and professional services showed distributed utilization across multiple regional healthcare providers.

View the file

Other files

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

Group: 15534 Current Paid Period: From 04/2025 to 03/2026

EnrollmentPremiumCapitationFee for Service Claims
Paid Year MonthContractsMembersPremiumPCPSpecialtyTotal CapitationValue Based
ProgramsInpatientOutpatientPhysicianOtherTotal MedicalPharmacyGrand TotalMLR
202504409440$344,898.61$0.00$1,739.77$1,739.77$1,791.70$84,560.15$106,969.75$21,207.06$77,518.35$290,255.31$78,575.50$372,362.28107.96%
202505408439$334,559.96$0.00$1,760.62$1,760.62$1,810.56$0.00$98,701.88$34,628.53$32,906.01$166,236.42$87,024.10$256,831.7076.77%
202506409440$337,331.76$0.00$1,746.45$1,746.45$2,053.82$84,199.40$38,607.65$31,125.05$33,578.67$187,510.77$74,082.09$265,393.1378.67%
202507419454$348,604.22$0.00$1,972.63$1,972.63$2,043.85$137,169.09$85,190.63$36,229.86$39,648.18$298,237.76$108,369.51$410,623.75117.79%
202508414450$349,452.88$0.00$1,856.41$1,856.41$2,053.82$35,573.37$55,632.73$74,151.23$29,826.58$195,183.91$89,480.52$288,574.6682.58%
202509412445$341,918.54$0.00$1,885.65$1,885.65$2,019.60$14,851.76$63,611.42$62,860.92$61,266.47$202,590.57$81,652.85$288,148.6784.27%
202510417449$376,107.14$0.00$1,924.96$1,924.96$2,178.00$11,578.66$58,032.85$46,596.47$38,471.94$154,679.92$108,873.12$267,656.0071.16%
202511417446$371,164.26$0.00$1,872.39$1,872.39$1,881.00$144,348.14$64,530.35$63,853.62$44,386.47$317,118.58$61,296.24$382,168.21102.96%
202512414445$378,078.48$0.00$1,820.39$1,820.39$2,439.23$278,518.92$108,186.51$57,328.39$118,751.47$562,785.29$111,771.05$678,815.96179.54%
202601414444$366,534.72$0.00$496.00$496.00$1,944.97$0.00$130,387.75$29,262.36$47,239.18$206,889.29$52,244.35$261,574.6171.36%
202602409439$369,754.94$0.00$2,892.52$2,892.52$1,824.07$175,359.89$59,598.53$22,716.88$34,697.01$292,372.31$49,016.15$346,105.0593.60%
202603409439$361,056.70$0.00$1,597.40$1,597.40$2,163.60$0.00$45,513.26$24,286.82$46,992.48$116,792.56$108,625.86$229,179.4263.47%
Total4,9515,330$4,279,462.21$0.00$21,565.19$21,565.19$24,204.22$966,159.38$914,963.31$504,247.19$605,282.81$2,990,652.69$1,011,011.34$4,047,433.4494.58%
Grouping Avg413444$356,621.85$0.00$1,797.10$1,797.10$2,017.02$80,513.28$76,246.94$42,020.60$50,440.23$249,221.06$84,250.95$337,286.1294.58%
Monthly Avg413444$356,621.85$0.00$1,797.10$1,797.10$2,017.02$80,513.28$76,246.94$42,020.60$50,440.23$249,221.06$84,250.95$337,286.1294.58%
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.
- Florida Blue proprietary and confidential information

&"Arial,Regular"&8 Report Run: 04/20/2026 2:31 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

2025043909100000409440
2025053899100000408439
2025063909100000409440
20250739710120000419454
20250839110130000414450
20250939010120000412445
20251039610110000417449
20251139610110000417446
20251239111120000414445
20260139210120000414444
20260238710120000409439
20260338710120000409439
Total4,69611813700004,9515,330
Grouping Avg39110110000413444
Monthly Avg39110110000413444
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.
- Florida Blue proprietary and confidential information

&"Arial,Regular"&8 Report Run: 04/20/2026 2:31 PM Page 2 of 2

S3 High Cost Claims Summ Page1

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

Group: 15534 Current Paid Period: From 04/2025 to 03/2026 Prior Paid Period: From 04/2024 to 03/2025 High Cost Claims Threshold: 50000

CURRENTInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipEnroll StatusDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1R07SUBSCRIBERACTIVESTENOSIS OF LARYNX; MALIGNANT NEOPLASM OF LARYNX, UNSPECIFIED; MALIGNANT NEOPLASM OF GLOTTIS324$419,331.2210$54,703.20338$83,532.2535$3,722.420$0.00$561,289.09$1,281,583.15
2011SUBSCRIBERTERMEDPAROXYSMAL ATRIAL FIBRILLATION; UNSPECIFIED ATRIAL FLUTTER; UNSPECIFIED ATRIAL FIBRILLATION42$96,978.0113$59,762.19122$49,942.4046$8,996.310$0.00$215,678.91$581,450.92
3011SUBSCRIBERACTIVEMALIGNANT NEOPLASM OF OVERLAPPING SITES OF LEFT FEMALE BREAST; ENCOUNTER FOR ANTINEOPLASTIC CHEMOTHERAPY; MALIGNANT NEOPLASM OF UPPER-OUTER QUADRANT OF LEFT FEMALE BREAST00$0.006$36,894.82337$156,669.2542$4,985.770$0.00$198,549.84$739,572.24
4023SUBSCRIBERACTIVEOTHER FRACTURE OF LEFT LOWER LEG, INITIAL ENCOUNTER FOR CLOSED FRACTURE; DISPLACED TRIMALLEOLAR FRACTURE OF LEFT LOWER LEG, INITIAL ENCOUNTER FOR CLOSED FRACTURE; DISPLACED TRIMALLEOLAR FRACTURE OF LEFT LOWER LEG, SUBSEQUENT ENCOUNTER FOR CLOSED FRACTURE WITH ROUTINE HEALING61$22,785.2835$8,190.8338$96,583.8521$28.650$0.00$127,588.61$309,431.56
5012SUBSCRIBERACTIVEPHARMACY RX; CHRONIC SINUSITIS, UNSPECIFIED; OTHER PRURITUS00$0.001$146.3516$2,430.8255$102,944.880$0.00$105,522.05$145,295.14
6020SPOUSEACTIVEVENTRICULAR PREMATURE DEPOLARIZATION; ENCOUNTER FOR ADJUSTMENT AND MANAGEMENT OF NEUROSTIMULATOR; PHARMACY RX00$0.0018$73,830.5193$15,620.0696$12,291.780$0.00$101,742.35$374,735.43
7006SUBSCRIBERACTIVEATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITHOUT ANGINA PECTORIS; ATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSTABLE ANGINA PECTORIS; CHEST PAIN, UNSPECIFIED61$74,954.223$2,597.0972$19,808.0944$189.900$0.00$97,549.30$850,458.50
8R07SUBSCRIBERACTIVEINTERVERTEBRAL DISC DISORDERS WITH RADICULOPATHY, LUMBAR REGION; PHARMACY RX; DIVERTICULOSIS OF LARGE INTESTINE WITHOUT PERFORATION OR ABSCESS WITHOUT BLEEDING101$62,617.0016$7,923.6078$18,428.2364$5,785.090$0.00$94,753.92$1,059,833.73
9012SUBSCRIBERACTIVEINTERVERTEBRAL DISC DISORDERS WITH RADICULOPATHY, LUMBAR REGION; OTHER INTERVERTEBRAL DISC DISPLACEMENT, LUMBAR REGION; SPINAL STENOSIS, LUMBAR REGION WITHOUT NEUROGENIC CLAUDICATION31$57,464.477$5,608.0092$23,890.0529$146.970$0.00$87,109.49$447,041.42
10012SUBSCRIBERACTIVEPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; PAIN IN LEFT THIGH00$0.001$163.008$891.2613$84,115.420$0.00$85,169.68$127,066.64
11002SUBSCRIBERACTIVEPHARMACY RX; LESION OF ULNAR NERVE, RIGHT UPPER LIMB; OTHER CHEST PAIN00$0.004$4,430.5542$5,696.5966$74,132.680$0.00$84,259.82$173,895.70
12007SUBSCRIBERACTIVEATHEROSCLEROSIS OF NATIVE ARTERIES OF EXTREMITIES WITH REST PAIN, RIGHT LEG; ATHEROSCLEROSIS OF NATIVE ARTERIES OF EXTREMITIES WITH REST PAIN, LEFT LEG; COMPRESSION OF VEIN00$0.003$9,221.90181$50,368.8827$1,673.670$0.00$61,264.45$195,513.05
13012SUBSCRIBERTERMEDMALIGNANT NEOPLASM OF TAIL OF PANCREAS; MALIGNANT NEOPLASM OF PANCREAS, UNSPECIFIED; OTHER ASCITES132$43,745.622$2,827.0359$12,745.4319$1,287.750$0.00$60,605.83$198,200.15
14007SUBSCRIBERACTIVEINFECTIOUS GASTROENTERITIS AND COLITIS, UNSPECIFIED; ATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH OTHER FORMS OF ANGINA PECTORIS; PHARMACY RX21$26,973.091$17,689.0062$6,440.7288$8,495.020$0.00$59,597.83$198,688.62
15006SPOUSEACTIVEANXIETY DISORDER, UNSPECIFIED; POSTMENOPAUSAL BLEEDING; PHARMACY RX41$31,982.033$3,970.0063$14,699.9756$5,292.580$0.00$55,944.58$333,314.58
16004SUBSCRIBERACTIVEPHARMACY RX; ENCOUNTER FOR SCREENING MAMMOGRAM FOR MALIGNANT NEOPLASM OF BREAST; ENCOUNTER FOR GYNECOLOGICAL EXAMINATION (GENERAL) (ROUTINE) WITHOUT ABNORMAL FINDINGS00$0.000$0.005$472.6121$54,636.340$0.00$55,108.95$85,560.13
17011SUBSCRIBERACTIVEDISPLACED INTERTROCHANTERIC FRACTURE OF RIGHT FEMUR, INITIAL ENCOUNTER FOR CLOSED FRACTURE; FRACTURE OF UNSPECIFIED PART OF NECK OF RIGHT FEMUR, INITIAL ENCOUNTER FOR CLOSED FRACTURE; PAIN IN RIGHT LEG41$33,626.679$9,380.8436$8,310.2170$518.740$0.00$51,836.46$342,740.57
Total8415$870,457.61132$297,338.911,642$566,530.67792$369,243.970$0.00$2,103,571.16$7,444,381.53
PRIORInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipEnroll StatusDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1023SUBSCRIBERTERMEDNON-ST ELEVATION (NSTEMI) MYOCARDIAL INFARCTION; ATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITHOUT ANGINA PECTORIS; PLEURAL EFFUSION, NOT ELSEWHERE CLASSIFIED192$652,305.031$610.31163$41,874.951$1,098.940$0.00$695,889.23$2,671,588.84
2011SUBSCRIBERTERMEDSPINAL STENOSIS, LUMBAR REGION WITHOUT NEUROGENIC CLAUDICATION; PAROXYSMAL ATRIAL FIBRILLATION; LONGSTANDING PERSISTENT ATRIAL FIBRILLATION32$119,238.8110$40,567.39105$31,238.8958$13,356.990$0.00$204,402.08$1,004,009.11
3C23SUBSCRIBERTERMEDOTHER SUPRAVENTRICULAR TACHYCARDIA; PHARMACY RX; CHEST PAIN, UNSPECIFIED00$0.003$115,543.7439$6,999.6727$10,971.670$0.00$133,515.08$432,403.97
4012SUBSCRIBERACTIVEPHARMACY RX; CHRONIC MAXILLARY SINUSITIS; OTHER CHRONIC SINUSITIS00$0.003$10,023.5042$9,032.4266$101,838.970$0.00$120,894.89$211,072.07
5012SUBSCRIBERACTIVEPHARMACY RX; PSORIASIS VULGARIS; ESSENTIAL (PRIMARY) HYPERTENSION00$0.000$0.005$277.3810$80,715.620$0.00$80,993.00$102,897.15
6002SUBSCRIBERTERMEDSECONDARY MALIGNANT NEOPLASM OF LIVER AND INTRAHEPATIC BILE DUCT; SEPSIS, UNSPECIFIED ORGANISM; MALIGNANT MELANOMA OF SKIN, UNSPECIFIED72$42,761.265$8,179.0081$20,954.0615$2,844.880$0.00$74,739.20$479,736.93
7011SUBSCRIBERACTIVERADICULOPATHY, LUMBAR REGION; RADICULOPATHY, SITE UNSPECIFIED; SPONDYLOSIS WITHOUT MYELOPATHY OR RADICULOPATHY, LUMBAR REGION00$0.001$67,098.5027$6,055.7143$0.000$0.00$73,154.21$193,095.67
8011SUBSCRIBERACTIVEIMMUNE THROMBOCYTOPENIC PURPURA; THROMBOCYTOPENIA, UNSPECIFIED; PHARMACY RX11$19,158.870$0.0087$30,177.1624$21,221.250$0.00$70,557.28$225,031.53
9007SUBSCRIBERACTIVEATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSTABLE ANGINA PECTORIS; ATHEROSCLEROSIS OF NATIVE CORONARY ARTERY OF TRANSPLANTED HEART WITH OTHER FORMS OF ANGINA PECTORIS; PHARMACY RX11$29,304.722$25,336.4680$10,198.63110$4,363.980$0.00$69,203.79$653,726.90
10007SUBSCRIBERACTIVEOTHER SPECIFIED DISORDERS OF KIDNEY AND URETER; PHARMACY RX; BENIGN NEOPLASM OF RIGHT KIDNEY00$0.001$12,488.0055$34,955.6063$18,515.680$0.00$65,959.28$125,410.40
11020SPOUSEACTIVEOTHER CHEST PAIN; SYNCOPE AND COLLAPSE; HYPOTENSION, UNSPECIFIED21$13,965.1016$33,252.74123$12,940.4190$3,194.350$0.00$63,352.60$242,425.20
12002SUBSCRIBERACTIVEPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; OTHER SPECIFIED DISORDERS OF BRAIN00$0.002$3,703.0023$4,022.9426$44,836.310$0.00$52,562.25$117,759.19
13008SUBSCRIBERACTIVESEPSIS, UNSPECIFIED ORGANISM; MENINGITIS, UNSPECIFIED; BASAL CELL CARCINOMA OF SKIN OF OTHER PARTS OF FACE31$30,878.121$59.8830$21,161.8912$158.610$0.00$52,258.50$193,324.20
14008SUBSCRIBERTERMEDPHARMACY RX; UNSPECIFIED OVARIAN CYST, RIGHT SIDE; MAMMOGRAPHIC HETEROGENEOUS DENSITY, BILATERAL BREASTS00$0.000$0.0028$2,781.3831$47,681.270$0.00$50,462.65$67,349.72
Total3610$907,611.9145$316,862.52888$232,671.09576$350,798.520$0.00$1,807,944.04$6,719,830.88
Notes:
- This report contains Personal Health Information (PHI) data.
- SSN = Social Security Number.
- Enrollment status as of last weekly maintenance cycle.
- Florida Blue proprietary and confidential information

&"Arial,Regular"&8 Report Run: 04/20/2026 2:31 PM Page 1 of 1

S4 High Cost Claims Summ Page1

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

Group: 15534 Current Paid Period: From 10/2025 to 03/2026 Prior Paid Period: From 10/2024 to 09/2025 High Cost Claims Threshold: 50000

CURRENTInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipEnroll StatusDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1R07SUBSCRIBERACTIVESTENOSIS OF LARYNX; MALIGNANT NEOPLASM OF LARYNX, UNSPECIFIED; MALIGNANT NEOPLASM OF GLOTTIS313$404,479.467$39,481.49314$81,591.7526$2,747.730$0.00$528,300.43$1,226,995.31
2011SUBSCRIBERACTIVEENCOUNTER FOR ANTINEOPLASTIC CHEMOTHERAPY; MALIGNANT NEOPLASM OF UPPER-OUTER QUADRANT OF LEFT FEMALE BREAST; MALIGNANT NEOPLASM OF OVERLAPPING SITES OF LEFT FEMALE BREAST00$0.003$26,812.93150$65,276.3619$1,391.010$0.00$93,480.30$381,688.53
3R07SUBSCRIBERACTIVEINTERVERTEBRAL DISC DISORDERS WITH RADICULOPATHY, LUMBAR REGION; ARTHRODESIS STATUS; PHARMACY RX101$62,617.0013$5,335.2559$17,290.2129$2,840.880$0.00$88,083.34$1,013,998.78
4023SUBSCRIBERACTIVEOTHER FRACTURE OF LEFT LOWER LEG, INITIAL ENCOUNTER FOR CLOSED FRACTURE; DISPLACED TRIMALLEOLAR FRACTURE OF LEFT LOWER LEG, SUBSEQUENT ENCOUNTER FOR CLOSED FRACTURE WITH ROUTINE HEALING; LYMPHEDEMA, NOT ELSEWHERE CLASSIFIED00$0.0026$4,977.346$73,161.2112$9.470$0.00$78,148.02$16,380.65
5002SUBSCRIBERACTIVEPHARMACY RX; OTHER CHEST PAIN; SHORTNESS OF BREATH00$0.001$1,588.0014$1,637.0932$68,032.740$0.00$71,257.83$125,296.67
6012SUBSCRIBERTERMEDMALIGNANT NEOPLASM OF TAIL OF PANCREAS; MALIGNANT NEOPLASM OF PANCREAS, UNSPECIFIED; OTHER ASCITES132$43,745.621$1,239.0349$11,998.417$785.960$0.00$57,769.02$189,638.82
Total546$510,842.0851$79,434.04592$250,955.03125$75,807.790$0.00$917,038.94$2,953,998.76
PRIORInpatientOutpatientProfessionalPharmacyOther
RankDivRelationshipEnroll StatusDiagnosis DescriptionDaysAdmitsPaid AmtVisitsPaid AmtServicesPaid Amt# of RxPaid AmtClaim CountPaid AmtTotal Paid AmtTotal Billed Amt
1011SUBSCRIBERTERMEDPAROXYSMAL ATRIAL FIBRILLATION; LONGSTANDING PERSISTENT ATRIAL FIBRILLATION; UNSPECIFIED ATRIAL FIBRILLATION52$61,611.8216$70,165.31156$53,930.4748$8,841.960$0.00$194,549.56$275,713.83
2C23SUBSCRIBERTERMEDOTHER SUPRAVENTRICULAR TACHYCARDIA; CHEST PAIN, UNSPECIFIED; SUPRAVENTRICULAR TACHYCARDIA, UNSPECIFIED00$0.003$115,543.7423$6,431.298$2,873.380$0.00$124,848.41$384,382.49
3012SUBSCRIBERACTIVEPHARMACY RX; CHRONIC SINUSITIS, UNSPECIFIED; TYPE 2 DIABETES MELLITUS WITHOUT COMPLICATIONS00$0.001$146.3522$2,677.0559$111,004.870$0.00$113,828.27$155,562.51
4011SUBSCRIBERACTIVEMALIGNANT NEOPLASM OF OVERLAPPING SITES OF LEFT FEMALE BREAST; BENIGN NEOPLASM OF LEFT BREAST; PHARMACY RX00$0.004$10,147.04205$92,395.4530$3,595.330$0.00$106,137.82$360,406.05
5020SPOUSEACTIVEVENTRICULAR PREMATURE DEPOLARIZATION; OTHER CHEST PAIN; HYPOTENSION, UNSPECIFIED00$0.0031$76,263.82116$18,906.0895$7,310.290$0.00$102,480.19$422,042.69
6006SUBSCRIBERACTIVEATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITHOUT ANGINA PECTORIS; ATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH UNSTABLE ANGINA PECTORIS; LOCALIZED SWELLING, MASS AND LUMP, HEAD61$74,954.224$3,337.0958$18,094.3940$245.520$0.00$96,631.22$801,674.81
7012SUBSCRIBERACTIVEINTERVERTEBRAL DISC DISORDERS WITH RADICULOPATHY, LUMBAR REGION; OTHER INTERVERTEBRAL DISC DISPLACEMENT, LUMBAR REGION; SPINAL STENOSIS, LUMBAR REGION WITHOUT NEUROGENIC CLAUDICATION31$57,464.475$5,037.0079$21,420.1523$72.270$0.00$83,993.89$433,983.19
8012SUBSCRIBERACTIVEPHARMACY RX; ENCOUNTER FOR SCREENING FOR MALIGNANT NEOPLASM OF COLON; ESSENTIAL (PRIMARY) HYPERTENSION00$0.001$163.0011$1,066.7214$82,559.690$0.00$83,789.41$111,137.33
9012SUBSCRIBERACTIVEPHARMACY RX; URINARY TRACT INFECTION, SITE NOT SPECIFIED; OTHER SPECIFIED SOFT TISSUE DISORDERS00$0.005$5,619.5032$1,674.7954$66,013.090$0.00$73,307.38$151,221.78
10011SUBSCRIBERACTIVEIMMUNE THROMBOCYTOPENIC PURPURA; PHARMACY RX; THROMBOCYTOPENIA, UNSPECIFIED11$19,158.870$0.0058$27,442.2232$21,153.670$0.00$67,754.76$216,934.44
11004SUBSCRIBERACTIVEPHARMACY RX; ENCOUNTER FOR SCREENING MAMMOGRAM FOR MALIGNANT NEOPLASM OF BREAST; ENCOUNTER FOR GYNECOLOGICAL EXAMINATION (GENERAL) (ROUTINE) WITHOUT ABNORMAL FINDINGS00$0.000$0.004$397.2026$60,857.270$0.00$61,254.47$79,076.87
12007SUBSCRIBERACTIVEINFECTIOUS GASTROENTERITIS AND COLITIS, UNSPECIFIED; ATHEROSCLEROTIC HEART DISEASE OF NATIVE CORONARY ARTERY WITH OTHER FORMS OF ANGINA PECTORIS; PHARMACY RX21$27,095.681$17,689.0082$8,744.4698$7,072.280$0.00$60,601.42$204,992.36
13007SUBSCRIBERACTIVEATHEROSCLEROSIS OF NATIVE ARTERIES OF EXTREMITIES WITH REST PAIN, RIGHT LEG; ATHEROSCLEROSIS OF NATIVE ARTERIES OF EXTREMITIES WITH REST PAIN, LEFT LEG; COMPRESSION OF VEIN00$0.002$10,980.00155$46,802.9621$1,649.930$0.00$59,432.89$176,302.66
14007SUBSCRIBERACTIVEOTHER SPECIFIED DISORDERS OF KIDNEY AND URETER; PHARMACY RX; BENIGN NEOPLASM OF RIGHT KIDNEY00$0.001$12,488.0038$27,505.3261$15,024.590$0.00$55,017.91$110,410.67
15011SUBSCRIBERACTIVEDISPLACED INTERTROCHANTERIC FRACTURE OF RIGHT FEMUR, INITIAL ENCOUNTER FOR CLOSED FRACTURE; FRACTURE OF UNSPECIFIED PART OF NECK OF RIGHT FEMUR, INITIAL ENCOUNTER FOR CLOSED FRACTURE; PAIN IN RIGHT LEG41$33,626.6710$10,958.8432$8,025.8570$1,666.610$0.00$54,277.97$354,130.61
16002SUBSCRIBERACTIVECAPSULAR CONTRACTURE OF BREAST IMPLANT, INITIAL ENCOUNTER; DISPLACEMENT OF BREAST PROSTHESIS AND IMPLANT, INITIAL ENCOUNTER; DISRUPTION OF EXTERNAL OPERATION (SURGICAL) WOUND, NOT ELSEWHERE CLASSIFIED, INITIAL ENCOUNTER00$0.007$34,541.0242$16,414.1953$693.270$0.00$51,648.48$200,605.13
Total217$273,911.7391$373,079.711,113$351,928.59732$390,634.020$0.00$1,389,554.05$4,438,577.42
Notes:
- This report contains Personal Health Information (PHI) data.
- SSN = Social Security Number.
- Enrollment status as of last weekly maintenance cycle.
- Florida Blue proprietary and confidential information

&"Arial,Regular"&8 Report Run: 04/20/2026 2:31 PM Page 1 of 1

S5 Monitoring by Utiliza Page1

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

Group: 15534 Current Paid Period: From 04/2025 to 03/2026

EnrollmentPremiumCapitationFee for Service Claims
Paid Year MonthDiv NumContractsMembersPremiumPCPSpecialtyTotal CapitationValue Based
ProgramsInpatientOutpatientPhysicianOtherTotal MedicalPharmacyGrand TotalMLR
20250400144$3,328.72$0.00$5.84$5.84$9.43$0.00$2,050.08$190.35$0.00$2,240.43$1,025.09$3,280.7998.56%
0021010$8,456.60$0.00$71.80$71.80$56.58$0.00$0.00$1,258.07$152.22$1,410.29$4,888.24$6,426.9176.00%
00433$2,536.98$0.00$21.54$21.54$9.43$0.00$0.00$94.30$0.00$94.30$6,524.42$6,649.69262.11%
0051111$9,153.98$0.00$16.06$16.06$18.86$0.00$0.00$0.00$964.38$964.38$1,013.80$2,013.1021.99%
0061719$16,185.98$0.00$136.42$136.42$103.73$0.00$1,800.88$1,663.19$1,335.89$4,799.96$5,840.34$10,880.4567.22%
0073640$30,590.98$0.00$58.40$58.40$84.87$27,095.68$3,665.02$2,053.59$33,889.75$66,704.04$9,661.16$76,508.47250.10%
0085963$51,543.02$0.00$452.34$452.34$396.06$0.00$2,314.03$3,824.13$16,778.42$22,916.58$14,769.71$38,534.6974.76%
00911$832.18$0.00$1.46$1.46$0.00$0.00$0.00$0.00$1,150.75$1,150.75$1,612.47$2,764.68332.22%
0101111$9,302.26$0.00$78.98$78.98$66.01$0.00$0.00$400.50$249.11$649.61$412.05$1,206.6512.97%
0116667$59,102.61$0.00$103.63$103.63$169.74$0.00$18,283.39$4,496.25$9,374.04$32,153.68$4,038.85$36,465.9061.70%
0129393$76,109.40$0.00$664.20$664.20$641.24$57,464.47$39,327.63$6,287.39$5,381.75$108,461.24$14,347.62$124,114.30163.07%
01755$3,121.60$0.00$2.00$2.00$0.00$0.00$0.00$344.90$228.35$573.25$924.09$1,499.3448.03%
01812$1,365.60$0.00$0.80$0.80$0.00$0.00$0.00$0.00$10.90$10.90$0.00$11.700.86%
0191212$6,867.52$0.00$4.80$4.80$9.43$0.00$0.00$0.00$1,024.44$1,024.44$1,179.12$2,217.7932.29%
020411$4,724.28$0.00$4.40$4.40$9.43$0.00$39,074.07$12.22$5,281.78$44,368.07$283.15$44,665.05945.44%
0235050$31,216.00$0.00$20.00$20.00$150.88$0.00$454.65$290.54$901.32$1,646.51$966.52$2,783.918.92%
024515$6,089.88$0.00$6.00$6.00$9.43$0.00$0.00$0.00$117.71$117.71$0.00$133.142.19%
C2300$0.00$0.00($1.20)($1.20)$0.00$0.00$0.00$0.00$0.00$0.00$0.00($1.20)0.00%
R0799$11,650.52$0.00$18.92$18.92$0.00$0.00$0.00$87.03$397.19$484.22$4,481.79$4,984.9342.79%
R0855$5,073.96$0.00$43.08$43.08$18.86$0.00$0.00$68.52$280.35$348.87$251.94$662.7513.06%
R1146$5,109.56$0.00$8.76$8.76$18.86$0.00$0.00$136.08$0.00$136.08$3,081.49$3,245.1963.51%
R1233$2,536.98$0.00$21.54$21.54$18.86$0.00$0.00$0.00$0.00$0.00$3,273.65$3,314.05130.63%
Total409440$344,898.61$0.00$1,739.77$1,739.77$1,791.70$84,560.15$106,969.75$21,207.06$77,518.35$290,255.31$78,575.50$372,362.28107.96%
Avg1920$15,677.21$0.00$79.08$79.08$81.44$3,843.64$4,862.26$963.96$3,523.56$13,193.42$3,571.61$16,925.56107.96%
20250500144$3,328.72$0.00$5.84$5.84$9.43$0.00$80.88$142.20$0.00$223.08$2,059.08$2,297.4369.02%
0021010$8,456.60$0.00$71.80$71.80$66.01$0.00$7,954.95$3,989.55$773.49$12,717.99$5,922.31$18,778.11222.05%
00433$2,536.98$0.00$21.54$21.54$9.43$0.00$0.00$0.00$83.52$83.52$3,813.21$3,927.70154.82%
0051111$9,153.98$0.00$16.06$16.06$18.86$0.00$1,910.00$338.91$692.01$2,940.92$4,261.53$7,237.3779.06%
0061719$16,185.98$0.00$136.42$136.42$113.16$0.00$2,540.88$2,579.53$979.19$6,099.60($835.88)$5,513.3034.06%
0073640$31,423.16$0.00$58.40$58.40$84.87$0.00$7,230.35$1,237.05$10,347.02$18,814.42$5,573.76$24,531.4578.07%
0086064$51,543.02$0.00$459.52$459.52$424.35$0.00$27,283.18$4,026.85$1,305.90$32,615.93$7,179.06$40,678.8678.92%
00911$832.18$0.00$1.46$1.46$0.00$0.00$0.00$0.00$1,372.67$1,372.67$0.00$1,374.13165.12%
0101111$9,302.26$0.00$78.98$78.98$66.01$0.00$0.00$492.13$246.31$738.44$425.84$1,309.2714.07%
0116566$56,488.40$0.00$97.82$97.82$150.88$0.00$13,843.87$5,696.08$3,626.69$23,166.64$6,274.22$29,689.5652.56%
0129393$78,646.38$0.00$693.98$693.98$650.67$0.00$3,999.86$12,020.73$6,482.10$22,502.69$39,660.13$63,507.4780.75%
01755$3,121.60$0.00$2.00$2.00$0.00$0.00$0.00$5.13$0.00$5.13$1,579.66$1,586.7950.83%
01812$1,365.60$0.00$0.80$0.80$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.800.06%
0191212$7,491.84$0.00$4.80$4.80$9.43$0.00$0.00$78.70$1,267.98$1,346.68$1,024.32$2,385.2331.84%
020411$4,724.28$0.00$4.40$4.40$9.43$0.00$7,410.08$1,108.59$150.01$8,668.68($34.44)$8,648.07183.06%
0235050$31,216.00$0.00$20.00$20.00$122.59$0.00$21,441.48$2,315.28$3,014.99$26,771.75$972.46$27,886.8089.33%
024515$6,089.88$0.00$6.00$6.00$18.86$0.00$0.00$0.00$986.92$986.92$822.98$1,834.7630.13%
C2300$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%
R0799$4,160.90$0.00$14.60$14.60$0.00$0.00$2,330.35$122.71$810.81$3,263.87$4,115.88$7,394.35177.71%
R0855$1,691.32$0.00$43.08$43.08$18.86$0.00$0.00$47.61$616.34$663.95$697.68$1,423.5784.17%
R1146$5,109.56$0.00$8.76$8.76$18.86$0.00$2,676.00$375.28$150.06$3,201.34$2,992.01$6,220.97121.75%
R1222$1,691.32$0.00$14.36$14.36$18.86$0.00$0.00$52.20$0.00$52.20$520.29$605.7135.81%
Total408439$334,559.96$0.00$1,760.62$1,760.62$1,810.56$0.00$98,701.88$34,628.53$32,906.01$166,236.42$87,024.10$256,831.7076.77%
Avg1920$15,207.27$0.00$80.03$80.03$82.30$0.00$4,486.45$1,574.02$1,495.73$7,556.20$3,955.64$11,674.1776.77%
20250600144$3,328.72$0.00$5.84$5.84$29.91$0.00$1,767.00$370.76$695.34$2,833.10$18.19$2,887.0486.73%
0021010$8,456.60$0.00$71.80$71.80$49.85$0.00$3,303.95$3,130.58$1,434.55$7,869.08$7,173.74$15,164.47179.32%
00433$2,536.98$0.00$21.54$21.54$9.97$0.00$0.00$186.41$228.35$414.76$3,813.21$4,259.48167.90%
0051111$9,153.98$0.00$16.06$16.06$19.94$0.00$3,902.00$0.00$1,202.02$5,104.02$1,074.20$6,214.2267.89%
0061719$16,185.98$0.00$136.42$136.42$109.67$74,954.22$4,189.21$10,000.21$7,719.76$96,863.40$1,055.48$98,164.97606.48%
0073640$31,423.16$0.00$58.40$58.40$109.67$0.00$6,908.00$2,463.61$2,012.35$11,383.96$3,838.66$15,390.6948.98%
0086266$54,925.66$0.00$473.88$473.88$438.68$0.00$2,163.57$2,919.65$3,255.16$8,338.38$18,390.00$27,640.9450.32%
00911$832.18$0.00$1.46$1.46$0.00$0.00$426.00$103.68$0.00$529.68$0.00$531.1463.83%
0101111$9,302.26$0.00$78.98$78.98$79.76$0.00$0.00$114.01$1,049.21$1,163.22$1,252.80$2,574.7627.68%
0116566$52,327.50$0.00$89.06$89.06$239.28$9,245.18$5,802.82$6,827.43$4,831.34$26,706.77$4,925.64$31,960.7561.08%
0129292$77,800.72$0.00$709.17$709.17$687.93$0.00$9,207.04$3,362.65$6,889.35$19,459.04$14,499.07$35,355.2145.44%
01755$3,121.60$0.00$2.00$2.00$0.00$0.00$207.20$202.84$19.88$429.92$1,075.36$1,507.2848.29%
01812$1,365.60$0.00$0.80$0.80$0.00$0.00$0.00$0.00$89.54$89.54$0.00$90.346.62%
0191212$7,491.84$0.00$4.80$4.80$19.94$0.00$0.00$0.00$1,566.53$1,566.53$4,043.98$5,635.2575.22%
020411$4,724.28$0.00$4.40$4.40$19.94$0.00$394.00$558.83$1,108.89$2,061.72$1,313.81$3,399.8771.97%
0235050$30,591.68$0.00$19.60$19.60$169.49$0.00$336.86$110.06$0.00$446.92$1,019.01$1,655.025.41%
024515$6,089.88$0.00$6.00$6.00$9.97$0.00$0.00$107.31$821.46$928.77$1,884.56$2,829.3046.46%
R0799$7,489.62$0.00$8.76$8.76$0.00$0.00$0.00$574.96$132.68$707.64$5,615.99$6,332.3984.55%
R0855$3,382.64$0.00$14.36$14.36$29.91$0.00$0.00$1.80$522.26$524.06$25.97$594.3017.57%
R1146$5,109.56$0.00$8.76$8.76$19.94$0.00$0.00$90.26$0.00$90.26$2,542.13$2,661.0952.08%
R1222$1,691.32$0.00$14.36$14.36$9.97$0.00$0.00$0.00$0.00$0.00$520.29$544.6232.20%
Total409440$337,331.76$0.00$1,746.45$1,746.45$2,053.82$84,199.40$38,607.65$31,125.05$33,578.67$187,510.77$74,082.09$265,393.1378.67%
Avg1921$16,063.42$0.00$83.16$83.16$97.80$4,009.50$1,838.46$1,482.15$1,598.98$8,929.08$3,527.72$12,637.7778.67%
20250700144$3,328.72$0.00$6.84$6.84$29.91$0.00$1,767.00$723.96$0.00$2,490.96$2,068.37$4,596.08138.07%
0021010$8,456.60$0.00$74.35$74.35$49.85$0.00$4,346.98$840.36$2,161.46$7,348.80$4,591.57$12,064.57142.66%
00433$2,536.98$0.00$22.29$22.29$9.97$0.00$0.00$0.00$103.52$103.52$7,626.42$7,762.20305.96%
0051111$9,153.98$0.00$18.81$18.81$19.94$0.00$636.58$1,848.53$228.35$2,713.46$1,076.75$3,828.9641.83%
0061719$16,185.98$0.00$141.17$141.17$119.64$0.00$740.00$2,932.32$556.77$4,229.09$505.28$4,995.1830.86%
0073741$32,255.34$0.00$69.91$69.91$109.67$0.00$20,457.35$3,215.30$1,627.76$25,300.41$10,802.45$36,282.44112.49%
0086367$54,925.66$0.00$497.21$497.21$438.68$0.00$6,710.22$4,683.53$19,622.62$31,016.37$15,765.62$47,717.8886.88%
00911$832.18$0.00$1.71$1.71$0.00$0.00$0.00$0.00$0.00$0.00$0.00$1.710.21%
0101111$9,302.26$0.00$81.73$81.73$79.76$0.00$0.00$177.57$401.18$578.75$1,318.54$2,058.7822.13%
0116567$56,546.64$0.00$113.01$113.01$239.28$114,383.81$21,246.80$11,686.27$4,201.36$151,518.24$7,866.23$159,736.76282.49%
0129698$81,927.56$0.00$829.44$829.44$687.93$0.00$10,141.14$3,082.16$4,335.29$17,558.59$40,551.12$59,627.0872.78%
01755$3,121.60$0.00$2.00$2.00$0.00$0.00$0.00$1.24$192.86$194.10$7.21$203.316.51%
01812$1,365.60$0.00$0.80$0.80$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.800.06%
0191313$8,116.16$0.00$5.20$5.20$19.94$0.00$0.00$66.13$1,393.88$1,460.01$2,986.28$4,471.4355.09%
020411$4,724.28$0.00$4.40$4.40$19.94$0.00$1,678.44$3,223.58$471.64$5,373.66$1,380.44$6,778.44143.48%
0235252$31,216.00$0.00$20.00$20.00$169.49$22,785.28$2,010.44$1,975.69$2,473.68$29,245.09$1,037.36$30,471.9497.62%
024617$6,089.88$0.00$6.00$6.00$0.00$0.00$0.00$0.48$0.00$0.48($8.06)($1.58)-0.03%
C2300$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%
R0799$7,489.62$0.00$15.39$15.39$0.00$0.00$1,679.68$658.44$303.60$2,641.72$4,391.11$7,048.2294.11%
R0855$4,228.30$0.00$37.15$37.15$19.94$0.00$0.00$219.10$462.58$681.68$1,746.86$2,485.6358.79%
R1146$5,109.56$0.00$10.26$10.26$19.94$0.00$13,613.00$895.20$1,111.63$15,619.83$4,088.44$19,738.47386.30%
R1222$1,691.32$0.00$14.96$14.96$9.97$0.00$163.00$0.00$0.00$163.00$567.52$755.4544.67%
Total419454$348,604.22$0.00$1,972.63$1,972.63$2,043.85$137,169.09$85,190.63$36,229.86$39,648.18$298,237.76$108,369.51$410,623.75117.79%
Avg1921$15,845.65$0.00$89.67$89.67$92.90$6,234.96$3,872.30$1,646.81$1,802.19$13,556.26$4,925.89$18,664.72117.79%
20250800144$3,328.72$0.00$6.04$6.04$29.91$0.00$1,767.00$197.54$501.69$2,466.23$1,960.94$4,463.12134.08%
0021010$8,456.60$0.00$72.30$72.30$49.85$0.00$2,120.00$591.29$1,171.30$3,882.59$4,071.47$8,076.2195.50%
00433$2,536.98$0.00$21.69$21.69$9.97$0.00$0.00$0.00$0.00$0.00$3,831.84$3,863.50152.29%
0051111$9,153.98$0.00$16.61$16.61$19.94$0.00$0.00$872.11$650.53$1,522.64$4,289.36$5,848.5563.89%
0061719$16,185.98$0.00$137.37$137.37$109.67$0.00$1,588.00$3,170.24$69.94$4,828.18$30.64$5,105.8631.54%
0073741$32,255.34$0.00$61.91$61.91$109.67$0.00$17,720.71$1,568.65$1,220.09$20,509.45$6,761.49$27,442.5285.08%
0086165$54,080.00$0.00$477.18$477.18$468.59$0.00$9,295.00$4,442.06$4,934.80$18,671.86$17,189.86$36,807.4968.06%
00911$832.18$0.00$1.51$1.51$0.00$0.00$0.00$56.18$1.80$57.98$0.00$59.497.15%
0101111$9,302.26$0.00$79.53$79.53$79.76$0.00$383.48$268.00$385.81$1,037.29$1,216.71$2,413.2925.94%
0116365$54,882.28$0.00$98.15$98.15$249.25$35,573.37$18,266.83$54,251.85$5,589.47$113,681.52$7,123.47$121,152.39220.75%
0129698$81,927.56$0.00$768.86$768.86$687.93$0.00$3,409.37$4,067.46$9,793.07$17,269.90$28,310.27$47,036.9657.41%
01755$3,121.60$0.00$2.00$2.00$0.00$0.00$0.00$235.12$47.80$282.92$2,298.26$2,583.1882.75%
01812$1,365.60$0.00$0.80$0.80$0.00$0.00$0.00$0.00$0.00$0.00$292.32$293.1221.46%
0191212$7,491.84$0.00$4.80$4.80$19.94$0.00$0.00$0.00$366.01$366.01$915.38$1,306.1317.43%
020411$4,724.28$0.00$4.40$4.40$19.94$0.00$283.53$1,090.57$1,330.24$2,704.34$1,421.17$4,149.8587.84%
0235151$31,840.32$0.00$21.60$21.60$149.55$0.00$540.81$1,943.14$3,458.22$5,942.17$2,940.24$9,053.5628.43%
024719$9,448.56$0.00$8.40$8.40$0.00$0.00$0.00$0.00$4.51$4.51$918.82$931.739.86%
R0799$7,489.62$0.00$13.59$13.59$0.00$0.00$258.00$522.58$229.61$1,010.19$3,987.35$5,011.1366.91%
R0855$4,228.30$0.00$36.15$36.15$19.94$0.00$0.00$0.00$71.69$71.69$897.68$1,025.4624.25%
R1146$5,109.56$0.00$9.06$9.06$19.94$0.00$0.00$266.79$0.00$266.79$502.96$798.7515.63%
R1222$1,691.32$0.00$14.46$14.46$9.97$0.00$0.00$607.65$0.00$607.65$520.29$1,152.3768.13%
Total414450$349,452.88$0.00$1,856.41$1,856.41$2,053.82$35,573.37$55,632.73$74,151.23$29,826.58$195,183.91$89,480.52$288,574.6682.58%
Avg2021$16,640.61$0.00$88.40$88.40$97.80$1,693.97$2,649.18$3,531.01$1,420.31$9,294.47$4,260.98$13,741.6582.58%
20250900144$3,328.72$0.00$6.04$6.04$29.70$0.00$0.00$287.79$0.00$287.79$1,027.42$1,350.9540.58%
00299$7,610.94$0.00$72.30$72.30$49.50$0.00$0.00$1,471.78$1,456.87$2,928.65$4,757.64$7,808.09102.59%
00433$2,536.98$0.00$21.69$21.69$9.90$0.00$0.00$0.00$47.61$47.61$3,813.21$3,892.41153.43%
0051111$9,153.98$0.00$16.61$16.61$19.80$0.00$3,165.00$307.04$527.78$3,999.82$1,639.20$5,675.4362.00%
0061618$15,340.32$0.00$130.14$130.14$108.90$0.00$20,608.92$3,003.37$2,771.06$26,383.35$90.06$26,712.45174.13%
0073741$32,255.34$0.00$61.91$61.91$108.90$14,851.76$7,623.75$4,274.64$2,087.84$28,837.99$5,510.71$34,519.51107.02%
0086162$51,644.48$0.00$475.64$475.64$435.60$0.00$506.16$4,038.03$15,619.79$20,163.98$9,261.75$30,336.9758.74%
00911$832.18$0.00$1.51$1.51$0.00$0.00$0.00$0.00$0.00$0.00$0.00$1.510.18%
0101010$9,302.26$0.00$79.53$79.53$79.20$0.00$3,348.89$1,714.42$290.55$5,353.86$1,214.11$6,726.7072.31%
0116264$51,553.56$0.00$93.62$93.62$247.50$0.00$11,853.50$37,704.03$14,087.13$63,644.66$5,075.71$69,061.49133.96%
01298100$81,081.90$0.00$814.91$814.91$693.00$0.00$7,110.00$3,933.84$3,618.05$14,661.89$38,950.27$55,120.0767.98%
01755$3,121.60$0.00$2.00$2.00$0.00$0.00$2,981.59$297.74$1,167.64$4,446.97$11.28$4,460.25142.88%
01812$1,365.60$0.00$0.80$0.80$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.800.06%
0191212$7,491.84$0.00$4.80$4.80$19.80$0.00$548.77$315.62$47.79$912.18$0.00$936.7812.50%
020411$4,724.28$0.00$4.40$4.40$19.80$0.00$319.68$362.76$674.30$1,356.74$1,525.66$2,906.6061.52%
0235151$33,713.28$0.00$20.40$20.40$148.50$0.00$4,376.49$4,814.88$17,369.03$26,560.40$1,161.86$27,891.1682.73%
024719$8,329.00$0.00$7.60$7.60$0.00$0.00$976.80$14.75$1,309.21$2,300.76$890.33$3,198.6938.40%
C0611$845.66$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000.00%
R0788$6,657.44$0.00$12.08$12.08$0.00$0.00($55.02)$148.88$115.18$209.04$2,534.50$2,755.6241.39%
R0855$4,228.30$0.00$36.15$36.15$19.80$0.00$246.89$171.35$0.00$418.24$962.18$1,436.3733.97%
R1146$5,109.56$0.00$9.06$9.06$19.80$0.00$0.00$0.00$76.64$76.64$3,226.96$3,332.4665.22%
R1222$1,691.32$0.00$14.46$14.46$9.90$0.00$0.00$0.00$0.00$0.00$0.00$24.361.44%
Total412445$341,918.54$0.00$1,885.65$1,885.65$2,019.60$14,851.76$63,611.42$62,860.92$61,266.47$202,590.57$81,652.85$288,148.6784.27%
Avg1920$15,541.75$0.00$85.71$85.71$91.80$675.08$2,891.43$2,857.31$2,784.84$9,208.66$3,711.49$13,097.6784.27%
20251000144$3,578.40$0.00$6.04$6.04$29.70$0.00$0.00$215.14$558.83$773.97$2,103.95$2,913.6681.42%
00299$9,090.80$0.00$65.07$65.07$69.30$0.00$1,588.00$532.03$976.85$3,096.88$25,461.15$28,692.40315.62%
00433$2,727.24$0.00$21.69$21.69$19.80$0.00$0.00$0.00$376.03$376.03$3,813.21$4,230.73155.13%
0051212$10,735.20$0.00$18.12$18.12$19.80$0.00$0.00$416.71$689.86$1,106.57$2,065.78$3,210.2729.90%
0061618$16,490.80$0.00$130.14$130.14$99.00$0.00$0.00$5,652.08$775.40$6,427.48$202.20$6,858.8241.59%
0073842$35,569.32$0.00$63.42$63.42$108.90$0.00$4,076.00$3,117.23$2,068.42$9,261.65$3,837.36$13,271.3337.31%
0086061$55,517.56$0.00$469.79$469.79$455.40$11,578.66$2,803.77$5,444.39$12,034.43$31,861.25$6,463.22$39,249.6670.70%
00911$894.60$0.00$1.51$1.51$0.00$0.00$0.00$56.18$1.80$57.98$0.00$59.496.65%
0101010$9,999.88$0.00$79.53$79.53$89.10$0.00$0.00$129.01$1,155.74$1,284.75$319.09$1,772.4717.72%
0116465$58,211.60$0.00$96.64$96.64$267.30$0.00$30,083.63$19,945.73$8,828.78$58,858.14$12,007.98$71,230.06122.36%
012101103$95,154.08$0.00$848.00$848.00$762.30$0.00$9,863.72$7,101.07$4,832.06$21,796.85$33,140.98$56,548.1359.43%
01755$3,355.70$0.00$2.00$2.00$0.00$0.00$0.00$1,029.50$1,108.83$2,138.33$174.16$2,314.4968.97%
01800$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%
0191212$8,053.68$0.00$4.80$4.80$19.80$0.00$0.00$0.00$0.00$0.00$0.00$24.600.31%
020411$5,078.64$0.00$4.40$4.40$19.80$0.00$2,031.20$619.80$1,036.98$3,687.98$1,815.00$5,527.18108.83%
0234949$32,214.72$0.00$19.20$19.20$158.40$0.00$1,034.23$745.24$391.53$2,171.00$2,843.14$5,191.7416.12%
024821$10,421.76$0.00$8.40$8.40$0.00$0.00$2,455.99$609.88$713.99$3,779.86$833.35$4,621.6144.35%
C0611$909.08$0.00$14.46$14.46$0.00$0.00$0.00$0.00$721.35$721.35$59.59$795.4087.50%
R0788$7,156.80$0.00$12.08$12.08$0.00$0.00$4,096.31$458.91$2,200.84$6,756.06$6,820.63$13,588.77189.87%
R0855$4,545.40$0.00$36.15$36.15$19.80$0.00$0.00$388.49$0.22$388.71$1,087.52$1,532.1833.71%
R1146$5,492.80$0.00$9.06$9.06$19.80$0.00$0.00$135.08$0.00$135.08$5,257.29$5,421.2398.70%
R1233$909.08$0.00$14.46$14.46$19.80$0.00$0.00$0.00$0.00$0.00$567.52$601.7866.20%
Total417449$376,107.14$0.00$1,924.96$1,924.96$2,178.00$11,578.66$58,032.85$46,596.47$38,471.94$154,679.92$108,873.12$267,656.0071.16%
Avg1920$17,095.78$0.00$87.50$87.50$99.00$526.30$2,637.86$2,118.02$1,748.72$7,030.91$4,948.78$12,166.1871.16%
20251100144$3,578.40$0.00$5.64$5.64$29.70$0.00$0.00$0.00$105.34$105.34$1,193.09$1,333.7737.27%
00299$9,090.80$0.00$71.30$71.30$59.40$0.00$0.00$1,424.19$320.48$1,744.67$4,295.00$6,170.3767.87%
00433$2,727.24$0.00$21.39$21.39$19.80$0.00$0.00$663.22$47.61$710.83$4,172.36$4,924.38180.56%
0051313$11,629.80$0.00$18.38$18.38$19.80$0.00$719.02$87.03$407.66$1,213.71$1,907.09$3,158.9827.16%
0061618$16,490.80$0.00$128.34$128.34$108.90$31,982.03$438.00$1,421.48$7,478.50$41,320.01$333.50$41,890.75254.02%
0073842$35,569.32$0.00$59.22$59.22$99.00$0.00$32,777.12$4,745.63$2,847.70$40,370.45$8,917.48$49,446.15139.01%
0086162$56,426.64$0.00$477.25$477.25$415.80$0.00$19,274.22$9,691.42$4,304.83$33,270.47$15,172.08$49,335.6087.43%
00911$894.60$0.00$1.41$1.41$0.00$0.00$0.00$0.00$0.00$0.00$8.36$9.771.09%
0101010$7,399.48$0.00$56.84$56.84$79.20$0.00$1,751.00$181.51$394.52$2,327.03$372.08$2,835.1538.32%
0116769$60,000.80$0.00$96.08$96.08$257.40$0.00$914.88$34,105.93$10,585.89$45,606.70$5,884.02$51,844.2086.41%
0129799$88,980.78$0.00$822.96$822.96$742.50$49,749.11$3,625.11$6,655.62$10,834.84$70,864.68$4,483.71$76,913.8586.44%
01755$3,355.70$0.00$2.00$2.00$0.00$0.00$0.00$216.94$448.08$665.02$178.42$845.4425.19%
0191212$8,053.68$0.00$4.80$4.80$0.00$0.00$0.00$0.00$316.88$316.88$0.00$321.683.99%
020411$5,078.64$0.00$4.40$4.40$0.00$0.00$0.00$495.88$822.95$1,318.83$3,248.56$4,571.7990.02%
0234949$31,543.58$0.00$19.20$19.20$0.00$0.00$3,277.37$1,060.06$2,657.24$6,994.67$2,214.69$9,228.5629.26%
024716$10,421.76$0.00$6.40$6.40$0.00$0.00$0.00$952.73$0.00$952.73($790.33)$168.801.62%
C0611$909.08$0.00$7.13$7.13$0.00$0.00$1,588.00$512.76$258.31$2,359.07$0.00$2,366.20260.29%
C2300$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%
R0788$7,156.80$0.00$11.28$11.28$0.00$62,617.00$0.00$1,165.24$1,807.39$65,589.63$4,786.95$70,387.86983.51%
R0855$4,545.40$0.00$35.65$35.65$19.80$0.00$165.63$267.33$1,207.16$1,640.12$928.18$2,623.7557.72%
R1146$5,492.80$0.00$8.46$8.46$19.80$0.00$0.00$106.45($458.91)($352.46)$3,470.71$3,146.5157.28%
R1233$1,818.16$0.00$14.26$14.26$9.90$0.00$0.00$100.20$0.00$100.20$520.29$644.6535.46%
Total417446$371,164.26$0.00$1,872.39$1,872.39$1,881.00$144,348.14$64,530.35$63,853.62$44,386.47$317,118.58$61,296.24$382,168.21102.96%
Avg1920$16,871.10$0.00$85.11$85.11$85.50$6,561.28$2,933.20$2,902.44$2,017.57$14,414.48$2,786.19$17,371.28102.96%
20251200144$3,578.40$0.00$5.84$5.84$24.18$0.00$0.00$349.84$0.00$349.84$1,116.84$1,496.7041.83%
00299$6,363.56$0.00$71.80$71.80$48.36$0.00$0.00$753.20$1,489.49$2,242.69$27,645.08$30,007.93471.56%
00433$2,727.24$0.00$21.54$21.54$16.12$0.00$9,995.00$1,294.42$749.35$12,038.77$3,813.21$15,889.64582.63%
0051313$11,629.80$0.00$18.98$18.98$16.12$0.00$2,889.06$1,434.77$1,843.99$6,167.82$1,446.07$7,648.9965.77%
0061618$16,490.80$0.00$129.24$129.24$88.66$0.00$0.00$1,042.20$666.34$1,708.54$286.27$2,212.7113.42%
0073842$35,569.32$0.00$61.32$61.32$72.54$265,077.57$15,949.90$11,080.59$7,554.91$299,662.97$10,294.88$310,091.71871.80%
0086263$57,335.72$0.00$478.46$478.46$346.58$0.00$15,048.30$5,476.62$17,645.28$38,170.20$14,145.12$53,140.3692.68%
00911$894.60$0.00$1.46$1.46$0.00$0.00$0.00$0.00$0.00$0.00$8.36$9.821.10%
0101010$9,090.80$0.00$71.80$71.80$48.36$0.00$0.00$760.15$630.02$1,390.17$218.81$1,729.1419.02%
0116668$62,469.92$0.00$97.82$97.82$381.33$10,435.00$48,997.38$18,118.77$5,274.61$82,825.76$5,568.34$88,873.25142.27%
0129395$91,708.02$0.00$747.05$747.05$1,187.42$0.00$4,415.03$2,719.76$3,082.13$10,216.92$29,864.86$42,016.2545.82%
01755$3,355.70$0.00$2.00$2.00$0.00$0.00$1,127.20$447.53$317.95$1,892.68$174.16$2,068.8461.65%
01800$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%
0191212$8,053.68$0.00$4.80$4.80$8.06$0.00$0.00$0.00$102.28$102.28$0.00$115.141.43%
020411$5,078.64$0.00$4.40$4.40$16.12$0.00$0.00$209.58$1,808.03$2,017.61$185.41$2,223.5443.78%
0234848$32,214.72$0.00$18.80$18.80$120.90$3,006.35$4,353.33$2,816.06$73,069.06$83,244.80$2,249.03$85,633.53265.82%
024920$10,686.24$0.00$7.20$7.20$8.06$0.00$0.00$649.86$303.21$953.07$0.00$968.339.06%
C0611$909.08$0.00$7.18$7.18$8.06$0.00$494.71$0.00$538.27$1,032.98$1,319.63$2,367.85260.47%
R0788$7,156.80$0.00$11.68$11.68$0.00$0.00$2,680.54$7,436.16$2,536.27$12,652.97$4,998.68$17,663.33246.80%
R0855$4,545.40$0.00$35.90$35.90$16.12$0.00$385.06$2,057.02$408.26$2,850.34$1,006.03$3,908.3985.99%
R1146$5,492.80$0.00$8.76$8.76$16.12$0.00$1,851.00$510.84$600.64$2,962.48$6,909.98$9,897.34180.19%
R1233$2,727.24$0.00$14.36$14.36$16.12$0.00$0.00$171.02$131.38$302.40$520.29$853.1731.28%
Total414445$378,078.48$0.00$1,820.39$1,820.39$2,439.23$278,518.92$108,186.51$57,328.39$118,751.47$562,785.29$111,771.05$678,815.96179.54%
Avg1920$17,185.39$0.00$82.75$82.75$110.87$12,659.95$4,917.57$2,605.84$5,397.79$25,581.15$5,080.50$30,855.27179.54%
20260100144$3,578.40$0.00$5.84$5.84$24.18$0.00$3,618.00$53.74$3.80$3,675.54$909.71$4,615.27128.98%
00299$8,181.72$0.00$7.56$7.56$48.36$0.00$0.00$164.79$526.99$691.78$1,529.86$2,277.5627.84%
00433$2,727.24$0.00$3.78$3.78$16.12$0.00$0.00$0.00$573.64$573.64$0.00$593.5421.76%
0051313$11,629.80$0.00$18.98$18.98$16.12$0.00$6,772.26$534.61$2,081.92$9,388.79$1,023.80$10,447.6989.84%
0061618$16,490.80$0.00$22.68$22.68$88.66$0.00$0.00$2,765.14$475.37$3,240.51$88.19$3,440.0420.86%
0073842$35,569.32$0.00$61.72$61.72$80.60$0.00$4,994.93$6,600.33$18,850.01$30,445.27$5,551.69$36,139.28101.60%
0086162$56,426.64$0.00$78.12$78.12$378.82$0.00$6,243.18$2,199.59$10,603.13$19,045.90$14,799.72$34,302.5660.79%
00911$894.60$0.00$1.46$1.46$0.00$0.00$0.00$172.53$1.80$174.33$17.67$193.4621.63%
0101010$9,090.80$0.00$12.60$12.60$48.36$0.00$0.00$0.00$75.16$75.16$194.56$330.683.64%
0116971$63,471.86$0.00$100.74$100.74$389.39$0.00$50,815.64$3,452.98$2,286.03$56,554.65$10,958.65$68,003.43107.14%
0129193$81,708.14$0.00$112.60$112.60$636.74$0.00$10,789.11$7,191.22$3,483.77$21,464.10$10,045.52$32,258.9639.48%
01755$3,355.70$0.00$2.00$2.00$0.00$0.00$556.33$1.20$92.10$649.63$174.16$825.7924.61%
0191212$8,053.68$0.00$4.80$4.80$8.06$0.00$0.00$75.72$0.00$75.72$0.00$88.581.10%
020411$5,078.64$0.00$4.40$4.40$16.12$0.00$0.00$209.58$519.29$728.87$996.15$1,745.5434.37%
0235050$30,872.44$0.00$18.80$18.80$120.90$0.00$25,553.46$2,799.19$2,425.14$30,777.79$2,097.02$33,014.51106.94%
024818$9,482.70$0.00$8.80$8.80$16.12$0.00$0.00$20.49$395.29$415.78$0.00$440.704.65%
C0611$909.08$0.00$1.26$1.26$8.06$0.00$0.00$0.00$131.38$131.38$193.19$333.8936.73%
R0788$7,156.80$0.00$11.68$11.68$0.00$0.00$306.52$645.88$4,651.33$5,603.73$1,763.05$7,378.46103.10%
R0855$4,545.40$0.00$6.30$6.30$16.12$0.00$20,738.32$2,324.97$0.00$23,063.29$846.84$23,932.55526.52%
R1146$5,492.80$0.00$8.76$8.76$16.12$0.00$0.00$0.00$63.03$63.03$487.05$574.9610.47%
R1222$1,818.16$0.00$3.12$3.12$16.12$0.00$0.00$50.40$0.00$50.40$567.52$637.1635.04%
Total414444$366,534.72$0.00$496.00$496.00$1,944.97$0.00$130,387.75$29,262.36$47,239.18$206,889.29$52,244.35$261,574.6171.36%
Avg2021$17,454.03$0.00$23.62$23.62$92.62$0.00$6,208.94$1,393.45$2,249.48$9,851.87$2,487.83$12,455.9371.36%
20260200144$3,578.40$0.00$5.84$5.84$24.18$0.00$0.00$5.45$0.00$5.45$1,289.40$1,324.8737.02%
00299$8,181.72$0.00$102.30$102.30$48.36$0.00$0.00$2,361.87$982.98$3,344.85$3,469.57$6,965.0885.13%
00433$2,727.24$0.00$40.02$40.02$16.12$0.00$0.00$100.85$25.86$126.71$0.00$182.856.70%
0051212$10,735.20$0.00$18.98$18.98$16.12$0.00$479.35$190.35$1,367.76$2,037.46$1,777.91$3,850.4735.87%
0061618$16,490.80$0.00$240.12$240.12$88.66$0.00$1,976.35$1,528.90$1,198.02$4,703.27$68.40$5,100.4530.93%
0073741$35,569.32$0.00$60.92$60.92$80.60$139,279.30$3,657.30$2,830.94$6,618.10$152,385.64$6,483.44$159,010.60447.04%
0086061$55,517.56$0.00$819.78$819.78$346.58$18,596.18$1,247.13$4,156.58$2,953.63$26,953.52$6,249.68$34,369.5661.91%
00911$894.60$0.00$1.46$1.46$0.00$0.00$0.00$0.00$0.00$0.00$17.67$19.132.14%
0101010$9,090.80$0.00$133.40$133.40$48.36$0.00$0.00$138.33$461.62$599.95$194.56$976.2710.74%
0116668$61,682.66$0.00$99.28$99.28$381.33$17,484.41$2,446.93$3,677.10$1,794.99$25,403.43$1,819.68$27,703.7244.91%
0128991$78,071.82$0.00$1,183.52$1,183.52$556.14$0.00$7,868.38$3,192.08$3,439.29$14,499.75$16,210.17$32,449.5841.56%
01755$3,355.70$0.00$2.00$2.00$0.00$0.00$556.19$237.26$1,125.34$1,918.79$870.37$2,791.1683.18%
01800$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%
0191212$8,053.68$0.00$4.80$4.80$8.06$0.00$0.00$0.00$0.00$0.00$0.00$12.860.16%
020411$5,078.64$0.00$4.40$4.40$16.12$0.00$32,678.53$2,081.33$735.55$35,495.41$1,079.51$36,595.44720.58%
0235050$32,214.72$0.00$18.80$18.80$112.84$0.00$5,448.70$235.30$1,436.49$7,120.49$994.70$8,246.8325.60%
024818$14,296.86$0.00$8.00$8.00$24.18$0.00$0.00$0.00$618.78$618.78$19.55$670.514.69%
03111$894.60$0.00$1.46$1.46$0.00$0.00$0.00$0.00$0.00$0.00$0.00$1.460.16%
03211$671.14$0.00$0.40$0.40$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.400.06%
C0611$909.08$0.00$13.34$13.34$8.06$0.00$0.00$0.00$131.66$131.66$0.00$153.0616.84%
R0799$7,156.80$0.00$11.68$11.68$0.00$0.00$2,164.88$817.05$10,316.27$13,298.20$4,070.42$17,380.30242.85%
R0855$4,545.40$0.00$66.70$66.70$16.12$0.00$0.00$163.14$1,106.37$1,269.51$996.50$2,348.8351.67%
R1146$5,492.80$0.00$8.76$8.76$16.12$0.00$1,074.79$592.70$384.30$2,051.79$3,073.33$5,150.0093.76%
R1222$4,545.40$0.00$46.56$46.56$16.12$0.00$0.00$407.65$0.00$407.65$331.29$801.6217.64%
Total409439$369,754.94$0.00$2,892.52$2,892.52$1,824.07$175,359.89$59,598.53$22,716.88$34,697.01$292,372.31$49,016.15$346,105.0593.60%
Avg1718$15,406.46$0.00$120.52$120.52$76.00$7,306.66$2,483.27$946.54$1,445.71$12,182.18$2,042.34$14,421.0493.60%
20260300144$3,578.40$0.00$5.92$5.92$29.85$0.00$0.00$77.68$0.00$77.68$1,109.71$1,223.1634.18%
00299$8,181.72$0.00$61.29$61.29$59.70$0.00$0.00$673.78$954.79$1,628.57$25,024.48$26,774.04327.24%
00433$2,727.24$0.00$20.43$20.43$19.90$0.00$0.00$0.00$200.28$200.28$13,774.40$14,015.01513.89%

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 .