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
ENR-106399ENRSofai R Phillips1978-12-26UHC-88188-9271398690656707 Camelback Rd, Chandler, AZ0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-105416ENRBetty Padilla1979-09-12UHC-00259-16—7491 Canyon Rd, Tampa, FL, 336090.48Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
PRV-21297PRVHeather O Griffin1987-08-11——8521 Palm Dr, Jacksonville, FL, 322780.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-138156ENRLuis P Powell—UHC-83291-9540084208687966 Ridge Rd, San Diego, CA, 921150.48Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-418123CLMDonald Sullivan1972-02-12UHC-55880-2681742480369412 Main St, Fresno, CA, 937090.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-124854ENREthan T Mitchell1954-08-17UHC-64818-2129385248064533 Valley View Dr, Atlanta, GA, 303720.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-141950ENROlivia Morales1966-11-08UHC-35280-0890596053592325 Forest Ave, San Diego, CA, 921480.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127103ENRBenjamin B Weaver1996-08-10UHC-20232-99—3047 Willow Ct, Columbus, OH, 432040.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23763PRVSean Holmes2003-08-13UHC-34874-0930738459417645 Apache Blvd, Dallas, TX, 752100.48Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-418024CLMYuki Murphy1945-05-16UHC-24467-3779521925343311 Ocean Ave, Sacramento, CA, 958160.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-112267ENRJason K Gordon1952-06-05UHC-52450-2822773068128596 Desert Sky Blvd, Plano, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54828TPADaivd Knight1981-12-18——5178 Baseline Rd Apt 32, Plano, TX, 750120.48Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+4 more
CLM-409460CLMChristian X Rojas2002-10-10—77399203812152 Oak St, Phoenix, AZ, 850740.48Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
TPA-51410TPAJean Contreras1943-06-21UHC-29251-6525559301533730 Hillcrest Rd, San Antonio, TX, 782020.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22021PRVVirginia N Carr1959-09-19UHC-61614-4032544514529085 Church St, Dallas, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58722TPAGrace Perkins2008-07-20UHC-06554-4722560176959709 Willow Ct Apt 21, Tempe, AZ, 852690.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-101433ENRJacqueline E Kelley1980-06-05UHC-56860-9140420300744235 Highland Ave, Houston, TX, 770140.48Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more
PRV-22939PRVSean Vasquez1953-03-25UHC-70165-8843392404635831 Palm Dr, Austin, TX0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131083ENRBrittany H Robertson1974-04-20UHC-97321-7325534974924828 Union St, Sacramento, CA, 958930.48Middle initial moved out of first nameMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-413332CLMDouglas Henderson1997-01-10UHC-07476-5177093864901129 Market St, Eden Prairie, MN, 553650.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-138746ENRMei Robertson1987-02-22UHC-47647-4673286251728987 Desert Sky Blvd, Jacksonville, FL, 322750.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-105437ENRPeter Li1990-06-04UHC-75872-7626929854734194 Washington St, Minneapolis, MN, 554400.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421486CLMJohn Fox1942-08-28UHC-40679-1571979975339468 Palm Dr, Dallas, TX, 752040.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-432040CLMBrittany Shaw—UHC-43130-1650761705626327 Ridge Rd, Denver, CO, 802990.48Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-411438CLMBrenda Tran1994-10-17UHC-06212-91—9506 Lake View Rd, Tucson, AZ, 857390.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-129855ENRMegan K Johnston1999-09-12UHC-38617-0848649218816312 Ridge Rd, San Diego, CA0.48Street suffix standardisedAddress re-casedCity re-casedState name converted to code+4 more
CLM-402628CLMRuth Vargas2001-04-09UHC-73294-7584692708477794 Union St, Glendale, AZ0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102158ENRPhilip T Hall1945-11-02UHC-71742-6423728093303728 Hillcrest Rd, San Diego, CA, 921770.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-401008CLMJese Carr1978-10-15—88191167046123 Willow Ct, Gilbert, AZ0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26637PRVStephen Murphy2002-07-19—27147756405656 Central Ave, Atlanta, GA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63997TPAGabriel Gilbert1987-01-10—69131996139797 River Rd, Tucson, AZ, 857230.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-58165TPARalhp Montgomery1968-03-03—47132203868841 Central Ave, Jacksonville, FL, 322230.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24074PRVDavid I Hernandez1987-06-28UHC-79977-02—8201 Camelback Rd, Orlando, FL0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
PRV-24075PRVDavid I Hernandez1987-06-28UHC-79977-02—8201 Camelback Rd, Orlando, FL0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-100964ENRJon W Bryant1980-03-06UHC-60743-9420675263096901 Baseline Rd, Plano, TX, 750330.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-21575PRVBenjamin Olson2003-05-25UHC-22547-3453665301157725 Palm Dr # 418, Las Vegas, NV, 891950.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-61729TPAElijah Moorales1950-03-08——7332 Forest Ave # 968, Columbus, OH, 432160.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-138806ENRTyler H Holmes1946-08-06UHC-39697-4163244445331884 Grand Ave, Houston, TX, 770520.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-414422CLMBanks Nicole1996-12-26UHC-03903-8755140458992517 Mountain View Dr, Mesa, AZ, 852000.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-110929ENRShirley Obriien2000-12-26UHC-56714-8759432486854525 Hillcrest Rd, Gilbert, AZ, 852600.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
TPA-55425TPAAngela Richardson1947-10-24—88471437947082 Oak St, Houston, TX, 770460.48Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-411331CLMDylan F Dean—UHC-33903-053722813844—0.48Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more
PRV-22554PRVJacqueline Baker1945-11-08——6071 Palm Dr, Atlanta, GA, 303600.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-400529CLMDorothy Hill1999-08-03UHC-52013-5327076886477095 Elm St, Orlando, FL, 328630.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-103999ENRJudith Brown2002-05-09UHC-51197-1098380689753207 Maple Ave Apt 15, Scottsdale, AZ, 852950.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-137589ENRKevin Howard1967-09-16UHC-68679-3948343847195866 Sunset Blvd, Chandler, AZ, 852120.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-21690PRVAdam Wright1944-07-04—29086743947199 Sunset Blvd, Gilbert, AZ0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-402418CLMNatalie S Guzman1994-02-26UHC-13685-4628253780103513 Central Ave Apt 22, Plano, TX, 750080.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-429419CLMBilly Hrrera1981-04-28—76198167623510 Park Pl, Fresno, CA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61361TPAArjun Marshall1974-03-22——4070 Willow Ct # 774, Tampa, FL0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
100,000 rows, page 82 of 2,000PreviousNext