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-130893ENRSteven Hunt—UHC-31698-06—2211 Willow Ct, Charlotte, NC, 282080.54Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
ENR-101296ENRMatthew Jensen1973-08-26UHC-03797-0959059282654550 Jefferson Ave, Seattle, WA, 981710.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-118203ENRWilliam W Thomas1963-02-12UHC-69152-82—6444 Ridge Rd, Scottsdale, AZ, 852800.54Name re-casedPhone missing area codeState name converted to codeGender normalised+1 more
ENR-110415ENRBradley X Robinson1985-07-17UHC-47589-1078941437445501 Sunset Blvd, Tampa, FL, 336810.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-138197ENRDiane Diaz———3673 Ocean Ave, Atlanta, GA, 303360.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-111290ENRPatricia X Mills1995-01-07UHC-35380-7594636854967958 Mountain View Dr, Tampa, FL, 336540.54Middle initial moved out of first nameSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-135072ENRCamila U Gibson1968-03-15UHC-37139-569162589539999 Bayshore Dr, Jacksonville, FL, 322720.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-120781ENREdwad Santiago1961-01-24UHC-06807-5593128459638477 Baseline Rd, Tempe, AZ, 852990.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-115214ENRHannah Andrews1987-09-21UHC-15893-4329629329899390 Palm Dr, Sacramento, CA0.54Name split from “Last, First”State code upper-casedZIP missingGender normalised+1 more
ENR-118975ENRPhillip L Barnes2005-01-26UHC-12496-0780884620562781 Indian School Rd, Denver, CO, 802790.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
ENR-117531ENRKevin Vasquez1965-12-12UHC-02982-4149872118633689 Grand Ave, Scottsdale, AZ, 852660.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-101849ENRStephen Murphy1992-11-09UHC-54490-8323453846712604 River Rd, Eden Prairie, MN0.54Name split from “Last, First”Two-digit birth yearPhone reformattedZIP missing+1 more
ENR-100083ENRMelissa D Fields1951-09-13UHC-11822-388014746440754 Central Ave, Houston, TX, 770850.54Middle initial moved out of first nameTwo-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-131179ENRDoris O Weaver1994-04-04UHC-85018-09—1270 Spring St, Columbus, OH, 432100.54Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-113719ENRAmy Yang2002-08-10UHC-84531-1047357489301529 Market St, Fresno, CA, 937610.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-119745ENRBobby Bowman1956-08-05UHC-05130-582445047058362 Indian School Rd Apt 32, Las Vegas, NV, 891910.54Name split from “Last, First”Phone reformattedUnit split from streetGender normalised+1 more
ENR-120819ENRKaren L Woods1944-07-03UHC-39950-1970161269889357 Indian School Rd, Plano, TX0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-125488ENRMarc Murray2007-03-02UHC-72241-88—2029 Mountain View Dr # 686, Columbus, OH, 432200.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-102186ENRChristina Garza2006-12-07UHC-41809-1373036185596305 Harbor Blvd, Glendale, AZ, 853620.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-109688ENRWillie I Walsh1992-07-21UHC-23657-2397527059248861 Ridge Rd, Eden Prairie, MN, 553130.54Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+1 more
ENR-109689ENRWillie I Walsh1992-07-21UHC-23657-2397527059248861 Ridge Rd, Eden Prairie, MN, 553130.54Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+1 more
ENR-128766ENRJenny Jensen2001-10-28UHC-53962-932922800161512 Main St Apt 36, Houston, TX, 770300.54Phone reformattedUnit split from streetState name converted to codeZIP+4 trimmed+1 more
ENR-116260ENRBobbby A Schultz1958-07-18UHC-06876-9525630731681371 Maple Ave, Seattle, WA, 981980.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-120082ENRDiana Q Oliver2003-10-02UHC-09068-4132825690894633 Hillcrest Rd, Seattle, WA, 981340.54Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more
ENR-136542ENRKimberly L Wiliamson1998-05-10UHC-18983-0526557460277202 Elm St, Miami, FL, 331270.54Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more
ENR-136541ENRKimberly L Wiliamson1998-05-10UHC-18983-0526557460277202 Elm St, Miami, FL, 331270.54Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more
ENR-112449ENRJerry Anderson2006-12-25UHC-02296-6675570093465218 Lake View Rd, San Antonio, TX, 782270.56Street suffix standardisedAddress re-casedState name converted to codeGender normalised
ENR-117256ENRSara S Espinoza1997-01-27UHC-90159-0479382003405773 Central Ave, Los Angeles, CA, 900720.56Name split from “Last, First”Two-digit birth yearEmail lower-casedGender normalised
ENR-100920ENRCarolyn Jones1975-12-23UHC-27279-41—6889 Elm St, Mesa, AZ, 852230.56Name split from “Last, First”Phone missing area codeState name converted to codePlan code upper-cased
ENR-129251ENRJanice Schmidt1959-02-27UHC-64276-118367053870658 Ocean Ave, Glendale, AZ, 853450.56Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed
ENR-102965ENRCynthia Torres1956-06-07UHC-01192-28—3928 Grand Ave, San Antonio, TX, 782810.56Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed
ENR-142096ENRJack A Yang1992-01-27UHC-07057-6143598542551847 Central Ave # 632, Gilbert, AZ, 852090.56Name split from “Last, First”Unit split from streetCity re-casedState name converted to code
ENR-140380ENRHenry Soto1968-02-26UHC-32029-1452426357658371 River Rd, Austin, TX, 787480.56Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed
ENR-137282ENRShilrey Day1939-05-17UHC-72696-7139026856568550 Cedar Ln, Plano, TX0.56Name split from “Last, First”Phone reformattedState name converted to codeZIP missing
ENR-119476ENRJohnny Henry1944-01-19UHC-67530-0785326149989524 Desert Sky Blvd Apt 10, Atlanta, GA, 303910.56Phone reformattedUnit split from streetZIP+4 trimmedGender normalised
ENR-107353ENRVargas A Mark1982-06-13UHC-25967-4563824183797658 Oak St, Phoenix, AZ, 850190.56Name split from “Last, First”Two-digit birth yearGender normalisedPlaceholder values cleared
ENR-135961ENRPhilip Q Valdez2002-07-04UHC-98601-3768550705515651 Ridge Rd, Los Angeles, CA, 900900.56Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised
ENR-111695ENRBetsy Soto1942-07-20UHC-24398-25—4815 Valley View Dr, Tampa, FL, 336580.56Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised
ENR-117587ENRCamila B Snyder1951-11-11UHC-68703-0932555317808443 Valley View Dr, Austin, TX, 787620.56Name re-casedTwo-digit birth yearState name converted to codeGender normalised
ENR-135140ENRLarry R Stephens1941-12-13UHC-87488-2675738561136390 Camelback Rd, Las Vegas, NV, 891260.56Name split from “Last, First”State name converted to codeZIP+4 trimmedPlaceholder values cleared
ENR-136395ENRRuth S Ortiz1991-01-22UHC-29847-4858658040518190 Grand Ave # 315, Los Angeles, CA, 900680.56Name split from “Last, First”Phone reformattedUnit split from streetState name converted to code
ENR-129909ENRJoyce Porter1963-11-26UHC-48696-87—7574 Jefferson Ave, Dallas, TX, 752160.56Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed
ENR-137631ENR—Junk1961-01-16UHC-52644-6477542830092216 Oak St, Sacramento, CA, 958500.56Street suffix standardisedAddress re-casedZIP+4 trimmedNo usable name (quarantined)
ENR-121262ENRJeremy Ray1995-12-15UHC-72912-9881194073692100 Sunset Blvd, Charlotte, NC0.56Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing
ENR-138723ENRWillis U Jason1994-01-20UHC-47418-0863051619185423 Meadow Ln, Gilbert, AZ, 852940.56Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased
ENR-124583ENRJeffrey Moore1985-05-28UHC-66663-74—7212 Oak St, Miami, FL, 331710.56Phone missing area codeZIP+4 trimmedGender normalisedPlaceholder values cleared
ENR-107317ENRJacqueline Reynolds1982-11-20UHC-88771-8728699031275254 Main St, Las Vegas, NV, 891740.56Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed
ENR-129597ENRHelen W Sanders1964-07-24UHC-99859-6858234223815250 Oak St, San Antonio, TX, 782930.56Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+6 more
ENR-108535ENRLawrence E Mitchell1940-07-19UHC-30433-1364258153505724 Hillcrest Rd Apt 11, Columbus, OH, 432210.56Middle initial moved out of first nameUnit split from streetCity re-casedState name converted to code
ENR-124504ENRBruce S Gray1997-05-17UHC-70709-9531820639823961 Baseline Rd # 971, Minneapolis, MN, 554100.56Name split from “Last, First”Phone reformattedUnit split from streetState name converted to code
43,101 rows, page 109 of 863PreviousNext