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-20090 | PRV | Philip Le | 1980-02-05 | — | 4016238117 | 6510 Pine Dr, Glendale, AZ, 85331 | 0.78 | Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+1 more |
| PRV-29566 | PRV | Denise Rogers | 1996-05-21 | UHC-63267-36 | 3935128684 | 6840 Ocean Ave, San Diego, CA, 92153 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20460 | PRV | Gerald Sullivan | 1938-07-08 | UHC-32009-78 | 4887059377 | 5553 Grand Ave, Dallas, TX, 75264 | 0.78 | Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-25905 | PRV | Jaon Le | 1962-09-25 | UHC-35979-49 | 8633354878 | 2959 Maple Ave, San Diego, CA, 92121 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-22050 | PRV | Laura Burke | 1972-11-18 | UHC-40110-94 | — | 5085 Market St, Seattle, WA, 98185 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-22647 | PRV | Gary Richards | 1994-12-26 | — | — | 720 Union St, Mesa, AZ, 85208 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22341 | PRV | Michelle Lee | 1952-02-03 | UHC-44850-78 | — | 88 Highland Ave, Charlotte, NC, 28211 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-29501 | PRV | Arjun Hanson | 1962-01-24 | UHC-47578-88 | 6287326931 | 7609 Spring St, Seattle, WA, 98109 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25007 | PRV | Charles L Webb | 1990-08-11 | UHC-53654-01 | 4444079877 | 2023 Desert Sky Blvd, Las Vegas, NV, 89154 | 0.78 | Two-digit birth yearPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-29556 | PRV | Stephanie Allen | 1957-04-18 | UHC-26220-93 | 7875833154 | 3199 Market St, Los Angeles, CA, 90086 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26324 | PRV | Lukia Vazquez | 1970-06-11 | — | 6337599464 | 4165 Meadow Ln, Fresno, CA, 93711 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20122 | PRV | Valentina S Gomez | 1980-09-13 | UHC-76561-42 | 3232465980 | 5672 Church St, Mesa, AZ, 85253 | 0.78 | Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-22277 | PRV | Patrick Morris | 1992-10-26 | — | 5335151382 | 3131 Palm Dr, Eden Prairie, MN, 55381 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24184 | PRV | Kathleen C Knight | 1981-08-22 | — | 2336873624 | 3149 Park Pl, Dallas, TX, 75204 | 0.78 | Middle initial moved out of first namePhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-26710 | PRV | Arjun J Carter | — | — | 8855956045 | 9536 Sunset Blvd, Tampa, FL, 33607 | 0.78 | Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more |
| PRV-28022 | PRV | Daniel Nunez | 1954-01-09 | — | 2176217578 | 580 Church St, Glendale, AZ, 85333 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27225 | PRV | Amber Perkins | 1978-11-22 | UHC-05855-16 | — | 5171 Elm St, Charlotte, NC, 28204 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23791 | PRV | Kathryn H Moreno | 1988-12-02 | UHC-94649-01 | 5587599229 | 9188 Grand Ave, Columbus, OH, 43239 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24820 | PRV | Henry Olson | 1999-05-16 | — | 3983088282 | 3416 Pine Dr, Miami, FL, 33112 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25774 | PRV | Wei Woods | 2003-02-07 | — | 6022887750 | 4294 Valley View Dr, San Diego, CA, 92162 | 0.78 | Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+1 more |
| PRV-20608 | PRV | Michael Z Boyd | 1992-07-23 | — | 3975431757 | 5328 Ridge Rd, San Antonio, TX | 0.78 | Date of birth reformattedPhone reformattedZIP missingWhitespace trimmed+1 more |
| PRV-22974 | PRV | Dylen Wheeler | 2000-01-26 | UHC-34756-24 | 7058103344 | 5635 Palm Dr, Eden Prairie, MN, 55303 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-25373 | PRV | Logan Richardson | 1981-11-11 | UHC-44547-13 | 3566552589 | 2481 Apache Blvd, Las Vegas, NV, 89167 | 0.78 | Name re-casedDate of birth reformattedState code upper-casedZIP+4 trimmed+1 more |
| PRV-23977 | PRV | Jacob Wbeb | 1985-05-07 | UHC-07880-02 | — | 6904 Broadway # 970, Houston, TX, 77048 | 0.78 | Name re-casedDate of birth reformattedUnit split from streetAddress re-cased+1 more |
| PRV-21647 | PRV | Christopher Payne | 2000-05-20 | — | 6947650155 | 6425 Desert Sky Blvd, Miami, FL, 33151 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26656 | PRV | Gloria Dean | 1938-09-23 | — | 2404923032 | — | 0.78 | Phone reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more |
| PRV-21492 | PRV | Steven E Elliott | 1998-11-26 | UHC-18138-25 | — | 8792 Pine Dr, Gilbert, AZ, 85241 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25114 | PRV | Nancy Banks | 1955-03-10 | UHC-78948-13 | 2483066386 | 3184 Bayshore Dr, Chandler, AZ, 85233 | 0.78 | Name re-casedDate of birth reformattedState name converted to codeEmail lower-cased+1 more |
| PRV-27750 | PRV | Aaron Davis | 1968-09-21 | UHC-45592-84 | 7727838164 | 1381 Highland Ave, San Antonio, TX, 78234 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27862 | PRV | Abigail X Santiago | 1947-05-18 | — | 4923525911 | 2848 Apache Blvd, Scottsdale, AZ, 85222 | 0.78 | Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-20795 | PRV | Michelle Rodriguez | 1970-02-01 | — | 6164451282 | 9037 Bayshore Dr, Denver, CO, 80227 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27268 | PRV | Nathan E Yang | 1957-05-21 | — | 4949271401 | 4848 Hillcrest Rd, Los Angeles, CA, 90002 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-22595 | PRV | Jacob F Cruz | 1988-07-09 | UHC-04690-02 | 9257108550 | 7937 Lincoln Way, San Diego, CA, 92162 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24007 | PRV | Russell J Le | 1978-09-17 | — | 4832926556 | 5812 Spring St, Austin, TX, 78725 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more |
| PRV-20196 | PRV | David Medina | 2006-04-26 | UHC-31366-75 | 5305152628 | — | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-21358 | PRV | Roneld Brooks | 1990-04-28 | — | 4632940381 | 7486 Union St, Glendale, AZ, 85382 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22988 | PRV | Keith Torres | 1956-12-22 | — | 9066891591 | 8102 Main St, Houston, TX, 77018 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26142 | PRV | Carlos Dean | 1970-08-04 | UHC-27915-16 | 2114532730 | — | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-24450 | PRV | Lisa Cruz | 2000-07-10 | — | 2583181027 | 6093 Hillcrest Rd, Scottsdale, AZ, 85208 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26603 | PRV | Matthew Hoffman | 1995-04-23 | UHC-49069-01 | 2903733827 | 3568 Church St, Gilbert, AZ, 85231 | 0.78 | Phone reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more |
| PRV-25447 | PRV | Arthur Hunt | 1914-03-03 | UHC-45720-74 | 8695945763 | 6255 Valley View Dr, Columbus, OH, 43246 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-28508 | PRV | Dorothy Hicks | 1946-08-25 | — | 4155760904 | 7841 River Rd, Tucson, AZ, 85755 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23186 | PRV | Keith Palmer | 1984-02-21 | — | 6806927523 | 7266 Meadow Ln, Columbus, OH, 43211 | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-29122 | PRV | Grace Porter | 1948-11-03 | UHC-43858-93 | 7486168913 | 1565 Indian School Rd, Seattle, WA, 98192 | 0.78 | Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-20233 | PRV | Arthur W Stephens | 1950-02-25 | — | 9336106282 | 8084 Union St, Orlando, FL, 32888 | 0.78 | Date of birth reformattedPhone reformattedCity re-casedGender normalised+1 more |
| PRV-25718 | PRV | Christina Morgan | 2007-03-17 | — | 6007923722 | 5927 Cedar Ln, Phoenix, AZ, 85021 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21114 | PRV | Jose Rivera | 2000-11-18 | — | 9239886567 | 1290 Union St, Mesa, AZ, 85228 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28633 | PRV | Diego Harveey | — | — | 6824100692 | — | 0.78 | Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more |
| PRV-24525 | PRV | Soofia I Lopez | 1997-04-09 | — | 6672772546 | — | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-22129 | PRV | Jeffrey Green | 1988-05-13 | — | 5662782770 | 4405 Camelback Rd, Orlando, FL, 32885 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |