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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-135283ENREthan M Rogers1938-12-18UHC-76883-3286943895331672 Spring St # 140, San Antonio, TX, 782510.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-142248ENRLinda Reid1941-09-26UHC-59494-8930650053393931 Harbor Blvd, San Diego, CA, 921040.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-26171PRVDennis C Ryvera1996-06-18——7168 Forest Ave Apt 36, Tempe, AZ, 852980.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-140080ENREthan Ramos—UHC-82654-9054198926946394 Main St, Eden Prairie, MN, 553270.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58815TPAJeremy A Roberts1994-12-02——9863 Sage Ct, Columbus, OH0.52Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
PRV-28104PRVRaymond Phillips1995-01-28UHC-34319-1140373412971479 Baseline Rd, Glendale, AZ, 853140.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122451ENRCarlos Holmes1945-12-12UHC-63535-5297872314085894 Cedar Ln, Mesa, AZ, 852590.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-59468TPABrittany Medina1995-11-10—38085636008502 Baseline Rd, Glendale, AZ, 853110.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419081CLMMargaret Parker1970-03-03——2902 Willow Ct, Fresno, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
PRV-23337PRVAhmed I Patel2005-02-09UHC-86063-1361239709187258 Apache Blvd, Austin, TX, 787660.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57973TPAPeter Richardson1988-10-15——4232 Mesa Dr, Phoenix, AZ, 850080.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-55740TPADanielle Thompson1993-05-12UHC-07773-71—5664 Ridge Rd, Columbus, OH, 432210.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-105101ENRArthur L Guzman1971-05-06UHC-34464-2563096284443255 Market St, Mesa, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56894TPAAshley Kelley1990-07-03——9283 Indian School Rd, San Diego, CA, 921290.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-119566ENRCarolyn P Spencer2001-05-09UHC-57300-9333258926197047 Mesa Dr, Tucson, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-116059ENRMary S Ellis1954-11-08UHC-94061-2661969877675588 Palm Dr Apt 31, Jacksonville, FL, 322820.52Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
ENR-130365ENRRobert M Sanchez—UHC-14192-8447283196053138 Meadow Ln, Jacksonville, FL, 322540.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-143068ENRFrances E Mendez2000-10-09UHC-31146-68—6052 Market St, Nashville, TN, 372380.52SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-124291ENRJordan Y Hill1979-05-24UHC-65651-73—9487 Church St, Tampa, FL, 336950.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-23590PRVVirginia F Smith1963-08-07UHC-21841-47—4860 Canyon Rd, Las Vegas, NV, 891530.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-119334ENRSamuel Y Vargas1949-09-18UHC-39371-85—3642 Apache Blvd, Atlanta, GA, 303740.52Name re-casedTwo-digit birth yearPhone missing area codeMember ID reformatted+2 more
TPA-61700TPAJordan Greene——23292024952298 Camelback Rd # 808, Scottsdale, AZ, 852550.52Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-54548TPATerresa Myers1966-05-12UHC-67569-91—3439 Pine Dr # 322, Tucson, AZ, 857630.52Name split from “Last, First”Date of birth reformattedUnit split from streetGender normalised+2 more
ENR-120431ENRPaul C Lewis1972-03-11UHC-89738-3768373860458134 Harbor Blvd, Houston, TX, 770030.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430922CLMBetty Perez1997-03-07UHC-12785-63—136 Mesa Dr, Minneapolis, MN, 554700.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-132892ENRLogan Parkar1994-07-10UHC-13216-29—7040 Willow Ct, Gilbert, AZ, 852350.52Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+2 more
ENR-137888ENRDaniel F Ward—UHC-94840-2030392098182104 Palm Dr, Denver, CO, 802940.52Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+2 more
CLM-430003CLMPaul Hernandez1972-07-11UHC-62047-51—3778 Sage Ct, Chandler, AZ, 852860.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61166TPADeborha Owens1969-09-28——7234 Highland Ave, Fresno, CA, 937210.52SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-105313ENRPriya S Pena2004-10-22UHC-70426-2390086855745528 Willow Ct, Mesa, AZ, 852270.52Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
CLM-407266CLMJulia D George1959-01-27—46949812122430 Valley View Dr, Charlotte, NC0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23744PRVGloria Allen1976-12-08UHC-05703-453084703302585 River Rd, Austin, TX, 787730.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405444CLMJason S Mills1948-12-08——1493 Sage Ct, Columbus, OH, 432030.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-129082ENRTimothy Harris1960-08-08UHC-02413-6936332749851631 Lincoln Way, Los Angeles, CA, 900030.52Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+2 more
PRV-27554PRVBradley Flures1978-11-17UHC-20706-4090343003343417 Indian School Rd, Gilbert, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-137523ENRBryan Q Fernandez2008-11-21UHC-35162-9337839171683502 Spring St, Fresno, CA, 937890.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62922TPAThomas Jimenez1993-09-18——7889 Forest Ave # 726, Gilbert, AZ, 852670.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-105032ENRBobby X Moreno1969-02-07UHC-17565-73—1957 Baseline Rd, Tampa, FL, 336270.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-415068CLMDenise Richardson2002-10-07UHC-40221-43—6090 Spring St, Chandler, AZ, 852530.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415069CLMDenise Richardson2002-10-07UHC-40221-43—6090 Spring St, Chandler, AZ, 852530.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-124064ENRTimothy Schultz2002-01-10UHC-79336-3452142564233983 Cedar Ln, Scottsdale, AZ, 852220.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-124636ENRPatricia K Patel2001-03-24UHC-80415-3057894161592379 Apache Blvd, Mesa, AZ, 852200.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-124506ENRAshley A Jensen1970-09-01UHC-25086-5345176940974415 Market St, San Diego, CA0.52Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-22144PRVLori S Williams1984-07-03—20180010397541 Washington St, Fresno, CA, 937340.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-24460PRVLinda C McDonald1987-03-12UHC-89393-8634048308784266 Broadway Apt 3, Miami, FL, 331920.52Two-digit birth yearUnit split from streetAddress re-casedZIP+4 trimmed+2 more
PRV-24883PRVArthur D Rios1956-06-28UHC-53771-89—583 Market St, Mesa, AZ, 852400.52Middle initial moved out of first nameSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-415113CLMCharles Hill1993-12-10UHC-05062-59—7232 Grand Ave, Denver, CO, 802390.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
CLM-412321CLMTerry W Richards1989-11-18—25353873962331 Apache Blvd, Minneapolis, MN, 554810.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-136568ENRChristina N Obrien1948-01-25UHC-57093-3345434135433904 Park Pl, Eden Prairie, MN, 553180.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-408280CLMJennifer A Rogers1942-06-12UHC-08853-68—5864 Union St, Scottsdale, AZ, 852990.52Middle initial moved out of first nameName re-casedTwo-digit birth yearStreet suffix standardised+2 more
100,000 rows, page 176 of 2,000PreviousNext