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-400588CLMAlan L Contreras1939-06-09UHC-96866-71—7196 Bayshore Dr, Tampa, FL, 336270.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-408127CLMRalph Jacobs1973-08-05—3638756339164 Ocean Ave, San Diego, CA, 921680.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420269CLMDiana D Jordan1939-05-18UHC-93994-7732147224159225 Camelback Rd, Atlanta, GA, 303640.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-427389CLMElijah Y Wood1984-09-24UHC-55725-25—3073 Main St, Scottsdale, AZ0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425687CLMAustin B Robertson1968-10-16UHC-45622-0979569575727410 Ocean Ave, Jacksonville, FL, 322220.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427529CLMJanet Dixon1983-02-25UHC-86590-78—6872 Palm Dr, Seattle, WA0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-422243CLMAdam B Young—UHC-88914-95—9456 Mesa Dr, Tempe, AZ, 852770.64Date of birth reformattedDate of birth unreadableMember ID reformattedStreet suffix standardised+2 more
CLM-422242CLMAdam B Young—UHC-88914-95—9456 Mesa Dr, Tempe, AZ, 852770.64Date of birth reformattedDate of birth unreadableMember ID reformattedStreet suffix standardised+2 more
CLM-411181CLMBeverly Wilson—UHC-95133-67—554 Pine Dr, Atlanta, GA, 303490.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-407995CLMRichard P Lucas—UHC-88157-7642157509512532 Oak St, Sacramento, CA, 958890.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-403482CLMNicole Lucas1989-08-13—50656426841029 Elm St, Eden Prairie, MN, 553450.64Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-417133CLMHarold Fuller1967-02-28——189 Grand Ave, Plano, TX, 750460.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-401754CLMPaatrick R Espinoza1996-01-18—2278139119—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-419521CLMPeter Castillo2007-04-06—4918611411237 Canyon Rd, San Antonio, TX, 782860.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410879CLMKnight Ryan1952-11-19UHC-97617-12——0.64Name re-casedDate of birth reformattedPhone missing area codeGender normalised+2 more
CLM-415946CLMJean Wilson1943-03-02UHC-50761-37—3814 Apache Blvd, Jacksonville, FL, 322750.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418314CLMLawrence Daiz1998-01-18UHC-88531-9154570810276361 Lincoln Way, Austin, TX, 787510.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-429567CLMAlexis N Armstrong2004-09-05——9668 Lincoln Way, Scottsdale, AZ, 852120.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420062CLMJames Wilson1998-04-08UHC-29080-5683727029241459 Mesa Dr, Fresno, CA0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420061CLMJames Wilson1998-04-08UHC-29080-5683727029241459 Mesa Dr, Fresno, CA0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420314CLMKathryn Li1941-10-12UHC-88833-99—6691 Ocean Ave, Sacramento, CA, 958250.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-400679CLMEvelyn Brooks1949-05-03UHC-06356-8863547711999160 Forest Ave, Scottsdale, AZ0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408921CLMChristina Gonzales1963-11-26UHC-49127-77—3686 Lake View Rd, Scottsdale, AZ, 852190.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-408726CLMSean Watson1977-07-12——2932 Mesa Dr, Orlando, FL, 328460.64Name re-casedDate of birth reformattedState name converted to codeGender normalised+2 more
CLM-417902CLMAna Fernandez1962-03-06—29378474857415 Sunset Blvd, Orlando, FL, 328040.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-405861CLMHeather Allen1952-07-21UHC-48091-12—9064 Grand Ave, Nashville, TN0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-401587CLMLucia Perkins1968-10-09UHC-64440-21—9799 Washington St, Denver, CO, 802470.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-401588CLMLucia Perkins1968-10-09UHC-64440-21—9799 Washington St, Denver, CO, 802470.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-404074CLMAustin I Rodriguez1994-10-26——9749 Mesa Dr, Mesa, AZ, 852880.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-432392CLMAlan Estrada1981-01-01—58230116573010 Ocean Ave, San Antonio, TX, 782900.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-428116CLMPriya Lopez1947-04-09—20765667956000 Harbor Blvd, Chandler, AZ0.64Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more
CLM-430549CLMRachel Griffin1997-03-14UHC-52956-07—8748 Hillcrest Rd, Atlanta, GA, 303900.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424094CLMNicole Gonzalez1959-04-24UHC-37073-66—1921 Union St, Las Vegas, NV, 891060.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421235CLMVirignia Ray—UHC-17642-309372571397350 Union St, Phoenix, AZ, 850450.64Name re-casedDate of birth unreadablePhone reformattedZIP+4 trimmed+2 more
CLM-428410CLMLuaren K Phillips1966-01-01UHC-19206-41—8819 Sunset Blvd, Seattle, WA, 981770.64Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424652CLMDebra Mendez1960-06-24UHC-40056-84—1756 Cedar Ln Apt 15, Glendale, AZ, 853420.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408674CLMMaiana Z Morrison1960-07-23UHC-48094-2187433438988632 Mesa Dr, Chandler, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-400964CLMBetty Pena1946-08-14——590 Ridge Rd, Jacksonville, FL0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-413927CLMSean Tucker1984-10-08——4906 Sage Ct, Gilbert, AZ, 852630.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-417134CLMAmanda I Taylor1996-10-16UHC-20184-7764335923119588 Ocean Ave, Seattle, WA0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420590CLMEmma A Sanders1948-08-06—22285434476865 Sage Ct, Nashville, TN, 372970.64Date of birth reformattedPhone reformattedCity re-casedState name converted to code+2 more
CLM-408427CLMAlvarado Michael1981-06-25UHC-14405-57—3038 Baseline Rd, Houston, TX, 770540.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407693CLMRyan Ramos1990-12-12UHC-27963-44—1686 Hillcrest Rd, Columbus, OH, 432270.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-427321CLMCharlie Gonzalez1974-07-20UHC-02909-70—559 Desert Sky Blvd, Mesa, AZ, 852950.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400318CLMKeith F Collins1956-11-21UHC-13066-46—9739 Market St Apt 21, Nashville, TN, 372080.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-419891CLMElijah Aadms1968-01-13UHC-50533-10—4148 Highland Ave, Denver, CO0.64Name split from “Last, First”Date of birth reformattedCity re-casedZIP missing+2 more
CLM-419712CLMSean Morgan2005-10-24UHC-75819-92—2936 Canyon Rd, Las Vegas, NV, 891330.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-406713CLMGabriel Carter—UHC-25374-66—7602 Spring St, Scottsdale, AZ, 852820.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-414206CLMHeather Sympson1995-12-01UHC-44129-0770527443714087 Apache Blvd, Plano, TX, 750050.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413510CLMWilliam Folwer1940-08-11——9182 Bayshore Dr, San Diego, CA, 921860.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
32,829 rows, page 133 of 657PreviousNext