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-405231CLMEvelyn Riley1986-12-18UHC-04663-2452634983082147 Desert Sky Blvd, Mesa, AZ, 852840.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-423871CLMLauren L Johnston1983-11-27—67834631287541 Mountain View Dr, San Antonio, TX, 782010.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-411673CLMDenise U Reid2001-09-24UHC-33235-06—9368 Union St, Los Angeles, CA, 900030.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-422386CLMGregory Kennedy1991-09-21UHC-80526-0326375991036903 Sunset Blvd, Dallas, TX, 752460.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-422387CLMGregory Kennedy1991-09-21UHC-80526-0326375991036903 Sunset Blvd, Dallas, TX, 752460.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-407486CLMAbigail Hicks2001-04-05UHC-46842-79—251 Hillcrest Rd, Seattle, WA, 981760.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414842CLMSara Jimenez1968-08-07———0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-402650CLMCarolyn Lawson1945-04-13UHC-41652-5688825330467320 Elm St, Charlotte, NC, 282550.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422074CLMPriya Allen1991-02-12UHC-44110-15—4591 Maple Ave, Tampa, FL, 336880.66Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413562CLMLuis X Gry2007-11-21UHC-12522-66—8034 Park Pl, Fresno, CA0.66Middle initial moved out of first nameDate of birth reformattedZIP missingWhitespace trimmed+1 more
CLM-422138CLMRussell Nunez1987-06-15UHC-92246-28—9308 River Rd, Jacksonville, FL, 322870.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422137CLMRussell Nunez1987-06-15UHC-92246-28—9308 River Rd, Jacksonville, FL, 322870.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-410462CLMJoe Lane1974-01-10UHC-01685-4723675181151430 Camelback Rd, Austin, TX, 787970.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-410353CLMKatherine Simmons1985-07-17UHC-12054-24—1289 Main St, Scottsdale, AZ, 852600.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-401579CLMLisaJunk1947-01-24—20325376801205 Apache Blvd, Minneapolis, MN, 554270.66Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared+1 more
CLM-428601CLMAisha Rojas1956-12-18UHC-94886-3329882192866374 Ocean Ave, Dallas, TX, 752080.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-408234CLMNick Williamson1986-07-06——4949 Canyon Rd, Minneapolis, MN, 554720.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-415697CLMJudy Burns1980-12-09UHC-13174-98—3367 Maple Ave, Seattle, WA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-419925CLMHannah Park1963-09-20UHC-14529-43—8629 Mesa Dr, Tampa, FL, 336150.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-400166CLMCharlotte Wheeler1964-03-13UHC-02876-5767453733468961 Park Pl, Sacramento, CA, 958440.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-410703CLMSarah D Bowman1983-04-27—34366798173180 Apache Blvd, Los Angeles, CA, 900410.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-400441CLMBrndon Alvarado1992-07-16UHC-74312-02—1039 Valley View Dr, Scottsdale, AZ, 852730.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-432703CLMJack Kelly1977-05-26UHC-23475-39—6237 Harbor Blvd, Seattle, WA, 981760.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-404234CLMPaela Hansen2005-01-05UHC-70145-78—7482 Oak St Apt 37, Austin, TX, 787780.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-432766CLMDoris Meyer1960-12-20UHC-45303-32—7944 Valley View Dr # 547, Plano, TX, 750360.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-408437CLMFuller Mateo1997-07-09UHC-83792-60—8580 Indian School Rd, Tampa, FL, 336450.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410523CLMCharlotte Y Patel2008-08-11UHC-45528-19—2247 Mountain View Dr, Los Angeles, CA, 900240.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-429642CLMChristine Lee2000-05-13UHC-56516-8385345064718465 Lake View Rd, Gilbert, AZ, 852630.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-407335CLMVirginia Weber—UHC-10635-06——0.66Name re-casedDate of birth missingGender normalisedWhitespace trimmed+1 more
CLM-427949CLMLauren Howard2005-04-18—78243535269045 Harbor Blvd, Minneapolis, MN, 554370.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-423481CLMAisha Patterson1988-02-14UHC-02136-81—2577 Meadow Ln, Phoenix, AZ, 850060.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410982CLMMateo I Weber1955-04-19UHC-71512-78—3648 Elm St, Miami, FL, 331840.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-415139CLMMei S Jordan1974-06-14UHC-25372-8173228138108501 Canyon Rd # 926, Tampa, FL, 336320.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422835CLMJacqueline T Willis1998-05-09UHC-10956-01—1671 Market St # 806, Denver, CO, 802900.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-417016CLMAlice Soto1970-05-14UHC-08324-5666967810033964 Baseline Rd, Eden Prairie, MN, 553060.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-402791CLMDaniel Rios1954-08-24UHC-16351-4296969542976945 Pine Dr, San Diego, CA, 921960.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-403164CLMDiego Daniels1953-10-13——3198 Highland Ave, Eden Prairie, MN, 553570.66Name split from “Last, First”City re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-415023CLMJanice Herrera1986-09-18UHC-91917-46—2585 Grand Ave, Austin, TX, 787600.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-401410CLMKenneth Chavez1979-03-09UHC-84069-65—142 Spring St, Columbus, OH, 432960.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-418335CLMCamila Ramos1952-05-01UHC-23396-6031568154328909 Market St, Charlotte, NC0.66Name split from “Last, First”Phone reformattedZIP missingWhitespace trimmed+1 more
CLM-400794CLMBrittany X Estrada1967-02-12—4737247689—0.66Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+1 more
CLM-402284CLMAlan Gomez1970-09-14UHC-96329-04—4112 Central Ave, Plano, TX, 750380.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-403456CLMChristina G Orteega1985-12-27UHC-82591-3365670002723808 Central Ave, Los Angeles, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-407607CLMRichard Washington2006-06-16UHC-88336-76—8427 Camelback Rd, Glendale, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-409244CLMEmma G Robertson——7425016743434 Pine Dr, Tempe, AZ, 852420.66Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430938CLMCharles T Ford1947-03-25——8772 Maple Ave, Tucson, AZ, 857250.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-431022CLMRoneld Yang1996-10-20UHC-10472-8853051227653499 Oak St, Phoenix, AZ, 850630.66Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+1 more
CLM-427858CLMBradley Hernandez1998-05-27——2161 Washington St, Sacramento, CA, 958720.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-425353CLMIsabbella Lynch1973-11-09——7754 Valley View Dr, Gilbert, AZ, 852350.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-423728CLMGrace Hicks1993-10-19——5443 Mesa Dr, Fresno, CA, 937560.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
32,829 rows, page 194 of 657PreviousNext