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-418667CLMChristian James1977-10-08UHC-82723-9144291672119378 Oak St, Tempe, AZ, 852420.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422867CLMJack Duncan1956-08-24UHC-24560-5979595746531814 Central Ave, Phoenix, AZ, 850210.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415457CLMNoah Bryant1949-03-15UHC-89912-1267688152088174 Pine Dr, Jacksonville, FL, 322620.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-408376CLMRonald Dunn1949-01-14—79476788631118 Desert Sky Blvd # 897, Fresno, CA, 937720.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-404345CLMAmy Hanson1938-10-03UHC-42412-5647935662708796 Bayshore Dr, Columbus, OH, 432400.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-412282CLMChristopher Rivera—UHC-38401-4978494091677584 Grand Ave, Tucson, AZ, 857870.62Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421291CLMHelen Guerrero1991-08-23UHC-70876-5476428525613231 Baseline Rd, Glendale, AZ, 853290.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431085CLMNatalie R Thompson1999-02-26UHC-21601-3434448855693722 Lincoln Way, Denver, CO, 802040.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-403014CLMElizabeth Carr1950-05-12UHC-31609-6266664472868111 Bayshore Dr, San Antonio, TX, 782460.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-418614CLMRachel Arnold2006-11-03UHC-88152-78—5388 Highland Ave, Austin, TX, 787050.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420583CLMGregory Hudson1968-08-14UHC-14069-21—7983 Hillcrest Rd # 180, Plano, TX0.62Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more
CLM-418157CLMChristopher Cunningham1989-03-02——9136 Apache Blvd, Seattle, WA, 981200.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428767CLMKyle Delgado1997-02-18UHC-21688-31—8719 Maple Ave, Columbus, OH, 432970.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425141CLMPiya Taylor1960-10-18—93344403692303 Hillcrest Rd, Atlanta, GA, 303470.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432437CLM—Junk1987-08-11UHC-33009-4827790756255506 Maple Ave, Tucson, AZ, 857420.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-400690CLMCharlotte E Bryant1993-09-22UHC-51096-9785882005124266 Union St # 802, Denver, CO, 802300.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-406039CLMLarry Barnes1958-04-09UHC-76599-0543124022302481 Mesa Dr, San Antonio, TX, 782070.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417540CLMRussell Moreno2005-07-27UHC-08496-11—8906 Broadway, Plano, TX, 750230.62Name re-casedDate of birth reformattedSSN last four extractedState code upper-cased+3 more
CLM-414492CLMJeremy Payne1938-08-06UHC-63081-9071181029595765 Indian School Rd, San Antonio, TX, 782680.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430111CLMFrank Yang1954-06-13—61474526964140 Jefferson Ave # 261, Nashville, TN, 372720.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-427986CLMGeorge Myers1939-07-26——1613 Mountain View Dr, Miami, FL, 331800.62Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-428634CLMChristopher Young1993-07-09UHC-27607-7935240158511866 Church St, Chandler, AZ, 852690.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429774CLMKathryn I Wallace1991-04-10——8278 Canyon Rd Apt 19, Jacksonville, FL, 322710.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-428528CLMBilly Dunn1959-03-16UHC-74132-1171070058178863 Bayshore Dr, Fresno, CA, 937460.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400217CLMHarold F Pena1997-05-15——1236 Union St, Charlotte, NC, 282390.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410717CLMVirginia Freeman1960-09-05UHC-43411-25—9052 Cedar Ln, Nashville, TN, 372750.62Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412161CLMDeborah N Harper1973-09-28——4799 River Rd, Charlotte, NC, 282910.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403748CLMHenry F Little1944-12-26——266 Camelback Rd Apt 29, Atlanta, GA, 303610.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-422961CLMJulye Dixon1947-05-03UHC-54209-3287180508398661 Bayshore Dr Apt 27, Gilbert, AZ, 852490.62Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
CLM-413570CLMLinda Wang1979-05-24—4636538677528 Sage Ct, Seattle, WA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418825CLMCarlos Young1958-03-14—75647109438579 Spring St, Tampa, FL, 336780.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423085CLMAna R Knight1992-08-10——4791 Harbor Blvd, Glendale, AZ, 853270.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-409352CLMJanet Z Cole1950-04-16UHC-14286-7421734715389793 Desert Sky Blvd, Scottsdale, AZ, 852820.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421198CLMMadison Guzman2008-05-25UHC-78690-13—9638 Park Pl, Glendale, AZ0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403457CLMChristina Ortega—UHC-82591-3365670002723808 Central Ave, Los Angeles, CA, 900290.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-423337CLMCatherine C Hart1973-11-23—50573428131502 Oak St, Gilbert, AZ, 852080.62Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-403284CLMJudith Gilbert1955-10-23——7478 Market St, Austin, TX, 787150.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-401275CLMMark R McDonald1989-02-06—85483003201238 Park Pl, Seattle, WA, 981920.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432642CLMSusan Carlson2003-04-25—57849327509449 Pine Dr, Columbus, OH, 432410.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417022CLMPeter Arnold1994-08-02—83139243971574 Oak St, Mesa, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426777CLMRoy Ellis—UHC-97344-0421356066662423 Central Ave, Mesa, AZ, 852340.62Name re-casedDate of birth missingPhone reformattedMember ID reformatted+3 more
CLM-408857CLMAngela R Guzman1958-01-27——1129 Main St # 599, Gilbert, AZ, 852250.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-412467CLMAlexis Watkins1946-10-08—62346315353596 Elm St Apt 29, Orlando, FL, 328610.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-426914CLMSusan Morrison1959-02-28UHC-92801-4787423346132746 Apache Blvd, Denver, CO, 802520.62Two-digit birth yearPhone reformattedMember ID reformattedState name converted to code+3 more
CLM-403246CLMKenneth Martinez1966-11-26—41364547506621 Sage Ct, Fresno, CA, 937350.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432036CLMRandy Scott1973-03-08UHC-99947-2043261789202010 Sunset Blvd, Tampa, FL, 336250.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415362CLMRuth West1976-01-09UHC-47531-91—8654 Lake View Rd, Glendale, AZ, 853420.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-425230CLMBraldey R Cole1966-12-02—34760957128014 Central Ave, San Diego, CA, 921590.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-413001CLMJean Graham1961-08-15UHC-91965-70—1653 Ridge Rd Apt 1, Tampa, FL, 336580.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-405622CLMTimothy Garza—UHC-77050-03—2981 Union St, Columbus, OH, 432740.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 86 of 657PreviousNext