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-132123ENRRussell T George2005-01-25UHC-35845-965175327379613 Apache Blvd, Charlotte, NC0.62Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-111601ENRLindda L Moore1961-12-17UHC-65655-6282069387271540 Market St, San Antonio, TX0.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-123163ENRLucai Hernandez2003-08-05UHC-88709-1229660763265947 Bayshore Dr, Tempe, AZ, 852870.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124937ENRJudith G Burns1978-04-16UHC-74937-9324585340538847 Pine Dr, Nashville, TN0.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-110999ENRBrandon Johnston1994-03-05UHC-18239-7981066111085819 Jefferson Ave, Minneapolis, MN, 554790.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-100537ENRJesse W Moreno1984-12-15UHC-81082-2791955047943578 Jefferson Ave, Dallas, TX, 752110.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130414ENRDenise T Vargas1949-10-23UHC-01600-9361467301354158 Central Ave, Nashville, TN0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105710ENRMariana S Delgado1989-10-06UHC-41386-078826588091516 Maple Ave, Orlando, FL, 328180.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-121998ENROmar Hicks1993-06-28UHC-71644-1696820238861129 Indian School Rd, Glendale, AZ, 853470.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109386ENRHelen N Kelley1996-05-12UHC-08411-8177046235589444 Valley View Dr, Columbus, OH, 432480.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-137815ENRSharon F Martin1946-05-10UHC-49913-3391992333702983 Forest Ave, Seattle, WA, 981440.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-109130ENRDennis Stephens1971-12-20UHC-47797-2729392221731079 Indian School Rd, Glendale, AZ, 853370.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-115711ENRKeith Russell1992-02-01UHC-15398-6998486619256957 Lake View Rd, Seattle, WA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135032ENRMateo Lee—UHC-39222-72—9241 Baseline Rd, Seattle, WA, 981570.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-126114ENRDaniel R Ellliott1944-03-10UHC-52792-2582640300698182 Washington St, San Diego, CA, 921720.62Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more
ENR-125889ENRSamuel N Fields1973-02-01UHC-70900-7769082291532094 Desert Sky Blvd, Fresno, CA0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140751ENRPamela Webb1959-08-09UHC-44862-7658863980186001 Church St, Austin, TX, 787600.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116040ENRReynolds Christian1969-06-13UHC-89526-4889173770961150 Meadow Ln, Plano, TX, 750800.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-102640ENRDoris Owens1976-10-07UHC-50196-2249061845103552 Highland Ave, Minneapolis, MN, 554080.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134642ENRWeber Amanda1939-09-08UHC-56145-0591427646374921 Desert Sky Blvd, Scottsdale, AZ, 852830.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-138323ENRKenneth McDonald2002-12-23UHC-23880-3823423563371501 River Rd # 192, Tampa, FL, 336100.62Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-120942ENRVirginia Bennett2007-07-09UHC-85901-1837792123843368 Lincoln Way, San Antonio, TX, 782460.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-129532ENRRalph A Mendoza1977-11-03UHC-00344-4977930927351456 Palm Dr, Los Angeles, CA0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142968ENRLinda Bishop1943-05-16UHC-76949-1145470078951478 Maple Ave, Jacksonville, FL, 322380.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132297ENRElizabeth Johnson1956-08-09UHC-09419-5071931186706599 River Rd, Phoenix, AZ, 850200.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
ENR-103495ENRAmy Watson1942-07-11UHC-71029-2495527480429190 Apache Blvd, San Diego, CA, 921580.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-128540ENRNicole A Cooper—UHC-91874-5657886901003515 Pine Dr, Eden Prairie, MN, 553020.62Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112474ENRMadison Z Mendez1988-10-11UHC-71301-9245980433838233 Bayshore Dr, Dallas, TX, 752570.62Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-115627ENRAiisha E Kelley1964-11-03UHC-96102-1838525083495803 Spring St, Las Vegas, NV, 891310.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137603ENRPatricia S Davis2002-01-17UHC-96971-1261460526995868 Oak St, Plano, TX, 750950.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127458ENRSamantha S Jones1956-09-12UHC-43746-7141759543138027 Union St, Tucson, AZ, 857870.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-139927ENRDavid Vezquez1991-07-20UHC-60007-8262436443865431 Mesa Dr, Atlanta, GA, 303910.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-118916ENRDenise N Hughes1952-09-28UHC-47133-4757440763694650 Market St, Jacksonville, FL, 322490.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-135725ENRCharles M Wang1994-02-03UHC-35113-59—9780 Willow Ct, Los Angeles, CA, 900310.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137350ENRGary S Watkins1952-02-13UHC-53844-0861049236951472 Union St, San Diego, CA, 921070.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108601ENRGerald P Lopez—UHC-58085-71—3691 Jefferson Ave, Jacksonville, FL, 322880.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-133751ENRPamela Garza1997-11-02UHC-24284-0877845062363571 Cedar Ln, Columbus, OH0.62Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-113500ENRDebra E Mejia2004-10-27UHC-43299-124674659001212 Sage Ct, Dallas, TX0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124249ENRKathryn O Henderson2006-01-19UHC-99531-6166021926063638 Pine Dr # 972, Sacramento, CA, 958920.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-128973ENRMaria P Dunn1941-02-26UHC-43773-5067734885035593 Church St, Jacksonville, FL0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127265ENRSara Carpenter1950-10-24UHC-95596-4441952310415046 Mesa Dr, Columbus, OH, 432520.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121373ENRGloria V Weber1955-05-05UHC-93543-0170970265019287 Oak St, Dallas, TX0.62Name re-casedPhone reformattedMember ID reformattedCity re-cased+3 more
ENR-124870ENREmily R Young1977-01-26UHC-47480-6085834362088117 Apache Blvd, Mesa, AZ, 852370.62Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more
ENR-141453ENRJuan C Obrien2008-07-20UHC-63527-6242880454901923 Elm St, Los Angeles, CA, 900450.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-130929ENREugene A Morales1976-03-11UHC-18419-70—7390 Bayshore Dr, Austin, TX, 787660.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-140516ENRGonzalez Katherine1958-10-26——3627 Highland Ave, Tampa, FL, 336370.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138864ENRKevin H Romero2005-01-10UHC-28011-6750861872766858 Lake View Rd, Fresno, CA, 937060.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108707ENRJean I Brown1938-02-24UHC-02515-8689694645979596 Lake View Rd, Glendale, AZ, 853540.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137584ENRMargaret Bradley1966-09-13UHC-01772-1367397503942445 Spring St, Glendale, AZ, 853140.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134148ENRGabriel M Spencer1954-01-08UHC-44268-2357996346765592 Pine Dr, Miami, FL, 331500.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
43,101 rows, page 142 of 863PreviousNext