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-140088ENRDennis F Watson1960-02-18UHC-66816-8838636558893612 Highland Ave, Chandler, AZ, 852260.40Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+2 more
ENR-128114ENRRoger F Sullivan1941-01-21UHC-76081-4835879898389235 Hillcrest Rd, Glendale, AZ, 853850.40Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410004CLMDenise Davis1976-01-20UHC-95791-99—8266 Oak St, Seattle, WA, 981490.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410753CLMZachary Shaw1965-07-13UHC-32514-98—6728 Market St, Mesa, AZ, 852830.40Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+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
PRV-27011PRVMichael Matthews1998-09-14—39329321619134 Grand Ave, Glendale, AZ, 853740.40Name split from “Last, First”Two-digit birth yearStreet 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
CLM-422616CLMJudith S Simmons1981-07-16UHC-35607-99—8104 Maple Ave Apt 4, Fresno, CA, 937280.40Middle initial moved out of first nameUnit split from streetStreet suffix standardisedAddress re-cased+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
CLM-411263CLMAdam Bailey———8267 Sage Ct, Fresno, CA, 937260.40Date of birth unreadableSSN last four extractedStreet suffix standardisedAddress re-cased+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
CLM-401773CLMTyler M Taylor—UHC-19451-27—9668 Hillcrest Rd, Charlotte, NC, 282710.40Date of birth missingMember ID reformattedState name converted to codeZIP+4 trimmed+2 more
TPA-56838TPACheryl Nunez1974-03-17—80048729223118 Elm St # 727, Scottsdale, AZ, 852550.40Name split from “Last, First”Two-digit birth yearUnit split from streetCity 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
CLM-427980CLMAbigail Rios—UHC-06532-92—5815 Bayshore Dr # 218, San Antonio, TX, 782960.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+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
CLM-432142CLMJoyce Hunt1993-11-16——2184 Main St, Atlanta, GA, 303240.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-411308CLMRonaldJunk1946-09-19UHC-31859-37—2525 Forest Ave, Mesa, AZ, 852890.40Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-411307CLMRonaldJunk1946-09-19UHC-31859-37—2525 Forest Ave, Mesa, AZ, 852890.40Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+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
CLM-431126CLMJoshua Watson—UHC-57517-29—5300 Lake View Rd, Atlanta, GA, 303660.40Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-57664TPACharlotte Austin———4548 Spring St # 115, Jacksonville, FL, 322690.40Name split from “Last, First”Date of birth unreadableUnit split from streetCity re-cased+2 more
CLM-401262CLMWayne H James1983-07-16——3720 Pine Dr, Seattle, WA, 981980.40Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP+4 trimmed+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
TPA-58379TPAArjun Banes2000-11-01——8922 Mountain View Dr, Scottsdale, AZ, 852180.40Name split from “Last, First”Two-digit birth yearPhone missing area codeStreet suffix standardised+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
TPA-52036TPAEric Bowman1954-03-13—84868864553834 Spring St, Denver, CO, 802510.40Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+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
CLM-430596CLMStephanie O Rojas—UHC-23206-4858093421633938 Main St, Jacksonville, FL, 322170.40Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+2 more
CLM-421267CLMChristian Hayes—UHC-86167-37—957 Camelback Rd # 858, Tempe, AZ0.40Date of birth missingUnit split from streetCity re-casedZIP missing+2 more
CLM-409802CLMBetty Martinez1996-03-10UHC-16621-1973249306025975 Lake View Rd, Jacksonville, FL, 322740.40Name split from “Last, First”Two-digit birth yearStreet 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
100,000 rows, page 37 of 2,000PreviousNext