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

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-413933CLMTim Olson1945-07-16UHC-86947-076262487152432 Union St, Sacramento, CA, 958460.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408210CLMJanet Aguilar2006-05-27UHC-14912-0460436315348578 Ridge Rd, San Antonio, TX, 782030.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-406764CLMCamila Miller1961-02-11UHC-19495-23—7163 Main St, Plano, TX, 750210.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-428354CLMKeith Thompson1963-12-21UHC-58395-7182666933096960 Indian School Rd # 152, Jacksonville, FL, 322740.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412462CLMSamuel Wong1947-11-23UHC-13804-81—3726 Hillcrest Rd Apt 14, Fresno, CA, 937400.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408145CLMYuki C Wagnner—UHC-11396-966375562087123 Sage Ct, Nashville, TN0.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-419845CLMPaul Le1992-11-08UHC-35140-5535973078913605 Oak St # 834, Minneapolis, MN, 554550.50Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
CLM-422256CLMBobby Santos1965-03-28UHC-83369-97—7250 Apache Blvd, Dallas, TX, 752170.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-412835CLMWilliam Black1967-03-21—21093421095405 Sunset Blvd, Jacksonville, FL, 322430.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-405764CLMPeter Mendoza1959-08-05UHC-10519-6373364882444978 Valley View Dr, Austin, TX0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-421568CLMAlexander Rivera1958-07-12UHC-52912-99—298 Washington St, Phoenix, AZ0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-401399CLMGabriel Robertson1946-05-09——5918 Mountain View Dr, Glendale, AZ, 853350.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-432559CLMAmanda Bennett2004-01-08UHC-35446-77—6065 Union St, Columbus, OH, 432510.50Name re-casedCity re-casedState name converted to codeZIP+4 trimmed+3 more
CLM-418910CLMRonald Ray1980-08-21UHC-88813-34—1776 Park Pl, Houston, TX, 770010.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-409918CLMGerald Cllins2008-05-28—46633584924668 Oak St, Glendale, AZ, 853810.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-417440CLMSamuel Rodriguez1957-12-02UHC-96426-29—9608 Meadow Ln, Plano, TX, 750180.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421951CLMSamuel Fisher1970-06-03UHC-59857-84—2380 Highland Ave, Seattle, WA0.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-423583CLMHarold O Howell1975-09-21UHC-51378-74—2564 Valley View Dr, Tucson, AZ, 857550.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417701CLMMargaret Morales1955-04-15UHC-83089-0655029680083331 Jefferson Ave, Miami, FL, 331610.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-427667CLMStephen Davis1963-12-19UHC-10367-58—4730 Washington St, Las Vegas, NV, 891740.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409328CLMJose Campbell1993-11-18UHC-25523-0662432631568087 Market St, Tempe, AZ, 852380.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414749CLMAllen E Mei1991-09-17UHC-06040-50—2703 Main St, Tampa, FL, 336340.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429373CLMJennifer Parker1977-11-09UHC-33407-884946594255241 Forest Ave, Austin, TX, 787160.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-401236CLMJordan Cruz2008-01-23UHC-28356-9497245526374114 Spring St, Plano, TX, 750470.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413783CLMDonald Ray1956-10-23UHC-01772-8057391247563621 Lake View Rd Apt 3, Orlando, FL, 328000.50Name re-casedTwo-digit birth yearUnit split from streetEmail lower-cased+3 more
CLM-424666CLMAlice Mejia1942-06-13——649 Apache Blvd, Denver, CO, 802540.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-426436CLMJennifre L Carroll1946-04-23—79420648224830 River Rd # 414, Las Vegas, NV, 891280.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-411700CLMMateo King1951-02-19—61231882164459 Hillcrest Rd, Tempe, AZ, 852030.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423423CLMCarolyn Porter1960-04-02UHC-22051-9296045202104594 River Rd, Sacramento, CA, 958150.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-418905CLMAustin Li1962-04-04UHC-41620-28—3597 Spring St, Plano, TX, 750290.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-413849CLMHeather Q Schultz2003-12-09UHC-31606-7823279989158354 Baseline Rd, Tucson, AZ, 857450.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406095CLMAlan W Tran1970-06-06UHC-55420-11—7475 Valley View Dr, Nashville, TN0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401620CLMDiaana Rice2002-10-03——4811 Maple Ave # 691, Fresno, CA, 937010.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421125CLMMadison Wilson2002-03-26UHC-28652-3395723362995217 Ocean Ave, San Antonio, TX, 782270.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-426414CLMJulie Rojas1950-04-23UHC-51780-16—5396 Meadow Ln # 484, San Diego, CA, 921390.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-429143CLMHeather Nelson———3480 Main St, Plano, TX, 750590.50Name re-casedDate of birth missingSSN last four extractedStreet suffix standardised+3 more
CLM-418843CLMDavid Masson—UHC-84212-3179096479334860 Mountain View Dr, Jacksonville, FL, 322550.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-422373CLMJessica Q Sanchez1948-10-19——2365 Mountain View Dr, Sacramento, CA, 958880.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-425200CLMJean W Gonzales1941-09-26UHC-86751-2435847574966416 Canyon Rd, San Antonio, TX, 782770.50Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
CLM-410594CLMAlice Pierce1941-03-26UHC-24760-22—217 Washington St # 973, Austin, TX, 787840.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421183CLMGary M Guerrero1985-12-10—41059451495571 Jefferson Ave, Los Angeles, CA0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-419888CLMBrian Walsh1969-11-11UHC-92358-31833588381383 Lincoln Way, Houston, TX, 770960.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-415255CLMRalph Pena——4703598893154 Central Ave, Jacksonville, FL, 322150.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-426102CLMDiana V Walker1939-03-20UHC-90580-2726141525432920 Park Pl, Dallas, TX, 752360.50Middle initial moved out of first nameName re-casedPhone reformattedCity re-cased+3 more
CLM-408238CLMJulia Estrada1999-12-16—84194284429472 Bayshore Dr # 137, San Diego, CA0.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-430362CLMJanet Reed1958-05-16—763544430195 Valley View Dr, Tempe, AZ, 852840.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428694CLMLucia Rios1939-04-02—50956945025436 Camelback Rd, Denver, CO, 802480.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
CLM-414701CLMAlexander Washington1959-07-09UHC-78887-44—5736 River Rd # 502, San Antonio, TX, 782470.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-423312CLMLiz Simpson—UHC-88527-1757837781887249 Valley View Dr, Las Vegas, NV, 891020.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-408265CLMAlice Duncan1962-04-05UHC-66041-95—4992 Church St # 454, Seattle, WA, 981610.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
32,829 rows, page 30 of 657PreviousNext