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-128114ENRRoger F Sullivan1941-01-21UHC-76081-4835879898389235 Hillcrest Rd, Glendale, AZ, 853850.40Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113542ENRCarolyn J Mills1982-06-17UHC-54330-8276253156249218 Canyon Rd Apt 24, Glendale, AZ, 853570.40Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
ENR-114003ENRCarlos Thompson—UHC-17306-3495135342877115 Apache Blvd # 644, Tampa, FL, 336520.40Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-113866ENRAmber Perez1943-10-25UHC-24581-9940130117686547 Union St # 160, Nashville, TN, 372440.40Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+2 more
ENR-111021ENRCamila M Lucas1959-11-09UHC-50549-37—1620 Jefferson Ave, Dallas, TX0.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-108720ENRGary U Schmidt1966-12-22UHC-93699-2090889610165966 Palm Dr Apt 15, Tucson, AZ, 857940.40Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-125667ENRRay Sullivan1989-08-22UHC-05981-64—5591 Sage Ct, Chandler, AZ0.40Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113390ENRChristine Morales2007-01-19UHC-18121-7556746778748944 Forest Ave Apt 8, Charlotte, NC, 282110.40Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-140556ENRJeff Padilla1983-08-18UHC-65369-2898780830929574 Ridge Rd, Eden Prairie, MN0.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-127527ENRRussell G Bell—UHC-91116-5829879687582688 Jefferson Ave, Atlanta, GA, 303800.40Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-141153ENRJustin V Munoz1996-07-23UHC-65561-7480856097102020 Main St, Fresno, CA, 937840.40Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-117896ENRJason R Harvey1955-05-26UHC-27403-6430081085207877 Elm St, Mesa, AZ0.40Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112844ENRDaniel E Flores1959-12-17UHC-10911-11—4711 Mesa Dr # 570, Mesa, AZ, 852810.40Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-130032ENRGrace Fields1954-06-17UHC-83534-8050161917299169 Market St, Dallas, TX, 752090.40Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-129381ENRWei A Romero1942-04-26UHC-05658-6855539502674297 Indian School Rd # 108, Seattle, WA0.40Name split from “Last, First”Member ID reformattedUnit split from streetZIP missing+2 more
ENR-112156ENRValentina Moore1979-09-23UHC-89782-29—6292 Meadow Ln, Austin, TX, 787110.40Name split from “Last, First”Phone missing area codeCity re-casedZIP+4 trimmed+2 more
ENR-130750ENRYuki Sandes1943-06-18UHC-72782-1536521570926666 Mesa Dr, Minneapolis, MN0.40Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119111ENRPatricia Peters2000-10-03UHC-65406-1194940457867041 Mountain View Dr, San Antonio, TX, 782540.40Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-132496ENRBrian Rogers1976-07-17UHC-74277-16—2065 Baseline Rd, Tucson, AZ, 857910.40Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-118400ENRElijah K Hudson1967-07-17UHC-28101-7135320803704748 Apache Blvd # 434, Nashville, TN0.40Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+2 more
ENR-110107ENRLucia Q Kim1948-10-13UHC-97425-8157837909564719 Canyon Rd, Eden Prairie, MN0.40Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-138036ENRJason Daz1988-03-18UHC-57179-8227632603871050 Lake View Rd # 418, Phoenix, AZ, 850920.40Name split from “Last, First”Unit split from streetState name converted to codeEmail lower-cased+2 more
ENR-101254ENRHeather I Lopez1941-12-08UHC-55811-29—2352 Ridge Rd Apt 19, Seattle, WA, 981220.40Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-112222ENRJanice Montgomery2005-11-28UHC-33646-3584374841015292 Union St, Jacksonville, FL0.40Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-138710ENRMason R Perkins1988-11-23UHC-51351-2450026276927401 Forest Ave, Seattle, WA, 981330.40Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-132862ENRJean L Parker2001-08-12UHC-85215-6684325775244997 Meadow Ln, Mesa, AZ0.40Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-108116ENRChristina I Montgomery—UHC-84985-5191843605583375 Central Ave, Gilbert, AZ, 852560.40Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-113323ENRWayne Padilla1946-08-05UHC-00942-19—1173 Sage Ct, Tucson, AZ0.40SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-142104ENREily Z Shaw1992-02-13UHC-67683-2842621506521137 Washington St # 570, Gilbert, AZ, 852580.40Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-112320ENRBeverly G Schmidt1993-03-21UHC-13118-6289965935102192 Lake View Rd, Orlando, FL0.40Name split from “Last, First”Two-digit birth yearPhone reformattedZIP missing+2 more
ENR-137422ENRAbigayl Morris1970-06-04UHC-59571-9037058123524579 Central Ave, Miami, FL, 331610.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-101201ENRMason N Reynolds1978-09-19UHC-75443-6547138903864261 Ocean Ave, Dallas, TX0.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-127830ENRAmy Bennett1970-10-21UHC-28725-9349561175881308 Bayshore Dr, Denver, CO, 802900.40Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-131940ENRRuth X Howard1995-01-05UHC-04494-26—8779 Camelback Rd, Orlando, FL, 328690.40Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-124068ENRDon A Hayes1949-04-16UHC-91495-7180221043435151 Jefferson Ave # 153, Los Angeles, CA0.40Phone reformattedSSN last four extractedUnit split from streetZIP missing+2 more
ENR-113745ENRAngela Sims1957-11-02UHC-40464-36—4117 Lake View Rd, Gilbert, AZ, 852090.40Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-119784ENRPamela Austin1943-06-16UHC-05115-47—4921 Grand Ave, Scottsdale, AZ, 852500.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-129939ENRAustin L Contreras1946-03-21UHC-46475-4636522391381920 Pine Dr, Miami, FL, 331450.40Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedSSN last four extracted+2 more
ENR-107659ENRWallace Barbara—UHC-80497-35—3506 Willow Ct, Phoenix, AZ, 850810.40Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-139424ENRBenjamin F Taylor1965-12-19UHC-86199-0690283459918247 Lake View Rd Apt 27, Gilbert, AZ, 852170.40Name split from “Last, First”Date of birth reformattedSSN last four extractedUnit split from street+2 more
ENR-111155ENRBrenda Garrett1985-09-28UHC-01984-2425473331683668 Ridge Rd Apt 3, Phoenix, AZ0.40Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-136929ENRKimberly P Henderson1942-10-18UHC-39645-38—4544 Mountain View Dr, Eden Prairie, MN, 553770.40Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-121284ENRJose Moore—UHC-25875-0758664088621197 Mountain View Dr # 832, Denver, CO, 802010.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-126387ENRDonald K Wells1959-12-16UHC-76669-77—96 Hillcrest Rd, Jacksonville, FL0.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-139008ENRCarol Rose1947-05-13UHC-87748-8941658700228587 Sunset Blvd, Austin, TX0.40Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-102294ENRBradley Rice1983-03-12UHC-06356-6528073810034855 Bayshore Dr, Atlanta, GA0.40Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-134339ENRZachary N Schultz1966-05-06UHC-17530-0997880021709272 River Rd, Seattle, WA0.40Name split from “Last, First”City re-casedState name converted to codeZIP missing+2 more
ENR-109369ENRRachel P Aguilar2004-01-13UHC-94877-9057858160612416 Valley View Dr, San Diego, CA, 921210.40Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-126558ENRWei K Griffin1983-07-13UHC-18705-8066941146906937 Union St, Houston, TX, 770010.40Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-141725ENRAnna Griffin—UHC-16810-6859481542869125 Oak St, Tampa, FL, 336070.40Date of birth unreadablePhone reformattedSSN last four extractedStreet suffix standardised+2 more
43,101 rows, page 20 of 863PreviousNext