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-410545CLMNicole Nunez———6643 Valley View Dr, Dallas, TX0.52Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-429166CLMNathan Peters1984-03-14——7611 Spring St, Gilbert, AZ, 852630.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416347CLMArjun Anderson2006-04-21UHC-43813-38—7072 Desert Sky Blvd Apt 18, Austin, TX0.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-412637CLMSteve Hoffman2007-05-08UHC-34421-69—4134 Harbor Blvd, Denver, CO, 802990.52Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
CLM-430502CLMPamela Guzman1982-06-11—40958810189168 Mountain View Dr, Tempe, AZ, 852570.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400632CLMJustin R Robertson2005-01-13UHC-36053-5055747068012985 Market St, Sacramento, CA, 958300.52Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
CLM-425235CLMDebra Garza1968-12-21UHC-76716-09—6122 Highland Ave, Austin, TX, 787560.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427491CLMKyle Salazar1941-01-26——4948 Ocean Ave, Tucson, AZ, 857260.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427490CLMKyle Salazar1941-01-26——4948 Ocean Ave, Tucson, AZ, 857260.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402897CLMWayne E Coleman1961-12-22——691 Grand Ave, Tampa, FL0.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-426622CLMDonna T Myers1954-01-21UHC-28456-299273674387648 Oak St, Gilbert, AZ0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-427728CLMAlexander Smith1958-09-25UHC-06478-9255838274011669 Park Pl Apt 10, Los Angeles, CA, 900200.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-418577CLMKeith Hicks1951-08-22—64640510053052 Canyon Rd, Minneapolis, MN0.52Name re-casedState name converted to codeZIP missingGender normalised+2 more
CLM-418576CLMKeith Hicks1951-08-22—64640510053052 Canyon Rd, Minneapolis, MN0.52Name re-casedState name converted to codeZIP missingGender normalised+2 more
CLM-418153CLMHrold K Mejia1969-10-17——1262 Willow Ct, Nashville, TN, 372700.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-415618CLMLogan Lawson1992-11-11—28368073939216 Mesa Dr Apt 38, Atlanta, GA, 303130.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431976CLMSam Ray1998-10-01UHC-71219-6732195835279124 Spring St, Charlotte, NC, 282990.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429557CLMAlexis Elliott1987-05-15UHC-17159-14—1711 Canyon Rd Apt 33, Tempe, AZ, 852600.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-429159CLMJason Z Thompson———1783 Indian School Rd, Nashville, TN, 372410.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-431732CLMYuki Williamson—UHC-67835-3425984892704914 Sage Ct, Jacksonville, FL, 322700.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-408381CLMNicholas Phillips1985-06-03——804 Cedar Ln, Mesa, AZ, 852710.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426681CLMJudith Larson—UHC-46251-9968364988066318 Sunset Blvd, Columbus, OH, 432370.52Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-430409CLMLucia Campbell1990-05-09UHC-20371-54—8774 Maple Ave, Fresno, CA, 937230.52Date of birth reformattedPhone missing area codeSSN last four extractedStreet suffix standardised+2 more
CLM-421676CLMJanice K Fox1953-01-27——3828 Meadow Ln, Nashville, TN0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428690CLMLucia Rios1939-04-02——5436 Camelback Rd, Denver, CO, 802480.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-428691CLMLucia Rios1939-04-02——5436 Camelback Rd, Denver, CO, 802480.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-411374CLMPamela Burns—UHC-07299-885162417294—0.52Name split from “Last, First”Date of birth unreadablePhone reformattedGender normalised+2 more
CLM-407519CLMMelissa Walsh—UHC-81070-1565859286899218 Bayshore Dr, Phoenix, AZ, 850510.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-431988CLMAustin Hansen2002-05-16——9390 Lincoln Way, Minneapolis, MN, 554100.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-412805CLMBrittany Hernandez1972-01-22——8092 Washington St, Miami, FL, 331520.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-408675CLMMariana L Russell1975-04-08UHC-35952-6071723875879455 Ridge Rd, Nashville, TN0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-402289CLMLauren Guzman1969-10-09UHC-74677-1480472475126579 Bayshore Dr, Dallas, TX0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-407703CLMNatalie Singh1946-01-04——1116 Market St, Chandler, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-406932CLMAmber O Delgado1998-09-15UHC-52060-85—6469 Market St, Minneapolis, MN, 554010.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426608CLMSarah Fisher1964-11-02UHC-62164-9883661733434209 Pine Dr, Fresno, CA, 937650.52Name split from “Last, First”Date of birth reformattedZIP+4 trimmedGender normalised+2 more
CLM-416321CLMGabriel Carr2007-02-14——2015 Jefferson Ave, Tempe, AZ, 852720.52Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+2 more
CLM-408729CLMFernandez Maria1962-12-10UHC-85600-60—9762 Forest Ave, Gilbert, AZ, 852550.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430828CLMSandra Jaackson1946-04-25UHC-53077-56—3183 Union St # 539, Fresno, CA, 937280.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431878CLMJeremy Dunncan1977-04-20——3976 Mountain View Dr, Fresno, CA, 937090.52SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403856CLMShirley Fowler1997-01-19UHC-32210-23—6694 Sage Ct, San Diego, CA0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-420586CLMMargaret Carlson1983-05-22——4067 Ridge Rd, Plano, TX, 750030.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426411CLMFrances Payne2003-01-05——2425 Willow Ct, Scottsdale, AZ, 852520.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-422762CLMOmar Freeman1968-07-21UHC-21072-5871127394046603 Highland Ave, Seattle, WA, 981780.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428152CLMGloria Yang1940-02-03UHC-03625-33—9382 Indian School Rd, Orlando, FL, 328710.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413032CLMBrittany Lucas2000-03-27——1258 Park Pl, Plano, TX, 750170.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403620CLMBrandon V Lopez1955-02-03—3293167866—0.52Name re-casedTwo-digit birth yearSSN last four extractedGender normalised+2 more
CLM-424167CLMMark Reyes1985-09-11——5171 Sage Ct, Gilbert, AZ, 852040.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-404337CLMRuth Q Hamilton1955-10-14UHC-05019-35—8217 Oak St, Phoenix, AZ, 850950.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-409420CLMRichards Luis1969-08-21UHC-28814-4392046173396338 Indian School Rd # 705, Gilbert, AZ, 852250.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408384CLMJoe Robinson1941-10-27—26341068895475 Lake View Rd, Jacksonville, FL0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 51 of 657PreviousNext