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-428453CLMMatao Prak2002-04-13UHC-21681-06—5295 River Rd, Denver, CO0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-422165CLMBilly R Collins1941-06-06——1834 Mountain View Dr, Austin, TX, 787620.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-420724CLMKathryn Kelley1941-03-05UHC-23952-71—5269 Washington St Apt 6, Nashville, TN, 372650.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-429937CLMNoah Franklin1960-09-27UHC-74947-71—1629 Grand Ave, Denver, CO, 802490.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-405044CLMKathleen Stewart1938-10-13——317 Mountain View Dr, Charlotte, NC, 282400.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408360CLMAna Q Allen1938-05-27UHC-40301-04—8410 Desert Sky Blvd, Denver, CO, 802520.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408361CLMAna Q Allen1938-05-27UHC-40301-04—8410 Desert Sky Blvd, Denver, CO, 802520.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423982CLMJerry Dominguez—UHC-34607-2793197801058695 Indian School Rd, Austin, TX, 787840.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432684CLMPeter Wang1989-06-01UHC-50056-3224033554095320 Lake View Rd Apt 12, Columbus, OH, 432730.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-426258CLMAshley Watson1960-12-22——4523 Maple Ave, Phoenix, AZ, 850640.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-424445CLMCharles Reynolds1961-09-26—29755746306382 Apache Blvd, Orlando, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428815CLMBetty Stephens2006-12-15UHC-08557-9188691394456241 Lincoln Way Apt 40, Eden Prairie, MN, 553450.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-417835CLMHannah Z Porter1991-06-15UHC-63800-6435646122165730 Palm Dr, Miami, FL, 331990.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426264CLMCamila Green1991-08-15UHC-53157-96—8860 Willow Ct, Phoenix, AZ, 850670.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-422305CLMKayla Walsh1967-03-10—68577113588522 Lake View Rd, Tucson, AZ, 857050.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405934CLMThomas W Schmidt1960-08-05—4057942500968 Canyon Rd, Fresno, CA, 937420.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422224CLMWilliam Mroales1997-12-01—9632818563342 Grand Ave # 276, Miami, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-430458CLMBenjamin Ferguson———6269 Willow Ct, Eden Prairie, MN, 553250.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-423596CLMWayne Nelson2003-08-18UHC-16289-79—4213 Spring St, Charlotte, NC0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422615CLMJudith Simmons1980-07-16UHC-35607-9974439036788104 Maple Ave, Fresno, CA, 937280.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-418923CLMMary Miller1940-11-17UHC-95565-83—9265 Sunset Blvd, Minneapolis, MN, 554760.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-413363CLMAndrew Ramos1951-09-27——2590 Market St, Dallas, TX, 752110.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-419104CLMJoan Cooper1994-06-27UHC-48751-848585513148572 Forest Ave, Scottsdale, AZ0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417478CLMWillie R Woods1981-12-09—29947572339597 Main St, Austin, TX, 787520.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429327CLMCarl Yang1971-09-16—57327091267828 Central Ave, Plano, TX, 750170.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432209CLMRaymond Maldonado1969-10-23UHC-59420-59—4552 Market St, Columbus, OH, 432850.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-421416CLMRebecca Mason———5546 Broadway, Glendale, AZ, 853930.50Name re-casedDate of birth unreadablePhone missing area codeAddress re-cased+3 more
CLM-424070CLMJackie Yang1938-05-18——3618 Pine Dr, Jacksonville, FL, 322740.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400070CLMAmbber Wells1979-06-25—2665950799299 Meadow Ln, Houston, TX, 770140.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417500CLMDennis Parker1972-05-03UHC-00717-4950534509103033 Washington St Apt 33, Mesa, AZ0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421422CLMKatherine Hughes1964-08-18UHC-58411-5395737486973745 Maple Ave # 784, San Diego, CA, 921140.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-405578CLMRaymond U Burns1943-08-03UHC-29776-5747031694932658 Hillcrest Rd, Austin, TX0.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407691CLMEugene H Kelly1976-07-07UHC-59154-82—1751 Valley View Dr, Miami, FL, 331480.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-402625CLMMelissa Welch1986-07-15UHC-74121-25—3450 Maple Ave, Las Vegas, NV, 891570.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-422844CLMAna N Gilbert———5440 Valley View Dr, Austin, TX, 787250.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-406860CLMGreen Luis1980-09-23—87441178991792 Mountain View Dr, San Antonio, TX, 782700.50Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+3 more
CLM-431320CLMJoe Thomas2007-03-01UHC-54570-0576395330458252 Main St, Plano, TX, 750330.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-424897CLMFrank Roberts1981-06-11——7429 Washington St, Phoenix, AZ, 850500.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-422395CLMJoshua Payne1938-09-03—28931056975146 Cedar Ln, Sacramento, CA, 958710.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-410833CLMEdward Daniels1985-10-27UHC-52432-1133431721638035 Central Ave # 267, Tampa, FL, 336150.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-429941CLMPatrick Sanders2005-09-06—35835405984835 Apache Blvd, San Diego, CA, 921930.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424239CLM—Junk1985-12-02UHC-44550-4352394438162515 Palm Dr, Tucson, AZ, 857670.50Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+3 more
CLM-415269CLMJesse Murray1963-12-17UHC-00502-6389484222682900 Lincoln Way, Jacksonville, FL, 322530.50Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+3 more
CLM-409421CLMLuis Richards1969-08-21UHC-28814-43—6338 Indian School Rd, Gilbert, AZ, 852250.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-421544CLMMegan Medina1944-10-12——3116 Hillcrest Rd, Jacksonville, FL, 322450.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-428129CLMRuth Meyer2004-06-19UHC-88349-2786473581078704 Central Ave, Glendale, AZ, 853410.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-401340CLMCatherine X Ellis1939-12-19UHC-05992-1975137687123991 Park Pl, Chandler, AZ, 852020.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-405449CLMDrew Brdaley—UHC-76594-50—3975 Sunset Blvd, Fresno, CA, 937920.50Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-403110CLMAndrea Fuller2005-03-01—31774117138857 Camelback Rd # 513, Tucson, AZ, 857370.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-400628CLMAlexander Thompson—UHC-81966-47—8452 Central Ave, Eden Prairie, MN0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 33 of 657PreviousNext