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-418892CLMEmily Young1977-01-26UHC-47480-6085834362088117 Apache Blvd, Mesa, AZ0.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-408389CLMKaren Wells1989-06-21UHC-15913-51—3908 Sunset Blvd, Nashville, TN0.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428570CLMKayla Knight1977-10-25UHC-89655-0692824923808687 Bayshore Dr, Sacramento, CA, 958270.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-410661CLMNancy Valdez1952-03-12UHC-91123-848833553974963 Canyon Rd Apt 38, Chandler, AZ, 852950.60Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more
CLM-429759CLMAna N Sendoval1951-01-11UHC-55976-5095477990283345 Sunset Blvd, Austin, TX, 787280.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407892CLMFatima Kim1982-01-04UHC-92687-81—5234 Elm St, Plano, TX, 750340.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-401812CLMJacqueline Willsi2003-09-05UHC-69078-9787160366305661 Sage Ct, San Diego, CA0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417174CLMCarolyn L Coleman1991-03-16—24170985678911 Oak St, Chandler, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-403120CLMAndrew Little1958-05-10UHC-87409-1959466731457294 Spring St, Chandler, AZ, 852570.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-403119CLMAndrew Little1958-05-10UHC-87409-1959466731457294 Spring St, Chandler, AZ, 852570.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-428778CLMAnna Bowman2007-03-24UHC-89187-8252957624683232 Spring St, Orlando, FL0.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-432795CLMStephen Murray1962-05-26—81138487024148 Main St, Seattle, WA, 981010.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-429580CLMKatherine N Ramirez1958-09-11—22370333268202 Palm Dr, Gilbert, AZ, 852120.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-410274CLMJanice Dixon1965-05-19UHC-16214-1443431397236092 Canyon Rd, Minneapolis, MN, 554220.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-400676CLMRaymond L Mendoza1943-05-14——6759 Canyon Rd, Columbus, OH, 432760.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-417525CLMMarilyn S King1970-10-14—88246655717092 Pine Dr, Houston, TX0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-427233CLMKimbely Larson2003-08-24UHC-41371-87—2152 Desert Sky Blvd, Glendale, AZ, 853610.60Name re-casedDate of birth reformattedSSN last four extractedCity re-cased+4 more
CLM-402655CLMAmy Murray1952-03-15UHC-24519-12—5657 Central Ave, San Diego, CA, 921440.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-413248CLMSusan P Adams1993-09-01—53881365628014 Valley View Dr, Minneapolis, MN, 554100.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-401726CLMEmma Patel1988-09-21—55623392023616 Indian School Rd, Phoenix, AZ, 850210.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-420115CLMRoger C Wang1971-06-16UHC-11203-299806840763932 Park Pl, Denver, CO, 802890.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-414960CLMWillie Vega1966-02-26UHC-62858-7047152364919486 Camelback Rd, Miami, FL, 331850.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-409737CLMScott Howell2004-09-04—22294350451885 Meadow Ln, Houston, TX, 770710.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-426692CLMTyler Wang1941-12-14UHC-25081-14—1579 Lincoln Way, Dallas, TX, 752170.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419458CLMDiego Ramirez1975-02-21UHC-57245-4132375905915394 Grand Ave, Jacksonville, FL, 322470.60Name re-casedDate of birth reformattedMember ID reformattedSSN last four extracted+4 more
CLM-424632CLMStephen E Soto1957-10-24UHC-38096-98—422 Indian School Rd, Austin, TX, 787490.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-400102CLMAnna McDonald1972-03-16UHC-61383-3178375943695798 Union St, Los Angeles, CA, 900150.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-431766CLMHeather Carpenter1995-04-21UHC-25991-8370945907047891 Forest Ave, San Diego, CA, 921730.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-406428CLMAshley Mason1971-10-05UHC-45542-3967596930638239 Mesa Dr, Los Angeles, CA, 900680.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-422528CLMDaniel Morales2006-06-28UHC-50469-9650277469835695 Willow Ct, Fresno, CA, 937390.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-413158CLMJesse Webb1946-04-25UHC-26449-28—4994 Lincoln Way # 382, Eden Prairie, MN, 553960.60Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
CLM-410622CLMRussell Stone2000-01-15—3197555816582 Ridge Rd Apt 37, Nashville, TN, 372480.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-410093CLMCarolyn Aguilar1970-08-14UHC-79100-3676434053879885 River Rd, Charlotte, NC, 282880.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-406020CLMJack Richerds1960-01-18UHC-96441-7593473781569467 Valley View Dr, San Antonio, TX, 782290.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-432527CLM—Junk1995-06-04UHC-48415-05—5289 Jefferson Ave, Atlanta, GA, 303680.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-400433CLMLaura Rivera1959-10-04UHC-17261-4738170266628899 Cedar Ln, Mesa, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-427472CLMKevin Cunningham1985-04-13UHC-16391-2093571762497364 Highland Ave, Fresno, CA, 937680.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-417281CLMRuth L Padilla1941-05-02UHC-57379-7862954061026925 Willow Ct, Minneapolis, MN, 554890.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-430976CLMPhilip Day—UHC-67344-6884559786166435 Sage Ct, Plano, TX, 750210.60Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more
CLM-424553CLMAmber Perkins1978-11-22UHC-05855-16—5171 Elm St, Charlotte, NC, 282040.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423226CLMJoyce R Evans1958-08-12UHC-33176-9930138113403579 Park Pl, San Diego, CA, 921080.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-429258CLMIsabella B Jordan1988-09-27UHC-55243-0974650404234855 Spring St, Phoenix, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-432192CLMJuztin Ortiz1979-01-21—24079564896818 Ridge Rd, Charlotte, NC, 282090.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-427853CLMCatherine A Howard1971-03-21UHC-63375-90—8486 Washington St, Glendale, AZ, 853250.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-427247CLMBruce Vega1971-04-17—46525479679446 Hillcrest Rd, Sacramento, CA, 958620.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-429276CLMNoah D Marquez1954-02-05UHC-44909-1474776869863964 Cedar Ln, Columbus, OH, 432440.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-418988CLMSophia Rogers1999-04-17—31480136661710 Hillcrest Rd, Austin, TX, 787950.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-429699CLMDouglas Banks1982-01-06—90190607781901 Mountain View Dr, Sacramento, CA0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424457CLMPamela Murray1983-10-15UHC-21642-27—4231 Ocean Ave, San Diego, CA, 921060.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421953CLMGeorge Crawford1968-03-12UHC-18913-1777441541632808 Oak St, Phoenix, AZ0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
32,829 rows, page 72 of 657PreviousNext