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-105517ENRJonatan F Wells1997-04-19UHC-50263-5368180720269341 Church St, Seattle, WA, 981600.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55985TPANatalie Bell2005-03-27——7886 Mountain View Dr, Charlotte, NC, 282640.50Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-138382ENRJennifer H Fisher2007-10-13UHC-19102-39—3860 Ocean Ave, Tempe, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-50932TPASantiago Aguilar1946-01-13——7366 Sunset Blvd, Charlotte, NC, 282190.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-21125PRVVirginia Singh1957-04-27UHC-78289-57—1609 Valley View Dr, Charlotte, NC0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-22102PRVCamila G Olson1949-01-07—52465108063970 Sage Ct, Atlanta, GA, 303420.50Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more
ENR-122210ENRChristina P Johnston1963-07-26UHC-64381-5665224308401967 Central Ave, Jacksonville, FL, 322450.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62375TPAKenneth Hamilton1985-10-18——4095 Lake View Rd, Sacramento, CA, 958830.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401541CLMSantiago Ford1994-12-11UHC-19531-20—179 Apache Blvd, Tucson, AZ0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406581CLMNancy Wright1957-08-22UHC-99348-62—4434 Canyon Rd, Tempe, AZ, 852410.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-132573ENRJon Q Dominguez1965-02-16UHC-49789-8988056255691946 Valley View Dr, Las Vegas, NV, 891810.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-55605TPAAustin Simpson1993-02-27——3090 Ocean Ave, Los Angeles, CA0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-27201PRVRalph K Collins1989-01-03—92573079151999 Ocean Ave, Columbus, OH, 432400.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134567ENRCarlos Clark1975-12-08UHC-35686-8769174658573497 Church St, Miami, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426928CLMSean Howell1979-03-20——1203 Sage Ct # 897, Sacramento, CA, 958890.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-133709ENRDoris Kelly1957-03-07UHC-00217-4839527269809827 Highland Ave, Seattle, WA, 981620.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-426583CLMStephen QJunk1990-04-08UHC-69270-12—580 Grand Ave, Scottsdale, AZ, 852170.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60041TPACharlotte U Armstrong1953-11-03—75192887932974 Washington St, Sacramento, CA, 958710.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29073PRVBrittany W Taylor1941-05-07UHC-11983-4094032991573835 Ridge Rd, Tempe, AZ, 852980.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
CLM-412685CLMJoan D Clark1939-07-07UHC-69400-46—4377 Ridge Rd, Jacksonville, FL0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-127869ENRGary Peters1954-08-17—5129654132355 Mesa Dr, Plano, TX, 750010.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-107133ENRElijah Q Cox1986-06-28UHC-15378-0870875501645551 Main St # 267, Jacksonville, FL0.50Phone reformattedUnit split from streetCity re-casedZIP missing+3 more
CLM-425760CLMAbbigail Morrison1950-04-01UHC-09145-97—928 Bayshore Dr, Minneapolis, MN, 554480.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-417453CLMRachel Webb2001-04-13UHC-11876-8631276251315298 Maple Ave Apt 9, Atlanta, GA, 303780.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-105940ENRRandy T Schultz1945-01-18UHC-67392-09—5172 Cedar Ln, Plano, TX, 750490.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100514ENRBobby C Gilbert2001-02-27UHC-67259-6636428100706310 Grand Ave, Dallas, TX, 752530.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-414502CLMBrandon Torres1955-11-27—28688748404878 Canyon Rd Apt 9, Chandler, AZ, 852670.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-413820CLMNicholas Wells1972-01-06——8075 Indian School Rd, Glendale, AZ, 853840.50Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-101798ENRAmy Graham1942-12-08UHC-93467-2281281782783276 Oak St, Seattle, WA, 981480.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-420437CLMRonald Ellis2007-01-06——1443 Apache Blvd, Denver, CO, 802600.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-106432ENRMei A Mendez1939-01-11UHC-90033-138557633406612 Hillcrest Rd Apt 11, Charlotte, NC, 282480.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-51591TPAMariana Schultz1987-05-13—59041759858300 Highland Ave, Houston, TX0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-22308PRVCarol Garrett1971-02-27UHC-98913-0344097552595161 Valley View Dr, Fresno, CA, 937850.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430686CLMSharon V Bell2006-07-20UHC-77136-29—6511 Sage Ct, Houston, TX0.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
PRV-22780PRVDavid Martin2007-09-12—32287699045526 Ridge Rd # 580, Denver, CO, 802090.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
TPA-61945TPAIsabella Singh1949-11-14—91625092208764 Baseline Rd, Columbus, OH, 432960.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-116957ENRAmber E Reyes—UHC-63044-2735255158836206 Ridge Rd, Minneapolis, MN, 554110.50Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-429099CLMBenjamin Thompson1990-07-25UHC-19802-1582698305996913 Park Pl, Las Vegas, NV, 891030.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-431107CLMJanet Vazquez—UHC-47351-63—2641 Palm Dr, Seattle, WA, 981100.50Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-60403TPABradley Williis1999-01-08——5874 Cedar Ln, Miami, FL, 331650.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59499TPAMark Silva1987-12-04——7641 Ocean Ave, Chandler, AZ, 852510.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-408817CLMVicky S Franklin—UHC-84410-2465868582995345 Valley View Dr, Denver, CO, 802590.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-109278ENRPamela Mitchell—UHC-76970-8178835418945418 River Rd, Phoenix, AZ, 850730.50Date of birth unreadablePhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-124656ENRHannah K Owens1946-10-28UHC-20754-8642730074646773 Willow Ct Apt 38, Orlando, FL, 328040.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125174ENRIsabella K Aguiilar———839 Mesa Dr Apt 12, Austin, TX, 787560.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
TPA-51806TPAJose Carpenter1971-02-23—55898619345511 Elm St, Phoenix, AZ, 850660.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27325PRVAngela Carpenter1990-07-20——4829 Jefferson Ave, Austin, TX, 787520.50Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
ENR-128099ENRRalph A Jimenez1989-07-12UHC-36480-4940264401125171 Desert Sky Blvd, Los Angeles, CA, 900630.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24069PRVTheresa Kelly1950-01-02UHC-26103-4968765601791014 Hillcrest Rd, San Diego, CA0.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-105215ENRArjun Ray1963-03-12UHC-68947-5271577051275602 Camelback Rd Apt 8, Atlanta, GA, 303050.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
100,000 rows, page 117 of 2,000PreviousNext