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-413002CLMAngela Watkins1997-08-02UHC-53758-5855182574882215 Canyon Rd Apt 40, Tampa, FL, 336130.40Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-431131CLMDebra Nelson1945-02-26UHC-84410-57—9628 Maple Ave, San Diego, CA, 921420.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-410656CLMAmanda Foster———395 Washington St # 772, San Diego, CA, 921990.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432613CLMSamantha Martiin——82771229839290 Canyon Rd Apt 28, San Antonio, TX, 782170.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432791CLMNancy Miller1953-09-11—77950037813880 Desert Sky Blvd # 907, Dallas, TX, 752720.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408150CLMHudson V Sarah2008-11-07UHC-43359-39—3760 Willow Ct # 157, Denver, CO, 802070.40Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
CLM-422037CLMAbby Nichols1956-10-26UHC-31174-53—4189 Elm St, Orlando, FL, 328890.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-427966CLMJuan Armstrong1955-11-06UHC-53733-41—4410 Forest Ave Apt 12, Columbus, OH, 432450.40Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-411946CLMElijah Wood—UHC-50101-19—2755 Sage Ct, Glendale, AZ0.40Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418822CLMSophia U Davis1966-05-17UHC-17097-4180638121934997 Baseline Rd, Houston, TX0.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-407763CLMHeather Hansen1938-08-09——8586 Apache Blvd, Sacramento, CA, 958120.40Name split from “Last, First”Phone missing area codeSSN last four extractedState name converted to code+2 more
CLM-422268CLMJustin Knight1985-10-27UHC-39714-96—2762 Forest Ave, Seattle, WA, 981020.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-421133CLMJacqueline Woods1954-12-17UHC-84563-2262074103608373 Mesa Dr, Chandler, AZ0.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-424377CLMAnna Morris1960-03-24——3498 Willow Ct, Columbus, OH0.40Name split from “Last, First”State name converted to codeZIP missingGender normalised+2 more
CLM-410004CLMDenise Davis1976-01-20UHC-95791-99—8266 Oak St, Seattle, WA, 981490.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410753CLMZachary Shaw1965-07-13UHC-32514-98—6728 Market St, Mesa, AZ, 852830.40Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-422616CLMJudith S Simmons1981-07-16UHC-35607-99—8104 Maple Ave Apt 4, Fresno, CA, 937280.40Middle initial moved out of first nameUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-411263CLMAdam Bailey———8267 Sage Ct, Fresno, CA, 937260.40Date of birth unreadableSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-401773CLMTyler M Taylor—UHC-19451-27—9668 Hillcrest Rd, Charlotte, NC, 282710.40Date of birth missingMember ID reformattedState name converted to codeZIP+4 trimmed+2 more
CLM-427980CLMAbigail Rios—UHC-06532-92—5815 Bayshore Dr # 218, San Antonio, TX, 782960.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432142CLMJoyce Hunt1993-11-16——2184 Main St, Atlanta, GA, 303240.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-411308CLMRonaldJunk1946-09-19UHC-31859-37—2525 Forest Ave, Mesa, AZ, 852890.40Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-411307CLMRonaldJunk1946-09-19UHC-31859-37—2525 Forest Ave, Mesa, AZ, 852890.40Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431126CLMJoshua Watson—UHC-57517-29—5300 Lake View Rd, Atlanta, GA, 303660.40Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-401262CLMWayne H James1983-07-16——3720 Pine Dr, Seattle, WA, 981980.40Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-430596CLMStephanie O Rojas—UHC-23206-4858093421633938 Main St, Jacksonville, FL, 322170.40Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+2 more
CLM-421267CLMChristian Hayes—UHC-86167-37—957 Camelback Rd # 858, Tempe, AZ0.40Date of birth missingUnit split from streetCity re-casedZIP missing+2 more
CLM-409802CLMBetty Martinez1996-03-10UHC-16621-1973249306025975 Lake View Rd, Jacksonville, FL, 322740.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-430510CLMRuth Schultz2007-02-04UHC-03534-7074652808561937 Bayshore Dr, San Antonio, TX, 782930.40Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-409914CLMGerald Reyes1994-04-26UHC-79915-5865285665213662 Grand Ave, Gilbert, AZ, 852090.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420716CLMSandra Owens1972-03-03UHC-34059-29—7000 Harbor Blvd Apt 16, Chandler, AZ, 852710.40Name split from “Last, First”Two-digit birth yearUnit split from streetStreet suffix standardised+2 more
CLM-402224CLMKimberly Morris1946-08-16——3790 River Rd Apt 2, Tucson, AZ, 857920.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-400426CLMJacqueline Chen1997-08-07UHC-37309-92—5143 Grand Ave, Los Angeles, CA0.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-424742CLMMason Reynolds—UHC-47917-8084725240494475 Indian School Rd, Charlotte, NC, 282760.40Name split from “Last, First”Date of birth unreadablePhone reformattedSSN last four extracted+2 more
CLM-428471CLMKyle Brown2002-05-02UHC-94017-832363788633901 Lincoln Way Apt 11, Seattle, WA, 981370.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430583CLMAhmed H Sullivan—UHC-97738-74—8848 Desert Sky Blvd, Charlotte, NC, 282960.40Middle initial moved out of first nameDate of birth unreadablePhone missing area codeStreet suffix standardised+2 more
CLM-410993CLMCarlos Alvarez1946-05-24UHC-45709-79—2196 Harbor Blvd, Houston, TX, 770960.40Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-419879CLMDJunk1968-12-08UHC-94194-4643858487493230 Oak St, Houston, TX, 770920.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-408488CLMAustin Dominguez1943-02-20UHC-60615-04—6619 Main St, Glendale, AZ, 853200.40Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-423246CLMSophia Lawrenke1989-05-04——2752 Valley View Dr, Charlotte, NC, 282150.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-410025CLMAndrea Morris—UHC-84486-67—3845 Maple Ave, Denver, CO, 802800.40Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-416791CLMPark Luis1961-06-19UHC-49347-2778892369847004 Harbor Blvd, Sacramento, CA, 958760.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-429873CLMAmber James1942-02-27UHC-46412-5583986074133347 Forest Ave, Sacramento, CA0.40Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+2 more
CLM-428702CLMHelen Thomas—UHC-64641-02—5587 Grand Ave, Tucson, AZ, 857720.40Name split from “Last, First”Date of birth missingPhone missing area codeGender normalised+2 more
CLM-430856CLMKaren Young—UHC-94385-95—2949 Hillcrest Rd Apt 1, San Diego, CA0.40Date of birth unreadableSSN last four extractedUnit split from streetZIP missing+2 more
CLM-422795CLMWilliam Lynch1958-01-03——8148 Sunset Blvd, Los Angeles, CA, 900130.40Name split from “Last, First”Two-digit birth yearPhone missing area codeGender normalised+2 more
CLM-407461CLMCarolyn M Palmer———1182 Apache Blvd, Orlando, FL, 328860.40Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-405782CLMMatthew Ryan———2434 Willow Ct, Eden Prairie, MN, 553860.40Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-416413CLMNancy I Sandoval1983-11-03UHC-95939-6795582604872398 Desert Sky Blvd, Scottsdale, AZ, 852840.40Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414951CLMKathryn Gonzalez1988-08-13UHC-91606-76—4472 Main St, Minneapolis, MN0.40Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 10 of 657PreviousNext