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-426603CLMChristopher Simmons1966-01-20UHC-42124-69—882 Park Pl, Tempe, AZ, 852990.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403318CLMTeresa Tran1997-11-01——9048 Grand Ave, Charlotte, NC0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-408372CLMAnnna Coleman2006-03-20——9158 Washington St, Austin, TX, 787470.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-427603CLMJoseph Day1948-02-19UHC-72292-79—6135 Apache Blvd, Miami, FL, 331330.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418789CLMBryan Morris1944-12-09—37587204812367 Jefferson Ave, Tucson, AZ0.64Phone reformattedCity re-casedZIP missingGender normalised+2 more
CLM-410391CLMSteven Parker1949-06-25UHC-34642-0193991111357981 Spring St, Phoenix, AZ, 850700.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400045CLMMaria McCoy1980-10-08——9418 Forest Ave, Orlando, FL0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418781CLMDoris Powell1996-12-12UHC-43897-5834351128232154 Main St, Sacramento, CA, 958250.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-426691CLMChristian I Patel1995-02-19UHC-73526-7724965318351065 Maple Ave, Atlanta, GA, 303580.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420328CLMKyle Smith1984-10-21—60095823772161 Jefferson Ave, Orlando, FL, 328270.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-423492CLMGabriel Bell1976-12-08—47728469417713 Market St, Tampa, FL, 336340.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-425138CLMLogan Davis1975-12-05UHC-19058-3394121234482947 Palm Dr, Tampa, FL, 336160.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430981CLMKaren Thomas2005-11-05UHC-47494-97—6718 Mesa Dr, Houston, TX, 770820.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-428759CLMMason Flores1946-01-06UHC-05511-99—4535 Willow Ct, Austin, TX, 787360.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-425261CLMAmy Fisher1975-05-19UHC-32895-692398252548653 Washington St, Chandler, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427020CLMKelly Luna1968-06-03UHC-78201-1051927347016508 Central Ave, Austin, TX, 787190.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403829CLMMarquez Mason1998-12-04UHC-73096-6164660299643220 Maple Ave, Sacramento, CA, 958430.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415503CLMRyan Mendez1950-05-28——2824 Valley View Dr, Jacksonville, FL0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-423081CLMKenneth Nguyen1989-12-14—8144767892—0.64Date of birth reformattedPhone reformattedSSN last four extractedGender normalised+2 more
CLM-423124CLMSandra Reynols1946-09-26UHC-58865-76—5433 Meadow Ln, Phoenix, AZ, 850350.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-431336CLMBrian Z Fox1969-01-20—30143088394879 Spring St, Glendale, AZ, 853780.64Phone reformattedCity re-casedState name converted to codeGender normalised+2 more
CLM-420455CLMJanet Morales1992-01-17—25625245201780 Spring St, Chandler, AZ, 852400.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-417693CLMJoan X Kelley1998-02-01UHC-58059-6337647876008796 Sage Ct, Minneapolis, MN, 554590.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404511CLMDaniel Allen1944-11-27UHC-80230-70—9804 Camelback Rd, Houston, TX, 770180.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421550CLMFrances Vega2006-03-18UHC-07350-60—2973 Elm St, Miami, FL, 331500.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426952CLMGerald Dean1964-08-14UHC-07212-83—6063 Ridge Rd, San Diego, CA, 921960.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405493CLMRachel Wheeler1968-04-06UHC-03328-76—3159 River Rd, Chandler, AZ0.64Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-402241CLMJesse Stewart1987-07-23UHC-43749-60—6125 Oak St, Gilbert, AZ, 852580.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-428918CLMDonald O Cooper1989-03-11—57569871064619 Central Ave, Los Angeles, CA, 900000.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408198CLMKathleen Wagner1990-12-17UHC-97845-1677163068609711 Spring St Apt 18, Tampa, FL, 336530.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-427204CLMWilliam M Hansen1974-02-21UHC-24086-776437986171201 River Rd, Jacksonville, FL, 322470.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-406207CLMWilliam Stewart1976-08-11UHC-87792-82—7629 Ridge Rd, Tampa, FL, 336500.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-406208CLMWilliam Stewart1976-08-11UHC-87792-82—7629 Ridge Rd, Tampa, FL, 336500.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-415101CLMMichelle Lee1942-09-04——182 Canyon Rd, Los Angeles, CA0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416490CLMTony Z Weaver1999-03-14UHC-71437-69—8177 Mountain View Dr, Fresno, CA0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-425666CLMAlexis O Vasquez1968-08-12UHC-44563-4377192505886026 Ocean Ave, Chandler, AZ, 852410.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400708CLMKaren T Rojas1996-05-21UHC-95344-6590383847376039 Sage Ct, Miami, FL, 331840.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400235CLMAngela Espinoza1979-07-09UHC-96990-15—6531 Ocean Ave, Fresno, CA, 937430.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426600CLMPat Owens1950-08-04UHC-87048-14—3078 Ocean Ave, Nashville, TN, 372010.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-408672CLMWillie Webb2006-09-24UHC-15119-47—7251 Willow Ct, Miami, FL0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-432768CLMMargaret Hall2004-11-13—6145442274548 Canyon Rd, Gilbert, AZ, 852120.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413848CLMEvelyn A Coleman1996-03-11—6764871565—0.64Name re-casedPhone reformattedSSN last four extractedGender normalised+2 more
CLM-424906CLMDiego R Knight1952-03-13UHC-29007-63—6387 Indian School Rd, Dallas, TX, 752330.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-419618CLMAaron Berry1972-03-04——3935 Market St, Chandler, AZ, 852860.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-417282CLMMateo I James2008-01-13UHC-62158-5663550048064536 Canyon Rd, Orlando, FL, 328630.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-423696CLMRonald West2007-07-24UHC-21226-6934990132551699 Union St, Minneapolis, MN, 554670.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401725CLMEmma Patel1988-09-21UHC-14814-27—3616 Indian School Rd, Phoenix, AZ0.64Name split from “Last, First”City re-casedState code upper-casedZIP missing+2 more
CLM-411786CLMEthan Kennedy2000-09-12UHC-94235-35—2663 Hillcrest Rd, Mesa, AZ, 852970.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432528CLMAmber Salazar1995-06-04UHC-48415-05—5289 Jefferson Ave Apt 30, Atlanta, GA, 303680.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-405970CLMLarry Bowman1973-10-22——1972 Valley View Dr, San Diego, CA0.64Name re-casedDate of birth reformattedZIP missingGender normalised+2 more
32,829 rows, page 115 of 657PreviousNext