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-24372 | PRV | Doris X Carroll | 1985-10-24 | UHC-14268-87 | 4776028146 | 5143 Indian School Rd, Dallas, TX, 75295 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23875 | PRV | Frances B Carpenter | 1989-07-13 | — | 2789370578 | 1399 Mountain View Dr, Plano, TX, 75046 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-26364 | PRV | Jacob Ramirez | 1979-06-01 | — | 2072070968 | 6959 Willow Ct, Tempe, AZ, 85296 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20239 | PRV | David Taylor | 1956-08-27 | — | 6073778597 | 4578 Baseline Rd, Jacksonville, FL, 32221 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21797 | PRV | Patricia Diaz | 1988-12-12 | UHC-24304-39 | 2249143798 | 1160 Washington St, Minneapolis, MN, 55427 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28851 | PRV | Evelyn Kim | 1991-05-18 | UHC-97183-17 | 8627110973 | 3615 Palm Dr, Seattle, WA, 98117 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24052 | PRV | Ray Gilbert | 1995-07-08 | UHC-47520-61 | 4154560807 | 6778 Sage Ct, Plano, TX, 75054 | 0.76 | Name re-casedPhone reformattedMember ID reformattedGender normalised+2 more |
| PRV-22992 | PRV | Rebecca Harris | 1995-09-15 | UHC-64318-81 | — | 7103 Market St, Atlanta, GA, 30388 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22448 | PRV | Alexander Gutierrez | 1969-08-03 | UHC-03255-02 | 6562687280 | 3809 Oak St, Sacramento, CA, 95811 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24182 | PRV | Maria Kim | 1946-06-22 | — | — | 1529 Market St, Tempe, AZ, 85233 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-26530 | PRV | Jordan Mitchell | 1995-11-27 | — | 3135680767 | 9584 Valley View Dr, Scottsdale, AZ, 85224 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25225 | PRV | Nancy T Williams | 1983-09-13 | UHC-38414-77 | 3487983527 | 4029 Harbor Blvd, Dallas, TX, 75225 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22188 | PRV | Jooyce Vargas | 1953-08-24 | — | 9374552440 | 6679 Spring St, Nashville, TN, 37222 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-25070 | PRV | Mei Wilson | 1978-03-11 | UHC-28950-12 | 8524687102 | 3147 Lincoln Way, Charlotte, NC, 28240 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-20354 | PRV | Kyle Thomas | 1971-04-10 | UHC-54913-13 | 3995382279 | 5913 Grand Ave, San Diego, CA, 92146 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-26365 | PRV | Jacob Ramirez | 1979-06-01 | — | 2072070968 | 6959 Willow Ct, Tempe, AZ, 85296 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28333 | PRV | Arthur Rivera | 1966-04-15 | — | 9749466383 | 8948 Apache Blvd, Houston, TX, 77054 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28839 | PRV | Mike George | 1955-06-24 | — | 6848031192 | 3589 Baseline Rd, Miami, FL, 33173 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28339 | PRV | Richard Rice | 1977-10-05 | UHC-29214-90 | — | 2371 Mesa Dr, Plano, TX, 75010 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-27351 | PRV | Brittany Alvarado | 1991-09-17 | UHC-89357-17 | 5975826766 | 7794 Baseline Rd, Phoenix, AZ, 85044 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-23474 | PRV | Alexander J Watkins | 1951-01-04 | UHC-16468-60 | 7905065866 | 4141 Meadow Ln, Columbus, OH, 43214 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22514 | PRV | Joan Hanson | 1970-10-28 | — | 3413620546 | 6881 Grand Ave, Orlando, FL, 32801 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-23583 | PRV | Stephanie Chavez | 1967-06-19 | — | 4925645552 | 1655 Indian School Rd, Phoenix, AZ, 85056 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-26449 | PRV | Eric Walsh | 1948-09-23 | UHC-81765-07 | 4749535319 | 2093 Indian School Rd, Tucson, AZ, 85756 | 0.76 | Name re-casedPhone reformattedCity re-casedGender normalised+2 more |
| PRV-21939 | PRV | Anthony D Collins | 1966-02-19 | — | 5729525310 | 1720 Pine Dr, Charlotte, NC, 28251 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23600 | PRV | Betty U Nichols | 1980-09-27 | — | 3877169503 | 6507 Oak St, Jacksonville, FL, 32265 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-28275 | PRV | Bobby Morgan | 2005-12-26 | UHC-41056-16 | 8993293453 | 5906 Maple Ave, Fresno, CA, 93738 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26340 | PRV | Annna Greene | 1986-02-14 | UHC-19124-93 | 9875217391 | 9359 Lake View Rd, Denver, CO, 80222 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27688 | PRV | Evelyn F Alvarado | 1979-10-24 | — | 3065217185 | 6542 Mesa Dr, San Antonio, TX, 78232 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29105 | PRV | Karen Holmes | 1997-05-28 | — | 9308401468 | 7304 Sage Ct, San Diego, CA, 92157 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-22412 | PRV | Jennifer M Hernandez | 1993-04-16 | — | 5092409310 | 2179 Pine Dr, Los Angeles, CA, 90073 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20221 | PRV | Andrea Collins | 1997-07-26 | — | 6439421120 | 7314 Mountain View Dr, Houston, TX, 77074 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-23061 | PRV | Ana James | 1952-02-17 | UHC-70297-58 | 8439058580 | 5758 Sunset Blvd, Los Angeles, CA, 90047 | 0.76 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-22347 | PRV | Bryen Ryan | 1983-06-11 | — | 9684781122 | 1607 Desert Sky Blvd, Sacramento, CA, 95858 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20297 | PRV | John Z Taylor | 1971-08-28 | UHC-19378-10 | 4673857651 | 8613 Washington St, Atlanta, GA, 30374 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25710 | PRV | Nicole Fuller | 1964-02-03 | UHC-31812-89 | 3558306285 | 9697 Ocean Ave, Orlando, FL, 32847 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20989 | PRV | Michael K Kelly | 1984-04-04 | UHC-55894-77 | 3142690661 | 9662 Willow Ct, Dallas, TX, 75200 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23486 | PRV | Daniel Palmer | 1976-01-03 | — | 7207690680 | 5385 Broadway, Eden Prairie, MN, 55313 | 0.76 | Name re-casedPhone reformattedCity re-casedGender normalised+2 more |
| PRV-22984 | PRV | Lawrence Hicks | 1954-03-16 | — | 6608903294 | 1518 Canyon Rd, Eden Prairie, MN, 55323 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25589 | PRV | Melissa Z Moreno | 1988-04-02 | UHC-16032-64 | 2194452758 | 5025 Oak St, Chandler, AZ, 85295 | 0.76 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22557 | PRV | Theresa Munoz | 1941-06-25 | UHC-11208-80 | 8789573749 | 5411 Mountain View Dr, Minneapolis, MN, 55412 | 0.76 | Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+2 more |
| PRV-28283 | PRV | Alice Cruz | 1939-01-08 | — | 4732383423 | 4350 Meadow Ln, Houston, TX, 77029 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23692 | PRV | Christina MJunk | 1954-09-19 | UHC-81624-09 | 4422218009 | 6995 Pine Dr, Plano, TX, 75052 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+2 more |
| PRV-29394 | PRV | Steve Santiago | 1963-04-22 | UHC-44779-58 | 5734295745 | 7267 Hillcrest Rd, Atlanta, GA, 30320 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-24573 | PRV | Rebecca U Hart | 1962-03-15 | — | 4442893304 | 2012 Jefferson Ave, Dallas, TX, 75284 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28185 | PRV | Pamela Thompson | 1997-01-21 | UHC-25513-16 | 4082124357 | 5987 Forest Ave, Denver, CO, 80250 | 0.76 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25659 | PRV | Ryan A Gonzalez | 1945-02-20 | — | 9038917608 | 7455 Ridge Rd, Dallas, TX, 75209 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20036 | PRV | Charles N Hall | 1983-05-04 | UHC-31175-80 | 5664880620 | 9101 Sage Ct, Tucson, AZ, 85798 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-27193 | PRV | Sarah Rivera | 1991-04-26 | — | 9097566613 | 9867 Sage Ct, Scottsdale, AZ, 85224 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24646 | PRV | Mason Wong | 1991-01-03 | — | 6776022117 | 4234 Willow Ct, Los Angeles, CA, 90028 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |