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
Provider network, flag “Phone reformatted”, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| PRV-25245 | PRV | Timothy Gordon | 1967-03-04 | — | 4993464992 | — | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-24913 | PRV | Mei T Le | 1942-07-21 | — | 5845439885 | 1892 Forest Ave Apt 23, Sacramento, CA, 95827 | 0.82 | Phone reformattedUnit split from streetWhitespace trimmed |
| PRV-28707 | PRV | James Mills | 1982-10-16 | — | 4896745749 | 9312 Broadway, Los Angeles, CA | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-27158 | PRV | Brneda Carpenter | 1953-05-23 | — | 3354432906 | — | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-23045 | PRV | Marilyn I Patterson | 1997-01-05 | UHC-43471-66 | 5688744256 | — | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-28966 | PRV | Jack Torres | 1949-02-10 | — | 3558995888 | 110 Spring St, Nashville, TN, 37271 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-28035 | PRV | Deborah Perry | 1941-09-28 | UHC-90537-38 | 4816085049 | 1929 Oak St, Fresno, CA, 93777 | 0.82 | Phone reformattedCity re-casedState name converted to code |
| PRV-28036 | PRV | Deborah Perry | 1941-09-28 | UHC-90537-38 | 4816085049 | 1929 Oak St, Fresno, CA, 93777 | 0.82 | Phone reformattedCity re-casedState name converted to code |
| PRV-29239 | PRV | Ethan Kim | 1972-01-09 | — | 4367579202 | 3734 Grand Ave, Gilbert, AZ, 85213 | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-22543 | PRV | Deborah Jenkins | 2002-05-05 | — | 5882734313 | 8137 Central Ave, Houston, TX, 77004 | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-21024 | PRV | Jackie Fowler | 1991-02-11 | UHC-54173-12 | 8907417379 | 9633 Central Ave, Los Angeles, CA, 90086 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-25531 | PRV | Gary Tucker | 2000-06-04 | UHC-38611-50 | 4186964420 | — | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-22292 | PRV | Beverly G Padilla | 1954-10-26 | UHC-35803-15 | 5395348170 | 6136 Park Pl, Mesa, AZ, 85225 | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-25695 | PRV | Cynthia Lopez | 2003-11-17 | — | 3319725403 | 4377 Washington St, Austin, TX, 78715 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| PRV-26652 | PRV | Bobby L Payne | 1987-08-17 | UHC-54861-76 | 2315860318 | 7432 Palm Dr, Columbus, OH, 43248 | 0.82 | Phone reformattedZIP+4 trimmedPlaceholder values cleared |
| PRV-25860 | PRV | Marcus Bruns | 1966-09-19 | UHC-37882-51 | 4782927645 | 2113 Washington St, Columbus, OH, 43279 | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-20529 | PRV | Ethan Le | 1939-11-24 | — | 9253589039 | 3103 Mesa Dr # 503, Phoenix, AZ, 85048 | 0.82 | Phone reformattedUnit split from streetPlaceholder values cleared |
| PRV-23913 | PRV | Isabella Nelson | 1992-04-21 | UHC-35456-26 | 5203335188 | 2964 Grand Ave, Austin, TX, 78797 | 0.82 | Date of birth reformattedPhone reformattedGender normalised |
| PRV-20012 | PRV | Olivia Mejia | 1996-01-27 | UHC-99227-11 | 6248894352 | — | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-27471 | PRV | Lucia Guerrero | 2006-03-10 | — | 7722482192 | 4320 Maple Ave, Sacramento, CA, 95806 | 0.82 | Phone reformattedZIP+4 trimmedPlaceholder values cleared |
| PRV-20486 | PRV | David Graham | 2003-09-12 | UHC-28829-66 | 9077284379 | 2470 Lincoln Way, Plano, TX, 75031 | 0.82 | Phone reformattedSSN last four extractedPlaceholder values cleared |
| PRV-27387 | PRV | Steven L Gibson | — | — | 4738530410 | — | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| PRV-29532 | PRV | Alice Gibson | 1966-05-04 | UHC-30304-46 | 8817648012 | 4012 Elm St, Eden Prairie, MN, 55318 | 0.82 | Phone reformattedStreet suffix standardisedAddress re-cased |
| PRV-29540 | PRV | Sena Peters | 2001-10-05 | — | 3404158757 | — | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-28610 | PRV | Harold Green | 1949-02-27 | UHC-22405-40 | 8092659483 | 5450 Spring St, Seattle, WA | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-28806 | PRV | Austin M Knight | 1938-02-20 | UHC-16690-66 | 3699950770 | 8220 Oak St, Minneapolis, MN, 55400 | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-28678 | PRV | Diane Snyder | 1952-05-14 | — | 4466455108 | 2666 Spring St Apt 22, Austin, TX, 78738 | 0.82 | Phone reformattedUnit split from streetPlaceholder values cleared |
| PRV-24819 | PRV | Debra Ray | 1978-06-08 | UHC-45020-13 | 2713762726 | 5864 Sage Ct, Minneapolis, MN | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-27664 | PRV | Sara Gordon | 1942-10-07 | — | 3573169412 | 7925 Highland Ave, Tampa, FL, 33697 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| PRV-22100 | PRV | Bradley H Weaver | 1986-04-15 | — | 5936633482 | — | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-22405 | PRV | Virginia Freeman | 2005-02-19 | — | 7952487698 | 2185 Mountain View Dr, Minneapolis, MN, 55465 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-25557 | PRV | Theresa C Hamilton | 1978-07-17 | — | 2749990981 | 412 Central Ave, Tampa, FL, 33602 | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-22016 | PRV | Nancy H Spencer | 2008-09-06 | UHC-62462-17 | 6803761098 | — | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-24110 | PRV | Donna Foster | 1995-07-14 | — | 4476310906 | — | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-27261 | PRV | William Rivera | 1971-03-13 | UHC-47674-88 | 5122810729 | — | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-27260 | PRV | William Rivera | 1971-03-13 | UHC-47674-88 | 5122810729 | — | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-24663 | PRV | Larry L Morales | 2002-09-18 | — | 6217476977 | 1782 Ridge Rd, Sacramento, CA, 95853 | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-26894 | PRV | Mria L Stephens | 1986-09-24 | UHC-32216-39 | 8617633911 | 1827 Canyon Rd, San Diego, CA, 92119 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-29380 | PRV | Karen Rose | 1993-11-16 | UHC-41271-45 | 8776486886 | 1976 Willow Ct, Las Vegas, NV, 89101 | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-21460 | PRV | Tim Lopez | 1946-01-15 | UHC-58975-81 | 5136726619 | 9308 Meadow Ln, Nashville, TN, 37271 | 0.82 | Phone reformattedStreet suffix standardisedAddress re-cased |
| PRV-26840 | PRV | Paul T Murphy | 1961-07-18 | — | 7627601954 | 4643 Main St, Tucson, AZ, 85747 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| PRV-20307 | PRV | Joseph Gilbert | 1946-07-21 | — | 3513213461 | — | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-21422 | PRV | Arjun P Morrison | 1981-02-02 | UHC-53363-37 | 3414964629 | — | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-22210 | PRV | Natalie Bihop | 1987-04-25 | — | 6973601068 | 5678 Baseline Rd, Fresno, CA, 93770 | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-23637 | PRV | Hiroshi S Mason | 1963-11-06 | — | 8542356009 | 410 Cedar Ln, Eden Prairie, MN | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-24953 | PRV | Mark Mills | 1962-04-06 | — | 6477423538 | 5792 Broadway, Glendale, AZ | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-24952 | PRV | Mark Mills | 1962-04-06 | — | 6477423538 | 5792 Broadway, Glendale, AZ | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-27347 | PRV | Samantha R Gonzales | 2008-03-06 | UHC-82018-07 | 5262306122 | 1965 Meadow Ln, San Diego, CA, 92159 | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-22356 | PRV | Ahmed J Phillips | 1944-01-07 | UHC-63412-32 | 9868312555 | 324 Park Pl, Gilbert, AZ | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-25851 | PRV | Sean Morgan | 2005-10-24 | — | 6436372880 | 2936 Canyon Rd, Las Vegas, NV, 89133 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |