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-25435 | PRV | Janat Morrison | 1993-11-28 | — | 2848247814 | 9399 Cedar Ln, San Antonio, TX, 78206 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27497 | PRV | Kayla Turner | 2001-02-19 | — | 3098253639 | — | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-23325 | PRV | Joseph P Walsh | 1946-09-24 | UHC-88359-68 | 3565000394 | 6650 Indian School Rd, San Diego, CA, 92172 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21951 | PRV | Andrea Foster | 2002-05-24 | UHC-45296-24 | — | 3205 Union St, Tucson, AZ, 85789 | 0.78 | Name re-casedDate of birth reformattedPhone missing area codeWhitespace trimmed+1 more |
| PRV-23735 | PRV | Gerald M Pena | 1978-10-23 | UHC-42304-14 | 5304689264 | 9382 Bayshore Dr, Phoenix, AZ, 85038 | 0.78 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21667 | PRV | Daniel Herrera | 1975-02-05 | — | 5087202685 | 8261 Broadway, Gilbert, AZ, 85219 | 0.78 | Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-27930 | PRV | Catherine Wheeler | 1952-10-07 | UHC-48380-89 | 8033194021 | 3516 Harbor Blvd, Tampa, FL, 33696 | 0.78 | Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21751 | PRV | Tyler Masoon | 1971-03-26 | UHC-20831-74 | 5576974499 | 1085 Meadow Ln, Atlanta, GA, 30305 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29072 | PRV | Lauren Snyder | 1956-08-01 | — | 6469188966 | 4984 Lincoln Way, Chandler, AZ, 85266 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more |
| PRV-27188 | PRV | Raymond Yeng | 1964-05-20 | UHC-67004-66 | 8595448822 | 6038 Market St, San Antonio, TX, 78289 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20445 | PRV | Sofia Padilla | 2007-03-04 | — | 2487623563 | 5934 Elm St, Gilbert, AZ, 85218 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21425 | PRV | Gabriel Owens | 1992-12-11 | — | 3666654353 | 5073 Desert Sky Blvd, Houston, TX, 77041 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-21349 | PRV | Natalie Adams | 1980-11-12 | UHC-15911-63 | — | 6511 Pine Dr, San Diego, CA, 92159 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22819 | PRV | Donald E Fox | 1994-09-09 | UHC-76516-01 | — | 3402 Pine Dr, Tampa, FL, 33694 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22480 | PRV | William Haarvey | 1943-01-28 | — | 5076532477 | 6888 Meadow Ln, Atlanta, GA, 30301 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28298 | PRV | Marcus Q Harvey | 1952-12-13 | — | — | 2799 Bayshore Dr, Charlotte, NC, 28212 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28791 | PRV | Jacob X Snyder | 1959-08-04 | — | 5203400319 | 3879 Lake View Rd, Charlotte, NC, 28276 | 0.78 | Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-25678 | PRV | Samuel Salazar | 1980-09-13 | — | — | 8284 Harbor Blvd, Sacramento, CA, 95851 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24334 | PRV | Megan A Morrison | 1981-12-16 | UHC-40939-67 | 8317493170 | 5736 Cedar Ln, Tampa, FL, 33645 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23747 | PRV | Melissa Gonzalez | 1975-01-07 | UHC-79439-98 | 4406958139 | 4070 Union St, Jacksonville, FL, 32256 | 0.78 | Phone reformattedMember ID reformattedCity re-casedZIP+4 trimmed+1 more |
| PRV-25745 | PRV | Megan Thomas | 1998-10-14 | UHC-49695-95 | 9085493516 | 2120 Highland Ave, Dallas, TX, 75221 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25212 | PRV | David Andrews | 1950-09-02 | UHC-01919-18 | 6954009348 | 3567 Sunset Blvd, Jacksonville, FL, 32215 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23497 | PRV | Roy Bowman | 1952-07-07 | — | 6592891954 | 1638 Pine Dr, Eden Prairie, MN, 55364 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-27053 | PRV | Sandra Vasquez | 1987-08-10 | UHC-92007-17 | 8475877055 | 1056 Mesa Dr, Nashville, TN, 37296 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23675 | PRV | Steven Z Schmidt | 1986-09-25 | UHC-10816-62 | 6286739037 | 5175 Market St, Las Vegas, NV, 89123 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25116 | PRV | Elijah Smith | 1982-08-13 | UHC-57936-14 | 9618841968 | 518 Desert Sky Blvd, Seattle, WA, 98134 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-26584 | PRV | Omar Arnold | 1976-04-22 | UHC-09544-10 | 2604801165 | 1974 Baseline Rd, Jacksonville, FL, 32254 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-21472 | PRV | Alan Rios | 2002-11-20 | UHC-32796-59 | 3025516496 | 9075 Desert Sky Blvd, Minneapolis, MN, 55480 | 0.78 | Date of birth reformattedMember ID reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-22136 | PRV | Gloria Rogers | 1984-03-18 | UHC-45329-47 | — | 5350 Desert Sky Blvd, Atlanta, GA, 30347 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-25841 | PRV | Olivia Arnold | 1940-05-23 | — | 8006046003 | 824 Forest Ave, Plano, TX, 75049 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-22926 | PRV | Sarah Campbell | 1945-02-09 | UHC-65576-41 | — | 671 Canyon Rd, Charlotte, NC, 28223 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-26060 | PRV | Mason Sanchez | 1953-01-04 | — | — | 1884 Forest Ave, San Antonio, TX, 78278 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21020 | PRV | Kenneth Gomez | 1985-03-06 | UHC-06126-03 | 9314943332 | 6290 Hillcrest Rd, Gilbert, AZ, 85261 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24664 | PRV | Eric Bell | 1943-10-03 | — | 7349738013 | 6105 Bayshore Dr, Denver, CO, 80258 | 0.78 | Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-24665 | PRV | Eric Bell | 1943-10-03 | — | 7349738013 | 6105 Bayshore Dr, Denver, CO, 80258 | 0.78 | Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-20442 | PRV | Dennis Garcia | 1998-11-12 | — | 5945612155 | 1989 Valley View Dr, Gilbert, AZ, 85287 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-20928 | PRV | Linda Spencer | 1966-09-16 | — | 3328480395 | 6260 Ridge Rd, Tucson, AZ, 85787 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27066 | PRV | Chris Phillips | 2005-12-25 | UHC-57380-52 | — | 5907 Ridge Rd, Phoenix, AZ, 85060 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20269 | PRV | Scott Alexander | 1938-02-10 | UHC-45983-33 | 4019916993 | 6524 Lincoln Way, Glendale, AZ, 85392 | 0.78 | Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-23550 | PRV | Barbara Schultz | 1997-02-25 | — | 7303432627 | 1266 Spring St, Dallas, TX, 75294 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-29402 | PRV | Nicholas Kennedy | 1974-04-10 | — | 4936835902 | 6881 Palm Dr, Jacksonville, FL, 32276 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-21517 | PRV | Katherine Soto | 1956-09-18 | — | — | 1461 Ridge Rd, Mesa, AZ, 85235 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21981 | PRV | Gloria Stone | 1965-04-03 | — | 4863376974 | — | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-20533 | PRV | David Turner | 1940-04-17 | UHC-15533-67 | 7333995098 | 9519 Jefferson Ave, Charlotte, NC, 28209 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-24660 | PRV | Teresa Vazquez | 2003-03-18 | — | 2924661981 | 6244 Union St, Plano, TX, 75087 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-23636 | PRV | Denyse Y Price | 1939-12-27 | UHC-27721-07 | 4589593879 | 8071 Desert Sky Blvd, Seattle, WA, 98119 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-28844 | PRV | Janet W Ford | 1969-10-09 | — | 7717112234 | 3521 River Rd, San Antonio, TX, 78213 | 0.78 | Middle initial moved out of first nameName re-casedDate of birth reformattedWhitespace trimmed+1 more |
| PRV-27161 | PRV | Frank Mendoza | 1981-10-06 | UHC-46190-14 | — | 9694 Oak St, Charlotte, NC, 28225 | 0.78 | Member ID reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-25446 | PRV | Arthur Hunt | 1941-03-03 | — | — | 6255 Valley View Dr, Columbus, OH, 43246 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28892 | PRV | Elizabeth Pena | 1972-08-11 | — | 5644732575 | 8280 Apache Blvd, Houston, TX, 77028 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |