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-414370CLMDiane Weaver1964-05-12UHC-06730-84—2791 Maple Ave Apt 21, Atlanta, GA, 303190.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407065CLMBrenda Wells1997-08-04——3625 Willow Ct # 221, Scottsdale, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-407191CLMKevin Peters———2466 Broadway, Columbus, OH, 432970.54Name split from “Last, First”Date of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-413524CLMJoan Jimenze1986-03-18UHC-70453-27—6493 Washington St, Minneapolis, MN, 554150.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-423835CLMAlan Schmidt1992-10-27——5248 Canyon Rd, Minneapolis, MN, 554410.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-409696CLMCarlos Chavez1943-08-28—25068688342256 Sunset Blvd, Orlando, FL, 328510.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-414720CLMLiz S Gutierrez—UHC-77937-50—7839 Willow Ct, San Antonio, TX, 782140.54Date of birth missingStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-425961CLMMartha Ellis1988-04-26UHC-36344-06—6810 Grand Ave, Denver, CO0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-427894CLMAaron Knight1983-07-13——8293 Spring St, Nashville, TN, 372190.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-429562CLMStephanie Yang2002-09-03——6020 Ocean Ave, Charlotte, NC, 282500.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-414692CLMDanielle Frranklin1970-02-18UHC-03800-71—7777 Market St, Jacksonville, FL, 322250.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-414693CLMDanielle Frranklin1970-02-18UHC-03800-71—7777 Market St, Jacksonville, FL, 322250.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-419989CLMJulia Mason1972-01-02——2791 Elm St, Plano, TX, 750380.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-431392CLMJerry Roberts2005-11-21———0.54Name split from “Last, First”Two-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-403240CLMKayla Ferguson2005-06-19UHC-37431-5165349575063533 Grand Ave, Las Vegas, NV, 891180.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-429753CLMJoseph Brooks1949-02-20UHC-78973-47—4944 Lake View Rd, Tampa, FL, 336580.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-403602CLMMary Edwards1949-09-06——7363 Forest Ave, Miami, FL0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-407090CLMSofia Crawford1998-03-01UHC-53642-74—8260 Church St, Nashville, TN, 372790.54Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-407213CLMKimberly Munoz2007-12-22——5212 Spring St, Jacksonville, FL, 322370.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-415181CLMBradley Oliver—UHC-67161-27—5188 Union St, Tampa, FL, 336560.54Name split from “Last, First”Date of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-415330CLMBruce Bryant2000-04-09UHC-31867-72—9841 Meadow Ln, Chandler, AZ, 852360.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-431048CLMRobert Flores1950-01-28UHC-72032-58—796 Mesa Dr, Glendale, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-428683CLMDrew Montgomery—UHC-32115-7074724011353903 Mesa Dr Apt 27, San Antonio, TX, 782840.54Name split from “Last, First”Date of birth unreadableUnit split from streetCity re-cased+1 more
CLM-425884CLMRaymond Jenkins2004-03-16——669 Washington St, Plano, TX, 750970.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-422655CLMOlivia McCoy1969-04-26UHC-44552-76—7460 Highland Ave, Minneapolis, MN, 554450.54Name split from “Last, First”Two-digit birth yearState code upper-casedGender normalised+1 more
CLM-417179CLMDonald Harper1975-11-02UHC-72323-54—499 Lincoln Way, Fresno, CA0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-431758CLMCharlotte Jacobs1947-07-01UHC-75072-89—2840 Cedar Ln, Scottsdale, AZ0.54Name split from “Last, First”Date of birth reformattedState name converted to codeZIP missing+1 more
CLM-426292CLMHelen Munoz1951-03-02UHC-11640-38—6368 Washington St, Gilbert, AZ0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-407838CLMRebecca Duncan1976-10-21UHC-15711-81—2569 Broadway, Denver, CO, 802590.54Name split from “Last, First”SSN last four extractedGender normalisedWhitespace trimmed+1 more
CLM-431604CLMWayne Rodriguez———257 Market St, Plano, TX, 750400.54Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413936CLMSharon Scott1977-06-19——463 Pine Dr, San Diego, CA, 921020.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-432141CLMKatherine Harrison1970-04-13——2321 Apache Blvd, Nashville, TN, 372120.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-419936CLMDoris Q Jordan1991-06-26UHC-58784-9162485972587210 Canyon Rd, Charlotte, NC, 282750.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-406995CLMCharles Bryant1995-10-01UHC-30385-79—8292 Hillcrest Rd Apt 38, Las Vegas, NV, 891060.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-402496CLMEvelyn Fisher2005-10-08UHC-52353-84—489 Highland Ave, Sacramento, CA, 958260.54Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-403095CLMAnn Adams1964-03-09UHC-49487-89—4774 Broadway, Scottsdale, AZ, 852440.54Name split from “Last, First”Member ID reformattedAddress re-casedZIP+4 trimmed+1 more
CLM-432615CLMDorothy Fernandez1958-06-18UHC-11988-64—4640 Pine Dr, San Diego, CA, 921810.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-430897CLMMartha Tran1979-12-14UHC-27532-54—9876 Broadway, Seattle, WA, 981470.54State name converted to codeZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-417333CLMNoah Park1955-07-17UHC-70378-4727272621177869 Elm St, San Antonio, TX0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-404097CLMAlex Berry1967-05-21——806 Apache Blvd, Los Angeles, CA, 900480.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-420608CLMElizabeth Kennedy1946-03-05UHC-31956-48—2428 Valley View Dr, Jacksonville, FL, 322870.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-411964CLMFrances Porter1962-08-20UHC-44995-70—9881 Lincoln Way, Las Vegas, NV0.54Date of birth reformattedState name converted to codeZIP missingGender normalised+1 more
CLM-426932CLMBrittany Moore2007-05-24——2956 Sunset Blvd, Tampa, FL, 336510.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-412308CLMAngela T Richardson1947-10-24UHC-54092-76—7082 Oak St, Houston, TX, 770460.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-415342CLMSoia Wislon2004-06-18UHC-06608-41—3482 River Rd, San Diego, CA, 921380.54Two-digit birth yearPhone missing area codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-430601CLMRandy Coko1977-02-14——185 Highland Ave, Chandler, AZ, 852010.54Name split from “Last, First”State name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-404712CLMMery Austin1955-10-10——9469 Cedar Ln, Miami, FL0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-412545CLMShirley C Ryan1986-10-27——4300 Grand Ave, Tempe, AZ, 852430.54Name split from “Last, First”Middle initial moved out of first nameCity re-casedZIP+4 trimmed+1 more
CLM-402720CLMStephen Harvey2002-05-23——3008 Mountain View Dr # 740, Fresno, CA, 937940.54Unit split from streetState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-401889CLMValentina Obrien1965-06-13UHC-50153-59—5035 Oak St, Los Angeles, CA, 900860.54Name re-casedState name converted to codeZIP+4 trimmedGender normalised+1 more
32,829 rows, page 59 of 657PreviousNext