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-23013 | PRV | Michelle W Cunningham | 2007-07-25 | UHC-27388-13 | 8905956307 | 1038 Main St, Gilbert, AZ, 85250 | 0.78 | Name re-casedPhone reformattedMember ID reformattedState name converted to code+1 more |
| PRV-20205 | PRV | Brandon Jackson | 1938-03-22 | — | 8882214017 | — | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-29548 | PRV | Amber Griffin | 1939-12-09 | — | 4068914367 | 6088 Desert Sky Blvd, San Diego, CA, 92193 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29547 | PRV | Amber Griffin | 1939-12-09 | — | 4068914367 | 6088 Desert Sky Blvd, San Diego, CA, 92193 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27531 | PRV | Abigail B Stone | 1952-01-07 | — | 7735189731 | 7249 River Rd, Seattle, WA, 98171 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23667 | PRV | Dennis Castro | 2000-05-06 | UHC-54013-05 | 3268442329 | 5520 Washington St, Miami, FL, 33174 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+1 more |
| PRV-20709 | PRV | Ahmed Gutierrez | 1970-04-28 | UHC-73708-45 | 8853274555 | 4959 Harbor Blvd, Scottsdale, AZ, 85285 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-22381 | PRV | Marcus Y Scott | 2003-02-20 | UHC-58921-89 | 5475676342 | 2530 Harbor Blvd, Mesa, AZ, 85252 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23162 | PRV | Elizabeth Espinoza | 1945-07-01 | UHC-70832-05 | — | 3005 Desert Sky Blvd, Glendale, AZ, 85373 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-22334 | PRV | Angela Park | 2004-01-02 | UHC-74100-67 | 4277292616 | 2773 River Rd, Columbus, OH, 43217 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26490 | PRV | Noah Wright | 1960-06-04 | — | 7834840937 | 7972 Hillcrest Rd, Scottsdale, AZ, 85253 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29262 | PRV | Camila J Price | 1972-05-11 | UHC-50192-84 | 9805047532 | 6672 Canyon Rd, Nashville, TN, 37270 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-23829 | PRV | Jacqueline Little | 1987-12-24 | — | 4069434164 | 8051 Camelback Rd, Eden Prairie, MN, 55303 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-22400 | PRV | Sofia Porter | 2002-07-04 | — | 2304349910 | 1396 Apache Blvd, Austin, TX, 78708 | 0.78 | Phone reformattedSSN last four extractedState code upper-casedWhitespace trimmed+1 more |
| PRV-20285 | PRV | Donna H Sanchez | 1979-09-22 | UHC-51598-69 | 5599370001 | 2472 Harbor Blvd, Scottsdale, AZ, 85225 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-24872 | PRV | Logan Kelly | 1978-06-24 | UHC-35916-53 | 8965104633 | 6858 Central Ave, Nashville, TN, 37221 | 0.78 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22276 | PRV | Mark Robertson | 1956-05-14 | UHC-79068-41 | 7818490952 | 3376 Indian School Rd, Phoenix, AZ, 85053 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21731 | PRV | Teresa Y Hughes | 1996-08-25 | UHC-82381-89 | 7248297926 | 7401 Oak St, Sacramento, CA, 95897 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+1 more |
| PRV-21299 | PRV | Johnny West | 1938-01-22 | — | 7749919668 | 8348 Market St, Austin, TX, 78748 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25421 | PRV | Sean Gordon | 1987-10-04 | UHC-32543-22 | 3757249175 | 6154 Canyon Rd, Mesa, AZ, 85230 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25420 | PRV | Sean Gordon | 1987-10-04 | UHC-32543-22 | 3757249175 | 6154 Canyon Rd, Mesa, AZ, 85230 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25795 | PRV | Logan Schmidt | 1940-05-01 | UHC-14333-36 | 2422240261 | 1699 Desert Sky Blvd, Mesa, AZ, 85237 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-27194 | PRV | Ahmed X Mejia | 1950-08-22 | UHC-77938-49 | 6628419650 | 8436 Indian School Rd, San Diego, CA, 92198 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24511 | PRV | Lawrence S Nichols | 1941-03-26 | UHC-23434-16 | 5985970939 | 2895 Canyon Rd, Las Vegas, NV, 89183 | 0.78 | Name re-casedPhone reformattedState code upper-casedZIP+4 trimmed+1 more |
| PRV-26849 | PRV | Sara Wallace | 1970-10-27 | UHC-48359-67 | 6659671601 | 298 Ridge Rd, Minneapolis, MN, 55471 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23923 | PRV | Tyler Allen | 1971-09-22 | — | 6758426337 | 6556 Apache Blvd, Plano, TX, 75082 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+1 more |
| PRV-24706 | PRV | Betty Hart | 1993-04-17 | — | — | — | 0.78 | Name re-casedPhone missing area codeEmail lower-casedWhitespace trimmed+1 more |
| PRV-20396 | PRV | Thomas J Griffin | 1986-12-03 | — | 8249420572 | 3794 Mountain View Dr, Charlotte, NC, 28247 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21662 | PRV | Christine D Elliott | 1956-03-08 | UHC-65978-88 | 2184941420 | 2209 Hillcrest Rd, Charlotte, NC, 28215 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27007 | PRV | Christopher Reynolds | 1962-02-17 | UHC-61478-29 | 6105832971 | 1652 Maple Ave, Orlando, FL, 32861 | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-20409 | PRV | Joseph Fields | 1967-12-01 | — | — | 704 Grand Ave, Denver, CO, 80254 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23096 | PRV | Brian Garcia | 1948-10-17 | — | 7906305029 | 678 Church St, Tampa, FL, 33625 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26410 | PRV | Randy I Lynch | 1996-09-27 | UHC-19138-60 | 8787679973 | 269 Canyon Rd, Eden Prairie, MN, 55336 | 0.78 | Two-digit birth yearPhone reformattedPlan code upper-casedWhitespace trimmed+1 more |
| PRV-28126 | PRV | Sharon Maldonado | — | UHC-48917-93 | 4786993618 | 7013 Meadow Ln, Tucson, AZ, 85755 | 0.78 | Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more |
| PRV-22940 | PRV | Zachary Hansen | 2006-09-21 | — | 9465627067 | 8690 Indian School Rd, Charlotte, NC, 28224 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21581 | PRV | Diane Santiago | 1982-08-20 | — | 6124835022 | 7407 Valley View Dr, Denver, CO, 80230 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24136 | PRV | Donna Howard | 1944-07-27 | — | 3286222434 | 5111 Bayshore Dr, Tampa, FL, 33675 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29505 | PRV | Betty Wang | 1985-06-11 | — | — | 8453 Washington St, Minneapolis, MN, 55471 | 0.78 | Name re-casedState name converted to codeEmail lower-casedWhitespace trimmed+1 more |
| PRV-22112 | PRV | Christine Marshall | 1978-11-02 | — | 5307815623 | 3165 Elm St, Houston, TX, 77095 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21195 | PRV | Judith Cruz | 1945-12-27 | — | 2975241766 | 2981 Highland Ave, Miami, FL, 33173 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20817 | PRV | Luis Payne | 1986-12-14 | — | — | 5466 Mesa Dr, Gilbert, AZ, 85234 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23193 | PRV | Helen McCoy | 2004-04-17 | — | 4133819639 | 1922 Central Ave, Phoenix, AZ, 85092 | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-29288 | PRV | Mei Santiago | 1972-08-04 | — | 8655792346 | 2981 Spring St, Sacramento, CA, 95857 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23056 | PRV | Betty I Hutner | 1989-09-07 | UHC-84042-08 | 8756302387 | 2690 Desert Sky Blvd, Seattle, WA, 98177 | 0.78 | Date of birth reformattedPhone reformattedSSN last four extractedWhitespace trimmed+1 more |
| PRV-27384 | PRV | Gerald Watson | 1959-09-14 | — | 3675314555 | 9473 Palm Dr, Chandler, AZ, 85276 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-25329 | PRV | Debra Hudson | 1999-06-22 | UHC-37158-60 | 6415311118 | 8828 Union St, Atlanta, GA, 30327 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28004 | PRV | Randy Burton | 1938-03-02 | — | 3015630417 | — | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-22141 | PRV | Carlos L Montgomery | 1956-05-18 | — | 3434117803 | 9412 Broadway, Austin, TX, 78724 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-25839 | PRV | Eric Lewis | 1979-09-26 | UHC-91782-76 | 5127804389 | 1644 Cedar Ln, Orlando, FL, 32864 | 0.78 | Date of birth reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more |
| PRV-29449 | PRV | Benjamin Walker | 1995-12-12 | UHC-70830-99 | 5879180816 | 4431 Union St, Jacksonville, FL | 0.78 | Date of birth reformattedMember ID reformattedZIP missingWhitespace trimmed+1 more |