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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-415752CLMDennis Watkins1994-06-21UHC-26047-788268386135—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-411471CLMAlice Simpson2004-09-19UHC-94887-7825872468382454 Spring St, Sacramento, CA, 958250.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-424560CLMBruce Burke1979-08-05UHC-27034-47——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-405845CLMJessica Rogers1941-09-24UHC-93976-9946568743563358 Central Ave, San Diego, CA, 921980.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-415460CLMMadison Padilla1968-11-07UHC-93662-76—6184 Ridge Rd, Miami, FL, 331780.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-417196CLMAmber Harvey1998-10-18UHC-45573-36—6154 Main St, Dallas, TX, 752750.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-410721CLMJose Munoz1982-11-23——4377 Jefferson Ave, Atlanta, GA, 303370.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-424530CLMCynthia Washington1945-04-24UHC-73781-5535835233896260 Harbor Blvd, Tucson, AZ, 857220.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-400578CLMBobby S Luna1977-04-22UHC-10718-284222340620—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-419887CLMBrian Walsh1969-11-11——83 Lincoln Way, Houston, TX, 770960.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-406544CLMMke Jurdan2000-11-24UHC-94325-832125125878—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-413305CLMLisa Hicks1984-01-14UHC-45936-13——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-403971CLMKenneth Z Tucker1947-04-12—2384297613—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-403912CLMAlbert Marshall1938-08-12UHC-66758-20—1431 Ocean Ave, San Diego, CA, 921300.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-413901CLMJustin A Johnson2003-07-03UHC-07622-056656228532—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-427973CLMChristopher V Obrien1982-05-11——5265 Central Ave, Atlanta, GA, 303320.80Name split from “Last, First”Name re-casedWhitespace trimmedPlaceholder values cleared
CLM-429817CLMJacob Gomez1976-07-10UHC-45306-71—6461 Valley View Dr, Atlanta, GA, 303800.80Name split from “Last, First”Date of birth reformattedPlan code upper-casedPlaceholder values cleared
CLM-410531CLMRuth R Myers1991-05-07UHC-99379-708999592196—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-420424CLMMason Sanchez1953-01-04UHC-38791-85—1884 Forest Ave, San Antonio, TX, 782780.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-403274CLMBrandon C Pierce1995-12-09UHC-26578-788164806498—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-404692CLMMargaret Miller1941-01-12UHC-71305-12—8565 Church St, Gilbert, AZ, 852620.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-405251CLMRandy Nichols2004-09-25———0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
CLM-410742CLMGregory Q Hudson1954-02-04UHC-41204-8653563688208058 Main St, Nashville, TN, 372620.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-431982CLMSantiago G Pena1975-07-25UHC-63606-39——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409321CLMAnn Obrien1945-12-04———0.80Name split from “Last, First”Name re-casedWhitespace trimmedPlaceholder values cleared
CLM-415680CLMShirley B Chavez1956-05-14———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-432510CLMSusan Perez1938-06-23——8072 Sage Ct, Chandler, AZ, 852390.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409860CLMChristian Lynch1948-12-03UHC-37248-012349623799—0.80Name split from “Last, First”Phone reformattedPlan code upper-casedPlaceholder values cleared
CLM-411591CLMLawrence Mejia1964-12-23—9603319548—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-400782CLMFatima Cook1975-03-18—7284883863—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-404214CLMJanice Clark1988-06-25—5189904977—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-408350CLMMariana Fields1960-11-22UHC-96749-2860222856543511 Main St, Phoenix, AZ, 850230.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-401304CLMSantiago D Howell1972-04-14———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-428272CLMBruce G Wells2006-05-17UHC-57727-467366220522—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-413448CLMEmily Sanders1943-06-20———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-425946CLMJustin Bennett1996-11-06UHC-31433-795368336101—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-417891CLMCharles Mithcell2008-12-26UHC-47452-548942419102—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-414420CLMGloria Richardson1981-06-07UHC-97404-89—920 Meadow Ln, Tempe, AZ, 852930.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
CLM-400655CLMPaul Jimenez1977-10-17———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-422730CLMBenjamin Fuller1964-03-15—21627390174702 Spring St, Nashville, TN, 372370.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-421135CLMAmber Larson1943-12-22——9158 Washington St, Atlanta, GA, 303790.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-411857CLMJson Murray1974-12-13—30190261654070 Lake View Rd, Tempe, AZ, 852730.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-424949CLMAndrew Palmer1939-02-02UHC-25445-684727111552—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-402351CLMFrances Porter1949-01-13—6076977962173 Broadway, Tempe, AZ, 852300.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
CLM-401525CLMJean Bell2006-05-09UHC-44976-64—5048 Palm Dr, Chandler, AZ, 852090.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-401631CLMJerry Walsh1995-09-24UHC-81721-076004562286—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-418861CLMLuis Knight1994-04-22—55326697594894 Bayshore Dr, Dallas, TX, 752830.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
CLM-406780CLMDonna V Russell1996-11-19—3658973097—0.80Name split from “Last, First”Phone reformattedEmail lower-casedPlaceholder values cleared
CLM-402137CLMJustin Carr1939-05-17UHC-98318-07——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-400190CLMJean A Torres1997-05-05—81178657802059 Camelback Rd, Houston, TX, 770250.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
3,226 rows, page 53 of 65PreviousNext