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-29484 | PRV | Wei Marshall | 1979-11-21 | UHC-81522-17 | 7992959881 | 6514 Mountain View Dr, Scottsdale, AZ, 85239 | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-23322 | PRV | Aaron Webb | 1964-02-02 | UHC-01857-64 | 3242847345 | 8555 Apache Blvd, San Antonio, TX, 78290 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-21646 | PRV | Helen Lynch | 1940-04-19 | — | 7927927574 | 465 Highland Ave, Fresno, CA, 93721 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-28486 | PRV | Walter Carlson | 1955-10-26 | UHC-39159-19 | 4295406549 | 2773 Mountain View Dr, Phoenix, AZ, 85067 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-25700 | PRV | Madison Hunter | 1956-09-19 | — | — | — | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-26218 | PRV | Mayr Owens | 1946-04-03 | UHC-44249-01 | 8373443938 | 7422 Apache Blvd, Denver, CO, 80252 | 0.94 | Phone reformattedEmail lower-casedPlaceholder values cleared |
| PRV-21028 | PRV | Christian E Perez | 1978-01-11 | UHC-47113-40 | 7507598645 | 9660 Grand Ave, Tempe, AZ, 85211 | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-24281 | PRV | Mari Wheeler | 1978-02-11 | — | 2863458013 | 6718 Broadway, Austin, TX, 78778 | 0.94 | Phone reformattedCity re-casedPlaceholder values cleared |
| PRV-24978 | PRV | Santiago D Jaames | 2005-11-18 | — | 5478943567 | 2035 Indian School Rd, Glendale, AZ, 85338 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-28621 | PRV | Michelle Lynch | 1944-05-17 | — | — | 7066 Central Ave, Jacksonville, FL, 32227 | 0.94 | City re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-27495 | PRV | Joe Scott | 1982-04-21 | UHC-63070-24 | 5714592362 | — | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-27318 | PRV | Roy Fuller | 1982-12-26 | UHC-84389-41 | 5659510193 | 3047 Main St, Minneapolis, MN, 55410 | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-26816 | PRV | Dennis Phillips | 1996-12-07 | — | 7066237718 | 725 Grand Ave, Orlando, FL, 32822 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-23036 | PRV | Frank O Stephens | 1983-04-08 | — | 3628098196 | 8890 Lincoln Way, Chandler, AZ, 85223 | 0.94 | Date of birth reformattedPhone reformattedPlaceholder values cleared |
| PRV-20211 | PRV | Tony Q Kelly | 2000-12-23 | UHC-84357-74 | 5628479738 | 5361 Sunset Blvd, Eden Prairie, MN, 55325 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-28730 | PRV | Marilyn Simmons | 1973-12-07 | UHC-99209-98 | 2787021808 | 9393 Harbor Blvd, Los Angeles, CA, 90020 | 0.94 | City re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-24516 | PRV | Mariana Harrison | 2007-03-03 | — | 5877232833 | — | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-21779 | PRV | Catherine E Taylor | 1965-12-12 | — | 8284089875 | 7245 Hillcrest Rd, Chandler, AZ, 85253 | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-25389 | PRV | Sean Yang | 1966-01-27 | — | 8445415132 | 9465 Palm Dr, San Diego, CA, 92191 | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-23091 | PRV | Ahmed Jacobs | 1982-06-07 | UHC-99057-32 | 9026572813 | 1326 Lincoln Way, Plano, TX, 75070 | 0.94 | Date of birth reformattedPhone reformattedPlaceholder values cleared |
| PRV-26482 | PRV | Gerald H Wagner | 1981-06-11 | UHC-78476-36 | — | — | 0.94 | Date of birth reformattedEmail lower-casedPlaceholder values cleared |
| PRV-23132 | PRV | Samuel Marshall | 2008-01-11 | UHC-42128-45 | 9107025386 | 185 Union St, Columbus, OH, 43242 | 0.94 | Phone reformattedState code upper-casedPlaceholder values cleared |
| PRV-23131 | PRV | Samuel Marshall | 2008-01-11 | UHC-42128-45 | 9107025386 | 185 Union St, Columbus, OH, 43242 | 0.94 | Phone reformattedState code upper-casedPlaceholder values cleared |
| PRV-21071 | PRV | Stephen Cook | 2001-11-05 | UHC-38054-36 | 8816650692 | — | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-27000 | PRV | Kelly H Harris | 1961-03-22 | UHC-15595-64 | 6919397031 | — | 0.94 | Member ID reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-23785 | PRV | Maria Owens | 1962-11-07 | UHC-11319-80 | — | 951 Pine Dr, Orlando, FL, 32842 | 0.94 | Name re-casedState code upper-casedPlaceholder values cleared |
| PRV-25107 | PRV | Douglas Rivera | 1976-07-10 | UHC-47071-90 | 5579884573 | — | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-23996 | PRV | Willie Robinson | 1967-08-05 | UHC-34240-65 | 8832454278 | 5548 Valley View Dr, Jacksonville, FL, 32295 | 0.94 | Date of birth reformattedPhone reformattedPlaceholder values cleared |
| PRV-28391 | PRV | Carolyn Santiao | 1979-07-12 | UHC-60388-44 | 2589087250 | 495 Indian School Rd, Dallas, TX, 75282 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-25125 | PRV | Micheel Patterson | 1950-07-25 | UHC-52330-39 | 5344757314 | — | 0.94 | Name re-casedEmail lower-casedPlaceholder values cleared |
| PRV-21491 | PRV | Raymmond H Schmidt | 1954-07-01 | UHC-32279-47 | 6626210257 | 8835 Valley View Dr, Jacksonville, FL, 32261 | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-23706 | PRV | George M Padilla | 2005-01-20 | — | — | 7600 Valley View Dr, Charlotte, NC, 28274 | 0.94 | City re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-25719 | PRV | Christina Morgan | 2007-03-17 | — | — | 5927 Cedar Ln, Phoenix, AZ, 85021 | 0.94 | State code upper-casedWhitespace trimmedPlaceholder values cleared |
| PRV-23493 | PRV | Julia C Wells | 1952-11-04 | UHC-90402-32 | 9414955159 | — | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-22478 | PRV | Arjun Chavez | 1958-07-21 | UHC-23529-51 | — | — | 0.94 | Date of birth reformattedEmail lower-casedPlaceholder values cleared |
| PRV-27607 | PRV | Luis Willis | 1980-11-19 | UHC-03152-84 | 4072630254 | 8903 Desert Sky Blvd, Denver, CO, 80210 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-27021 | PRV | Janice Allen | 1969-04-25 | UHC-89622-69 | 7368614572 | 948 Union St, Nashville, TN, 37289 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-27566 | PRV | Gerald Mendez | 1963-01-11 | — | 4285249639 | — | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-25785 | PRV | Peter T Castillo | 2007-04-06 | UHC-85777-05 | 4918611411 | 237 Canyon Rd, San Antonio, TX, 78286 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-25751 | PRV | Randy Nelson | 1980-11-09 | — | 6327349209 | 4414 Sage Ct, Chandler, AZ, 85229 | 0.96 | State code upper-casedPlaceholder values cleared |
| PRV-27322 | PRV | Jacqueline Clark | 1943-06-17 | — | 5788747654 | 9455 Willow Ct, Tempe, AZ, 85204 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-23573 | PRV | Natalie T Turner | 1989-06-07 | UHC-95921-01 | 4034244528 | — | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-20922 | PRV | Ann Eliott | 1990-05-15 | UHC-87363-16 | 2843122218 | 3996 Broadway, Glendale, AZ, 85361 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-22569 | PRV | Christian Barnes | 1941-11-12 | UHC-06628-52 | 9263517139 | 7655 Canyon Rd, Los Angeles, CA, 90057 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-27346 | PRV | Jason Willis | 1938-04-20 | UHC-58129-66 | — | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-24231 | PRV | Aisha Ryan | 2006-03-11 | UHC-58675-91 | 9812238695 | — | 0.96 | Date of birth reformattedPlaceholder values cleared |
| PRV-24400 | PRV | Nancy Lane | 1959-10-12 | — | 6283874434 | 8901 Market St, Charlotte, NC, 28269 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-29312 | PRV | Petr S Alexander | 1961-05-20 | UHC-95104-59 | 3987697238 | 6695 Market St, Orlando, FL, 32821 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-22315 | PRV | David Adams | 1980-12-14 | UHC-48978-80 | — | — | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-25104 | PRV | Jordan D Vasquez | 1992-08-12 | — | 9424997975 | — | 0.96 | Phone reformattedPlaceholder values cleared |