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-420854CLMDon Baker1982-01-10UHC-82382-1685041865249253 Apache Blvd, Seattle, WA, 981350.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407407CLMSusan Padilla1981-03-01UHC-73638-75—2782 Central Ave, Seattle, WA, 981820.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-426927CLMFatima Oliver1962-01-25UHC-11964-3048750216303457 Harbor Blvd, Miami, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430802CLMMarilyn Castillo1980-01-24——7402 Highland Ave Apt 29, Chandler, AZ0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402729CLMAna I Coleman1941-03-12——4247 Grand Ave, Los Angeles, CA, 900030.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-404642CLMBilly Tucker1987-12-20UHC-60679-1455087718516369 Indian School Rd, Tampa, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-419288CLMMadison Knight1984-02-05UHC-85507-79—8677 Baseline Rd Apt 18, Atlanta, GA, 303190.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-418497CLMIsabella P McDonald1967-08-02UHC-60298-7248162624457667 Pine Dr Apt 20, Columbus, OH, 432470.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-414141CLMRay Banks1966-04-28UHC-72994-01—3219 Grand Ave, Eden Prairie, MN, 553440.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420839CLMRaymond X Muunoz1976-05-13UHC-91631-69—8454 Apache Blvd, Scottsdale, AZ, 852480.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429692CLMAshely O Ryan1981-05-26—23598435995777 Grand Ave, Fresno, CA, 937800.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
CLM-412958CLMDylan Ross1942-02-11——8779 Forest Ave, Orlando, FL, 328690.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-421448CLMEmma L Carroll1984-04-25UHC-47807-89—8499 Indian School Rd, Fresno, CA, 937350.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-409956CLMKayla Flores1951-06-13UHC-94241-41—1387 Main St, Mesa, AZ0.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-417090CLMWilson Maison1993-07-06UHC-64072-59—1284 Mesa Dr, Jacksonville, FL0.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-405923CLMRios Harold———6491 Highland Ave Apt 38, Jacksonville, FL, 322620.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
CLM-428170CLMKevin Matthews1965-08-15—66160382376609 Mesa Dr, Houston, TX0.50Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
CLM-413684CLMJanice Robinson—UHC-21270-0370038794755220 River Rd, Columbus, OH, 432440.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-431916CLMAmy H Pena1939-08-28UHC-89660-2638434608639258 Hillcrest Rd # 611, Houston, TX, 770400.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-411917CLMOlivia Anderson1990-05-17UHC-15283-6992169225014847 Bayshore Dr # 745, Tucson, AZ0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-414541CLMBobby Carroll1998-09-03UHC-56827-6045961408928355 Palm Dr Apt 24, Chandler, AZ, 852540.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-413401CLMLauren H Shaw1997-08-15UHC-70188-66—2823 Spring St, Los Angeles, CA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-415118CLMCharlie Burke1955-11-08UHC-58990-73—5211 Sunset Blvd # 664, Atlanta, GA, 303540.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-416909CLMAngela Perez1955-05-05UHC-27456-12—2789 Valley View Dr, Atlanta, GA, 303310.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-429829CLMNancy Porter1940-07-15UHC-71964-53—6331 Ocean Ave, Dallas, TX, 752910.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-405130CLMSofia Obrien1967-03-16UHC-11144-4176136033717485 Ridge Rd, Jacksonville, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418700CLMGeorge Shaw1984-10-02UHC-36004-7779965395686572 Bayshore Dr # 840, Tucson, AZ, 857800.50Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more
CLM-429734CLMRalph Reyes2001-05-26—72864968049795 Union St, Fresno, CA, 937190.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401541CLMSantiago Ford1994-12-11UHC-19531-20—179 Apache Blvd, Tucson, AZ0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406581CLMNancy Wright1957-08-22UHC-99348-62—4434 Canyon Rd, Tempe, AZ, 852410.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-426928CLMSean Howell1979-03-20——1203 Sage Ct # 897, Sacramento, CA, 958890.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-426583CLMStephen QJunk1990-04-08UHC-69270-12—580 Grand Ave, Scottsdale, AZ, 852170.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412685CLMJoan D Clark1939-07-07UHC-69400-46—4377 Ridge Rd, Jacksonville, FL0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-425760CLMAbbigail Morrison1950-04-01UHC-09145-97—928 Bayshore Dr, Minneapolis, MN, 554480.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-417453CLMRachel Webb2001-04-13UHC-11876-8631276251315298 Maple Ave Apt 9, Atlanta, GA, 303780.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-414502CLMBrandon Torres1955-11-27—28688748404878 Canyon Rd Apt 9, Chandler, AZ, 852670.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-413820CLMNicholas Wells1972-01-06——8075 Indian School Rd, Glendale, AZ, 853840.50Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-420437CLMRonald Ellis2007-01-06——1443 Apache Blvd, Denver, CO, 802600.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-430686CLMSharon V Bell2006-07-20UHC-77136-29—6511 Sage Ct, Houston, TX0.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
CLM-429099CLMBenjamin Thompson1990-07-25UHC-19802-1582698305996913 Park Pl, Las Vegas, NV, 891030.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-431107CLMJanet Vazquez—UHC-47351-63—2641 Palm Dr, Seattle, WA, 981100.50Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-408817CLMVicky S Franklin—UHC-84410-2465868582995345 Valley View Dr, Denver, CO, 802590.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-403735CLMMunoz Jeremy2005-08-02UHC-17752-21—4774 Spring St, Seattle, WA, 981820.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-423466CLMAna Thomas1983-07-19—32849167618738 Camelback Rd, Scottsdale, AZ, 852280.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410976CLMDenny Hamilton—UHC-00203-2778187750654256 Ocean Ave, Columbus, OH0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-429768CLMEric A Burke1976-06-20——5360 Valley View Dr # 611, San Diego, CA, 921940.50Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-411007CLMJeffrey Stewart1995-03-24UHC-18721-5520695388876049 Grand Ave, Columbus, OH, 432890.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-419431CLMChristine Stevens1983-06-13—41594417399540 Broadway, San Antonio, TX, 782150.50Name split from “Last, First”Two-digit birth yearPhone reformattedAddress re-cased+3 more
CLM-415766CLMMason Castro1957-09-28UHC-01653-7276440396754926 Main St, Austin, TX0.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-410161CLMAlexander Carpenter1948-07-15UHC-30993-74—1607 Oak St, Orlando, FL, 328110.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 32 of 657PreviousNext