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-138795ENRJonathan Bryant—UHC-15588-8628791568378590 Apache Blvd, San Antonio, TX0.50Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+3 more
ENR-141552ENRBilly R Fisher1980-06-20UHC-98030-2769962691351611 Hillcrest Rd Apt 31, Seattle, WA, 981550.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-127541ENRJoan U Morgan1953-12-09UHC-54119-0732493433363800 Washington St, Eden Prairie, MN, 553280.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125805ENRPaul Montgomery—UHC-33633-1892756166289334 Oak St, Phoenix, AZ, 850240.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-102128ENRAronld G Cheryl1939-07-17UHC-49778-2794744718991883 Canyon Rd, Chandler, AZ, 852800.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103358ENRJulie E Olson1972-11-08UHC-69723-7657830765152676 Hillcrest Rd, Jacksonville, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-139111ENRYuki Ruiz1972-03-21UHC-19041-11—6056 Ridge Rd, Nashville, TN, 372570.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-137078ENRJason R Morgan2006-04-10UHC-31457-9150427185662752 Hillcrest Rd, Tampa, FL0.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
ENR-120144ENRKathryn J Hill1960-10-10UHC-93631-5546325010447190 Maple Ave, Jacksonville, FL, 322420.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-127561ENRMason W Howard1981-02-03UHC-97472-9095552543272216 Church St, Jacksonville, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121404ENRLisa Bishop1946-04-25UHC-70027-5945557135435476 Mesa Dr, Fresno, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133727ENRZachary U Morris1985-09-28UHC-13938-46—6613 Pine Dr, Fresno, CA, 937230.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-105726ENRUJunk1966-03-12UHC-76518-547278331495733 Spring St, Los Angeles, CA, 900890.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112856ENRPatrick Marquez1995-05-22UHC-59828-3655224019614295 Apache Blvd, Austin, TX, 787540.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-136457ENRBenjamin Mills1962-04-28UHC-47258-4760865574764151 Desert Sky Blvd, Orlando, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116683ENRTyler Barnes1942-05-11UHC-01576-4157261236377124 Market St # 346, Chandler, AZ0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-131549ENRLori WJunk1951-03-15UHC-50744-7144565177973221 Canyon Rd, Minneapolis, MN, 554060.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-134815ENRJoe B Cox1954-06-17UHC-98294-1072634140215787 Sunset Blvd Apt 20, Orlando, FL, 328390.50Phone reformattedUnit split from streetState name converted to codeEmail lower-cased+3 more
ENR-118974ENRJanice K Richards1938-06-13UHC-36443-2360433172162622 Jefferson Ave, Charlotte, NC, 282540.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-138153ENRJerry Rosss1979-06-17UHC-06332-38—7056 Palm Dr, Charlotte, NC, 282710.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-135731ENRIsabella R Wong2002-04-02UHC-26829-4021439312057567 Sage Ct, Gilbert, AZ, 852630.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140883ENRSopia E Spencer1939-06-15UHC-86480-2830847571717663 Ocean Ave, Houston, TX, 770130.50Middle initial moved out of first nameStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-117604ENRHamilton U Doris1949-03-21UHC-29716-4387551746728807 Indian School Rd Apt 14, Los Angeles, CA, 900630.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-135962ENRHenry V Obrien—UHC-71537-8024091651201614 Camelback Rd # 839, Atlanta, GA, 303720.50Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
ENR-134817ENRDouglas O Harris1965-08-21UHC-03403-79—4687 Main St, Nashville, TN, 372550.50Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
ENR-112543ENRNancy I Salazar1981-03-05UHC-90313-6583466638055548 Sage Ct, Columbus, OH, 432960.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-104202ENRRuth M Hill—UHC-49852-183805349906557 Jefferson Ave, Plano, TX, 750280.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101507ENRAnna Lawrence1983-12-17UHC-95417-06—9750 Sage Ct, Las Vegas, NV0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
ENR-101506ENRAnna Lawrence1983-12-17UHC-95417-06—9750 Sage Ct, Las Vegas, NV0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
ENR-141186ENRAnthony Ward1982-02-06UHC-87149-6494070492381081 Pine Dr, Atlanta, GA, 303970.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-122538ENROmar D Johnson1962-12-05UHC-46064-4369026193853316 Forest Ave, Phoenix, AZ, 850080.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140009ENRVincent Delgado1960-02-12UHC-58815-2574021267745442 Sunset Blvd, Miami, FL, 331620.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-139562ENRWillie Chavez1952-10-12UHC-99334-3386558015752780 Desert Sky Blvd, Plano, TX, 750960.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114231ENRAlbert O Santos1985-08-12UHC-10621-5066597909402953 Union St, Chandler, AZ, 852210.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-111986ENRSofia C Evans1941-08-25UHC-68436-7992984543894963 Lake View Rd, Houston, TX, 770940.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-119212ENRSandra Soto2001-10-01UHC-82070-0221297142869307 Mesa Dr Apt 32, Denver, CO, 802800.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-126242ENRWayne Davis1956-05-25UHC-67278-96—4681 Oak St, Eden Prairie, MN, 553090.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119554ENRLiz George1960-05-24UHC-90127-8368746656612879 Sunset Blvd, Chandler, AZ, 852100.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-106540ENRAustin Jordan1951-04-05UHC-02354-94—4762 Church St Apt 30, Eden Prairie, MN, 553400.50Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
ENR-122939ENRNicholas I Montgomery1976-12-24UHC-07349-5827472172898660 Baseline Rd # 774, San Antonio, TX, 782500.50Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more
ENR-103235ENRDenny Lopez1962-10-07UHC-83888-9577042787582194 Church St, Seattle, WA, 981060.50Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+3 more
ENR-112429ENRSara B Ramos1998-09-02UHC-90845-0265681511764731 Sage Ct, San Diego, CA, 921680.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142908ENRJoyyce U Snyder1993-12-04UHC-73911-6640224665008349 Willow Ct, Fresno, CA, 937290.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-116637ENRSharon Jordan1940-10-09UHC-95905-1141888701619743 Ridge Rd, Jacksonville, FL, 322070.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115991ENRLucia T Reid2007-05-10UHC-97211-9170095422042443 Washington St, Chandler, AZ, 852450.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112706ENRElijah Owens—UHC-32230-666147492074428 Church St, Scottsdale, AZ, 852760.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
ENR-112679ENRVirginia T Rice—UHC-60262-0957945767836678 Lincoln Way, Fresno, CA, 937260.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-137936ENRGloria Chapman1938-10-11UHC-10323-5847826301964425 Mesa Dr # 964, Denver, CO, 802910.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-133226ENROmar Castro1951-12-07UHC-27170-0794163829387219 Oak St, Miami, FL, 331800.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-116567ENRJerry Burke1976-08-18UHC-38441-26—8032 Valley View Dr, Nashville, TN, 372480.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
43,101 rows, page 66 of 863PreviousNext