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-28001 | PRV | Mary N Coleman | 1995-06-14 | — | 5556313855 | — | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-21380 | PRV | Natalie L Welch | 1981-10-07 | UHC-77444-76 | 6436189753 | 218 Valley View Dr # 844, Tempe, AZ, 85274 | 0.78 | Date of birth reformattedPhone reformattedUnit split from streetWhitespace trimmed+1 more |
| PRV-27307 | PRV | Raymond W Tores | 1938-10-14 | — | 7448457649 | 3104 Desert Sky Blvd, Los Angeles, CA, 90033 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25885 | PRV | Nicholas Bowman | 1993-08-02 | UHC-35066-30 | — | 8094 Main St, Sacramento, CA, 95807 | 0.78 | Name re-casedPhone missing area codeCity re-casedWhitespace trimmed+1 more |
| PRV-23450 | PRV | Christine M Wallace | 1942-08-13 | UHC-77178-03 | 6246353466 | 7864 Union St, Houston, TX, 77048 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28279 | PRV | Diane Little | 1956-02-14 | — | 6253177654 | 9056 Washington St, Orlando, FL, 32845 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23346 | PRV | Amanda Allen | 1954-10-20 | — | 4779035426 | — | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-23299 | PRV | Anthony Guerrero | 1972-11-10 | — | 2622920400 | — | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-21085 | PRV | Deborah Jacobs | 2005-02-05 | UHC-75354-55 | 7373546839 | 3198 Apache Blvd, Orlando, FL, 32809 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more |
| PRV-28842 | PRV | Bradley Hunt | 1952-02-13 | UHC-08493-41 | 4684525828 | 3232 Lake View Rd, Nashville, TN, 37206 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedEmail lower-cased+1 more |
| PRV-22041 | PRV | Diane Gibson | 1978-01-07 | — | 7289213628 | 8641 Highland Ave, Austin, TX, 78720 | 0.78 | Date of birth reformattedPhone reformattedZIP+4 trimmedEmail lower-cased+1 more |
| PRV-24831 | PRV | Carlos Kennedy | 1976-02-05 | UHC-61491-38 | 9014896388 | 4777 Palm Dr, Orlando, FL, 32867 | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-25458 | PRV | Ronald Espinoza | 1975-10-25 | — | — | 3502 Lincoln Way, Eden Prairie, MN, 55309 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21169 | PRV | Kahtleen Carpenter | 1965-06-13 | UHC-24892-68 | 2586454641 | 3201 Park Pl, Denver, CO, 80239 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25753 | PRV | Santiago O Hamilton | 2007-02-12 | UHC-80543-19 | — | 6075 Canyon Rd, Phoenix, AZ, 85080 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24723 | PRV | Russell Jimenez | 1972-08-26 | UHC-20971-83 | 3317140263 | 8370 Harbor Blvd, Atlanta, GA, 30326 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24483 | PRV | Douglas Hunt | 1965-02-04 | — | 6002316071 | 9724 Sunset Blvd, Tempe, AZ, 85249 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20335 | PRV | Logan Andrews | 1946-09-04 | UHC-61157-91 | — | 6199 Sage Ct, Miami, FL, 33164 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23287 | PRV | Shirley Le | 1982-02-01 | — | 8314009761 | 6940 Camelback Rd, Jacksonville, FL, 32258 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-25502 | PRV | Roy Q Simpson | 1956-07-16 | — | 9677755119 | 9767 Harbor Blvd, Gilbert, AZ, 85278 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more |
| PRV-22015 | PRV | Jerry Fowler | 1948-09-15 | UHC-15169-15 | 2374041501 | — | 0.78 | Name re-casedTwo-digit birth yearEmail lower-casedWhitespace trimmed+1 more |
| PRV-26186 | PRV | Arthur O Kelley | 1973-10-12 | UHC-35949-93 | 4266714227 | 5723 Washington St, Jacksonville, FL, 32202 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25646 | PRV | Marha Brooks | 1966-10-23 | — | 4385156124 | — | 0.78 | Phone reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more |
| PRV-25645 | PRV | Marha Brooks | 1966-10-23 | — | 4385156124 | — | 0.78 | Phone reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more |
| PRV-22878 | PRV | Hanson Elijah | 2003-03-04 | UHC-11708-39 | — | 119 Indian School Rd, Jacksonville, FL, 32200 | 0.78 | Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+1 more |
| PRV-27819 | PRV | Kelly Robinson | 1981-07-19 | — | 9245058985 | 7506 Cedar Ln Apt 11, Orlando, FL, 32883 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+1 more |
| PRV-28753 | PRV | Barbara C Carroll | 1966-01-23 | — | 5239637570 | — | 0.78 | Name re-casedPhone reformattedSSN last four extractedWhitespace trimmed+1 more |
| PRV-20973 | PRV | Kevin J Cunningham | 2002-07-11 | UHC-11004-76 | 8328555721 | 7149 Park Pl, Los Angeles, CA, 90083 | 0.78 | Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23451 | PRV | Frances Porter | 1962-08-20 | — | 6329397159 | 5689 Bayshore Dr, Las Vegas, NV, 89157 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23331 | PRV | Gary King | 1974-08-05 | UHC-19513-90 | 4534671857 | 6406 Camelback Rd, Columbus, OH, 43211 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-28478 | PRV | Kelly B Contreras | 2004-02-22 | — | 8759710356 | 6369 Maple Ave, Eden Prairie, MN, 55346 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-21903 | PRV | Ralph Schultz | 1980-08-17 | — | 9157722627 | 8278 Elm St, Miami, FL, 33140 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-26470 | PRV | Thomas Harrison | 1996-03-24 | UHC-69538-36 | 3882122897 | 9744 Ocean Ave, Eden Prairie, MN, 55304 | 0.78 | Name split from “Last, First”Phone reformattedState code upper-casedWhitespace trimmed+1 more |
| PRV-21691 | PRV | Nathan K Moore | 2000-08-01 | UHC-49058-08 | — | 2651 Central Ave, Eden Prairie, MN, 55339 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27657 | PRV | Beverly Wheeler | 1947-10-05 | — | 9437954809 | 7151 Central Ave, San Diego, CA, 92180 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21888 | PRV | Joseph Carpenter | 1962-01-19 | — | 7323945307 | 611 Church St, Las Vegas, NV | 0.78 | Name re-casedPhone reformattedCity re-casedZIP missing+1 more |
| PRV-25448 | PRV | Gloria Johnston | 1996-01-21 | — | 9073681399 | 6547 Union St, Minneapolis, MN, 55449 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-29500 | PRV | Arjun Hanson | 1962-01-24 | UHC-47578-88 | 6287326931 | 7609 Spring St, Seattle, WA | 0.78 | Name re-casedPhone reformattedZIP missingWhitespace trimmed+1 more |
| PRV-26962 | PRV | Shirley L Harrison | 1940-04-24 | — | 7475212037 | 3720 Camelback Rd, Atlanta, GA, 30356 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25224 | PRV | Adam Ruiz | 2002-03-19 | — | 5249089026 | 4394 Apache Blvd, Charlotte, NC, 28251 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26046 | PRV | Ahmed Reid | 1947-12-15 | UHC-00042-25 | 9192352753 | 3342 Grand Ave, Glendale, AZ, 85326 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21968 | PRV | Kenneth R Hunter | 1970-02-17 | UHC-04666-05 | 4315968454 | 7067 Indian School Rd, Fresno, CA, 93789 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20406 | PRV | Nancy George | 1946-06-28 | — | 3134241295 | 6342 Forest Ave # 511, Scottsdale, AZ, 85290 | 0.78 | Name re-casedPhone reformattedUnit split from streetWhitespace trimmed+1 more |
| PRV-28061 | PRV | Douglas Hawkins | 1949-10-14 | — | 4096948184 | 9435 Harbor Blvd, Nashville, TN, 37274 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-29004 | PRV | Jason Powell | 1940-03-25 | — | 4213071637 | 9000 Spring St, Phoenix, AZ, 85047 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-29524 | PRV | Samantha E Johnston | 1973-06-25 | UHC-14942-21 | 8578481142 | — | 0.78 | Date of birth reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more |
| PRV-21780 | PRV | Marc A Roberts | 2005-04-16 | UHC-52099-28 | 4009156736 | 1639 River Rd, Miami, FL, 33122 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24415 | PRV | Yuki Russell | 1942-02-14 | UHC-06443-59 | 4839904752 | 4736 Ridge Rd, Mesa, AZ, 85223 | 0.78 | Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-22125 | PRV | Diane Alvarez | 1998-06-11 | — | 3585520249 | 7578 Central Ave, Plano, TX, 75055 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21783 | PRV | Richard Duncna | 1965-12-24 | — | 5126635512 | 573 Oak St, Houston, TX | 0.78 | Date of birth reformattedPhone reformattedZIP missingWhitespace trimmed+1 more |