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
All sources, flag “Date of birth missing”, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| CLM-428264 | CLM | Jason Morgan | — | UHC-31457-91 | 5042718566 | — | 0.82 | Date of birth missingPhone reformattedPlaceholder values cleared |
| ENR-135105 | ENR | Raymond B Vargas | — | UHC-85125-76 | 6504315259 | 9088 River Rd, Houston, TX, 77017 | 0.82 | Date of birth missingPhone reformattedPlaceholder values cleared |
| ENR-110708 | ENR | Alexander F Ortega | — | UHC-31229-34 | 5635909719 | 3118 Palm Dr, Sacramento, CA, 95830 | 0.82 | Date of birth missingPhone reformattedPlaceholder values cleared |
| CLM-422257 | CLM | Christina Payne | — | — | 4604242324 | 6552 Baseline Rd, Denver, CO, 80209 | 0.82 | Date of birth missingPhone reformattedCity re-cased |
| ENR-142069 | ENR | Nicholas Hill | — | UHC-19819-24 | 5237625924 | 7755 Canyon Rd, Los Angeles, CA, 90089 | 0.82 | Date of birth missingMember ID reformattedWhitespace trimmed |
| ENR-119962 | ENR | Heather C Bailey | — | UHC-26075-27 | 5539586838 | — | 0.82 | Name re-casedDate of birth missingPhone reformatted |
| CLM-408492 | CLM | Donna N Allen | — | UHC-09329-72 | 8384274365 | 8751 Bayshore Dr, Charlotte, NC, 28299 | 0.82 | Date of birth missingPhone reformattedPlaceholder values cleared |
| CLM-406008 | CLM | Christine Knight | — | — | — | — | 0.84 | Date of birth missingWhitespace trimmed |
| ENR-115322 | ENR | Brenda Y Montgomery | — | UHC-06242-21 | 2159996590 | 8095 Grand Ave, Los Angeles, CA, 90071 | 0.84 | Date of birth missingPhone reformatted |
| ENR-132171 | ENR | Jack U Austin | — | UHC-01081-09 | 3449547624 | 6937 Union St, Orlando, FL, 32834 | 0.84 | Date of birth missingWhitespace trimmed |
| ENR-125318 | ENR | Nancy Evans | — | UHC-67038-95 | — | 180 Forest Ave, Orlando, FL, 32825 | 0.84 | Date of birth missingPlaceholder values cleared |
| TPA-53405 | TPA | Rachel Hart | — | — | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| ENR-143019 | ENR | Julie Ross | — | UHC-35911-86 | 3829562824 | 7517 Meadow Ln, Chandler, AZ, 85280 | 0.84 | Date of birth missingWhitespace trimmed |
| CLM-424586 | CLM | Janice Jordan | — | — | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| PRV-24745 | PRV | Mariana T Kelly | — | UHC-73475-49 | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| CLM-411884 | CLM | Donald Vargas | — | — | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| TPA-58669 | TPA | Stephanie Ross | — | — | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| ENR-129430 | ENR | Shiley U Baker | — | UHC-45715-13 | — | 2489 Lake View Rd, Tucson, AZ, 85782 | 0.84 | Date of birth missingPlaceholder values cleared |
| ENR-139859 | ENR | Frances Rice | — | UHC-56562-77 | 3756557059 | 817 Washington St, Las Vegas, NV, 89154 | 0.84 | Name re-casedDate of birth missing |
| CLM-417032 | CLM | Juan McCoy | — | UHC-62486-62 | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| PRV-22575 | PRV | Paul E Hollmes | — | UHC-05951-73 | 4465412660 | 5401 Forest Ave, Scottsdale, AZ, 85254 | 0.84 | Date of birth missingPhone reformatted |
| ENR-109821 | ENR | Mateo Pierce | — | UHC-17328-37 | 2404505214 | 7217 Lincoln Way, Los Angeles, CA, 90012 | 0.84 | Date of birth missingPhone reformatted |
| ENR-140848 | ENR | Amber P Herrera | — | UHC-91429-67 | 9124045238 | 7215 Mesa Dr, Jacksonville, FL, 32259 | 0.84 | Date of birth missingPhone reformatted |
| PRV-24643 | PRV | George A Bryant | — | UHC-88695-40 | — | 2407 Bayshore Dr, San Diego, CA, 92181 | 0.84 | Date of birth missingPlaceholder values cleared |
| TPA-60264 | TPA | Harold Ramirez | — | — | — | 6606 Forest Ave, Charlotte, NC, 28260 | 0.84 | Date of birth missingPlaceholder values cleared |
| CLM-410783 | CLM | Frances Long | — | — | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| TPA-54089 | TPA | Frances Yang | — | — | — | 1650 Forest Ave, Los Angeles, CA, 90069 | 0.84 | Date of birth missingPlaceholder values cleared |
| ENR-127095 | ENR | Frances S Sanchez | — | UHC-05351-57 | 7467049493 | 7524 Broadway, Sacramento, CA, 95859 | 0.84 | Name re-casedDate of birth missing |
| TPA-55837 | TPA | Graace Maldonado | — | — | — | 6552 Baseline Rd, Jacksonville, FL, 32265 | 0.84 | Date of birth missingPlaceholder values cleared |
| CLM-404875 | CLM | Jerry Hawkins | — | UHC-79567-63 | 9046466195 | — | 0.84 | Date of birth missingPlaceholder values cleared |
| ENR-115801 | ENR | Jesse N Pena | — | UHC-04366-25 | 6542340728 | 2100 Jefferson Ave, Charlotte, NC, 28220 | 0.84 | Date of birth missingPhone reformatted |
| TPA-56450 | TPA | Ethan Harvey | — | — | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| PRV-28520 | PRV | Emily Nichols | — | — | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| CLM-413502 | CLM | Linda Ortega | — | UHC-22191-27 | 5424309981 | — | 0.84 | Date of birth missingPlaceholder values cleared |
| CLM-410410 | CLM | Frank Garrett | — | UHC-47816-04 | — | 9229 Sunset Blvd, Tampa, FL, 33618 | 0.84 | Name re-casedDate of birth missing |
| ENR-125722 | ENR | Julia D Spencer | — | UHC-09111-93 | 9802434347 | 8863 Meadow Ln, Dallas, TX, 75296 | 0.84 | Date of birth missingPhone reformatted |
| CLM-430825 | CLM | Samuel S Ray | — | — | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| ENR-120323 | ENR | Angela J Castillo | — | UHC-62876-52 | 5924123690 | 5311 Central Ave, Nashville, TN, 37223 | 0.84 | Name re-casedDate of birth missing |
| ENR-101959 | ENR | Dorothy K Ray | — | — | 9869724173 | 802 Church St, San Antonio, TX, 78250 | 0.86 | Date of birth missing |
| ENR-128796 | ENR | Katherine P Hamilton | — | UHC-73729-70 | 3095174131 | 10 Mountain View Dr, Columbus, OH, 43237 | 0.86 | Date of birth missing |