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-404188CLMSharon Santos1990-01-28UHC-46936-5990598486216404 Bayshore Dr, Denver, CO, 802720.64Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more
CLM-432228CLMWayne Contreras1939-08-03—92652725048608 Hillcrest Rd, Charlotte, NC, 282170.64Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-404759CLMNancy Elliott2004-10-04UHC-74232-48—4488 Washington St, Houston, TX, 770510.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-410126CLMBruce Watson1956-10-01UHC-58660-37—8285 Ocean Ave, Mesa, AZ, 852890.64Name re-casedDate of birth reformattedState name converted to codeGender normalised+2 more
CLM-412841CLMEthan Johnson2007-03-24UHC-83697-77—306 Maple Ave, Los Angeles, CA0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411644CLMAdam Alvarado1941-02-23—59389960101044 Main St, Los Angeles, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-406291CLMNathan W Powell1989-03-17—4416767283683 Willow Ct, Seattle, WA, 981770.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429930CLMMichelle Oliver1978-02-16UHC-82552-0940033617078192 Indian School Rd, Sacramento, CA, 958990.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412819CLMHiroshi Harvey1985-11-11UHC-85614-5950022129542083 Park Pl # 539, Jacksonville, FL, 322890.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414963CLMLucia Vega2006-09-16—63856829511004 Willow Ct, Nashville, TN, 372270.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414962CLMLucia Vega2006-09-16—63856829511004 Willow Ct, Nashville, TN, 372270.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407785CLMVictoria C Fox1985-02-11UHC-83918-84—6276 Oak St, Tampa, FL, 336680.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-414781CLMScott Bryant1972-08-07—39435881502176 Broadway, San Antonio, TX, 782000.64Two-digit birth yearAddress re-casedCity re-casedState name converted to code+2 more
CLM-430310CLMBrian Burke2003-06-24UHC-91013-1494258660954636 Union St, Fresno, CA, 937670.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404484CLMHenry Anedrson1953-11-06——5226 Washington St, Charlotte, NC, 282460.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-422660CLMBilly D Bradley1998-05-18UHC-31626-5184138344712621 Palm Dr Apt 19, Atlanta, GA, 303740.64Date of birth reformattedMember ID reformattedUnit split from streetCity re-cased+2 more
CLM-400134CLMPaul Russell1988-05-04UHC-55726-01—6403 Mountain View Dr, Chandler, AZ, 852640.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424832CLMJoe Weaver1989-10-27—69656989347990 Jefferson Ave, San Antonio, TX, 782450.64Name re-casedPhone reformattedState name converted to codeGender normalised+2 more
CLM-417030CLMPatrick Patel1985-10-17UHC-39683-22—2331 Apache Blvd, Houston, TX, 770990.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-430007CLMJacqueline Hanesn1998-02-28UHC-97637-81—7272 Forest Ave, Minneapolis, MN, 554370.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-400614CLMJacqueline Lawrence2008-06-11UHC-77929-71—8326 Desert Sky Blvd, Eden Prairie, MN, 553000.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403416CLMJessica Bennett1957-09-24UHC-12177-94—41 Indian School Rd, Mesa, AZ, 852270.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-418415CLMRyan Hunter1966-10-05UHC-48235-63—7479 Forest Ave, Charlotte, NC, 282090.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-405411CLMDiego Bradley1981-06-15UHC-63626-44—6733 River Rd # 668, Tempe, AZ, 852590.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426544CLMMaria P King1975-10-01UHC-23433-6638599892333684 Oak St, Tampa, FL, 336300.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424116CLMFrank Lawrence1992-06-14—23441225444496 River Rd, Tucson, AZ, 857350.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-418124CLMDonald Sullivan———9412 Main St, Fresno, CA, 937090.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-407714CLMAmy O Elliott1950-07-18—46561051967041 Elm St, Phoenix, AZ, 850700.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-420679CLMDebbie Davis1953-07-11—59638629819882 Valley View Dr, Austin, TX, 787450.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429484CLMStephen Z King1969-01-20UHC-15796-58—5493 Meadow Ln, Los Angeles, CA, 900190.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424891CLMBrandon N Smith1958-10-14UHC-72514-77—1746 Bayshore Dr, Dallas, TX0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-406936CLMHannah Alvarado2001-11-22——1224 Mountain View Dr, Plano, TX, 750960.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416304CLMAnna Reiid1965-12-01UHC-32350-43—6762 Spring St, Fresno, CA, 937440.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404062CLMJudith Myers1946-09-27UHC-57361-7853638323277974 Ocean Ave, Austin, TX, 787580.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405852CLMKelly Aguilar1938-11-04UHC-52255-77—5312 Ridge Rd # 126, San Antonio, TX, 782460.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-411557CLMKelly Watson1987-01-01—8166214642—0.64Name re-casedPhone reformattedSSN last four extractedGender normalised+2 more
CLM-426858CLMSofia Q Ramos1993-10-13—5789974934273 Church St, Tucson, AZ, 857400.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408226CLMJulia Carroll1972-07-10UHC-35780-7083128375615704 Jefferson Ave, Atlanta, GA0.64Name re-casedPhone reformattedState name converted to codeZIP missing+2 more
CLM-416063CLMDonald Matthews1995-02-05UHC-95205-05—1183 Grand Ave, Eden Prairie, MN, 553520.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-406992CLMEric Bishop1951-02-13——2768 Highland Ave, Denver, CO, 802870.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408075CLMNathan West1970-10-16UHC-00293-65—8702 Valley View Dr, Phoenix, AZ, 850030.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-407804CLMBrandon Bryant1995-01-07UHC-65094-90—7968 Central Ave, Tampa, FL, 336480.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-415636CLMDylan Hudson2005-07-01UHC-06408-75—3085 Camelback Rd, Fresno, CA, 937770.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-419882CLMHiroshi Castro1950-07-07UHC-42235-4134436453514534 Church St, Gilbert, AZ, 852280.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-409988CLMLawrence Howard1945-12-13UHC-07588-78—9438 Valley View Dr, Los Angeles, CA, 900770.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-401434CLMBobby Q Jordan1994-07-21UHC-41568-13—7850 Market St, Charlotte, NC, 282250.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413917CLMBarbara Stephens2008-08-03UHC-27000-567179503033315 Grand Ave, Chandler, AZ, 852480.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-415120CLMAna Webb2001-09-28—31838600526431 Desert Sky Blvd, Tampa, FL, 336410.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-402442CLMRichard Patterson1998-06-23UHC-63925-81—2676 Market St, Nashville, TN, 372430.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421577CLMHanson Michael1983-07-01——3342 Sage Ct, Fresno, CA, 937380.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 138 of 657PreviousNext