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-426096CLMDanielle Schultz1941-07-01UHC-73966-9495959068717494 Union St, Eden Prairie, MN, 553020.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402454CLMMiller Kellly—UHC-25101-7078465639198861 Sage Ct, Plano, TX, 750730.64Name re-casedDate of birth missingMember ID reformattedStreet suffix standardised+2 more
CLM-420374CLMNatalie Fields1991-03-02UHC-40274-7693935770988410 Desert Sky Blvd, Tucson, AZ, 857200.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413041CLMJeremy Snyder1988-04-05—4686701391106 Washington St, Denver, CO, 802720.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-415974CLMChritina Bishop1975-04-27——2857 Bayshore Dr, Phoenix, AZ, 850090.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-425872CLMAustin V Evans1974-06-26UHC-08309-61—6408 Camelback Rd # 987, Houston, TX, 770680.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-411704CLMHenry Zachary1967-10-27—56064210924745 Palm Dr, Glendale, AZ, 853310.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419058CLMRoger Palmer1996-09-07UHC-52177-1921423862768924 Sage Ct, Nashville, TN, 372510.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428398CLMHeather Castillo1970-03-18——6411 Main St, Scottsdale, AZ, 852550.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-403820CLMMiller F Gerald1983-04-03UHC-84890-9585063317603450 Maple Ave, Denver, CO, 802180.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429991CLMArthur Nichols1942-09-26UHC-48023-8995579254991576 Mountain View Dr # 863, Columbus, OH, 432080.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-411728CLMAlice Freeman1968-04-04UHC-80293-6387389383976953 Pine Dr, Fresno, CA, 937890.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414779CLMScott D Bryant1972-08-07UHC-95355-1339435881502176 Broadway Apt 23, San Antonio, TX, 782000.64Name split from “Last, First”Phone reformattedUnit split from streetAddress re-cased+2 more
CLM-413443CLMHelen Luna1977-05-07—71496811182528 Pine Dr, Tempe, AZ, 852260.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-418513CLMBruce Jones1974-06-19UHC-24551-8445388085996757 Church St Apt 23, Gilbert, AZ, 852540.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-418067CLMDouglas E Collins1941-10-14UHC-00437-78—446 Baseline Rd, Tempe, AZ, 852110.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424462CLMSara Oliver1957-09-03—70558708079299 Highland Ave, Scottsdale, AZ, 852680.64Date of birth reformattedPhone reformattedState name converted to codeGender normalised+2 more
CLM-427262CLMJakk Freeman1946-07-23—70474469232736 Lake View Rd, San Antonio, TX, 782940.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402261CLMSofia Day1938-07-28UHC-43857-58—2714 Ocean Ave, Chandler, AZ, 852450.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-418785CLMKathryn Collins1973-12-27UHC-56200-3938564576171909 Canyon Rd, Denver, CO, 802500.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-413536CLMBetty Bennett1972-12-08UHC-09862-50—1451 Main St, Tampa, FL, 336050.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415527CLMMean A Rios1976-08-25UHC-68589-6493482438023996 Sage Ct, Denver, CO0.64Member ID reformattedCity re-casedZIP missingGender normalised+2 more
CLM-418665CLMGary Brown1950-01-24UHC-63458-0145884767315247 Jefferson Ave, Tucson, AZ, 857890.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415785CLMAlbert Daniels1952-03-03UHC-27627-557882228939—0.64Name re-casedPhone reformattedSSN last four extractedEmail lower-cased+2 more
CLM-428514CLMJulia O Ortega1949-04-12UHC-48319-9621923617262489 Camelback Rd Apt 20, Orlando, FL, 328740.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-415164CLMTerry Peterson1940-03-22UHC-56448-4978266113223240 Apache Blvd, Los Angeles, CA, 900660.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425245CLMArthur Greene1942-11-16UHC-13551-49—4951 Canyon Rd, Los Angeles, CA, 900850.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-421753CLMLinda Johnson1994-09-18——3980 Baseline Rd, Columbus, OH, 432150.64Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more
CLM-423169CLMBrandon B Long1963-11-17UHC-49927-34—6600 Ocean Ave, Tampa, FL, 336490.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420275CLMJesse C Perkins1939-08-23UHC-21132-90—2291 Market St, Glendale, AZ0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415547CLMCarol W Guzman2008-10-12—97899613473432 Grand Ave, Plano, TX, 750030.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422767CLMJoe Obrien1938-06-20——832 Oak St, Jacksonville, FL, 322880.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405676CLMMari Hanzen1983-11-28UHC-89653-21—9210 Sage Ct, Tempe, AZ, 852920.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-401350CLMJames P Weaver1945-03-05UHC-45993-0889645673857387 Bayshore Dr, Nashville, TN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-408447CLMJoshua T Walsh1988-08-25UHC-33244-9238347866483529 Union St, Eden Prairie, MN, 553490.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405024CLMWillie Cole1985-09-21UHC-94020-81—1476 Sunset Blvd, Nashville, TN, 372960.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-410292CLMKimberly Lopez———8071 Church St, Phoenix, AZ0.64Name re-casedDate of birth missingCity re-casedZIP missing+2 more
CLM-409686CLMIsabella F Sandoval1960-09-25UHC-55384-75—3929 Mountain View Dr, Los Angeles, CA, 900730.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-420700CLMDonna Guerrero1993-09-18UHC-56642-68—5282 Main St, Charlotte, NC, 282040.64Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-405093CLMValentina J Alvarado1954-06-20—24946033632353 Palm Dr, Orlando, FL, 328310.64Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
CLM-409936CLMLori T Ward1965-06-23UHC-57208-3053172121505185 Maple Ave, Denver, CO, 802710.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405371CLMDanielle Ellis1990-10-07—43361290165780 Meadow Ln, Sacramento, CA, 958250.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-420858CLMIsabella Yang1991-12-21UHC-46102-0535690972206288 Highland Ave # 427, Tempe, AZ, 852300.64Phone reformattedMember ID reformattedUnit split from streetZIP+4 trimmed+2 more
CLM-417624CLMJennifer Hicks1977-06-28UHC-17473-4439624820759182 Ridge Rd, Tempe, AZ, 852260.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420456CLMJennifer Watkins——31467200421753 Baseline Rd, Glendale, AZ, 853600.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420277CLMMaria H Carter1941-07-21UHC-99707-79—4284 Pine Dr, Gilbert, AZ, 852970.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-420278CLMMaria H Carter1941-07-21UHC-99707-79—4284 Pine Dr, Gilbert, AZ, 852970.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-410341CLMMegaan Z Olson1945-12-08UHC-31741-46—3348 Ridge Rd, Los Angeles, CA, 900970.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-411292CLMJuan Watkins1978-02-27——9150 Sage Ct, Seattle, WA, 981060.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-417984CLMChristine C Delgado1941-08-20—42091252136732 Elm St, Jacksonville, FL, 322370.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 128 of 657PreviousNext