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-20705 | PRV | Jonathan Cunningham | 1971-01-22 | — | 6833334528 | 1755 Lake View Rd, Plano, TX, 75005 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24466 | PRV | Peterson S Terry | 1940-03-22 | — | 7826611322 | 9120 Harbor Blvd, Miami, FL, 33121 | 0.78 | Date of birth reformattedGender normalisedPlan code upper-casedWhitespace trimmed+1 more |
| PRV-20540 | PRV | Diane A Lopez | 2008-02-15 | UHC-47129-97 | 8182588640 | 4270 Lincoln Way, Seattle, WA, 98111 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23526 | PRV | Sean Fuller | 1986-08-24 | UHC-36745-76 | — | 1395 Grand Ave, Chandler, AZ, 85201 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-29246 | PRV | Jack Gray | 1966-11-25 | UHC-88547-19 | 9105895781 | 6736 Church St, Sacramento, CA, 95837 | 0.78 | Name re-casedTwo-digit birth yearCity re-casedWhitespace trimmed+1 more |
| PRV-20995 | PRV | Pamela Fuller | 1946-11-06 | UHC-53055-98 | 7728959546 | 3164 Hillcrest Rd, Gilbert, AZ, 85248 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20604 | PRV | Christina F Perez | 2000-01-20 | UHC-96033-78 | 4557544897 | 9108 Meadow Ln, Gilbert, AZ, 85255 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20672 | PRV | Denny Sandeers | 1982-03-12 | — | — | — | 0.78 | Name re-casedEmail lower-casedGender normalisedWhitespace trimmed+1 more |
| PRV-25650 | PRV | Sara P Ford | 2005-12-04 | UHC-92388-04 | 7542256746 | 2123 Indian School Rd, Charlotte, NC, 28221 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25118 | PRV | Kenneth Z Peeters | 1991-09-06 | — | 8464055697 | 2744 Hillcrest Rd, Houston, TX, 77004 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24963 | PRV | Omar Hicks | 1993-06-28 | — | 9682023886 | — | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-24246 | PRV | Donna Welch | — | UHC-78754-72 | 5074405110 | — | 0.78 | Date of birth reformattedDate of birth unreadablePhone reformattedEmail lower-cased+1 more |
| PRV-22410 | PRV | Doris Cunnigham | 1949-03-07 | UHC-12346-13 | 3359438706 | 6648 Palm Dr, Chandler, AZ, 85284 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22519 | PRV | Judith M Dean | 1998-06-17 | — | 9897444303 | 7492 Market St, Mesa, AZ, 85270 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21856 | PRV | Jordan K Richards | 1964-04-15 | — | — | 4417 Market St, Charlotte, NC, 28204 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27512 | PRV | Nathan R Clark | 1941-01-15 | — | 2929846918 | 387 Jefferson Ave, Chandler, AZ, 85217 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28276 | PRV | Joan Vazquez | 1958-10-06 | — | 3959648074 | 2813 Valley View Dr, Chandler, AZ, 85283 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22680 | PRV | Mariana Williamson | 1971-12-27 | UHC-03230-89 | 2479745300 | 1598 Desert Sky Blvd, Phoenix, AZ, 85048 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27575 | PRV | Brenda Wells | 1961-07-12 | UHC-70706-56 | 6507345717 | 5623 Maple Ave, Mesa, AZ, 85251 | 0.78 | Phone reformattedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-24875 | PRV | Priya Brown | 1939-10-04 | — | 9616654710 | 9357 Canyon Rd, Los Angeles, CA, 90062 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24860 | PRV | Aisha Z Chapman | — | — | 2254697944 | 4462 Cedar Ln, Miami, FL, 33191 | 0.78 | Date of birth missingPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-23387 | PRV | Alice Freeman | — | UHC-80293-63 | 8738938397 | — | 0.78 | Name re-casedDate of birth unreadablePhone reformattedWhitespace trimmed+1 more |
| PRV-20514 | PRV | Doorothy Jacobs | 1942-02-04 | UHC-33416-55 | — | 2626 River Rd, Fresno, CA, 93771 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-20141 | PRV | Joan Y Bryant | 1958-12-01 | UHC-19390-36 | 5253887592 | 6477 Spring St, Mesa, AZ | 0.78 | Date of birth reformattedPhone reformattedZIP missingWhitespace trimmed+1 more |
| PRV-27526 | PRV | Nacy Daniels | 1976-11-12 | UHC-96138-11 | 6496387234 | 8662 Cedar Ln, Orlando, FL, 32823 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26089 | PRV | Jsese Williamson | 1961-10-13 | UHC-57888-13 | — | 5866 Pine Dr, Austin, TX, 78771 | 0.78 | Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more |
| PRV-26034 | PRV | Melissa Ramos | 2002-06-10 | UHC-99031-01 | 8763769108 | 7751 Bayshore Dr, Chandler, AZ, 85233 | 0.78 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23538 | PRV | Ashley Thompson | 2003-06-17 | UHC-02035-47 | 8348385087 | 5416 Lincoln Way, Sacramento, CA, 95875 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-22320 | PRV | Ahmed Vega | 1991-05-16 | — | 3914332193 | 1975 Jefferson Ave, San Diego, CA, 92114 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23305 | PRV | Christina O Maldonado | 1957-06-20 | — | 3633956290 | 8246 Valley View Dr, Eden Prairie, MN, 55379 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23158 | PRV | Joyce A Herrera | 1942-06-21 | UHC-61035-88 | 5757403081 | 2531 Ridge Rd, Dallas, TX, 75219 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29396 | PRV | James Ruiz | 1987-07-19 | UHC-92430-95 | 3378820309 | — | 0.78 | Name re-casedDate of birth reformattedMember ID reformattedGender normalised+1 more |
| PRV-21170 | PRV | Helen Hicks | 1962-07-12 | UHC-81077-42 | 7554680846 | 6150 Cedar Ln, Dallas, TX, 75280 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-21653 | PRV | Bradley Vazquez | 1944-01-07 | — | 2799737529 | 9117 Meadow Ln, Atlanta, GA, 30368 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+1 more |
| PRV-25086 | PRV | Tyler Singh | 2002-04-12 | — | 9546375251 | 7305 Valley View Dr, Las Vegas, NV, 89124 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-22455 | PRV | Cheryl Little | 1951-06-21 | — | 2967803744 | 8771 Meadow Ln, Eden Prairie, MN, 55382 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20023 | PRV | Vincent Hansen | 1953-05-26 | — | 7005908077 | 2218 Park Pl, Las Vegas, NV, 89138 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-25540 | PRV | Yuki Hanson | 1981-03-04 | UHC-02203-04 | 5829358898 | — | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-23001 | PRV | Alice E Marshall | 1988-11-22 | — | 6698641806 | 5036 Bayshore Dr, Plano, TX, 75009 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-20369 | PRV | Timothy Reed | 1963-03-14 | — | 2168700023 | 6904 Lincoln Way, Columbus, OH, 43203 | 0.78 | Phone reformattedCity re-casedGender normalisedWhitespace trimmed+1 more |
| PRV-25111 | PRV | Martha Foster | 1963-04-15 | — | 2094991159 | 539 Church St, Nashville, TN, 37292 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22257 | PRV | Betty K Butler | 1956-11-26 | UHC-72899-24 | 5786329064 | 1390 Jefferson Ave, Dallas, TX, 75228 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-21187 | PRV | Doris Welch | 1950-07-19 | — | 4428915456 | 2676 Forest Ave, Houston, TX, 77070 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-25191 | PRV | Elizabeth R Fisher | — | — | 3406818983 | 8427 Main St, Jacksonville, FL, 32260 | 0.78 | Name re-casedDate of birth unreadableCity re-casedWhitespace trimmed+1 more |
| PRV-26064 | PRV | Nathan A Bennett | 1998-08-28 | — | — | 1469 Spring St, Eden Prairie, MN, 55313 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-25643 | PRV | Lauren Chen | 2003-04-01 | UHC-04060-90 | 7099518613 | 8160 Indian School Rd, Austin, TX, 78773 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25062 | PRV | Charlotte Reid | 1997-11-10 | — | 2822351642 | 8889 Main St, Mesa, AZ, 85273 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25190 | PRV | Elizabeth Fisher | 1955-03-03 | — | 3406818983 | 8427 Main St, Jacksonville, FL, 32260 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-23962 | PRV | Amber Dean | 1961-02-19 | UHC-03303-76 | 7743126836 | 2058 Sage Ct, Mesa, AZ, 85253 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26448 | PRV | Eric Walsh | 1948-09-23 | — | — | 2093 Indian School Rd, Tucson, AZ, 85756 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |