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-410682CLMSteven Campbell1996-09-20UHC-56403-1344327949925909 Central Ave, Orlando, FL, 328980.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-413778CLMMark Ross1997-07-21UHC-63530-2259740276581949 Mountain View Dr, Los Angeles, CA, 900280.64Name split from “Last, First”Date of birth reformattedCity re-casedZIP+4 trimmed+2 more
CLM-426167CLMKayla C Yang1952-06-07UHC-08889-5752950954667845 Palm Dr, Fresno, CA0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411437CLMArthur George2000-07-02UHC-37062-38—3309 Sunset Blvd, Las Vegas, NV, 891770.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411993CLMHannah M Flores1941-11-18UHC-63078-53—9304 Lake View Rd, Plano, TX, 750400.64Name re-casedTwo-digit birth yearMember ID reformattedZIP+4 trimmed+2 more
CLM-401432CLMSophia Pierce1973-09-23UHC-04501-42—6744 Desert Sky Blvd, Glendale, AZ, 853820.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427378CLMRoger Davis1994-04-28——4491 Elm St Apt 16, Miami, FL, 331680.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-420499CLMCharlotte Sanders1978-04-13—70982489852361 Willow Ct, Eden Prairie, MN, 553540.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419395CLMSophia P Moreno1978-04-16UHC-86788-8394390196887487 Ridge Rd, Tucson, AZ, 857210.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-418036CLMBrandon Gilbert1979-12-13UHC-89487-07—2482 Market St, Phoenix, AZ, 850210.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405469CLMAmber Bailey1999-11-06UHC-62902-39—630 Union St, Jacksonville, FL, 322080.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-414013CLMKaren Lucas1976-10-28UHC-73213-28—7119 Palm Dr, Dallas, TX, 752610.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-420092CLMJanet Harris1998-10-06UHC-03351-82—1529 Highland Ave, Tempe, AZ, 852480.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-432477CLMEmma Maldonado1997-11-02UHC-45716-23—2613 Central Ave, San Diego, CA, 921480.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-432476CLMEmma Maldonado1997-11-02UHC-45716-23—2613 Central Ave, San Diego, CA, 921480.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-407265CLMCarol Mendoza1946-05-19UHC-73382-6489121861047006 Harbor Blvd, Jacksonville, FL, 322200.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-414255CLMBrittany Romero1960-07-06UHC-23742-3830036422461712 Ridge Rd, Dallas, TX, 752670.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400670CLMMelissa Palmer1949-04-01—28296910731984 Washington St, Tampa, FL, 336140.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431925CLMJustin Hernandze1939-02-15UHC-93913-12—4617 Willow Ct, Gilbert, AZ, 852600.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-414547CLMGeorge Diaz1971-08-22UHC-75475-51—2001 Washington St, Fresno, CA, 937780.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-404545CLMKtaherine Q Wang1986-01-14——7805 Harbor Blvd, Gilbert, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-413526CLMBenjamin Peters2006-10-23——8029 Mesa Dr, Houston, TX, 770140.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-401740CLMTersa Hanson1968-11-19——6035 Indian School Rd # 188, Jacksonville, FL, 322650.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-427623CLMAmber N Lee2004-04-08——5091 Church St, Sacramento, CA, 958830.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-417565CLMMariana Freeman1968-12-20UHC-39956-0189754615397185 Valley View Dr, Las Vegas, NV, 891090.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-425748CLMSraa Robertson1962-04-12UHC-65179-24—910 Forest Ave, Phoenix, AZ, 850050.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428135CLMBarbara Howell1968-03-16UHC-00518-5138994385466495 Mountain View Dr, Los Angeles, CA, 900620.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403481CLMHiroshi Wood1960-10-20——8320 River Rd, Eden Prairie, MN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-414363CLMBarbara Oliver1976-07-15UHC-71536-7745126664442343 Sunset Blvd, Austin, TX, 787780.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406224CLMJessica C Menndez1958-11-24UHC-94335-21—1455 Meadow Ln, Phoenix, AZ, 850160.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-405599CLMMadison Simmons1970-06-11UHC-47808-5161138029271841 Lake View Rd, Sacramento, CA, 958620.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-402262CLMSofia Day1938-07-28——2714 Ocean Ave, Chandler, AZ, 852450.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-406108CLMLinda Gomez2002-12-22UHC-79026-9583691906474100 Lincoln Way, Las Vegas, NV, 891090.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411130CLMNicole Hughes2001-10-12UHC-13273-3943057707945263 Willow Ct, Columbus, OH, 432710.64Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-407540CLMDiana X Murphy1963-09-13UHC-35658-267635285128800 Market St, Mesa, AZ, 852600.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407893CLMAlexis Olson1974-03-23——2050 River Rd, Charlotte, NC, 282210.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422201CLMHenry Salazar2006-05-10—8067857829—0.64Phone reformattedSSN last four extractedEmail lower-casedGender normalised+2 more
CLM-420807CLMJordan Rose1980-10-09——4464 Lincoln Way, Gilbert, AZ, 852410.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-422621CLMDanielle Lee1975-10-25—87453311267026 Jefferson Ave, Atlanta, GA, 303060.64Name re-casedPhone reformattedState name converted to codeGender normalised+2 more
CLM-419631CLMShirley Torres1992-01-21UHC-32432-85—5278 Harbor Blvd, San Diego, CA, 921120.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-430531CLMChristian Thomas2005-10-19——4914 Market St, Gilbert, AZ, 852740.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408215CLMPriya Z Clark1940-07-26UHC-40047-747576815457—0.64Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more
CLM-407901CLMBradley X Robinson1985-07-17——8938 Grand Ave, Tempe, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410869CLMFrakn Gomez1940-12-15—53784753542750 Mesa Dr # 635, Austin, TX, 787870.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-427055CLMSarah Millar1953-10-07UHC-52058-4943666663155539 Desert Sky Blvd Apt 10, Atlanta, GA, 303960.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-428784CLMChristina Dominguez1985-09-15UHC-80528-858428256560949 Pine Dr, Dallas, TX, 752510.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408985CLMJoyce Bowman1953-08-08UHC-07872-4773096028561658 Canyon Rd, Plano, TX, 750170.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427342CLMBrian Jacobs2001-11-04UHC-22822-80—6051 Valley View Dr, Jacksonville, FL0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-406179CLMRonald U Reed1947-10-26—73720748629356 Forest Ave Apt 8, Jacksonville, FL, 322540.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-403356CLMRachel Hart1963-10-16UHC-02912-42—8973 Indian School Rd Apt 4, Houston, TX, 770550.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 134 of 657PreviousNext