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-407177CLMAhmed T Wallace1970-07-11——4100 Cedar Ln, Scottsdale, AZ0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-424065CLMPatricia Ross1949-05-22UHC-68744-18—52 Desert Sky Blvd, Glendale, AZ, 853940.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-430815CLMDiego Montgomery1950-06-08——2865 Main St, Columbus, OH, 432110.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413278CLMKatherine King1944-12-21——5831 Meadow Ln # 329, Tempe, AZ, 852710.52Name re-casedTwo-digit birth yearUnit split from streetState name converted to code+2 more
CLM-419539CLMTerry Riley—UHC-75916-85—6634 Union St Apt 4, Seattle, WA, 981780.52Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-429105CLMWalter Gomez1945-05-22UHC-83989-3759069430612117 Camelback Rd, Chandler, AZ, 852990.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-430543CLMLauren Ryyan2006-01-13——4827 Hillcrest Rd # 940, Mesa, AZ, 852390.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-410806CLMRaymond Flores2007-11-09UHC-03771-175924754300147 Apache Blvd, Eden Prairie, MN, 553570.52Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-406325CLMJeremy Ramos1965-08-26——674 River Rd Apt 23, Tempe, AZ, 852790.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-403930CLMDanielle White1999-07-17UHC-49036-2496991903275573 Bayshore Dr, Minneapolis, MN, 554700.52Name re-casedTwo-digit birth yearZIP+4 trimmedGender normalised+2 more
CLM-431912CLMMeyer I Omar1997-04-26UHC-76229-33—6245 Market St # 805, Dallas, TX, 752020.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-424502CLMHeather Santiago1984-05-12UHC-96448-7992162741516619 Spring St, Minneapolis, MN, 554440.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423687CLMTerry Johnson—UHC-42292-19—7141 Grand Ave, Dallas, TX, 752720.52Name split from “Last, First”Date of birth unreadableSSN last four extractedState code upper-cased+2 more
CLM-401231CLMDennis Matthews1968-10-04——4603 Desert Sky Blvd, Fresno, CA, 937520.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-409518CLMHiroshi Freeman1977-05-09UHC-18692-0345634854615685 Lake View Rd, Mesa, AZ, 852820.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-409570CLMHarold Mason1940-11-11UHC-33464-88—1481 Hillcrest Rd # 741, Gilbert, AZ, 852380.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-421301CLMDonald Mooe1991-05-04UHC-35863-3839442877769889 Indian School Rd, Austin, TX, 787610.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-412961CLMRuth Payne1977-11-16UHC-75266-66—6794 Church St, Jacksonville, FL, 322900.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415301CLMAmy Lawrence—UHC-73297-66—2012 Mountain View Dr, Denver, CO, 802470.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-419672CLMWilliam Singh1953-02-25UHC-07485-7266383477772604 Meadow Ln # 378, Dallas, TX, 752220.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-407097CLMGerald Y Wagner1982-02-05UHC-37501-46—9744 River Rd, Charlotte, NC, 282690.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423132CLMCynthia King1981-07-10UHC-15784-433084654069386 Mesa Dr, Fresno, CA, 937540.52Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+2 more
CLM-416180CLMThomas Lawrence———5476 Mountain View Dr # 876, Charlotte, NC, 282760.52Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+2 more
CLM-400668CLMAshley Jones1969-09-11UHC-95558-79—1608 Desert Sky Blvd, Tucson, AZ, 857440.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-430817CLMDiego Montgomery1950-06-08UHC-56570-2394291183112865 Main St, Columbus, OH, 432110.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-410486CLMCarrolyn Price2005-12-07—63029916988651 Ridge Rd, Atlanta, GA, 303910.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-421447CLMDylan Lewis1941-12-03UHC-60307-39—5083 Elm St Apt 37, Scottsdale, AZ0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-428418CLMDiana V Ellis1985-05-03—39433155762713 Maple Ave Apt 25, Phoenix, AZ, 850470.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-431568CLMJery Obrien1955-01-20UHC-15196-52—4060 Mesa Dr # 800, Jacksonville, FL, 322040.52Name split from “Last, First”Name re-casedUnit split from streetStreet suffix standardised+2 more
CLM-415894CLMDiego Lane1943-06-06——1277 Baseline Rd, San Diego, CA, 921860.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-414186CLMCarlos Daniels1943-06-12UHC-16011-75—7763 Main St, Gilbert, AZ, 852180.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-430685CLMSharn Bell2006-07-20UHC-77136-29—6511 Sage Ct, Houston, TX, 770180.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-424078CLMHannah Bradley1971-09-11——3317 Elm St, Houston, TX0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-415759CLMMichael Anderson1966-05-26UHC-95902-85—8542 Willow Ct, Jacksonville, FL, 322600.52Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416296CLMJerry Watkins1957-07-07UHC-20153-7294077037482207 Washington St # 434, Los Angeles, CA, 900980.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432114CLMJulie Miller2007-01-20—62784060307356 Camelback Rd, Tucson, AZ0.52Name split from “Last, First”Phone reformattedZIP missingGender normalised+2 more
CLM-422371CLMJess Q Sanchez———2365 Mountain View Dr, Sacramento, CA, 958880.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424951CLMJoe E Ramos1969-08-23UHC-60247-7630585354166532 Mountain View Dr, San Antonio, TX, 782810.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-405330CLMRachel H Wong1946-03-22—81840202239625 Ocean Ave, Denver, CO, 802320.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405331CLMRachel H Wong1946-03-22—81840202239625 Ocean Ave, Denver, CO, 802320.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-429517CLMJulia D Luna1971-02-15——8584 Main St # 607, Tampa, FL, 336780.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406616CLMDenise T Henderson1969-04-06——5931 Jefferson Ave Apt 30, Tampa, FL, 336110.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414277CLMZachary Wakins—UHC-26709-9271268536309266 Ridge Rd, Atlanta, GA, 303220.52Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
CLM-425012CLMAisha Medina1999-02-06——7802 Ocean Ave # 205, San Antonio, TX, 782700.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-421335CLMMaria E Spencer1977-03-27—7254509368973 Sage Ct, Eden Prairie, MN, 553490.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430883CLMAustin Espinoza2003-02-23UHC-00961-0831334686982063 Valley View Dr, Minneapolis, MN, 554830.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-413172CLMAliceJunk1970-09-28—94185073228729 Park Pl, Houston, TX, 770780.52Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+2 more
CLM-414677CLMDunn Wei1946-05-02UHC-73139-8837561217026309 Lincoln Way # 414, Plano, TX, 750410.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-427555CLMKymberly Wood1984-10-03——6099 Cedar Ln, Tucson, AZ, 857080.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400107CLMCharles N Hall1983-05-04——9101 Sage Ct, Tucson, AZ, 857980.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
32,829 rows, page 40 of 657PreviousNext