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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-431280CLMHannah Ramos1952-09-18——8140 Broadway, Tempe, AZ, 852580.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-423223CLMJerry Hoffman1942-07-21UHC-04371-18—9164 Market St, Mesa, AZ, 852540.70Street suffix standardisedAddress re-casedState name converted to code
CLM-414223CLMMichelle W Rivera1989-06-02UHC-89576-6432257378266134 Hillcrest Rd, Tampa, FL, 336670.70Two-digit birth yearState name converted to codeWhitespace trimmed
CLM-421857CLMKayla Bennett1940-09-15UHC-47842-61——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-431598CLMBeverly Q Schultz1981-07-09UHC-83728-87—627 Highland Ave, Dallas, TX, 752610.70Name re-casedTwo-digit birth yearZIP+4 trimmed
CLM-415810CLMSteven Boyd1944-08-08—98656622113000 Mesa Dr, San Diego, CA, 921000.70Name split from “Last, First”ZIP+4 trimmedPlaceholder values cleared
CLM-403801CLMFrances Jacobs1986-09-08——9439 Baseline Rd Apt 31, Atlanta, GA, 303730.70Unit split from streetStreet suffix standardisedAddress re-cased
CLM-412679CLMMark X Delgado1948-10-08UHC-23763-86—2337 Mesa Dr, Tempe, AZ, 852090.70Middle initial moved out of first nameTwo-digit birth yearPlaceholder values cleared
CLM-409676CLMMargaret Hernandez2008-07-14——7702 Main St, Miami, FL, 331280.70SSN last four extractedGender normalisedPlaceholder values cleared
CLM-428932CLMTheresa W West1990-09-16——1312 Main St # 327, Columbus, OH, 432930.70Unit split from streetStreet suffix standardisedAddress re-cased
CLM-412563CLMRyan Martin2008-09-08——678 Palm Dr, Miami, FL, 331870.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-408301CLMMichelle Jensen———311 Park Pl, Nashville, TN, 372170.70Date of birth unreadableGender normalisedPlaceholder values cleared
CLM-406599CLMEmma X Meyer—UHC-13185-09—5206 Sunset Blvd, Columbus, OH, 432250.70Date of birth missingGender normalisedPlaceholder values cleared
CLM-414472CLMSimmons David1959-08-06UHC-48775-8061521176381491 Lake View Rd, Fresno, CA, 937130.70Two-digit birth yearPhone reformattedState name converted to code
CLM-418714CLMAustin S Smmith2007-09-13UHC-95971-84—8639 Lincoln Way, Jacksonville, FL, 322720.70Name split from “Last, First”ZIP+4 trimmedPlaceholder values cleared
CLM-407762CLMPriya I Price1954-04-23——846 Spring St # 307, Gilbert, AZ, 852400.70Unit split from streetState name converted to codePlaceholder values cleared
CLM-400474CLMJonh Q Contreras1974-04-23——5777 Bayshore Dr, Denver, CO, 802790.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-403780CLMDylan D Arnold1964-03-17UHC-34868-16—7544 Pine Dr, Jacksonville, FL, 322250.70Date of birth reformattedSSN last four extractedGender normalised
CLM-432664CLMZachray Allen1997-01-10UHC-52129-98—2122 Union St # 444, Plano, TX, 750210.70Unit split from streetState name converted to codePlaceholder values cleared
CLM-408129CLMChristian Romero1957-02-08———0.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-403952CLMBobby Cooper1998-12-01———0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-409702CLMShirley P Aguilar2000-10-16———0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-411750CLMJessica Jones1976-11-17——371 Meadow Ln, Glendale, AZ, 853460.70Name split from “Last, First”ZIP+4 trimmedPlaceholder values cleared
CLM-403689CLMValentina Gonzalez1995-09-13UHC-08034-63——0.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-429501CLMAbigail Tunrer—UHC-81001-64—1536 Lake View Rd, Nashville, TN, 372720.70Date of birth unreadableState name converted to codePlaceholder values cleared
CLM-421521CLMMaria Garcia1981-09-10UHC-26872-43—3787 Mountain View Dr, Houston, TX, 770480.70Name split from “Last, First”State name converted to codePlaceholder values cleared
CLM-403082CLMJose M Howell1979-11-01UHC-12973-72——0.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-416849CLMDebra Elliott—UHC-39687-17—2215 Valley View Dr, Orlando, FL, 328580.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
CLM-400989CLMAmber Greene1942-05-19UHC-79174-43—7738 Market St, Denver, CO0.70Name split from “Last, First”ZIP missingPlaceholder values cleared
CLM-412122CLMShirley Gibson—UHC-25275-60——0.70Name split from “Last, First”Date of birth missingPlaceholder values cleared
CLM-431652CLMValentina Simmons1940-12-10UHC-46999-92—5097 Desert Sky Blvd, Tucson, AZ, 857500.70Name split from “Last, First”Phone missing area codeWhitespace trimmed
CLM-416028CLMBrenda Nguyen—UHC-96686-3973996649395028 Harbor Blvd, San Diego, CA0.70Date of birth missingZIP missingPlaceholder values cleared
CLM-432469CLMAaron D Salazar1990-08-04———0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
CLM-425744CLMMartha Willis1998-08-07—50668523096574 Main St, Plano, TX, 750200.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-415968CLMPatrick J Gardner2000-08-12UHC-61113-46——0.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-411657CLMPamela Jones1949-04-26———0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-400078CLMNancy Vega1974-03-24UHC-26451-41——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-428797CLMRussell Weaver1962-04-14UHC-60979-3184259052813160 Pine Dr # 798, Phoenix, AZ, 850160.70Name split from “Last, First”Phone reformattedUnit split from street
CLM-431954CLMMaria Davis1980-04-07UHC-91962-84—7357 Apache Blvd, Mesa, AZ, 852750.70Name split from “Last, First”ZIP+4 trimmedPlaceholder values cleared
CLM-408837CLMLawrence Gutierrez1943-12-13UHC-49649-11—3482 Jefferson Ave, Columbus, OH0.70Name split from “Last, First”ZIP missingPlaceholder values cleared
CLM-407623CLMWilliam O McDonald1987-08-17———0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-407622CLMWilliam O McDonald1987-08-17———0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-401558CLMRoger R George—UHC-68033-85—6203 Maple Ave, Minneapolis, MN, 554270.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
CLM-418462CLMJustin X Schultz1985-08-09UHC-07089-67—1094 Union St, San Diego, CA, 921050.70State name converted to codeGender normalisedPlaceholder values cleared
CLM-430438CLMDouglas Padilla1957-05-24UHC-59766-26—5856 Willow Ct, Gilbert, AZ, 852740.70Street suffix standardisedAddress re-casedGender normalised
CLM-411036CLMArjun C Schmidt1992-12-03UHC-24941-46—1003 Indian School Rd, Mesa, AZ, 852210.70Street suffix standardisedAddress re-casedZIP+4 trimmed
CLM-415257CLMJanet Y Reynolds1948-12-05——2594 Cedar Ln # 778, Nashville, TN, 372250.70Name split from “Last, First”Date of birth reformattedUnit split from street
CLM-407610CLMChristina Perez1944-11-01UHC-42737-449453053626—0.70Name split from “Last, First”SSN last four extractedPlaceholder values cleared
CLM-401939CLMEmma Munoz1994-09-16UHC-82412-81—2062 Jefferson Ave, Dallas, TX, 752130.70Name split from “Last, First”Phone missing area codePlaceholder values cleared
CLM-410186CLMRonald Cox1980-08-09UHC-19931-06—6564 Camelback Rd, Charlotte, NC, 282700.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
32,829 rows, page 221 of 657PreviousNext