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-419154CLMTerry Fernandez1985-03-27UHC-26247-59—6649 Grand Ave, Jacksonville, FL, 322500.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-430361CLMMariana Garrett2003-11-15——6949 Sunset Blvd Apt 4, Mesa, AZ, 852580.52Two-digit birth yearUnit split from streetCity re-casedGender normalised+2 more
CLM-420883CLMPaul Bennett1970-06-17UHC-74898-509694094238—0.52Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+2 more
CLM-416750CLMJordan Fisher1949-10-12UHC-55830-11—7641 Mesa Dr, Denver, CO0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-421895CLMEthan L Jackson—UHC-62313-89—801 Main St, San Antonio, TX, 782690.52Date of birth missingStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411977CLMFrank Castillo2005-01-02——3298 Jefferson Ave, Miami, FL, 331290.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-425348CLMDot Patterson———3384 Cedar Ln, Nashville, TN, 372660.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-410789CLMDeborah McDonald1956-04-26——361 Palm Dr, Orlando, FL, 328970.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-426690CLMCarl Ray1963-08-05UHC-21904-36—1930 Harbor Blvd # 457, Mesa, AZ, 852080.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426643CLMNancy Richards1948-06-12UHC-93715-4981295667028910 Mountain View Dr Apt 19, Dallas, TX, 752340.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-423665CLMJanice A Banks1964-06-22——7977 Elm St, Orlando, FL, 328470.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413335CLMDouglas T Henderson1997-01-10UHC-07476-51—1129 Market St, Eden Prairie, MN0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-425086CLMJoan Z Bennett1943-02-10UHC-27960-11—6070 Union St, San Diego, CA, 921460.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431215CLMSophia Daniels1983-05-06——9788 Jefferson Ave, Denver, CO, 802750.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431174CLMVirginia Fernandez1973-06-03UHC-33328-148542792861—0.52Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+2 more
CLM-412575CLMJoe Ford———1902 Highland Ave, Chandler, AZ, 852010.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-414974CLMKeith Vasquez2000-09-04UHC-43961-56—5742 Maple Ave, Columbus, OH, 432990.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-419817CLMDoris Elliott1948-06-26——7824 Lake View Rd, Chandler, AZ, 852220.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431450CLMAnna Weaver1965-12-26——400 Forest Ave, Scottsdale, AZ, 852210.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-417167CLMMatthew Williamson1955-12-05——4340 Harbor Blvd, Houston, TX, 770520.52Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-408569CLMTimothy Obrien1994-05-22UHC-68603-349698669011631 Sunset Blvd, Mesa, AZ, 852320.52Name split from “Last, First”Name re-casedPhone reformattedStreet suffix standardised+2 more
CLM-418417CLMRyan L Hunter1965-10-05UHC-48235-63—7479 Forest Ave Apt 28, Charlotte, NC, 282090.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430864CLMDonna Lucas1972-08-05UHC-67714-8435496133612603 Camelback Rd, Sacramento, CA, 958310.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423035CLMCamila J Guerrero1977-02-06——3791 Ridge Rd, Charlotte, NC, 282180.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420489CLMAbigail Peters——41453092938838 Elm St, Atlanta, GA, 303730.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404361CLMIsabella Burns1948-08-20UHC-10907-04—709 Mountain View Dr, Atlanta, GA, 303970.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426785CLMAngela Ellis1949-03-02UHC-75200-9344637625832733 Baseline Rd # 743, Tampa, FL, 336900.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-419717CLMAmber Bradlye1985-11-09UHC-76447-81399719962661 Market St, Houston, TX, 770430.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-410623CLMKeith Campbell1962-05-19UHC-28637-30—5441 Meadow Ln # 306, Nashville, TN, 372340.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-417947CLMKevin Cunningham1962-09-09UHC-16646-6526089730939629 Cedar Ln, Gilbert, AZ, 852640.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-407965CLMCharlotte I Welch1957-01-17UHC-68577-0240467509212334 Lake View Rd, Houston, TX, 770110.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432005CLMVirginia Gordon1975-11-08UHC-62470-62—3974 Willow Ct, Gilbert, AZ, 852450.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-426477CLMGregory Day1959-02-20—5348763142195 Meadow Ln, Charlotte, NC, 282660.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-428242CLMAlice Cruz1939-01-08UHC-28830-68—4350 Meadow Ln Apt 20, Houston, TX, 770290.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430980CLMKaren Thomas2005-11-05UHC-47494-97—6718 Mesa Dr, Houston, TX, 770820.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402281CLMHiroshi N Kelley1977-12-16UHC-89921-68—1459 Jefferson Ave, Miami, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-415201CLMEmily X Contreras1984-11-12——1247 Baseline Rd, San Antonio, TX, 782200.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-416497CLMAisha Gibson1941-12-19—87736347953743 Church St Apt 19, Atlanta, GA, 303590.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-400082CLMFatima Lynch2001-08-22UHC-78829-5935186822317675 Harbor Blvd, Columbus, OH0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-402691CLMLarry Myes1944-11-25UHC-51103-97—4345 Maple Ave, Houston, TX, 770100.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-425106CLMMartha Dixon2007-02-09UHC-86777-89—8595 Desert Sky Blvd, Houston, TX, 770740.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-413431CLMGabriel Gray1962-05-03UHC-31656-924787614161868 Sage Ct, Columbus, OH, 432660.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403424CLMGrace I Robertson1940-03-22UHC-83130-165547331813101 Sunset Blvd, Las Vegas, NV, 891580.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-408687CLMEvelyn Ramos1970-12-02UHC-77500-44—330 Baseline Rd, Orlando, FL, 328320.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-431278CLMNicholas Marshall1955-12-11UHC-05205-986498532301779 Elm St, Atlanta, GA, 303360.52Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
CLM-430251CLMAshley Q Mejia1969-02-05UHC-53643-77—4736 Desert Sky Blvd, Scottsdale, AZ, 852860.52Name re-casedPhone missing area codeZIP+4 trimmedGender normalised+2 more
CLM-424266CLMJess Dominguez1987-06-07UHC-00531-6071865100016559 Indian School Rd, San Antonio, TX, 782390.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411506CLMElijah Hudson1984-08-09UHC-86992-5594051491757178 Desert Sky Blvd, Charlotte, NC0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-420872CLMDonna Cook1978-02-12—87987082986955 Maple Ave # 791, Scottsdale, AZ, 852560.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-421086CLMPatrickJunk1992-05-21UHC-25254-36—1167 Cedar Ln, Columbus, OH, 432610.52Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+2 more
32,829 rows, page 45 of 657PreviousNext