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-21244 | PRV | David Garza | 1938-04-06 | — | 6429218121 | 4042 Canyon Rd, Plano, TX, 75098 | 0.78 | Name re-casedDate of birth reformattedSSN last four extractedWhitespace trimmed+1 more |
| PRV-21415 | PRV | Catherine Deaan | 1996-07-17 | UHC-12425-81 | 7389942638 | 3457 Broadway, San Antonio, TX, 78206 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-25286 | PRV | Andrea Carter | 1968-01-14 | — | — | 589 Bayshore Dr, Houston, TX, 77082 | 0.78 | Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-24691 | PRV | Randy Robertson | 1977-01-15 | — | 4489147374 | 6663 Church St, San Diego, CA, 92137 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28701 | PRV | Daniel Martinez | 1964-05-21 | — | 9676271166 | 8883 Forest Ave, Chandler, AZ, 85249 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20905 | PRV | Joyce L Hunt | 1983-08-26 | UHC-86921-20 | 2477112906 | 2307 Sage Ct, Phoenix, AZ, 85069 | 0.78 | Name re-casedDate of birth reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-27700 | PRV | Abigail Tran | 2004-04-13 | — | — | — | 0.78 | Name re-casedDate of birth reformattedEmail lower-casedGender normalised+1 more |
| PRV-26305 | PRV | Mason L Miller | 1955-12-23 | — | — | 825 Mountain View Dr, Houston, TX, 77005 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24087 | PRV | Adam Ellis | 1958-09-26 | — | — | 8930 Cedar Ln, Glendale, AZ, 85301 | 0.78 | Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-28700 | PRV | Elijah Chapman | 1959-02-20 | — | 2179590319 | 392 Indian School Rd, Atlanta, GA, 30301 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25594 | PRV | Mei McDonald | 1939-01-28 | UHC-20880-78 | 4816081080 | 7772 Lincoln Way, Houston, TX, 77077 | 0.78 | Two-digit birth yearPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-28196 | PRV | Nicholas V Jackson | 1987-08-03 | UHC-25427-08 | 5773694218 | — | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-23145 | PRV | Brenda D Rojas | 1985-06-14 | — | 5556592334 | 1484 Grand Ave, Chandler, AZ, 85228 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22388 | PRV | Shirlay Welch | 1944-11-10 | — | 5096102614 | 5380 Washington St, Miami, FL, 33147 | 0.78 | Name re-casedCity re-casedState name converted to codeWhitespace trimmed+1 more |
| PRV-21373 | PRV | Patriccia Simmons | 1963-12-19 | UHC-34156-49 | 6842935793 | 320 Sage Ct, Los Angeles, CA, 90029 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-28462 | PRV | Ethan Espinoza | 1975-12-18 | UHC-90568-69 | 5338046642 | 4821 Baseline Rd, Glendale, AZ, 85316 | 0.78 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20056 | PRV | Teresa Franklin | 2006-09-27 | UHC-79947-46 | 4965056080 | 4892 Broadway, Orlando, FL, 32896 | 0.78 | Name re-casedPhone reformattedSSN last four extractedAddress re-cased+1 more |
| PRV-21887 | PRV | Sophia H Mrquez | 1986-09-01 | UHC-21684-62 | — | 6786 Meadow Ln, Fresno, CA, 93755 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23117 | PRV | Fatima Z Baker | 1982-12-22 | — | 7482443393 | 7973 Apache Blvd, Chandler, AZ, 85289 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22793 | PRV | Andrew Bennett | 1959-07-03 | UHC-25240-08 | 3412037316 | 7099 Cedar Ln, Las Vegas, NV, 89149 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+1 more |
| PRV-20282 | PRV | Barb Ryan | 1964-05-01 | — | 3232403800 | 6299 Sunset Blvd, San Diego, CA, 92148 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26880 | PRV | Willie Hill | 1954-02-17 | — | — | 6950 Camelback Rd, Gilbert, AZ, 85250 | 0.78 | Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-23381 | PRV | Crawford C Carlos | 1969-08-09 | UHC-73470-50 | 5208811292 | 4540 Central Ave, Atlanta, GA, 30376 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24223 | PRV | Janice Richrds | 1938-06-13 | UHC-36443-23 | 6043317216 | 2622 Jefferson Ave, Charlotte, NC, 28254 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23648 | PRV | Barb Z Robinson | 1953-03-09 | UHC-20413-79 | 4286836779 | 1839 River Rd, Miami, FL, 33164 | 0.78 | Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+1 more |
| PRV-27129 | PRV | Luis Larson | 1979-08-22 | — | 2644571080 | 362 Ocean Ave, Plano, TX, 75067 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20800 | PRV | Kimberly Ryan | — | UHC-73887-22 | 3252899304 | 8063 Broadway, Charlotte, NC, 28277 | 0.78 | Name re-casedDate of birth missingPhone reformattedMember ID reformatted+1 more |
| PRV-24608 | PRV | Frank N Bishop | 1987-09-21 | UHC-33994-11 | 3086636932 | 5597 Willow Ct, Las Vegas, NV, 89124 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25655 | PRV | Ahmed Sanders | 1960-10-26 | UHC-07701-06 | 4209977132 | 2821 Sunset Blvd, Sacramento, CA, 95877 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27067 | PRV | Anthony Carpenter | 1959-08-27 | UHC-46961-33 | 8475944106 | 6235 Mountain View Dr, Orlando, FL, 32828 | 0.78 | Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22457 | PRV | Abigail L Marshall | 1943-09-25 | — | 6475203297 | 8253 Desert Sky Blvd, Dallas, TX, 75264 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27904 | PRV | Jason V Murray | 1991-08-18 | — | 5795572501 | 6816 Willow Ct, Charlotte, NC, 28277 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24073 | PRV | David Hernandez | 1987-06-28 | — | 6913086821 | 1326 Washington St, Denver, CO, 80226 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26661 | PRV | Dylan O Reid | 1943-12-05 | UHC-30535-48 | 6455474498 | 2056 Mesa Dr, Plano, TX, 75058 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27064 | PRV | Samantha Rose | 1967-01-14 | — | 3393553725 | 3541 Pine Dr, Plano, TX, 75004 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20985 | PRV | Lucia D Bradley | 1997-12-17 | — | 5228314300 | 3641 Spring St, Eden Prairie, MN, 55317 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26235 | PRV | JoyceJunk | 1989-12-12 | — | 2422470655 | 5954 Central Ave, San Diego, CA, 92120 | 0.78 | Name re-casedPhone reformattedCity re-casedPlaceholder values cleared+1 more |
| PRV-20303 | PRV | Camila Santos | 1951-11-20 | — | 6823136559 | 4386 Lake View Rd, Seattle, WA, 98115 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23276 | PRV | Beth V Ray | 1992-01-25 | UHC-56495-72 | 6232037637 | 7416 Oak St, Las Vegas, NV, 89186 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-21832 | PRV | Andrea Z Morgan | 1936-02-21 | — | 3905179077 | 125 Apache Blvd, Tempe, AZ, 85201 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22609 | PRV | Jaffrey Griffin | 1944-08-13 | UHC-57372-73 | 6308144980 | 8977 Ridge Rd, Seattle, WA, 98189 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-26214 | PRV | Jeremy O Barnes | 1995-11-25 | — | — | 8573 Ocean Ave, Chandler, AZ, 85261 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25371 | PRV | Julie Hughes | 1993-02-08 | — | 5419353243 | 5616 Central Ave, Orlando, FL, 32819 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27994 | PRV | Lawrence Fuller | — | — | 9783604569 | — | 0.78 | Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more |
| PRV-27125 | PRV | Timothhy S Alexander | 1962-08-04 | — | 8214063545 | 4556 Desert Sky Blvd, Fresno, CA, 93724 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28281 | PRV | Christina Diaz | 1980-06-18 | — | 3397110595 | 6501 Baseline Rd, Orlando, FL, 32822 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27550 | PRV | Priya Dean | 1945-05-26 | UHC-97670-53 | 6823689397 | 9490 Central Ave, Tempe, AZ, 85220 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24836 | PRV | Thomas Ortega | 1948-10-07 | — | 8998194723 | 3281 Ocean Ave, San Antonio, TX, 78234 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-23106 | PRV | Diane B Henderson | 1946-12-20 | UHC-09074-03 | 3942601676 | 6357 Oak St Apt 24, Phoenix, AZ, 85000 | 0.78 | Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+1 more |
| PRV-26139 | PRV | Teresa Dlgado | 1950-02-04 | UHC-40854-32 | 5405650622 | 3500 Valley View Dr, Phoenix, AZ, 85009 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |