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-26476 | PRV | Jennifer Jensen | 2001-10-28 | UHC-53962-93 | 2922800161 | 512 Main St, Houston, TX, 77030 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20035 | PRV | Mariana Turner | 1997-07-23 | — | 3437119710 | 9224 Sage Ct, Nashville, TN, 37264 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-24456 | PRV | Logan S Romero | 1948-08-03 | UHC-29691-98 | 2163386986 | 3367 Central Ave, Los Angeles, CA, 90020 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-29106 | PRV | Cheryl Jordan | 2003-06-06 | UHC-20575-37 | 5728804657 | 9780 Forest Ave, San Antonio, TX, 78296 | 0.64 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+2 more |
| PRV-20563 | PRV | Harvey Y Teresa | 1995-07-24 | UHC-30222-34 | — | 4064 Palm Dr, Mesa, AZ | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-21037 | PRV | Bradley L Burke | 1938-12-02 | — | 7307930540 | 2646 Main St, Tucson, AZ, 85768 | 0.64 | Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+2 more |
| PRV-26053 | PRV | Vasquez Pamela | 1965-10-16 | — | 8414621454 | 7641 Palm Dr, Houston, TX, 77027 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21440 | PRV | Kelly J Wight | 1988-08-05 | UHC-66125-58 | 3649000823 | 4952 Mesa Dr, San Antonio, TX | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-23518 | PRV | Carlos Alvarez | 1977-10-26 | — | 7704001467 | 4812 River Rd, Dallas, TX, 75238 | 0.64 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25211 | PRV | James Mejia | 1976-04-10 | — | 5676864892 | 1966 Palm Dr, Columbus, OH, 43262 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-29487 | PRV | Lucia Castillo | 1989-12-02 | — | — | 413 Ocean Ave, Miami, FL, 33108 | 0.64 | Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-26035 | PRV | Melissa Ramos | 2002-06-10 | — | 8763769108 | 7751 Bayshore Dr, Chandler, AZ, 85233 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-24420 | PRV | Danielle Ramirez | 1966-02-11 | UHC-72750-13 | — | 8031 Spring St, Miami, FL, 33107 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-23580 | PRV | Sharon Thomas | 1942-09-22 | UHC-96128-13 | — | 3073 Lincoln Way, San Antonio, TX, 78243 | 0.64 | Name re-casedDate of birth reformattedPhone missing area codeZIP+4 trimmed+2 more |
| PRV-29156 | PRV | Marcus Valdez | 1964-02-25 | UHC-98477-89 | 2883200427 | 7713 Ridge Rd, Scottsdale, AZ | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-26068 | PRV | Amy Lynch | 2007-07-28 | — | 7839207817 | 6954 Highland Ave, Chandler, AZ, 85273 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26397 | PRV | Aaron Soto | 1985-01-05 | UHC-84486-65 | 3543586621 | 505 Washington St, Fresno, CA, 93711 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-25275 | PRV | Patricia Phillips | 1964-04-13 | UHC-42386-79 | 5219611092 | 6649 Hillcrest Rd, Plano, TX, 75021 | 0.64 | Phone reformattedZIP+4 trimmedEmail lower-casedGender normalised+2 more |
| PRV-24825 | PRV | Nicholas Alexander | 1989-04-25 | UHC-55928-14 | 7916354300 | 6192 Canyon Rd, Mesa, AZ, 85282 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23757 | PRV | Heather Pierce | 1975-03-11 | — | 8969681540 | 1540 Maple Ave Apt 11, San Antonio, TX, 78253 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-20435 | PRV | Amber Yang | 1959-09-10 | — | 3556570858 | 1998 Jefferson Ave, Glendale, AZ | 0.64 | Date of birth reformattedPhone reformattedState name converted to codeZIP missing+2 more |
| PRV-26345 | PRV | Brittany Snyder | 1940-04-21 | — | 9547843216 | 1147 Forest Ave, Las Vegas, NV | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25570 | PRV | Ronald Long | 1972-07-10 | — | — | 3301 Oak St, Charlotte, NC, 28270 | 0.64 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| PRV-20288 | PRV | Gloria H Dunn | 1982-05-22 | — | 5967125464 | 938 Elm St, Atlanta, GA, 30329 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20204 | PRV | Brandon Jackson | 1938-03-22 | — | — | 9363 Bayshore Dr, Atlanta, GA, 30335 | 0.64 | Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23103 | PRV | Lawrence Bishop | 1986-08-04 | UHC-76858-34 | 4372496513 | 9670 Camelback Rd, Gilbert, AZ | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-28804 | PRV | Don Freeman | 1947-02-17 | — | 6004342609 | 1080 Palm Dr, Tucson, AZ, 85769 | 0.64 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29440 | PRV | Andrea Y Evans | 2002-01-12 | — | 9764107105 | 6496 Spring St, Sacramento, CA, 95847 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-26341 | PRV | Roger J Patterson | 1985-04-25 | UHC-93623-42 | 5027358264 | 6366 Washington St # 330, Atlanta, GA, 30326 | 0.64 | Phone reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more |
| PRV-21735 | PRV | Steven Y Ortega | 1941-03-27 | UHC-06063-03 | 2828626106 | 1456 Jefferson Ave, Tempe, AZ, 85239 | 0.64 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| PRV-27216 | PRV | Stephanie Harris | 1943-12-15 | UHC-40495-92 | 6903715635 | 3844 Spring St, Eden Prairie, MN, 55306 | 0.64 | Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+2 more |
| PRV-29486 | PRV | Lucia J Castillo | 1989-12-02 | UHC-03398-73 | — | 413 Ocean Ave, Miami, FL, 33108 | 0.64 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| PRV-27211 | PRV | Bruce Cruz | 1981-12-23 | UHC-98583-63 | 7274964163 | 5953 Elm St, Los Angeles, CA | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-27874 | PRV | Rebecca D Meendoza | 2006-03-10 | — | — | 9585 Baseline Rd # 463, Houston, TX, 77094 | 0.64 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-27266 | PRV | Grace Owens | 1972-01-25 | UHC-29617-42 | 8243192196 | 685 Apache Blvd Apt 12, Dallas, TX, 75211 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-24381 | PRV | Douglas Carpenter | 1945-07-21 | — | 4924136877 | 3423 Jefferson Ave, Tampa, FL, 33648 | 0.64 | Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+2 more |
| PRV-23688 | PRV | Frances Elliott | 1958-02-18 | UHC-93061-35 | 9118649287 | 2493 Maple Ave, Chandler, AZ, 85243 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20434 | PRV | Bryan Cruz | 1941-08-23 | — | 5412833470 | 2664 Park Pl Apt 16, Eden Prairie, MN, 55330 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-25031 | PRV | Joe Powell | 1960-07-20 | UHC-80342-40 | — | 5587 Harbor Blvd, Tampa, FL, 33642 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-23924 | PRV | Brian I Myers | 1996-02-11 | — | 2775774358 | 9050 Mesa Dr, Tempe, AZ, 85221 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22542 | PRV | Mei Hicks | 1988-06-05 | — | 2482948291 | 8342 Lake View Rd, Chandler, AZ, 85284 | 0.64 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24138 | PRV | Walter Medina | 2008-11-16 | UHC-70862-60 | 7669759855 | 974 Canyon Rd, Tempe, AZ, 85223 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-26569 | PRV | Gabriel H Bradley | 1946-03-05 | — | 4684386833 | 1795 Church St Apt 24, Fresno, CA | 0.64 | Name re-casedDate of birth reformattedUnit split from streetZIP missing+2 more |
| PRV-26197 | PRV | Justin G Griffin | 1966-09-20 | UHC-52595-90 | 4024591325 | 5035 Mesa Dr, Jacksonville, FL, 32285 | 0.64 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| PRV-23224 | PRV | Juan Gilbert | 2007-03-14 | UHC-46118-29 | — | 354 Baseline Rd, Jacksonville, FL, 32286 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-25689 | PRV | Jonathan U Le | 1978-08-09 | — | 8089783259 | 8427 Valley View Dr, Phoenix, AZ, 85016 | 0.64 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-25660 | PRV | Walter Gilbert | 1963-05-27 | — | 4285885393 | 2595 Maple Ave Apt 4, Chandler, AZ | 0.64 | Name re-casedDate of birth reformattedUnit split from streetZIP missing+2 more |
| PRV-20114 | PRV | Robert C Hoffman | 1980-04-20 | UHC-41946-58 | 9377788548 | 8892 Spring St Apt 21, Dallas, TX, 75231 | 0.64 | Middle initial moved out of first namePhone reformattedMember ID reformattedUnit split from street+2 more |
| PRV-25641 | PRV | Danielle Wheeler | 1997-09-09 | UHC-34384-77 | 6762114890 | 3755 Church St, Houston, TX, 77002 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-20655 | PRV | Russell Wood | 1958-08-17 | UHC-18978-12 | 6504591886 | 667 Lake View Rd, Phoenix, AZ, 85043 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |