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-24557 | PRV | Aisha Q Henderon | 1986-02-18 | — | 6573880632 | 563 Spring St, San Antonio, TX, 78287 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23513 | PRV | Lawrence Garza | 1959-02-09 | — | 2267021806 | 6718 Park Pl, Las Vegas, NV, 89176 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23514 | PRV | Lawrence Garza | 1959-02-09 | — | 2267021806 | 6718 Park Pl, Las Vegas, NV, 89176 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23678 | PRV | Eugene Richardson | 1956-02-08 | UHC-44774-84 | 6603350643 | 2383 Camelback Rd Apt 1, Tucson, AZ, 85770 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more |
| PRV-22888 | PRV | Scott S Hart | 1962-04-02 | UHC-39979-07 | 4126057459 | 7942 Oak St, Miami, FL, 33100 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22487 | PRV | Adams Jacqueline | 1996-06-09 | UHC-65215-45 | — | 5404 Spring St, Houston, TX, 77067 | 0.76 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26518 | PRV | Matthew Schmidt | 1990-04-09 | — | 7876960213 | 3401 Pine Dr, Glendale, AZ, 85381 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22787 | PRV | Kevin W Stewart | 1974-06-17 | UHC-27292-56 | 8483260593 | 5356 Washington St, Phoenix, AZ, 85065 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22786 | PRV | Kevin W Stewart | 1974-06-17 | UHC-27292-56 | 8483260593 | 5356 Washington St, Phoenix, AZ, 85065 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24891 | PRV | Victoria Taylor | 1984-12-03 | — | 5944035375 | 5710 Harbor Blvd, San Diego, CA, 92190 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25869 | PRV | Lauren McCoy | 1946-01-06 | — | 5459437491 | 692 Spring St, Charlotte, NC, 28248 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28437 | PRV | Sophia Park | 1970-03-08 | UHC-14809-43 | 7796971528 | 6165 Grand Ave, Austin, TX, 78742 | 0.76 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-21252 | PRV | Danielle Long | 1998-01-10 | UHC-61358-21 | 8696088611 | 105 Ocean Ave, Los Angeles, CA, 90077 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23943 | PRV | Yuki N Patel | 1970-03-23 | — | 8776403575 | 4070 Baseline Rd, Chandler, AZ, 85210 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25074 | PRV | Ashley Fields | 1986-05-25 | UHC-74750-45 | — | — | 0.76 | Name re-casedDate of birth reformattedMember ID reformattedGender normalised+2 more |
| PRV-26091 | PRV | Omar Guerrero | 1949-02-11 | — | 2767338359 | 6655 Church St, Atlanta, GA, 30399 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22811 | PRV | Brian Reid | 1972-04-13 | — | 2792120513 | 7920 Valley View Dr, Orlando, FL, 32843 | 0.76 | Name re-casedPhone reformattedState code upper-casedGender normalised+2 more |
| PRV-22303 | PRV | Bryan Lopez | 1952-11-09 | — | — | 7665 Elm St, Denver, CO, 80287 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-24006 | PRV | Sean Andrews | 1961-10-20 | UHC-41599-44 | 5742116430 | 6743 Highland Ave, Denver, CO, 80239 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more |
| PRV-25117 | PRV | Danielle Jordan | 1973-12-20 | UHC-72650-33 | — | 2275 Hillcrest Rd, Sacramento, CA, 95836 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21049 | PRV | Jessica G Rios | 1950-07-04 | — | 6348221949 | 552 Spring St, Charlotte, NC, 28238 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-21722 | PRV | Andrea Washington | 1981-01-01 | UHC-84724-16 | 6508071942 | 912 Palm Dr, Charlotte, NC, 28285 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27653 | PRV | Kevin H Ortega | 1950-11-09 | — | — | 7358 Oak St, Houston, TX, 77057 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26145 | PRV | Gary Jenkins | 1989-05-08 | — | 2377162164 | 5509 Palm Dr, Jacksonville, FL, 32273 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26146 | PRV | Gary Jenkins | 1989-05-08 | — | 2377162164 | 5509 Palm Dr, Jacksonville, FL, 32273 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25840 | PRV | Olivya Z Arnold | 1940-05-23 | UHC-48489-95 | 8006046003 | 5441 Willow Ct, Scottsdale, AZ, 85216 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-27354 | PRV | Frances Weaver | 1999-12-23 | — | 8169184825 | 9050 Camelback Rd, Seattle, WA, 98143 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-25901 | PRV | Bryan Banks | 1985-07-06 | — | 4117616199 | 1805 Palm Dr, Phoenix, AZ, 85090 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-28900 | PRV | Christina V Mills | 1968-09-02 | UHC-64877-91 | 7227301526 | 2856 Grand Ave, Fresno, CA, 93737 | 0.76 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26452 | PRV | Betty Morales | 1968-05-13 | UHC-75997-35 | 4278558517 | 532 Palm Dr, Sacramento, CA, 95834 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-24888 | PRV | Catherine Robinson | 1952-06-07 | — | 5067668750 | — | 0.76 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more |
| PRV-21573 | PRV | Walter X Espinoza | 1976-05-06 | — | 5095932183 | 9590 Bayshore Dr, Gilbert, AZ, 85229 | 0.76 | Name re-casedDate of birth reformattedEmail lower-casedGender normalised+2 more |
| PRV-24398 | PRV | Alex Welch | 1986-01-05 | UHC-67317-69 | 7666300088 | 2046 Palm Dr, Fresno, CA, 93727 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28598 | PRV | Raymond Richards | 1962-10-21 | UHC-30938-76 | 5183840984 | 4610 Union St, Charlotte, NC, 28270 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23168 | PRV | Fatima Harris | 1993-07-21 | — | 8727874024 | 9585 Oak St, Tampa, FL, 33629 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27420 | PRV | Day Catherine | 1943-07-04 | UHC-08875-72 | 6987277846 | 5538 Grand Ave, Plano, TX | 0.76 | Name re-casedPhone reformattedMember ID reformattedZIP missing+2 more |
| PRV-21883 | PRV | Angela King | 1998-07-19 | UHC-52357-03 | 8092970983 | 5763 River Rd, Eden Prairie, MN, 55354 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26227 | PRV | Dick Lawrence | 1950-10-16 | — | 6272118276 | 6026 Church St, Gilbert, AZ, 85225 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-27883 | PRV | Larry Stephens | 1941-12-13 | — | 7573856113 | 6390 Camelback Rd, Las Vegas, NV, 89126 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27364 | PRV | Nick Arnold | 1980-06-27 | — | 6539570181 | 9623 Forest Ave, Chandler, AZ, 85259 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-20350 | PRV | Martha Padilla | 1940-01-26 | UHC-51567-53 | 3902255298 | 3228 River Rd, Tempe, AZ, 85202 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more |
| PRV-23847 | PRV | Susan Wong | 1939-04-05 | — | 4805225549 | 730 Desert Sky Blvd, Sacramento, CA, 95826 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21198 | PRV | James Cunningham | 1949-02-15 | — | 5092376050 | 7014 Desert Sky Blvd, Denver, CO, 80253 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27890 | PRV | Joe Harvey | 1970-03-07 | — | 6054023698 | 7400 Spring St, Orlando, FL, 32890 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-25656 | PRV | Russell Parker | 1970-08-10 | UHC-91285-73 | 6027276902 | 3317 Oak St, Las Vegas, NV, 89180 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28555 | PRV | Melissa Vega | 1973-10-25 | — | 6497958231 | 5150 Park Pl, Tempe, AZ | 0.76 | Name re-casedDate of birth reformattedPhone reformattedZIP missing+2 more |
| PRV-29077 | PRV | Mark Gardner | 1966-02-12 | — | 3145760286 | 607 Harbor Blvd, Charlotte, NC, 28207 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23813 | PRV | Zachary P Morales | 1995-08-08 | UHC-95210-09 | 5612126194 | 9060 Washington St, Tampa, FL, 33656 | 0.76 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-25603 | PRV | Carolyn Pierce | 1990-11-13 | UHC-31172-20 | 8409420975 | 2381 Mountain View Dr, Jacksonville, FL, 32296 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21714 | PRV | Larry I Bradley | 1979-01-15 | — | 4323159224 | 1967 Meadow Ln, Tucson, AZ, 85756 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |