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-21024 | PRV | Jackie Fowler | 1991-02-11 | UHC-54173-12 | 8907417379 | 9633 Central Ave, Los Angeles, CA, 90086 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-24716 | PRV | Rachel Allen | 1990-08-27 | — | 9706551598 | 1261 Lake View Rd, Chandler, AZ, 85284 | 0.82 | Name re-casedGender normalisedPlaceholder values cleared |
| PRV-27068 | PRV | Danielle Lee | 1963-06-15 | — | 6169152305 | 5751 Desert Sky Blvd, Dallas, TX | 0.82 | ZIP missingWhitespace trimmedPlaceholder values cleared |
| PRV-24505 | PRV | Roger R Aguilar | 1979-07-06 | UHC-34944-90 | — | — | 0.82 | Phone missing area codeWhitespace trimmedPlaceholder values cleared |
| PRV-25531 | PRV | Gary Tucker | 2000-06-04 | UHC-38611-50 | 4186964420 | — | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-22292 | PRV | Beverly G Padilla | 1954-10-26 | UHC-35803-15 | 5395348170 | 6136 Park Pl, Mesa, AZ, 85225 | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-24134 | PRV | Lori Rice | 1950-07-23 | UHC-02844-10 | 2503648762 | 5646 Cedar Ln, Mesa, AZ, 85298 | 0.82 | Name split from “Last, First”Whitespace trimmedPlaceholder values cleared |
| PRV-25021 | PRV | Elijah Richardson | 1951-04-02 | UHC-63367-57 | — | 3875 Park Pl, Orlando, FL, 32864 | 0.82 | Name re-casedGender normalisedPlaceholder values cleared |
| PRV-25695 | PRV | Cynthia Lopez | 2003-11-17 | — | 3319725403 | 4377 Washington St, Austin, TX, 78715 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| PRV-27831 | PRV | Ruth Spencer | 2002-07-12 | UHC-50944-63 | — | 1966 Main St, Tempe, AZ, 85241 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-29536 | PRV | Amy Grant | 1983-06-11 | UHC-34713-39 | — | — | 0.82 | Name split from “Last, First”Whitespace trimmedPlaceholder values cleared |
| PRV-23059 | PRV | Rachel Walker | 1941-06-28 | — | — | 6112 Elm St, Gilbert, AZ, 85267 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-26652 | PRV | Bobby L Payne | 1987-08-17 | UHC-54861-76 | 2315860318 | 7432 Palm Dr, Columbus, OH, 43248 | 0.82 | Phone reformattedZIP+4 trimmedPlaceholder values cleared |
| PRV-23379 | PRV | Anna Edwards | 2007-08-12 | — | 5888661153 | 4080 Palm Dr, Tucson, AZ, 85782 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-22790 | PRV | Roy Crawford | 1991-07-27 | — | — | 6673 Oak St, Seattle, WA, 98175 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-26373 | PRV | Marilyn Hawkins | 2002-08-22 | UHC-70032-40 | 6467135533 | 7537 Pine Dr, Tempe, AZ, 85255 | 0.82 | Name re-casedTwo-digit birth yearPlaceholder values cleared |
| PRV-22612 | PRV | Alexander James | 1942-04-05 | — | 6717390757 | 2652 Canyon Rd, Scottsdale, AZ, 85237 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-25860 | PRV | Marcus Bruns | 1966-09-19 | UHC-37882-51 | 4782927645 | 2113 Washington St, Columbus, OH, 43279 | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-26687 | PRV | Marilyn Yang | 1980-11-06 | — | — | 7292 River Rd, Charlotte, NC, 28209 | 0.82 | Name split from “Last, First”Date of birth reformattedPlaceholder values cleared |
| PRV-20529 | PRV | Ethan Le | 1939-11-24 | — | 9253589039 | 3103 Mesa Dr # 503, Phoenix, AZ, 85048 | 0.82 | Phone reformattedUnit split from streetPlaceholder values cleared |
| PRV-27929 | PRV | Barb Carr | 2000-03-19 | UHC-71429-35 | 5953887054 | — | 0.82 | Member ID reformattedGender normalisedPlaceholder values cleared |
| PRV-25920 | PRV | Katlheen Y Powell | 1995-01-16 | — | 9098901879 | 8223 Bayshore Dr, Plano, TX, 75085 | 0.82 | Email lower-casedGender normalisedPlaceholder values cleared |
| PRV-23913 | PRV | Isabella Nelson | 1992-04-21 | UHC-35456-26 | 5203335188 | 2964 Grand Ave, Austin, TX, 78797 | 0.82 | Date of birth reformattedPhone reformattedGender normalised |
| PRV-20855 | PRV | Paul Fiser | 1946-10-26 | UHC-29098-94 | 6037062710 | 4494 Lake View Rd, Minneapolis, MN, 55458 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-20012 | PRV | Olivia Mejia | 1996-01-27 | UHC-99227-11 | 6248894352 | — | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-27471 | PRV | Lucia Guerrero | 2006-03-10 | — | 7722482192 | 4320 Maple Ave, Sacramento, CA, 95806 | 0.82 | Phone reformattedZIP+4 trimmedPlaceholder values cleared |
| PRV-25130 | PRV | Alexis J West | 1996-10-23 | — | — | 5812 Church St, Dallas, TX, 75264 | 0.82 | State name converted to codeEmail lower-casedPlaceholder values cleared |
| PRV-20486 | PRV | David Graham | 2003-09-12 | UHC-28829-66 | 9077284379 | 2470 Lincoln Way, Plano, TX, 75031 | 0.82 | Phone reformattedSSN last four extractedPlaceholder values cleared |
| PRV-22438 | PRV | Ralph Hayes | 1956-12-23 | — | — | 6945 Valley View Dr, Tampa, FL, 33624 | 0.82 | Two-digit birth yearWhitespace trimmedPlaceholder values cleared |
| PRV-26102 | PRV | Natalie Estrada | 1938-05-17 | UHC-84399-83 | 4355169604 | 8742 Church St, Fresno, CA, 93739 | 0.82 | Name split from “Last, First”Date of birth reformattedPlaceholder values cleared |
| PRV-20506 | PRV | Bryan Mitchell | 1940-10-05 | UHC-65222-38 | 5217695306 | 6937 Meadow Ln, Houston, TX, 77057 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-26238 | PRV | Jean Rodriguez | 2002-01-01 | — | 6172578463 | 4404 Valley View Dr, Atlanta, GA, 30335 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-24447 | PRV | Timothy Brooks | 1978-03-15 | UHC-96249-54 | 6567818224 | 9727 Maple Ave, Tempe, AZ, 85257 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-24912 | PRV | Christine Stewart | 1946-01-03 | UHC-62819-22 | — | 412 Palm Dr, Austin, TX, 78728 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-27387 | PRV | Steven L Gibson | — | — | 4738530410 | — | 0.82 | Date of birth unreadablePhone reformattedPlaceholder values cleared |
| PRV-23885 | PRV | Logan Y Gonzales | 1986-07-13 | UHC-19729-25 | 6133580109 | 6025 River Rd, Orlando, FL, 32899 | 0.82 | Street suffix standardisedAddress re-casedEmail lower-cased |
| PRV-29532 | PRV | Alice Gibson | 1966-05-04 | UHC-30304-46 | 8817648012 | 4012 Elm St, Eden Prairie, MN, 55318 | 0.82 | Phone reformattedStreet suffix standardisedAddress re-cased |
| PRV-27477 | PRV | Logan Campbell | 1983-12-26 | UHC-12459-58 | 3486926379 | 201 Central Ave, Atlanta, GA, 30336 | 0.82 | Two-digit birth yearWhitespace trimmedPlaceholder values cleared |
| PRV-29540 | PRV | Sena Peters | 2001-10-05 | — | 3404158757 | — | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-20500 | PRV | Abigail O Perkins | 1971-04-28 | UHC-99873-07 | — | 7914 Oak St, Columbus, OH, 43289 | 0.82 | Name re-casedDate of birth reformattedState name converted to code |
| PRV-28436 | PRV | Betty Rodriguez | 2008-01-02 | — | 8284575874 | 1339 Spring St, Plano, TX, 75083 | 0.82 | Email lower-casedGender normalisedPlaceholder values cleared |
| PRV-27230 | PRV | Natalie Harper | 1974-06-13 | UHC-41642-39 | — | 4968 Camelback Rd, Atlanta, GA, 30307 | 0.82 | Name split from “Last, First”Whitespace trimmedPlaceholder values cleared |
| PRV-26258 | PRV | Mari Luna | 1998-08-15 | — | 4407334607 | 801 Indian School Rd, Glendale, AZ, 85332 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-24851 | PRV | Madison Taylor | 1957-08-22 | — | 2967985659 | 16 Ocean Ave, Jacksonville, FL, 32299 | 0.82 | Name split from “Last, First”Whitespace trimmedPlaceholder values cleared |
| PRV-22318 | PRV | Roger X Stephens | 1991-01-11 | — | 9248808854 | 8151 Indian School Rd, Jacksonville, FL | 0.82 | City re-casedZIP missingPlaceholder values cleared |
| PRV-25240 | PRV | Kevin Jimenez | 1979-05-15 | — | 2288754057 | 6825 Ocean Ave, Eden Prairie, MN, 55312 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-28610 | PRV | Harold Green | 1949-02-27 | UHC-22405-40 | 8092659483 | 5450 Spring St, Seattle, WA | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-24704 | PRV | Harold Tran | 1979-04-05 | — | 4353993296 | 9620 Broadway, Chandler, AZ, 85240 | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-21999 | PRV | Wilie Brooks | 1964-08-16 | — | — | 1402 Indian School Rd, Las Vegas, NV, 89178 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-23963 | PRV | Russell Gray | 2002-03-16 | — | 5432285784 | 92 Palm Dr, Eden Prairie, MN, 55349 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |