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, flag “State name converted to code”, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| ENR-132631 | ENR | Jesse Spencer | 1948-11-07 | — | 8872955665 | 3187 Meadow Ln, Tampa, FL, 33697 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-120185 | ENR | Teresa G Grdon | 1991-07-14 | UHC-38136-28 | 9567337385 | 1022 Camelback Rd, Eden Prairie, MN, 55372 | 0.82 | Name re-casedState name converted to codeEmail lower-cased |
| CLM-410313 | CLM | Donna Hoffman | 1998-08-07 | — | — | 5099 Canyon Rd, Columbus, OH, 43264 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-427080 | CLM | Sofia U Andrews | 1996-02-17 | UHC-65628-97 | 6905613448 | 377 Spring St, Charlotte, NC, 28218 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| CLM-410579 | CLM | Jack Henderson | 1954-06-16 | UHC-16606-32 | — | 5249 Union St, Fresno, CA, 93775 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| CLM-406481 | CLM | Zachary Q Vega | 1949-05-07 | — | — | 9888 Park Pl, Sacramento, CA, 95847 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-134986 | ENR | Judith Larson | 1952-10-27 | UHC-46251-99 | 6836498806 | 6318 Sunset Blvd, Columbus, OH, 43237 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-427544 | CLM | Marilyn Y George | 1956-07-01 | — | — | 4851 Desert Sky Blvd, Jacksonville, FL, 32249 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| CLM-413058 | CLM | Danielle Thompson | 1993-05-12 | — | — | 5664 Ridge Rd, Columbus, OH, 43221 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-414011 | CLM | Gloria Sanchez | 1977-08-26 | UHC-28712-93 | — | 3874 Church St, Columbus, OH, 43288 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| CLM-400533 | CLM | Jacob Carlson | 1998-05-03 | UHC-93191-37 | — | 9129 Apache Blvd, Minneapolis, MN, 55469 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-118477 | ENR | Olivia H Rivera | 1952-07-01 | UHC-39208-52 | 7867219172 | 2918 Park Pl, Minneapolis, MN, 55499 | 0.82 | Name re-casedMember ID reformattedState name converted to code |
| CLM-418752 | CLM | Josh Frnklin | 1955-05-26 | — | — | 1169 Park Pl, Tucson, AZ, 85786 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-124955 | ENR | Shirley Adams | 1958-03-11 | UHC-87919-53 | 9054980219 | 2419 Sunset Blvd, Tampa, FL, 33625 | 0.82 | Date of birth reformattedState name converted to codeWhitespace trimmed |
| ENR-102079 | ENR | Douglas Shaw | 2007-05-05 | UHC-29466-62 | 6554638466 | 2059 Valley View Dr, Charlotte, NC, 28285 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| ENR-113664 | ENR | Philip Wood | 1946-02-19 | UHC-74863-07 | 8772941398 | 3849 Highland Ave, Mesa, AZ, 85209 | 0.82 | Name re-casedDate of birth reformattedState name converted to code |
| ENR-136520 | ENR | Bradley N Hernandez | 1998-05-27 | UHC-70759-17 | 8603992759 | 2161 Washington St, Sacramento, CA, 95872 | 0.82 | Date of birth reformattedState name converted to codeWhitespace trimmed |
| TPA-54677 | TPA | Amanda Foster | 1974-01-09 | — | — | 395 Washington St, San Diego, CA, 92199 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| CLM-420805 | CLM | John Fernandez | 1959-03-01 | UHC-23284-11 | 6678472896 | 5731 Sage Ct, Houston, TX, 77046 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| ENR-117967 | ENR | Stephanie D Wells | 1947-10-16 | UHC-42795-81 | 3312038908 | 7631 Central Ave, Scottsdale, AZ, 85275 | 0.82 | Date of birth reformattedPhone reformattedState name converted to code |
| TPA-57192 | TPA | Gary K Mills | 1986-01-19 | UHC-36526-63 | 7785450619 | 1766 Church St, Denver, CO, 80293 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| TPA-59836 | TPA | Abigail Soto | 1953-03-27 | — | 6174447910 | 3268 Lake View Rd, Mesa, AZ, 85252 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| TPA-61385 | TPA | Bradley Cox | 1951-01-18 | UHC-86083-56 | — | 4643 Harbor Blvd, Dallas, TX, 75247 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| CLM-402195 | CLM | Sue Morris | 1958-03-10 | UHC-02849-78 | — | 6814 Baseline Rd, Jacksonville, FL, 32291 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| CLM-416449 | CLM | Ruth Peterson | 1959-09-25 | — | — | 2019 River Rd, Denver, CO, 80270 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-128070 | ENR | Katherine Lucas | 1946-05-19 | UHC-42065-62 | 2249149800 | 1463 Cedar Ln, Gilbert, AZ, 85254 | 0.82 | Phone reformattedState name converted to codeEmail lower-cased |
| ENR-138549 | ENR | Joyce S Walsh | 2005-05-05 | UHC-32807-99 | 8707354629 | 3039 Ocean Ave, Tampa, FL, 33641 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-421659 | CLM | Kathleen Lynch | 1979-09-21 | UHC-39030-53 | 2289098244 | 7652 Sage Ct, Austin, TX, 78794 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-420040 | CLM | Kayla Cole | 1978-01-06 | UHC-96523-84 | — | 1075 Sunset Blvd, San Antonio, TX, 78248 | 0.82 | Member ID reformattedState name converted to codePlaceholder values cleared |
| CLM-408877 | CLM | Stepanie Woods | 1995-10-19 | UHC-93610-29 | — | 129 Broadway, Miami, FL, 33163 | 0.82 | Address re-casedState name converted to codePlaceholder values cleared |
| CLM-428686 | CLM | Cynthia V Fuller | 1974-01-03 | UHC-17057-28 | 2178250135 | 2479 Park Pl, Charlotte, NC, 28299 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-109036 | ENR | Jean Perry | 1962-12-27 | UHC-02151-49 | 4108109877 | 821 Jefferson Ave, Mesa, AZ, 85284 | 0.82 | Date of birth reformattedMember ID reformattedState name converted to code |
| CLM-409003 | CLM | Eugene R Larson | 1981-12-17 | UHC-44889-49 | 2722871552 | 7615 Palm Dr, Glendale, AZ, 85331 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| CLM-428469 | CLM | Joan Allen | 1967-12-22 | UHC-42345-40 | — | 7075 Harbor Blvd, Orlando, FL, 32822 | 0.82 | Date of birth reformattedState name converted to codePlaceholder values cleared |
| CLM-409792 | CLM | Jacqueline Z Webb | 1940-04-10 | — | 2482686027 | 9796 Washington St, Columbus, OH, 43259 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| TPA-51070 | TPA | Douglas Morgan | 1974-01-02 | — | 7783900003 | 4328 Grand Ave, Chandler, AZ, 85207 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| TPA-57061 | TPA | Henry W Kennedy | 1990-11-13 | — | — | 9131 Oak St, Fresno, CA, 93700 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-429193 | CLM | David Mson | 1997-04-19 | UHC-37883-73 | — | 8973 Cedar Ln, Seattle, WA, 98181 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-133274 | ENR | Cheryl Ford | 1970-03-09 | UHC-38625-91 | 8433829712 | 8157 Indian School Rd, Chandler, AZ, 85295 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| PRV-26840 | PRV | Paul T Murphy | 1961-07-18 | — | 7627601954 | 4643 Main St, Tucson, AZ, 85747 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| CLM-406738 | CLM | Barb Hanson | 1966-06-11 | — | — | 6526 Apache Blvd, Dallas, TX, 75243 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| ENR-141330 | ENR | Rebecca Q Jones | 1967-05-27 | UHC-46908-53 | 7535833803 | 7642 Lincoln Way, Seattle, WA, 98182 | 0.82 | Date of birth reformattedState name converted to codeEmail lower-cased |
| ENR-127063 | ENR | Kimberly Austin | 1952-01-03 | UHC-95368-25 | 3856254891 | 4699 Main St, Seattle, WA, 98170 | 0.82 | Name re-casedState name converted to codeWhitespace trimmed |
| PRV-26162 | PRV | Kenneth Gonzales | 1994-09-09 | UHC-22366-98 | — | 2617 Cedar Ln, Chandler, AZ, 85216 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| CLM-403281 | CLM | Fatima Black | 1952-10-15 | UHC-56500-90 | 2853816591 | 8227 Washington St, Los Angeles, CA, 90081 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| ENR-131844 | ENR | Anna Fernandez | 1975-05-14 | UHC-68550-23 | 3569430460 | 5104 Ridge Rd, Tucson, AZ, 85769 | 0.82 | Name re-casedPhone reformattedState name converted to code |
| CLM-417375 | CLM | Sean J Allen | 1945-02-02 | UHC-01959-63 | — | 9540 Lake View Rd, Denver, CO, 80293 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| ENR-129449 | ENR | Sean Gardner | 1964-07-20 | UHC-33476-72 | — | 9447 Lake View Rd, Seattle, WA, 98112 | 0.82 | State name converted to codeEmail lower-casedPlaceholder values cleared |
| ENR-107382 | ENR | Stephen T Simpson | 1947-01-08 | UHC-56439-22 | 9137058604 | 1477 Park Pl, Glendale, AZ, 85338 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| ENR-139551 | ENR | Barbara Rodriguez | 1943-10-05 | UHC-75032-93 | 4535201603 | 1117 Ridge Rd, Phoenix, AZ, 85068 | 0.82 | Name re-casedState name converted to codeWhitespace trimmed |