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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-418018CLMJennifer Santos1944-02-16——4465 Hillcrest Rd, Seattle, WA, 981300.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409267CLMHiroshi Miller1979-09-12——8858 Sage Ct, Gilbert, AZ, 852630.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-405725CLMFrank Parker1971-08-04—67179403394004 Hillcrest Rd, Chandler, AZ, 852510.68Name split from “Last, First”Phone reformattedSSN last four extractedPlaceholder values cleared
CLM-402516CLMEthan K Estrada1966-04-28UHC-68529-8929136274245007 Apache Blvd # 725, Chandler, AZ, 852290.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-428400CLMJeremy Greeen1999-09-19——638 Meadow Ln Apt 14, Gilbert, AZ, 852720.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-405840CLMRuth Stephens1956-11-26UHC-49733-39——0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-425763CLMTheresa Olson1996-07-03UHC-42656-48—9830 Broadway, Houston, TX, 770040.68Name split from “Last, First”SSN last four extractedAddress re-casedWhitespace trimmed
CLM-430602CLMRandy Cok1977-02-14——5729 Central Ave, San Diego, CA, 921550.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-402917CLMRoy Tucker1946-01-17UHC-34706-33—7341 Oak St Apt 15, Atlanta, GA, 303000.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-416422CLMRoger Bishop1960-11-05——2419 Park Pl, Atlanta, GA, 303790.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-420845CLMGary Stewart2004-07-21——4203 Apache Blvd, Plano, TX, 750760.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-411025CLMSara Andrews1961-11-02UHC-45537-10——0.68Name split from “Last, First”Date of birth reformattedPhone missing area codePlaceholder values cleared
CLM-418509CLMSteven R Bowman1941-09-01UHC-95679-56—8216 Cedar Ln, Orlando, FL, 328990.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-413416CLMBobby Miller1995-01-10UHC-03506-5337131432403637 Harbor Blvd, Tucson, AZ, 857590.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-430150CLMSamantha Howard1955-11-11UHC-54388-27—7572 Cedar Ln, Gilbert, AZ, 852800.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-410737CLMCarol Banks1999-02-17UHC-53162-5862829000927354 Mesa Dr, Scottsdale, AZ, 852530.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
CLM-419710CLMAbigail Arnnold1943-01-12—7187396828—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-430719CLMEugene Reyes1966-05-18UHC-92197-11——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-413587CLMWhie Melissa2000-05-10UHC-48799-02——0.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
CLM-417183CLMAlbert Schultz1939-12-06UHC-79247-71—8850 Hillcrest Rd, Columbus, OH, 432190.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-402680CLMCharlotte Shaw—UHC-98731-47——0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-429858CLMNoah A Tucker1993-06-02UHC-19864-11—2659 Park Pl, Columbus, OH, 432190.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-425648CLMNataalie P Ryan1965-04-26UHC-61600-45—6981 Pine Dr, Los Angeles, CA, 900590.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-424893CLMCarl Campbell1955-01-05——515 Canyon Rd, Sacramento, CA, 958700.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421911CLMJoshua Harper1971-08-11UHC-85497-41—282 Ocean Ave, Los Angeles, CA, 900230.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-407377CLMJoe Harvey1956-09-20——6432 Hillcrest Rd, Atlanta, GA, 303570.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-413214CLMAlbert Mendez1972-10-21UHC-76989-44——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-426342CLMOmar Weaver2002-02-28UHC-71491-85—4595 Sage Ct, Fresno, CA, 937820.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-415686CLMJordan Willis2001-06-16UHC-82878-8855582480886683 Desert Sky Blvd, Fresno, CA, 937940.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-407686CLMTimothy N Dunn2001-10-15UHC-00270-77—5933 Mountain View Dr, Sacramento, CA, 958550.68Name split from “Last, First”Middle initial moved out of first nameMember ID reformattedPlaceholder values cleared
CLM-430300CLMAndrea Martinez1941-05-17UHC-02997-045389124249—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-410822CLMTeresa Hudson———7336 Mountain View Dr, Nashville, TN, 372590.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-414071CLMMichael Lucas1965-08-11——1524 Highland Ave, Eden Prairie, MN, 553290.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410943CLMValentina C Ray2000-05-10—56168244923346 Sunset Blvd, Fresno, CA, 937500.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-411909CLMRandy Webb1957-12-03———0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-428059CLMEugene S Reyes1996-11-22UHC-32191-16—4332 Apache Blvd, Columbus, OH, 432310.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-420007CLMPatricia Dixon1980-05-05——4078 Elm St, Charlotte, NC, 282100.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-430588CLMJanet Grrant1991-05-18UHC-09003-41—7089 Willow Ct, Los Angeles, CA, 900800.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-406360CLMLucia Lynch1968-04-09UHC-33985-3956048615468941 Forest Ave, Atlanta, GA, 303020.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
CLM-400965CLMMary Wilils1939-06-26UHC-39266-51—1470 Apache Blvd, Austin, TX, 787050.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-410618CLMRonald Sanders1978-08-24UHC-31632-29—7520 Church St, Minneapolis, MN, 554140.68Name split from “Last, First”Two-digit birth yearMember ID reformattedWhitespace trimmed
CLM-407753CLMKayla Wheeler1938-11-09UHC-62250-44—5670 Valley View Dr, Las Vegas, NV, 891690.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
CLM-414942CLMBenjamin Contreras1980-06-23UHC-74433-78—7408 Sage Ct, Gilbert, AZ, 852100.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432727CLMSarah Fuller1958-03-06UHC-44743-03—5274 Maple Ave, Glendale, AZ, 853340.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-422125CLMDonald Patel1989-03-28—7724414294958 Cedar Ln, Denver, CO0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
CLM-400260CLMJonathan Edwards1969-10-03UHC-24676-5493293932042491 Palm Dr Apt 15, Denver, CO, 802610.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
CLM-400642CLMYuki Berry1953-10-02——5752 Lincoln Way, Atlanta, GA, 303540.68Name split from “Last, First”State code upper-casedGender normalisedPlaceholder values cleared
CLM-422240CLMMeidna J Juan1967-05-10UHC-12396-73—1799 Bayshore Dr, Los Angeles, CA, 900750.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-419107CLMGregory Reid1943-07-18UHC-65879-0767688433802914 Maple Ave, Atlanta, GA, 303990.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-408986CLMBetty Walalce1938-07-14UHC-94593-87—4159 Harbor Blvd, Houston, TX, 770410.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
3,226 rows, page 44 of 65PreviousNext