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-23718 | PRV | Michael V Harrison | 1963-07-09 | UHC-04868-24 | 9577426060 | 7551 Lake View Rd, Los Angeles, CA, 90095 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27572 | PRV | Kathleen Day | 1966-11-21 | UHC-04206-33 | 4146753098 | 3932 Meadow Ln, Tampa, FL, 33660 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26121 | PRV | Davis Deborah | 1953-07-11 | UHC-21383-58 | 5963862981 | 9882 Valley View Dr, Austin, TX, 78745 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-24153 | PRV | Bradley Arnold | 1957-01-14 | — | — | 525 Lake View Rd, Gilbert, AZ | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27852 | PRV | Julie Hart | 1940-08-25 | — | — | 3705 Harbor Blvd, Mesa, AZ, 85245 | 0.62 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| PRV-28616 | PRV | Andrew Brown | 1975-10-17 | — | 6199336966 | 7476 Apache Blvd # 576, San Diego, CA, 92144 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-25208 | PRV | Fatima Daniels | 2007-06-08 | — | 6599382100 | 500 Desert Sky Blvd, Plano, TX | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27877 | PRV | Ahmed Russell | 1951-03-24 | — | 2914949633 | 9679 Hillcrest Rd, Los Angeles, CA, 90087 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25436 | PRV | Sara Obrien | 2005-07-18 | UHC-73544-87 | 5999066106 | 8510 Sage Ct, Orlando, FL | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23492 | PRV | Joshua Ross | 1989-12-07 | — | 2955334474 | 3415 Pine Dr, Miami, FL, 33128 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21826 | PRV | Sophia Z Lynhc | — | UHC-01980-86 | 7369644069 | 2211 Harbor Blvd, Mesa, AZ, 85279 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+3 more |
| PRV-22271 | PRV | Janet Fox | 1996-07-05 | UHC-69968-18 | 4845099574 | 9667 Mesa Dr, Columbus, OH | 0.62 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-25215 | PRV | Jason X Garrett | 1978-04-08 | — | 6574036234 | 5500 Canyon Rd, Fresno, CA, 93799 | 0.62 | Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more |
| PRV-20729 | PRV | Lauren Nunez | 1976-04-15 | UHC-81063-83 | 5876623640 | 8700 Oak St, Sacramento, CA, 95864 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24931 | PRV | Margaret Cole | 1973-09-02 | UHC-65282-20 | 4333174026 | 6556 Lake View Rd, Las Vegas, NV | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27289 | PRV | Martha Hart | 1992-08-09 | — | 6112168218 | 8285 Oak St, Orlando, FL, 32874 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22046 | PRV | Matthew K Montgomery | 1972-10-03 | — | 9079446751 | 4920 Lake View Rd Apt 31, Charlotte, NC, 28279 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-24542 | PRV | Evelyn Z Freeman | 1958-03-22 | — | 5744770213 | 1736 Mountain View Dr, Atlanta, GA, 30364 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-28394 | PRV | Richard Ryan | 2005-07-22 | UHC-99882-77 | 9899269507 | 1288 Washington St Apt 35, Fresno, CA, 93743 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-21833 | PRV | Jason Morales | 1947-11-11 | — | 7029978960 | 3993 Desert Sky Blvd, Charlotte, NC, 28246 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+3 more |
| PRV-27226 | PRV | Santiago Franklin | 1954-10-10 | UHC-35421-78 | 9599179021 | 8938 Union St, Gilbert, AZ, 85212 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-27423 | PRV | Arthur Greene | 1942-11-16 | — | 4914654923 | 4951 Canyon Rd, Los Angeles, CA, 90085 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more |
| PRV-26399 | PRV | Richard Montgomery | 1974-09-26 | UHC-73151-29 | 4444215030 | 5204 Lincoln Way, Sacramento, CA, 95802 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25473 | PRV | Kayla Brooks | 1955-09-14 | — | 5992514981 | 2690 Oak St Apt 4, Los Angeles, CA, 90007 | 0.62 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-23027 | PRV | Amber Salazar | 1962-12-17 | — | 3498815048 | 1069 Sunset Blvd Apt 15, Las Vegas, NV, 89103 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-22135 | PRV | Richard Medina | 1988-06-20 | — | 5669552739 | 9218 Highland Ave, Eden Prairie, MN, 55378 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29375 | PRV | Wei Rogers | 1991-09-25 | — | 7742378258 | 9562 Elm St, Orlando, FL, 32889 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28956 | PRV | Helen Ryan | 1998-10-21 | — | 6305830091 | 3533 Pine Dr, Atlanta, GA, 30366 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-27256 | PRV | Andrew Vargas | 1942-06-24 | — | 7979818086 | 8072 Mountain View Dr, San Diego, CA, 92104 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-20614 | PRV | Charlotte V Moore | 2002-02-05 | — | 8357656917 | 3631 Market St, Minneapolis, MN, 55475 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27542 | PRV | Andrea S McDonald | 1964-07-03 | — | — | 323 Mountain View Dr # 552, Columbus, OH, 43281 | 0.62 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-24032 | PRV | Jessica G Perez | 1997-02-15 | — | 8917133214 | 9284 Willow Ct, Dallas, TX | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27380 | PRV | Kaen Oliver | 1961-01-25 | UHC-08596-95 | 8316253695 | 532 Lincoln Way, Houston, TX, 77049 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-20476 | PRV | Julie Washington | 1939-10-25 | UHC-19375-27 | 4662015517 | 4718 Union St, Scottsdale, AZ, 85298 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20197 | PRV | Linda Y Oliver | 1945-06-19 | — | 9753209662 | 8742 Baseline Rd, Tampa, FL, 33609 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24887 | PRV | Megan R Lee | 1974-08-11 | UHC-53262-83 | — | 1493 Highland Ave, Denver, CO, 80254 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-24886 | PRV | Megan R Lee | 1974-08-11 | UHC-53262-83 | — | 1493 Highland Ave, Denver, CO, 80254 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-23672 | PRV | Carlos Hunt | 1971-12-18 | — | 3175981099 | 1181 Desert Sky Blvd, San Diego, CA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24802 | PRV | Jose Morrison | 1953-08-27 | UHC-06840-28 | 7077132703 | 8493 Harbor Blvd Apt 20, Glendale, AZ, 85334 | 0.62 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-22048 | PRV | Diana Ramos | 1994-10-07 | UHC-98291-09 | 7007448006 | 8705 Pine Dr, Atlanta, GA, 30335 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-20067 | PRV | Roy Wood | — | — | 6067236102 | 2733 Sunset Blvd, Gilbert, AZ, 85212 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| PRV-27790 | PRV | Joan O Brooks | 1964-05-03 | UHC-26997-72 | 6432077408 | 2198 Forest Ave Apt 40, Phoenix, AZ, 85096 | 0.62 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-27791 | PRV | Joan O Brooks | 1964-05-03 | UHC-26997-72 | 6432077408 | 2198 Forest Ave Apt 40, Phoenix, AZ, 85096 | 0.62 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-26992 | PRV | Juulie J Gomez | 1941-06-07 | UHC-08457-10 | 7508062634 | 5130 Bayshore Dr # 696, Gilbert, AZ, 85241 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-23323 | PRV | Logan Collins | 1944-12-21 | — | 5114008104 | 9814 Pine Dr # 700, Las Vegas, NV, 89137 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-26548 | PRV | Mariana Franlkin | 1954-12-15 | — | 8135063873 | 6836 Main St, Plano, TX, 75019 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26937 | PRV | Sarah Frankllin | — | UHC-19757-48 | 6752135009 | 5484 Central Ave, Sacramento, CA, 95864 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| PRV-23725 | PRV | Ethan Ross | 1978-05-11 | — | 8693779501 | 1589 Central Ave, Jacksonville, FL, 32248 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-27547 | PRV | Alexander James | 1995-08-17 | UHC-89597-44 | 7732849113 | 2877 Indian School Rd, Tempe, AZ, 85221 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20749 | PRV | John Berry | 1950-04-11 | UHC-41668-73 | 3954812675 | 3364 Forest Ave, Glendale, AZ, 85322 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |