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-411250CLMLuis Watsno2007-09-15—5886013478265 Spring St, Los Angeles, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-402801CLMEmily Walker1997-10-13——350 Main St # 285, San Diego, CA, 921350.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415920CLMDonna Webeer1951-08-05UHC-68630-22—3086 Sunset Blvd, Scottsdale, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-422092CLMLuis R Romero1947-05-10—93223774682683 Mountain View Dr, Glendale, AZ0.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-410663CLMCarolyn King—UHC-08940-62—2064 Park Pl, San Antonio, TX, 782710.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-410684CLMTeresa Gonzales1961-04-23—44678704839167 Grand Ave, Houston, TX0.66Phone reformattedCity re-casedZIP missingGender normalised+1 more
CLM-432522CLMBrandon Graham—UHC-05149-71—8834 Mesa Dr, San Antonio, TX, 782530.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-432267CLMKyle Q Wells1988-04-04UHC-72557-1873237381055026 Sage Ct, Sacramento, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-409739CLMScott U Howell2004-09-04UHC-80139-4822294350451885 Meadow Ln, Houston, TX, 770710.66Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-421635CLMJustin Nguyen1975-03-19UHC-14195-85—9384 Park Pl, San Antonio, TX, 782740.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-416317CLMCharlotte Le1980-08-17UHC-88223-3574362526423814 Mesa Dr, Charlotte, NC, 282170.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-418514CLMKelly Praker1956-06-27UHC-71577-37—8069 Palm Dr, Dallas, TX, 752350.66Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-416681CLMDorothy Wagner—UHC-27472-49——0.66Date of birth unreadableGender normalisedPlan code upper-casedWhitespace trimmed+1 more
CLM-414743CLMShirley Lopez1991-06-04UHC-44235-49—1286 Park Pl Apt 22, Scottsdale, AZ, 852140.66Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-428820CLMEic Shaw1996-01-06——5021 Indian School Rd, Charlotte, NC, 282760.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-417704CLMBrandon Dixon1978-07-20UHC-95071-9180745568619110 Central Ave, Tampa, FL0.66Date of birth reformattedPhone reformattedState name converted to codeZIP missing+1 more
CLM-432500CLMOmar Bryant1987-03-17UHC-89172-02—3274 Willow Ct, Chandler, AZ, 852070.66Member ID reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-430230CLMMaria Montgomery1951-04-08—61734444292720 Baseline Rd # 888, Plano, TX, 750560.66Name re-casedUnit split from streetCity re-casedState name converted to code+1 more
CLM-423608CLMGerald Perkins1983-10-22UHC-47298-31—9658 Maple Ave, Glendale, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-416110CLMCarlos T Walsh1955-02-16UHC-12354-086298076457—0.66Name split from “Last, First”Middle initial moved out of first nameMember ID reformattedWhitespace trimmed+1 more
CLM-411399CLMJulie T Ortega1964-09-26——1649 Mountain View Dr, Fresno, CA0.66Name split from “Last, First”Date of birth reformattedZIP missingWhitespace trimmed+1 more
CLM-419771CLMHannah Schultz1980-07-03—96247471478354 Mountain View Dr, Scottsdale, AZ, 852980.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-425601CLMKimberly Nichls1990-03-12UHC-32538-3373789947026697 Central Ave, Tucson, AZ, 857290.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-417936CLMAlbert Gonzalez1940-07-10UHC-09877-20—2501 Mountain View Dr, Sacramento, CA, 958190.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-430503CLMPamela Guzman1982-06-11UHC-98619-77—9168 Mountain View Dr, Tempe, AZ, 852570.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-426354CLMMaria P Hawkins1984-05-24UHC-51163-84—4711 Desert Sky Blvd, Austin, TX, 787830.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-426355CLMMaria P Hawkins1984-05-24UHC-51163-84—4711 Desert Sky Blvd, Austin, TX, 787830.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-421390CLMPriya Shaw1962-02-02UHC-12156-22—5944 Park Pl, San Diego, CA, 921490.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-414891CLMDevid R Ryan1956-10-15——5705 Pine Dr, Tempe, AZ, 852470.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-429783CLMVincent Ward1982-04-26——2532 Market St, Mesa, AZ, 852010.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-403277CLMHarold Cox1990-07-21—89663290137364 Lincoln Way, Las Vegas, NV0.66Name split from “Last, First”Phone reformattedZIP missingWhitespace trimmed+1 more
CLM-426602CLMChristopher Simmons1966-01-20—8908945678882 Park Pl, Tempe, AZ0.66Phone reformattedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-411265CLMOmar Wheeler1960-05-05UHC-30732-712125578510239 Camelback Rd, Chandler, AZ, 852100.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-432399CLMRonald Cox1994-08-04UHC-07390-48—1782 Camelback Rd # 759, Scottsdale, AZ, 852310.66Date of birth reformattedUnit split from streetCity re-casedGender normalised+1 more
CLM-425226CLMJose Matthews———2912 Hillcrest Rd, Nashville, TN, 372100.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421311CLMLori Montgommery1983-05-09UHC-75965-0545991803356858 Market St, Tucson, AZ, 857920.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-423167CLMKaren Reynolds1987-01-01UHC-41791-25—1102 Jefferson Ave, Fresno, CA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-412284CLMKathleen Bryant1993-08-19UHC-97131-905482378126—0.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-402352CLMRalph Woods1967-07-26UHC-78850-61—6887 Spring St, Tampa, FL, 336710.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-402976CLMPhilip Le1983-04-22UHC-39834-9475348630353707 Union St, Jacksonville, FL, 322020.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-401993CLMAlexis Henderson1968-03-27—24724074175737 Lake View Rd, Phoenix, AZ, 850330.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421772CLMJose Y Perez1980-04-25UHC-94809-39—4123 Central Ave, Gilbert, AZ, 852570.66Name split from “Last, First”Street suffix standardisedAddress re-casedPlan code upper-cased+1 more
CLM-414993CLMKieth L Jones1987-01-29UHC-95396-9124741923425349 Palm Dr, Orlando, FL, 328840.66City re-casedState name converted to codeGender normalisedPlan code upper-cased+1 more
CLM-421288CLMLawrence Johnston1976-02-23——4994 Desert Sky Blvd, Tempe, AZ, 852950.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-425470CLMSteven Ramos1969-01-26—73129290981184 Hillcrest Rd, Sacramento, CA0.66Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+1 more
CLM-400519CLMJoseph Jordan1959-10-27UHC-90858-1124182465988423 Palm Dr, Las Vegas, NV, 891430.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-410334CLMAbigail Y Martinez1967-03-08UHC-84886-97—2815 River Rd, Mesa, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-404222CLMJanet Ross2007-08-11UHC-36044-21—4119 Bayshore Dr, Charlotte, NC, 282510.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402171CLMKathryn Stone1968-08-16UHC-92523-76—4756 Pine Dr, Seattle, WA, 981310.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-415617CLMLinda E Green1970-08-10——8032 Valley View Dr, Los Angeles, CA, 900380.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
32,829 rows, page 165 of 657PreviousNext