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-423427CLMRalph Knight1998-02-15——3878 Jefferson Ave, Seattle, WA, 981550.66City re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-432533CLMArjun Hanson1962-01-24UHC-47578-88—7609 Spring St, Seattle, WA, 981090.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-410190CLMGabriel Ward1972-06-13——2708 River Rd # 202, Austin, TX, 787380.66Date of birth reformattedUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
CLM-420427CLMThomas Carter1984-12-06——4427 Maple Ave, Glendale, AZ, 853040.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-414210CLMDanielle Webar1961-11-12——9546 Valley View Dr, Scottsdale, AZ, 852740.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-405603CLMRaymond Gardner1948-01-19——1331 Indian School Rd # 254, Scottsdale, AZ, 852600.66Name re-casedDate of birth reformattedUnit split from streetZIP+4 trimmed+1 more
CLM-402863CLMTimothy Le1982-07-08UHC-27033-98—1198 Washington St, Phoenix, AZ0.66Name re-casedMember ID reformattedZIP missingGender normalised+1 more
CLM-411284CLMGrace K Harrison1956-10-08UHC-04847-634546100957592 Ocean Ave, Mesa, AZ, 852560.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-413022CLMJulie M Armstrong1995-02-28——1904 Sunset Blvd, Chandler, AZ, 852390.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-402783CLMWei C Carlson1949-12-04—67290082033604 Hillcrest Rd Apt 18, Glendale, AZ, 853020.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-412698CLMNathan Franklin1942-08-05UHC-12055-1688324036153003 Sage Ct, Chandler, AZ, 852020.66Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
CLM-424592CLMPaul Estrada1983-07-26UHC-63153-81—5930 Ridge Rd Apt 23, Seattle, WA, 981130.66Unit split from streetCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-418353CLMBobby Wright1995-04-03UHC-74847-8448465564248097 Central Ave, Eden Prairie, MN, 553230.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-423526CLMRuth Clark1982-10-24UHC-55596-08—2811 Apache Blvd, Nashville, TN, 372600.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-427202CLMWilliam Hansen1974-02-21UHC-24086-77—201 River Rd, Jacksonville, FL, 322470.66Phone missing area codeMember ID reformattedState code upper-casedGender normalised+1 more
CLM-421310CLMDouglas Padilla1983-05-27UHC-70673-95—6987 Park Pl, Atlanta, GA, 303120.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-431439CLMAnn Hoffman2008-02-22—33999350161273 Ocean Ave, Minneapolis, MN, 554680.66Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+1 more
CLM-401335CLMSaa W Gomez2002-04-12UHC-60271-3865365452305624 Elm St, Columbus, OH, 432980.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-429198CLMDaniel Alexander1961-03-27——100 Oak St, Nashville, TN, 372280.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-415791CLMMichelle Schultz1971-05-14UHC-74086-57—4881 Lincoln Way, Scottsdale, AZ, 852450.66Date of birth reformattedCity re-casedZIP+4 trimmedGender normalised+1 more
CLM-424231CLMStephanie B Porter1974-01-20——3850 Jefferson Ave, Los Angeles, CA, 900860.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-431765CLMDylan H Alexander2003-08-15UHC-29580-17—4658 Valley View Dr # 324, Los Angeles, CA, 900280.66Name split from “Last, First”Date of birth reformattedUnit split from streetWhitespace trimmed+1 more
CLM-406154CLMAustin Robertson1968-04-21——8721 Palm Dr, Las Vegas, NV, 891270.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410966CLMHiroshi Harrison1948-04-27UHC-09174-09—8739 Ocean Ave, Las Vegas, NV, 891290.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-406184CLMLaura Anderson—UHC-07846-02—5977 River Rd, Nashville, TN, 372140.66Name re-casedDate of birth missingGender normalisedWhitespace trimmed+1 more
CLM-424249CLMWalter O Carter1998-01-14UHC-11426-79—6131 Lincoln Way, Phoenix, AZ0.66Two-digit birth yearCity re-casedZIP missingWhitespace trimmed+1 more
CLM-428626CLMDouglas Kelly1994-05-25—96444243329857 Washington St, Charlotte, NC, 282310.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430174CLMJohn Matthews1957-08-27UHC-47617-95—5065 Indian School Rd, Plano, TX, 750290.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
CLM-415250CLMTyler Gomez1972-04-01——33 Main St, Atlanta, GA, 303700.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-413015CLMGabriel Dominguez1961-06-01UHC-64727-36—3778 Spring St, Scottsdale, AZ, 852820.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-420311CLMSandra Kellye1960-02-27UHC-48028-88—6943 Lincoln Way, Tucson, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-426101CLMBeveryl Morales1955-05-12UHC-59503-45—1235 Cedar Ln, San Diego, CA, 921760.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-423142CLMOlivia Tucker1946-05-01UHC-36764-8158560171476613 Highland Ave, Tucson, AZ, 857800.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-425249CLMEthan S Sims1969-05-08UHC-64045-26—6288 Elm St, Plano, TX, 750050.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-410991CLMJulia Franklin2001-03-26UHC-21881-2538839612902038 Indian School Rd, Jacksonville, FL0.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-413766CLMBradley Fowler1996-12-25UHC-39855-0680157358659853 Lake View Rd, Gilbert, AZ, 852880.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-427117CLMGabriel Gonzalez1939-10-10UHC-48725-0275560399462465 Central Ave # 885, Orlando, FL, 328770.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-431676CLMSophia Jacobs1941-04-15UHC-74205-2424731066648862 Bayshore Dr # 497, Mesa, AZ, 852090.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-411944CLMRussell Montgomery1939-05-18UHC-52136-1894432878991323 Elm St # 996, Tampa, FL, 336540.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-413670CLMCharles Hayes1979-05-14UHC-18806-91—4463 Park Pl, Houston, TX, 770730.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-422574CLMSamantha Reid1944-10-26—62228675458681 River Rd, San Antonio, TX, 782730.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-423189CLMJesse Armstrong1941-04-03UHC-52920-6386371555112778 Elm St, Miami, FL, 331090.66Name split from “Last, First”Date of birth reformattedCity re-casedGender normalised+1 more
CLM-418158CLMChristopher Cunningham1990-03-02UHC-09111-69—9136 Apache Blvd, Seattle, WA, 981200.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-417203CLMCarlos Torres1970-09-14UHC-33962-64—1314 Hillcrest Rd, Mesa, AZ, 852200.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-414656CLMRalph Hudson1995-08-07——1667 Mountain View Dr, Jacksonville, FL, 322620.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-413053CLMDeborah O Godron1941-05-26UHC-25069-0133983062726829 Ridge Rd, Houston, TX, 770070.66Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+1 more
CLM-425399CLMIsabella Lee1954-08-09——4462 Market St, Atlanta, GA, 303680.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-419210CLMJudith Robertson1974-05-11UHC-96845-24—9604 Elm St, Nashville, TN0.66City re-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-416805CLMAaron Hernandez1991-12-10——4536 Union St, Tempe, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-430406CLMMichelle Gordon1967-03-12—50740354685834 River Rd, Minneapolis, MN0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
32,829 rows, page 156 of 657PreviousNext