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-417528CLMAilce Griffin1973-02-01UHC-73266-954854263168393 Park Pl, Denver, CO0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-414947CLMDonna Austin1956-02-08UHC-08695-42—3198 Maple Ave, Fresno, CA, 937840.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-405030CLMChristopher Cunningham1946-04-04—29566300653285 River Rd, Charlotte, NC0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410460CLMZachary Green1978-02-02—35082878552091 Willow Ct, San Diego, CA, 921340.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401976CLMEvelyn Lee2007-02-22UHC-62339-8370133849677247 River Rd, Nashville, TN, 372930.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-407017CLMDavid G Henry1964-01-25UHC-48679-36—4431 Harbor Blvd, Charlotte, NC, 282020.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410441CLMAmy Yang2002-08-10—47357489301529 Market St, Fresno, CA, 937610.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416243CLMJoyce Hanson1944-01-14——2684 Grand Ave, Plano, TX, 750620.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422610CLMCarlos Williiamson1977-07-01UHC-61358-7270751079745335 Highland Ave, Tempe, AZ, 852420.64Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
CLM-424880CLMMason Price1971-09-26UHC-45042-0671247017902697 Hillcrest Rd Apt 39, Charlotte, NC, 282310.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-401456CLMTeresa C Hill1990-08-22UHC-82145-43—8639 Meadow Ln, Seattle, WA, 981780.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427796CLMChristina Estarda1969-02-07—25757431925680 Canyon Rd, Nashville, TN, 372010.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-431994CLMSarah J Long1993-01-20UHC-42321-4231531434256140 Camelback Rd # 151, Houston, TX, 770630.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-429280CLMChristine Hughes1964-05-10UHC-27448-5531128407993921 Bayshore Dr, Orlando, FL, 328930.64Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+2 more
CLM-407214CLMKimberly Munoz2007-12-22——5212 Spring St, Jacksonville, FL, 322370.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-429216CLMJohn Moore1996-04-11UHC-80866-83—3523 Market St, Sacramento, CA, 958630.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-425060CLMDebra Schmidt1941-08-21UHC-39182-5267851290371984 Jefferson Ave, Tempe, AZ, 852320.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428539CLMIsabella Murphy1957-02-06UHC-81397-5322264767671338 Central Ave, Columbus, OH, 432980.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416175CLMRebecca B Collins1972-06-13UHC-41980-63—7226 Maple Ave # 130, Houston, TX, 770760.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-402038CLMThoams Chavez1958-01-21UHC-08205-9363969103346626 Market St, Miami, FL, 331990.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-403491CLMMartha G Day1986-10-03—68680630494026 Mesa Dr, Nashville, TN, 372150.64Middle initial moved out of first namePhone reformattedGender normalisedPlan code upper-cased+2 more
CLM-409305CLMLori V Ellis2005-08-15UHC-21885-66—5821 Union St, Orlando, FL, 328790.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-411237CLMJoyce Spencer1948-01-17—97123809335919 Broadway # 624, Sacramento, CA, 958000.64Name split from “Last, First”Phone reformattedUnit split from streetAddress re-cased+2 more
CLM-428914CLMEmma M Rodriguez1977-10-28——8610 Church St, Tempe, AZ, 852210.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413969CLMMaria Young1981-05-21UHC-57966-6377476038134044 Maple Ave, Charlotte, NC, 282150.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-402343CLMBrandon W Russell1988-12-24UHC-06169-413012852333—0.64Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+2 more
CLM-403634CLMHenry Marshaall1954-10-23—65873319208683 Forest Ave, Orlando, FL, 328730.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-408098CLMRyan Richards1980-05-09UHC-91216-27—8087 Mesa Dr, Seattle, WA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-408872CLMMaria Ortiz1961-08-02——1527 Park Pl, Nashville, TN, 372220.64Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-432698CLMRachel Adams1939-03-26UHC-34375-78—5892 Oak St, Tucson, AZ, 857240.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-432699CLMRachel Adams1939-03-26UHC-34375-78—5892 Oak St, Tucson, AZ, 857240.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-413030CLMLarry Garcia1966-06-25UHC-28303-69—5239 Jefferson Ave, Tempe, AZ, 852070.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-411962CLMDavid R Bishup1973-10-26UHC-19805-3294762028631186 Harbor Blvd, Seattle, WA, 981170.64Middle initial moved out of first nameName re-casedPhone reformattedGender normalised+2 more
CLM-416833CLMKatherine Walsh1950-09-28UHC-91901-697788921266356 River Rd, Charlotte, NC, 282540.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429352CLMJeremy Dunn1989-07-21—81747697078291 Maple Ave, Houston, TX, 770800.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412623CLMVincent George1996-04-01—40122944191886 Market St, Miami, FL0.64Name re-casedTwo-digit birth yearPhone reformattedZIP missing+2 more
CLM-432691CLMSue Hart1938-10-02UHC-24309-1935560063182889 Maple Ave, Fresno, CA, 937960.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-429391CLMEmily Roberts1955-07-11—95652869356341 Meadow Ln, Tucson, AZ, 857450.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407185CLMEdward Watkins2001-10-19UHC-04151-6497059597921525 Desert Sky Blvd # 383, Dallas, TX, 752750.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-401017CLMMelissa M Moreno2000-09-17—57495015267186 Lake View Rd # 207, Chandler, AZ, 852070.64Name re-casedDate of birth reformattedUnit split from streetState name converted to code+2 more
CLM-414371CLMSaa Harper1994-03-15UHC-71898-36—9413 Meadow Ln, San Diego, CA, 921220.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-421466CLMKaren Foster1992-04-04—68453936156582 Pine Dr, Fresno, CA, 937120.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403569CLMDennis Larson1965-09-05—5948665211290 Camelback Rd, Charlotte, NC, 282720.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408325CLMLary R Jones—UHC-94064-39—6613 Jefferson Ave, Plano, TX, 750890.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-430434CLMKathleen Moore1989-12-27UHC-75963-2943399763906354 Sage Ct, San Diego, CA, 921090.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429634CLMGabriel Watson1940-07-08UHC-73072-51—2560 Central Ave, Tucson, AZ, 857790.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-416644CLMSusan Howadr1985-08-06UHC-50641-0147849119316781 Forest Ave, Phoenix, AZ, 850590.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431814CLMDiana Salazar2001-02-17UHC-69415-5493755748209622 Desert Sky Blvd, Sacramento, CA, 958840.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401414CLMNathan Montgomery2000-04-18UHC-06179-3697955008801072 Pine Dr, Phoenix, AZ, 850530.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428285CLMJessica Y Carroll——50333315049859 Sage Ct, Jacksonville, FL, 322060.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 147 of 657PreviousNext