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-22627 | PRV | Bradley Baker | 1997-02-18 | — | 2687916853 | 5704 Broadway, Sacramento, CA, 95852 | 0.88 | Date of birth reformattedPhone reformattedAddress re-casedEmail lower-cased+2 more |
| PRV-21258 | PRV | Joe M Flores | 1977-12-18 | — | 6988253862 | 8481 River Rd, Plano, TX, 75008 | 0.88 | Name re-casedPhone reformattedCity re-casedPlan code upper-cased+2 more |
| PRV-20474 | PRV | Maria P Peterson | 1984-06-19 | UHC-70195-31 | 8104349538 | 9048 Lake View Rd, Tempe, AZ, 85271 | 0.88 | Name re-casedPhone reformattedState code upper-casedEmail lower-cased+2 more |
| PRV-23933 | PRV | Rachel Lee | 1939-11-02 | UHC-20804-03 | 2993997503 | 3132 Meadow Ln, Las Vegas, NV, 89139 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-25741 | PRV | Rebecca N Munoz | 2001-02-01 | UHC-92686-75 | 7662838843 | 7527 Maple Ave, Scottsdale, AZ, 85219 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-27785 | PRV | Aaron Barnes | 1945-11-27 | UHC-75608-11 | 8092818450 | 9539 River Rd, Columbus, OH, 43270 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| PRV-24930 | PRV | Carlos Ford | 1973-06-22 | UHC-51499-08 | 8544796446 | 3488 Palm Dr, Tucson, AZ, 85712 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-25592 | PRV | Henry Jordan | 1968-05-02 | UHC-15997-66 | 3612431772 | 3607 Ridge Rd, Tampa, FL, 33646 | 0.88 | Date of birth reformattedPhone reformattedMember ID reformattedCity re-cased+2 more |
| PRV-27898 | PRV | Kathryn J Thompson | 1989-02-25 | — | 3849909239 | 9214 Forest Ave, Minneapolis, MN, 55416 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-23794 | PRV | Cynthia Mejia | 1957-06-17 | — | 5234744072 | 8021 Spring St, Austin, TX, 78792 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-27622 | PRV | Scott Duncan | 1970-06-06 | — | 2014421258 | 71 Bayshore Dr, Los Angeles, CA, 90071 | 0.88 | Date of birth reformattedPhone reformattedCity re-casedEmail lower-cased+2 more |
| PRV-22766 | PRV | Mariana J Jimenez | 1965-07-21 | — | 9015991310 | 4008 Church St, Miami, FL, 33101 | 0.88 | Name re-casedPhone reformattedCity re-casedState code upper-cased+2 more |
| PRV-29199 | PRV | Anthony Perkins | 1988-06-09 | UHC-29134-84 | 4156884151 | 5905 Elm St, Las Vegas, NV, 89113 | 0.88 | Phone reformattedMember ID reformattedCity re-casedEmail lower-cased+2 more |
| PRV-29047 | PRV | Raymond Q Alvarado | 1940-05-14 | UHC-63639-31 | 2114911603 | 1325 Market St, Dallas, TX, 75230 | 0.88 | Name re-casedPhone reformattedMember ID reformattedCity re-cased+2 more |
| PRV-27329 | PRV | Gay Rice | 1983-06-05 | UHC-79247-20 | 6587037804 | 9612 Union St, Denver, CO, 80219 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more |
| PRV-24236 | PRV | Emily D Wells | 1971-03-28 | — | 8798240310 | 2695 Mountain View Dr, San Diego, CA, 92155 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-20154 | PRV | Joseph Jordan | 1959-10-27 | — | 2418246598 | 6397 Highland Ave, Scottsdale, AZ, 85227 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-28157 | PRV | Roger Robertson | 2002-05-06 | — | 7649410369 | — | 0.90 | Name re-casedDate of birth reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-22799 | PRV | George Richardson | 2004-03-11 | — | 4043572491 | 7985 Palm Dr, Sacramento, CA, 95884 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-25871 | PRV | Roger T Ferguson | 1960-04-12 | — | 9527383499 | 4199 Church St, Glendale, AZ, 85349 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-25253 | PRV | Cheryl Cunningham | 1963-02-20 | UHC-69862-58 | 8194278892 | 9223 Elm St, Seattle, WA, 98192 | 0.90 | Date of birth reformattedPhone reformattedMember ID reformattedState code upper-cased+1 more |
| PRV-20393 | PRV | Maria H Warren | 1982-03-24 | UHC-60350-58 | 6485139927 | 5611 Hillcrest Rd, Plano, TX, 75062 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-24543 | PRV | Philip E Marquez | 1996-12-05 | — | 4993872619 | 875 Broadway, Seattle, WA, 98117 | 0.90 | Name re-casedPhone reformattedAddress re-casedState code upper-cased+1 more |
| PRV-25295 | PRV | Gloria Deaan | 1970-08-16 | UHC-28610-05 | 6426518782 | 7126 Meadow Ln, Miami, FL, 33137 | 0.90 | Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-24523 | PRV | Melissa Fisher | 1988-09-10 | — | 6708264013 | 7841 Willow Ct, Miami, FL, 33114 | 0.90 | Date of birth reformattedPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-22782 | PRV | Cynthia N Luna | 1970-06-09 | UHC-76246-70 | 8587875628 | 5505 Washington St, Atlanta, GA, 30301 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-21658 | PRV | Adam Simpson | 1949-08-17 | — | 3427087271 | 1763 Sage Ct, Scottsdale, AZ, 85273 | 0.90 | Name re-casedPhone reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-26838 | PRV | Nicole F Santos | 1938-12-19 | — | 2537013915 | 9029 Ocean Ave, Minneapolis, MN, 55437 | 0.90 | Date of birth reformattedPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-26746 | PRV | Jonathan H Johnston | 1977-03-04 | — | 9172331133 | — | 0.90 | Name re-casedPhone reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-23603 | PRV | Beverly Y Hunt | 1984-05-06 | UHC-39169-49 | 3373336093 | 1902 Maple Ave, Gilbert, AZ, 85246 | 0.90 | Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-26109 | PRV | Christopher Russell | 1958-05-19 | — | 7678880764 | — | 0.90 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+1 more |
| PRV-27801 | PRV | Gerald K Robertson | 1945-09-20 | — | — | 2789 Palm Dr, Phoenix, AZ, 85083 | 0.90 | Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-29496 | PRV | Paul Morris | 1987-08-17 | UHC-21357-84 | 3974456187 | 9224 Sunset Blvd, Las Vegas, NV, 89157 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-22745 | PRV | Elijah Gray | 2002-07-26 | UHC-73436-77 | 6382969891 | — | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-26210 | PRV | Mason Ortiz | 2008-02-08 | UHC-43983-84 | 8272432942 | 9428 Lake View Rd, Tempe, AZ, 85262 | 0.90 | Date of birth reformattedMember ID reformattedState code upper-casedWhitespace trimmed+1 more |
| PRV-20329 | PRV | Beverly Aguilar | 1948-02-07 | UHC-27212-80 | 7377223654 | 2486 Baseline Rd, Scottsdale, AZ, 85255 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-25737 | PRV | Amber Munoz | 1984-08-17 | UHC-03266-71 | 5585273189 | 9780 Maple Ave, Chandler, AZ, 85275 | 0.90 | Phone reformattedCity re-casedEmail lower-casedWhitespace trimmed+1 more |
| PRV-21801 | PRV | Helen Gray | 1978-07-03 | UHC-92539-10 | 5214004681 | — | 0.90 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+1 more |
| PRV-28710 | PRV | Kathryn Mendez | 1968-06-22 | UHC-53197-07 | 7433484944 | 7362 Maple Ave, Tucson, AZ, 85782 | 0.90 | Date of birth reformattedPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-24260 | PRV | Paul Z Cooper | 1984-05-19 | — | 9275331056 | — | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-24259 | PRV | Paul Z Cooper | 1984-05-19 | — | 9275331056 | — | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-23585 | PRV | Catherine Tucker | 1967-02-09 | — | 9256588008 | 7520 Ridge Rd, Austin, TX, 78746 | 0.90 | Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-29514 | PRV | Cheryl Carr | 1981-12-11 | — | 6254293747 | — | 0.90 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+1 more |
| PRV-22711 | PRV | Justin Morgan | 1956-06-21 | — | 6767539937 | 4401 Desert Sky Blvd, Tempe, AZ, 85233 | 0.90 | Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-22710 | PRV | Justin Morgan | 1956-06-21 | — | 6767539937 | 4401 Desert Sky Blvd, Tempe, AZ, 85233 | 0.90 | Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-25777 | PRV | Rachel Freeman | 1974-12-07 | — | 9563321775 | 7580 Central Ave, Nashville, TN, 37276 | 0.90 | Name re-casedCity re-casedState code upper-casedWhitespace trimmed+1 more |
| PRV-27036 | PRV | Andrea Lucas | 1992-04-01 | — | 3816365031 | 4378 Lake View Rd, Denver, CO, 80245 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-25732 | PRV | Wlter Lucas | 1938-06-22 | — | 9584905029 | 6999 Indian School Rd, Denver, CO, 80270 | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-23254 | PRV | Adam A Weaver | 1941-07-08 | — | 2108899697 | 4901 Spring St, Mesa, AZ, 85271 | 0.90 | Phone reformattedCity re-casedState code upper-casedEmail lower-cased+1 more |
| PRV-28261 | PRV | Joshua Hicks | 1958-02-27 | — | 5172881512 | — | 0.90 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |