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-29031 | PRV | Russell Brooks | 1971-11-18 | — | 6005554046 | 2424 Central Ave, Las Vegas, NV, 89132 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| PRV-25977 | PRV | Scott P Hughes | 1958-01-10 | UHC-53716-26 | 8217485157 | 5069 Lincoln Way Apt 6, Orlando, FL, 32854 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-21664 | PRV | Maggie Obrien | 1985-05-03 | UHC-19518-51 | 2982673659 | 1406 Elm St, Nashville, TN, 37286 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27895 | PRV | Joe G Bishop | 1967-10-04 | UHC-26419-88 | 6258259436 | 3979 Elm St Apt 38, Gilbert, AZ, 85264 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-23083 | PRV | Bobby Henderson | 1995-04-15 | UHC-70285-55 | 5709873670 | 9539 Mesa Dr, Los Angeles, CA, 90027 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-28664 | PRV | Andy Ford | 1967-04-18 | — | 2557190087 | 4446 Bayshore Dr, Scottsdale, AZ, 85266 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-21040 | PRV | Janice Ramirez | 1973-02-17 | UHC-60736-65 | 2633376732 | 4673 Sunset Blvd, Eden Prairie, MN, 55358 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21039 | PRV | Janice Ramirez | 1973-02-17 | UHC-60736-65 | 2633376732 | 4673 Sunset Blvd, Eden Prairie, MN, 55358 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26131 | PRV | Carolyn Kennedy | 1948-08-06 | UHC-02309-97 | 5397528324 | 5655 Main St, Glendale, AZ, 85336 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26025 | PRV | Michelle Spencer | 2002-07-28 | — | 7833940461 | 4328 Pine Dr, Plano, TX, 75094 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-20226 | PRV | Joe J Washington | 1952-07-17 | UHC-56815-47 | 6196643976 | 6560 Market St, Glendale, AZ, 85325 | 0.62 | Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+3 more |
| PRV-21918 | PRV | Kevvin A Rice | 1953-10-12 | — | 7408127885 | 7401 Pine Dr, Fresno, CA, 93756 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27192 | PRV | Mark Schultz | 1984-04-08 | — | 6925889993 | 3302 Palm Dr Apt 25, Denver, CO, 80239 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-22131 | PRV | Henry Roberts | 1969-10-21 | — | 6856078523 | 7955 Sage Ct # 199, Chandler, AZ, 85285 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-21478 | PRV | Justin Wong | 1960-01-10 | — | 5583050718 | 4253 Forest Ave, Tucson, AZ, 85741 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24535 | PRV | Ruth West | 1976-01-09 | UHC-47531-91 | 7219560400 | 8654 Lake View Rd, Glendale, AZ, 85342 | 0.62 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| PRV-28105 | PRV | Hiroshi Nichols | 1940-10-19 | — | 2245412449 | 3716 Camelback Rd, Denver, CO, 80219 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22360 | PRV | Ryan Howell | 1982-04-25 | UHC-91148-66 | — | 4377 Forest Ave, Miami, FL, 33176 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24147 | PRV | Diego Cole | 2004-10-23 | — | 7548327846 | 2462 Sage Ct, Sacramento, CA, 95810 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25882 | PRV | Margaret G Chavez | 1972-11-16 | UHC-76634-70 | 9282038691 | 27 Sage Ct, Seattle, WA, 98131 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27693 | PRV | Donald O Washinggton | 1999-02-07 | — | 7537451819 | 732 Church St, Glendale, AZ, 85315 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25534 | PRV | Marilyn Reyes | 1975-10-22 | — | 3649536284 | 6140 Baseline Rd, Eden Prairie, MN, 55365 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23872 | PRV | Edward Holmes | 1960-12-14 | UHC-55851-37 | 2157943393 | 1254 Jefferson Ave, Glendale, AZ, 85360 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26332 | PRV | Gloria Stewart | 1979-03-28 | — | 4772561517 | 7869 Indian School Rd, Jacksonville, FL | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20581 | PRV | Omar Dixon | 1973-07-09 | UHC-94376-27 | 5108418557 | 636 Meadow Ln, Tempe, AZ | 0.62 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more |
| PRV-25832 | PRV | Kimberly W Henderson | 1980-02-01 | UHC-76058-16 | 4509111685 | 5226 Desert Sky Blvd, Austin, TX, 78772 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25057 | PRV | Amanda Campbell | 1940-10-01 | UHC-80536-94 | 5622652929 | 8762 Indian School Rd Apt 27, Orlando, FL, 32834 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-25052 | PRV | Gerald Jenkins | — | — | 5225566908 | 9796 Desert Sky Blvd, Chandler, AZ, 85242 | 0.62 | Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20757 | PRV | Christopher Y Perry | 1981-12-03 | — | 4438076499 | 2218 Apache Blvd, Nashville, TN, 37233 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| PRV-28034 | PRV | Deborah Pery | 1942-09-28 | UHC-90537-38 | 4816085049 | 1929 Oak St, Fresno, CA, 93777 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| PRV-26680 | PRV | Megan Carter | 1953-09-14 | UHC-16129-53 | 4674071961 | 2354 Canyon Rd, Tucson, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28077 | PRV | William Hunt | 1993-07-18 | — | 3074370892 | 670 Willow Ct, Orlando, FL, 32837 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24162 | PRV | Danielle G Carroll | 1992-03-01 | UHC-70974-77 | 5179648732 | 1954 Maple Ave, Gilbert, AZ, 85256 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23893 | PRV | Lauren Shaw | 1997-08-15 | UHC-70188-66 | 6014169084 | 2823 Spring St, Los Angeles, CA, 90095 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-28539 | PRV | Peter Carlson | 1949-05-26 | UHC-51214-95 | 2592701194 | 206 Maple Ave, Tempe, AZ, 85230 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24741 | PRV | Jennifer Hayse | 2004-01-09 | UHC-67865-24 | 6818982160 | 314 Maple Ave, Phoenix, AZ, 85021 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20839 | PRV | Greg Hudson | 2001-05-05 | UHC-35926-32 | 4223891622 | 3589 Spring St, Tucson, AZ, 85701 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27523 | PRV | Stephen Webb | 1950-06-21 | — | 7028641262 | 7464 Canyon Rd, Minneapolis, MN | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26331 | PRV | Ronald Guerrero | 1953-09-22 | — | — | 8347 Market St, Scottsdale, AZ, 85262 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-20404 | PRV | Ablert Clark | 1977-05-15 | UHC-36686-91 | 8862532948 | 7039 Apache Blvd, Eden Prairie, MN, 55330 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26016 | PRV | Tyler Li | 1939-02-08 | UHC-35505-93 | 5075694556 | 3573 Grand Ave, Las Vegas, NV, 89111 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-26015 | PRV | Tyler Li | 1939-02-08 | UHC-35505-93 | 5075694556 | 3573 Grand Ave, Las Vegas, NV, 89111 | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-20301 | PRV | Emily Mejia | 1976-04-16 | UHC-14207-80 | 2842861564 | 9063 Hillcrest Rd, Dallas, TX, 75252 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29554 | PRV | Bruce Bennett | 1966-04-06 | — | 2022203023 | 1262 Union St, Miami, FL, 33108 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-23936 | PRV | Philip W Lawson | 2008-12-27 | UHC-04229-09 | — | 8364 Main St, Dallas, TX, 75217 | 0.62 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more |
| PRV-24561 | PRV | Elizabeth Ruiz | 1971-02-03 | UHC-93078-29 | 2312135623 | 1768 Union St, San Antonio, TX, 78242 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27461 | PRV | George Bishop | 1998-03-28 | UHC-09489-36 | 9042857970 | 1650 Grand Ave, Plano, TX, 75052 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-24242 | PRV | William R Allen | 1953-06-12 | — | 3647074187 | 430 Highland Ave, Dallas, TX, 75267 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28761 | PRV | Charlotte X Ramos | 1996-05-05 | UHC-26786-04 | 8714727455 | 3625 Ocean Ave, Denver, CO, 80249 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21670 | PRV | Anthony Fox | 1958-07-09 | — | 9792049229 | 3622 Desert Sky Blvd, Eden Prairie, MN, 55305 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |