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-402987CLMCarolyn Ward2004-03-16—51622976299472 Desert Sky Blvd, Chandler, AZ, 852980.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431283CLMKelly Fowler1942-10-03UHC-70294-5682197492614775 Washington St, Mesa, AZ, 852420.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417954CLMRoger F Arnold2005-06-25UHC-95539-2029257539392065 Lake View Rd # 259, Denver, CO0.62Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+3 more
CLM-414865CLMGregory Ramos1984-08-11UHC-69287-98—843 Harbor Blvd, Nashville, TN, 372020.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412032CLMAaron Luna1942-12-10UHC-83607-5472642059779188 Pine Dr, Chandler, AZ, 852080.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403851CLMLarry Y Arnold1978-01-01—21139563421043 Ocean Ave, Tucson, AZ, 857450.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-413300CLMTeresa Ford2007-08-17—85334560019494 Market St, Gilbert, AZ, 852590.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426181CLMKevin Tucker1951-06-09——1128 Harbor Blvd, Columbus, OH, 432420.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431343CLMKayla Brooks1994-05-18UHC-31508-8927798183874646 Camelback Rd, Seattle, WA, 981380.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-403483CLMBryan Green1995-07-18UHC-72511-86—6662 Camelback Rd, Seattle, WA, 981670.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417985CLMAbigail Owens1964-11-24UHC-36998-88—9000 Valley View Dr, Chandler, AZ0.62Name re-casedCity re-casedZIP missingEmail lower-cased+3 more
CLM-407751CLMChristina Young1946-01-15UHC-65599-8545335441791509 Maple Ave, Denver, CO, 802250.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425514CLMWalter Morrsi1945-08-18—75285523679310 Forest Ave, Las Vegas, NV, 891240.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-423904CLMCamila Bennett1992-08-15—26698954765969 Elm St, Atlanta, GA, 303370.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406868CLMVirginia Caarr1959-09-19—32544514529085 Church St, Dallas, TX, 752830.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406867CLMVirginia Caarr1959-09-19—32544514529085 Church St, Dallas, TX, 752830.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404604CLMPria M Vasquez2002-08-06UHC-73382-0957236855389473 Maple Ave, Plano, TX, 750030.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-429413CLMDylan Russell1950-01-20UHC-68476-272297165281875 Camelback Rd, Fresno, CA, 937950.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-415112CLMMaria Montgomery1962-07-03——1044 Ridge Rd # 872, Phoenix, AZ, 850960.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-417074CLMHannah Williams1972-04-05—68120214937890 Oak St, San Diego, CA0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415493CLMPamela X Santiago1980-12-17UHC-11261-20—3766 Palm Dr Apt 10, Atlanta, GA, 303730.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-430470CLMKathryn Welch1940-12-08—90993401005983 Indian School Rd, Denver, CO0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400881CLMJanet Wright1966-09-20—31531854164019 Maple Ave, Minneapolis, MN, 554150.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418371CLMKenneth Fisher1957-09-07UHC-65531-04—8808 Harbor Blvd, Tucson, AZ, 857450.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407547CLMBruce Sanchez1966-12-13UHC-67947-3994094832069891 Highland Ave, Tempe, AZ, 852160.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421150CLMMatt Marquez1984-02-09UHC-31075-4280573329896565 Maple Ave, Glendale, AZ, 853220.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423573CLMAlbert Rios1958-01-26UHC-29234-9553956575406504 Jefferson Ave, Eden Prairie, MN, 553640.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419261CLMStephen Grant1948-05-25UHC-44427-9490951611962957 Desert Sky Blvd, Las Vegas, NV, 891170.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407013CLMJacob Kim—UHC-18672-9648774896248072 Elm St, Jacksonville, FL, 322910.62Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432491CLMRoger Martinez1990-03-15UHC-40330-5450442559466998 Cedar Ln # 605, Phoenix, AZ, 850490.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412596CLMKathy Brown1994-08-14——3092 Sage Ct, Orlando, FL0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429483CLMStephen King1968-01-20—21997798715493 Meadow Ln, Los Angeles, CA, 900190.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-412656CLMElizabeth N Chapman1944-12-23—86769775432615 Ridge Rd, San Antonio, TX, 782120.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421692CLMJudy J Henderson1973-01-23UHC-53252-6987531614294191 Ridge Rd, Eden Prairie, MN, 553540.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-404550CLMAndrew D Freeman1959-01-14UHC-02052-0135592115104715 Palm Dr, Tucson, AZ, 857720.62Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425476CLMBoby Chen2003-07-10—80829701227936 Pine Dr, San Antonio, TX, 782100.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403128CLMCharlotte Gray1975-04-20——7259 Camelback Rd, Tucson, AZ, 857090.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413812CLMRyan Johnson1997-09-28UHC-89836-1785763618533038 Desert Sky Blvd, Tempe, AZ, 852100.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-400352CLMMason Kyle—UHC-92667-2994138048329092 Park Pl, Orlando, FL, 328880.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-422026CLMCynthia D Jenkinns1996-07-15UHC-84353-34—3297 Ridge Rd, San Antonio, TX, 782540.62Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403126CLMNicholas Carter1938-12-23UHC-84056-95—8213 Apache Blvd # 759, Orlando, FL, 328430.62Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-431674CLMSophia Jacobs1941-04-15UHC-74205-2424731066648862 Bayshore Dr, Mesa, AZ, 852090.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-427508CLMBrian Matthews1964-09-19—26431648956673 Meadow Ln, Miami, FL, 331320.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400090CLMMark Z Burke1994-05-26UHC-86223-27—4572 Forest Ave, Nashville, TN, 372890.62Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422068CLMFatima Thomas1960-03-25UHC-12199-64—9534 Sage Ct, Scottsdale, AZ, 852290.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417973CLMChristian Jenkins1987-10-28—85398461894808 Cedar Ln, Nashville, TN, 372700.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411749CLMSean Price1983-08-27UHC-80429-8669131469488150 Harbor Blvd, Glendale, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410817CLMStephen Graham1938-09-27——3890 Jefferson Ave # 234, Houston, TX, 770240.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-407877CLMSamantha Elliott1975-08-03UHC-46587-22—5177 Highland Ave, Scottsdale, AZ, 852230.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429771CLMJean Aguilar1964-03-15—78283147234645 Sunset Blvd, Seattle, WA, 981080.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 88 of 657PreviousNext