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-22332 | PRV | Evelyn Herrera | 1973-06-03 | — | 7365475531 | 2696 Baseline Rd, Tampa, FL, 33643 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22985 | PRV | Wei N Berry | 1983-09-09 | UHC-57906-75 | 7145231338 | 1615 Indian School Rd, Eden Prairie, MN, 55342 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22956 | PRV | Kyle Dominguez | 1954-02-12 | UHC-43293-68 | 7332068412 | 2026 Elm St, Minneapolis, MN, 55438 | 0.78 | Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-28274 | PRV | Alexander Patel | 1985-09-23 | — | 4435563349 | 5375 Sunset Blvd, Plano, TX, 75026 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25671 | PRV | Fatima Bryant | 1992-08-14 | UHC-41018-08 | 7372781105 | 9517 Lincoln Way, Sacramento, CA, 95858 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-21949 | PRV | Randy Lawrence | 1981-01-02 | — | 9258489130 | 8287 Highland Ave Apt 37, Glendale, AZ, 85316 | 0.78 | Date of birth reformattedPhone reformattedUnit split from streetWhitespace trimmed+1 more |
| PRV-24766 | PRV | Jordan A Aguilar | 1945-11-04 | — | 8319281593 | — | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-24765 | PRV | Jordan A Aguilar | 1945-11-04 | — | 8319281593 | — | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-28422 | PRV | Adam P Hicks | 1979-05-03 | UHC-61952-26 | 4716532928 | 5348 Mountain View Dr, Denver, CO, 80282 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-20617 | PRV | Oliver Charlotte | 1995-04-07 | UHC-71629-03 | 2892416501 | 951 Jefferson Ave, Sacramento, CA, 95887 | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-20275 | PRV | Wayne Diaz | 1974-08-03 | — | 8103819715 | 7786 Highland Ave, Minneapolis, MN, 55484 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-20050 | PRV | Austin Hart | 1961-05-21 | — | — | 6027 Apache Blvd, Mesa, AZ, 85259 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25045 | PRV | Cheryl Thomas | 1997-04-20 | UHC-96463-73 | 7528030642 | 8372 Cedar Ln, Eden Prairie, MN, 55387 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26971 | PRV | Olivia Q Wang | 1971-01-19 | UHC-18220-29 | 5708720991 | 5888 Lincoln Way, Gilbert, AZ, 85259 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+1 more |
| PRV-26447 | PRV | Natalie Taylor | 1990-05-01 | UHC-81929-18 | 4462800579 | 3265 Main St, Atlanta, GA, 30372 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-23304 | PRV | Cynthia M Elliott | 1990-07-15 | UHC-89870-57 | — | 8525 Sage Ct, Eden Prairie, MN, 55386 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23378 | PRV | Emily Hanson | 1987-06-12 | — | 8566311779 | 3323 Hillcrest Rd, Las Vegas, NV, 89132 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-20819 | PRV | Diego A Valdez | 1962-04-06 | — | 5768453658 | — | 0.78 | Middle initial moved out of first nameName re-casedPhone reformattedWhitespace trimmed+1 more |
| PRV-22678 | PRV | Jean T Shaw | 1940-04-23 | — | 5872686825 | 6276 Elm St, Atlanta, GA, 30308 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20265 | PRV | Diana Ross | 1985-04-21 | — | 4664677953 | — | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-20854 | PRV | Willie Woods | 2001-02-18 | — | 9468977509 | 6332 Broadway, Phoenix, AZ, 85019 | 0.78 | Name re-casedAddress re-casedCity re-casedState name converted to code+1 more |
| PRV-20263 | PRV | Diana Ross | 1985-04-21 | UHC-68670-46 | 4664677953 | 5464 Oak St, Tempe, AZ, 85277 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20264 | PRV | Diana Ross | 1985-04-21 | UHC-68670-46 | 4664677953 | 5464 Oak St, Tempe, AZ, 85277 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27491 | PRV | Rogre Stevens | 1978-03-01 | — | — | 3348 Lincoln Way, Chandler, AZ, 85217 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20491 | PRV | Gloria X Chapman | 1944-07-20 | — | 6343153093 | 9217 Elm St, Phoenix, AZ, 85055 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21508 | PRV | Austin Watson | 1998-06-16 | UHC-30177-94 | 6283583015 | 7865 Highland Ave, Minneapolis, MN, 55425 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23986 | PRV | Theresa Mendez | 1976-12-25 | UHC-72420-38 | 4758232018 | 7707 River Rd, Miami, FL, 33156 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23668 | PRV | Justin Payne | 1949-11-03 | UHC-39329-76 | 4482530587 | 1744 Willow Ct, Gilbert, AZ, 85216 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27936 | PRV | Sarah Carroll | 1969-05-06 | — | 4593740828 | 2788 Ridge Rd, Columbus, OH, 43236 | 0.78 | Name re-casedDate of birth reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-24678 | PRV | Omar Dunn | 1981-11-14 | UHC-59784-86 | 9478014741 | 5238 Union St, Chandler, AZ, 85230 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28725 | PRV | Jesse Lewis | 1976-02-19 | UHC-25390-99 | 7804542217 | 2263 Oak St, Gilbert, AZ, 85233 | 0.78 | Name re-casedPhone reformattedEmail lower-casedGender normalised+1 more |
| PRV-20322 | PRV | Henry Gray | 1950-12-21 | — | — | 119 Park Pl, Gilbert, AZ, 85282 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-24534 | PRV | Sophia U Williamson | 1944-06-09 | UHC-37598-10 | — | 7952 Grand Ave, Plano, TX, 75077 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26605 | PRV | Dylan Gibson | 2002-01-13 | — | 6757098180 | 8165 Meadow Ln, Jacksonville, FL, 32264 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28379 | PRV | Madison Butler | 1975-06-07 | UHC-99817-46 | 2962530468 | 8928 Lake View Rd, Minneapolis, MN, 55401 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23375 | PRV | Anthony Carr | 1972-04-27 | UHC-16569-19 | 5814629705 | 8920 Sage Ct, Mesa, AZ, 85273 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-21676 | PRV | Julie Nelson | 2006-06-26 | — | 7157793011 | 2858 Hillcrest Rd, Denver, CO, 80238 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20129 | PRV | Jack Roberts | 1985-02-01 | — | 2859058674 | 2800 Lake View Rd, Atlanta, GA, 30335 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23549 | PRV | Isabella Black | 1988-09-02 | — | 8686574633 | 521 Spring St, San Diego, CA, 92104 | 0.78 | Date of birth reformattedPhone reformattedCity re-casedState name converted to code+1 more |
| PRV-26792 | PRV | Melissa Owens | 1972-03-18 | UHC-20322-63 | 7324086024 | 7251 Sunset Blvd, San Antonio, TX, 78222 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20290 | PRV | Christian I Williamson | 1974-08-05 | — | — | 3455 Oak St, Chandler, AZ, 85285 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-29050 | PRV | Michelle Bowman | 1971-10-24 | — | — | 7317 Oak St, Tampa, FL, 33639 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26127 | PRV | Cynthia Hill | 2006-08-21 | UHC-85055-61 | 2036047667 | 3680 Indian School Rd, Tucson, AZ, 85754 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-27522 | PRV | Stephen Y Webb | 1950-06-21 | — | 7028641262 | 3827 Camelback Rd, Mesa, AZ, 85215 | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-26401 | PRV | Joyce Evans | — | UHC-63977-81 | 9738624698 | — | 0.78 | Name re-casedDate of birth missingEmail lower-casedWhitespace trimmed+1 more |
| PRV-24995 | PRV | Jacob Little | 1974-07-12 | — | 6986938137 | 2649 Indian School Rd, Houston, TX, 77023 | 0.78 | Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more |
| PRV-26129 | PRV | Andrew Bradley | 1951-04-22 | — | 8902605677 | 9405 Washington St, Tempe, AZ, 85205 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20924 | PRV | Megan Perkins | 1985-09-03 | — | 9665580892 | 3220 Camelback Rd, Seattle, WA, 98196 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27990 | PRV | Olivia Medina | 1968-07-12 | UHC-41565-81 | 3089282390 | 9683 Canyon Rd, Orlando, FL, 32802 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24435 | PRV | Teresa V Harrison | 2007-01-27 | UHC-56572-05 | 9753049752 | 1781 Harbor Blvd, San Antonio, TX, 78294 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |