Exhibit_C_Claimrun_Updated.xlsx

XLSX spreadsheet 50 KB Posted

Attached to
Group Life & Disability and Supplemental Health Benefits
Solicitation number
RFP-1-26-12
Issued by
Brevard County, Florida

About this file

Exhibit C is a claimrun spreadsheet supporting a benefits procurement for a Florida county government. The solicitation seeks a single carrier/administrator to provide group-sponsored Accident, Hospital Indemnity, and Critical Illness/Cancer coverage effective January 1, 2027. These supplemental health benefits will expand the county's current voluntary (employee-paid) offerings, which are presently administered through individual representatives from Aflac, Allstate, and Colonial Life. The county anticipates consolidating these fragmented individual products into a unified group-administered program, with only the awarded group-sponsored benefits eligible for payroll deduction and group administration beginning January 1, 2027.

The spreadsheet contains claimrun data and historical claims information relevant to the county's current supplemental health benefit utilization and cost experience. This data supports the RFP evaluation process by providing proposers and the county with baseline information on claims activity and expenses associated with the existing individual plans. Employees currently enrolled in individual Colonial, Aflac, and Allstate policies may continue those coverages on a direct-bill basis without payroll deduction or on-site enrollment support. The county maintains existing fully insured Group Term Life, AD&D, Short-Term Disability, and Long-Term Disability coverage through Standard Insurance Company under a contract effective January 1, 2019.

View the file

Other files

File Type Posted
RFQ_Selection_Committee_Consolidated_Evaluation_Scoresheet.pdf PDF
Public_Meeting_Notice.pdf PDF
RFP_Tabulation__Names_Only.pdf PDF
Addendum_2.pdf PDF
Exhibit_C___Incurred__Paid_Updated_w_BL_Breakout.xlsx XLSX spreadsheet
Exhibit_C__Offset_Report.xlsx XLSX spreadsheet
Exhibit_A__Census.xlsx XLSX spreadsheet
Exhibit_C__Offset_Key.pdf PDF
Addendum_1.pdf PDF
Exhibit_C__Incurred__Paid_Updated.pdf PDF
Exhibit_C__Brevard_Life__DI_SelfBill_2.1.26.xlsx XLSX spreadsheet
Exhibit_B__Allstate__Brevard_Fire_department.pdf PDF
Attachment_E__Draft_Contract.pdf PDF
Exhibit_C__641728_BREVARD_COUNTY_BOARD__Claimrun.pdf PDF
Attachment_C__Premium_Worksheet.xlsx XLSX spreadsheet
Exhibit_A__Census.pdf PDF
Exhibit_B__The_Standard_Life_Plan_Cert_Retirees.pdf PDF
Exhibit_B_Life_Age_Reduction_Amendment_1.1.26.pdf PDF
Exhibit_B_Aflac__Brevard_2025.pdf PDF
Exhibit_B__Colonial_Life__Brevard_2025.pdf PDF
Attachment_A__Mandatory_Requirements__Proposal_Worksheet_revised_6.4.26.docx DOCX document
Exhibit_B__The_Standard_LTD_Cert.pdf PDF
Exhibit_B_Spouse_Life_Age_Reduction_Amendment_1.1.26.pdf PDF
Exhibit_C_Incurred_vs._Paid_Exhibit.pdf PDF
Attachment_B__Plan_Design_Worksheet.xlsx XLSX spreadsheet
Exhibit_B__The_Standard_STD_Cert.pdf PDF
Exhibit_B__The_Standard_Life_and_ADD_Cert_Active_EEs.pdf PDF
Attachment_D_Certification_of_Financial_Condition.pdf PDF
INV__SPECIFICATIONS.pdf PDF
Exhibit_C__Claim_Run_Reference_Sheet.pdf PDF
Show all 30

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

641728 Claimrun

641728 BREVARD COUNTY BOARD
Group Claim Experience
1/1/2022 through 6/30/2026
THE INFORMATION IN THESE REPORTS IS CONFIDENTIAL AND PROPRIETARY. THESE REPORTS ARE TO BE ACCESSIBLE ONLY TO THOSE COMPANY
PERSONNEL WHO HAVE A LEGITIMATE BUSINESS REASON TO EXAMINE THE INFORMATION. THESE REPORTS MAY NOT BE REDISCLOSED
WITHOUT THE WRITTEN AUTHORIZATION OF STANDARD INSURANCE COMPANY.
Claim NumberGenderCoverageProductBirth DateIncurred DateApproved DateTerm DatePendingBenefitPaid
This PeriodPaid
This ClaimEnding
ReserveBeginning

Reserve

F69061MTERMALAug-86Oct-21Jan-22Jan-22100,000.00100,000.00100,000.00
F74297MTERMALOct-70Sep-21Dec-21Jan-2280,000.0080,000.0080,000.00
F81984MTERMALJan-48Feb-22Mar-22Mar-2215,000.0015,000.00
F84613FTERMALMar-64Mar-22Apr-22Apr-2290,000.0090,000.00
F86599MTERMALSep-66Mar-22May-22May-2220,000.0020,000.00
F94831FTERMALJun-96Jul-22Oct-22Jan-2350,000.0050,000.00
F98298MTERMALAug-88Sep-22Oct-22Oct-2230,000.0030,000.00
G01532MTERMALJan-88May-22Nov-22Nov-2250,000.0050,000.00
G25791MTERMALDec-63Jul-23Aug-23Sep-23150,000.00150,000.00
G27262FTERMALJun-71Jul-23Aug-23Aug-2350,000.0050,000.00
G29820FTERMALMay-67Aug-23Oct-23Oct-2360,000.0060,000.00
G33954FTERMALAug-57Oct-23Nov-23Nov-2318,400.0018,400.00
G36971MTERMALJul-47Nov-23Jan-24Jan-2410,000.0010,000.00
G44632FTERMALJul-70Mar-24Mar-24Mar-24150,000.00150,000.00
G61564MTERMALDec-54Oct-24Nov-24Nov-2460,000.0060,000.00
G62404MTERMALJun-72Oct-24Nov-24Nov-24190,000.00190,000.00
G63633FTERMALMay-75Oct-24Feb-25Feb-2570,000.0070,000.00
G67658MTERMALOct-57Nov-24Jan-25Jan-25184,800.00184,800.00
G73565MTERMALMar-61Mar-25Mar-25Mar-2550,000.0050,000.00
G90386MTERMALOct-61Oct-25Oct-25Nov-2580,000.0080,000.00
G96096FTERMALJan-57Dec-25Jan-26Jan-267,600.007,600.00
H00417MTERMALMay-74Jan-26Feb-26Feb-26100,000.00100,000.00
H03146MTERMALApr-63Mar-26Mar-26Mar-26150,000.00150,000.00
PRODUCT -AL1,765,800.001,765,800.00180,000.00
F69061MTERMBLAug-86Oct-21Jan-22Jan-2245,000.0045,000.0045,000.00
F74297MTERMBLOct-70Sep-21Jan-22Jan-2239,000.0039,000.0039,000.00
F78736MTERMBLOct-64Jan-22Feb-22Feb-2230,000.0030,000.00
F79203FTERMBLApr-61Jan-22Feb-22May-2210,000.0010,000.00
F79840FTERMBLApr-61Jan-22Feb-22Mar-2241,000.0041,000.00
F81984MTERMBLJan-48Feb-22Mar-22Mar-2230,500.0030,500.00
F84613FTERMBLMar-64Mar-22Apr-22Apr-2233,000.0033,000.00
F84614MTERMBLDec-54Mar-22Apr-22Apr-2210,000.0010,000.00
F86599MTERMBLSep-66Mar-22May-22May-2229,000.0029,000.00
F94025MTERMBLOct-96Jun-22Aug-22Aug-2246,000.0046,000.00
F94831FTERMBLJun-96Jul-22Oct-22Jan-2336,000.0036,000.00
F94992MTERMBLApr-61Jul-22Aug-22Aug-225,000.005,000.00
F95327MTERMBLNov-64Jul-22Aug-22Aug-2283,000.0083,000.00
F98298MTERMBLAug-88Sep-22Oct-22Oct-2244,000.0044,000.00
G01532MTERMBLJan-88May-22Nov-22Nov-2233,000.0033,000.00
G06563MTERMBLJun-90Dec-22Apr-23Apr-2348,000.0048,000.00
G06570MTERMBLAug-99Dec-22Jan-23Jan-2346,000.0046,000.00
G09755MTERMBLOct-47Jan-23Feb-23Feb-235,000.005,000.00
G11641MTERMBLSep-65Jan-23Mar-23Mar-2359,000.0059,000.00
G25791MTERMBLDec-63Jul-23Aug-23Sep-2352,000.0052,000.00
G27262FTERMBLJun-71Jul-23Aug-23Aug-2349,000.0049,000.00
G29820FTERMBLMay-67Aug-23Oct-23Oct-2348,000.0048,000.00
G30941MTERMBLDec-51Oct-23Oct-23Oct-235,000.005,000.00
G31508MTERMBLSep-60Sep-23Oct-23Oct-2363,000.0063,000.00
G32335FTERMBLNov-56Aug-23Nov-23Nov-2332,760.0032,760.00
G33954FTERMBLAug-57Oct-23Nov-23Nov-2349,680.0049,680.00
G34866MTERMBLJul-70Nov-23Dec-23Dec-2349,000.0049,000.00
G36971MTERMBLJul-47Nov-23Jan-24Jan-2416,500.0016,500.00
G39201FTERMBLJan-66Jan-24Jan-24Jan-2439,000.0039,000.00
G44632FTERMBLJul-70Mar-24Mar-24Mar-2454,000.0054,000.00
G59461FTERMBLNov-29Aug-24Sep-24Sep-245,000.005,000.00
G61564MTERMBLDec-54Oct-24Nov-24Nov-2416,800.0016,800.00
G62404MTERMBLJun-72Oct-24Nov-24Nov-2467,000.0067,000.00
G63633FTERMBLMay-75Oct-24Feb-25Feb-2554,000.0054,000.00
G65472FTERMBLSep-36Nov-24Dec-24Jan-255,000.005,000.00
G67658MTERMBLOct-57Nov-24Jan-25Jan-2563,000.0063,000.00
G70404MTERMBLNov-48Aug-24Feb-25Feb-255,000.005,000.00
G73565MTERMBLMar-61Mar-25Mar-25Mar-2541,000.0041,000.00
G77771MTERMBLNov-59Apr-25May-25May-2541,400.0041,400.00
G81521FTERMBLApr-33May-25Jun-25Jun-255,000.005,000.00
G81920FTERMBLJan-63Jun-25Jun-25Jun-2552,000.0052,000.00
G83192FTERMBLSep-73Jul-25Jul-25Jul-2532,000.0032,000.00
G83535FTERMBLSep-73Jul-25Jul-25Jul-2541,000.0041,000.00
G90386MTERMBLOct-61Oct-25Oct-25Nov-2583,000.0083,000.00
G93197MTERMBLSep-58Nov-25Nov-25Nov-2510,000.0010,000.00
G96096FTERMBLJan-57Dec-25Jan-26Jan-2646,360.0046,360.00
H00417MTERMBLMay-74Jan-26Feb-26Feb-2691,000.0091,000.00
H03146MTERMBLApr-63Mar-26Mar-26Mar-2651,000.0051,000.00
H06026MTERMBLJan-64Mar-26Apr-26Apr-2637,000.0037,000.00
PRODUCT -BL1,877,000.001,877,000.0084,000.00
COVERAGE -TERM3,642,800.003,642,800.00264,000.00
C19453FTPD2ALSep-57Sep-08Feb-1091,200.0059,280.0078,000.00
C34831MTPD2ALJan-59Jun-09Oct-09152,000.0098,800.00130,000.00
C54723MTPD2ALApr-63Jan-10Jun-10Mar-2697,500.00
C59609FTPD2ALJun-58Jun-09Aug-1040,800.0026,520.0039,000.00
C67225FTPD2ALAug-57Jan-10Apr-11136,000.0088,400.00130,000.00
C72986MTPD2ALNov-59Aug-10Mar-11138,000.0089,700.0097,500.00
C88766MTPD2ALSep-54Aug-10Oct-11Oct-2458,500.00
C93852FTPD2ALAug-60Jul-11Mar-1292,000.0059,800.0065,000.00
C97355MTPD2ALJul-53Jul-11Dec-11Sep-2349,400.00
D00054MTPD2ALDec-54Jul-11Apr-12Nov-2454,600.00
D30407MTPD2ALMar-68Apr-12Feb-13Jan-2458,500.00
D37273FTPD2ALJul-59Oct-12May-1375,600.0049,140.0058,500.00
D38102FTPD2ALOct-57Jan-12May-1447,600.0030,940.0045,500.00
D39135MTPD2ALNov-62Sep-12Nov-1370,000.0045,500.0045,500.00
D67831FTPD2ALDec-64Jan-14Aug-14160,000.00104,000.00104,000.00
D98454MTPD2ALSep-55Mar-15Feb-16May-2241,860.00
E04406FTPD2ALDec-56Sep-15Apr-1690,000.0058,500.0058,500.00
E21147MTPD2ALApr-63May-16Aug-17Dec-2245,500.00
E30365MTPD2ALApr-59May-16Jul-1775,600.0049,140.0058,500.00
E40024MTPD2ALApr-64Jan-17Oct-1740,000.0026,000.0026,000.00
E43126FTPD2ALSep-65Feb-17Dec-1770,000.0045,500.0045,500.00
E75759FTPD2ALMay-67Apr-18Mar-1950,000.0032,500.0032,500.00
E97152FTPD2ALFeb-64Jan-18Aug-1970,000.0045,500.0045,500.00
F20818FTPD2ALMay-70Nov-19Jul-2050,000.0032,500.0032,500.00
F52040MTPD2ALAug-88Apr-20Jul-21Sep-2219,500.00
F52272MTPD2ALJun-62Nov-20Jun-21Sep-2258,500.00
F68746FTPD2ALApr-57Apr-21Dec-21Apr-226,500.00
F80463MTPD2ALMay-77Jul-21Apr-22150,000.0097,500.00
G12028MTPD2ALDec-61Jul-22Mar-23Jul-23
G21637FTPD2ALDec-55Jan-23Jun-23Jan-24
G22395MTPD2ALOct-75Feb-23Aug-23
G27827MTPD2ALSep-68Apr-23Nov-23100,000.0065,000.00
G29569MTPD2ALApr-70Aug-23Oct-23100,000.0065,000.00
G62510MTPD2ALNov-66May-24Nov-24Aug-25
H02231FTPD2ALDec-65Feb-26Mar-2670,000.0045,500.00
H05267MTPD2ALAug-67Oct-25May-2650,000.0032,500.00
PRODUCT -AL1,247,220.001,582,360.00
C19453FTPD2BLSep-57Sep-08Feb-1019,760.0012,844.0016,900.00
C24484MTPD2BLSep-59Sep-08May-0926,000.0016,900.0016,900.00
C34831MTPD2BLJan-59Jun-09Oct-0951,680.0033,592.0044,200.00
C54723MTPD2BLApr-63Jan-10Jun-10Mar-2633,150.00
C54952FTPD2BLFeb-54Nov-09Jun-10May-2422,100.00
C59605MTPD2BLAug-58Dec-09Feb-14Dec-2427,300.00
C59609FTPD2BLJun-58Jun-09Aug-1022,440.0014,586.0021,450.00
C67225FTPD2BLAug-57Jan-10Dec-1063,240.0041,106.0060,450.00
C72986MTPD2BLNov-59Aug-10Mar-1149,680.0032,292.0035,100.00
C87814MTPD2BLFeb-52Mar-11Aug-11Feb-2215,210.00
C88766MTPD2BLSep-54Aug-10Oct-11Oct-2423,400.00
C93852FTPD2BLAug-60Jul-11Mar-1236,800.0023,920.0026,000.00
C97355MTPD2BLJul-53Jul-11Dec-11Sep-2321,736.00
D00054MTPD2BLDec-54Jul-11Apr-12Nov-2415,288.00
D30407MTPD2BLMar-68Apr-12Feb-13Jan-2414,300.00
D37273FTPD2BLJul-59Oct-12May-1329,400.0019,110.0022,750.00
D38102FTPD2BLOct-57Jan-12Mar-1422,440.0014,586.0021,450.00
D39135MTPD2BLNov-62Sep-12Sep-1328,000.0018,200.0018,200.00
D39874FTPD2BLJul-78Dec-12Jun-13May-2418,850.00
D64913MTPD2BLJan-64Apr-14Nov-15Apr-2624,050.00
D67831FTPD2BLDec-64Jan-14Aug-1432,000.0020,800.0020,800.00
D98454MTPD2BLSep-55Mar-15Feb-16May-2214,950.00
E04406FTPD2BLDec-56Sep-15Feb-1622,200.0014,430.0022,724.00
E14239MTPD2BLApr-63Dec-15Jul-16Sep-2424,050.00
E21147MTPD2BLApr-63May-16Aug-17Dec-2218,200.00
E30365MTPD2BLApr-59May-16Jul-1726,880.0017,472.0020,800.00
E40024MTPD2BLApr-64Jan-17Oct-1725,000.0016,250.0016,250.00
E43126FTPD2BLSep-65Feb-17Dec-1730,000.0019,500.0019,500.00
E75759FTPD2BLMay-67Apr-18Mar-1931,000.0020,150.0020,150.00
E97152FTPD2BLFeb-64Jan-18Aug-1932,000.0020,800.0020,800.00
F20818FTPD2BLMay-70Nov-19Jul-2036,000.0023,400.0023,400.00
F52040MTPD2BLAug-88Apr-20Jul-21Sep-2228,600.00
F52272MTPD2BLJun-62Nov-20Jun-21Sep-2229,250.00
F68746FTPD2BLApr-57Apr-21Dec-21Apr-2221,450.00
F80463MTPD2BLMay-77Jul-21Apr-2258,000.0037,700.00
F85068MTPD2BLApr-58Sep-21Jun-22Oct-22
G12028MTPD2BLDec-61Jul-22Mar-23Jul-23
G21637FTPD2BLDec-55Jan-23Jun-23Jan-24
G22395MTPD2BLOct-75Feb-23Aug-23
G25716MTPD2BLJul-63Jan-23Aug-23Oct-23
G27827MTPD2BLSep-68Apr-23Nov-2355,000.0035,750.00
G29569MTPD2BLApr-70Aug-23Oct-2368,000.0044,200.00
G62510MTPD2BLNov-66May-24Nov-24Aug-25
G86782MTPD2BLMar-70Feb-25Oct-2547,000.0030,550.00
G88191MTPD2BLDec-65Apr-25Sep-2546,000.0029,900.00
H02231FTPD2BLDec-65Feb-26Mar-2675,000.0048,750.00
H05267MTPD2BLAug-67Oct-25May-2658,000.0037,700.00
PRODUCT -BL644,488.00799,708.00
SUBTOTAL PENDING -TPD2
SUBTOTAL OTHER -TPD21,891,708.002,382,068.00
COVERAGE -TPD21,891,708.002,382,068.00
G16288MDEPXCMay-04Mar-23Apr-23Apr-2310,000.0010,000.00
G51162FDEPXCMar-98May-24Jul-24
PRODUCT -XCL10,000.0010,000.00
F83862MDEPXSSep-60Jan-22Apr-22Apr-2220,000.0020,000.00
F85707FDEPXSDec-74Mar-22Apr-22Apr-2230,000.0030,000.00
F92522MDEPXSMay-58Jun-22Oct-22Oct-2220,000.0020,000.00
F95378MDEPXSDec-46Jul-22Aug-22Aug-2220,000.0020,000.00
G04096FDEPXSSep-59Nov-22Dec-22Dec-2230,000.0030,000.00
G17754MDEPXSJul-58Apr-23May-23May-2320,000.0020,000.00
G33546MDEPXSAug-63Oct-23Nov-23Nov-2330,000.0030,000.00
G36887MDEPXSNov-76Dec-23Jan-24Jan-2430,000.0030,000.00
G39595MDEPXSNov-42Jan-24Feb-24Feb-2415,000.0015,000.00
G51364MDEPXSMar-73Jun-24Jun-24Jun-24105,000.00105,000.00
G55964MDEPXSFeb-61Aug-24Aug-24Aug-245,000.005,000.00
G63518FDEPXSMay-75Oct-24Nov-24Nov-2430,000.0030,000.00
G65613MDEPXSOct-57Nov-24Dec-24Jan-25
G77786MDEPXSApr-64Apr-25May-25May-2520,000.0020,000.00
G79109MDEPXSNov-48May-25May-25May-2510,000.0010,000.00
G89389FDEPXSDec-80Sep-25Oct-25Oct-2520,000.0020,000.00
G91649FDEPXSFeb-69Oct-25Oct-25Oct-2530,000.0030,000.00
G96036FDEPXSJan-63Dec-25Dec-25Dec-2530,000.0030,000.00
G99649FDEPXSMar-72Jan-26Feb-26Feb-2625,000.0025,000.00
PRODUCT -XSL490,000.00490,000.00
COVERAGE -DEP500,000.00500,000.00
G06570MAD&DBAAug-99Dec-22Jan-23Jan-2346,000.0046,000.00
PRODUCT -BA46,000.0046,000.00
COVERAGE -AD&D46,000.0046,000.00
HK3269MSTDSTFeb-44Mar-21May-21Sep-21-369.68,500.80
HM2237FSTDSTJan-59May-21Jun-21Nov-21192.8910,801.20
HP6281MSTDSTJul-90Jul-21Aug-21Jan-221,575.348,486.48
HQ6786FSTDSTApr-58Aug-21Sep-21Sep-21753.6
HR0328MSTDSTSep-53Aug-21Oct-21Feb-222,257.926,325.09
HR6120MSTDSTApr-58Sep-21Oct-21Mar-225,163.589,429.12
HS2786MSTDSTJun-82Sep-21Dec-21Jan-223,656.2310,076.88
HS8654FSTDSTOct-61Oct-21Oct-21Apr-225,733.069,786.76
HT0937FSTDSTMar-59Nov-21Jan-22Dec-216060
HT1361FSTDSTApr-64Nov-21Nov-21Feb-222,177.543,949.94
HT4846MSTDSTNov-82Oct-21Nov-21Apr-228,331.4511,664.00
HT8446FSTDSTJul-59Oct-21Nov-21Mar-224,508.886,924.36
HU8417MSTDSTApr-85Oct-21Dec-21Jan-221,124.643,695.23
HU9604MSTDSTMar-66Dec-21Jan-22Feb-222,726.642,726.64
HV6854MSTDSTDec-64Dec-21Jan-22Jan-221,082.381,082.38
HW1693MSTDSTJun-91Dec-21Jan-22Feb-221,750.421,750.42
HW1894MSTDSTFeb-61Dec-21Jan-22Mar-227,690.327,690.32
HW8620MSTDSTJun-92Dec-21Feb-22Jun-228,234.428,234.42
HX0008MSTDSTJan-78Jan-22Mar-22Jul-2210,033.2710,033.27
HY2319FSTDSTAug-62Jan-22Feb-22Apr-223,083.303,083.30
HY5888FSTDSTOct-89Feb-22Mar-22Apr-223,927.623,927.62
HY6369MSTDSTApr-86Feb-22Mar-22Mar-221,237.671,237.67
HY6564FSTDSTApr-63Feb-22Mar-22Jul-2213,154.4013,154.40
HY7144FSTDSTApr-75Feb-22Mar-22Mar-221,470.231,470.23
HY8927FSTDSTOct-57Feb-22Mar-22May-227,796.607,796.60
HZ1303FSTDSTNov-70Mar-22Mar-22May-224,546.934,546.93
HZ1470FSTDSTAug-76Mar-22Mar-22Apr-222,116.802,116.80
HZ9163MSTDSTAug-94Mar-22Apr-22May-223,034.013,034.01
JA1151MSTDSTJun-77Mar-22Apr-22Mar-221,368.811,368.81
JA8954MSTDSTJun-76Mar-22Apr-22Jun-226,623.906,623.90
JB1317MSTDSTSep-69Apr-22May-22Jul-225,141.195,141.19
JB1514MSTDSTNov-69Apr-22May-22Oct-2216,062.5516,062.55
JB3167FSTDSTDec-87Mar-22May-22Apr-2221.4321.43
JB5214FSTDSTFeb-73Mar-22May-22May-222,892.082,892.08
JC1901FSTDSTDec-55Apr-22May-22Aug-226,550.746,550.74
JC3958FSTDSTApr-75Jun-22Jun-22Jul-221,832.431,832.43
JD0645FSTDSTAug-72Jun-22Jun-22Jul-222,263.902,263.90
JD8521MSTDSTJun-92Jun-22Jul-22Jul-22881.03881.03
JD9997FSTDSTNov-58Aug-22Aug-22Sep-223,433.993,433.99
JE1749FSTDSTMar-95Sep-22Sep-22Oct-221,549.611,549.61
JE2798FSTDSTApr-59Aug-22Sep-22Aug-221,262.721,262.72
JE7054FSTDSTFeb-59Jul-22Jul-22Jan-239,642.489,642.48
JE7090MSTDSTApr-65Jul-22Aug-22Dec-226,179.996,179.99
JF0229FSTDSTJul-65Aug-22Sep-22Sep-221,779.281,779.28
JF4856FSTDSTOct-65Jun-22Aug-22Nov-226,131.926,131.92
JF5275FSTDSTMay-86Jul-22Aug-22Sep-224,521.604,521.60
JF7288FSTDSTJul-87Aug-22Aug-22Oct-223,128.923,128.92
JG2815MSTDSTDec-49Sep-22Sep-22Dec-227,024.807,024.80
JG8513FSTDSTAug-62Aug-22Sep-22Oct-222,711.492,711.49
JH4943MSTDSTMar-64Oct-22Nov-22Jan-239,492.379,492.37
JJ5672MSTDSTMar-70Oct-22Nov-22Dec-224,581.764,581.76
JJ6711FSTDSTFeb-62Nov-22Dec-22Jan-234,554.244,554.24
JK4472MSTDSTJun-64Nov-22Dec-22Jan-233,448.953,448.95
JM2428MSTDSTJul-70Dec-22Jan-23Mar-237,250.667,250.66
JM6759FSTDSTDec-55Jan-23Feb-23Jul-239,486.439,486.43
JM8066MSTDSTJul-63Jan-23Feb-23Jul-2314,388.4814,388.48
JM9413MSTDSTAug-67Jan-23Feb-23Jul-2313,829.7613,829.76
JM9830FSTDSTFeb-72Mar-23Mar-23May-232,739.822,739.82
JN0705MSTDSTJan-53Jan-23Mar-23Apr-235,175.275,175.27
JN5598MSTDSTJun-63Feb-23Feb-23May-235,127.645,127.64
JP2050FSTDSTDec-81Feb-23Feb-23Apr-233,272.463,272.46
JP2074MSTDSTApr-82Mar-23Mar-23Apr-232,153.012,153.01
JQ1428MSTDSTOct-85Feb-23Apr-23Aug-237,996.207,996.20
JQ3654FSTDSTDec-90Mar-23Apr-23May-234,118.394,118.39
JQ6789MSTDSTJul-71Mar-23May-23Sep-2313,699.4413,699.44
JQ8528FSTDSTNov-99Feb-23Apr-23Jun-236,133.496,133.49
JR1311MSTDSTOct-71Mar-23May-23Sep-239,567.369,567.36
JR5998FSTDSTMar-69Mar-23May-23Sep-2311,852.2611,852.26
JR9914MSTDSTSep-68Apr-23May-23Oct-2315,488.6415,488.64
JS0930FSTDSTMay-93Jun-23Jun-23Jul-232,839.722,839.72
JS2878FSTDSTNov-85May-23May-23Jun-231,803.681,803.68
JS8513FSTDSTMar-86Apr-23Jun-23May-23473.29473.29
JS8598MSTDSTApr-81Feb-23Jun-23Aug-234,716.564,716.56
JT2829FSTDSTSep-63May-23Jun-23Jun-231,595.361,595.36
JT6333MSTDSTSep-69May-23Jul-23Jul-232,791.482,791.48
JT9763FSTDSTJun-76May-23Jul-23Jul-232,201.342,201.34
JT9947FSTDSTNov-70Jul-23Jul-23Sep-235,501.595,501.59
JU0665MSTDSTJan-68Jul-23Aug-23Oct-236,415.726,415.72
JU1485MSTDSTJul-70May-23Aug-23Nov-238,749.068,749.06
JU2671FSTDSTOct-62May-23Jul-23Sep-233,983.963,983.96
JU4245MSTDSTApr-75Jul-23Jul-23Oct-234,307.494,307.49
JU6595MSTDSTApr-93Jul-23Jul-23Aug-231,771.721,771.72
JW0243FSTDSTDec-68Aug-23Sep-23Oct-233,179.263,179.26
JW3516FSTDSTOct-76Aug-23Sep-23Oct-232,005.702,005.70
JW3753FSTDSTFeb-66Aug-23Sep-23Oct-232,379.862,379.86
JW4658MSTDSTDec-74Aug-23Sep-23Aug-23912.58912.58
JX5295MSTDSTJul-74Jul-23Sep-23Oct-235,570.425,570.42
JY6763MSTDSTDec-49Oct-23Oct-23Jan-246,121.626,121.62
JZ9126MSTDSTOct-74Nov-23Nov-23Jan-245,616.245,616.24
KA1457FSTDSTNov-62Oct-23Dec-23Feb-247,162.927,162.92
KA3535FSTDSTJul-64Nov-23Dec-23May-2410,062.7210,062.72
KA8366MSTDSTFeb-64Nov-23Dec-23Mar-245,977.205,977.20
KB2245FSTDSTFeb-70Dec-23Jan-24Jan-243,116.043,116.04
KB2451MSTDSTMar-56Nov-23Dec-23Jan-243,027.263,027.26
KB4168MSTDSTApr-57Oct-23Jan-24Apr-2410,897.9210,897.92
KB5448FSTDSTDec-68Jan-24Jan-24Feb-243,439.993,439.99
KB5577MSTDSTDec-73Dec-23Jan-24Mar-247,022.367,022.36
KB8357FSTDSTSep-71Jan-24Feb-24Mar-242,385.752,385.75
KC4120MSTDSTDec-82Dec-23Jan-24Jun-2417,802.4817,802.48
KC4545MSTDSTFeb-60Dec-23Feb-24Mar-245,376.465,376.46
KC4787MSTDSTDec-03Nov-23Mar-24Apr-245,489.605,489.60
KC9759MSTDSTApr-93Jan-24Feb-24Feb-241,090.281,090.28
KE3203MSTDSTNov-65Mar-24Mar-24May-243,591.473,591.47
KE4282FSTDSTFeb-86Apr-24Apr-24Jun-244,865.284,865.28
KF6283FSTDSTSep-71Apr-24May-24Jun-243,976.253,976.25
KG2722MSTDSTOct-72Mar-24May-24Jun-241,611.631,611.63
KG4276MSTDSTOct-75Apr-24May-24May-243,094.593,094.59
KG6548MSTDSTMar-60Apr-24May-24Jul-245,111.075,111.07
KG9122MSTDSTOct-87Apr-24Apr-24Jun-245,726.585,726.58
KG9722FSTDSTAug-89May-24May-24Jul-243,442.553,442.55
KH2446FSTDSTJul-89Apr-24May-24Jun-241,851.981,851.98
KH6549FSTDSTDec-68Jun-24Jun-24Jul-242,625.272,625.27
KJ1701MSTDSTNov-77Apr-24May-24Sep-2412,945.3512,945.35
KJ4776FSTDSTDec-76Aug-24Aug-24Sep-242,993.712,993.71
KJ5433MSTDSTFeb-79Apr-24Jun-24Jul-246,697.946,697.94
KJ6400MSTDSTMar-70Jun-24Jun-24Aug-243,717.783,717.78
KJ6667FSTDSTAug-76Jun-24Jun-24Jul-242,040.242,040.24
KJ6701FSTDSTJul-82Jun-24Jun-24Jul-242,736.002,736.00
KJ7336MSTDSTDec-86May-24Jul-24Jul-242,649.902,649.90
KK5766MSTDSTSep-83May-24Jul-24Aug-248,753.548,753.54
KK6046MSTDSTApr-83Jul-24Jul-24Oct-244,015.204,015.20
KK6585FSTDSTAug-89Jun-24Jul-24Aug-244,509.274,509.27
KK8513FSTDSTOct-62Jun-24Jul-24Sep-245,646.115,646.11
KL6672FSTDSTApr-78Jul-24Aug-24Oct-247,304.897,304.89
KL8511MSTDSTMar-80Jul-24Aug-24Aug-241,497.041,497.04
KN1306MSTDSTApr-71Aug-24Aug-24Oct-243,934.303,934.30
KN6261MSTDSTDec-60Sep-24Oct-24Mar-2514,595.0714,595.07
KN6390FSTDSTAug-93Sep-24Oct-24Nov-245,390.105,390.10
KP0221FSTDSTJul-00Aug-24Sep-24Oct-244,093.744,093.74
KP3235FSTDSTAug-82Jun-24Sep-24Sep-245,328.965,328.96
KQ3188FSTDSTJul-95Oct-24Oct-24Nov-242,919.462,919.46
KQ3430FSTDSTNov-69Nov-24Nov-24Jan-252,639.912,639.91
KR4955FSTDSTJan-88Aug-24Nov-24Sep-246060
KS0931FSTDSTMar-91Nov-24Nov-24Jan-256,677.286,677.28
KS3091MSTDSTJul-92Oct-24Nov-24Nov-24701.49701.49
KS7669FSTDSTDec-63Oct-24Nov-24Dec-242,112.382,112.38
KT4409MSTDSTJan-61Dec-24Dec-24Jan-251,909.731,909.73
KT9079FSTDSTSep-90Dec-24Dec-24Jan-252,429.762,429.76
KV0244MSTDSTDec-73Dec-24Dec-24Mar-259,926.409,926.40
KY6724FSTDSTDec-68Jan-25Feb-25Jul-2517,677.4417,677.44
LB0376MSTDSTJul-87Feb-25Mar-25Aug-2514,345.5514,345.55
LB6785MSTDSTApr-86Feb-25Feb-25Mar-252,288.892,288.89
LB8924MSTDSTSep-62Feb-25Mar-25Aug-2512,579.8412,579.84
LC7053MSTDSTMar-70Feb-25Mar-25Aug-2512,928.6412,928.64
LC8197FSTDSTJan-94Mar-25Apr-25May-252,620.902,620.90
LD2637FSTDSTJul-74Dec-24Mar-25Jun-2510,710.9610,710.96
LE4646FSTDSTAug-81Oct-24May-25Apr-2510,298.8810,298.88
LE4709FSTDSTApr-71Apr-25May-25Jun-252,294.402,294.40
LG6083MSTDSTDec-65Apr-25May-25Oct-2512,700.8012,700.80
LH1105FSTDSTMay-94Jun-25Jun-25Aug-256,170.456,170.45
LK0633FSTDSTNov-90May-25Jun-25Jul-251,520.431,520.43
LK1161MSTDSTMar-71Apr-25Jun-25Jun-255,384.755,384.75
LK2141FSTDSTJul-83Jun-25Jun-25Oct-2512,900.7812,900.78
LK3718FSTDSTApr-84Jun-25Jun-25Aug-253,353.733,353.73
LL8028FSTDSTFeb-69Jun-25Jul-25Sep-254,195.414,195.41
LM4594FSTDSTNov-70Jul-25Jul-25Oct-2510,212.4810,212.48
LM8188MSTDSTSep-86Aug-25Aug-25Sep-254,231.174,231.17
LN6938FSTDSTMar-89Sep-25Sep-25Oct-252,655.632,655.63
LR3871FSTDSTJul-87Aug-25Sep-25Oct-252,789.282,789.28
LR8341MSTDSTMay-66Aug-25Sep-25Oct-254,247.704,247.70
LT0232MSTDSTApr-86Sep-25Oct-25Nov-252,314.612,314.61
LU9190MSTDSTAug-67Oct-25Nov-25Apr-2617,107.2017,107.20
LV5408MSTDSTJan-61Nov-25Nov-25Dec-252,220.972,220.97
LW4434MSTDSTAug-84Oct-25Nov-25Nov-25668.55668.55
LX2900MSTDSTMar-64Oct-25Nov-25Jan-265,095.205,095.20
LX3581MSTDSTJan-89Oct-25Dec-25Dec-251,079.981,079.98
MC1911FSTDSTJan-57Nov-25Dec-25Dec-25939.3939.3
MC3033MSTDSTJul-82Jan-26Jan-26Feb-26807.762,192.512,192.51
MC5767MSTDSTOct-00Nov-25Dec-25Jan-262,154.422,154.42
ME2312FSTDSTMar-77Jan-26Jan-26Mar-264081,690.301,690.30
MF3902FSTDSTFeb-79Dec-25Jan-26May-26450.728,370.558,370.55
MG5031FSTDSTDec-95Jan-26Feb-26Apr-26572.646,217.276,217.27
MH4932MSTDSTJul-68Feb-26Feb-26Mar-26741.844,556.974,556.97
MH9582FSTDSTDec-68Feb-26Feb-26Apr-26539.524,007.884,007.88
MK5145FSTDSTJul-00Mar-26Apr-26May-26658.083,948.483,948.48
MK6006FSTDSTFeb-70Jan-26Mar-26Jul-26538.569,059.539,059.53
MM9102MSTDSTFeb-05Mar-26Apr-26May-26596.594,431.834,431.83
MN0658FSTDSTDec-89May-26May-26Jul-26449.522,119.172,119.17
MN5037FSTDSTMay-91Apr-26May-26Jun-26572.643,517.613,517.61
MP9116FSTDSTJun-94Apr-26Jun-26May-26572.642,126.902,126.90
MQ2111MSTDSTMar-64May-26Jun-26Aug-26578.883,390.563,390.56
MQ2340MSTDSTJun-71May-26May-26Jun-26712.322,645.772,645.77
MQ6708FSTDSTApr-93Apr-26May-26Jun-26606.613,557.343,557.34
MQ7005FSTDSTMay-89Apr-26May-26Jun-26697.685,083.085,083.08
MS5895FSTDSTMar-95Jun-26Jun-26Jul-261,041.554,166.204,166.20
PRODUCT -ST930,338.57986,380.10
COVERAGE -STD930,338.57986,380.10
FD7051MLTDLTAug-59Jan-17Aug-17Sep-232,275.302,080.657,380.654,635.00
FE7836FLTDLTSep-65Feb-17Jul-171,497.5440,779.2388,845.7457,275.7496,685.28
FG4276MLTDLTMar-59Jul-17Oct-17Feb-222,024.10-6,072.3034,893.32
FG9495MLTDLTNov-57Jun-17Oct-17May-242,843.3312,808.972,751.00
FQ2809FLTDLTFeb-64Jan-18Jul-181,560.005,400.0019,202.364,830.008,906.00
FV6007FLTDLTMay-67Apr-18Sep-181,503.849,225.3621,646.449,466.9816,142.03
GS9233FLTDLTMay-70Nov-19Apr-201,799.0686,841.09120,913.299,630.0067,008.02
GT6687MLTDLTJul-69Dec-19May-20Jun-22-14,400.098,400.00584
GT7579FLTDLTJan-71Dec-18May-202,127.906,908.9614,012.3910,492.0018,348.69
GZ8773MLTDLTApr-82May-20Sep-20Jul-242,220.4042,187.6070,904.717,802.38
HH0234FLTDLTSep-88Sep-20Mar-21Dec-251,573.5376,037.0690,097.3449,530.59
HJ7096MLTDLTJun-62Nov-20Apr-21Sep-252,256.7610,140.7814,581.416,835.63
HP3220MLTDLTSep-66Mar-21Oct-21Mar-221,418.95-2,471.921,690.1126,964.55
HR8037FLTDLTJan-59May-21Jan-22Nov-2589,330.1989,330.19
HR9580FLTDLTApr-57Apr-21Oct-21Sep-2213,003.5217,793.6112,792.50
HW4863MLTDLTSep-53Aug-21Feb-22
HW9220MLTDLTJul-90Jul-21Feb-22Jan-221,539.35595.75595.75
HX2224MLTDLTMay-77Jul-21Feb-223,089.605,600.005,600.0013,346.00
HZ4789MLTDLTNov-82Oct-21Mar-22Aug-222,246.238,794.528,794.52
JA1622FLTDLTOct-61Oct-21May-22Apr-221,779.53237.21237.21
JA8217MLTDLTApr-58Sep-21Apr-22Mar-242,400.002,400.00
JD1343MLTDLTJan-78Jan-22Jun-22Sep-223,349.267,818.677,818.67
JD4902MLTDLTJun-92Dec-21Jul-22Jul-221,889.162,920.792,920.79
JM2838MLTDLTDec-61Jul-22Mar-23Jan-2533,963.6833,963.68
JN6487FLTDLTFeb-59Jul-22Apr-23Jul-2425,670.9525,670.95
JS5983FLTDLTDec-55Jan-23Jun-23Dec-239,240.619,240.61
JT6834MLTDLTAug-67Jan-23Jun-23Dec-232,492.247,680.117,680.11
JV1109MLTDLTJul-63Jan-23Aug-23Sep-232,592.925,185.845,185.84
JV5705MLTDLTOct-71Mar-23Aug-23Jun-2536,506.5236,506.52
JW3253MLTDLTSep-68Apr-23Aug-232,791.1886,626.5886,626.58102,148.48
JW7561MLTDLTJul-71Mar-23Oct-232,473.32
JW9412FLTDLTMar-69Mar-23Oct-232,573.81
JY7739MLTDLTFeb-66Jan-23Jan-241,902.4743,487.6643,487.66
JZ1711MLTDLTJul-70May-23Nov-23Nov-232,396.743.333.33
KG0284FLTDLTMay-93Sep-23Jun-242,400.32
KG1201MLTDLTDec-03Nov-23Jun-241,929.05
KH8581MLTDLTDec-82Dec-23May-24Jul-243,346.90557.59557.59
KL4323MLTDLTApr-70Aug-23Oct-243,476.453,206.453,206.458,434.00
KL9022MLTDLTNov-66May-24Nov-241,983.1319,751.7319,751.73
KM2502MLTDLTMar-77Dec-23Oct-24May-253,402.561,060.001,060.00
LK4488FLTDLTDec-68Jan-25Jun-253,185.629,351.299,351.297,701.00
LL0283MLTDLTJul-87Feb-25Jun-253,020.5830,010.6130,010.61163,556.18
LL9724MLTDLTSep-62Feb-25Aug-252,271.19
LR0763MLTDLTMar-70Feb-25Aug-252,348.144,494.824,494.825,403.00
LS1343MLTDLTDec-65Apr-25Sep-252,288.791,149.991,149.995,629.00
MM5912MLTDLTAug-67Oct-25Apr-263,082.869,042.579,042.5799,214.47
VE3818MLTDLTApr-61Dec-07Mar-08Jul-221,669.101,229.1622,371.436,081.00
VG0317FLTDLTSep-57Sep-08Mar-09Mar-2435,222.00235,850.4835,380.06
VG7022MLTDLTSep-59Sep-08May-09Sep-249,432.2867,909.447,753.10
VJ9151MLTDLTAug-58Dec-09Aug-10Aug-2311,299.4393,456.489,567.58
VK2830FLTDLTAug-57Jan-10Dec-10Feb-2410,314.08142,146.0111,062.21
VL5806MLTDLTNov-59Aug-10Feb-11Nov-243,413.3317,910.322,726.00
VN7975FLTDLTAug-60Jul-11Oct-111,967.015,400.0023,053.791,713.005,569.00
VQ2620FLTDLTOct-57Jan-12Sep-12Oct-221,006.4512,306.45592
VR5228MLTDLTMar-68Apr-12Jan-13Jun-251,126.234,206.6715,206.6710,773.00
VS2980MLTDLTNov-62Sep-12May-131,431.405,400.0016,756.083,723.007,013.00
VS3926FLTDLTJul-59Oct-12Apr-13May-265,280.0020,299.264,774.00
VS4645FLTDLTJul-78Dec-12Jun-131,439.7169,106.08215,839.80257,607.31
VU8207MLTDLTJan-64Apr-14Jun-14Mar-261,844.965,078.5714,109.798,289.00
VV0733FLTDLTDec-64Jan-14Jul-141,560.005,400.0034,592.275,639.008,794.00
SUBTOTAL PENDING -LT
SUBTOTAL OTHER -LT888,978.781,899,666.07508,201.85694,966.93
PRODUCT -LT888,978.781,899,666.07508,201.85694,966.93
JN2685MLTDL6Jun-64Nov-22Feb-23Nov-22693693
SUBTOTAL PENDING -L6
SUBTOTAL OTHER -L6693693
PRODUCT -L6693693
HY1975MLTDSBMar-59Jul-17Feb-22Feb-226,072.306,072.30
JB6986MLTDSBSep-66Mar-21May-22Mar-228,513.708,513.70
SUBTOTAL PENDING -SB
SUBTOTAL OTHER -SB14,586.0014,586.00
PRODUCT -SB14,586.0014,586.00
SUBTOTAL PENDING -LTD
SUBTOTAL OTHER -LTD904,257.781,914,945.07508,201.85694,966.93
COVERAGE -LTD904,257.781,914,945.07508,201.85694,966.93
POLICY -6417286,023,396.357,090,125.172,399,909.853,341,034.93

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