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-416456CLMHenry Duncan1948-07-01UHC-37120-86—7478 Oak St, Phoenix, AZ, 850250.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-405869CLMRalph R Williamson1987-07-26UHC-12735-84—1667 Palm Dr, Scottsdale, AZ, 852540.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-405870CLMRalph R Williamson1987-07-26UHC-12735-84—1667 Palm Dr, Scottsdale, AZ, 852540.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-408257CLMWayne Franklin1967-01-01——8723 Baseline Rd, Tempe, AZ, 852520.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425281CLMSusan Adams1989-09-14UHC-28024-94—1582 Lake View Rd, Tampa, FL, 336440.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-404213CLMKevin Baker2001-01-12UHC-06930-2789668714869150 Church St, Jacksonville, FL, 322250.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-412543CLMMelissa R Rivera1960-04-26UHC-44304-8841593074522772 Park Pl, Atlanta, GA0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417650CLMJacob Walker1998-02-27UHC-50958-96—2767 Highland Ave, Scottsdale, AZ, 852500.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400300CLMWayne Anderson1962-01-16UHC-02479-04—3004 Main St, Denver, CO, 802620.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-400299CLMWayne Anderson1962-01-16UHC-02479-04—3004 Main St, Denver, CO, 802620.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427340CLMBrian Adams1954-04-02—78574307254847 Ridge Rd # 639, Minneapolis, MN, 554700.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-407671CLMChris Diaz1940-11-27UHC-69730-93—3368 Oak St, Mesa, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-419683CLMDorothy Lawrence1966-04-11——1167 Canyon Rd, Los Angeles, CA, 900870.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413144CLMChristina V Carter1943-10-03UHC-20494-29—6427 Pine Dr, Scottsdale, AZ, 852660.64Name split from “Last, First”Date of birth reformattedCity re-casedZIP+4 trimmed+2 more
CLM-405479CLMMei Watkins1986-04-13——2223 Apache Blvd, Chandler, AZ, 852620.64Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+2 more
CLM-429684CLMDonald Carr2007-07-24UHC-61234-06—3247 Valley View Dr, Atlanta, GA, 303130.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429683CLMDonald Carr2007-07-24UHC-61234-06—3247 Valley View Dr, Atlanta, GA, 303130.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416549CLMHenry K Wlker1949-05-17UHC-07090-4279671681179002 Oak St, Sacramento, CA, 958230.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-416878CLMJake Little1974-07-12UHC-14867-13—2649 Indian School Rd, Houston, TX, 770230.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-417578CLMAngela P Hamilton1960-09-08UHC-96995-64—1326 Valley View Dr, Houston, TX, 770960.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-425451CLMRay Grant1957-06-21—52540958999859 Elm St, Miami, FL, 331700.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406966CLMLaura Burke1972-11-18——5085 Market St, Seattle, WA, 981850.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-431001CLMJudy D Oliver1939-04-05UHC-16714-1560755648459763 Harbor Blvd, Plano, TX, 750890.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-431426CLMLucia Fooster1941-02-06——9138 Lincoln Way, Las Vegas, NV, 891270.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-409038CLMAlbert Hicks2008-09-12—80726771516396 Sage Ct, Sacramento, CA, 958980.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420068CLMLauren Kelly2003-11-07UHC-96244-6428792918101212 Hillcrest Rd, Chandler, AZ, 852400.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408534CLMBilly K Rice1949-02-24——3279 Lake View Rd, Miami, FL, 331830.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406972CLMMargaret Anderson1995-02-21UHC-40281-8473122640544717 Jefferson Ave # 351, Miami, FL, 331430.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425536CLMBeverly K Cunningham1961-03-23—43171462115678 Meadow Ln, Miami, FL, 331730.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408585CLMDoris West1939-12-09——9597 Camelback Rd, Tempe, AZ, 852590.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423100CLMArthur Jimenez2001-02-01UHC-75581-43—4586 Lake View Rd, Eden Prairie, MN, 553420.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-406653CLMKayla N Chapman1951-09-02UHC-86296-21—4741 Hillcrest Rd, Los Angeles, CA, 900230.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-400685CLMArthur R Hunt1994-12-18UHC-77473-21—9247 Sage Ct, Nashville, TN, 372690.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-411794CLMCheryl Li1995-05-19—27932932152801 Apache Blvd, Scottsdale, AZ, 852620.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-418343CLMCarol Kelly1939-10-17UHC-09522-48—1796 Maple Ave, Seattle, WA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-430809CLMJordan P Evans1991-12-13UHC-87973-5748867985626438 Sage Ct, Columbus, OH, 432560.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406021CLMNicholas Gomez1984-01-17UHC-98466-9797242287302392 Willow Ct, Chandler, AZ, 852780.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401949CLMRachel Duncan1956-12-06UHC-69533-344463054175696 Sage Ct, Los Angeles, CA, 900160.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410182CLMCheryl Murray2004-09-04UHC-17856-63—8800 Union St, Nashville, TN, 372930.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-422376CLMKathleen Santos1950-10-05UHC-55877-6923792024418956 Grand Ave, Atlanta, GA, 303980.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-404198CLMChristine Knight1999-07-12——2960 Valley View Dr, Tampa, FL, 336320.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415651CLMJoshua Harris1945-03-05—83423915167597 Hillcrest Rd, Dallas, TX, 752700.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-401867CLMDennis Henderson2006-02-18UHC-96738-49—9816 Washington St, Fresno, CA, 937910.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-400046CLMOlivia Mejia1996-01-27UHC-99227-1162488943521802 Forest Ave, Atlanta, GA, 303890.64Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-423845CLMNicole Mejia1962-05-14UHC-35763-47—3685 Baseline Rd, Minneapolis, MN, 554690.64Name re-casedDate of birth reformattedZIP+4 trimmedGender normalised+2 more
CLM-431927CLMIsabella White1963-09-10——9080 Canyon Rd, Tampa, FL, 336360.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-400929CLMJohn Taylor1971-08-28UHC-19378-10—8613 Washington St, Atlanta, GA, 303740.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-421663CLMBenjamin Wong1948-10-12UHC-60828-1734059705651782 Pine Dr # 137, Mesa, AZ, 852170.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408920CLMAlexis Lane1966-10-02UHC-83946-953509547239—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-426574CLMJoyce Wells1988-11-18——3694 Sage Ct, Dallas, TX, 752150.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
32,829 rows, page 112 of 657PreviousNext