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-427334CLMAbigail Stephens1949-09-04UHC-27778-6232747916897724 Camelback Rd, Plano, TX, 750700.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420289CLMSarah Hall1963-09-18—73359779307399 Park Pl # 381, Gilbert, AZ, 852050.64Phone reformattedUnit split from streetCity re-casedGender normalised+2 more
CLM-431716CLMCarol Lane1971-04-14UHC-55885-02—1038 Apache Blvd, Dallas, TX, 752070.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-406296CLMRebecca T Moore2000-10-24—21153513406114 Meadow Ln # 964, Charlotte, NC, 282110.64Name re-casedPhone reformattedUnit split from streetState name converted to code+2 more
CLM-432552CLMCharles Wang1970-06-14—86337787618724 Camelback Rd, Charlotte, NC, 282490.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-432351CLMJulie Hall1956-08-14——1783 Union St, Jacksonville, FL, 322020.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-432105CLMMargaret Stone1939-12-20UHC-82602-399749293907854 River Rd, Phoenix, AZ, 850410.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427736CLMLucia Hughes1939-07-22—37259766543294 Lake View Rd, Atlanta, GA, 303450.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-413531CLMBrian Parker1983-03-04—45258644705116 Ocean Ave, Minneapolis, MN, 554600.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419697CLMMarcus Burke2007-05-07UHC-06300-95—8892 Meadow Ln, Minneapolis, MN0.64Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-403724CLMJulie Simmos1977-12-28——3742 Forest Ave, Tucson, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-414179CLMAnn Lee1965-09-22UHC-72493-0882089835864216 Church St, Plano, TX0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406807CLMPatricia Hart1974-05-14UHC-97214-71—6473 Jefferson Ave, Phoenix, AZ, 850180.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405105CLMMary A Miller1961-10-25—4732937664870 Market St Apt 21, Orlando, FL, 328320.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405596CLMSandra Smith1977-06-05UHC-19366-2440950111272383 Park Pl, Chandler, AZ, 852040.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-413659CLMTimothy Dixon1951-11-17—44563109711368 Ridge Rd, Plano, TX, 750780.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408491CLMStephen Ptael1961-07-20——8076 Highland Ave, Columbus, OH, 432900.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430964CLMLuis Butler1948-01-28UHC-19301-15—7243 Sunset Blvd, Tampa, FL, 336710.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419212CLMJason X Herrera1956-10-03UHC-87054-0660326292246182 Baseline Rd, Gilbert, AZ, 852520.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410272CLMJoshua Cook1959-11-20UHC-57439-68—352 Apache Blvd, Tucson, AZ, 857850.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401485CLMNatalie Simpson1940-11-11—49470905294332 Maple Ave, Jacksonville, FL, 322070.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-426010CLMBrenda Lee1955-11-20UHC-79610-8433899011351869 Cedar Ln, Houston, TX, 770510.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405407CLMKeith Ortega1978-12-20UHC-38565-14—2270 Ocean Ave, San Diego, CA, 921700.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416313CLMKathy W Johnston1964-01-05—65960693615071 Elm St, Miami, FL, 331090.64Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-423558CLMDavid Brooks1939-05-06UHC-87270-42—5972 Jefferson Ave, Jacksonville, FL, 322620.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412880CLMRandy H Montgomery1973-12-01——1863 Desert Sky Blvd, Houston, TX, 770440.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-414400CLMAmanda Olson1996-07-06——4130 Hillcrest Rd, Columbus, OH0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-428527CLMBilly R Dunn—UHC-74132-1171070058178863 Bayshore Dr, Fresno, CA, 937460.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427459CLMDonna Graham1976-06-12UHC-00728-7177673054301770 Oak St, Miami, FL, 331040.64Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+2 more
CLM-400451CLMMargaret K Chavez1951-03-19UHC-92419-1187566104305663 Spring St, Minneapolis, MN, 554570.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419074CLMJason Gray1983-11-23——3678 Spring St # 478, Gilbert, AZ, 852640.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425301CLMTheresa Rios1950-03-14—49636872259833 Park Pl, Tempe, AZ, 852590.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417523CLMMichelle Green1975-07-07—96151653519862 Maple Ave, Gilbert, AZ, 852500.64Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
CLM-400954CLMCamila Santos1951-11-20—68231365594386 Lake View Rd, Seattle, WA, 981150.64Name re-casedPhone reformattedState name converted to codeGender normalised+2 more
CLM-429186CLMEric P Williamson1998-05-13—41151658516793 Hillcrest Rd, Tampa, FL, 336510.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-407961CLMKeith L Gordon1964-04-19——6363 Mesa Dr Apt 20, Scottsdale, AZ, 852490.64Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-404186CLMAlexis Daivs1952-08-28UHC-98113-37—3470 Bayshore Dr, Los Angeles, CA, 900160.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432799CLMSara Baker1998-08-02UHC-05605-66—9166 Market St, Atlanta, GA, 303310.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410291CLMKaren Morrison1985-06-12UHC-03154-6394170357989358 Mountain View Dr, Fresno, CA, 937270.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-409161CLMMary Rivera1951-04-24UHC-91758-33—3566 Central Ave, Las Vegas, NV, 891520.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-425177CLMJames Y Richardson1943-05-17UHC-80635-16—4127 Highland Ave, Gilbert, AZ, 852290.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-407644CLMButler K Betty1956-11-26UHC-72899-2457863290641390 Jefferson Ave, Dallas, TX, 752280.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401753CLMAisha X Stewart1990-01-28UHC-19127-09—4407 Baseline Rd # 262, Eden Prairie, MN, 553680.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-411401CLMEmma Harrison1939-12-13UHC-39812-09—1925 Mountain View Dr, Miami, FL, 331230.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420860CLMDiego Matthews1938-12-01UHC-11271-69—4858 Mountain View Dr, Tucson, AZ, 857080.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428753CLMJoan T Coleman2003-05-25UHC-76680-53—6592 Willow Ct Apt 33, Tampa, FL, 336360.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425696CLMDiego Vasquez1979-11-06—81959649438166 Ocean Ave, Miami, FL, 331980.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-421488CLMPhiilip B Simmons1967-10-13UHC-94170-33—4893 Maple Ave, Eden Prairie, MN, 553790.64Name re-casedCity re-casedState name converted to codeGender normalised+2 more
CLM-417569CLMStephen Carpenter1973-02-04UHC-76604-6746328202371248 Union St, Sacramento, CA, 958640.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418541CLMMei Cunningham1985-07-19UHC-58863-81—9664 Mesa Dr, Seattle, WA, 981350.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 150 of 657PreviousNext