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-427150CLMMarilyn R Sullivan1951-05-20—27485195085246 Desert Sky Blvd, Miami, FL0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-415855CLMDeba Young1945-02-12—56426813558723 Park Pl Apt 33, Houston, TX, 770500.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-411834CLMSarah Nguyen2004-01-18—8146241762127 Lake View Rd, Orlando, FL0.58Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-414159CLMGabriel Cole2007-05-03UHC-91900-159127862685373 Cedar Ln, Houston, TX, 770620.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-416700CLMSara Ramirez1991-07-10UHC-30553-7152087988613107 Lake View Rd, Gilbert, AZ, 852700.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-419160CLMHenry U Wright1956-07-12UHC-18814-5279956593188505 Sunset Blvd Apt 30, Chandler, AZ, 852120.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-408919CLMAlexis Lane1966-10-02UHC-83946-9535095472397368 Desert Sky Blvd, San Antonio, TX0.58Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-421826CLMJeffrey X Green1958-05-12UHC-73338-8367224460856830 Church St, Columbus, OH, 432290.58Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-419180CLMElijah W Munoz1957-11-23—66086760977576 Jefferson Ave, Houston, TX, 770040.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-406140CLMJacob Kim1988-11-28UHC-20478-9361766438229324 Indian School Rd, Charlotte, NC, 282240.58Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-424029CLMJose Schultz1991-03-25UHC-51372-9222083989032497 Washington St, Atlanta, GA, 303990.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-404961CLMScott Alvarez1953-05-08UHC-73594-8039020903651011 Ocean Ave, Denver, CO, 802210.58Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-425652CLMLisa Walker1950-02-28—96962959747489 Valley View Dr, Denver, CO, 802050.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-401825CLMBoobby Banks—UHC-25181-5838529211088937 Ocean Ave, Nashville, TN, 372690.58Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
CLM-427318CLMBrenda Y Gonzalez1966-12-25UHC-48692-6582021416423145 Apache Blvd, Houston, TX, 770840.58Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
CLM-415745CLMNancy Myers1991-06-05—55855851475117 Indian School Rd, Minneapolis, MN, 554290.58Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-404233CLMPamela Hansen2005-01-05—69639143267482 Oak St, Austin, TX, 787780.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-421884CLMElijah S Medina1952-02-09UHC-63153-9497783446168286 Bayshore Dr # 532, Columbus, OH, 432670.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-411898CLMDonald O Lynch1999-02-27UHC-41325-8053133149342835 Lake View Rd, Mesa, AZ, 852650.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-402048CLMStephanie Allen1995-11-20UHC-51810-4762137185198645 Apache Blvd, Tempe, AZ, 852100.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-427752CLMAndrea Wagner1940-02-15—54621804737893 Cedar Ln, Glendale, AZ, 853320.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-406441CLMPriya Stone1946-06-10UHC-32131-6497122302938768 Bayshore Dr, Eden Prairie, MN, 553730.60Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-425858CLMDonna Reed1985-11-09UHC-68692-1844756244587251 Harbor Blvd, Columbus, OH, 432660.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417805CLMSean F Wright2002-05-23—248949323034 Bayshore Dr, Austin, TX, 787530.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-424181CLMMatthew Ward1944-03-10UHC-15822-5460949929842316 Baseline Rd, Glendale, AZ, 853110.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-410444CLMCynthia Hunter2007-09-01UHC-66546-3075949343435520 Elm St, Seattle, WA, 981660.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-410443CLMCynthia Hunter2007-09-01UHC-66546-3075949343435520 Elm St, Seattle, WA, 981660.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-412453CLMJoey Ward1957-04-24UHC-28293-97—6443 Bayshore Dr, Glendale, AZ, 853670.60Name re-casedDate of birth reformattedMember ID reformattedSSN last four extracted+4 more
CLM-432236CLMAisha Gardner1969-09-06—82978646188538 Hillcrest Rd, Sacramento, CA, 958840.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428042CLMAustin Santos1978-06-09—7883371383457 Oak St, Chandler, AZ, 852370.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-424902CLMAlan Obiren—UHC-95481-8954134509562792 Bayshore Dr, Atlanta, GA, 303910.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-406760CLMAlexis Fernanedz1944-09-25UHC-19671-72—4367 Valley View Dr, Scottsdale, AZ, 852670.60Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-400412CLMRobert Hoffman1980-04-20UHC-41946-5893777885488892 Spring St, Dallas, TX, 752310.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-412512CLMAna Jenkins1946-01-22UHC-83983-707778597230882 Broadway Apt 28, Columbus, OH, 432330.60Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
CLM-418646CLMCynthia Perkins1954-01-11UHC-57488-4078828855353711 Mountain View Dr, Plano, TX, 750170.60Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-429599CLMMary Taylor2000-02-17UHC-20820-8868941169727667 Bayshore Dr, Minneapolis, MN, 554000.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417329CLMMichael Flores2000-05-13—71631718867802 Oak St Apt 33, Charlotte, NC, 282710.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-413737CLMJonathan Marquez1967-09-02—27161471836239 Canyon Rd, Dallas, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-429849CLMAdam Sanders2005-02-09UHC-72705-0974634640535341 Ridge Rd, Tempe, AZ, 852060.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403616CLMMelissa Park1982-04-21UHC-93563-20—2042 Camelback Rd, Eden Prairie, MN, 553730.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-404217CLMLawrence Harris2008-04-03UHC-52485-4241441726852714 Elm St, Mesa, AZ, 852750.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-415818CLMPatricia M Payne2003-11-14—20643934794502 Cedar Ln # 467, Minneapolis, MN, 554270.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-423993CLMWalter Ray1991-11-28UHC-99412-1081557609921070 Cedar Ln, Austin, TX, 787410.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-409819CLMSofia D Wrd1961-04-16UHC-55808-7923665152976963 Desert Sky Blvd, Tucson, AZ, 857860.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-404970CLMSamantha Miller1940-11-09UHC-50684-94—5308 Grand Ave, Tucson, AZ, 857780.60Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
CLM-412648CLMJanet Young1976-05-24—24257051943328 Oak St, Nashville, TN, 372800.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-409110CLMDonald Walker2002-06-26—29696529316076 Palm Dr, Tempe, AZ, 852640.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421264CLMChristian Hayes1963-03-14UHC-86167-379628231378957 Camelback Rd, Tempe, AZ0.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-428910CLMBilly Lewis1942-04-19UHC-32201-1622127318091864 Main St, Eden Prairie, MN, 553690.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-406615CLMJeremy Dean1938-10-04UHC-80606-8530926497796931 Park Pl, Phoenix, AZ, 850950.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
32,829 rows, page 64 of 657PreviousNext