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-408327CLMAbigail T Pyne2008-05-01UHC-49968-6167379258142812 Sage Ct, Nashville, TN, 372870.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-401569CLMHannah Coleman1957-12-14UHC-98061-34—295 Desert Sky Blvd, Minneapolis, MN, 554090.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431703CLMSamuel Gardner1940-08-26UHC-71837-1294443882885394 Meadow Ln # 550, Gilbert, AZ, 852080.62Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-425326CLMCynthia Moore1943-06-06UHC-70365-62—88 Church St, Los Angeles, CA, 900280.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-408115CLMAlvarez Tyler1966-04-13UHC-06222-12—9548 Mountain View Dr, Mesa, AZ, 852420.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403475CLMPierce Kathryn1939-02-21—53352574499528 Washington St, Tampa, FL, 336280.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422519CLMHelen Williams1978-04-25UHC-69324-2238142719211803 Bayshore Dr, San Antonio, TX0.62Name re-casedPhone reformattedCity re-casedZIP missing+3 more
CLM-417458CLMIsabella Gutierrez1951-12-15UHC-20838-77—4325 Elm St, Fresno, CA, 937900.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426481CLMTeresa Elliott1939-11-27——621 Grand Ave, Gilbert, AZ, 852590.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426949CLMKaren Powell1988-04-09—96486333709084 Highland Ave, Columbus, OH, 432750.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425827CLMChristina Schmidt1996-06-17UHC-77684-459199326338113 Highland Ave, Mesa, AZ0.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-423679CLMLawrence Gomez1999-08-14UHC-68241-4079498766416422 Harbor Blvd, Denver, CO, 802770.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-423680CLMLawrence Gomez1999-08-14UHC-68241-4079498766416422 Harbor Blvd, Denver, CO, 802770.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-424829CLMJose Patterson1982-09-22—84965509509395 Sunset Blvd # 277, Houston, TX, 770660.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-415090CLMDaniel K Reid1939-01-23UHC-18514-12—8395 Camelback Rd, Columbus, OH, 432090.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418161CLMJoseph Wong1958-03-21——3089 Lake View Rd Apt 23, Scottsdale, AZ, 852580.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-400376CLMGlorria Woods1998-09-16UHC-12398-94—6142 Jefferson Ave, San Antonio, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412007CLMJulia Cook1977-05-13——9050 Highland Ave, Scottsdale, AZ, 852170.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-416145CLMJonathan Burke1984-10-02UHC-30312-35—4277 Washington St # 967, Denver, CO, 802090.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-411262CLMAdam Bailey1993-04-26—59361051888267 Sage Ct, Fresno, CA, 937260.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
CLM-415155CLMAmber Burke1994-03-09UHC-16041-5589092749708073 Sunset Blvd, Austin, TX0.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-403409CLMVirginia D Nelson1942-06-13UHC-91099-8833790334835994 Ridge Rd, Tempe, AZ, 852830.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402932CLMSarah Reed1980-11-17—42888262136096 Hillcrest Rd Apt 32, Tempe, AZ, 852420.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-426921CLMTheresa Washington1957-04-11UHC-57051-3393743688343875 Washington St, Scottsdale, AZ0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-427249CLMJoshua Rose1961-09-22—70952991557769 Ridge Rd, Minneapolis, MN, 554560.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-402886CLMMark V Cloe1958-09-01——9515 Sunset Blvd, Nashville, TN, 372860.62Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-414706CLMSophia Perez1948-12-19UHC-65778-8744527874322043 Forest Ave, Sacramento, CA, 958330.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403814CLMJesse Y Alvarez1939-04-07—64164467818496 Harbor Blvd, Scottsdale, AZ, 852710.62Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407806CLMBrandon Bryant1995-01-07UHC-65094-90—7968 Central Ave, Tampa, FL, 336480.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-410585CLMDenise Hawkins2001-05-23UHC-13378-62—1088 Washington St, Charlotte, NC, 282560.62Name re-casedStreet suffix standardisedAddress re-casedGender normalised+3 more
CLM-411637CLMSusan E Coleman1952-10-13UHC-57625-863484770801355 Mountain View Dr, Tempe, AZ, 852080.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401011CLMJustin Weber1948-06-28UHC-21843-6386070397909726 Palm Dr, Miami, FL, 331310.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401661CLMChristina Sandoval1983-12-28—6713807910257 Meadow Ln, Fresno, CA, 937620.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-413683CLMDaniel Myers2000-04-01UHC-98359-04—3748 Canyon Rd, Tempe, AZ, 852480.62Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-412652CLMEvelyn I Stewart1997-03-04UHC-37643-23—8320 Union St, Atlanta, GA, 303320.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-421132CLMHannah Hoffman1951-10-12UHC-41519-6164182145182300 Elm St Apt 40, Orlando, FL, 328790.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-409707CLMJoshua Smith1948-04-04UHC-43885-01—7868 Bayshore Dr, Jacksonville, FL, 322660.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421090CLMDavd Butler2004-12-28——2061 Lake View Rd, Mesa, AZ, 852770.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432169CLMLogan Morrison1992-11-08UHC-83355-8282631219897541 Canyon Rd, Phoenix, AZ, 850430.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429942CLMPatrick Sanders2005-09-06UHC-58486-4635835405984835 Apache Blvd, San Diego, CA, 921930.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411821CLMVincent Jones1975-09-01UHC-15101-05—3540 Jefferson Ave, Nashville, TN0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406421CLMChristine N Reid1967-02-20—78720631297201 Ridge Rd, Jacksonville, FL, 322800.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428736CLMPamela Cooper1993-04-16UHC-38311-7959956354297204 Indian School Rd Apt 29, Miami, FL, 331070.62Date of birth reformattedPhone reformattedUnit split from streetState code upper-cased+3 more
CLM-430077CLMJoyce Hughes1975-01-28UHC-03319-12—4430 Park Pl, Atlanta, GA, 303090.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417614CLMChristopher Johnson1986-12-21UHC-69482-09—2472 Highland Ave, Mesa, AZ, 852460.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423562CLMHannah P Brooks1959-04-20——6472 Washington St, Jacksonville, FL, 322480.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407515CLMLawrence Maldonado1994-07-20—81329809197498 Main St, Glendale, AZ, 853670.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-428061CLMMadison L Perry1958-07-15UHC-18581-365668111707744 Harbor Blvd, Glendale, AZ, 853890.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419157CLMMadison Hunter1956-09-19UHC-08390-0923529693045842 Valley View Dr, Nashville, TN, 372300.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413626CLMTyler Madina1990-10-01UHC-89806-7323478909453212 Grand Ave, Mesa, AZ, 852820.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 76 of 657PreviousNext