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-426111CLMMary Chen1953-10-21UHC-42080-3686085699385728 Desert Sky Blvd, Charlotte, NC, 282480.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404754CLMJeck T Vargas2005-10-08UHC-19817-94—2856 Baseline Rd, Plano, TX, 750000.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407209CLMHenry X Roberts1969-10-21UHC-17992-7568560785237955 Sage Ct Apt 12, Chandler, AZ, 852850.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-403711CLMKeith I Vazquez1965-05-23——6164 Grand Ave, Scottsdale, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418054CLMKaren O Andeson1974-08-20——3300 Mountain View Dr, Los Angeles, CA, 900490.64Street suffix standardisedAddress re-casedGender normalisedPlan code upper-cased+2 more
CLM-426568CLMAhmed Fissher1970-04-26UHC-88024-63—3622 Church St, San Diego, CA, 921060.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-418673CLMKyle Wallace1979-06-21UHC-43398-94—4635 Indian School Rd Apt 11, Tempe, AZ, 852900.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418114CLMKimberly Burns1982-01-20——3423 Camelback Rd Apt 19, Tempe, AZ, 852560.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-401454CLMNoah K Thompson1941-11-01UHC-55460-6330267289445805 Lincoln Way, Los Angeles, CA, 900830.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417946CLMKevin Cunningham1962-09-09——9629 Cedar Ln, Gilbert, AZ, 852640.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-429264CLMNicholas Carr1989-07-01UHC-93074-6997383142849452 Indian School Rd, Tucson, AZ, 857420.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413926CLMAustin Y Patel1972-10-22——1655 Baseline Rd, Atlanta, GA, 303870.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-400111CLMPriya Griffin1949-11-04UHC-95233-69—229 Elm St, Atlanta, GA, 303600.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422910CLMBradley Rodriguez1956-08-20UHC-54839-1944228750806966 Canyon Rd, Tampa, FL, 336200.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409345CLM—Junk1980-06-04UHC-22345-18—2722 Grand Ave, Scottsdale, AZ, 852240.64Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-421030CLMEvelyn Q Matthews1950-08-19UHC-50807-1236995507223422 Market St Apt 11, Chandler, AZ, 852600.64Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
CLM-413447CLMEmily Sanders——69528885301004 Central Ave, Glendale, AZ, 853130.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-416320CLMGabriel Carr2007-02-14—66936114732015 Jefferson Ave, Tempe, AZ, 852720.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-413869CLMJackie Contreras1958-06-05—58197915568014 Forest Ave, Gilbert, AZ, 852860.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429694CLMDeebra Wod1946-09-21UHC-63319-04—3612 Sunset Blvd, Houston, TX, 770290.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-418152CLMHarrold K Mejia1969-10-17UHC-63645-9151633202942037 Desert Sky Blvd, Las Vegas, NV, 891090.64Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+2 more
CLM-407271CLMGraham M Mason1983-02-26UHC-31696-70—4232 Desert Sky Blvd, Charlotte, NC, 282010.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-409138CLMBruce Adams1942-10-15——6011 Main St, Sacramento, CA, 958240.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420942CLMBetty U Wood1993-01-15UHC-43146-3280759327872494 Lincoln Way, Miami, FL, 331120.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432788CLMBenjamin S Lane1985-01-05UHC-09486-02—6981 Cedar Ln, Miami, FL, 331140.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-409651CLMWei Jenkins1985-01-01UHC-07937-8962576164002854 Elm St, Nashville, TN, 372530.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400941CLMSantiago Elliott1978-11-02UHC-15961-44—3870 Willow Ct, Mesa, AZ, 852570.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-420140CLMDiane Hughes2002-11-27UHC-73105-62—5255 River Rd, Seattle, WA, 981340.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-415234CLMBetty Walsh1988-09-04UHC-06757-5991282887783850 Maple Ave, Sacramento, CA, 958040.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420715CLMDennis N Ray1961-07-12UHC-11585-25—959 Sunset Blvd, Atlanta, GA0.64Middle initial moved out of first nameName re-casedDate of birth reformattedZIP missing+2 more
CLM-414171CLMMateo Wright1949-05-26UHC-17285-52—4302 Harbor Blvd, Columbus, OH, 432340.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413093CLMCynthia Mejia—UHC-80006-11—8021 Spring St, Austin, TX, 787920.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-415608CLMLarry H Mejia1944-06-07—82827648753854 Desert Sky Blvd, Jacksonville, FL0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-404004CLMRyan Thompson1943-03-11UHC-29740-7642499136712844 Camelback Rd, Glendale, AZ, 853900.64Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-424961CLMDavid Bennett2008-07-02UHC-52325-2163142430754502 Sunset Blvd, Los Angeles, CA, 900290.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414145CLMKelly Clark1954-01-15——7794 Washington St, Orlando, FL, 328200.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420114CLMRoger Wang1971-06-16UHC-11203-29—932 Park Pl, Denver, CO0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-426506CLMJordan Walker1988-02-19UHC-96381-0425245092373465 Union St # 959, Columbus, OH, 432910.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-400681CLMEvelyn Brooks1949-05-03UHC-06356-8863547711999160 Forest Ave, Scottsdale, AZ0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401112CLMJeffrey Garrett1942-07-10—83674690739155 Bayshore Dr, Seattle, WA, 981410.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424141CLMDonald R Hudson1976-01-19UHC-43303-53—6764 Baseline Rd # 526, Charlotte, NC, 282840.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405904CLMSophia N Wagner1982-04-26—8895125018617 Highland Ave, Gilbert, AZ0.64Name re-casedTwo-digit birth yearPhone reformattedZIP missing+2 more
CLM-412866CLMSteven Clark1959-12-17——9021 Sage Ct, Denver, CO, 802680.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-417092CLMNicole Owens1975-09-15——618 Mountain View Dr, San Antonio, TX, 782160.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423842CLMWayne Ward1981-01-02UHC-83240-7660541990989586 Baseline Rd, Seattle, WA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-428506CLMAlbert Kim1960-05-01UHC-94099-8481791017157346 Spring St, Las Vegas, NV, 891510.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-407393CLMBobby Alexander2003-03-28UHC-39102-268218710887711 Mountain View Dr, Tempe, AZ, 852420.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-424368CLMBilly Burns1994-09-28——1909 River Rd, Columbus, OH, 432510.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-408121CLMStephen Peterson1943-06-12—52298349776606 Jefferson Ave, San Antonio, TX, 782420.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402072CLM—Junk2002-08-25—6695645536—0.64Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+2 more
32,829 rows, page 132 of 657PreviousNext