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-109516ENRRichard Q Santos1947-06-15UHC-94580-9269049554307248 Main St, Mesa, AZ, 852170.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-137126ENRJonathan Z Kennedy1961-12-02UHC-96291-49—2767 Grand Ave, Tampa, FL, 336050.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-103869ENRJennifer Wood1995-03-05UHC-28217-72340956095584 Union St, San Antonio, TX, 782690.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-140835ENRJulia M Roberts1944-04-19UHC-00443-9484481496975684 Mesa Dr, San Antonio, TX0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129198ENRAbigail F Gilbert1989-04-04UHC-55949-97—937 Canyon Rd, Orlando, FL, 328410.60Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-119965ENREugene Dean1980-11-04UHC-92457-4370340437311663 Forest Ave, Sacramento, CA, 958760.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-120412ENRRebecca U Hart1962-03-15UHC-48738-1844428933042012 Jefferson Ave, Dallas, TX, 752840.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-118327ENRCheryl Wells1996-05-23UHC-85133-1573675267638038 Ocean Ave, Minneapolis, MN, 554600.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-118297ENRStephanie Holmes1987-09-26UHC-67717-3054674645103877 Harbor Blvd, Scottsdale, AZ, 852120.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-102586ENRVincent Jimenez—UHC-80139-4980598504836632 Sage Ct, Mesa, AZ, 852020.60Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more
ENR-139357ENRMateo Y Gardner1991-11-03UHC-88333-7022837160172185 Market St, Minneapolis, MN, 554680.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-128776ENRLinda I Thompson1987-09-14UHC-07643-4747064348797853 Indian School Rd, Chandler, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-128147ENRRalph U Amrstrong1981-07-21UHC-24998-7064558895478223 Pine Dr, Los Angeles, CA, 900770.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-120268ENRAnn Perkins2005-06-21UHC-55959-6576936100463947 Willow Ct, Nashville, TN0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138615ENRMason Taylor2001-07-19UHC-83381-4327674084251473 Bayshore Dr, Phoenix, AZ, 850930.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124213ENROmar Park1975-11-13UHC-01183-8548280456074331 Palm Dr, Gilbert, AZ, 852910.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127777ENRAndrew Bryant1951-01-06UHC-48874-4734724677265644 Mountain View Dr, Scottsdale, AZ, 852620.60Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-122930ENRHerny Wang1956-10-11UHC-73333-8354658427219589 Forest Ave, Denver, CO0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-101032ENRHiroshi G Fullre—UHC-10742-9280247698789186 Church St, Tampa, FL, 336800.60Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more
ENR-131209ENRNicole King1969-03-10UHC-75840-7288488917676954 Pine Dr, Phoenix, AZ, 850910.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-138669ENRCarol W Turner1988-06-04UHC-66102-258674376699834 Highland Ave, Eden Prairie, MN, 553250.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122767ENRChristina D Sanchez2006-06-01UHC-05882-67445539984428 Sunset Blvd, Houston, TX, 770520.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-129223ENRAndrea L Wells1974-04-08UHC-09143-6629626362831442 Highland Ave, Atlanta, GA, 303010.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-134239ENRDorothy Cook1982-07-23UHC-19060-9084923207835326 Union St Apt 37, Minneapolis, MN, 554080.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-135215ENREthan Wood1996-02-07UHC-49596-3450457758037948 Main St, Charlotte, NC, 282490.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-120529ENRJanet T Hoffman1977-04-21UHC-00217-94—9782 Valley View Dr, Dallas, TX, 752310.60Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+4 more
ENR-112008ENRMaeo Armstrong1979-02-15UHC-54870-9388685588111841 Bayshore Dr, Los Angeles, CA, 900690.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-116918ENRPatty A Nguyen2005-03-23UHC-22321-6472435783486015 Elm St, Fresno, CA, 937700.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-141833ENRLauren Jackson2004-04-04UHC-07467-1289034567517895 Harbor Blvd, Houston, TX, 770660.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132433ENRRandy R Wallace1987-05-26UHC-72706-799032230751415 Indian School Rd # 782, Mesa, AZ, 852960.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-142460ENRDeborah N Chapman1938-10-27UHC-03542-1125357241746636 Canyon Rd, Houston, TX, 770280.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-108706ENRRandy I Lawrence1981-01-02UHC-90741-1892584891308287 Highland Ave, Glendale, AZ0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127968ENRLysa Z Pena1956-11-01—59525173294869 Elm St, Nashville, TN, 372880.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-136664ENRNancy Jaes1956-09-17UHC-08079-4231426893466858 Sage Ct, Denver, CO, 802280.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-130000ENRBenjamin H Rozs1945-12-11UHC-24918-6036185490798110 Spring St Apt 38, Denver, CO, 802950.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-142564ENRLawrence Porter1986-05-26UHC-43623-9590020711794902 Camelback Rd, Miami, FL, 331450.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-104028ENRNicholas Mejia2003-02-11UHC-04504-3187833767861116 Sage Ct, Miami, FL0.60Name re-casedStreet suffix standardisedAddress re-casedZIP missing+4 more
ENR-116091ENRAna K Gutierrez1950-06-21UHC-96937-0779336494466563 Elm St, Los Angeles, CA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-121528ENRTimothy Y Aguilar1996-11-08UHC-28975-9250027133141629 River Rd, Las Vegas, NV, 891230.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127299ENRDebra Cruz1962-01-28UHC-87928-933065357595607 Palm Dr, Tucson, AZ, 857690.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-112299ENRCynthia I Diaz2002-12-02UHC-72241-5685860646074342 Baseline Rd, Denver, CO, 802740.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-128640ENRCatherine Ford1977-12-27UHC-81203-9197289803141919 Harbor Blvd, Sacramento, CA, 958090.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-132214ENRSharon Cunningham2003-10-05UHC-87424-5990028239688900 Mountain View Dr, Minneapolis, MN0.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-124275ENRJudith Knight2002-06-07UHC-03688-3491188769109778 Baseline Rd, San Antonio, TX, 782560.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-113989ENRGregory N Jenkins1983-02-07UHC-71141-9769825123437418 Mountain View Dr, Columbus, OH, 432210.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-143009ENRNathan G Phillips1964-12-27UHC-35983-0639760398103692 River Rd # 385, Jacksonville, FL, 322180.60Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-106927ENRSandra A Weber1963-07-13UHC-22732-277909447106525 Canyon Rd, Mesa, AZ, 852780.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-122312ENRChristopher Dixon1953-03-19UHC-08912-5798772766892285 Highland Ave, Charlotte, NC, 282980.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-109648ENRWaye Jensen—UHC-95377-9750250696137350 Bayshore Dr, Tampa, FL, 336000.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-115048ENRArthur George2000-07-02UHC-37062-3840440055563309 Sunset Blvd, Las Vegas, NV, 891770.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
43,101 rows, page 121 of 863PreviousNext