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-22033 | PRV | Robert K Romero | 1986-11-18 | UHC-84309-91 | 2892436915 | 4570 Baseline Rd, Tucson, AZ, 85780 | 0.62 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-24809 | PRV | Stephen Weber | 1987-01-28 | — | 6874491291 | 8952 Sage Ct, Charlotte, NC, 28253 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26406 | PRV | Philip Andrews | 1970-08-06 | — | 9803898782 | 5061 Elm St, Nashville, TN, 37274 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-26282 | PRV | Katherine V Willis | 1995-08-27 | — | — | 7286 Market St, Tampa, FL, 33675 | 0.62 | Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26583 | PRV | Peer Payne | 1994-06-07 | — | 2385128845 | 4592 Maple Ave, Atlanta, GA, 30378 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22720 | PRV | Scott Johnston | 1991-06-01 | UHC-09585-03 | 5782113159 | 8261 Pine Dr, San Diego, CA, 92181 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-24444 | PRV | Jannet Hernandez | 1956-04-08 | UHC-93819-19 | 9423625956 | 5958 Meadow Ln, Tampa, FL, 33687 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26589 | PRV | Lias Ferguson | 1965-10-13 | UHC-46337-12 | 5077289719 | 4972 Cedar Ln # 107, Eden Prairie, MN, 55370 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-22127 | PRV | Grace Phillips | 1939-01-26 | — | 2322617469 | 7250 Pine Dr, Houston, TX, 77002 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25953 | PRV | Daniel Webb | 1951-10-12 | UHC-29575-59 | 3948521162 | 4456 Harbor Blvd, Denver, CO, 80231 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29022 | PRV | Matthew Cox | 1952-01-15 | UHC-62478-86 | 8509834923 | 6971 Park Pl, Atlanta, GA, 30377 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27713 | PRV | Joe S Mills | 1948-12-08 | — | 8457087300 | 2003 Mountain View Dr # 463, Miami, FL, 33167 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-21229 | PRV | Daniel O Duncan | 1938-07-21 | — | 7425243732 | 6999 Canyon Rd, Houston, TX, 77066 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22213 | PRV | Camila Sandoval | — | — | 6153861685 | 7717 Ocean Ave, Jacksonville, FL, 32220 | 0.62 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22203 | PRV | Joan Duncan | 1950-01-11 | UHC-35968-68 | 9008536637 | 8323 Spring St, Los Angeles, CA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20216 | PRV | Karen T Rojas | 1996-05-21 | UHC-95344-65 | 9038384737 | 6039 Sage Ct # 528, Miami, FL, 33184 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-24701 | PRV | Aaron T Simpson | 2005-05-22 | UHC-21933-26 | 6439817281 | 659 Washington St, Miami, FL, 33175 | 0.62 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26735 | PRV | Vincent Russll | 1998-07-01 | — | 7283810394 | 1656 Maple Ave, Eden Prairie, MN, 55319 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26736 | PRV | Vincent Russll | 1998-07-01 | — | 7283810394 | 1656 Maple Ave, Eden Prairie, MN, 55319 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20537 | PRV | Jeremy Bailey | 1956-06-22 | — | 4675944062 | 2491 Cedar Ln, Fresno, CA, 93755 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-22279 | PRV | Eugene H Kellly | 1976-07-07 | UHC-59154-82 | 8614086016 | 1751 Valley View Dr, Miami, FL, 33148 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28018 | PRV | Matthew Padilla | 1988-06-22 | UHC-76766-77 | 7206064212 | 4283 Valley View Dr, San Diego, CA, 92134 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-21066 | PRV | Catherine Herrera | 1959-05-15 | UHC-29635-57 | 9716543306 | 6478 Canyon Rd, San Antonio, TX | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24461 | PRV | Jean J Carpenter | 1966-02-01 | UHC-69541-09 | 7779916915 | 3025 Bayshore Dr Apt 23, Tempe, AZ, 85287 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-24997 | PRV | Elijah Myers | 1989-12-09 | — | 5506243373 | 3062 Highland Ave, Dallas, TX, 75233 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20327 | PRV | Maria L Long | 1972-11-04 | UHC-89960-59 | 9763378811 | 5897 Central Ave, Glendale, AZ, 85322 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24477 | PRV | Ethan Ortiz | 1968-07-09 | — | 6939202181 | 3946 Park Pl, Nashville, TN, 37215 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-22032 | PRV | Gerald Davis | 1959-07-13 | — | 7918239090 | 7154 Pine Dr, Tempe, AZ, 85215 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-21525 | PRV | Eugene Owens | 2008-05-22 | UHC-90372-35 | 2488505614 | 3082 Indian School Rd, Dallas, TX, 75238 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28148 | PRV | Mark Lopez | 1954-09-19 | UHC-01657-31 | 2959574362 | 810 Mesa Dr Apt 13, Sacramento, CA, 95812 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-25018 | PRV | Philip Mejia | 1940-07-22 | — | 3108702256 | 6716 Central Ave, Plano, TX, 75019 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-28945 | PRV | Janet Grant | 1991-05-18 | — | 4312737256 | 7089 Willow Ct, Los Angeles, CA, 90080 | 0.62 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23355 | PRV | Kayla L Ramos | 1946-06-04 | — | 4414144068 | 7515 Market St, Charlotte, NC, 28233 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21158 | PRV | Sean Allen | 1993-09-14 | — | 4958396051 | 1226 Willow Ct, Los Angeles, CA, 90091 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27532 | PRV | Betty Griffin | 1981-06-15 | — | 7358929307 | 3605 Washington St, Houston, TX, 77096 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-21562 | PRV | Judith Cooper | 1957-01-28 | — | — | 6211 Palm Dr, Eden Prairie, MN, 55331 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| PRV-21561 | PRV | Judith Cooper | 1957-01-28 | — | — | 6211 Palm Dr, Eden Prairie, MN, 55331 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| PRV-25670 | PRV | Karen S Rivera | 1984-05-22 | — | 6439595537 | 9144 Ridge Rd, Fresno, CA, 93779 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21312 | PRV | Jacob Simpson | 2000-01-24 | UHC-02926-18 | 6627987381 | 4452 Maple Ave, Charlotte, NC, 28267 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24230 | PRV | Aisha Ryan | 2006-03-11 | — | 9812238695 | 7550 Spring St, Gilbert, AZ, 85220 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-29027 | PRV | Christopher Ross | 1990-02-16 | UHC-51132-99 | 7698326458 | 5213 Spring St, Seattle, WA, 98152 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-27553 | PRV | Heather Meyer | 1985-05-19 | UHC-17486-97 | 6239850085 | 9200 Harbor Blvd, Charlotte, NC, 28252 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25390 | PRV | Sean Yang | 1966-01-27 | — | 8445415132 | 9465 Palm Dr, San Diego, CA, 92191 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26207 | PRV | Donald Daniels | — | — | 6124238839 | 6814 Valley View Dr, Dallas, TX, 75290 | 0.62 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28640 | PRV | Maria Rose | 1968-09-16 | — | 7594134013 | 1103 Sunset Blvd, Seattle, WA | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-26560 | PRV | Jacob Wallace | 1969-05-04 | UHC-66285-29 | 8632623231 | 9419 Sage Ct, Minneapolis, MN, 55451 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20192 | PRV | Amanda D Wheeler | 1938-07-07 | — | 7297087633 | 9600 Maple Ave, Phoenix, AZ, 85055 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27101 | PRV | Doris Thomas | 1984-12-15 | UHC-73006-67 | 5944511673 | 1951 Union St, San Diego, CA, 92188 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| PRV-22414 | PRV | Camla Sandoval | 1983-09-18 | UHC-60824-59 | 4592179167 | 5221 Broadway # 109, Seattle, WA, 98142 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-24508 | PRV | Julie Allen | 2006-07-18 | — | 9586179676 | 455 Indian School Rd, Dallas, TX, 75215 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |