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-405700CLMMichael Owens1940-08-19UHC-07421-1641084837873292 Valley View Dr Apt 14, Austin, TX, 787730.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-409966CLMHenry Espinoza1959-07-26UHC-08632-9435467014321745 Church St, Austin, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412163CLMDeborha Harper1973-09-28UHC-63588-9832470122154799 River Rd, Charlotte, NC, 282910.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-401733CLMNichols Cynthia1963-03-16UHC-36208-79—7549 Main St, Mesa, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430654CLMSandra M McCoy1999-11-15—26881838772098 Camelback Rd, Scottsdale, AZ, 852820.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431907CLMMelissa B Hudson2007-09-06—51383677971746 Grand Ave, Gilbert, AZ, 852100.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-402744CLMDiane Foster2006-03-08—52459608824393 Jefferson Ave, Austin, TX, 787680.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401977CLMCharles R Jackson1947-09-05—3633231835—0.62Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+3 more
CLM-416915CLMJoe Harvey1996-02-27UHC-44826-0350838980798728 Indian School Rd, Columbus, OH, 432960.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406805CLMAhmed Davis2003-01-10UHC-86559-68—9045 Mesa Dr, Eden Prairie, MN, 553000.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400872CLMFatima E Nguyen1984-03-14UHC-77642-95—2819 Palm Dr, Houston, TX, 770800.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429418CLMDiana J Clark1992-05-04UHC-38721-4391956978838490 Lincoln Way, Las Vegas, NV, 891140.62Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+3 more
CLM-425426CLMBarbara Park1982-05-01UHC-16638-84—4177 Pine Dr, Scottsdale, AZ, 852240.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429880CLMJuile Pena1994-12-14UHC-64751-1982964318399289 Ridge Rd, Atlanta, GA, 303090.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413440CLMBruce Garza1971-02-23—21083128452756 Ocean Ave, Miami, FL, 331130.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-431948CLMKimberly Ferguson—UHC-50163-5027293435769024 Mesa Dr, Scottsdale, AZ, 852470.62Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411756CLMSofia Weaaver1968-01-17UHC-57114-2995734906828340 Spring St, Glendale, AZ, 853100.62Name re-casedPhone reformattedMember ID reformattedZIP+4 trimmed+3 more
CLM-419566CLMGerald Willis1957-08-12UHC-23329-03—7465 Church St, Houston, TX, 770080.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407669CLMKevin Scott1977-09-05UHC-95333-52—6262 Apache Blvd, Columbus, OH, 432160.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403025CLMJordan F Gardner1969-10-17UHC-58120-6052160987759683 Forest Ave Apt 7, Fresno, CA, 937410.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-429507CLMDouglas Alvarado2000-03-27UHC-27382-79—1453 Indian School Rd Apt 2, Jacksonville, FL, 322530.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-425369CLMJuan Graham1937-06-16—88198769064334 Harbor Blvd, Fresno, CA, 937330.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415054CLMAngela Sullivan2002-10-25——2017 Desert Sky Blvd, Tucson, AZ, 857830.62Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more
CLM-413711CLMHeather Perez1961-11-18UHC-55402-81—3546 Ridge Rd # 623, Chandler, AZ, 852090.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413710CLMHeather Perez1961-11-18UHC-55402-81—3546 Ridge Rd # 623, Chandler, AZ, 852090.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402676CLMWJunk1993-02-22UHC-11771-60—3287 Bayshore Dr, Orlando, FL, 328870.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427022CLMNatalie Cruz2001-08-03——1185 Desert Sky Blvd, Charlotte, NC, 282000.62Street suffix standardisedAddress re-casedState code upper-casedGender normalised+3 more
CLM-430420CLMDennis Nelson1992-09-02UHC-45196-98—8076 Valley View Dr, Scottsdale, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421877CLMMaria Simpson2008-12-22UHC-29411-6634394943076926 Union St, Tempe, AZ, 852280.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424192CLMRebecca T Aguilar1952-05-09—76947675158664 Cedar Ln, Seattle, WA, 981670.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424545CLMMichael Gutierrez1953-06-19UHC-45944-0462646099075232 Willow Ct, Sacramento, CA, 958270.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-429182CLMMegan Richardson1959-05-13—94091385872569 Indian School Rd, Orlando, FL, 328550.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-426315CLMAlex Young1952-05-28UHC-08174-2249020036565866 Main St, Plano, TX0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-430267CLMAnna Knight1952-02-05UHC-17139-804494658264523 Valley View Dr, Sacramento, CA, 958660.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-408790CLMBobby Robinson1943-11-27UHC-17176-3438656676269401 Highland Ave, Atlanta, GA, 303090.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403201CLMJoyce Hunt1983-08-26UHC-86921-2024771129062307 Sage Ct, Phoenix, AZ, 850690.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-404637CLMSophia Howell1997-04-28UHC-51733-01—2377 Apache Blvd, San Diego, CA, 921440.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-417616CLMBobby Campbell1954-09-06—69527445652686 Church St, Phoenix, AZ, 850540.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422913CLMKayla Mills2007-04-02—88678569193905 Apache Blvd Apt 23, Miami, FL, 331310.64Name re-casedPhone reformattedUnit split from streetGender normalised+2 more
CLM-405076CLMPatty V Grant1962-11-13UHC-86096-7431774523902725 Hillcrest Rd, Mesa, AZ, 852640.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-425227CLMBenjamin O Martin—UHC-36994-1165574411886483 Union St, Tempe, AZ, 852530.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412947CLMKyle Phillips1999-01-04UHC-66079-97—2516 Harbor Blvd, Austin, TX0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-417243CLMJoyce Santiago2000-08-25——832 Highland Ave, Los Angeles, CA, 900080.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-420938CLMJuudith Soto1995-03-06—7712855888580 Jefferson Ave, San Antonio, TX, 782240.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427624CLMAmber Lee2004-04-08UHC-32742-9153626515595091 Church St, Sacramento, CA, 958830.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431309CLMKeith Herrera1976-08-18—5636249105740 Broadway, Los Angeles, CA, 900520.64Phone reformattedCity re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-415517CLMJason Rios2008-12-12UHC-15718-04—3062 Grand Ave, Chandler, AZ, 852160.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-406894CLMBrandon Stephens1981-06-27—33681996212701 Mesa Dr, Tempe, AZ, 852400.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416096CLMSandra Mason1954-04-28—3903756414862 Maple Ave, Mesa, AZ, 852550.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430083CLMHannah Howell1938-12-24UHC-33142-04—550 Palm Dr, Plano, TX, 750330.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 103 of 657PreviousNext