Spreadsheet: 843359d1695224781-identifying-multiple-dupes-sample
Sheet: Sheet1

c.Contract ID | [NAME] | Claim Paid Date KY | LossType Category | LossType Desc | LossType Part Desc | Sale Date KY | Program Desc | Plan Desc | [NAME] | Paid Claims Total Amt | Incurred Claims Amt | Incurred Claims Count | Paid Claims Count
10000153 | P | 20230427 |  |  |  | 20230313 |  | Premier Plus New | 51990 | 0 | 0 | 1 | 1
10000153 | P | 20230427 | Electrical/AC | Electrical | Switches (Non-Manually Operated) | 20230313 |  | Premier Plus New | 51990 | 0 | 0 | 1 | 1
10000167 | P | 20230825 |  |  |  | 20230313 |  | PREMIER NEW | 55676 | -200 | -200 | 1 | 1
10000167 | P | 20230825 | Electrical/AC | [NAME] | [NAME]. | 20230313 |  | PREMIER NEW | 55676 | 1317.12 | 1317.12 | 1 | 1
10000167 | P | 20230725 |  |  | [NAME]. | 20230313 |  | PREMIER PLUS USED | 65559 | -200 | -200 | 1 | 1
10000228 | P | 20230725 | Electrical/AC | Electrical | Power Door Lock Actuator/Motor | 20230313 |  | PREMIER PLUS USED | 65559 | 634.15 | 634.15 | 1 | 1
10000328 | P | 20230502 |  |  |  | 20230313 |  | PREMIER PLUS USED | 82510 | -100 | 0 | 1 | 1
10000328 | P | 20230502 | Engine/Drivetrain | Fuel System | [NAME] | 20230313 |  | PREMIER PLUS USED | 82510 | 390.66 | 0 | 1 | 1
10000333 | P | 20230408 |  |  |  | 20230304 |  | PREMIER PLUS USED | 35734 | -100 | 0 | 1 | 1
10000333 | P | 20230408 | Chassis/Trim | Brakes | (ABS) Wheel Speed Sensors | 20230304 |  | PREMIER PLUS USED | 35734 | 167.99 | 0 | 1 | 1
10000333 | P | 20230408 | Engine/Drivetrain | Engine | Oil Pump/Housing | 20230304 |  | PREMIER PLUS USED | 35734 | 875.29 | 0 | 1 | 1
10000333 | P | 20230408 | Rental/Towing | Rental | Rental $50 For 5 Days Maximum | 20230304 |  | PREMIER PLUS USED | 35734 | 250 | 0 | 1 | 1
10000580 | P | 20230414 |  |  |  | 20230313 |  | PREMIER USED | 52301 | -200 | -200 | 1 | 1
10000580 | P | 20230414 | Engine/Drivetrain | Drive Assemblies | Axle Shafts | 20230313 |  | PREMIER USED | 52301 | 1498.49 | 1498.49 | 1 | 1
10000642 | P | 20230708 |  |  |  | 20230311 |  | POWERTRAIN PLUS USED | 95459 | -200 | -200 | 1 | 1
10000642 | P | 20230708 | Engine/Drivetrain | Engine | [NAME] | 20230311 |  | POWERTRAIN PLUS USED | 95459 | 399.74 | 399.74 | 1 | 1
10000642 | P | 20230706 |  |  | [NAME] | 20230313 |  | PREMIER PLUS USED | 55540 | 0 | 0 | 1 | 1
10000693 | P | 20230706 | Electrical/AC | [NAME] | Condenser | 20230313 |  | PREMIER PLUS USED | 55540 | 1395.53 | -10.65 | 1 | 1
10000732 | P | 20230420 |  |  |  | 20230313 |  | PREMIER NEW | 36596 | -100 | -100 | 1 | 1
10000732 | P | 20230420 | Engine/Drivetrain | Fuel System | [NAME] | 20230313 |  | PREMIER NEW | 36596 | 362.46 | 362.46 | 1 | 1
10000808 | P | 20230519 |  |  |  | 20230313 |  | PREMIER NEW | 59560 | -200 | -200 | 1 | 1
10000808 | P | 20230519 | Electrical/AC | [NAME] | A/C Seals and Gaskets | 20230313 |  | PREMIER NEW | 59560 | 478.66 | 478.66 | 1 | 1
10000950 | P | 20230808 |  |  |  | 20230313 |  | PREMIER PLUS USED | 78744 | -200 | 0 | 1 | 1
10000950 | P | 20230808 | Engine/Drivetrain | Cooling | Fan Control Module | 20230313 |  | PREMIER PLUS USED | 78744 | 1291.08 | 0 | 1 | 1
10001276 | P | 20230829 |  |  |  | 20230313 |  | PREMIER PLUS NEW | 46072 | -50 | -50 | 1 | 1
10001276 | P | 20230829 | Engine/Drivetrain | Emission System | [NAME] | 20230313 |  | PREMIER PLUS NEW | 46072 | 280.77 | 280.77 | 1 | 1
10001294 | P | 20230711 |  |  |  | 20230313 |  | PREMIER PLUS USED | 75835 | -200 | 0 | 1 | 1
10001294 | P | 20230711 | Engine/Drivetrain | Cooling | Coolant Level Sensor/Tank | 20230313 |  | PREMIER PLUS USED | 75835 | 336 | 0 | 1 | 1
10001294 | P | 20230711 | Rental/Towing | Roadside Assistance | Towing | 20230313 |  | PREMIER PLUS USED | 75835 | 100 | 0 | 1 | 1
10001294 | P | 20230718 | Rental/Towing | Rental | Rental $50 For 5 Days Maximum | 20230313 |  | PREMIER PLUS USED | 75835 | 250 | 0 | 1 | 1