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.
- Placeholder values cleared71,257Placeholder tokens such as NULL, N/A, UNKNOWN or "-" treated as empty
- Whitespace trimmed57,061Leading or trailing whitespace removed from one or more fields
- Address re-cased56,490Street line re-cased and punctuation removed
- Street suffix standardised55,824Street suffix standardised to USPS abbreviation (Street to St, Avenue to Ave, and so on)
- Phone reformatted50,244Phone reduced to ten digits, punctuation and leading country code removed
- Name re-cased39,996Name letter-case rewritten to Title Case and stray characters removed
- Date of birth reformatted32,400Date of birth rewritten to ISO 8601 from a source format (MM/DD/YYYY, YYYYMMDD, Mon D, YYYY)
- City re-cased17,850City re-cased to Title Case
- Gender normalised16,828Gender mapped to F or M from a longer or variant value
- Email lower-cased11,635Email lower-cased
- Name split from “Last, First”9,980First-name field held "LAST, FIRST"; the two parts were split into their own fields
- State name converted to code9,084Full state name replaced by its two-letter USPS code
- ZIP+4 trimmed8,263ZIP+4 trimmed to the five-digit ZIP
- Member ID reformatted7,723Member ID re-hyphenated and upper-cased to the UHC-#####-## pattern
- ZIP missing7,146Street address present but no ZIP supplied
- Unit split from street6,994Apartment, suite or unit designator split from street line and re-appended in standard form
- Two-digit birth year6,661Date of birth carried a two-digit year; century inferred by pivot
- State code upper-cased4,010Two-letter state code upper-cased
- Plan code upper-cased3,278Plan code upper-cased
- SSN last four extracted2,817Last four digits of SSN extracted from a longer or punctuated value
- Date of birth unreadable2,274Date of birth did not match any known format or was out of range; cleared
- Phone missing area code2,021Phone had only seven digits (no area code); cleared
- Middle initial moved out of first name1,125A single middle initial was embedded in the first-name field and moved to middle name
- Date of birth missing990Date of birth absent or a null token; left empty
- No usable name (quarantined)505No usable last name; record quarantined as junk and excluded from matching
Normalised records
Claims, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| CLM-411717 | CLM | Alex Bradley | 1945-09-17 | — | 9398779006 | 4988 Mountain View Dr, Denver, CO, 80288 | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-428291 | CLM | Hannah Harris | 1962-05-09 | — | — | 4928 Bayshore Dr, Glendale, AZ, 85356 | 0.60 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-410782 | CLM | Juan Hart | 1970-04-08 | UHC-11791-07 | 9213513526 | 3203 Meadow Ln, Jacksonville, FL, 32257 | 0.60 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| CLM-422777 | CLM | Michelle Burns | 1938-06-03 | UHC-94933-30 | 3189326726 | 4095 Park Pl, Dallas, TX | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-407969 | CLM | Samantha Weaver | — | — | 8098140489 | 419 Oak St, Scottsdale, AZ, 85236 | 0.60 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| CLM-420832 | CLM | Sean N Chapman | 2002-02-14 | UHC-35561-40 | 5998998129 | 6702 Church St, Minneapolis, MN | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-431870 | CLM | Michael McDonald | 1982-07-05 | UHC-87977-24 | 2312030340 | 6489 Camelback Rd, Gilbert, AZ | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-408782 | CLM | Russell C Delgado | 1982-08-10 | — | 3697111327 | 8347 Harbor Blvd # 889, Atlanta, GA, 30379 | 0.60 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more |
| CLM-418968 | CLM | Barbara Gibson | 1951-10-28 | UHC-17543-83 | 4345733827 | 6723 Forest Ave # 649, Los Angeles, CA, 90063 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| CLM-432377 | CLM | Amanda Yang | 1941-10-25 | UHC-99907-18 | 2575223460 | 1855 Baseline Rd, Mesa, AZ, 85237 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-430831 | CLM | Jerry Stevens | 1997-06-17 | UHC-69450-06 | 2444550441 | 4239 Union St, San Diego, CA, 92162 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-430813 | CLM | Andrea Harrison | 1956-06-22 | — | — | 1180 Meadow Ln, Phoenix, AZ, 85054 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-416451 | CLM | Terry Jenkins | 1973-05-04 | UHC-17173-50 | 5448407784 | 4419 Maple Ave, Eden Prairie, MN, 55344 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| CLM-424344 | CLM | Heather Vazquez | 1956-05-14 | UHC-60010-83 | 6876094958 | 1445 Central Ave, Glendale, AZ, 85399 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-423833 | CLM | Christine Pwell | 1984-11-14 | UHC-91272-76 | 9619844221 | 1042 Maple Ave, Houston, TX | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-423832 | CLM | Christine Pwell | 1984-11-14 | UHC-91272-76 | 9619844221 | 1042 Maple Ave, Houston, TX | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-425000 | CLM | Vicky Graham | 1950-09-24 | — | 6796257726 | 1392 Forest Ave, San Antonio, TX, 78284 | 0.60 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-419072 | CLM | Timothy Clark | 1959-09-22 | UHC-35369-94 | 3883590899 | 1801 Mountain View Dr # 856, Orlando, FL, 32874 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| CLM-413874 | CLM | Teresa Meyer | 1962-09-10 | UHC-53988-81 | 7158124392 | 9295 Apache Blvd, Las Vegas, NV, 89197 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-430285 | CLM | Deborah Grodon | 1995-09-18 | — | — | 5176 Mesa Dr, San Diego, CA, 92158 | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-409952 | CLM | Douglas R Schultz | 1974-07-19 | — | 7723170773 | 3366 Elm St, Miami, FL, 33181 | 0.60 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-425089 | CLM | Wei B Rodriguez | 1944-09-20 | UHC-29509-85 | — | 8123 Mountain View Dr, Tempe, AZ, 85254 | 0.60 | Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more |
| CLM-413083 | CLM | Hiroshi Rogers | 1986-08-07 | UHC-98848-91 | 4746107880 | 3858 Baseline Rd, Miami, FL | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-402528 | CLM | Arthur Munoz | 2006-05-28 | UHC-53883-63 | 9609752681 | 657 Sunset Blvd, Tempe, AZ, 85252 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| CLM-428478 | CLM | Brandon Sanchez | 1967-08-24 | UHC-70694-47 | 3565802709 | 2492 Grand Ave, Nashville, TN, 37257 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| CLM-431614 | CLM | Sean Hamilton | 1939-06-15 | — | — | 4965 Palm Dr, Seattle, WA, 98113 | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-413178 | CLM | Lisa Clark | 1977-03-13 | UHC-08004-40 | — | 5429 Sunset Blvd, Atlanta, GA, 30336 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-411340 | CLM | Anthony Hiill | 2003-07-19 | UHC-15437-91 | 4644284895 | 7834 Palm Dr # 320, Mesa, AZ, 85266 | 0.60 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more |
| CLM-427476 | CLM | Margaret Gonzales | 1981-02-10 | UHC-59119-32 | 8317311167 | 6102 Valley View Dr, Orlando, FL, 32807 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-425131 | CLM | Wei Medina | 1952-10-25 | UHC-05721-07 | — | 4780 Lake View Rd Apt 4, Plano, TX, 75067 | 0.60 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| CLM-423491 | CLM | Mariana Flores | 1977-09-19 | UHC-75178-35 | 7913273035 | 8810 Elm St, Gilbert, AZ, 85254 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-426345 | CLM | Omar Weaver | 2002-02-28 | UHC-71491-85 | 7039799708 | 4595 Sage Ct, Fresno, CA, 93782 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-415442 | CLM | Samuel Castro | 1975-05-08 | UHC-99010-79 | 9047985083 | 216 Indian School Rd, Dallas, TX, 75266 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| CLM-424288 | CLM | Mei Rogers | 1965-01-05 | UHC-26204-76 | — | 6945 Jefferson Ave, Miami, FL | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-401479 | CLM | Roger Ortiz | 1945-02-12 | UHC-02384-96 | 3637014238 | 2298 Ocean Ave Apt 1, Tempe, AZ, 85201 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| CLM-407489 | CLM | Timothy Nichols | 1989-07-13 | UHC-96375-54 | 7635111728 | 8409 Bayshore Dr Apt 26, San Antonio, TX, 78268 | 0.60 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| CLM-406520 | CLM | Melissa Q Montgomery | 1985-02-11 | — | 3985284849 | 1611 Spring St, Plano, TX, 75087 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-432080 | CLM | Scott Campbell | 1947-06-03 | — | 3803424135 | 15 Hillcrest Rd, Sacramento, CA, 95811 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| CLM-425054 | CLM | MarkJunk | 1941-03-17 | — | 4454490533 | 6407 Spring St, Jacksonville, FL, 32232 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-425350 | CLM | Dorothy Patterson | 1963-07-14 | UHC-01755-52 | — | 3384 Cedar Ln, Nashville, TN, 37266 | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-417977 | CLM | Park Hiroshi | — | — | 5464354921 | 4378 Apache Blvd, Gilbert, AZ, 85241 | 0.60 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| CLM-405785 | CLM | Pamela Jordan | 1982-06-16 | UHC-28186-78 | 8656907925 | 2690 Highland Ave, Phoenix, AZ, 85048 | 0.60 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| CLM-428160 | CLM | Grace Phillips | 1971-09-14 | UHC-93122-46 | 3805608428 | 1782 Valley View Dr, Fresno, CA, 93704 | 0.60 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-431810 | CLM | Samuel Richards | 1984-02-14 | — | 2645453770 | 2173 Mountain View Dr, Phoenix, AZ, 85006 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-401266 | CLM | Marilyn Long | 1982-08-17 | — | 4696515047 | 4829 Oak St, Atlanta, GA, 30357 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-424255 | CLM | Scott N Anedrson | 1987-07-26 | — | 2314012079 | 4712 Hillcrest Rd, Glendale, AZ, 85348 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-418283 | CLM | Abigail Aguilar | 1997-05-25 | UHC-54533-25 | — | 8621 Hillcrest Rd, Las Vegas, NV | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-411624 | CLM | George Day | 1963-09-28 | — | — | 6255 River Rd, Phoenix, AZ, 85095 | 0.60 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| CLM-420819 | CLM | Ashley Pena | — | UHC-93084-46 | — | 5362 Church St, Los Angeles, CA, 90017 | 0.60 | Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more |
| CLM-401178 | CLM | Mark Gomez | 1962-09-20 | — | 4849056405 | 5250 Indian School Rd, Eden Prairie, MN, 55378 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |