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-407890CLMVincent Palmer1969-09-01UHC-31592-87—6694 Market St, Seattle, WA, 981730.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-420594CLMBarbara Z Fields2004-03-07UHC-16430-39—5933 Oak St, Glendale, AZ, 853250.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426249CLMWayne Hunt1959-02-25UHC-34787-4462063615038367 Willow Ct, Tucson, AZ, 857690.64Phone reformattedSSN last four extractedCity re-casedState name converted to code+2 more
CLM-420190CLMMaria Gonzales—UHC-94421-13—1366 Lincoln Way, Atlanta, GA, 303210.64Date of birth missingStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
CLM-407508CLMAndrea Kennedy1959-07-01UHC-99655-8731035316877806 Market St, Phoenix, AZ, 850200.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405398CLMCatherine B Baker1961-01-05UHC-89089-25—8109 Sunset Blvd, San Diego, CA, 921520.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407441CLMEvelyn Burke1951-03-08——9253 Valley View Dr, Atlanta, GA, 303650.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-421653CLMJim M Maldonado1954-08-19—27598744019382 Mountain View Dr, Mesa, AZ, 852720.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415272CLMKimberly Marquez1942-05-15UHC-94929-40—1432 Valley View Dr, Las Vegas, NV, 891700.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-413704CLMRyyan Harvey1976-06-26UHC-08814-3474766426655411 Harbor Blvd, Mesa, AZ, 852720.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431968CLMRandy Foster2000-01-18—35447238108906 Palm Dr, Denver, CO, 802150.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-408880CLMJuna Powell1975-01-22UHC-99289-8845177122701179 Bayshore Dr, Los Angeles, CA, 900580.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414348CLMKayla Knight—UHC-65232-63—3353 Highland Ave, Mesa, AZ, 852460.64Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424441CLMKenneth Daniels1986-12-06—38725673093524 Central Ave, Orlando, FL, 328370.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431657CLMBilly Fisher1980-06-20—69962691351611 Hillcrest Rd, Seattle, WA, 981550.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428393CLMAaron Gonzalez1962-11-03—25389120289680 Mountain View Dr, Seattle, WA, 981030.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420760CLMLarry Gordon1942-10-07UHC-57084-0631929643363764 Canyon Rd, Atlanta, GA, 303310.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-417113CLMAlan Lane1982-06-10UHC-36065-9983935829593933 Pine Dr, Plano, TX, 750960.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411891CLMRyanJunk1965-12-23UHC-60653-8571763955105944 Lake View Rd, Sacramento, CA, 958860.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416998CLMKenneth Carr1947-01-02UHC-16971-71—5461 Grand Ave, Tucson, AZ, 857100.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-431877CLMPatrick Y Padilla1968-02-15UHC-49823-74—4783 Oak St, Mesa, AZ, 852640.64Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424761CLMShirley Munoz1962-10-06——9750 Sage Ct, Fresno, CA0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-421229CLMSharon Reynolds1980-02-01UHC-55069-695148055266653 Ocean Ave, San Diego, CA, 921670.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402550CLMJordan Porter1970-07-21UHC-35270-91—214 Washington St, Los Angeles, CA0.64Name re-casedMember ID reformattedZIP missingGender normalised+2 more
CLM-405006CLMLinda O Martinez1963-12-01——9442 Lake View Rd, Las Vegas, NV, 891480.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-422761CLMPaul L King1938-01-15—7426528430327 Ridge Rd, Charlotte, NC, 282410.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426372CLMSharon Salazar1961-01-18—39086604161694 Mesa Dr, Atlanta, GA, 303930.64Phone reformattedCity re-casedZIP+4 trimmedGender normalised+2 more
CLM-403670CLMLawrence Estrada1944-10-22——4645 Harbor Blvd, Columbus, OH0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419558CLMRachel Wagner1967-02-28—68843017023551 Palm Dr, Columbus, OH, 432100.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418280CLMBeerly Moreno1956-04-28—2828058561—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+2 more
CLM-423291CLMLuis Nuenz1978-02-27UHC-38456-51—967 Bayshore Dr, Tampa, FL0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-427165CLMNicholas H Le1977-05-15UHC-49251-6785773968604494 Spring St, Orlando, FL0.64Two-digit birth yearPhone reformattedMember ID reformattedState code upper-cased+2 more
CLM-414892CLMFatima S Soto1993-08-20UHC-71122-66—8728 Sage Ct, Columbus, OH, 432300.64SSN last four extractedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
CLM-417995CLMAdam Lewis1977-05-17UHC-06334-32—5302 Indian School Rd, Austin, TX, 787290.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419713CLMSean Morgan2005-10-24UHC-75819-92—2936 Canyon Rd, Las Vegas, NV, 891330.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424108CLMOmar Ferguson1950-11-04UHC-22742-24—7551 Harbor Blvd, Los Angeles, CA, 900220.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-430906CLMEugene Edwards1968-07-25UHC-48436-7085928262764403 Highland Ave, Plano, TX, 750010.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428431CLMDouglas Knight1967-12-22UHC-58513-50—427 Central Ave, Chandler, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-418770CLMSophia W Evans1974-12-27UHC-44844-73—9437 Sunset Blvd Apt 40, Chandler, AZ, 852300.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-411711CLMAnthony Carr1972-04-27UHC-16569-1958146297058920 Sage Ct, Mesa, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-405642CLMAndrew Davis—UHC-87127-1394046594771983 Oak St, Tucson, AZ, 857250.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424004CLMJeremy V Elliott1977-09-03UHC-55568-28—1576 Grand Ave, Tucson, AZ, 857840.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424005CLMJeremy V Elliott1977-09-03UHC-55568-28—1576 Grand Ave, Tucson, AZ, 857840.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-409560CLMAndrew L Bennett1959-07-03UHC-25240-08—7099 Cedar Ln, Las Vegas, NV0.64Member ID reformattedCity re-casedZIP missingGender normalised+2 more
CLM-426678CLMBatty Pena1979-03-21UHC-94994-5967751510789749 Pine Dr, Jacksonville, FL, 322300.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-414856CLMDonald Gonzales2006-10-09—9435833336179 Forest Ave, Jacksonville, FL, 322800.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-421066CLMDon Daniels2001-05-01UHC-99841-01—6814 Valley View Dr, Dallas, TX, 752900.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428974CLMPriya Valdez1962-08-15UHC-79291-64—3451 Willow Ct # 241, Tempe, AZ, 852170.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-416673CLMCatheriine Lee1967-03-15UHC-31793-24—1926 Union St, Chandler, AZ, 852490.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-405800CLMJulia McDonald1999-01-04UHC-38336-7590390039889310 Washington St, Houston, TX, 770280.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 149 of 657PreviousNext