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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-127791ENRSarah C Murphy1964-06-03UHC-01157-3054735490167273 Palm Dr, Scottsdale, AZ, 852370.50Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more
ENR-117697ENRMarilyn E Long1948-06-28UHC-02319-9951651120724006 Broadway, Eden Prairie, MN, 553740.50Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+3 more
ENR-117698ENRMarilyn E Long1948-06-28UHC-02319-9951651120724006 Broadway, Eden Prairie, MN, 553740.50Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+3 more
ENR-102938ENRDan R Brooks1984-10-20UHC-42328-9061465925575113 Cedar Ln, Phoenix, AZ, 850090.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-103405ENRAaron Munoz1943-12-09UHC-15982-6673374867424673 Palm Dr # 119, Glendale, AZ0.50Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more
ENR-124505ENRJohn T Ramos1994-07-07UHC-05969-1320862788143869 Baseline Rd, Fresno, CA, 937120.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-116910ENRJudy Y Ward1976-07-26UHC-72375-159225331442398 Main St, Atlanta, GA, 303200.50Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-123354ENRWayne T Garza1990-11-24UHC-17167-67—7840 Forest Ave # 508, Jacksonville, FL, 322950.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-109075ENRDorothy S Nunez1975-01-16UHC-27583-3275033961605049 Spring St Apt 28, Minneapolis, MN0.50Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more
ENR-109076ENRDorothy S Nunez1975-01-16UHC-27583-3275033961605049 Spring St Apt 28, Minneapolis, MN0.50Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more
ENR-141688ENRAnna F Guzman1968-06-28UHC-10311-6778333351048017 Washington St, Scottsdale, AZ, 852520.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
ENR-140462ENRMartha Z Ruiz1948-04-01UHC-79278-0947291985275670 Main St, Eden Prairie, MN, 553720.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-125951ENRMarilyn James1969-10-05UHC-34608-5343041650704451 Forest Ave Apt 23, Scottsdale, AZ, 852650.50Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+3 more
ENR-125025ENRAisha Stone—UHC-36349-477474481889905 Main St, Houston, TX, 770550.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134655ENRDennis N Patterson1969-03-28UHC-31263-3095351981923295 Market St, Eden Prairie, MN, 553740.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115748ENRDavid R Bishop1973-10-26UHC-19805-3294762028631186 Harbor Blvd, Seattle, WA, 981170.50Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
ENR-106083ENRBruce Matthews1948-10-15UHC-70940-8235648789069500 Church St, Eden Prairie, MN, 553620.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122977ENRVicky Q Hamilton1974-09-06UHC-20657-6853899134921611 Spring St, Las Vegas, NV, 891620.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-110572ENRAmy B Franklin1995-06-08UHC-99324-8854478756802923 Washington St, Mesa, AZ, 852790.50Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
ENR-138986ENRDenise Burns1987-02-12UHC-01051-8747962772795721 Meadow Ln, Eden Prairie, MN0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119565ENRNicole Padilla—UHC-62109-3865941677356464 Highland Ave # 838, Eden Prairie, MN, 553040.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130212ENRMarilyn D Bryant1956-07-24UHC-01965-8277493324419387 Apache Blvd, Tampa, FL, 336740.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-120207ENRThomas I Hamilton2001-12-07UHC-44880-96—7449 Baseline Rd Apt 12, Fresno, CA, 937410.50Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-115524ENRLaura O Ruiz1990-01-04UHC-43485-0741668477952480 Elm St, Plano, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120153ENRLucia U Schmidt1955-03-08UHC-12220-9642393085366822 Church St, Glendale, AZ0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125746ENRBradley Brery1994-07-25UHC-89119-309077518680302 Canyon Rd, Tempe, AZ, 852060.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-100233ENRMarcus Schmidt2006-12-12UHC-74913-8869973280171781 Apache Blvd, Dallas, TX, 752460.50Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
ENR-101185ENREric G Hoffman—UHC-44737-8375837807764427 Desert Sky Blvd, Plano, TX, 750480.50Date of birth missingPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-100526ENRSusan Freeman1948-01-26UHC-73337-8641825352458141 Pine Dr, Sacramento, CA, 958100.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124309ENRJoshua Warren1949-05-13UHC-33579-29—497 Baseline Rd, Orlando, FL, 328310.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-116180ENRGregory U Campbell1992-07-05UHC-86806-0496233347201084 Lake View Rd, Los Angeles, CA, 900330.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-122653ENREugene J Johnson1959-08-22UHC-80550-8487833990919294 Park Pl, Tucson, AZ, 857360.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-139842ENRAaron S Shaw—UHC-68668-9161698898133907 Elm St, Seattle, WA0.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-136381ENRDoris Stevens1967-10-25UHC-63515-4640451732013446 Apache Blvd # 441, Nashville, TN, 372220.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-111143ENRRoy Jimenez2000-04-02—66951753209219 Apache Blvd Apt 30, Glendale, AZ, 853820.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136318ENRKatherine B West2001-01-25UHC-33223-956707918648798 Central Ave Apt 4, Dallas, TX, 752130.50Name re-casedDate of birth reformattedUnit split from streetState name converted to code+3 more
ENR-121069ENRDiane U Baker1983-07-26UHC-71337-5032043183131048 Hillcrest Rd, Las Vegas, NV, 891880.50Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more
ENR-140800ENRAleexander C Reed2007-01-17UHC-71496-8164155562243769 Meadow Ln, Columbus, OH, 432210.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-127161ENRMegan B Clark1990-01-05UHC-96665-83—3323 Grand Ave, Eden Prairie, MN0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-110922ENRShirley Butler1993-09-06UHC-47514-26—218 Canyon Rd, Phoenix, AZ, 850060.50Name re-casedTwo-digit birth yearPhone missing area codeMember ID reformatted+3 more
ENR-122364ENRJanice Wilson1947-01-19UHC-63240-6748462816263994 Ocean Ave # 412, Austin, TX, 787980.50Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-127716ENRAmber Reed1938-03-05UHC-77622-2984594386094076 Canyon Rd # 248, Orlando, FL, 328250.50Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+3 more
ENR-130138ENRKyle K Smith—UHC-64566-5263443570571315 Park Pl, San Diego, CA0.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-134669ENRStephen K Garza1982-04-22UHC-48291-2594569652871800 Central Ave, Minneapolis, MN, 554170.50Name re-casedTwo-digit birth yearPhone reformattedState code upper-cased+3 more
ENR-117953ENRLaura E Mendez—UHC-60316-2329959500175085 Bayshore Dr # 518, Phoenix, AZ, 850460.50Name re-casedDate of birth reformattedDate of birth unreadableUnit split from street+3 more
ENR-114634ENRDonald Yang—UHC-31855-28—9167 Washington St, Columbus, OH0.50Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121748ENRRonald Rojas1943-10-01UHC-59380-9080839655186395 Valley View Dr, Miami, FL, 331990.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-138781ENRAlexis Elliott1987-05-15UHC-17159-1420899791461711 Canyon Rd, Tempe, AZ, 852600.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-130682ENRMartha Ellis1946-03-14UHC-51149-9384376706063183 Grand Ave, San Antonio, TX, 782560.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-107937ENRMason M King—UHC-51740-5020370328993044 Ridge Rd, Eden Prairie, MN, 553560.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
43,101 rows, page 45 of 863PreviousNext