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-404704CLMJesse Walker1941-05-04——5667 Camelback Rd, Columbus, OH, 432860.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-406946CLMEmma I Santiago1995-03-17——5006 Spring St # 378, Denver, CO, 802280.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-405318CLMDannielle Q Jackson1954-10-11———0.66Middle initial moved out of first nameName re-casedTwo-digit birth yearWhitespace trimmed+1 more
CLM-401945CLMChristina Nguyen2003-04-20UHC-52000-64—9150 Harbor Blvd, San Diego, CA, 921820.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-427242CLMStephen X Carter1945-09-16——8200 Pine Dr, Tempe, AZ, 852450.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-412120CLMVirginia H Morrison1981-02-21—81758047837046 Valley View Dr, Las Vegas, NV, 891690.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-416348CLMArjun Anderson2006-04-21——7072 Desert Sky Blvd, Austin, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-419503CLMAndrew Freeman1985-08-02—41452015178606 Church St, Denver, CO, 802210.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-429236CLMKen Barnes1982-10-20UHC-22269-87—737 Oak St, Chandler, AZ, 852400.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-418279CLMBeverly Moreno1955-04-28UHC-40140-87—5553 Grand Ave, Glendale, AZ, 853480.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-408969CLMMegan F Bradley1967-01-09——251 Grand Ave, Fresno, CA, 937690.66Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-403585CLMLuis Ramos2006-08-19—71670343103844 Ridge Rd, San Antonio, TX, 782480.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-429486CLMStephen King1969-01-20UHC-15796-58—5493 Meadow Ln, Los Angeles, CA, 900190.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-432225CLMFatima Jacobs1974-02-04UHC-41356-3331075608704275 Union St, Mesa, AZ, 852060.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-400409CLMMary Lucas1972-07-10——6062 Harbor Blvd, San Diego, CA, 921820.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-409012CLMRaymond N Marshall1962-04-13UHC-07714-18—495 Apache Blvd, San Antonio, TX, 782980.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-405702CLMAnna Q Carpenter1952-02-03UHC-11448-9390696220135759 River Rd, Jacksonville, FL, 322880.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-415861CLMJulie Fernandez1941-10-24——6804 Harbor Blvd, Chandler, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-428689CLMWalter A Tucker1976-12-11UHC-36982-7488791366327362 Desert Sky Blvd, Jacksonville, FL, 322530.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-403600CLMJudy Burke1968-03-10UHC-81539-57—7561 Broadway, Columbus, OH, 432820.66Name split from “Last, First”Address re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-427385CLMDebbie Perry1941-09-28UHC-90537-3848160850491929 Oak St, Fresno, CA, 937770.66Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+1 more
CLM-414312CLMStephanie Mejia1984-11-12—56484769843840 Highland Ave, Glendale, AZ, 853830.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-405492CLMTheresa Harvey1953-09-10——1065 Lake View Rd, Mesa, AZ, 852190.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-428646CLMMadisoon J Johnston1967-12-21——5120 Palm Dr, Phoenix, AZ, 850100.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-426911CLMSusaan Morrison1959-02-28———0.66Name re-casedDate of birth reformattedSSN last four extractedGender normalised+1 more
CLM-404985CLMKaren Wells1991-03-06UHC-21724-1536639268883117 Central Ave, Minneapolis, MN, 554070.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-403722CLMJulie Simmons1977-12-28——3742 Forest Ave, Tucson, AZ, 857830.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-406188CLMJerry Meyer1954-02-05—68188037806076 Pine Dr, Plano, TX0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-421057CLMSamuel Bennett———6650 Mountain View Dr, Tampa, FL, 336170.66Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-406735CLMChristian Z Santiago1987-03-15——3993 Jefferson Ave, San Antonio, TX, 782020.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-402460CLMChristian Gomez1984-11-27——7865 Bayshore Dr, Austin, TX, 787330.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-430256CLMAlbert Lynch1976-06-16——3732 Sage Ct, Denver, CO, 802750.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-415958CLMJoan T Lee1994-08-13——4173 Apache Blvd, Jacksonville, FL, 322260.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-403773CLMBryan A Guerrero1988-06-06—30057804867948 Ridge Rd, Sacramento, CA, 958880.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-428735CLMPatricia Coleman—UHC-71949-76—6613 Apache Blvd, Atlanta, GA, 303440.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
CLM-404519CLMAlexis Harvey1991-02-11UHC-56292-0459961900886202 Bayshore Dr, Nashville, TN, 372110.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-420158CLM—Junk1946-11-05UHC-87019-89—3708 Apache Blvd, Scottsdale, AZ0.66Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared+1 more
CLM-432188CLMStephen Gibson1995-11-22UHC-07734-297075574177—0.66Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed+1 more
CLM-412650CLMOmar R Baker1982-12-17UHC-82232-6179469558985030 Desert Sky Blvd, Orlando, FL, 328080.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-410901CLMEvelyn Garrett1942-11-19UHC-93545-01—2256 River Rd, Jacksonville, FL, 322700.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-405178CLMKathy Ortiz2002-12-20UHC-91659-1538880398208356 Indian School Rd, Charlotte, NC, 282410.66Name split from “Last, First”Phone reformattedState name converted to codeWhitespace trimmed+1 more
CLM-413118CLMYuki Ortega—UHC-69924-7892487647979570 Cedar Ln, Los Angeles, CA, 900890.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
CLM-423009CLMCarolyn Long1977-07-03UHC-14882-88—9864 Desert Sky Blvd Apt 8, San Diego, CA, 921880.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-419885CLMSara Schultz1949-10-05UHC-16036-07—7856 Union St # 583, Atlanta, GA, 303470.66Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-412409CLMWillie Armmstrong1957-11-18UHC-69417-6623880154335056 Market St, Las Vegas, NV, 891730.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-420578CLMJuan Lewis———4772 Jefferson Ave, Scottsdale, AZ, 852070.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
CLM-425976CLMGeorge Smith2008-06-25UHC-87014-69—8472 Cedar Ln, Fresno, CA, 937830.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402642CLMAdam Delgado—UHC-54823-07—7282 Maple Ave, Tampa, FL, 336720.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-420748CLMWalter Hernandez2001-11-13——2225 Ridge Rd, Nashville, TN0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-413962CLMGerald Hudson—UHC-90982-29—522 Church St, Houston, TX, 770120.66Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
32,829 rows, page 187 of 657PreviousNext