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-426081 | CLM | Mason Smith | 1961-02-15 | UHC-13514-35 | 2662525669 | 3073 Jefferson Ave, Tempe, AZ, 85289 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-128292 | ENR | Hnery Chen | — | UHC-33237-14 | 3595577703 | 7603 Sunset Blvd, Dallas, TX, 75297 | 0.46 | Name re-casedDate of birth missingPhone reformattedMember ID reformatted+5 more |
| ENR-127559 | ENR | Kathleen UJunk | 1981-08-17 | UHC-96127-46 | 4137038990 | 3451 Sunset Blvd, Orlando, FL, 32860 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-119121 | ENR | Natalie Sims | — | UHC-65915-99 | 6168001734 | 3877 Main St, Las Vegas, NV, 89162 | 0.46 | Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| CLM-424924 | CLM | Doris T Ford | 1958-02-28 | UHC-97244-05 | — | 1242 Lake View Rd # 450, Scottsdale, AZ, 85224 | 0.46 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more |
| ENR-136623 | ENR | Valentina Payne | 1974-01-26 | UHC-22618-46 | 8846579959 | 4929 Church St, Jacksonville, FL, 32288 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-110806 | ENR | Jonathan Sanndoval | 1962-03-06 | UHC-01777-85 | 8107213077 | 2173 Mesa Dr Apt 33, Nashville, TN, 37299 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| CLM-414448 | CLM | Emily Wels | 1971-03-28 | — | 8798240310 | 2695 Mountain View Dr, San Diego, CA, 92155 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-105477 | ENR | Elijah M Delgado | 1982-04-20 | UHC-99236-88 | 2645003478 | 4532 Canyon Rd, Sacramento, CA | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |
| ENR-122462 | ENR | Evelyn P Colmean | 1987-02-14 | UHC-14941-93 | 2359681318 | 1338 Ridge Rd, Gilbert, AZ, 85253 | 0.46 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-104456 | ENR | Aisha N Cole | 1975-04-01 | UHC-86878-50 | 4593416989 | 4922 Cedar Ln, Minneapolis, MN | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| ENR-125435 | ENR | Mary B Cook | 1976-10-13 | UHC-16807-52 | 2643791110 | 7214 Palm Dr Apt 36, Nashville, TN, 37249 | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-105318 | ENR | Bryan Li | 1943-02-22 | UHC-16862-67 | 8793330394 | 5152 Central Ave, Glendale, AZ, 85386 | 0.46 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-105781 | ENR | Gerald Powell | 1948-10-22 | UHC-96423-73 | 2937337385 | 730 Camelback Rd, San Antonio, TX | 0.46 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-25087 | PRV | —Junk | 2005-01-27 | — | 8838963783 | 8651 Highland Ave, Nashville, TN, 37279 | 0.46 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| ENR-128863 | ENR | Walter Q Porter | 1954-07-21 | UHC-68877-75 | 4745678988 | 8571 Lincoln Way, Tempe, AZ, 85253 | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-128862 | ENR | Walter Q Porter | 1954-07-21 | UHC-68877-75 | 4745678988 | 8571 Lincoln Way, Tempe, AZ, 85253 | 0.46 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |
| CLM-403067 | CLM | Alexis Garza | 1972-01-15 | — | 6564150199 | 7046 Pine Dr, Eden Prairie, MN | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-124231 | ENR | Sharon V Greene | 1982-12-09 | UHC-72907-79 | 4024881705 | 6821 Grand Ave # 981, Miami, FL, 33132 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more |
| ENR-112473 | ENR | Ruth U Larsun | 1960-08-11 | UHC-12479-78 | 5659225745 | 1086 Forest Ave, Denver, CO, 80224 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| CLM-415239 | CLM | Aisha Owens | 2002-06-26 | UHC-84488-96 | 2317075318 | 7806 Main St, Orlando, FL, 32868 | 0.46 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-427674 | CLM | Grace Wong | 2000-12-03 | UHC-13056-47 | — | 3571 Spring St, Sacramento, CA | 0.46 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+5 more |
| ENR-127157 | ENR | Schmidt Sarah | 1965-01-28 | UHC-67055-10 | 4608207029 | 8051 Willow Ct # 958, San Diego, CA, 92166 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| CLM-430178 | CLM | Ethan EJunk | 1961-03-01 | UHC-07381-68 | 7583811982 | 8361 Indian School Rd, Nashville, TN, 37248 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| CLM-410288 | CLM | Andrew McDonald | — | UHC-38489-91 | 4374342555 | 7493 Sunset Blvd, Chandler, AZ, 85282 | 0.46 | Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+5 more |
| ENR-134370 | ENR | Burce G Moore | 1964-11-19 | UHC-28109-74 | 3156653892 | 1620 Willow Ct, Mesa, AZ, 85236 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more |
| CLM-400369 | CLM | Grace Burton | 1981-01-26 | UHC-52024-75 | 2889449993 | 8064 Maple Ave, Columbus, OH | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-117844 | ENR | Gerald H Silva | 1976-09-23 | UHC-54444-80 | 2935575873 | 3638 Valley View Dr, San Antonio, TX, 78284 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-405921 | CLM | Steven Ortaga | 1941-03-27 | — | 2828626106 | 1456 Jefferson Ave, Tempe, AZ, 85239 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| CLM-407554 | CLM | Jack I Ray | 1943-10-02 | UHC-32122-35 | 8863400298 | 4554 Meadow Ln, Phoenix, AZ | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-141739 | ENR | Lucia I Robertson | 1985-09-01 | UHC-90498-98 | 5993145405 | 4263 Cedar Ln, Tempe, AZ, 85289 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| CLM-416331 | CLM | Ellis Gerald | 1985-06-11 | — | 4103588512 | 589 Mountain View Dr # 525, Tempe, AZ, 85252 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| PRV-24558 | PRV | Aisha Q Hendeerson | 1986-02-18 | UHC-27793-06 | — | 563 Spring St, San Antonio, TX, 78287 | 0.46 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-122826 | ENR | Kelly T Day | 1983-01-19 | UHC-30774-01 | 9776229722 | 8106 Forest Ave, Gilbert, AZ, 85277 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more |
| CLM-417154 | CLM | RachelJunk | 1959-08-26 | UHC-31823-84 | — | 7580 Maple Ave, Eden Prairie, MN, 55354 | 0.46 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+5 more |
| ENR-102312 | ENR | Mariana Shaw | 1991-10-19 | UHC-03384-46 | 5577106620 | 1773 Park Pl Apt 29, Nashville, TN | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| CLM-424978 | CLM | Denise Anderson | 1987-05-16 | — | 2936129893 | 3970 Market St # 834, Las Vegas, NV, 89189 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-140594 | ENR | Singh Katherine | 1989-10-16 | UHC-36821-73 | 7246348022 | 9696 Mountain View Dr, Denver, CO, 80209 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| PRV-28677 | PRV | Austin O Gordon | 1964-09-27 | UHC-50210-62 | 3875910563 | 9313 Highland Ave # 505, Jacksonville, FL, 32240 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-123200 | ENR | Rachel F Maldonado | — | UHC-71621-23 | 5604859058 | 9202 Main St, Austin, TX, 78720 | 0.46 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more |
| CLM-402098 | CLM | Brittany Taylor | 1982-05-25 | UHC-75127-09 | 6858117945 | 6710 Valley View Dr, Mesa, AZ, 85299 | 0.46 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| CLM-420193 | CLM | Wei Miller | 1949-03-27 | UHC-77831-87 | 6977770510 | 3062 Camelback Rd, Phoenix, AZ | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-139679 | ENR | Mariana K Mitchell | 1972-03-12 | UHC-47406-20 | 7717381941 | 762 Sage Ct, Tempe, AZ | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-108623 | ENR | Justin G Cooper | 1991-11-18 | UHC-26825-50 | 2288619677 | 7406 Spring St, Miami, FL, 33143 | 0.46 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-116972 | ENR | Greg Washington | 1972-09-15 | UHC-30230-14 | 4474142347 | 9052 Forest Ave, San Diego, CA, 92177 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-117257 | ENR | Dlan Hunter | 1970-12-16 | UHC-44105-80 | 9209200762 | 4137 Sunset Blvd, Fresno, CA | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| CLM-420533 | CLM | Mertha Q Salazar | 1982-06-10 | UHC-04503-85 | 6134008412 | 8402 Pine Dr, Plano, TX, 75041 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| CLM-417786 | CLM | Walter Chavez | 1994-05-07 | — | 3416809590 | 7980 Maple Ave, Austin, TX, 78761 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-135601 | ENR | Marilyn R Sullivan | 1952-05-20 | UHC-59465-80 | 2748519508 | 5246 Desert Sky Blvd, Miami, FL, 33143 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more |
| CLM-426200 | CLM | Cheryl Padilla | 1978-04-06 | UHC-20056-04 | 6446686372 | 9498 Forest Ave, Tempe, AZ, 85260 | 0.46 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more |