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-20359 | PRV | Victoria Wilson | 1951-06-12 | UHC-11161-09 | 9346631750 | 9848 Indian School Rd, Jacksonville, FL | 0.78 | Date of birth reformattedPhone reformattedZIP missingWhitespace trimmed+1 more |
| PRV-21528 | PRV | Sandra Weeber | 1963-07-13 | UHC-22732-27 | 7909447106 | 525 Canyon Rd, Mesa, AZ, 85278 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28827 | PRV | Justin Warren | 2007-01-18 | — | 3529052564 | 9861 Harbor Blvd Apt 23, Atlanta, GA, 30328 | 0.78 | Phone reformattedUnit split from streetCity re-casedWhitespace trimmed+1 more |
| PRV-28674 | PRV | Mateo T Riley | 1995-03-20 | UHC-78610-28 | 6438338072 | 231 Cedar Ln, Eden Prairie, MN, 55313 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27103 | PRV | Doris Powell | 1975-10-28 | — | 8973165951 | 1164 Grand Ave, Las Vegas, NV, 89153 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24982 | PRV | Jnoathan Alvarez | 2005-09-12 | UHC-37217-80 | 5853818945 | 7872 Meadow Ln, Eden Prairie, MN, 55392 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27207 | PRV | Samuel Simmnos | 1945-05-25 | UHC-47169-69 | — | 519 Grand Ave, Orlando, FL, 32885 | 0.78 | Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more |
| PRV-26276 | PRV | Emma K Hayes | 1947-11-22 | UHC-08659-93 | 4386184440 | 7363 Cedar Ln, Charlotte, NC, 28215 | 0.78 | Phone reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more |
| PRV-27715 | PRV | Jose Hunter | 2001-02-17 | UHC-26224-70 | — | 9111 Maple Ave, Seattle, WA, 98100 | 0.78 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26997 | PRV | Janet G Medina | 1969-11-27 | UHC-08466-39 | 8256302595 | 9565 Lake View Rd, Scottsdale, AZ, 85226 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-25431 | PRV | Pamela Bryant | 1960-03-17 | — | 6159289513 | 609 Lake View Rd, Los Angeles, CA, 90019 | 0.78 | Phone reformattedZIP+4 trimmedEmail lower-casedWhitespace trimmed+1 more |
| PRV-25802 | PRV | Mery Franklin | 1942-09-17 | UHC-63571-51 | 2198708516 | 728 Washington St, Austin, TX, 78725 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26613 | PRV | Michael Reynolds | 2006-01-17 | UHC-88165-10 | 4427216562 | 6996 Cedar Ln, Dallas, TX, 75289 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29509 | PRV | Michael Z Baker | 1986-06-09 | UHC-59475-73 | 6973352647 | 9543 Ocean Ave, Tempe, AZ, 85202 | 0.78 | Date of birth reformattedState code upper-casedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-21180 | PRV | Nicholas Crawford | 2005-03-02 | UHC-87530-99 | 9496814784 | 8939 Palm Dr, Houston, TX, 77065 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23602 | PRV | Benjamin Robinson | 2006-11-02 | UHC-34560-42 | 2866185207 | 5706 Church St, Scottsdale, AZ, 85295 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22495 | PRV | Ralph Carpenter | 1967-06-11 | — | 7894909266 | 9818 Baseline Rd, Jacksonville, FL, 32236 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-26443 | PRV | Jose Weber | 1983-03-07 | — | 5296399108 | 7632 Mesa Dr, Tempe, AZ, 85255 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-22225 | PRV | Joe Silva | 1944-11-08 | UHC-53993-88 | 3675180514 | 3387 River Rd, Mesa, AZ, 85247 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20163 | PRV | Tyler Moreno | 1994-11-12 | UHC-79913-58 | 2462919795 | 1312 Ridge Rd, Seattle, WA, 98120 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20389 | PRV | Steven Lewis | 1941-11-08 | UHC-52617-07 | — | 5512 Ridge Rd, Glendale, AZ | 0.78 | Name re-casedDate of birth reformattedCity re-casedZIP missing+1 more |
| PRV-23989 | PRV | Logan H Wang | 2001-03-04 | — | 5619720419 | 9242 Park Pl, Phoenix, AZ, 85058 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21209 | PRV | Benjamin Rihcardson | 1958-04-17 | UHC-80303-69 | 5606446879 | 6480 Indian School Rd, Dallas, TX, 75277 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-29412 | PRV | Diane Chavez | 1971-09-18 | — | 3069769457 | 7566 Mountain View Dr, Jacksonville, FL, 32255 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23670 | PRV | Abigail Alexander | 1940-03-04 | — | 5822914748 | 6190 Indian School Rd, Atlanta, GA, 30392 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25684 | PRV | Scott Tran | 1976-08-06 | UHC-47745-73 | 8696995329 | 1201 Palm Dr, Houston, TX, 77031 | 0.78 | Name re-casedPhone reformattedMember ID reformattedGender normalised+1 more |
| PRV-22515 | PRV | Knneth U Larson | 1982-07-22 | UHC-86392-72 | 3224386680 | 3899 Central Ave, Tempe, AZ, 85267 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26092 | PRV | Roy X Young | 1964-04-11 | — | 6443274383 | 3149 Mountain View Dr, Jacksonville, FL, 32273 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20715 | PRV | Ethan Hughes | 1959-03-09 | — | 4583701146 | 3985 Palm Dr, Tucson, AZ, 85755 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28953 | PRV | Mateo K Patel | 1961-03-05 | UHC-36080-99 | 5076092351 | 8109 Canyon Rd, San Antonio, TX, 78253 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+1 more |
| PRV-25200 | PRV | Henry Jacobs | 1983-09-26 | — | 3334796139 | 9810 Palm Dr, Houston, TX, 77083 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28418 | PRV | Lawrence Little | 1939-09-04 | — | 2588354136 | 8794 Harbor Blvd, Phoenix, AZ, 85094 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25075 | PRV | Diego Wood | 1998-05-03 | — | 7676343463 | — | 0.78 | Two-digit birth yearPhone reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-21615 | PRV | Mason Gomez | 1962-04-19 | — | 7955081423 | 3565 Hillcrest Rd, Gilbert, AZ, 85264 | 0.78 | Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more |
| PRV-25861 | PRV | Judy Schmidt | 2002-02-05 | — | 6373923645 | 4339 Park Pl, Tempe, AZ, 85233 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-26343 | PRV | Joe G Stewart | 1953-02-11 | UHC-21317-80 | 5262346068 | 286 Sage Ct, Los Angeles, CA, 90063 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+1 more |
| PRV-27678 | PRV | Wei Arnold | 1976-05-23 | UHC-93430-91 | 5936496455 | 9213 Pine Dr, Glendale, AZ, 85331 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28393 | PRV | Harold Sandoval | 2006-12-28 | UHC-13759-35 | 8739872211 | 3094 Mountain View Dr, Jacksonville, FL | 0.78 | Name re-casedPhone reformattedZIP missingWhitespace trimmed+1 more |
| PRV-24362 | PRV | Dorothy Hudson | 1988-11-08 | — | 8235125322 | 3077 Meadow Ln, Minneapolis, MN, 55437 | 0.78 | Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-27528 | PRV | Marilyn Rice | 1941-09-13 | UHC-69910-24 | 4712389955 | 1406 Ocean Ave, Nashville, TN, 37235 | 0.78 | Name re-casedTwo-digit birth yearCity re-casedWhitespace trimmed+1 more |
| PRV-23092 | PRV | Hannah Watson | 1995-07-27 | UHC-44586-69 | 7182887677 | 9895 Bayshore Dr, San Antonio, TX, 78224 | 0.78 | Street suffix standardisedAddress re-casedPlan code upper-casedWhitespace trimmed+1 more |
| PRV-26785 | PRV | Ruth Jackson | 2003-08-16 | — | 7248121502 | 8808 Camelback Rd, Las Vegas, NV | 0.78 | Name re-casedPhone reformattedZIP missingWhitespace trimmed+1 more |
| PRV-26930 | PRV | Evelyn Z Hill | 1943-08-03 | UHC-49905-98 | 5399879574 | 3867 Desert Sky Blvd, San Antonio, TX, 78265 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28526 | PRV | Arjun Hudson | 1999-04-14 | UHC-69955-67 | 3663862344 | 4237 Sunset Blvd, Gilbert, AZ, 85297 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22005 | PRV | Larry S Gibson | — | UHC-74898-55 | 9375549069 | — | 0.78 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+1 more |
| PRV-29414 | PRV | Stephanie E Alvarado | 2006-12-17 | — | 4554158798 | 985 Ridge Rd, San Antonio, TX, 78240 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25326 | PRV | Wayne Silva | 2005-02-18 | — | 2374504670 | 3386 Union St, Orlando, FL, 32817 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-22343 | PRV | Debra Z Price | 1948-07-26 | — | 4333085023 | 7061 Willow Ct, Houston, TX, 77082 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26810 | PRV | Teresa Chavez | 1980-12-08 | — | — | 2318 Harbor Blvd, Mesa, AZ, 85214 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-28087 | PRV | Bruce Vaqzuez | — | UHC-72856-87 | 8319669136 | — | 0.78 | Name re-casedDate of birth missingPhone reformattedWhitespace trimmed+1 more |