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-430592CLMStephanie Burke1974-03-25UHC-61758-29—7411 Valley View Dr, Mesa, AZ0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426161CLMRoy Watson1981-02-16UHC-53548-2759696106337291 Hillcrest Rd, Glendale, AZ, 853030.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-420968CLMMelissaJunk1998-06-13UHC-73960-39—4529 Grand Ave # 997, Minneapolis, MN, 554920.52Name re-casedTwo-digit birth yearUnit split from streetWhitespace trimmed+2 more
CLM-423087CLMSteven P Maldonado1985-04-19——1352 Desert Sky Blvd, Minneapolis, MN, 554780.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-410643CLMRachel Z Patterson1941-11-27——8143 Mountain View Dr, Tampa, FL, 336860.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-403492CLMMelissa Brooks1990-06-02UHC-50029-66—72 Park Pl, Sacramento, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-420235CLMKaren Q Ruiz1943-08-01——5995 Sage Ct, Austin, TX, 787820.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-426591CLMGary Fields1988-08-24UHC-65382-80—8600 Willow Ct, Fresno, CA, 937360.52Name split from “Last, First”Member ID reformattedZIP+4 trimmedGender normalised+2 more
CLM-423726CLMBubby T Colilns—UHC-46738-0124334856378599 Lake View Rd, Tempe, AZ, 852650.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-427915CLMSarah Perkins1949-06-25——2882 Indian School Rd, Sacramento, CA, 958220.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-424361CLMPamela Hayes1967-07-20——3336 Valley View Dr, Atlanta, GA, 303250.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-418941CLMHelen O Jhnson1977-05-18UHC-28850-11—9802 Bayshore Dr, Los Angeles, CA0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-432499CLMOmar Bryant1987-03-17UHC-89172-02—3274 Willow Ct, Chandler, AZ, 852070.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-416191CLMSteven Brooks1991-05-11UHC-72425-74—6614 Camelback Rd # 960, Tampa, FL, 336990.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-428624CLMAmber Wheeler2008-03-05UHC-82210-35—638 Forest Ave, Mesa, AZ, 852500.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-405825CLMEmma Hall1991-06-23UHC-83120-1679688745553419 Indian School Rd, Minneapolis, MN0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410268CLMMike Evans2006-09-04——8354 Maple Ave Apt 7, Orlando, FL, 328560.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425675CLMBryan Ray1958-11-20UHC-15231-85—9671 Indian School Rd, Tucson, AZ, 857650.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431574CLMCatherine Q Wright1952-12-03UHC-46069-48—4260 Lake View Rd, Jacksonville, FL, 322560.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431452CLMJose S Jensen1953-01-13UHC-42670-9642527441812719 Ocean Ave, Nashville, TN, 372600.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431453CLMJose S Jensen1953-01-13UHC-42670-9642527441812719 Ocean Ave, Nashville, TN, 372600.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401779CLMAnn Reyes—UHC-80982-32—5760 Oak St # 231, Gilbert, AZ, 852810.52Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-428284CLMRichard Bailey—UHC-89724-56—735 Jefferson Ave, Miami, FL, 331000.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405065CLMSandra Adams1983-12-04UHC-23338-39—589 Pine Dr, Dallas, TX, 752900.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-423669CLMSantiago Prike———8949 Mesa Dr, Houston, TX0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-403568CLMJoe Richardson1943-10-04UHC-53594-59—5386 Apache Blvd, Nashville, TN0.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-407453CLMJose Reyes1982-09-22——3037 Willow Ct, Phoenix, AZ, 850740.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-422460CLMCharles Q Medina1965-05-16UHC-94822-28—8165 Sunset Blvd, Houston, TX, 770910.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
CLM-400348CLM—Junk1950-12-14UHC-83429-9575649720078824 Ocean Ave, Charlotte, NC, 282940.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401515CLMAlice Le1943-01-22UHC-49554-66—845 Bayshore Dr, Charlotte, NC0.52Name split from “Last, First”City re-casedZIP missingGender normalised+2 more
CLM-407658CLMRyn Austin—UHC-79286-6143585148481673 Church St, Orlando, FL, 328330.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-428670CLMDouglas Patterson2000-08-26UHC-20741-40—4786 Sage Ct, Los Angeles, CA, 900520.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-419443CLMJoe Bishop—UHC-58513-77—1154 Forest Ave, Eden Prairie, MN, 553870.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-405944CLMZachary Harris1972-03-02UHC-04428-6275244190316872 Sage Ct # 826, Miami, FL, 331030.52Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+2 more
CLM-409728CLMJacob Cooper1970-12-18UHC-27394-07—9817 Pine Dr, Chandler, AZ, 852570.52Name split from “Last, First”City re-casedZIP+4 trimmedGender normalised+2 more
CLM-403572CLMTimothy Reynolds1961-07-01UHC-76724-37—8333 Forest Ave, Miami, FL0.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-422210CLMVincent Morgan1986-08-06UHC-89453-5560197590136852 Union St # 772, Phoenix, AZ, 850970.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414794CLMScott Ward1943-10-21——468 Pine Dr, Jacksonville, FL, 322510.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
CLM-419553CLMGerald Fisher1943-06-08——268 Indian School Rd, Charlotte, NC0.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-406225CLMArthur M Thompson1941-09-20UHC-87768-9476463889354865 Elm St, Atlanta, GA, 303730.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401591CLMKathryn T Schmidt1956-10-09UHC-18595-4664151887445650 Pine Dr # 989, Tucson, AZ, 857140.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405633CLMMarcus Nelson1957-04-08UHC-34131-61—4225 Washington St Apt 11, Tempe, AZ, 852760.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-423432CLMMei Hoffman1938-05-02UHC-76616-8465634587829428 Oak St, Plano, TX, 750310.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-408778CLMKaren F Jackson1947-05-22—85433793291428 Jefferson Ave, Los Angeles, CA, 900230.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428926CLMKimberly Bell2003-09-01—59790337043424 Central Ave, Tempe, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408793CLMNancy Simpson1956-04-01—20595855065617 Jefferson Ave # 110, Sacramento, CA, 958280.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-405585CLMJacqueline Brooks1964-10-04UHC-71813-5241022467586927 Park Pl Apt 39, Columbus, OH, 432780.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405584CLMJacqueline Brooks1964-10-04UHC-71813-5241022467586927 Park Pl Apt 39, Columbus, OH, 432780.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408172CLMVirginia Hanson1953-08-12——2261 Willow Ct, Jacksonville, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-431805CLMChristine Cooper1963-04-27UHC-90180-01—4649 Camelback Rd, Tampa, FL, 336460.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 54 of 657PreviousNext