Normalised records

Normalised records (silver)

Each raw row is parsed into consistently formatted fields. Every change from the raw value is recorded as a data-quality flag.

Normalised rows
99,495
usable in matching
Flagged rows
99,881
99.9% carry at least one flag
Junk quarantined
505
no usable last name
Average quality score
0.75
1.00 = no corrections needed

Quality flags

What normalisation had to do, and how often. Select a flag to filter the table.

Normalised records

Claims, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-422737CLMTerry A Turner1971-11-01UHC-21752-2127377983361967 Valley View Dr, Houston, TX0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408132CLMAndrea Coleman1998-03-17UHC-21993-8950596861507471 Washington St, Tempe, AZ, 852320.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-422315CLMLisa Ferguson1965-10-13—50772897194972 Cedar Ln, Eden Prairie, MN, 553700.48Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-414041CLMDaviid Hernandez1987-06-28UHC-79977-0269130868211326 Washington St, Denver, CO, 802260.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421012CLMJoan Maldonado1990-12-10UHC-93987-6495474562091564 Ridge Rd, Tampa, FL0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-400383CLMEthan Burton1962-07-06UHC-46365-9873653725601411 Desert Sky Blvd, Phoenix, AZ, 850650.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-417213CLMOmar Adams1972-10-03UHC-62737-7166192101108093 Canyon Rd, San Antonio, TX, 782340.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-406298CLMSarah Scott1944-05-16UHC-34036-5744646593959320 Maple Ave, Orlando, FL0.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-407468CLMChristian Reynoolds1969-04-15——836 Bayshore Dr, Plano, TX, 750010.48Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
CLM-411752CLMEmily Thompson1964-02-27UHC-60492-2285835602607291 Mesa Dr Apt 35, Charlotte, NC, 282160.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-411751CLMEmily Thompson1964-02-27UHC-60492-2285835602607291 Mesa Dr Apt 35, Charlotte, NC, 282160.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-425818CLMChristine Wagner1989-02-28—74668063518466 Jefferson Ave, Tucson, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-411037CLMHeather H Lynch1996-05-02UHC-37423-636293745670695 Highland Ave, Plano, TX0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-413581CLMStephen Hansen1985-08-18UHC-90531-9651944571553118 Sunset Blvd, Nashville, TN0.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-430179CLMCarolyn I Li1943-09-13UHC-24165-9350944476902737 Lake View Rd, Minneapolis, MN0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-419905CLMChristine K Hawkins1963-02-21—47132140891463 Palm Dr, Miami, FL, 331380.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402892CLMGrace Hawkins1938-07-27UHC-70840-0658897328401559 Willow Ct, Fresno, CA, 937010.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-428672CLMJordan Wood2004-05-05——7709 Park Pl, Dallas, TX0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-420290CLMSarah Adams2006-06-09UHC-57106-30—2699 Canyon Rd # 140, Fresno, CA, 937840.48Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
CLM-406181CLMArjun Wang1953-11-17—34530242638871 Lincoln Way, Las Vegas, NV, 891610.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-411371CLMOlivia J Padilla1995-03-16UHC-81861-1261084928318451 Camelback Rd, Austin, TX0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-431050CLMLawrence E Hansen1988-02-04——2358 Meadow Ln Apt 21, Miami, FL, 331030.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-418649CLMBilly Weaver1953-05-24UHC-92169-3565380225771760 Pine Dr Apt 6, Sacramento, CA, 958740.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-409612CLMVirginia Martin1953-05-18——5201 Apache Blvd, Orlando, FL, 328750.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-414633CLMKelly Kim1957-09-20—94275666307517 Main St, Seattle, WA, 981680.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-430090CLMWalter Burns———739 Valley View Dr, Seattle, WA, 981830.48Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+4 more
CLM-416424CLMMelissa Anderson—UHC-00123-9532760357608861 Canyon Rd, Atlanta, GA, 303620.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-418900CLMHeather Vazquez1986-11-05——3112 Grand Ave, Orlando, FL, 328230.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-418901CLMHeather Vazquez1986-11-05——3112 Grand Ave, Orlando, FL, 328230.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-421283CLMShirley L Morris1985-03-17UHC-89888-33—7543 Canyon Rd, Atlanta, GA, 303750.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417823CLMLarry Lynhc1992-07-16—98199216874992 Valley View Dr, San Antonio, TX, 782750.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-421026CLMShirley F Graham2005-11-13UHC-24244-7542153227009296 Maple Ave, Sacramento, CA, 958510.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421400CLMJeffrey Park1938-06-15—79036381005894 Pine Dr, Chandler, AZ, 852820.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-432488CLMDylan Hansen2005-12-04UHC-66853-5543326918932016 River Rd Apt 4, Tempe, AZ0.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-403540CLMGregory Elliott1961-08-16UHC-34661-18—1131 Central Ave Apt 20, Atlanta, GA, 303320.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-418711CLMJanice West1946-05-25—7406652820207 Meadow Ln, Chandler, AZ, 852570.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419912CLMLinda Wagner1994-05-17UHC-79792-8731792763894845 Hillcrest Rd, San Diego, CA, 921360.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-414680CLMEdward Phillips1997-07-02UHC-73690-8488335640374980 Sunset Blvd Apt 8, Columbus, OH, 432160.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-430953CLMRandy Valdez1956-02-15UHC-86863-81—1385 Ocean Ave, Columbus, OH, 432890.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418123CLMDonald Sullivan1972-02-12UHC-55880-2681742480369412 Main St, Fresno, CA, 937090.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-418024CLMYuki Murphy1945-05-16UHC-24467-3779521925343311 Ocean Ave, Sacramento, CA, 958160.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-409460CLMChristian X Rojas2002-10-10—77399203812152 Oak St, Phoenix, AZ, 850740.48Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
CLM-413332CLMDouglas Henderson1997-01-10UHC-07476-5177093864901129 Market St, Eden Prairie, MN, 553650.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-421486CLMJohn Fox1942-08-28UHC-40679-1571979975339468 Palm Dr, Dallas, TX, 752040.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-432040CLMBrittany Shaw—UHC-43130-1650761705626327 Ridge Rd, Denver, CO, 802990.48Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-411438CLMBrenda Tran1994-10-17UHC-06212-91—9506 Lake View Rd, Tucson, AZ, 857390.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-402628CLMRuth Vargas2001-04-09UHC-73294-7584692708477794 Union St, Glendale, AZ0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-401008CLMJese Carr1978-10-15—88191167046123 Willow Ct, Gilbert, AZ0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-414422CLMBanks Nicole1996-12-26UHC-03903-8755140458992517 Mountain View Dr, Mesa, AZ, 852000.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-411331CLMDylan F Dean—UHC-33903-053722813844—0.48Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more
32,829 rows, page 21 of 657PreviousNext