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-403147CLMMargaret James1943-09-04——831 Grand Ave, Tempe, AZ, 852400.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431165CLMRachel Walker1993-07-16——5745 Willow Ct, Denver, CO0.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-413054CLMVirginia F Dominguez1997-03-24UHC-47834-81—9376 Elm St, Orlando, FL, 328460.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-428798CLMRussell Weaver1962-04-14UHC-60979-31—3160 Pine Dr, Phoenix, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-400140CLMSofia Nunez1980-07-22UHC-92875-982684198246277 Lake View Rd, Nashville, TN0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404343CLMDonald Coleman1984-12-24UHC-72406-8059042752181107 Maple Ave, Austin, TX, 787270.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413236CLMDavid Lynch1959-02-27UHC-52815-4790299032526485 Harbor Blvd, Dallas, TX, 752920.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403787CLMMateo Myers1976-07-16UHC-90347-4363693442365802 Ridge Rd, Glendale, AZ, 853080.50Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-421574CLMMadison E Moore2001-01-14UHC-36940-63—6393 Grand Ave, Tempe, AZ, 852600.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-424059CLMKyle Black1992-11-16——7088 Hillcrest Rd, San Antonio, TX, 782450.50Name split from “Last, First”Date of birth reformattedCity re-casedState name converted to code+3 more
CLM-410377CLMArjun Lerson1991-01-24UHC-89929-2498544054541443 Mesa Dr, Plano, TX, 750590.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427903CLMRebecca Y Bennett1961-04-14UHC-24020-26—5489 Elm St, Tempe, AZ, 852840.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429828CLMKelly Rivera1941-09-27UHC-23051-0835549542547314 Baseline Rd, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407063CLMChristopher Duncan2003-06-26UHC-75482-8787058895025806 Oak St, Dallas, TX, 752230.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-429056CLMBilly F Wheeler1971-12-03—78745725007819 Willow Ct, Austin, TX, 787130.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403749CLMHenry F Litle1944-12-26UHC-93359-73—266 Camelback Rd, Atlanta, GA, 303610.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
CLM-409643CLMGerald Nichols1956-12-02—2252722408592 Broadway, Los Angeles, CA, 900920.50Name re-casedPhone reformattedSSN last four extractedZIP+4 trimmed+3 more
CLM-410672CLMJeffrey Simmons1977-03-08UHC-64891-4788094836266175 River Rd, Tempe, AZ, 852400.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-400027CLMVincent Oliver1973-05-14UHC-16577-40—6938 Apache Blvd, San Diego, CA0.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404938CLMAnn B Ryan2003-08-24—8399494266423 Oak St, Las Vegas, NV0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-417757CLMCarlos B Gibson1939-07-05—32331658208326 Cedar Ln, Tucson, AZ, 857720.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-427181CLMJacob J Patterson1994-09-20UHC-78868-43—3426 Maple Ave # 570, Dallas, TX, 752780.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-419195CLMBruce Santos1996-02-23—36023623724163 Ocean Ave, Miami, FL, 331220.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426518CLMClark Peetr1938-10-16——3744 Sunset Blvd, Eden Prairie, MN, 553750.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-419359CLMSamantha Burns1993-07-27—49367076219661 Main St, Nashville, TN, 372480.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404862CLMAhmed Vazquez1955-08-09UHC-66130-9391425412726035 Oak St, Fresno, CA, 937230.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422411CLMJoseph Carter—UHC-97279-2925373839193938 Desert Sky Blvd, Chandler, AZ, 852310.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-432250CLMCatherine Romero1952-02-09——9615 Camelback Rd, Tempe, AZ, 852630.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-426346CLMCarolyn Wilson1964-04-24UHC-81583-7547568962872570 Valley View Dr Apt 30, Jacksonville, FL, 322430.50SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-418967CLMCharles Sullivan1963-10-07——3599 Maple Ave, Orlando, FL, 328580.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-410406CLMMei Rose1951-02-06UHC-33521-18—6585 Forest Ave, Atlanta, GA, 303140.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405859CLMSara King1996-12-15UHC-68504-05—4661 Central Ave, Tucson, AZ, 857060.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-423537CLMMegan Jimenez1951-04-18UHC-30141-5290794920537961 Maple Ave, Minneapolis, MN0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-409286CLMKyle Webb1991-06-22UHC-73310-75—3288 Lake View Rd, Mesa, AZ, 852700.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-421478CLMAhmed Cunningham1967-12-02UHC-90142-4158132237739547 Baseline Rd, Dallas, TX, 752380.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-429988CLMRaymond Wood1988-01-25UHC-06749-57—2432 Camelback Rd # 413, Miami, FL, 331430.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406571CLMJean Ward1942-05-13—79024415022434 River Rd # 772, San Diego, CA, 921460.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-426032CLMDanielle Palmre2001-07-22UHC-01567-87—9568 Maple Ave, San Diego, CA, 921620.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410432CLMCatherine Bennett1945-01-20——9312 Indian School Rd, Orlando, FL0.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-431778CLMAshley Carter1951-02-25——970 Mesa Dr Apt 36, Dallas, TX, 752600.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-405322CLMDick Jimenez1941-09-12UHC-48141-593878462631792 Desert Sky Blvd, Sacramento, CA, 958590.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418017CLMGray Rodriguez1987-10-28——1022 Park Pl # 477, Fresno, CA, 937510.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-418655CLMMaria Gonzales1946-04-21UHC-62081-02—6725 Bayshore Dr # 462, Glendale, AZ, 853300.50Date of birth reformattedMember ID reformattedUnit split from streetZIP+4 trimmed+3 more
CLM-409379CLMCynthia Morgan1985-01-11——1084 Canyon Rd # 260, Charlotte, NC, 282710.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
CLM-407283CLMDylan Rojas1974-10-07—81228846904391 Camelback Rd, Austin, TX, 787620.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-410330CLMRonald I Watkins2008-06-26—949232041521 Washington St, Fresno, CA, 937920.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-418449CLMScott Alvarado—UHC-03782-0496492973885896 Hillcrest Rd # 565, Glendale, AZ, 853990.50Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
CLM-432078CLMTerry Ward1946-01-15UHC-07080-31—7505 Elm St, Tampa, FL, 336040.50Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429015CLMBrenda Green1966-08-06—24646199234014 Canyon Rd, Eden Prairie, MN, 553480.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-402733CLMJustin X Murphhy1997-05-06UHC-71276-28—176 Lake View Rd Apt 13, Gilbert, AZ, 852530.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 29 of 657PreviousNext