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-21174 | PRV | Emily Rojas | 1973-08-11 | — | 4547015886 | 3791 Baseline Rd, Mesa, AZ, 85242 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-23277 | PRV | Diana L Grant | 1941-09-26 | — | 5215756151 | — | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-20009 | PRV | Vincent Oliver | 1973-05-14 | UHC-16577-40 | 7476422564 | — | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-21324 | PRV | Karen M Campbell | 1967-07-12 | — | 3704473086 | 3013 Market St, San Antonio, TX, 78271 | 0.94 | Email lower-casedWhitespace trimmedPlaceholder values cleared |
| PRV-24956 | PRV | Logan Green | 1972-01-18 | — | 5134467856 | 32 Willow Ct, Chandler, AZ, 85266 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-23848 | PRV | Joan Hamitlon | 2005-09-16 | — | — | 9063 Central Ave, Columbus, OH, 43210 | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-26136 | PRV | Donna Sullivan | 1998-01-01 | UHC-84309-27 | 5786888092 | 7269 Broadway, Atlanta, GA, 30393 | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-24842 | PRV | Willie Moreno | 1965-07-25 | — | 2845322100 | — | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-23572 | PRV | Natalie Turner | 1989-06-07 | — | 4034244528 | 9798 Spring St, San Antonio, TX, 78202 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-27319 | PRV | Rebeecca Casstro | 1961-12-19 | UHC-67749-01 | 3614421066 | 5577 Valley View Dr, Scottsdale, AZ, 85240 | 0.94 | Phone reformattedCity re-casedPlaceholder values cleared |
| PRV-20718 | PRV | Christian Gomez | 1984-11-27 | — | 4393874184 | 7865 Bayshore Dr, Austin, TX, 78733 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-22237 | PRV | Daniel Wong | 1981-07-10 | UHC-33833-96 | 9673669916 | 4430 Meadow Ln, Jacksonville, FL, 32235 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-25067 | PRV | Russell Q Matthews | 1964-12-28 | — | 9684397875 | 8711 Union St, San Antonio, TX, 78245 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-25768 | PRV | Christine W Stevens | 1983-06-13 | UHC-87437-98 | — | 9540 Broadway, San Antonio, TX, 78215 | 0.94 | Name re-casedAddress re-casedPlaceholder values cleared |
| PRV-27363 | PRV | Sharon Wilson | 1960-07-09 | — | 9115479369 | 9327 Highland Ave, Glendale, AZ, 85346 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-22726 | PRV | Cynthia Elliott | 2007-09-02 | — | 5113382771 | 9248 Sage Ct, San Antonio, TX, 78200 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-20255 | PRV | Danielle Soto | 1989-11-01 | — | 7109818547 | 8873 Sunset Blvd, Austin, TX, 78719 | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-24289 | PRV | Garrett V Kathleen | 1959-05-02 | UHC-55711-88 | 6927725384 | 9748 Market St, Fresno, CA, 93748 | 0.94 | Name re-casedCity re-casedPlaceholder values cleared |
| PRV-29530 | PRV | Jacob Espinoza | 1943-03-01 | — | 2186631113 | 9827 Lake View Rd, San Diego, CA, 92130 | 0.94 | State code upper-casedWhitespace trimmedPlaceholder values cleared |
| PRV-21368 | PRV | Stephen Russell | 1971-10-09 | UHC-67042-21 | 9222453799 | 6613 Jefferson Ave, Orlando, FL, 32877 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-24272 | PRV | Ethan Robertson | 2000-07-21 | — | — | 7669 Maple Ave, San Antonio, TX, 78202 | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-20524 | PRV | Dylan Kim | 2007-06-24 | UHC-93308-26 | 8946694364 | 7800 Elm St, Dallas, TX, 75249 | 0.94 | State code upper-casedWhitespace trimmedPlaceholder values cleared |
| PRV-25545 | PRV | Doris F Contreras | 1982-06-15 | UHC-33127-95 | — | — | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-23095 | PRV | Arjun Gutierrez | 2005-12-12 | UHC-35844-53 | 4976030816 | 1284 Canyon Rd, San Antonio, TX, 78238 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-20776 | PRV | Terry Elliott | 1980-07-19 | UHC-19456-25 | 6812696009 | 5002 Palm Dr, Fresno, CA, 93752 | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-22486 | PRV | Kathryn Z Sandoval | 1956-09-11 | — | — | 2498 Meadow Ln, Fresno, CA, 93760 | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-20172 | PRV | William Contreras | 1988-08-12 | UHC-82947-39 | 7972873843 | — | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-26934 | PRV | Eugene Harper | 1961-01-04 | — | 7052485267 | — | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-26933 | PRV | Eugene Harper | 1961-01-04 | — | 7052485267 | — | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |
| PRV-22994 | PRV | Patricia Hayes | 1993-05-27 | — | 6194100159 | 6331 Hillcrest Rd, Sacramento, CA, 95813 | 0.94 | State code upper-casedWhitespace trimmedPlaceholder values cleared |
| PRV-27896 | PRV | Theresa P Gonzales | 1981-09-04 | UHC-23093-68 | 6407373218 | 4832 Lake View Rd, Gilbert, AZ, 85258 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-29580 | PRV | Julie Ross | 1939-11-28 | UHC-35911-86 | 3829562824 | — | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-22513 | PRV | Samuel Payne | 1976-12-25 | UHC-26523-27 | 2856540118 | 3658 Highland Ave, Plano, TX, 75059 | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-22235 | PRV | Tom Mendoza | 1964-11-16 | UHC-87035-55 | 9103901758 | — | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-22946 | PRV | Evelyn F Campbell | 1999-05-21 | UHC-88927-95 | 3747667952 | 8276 Spring St, Orlando, FL, 32860 | 0.94 | Date of birth reformattedPhone reformattedPlaceholder values cleared |
| PRV-22865 | PRV | Ralph Johnson | 1939-11-02 | — | — | — | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-25524 | PRV | Gray S Bruce | 1997-05-17 | UHC-70709-95 | 3182063982 | 3961 Baseline Rd, Minneapolis, MN, 55410 | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-24763 | PRV | Sean Allen | 1967-11-11 | — | 6972892673 | 9243 Union St, Seattle, WA, 98183 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-24169 | PRV | Adam Chapman | 1985-07-19 | — | 5739619826 | 8709 Sage Ct, Eden Prairie, MN, 55360 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-28408 | PRV | Diana B Mills | 1972-11-19 | UHC-74388-14 | 8517641826 | 7835 Broadway, Atlanta, GA, 30342 | 0.94 | Address re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-25508 | PRV | Danielle P Day | 2005-07-09 | UHC-21529-84 | 5927859778 | — | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-29585 | PRV | Tyler Ramirez | 1985-08-04 | — | 8174637516 | 135 Church St, San Diego, CA, 92111 | 0.94 | Date of birth reformattedPhone reformattedPlaceholder values cleared |
| PRV-29322 | PRV | Mateo Simpson | 1994-10-16 | UHC-34741-79 | 2039855055 | 2939 Broadway, Las Vegas, NV, 89108 | 0.94 | Name re-casedWhitespace trimmedPlaceholder values cleared |
| PRV-26614 | PRV | Sharon Campbell | 1956-06-07 | UHC-06772-04 | 4465041093 | 878 Canyon Rd, Tucson, AZ, 85718 | 0.94 | Phone reformattedEmail lower-casedPlaceholder values cleared |
| PRV-26615 | PRV | Sharon Campbell | 1956-06-07 | UHC-06772-04 | 4465041093 | 878 Canyon Rd, Tucson, AZ, 85718 | 0.94 | Phone reformattedEmail lower-casedPlaceholder values cleared |
| PRV-29127 | PRV | Diego Collins | 2006-12-06 | — | 7065794686 | 1389 Lincoln Way, Plano, TX, 75034 | 0.94 | Name re-casedEmail lower-casedPlaceholder values cleared |
| PRV-21423 | PRV | Bruce P Ferguson | 1978-04-10 | UHC-65891-58 | 3388534845 | — | 0.94 | Date of birth reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-27956 | PRV | George I West | 1993-12-28 | — | 4487562851 | 1635 Mountain View Dr, Mesa, AZ, 85219 | 0.94 | Phone reformattedWhitespace trimmedPlaceholder values cleared |
| PRV-27634 | PRV | Marcus Foster | 1961-09-23 | — | 6838722074 | — | 0.94 | Name re-casedPhone reformattedPlaceholder values cleared |
| PRV-23525 | PRV | Martha Powell | 1943-12-23 | UHC-78239-03 | 9737120551 | — | 0.94 | Name re-casedDate of birth reformattedPlaceholder values cleared |