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, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| PRV-21787 | PRV | Teresa Reid | 1988-07-24 | — | 6166325139 | — | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-28702 | PRV | Daniel Martinez | 1964-05-21 | UHC-53488-77 | 9676271166 | 8883 Forest Ave, Chandler, AZ, 85249 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-20467 | PRV | Kathryn Contreras | 1972-06-05 | UHC-93092-01 | 2874278678 | 1935 Church St, Glendale, AZ, 85310 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-21633 | PRV | Andrew Chavez | 1997-09-10 | UHC-24032-03 | 6108062111 | 1473 Indian School Rd, Nashville, TN, 37243 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-21161 | PRV | Christopher Williamson | 2002-02-28 | — | 5136237039 | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-27049 | PRV | Sandra Santiago | 1951-04-21 | UHC-18065-04 | — | 94 Maple Ave, Las Vegas, NV, 89172 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-23574 | PRV | Sims Heather | 1986-06-13 | UHC-21954-04 | 7628443339 | 8996 Church St, Tampa, FL, 33665 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-27412 | PRV | Benjamin Martin | 1967-09-19 | — | — | 6483 Union St, Tempe, AZ, 85253 | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-28206 | PRV | Emma P Alvarez | 1971-08-21 | — | 7285720272 | — | 0.96 | Date of birth reformattedPlaceholder values cleared |
| PRV-21886 | PRV | Hannah Hunt | 1988-10-03 | — | — | 2590 Sage Ct, Glendale, AZ, 85319 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-20919 | PRV | Nancy Brooks | 2002-03-20 | — | — | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-28694 | PRV | Sean Vega | 1996-02-13 | UHC-58043-65 | 5273840197 | 8359 Indian School Rd, Denver, CO, 80240 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-25314 | PRV | Kenneth W Stewart | 1946-06-05 | — | 8564494783 | 5531 River Rd, Plano, TX, 75090 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-20181 | PRV | Katherine Spencer | 1941-12-05 | — | — | 7159 Jefferson Ave, Eden Prairie, MN, 55395 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-26737 | PRV | Alan J Wang | 1945-05-20 | — | — | 6676 Spring St, Jacksonville, FL, 32292 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-24344 | PRV | Badley Weber | 1989-10-06 | — | — | — | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-22976 | PRV | Shirley N James | 1958-03-17 | — | — | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-25126 | PRV | Alexander B Fernandez | 1965-08-05 | — | 3977123312 | 3851 Spring St, Plano, TX, 75031 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-22841 | PRV | Elijah Clark | 2002-10-25 | UHC-58917-79 | 3834939299 | 7887 Market St, Gilbert, AZ, 85208 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-26242 | PRV | Carolyn Z James | 1987-01-25 | — | — | — | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-28629 | PRV | Linda Le | 2006-02-15 | — | — | 9480 Hillcrest Rd, San Diego, CA, 92178 | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-27565 | PRV | Betty Willis | 1958-07-17 | — | 9513124114 | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-26860 | PRV | Ahmed Ortiz | 1974-12-11 | UHC-30129-78 | 5692420152 | 8727 Broadway, Plano, TX, 75064 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-29425 | PRV | Judy Morrison | 1964-06-15 | UHC-54028-49 | 7017695054 | 9692 Main St, Austin, TX, 78753 | 0.96 | City re-casedPlaceholder values cleared |
| PRV-28125 | PRV | Jacqueline Mitchell | 1984-06-10 | UHC-85622-08 | — | 7226 Broadway, Denver, CO, 80223 | 0.96 | City re-casedPlaceholder values cleared |
| PRV-23737 | PRV | Lucia Little | 2008-01-04 | — | 9542185645 | — | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-23203 | PRV | Pamela Jacobs | 1988-02-02 | UHC-33484-83 | — | 3967 Highland Ave, Atlanta, GA, 30382 | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-26510 | PRV | Sharon Vega | 1970-01-16 | — | 6665859164 | 6900 Baseline Rd, San Diego, CA, 92104 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-28523 | PRV | Marcus Walsh | 1997-07-05 | — | 9878415044 | 9217 Church St, Tampa, FL, 33645 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-29518 | PRV | Julie D Medina | 2004-05-05 | UHC-60078-04 | — | 7323 Apache Blvd, Austin, TX, 78743 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-26594 | PRV | Ethan Oliiver | 1938-11-05 | — | — | 646 Ridge Rd, Sacramento, CA, 95800 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-29476 | PRV | Catherine Harris | 1994-08-16 | UHC-89494-51 | 3514708871 | 2084 Lincoln Way, Chandler, AZ, 85269 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-21316 | PRV | Ambeer W Mejia | 1953-02-17 | UHC-13136-66 | 4953626145 | 5149 Mesa Dr, Gilbert, AZ, 85265 | 0.96 | Date of birth reformattedPlaceholder values cleared |
| PRV-28380 | PRV | Madison Butler | 1975-06-07 | — | — | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-25038 | PRV | Jacqueline Walker | 1999-08-16 | — | 7758403384 | 7619 Oak St, Mesa, AZ, 85255 | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-27391 | PRV | Sofia A Ortiz | 1995-11-04 | UHC-16134-88 | 4399816570 | — | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-28747 | PRV | Kevin O Guzman | 1963-07-25 | — | 2788808571 | — | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-20516 | PRV | Dot Perez | 1984-06-20 | UHC-96748-73 | 2098689013 | 2167 Mesa Dr, Seattle, WA, 98109 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-20517 | PRV | Dot Perez | 1984-06-20 | UHC-96748-73 | 2098689013 | 2167 Mesa Dr, Seattle, WA, 98109 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-21674 | PRV | Christopher Keelley | 1959-08-12 | UHC-48024-33 | — | 9760 Highland Ave, Sacramento, CA, 95867 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-22363 | PRV | Kathy Ford | 1939-07-16 | UHC-11119-53 | 8433358005 | 9302 Main St, Tucson, AZ, 85720 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-22301 | PRV | Gloria Black | 1994-12-14 | UHC-21146-15 | 7948045970 | 509 Camelback Rd, Fresno, CA, 93715 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-22353 | PRV | Cynthia Lucas | 1964-12-23 | UHC-72108-02 | 4202361988 | 64 Indian School Rd, Minneapolis, MN, 55436 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-22903 | PRV | Dylan Foster | 1970-07-22 | — | — | 2855 Washington St, Minneapolis, MN, 55491 | 0.96 | City re-casedPlaceholder values cleared |
| PRV-21743 | PRV | Zachary Harris | 1972-03-02 | — | 7524419031 | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-26334 | PRV | Ahmed Perkins | 1948-08-28 | — | — | 3105 Main St, Glendale, AZ, 85324 | 0.96 | Date of birth reformattedPlaceholder values cleared |
| PRV-24611 | PRV | Carolyn W Stevesn | 2005-09-16 | — | 5539915428 | 5431 Forest Ave, Seattle, WA, 98176 | 0.96 | Date of birth reformattedPlaceholder values cleared |
| PRV-20742 | PRV | Russell Walker | 1991-03-18 | UHC-74532-97 | 4372865571 | 3949 Main St, Orlando, FL, 32835 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-21634 | PRV | Bradley Palmer | 1952-02-11 | UHC-68445-57 | 2638619542 | 2004 Jefferson Ave, Seattle, WA, 98139 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-27614 | PRV | Natalie Reid | 1987-10-19 | UHC-17980-94 | 8708111811 | — | 0.96 | Phone reformattedPlaceholder values cleared |