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-427864CLMJackie M Young1990-01-01——5721 Valley View Dr, Gilbert, AZ, 852230.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-413116CLMBarbara Snyder1975-07-12UHC-34905-1652856280091746 Bayshore Dr, Charlotte, NC, 282170.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412011CLMJose W Campbell1980-01-09——5850 Union St, Jacksonville, FL, 322690.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-424898CLMDiego Freeman1971-12-28UHC-98952-98—3303 Ocean Ave # 485, Glendale, AZ, 853090.66Name split from “Last, First”Member ID reformattedUnit split from streetWhitespace trimmed+1 more
CLM-430929CLMJason Meyer2002-12-20UHC-71924-51—412 Canyon Rd, Los Angeles, CA, 900530.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-404709CLMCharlles Rice1968-08-21UHC-28560-6881821848637601 Spring St, Tampa, FL, 336620.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-431354CLMPamela Schmidt1948-08-12UHC-00388-35—2097 Lake View Rd, Tampa, FL, 336700.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-400245CLMPamlea Gonzalez—UHC-32865-9482987413202138 Highland Ave, San Diego, CA, 921480.66Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-401913CLMSharon Patterson1968-01-26UHC-01025-68—7671 Central Ave, Atlanta, GA, 303640.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-429354CLMChristian Lane—UHC-80877-08—4761 Ocean Ave, Scottsdale, AZ, 852700.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-417415CLMAngela Martin2006-02-23UHC-26771-605632274890—0.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
CLM-425966CLMArjun Fernandez1950-04-22UHC-20619-1390130758073885 Park Pl, Minneapolis, MN, 554360.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-431835CLMRyen R Butler2000-07-04UHC-03130-9338756058628043 River Rd, Tucson, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-430757CLMJerry Knight1993-08-06UHC-14087-46—2251 Forest Ave, Los Angeles, CA, 900320.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-403493CLMMaria Burns1978-03-19———0.66Two-digit birth yearPhone missing area codeEmail lower-casedWhitespace trimmed+1 more
CLM-417437CLMAngela Sullivan1962-09-08——173 Indian School Rd, Minneapolis, MN, 554020.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-405177CLMMariana I Carlson1958-07-21—79081419573744 Elm St, Minneapolis, MN, 554740.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-405456CLMPhilip Lawrence1991-10-02UHC-27655-8980232220721594 River Rd, Chandler, AZ, 852000.66Name re-casedPhone reformattedMember ID reformattedState name converted to code+1 more
CLM-431517CLMPriia Griffin1991-04-14UHC-12688-71—7957 Elm St, Jacksonville, FL, 322440.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-423749CLMJulia Myers2001-03-08UHC-12935-90—7917 Desert Sky Blvd, Scottsdale, AZ, 852710.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-424843CLMJohn Bell1957-01-01UHC-95187-2931953964198461 Union St, Los Angeles, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-407857CLMRonald Espinoza1981-09-20——763 Oak St, Atlanta, GA, 303550.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-429824CLMScott Matrin2007-07-10UHC-42759-81—3618 Cedar Ln, Dallas, TX, 752140.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-408085CLMRyan Robinson1946-08-04——1897 Ocean Ave Apt 2, Houston, TX, 770810.66Date of birth reformattedUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
CLM-418241CLMVincent Silva1964-12-23UHC-21678-20—1724 Valley View Dr # 352, Miami, FL, 331820.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-416964CLMShirley Q Wag1946-08-25——9684 Ridge Rd, Mesa, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-403938CLMJerry Vasquez2000-12-19UHC-81842-70—3137 Willow Ct, Fresno, CA, 937010.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-413456CLMBarb Edwards1951-10-01UHC-91524-188699664205—0.66Name split from “Last, First”Phone reformattedSSN last four extractedWhitespace trimmed+1 more
CLM-409081CLMRobert Tran1979-03-12UHC-15067-68—6155 Spring St, Plano, TX, 750080.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-420265CLMChristopher T Rios—UHC-69476-29—8480 Elm St, Plano, TX, 750440.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419848CLMDoris Chavez1945-06-01UHC-61116-89—3286 Bayshore Dr, Gilbert, AZ, 852340.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412390CLMJack Russell1972-04-12——7332 Church St, Seattle, WA0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-416790CLMFatima Bryant2001-06-19UHC-81628-53—5830 Willow Ct, Fresno, CA, 937000.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-412633CLMJudy Grza1960-01-16UHC-43428-27—3068 Jefferson Ave, Columbus, OH, 432630.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-418992CLMSofia I Rioos1992-06-06UHC-21043-758688752423—0.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
CLM-419143CLMYuki Perkins1967-05-28UHC-55774-23—329 Park Pl Apt 3, Dallas, TX, 752070.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-420566CLMRoy Young1964-04-11UHC-43268-7464432743833149 Mountain View Dr # 640, Jacksonville, FL, 322730.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-424230CLMBilly Lewis2001-11-16UHC-05923-12—3868 Harbor Blvd, Miami, FL, 331870.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-408834CLMRebecca Roberts1981-03-07UHC-71907-1684248248897830 Camelback Rd, Glendale, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-405877CLMDeborah Ramos1996-05-03UHC-13452-14—2747 Baseline Rd, Los Angeles, CA, 900080.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-409693CLMChristian Woods1949-11-26—48285515739237 Main St, Plano, TX, 750760.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-421002CLMDebra Garza1984-04-28UHC-51147-76—6588 Ocean Ave, Columbus, OH, 432430.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-416099CLMDanielle King1982-05-23UHC-42664-83—6050 Park Pl, Fresno, CA, 937070.66Name re-casedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-432414CLMJudy P Henry1987-05-03UHC-61460-0348229490351612 Forest Ave, Tempe, AZ, 852630.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-416173CLMEthan Q Moore1993-04-26—85552042354536 River Rd, Chandler, AZ, 852910.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-422444CLMAmanda Alexander1938-02-27UHC-10695-829336832337879 Sunset Blvd Apt 23, Houston, TX, 770270.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-419374CLMChristine Duncan2004-09-21——5366 Canyon Rd, Minneapolis, MN, 554650.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407338CLMElijah Sandoval1995-08-03UHC-68589-33—4630 Market St, Miami, FL, 331450.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421727CLMMason S Garrett2005-06-06—87251992676530 Bayshore Dr, Nashville, TN, 372810.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-415907CLMAlexis Reynolds1988-03-04——5890 Harbor Blvd, Glendale, AZ, 853870.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
32,829 rows, page 166 of 657PreviousNext