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-424946CLMMaria Rmos1993-08-27UHC-15701-44—1825 Pine Dr, Columbus, OH, 432310.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-416937CLMAmberJunk1950-05-03UHC-16493-1828473580593362 Pine Dr # 516, San Antonio, TX, 782520.38Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-425692CLMMei Maldonado1945-11-02UHC-86595-66—7457 Park Pl, Houston, TX, 770820.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-404275CLMAndrea Medina1987-08-16——4090 Church St, Tucson, AZ, 857570.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-417303CLMTheresa Burns1961-08-13UHC-49456-9186776512396374 River Rd, Miami, FL, 331460.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-401181CLMDiego P Bishop1959-12-25UHC-89423-8629630504726395 Jefferson Ave, Eden Prairie, MN, 553450.38Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
CLM-413403CLMSarah Hunt1998-07-09UHC-87592-4238084394903523 Market St, Houston, TX, 770460.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-414132CLMKaren Welch1955-01-05UHC-51273-0255681198965842 Washington St, Plano, TX, 750960.38Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-400449CLMMargaret Cavez1951-03-19UHC-92419-11—5663 Spring St # 869, Minneapolis, MN, 554570.38Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-417337CLMJudy Z Pierce1991-02-15UHC-76830-07—2875 Maple Ave Apt 11, San Antonio, TX0.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-425686CLMAustin Robertson1968-10-16UHC-45622-09—7410 Ocean Ave Apt 39, Jacksonville, FL, 322220.38Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-400130CLMMargaret Reyes—UHC-72818-46—2556 Lake View Rd, Tampa, FL0.38Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-429414CLMDouglas X Lewis1967-09-08UHC-76690-56—560 Spring St Apt 6, Dallas, TX, 752540.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-422304CLMOmar Arnold1976-04-22UHC-09544-10—1974 Baseline Rd, Jacksonville, FL, 322540.38Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-423373CLMBrandon Halll1997-08-11UHC-21070-59—1192 Union St Apt 7, Chandler, AZ, 852800.38Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-425900CLMAshley Castro1970-04-21——1834 Jefferson Ave, Austin, TX0.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-403736CLMAdam Singh2002-01-12UHC-60218-20—5610 Camelback Rd, Nashville, TN, 372170.38Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-425804CLMStephanie Chapman1961-10-04—62568836107839 Main St # 781, Gilbert, AZ, 852620.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-429987CLMRymond Wood1988-01-25——1485 Apache Blvd Apt 11, Glendale, AZ, 853810.38Name split from “Last, First”SSN last four extractedUnit split from streetStreet suffix standardised+3 more
CLM-429767CLMEric A Burke———5360 Valley View Dr # 904, San Diego, CA, 921940.38Name re-casedDate of birth reformattedDate of birth unreadableUnit split from street+3 more
CLM-416053CLMBian Ramirez1955-01-27UHC-95424-96—3731 Market St Apt 29, Tempe, AZ, 852860.38Name re-casedTwo-digit birth yearUnit split from streetState name converted to code+3 more
CLM-408996CLMMargaret Ramirez1942-07-20——9566 Bayshore Dr, Austin, TX0.38Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
CLM-422342CLMDorothy Richards1979-02-07—8163835314987 Willow Ct, San Antonio, TX, 782800.38Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-425333CLMTeresa Y Davis1962-01-25UHC-40343-6770343641602133 Lake View Rd, Orlando, FL, 328410.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-400911CLMCarl Sandoval1998-04-01UHC-49946-01—1075 Elm St Apt 20, Plano, TX0.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-407945CLMWillieJunk2000-12-12UHC-06567-1026082286419015 River Rd, Minneapolis, MN0.38Street suffix standardisedAddress re-casedZIP missingGender normalised+3 more
CLM-415849CLMShirley Harper1966-05-19UHC-21504-79—9319 Church St Apt 37, Scottsdale, AZ, 852880.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-410426CLMEmma E Garza—UHC-80361-35—9103 Jefferson Ave, Seattle, WA, 981410.38Name split from “Last, First”Date of birth reformattedDate of birth unreadableCity re-cased+3 more
CLM-428266CLMLaura Thommas1940-04-21UHC-63477-40—2534 Central Ave # 407, Columbus, OH, 432270.38Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-420249CLMNathan Mendoza1952-11-13UHC-94958-6480345258125711 Elm St, Atlanta, GA0.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403709CLMKeith Vazquez1965-05-23—20966825676164 Grand Ave Apt 19, Scottsdale, AZ0.38Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-426262CLMJulia Calrson1963-11-18UHC-47137-69—4096 Central Ave, Gilbert, AZ, 852150.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-426263CLMJulia Calrson1963-11-18UHC-47137-69—4096 Central Ave, Gilbert, AZ, 852150.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-412128CLMRuth Rose2006-07-19——4493 Main St, Minneapolis, MN, 554920.40Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402189CLMTheresa West1982-03-22UHC-07177-15—8304 Baseline Rd, San Diego, CA, 921310.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-432413CLMJudy Henry1987-05-03UHC-61460-03——0.40Name split from “Last, First”Phone missing area codeSSN last four extractedGender normalised+2 more
CLM-407481CLMSteven G Ellis1944-12-28UHC-97673-7649180304326255 Park Pl, Jacksonville, FL, 322720.40Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedSSN last four extracted+2 more
CLM-405173CLMBarbara R Silva1965-04-05—33641360397394 Valley View Dr, Austin, TX, 787810.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-412734CLMEugene Richardson1956-02-08—66033506432383 Camelback Rd, Tucson, AZ, 857700.40Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-411251CLMHeather B Webb———4296 Harbor Blvd, Dallas, TX, 752520.40Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-420409CLMAbigail Jordan1997-10-26UHC-73690-42—3737 Oak St # 136, Denver, CO, 802940.40Name split from “Last, First”SSN last four extractedUnit split from streetState name converted to code+2 more
CLM-417409CLMKimberly Mejia1985-02-21UHC-36570-17—5419 Park Pl, Seattle, WA, 981130.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-406739CLMKelly Richards1995-06-22UHC-61615-48—7406 Pine Dr, Orlando, FL0.40SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-425510CLMAaron Watkins1967-12-08——7721 Maple Ave, Sacramento, CA0.40Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-405376CLMJeffrey B Valdez———8667 Baseline Rd, Nashville, TN, 372400.40Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-416896CLMCaol Hall2004-04-28—95797792076376 Desert Sky Blvd Apt 3, Phoenix, AZ, 850180.40Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+2 more
CLM-421084CLMRebecca Carlson———3457 Bayshore Dr, Chandler, AZ, 852420.40Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-413187CLMSteven O Wagner1938-02-24UHC-58486-0226494320642800 Highland Ave, Los Angeles, CA0.40Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
CLM-419530CLMAshley B Munoz——5102809704776 Apache Blvd # 350, Nashville, TN, 372820.40Name split from “Last, First”Date of birth unreadableUnit split from streetStreet suffix standardised+2 more
CLM-405506CLMMadison Montgomery1976-10-17UHC-92303-01—9194 Broadway # 691, Gilbert, AZ, 852190.40Name re-casedUnit split from streetState name converted to codeZIP+4 trimmed+2 more
32,829 rows, page 9 of 657PreviousNext