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-410495CLMKathleen Berry1952-08-18UHC-82564-4526248065325038 River Rd, Phoenix, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413450CLMSamantha Obrien1965-02-22UHC-10855-8587084114226785 Oak St, Seattle, WA, 981360.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-402111CLMValdez Mateo1962-09-19UHC-38430-28—9595 Sage Ct, San Diego, CA0.64Name re-casedMember ID reformattedCity re-casedState name converted to code+2 more
CLM-425662CLMBenjamin Turner1986-11-22——8717 Desert Sky Blvd, San Antonio, TX, 782090.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-409530CLMMatthew Hanson1944-12-11UHC-50046-1029276074821870 Spring St, Glendale, AZ, 853250.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-419037CLMBecky Wylliams1980-04-20UHC-32568-63—1967 Union St, Charlotte, NC, 282780.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416752CLMDanielle Garza1978-11-07—96486310912118 Desert Sky Blvd, Charlotte, NC, 282410.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416753CLMDanielle Garza1978-11-07—96486310912118 Desert Sky Blvd, Charlotte, NC, 282410.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429667CLMChristine R Snyder1993-04-25UHC-52575-4538940158765818 River Rd, Gilbert, AZ0.64Name re-casedPhone reformattedZIP missingGender normalised+2 more
CLM-406782CLMBillly Perez1978-10-05—25629630496069 Mesa Dr, Gilbert, AZ, 852020.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-417124CLMWayne Moris1984-06-07UHC-85819-2481664045423686 Main St, Charlotte, NC, 282670.64Name split from “Last, First”Date of birth reformattedCity re-casedGender normalised+2 more
CLM-429045CLMKyle Howell1986-12-25—3252676589274 Highland Ave, Miami, FL0.64Date of birth reformattedPhone reformattedZIP missingGender normalised+2 more
CLM-422258CLMAlbert Sanders1976-05-06——5471 Camelback Rd, Las Vegas, NV0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-421981CLMGrace Stephens1956-03-05UHC-10502-17—1151 Palm Dr, San Antonio, TX, 782660.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404120CLMAngela Mendoza1959-05-04UHC-25015-5384748163534483 Spring St, Charlotte, NC, 282480.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429529CLMMei Robertson1987-02-22UHC-47647-46—8987 Desert Sky Blvd, Jacksonville, FL, 322750.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424484CLMSharon Q Alexander1992-04-27UHC-08955-2945268425014450 Ocean Ave, Dallas, TX, 752130.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417181CLMMelissa Santiago1992-03-10UHC-16590-48—1606 Washington St, Denver, CO, 802590.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414119CLMJoseph Greene1966-11-03UHC-02610-2381040907782364 Palm Dr Apt 10, Tempe, AZ, 852980.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-427531CLMVirginia E Wheeler——94049231723426 Main St, Denver, CO, 802770.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-426697CLMDennis Harris1980-02-23——9387 Valley View Dr, Sacramento, CA, 958680.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422862CLMSam Z Maldonado1981-09-05UHC-98202-142787469307620 Desert Sky Blvd, Dallas, TX, 752810.64Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-431576CLMAna Soto1940-01-25UHC-71245-437794951800234 Spring St, Tempe, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-413803CLMHenry Johnsun1982-05-24—73697635928640 Willow Ct, Tucson, AZ, 857570.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412906CLMRyan Dominguez1939-09-20UHC-98592-4572691628653654 Hillcrest Rd, Tempe, AZ, 852120.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419832CLMDaniel Elliott1944-03-10——8182 Washington St, San Diego, CA, 921720.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416443CLMJanice Z Ramos1999-11-02—47089850837210 Ocean Ave, Atlanta, GA, 303810.64Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416279CLMCarlos C Kennady1976-02-05UHC-61491-3890148963886234 Highland Ave, Phoenix, AZ, 850560.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425926CLMBenjamin Brown1979-03-15UHC-21896-7166089417557984 Park Pl, Tempe, AZ, 852090.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404479CLMAlan Soto1995-10-12UHC-84799-557157709265887 River Rd, Glendale, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-404601CLMRussell Elliott2002-09-26—76351656158498 Camelback Rd, San Diego, CA0.64Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
CLM-414670CLMBrenda Sullivan1992-01-01——1728 Highland Ave, Orlando, FL, 328900.64Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+2 more
CLM-406838CLMMarilyn Peters2008-04-10UHC-57980-9177041493929318 Elm St, Plano, TX, 750460.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416699CLMLuis Delgado1999-05-08—50322233726453 Grand Ave, Las Vegas, NV0.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-425888CLMRandy Edwards1967-04-07—91188900621054 Washington St, Miami, FL, 331280.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-407574CLMJonathan Scott1964-01-16UHC-08162-01—4975 Oak St, Austin, TX, 787260.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-423403CLMCarolyn Martin1986-03-17—42827904625919 Church St, Plano, TX0.64Date of birth reformattedPhone reformattedZIP missingGender normalised+2 more
CLM-402597CLMJerry Carlson1947-08-04—9233213788—0.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-416578CLMDeb Price—UHC-27304-07—6605 Highland Ave, Phoenix, AZ, 850950.64Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-429292CLMPadilla Ann2008-10-04UHC-67047-34—6081 Lake View Rd Apt 17, Minneapolis, MN, 554390.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-412956CLMYuki Jackson1948-06-05—35728916173177 Sunset Blvd, Scottsdale, AZ, 852790.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-421880CLMRuth White—UHC-31890-56—262 Washington St, Los Angeles, CA, 900410.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-423367CLMYuki Wright1986-02-22UHC-59968-8694668355889017 Pine Dr # 800, Jacksonville, FL, 322410.64Name re-casedPhone reformattedUnit split from streetCity re-cased+2 more
CLM-403337CLMLiz Robinson1970-03-06——1232 Pine Dr, Sacramento, CA0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419115CLMZachary Grant1965-07-14UHC-82010-7263862676637471 Jefferson Ave, Houston, TX, 770890.64Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
CLM-424840CLMAlan Dean1956-02-21——5565 Central Ave, Miami, FL, 331380.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401745CLMBradley Rice1983-03-12UHC-06356-65—4855 Bayshore Dr, Atlanta, GA, 303500.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400908CLMRonald Cooper1946-10-28UHC-75874-34—9401 Union St, Las Vegas, NV, 891320.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-424204CLMKayla U Wood1999-01-05UHC-10376-99—834 Highland Ave, Tampa, FL0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-432211CLMCatherine B Contreras2003-10-05UHC-25346-21—8672 Sage Ct, Scottsdale, AZ, 852890.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 142 of 657PreviousNext