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-115632ENRNathan Fox1968-01-26UHC-69999-9967977594154909 Mountain View Dr, Fresno, CA, 937630.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-115608ENRBeverly O Sanchez—UHC-57625-5936329990238609 Forest Ave, Chandler, AZ, 852950.60Name re-casedDate of birth missingPhone reformattedMember ID reformatted+4 more
ENR-128083ENRPeter R Ferguson1948-03-25UHC-45310-0540041856781560 Central Ave, Houston, TX, 770660.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-121447ENRWillie Li—UHC-81208-2379863942278736 Jefferson Ave, Los Angeles, CA, 900750.60Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more
ENR-124627ENRJanice M Wets1946-05-25UHC-30537-947406652820207 Meadow Ln, Chandler, AZ0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-106863ENRJason Duncan1996-06-16UHC-47431-542323134848783 Washington St, Houston, TX, 770910.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-101392ENRChristian Marshall1949-12-23UHC-23971-0829944791698663 Desert Sky Blvd, San Diego, CA, 921080.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-105126ENRChristina Cruz1986-09-05UHC-96388-3930871130514501 Jefferson Ave, Eden Prairie, MN, 553910.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-142865ENRCatherine L Bennett1980-01-12UHC-58898-702587124462939 Ocean Ave Apt 32, Austin, TX, 787900.60Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more
ENR-103829ENRJacqueline Sanders1964-11-23UHC-67570-5262324147816642 Ridge Rd, Gilbert, AZ, 852670.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-140828ENRChristopher I Henderson1979-03-26UHC-31623-414103437224983 Grand Ave, Atlanta, GA, 303750.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101690ENRMelissa Jimenez1939-10-06UHC-42639-4488981563746734 Pine Dr, Atlanta, GA, 303730.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-101723ENRCatherine X Ellis1939-12-19UHC-05992-1975137687123991 Park Pl, Chandler, AZ, 852020.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-139276ENRDanielle Austin1971-08-11UHC-75102-8134420048028500 Canyon Rd, Minneapolis, MN, 554060.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114348ENRAisha Miller1948-10-19UHC-31707-7359736359845672 Elm St # 540, Austin, TX, 787160.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-114109ENRJacqueline Rice1965-03-03UHC-18053-0436483476408134 Lake View Rd, Atlanta, GA, 303490.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-119492ENRAmber Gutierrez2002-09-05UHC-40564-3396792222067696 River Rd, Tucson, AZ, 857660.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132806ENRKayla E Padilla2008-11-26UHC-70209-4962762911747096 Lake View Rd, Gilbert, AZ, 852540.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-132162ENRRoger O Sanchez1966-03-16UHC-37942-6354265468127701 Lake View Rd # 645, Columbus, OH, 432950.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-114585ENRChristopher Z Stewart2007-01-04UHC-24875-0529354313053083 Main St, Houston, TX, 770680.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-117032ENRLuis S Howard1987-09-10UHC-63334-205407541885744 Harbor Blvd, Las Vegas, NV, 891390.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-100795ENRBrnadon R Bryant1980-12-13UHC-78047-9595334002312086 Maple Ave, Atlanta, GA, 303420.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-111380ENRCatherine H Morgan2006-04-10UHC-30159-8857184806696975 Hillcrest Rd Apt 36, Tempe, AZ, 852370.60Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-102349ENRDebra V White1951-01-13UHC-67594-75—7964 Valley View Dr, Minneapolis, MN, 554910.60Name re-casedCity re-casedState code upper-casedZIP+4 trimmed+4 more
ENR-142571ENRRonald H Harrison1984-04-25UHC-20068-10—8832 Mountain View Dr, San Diego, CA, 921930.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-143002ENRMarcus H Fernandez1997-10-04UHC-69524-0749798294741095 Hillcrest Rd, Tempe, AZ, 852980.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-112418ENRJessica Elis1997-03-05UHC-51002-7589081849922135 Mesa Dr Apt 21, Jacksonville, FL, 322800.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-124651ENRDennis B Mitchell1993-04-03UHC-59416-9261225874599110 Mountain View Dr, Austin, TX, 787380.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-118694ENRLori I Austyn2003-07-23UHC-45897-7669056722133574 Cedar Ln, Fresno, CA, 937600.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133291ENRRaymond Grant1957-06-21UHC-33272-2652540958999859 Elm St, Miami, FL0.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-141355ENRRoger Reid1961-06-04UHC-97347-56—9877 Valley View Dr, Sacramento, CA, 958800.60Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
ENR-119349ENRMason U Pierce1970-10-14UHC-14486-4575841837265979 Maple Ave, San Antonio, TX, 782710.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-106607ENRCharlotte Payne1943-09-07UHC-66273-8030377764615422 Oak St, Las Vegas, NV, 891210.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-135319ENRBrittany B Moore2007-05-24UHC-86886-7757125355632956 Sunset Blvd, Tampa, FL, 336510.60Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-113207ENRMateo P McCoy1989-09-18UHC-20963-718246598642514 Spring St, Scottsdale, AZ, 852790.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-140368ENRAustin Santos2004-09-16UHC-27796-5730527684559199 Church St, Dallas, TX, 752070.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-100934ENRRobert Nichols2007-10-24UHC-85970-4169139748505023 Cedar Ln, Seattle, WA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-142422ENRJustin Chapman1967-03-13UHC-61066-9793170536423608 Sage Ct # 377, Charlotte, NC, 282160.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-111617ENREmma N Dunn1972-11-22UHC-28577-5160955642947042 Broadway, Chandler, AZ, 852490.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-108922ENRSamuel Murphy1938-03-23UHC-88511-6964962997275850 Main St, San Diego, CA, 921140.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-136805ENRJanice L Hamilton1977-02-23UHC-98453-7639667201566541 Cedar Ln, Las Vegas, NV, 891370.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-133392ENRRachel D Kim1946-03-19UHC-21617-33—977 Ridge Rd, Plano, TX, 750860.60Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-100267ENRKathryn J Kelly1955-01-24UHC-61592-3065865136406310 Cedar Ln, Mesa, AZ, 852550.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-140612ENRBradley Perez1988-02-23UHC-12473-5985290106493352 Oak St, Orlando, FL, 328370.60Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
ENR-139997ENRStephen U Herrera1950-05-18UHC-99274-5793041058751373 Park Pl, Minneapolis, MN, 554490.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-137650ENRGregory Pena1944-04-24UHC-46769-6352376986011872 Meadow Ln, Columbus, OH, 432180.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-139873ENRNatalie Spencer1986-01-27UHC-74798-5091365320076562 Jefferson Ave, Houston, TX0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116638ENRThomas A Guzman1998-04-26UHC-06290-3785387881546043 Apache Blvd, Tempe, AZ, 852340.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133667ENRCarl Pierce1981-07-24UHC-13973-1854023912187608 Baseline Rd # 234, Orlando, FL, 328730.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-102271ENRPriya M Bryant1995-09-20UHC-21221-3896987443622965 Lake View Rd, Chandler, AZ, 852880.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
43,101 rows, page 128 of 863PreviousNext