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-411538CLMLinda L Burns1949-04-04—4928863686982 Forest Ave Apt 19, Glendale, AZ, 853010.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-429715CLMGloriia Martin1989-09-15——6216 Canyon Rd, Miami, FL, 331550.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-403217CLMPriya West2006-07-03——7070 Oak St, Charlotte, NC, 282520.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-417273CLMDanielle Jordan1973-12-20UHC-72650-33—2275 Hillcrest Rd, Sacramento, CA, 958360.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425704CLMKayla Willis1944-09-11UHC-95285-80—7871 Ridge Rd, Tampa, FL, 336160.66Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+1 more
CLM-432593CLMMateo I Williamson1940-08-16UHC-09947-95—4707 Central Ave, Denver, CO0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-409534CLMVirginia Medina1989-10-20——6473 Bayshore Dr # 655, Austin, TX, 787000.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-418922CLMMary Miller1940-11-17—48662593189265 Sunset Blvd # 750, Minneapolis, MN, 554760.66Phone reformattedUnit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-415405CLMJean Young1940-05-22UHC-88826-0637843748778587 Hillcrest Rd, Las Vegas, NV, 891100.66Name re-casedTwo-digit birth yearSSN last four extractedWhitespace trimmed+1 more
CLM-414727CLMJudy Castro1984-02-12UHC-14119-0925386182408470 Church St Apt 13, Plano, TX, 750030.66Phone reformattedUnit split from streetCity re-casedState name converted to code+1 more
CLM-412337CLMAndrew Crawford1995-08-27UHC-58070-1339790710876472 Apache Blvd, Phoenix, AZ, 850800.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-400925CLMPeter Carter1999-02-24UHC-21483-29—8215 Market St, Fresno, CA, 937550.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-422493CLMChristian Peterson1969-06-14UHC-46520-71—2683 Indian School Rd, Eden Prairie, MN, 553580.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-427991CLMJanice Kennedy1948-03-14—52655235107102 Union St, Denver, CO, 802480.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-430035CLMBillly E Adams2006-06-17UHC-87978-84—1516 Highland Ave, Chandler, AZ, 852870.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-432790CLMNancy Miller1953-09-11UHC-43773-5477950037813880 Desert Sky Blvd, Dallas, TX, 752720.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-427549CLMDorothy George1955-03-04UHC-73922-65—2036 Camelback Rd, Denver, CO, 802190.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404328CLMAna R Banks1968-10-12—55475361595264 Elm St # 832, Minneapolis, MN, 554740.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-404530CLMHeathr Griffin1987-08-11UHC-60659-31—8521 Palm Dr, Jacksonville, FL, 322780.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-412979CLMRuth Vazquez2006-09-08—24396177943458 Oak St, San Antonio, TX, 782820.66Name re-casedTwo-digit birth yearCity re-casedState name converted to code+1 more
CLM-432207CLMMichelle Ramos1976-07-08UHC-95677-22—7537 Park Pl, Charlotte, NC, 282460.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-406317CLMBobby Jimenez1963-03-15—89148905048735 Ridge Rd, San Diego, CA, 921690.66Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+1 more
CLM-405337CLMHenry Mitchell1992-03-03UHC-74665-73—3105 Mountain View Dr, Columbus, OH, 432230.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407774CLMBryan Lopez1952-11-09UHC-88128-54—7665 Elm St, Denver, CO, 802870.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-424213CLMRoy Campbell1965-02-19—80229475104888 Union St Apt 1, Phoenix, AZ, 850600.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-431064CLMKathleen Jacobs—UHC-95648-1543034371195998 Sage Ct, Nashville, TN, 372500.66Name split from “Last, First”Date of birth unreadablePhone reformattedMember ID reformatted+1 more
CLM-413318CLMHannah Nelson1960-11-08UHC-47037-05—8044 Grand Ave, Tucson, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-418374CLMJack Schultz1958-03-23UHC-16669-60—1433 Union St, Orlando, FL, 328470.66Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+1 more
CLM-400305CLMJohn Brooks1995-06-08——2490 Broadway, Mesa, AZ, 852750.66Date of birth reformattedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-401841CLMBetty T Peters1940-12-28UHC-02149-7491065805537521 Camelback Rd # 169, Sacramento, CA0.66Member ID reformattedUnit split from streetZIP missingWhitespace trimmed+1 more
CLM-413458CLMBarbara Edwards1951-10-01UHC-91524-18—4467 Ocean Ave, Seattle, WA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-425511CLMHirsohi D Estrada—UHC-03525-6421141069595345 Cedar Ln, Los Angeles, CA, 900380.66Date of birth unreadablePhone reformattedState name converted to codeWhitespace trimmed+1 more
CLM-432715CLMRandy Riley1975-07-01——2611 Jefferson Ave, Plano, TX, 750540.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-430622CLMFrank D Miller1965-03-06UHC-04100-71—9039 Park Pl, Eden Prairie, MN0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-427813CLMSophia Ryan1966-08-03UHC-48990-31—8766 Spring St, Seattle, WA, 981770.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421151CLMScott Rogers———1722 Canyon Rd, Fresno, CA, 937690.66Date of birth missingStreet suffix standardisedAddress re-casedState code upper-cased+1 more
CLM-406483CLMShirley R Marshall1980-07-26——8918 Park Pl, Denver, CO, 802720.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-421324CLMBobby Chapman2004-02-20UHC-80403-78—2613 Cedar Ln, Austin, TX0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-423542CLMAnn Lawrence1993-12-14UHC-40605-61—8405 Apache Blvd, Miami, FL, 331250.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-400907CLMMason Reynolds1978-09-19UHC-75443-65—4261 Ocean Ave, Dallas, TX, 752090.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-408037CLMScott Pena1993-10-14——2019 Oak St, Tucson, AZ, 857980.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-413633CLMRoger Guzman1991-11-22UHC-24096-79—7777 Baseline Rd, Los Angeles, CA, 900370.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407773CLMCharles O Ellis1972-11-13UHC-01634-67—9432 Church St, San Diego, CA, 921520.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-410404CLMDebbie Smith1955-02-11UHC-06521-05—805 Market St, Plano, TX, 750810.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-411705CLMRyan Riley1987-02-22—5577288089592 Sage Ct, Nashville, TN, 372120.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-409563CLMCarolyn Berry1961-03-20UHC-09486-83—9798 Main St, Seattle, WA, 981420.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-413070CLMPatrick Perez1975-05-24UHC-74189-68—6266 Cedar Ln, Gilbert, AZ, 852130.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-405713CLMDennis Grnt1934-04-27—21171219323986 Maple Ave, Los Angeles, CA0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-404051CLMNicholas Cox1943-10-01——3321 Spring St, Sacramento, CA, 958830.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-430139CLMAdam Vega1974-12-27UHC-75377-52—3130 Cedar Ln, San Diego, CA, 921810.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
32,829 rows, page 176 of 657PreviousNext