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-417003CLMDylan Clark1998-10-11—65536927113398 Apache Blvd Apt 15, Eden Prairie, MN, 553670.52Name split from “Last, First”Phone reformattedUnit split from streetGender normalised+2 more
CLM-422704CLMVirginia Cunningham1956-10-16UHC-75540-3835168136642093 Bayshore Dr Apt 26, Charlotte, NC, 282970.52Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+2 more
CLM-404963CLMGary Hughes1947-06-17UHC-42310-5651453581306761 Cedar Ln, Mesa, AZ, 852350.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411041CLMCharlotte I Payne2005-01-13——2382 Grand Ave, Glendale, AZ, 853540.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430336CLMDiego Contreras1948-02-23UHC-46032-06—2310 Forest Ave # 235, Eden Prairie, MN, 553600.52SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432513CLMHarold Pierce1958-09-17UHC-59853-76—5371 Park Pl, Glendale, AZ, 853700.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431751CLMAlan Gilbert1966-08-18UHC-57392-18—5697 Camelback Rd, Charlotte, NC, 282480.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-412643CLMAndrea Sanders1976-03-15—87566136606103 Market St, Columbus, OH, 432480.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411892CLMRyan Fuller1965-12-23—71763955109460 Elm St, Columbus, OH0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418815CLMRichard Boyd1945-02-02—98966953632919 Jefferson Ave Apt 29, Scottsdale, AZ, 852580.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-415141CLMJacqueline Munoz1961-08-13UHC-96980-7430461477329815 Ocean Ave # 632, Chandler, AZ0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425545CLMSophia Foster1939-02-09UHC-38274-5798390742737330 Canyon Rd, Nashville, TN, 372410.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-424862CLMBen Rose2007-04-19UHC-01453-15—3350 Maple Ave, Scottsdale, AZ, 852160.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401286CLMEmma Valdez—UHC-16477-14—5102 Cedar Ln, Seattle, WA, 981920.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-432405CLMMicehlle Alvarez2007-03-11UHC-56884-74—9370 Hillcrest Rd, Tempe, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-423587CLMVictoria Herrera1944-07-22UHC-21655-7483462154196228 Bayshore Dr Apt 10, Tempe, AZ0.52Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+2 more
CLM-429884CLMAnn Garrett1938-12-18UHC-63615-33—5563 Lincoln Way # 379, Houston, TX, 770730.52Name split from “Last, First”Member ID reformattedUnit split from streetState name converted to code+2 more
CLM-406174CLMJean Kelly2007-01-26——1655 Cedar Ln, Chandler, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-418690CLMBilly Anderson1984-05-10—7867473559—0.52Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+2 more
CLM-403283CLMJudith E Gilbert1955-10-23UHC-52805-66—7478 Market St, Austin, TX, 787150.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-423404CLMScott Duncan1997-10-26UHC-47476-28—4543 Indian School Rd, Gilbert, AZ0.52Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-426586CLMDiana Garrett1962-01-07UHC-79807-80—2079 Ocean Ave, Nashville, TN, 372830.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-404044CLMRobert Wng1951-08-03UHC-24041-45—167 Harbor Blvd, Sacramento, CA, 958880.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415830CLMGabriel L Hawkins1949-12-22—86434193263579 Desert Sky Blvd, San Antonio, TX, 782170.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-427240CLMJuan Richardson1953-06-28UHC-66465-9929142351024782 Palm Dr, Scottsdale, AZ, 852790.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-427819CLMAndrea Armstrong1958-04-28UHC-90391-35—1343 Willow Ct, Tampa, FL, 336020.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-420923CLMNaancy Freeman1991-07-03UHC-64096-58—4919 Sunset Blvd, San Antonio, TX, 782620.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418568CLMSteven Howell2008-02-19UHC-92754-01—1820 Maple Ave Apt 37, Sacramento, CA, 958780.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426803CLMHannah Chavez1968-07-28UHC-39743-8669136746942210 Park Pl, Glendale, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-423575CLMDouglas Daniels1957-01-06UHC-43682-30—3223 Washington St, Denver, CO0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-416406CLMHeather Hill—UHC-75926-3534090333998353 Washington St # 185, Atlanta, GA, 303840.52Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-403501CLMLori N Duncan1965-10-18UHC-77386-4087698161752740 Oak St, Plano, TX0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-423176CLMKelly Lucas1947-12-15UHC-15635-05—6413 Meadow Ln, Seattle, WA, 981180.52Name split from “Last, First”Date of birth reformattedState name converted to codeGender normalised+2 more
CLM-407599CLMWayne Wallace1967-05-17UHC-45597-20—4877 Valley View Dr, Tampa, FL, 336700.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-408422CLMLauren Roberts1985-08-02UHC-80177-29—2732 Palm Dr, Denver, CO0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-408688CLMEvelyn Ramos1970-12-02——330 Baseline Rd, Orlando, FL, 328320.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-404417CLMHiroshi Mills1962-05-01UHC-42502-0824971539411782 Highland Ave # 310, Las Vegas, NV, 891620.52Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+2 more
CLM-411133CLMLori Garcia1993-06-24UHC-39221-56—988 Sage Ct, Tampa, FL, 336910.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-419364CLMSofia Wallace1989-07-10—95165321101093 Ocean Ave, Orlando, FL, 328450.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422657CLMMarcus Kelley1975-06-02——6515 Elm St, Eden Prairie, MN, 553060.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-411949CLMJacob Roberts1959-04-06UHC-64537-46—5524 Canyon Rd Apt 8, Austin, TX, 787960.52Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+2 more
CLM-429119CLMHerrera G Jim———4491 Church St Apt 16, Denver, CO, 802280.52Name re-casedDate of birth unreadableUnit split from streetZIP+4 trimmed+2 more
CLM-417149CLMMaria Hansen1977-08-11——7203 Central Ave, Los Angeles, CA0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-410036CLMReecca H Tucker—UHC-44298-25—1044 Harbor Blvd, Austin, TX0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-429901CLMMark Nelson1957-10-06——3833 Desert Sky Blvd, Las Vegas, NV0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-424807CLMMartha Hart1992-08-09UHC-75199-01—8285 Oak St, Orlando, FL, 328740.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-402805CLMBruce Harper2006-11-25——2021 River Rd # 649, Fresno, CA, 937710.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-418205CLMSharon Fowler1998-12-14—72433457659896 Apache Blvd, Mesa, AZ, 852620.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-429138CLMRoger Lawrence—UHC-53970-063713574526305 Pine Dr, Las Vegas, NV, 891080.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418947CLMBobby Hicks1953-02-05UHC-64037-39—9653 Palm Dr, Glendale, AZ, 853820.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 43 of 657PreviousNext