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-404891CLMJacqueline Maldunado1998-04-09UHC-66870-4625032667267026 River Rd, Chandler, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400132CLMPaul Russell1988-05-04——6403 Mountain View Dr, Chandler, AZ, 852640.62Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+3 more
CLM-400131CLMPaul Russell1988-05-04——6403 Mountain View Dr, Chandler, AZ, 852640.62Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+3 more
CLM-422091CLMDaniel D Sanchez1968-03-01——1280 Mesa Dr, Eden Prairie, MN, 553960.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-423689CLMAaron Johnson1978-11-04UHC-30422-67—9581 Indian School Rd, San Antonio, TX, 782830.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403613CLMRonald N Richardson1961-04-12UHC-28177-64—7869 Grand Ave # 299, Sacramento, CA, 958500.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-415449CLMJames Fernandez1994-08-23UHC-25043-68—8740 Palm Dr, Seattle, WA, 981020.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-417228CLMAndrea Anderson1945-09-25UHC-88955-23—1436 Cedar Ln, San Antonio, TX, 782500.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-416454CLMPriya Brown1939-10-04UHC-98213-179616654710247 Baseline Rd, San Antonio, TX, 782440.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419309CLMRebecca Munoz2001-02-01—76628388437527 Maple Ave Apt 20, Scottsdale, AZ, 852190.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-418838CLMJennifer Martinez1972-10-26UHC-89803-35—7039 Elm St, Minneapolis, MN, 554670.62Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-403380CLMDeborah Fox1950-06-06——1515 Hillcrest Rd, Orlando, FL, 328910.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406265CLMBrandon Marquez1988-10-02—6857736445573 Canyon Rd, Gilbert, AZ, 852320.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-424154CLMJoshua Vasquez1966-07-05—63763719949356 Park Pl, Atlanta, GA, 303800.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-420376CLMLori V Nichols1941-10-03UHC-19429-29—8962 Union St, Gilbert, AZ, 852640.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407498CLMPeter Fowler1972-04-02——646 Willow Ct, Tampa, FL, 336750.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420683CLMBilly Ramirez1964-04-15UHC-43295-81—773 Union St, Charlotte, NC, 282130.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425490CLMAmber Baker1975-02-20UHC-69086-4795829584418203 Bayshore Dr Apt 23, Austin, TX, 787270.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-428775CLMMichael Duncan2004-05-22UHC-46296-78—1692 Central Ave, Charlotte, NC, 282850.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-409543CLMStephanie Nichols1973-03-28UHC-36102-54—6263 Ocean Ave # 311, Gilbert, AZ, 852520.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-420795CLMAaron Y Pierce1942-09-19—34828520307423 Park Pl, Houston, TX, 770630.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422113CLMGloria Brooks——32539539619448 Cedar Ln, Orlando, FL, 328130.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-410950CLMJoseph A Estrada1977-05-26UHC-44142-504514839542712 Washington St, Los Angeles, CA, 900250.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402491CLMBarb C McDonald1983-01-14UHC-32514-51—2086 Washington St, Charlotte, NC, 282270.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407973CLMDanielle Reynolds1999-12-27UHC-46263-1078195984793684 Willow Ct, Atlanta, GA, 303960.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-403136CLMHannah M Aguilar1973-09-23——5872 Harbor Blvd, Minneapolis, MN, 554020.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401617CLMSophia Fox1973-06-20UHC-96989-32—5249 Sage Ct, Houston, TX, 770120.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423937CLMGerald Foster1993-02-26——8689 Jefferson Ave, Tucson, AZ, 857620.62Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-413568CLMBrandon Peterson1974-03-12UHC-68516-2457284243068586 Central Ave, Glendale, AZ, 853920.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425295CLMRichard F Cruz2008-02-16UHC-30512-30—9194 Mesa Dr, Houston, TX, 770080.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403529CLMMaria Chavez1966-05-25UHC-22088-39—9462 Mountain View Dr # 944, Atlanta, GA, 303180.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-427693CLMAmy Fernandez1948-03-16—28972047603078 Lake View Rd # 495, Los Angeles, CA, 900290.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-407184CLMHelen N Kelley1996-05-12UHC-08411-81—9444 Valley View Dr, Columbus, OH, 432480.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-416842CLMMason Ferguon1968-08-04UHC-99590-17—4206 Elm St, Scottsdale, AZ, 852430.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406255CLMLinda Wood2007-12-16UHC-88685-4951252697924941 Highland Ave Apt 30, Columbus, OH, 432310.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-425214CLMJerry Hamilton1954-08-13UHC-24792-3120967071763452 Ocean Ave, Seattle, WA0.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401507CLMMariana O Fox1973-08-19UHC-10297-9360680404097850 Baseline Rd, Nashville, TN0.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-418515CLMKelly Parkr1956-06-27UHC-71577-3783080155168069 Palm Dr, Dallas, TX, 752350.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404585CLMMaria T Pierce1999-11-23—92460105758608 Camelback Rd, Seattle, WA, 981030.62Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-404485CLMNatalie N King1946-01-09UHC-53620-3743478365085353 Valley View Dr, Mesa, AZ, 852560.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
CLM-411669CLMCynthia Montgomery1950-08-16UHC-56890-57—8486 Maple Ave, Los Angeles, CA, 900290.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431058CLMJonathan Hunt1991-05-28UHC-20299-8623389320438273 Palm Dr, Tampa, FL, 336130.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422204CLMAaron Coleman1950-11-02—46847164385871 Forest Ave, Las Vegas, NV, 891920.62Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
CLM-420241CLMNancy George1979-06-04UHC-95306-31—436 Bayshore Dr # 320, San Antonio, TX, 782340.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-425694CLMAaron Reyes1946-09-11UHC-03623-3824061062597541 Canyon Rd, Charlotte, NC, 282280.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402051CLMNancy Munoz1947-05-03UHC-50527-20—3307 Elm St, Plano, TX, 750940.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424908CLMScott Romero1949-12-11—86051807119688 Spring St, Seattle, WA, 981880.62Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-425745CLMJamees Li2003-12-03——823 Bayshore Dr, Houston, TX, 770630.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432701CLMKatherine Silva1967-06-26UHC-61789-52—1917 Palm Dr, Houston, TX, 770400.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432780CLMBrian Vazquez1956-09-26UHC-89900-10—6606 Oak St Apt 23, Austin, TX0.62Name re-casedDate of birth reformattedUnit split from streetCity re-cased+3 more
32,829 rows, page 100 of 657PreviousNext