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-429370CLMLogan P Sanders1962-11-27UHC-91805-80—5114 Forest Ave, Fresno, CA, 937690.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-404826CLMMarcus Hart1983-11-13—43735264423873 Lincoln Way, Gilbert, AZ, 852790.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-431299CLMDanielle P Boyd1988-04-25UHC-99875-3667283599626982 Mountain View Dr, Miami, FL, 331160.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-405636CLMBrandon Snyder1968-12-04——8063 Pine Dr Apt 28, Nashville, TN, 372480.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419654CLMLisa Vargas1939-02-28——3295 Meadow Ln, Atlanta, GA, 303670.66Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+1 more
CLM-432391CLMCharlotte C Simpson1998-06-25UHC-77087-3990850824945938 Jefferson Ave, Sacramento, CA, 958340.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-432390CLMCharlotte C Simpson1998-06-25UHC-77087-3990850824945938 Jefferson Ave, Sacramento, CA, 958340.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-409710CLMDenise F Lopez1984-03-27UHC-94618-30—5822 Hillcrest Rd, Minneapolis, MN0.66Name re-casedTwo-digit birth yearZIP missingWhitespace trimmed+1 more
CLM-422456CLMLarry Cole1986-09-09UHC-55286-4076056638047823 Bayshore Dr, Seattle, WA, 981670.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-429763CLMNicole C Le1987-04-18——9757 Church St, Mesa, AZ, 852770.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-410989CLMGerald Robertson1950-10-09—7873326872—0.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-404408CLMMatt White1973-02-19—47846442068059 Valley View Dr, Gilbert, AZ, 852240.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425070CLMJoan Fowler1983-10-14—71261095267025 Sage Ct, Fresno, CA, 937220.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-419581CLMTran Vincent—UHC-61998-96—3950 Harbor Blvd, San Diego, CA, 921720.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-429407CLMEdward F Edwards1964-11-24——1315 Apache Blvd Apt 7, Charlotte, NC, 282410.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-422539CLMMaria Lopez1945-04-08UHC-24953-2658844670833303 Forest Ave, Jacksonville, FL, 322430.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-402948CLMChris Weaver1986-04-05UHC-97085-20—9496 Lincoln Way, Chandler, AZ, 852690.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407194CLMEmma Crawford1984-03-02——5153 Sage Ct, San Diego, CA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-419300CLMIsabella Walsh1979-06-04UHC-12076-1621320244178165 Camelback Rd, Orlando, FL, 328270.66Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-401009CLMAndrea Meyer1993-04-13——1916 Mountain View Dr, Los Angeles, CA, 900070.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-409801CLMDebra Lee—UHC-96470-5776934783462601 Hillcrest Rd, Jacksonville, FL, 322310.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-413148CLMLucia Owens2008-07-17UHC-32020-14—4476 Pine Dr, Charlotte, NC, 282680.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-406299CLMSarah Scott1944-05-16UHC-34036-57—9320 Maple Ave, Orlando, FL, 328130.66Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411757CLMDaniel Wood1976-08-20UHC-16055-58—2271 Desert Sky Blvd, Plano, TX, 750500.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-415918CLMKaren Montgomery1949-10-28——6291 Oak St, Las Vegas, NV, 891850.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-415917CLMKaren Montgomery1949-10-28——6291 Oak St, Las Vegas, NV, 891850.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-431901CLMMargaret F Fernandez1938-09-28——1878 Ocean Ave, Atlanta, GA0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-431900CLMMargaret F Fernandez1938-09-28——1878 Ocean Ave, Atlanta, GA0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-408276CLMDebra Fuller1993-07-20—56898332224128 Mountain View Dr, Chandler, AZ, 852230.66Name split from “Last, First”Phone reformattedCity re-casedGender normalised+1 more
CLM-402623CLMLuis Vega1938-07-28——2560 Ocean Ave # 314, Minneapolis, MN, 554580.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-430249CLMBettyJunk1959-02-22——6648 Mountain View Dr, Tucson, AZ, 857100.66Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared+1 more
CLM-411473CLMAmanda F Morris1994-05-17UHC-04270-36——0.66Date of birth reformattedPhone missing area codeGender normalisedWhitespace trimmed+1 more
CLM-411472CLMAmanda F Morris1994-05-17UHC-04270-36——0.66Date of birth reformattedPhone missing area codeGender normalisedWhitespace trimmed+1 more
CLM-422546CLMPamela Tran1947-06-05UHC-02051-22—4889 Spring St Apt 37, Sacramento, CA, 958280.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-411746CLMAshley Perry1987-02-07UHC-75552-09—3205 Ridge Rd, Atlanta, GA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-403180CLMAustin Hughes2000-06-04UHC-81540-494454953335138 Meadow Ln, Eden Prairie, MN, 553080.66Date of birth reformattedPhone reformattedMember ID reformattedState name converted to code+1 more
CLM-422692CLMRichard Santiago1986-05-09UHC-26774-1866074515709782 Bayshore Dr, Austin, TX, 787220.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-408763CLMAlvarez Gerald1956-10-14UHC-63558-9860567333433604 Mountain View Dr Apt 27, Miami, FL, 331320.66Name re-casedDate of birth reformattedUnit split from streetGender normalised+1 more
CLM-400788CLMAlice Knight1958-06-21UHC-58125-21—6465 Pine Dr Apt 11, Orlando, FL, 328590.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421474CLMLauren Contreras1939-12-12—81766002181656 Sage Ct, Eden Prairie, MN, 553630.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-421025CLMJanice B Wheeler1997-09-12UHC-26426-40—3263 Central Ave Apt 34, Glendale, AZ, 853630.66Date of birth reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
CLM-401311CLMAlvarado Grace1945-12-20UHC-86365-86—806 Desert Sky Blvd, Atlanta, GA, 303300.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407365CLMBrian Jenkins2006-11-01UHC-85971-66—7721 Palm Dr, San Diego, CA, 921650.66Name re-casedDate of birth reformattedZIP+4 trimmedGender normalised+1 more
CLM-421582CLMTyler Maldonado1948-07-12UHC-19189-7641680786757191 Mesa Dr, Minneapolis, MN, 554800.66Phone reformattedCity re-casedZIP+4 trimmedGender normalised+1 more
CLM-406857CLMThomas Z Sandoval1954-06-23—31998167361297 Apache Blvd, Charlotte, NC, 282880.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-424476CLMDiana Turner1970-11-06—79396902173212 Lake View Rd, Gilbert, AZ, 852350.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-419775CLMNoah Washington1978-09-03UHC-11037-22——0.66Name split from “Last, First”Two-digit birth yearPlan code upper-casedWhitespace trimmed+1 more
CLM-420966CLMJanice Turnr1990-07-22UHC-64309-0286894133145832 Ridge Rd, Tampa, FL, 336420.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-403439CLMSofia Jimenez2000-07-28UHC-48462-3221176557691804 Canyon Rd, Orlando, FL, 328550.66Phone reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-431225CLMChristian Lynch1982-04-12UHC-89218-0947356220602724 Central Ave # 869, San Antonio, TX, 782480.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
32,829 rows, page 169 of 657PreviousNext