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-24976 | PRV | Jessica Campbell | 1970-05-04 | — | 4142670478 | 343 Palm Dr, Tucson, AZ, 85763 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21060 | PRV | Bryan A Guerrero | 1988-06-06 | UHC-91293-76 | 3005780486 | 7948 Ridge Rd, Sacramento, CA, 95888 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28177 | PRV | Randy R Vazquez | 1960-06-15 | UHC-86837-23 | 6365778967 | 9686 Lake View Rd, Austin, TX, 78792 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20388 | PRV | Julie Romero | 1940-12-17 | UHC-28284-55 | — | 5302 Apache Blvd, Denver, CO, 80229 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20139 | PRV | Debra Davis | 1986-02-13 | — | 8346478281 | 1252 Church St, Orlando, FL, 32862 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-29219 | PRV | Chris Richards | 1960-12-12 | UHC-05977-75 | 8454528539 | 5798 Ocean Ave, Eden Prairie, MN, 55304 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26329 | PRV | Barbara Johnston | 1974-09-16 | UHC-72209-44 | 5804223914 | 5293 Washington St, Dallas, TX, 75254 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-27440 | PRV | Perry Virginia | 1997-09-27 | UHC-18439-67 | 9137586693 | 7873 Market St, Plano, TX, 75047 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22132 | PRV | Christopher N Webb | 1988-01-17 | UHC-62698-47 | — | 3164 Union St, Houston, TX, 77068 | 0.78 | Member ID reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-29477 | PRV | Nathhan Palmer | 2006-09-05 | UHC-74591-49 | 8533943585 | 4351 Elm St, Scottsdale, AZ, 85259 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-29266 | PRV | Garbiel Gilbert | 1987-01-10 | — | 6913199613 | 9797 River Rd, Tucson, AZ, 85723 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21096 | PRV | Dot Clark | 1989-03-13 | — | 8518803134 | 9671 Sunset Blvd, San Antonio, TX, 78258 | 0.78 | Two-digit birth yearPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-21738 | PRV | Lawrence Jimenez | 2008-09-25 | — | 9293218124 | 8191 Valley View Dr, San Antonio, TX, 78280 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25299 | PRV | Gregory Taylor | 1975-03-06 | — | 8789534201 | 3415 Washington St, Gilbert, AZ, 85212 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24479 | PRV | Betty W Romero | 1970-01-02 | — | 5552874995 | 5730 Union St, Tucson, AZ, 85777 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24667 | PRV | Jerry Brooks | 2006-11-13 | — | 9304291308 | 9445 Market St, Glendale, AZ, 85372 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20807 | PRV | Ruth Wells | 2003-12-08 | — | 8227708183 | 7402 Sage Ct, Tempe, AZ, 85264 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25926 | PRV | Stephen Richardson | 2001-05-28 | UHC-35712-05 | 4352065878 | 9587 Meadow Ln, Charlotte, NC, 28232 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25925 | PRV | Stephen Richardson | 2001-05-28 | UHC-35712-05 | 4352065878 | 9587 Meadow Ln, Charlotte, NC, 28232 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25778 | PRV | Theresa Phillips | 2001-12-07 | UHC-41602-41 | 4993192275 | 942 Pine Dr, Houston, TX, 77071 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23470 | PRV | Lisa O Walker | 1960-01-24 | UHC-66353-78 | — | 3284 Mesa Dr, Atlanta, GA, 30361 | 0.78 | Name re-casedMember ID reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-24337 | PRV | Ruth N Hicks | 2006-01-27 | — | — | 4785 Pine Dr, Tampa, FL, 33616 | 0.78 | Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-24927 | PRV | Ronald Mejia | 2006-03-14 | — | 8055248988 | 7266 Union St, Minneapolis, MN, 55464 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-27221 | PRV | Jesse Fernandez | 1954-03-09 | UHC-88309-60 | 8075922637 | 4226 Jefferson Ave, Plano, TX, 75088 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28754 | PRV | Laura Washington | 1987-02-21 | UHC-91264-39 | — | 6061 Camelback Rd, Miami, FL, 33108 | 0.78 | Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20025 | PRV | Mari Ortiz | 1999-11-28 | UHC-72125-46 | 2369092219 | 5555 Harbor Blvd, Jacksonville, FL, 32241 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-29095 | PRV | Jean X McCoy | 1963-12-09 | UHC-59244-39 | 5507371454 | 343 Maple Ave, Tampa, FL, 33600 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-24672 | PRV | Camila Y Dunn | 2007-12-05 | — | 4307541468 | 3918 Palm Dr, Minneapolis, MN, 55448 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-23454 | PRV | Sophia O Dixon | 1938-03-10 | UHC-10387-52 | 5022621731 | 3158 Spring St, Mesa, AZ, 85256 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22350 | PRV | Valentina Adams | 1955-01-24 | — | 5356165261 | 3261 Mesa Dr, Seattle, WA, 98130 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21574 | PRV | Walter Espinoza | 1976-05-06 | UHC-40017-55 | 5095932183 | 9590 Bayshore Dr, Gilbert, AZ, 85229 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-26858 | PRV | Kimberly Chapman | 1980-11-22 | UHC-86534-05 | 4258929299 | 3546 Meadow Ln, Mesa, AZ, 85213 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29177 | PRV | Albert P Howard | 2004-09-11 | UHC-92633-37 | 2426438010 | 6203 Park Pl, Gilbert, AZ, 85222 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22815 | PRV | Aisha Baker | 1944-03-19 | — | 2258031079 | 5994 Indian School Rd # 611, Charlotte, NC, 28210 | 0.78 | Name re-casedPhone reformattedUnit split from streetEmail lower-cased+1 more |
| PRV-22035 | PRV | Lisa Hoawrd | 2000-06-25 | UHC-49832-15 | 4106632404 | 5634 Market St, Charlotte, NC, 28296 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28197 | PRV | Marcus Q Clark | 1950-06-14 | UHC-21648-41 | 9649924551 | 3369 Washington St, Dallas, TX, 75290 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20963 | PRV | Grace Bell | 1995-11-19 | UHC-02851-25 | 2544018753 | 6185 River Rd, San Antonio, TX, 78256 | 0.78 | Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more |
| PRV-25398 | PRV | Terry A Medina | — | — | 5184330047 | 9633 Sage Ct, Eden Prairie, MN, 55316 | 0.78 | Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-22169 | PRV | Rachel Watson | — | UHC-77213-11 | 3512869184 | 1928 Camelback Rd, San Diego, CA, 92132 | 0.78 | Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-24302 | PRV | Frank Walker | 1952-01-25 | — | 7333134220 | 9876 Spring St, Mesa, AZ, 85228 | 0.78 | Name re-casedTwo-digit birth yearCity re-casedWhitespace trimmed+1 more |
| PRV-26645 | PRV | Kevin Marshall | 1997-04-04 | — | 7714690933 | 105 Harbor Blvd, Dallas, TX, 75263 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27514 | PRV | Joe Howell | 1964-08-20 | — | 9196017328 | 690 River Rd, Plano, TX, 75041 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28859 | PRV | Gary Hunt | 1951-03-16 | UHC-70975-49 | 2885966179 | — | 0.78 | Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-29558 | PRV | Joseph Fields | 1938-04-04 | UHC-07821-43 | 4577211227 | 3975 Sunset Blvd, Mesa, AZ, 85235 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27894 | PRV | Elijah Weaver | 1954-12-01 | — | — | — | 0.78 | Name re-casedDate of birth reformattedPhone missing area codeWhitespace trimmed+1 more |
| PRV-21867 | PRV | Brandon Cooper | 1971-02-17 | — | — | 647 Jefferson Ave, Orlando, FL, 32818 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20270 | PRV | Brenda Mitchell | 1973-10-13 | UHC-31490-89 | 7375024807 | 194 Willow Ct, Minneapolis, MN, 55439 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20241 | PRV | Alexander Murphy | 1960-08-22 | — | 9586831073 | 2012 Palm Dr, Eden Prairie, MN, 55302 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27485 | PRV | Janet A Payne | 1992-07-08 | UHC-51229-92 | 7036460010 | 2335 Camelback Rd, Mesa, AZ, 85281 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20019 | PRV | Laura Hamilton | 1957-01-17 | UHC-53829-66 | — | 7386 River Rd, Las Vegas, NV, 89191 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |