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-416411CLMAmber Bryant—UHC-16604-78—2103 Church St, Mesa, AZ, 852470.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422781CLMJudy Wang1985-04-05UHC-93720-2837186824866688 Washington St, Houston, TX0.66Name split from “Last, First”Phone reformattedZIP missingWhitespace trimmed+1 more
CLM-429321CLMKatherine Porter1998-09-10UHC-66665-29—8284 Willow Ct, Eden Prairie, MN, 553920.66Date of birth reformattedPhone missing area codeSSN last four extractedCity re-cased+1 more
CLM-400817CLMNooah Yang—UHC-48251-048952513917—0.66Name re-casedDate of birth unreadablePhone reformattedGender normalised+1 more
CLM-413455CLMHannha Ferguson1991-12-11UHC-39726-6652043898943085 Jefferson Ave, Eden Prairie, MN, 553060.66Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-416486CLMOlivia W Maldonado1959-04-02UHC-73748-47—3376 Washington St, Gilbert, AZ, 852850.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-408900CLMAlexis A Lawson1941-07-05UHC-03023-1448630824865486 Church St, Eden Prairie, MN, 553330.66Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
CLM-414160CLMBrandon Fowler1937-06-25UHC-57396-57—820 Mesa Dr Apt 14, Minneapolis, MN, 554440.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-425989CLMKevin V Knight1953-01-22UHC-45883-68—7111 Ridge Rd, Minneapolis, MN, 554440.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422218CLMLauren Payne—UHC-12594-86—6651 Palm Dr, Plano, TX, 750680.66Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-407907CLMHeather Guzman1994-03-07—87563949258989 Pine Dr Apt 12, Minneapolis, MN, 554790.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-404946CLMJoe O Salazar1995-08-18UHC-98084-25—8258 Hillcrest Rd, Seattle, WA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-418834CLMJacob King1999-06-22UHC-05410-78—6356 Washington St, Tempe, AZ, 852720.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-413037CLMJessica T Snyder1964-07-06UHC-92417-5120953711117170 Desert Sky Blvd # 916, Sacramento, CA, 958660.66Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+1 more
CLM-407192CLMAndrea T Gilbert2000-09-22UHC-60971-0373993542192744 Valley View Dr, Los Angeles, CA, 900370.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-426557CLMJanet Chapman1957-05-01UHC-92930-87—41 Apache Blvd, Miami, FL, 331380.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-412463CLMMargaret Hoffman1983-03-15UHC-84121-2683431149324553 Canyon Rd, Scottsdale, AZ, 852040.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-423043CLMEmily Hicks2002-10-01UHC-24836-7186460499231755 Willow Ct, Plano, TX, 750510.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430713CLMBrittany Banks1948-07-03UHC-86957-869155051099493 Camelback Rd, Orlando, FL, 328580.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-407801CLMEric Lane——53566846099899 Central Ave, Tampa, FL, 336300.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-432101CLMJason Rogers1955-10-21UHC-81029-9173839661023757 Pine Dr, Minneapolis, MN, 554140.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-416992CLMJennifer Little1954-06-06UHC-31231-20—6996 Lincoln Way, Jacksonville, FL, 322300.66Date of birth reformattedState name converted to codeEmail lower-casedGender normalised+1 more
CLM-414151CLMRalph Cole1964-06-11UHC-07842-5725187141109782 Valley View Dr, Tucson, AZ, 857780.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-421919CLMBetty Griffin1955-04-26——8221 Bayshore Dr Apt 32, Sacramento, CA, 958610.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-406808CLMAmanda Evans2000-03-03UHC-14543-34—3904 Ocean Ave, San Diego, CA, 921540.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-422963CLMHoffman Debra1983-03-20UHC-18077-63—7106 Apache Blvd, Tampa, FL, 336310.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-420732CLMJaack Ray—UHC-59604-32—7181 Cedar Ln, Plano, TX, 750960.66Date of birth unreadableCity re-casedGender normalisedWhitespace trimmed+1 more
CLM-420355CLMJessica McCoy1952-01-10UHC-14823-28—2580 Hillcrest Rd, Jacksonville, FL, 322870.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-408056CLMRuth Harper1949-07-03UHC-27779-179407456612—0.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
CLM-407211CLMChristopher N Webb1988-01-17UHC-62698-47—3164 Union St, Houston, TX, 770680.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-422566CLMRyan Harrison1958-11-16UHC-72506-7957036126682325 Washington St, Atlanta, GA, 303530.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-401760CLMKatherine T Russell1954-11-01UHC-43937-93—1701 Washington St, Las Vegas, NV, 891760.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-424152CLMAnn Harper1944-02-20——9213 Camelback Rd, Austin, TX, 787760.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-426613CLMStephanie Pierce1981-10-12UHC-32289-79—7115 Camelback Rd, San Antonio, TX, 782930.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-421097CLMDennis Holmes1981-01-15UHC-23663-34—8792 Elm St, Miami, FL, 331530.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-429265CLMTerry Russell1940-06-04——8387 Apache Blvd, Charlotte, NC, 282040.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-427432CLMBrittany Marquez1964-12-27——4717 Spring St, Columbus, OH, 432490.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-419756CLMGreene Noah1950-02-17UHC-68781-1267644169811784 River Rd, Atlanta, GA0.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-416518CLMChristian Ferguson1949-08-19UHC-15332-76—7562 Indian School Rd, Fresno, CA, 937330.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-409354CLMMegan Lee2001-01-08UHC-95660-419516442188153 Bayshore Dr, Sacramento, CA, 958450.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-422685CLMDiego Richardson1943-08-13UHC-07366-97—9038 Cedar Ln, San Antonio, TX, 782140.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-407462CLMAna Hunter2008-10-04UHC-68356-50—6740 Hillcrest Rd, Las Vegas, NV, 891210.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-417264CLMScott N Gonzales1994-01-25——7746 Pine Dr, Tampa, FL, 336420.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-422079CLMNatalie J Murphy2002-12-24—79599204882401 Union St Apt 17, Austin, TX0.66Name re-casedDate of birth reformattedPhone reformattedUnit split from street+1 more
CLM-407380CLMJeremy Nichols1978-04-27UHC-36703-86—7024 Indian School Rd, Orlando, FL, 328600.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-421924CLMTheresa Henry1990-12-11——8184 Meadow Ln Apt 11, San Diego, CA, 921750.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-426323CLMGloria Guzman1939-05-23——5838 Pine Dr, Glendale, AZ, 853940.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-406613CLMJose O Roberts1924-07-12UHC-90725-16—1301 Elm St # 495, Jacksonville, FL, 322900.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-411627CLMSntiago Henry1995-11-06UHC-14707-793157058390226 Canyon Rd, Mesa, AZ, 852550.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410234CLMJanice W Lopez1947-05-11—78831634282564 Lincoln Way Apt 1, San Antonio, TX, 782930.66Phone reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
32,829 rows, page 163 of 657PreviousNext