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 |
|---|---|---|---|---|---|---|---|---|
| CLM-409099 | CLM | Luis Greene | 2000-06-15 | UHC-14290-02 | — | 5329 Lincoln Way Apt 17, Atlanta, GA, 30372 | 0.46 | Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+5 more |
| ENR-120123 | ENR | Amy F Baker | 1967-05-15 | UHC-44725-60 | 6939921271 | 4115 Palm Dr, Chandler, AZ, 85223 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| PRV-23494 | PRV | Evelyn Gardner | 1992-09-28 | UHC-73149-18 | 9326350746 | 3445 Mountain View Dr Apt 14, Mesa, AZ, 85250 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-131866 | ENR | Richard N Chapman | 1999-11-01 | UHC-28200-70 | 8314581341 | 5513 Desert Sky Blvd, Plano, TX, 75012 | 0.46 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-123941 | ENR | Grace P Kim | 1952-04-02 | UHC-89018-09 | 4764590477 | 2766 Sage Ct, Denver, CO | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |
| CLM-423595 | CLM | Christine Hoffman | 2003-05-09 | UHC-38010-16 | — | 5855 Spring St, Phoenix, AZ, 85022 | 0.46 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-417775 | CLM | Patricia K Phillips | 1964-04-13 | UHC-42386-79 | — | 6649 Hillcrest Rd, Plano, TX, 75021 | 0.46 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-108228 | ENR | Shirley V Watson | 1942-01-18 | UHC-42611-87 | — | 5102 Main St, Austin, TX, 78707 | 0.46 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| ENR-138119 | ENR | Natalie Kim | 1997-01-07 | UHC-69045-49 | 4997363276 | 9655 Cedar Ln # 327, Phoenix, AZ, 85081 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| PRV-27875 | PRV | Rebecca D Mendoza | 2006-03-10 | UHC-41468-60 | 8696390034 | 9585 Baseline Rd, Houston, TX, 77094 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| TPA-60163 | TPA | Raymond Turner | 1999-09-09 | — | 9878746251 | 321 Grand Ave # 314, Denver, CO, 80208 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| PRV-23741 | PRV | Chapman Heather | 1981-12-02 | — | 6795081731 | 7036 Park Pl, Minneapolis, MN | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| TPA-59541 | TPA | Mateo Silva | 2008-01-02 | — | — | 4577 Camelback Rd Apt 22, Columbus, OH, 43210 | 0.46 | Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+5 more |
| CLM-406672 | CLM | Nicole V Burke | 1985-04-14 | UHC-61538-74 | 9049854277 | 7663 River Rd, Orlando, FL | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-111914 | ENR | Christine D Barnes | 2006-01-22 | UHC-70917-32 | 5322633861 | 5821 Washington St, Columbus, OH, 43290 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-21599 | PRV | Denise Dunn | 1954-05-11 | UHC-66614-26 | 3797197048 | 5263 Sunset Blvd # 365, Tempe, AZ | 0.46 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-134226 | ENR | Victoria Rogers | 2008-05-10 | UHC-57091-14 | 7343817018 | 1444 Indian School Rd, Plano, TX, 75029 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-110925 | ENR | Helen Spencer | 1939-09-05 | UHC-12971-42 | 3945372124 | 3371 Meadow Ln Apt 40, Orlando, FL, 32807 | 0.46 | Name re-casedPhone reformattedSSN last four extractedUnit split from street+5 more |
| TPA-57435 | TPA | Beverly Bannett | 1948-08-14 | UHC-99014-61 | — | 4158 Indian School Rd, Denver, CO, 80291 | 0.46 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-25658 | PRV | Aisha Stone | 1984-07-07 | UHC-36349-47 | 7474481889 | 905 Main St, Houston, TX | 0.46 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| PRV-20936 | PRV | Gary Palmer | 1948-08-24 | — | 7318882464 | 4655 Meadow Ln, Los Angeles, CA, 90091 | 0.46 | Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| CLM-417459 | CLM | Isabella Gutierrez | 1951-12-15 | UHC-20838-77 | — | 4325 Elm St, Fresno, CA, 93790 | 0.46 | Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-118764 | ENR | Jeremy J Ortega | 2002-08-07 | UHC-18231-87 | 3009812935 | 4675 Indian School Rd, Charlotte, NC, 28278 | 0.46 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-415286 | CLM | Edwards Janice | 1951-03-03 | UHC-49570-05 | 2073584379 | 207 Park Pl, Dallas, TX, 75239 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| CLM-432482 | CLM | Luis Jonees | 1948-05-16 | UHC-28777-79 | 9778047251 | 2298 Sage Ct, Phoenix, AZ, 85096 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-139950 | ENR | Brandon M Hamilton | 1965-04-13 | UHC-11844-80 | 6679283938 | 8869 Mountain View Dr, Tucson, AZ | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-27501 | PRV | Obrien M Laura | 2000-08-16 | — | 4486001681 | 3657 Desert Sky Blvd Apt 36, Los Angeles, CA, 90029 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more |
| ENR-119744 | ENR | Laura Watkins | 1961-02-15 | UHC-86062-54 | 2947284413 | 2762 Willow Ct Apt 17, Mesa, AZ, 85231 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-113079 | ENR | Katherine B Larson | 1972-09-17 | UHC-24304-50 | 4912407045 | 4444 Main St, Los Angeles, CA | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| PRV-20657 | PRV | Stephen Mason | 1949-01-20 | — | 7267442355 | 5037 Ocean Ave, Columbus, OH, 43224 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-123016 | ENR | Melissa Hart | 1959-12-19 | — | 5719269051 | 1003 Apache Blvd, San Diego, CA, 92175 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| PRV-27711 | PRV | Kelly Carlson | — | — | 5609476747 | 4379 Palm Dr Apt 19, Jacksonville, FL, 32281 | 0.46 | Name re-casedDate of birth unreadablePhone reformattedUnit split from street+5 more |
| PRV-21370 | PRV | Jesse Hernandez | 1989-02-19 | — | 7966025148 | 2786 Spring St, Fresno, CA | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-419689 | CLM | Ryan Wong | 1941-03-06 | UHC-57924-23 | 4772707195 | 6303 River Rd, Atlanta, GA, 30337 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-124183 | ENR | Santiago Z Dominguez | 1963-04-09 | UHC-05052-57 | 5992637780 | 9297 Forest Ave, Dallas, TX, 75214 | 0.46 | Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+5 more |
| ENR-113586 | ENR | Julia S Nguyen | 1969-11-02 | UHC-27419-79 | 4658031478 | 5776 Meadow Ln Apt 20, Charlotte, NC, 28293 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| PRV-29234 | PRV | Ruth F Mejia | 1994-02-05 | UHC-04349-37 | 5244507176 | 4936 Ocean Ave, Seattle, WA, 98130 | 0.46 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| CLM-418300 | CLM | Gloria Dean | 2002-02-17 | UHC-59777-51 | 5185532839 | 3807 Meadow Ln, Plano, TX | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-100026 | ENR | Nancy O Campbell | 1991-05-20 | UHC-10392-04 | 7332381159 | 3517 Baseline Rd # 391, Jacksonville, FL, 32266 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| CLM-432551 | CLM | Robert Ramos | 1946-11-20 | UHC-34491-97 | — | 5876 Indian School Rd, San Antonio, TX, 78239 | 0.46 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-102206 | ENR | Arthur N Mason | 1975-07-11 | UHC-95789-74 | 3373974367 | 5652 Jefferson Ave # 776, San Antonio, TX, 78266 | 0.46 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-110807 | ENR | Kathleen Wganer | 1990-12-17 | UHC-97845-16 | 7716306860 | 9711 Spring St # 709, Tampa, FL, 33653 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-129468 | ENR | Tyler M Mason | — | UHC-65746-05 | 7276199688 | 4287 Union St, San Diego, CA, 92134 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth missingPhone reformatted+5 more |
| ENR-127727 | ENR | Katherine V Wagner | 1962-05-06 | UHC-22531-13 | 7622018414 | 1301 Ocean Ave, Columbus, OH, 43273 | 0.46 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-136373 | ENR | Doris X James | 1957-05-03 | — | 5085601226 | 1527 Elm St, Plano, TX, 75087 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| PRV-27059 | PRV | George B Gilbert | 1990-12-21 | UHC-16075-96 | 8126049356 | 5038 Ocean Ave, Seattle, WA, 98165 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more |
| PRV-26326 | PRV | Carol Mason | 1947-06-16 | UHC-05630-68 | 4158604155 | 1548 Grand Ave Apt 38, Los Angeles, CA | 0.46 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more |
| ENR-134771 | ENR | Alan Smith | 2004-11-04 | UHC-62253-64 | 9226668786 | 8017 Highland Ave, Glendale, AZ, 85346 | 0.46 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+5 more |
| ENR-137757 | ENR | Ann Santiago | 1990-01-07 | UHC-72018-89 | 4313414103 | 4669 Main St, Glendale, AZ, 85338 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-122059 | ENR | Frank Weber | 1956-03-02 | UHC-60254-75 | 8028170414 | 3595 Valley View Dr, Glendale, AZ, 85311 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |