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-407112CLMEmma Tucker1955-10-18UHC-67045-1335961167664116 Market St, Mesa, AZ, 852450.66Date of birth reformattedPhone reformattedState name converted to codeGender normalised+1 more
CLM-410058CLMCheryl Carroll1967-02-19UHC-80042-9860047804116440 Union St, San Antonio, TX, 782130.66Phone reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-416143CLMEvelyn Elliott1949-01-12——5279 Pine Dr # 498, Houston, TX, 770460.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-414416CLMRoger Graham1985-04-21UHC-31502-30—8975 Sage Ct, Phoenix, AZ, 850460.66City re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-423152CLMJeremy Wong1939-09-08——4708 Grand Ave, Seattle, WA, 981410.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-405745CLMMargaret Bryant1965-09-06UHC-79598-73—1180 Union St, Houston, TX, 770990.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-405562CLMGrace Kngiht1976-05-11——7100 Camelback Rd, San Diego, CA, 921960.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-405484CLMLinda Stevens1949-05-21UHC-29670-5769330221295554 Forest Ave # 815, Dallas, TX, 752200.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-408679CLMJanice K Burton1956-04-03UHC-20074-8722651091375988 Baseline Rd, Seattle, WA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-431281CLMHananh Ramos1952-09-18UHC-51097-4657171595968140 Broadway, Tempe, AZ0.66Name split from “Last, First”Phone reformattedZIP missingWhitespace trimmed+1 more
CLM-423996CLMKaren N Harrison1987-01-26UHC-86250-15——0.66Middle initial moved out of first nameName re-casedGender normalisedWhitespace trimmed+1 more
CLM-403469CLMAnthony Bryant1952-09-21——5921 Valley View Dr # 783, Charlotte, NC, 282860.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-420520CLMJudith Ford1949-12-12UHC-34094-33—4967 Cedar Ln, Chandler, AZ, 852630.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-432572CLMDorothy Gomez1965-10-25UHC-28888-4384044480854929 Elm St, Los Angeles, CA, 900300.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-408060CLMSam Wheeler1959-09-23UHC-12175-52—9508 Ridge Rd, Fresno, CA, 937580.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-410979CLMLauren Perez1948-06-06UHC-37524-5391543356647080 Main St Apt 29, Fresno, CA, 937000.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-418895CLMSophia Turner1947-01-18UHC-88478-15—4569 Harbor Blvd, Columbus, OH, 432660.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-408033CLMDeboah Freeman1943-02-20—85240980331889 Market St, Orlando, FL, 328320.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-408032CLMDeboah Freeman1943-02-20—85240980331889 Market St, Orlando, FL, 328320.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425026CLMGeogre Austin1938-09-20UHC-22482-0449039786753710 Bayshore Dr, Phoenix, AZ, 850730.66Two-digit birth yearPhone reformattedCity re-casedZIP+4 trimmed+1 more
CLM-427678CLMAnn Salazar1960-10-10——288 Hillcrest Rd, Plano, TX, 750890.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-406200CLMKathryn Sanchez1955-09-08UHC-35361-1421949296415727 Indian School Rd, Nashville, TN, 372340.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-422194CLMLuis Freeman1990-03-27UHC-20455-14—3146 Canyon Rd, Gilbert, AZ, 852740.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-426144CLMRichard Espinoza1957-05-16UHC-68182-025163396241—0.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-412525CLMJon Parker1952-09-07UHC-53297-2664664982128769 Lincoln Way, Seattle, WA, 981740.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425676CLMBryan Ray1958-11-20UHC-15231-858976852507—0.66Phone reformattedMember ID reformattedSSN last four extractedGender normalised+1 more
CLM-412550CLMDiane Daniels1940-12-16UHC-73681-72—8712 Forest Ave, Las Vegas, NV0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-419743CLMChristina Lewis1955-08-23——8303 Indian School Rd, Chandler, AZ, 852190.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412042CLMJonathan Z McDonald1987-07-24—32043879322481 Palm Dr, Charlotte, NC, 282690.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411629CLMHelen West1958-11-03——6857 Union St, Miami, FL, 331900.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-422471CLMRuth W Jordan—UHC-15673-95—2396 Ridge Rd, Nashville, TN, 372300.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419799CLMDiane Reid1954-02-03UHC-19446-14—2365 Sage Ct, Houston, TX0.66Two-digit birth yearState code upper-casedZIP missingWhitespace trimmed+1 more
CLM-415413CLMMariana Peterson1979-12-19—88979229506743 Park Pl, Scottsdale, AZ, 852560.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419961CLMTeresa Stephens1973-08-20UHC-87322-48—604 Maple Ave, Chandler, AZ, 852020.66Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-406191CLMGabriel Brown1995-05-27——3573 Forest Ave, Tampa, FL, 336810.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-410893CLMMunoz Hiroshi1976-06-14——7710 Elm St, Tampa, FL0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-414421CLMCarl C Mitchell1939-12-08——1902 Mesa Dr, Minneapolis, MN, 554080.66Name re-casedPhone missing area codeCity re-casedGender normalised+1 more
CLM-416590CLMEvelyn G Bakar1953-06-08UHC-01180-54—2621 Union St, Columbus, OH0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-410108CLMCheryl Garza1964-08-05UHC-54815-28—561 Jefferson Ave, San Diego, CA, 921670.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-405598CLMMason P Herrera1943-02-05—5424196196182 Willow Ct, Charlotte, NC, 282990.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
CLM-415947CLMJean Wilson1943-03-02—8927115598—0.66Phone reformattedSSN last four extractedGender normalisedWhitespace trimmed+1 more
CLM-411685CLMCatherine Collins1952-01-23——8370 Sunset Blvd, Minneapolis, MN, 554900.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-413252CLMLisa Mendez1949-07-05UHC-55575-93—105 Cedar Ln # 365, Tucson, AZ, 857020.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-429793CLMJeremy Moore1995-09-27——7041 Willow Ct, Mesa, AZ, 852620.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-426638CLMRoy Dnucan1974-12-12——6138 Grand Ave, Sacramento, CA, 958790.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-412313CLMPriya Warren1987-11-26UHC-51416-3555965042069787 Park Pl, Glendale, AZ, 853310.66Two-digit birth yearPhone reformattedCity re-casedState name converted to code+1 more
CLM-402026CLMDenise Johnston2008-03-09UHC-49425-51—6538 Palm Dr, Gilbert, AZ, 852100.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-411910CLMRoy K Vargas1995-02-27——8851 Maple Ave, Los Angeles, CA, 900660.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-415398CLMDiana Hughes1975-03-01UHC-99954-49—8291 Palm Dr Apt 3, Dallas, TX, 752540.66Two-digit birth yearMember ID reformattedUnit split from streetWhitespace trimmed+1 more
CLM-407855CLMRussell Little1952-07-01UHC-66311-10—9059 Indian School Rd Apt 1, Mesa, AZ, 852100.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
32,829 rows, page 183 of 657PreviousNext