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-416787CLMGeorge Cooleman1961-02-13—96092667174707 Meadow Ln, Las Vegas, NV0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408602CLMArthur Lucas1982-09-11UHC-03901-28—2547 Ocean Ave, Nashville, TN, 372280.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429128CLMDiane Diaz1958-03-01UHC-31018-76—3673 Ocean Ave, Atlanta, GA, 303360.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431538CLMRichard White1967-04-21UHC-57024-229234712099371 Palm Dr, Houston, TX, 770000.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414117CLMDennis B Spencer1979-01-01—89497039734568 Church St, Minneapolis, MN, 554510.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431998CLMRalph Mejia1955-01-02—38453637829551 Willow Ct, Dallas, TX, 752280.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417157CLMMichael Robinson1959-07-08UHC-13400-89728752516655 Union St, Orlando, FL, 328390.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421432CLMLucia Vazquez1970-06-11—63375994644165 Meadow Ln, Fresno, CA, 937110.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430454CLMRalph L Phillips1983-08-09UHC-05137-74—6178 Park Pl, Austin, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407659CLMSarah B Ford1998-10-01UHC-23807-4981770109117721 Maple Ave, Phoenix, AZ, 850880.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415545CLMAndy Romero1986-01-06——7154 Highland Ave, Charlotte, NC, 282100.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405668CLMHenry Larson2005-10-19UHC-00409-5762150212803319 Maple Ave, Jacksonville, FL, 322040.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400195CLMAndrea R Mendoza1949-05-24UHC-31553-52—3821 Willow Ct, Denver, CO, 802300.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-410517CLMJames Burke1984-04-13UHC-15512-7147689820742643 Park Pl, Dallas, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409372CLMGerald Ramirez1975-05-28UHC-09097-49—7735 Ridge Rd, Nashville, TN, 372360.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-405262CLMHelen Simmmons——4919270856711 Oak St, Eden Prairie, MN, 553770.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-426970CLMWei K Ruiz1962-05-15UHC-43378-2049143429734731 Canyon Rd, Sacramento, CA, 958790.62Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-426763CLMBrian Stone1973-10-20——1030 Highland Ave, San Diego, CA0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426647CLMLori Lucas1987-09-03UHC-85098-51—699 Spring St, Los Angeles, CA, 900970.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-409126CLMJenny Bradley1986-09-17UHC-27870-3248684099638203 Park Pl, Houston, TX, 770440.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-413902CLMJustin Johnsno2003-07-03—66562285324490 Palm Dr, Tempe, AZ, 852930.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404182CLMChristina Austin1968-05-12UHC-18686-1173485466091879 Forest Ave, Orlando, FL, 328800.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413366CLMTeresaJunk2002-02-28UHC-70614-27—421 Camelback Rd, Fresno, CA, 937100.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-404271CLMNancy Williams1978-09-28——6186 Grand Ave, Las Vegas, NV, 891450.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402945CLMFrances Bailey1996-09-28——8364 Park Pl, Nashville, TN, 372260.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423918CLMAlice Meyer1980-10-04UHC-24459-4641180733647448 Mesa Dr Apt 38, Chandler, AZ, 852720.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410629CLMRonald Olson1939-10-04UHC-08656-71—9584 Maple Ave, Dallas, TX, 752480.62Name re-casedStreet suffix standardisedAddress re-casedGender normalised+3 more
CLM-419857CLMGeorge Garza1954-05-23——9721 Indian School Rd, Dallas, TX, 752910.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-421379CLMDylan Bowman1984-06-22——2383 Cedar Ln, Jacksonville, FL, 322370.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401950CLMRachel Duncan1956-12-06UHC-69533-34—696 Sage Ct, Los Angeles, CA, 900160.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430086CLMAmy Butler1959-06-20——1003 Harbor Blvd, Tucson, AZ, 857530.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418735CLMRandy Fisher1984-01-26UHC-09845-248405547906772 Harbor Blvd, Atlanta, GA, 303930.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-410557CLMThomas D Walker1999-03-19—73296350295048 Market St, Glendale, AZ, 853980.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406054CLMLaura Perkins1956-09-28UHC-63015-7182067780655448 Baseline Rd, Minneapolis, MN, 554930.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-403073CLMDiego West1962-07-26——3822 Baseline Rd, Dallas, TX, 752350.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-427189CLMPriya Rodriguez1963-11-16UHC-00786-9367238061497200 Indian School Rd # 773, Las Vegas, NV, 891540.62Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
CLM-412272CLMCharlotte C Obrien1983-03-14UHC-54203-403556449036314 Washington St, San Diego, CA, 921680.62Name split from “Last, First”Name re-casedPhone reformattedStreet suffix standardised+3 more
CLM-424145CLMJoey Wallace1976-07-05UHC-18297-39—916 Canyon Rd, Atlanta, GA, 303550.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407937CLMNoah Clark1948-07-26UHC-89607-2227737092276089 Hillcrest Rd, Seattle, WA, 981210.62Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-425974CLMTyler Myers1945-12-14——7937 River Rd # 960, Atlanta, GA, 303770.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421586CLMDoris Guzman1957-10-23UHC-56787-5936427223553126 Indian School Rd, Minneapolis, MN, 554660.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-407819CLMLinda Price2004-11-07UHC-25551-76—8430 Cedar Ln, Chandler, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420806CLMJordan F Rose1980-10-09UHC-57654-16—4464 Lincoln Way, Gilbert, AZ, 852410.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405117CLMMaria T Ortega1953-05-24UHC-21435-1823193628245472 Oak St, Austin, TX, 787140.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427794CLMAlice Austin1992-08-28UHC-95346-5179676477728627 Harbor Blvd, Phoenix, AZ, 850030.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-420043CLMDanny Parker1977-04-03UHC-98857-9356394623755608 Canyon Rd, Tucson, AZ, 857590.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414048CLMMason Le1954-04-12—60575311261454 Camelback Rd Apt 7, Glendale, AZ, 853610.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-425010CLMDennis M Elliott1944-08-12UHC-36167-2389899554092860 Ocean Ave, Eden Prairie, MN, 553870.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-420937CLMJudith N Soto1995-03-06——580 Jefferson Ave, San Antonio, TX, 782240.62Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-414021CLMJoe Wright1992-06-04UHC-08635-40—907 Apache Blvd, Gilbert, AZ, 852910.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 90 of 657PreviousNext