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-423792CLMSamantha Cox1974-01-03——7598 Oak St, Dallas, TX, 752910.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-412681CLMLuis Lee1965-04-28UHC-56887-73—7876 Bayshore Dr Apt 30, Phoenix, AZ0.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-417543CLMSandra R Hart1950-09-18UHC-51984-99—9811 Maple Ave # 933, Orlando, FL0.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-429587CLMLaura Ford1971-04-01——2828 Maple Ave Apt 8, Gilbert, AZ, 852830.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-403206CLMJakob G Wong1982-10-02——1191 Camelback Rd Apt 17, Mesa, AZ, 852100.48Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+4 more
CLM-423315CLMMark Elliott1981-08-23UHC-53509-9927285563637325 Harbor Blvd, Minneapolis, MN0.48Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
CLM-428703CLMKathryn Carlson1939-12-07UHC-76593-9555480832162320 Highland Ave, Las Vegas, NV, 891090.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-400534CLMCarl Jacobs1989-03-02——3975 Canyon Rd # 837, Gilbert, AZ, 852960.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-428219CLMAustin Welch—UHC-09700-727728276325278 Palm Dr, Gilbert, AZ0.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428711CLMPeter Black1991-07-06UHC-10895-5052979266999849 Palm Dr # 580, Miami, FL0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-403242CLMKeith G Cunningham1962-05-22—93871373186316 Central Ave, Charlotte, NC, 282240.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402421CLMLauren Carroll1963-12-24—86671074302829 Lake View Rd, Mesa, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-409349CLMMatthew R Romero1972-07-08——138 Market St, Tempe, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407908CLMMichelle Lee1952-02-03UHC-44850-78246888320188 Highland Ave, Charlotte, NC, 282110.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-426370CLMMei Y Reyes1945-08-10—22853008241048 Main St Apt 3, Jacksonville, FL, 322410.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-404467CLMGabriel Campbell1941-09-14UHC-07730-9285122041761460 Pine Dr # 396, Plano, TX, 750010.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-416731CLMThomas Black1962-10-13UHC-99272-93—9730 Oak St, Glendale, AZ, 853210.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-418708CLMMichelle Carpenter2004-12-26UHC-19794-40—1416 Spring St, Scottsdale, AZ, 852150.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-419720CLMTheresa G Ruiz—UHC-19329-1488875609105807 Bayshore Dr, Columbus, OH, 432900.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-432077CLMTerry Q Duncan1972-11-17UHC-55410-43—8349 Sunset Blvd Apt 40, Fresno, CA, 937260.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-409582CLMJennifer Riley1988-04-14——4639 Baseline Rd, Jacksonville, FL, 322860.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-423289CLMHansen Richaard1959-10-08—35058924021452 Cedar Ln Apt 10, Nashville, TN, 372150.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-405594CLMCatherine Morrison2008-01-27UHC-23703-76—4880 Ocean Ave, Charlotte, NC, 282730.48Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-410455CLMPatrick H Sanchez1955-04-09—21998659888588 Church St, Dallas, TX, 752150.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-419117CLMCynthia B Turner1951-09-10UHC-24518-0228894185638782 Hillcrest Rd, Miami, FL, 331070.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-426967CLMChristine Delgado1940-08-24UHC-79906-7823281456336770 Baseline Rd, Minneapolis, MN, 554250.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-431227CLMDiego Moreno1957-09-05UHC-06269-7058691190578878 Central Ave, Chandler, AZ, 852680.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-407730CLMBeverly Padilla1954-10-26UHC-35803-1553953481706136 Park Pl Apt 4, Mesa, AZ, 852250.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-405644CLMStephen Chavez1993-06-01—43798277883236 Jefferson Ave, San Antonio, TX, 782470.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-432741CLMBarbara Marquez2002-02-02UHC-40992-9141755186629446 Hillcrest Rd, San Diego, CA, 921930.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421780CLMKyle Burs1946-02-23UHC-52612-93—7723 Hillcrest Rd, Tucson, AZ, 857250.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-412753CLMPriya Spencer2007-01-27UHC-46670-649653775496252 Apache Blvd, Houston, TX, 770150.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-405719CLMMary Schmidt1977-05-21UHC-12590-7238666018286452 Harbor Blvd, Miami, FL0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-402513CLMMelissa Fuller1986-09-12UHC-18904-0630222263739543 Cedar Ln, Houston, TX, 770510.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-422322CLMHeather Cox1957-09-25UHC-48098-196348182128613 Ridge Rd, Los Angeles, CA, 900080.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408146CLMYuki Wagner1980-05-17UHC-11396-966375562087123 Sage Ct, Nashville, TN, 372050.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416269CLMMaria E Chen2006-10-09UHC-06607-37—5649 Elm St, Eden Prairie, MN, 553450.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-409333CLMLauren Sullivan1986-10-09UHC-92701-448836385689381 Park Pl, Tampa, FL, 336970.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-420752CLMMariana I Arnold1967-07-07——495 Meadow Ln, Austin, TX, 787610.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405206CLMBrittany Campbell1953-04-18UHC-99813-0482785177635105 Valley View Dr, Fresno, CA, 937590.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-411953CLMSandra Reyes1964-07-08—82491835948178 Market St # 425, Dallas, TX, 752300.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-402556CLMBryan Carpenter1953-01-10UHC-20454-3225494366703793 Harbor Blvd, Los Angeles, CA, 900750.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417678CLMJanice Marquez1938-09-08UHC-17144-8065097373728672 Cedar Ln, Chandler, AZ, 852530.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421555CLMVirginia Schmidt—UHC-83823-8789331983979250 Forest Ave, Seattle, WA, 981460.48Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-428289CLMGregory Cruz1974-01-27UHC-66888-1798658435535351 Market St Apt 24, Jacksonville, FL, 322550.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
CLM-426896CLMStephen Lawrence1974-12-08UHC-90352-6464421448065363 Park Pl Apt 13, Plano, TX, 750870.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-419268CLMBradley Powell1958-08-26—50984788461114 Highland Ave, Gilbert, AZ0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-407539CLMVirginia G Yang1988-08-28UHC-41415-62—200 Jefferson Ave, Mesa, AZ, 852870.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-408895CLMAisha Robinson1961-10-19UHC-79685-7820730042021393 Spring St # 483, San Antonio, TX, 782060.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-431586CLMMarilyn G Dominguez1991-04-14UHC-83227-42—6157 Camelback Rd, Fresno, CA, 937450.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
32,829 rows, page 15 of 657PreviousNext