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

Claims, lowest dq score first

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-426566CLMPeter Olson1976-02-17UHC-64174-06—1042 Sunset Blvd, Chandler, AZ, 852070.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-423955CLMTyer Edwards1988-03-04UHC-69572-7884250814228005 Church St # 102, Los Angeles, CA, 900560.68Phone reformattedUnit split from streetState name converted to codePlaceholder values cleared
CLM-419523CLMPeter Castillo2007-04-06——237 Canyon Rd, San Antonio, TX, 782860.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410521CLMMariana Porter1999-10-22UHC-32514-31—8211 Grand Ave, Chandler, AZ, 852610.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-416444CLMJanice Ramos1999-11-02—47089850837210 Ocean Ave, Atlanta, GA, 303810.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-404644CLMSean C Torres———1225 Park Pl, Las Vegas, NV, 891210.68Date of birth unreadableZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-412315CLMCatherine Henderson1986-01-17UHC-95700-7576795638694276 Church St, Miami, FL, 331400.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409943CLMGerald Carpenter—UHC-74053-6359490285406030 Meadow Ln, Tucson, AZ, 857720.68Date of birth unreadableSSN last four extractedCity re-casedPlaceholder values cleared
CLM-401839CLMHiroshi I Reynolds1965-06-21—39352960252054 Sunset Blvd, Sacramento, CA, 958970.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-428573CLMGabriel R Barnes1990-12-06UHC-60346-86—3179 Sage Ct, San Diego, CA, 921140.68Middle initial moved out of first nameTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-423258CLMMark Howell2000-01-15——8095 Bayshore Dr, San Diego, CA0.68Name re-casedStreet suffix standardisedAddress re-casedZIP missing
CLM-423661CLMAndrew U Nunez—UHC-64434-62—9834 Elm St # 965, Austin, TX, 787930.68Date of birth unreadableUnit split from streetWhitespace trimmedPlaceholder values cleared
CLM-421779CLMRachel U Anderson1940-09-13—60151735088708 Union St, Las Vegas, NV, 891300.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-416280CLMFrank Duncan1981-04-09—3479009627696 Park Pl, Seattle, WA, 981600.68Two-digit birth yearZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-402425CLMMargaret Franklin1941-10-02UHC-75474-29—4443 Central Ave, Gilbert, AZ, 852740.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-420833CLMDebra Estrada1964-10-01——3265 Elm St, Fresno, CA, 937530.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-425698CLMCynthia Porter1983-10-11UHC-55361-65—9877 Union St, Miami, FL, 331020.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
CLM-419397CLMNicole Barnes1993-01-26———0.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
CLM-407728CLMSteve Park1941-01-23UHC-23541-9755067396698298 Main St, Sacramento, CA, 958450.68Two-digit birth yearCity re-casedGender normalisedPlaceholder values cleared
CLM-430302CLMDebbie Perez———2625 Highland Ave, Chandler, AZ, 852460.68Name re-casedDate of birth missingZIP+4 trimmedPlaceholder values cleared
CLM-410302CLMBrittany Simpson1992-05-18UHC-61931-7163599346703674 Church St, Las Vegas, NV, 891060.68Two-digit birth yearState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-402755CLMLucia Bryant1975-06-09UHC-06528-43—7161 Canyon Rd, Houston, TX, 770780.68Member ID reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-431203CLMBradley Jones1962-03-17UHC-59050-8474757212606499 Bayshore Dr, Houston, TX, 770640.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432729CLMMadison Thomas1945-05-25UHC-45958-44—9336 Maple Ave Apt 4, Minneapolis, MN, 554400.68Date of birth reformattedSSN last four extractedUnit split from streetPlaceholder values cleared
CLM-412807CLMAlice Perkins1993-01-28UHC-87615-02—951 Palm Dr, Orlando, FL, 328330.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-418702CLMPaul Martinez1953-03-19—83151757232801 Grand Ave, Fresno, CA0.68State name converted to codeZIP missingWhitespace trimmedPlaceholder values cleared
CLM-408225CLMSandra Ryan1995-12-02——3076 Spring St, Chandler, AZ, 852500.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-400161CLMMariaJunk2007-03-12UHC-35556-52—5103 Willow Ct, Tempe, AZ, 852470.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
CLM-409861CLMVirginia Ward2000-10-04——6445 Cedar Ln, Tampa, FL, 336470.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-406406CLMMarcus Munoz1972-08-23UHC-39935-89—1896 Baseline Rd, Orlando, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-412683CLMEthan Walsh1941-03-07——5428 Mountain View Dr, Tampa, FL, 336330.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-412684CLMEthan Walsh1941-03-07——5428 Mountain View Dr, Tampa, FL, 336330.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-406684CLMVirginia Hoffman1947-09-20—7588526273—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-410326CLMBrian W Roberts—UHC-10708-73—4456 River Rd, Tucson, AZ0.68Date of birth missingZIP missingWhitespace trimmedPlaceholder values cleared
CLM-427867CLMHenry Nguyen2002-03-18UHC-95115-21—5080 Canyon Rd, Columbus, OH, 432730.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-411199CLMPeter McCoy2000-04-02UHC-64916-3987998848153108 Desert Sky Blvd, Columbus, OH, 432700.68Name re-casedTwo-digit birth yearState name converted to codePlaceholder values cleared
CLM-413977CLMLisa Garrett1941-11-08——4103 Sage Ct, Houston, TX0.68SSN last four extractedZIP missingWhitespace trimmedPlaceholder values cleared
CLM-404888CLMLinda Murraay—UHC-87160-20—9085 Washington St Apt 7, Mesa, AZ, 852500.68Date of birth missingUnit split from streetWhitespace trimmedPlaceholder values cleared
CLM-411229CLMJacob Vasquez1985-05-07UHC-00788-94——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-413468CLMHannah Brown1961-10-21UHC-26443-88——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-411940CLMBilly Bowman1957-02-15——4063 Meadow Ln, Columbus, OH, 432080.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-406104CLMVincent Welch1993-09-10UHC-82611-55—6269 Central Ave, Denver, CO, 802110.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-425065CLMTerry Watson1944-11-06—9459152615706 Forest Ave Apt 23, San Diego, CA, 921440.68Phone reformattedUnit split from streetState name converted to codeWhitespace trimmed
CLM-406456CLMJason S Ortiz1967-02-28UHC-90014-42—6807 Highland Ave, Chandler, AZ, 852360.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-403561CLMMargaret Long1942-10-12UHC-58275-24—3638 Lake View Rd, Fresno, CA, 937360.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-429921CLMRichard Hall1969-05-12——9227 Camelback Rd, Las Vegas, NV0.68Name re-casedZIP missingGender normalisedPlaceholder values cleared
CLM-421354CLMJacuqeline R Siingh1983-10-16—72683931728898 Forest Ave, Denver, CO, 802410.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-411659CLMSanchez Lisa1951-01-20—31877830383976 Mesa Dr, Gilbert, AZ, 852530.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-410925CLMValentina U Estrada1994-07-25UHC-11269-95—2900 Baseline Rd, Charlotte, NC, 282280.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-406204CLMNicole Snyder1950-01-09——1353 Elm St, Columbus, OH0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
32,829 rows, page 213 of 657PreviousNext