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, flag “Two-digit birth year”, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| CLM-429046 | CLM | Martha N Herrera | 1956-06-01 | UHC-70389-89 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-425002 | CLM | Victoria Graham | 1950-09-24 | UHC-99148-14 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-412811 | CLM | Mei Jordan | 1986-12-06 | UHC-15729-08 | 3086820790 | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-403761 | CLM | Cheryl Sott | 1971-07-23 | — | — | 9254 Union St, Miami, FL, 33196 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-425669 | CLM | Jesse Ramos | 2008-04-13 | UHC-31567-09 | — | 7233 Park Pl, Fresno, CA, 93758 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-410881 | CLM | Abigail Gray | 1998-07-12 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-407755 | CLM | Karen Dean | 1964-12-28 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-409462 | CLM | Jerry Anderson | 2006-12-25 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-414114 | CLM | Joe Harvey | 1942-03-03 | UHC-94032-08 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-403402 | CLM | Sofia Carpenter | 1995-07-07 | UHC-20485-01 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-414447 | CLM | Deborah K Meeyer | 2005-03-27 | UHC-43843-48 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-409149 | CLM | Sandra Maldonado | 1972-06-20 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-403470 | CLM | Raymond Riley | 1973-12-25 | UHC-77200-05 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-423864 | CLM | Heather Fuller | 1938-09-04 | UHC-97671-82 | — | 5849 Mesa Dr, Minneapolis, MN, 55478 | 0.84 | Two-digit birth yearCity re-cased |
| CLM-416587 | CLM | Helen V Mejia | 1987-01-20 | UHC-40105-27 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-412695 | CLM | Isabella Torres | 2008-09-07 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-432654 | CLM | Stephen Watkins | 1966-10-20 | — | — | 5875 Harbor Blvd, Gilbert, AZ, 85240 | 0.84 | Two-digit birth yearWhitespace trimmed |
| CLM-417185 | CLM | Ronald Ramos | 1957-11-19 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-409299 | CLM | Raymond I Campbell | 2002-11-15 | UHC-88385-96 | 7735217027 | 5500 Ocean Ave, Glendale, AZ, 85328 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-417205 | CLM | Carlos Torres | 1970-09-14 | UHC-33962-64 | 9713708636 | 1314 Hillcrest Rd, Mesa, AZ, 85220 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-425866 | CLM | Roer Gordon | 1945-04-10 | — | — | 3536 Grand Ave, Denver, CO, 80260 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-425865 | CLM | Roer Gordon | 1945-04-10 | — | — | 3536 Grand Ave, Denver, CO, 80260 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-429728 | CLM | Marcus Luna | 1955-03-12 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-425184 | CLM | Deborah Lynch | 1993-12-15 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-415326 | CLM | Melissa Fisher | 1988-09-10 | UHC-89139-26 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-428854 | CLM | Hannah Santiago | 1963-03-04 | — | — | 7868 Mountain View Dr, Chandler, AZ, 85295 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-430727 | CLM | Janice West | 1955-07-13 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-419102 | CLM | Julia Alexander | 1993-08-02 | UHC-68877-99 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-406835 | CLM | Mary Cox | 1963-06-09 | UHC-99989-78 | — | 2441 Canyon Rd, Eden Prairie, MN, 55375 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-418294 | CLM | Jonathan I Hughes | 1980-01-09 | — | — | 1879 Union St, Fresno, CA, 93779 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-414042 | CLM | Judy Gilbert | 1945-12-06 | UHC-52917-22 | — | 7983 Lincoln Way, Glendale, AZ, 85335 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-428858 | CLM | Camila B Torres | 1939-02-23 | UHC-74623-75 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-412387 | CLM | Brandon Munoz | 1954-08-13 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-420714 | CLM | Denny Ray | 1961-07-12 | UHC-11585-25 | — | 959 Sunset Blvd, Atlanta, GA, 30368 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-427548 | CLM | Dorothy George | 1955-03-04 | UHC-73922-65 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-411045 | CLM | Mei Hudson | 1961-05-03 | UHC-21510-91 | 2546809363 | 6252 Ocean Ave, Tampa, FL, 33610 | 0.84 | Two-digit birth yearPhone reformatted |
| CLM-411046 | CLM | Mei Hudson | 1961-05-03 | UHC-21510-91 | 2546809363 | 6252 Ocean Ave, Tampa, FL, 33610 | 0.84 | Two-digit birth yearPhone reformatted |
| CLM-406293 | CLM | Nathan Powell | 1989-03-17 | UHC-58381-41 | — | 683 Willow Ct, Seattle, WA, 98177 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-419089 | CLM | Theresa Little | 1994-03-22 | — | — | 8899 Maple Ave, Charlotte, NC, 28210 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-405548 | CLM | Ahmed Welch | 1986-09-19 | UHC-38427-46 | 3773730239 | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-410874 | CLM | Thomas X Luna | 1986-04-10 | UHC-64102-71 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-420722 | CLM | Barbara Adams | 1965-10-03 | UHC-39914-52 | 5533683724 | — | 0.84 | Two-digit birth yearPhone reformatted |
| CLM-418275 | CLM | Jacob Vazquez | 1972-07-14 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-429490 | CLM | Gloria Lopez | 1942-12-10 | UHC-27080-04 | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-405872 | CLM | Deborah Baker | 1994-06-22 | UHC-63704-66 | — | 3889 Canyon Rd, Plano, TX, 75041 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-432148 | CLM | Willie Heyes | 1938-07-10 | UHC-36054-81 | 8472488292 | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-432147 | CLM | Willie Heyes | 1938-07-10 | UHC-36054-81 | 8472488292 | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-418730 | CLM | Egene Nunez | 1969-01-28 | — | — | 2385 Mesa Dr, Sacramento, CA, 95807 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-409196 | CLM | Susan I Ramirez | 1965-10-02 | UHC-57037-18 | — | 9289 Sage Ct, Tucson, AZ, 85768 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| CLM-416305 | CLM | Laura W Dunn | 1991-05-17 | UHC-73734-03 | 4682295174 | 7113 Central Ave, Atlanta, GA, 30375 | 0.84 | Two-digit birth yearPlaceholder values cleared |