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-412254CLMMichelle A Morales1967-07-07UHC-22339-4868693830191321 Washington St, Chandler, AZ, 852780.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-413845CLMMei Lee1978-11-25UHC-02340-9779283509364010 Central Ave, Denver, CO, 802740.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-404617CLMLinda Burton1988-11-06UHC-38270-36—3172 Baseline Rd, Phoenix, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-403055CLMAlexander V Bell————0.66Name re-casedDate of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-405573CLMEthan Ramos1939-01-13UHC-13536-9172267771856459 Willow Ct, Tampa, FL, 336030.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-422110CLMEmily Bennett1981-02-04——5579 Lake View Rd, Fresno, CA0.66Date of birth reformattedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-421709CLMThomas Rodriguez1948-09-10UHC-16493-5583564597106430 Maple Ave, Minneapolis, MN, 554970.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-412352CLMAnn Morales1982-03-06UHC-02904-05—3142 Park Pl, Austin, TX, 787730.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-420245CLMEthan Boyd1990-12-17——7978 Sage Ct, Atlanta, GA, 303720.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-400460CLMJulia Obrien1940-01-03——497 Oak St, Gilbert, AZ, 852800.66Name split from “Last, First”Name re-casedStreet suffix standardisedAddress re-cased+1 more
CLM-412911CLMVirginia Foster———8712 Central Ave, Gilbert, AZ, 852210.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-400994CLMJason Garrett2002-09-09UHC-15801-99—4930 Lincoln Way, Tucson, AZ, 857770.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-415168CLMAna Gutirrez1962-01-24UHC-95156-7180767257414154 Valley View Dr, Columbus, OH0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-404400CLMGregory Jensen2005-08-16UHC-11923-03—3096 Pine Dr, Scottsdale, AZ, 852850.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-411982CLMChristian Fuller1993-07-18——7702 Harbor Blvd Apt 39, Minneapolis, MN, 554310.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-410577CLMJoyce Morrison2008-07-04UHC-87643-47—2570 Lake View Rd, Nashville, TN, 372620.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-401998CLMAnna U Shaw1956-08-26UHC-44369-31—8585 Desert Sky Blvd, San Antonio, TX, 782760.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-431253CLMKimberly O Hill1945-12-18—77074823016792 Ocean Ave, Mesa, AZ, 852340.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-406640CLMHarold Vega1946-06-06——9470 Highland Ave, Orlando, FL, 328420.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-402517CLMEtthan K Estrada1966-04-28UHC-68529-8929136274245007 Apache Blvd, Chandler, AZ, 852290.66Middle initial moved out of first nameDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-415186CLMGabriel Taylor1973-05-24UHC-69788-78—916 Apache Blvd, Eden Prairie, MN, 553450.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-403387CLM—Junk1948-06-07UHC-54129-77—5967 Grand Ave, Mesa, AZ, 852060.66Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared+1 more
CLM-405429CLMBetty S Wallace1952-03-11—86853775063223 Central Ave, Sacramento, CA, 958790.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-428941CLMBradley Kelley1979-09-06UHC-90063-13—3620 Willow Ct, San Diego, CA, 921720.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-429790CLMNancy Marshall1961-03-10UHC-91729-28—9776 Main St, Phoenix, AZ, 850730.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-430649CLMSharon Davis1995-09-05—36757033498337 Canyon Rd, Plano, TX, 750660.66Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+1 more
CLM-430808CLMRyan Martinez1951-06-25UHC-35070-7634355182927459 Main St, Gilbert, AZ, 852640.66Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+1 more
CLM-422750CLMJulie K Banks—UHC-67292-1296165710522818 River Rd, Minneapolis, MN, 554190.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-406768CLMCharlotte Sanchez1979-02-14UHC-10300-7247732743816991 Desert Sky Blvd, Orlando, FL0.66Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+1 more
CLM-412086CLMDiego McDonald1953-03-16UHC-23070-1796526393882991 Ocean Ave, Columbus, OH, 432740.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-408400CLMAnthony Henderson1989-01-09—22622703413140 Central Ave, Tucson, AZ, 857010.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-400034CLMMartha V Stone1952-05-13——776 Oak St, Eden Prairie, MN, 553320.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
CLM-411594CLMAllen Amanda1954-10-20——4736 Lake View Rd Apt 34, San Diego, CA, 921960.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-413210CLMKathryn O Bradley1997-02-02—57858307361751 Oak St, Jacksonville, FL, 322390.66Name re-casedTwo-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
CLM-423033CLMChristne Graham1955-05-24UHC-76301-3865980308121820 Mesa Dr, Denver, CO, 802980.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-415110CLMDrois Ramirez1991-07-19UHC-73871-54—9148 Lincoln Way, Minneapolis, MN, 554020.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-409438CLMJess Ellis1997-03-05UHC-51002-75—2135 Mesa Dr, Jacksonville, FL, 322800.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-430936CLMKenneth Garrett1999-04-11——4405 Willow Ct, Chandler, AZ, 852770.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-407493CLMMateo Pierce1985-05-01UHC-17328-37—7217 Lincoln Way, Los Angeles, CA, 900120.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-427177CLMSamantha Spencer1998-11-24UHC-00058-48—6140 Grand Ave, Eden Prairie, MN, 553070.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-425730CLMBrenda Rodriguez1957-10-04UHC-80980-57—4390 Baseline Rd, Tucson, AZ, 857380.66Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-415702CLMAustin Kennedy1996-05-24——919 Ocean Ave, Seattle, WA, 981750.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425622CLMEdward Alvarado1960-06-18———0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-408971CLMMeyer Diego1940-12-11——7254 Sunset Blvd # 940, Seattle, WA0.66Name re-casedUnit split from streetZIP missingWhitespace trimmed+1 more
CLM-431711CLMDiane Y Fuller1957-04-08UHC-00407-07—5890 Apache Blvd, Houston, TX, 770640.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-406302CLMJoyce Palmer1980-11-24UHC-68741-60—712 Pine Dr, Atlanta, GA, 303600.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-404668CLMMargaret Smith1976-01-15UHC-25071-6333425918241446 Ridge Rd, Chandler, AZ0.66Two-digit birth yearPhone reformattedCity re-casedZIP missing+1 more
CLM-416523CLMValentina G Garrett1942-11-17UHC-09961-92—8627 Willow Ct, San Diego, CA, 921390.66Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-409944CLMGerald Carpenter1978-05-07——6030 Meadow Ln # 400, Tucson, AZ, 857720.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-401656CLMAlbert Salazar1970-06-22——7410 Forest Ave, Los Angeles, CA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
32,829 rows, page 159 of 657PreviousNext