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
All sources, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| PRV-24037 | PRV | Mason Rios | 1950-09-14 | UHC-34110-11 | 2208220528 | 8770 Washington St Apt 16, Glendale, AZ, 85340 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more |
| PRV-23659 | PRV | Brenda Henry | 2004-01-05 | — | 6998126106 | 2034 Cedar Ln Apt 18, Chandler, AZ | 0.44 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more |
| ENR-113563 | ENR | Bruce C Morris | 1986-01-18 | UHC-33350-17 | 7646439587 | 6865 Mesa Dr, Gilbert, AZ, 85258 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-103074 | ENR | Frank Santiago | 1946-02-25 | UHC-15366-30 | 2686214170 | 4144 Desert Sky Blvd, Tampa, FL, 33686 | 0.44 | Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+6 more |
| ENR-121051 | ENR | Bily Ortiz | 2006-10-20 | UHC-78085-15 | 7948078515 | 3156 Bayshore Dr, Eden Prairie, MN, 55357 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| PRV-29575 | PRV | Maria Fields | 1944-03-23 | — | 4249872474 | 7659 Hillcrest Rd, Minneapolis, MN, 55489 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| PRV-23726 | PRV | Megan Wilson | 1956-03-14 | UHC-27377-95 | 6733016707 | 9499 Market St, Denver, CO, 80247 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| CLM-402488 | CLM | Susan Bell | 1980-04-10 | UHC-59959-19 | 2658995802 | 6313 Jefferson Ave, Los Angeles, CA, 90023 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more |
| ENR-113072 | ENR | Kathleen O Williamson | 1964-11-04 | UHC-41645-14 | 9418056680 | 7680 Indian School Rd, Charlotte, NC, 28244 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-103718 | ENR | Diego Valdez | 1962-04-06 | UHC-00431-81 | — | 315 Palm Dr, Tucson, AZ | 0.44 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-111554 | ENR | Timothy P Weber | 2001-09-27 | UHC-91272-09 | — | 3400 Park Pl, Scottsdale, AZ | 0.44 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+6 more |
| ENR-105768 | ENR | Jeremy Chapman | 1985-12-26 | UHC-44520-76 | 3586643307 | 5814 Forest Ave, Miami, FL, 33159 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| CLM-425779 | CLM | Mark Long | 1976-08-26 | UHC-50062-61 | 3155420342 | 365 Camelback Rd # 468, Seattle, WA, 98171 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more |
| PRV-21018 | PRV | Larry L Mills | 1998-01-13 | — | 5265578622 | 155 Harbor Blvd # 679, Gilbert, AZ, 85209 | 0.44 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedUnit split from street+6 more |
| CLM-420844 | CLM | Jacob Jensen | 1942-01-19 | UHC-74692-41 | 4237326649 | 5608 Meadow Ln, Denver, CO | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-100457 | ENR | Jackie T Johnston | 1999-08-07 | UHC-56323-70 | 9353383997 | 568 Jefferson Ave, Plano, TX | 0.44 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+6 more |
| ENR-119488 | ENR | Isabella U Burton | 1980-11-25 | UHC-09055-50 | 7938588103 | 3009 Apache Blvd # 188, Tempe, AZ, 85238 | 0.44 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+6 more |
| PRV-25231 | PRV | Carlos S McCoy | 1981-10-23 | — | 2367526035 | 4191 Grand Ave, Plano, TX, 75061 | 0.44 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-116127 | ENR | Juie Sullivan | 1979-09-27 | UHC-95420-85 | — | 5655 Union St, Las Vegas, NV | 0.44 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+6 more |
| ENR-129338 | ENR | Bruce I Dean | 1983-05-07 | UHC-92761-61 | 4503754132 | 1899 Oak St, Houston, TX, 77033 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-115545 | ENR | Ethan Kennedy | — | UHC-94235-35 | 3559499214 | 2663 Hillcrest Rd # 756, Mesa, AZ, 85297 | 0.44 | Name re-casedDate of birth missingPhone reformattedMember ID reformatted+6 more |
| PRV-27018 | PRV | Benjamin Cox | 1983-03-07 | UHC-68145-78 | 4019548847 | 2173 Main St, San Antonio, TX, 78230 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| CLM-406009 | CLM | Gerald Richardson | 1957-04-11 | UHC-52791-35 | 2998825660 | 1747 Sage Ct # 324, Gilbert, AZ, 85254 | 0.44 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+6 more |
| CLM-412268 | CLM | David W Hansen | 2004-02-20 | UHC-62023-76 | 8323597913 | 8251 Apache Blvd, Jacksonville, FL, 32255 | 0.44 | Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+6 more |
| ENR-100688 | ENR | Martha B Parker | — | UHC-19603-97 | 6026444202 | 9366 Maple Ave Apt 24, Eden Prairie, MN, 55321 | 0.44 | Name re-casedDate of birth unreadablePhone reformattedUnit split from street+6 more |
| TPA-50089 | TPA | Mike Dunn | 2006-08-16 | — | 5549773334 | 7975 Church St, Glendale, AZ, 85329 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-106044 | ENR | Randy Murray | 2001-09-26 | UHC-92433-34 | 9045989786 | 1777 Central Ave, Miami, FL, 33117 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| CLM-423639 | CLM | Eugene Morales | 1976-03-11 | UHC-18419-70 | 5559934176 | 7390 Bayshore Dr Apt 30, Austin, TX, 78766 | 0.44 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+6 more |
| CLM-413217 | CLM | Mark F Maldonado | 1990-06-11 | UHC-07588-91 | 5335139184 | 925 Central Ave, Eden Prairie, MN, 55325 | 0.44 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+6 more |
| ENR-120316 | ENR | Cynthia Alvarez | 1953-07-13 | UHC-21356-89 | 8032261633 | 1555 Lake View Rd, Scottsdale, AZ | 0.44 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-120279 | ENR | Scott Guzman | 1989-02-04 | UHC-03230-14 | 3716428266 | 2262 Cedar Ln, Tampa, FL | 0.44 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more |
| CLM-415276 | CLM | Camila Brown | 1951-11-17 | UHC-87174-49 | 6099803556 | 3113 Forest Ave, Orlando, FL, 32832 | 0.44 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+6 more |
| ENR-128740 | ENR | VincentJunk | 1990-12-24 | UHC-51856-42 | 9089137181 | 8425 Jefferson Ave, Nashville, TN, 37245 | 0.44 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more |
| ENR-117815 | ENR | Sophia Hill | 1975-08-12 | UHC-72031-89 | 2908416465 | 4128 Spring St # 237, Denver, CO, 80218 | 0.44 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+6 more |
| ENR-105153 | ENR | Timothy H Rivera | 1946-03-08 | UHC-26841-12 | 9212725890 | 5323 Canyon Rd, Scottsdale, AZ, 85236 | 0.44 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more |
| ENR-129154 | ENR | Joseph M Daniiels | 1995-07-13 | UHC-26322-25 | 8167990088 | 9477 Bayshore Dr, Phoenix, AZ | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-124415 | ENR | Ashley E Thompson | 1999-11-22 | UHC-62776-77 | 4078435113 | 8765 Central Ave, Eden Prairie, MN, 55320 | 0.44 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+6 more |
| ENR-135864 | ENR | Emily C Dominguez | 1985-10-01 | UHC-30743-93 | 5233103106 | 4578 Pine Dr, Jacksonville, FL, 32253 | 0.44 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more |
| PRV-21725 | PRV | Noah Pena | 1977-02-21 | — | 7034408565 | 9475 Canyon Rd, Fresno, CA | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-115925 | ENR | Patricia B Kim | 1998-05-23 | UHC-30627-19 | 5126885251 | 3503 Elm St # 816, Columbus, OH, 43251 | 0.44 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more |
| CLM-432054 | CLM | Amy H Gilbert | 1973-11-04 | UHC-06665-71 | 5653631605 | 4705 Mountain View Dr Apt 18, San Antonio, TX, 78229 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more |
| CLM-400712 | CLM | Stephen Murphy | 1955-10-14 | UHC-00291-43 | 6837202601 | 9309 Ridge Rd, Nashville, TN | 0.44 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+6 more |
| ENR-107898 | ENR | Ray U Ruiz | 1949-08-14 | UHC-95302-67 | 2634070107 | 4347 Camelback Rd Apt 28, Tempe, AZ, 85245 | 0.44 | Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+6 more |
| PRV-22077 | PRV | Austin Henderson | 1993-03-13 | UHC-20641-02 | 4688129841 | 4944 Indian School Rd Apt 2, San Diego, CA, 92114 | 0.44 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+6 more |
| ENR-135689 | ENR | Maria G Stone | 1953-02-23 | UHC-66345-90 | 6979797447 | 3800 Sage Ct # 456, Sacramento, CA, 95814 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more |
| TPA-62493 | TPA | Cheryl Yang | 2003-02-03 | — | 7472906448 | 3370 Bayshore Dr Apt 21, Jacksonville, FL, 32235 | 0.44 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+6 more |
| PRV-27343 | PRV | Kelly Burton | 1980-10-12 | UHC-06398-61 | 7674587524 | 9072 Park Pl, Dallas, TX, 75217 | 0.44 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more |
| CLM-417084 | CLM | Russell Matthews | 1964-12-28 | UHC-68793-97 | — | 8711 Union St Apt 5, San Antonio, TX, 78245 | 0.44 | Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+6 more |
| CLM-413656 | CLM | Amy Sandoval | 1978-01-28 | UHC-15452-48 | 4882054874 | 7809 Sunset Blvd, Charlotte, NC | 0.44 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+6 more |
| PRV-21329 | PRV | Rebecca Munoz | 1958-09-21 | — | 3485736847 | 8264 Hillcrest Rd # 969, Charlotte, NC, 28260 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more |