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-25278 | PRV | Roger H Nelson | 1989-06-14 | — | 9684758967 | 1103 Desert Sky Blvd, Tucson, AZ, 85733 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26413 | PRV | Izabella B Kennedy | 1951-08-10 | UHC-97057-97 | 4052366527 | 2989 Ridge Rd, Chandler, AZ, 85217 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22189 | PRV | Jack Kelly | 1984-08-10 | UHC-72971-02 | 3582369506 | 8029 Willow Ct, San Antonio, TX, 78230 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26342 | PRV | Joe Stewart | 1953-02-11 | UHC-21317-80 | 5262346068 | 286 Sage Ct, Los Angeles, CA, 90063 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24325 | PRV | Mei Allen | 1991-09-17 | UHC-06040-50 | 7967700380 | 2703 Main St, Tampa, FL, 33634 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27661 | PRV | Camila Herrera | 1946-01-08 | — | 4765411019 | 6176 Park Pl, Glendale, AZ, 85380 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22214 | PRV | Lee Julie | 1985-06-28 | UHC-59108-59 | — | 7238 Main St, Tucson, AZ, 85743 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25651 | PRV | Nicole Carr | 1961-06-14 | — | 4023802792 | 7331 Pine Dr, Phoenix, AZ, 85053 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-26817 | PRV | Christina Contreras | 1967-07-06 | UHC-62827-35 | 9404286373 | — | 0.76 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+2 more |
| PRV-28124 | PRV | Johnny Lynch | 1973-03-02 | UHC-98159-44 | 9537713252 | 4664 Maple Ave, Tempe, AZ, 85211 | 0.76 | Name re-casedDate of birth reformattedMember ID reformattedGender normalised+2 more |
| PRV-23421 | PRV | Nancy Stpehens | 2005-01-22 | — | 8544729067 | 8008 Ocean Ave, Scottsdale, AZ, 85205 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28201 | PRV | Patricia Gardner | 2004-03-08 | UHC-34913-40 | 6845625659 | 5921 Union St, Chandler, AZ, 85203 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-27589 | PRV | Mariana Hansen | 1948-10-02 | — | 3297020131 | 7499 Desert Sky Blvd, Eden Prairie, MN, 55370 | 0.76 | Date of birth reformattedPhone reformattedState name converted to codeEmail lower-cased+2 more |
| PRV-22072 | PRV | Joshua Q Munoz | 1994-01-20 | — | 2214594792 | 4852 Washington St, Dallas, TX, 75237 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20635 | PRV | Ahmed Gutierrez | 1938-05-12 | — | 2336721836 | 6178 Forest Ave, Columbus, OH, 43204 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23810 | PRV | John Hicks | 1993-02-23 | UHC-25546-25 | — | 4101 Hillcrest Rd, Charlotte, NC, 28299 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26097 | PRV | Gregory U Husdon | 1968-08-14 | UHC-14069-21 | 2769558963 | 7983 Hillcrest Rd, Plano, TX, 75060 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-23625 | PRV | Gregory Cole | 1995-09-24 | UHC-65103-91 | 6262128314 | 2080 Washington St, Austin, TX, 78714 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29237 | PRV | Natalie Ryan | 2004-06-05 | — | 3095522514 | 9790 Washington St, Minneapolis, MN, 55421 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-22168 | PRV | Mateo A Lane | 1942-10-27 | — | 7105209273 | 3117 Pine Dr, Miami, FL, 33136 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-22537 | PRV | Jack O Hudson | 1999-01-25 | — | 7907161482 | 9203 Broadway, Miami, FL, 33199 | 0.76 | Phone reformattedAddress re-casedCity re-casedState code upper-cased+2 more |
| PRV-29010 | PRV | Katherine Q Wheeler | 1982-06-17 | UHC-14259-82 | 9459171020 | 5094 Maple Ave, Las Vegas, NV, 89196 | 0.76 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-27472 | PRV | Daniel Hudson | 1996-07-23 | UHC-33246-35 | 4358914542 | 8069 Lincoln Way, Jacksonville, FL, 32245 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22258 | PRV | Diana Rian | 1945-09-14 | — | 6742543948 | 3336 Market St, Tucson, AZ, 85736 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-22817 | PRV | Danielle Torres | 2003-09-16 | — | 8558324572 | 3202 Central Ave, Orlando, FL, 32859 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25560 | PRV | Eugene Nunez | 1969-01-28 | — | 4899350703 | 2385 Mesa Dr, Sacramento, CA, 95807 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more |
| PRV-23439 | PRV | Jose Rodriguez | 1972-10-11 | UHC-49925-88 | 3472183963 | 385 Market St, Dallas, TX, 75261 | 0.76 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20116 | PRV | Terry Martinez | 1970-10-08 | UHC-27731-53 | 6723861608 | 5456 Park Pl, San Antonio, TX, 78251 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-21893 | PRV | Stephen N Holmes | 1940-01-28 | UHC-84368-17 | 2114154493 | 2998 Cedar Ln, Orlando, FL, 32851 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20859 | PRV | Keith D Morales | 1973-08-27 | — | 5556704672 | 9255 Washington St, Plano, TX, 75009 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25806 | PRV | Jordan Carpenter | 1977-03-17 | — | — | 7257 Mesa Dr, Phoenix, AZ, 85088 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24465 | PRV | Terry S Peterson | 1940-03-22 | — | 7826611322 | 3240 Apache Blvd, Los Angeles, CA, 90066 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21756 | PRV | Mei White | 1981-03-25 | — | — | 8916 River Rd, Jacksonville, FL, 32273 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-22532 | PRV | Mariana Anderson | 2000-10-14 | — | 8244073420 | 340 Ocean Ave, Columbus, OH, 43274 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21133 | PRV | Judy Gomez | — | UHC-18172-29 | 9402504971 | 8411 Canyon Rd, Orlando, FL, 32840 | 0.76 | Name re-casedDate of birth unreadablePhone reformattedEmail lower-cased+2 more |
| PRV-29357 | PRV | Arthur Oliver | 1972-07-19 | — | — | 3820 Mountain View Dr, Minneapolis, MN, 55472 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-22407 | PRV | Stephanie Adams | 1955-12-25 | UHC-59976-73 | 5406072644 | 3604 River Rd, Eden Prairie, MN, 55376 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more |
| PRV-22686 | PRV | Cheryl Stephens | 2008-06-25 | — | 9423658387 | — | 0.76 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more |
| PRV-22231 | PRV | Joshua Turner | 2005-08-27 | UHC-57288-86 | 4086696990 | 7345 Cedar Ln, Eden Prairie, MN, 55377 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-24209 | PRV | Raymond Padilla | 1959-11-23 | — | 8492927414 | 6845 Maple Ave, Minneapolis, MN, 55439 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23840 | PRV | Arjun C Cruz | 2002-01-18 | — | 7614780340 | 2954 Palm Dr, Eden Prairie, MN, 55315 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-21314 | PRV | Priya Warren | 1958-06-19 | UHC-43262-29 | 9333868605 | 7010 Bayshore Dr, Tampa, FL, 33653 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-27206 | PRV | Sharon Alexander | 1992-04-27 | — | 4526842501 | 4450 Ocean Ave, Dallas, TX, 75213 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28085 | PRV | Ralph Peterson | 1995-08-04 | UHC-53260-05 | 4588571984 | 1958 Market St, Sacramento, CA, 95883 | 0.76 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-25691 | PRV | Angela E Murray | 2004-11-25 | — | 9422472957 | 53 Elm St, Nashville, TN, 37215 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25244 | PRV | Timothy Gordon | 1967-03-04 | UHC-69308-48 | 4993464992 | 3260 Union St, Phoenix, AZ, 85005 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28537 | PRV | Meriana Williamson | 1967-04-01 | UHC-94555-31 | 4858857683 | 2955 Church St, Fresno, CA, 93708 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-21193 | PRV | Logan Mendoza | 1997-07-19 | UHC-83159-66 | 3264563054 | 5812 Jefferson Ave, Tucson, AZ, 85728 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-26782 | PRV | Susan X Webb | 1952-10-06 | UHC-58050-50 | 4289285824 | 2347 Lincoln Way, Eden Prairie, MN, 55390 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more |
| PRV-20461 | PRV | Martha G Carter | 1989-09-22 | — | 8923339841 | 8319 Lake View Rd, Las Vegas, NV, 89104 | 0.76 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more |