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-114353ENRCarl N Boyd1942-12-18UHC-08601-36—8407 Washington St, Mesa, AZ, 852690.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-105439ENREmily Q Rojas1973-08-11UHC-97762-04—3791 Baseline Rd, Mesa, AZ0.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-429166CLMNathan Peters1984-03-14——7611 Spring St, Gilbert, AZ, 852630.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-105587ENRJordan L Ross—UHC-47728-6229395183748556 Market St, Eden Prairie, MN, 553650.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416347CLMArjun Anderson2006-04-21UHC-43813-38—7072 Desert Sky Blvd Apt 18, Austin, TX0.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57054TPAMarrk Green1988-03-05UHC-58036-68—464 Ocean Ave, San Diego, CA, 921140.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-412637CLMSteve Hoffman2007-05-08UHC-34421-69—4134 Harbor Blvd, Denver, CO, 802990.52Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
ENR-140695ENRJule N Guerrero1976-02-13—90088934943375 Apache Blvd, Sacramento, CA, 958220.52Two-digit birth yearPhone reformattedSSN last four extractedEmail lower-cased+2 more
ENR-104470ENRJanice Little1980-06-04UHC-10517-8422157104561594 Indian School Rd, Las Vegas, NV, 891990.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430502CLMPamela Guzman1982-06-11—40958810189168 Mountain View Dr, Tempe, AZ, 852570.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400632CLMJustin R Robertson2005-01-13UHC-36053-5055747068012985 Market St, Sacramento, CA, 958300.52Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
ENR-127678ENRBrenda M Ray1980-05-09UHC-99155-7625721429059660 Elm St, Mesa, AZ, 852320.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-22901PRVHenry T Espinoza1959-07-26——1745 Church St, Austin, TX0.52Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+2 more
TPA-52112TPADiane S Banks1988-03-16——8353 Ocean Ave, Orlando, FL, 328730.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-126765ENRJean Martin1980-08-25UHC-24078-99—2678 Cedar Ln # 136, Columbus, OH, 432760.52Name re-casedPhone missing area codeUnit split from streetState name converted to code+2 more
ENR-128414ENRSophia Ray1999-10-03UHC-48513-757377922231707 Valley View Dr # 825, Austin, TX0.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-136633ENRJamesJunk1966-02-24UHC-52508-51—9781 Harbor Blvd, Phoenix, AZ0.52Name re-casedState name converted to codeZIP missingWhitespace trimmed+2 more
CLM-425235CLMDebra Garza1968-12-21UHC-76716-09—6122 Highland Ave, Austin, TX, 787560.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52743TPAGloria Bennett——36137358718792 Grand Ave, Minneapolis, MN, 554190.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-100847ENRSarah D Howell1966-05-27UHC-08662-712373550725320 Main St, Austin, TX, 787510.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28914PRVAlan Lopez1983-04-13UHC-37303-83—6719 Union St, Gilbert, AZ0.52Name re-casedDate of birth reformattedPhone missing area codeState name converted to code+2 more
CLM-427491CLMKyle Salazar1941-01-26——4948 Ocean Ave, Tucson, AZ, 857260.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427490CLMKyle Salazar1941-01-26——4948 Ocean Ave, Tucson, AZ, 857260.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-118351ENRFrances Kyng1988-05-04UHC-31602-8150658200886888 Forest Ave, Tempe, AZ, 852540.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-109824ENRJuan J Wong1992-03-15UHC-16504-5779864655375751 Union St, Los Angeles, CA, 900430.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-139050ENRArthur Watkins1939-08-05UHC-78749-93—8530 Canyon Rd, Gilbert, AZ, 852720.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-137590ENRWilliam T Woong1980-05-15UHC-15878-7242074557437700 Palm Dr Apt 8, Scottsdale, AZ, 852540.52Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
CLM-402897CLMWayne E Coleman1961-12-22——691 Grand Ave, Tampa, FL0.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-137611ENRLogaan Jimenez1974-10-24UHC-70338-3025250239138893 Mesa Dr, San Antonio, TX0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-125341ENRJudith Robertson1974-05-11UHC-96845-24—9604 Elm St Apt 14, Nashville, TN, 372680.52Name split from “Last, First”Date of birth reformattedUnit split from streetGender normalised+2 more
TPA-56738TPABrian Carter1941-08-02——4200 Valley View Dr # 372, Los Angeles, CA, 900140.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-123998ENRTyler A Oliver1951-05-20UHC-51920-31—7954 Market St, Seattle, WA, 981730.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-50049TPADylan Reed———5538 Park Pl, Gilbert, AZ, 852090.52Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-426622CLMDonna T Myers1954-01-21UHC-28456-299273674387648 Oak St, Gilbert, AZ0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-59977TPADoris Fisher1999-12-25—30821150523931 Oak St Apt 4, Glendale, AZ, 853760.52Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+2 more
ENR-123991ENRAlan F Ward1981-08-20UHC-36246-039299486177117 Mesa Dr, Dallas, TX, 752130.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135489ENRMarcus Ford1972-01-02UHC-07354-0470463647394043 Washington St, Eden Prairie, MN, 553440.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427728CLMAlexander Smith1958-09-25UHC-06478-9255838274011669 Park Pl Apt 10, Los Angeles, CA, 900200.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-418577CLMKeith Hicks1951-08-22—64640510053052 Canyon Rd, Minneapolis, MN0.52Name re-casedState name converted to codeZIP missingGender normalised+2 more
CLM-418576CLMKeith Hicks1951-08-22—64640510053052 Canyon Rd, Minneapolis, MN0.52Name re-casedState name converted to codeZIP missingGender normalised+2 more
CLM-418153CLMHrold K Mejia1969-10-17——1262 Willow Ct, Nashville, TN, 372700.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-102705ENRRaymond Scott1988-07-05UHC-74464-5122331222217866 Lincoln Way Apt 16, Denver, CO, 802280.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-120023ENRKyle Harrison1967-05-15UHC-34852-9663596489482106 Mountain View Dr, Gilbert, AZ, 852170.52Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+2 more
CLM-415618CLMLogan Lawson1992-11-11—28368073939216 Mesa Dr Apt 38, Atlanta, GA, 303130.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431976CLMSam Ray1998-10-01UHC-71219-6732195835279124 Spring St, Charlotte, NC, 282990.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429557CLMAlexis Elliott1987-05-15UHC-17159-14—1711 Canyon Rd Apt 33, Tempe, AZ, 852600.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-105125ENRAnthony X Jensen—UHC-85828-8584139067824054 Church St, Tampa, FL, 336360.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121504ENRValentina G Cunningham1969-08-28UHC-01564-7148356491962965 Baseline Rd, Chandler, AZ, 852440.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-20598PRVDavid F Kelley1970-06-19—4127037771979 Mountain View Dr Apt 35, Dallas, TX0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-63777TPASteeve Robertson1974-04-26——4568 Canyon Rd, Fresno, CA, 937350.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
100,000 rows, page 180 of 2,000PreviousNext