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-415148CLMAaron Evans1944-06-16UHC-51560-7569353654222320 Central Ave, Austin, TX, 787530.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432428CLMRebecca Howard1998-06-19UHC-89882-7179557298687322 Camelback Rd, Austin, TX, 787510.64Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more
CLM-405649CLMJohnny Trores1995-01-21—61545621586220 Ocean Ave, Minneapolis, MN, 554460.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-407861CLMMarilyn Hunt2000-04-25—43340499239005 Ridge Rd, Glendale, AZ, 853910.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430323CLM—Junk1956-01-06——2593 Spring St, Charlotte, NC, 282320.64Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-406690CLMRaymnd Rodriguez—UHC-81501-187043124628—0.64Name split from “Last, First”Date of birth unreadablePhone reformattedEmail lower-cased+2 more
CLM-418145CLMMari F Webb1943-09-01—75736937098356 Maple Ave, Miami, FL, 331200.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-400699CLMMarc X Collins1946-03-20UHC-00187-2837725247343486 Harbor Blvd, Fresno, CA, 937860.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-417726CLMLogan Yang1967-09-12—8243758064622 Main St, Chandler, AZ, 852200.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416294CLMJerry J Watkins—UHC-20153-7294077037482207 Washington St, Los Angeles, CA, 900980.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-429868CLMShirley Banks1947-01-01UHC-47686-958706502113125 Lake View Rd Apt 40, Charlotte, NC, 282550.64Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
CLM-404803CLMKyle Romero1943-05-03——7259 Lincoln Way, Minneapolis, MN, 554840.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411286CLMDeborah Cooper1980-01-04UHC-66987-746489207149742 River Rd, Tempe, AZ, 852560.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-429398CLMTheresa Carter1968-12-13UHC-04988-6481864834644683 Palm Dr, Chandler, AZ, 852620.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410047CLMPamela Z Santiago1982-04-10UHC-70706-81—8298 Ridge Rd, Charlotte, NC, 282220.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429551CLMAnna Harvey1968-10-09—77757454583429 Forest Ave, Chandler, AZ, 852740.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428635CLMChristopher Young1993-07-09UHC-27607-7935240158511866 Church St, Chandler, AZ, 852690.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407704CLMNatalie Singh1946-01-04UHC-94046-1896731854021116 Market St Apt 23, Chandler, AZ, 852600.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419274CLMKelly Espinoza1989-05-10—85860214249183 Central Ave, Jacksonville, FL, 322860.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-419275CLMKelly Espinoza1989-05-10—85860214249183 Central Ave, Jacksonville, FL, 322860.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428335CLMJoyce Z Wong1947-06-23UHC-83210-2295020798853082 Meadow Ln, San Diego, CA, 921640.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431601CLMBeverly Schultz1981-07-09——627 Highland Ave, Dallas, TX, 752610.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-406324CLMSara Carter1945-03-08UHC-19581-6545756589824145 Lake View Rd, Phoenix, AZ, 850970.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-412820CLMHiroshi Harvey1985-11-11—50022129542083 Park Pl, Jacksonville, FL0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-420669CLMRoy Butler1986-02-23——2332 Lake View Rd, Nashville, TN0.64Street suffix standardisedAddress re-casedZIP missingPlan code upper-cased+2 more
CLM-408232CLMOlivia Stephens———2367 Desert Sky Blvd, San Diego, CA, 921360.64Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-400949CLMHeather I Lopez1941-12-08UHC-55811-2954063161832352 Ridge Rd, Seattle, WA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-414838CLMLawrence T Owens———2445 Grand Ave, Scottsdale, AZ, 852050.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-425899CLMEric Robertson2008-07-10——3096 Union St, Fresno, CA, 937660.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-402063CLMKimberly Vazquez1971-03-08UHC-88315-802569427753866 Maple Ave, Nashville, TN0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-427303CLMTyler P Cole1999-01-20——2050 Indian School Rd, Minneapolis, MN, 554860.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406892CLMLaura G Aguilar1943-08-17UHC-46548-4428026556913684 Baseline Rd, Denver, CO, 802830.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-409820CLMSofia Ward1961-04-16UHC-55808-79—6963 Desert Sky Blvd, Tucson, AZ, 857860.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424046CLMHenry Ross1987-12-05——2139 Spring St, Tucson, AZ, 857880.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-409393CLMMason Gracia1938-08-04UHC-80156-07—7806 Spring St, Austin, TX, 787020.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-422756CLMArjun V Anderson1985-07-05UHC-56313-5960093152749629 Mesa Dr, Plano, TX, 750450.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421398CLMNathan Martin1993-02-17UHC-79747-5136322108833231 Central Ave, Las Vegas, NV, 891200.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419150CLMEugene Bell1961-02-08—32553857318207 Highland Ave, Las Vegas, NV, 891970.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414638CLMHiroshi Gonzalez1939-03-20UHC-77778-9377626340256699 Willow Ct, Scottsdale, AZ0.64Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
CLM-405338CLMFrances Jensen———6699 Market St, San Diego, CA, 921010.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-430693CLMLucia Goemz—UHC-42126-1652836013145088 Union St, Gilbert, AZ, 852550.64Date of birth unreadableMember ID reformattedCity re-casedZIP+4 trimmed+2 more
CLM-429616CLMKevin Patel—UHC-81454-64—6854 Park Pl, Seattle, WA, 981400.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-414534CLMPatricya Wang1950-08-14UHC-99901-23—8628 Maple Ave, Plano, TX0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-414076CLMChristina Larson1995-09-26UHC-33882-58—7029 Market St, Las Vegas, NV, 891900.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-412774CLMWalter Ward1961-05-09—68922053678712 Main St # 960, Sacramento, CA, 958960.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-422301CLMKimberly Armstrong1969-10-12——5404 Maple Ave # 112, Sacramento, CA, 958970.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-429857CLMNoah Campbell1961-12-01UHC-25272-6830338636217910 Harbor Blvd, Orlando, FL, 328800.64Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-416725CLMJoyce Cole——45837209552045 Oak St, Fresno, CA, 937280.64Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
CLM-417917CLMDonald G Fernandez1956-09-28UHC-09849-8389462831241413 Meadow Ln Apt 36, Tucson, AZ, 857930.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-417918CLMDonald G Fernandez1956-09-28UHC-09849-8389462831241413 Meadow Ln Apt 36, Tucson, AZ, 857930.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 152 of 657PreviousNext