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-24348 | PRV | Patrikk Nguyen | 2001-11-21 | UHC-62124-12 | 6962571225 | 4943 Elm St, Sacramento, CA, 95809 | 0.74 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28432 | PRV | Gregory Pena | 1944-04-24 | UHC-46769-63 | 5237698601 | 1872 Meadow Ln, Columbus, OH, 43218 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21458 | PRV | Santiago Torres | 1961-06-15 | — | 2596244074 | 5968 Park Pl, Tucson, AZ, 85756 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20521 | PRV | Virginia E Castillo | 1992-06-06 | UHC-00947-15 | — | 6133 Canyon Rd, Los Angeles, CA, 90090 | 0.74 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-28096 | PRV | Tyler Sanders | 1995-01-19 | — | 6497244073 | 1664 Forest Ave, Minneapolis, MN, 55456 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23920 | PRV | Bradley N Johnson | 1940-08-14 | UHC-61999-90 | 5215706159 | 5772 Ocean Ave, Mesa, AZ, 85292 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25014 | PRV | Naatlie Shaw | 1966-08-15 | UHC-04451-66 | 2396014239 | 491 Palm Dr, Sacramento, CA, 95819 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20168 | PRV | Diego Sanchez | 1965-02-07 | UHC-13365-28 | 5905475100 | 9567 Park Pl, Charlotte, NC, 28231 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| PRV-28716 | PRV | Sam Rodriguez | 1969-03-03 | UHC-63074-78 | 2075511467 | 3532 Sage Ct # 296, Sacramento, CA, 95843 | 0.74 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more |
| PRV-27434 | PRV | Alan Wheeler | 1941-03-09 | — | 2066442524 | 2513 Bayshore Dr, Las Vegas, NV, 89167 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25575 | PRV | Robert B Washingtun | 1969-04-03 | UHC-52616-95 | — | 8721 Apache Blvd, Miami, FL, 33146 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29184 | PRV | Christina A Silva | 1989-01-20 | — | 5524932005 | 4021 Maple Ave, Las Vegas, NV, 89161 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27642 | PRV | Ruth Z Ross | 1970-04-21 | — | 5392567651 | 3071 Canyon Rd, Phoenix, AZ, 85096 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-28415 | PRV | Frances Carlson | 1966-02-26 | UHC-63471-05 | 5128971480 | 6154 Grand Ave, Tampa, FL, 33608 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-28338 | PRV | Elijah Z Le | 1964-09-23 | UHC-95173-48 | — | 9800 Elm St, Fresno, CA, 93709 | 0.74 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25289 | PRV | Adam O Rodriguez | 1997-06-16 | — | 4485379656 | 7818 Oak St, San Diego, CA, 92131 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21844 | PRV | Dunn Terry | 1970-06-22 | — | 4193152449 | 1568 Cedar Ln, San Antonio, TX, 78202 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26805 | PRV | Alan Adams | 1967-08-10 | UHC-50559-22 | 2804951766 | 3569 Meadow Ln, Minneapolis, MN, 55480 | 0.74 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more |
| PRV-27941 | PRV | Marilyn Guerrero | 1997-05-12 | UHC-29798-32 | 9315663424 | 3267 Mesa Dr, Orlando, FL, 32804 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-20552 | PRV | Catherine J Bishop | 1967-10-17 | — | 2628916417 | 513 Ocean Ave, Tempe, AZ, 85221 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26168 | PRV | Grace N Patterson | 1983-10-22 | UHC-65183-74 | 9579054803 | 2433 Forest Ave, Jacksonville, FL, 32214 | 0.74 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25040 | PRV | Juan George | 1969-10-12 | UHC-51548-97 | 6812589562 | 416 Hillcrest Rd, Austin, TX, 78790 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28433 | PRV | Andrea Boyd | 2001-04-15 | — | 4288102609 | 6842 Harbor Blvd, Columbus, OH, 43208 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20616 | PRV | Nancy Carr | 1981-10-16 | UHC-63787-77 | 3997255243 | 489 Market St, Sacramento, CA, 95855 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24328 | PRV | Carlos U Ramos | 1967-06-09 | UHC-80608-77 | 6347624987 | 2238 Indian School Rd, Tempe, AZ, 85255 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25251 | PRV | Brenda H Santiago | 1995-01-10 | — | 5637327961 | 7882 Washington St, Glendale, AZ, 85377 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25399 | PRV | Omar Rivera | 1956-11-01 | UHC-34231-80 | 9509040727 | 2530 Sunset Blvd, Tampa, FL, 33636 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| PRV-25636 | PRV | Mark Greene | 1991-10-25 | UHC-68929-38 | 2454801147 | 9173 Meadow Ln, Dallas, TX, 75223 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22548 | PRV | Bailey Harold | 1979-08-05 | — | — | 2892 Maple Ave, Tucson, AZ, 85756 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29342 | PRV | Charles Jordan | 1963-03-19 | — | 8562325024 | 9327 Pine Dr, Las Vegas, NV, 89168 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25618 | PRV | Mateo Wilson | 1980-06-19 | — | 4416471125 | 4537 Highland Ave, Dallas, TX, 75236 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26357 | PRV | George Robinson | 1999-01-11 | — | 9589138536 | 4700 Highland Ave, Miami, FL, 33160 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24241 | PRV | Noah Garrett | 1948-06-17 | UHC-99638-91 | 7952268932 | 3201 Sunset Blvd, Charlotte, NC, 28246 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-23834 | PRV | Ann X Fields | 1946-01-03 | UHC-32591-81 | 2802824556 | 5259 Valley View Dr, Tempe, AZ, 85241 | 0.74 | Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+3 more |
| PRV-28936 | PRV | Arnold U Kethleen | 1967-02-03 | UHC-42875-96 | 8216902371 | 5324 Willow Ct, Minneapolis, MN, 55496 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-23242 | PRV | Helne Robinson | 1996-03-10 | — | 6532054941 | 1332 Hillcrest Rd, Atlanta, GA, 30378 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29429 | PRV | Lisa S Nelson | 1971-08-13 | UHC-22297-46 | 4947561674 | 4376 Mesa Dr, Scottsdale, AZ, 85289 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20895 | PRV | Carlos Z Davis | 1969-10-11 | — | 9248904846 | 7596 Indian School Rd, Phoenix, AZ, 85098 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22605 | PRV | Elizabeth Bell | 1969-12-27 | UHC-65359-87 | 3476491358 | 4741 Hillcrest Rd, Dallas, TX, 75249 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27482 | PRV | Joan Santos | 1978-01-04 | — | 5335437294 | 8108 Ridge Rd, Dallas, TX, 75208 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28251 | PRV | Bruce Garrett | 1950-06-24 | UHC-17603-90 | 4155548487 | 9636 Bayshore Dr, Columbus, OH, 43299 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22040 | PRV | Diane Gibson | 1978-01-07 | — | 7289213628 | 8641 Highland Ave, Austin, TX, 78720 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25919 | PRV | Ralph Jacobs | 1982-04-19 | UHC-34844-14 | 6469023287 | 3178 Lincoln Way, Jacksonville, FL, 32271 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26140 | PRV | Danielle Russell | 1991-07-01 | — | 4739164877 | 2379 Forest Ave, Tucson, AZ, 85737 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-28877 | PRV | Pamela Wallace | 1988-03-20 | — | 6877075010 | 8337 Bayshore Dr, Tempe, AZ, 85298 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25383 | PRV | Christopher Cunningham | 1990-03-02 | UHC-09111-69 | 8775872086 | 9136 Apache Blvd, Seattle, WA, 98120 | 0.74 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-25598 | PRV | Arjun Rojas | 1990-12-11 | — | 4594541601 | 9833 Jefferson Ave, Chandler, AZ, 85299 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25513 | PRV | Ethan Davis | 1973-12-20 | — | 6292019441 | 6281 River Rd, Eden Prairie, MN, 55344 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26570 | PRV | Amber Hamilton | 1988-09-26 | UHC-84817-87 | 3644457321 | 3555 Forest Ave, Mesa, AZ, 85274 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20291 | PRV | Christian I Williamson | 1974-08-05 | UHC-01208-77 | 6646702564 | 3455 Oak St, Chandler, AZ, 85285 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |