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-419779CLMVirginia Santos1963-04-24UHC-04585-66—4794 Mountain View Dr, Miami, FL, 331750.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-419778CLMVirginia Santos1963-04-24UHC-04585-66—4794 Mountain View Dr, Miami, FL, 331750.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-403734CLMGbariel Gonzalez1997-11-09—63439521937576 Valley View Dr, Jacksonville, FL, 322360.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
CLM-414858CLMNancy C Rojas1999-06-09UHC-90304-33—6782 Pine Dr, Houston, TX, 770650.66Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more
CLM-410580CLMJack Henderson1954-06-16——5249 Union St, Fresno, CA, 937750.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-413043CLMKelly Little2008-11-24UHC-49705-38—1047 Palm Dr, Austin, TX, 787620.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-425553CLMEmily White1942-09-14——208 Apache Blvd, Tempe, AZ, 852950.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-410882CLMAbigail Gray1998-07-12UHC-91906-99—3479 Market St Apt 28, Nashville, TN, 372920.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-410034CLMBruce Morales1938-04-18UHC-48238-50—1436 Jefferson Ave Apt 28, San Diego, CA, 921670.66Name re-casedTwo-digit birth yearUnit split from streetPlan code upper-cased+1 more
CLM-412336CLMStephen Evans2005-02-27UHC-29479-71—4867 Central Ave, Glendale, AZ, 853770.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-402818CLMBeth Porter1971-02-24——4206 Indian School Rd, Gilbert, AZ, 852740.66Name re-casedTwo-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
CLM-401789CLMWalter F Harris1955-10-03UHC-38852-43—7654 River Rd, Plano, TX, 750180.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-422893CLMDouglas S Matthews1976-06-02UHC-71180-4031191338191722 Canyon Rd, Tampa, FL, 336010.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-404240CLMMartha Romero1971-12-09—40781204534012 Broadway, Sacramento, CA0.66Two-digit birth yearAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-432066CLMDavid Green1962-05-06UHC-37765-37—3728 Jefferson Ave, Tucson, AZ, 857330.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-431341CLMAdam Schultz1975-10-28UHC-81014-14—442 Main St, Dallas, TX, 752250.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-431593CLMYuki Pakr2004-04-23UHC-60795-85—6274 Camelback Rd, Tampa, FL, 336960.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410466CLMRoy M Crawford2004-06-04UHC-12133-87—1696 Park Pl, Mesa, AZ, 852970.66Name split from “Last, First”Member ID reformattedSSN last four extractedState code upper-cased+1 more
CLM-401369CLMEric Cole1992-11-06——360 Apache Blvd, Tempe, AZ, 852960.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-402520CLMDouglas Mrgan1974-01-02——4328 Grand Ave, Chandler, AZ, 852070.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-420945CLMFrances K Hudson———9405 Willow Ct, Nashville, TN, 372460.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-410304CLMEmma Wagner1944-08-22——5589 Broadway, Orlando, FL, 328550.66Date of birth reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-403099CLMSamantha Jensen1962-07-24UHC-60388-12—8073 Central Ave, Fresno, CA, 937390.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-427371CLMWayne Brown1946-04-03UHC-91030-40—7841 River Rd, Columbus, OH, 432800.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-401037CLMMateo Mendoza—UHC-72923-14—4100 Main St, Fresno, CA, 937070.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-416488CLMAnthony Weaver1999-03-14——8177 Mountain View Dr, Fresno, CA, 937550.66Name re-casedDate of birth reformattedState name converted to codeGender normalised+1 more
CLM-420267CLMBilly N Valdez1968-12-02UHC-52318-42—1459 Hillcrest Rd, Glendale, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-405813CLMJordan A Munoz—UHC-64719-866424777794—0.66Date of birth reformattedDate of birth unreadablePhone reformattedGender normalised+1 more
CLM-400687CLMFreeman Z Lauren1958-04-09UHC-00648-1341950942192778 Bayshore Dr, Eden Prairie, MN, 553880.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-422770CLMGregory Le1939-12-05UHC-77243-54—3244 Spring St, San Diego, CA, 921140.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-411375CLMHeather Garza1983-04-15—62794808197382 Baseline Rd, Phoenix, AZ, 850130.66Name re-casedPhone reformattedState name converted to codeGender normalised+1 more
CLM-409057CLMAisha Long—UHC-66414-7246971708804700 Desert Sky Blvd, Tempe, AZ, 852590.66Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+1 more
CLM-406277CLMAndrea Z Morgan1963-02-21UHC-95133-83—125 Apache Blvd, Tempe, AZ, 852010.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413196CLMSusan Matthews1979-01-19UHC-95229-19—9469 Ocean Ave, Charlotte, NC0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-400844CLMRyan Kelly1969-12-07UHC-98387-34—9059 Maple Ave, Austin, TX, 787800.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-432675CLMWei Mason1982-09-01UHC-68321-28—9839 Palm Dr, Seattle, WA0.66Name split from “Last, First”Date of birth reformattedZIP missingWhitespace trimmed+1 more
CLM-430909CLMJose Pena1972-04-18UHC-68169-21—1513 Indian School Rd, Los Angeles, CA, 900560.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-403030CLMRaymond Lewis1949-01-21UHC-00572-265365907879561 Pine Dr, Jacksonville, FL, 322660.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-419661CLMRobert Webb1999-07-16—29779992987762 Mountain View Dr, Las Vegas, NV, 891100.66Name re-casedPhone reformattedZIP+4 trimmedGender normalised+1 more
CLM-421370CLMVirginia I Clark1956-11-05UHC-07844-60—8280 Forest Ave, Phoenix, AZ, 850310.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-401646CLMMichael Armstrong1958-12-05——9055 Bayshore Dr # 843, Austin, TX, 787300.66Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-400838CLMDylan W Green1988-10-20UHC-27229-3075563907808017 Ridge Rd, Tempe, AZ, 852410.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-423547CLMScott Marshall——78164148726184 Church St, Glendale, AZ, 853470.66Name re-casedDate of birth unreadablePhone reformattedGender normalised+1 more
CLM-404722CLMBenjamin Morgan1941-05-03UHC-99637-20—8904 Main St Apt 24, Fresno, CA, 937090.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-426084CLMAmy N Austin1990-06-06——8232 Mountain View Dr, Nashville, TN, 372350.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-401196CLMNoah West2008-12-14—39562484275602 Central Ave, Denver, CO, 802640.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-418963CLMYuki Boyd1947-07-04——4553 Oak St, Eden Prairie, MN, 553670.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-410209CLMSarah B Edwards1940-04-27——7813 Main St, San Diego, CA, 921180.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-413044CLMBrandon Kim1962-06-04——4843 Meadow Ln, Fresno, CA, 937190.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-413292CLMCarl Park1963-01-14UHC-65013-1963725633939297 Ocean Ave, Fresno, CA, 937410.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
32,829 rows, page 170 of 657PreviousNext