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-25489 | PRV | Aisha Castro | 1938-10-08 | UHC-02967-76 | 8946040056 | 3200 Apache Blvd, Las Vegas, NV, 89111 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-25432 | PRV | Omar V Moore | 2004-07-06 | — | 2598112902 | 6676 Central Ave, Columbus, OH, 43232 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27762 | PRV | Maria Hawkins | 1984-05-24 | UHC-51163-84 | 4666594416 | 4711 Desert Sky Blvd, Austin, TX, 78783 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26120 | PRV | Mary G Nunez | 1967-06-23 | UHC-30029-90 | 4078082756 | 326 Willow Ct, Houston, TX, 77049 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-28307 | PRV | Marcus P Davis | 1951-01-24 | UHC-27003-57 | 5598648628 | 889 Elm St, Columbus, OH, 43225 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-21122 | PRV | Jeremy Wagner | 1995-05-10 | UHC-69263-65 | 3948288733 | 5862 Oak St, Eden Prairie, MN, 55305 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26618 | PRV | Lori Bradley | 1960-07-22 | UHC-54008-33 | 9038515267 | 75 Market St, Las Vegas, NV, 89112 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26648 | PRV | Ralph A Mendoza | 1977-11-03 | UHC-00344-49 | 7793092735 | 1456 Palm Dr, Los Angeles, CA, 90082 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24079 | PRV | Mason Le | 1954-04-12 | — | 6057531126 | 1454 Camelback Rd, Glendale, AZ, 85361 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-24291 | PRV | Alan J Ellis | 1946-01-13 | — | 9427220019 | 491 Mesa Dr, Gilbert, AZ, 85284 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26693 | PRV | Betty Cox | 1944-01-01 | — | 2833629998 | 3527 Central Ave, Jacksonville, FL, 32275 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22115 | PRV | Ryan M Duncan | 2002-11-20 | — | 5002363668 | 8674 Willow Ct, Plano, TX, 75024 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20763 | PRV | Gregory H Richardson | 1961-04-11 | UHC-32697-71 | 2909667947 | 1687 Palm Dr, Dallas, TX, 75271 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20789 | PRV | Emily Roberts | 2006-06-27 | — | 2562969088 | 2034 Hillcrest Rd, Phoenix, AZ, 85017 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28515 | PRV | Barbara Hayes | 1951-03-26 | — | 9766358924 | 590 Meadow Ln, Fresno, CA, 93737 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-28964 | PRV | Edward Hicks | 1989-04-06 | — | 6545484363 | 3192 Mesa Dr, Columbus, OH, 43209 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22425 | PRV | Natalie Medina | 1972-05-23 | UHC-72744-31 | 3972900505 | 3602 Sunset Blvd, Tampa, FL, 33623 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28600 | PRV | Virginia Y Wong | 1971-03-07 | UHC-96611-25 | 6714357218 | 6349 River Rd, Chandler, AZ, 85271 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24740 | PRV | Charles V Murphy | 1953-02-10 | UHC-98759-52 | 3086765729 | 2992 Market St, Seattle, WA, 98162 | 0.76 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more |
| PRV-20693 | PRV | Roger Crawford | 1966-01-21 | UHC-92649-44 | — | 8719 Oak St, Phoenix, AZ, 85008 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27298 | PRV | Julie Butler | 1976-09-06 | UHC-18149-70 | 2847955261 | 3540 Apache Blvd, Los Angeles, CA, 90080 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21819 | PRV | Timothy Flores | 1980-10-14 | UHC-53330-02 | 5772997854 | 6476 Washington St, Eden Prairie, MN, 55389 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25488 | PRV | Kelly Warren | 1998-01-06 | — | 8732410158 | 4879 Harbor Blvd, Minneapolis, MN, 55421 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24304 | PRV | Evelyn Burns | 1991-10-17 | — | 7284719453 | 4461 Spring St, Tampa, FL, 33671 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20364 | PRV | Bryan Q Hansen | 1945-11-13 | UHC-58991-88 | 3276988031 | 8525 Highland Ave, San Antonio, TX, 78231 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-21541 | PRV | Sophia Hughes | 2006-11-23 | UHC-77760-37 | 7506300514 | 2143 Bayshore Dr, Tempe, AZ, 85230 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-27533 | PRV | Timothy Hicks | 1942-12-19 | UHC-95337-33 | 5286479517 | 4810 Church St, Scottsdale, AZ, 85295 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26261 | PRV | Brittany Mendez | 1946-05-27 | — | 9825017689 | 5701 Baseline Rd, Columbus, OH, 43234 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27037 | PRV | Jose Nelson | 1986-01-14 | UHC-60100-97 | 9797179244 | 2966 Grand Ave, Nashville, TN, 37272 | 0.76 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more |
| PRV-28357 | PRV | Marrtha Black | 1979-07-25 | UHC-60855-59 | 7275741569 | 9603 Baseline Rd, Seattle, WA, 98174 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29447 | PRV | Christian Morano | 1939-05-17 | — | 4474812422 | 9892 Lake View Rd, Scottsdale, AZ | 0.76 | Name re-casedDate of birth reformattedCity re-casedZIP missing+2 more |
| PRV-23883 | PRV | Patel Paul | 1942-11-22 | UHC-67299-32 | 6717233707 | 8622 Bayshore Dr Apt 22, Tucson, AZ, 85741 | 0.76 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+2 more |
| PRV-22631 | PRV | Willie Graham | 2001-04-23 | UHC-19939-09 | 4168641075 | 7899 Willow Ct, Minneapolis, MN, 55468 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23031 | PRV | Timothy Martin | 1985-02-15 | UHC-77042-14 | 8215652923 | 5826 Maple Ave, Fresno, CA, 93768 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26871 | PRV | Steve Lewis | 1945-04-19 | UHC-79108-37 | 7083511873 | 6070 Sage Ct, Scottsdale, AZ, 85260 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21009 | PRV | Timotyh Reynolds | 1961-07-01 | — | 4558027913 | 8333 Forest Ave, Miami, FL, 33125 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23558 | PRV | Sophia Murphy | 1975-06-15 | — | 4433302133 | 7694 Pine Dr, Glendale, AZ, 85314 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-23559 | PRV | Sophia Murphy | 1975-06-15 | — | 4433302133 | 7694 Pine Dr, Glendale, AZ, 85314 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-24594 | PRV | George Owens | 1938-04-26 | — | 6016586517 | 491 Union St, Glendale, AZ, 85322 | 0.76 | Date of birth reformattedPhone reformattedState code upper-casedZIP+4 trimmed+2 more |
| PRV-20128 | PRV | Harold Y Cole | 1946-09-26 | UHC-46572-82 | 4449423700 | 5148 Lincoln Way, San Antonio, TX, 78244 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22882 | PRV | Jess Fox | 1991-05-08 | — | 4932291787 | 2148 Apache Blvd, Jacksonville, FL, 32241 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more |
| PRV-21277 | PRV | Priya Dixon | 1998-08-21 | — | 3209531958 | 4608 Desert Sky Blvd, Columbus, OH, 43261 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27026 | PRV | Brandon Robinson | 1952-09-16 | UHC-78201-84 | 3552868027 | 5826 Jefferson Ave, Tempe, AZ, 85218 | 0.76 | Name re-casedPhone reformattedCity re-casedGender normalised+2 more |
| PRV-22324 | PRV | Amanda Peters | 1967-11-03 | — | 9289689090 | 2524 Spring St, Minneapolis, MN, 55488 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21455 | PRV | Camila S Murphy | 1977-05-27 | UHC-32185-12 | 7648076360 | 7655 Forest Ave, Scottsdale, AZ, 85253 | 0.76 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25135 | PRV | Keith Fod | 1947-04-21 | UHC-33594-46 | 4382416892 | 6215 Central Ave, Orlando, FL, 32811 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27270 | PRV | Joan Weber | 1940-06-07 | — | 8626198648 | 2151 Canyon Rd, Los Angeles, CA, 90083 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25881 | PRV | Linda Martin | 2006-09-27 | — | — | 1063 Union St, Dallas, TX, 75262 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-24730 | PRV | Albert Johnston | 1961-03-13 | UHC-99093-54 | 9212037775 | 6902 Indian School Rd, Chandler, AZ, 85283 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-20513 | PRV | Dorothy Jacobs | 1942-02-04 | — | 4322011656 | 2626 River Rd, Fresno, CA, 93771 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |