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-28480 | PRV | Danielle Diaaz | 1947-03-24 | UHC-42957-15 | 6557210908 | 2992 Jefferson Ave, Miami, FL, 33121 | 0.78 | Name re-casedDate of birth reformattedSSN last four extractedWhitespace trimmed+1 more |
| PRV-25172 | PRV | Kenneth Masun | 1962-08-27 | UHC-03925-28 | 2707546714 | 8342 Washington St, Charlotte, NC, 28233 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-26983 | PRV | Grace I Williiams | 1977-04-18 | — | 2232374335 | 9067 Highland Ave, Jacksonville, FL, 32233 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26411 | PRV | Ntaalie Ward | 1959-04-17 | UHC-22202-45 | 5949289595 | 2490 Apache Blvd, Gilbert, AZ, 85264 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-23561 | PRV | Keith McDonald | 1941-01-01 | UHC-82124-06 | 4165913789 | 1076 Apache Blvd, Sacramento, CA, 95814 | 0.78 | Name split from “Last, First”Phone reformattedMember ID reformattedWhitespace trimmed+1 more |
| PRV-27860 | PRV | Sandra Ward | 1996-05-25 | — | 6085460242 | 7221 Park Pl, Gilbert, AZ, 85275 | 0.78 | Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-26586 | PRV | Shirley Powel | 1968-11-08 | — | 6714997328 | 7652 Ocean Ave, Seattle, WA, 98160 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21093 | PRV | Btty Y Willis | 2006-05-12 | — | 9413319643 | 7434 Canyon Rd, Gilbert, AZ, 85267 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-28337 | PRV | Elijah Z Le | 1964-09-23 | — | 5338389722 | 9800 Elm St, Fresno, CA, 93709 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-21126 | PRV | Virginia B Singh | 1957-04-27 | — | 7104572779 | 1609 Valley View Dr, Charlotte, NC, 28268 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28439 | PRV | Joyce Johnson | 1994-08-04 | UHC-57438-80 | — | 1785 Ridge Rd, Scottsdale, AZ, 85209 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21512 | PRV | Ana Contreras | 2003-05-17 | — | 6187624848 | 9416 Ridge Rd, Atlanta, GA, 30359 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24897 | PRV | Yuki Aguilar | 1986-12-19 | — | 2789970779 | 2651 Ocean Ave, Denver, CO, 80231 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29307 | PRV | David Hunter | 1957-02-20 | — | 8163133970 | 9047 Harbor Blvd, Las Vegas, NV, 89153 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22024 | PRV | Steve Meyer | 1999-09-17 | — | 7189393961 | 226 Indian School Rd, Tucson, AZ, 85773 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-21162 | PRV | Fatima Elliott | 1950-11-05 | — | — | 5297 Indian School Rd, San Diego, CA, 92115 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21828 | PRV | Bryan Valdez | 1964-07-24 | UHC-23489-04 | 3205360215 | 5054 Lake View Rd, Mesa, AZ, 85254 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23156 | PRV | Noah Sctot | 1995-03-20 | — | 7635846302 | 8854 Mountain View Dr, San Diego, CA, 92129 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-26361 | PRV | Doris Guzman | 1956-10-23 | UHC-56787-59 | 3642722355 | 3126 Indian School Rd, Minneapolis, MN, 55466 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24696 | PRV | Tyler X Snyder | 1964-08-19 | UHC-00613-40 | 7393587845 | 6743 Lake View Rd, Eden Prairie, MN, 55316 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26761 | PRV | Cynthia Oretga | 2002-07-08 | UHC-54454-59 | 2574457724 | 3415 Canyon Rd, Nashville, TN, 37299 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23624 | PRV | Brandon White | 2000-04-11 | UHC-94755-46 | — | 1696 Apache Blvd, Las Vegas, NV, 89171 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23991 | PRV | Alice X Baker | 1952-04-16 | UHC-01066-48 | 7382400525 | 2666 Church St, Gilbert, AZ | 0.78 | Phone reformattedZIP missingEmail lower-casedWhitespace trimmed+1 more |
| PRV-22978 | PRV | Rebecac G Elliott | 1951-07-04 | — | — | 1001 Lincoln Way, Columbus, OH, 43213 | 0.78 | Name split from “Last, First”Date of birth reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-22370 | PRV | Ana Ortega | 1951-06-23 | UHC-19282-90 | 7299707135 | 2539 Palm Dr, Scottsdale, AZ, 85230 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27856 | PRV | Jordan Weaver | 1947-11-19 | UHC-41990-34 | 5623143035 | 4916 Sunset Blvd, Phoenix, AZ, 85065 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24650 | PRV | John Porter | 1993-06-22 | — | 7939670501 | 2936 Camelback Rd, San Diego, CA, 92107 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28834 | PRV | Isabella Crawford | 1950-05-23 | UHC-64929-99 | 4734618525 | 4169 Willow Ct, San Diego, CA, 92146 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23750 | PRV | Rachel I Diaz | 1999-12-10 | UHC-34219-67 | 5266524855 | 9301 Highland Ave, Nashville, TN, 37232 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28489 | PRV | Aisha W Hudson | 1969-07-28 | — | 3515930306 | 7330 Sunset Blvd, Tucson, AZ, 85756 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23739 | PRV | Dorothy Bishop | 1975-12-12 | — | 7744583790 | 8850 Mesa Dr, Houston, TX, 77040 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-25921 | PRV | Emma X Meyer | 1950-04-22 | UHC-01738-01 | 6689947215 | 4057 Main St, Tampa, FL, 33669 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-21487 | PRV | Carl Davis | 1987-07-12 | UHC-93283-17 | 5098810468 | 4425 Union St, Scottsdale, AZ, 85254 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23529 | PRV | Denise Estrada | 1979-12-20 | — | — | 9543 Highland Ave, Columbus, OH, 43252 | 0.78 | Two-digit birth yearCity re-casedState code upper-casedWhitespace trimmed+1 more |
| PRV-23809 | PRV | Ronald Daniels | 1943-03-18 | UHC-95529-06 | 6304574545 | 2498 Oak St, Plano, TX, 75033 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25320 | PRV | Janice Greene | 1986-08-15 | UHC-32981-06 | — | 3408 Spring St, Sacramento, CA, 95829 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27154 | PRV | Katherine Cox | 2008-07-13 | — | 4399238866 | 4094 Washington St, Denver, CO, 80226 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-25725 | PRV | Mariana Munoz | 1971-04-24 | UHC-53160-14 | 2672304254 | 8127 Desert Sky Blvd, Los Angeles, CA, 90086 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-28286 | PRV | Jason R Morgan | 2006-04-10 | UHC-31457-91 | 5042718566 | 2752 Hillcrest Rd, Tampa, FL, 33699 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21830 | PRV | Andrea Sanchez | 1951-01-03 | UHC-98290-98 | 3128975630 | — | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-24121 | PRV | Evelyn N Anderson | 2001-02-11 | — | 3626162639 | 1535 Ocean Ave, Fresno, CA, 93714 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more |
| PRV-23697 | PRV | Diana Brown | 1961-08-05 | UHC-44223-69 | 6417758041 | 4932 Oak St, Miami, FL, 33133 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21815 | PRV | Jessica Mendez | 1958-11-24 | UHC-94335-21 | 2742227518 | 1455 Meadow Ln, Phoenix, AZ, 85016 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25674 | PRV | Pat I Howard | — | UHC-28807-93 | 9308686400 | 7671 Sunset Blvd, Minneapolis, MN, 55499 | 0.78 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+1 more |
| PRV-26713 | PRV | Albert Hughes | 1942-06-20 | UHC-56108-84 | 2625017162 | 6509 Apache Blvd, Tucson, AZ, 85710 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-27436 | PRV | Diane S Moore | 1940-11-02 | UHC-33475-05 | 4906470638 | 3407 Desert Sky Blvd, Chandler, AZ, 85296 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24547 | PRV | Carolyn Jordan | 1952-10-12 | — | 9293703365 | 3878 Market St, Charlotte, NC | 0.78 | Date of birth reformattedCity re-casedZIP missingWhitespace trimmed+1 more |
| PRV-26114 | PRV | Madison Daniels | 1946-07-06 | UHC-22765-24 | 9375241910 | 5065 Desert Sky Blvd, Mesa, AZ, 85275 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20766 | PRV | Sean V Stevens | 1989-01-21 | — | 9728432516 | 7458 Grand Ave, Chandler, AZ, 85227 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26055 | PRV | Gloria Tran | 1945-05-04 | — | 5176778499 | 403 Lake View Rd, Tampa, FL, 33674 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |