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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-422579CLMGerge Z Flores1959-01-16UHC-44693-88—8251 Pine Dr, Jacksonville, FL, 322800.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-118573ENRPriyya Moore1977-07-03UHC-65655-6348628872448579 Hillcrest Rd, Glendale, AZ, 853640.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-426707CLMGregory Palmer1975-11-04——7816 Apache Blvd # 727, Chandler, AZ, 852090.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412719CLMCarlos Hunt1971-12-18UHC-24311-47—1181 Desert Sky Blvd, San Diego, CA, 921180.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-27160PRVJuy Kim1947-05-11—26559551751313 Market St, Miami, FL, 331610.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414593CLMKaylla N Mendez1963-06-14UHC-45096-59—3449 Forest Ave, Plano, TX0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-113302ENRDebra M Bradley1971-01-11UHC-29050-7375452612871134 Maple Ave, Scottsdale, AZ, 852540.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-422597CLMKimberly Green1987-09-27UHC-75762-9082233950111921 Hillcrest Rd, Orlando, FL, 328230.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121042ENRDiane A Hunter1964-01-01UHC-50127-4989837748268372 Lake View Rd Apt 30, Plano, TX, 750120.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-423619CLMDiane Ramos1951-10-02UHC-44594-976556412449131 Willow Ct, Glendale, AZ, 853500.50Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-120879ENRDebra Young1945-02-12UHC-20229-0556426813558723 Park Pl, Houston, TX, 770500.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120530ENRBarbara C Fisher1938-06-16UHC-18628-8657288192694226 Church St, Orlando, FL, 328220.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-122540ENRAshlye Fields1986-05-25UHC-74750-4575224248986344 Forest Ave, Jacksonville, FL0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402422CLMLauren Carroll1963-12-24UHC-72475-9886671074302829 Lake View Rd, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-58089TPAIsabella Harvey1942-01-02——3704 Highland Ave, Columbus, OH0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127444ENREthan M Taylor1997-03-22UHC-84782-4978846470564991 Lincoln Way, Austin, TX, 787860.50Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more
ENR-140285ENRHiroshi Y Sims1972-10-22UHC-85479-928352798010393 Lincoln Way, Fresno, CA, 937660.50Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+3 more
CLM-409335CLMScottJunk1954-07-22UHC-89192-2237049541479154 Cedar Ln, Seattle, WA, 981020.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421723CLMDebra Holmes2003-01-12UHC-55286-16—6762 River Rd, Eden Prairie, MN, 553260.50Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-133892ENRKathryn Waren1959-03-12UHC-71018-9431671364606289 Jefferson Ave, Los Angeles, CA, 900130.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-120659ENRKayla Kim1993-05-19UHC-11035-6230947464339631 Church St # 591, Los Angeles, CA, 900920.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-54767TPADennis Watkins1951-03-20——7949 Jefferson Ave, San Diego, CA, 921970.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130458ENRVJunk1999-05-04UHC-41301-4176635427432788 Sage Ct, Plano, TX, 750350.50Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
PRV-24658PRVKathryn Ortega2002-07-27UHC-85581-79—1848 Main St, Atlanta, GA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54201TPAAisha Stephens1996-04-17——2778 Valley View Dr, Minneapolis, MN, 554350.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418881CLMAnnna Ward1958-06-16—60142151321243 Oak St, Minneapolis, MN, 554930.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420041CLMVirginia Wilson1999-05-18UHC-88267-97—7763 Oak St # 570, San Antonio, TX, 782680.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-136968ENRMaason H George1999-06-17UHC-70059-3963183697638193 Meadow Ln, Gilbert, AZ, 852360.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108696ENRCynthia Q Owens1961-04-27UHC-95956-5771824249789409 Main St, Phoenix, AZ, 850510.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425780CLMAlbert Sanders1975-04-25UHC-20970-55—7144 Market St, Las Vegas, NV, 891140.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403478CLMSharon Byod1957-07-20UHC-93216-37—4822 Camelback Rd, Minneapolis, MN, 554710.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-406314CLMCheryl Grant1948-07-19UHC-37922-3982071450047726 Broadway Apt 18, Gilbert, AZ, 852140.50Name split from “Last, First”Date of birth reformattedUnit split from streetAddress re-cased+3 more
ENR-120858ENRTeresa Fox1961-05-17UHC-55652-5770834514643267 Camelback Rd, Minneapolis, MN, 554370.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-25461PRVBarbara F James1988-06-23UHC-77875-98—2480 Ocean Ave # 741, Miami, FL, 331030.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25758PRVEthan Simmons1947-08-08UHC-10103-539273792900922 Palm Dr, Tempe, AZ, 852590.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51014TPARyan S Boyd1998-11-04——3945 Sage Ct, Mesa, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-124338ENRDebra Z Black2004-05-25UHC-02549-2547572302232045 Valley View Dr # 897, San Diego, CA, 921080.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-424281CLMAdam Taylor1958-11-06UHC-10122-04—5074 Ocean Ave, Scottsdale, AZ, 852520.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-406138CLMDiana Berry1978-03-11UHC-53245-5368165813248859 Spring St Apt 30, Miami, FL, 331970.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-407248CLMGrace Hayes—UHC-70367-18—4935 Apache Blvd # 663, Orlando, FL, 328040.50Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+3 more
ENR-127108ENRBeth Kennedy1946-03-05UHC-31956-4893228501282428 Valley View Dr Apt 36, Jacksonville, FL, 322870.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-405716CLMFrances Davsi2002-03-11UHC-96294-82—6445 Washington St, San Antonio, TX, 782360.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115774ENRHiroshi Lawrece1943-01-16UHC-54967-0128351696727093 Grand Ave, Scottsdale, AZ, 852750.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-124765ENRKayla A Garrett1993-01-02UHC-84412-0459527114003765 Desert Sky Blvd, Fresno, CA, 937730.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
ENR-124764ENRKayla A Garrett1993-01-02UHC-84412-0459527114003765 Desert Sky Blvd, Fresno, CA, 937730.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
PRV-24726PRVRonald Lee1941-06-28——7618 Desert Sky Blvd, Seattle, WA0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-52228TPALawrence Ward1983-01-07UHC-20136-99—664 Elm St, Tempe, AZ0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
ENR-107830ENRCrlos Salazar1992-08-07UHC-04052-2140797028872954 Canyon Rd, Phoenix, AZ0.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62060TPARichard Harrison1988-06-17——3120 Main St, Tampa, FL0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-125130ENRSam Johnstton1951-06-13UHC-73743-6293642292423367 Desert Sky Blvd, Seattle, WA, 981130.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
100,000 rows, page 93 of 2,000PreviousNext