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-28417 | PRV | Ralph Arnold | 1998-08-26 | — | 9143792078 | 1334 Jefferson Ave # 442, San Antonio, TX, 78254 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-28416 | PRV | Ralph Arnold | 1998-08-26 | — | 9143792078 | 1334 Jefferson Ave # 442, San Antonio, TX, 78254 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-27886 | PRV | Rebecca Stevens | — | — | 2343656742 | 2879 Lincoln Way, Los Angeles, CA, 90097 | 0.64 | Name re-casedDate of birth unreadablePhone reformattedZIP+4 trimmed+2 more |
| PRV-23441 | PRV | Samantha T Welch | 1970-08-20 | UHC-81164-04 | 4308865183 | 3081 Jefferson Ave, San Antonio, TX | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22788 | PRV | Angela Q Hawkins | 2003-04-13 | — | 8632020678 | 8940 Church St, Mesa, AZ, 85276 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-22427 | PRV | Jason Ramirez | 1998-11-21 | UHC-37350-18 | 2276145840 | 6727 Valley View Dr, Minneapolis, MN, 55491 | 0.64 | Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-24633 | PRV | Mei Hunt | 1946-12-20 | UHC-84600-88 | — | 7787 Baseline Rd, Phoenix, AZ, 85053 | 0.64 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26325 | PRV | Priya Stewart | 1976-08-09 | UHC-29329-49 | 4672770248 | 6977 Hillcrest Rd, Jacksonville, FL | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28969 | PRV | Edward Boyd | — | — | 7173338374 | 8783 Willow Ct, San Diego, CA, 92123 | 0.64 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27487 | PRV | Riick Jenkins | 1953-09-25 | — | 4009793863 | 1374 Forest Ave, Austin, TX, 78715 | 0.64 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24367 | PRV | Jooyce Gonzales | 1996-07-20 | UHC-24623-10 | 2376566859 | 3425 Pine Dr Apt 20, Jacksonville, FL, 32244 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-27431 | PRV | Douglas Yang | — | UHC-45248-33 | — | 6930 Lincoln Way, Fresno, CA, 93790 | 0.64 | Name re-casedDate of birth missingMember ID reformattedStreet suffix standardised+2 more |
| PRV-27274 | PRV | Benjamin Alvarado | 1960-08-19 | UHC-00426-39 | 6566811955 | 8188 Mesa Dr, Sacramento, CA, 95826 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29576 | PRV | Maria D Fields | 1944-03-23 | — | 4249872474 | 7659 Hillcrest Rd, Minneapolis, MN, 55489 | 0.64 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more |
| PRV-23524 | PRV | Kathryn X Lopez | 2001-01-08 | — | 9363317270 | 2249 Valley View Dr, Scottsdale, AZ, 85265 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25250 | PRV | Mariana Ryan | 1955-05-09 | — | — | 2596 Valley View Dr, Plano, TX, 75082 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-26917 | PRV | Carlos Palmer | 1983-09-21 | — | 4607233450 | 9440 Palm Dr # 423, Tampa, FL, 33651 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-24177 | PRV | Paul Collins | 1958-04-25 | UHC-68079-95 | 7705465499 | 2464 Central Ave, San Diego, CA, 92124 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-22617 | PRV | Alice Fox | 1956-01-28 | — | 7556918267 | 4968 Mountain View Dr, Charlotte, NC, 28291 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22785 | PRV | Angela Wang | 1967-03-01 | UHC-43079-70 | 6679889966 | 8641 Valley View Dr, Orlando, FL, 32887 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27505 | PRV | Andrew A Harper | 1980-05-08 | UHC-99041-25 | 9468199420 | 5722 Lincoln Way, Tempe, AZ | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22386 | PRV | Kimberly Young | 1974-07-18 | — | 3612186867 | 5824 Washington St, Mesa, AZ, 85291 | 0.64 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| PRV-29032 | PRV | Benjamin K Vasquuez | 2006-04-10 | UHC-82637-55 | 3042095884 | 5631 Mountain View Dr, Orlando, FL, 32879 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-20654 | PRV | Jamse Marshall | 2006-09-03 | UHC-35247-81 | 3546443991 | 2554 Willow Ct, San Antonio, TX | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22464 | PRV | Janet Holmes | 2001-05-05 | UHC-27263-09 | 7608132571 | 5096 River Rd, Las Vegas, NV, 89148 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-25720 | PRV | Wei Hamilton | 1938-05-27 | — | — | 4558 Cedar Ln, Plano, TX | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-21223 | PRV | Camila Delgado | 1975-06-05 | UHC-77210-26 | 8896251986 | 4527 Desert Sky Blvd, Glendale, AZ, 85301 | 0.64 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| PRV-24462 | PRV | Diego W Lawson | 1966-10-07 | UHC-46964-36 | 4479788753 | 8363 Cedar Ln, Mesa, AZ, 85237 | 0.64 | Middle initial moved out of first nameStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22349 | PRV | Valentina Adams | 1955-01-24 | UHC-04850-47 | 5356165261 | 3261 Mesa Dr, Seattle, WA, 98130 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27669 | PRV | Christopher Mendoza | 1986-10-10 | — | 3393631130 | 1970 Central Ave, Nashville, TN, 37268 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-27135 | PRV | Stephanie B Porter | 1974-01-20 | UHC-82341-82 | 8525836360 | 3850 Jefferson Ave, Los Angeles, CA, 90086 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26630 | PRV | Larry Riley | 1938-04-13 | UHC-29158-66 | 3113969988 | 4797 Mountain View Dr, Orlando, FL | 0.64 | Name re-casedCity re-casedZIP missingGender normalised+2 more |
| PRV-24443 | PRV | Grace Jenkins | 1998-10-08 | — | 6244733419 | 4259 Sage Ct, Tampa, FL, 33608 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-25358 | PRV | Jaack N Burns | — | — | 3045836899 | 4753 Apache Blvd, San Diego, CA, 92197 | 0.64 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29349 | PRV | Stephanie Elliott | 1957-09-15 | — | 3688106511 | 2713 Bayshore Dr, Gilbert, AZ, 85252 | 0.64 | Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more |
| PRV-27630 | PRV | Eric Robertson | 2008-07-10 | UHC-01745-78 | 2186271767 | 3096 Union St, Fresno, CA, 93766 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23789 | PRV | Mary Robinson | 2006-01-16 | — | 7643267621 | 7941 Valley View Dr, Mesa, AZ | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25271 | PRV | Justin Johnson | 1992-03-02 | — | 6547959197 | 3789 Valley View Dr, Eden Prairie, MN, 55304 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23967 | PRV | Anthony L Palmer | 1953-06-21 | UHC-35596-29 | 6407435110 | 867 Elm St, Fresno, CA, 93755 | 0.64 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28721 | PRV | Angela O Harrison | 1950-06-12 | — | 2668981906 | 2120 Sunset Blvd, Jacksonville, FL, 32239 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24055 | PRV | Julie Li | 1986-01-24 | — | 9312746436 | 2088 Ocean Ave, Miami, FL, 33136 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23546 | PRV | Nancy Gray | 1941-07-06 | — | 3363845937 | 5749 Ridge Rd, Mesa, AZ | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-23545 | PRV | Nancy Gray | 1941-07-06 | — | 3363845937 | 5749 Ridge Rd, Mesa, AZ | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-21424 | PRV | Austin Wong | 1961-03-19 | UHC-52819-86 | 7579956047 | 7229 Cedar Ln, Los Angeles, CA | 0.64 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more |
| PRV-22498 | PRV | Marshall J Christian | 1994-01-04 | UHC-58093-69 | 8485091616 | 5719 Sunset Blvd Apt 37, Minneapolis, MN, 55478 | 0.64 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| PRV-27460 | PRV | Thomas Matthews | 2002-08-28 | UHC-58466-91 | — | 8141 Mountain View Dr, Miami, FL, 33161 | 0.64 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| PRV-24480 | PRV | Betty W Romero | 1970-01-02 | UHC-86415-53 | 5552874995 | 5730 Union St # 903, Tucson, AZ, 85777 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-23490 | PRV | Andrew Lee | 1991-10-06 | — | — | 9648 Grand Ave, Eden Prairie, MN, 55342 | 0.64 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21576 | PRV | Daniel T Williams | 1993-11-01 | UHC-57654-55 | 3412590056 | 8390 Park Pl, Minneapolis, MN, 55408 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21777 | PRV | Mark Foster | 1939-07-22 | — | 9846263981 | 4474 Sage Ct Apt 34, Fresno, CA, 93713 | 0.64 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more |