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-23005 | PRV | Vincent K Smith | 1954-08-27 | — | 3492261141 | 2219 Canyon Rd, San Diego, CA, 92184 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29393 | PRV | Charles Marquez | 1943-08-17 | UHC-60230-72 | 7685626720 | 9250 Park Pl, Charlotte, NC, 28209 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22768 | PRV | Jack Mendoza | 1978-09-13 | — | 6868208834 | 6468 Camelback Rd, Chandler, AZ, 85243 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27591 | PRV | Debra E Spencer | 2002-07-17 | — | — | 1364 Willow Ct, Plano, TX, 75023 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29251 | PRV | Ashley Castillo | 2007-03-10 | UHC-36019-06 | 5076674217 | 9750 Desert Sky Blvd, Denver, CO, 80289 | 0.74 | Name re-casedDate of birth reformattedCity re-casedZIP+4 trimmed+3 more |
| PRV-28637 | PRV | Chistina Garcia | 1969-02-11 | UHC-73700-75 | 4336748812 | 7938 Church St, Houston, TX, 77017 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-21298 | PRV | John Wast | 1938-01-22 | UHC-39164-01 | 7749919668 | 8348 Market St, Austin, TX, 78748 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-27682 | PRV | Lauren U Peters | 1984-07-16 | — | 2252857791 | 1420 Oak St, Glendale, AZ, 85392 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27946 | PRV | Sean A Gordon | 1948-09-19 | UHC-57083-46 | 6269540392 | 9787 Canyon Rd, Mesa, AZ, 85272 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-29310 | PRV | Jeremy Carroll | 1981-07-04 | — | 3463307896 | 9384 Church St, Las Vegas, NV, 89118 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21572 | PRV | Sara Patel | 2002-03-22 | UHC-48728-33 | 7678398428 | 1780 Baseline Rd, Tucson, AZ, 85768 | 0.74 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-24591 | PRV | Kathleen Crawford | 1999-06-01 | UHC-99013-43 | 3078235692 | 5269 Jefferson Ave, Glendale, AZ, 85356 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29240 | PRV | Mary Hudzon | 1995-01-14 | UHC-28041-40 | 7754797193 | 9385 Mesa Dr, San Diego, CA, 92171 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28574 | PRV | John Moore | 1996-04-11 | — | 4072061847 | 3523 Market St, Sacramento, CA, 95863 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-29521 | PRV | Alan Harris | 1946-08-05 | — | 6765925049 | 1221 Union St, Minneapolis, MN, 55422 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29204 | PRV | Charles Z Jimenez | 1946-02-17 | UHC-25702-22 | 9815565596 | 5023 River Rd, Austin, TX, 78767 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-24690 | PRV | Kenneth Thompson | 1952-02-21 | — | 4765472424 | 2624 Central Ave, San Antonio, TX, 78270 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23716 | PRV | Christian W Lane | 1971-03-19 | — | 9039419029 | 5676 Meadow Ln, Jacksonville, FL, 32260 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20120 | PRV | Camila Bryant | 1941-07-01 | UHC-78163-31 | 4093755405 | 517 Harbor Blvd, Columbus, OH, 43259 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26351 | PRV | Marcus O Nichols | 2005-03-17 | UHC-25674-18 | 3672142096 | 3722 Camelback Rd, Eden Prairie, MN, 55322 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20408 | PRV | Joe Y Reid | 1960-07-03 | UHC-26803-21 | 7926307434 | 8020 Sunset Blvd, Seattle, WA, 98118 | 0.74 | Name re-casedPhone reformattedMember ID reformattedCity re-cased+3 more |
| PRV-25769 | PRV | Jennifer Dean | 1954-01-02 | UHC-62336-89 | 6205421689 | 8007 Indian School Rd, Jacksonville, FL, 32204 | 0.74 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22162 | PRV | Lisa J Bryant | 1997-02-06 | — | 9268184628 | 5893 Meadow Ln, Nashville, TN, 37224 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-21651 | PRV | Amanda Wright | 1972-08-09 | — | 4056449641 | 1297 Willow Ct, Charlotte, NC, 28241 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21652 | PRV | Amanda Wright | 1972-08-09 | — | 4056449641 | 1297 Willow Ct, Charlotte, NC, 28241 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20822 | PRV | Beverly Taylor | 1996-03-12 | UHC-10404-50 | 4842487245 | 8531 Canyon Rd, Mesa, AZ, 85240 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedState code upper-cased+3 more |
| PRV-21613 | PRV | Albert Mason | 1954-03-14 | UHC-72233-68 | 7695936039 | 2440 Desert Sky Blvd, Glendale, AZ, 85355 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20543 | PRV | Teresa Chavez | 1953-05-09 | UHC-36535-42 | 4362124413 | 1648 Valley View Dr, Eden Prairie, MN, 55343 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-27600 | PRV | Alice Hunter | 2006-08-21 | UHC-81231-21 | 6005691813 | 2357 Indian School Rd, Plano, TX, 75062 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-28256 | PRV | Logan Laron | 1945-04-19 | UHC-56916-28 | 9866887457 | 6157 Forest Ave, Phoenix, AZ, 85053 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22291 | PRV | Julia Mitchell | 1953-11-03 | UHC-66986-06 | 3719875870 | 9134 Cedar Ln, Nashville, TN, 37211 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27153 | PRV | Deborah Vargas | 1944-06-26 | — | 4096433678 | 4953 Apache Blvd, Minneapolis, MN, 55473 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21249 | PRV | Jeffrey Larson | 1955-09-24 | UHC-00373-95 | 2895514159 | 5242 Jefferson Ave, Scottsdale, AZ, 85236 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21602 | PRV | Wayne Gutierrez | 1982-11-13 | UHC-35850-27 | 4287131616 | 7979 Park Pl, Miami, FL, 33196 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24201 | PRV | Kathryn Nunez | 1984-11-27 | — | 7087994006 | 3733 Meadow Ln, Los Angeles, CA, 90025 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-23824 | PRV | Melissa Rose | 1954-07-10 | UHC-51916-72 | 8748714040 | 6028 Maple Ave, Phoenix, AZ, 85084 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21406 | PRV | Brenda Johnston | 1996-01-24 | — | 8784258724 | 1490 River Rd, Tampa, FL, 33656 | 0.74 | Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+3 more |
| PRV-21405 | PRV | Brenda Johnston | 1996-01-24 | — | 8784258724 | 1490 River Rd, Tampa, FL, 33656 | 0.74 | Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+3 more |
| PRV-20485 | PRV | Terry Hansen | 1956-10-09 | — | 4798898424 | 9836 Camelback Rd, Gilbert, AZ, 85294 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22990 | PRV | Ronald I Watkins | 2008-06-26 | — | 9492320415 | 21 Washington St, Fresno, CA, 93792 | 0.74 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-26986 | PRV | Fatima Z Bell | 1997-02-17 | — | 3783962460 | 3325 Harbor Blvd, Miami, FL, 33179 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25160 | PRV | Amanda Weaver | 2008-06-06 | — | 6942664323 | 7895 Park Pl, Plano, TX, 75007 | 0.74 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-27537 | PRV | Elijah Wilson | 1945-03-07 | — | 3272767470 | 8213 River Rd, Denver, CO, 80231 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20586 | PRV | Stephen Garza | 1947-12-11 | — | 9046536487 | 9896 Ridge Rd, Orlando, FL, 32863 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26430 | PRV | Arjun Evans | 1979-02-19 | — | 2913574271 | 5961 Broadway, Scottsdale, AZ, 85235 | 0.74 | Name split from “Last, First”Date of birth reformattedPhone reformattedAddress re-cased+3 more |
| PRV-24712 | PRV | Charles J Ray | 1951-09-17 | — | — | 8897 Ridge Rd, Nashville, TN, 37227 | 0.74 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| PRV-28512 | PRV | Priya Ryan | 1989-06-17 | UHC-94155-47 | 4776411864 | 6949 Canyon Rd, Chandler, AZ, 85249 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25728 | PRV | Joseph O Delgado | 1980-05-26 | UHC-93057-58 | 5163807761 | 7648 Jefferson Ave, San Diego, CA, 92159 | 0.74 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-26804 | PRV | Kathleen Hughes | 1949-12-20 | UHC-40860-30 | 6968408950 | 5289 Oak St, Phoenix, AZ, 85065 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29382 | PRV | Keith Cruz | 1946-01-14 | UHC-71380-39 | 8117629109 | 5885 Sunset Blvd # 810, Plano, TX, 75054 | 0.74 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more |