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
Claims, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| CLM-422831 | CLM | Timothy U Carpenter | 1970-04-07 | — | 4365542674 | 8987 Hillcrest Rd, Mesa, AZ, 85217 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-412541 | CLM | Debra Powell | 1945-02-07 | UHC-90874-75 | — | 4358 Forest Ave, Tampa, FL, 33622 | 0.74 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-429720 | CLM | Chuck Reid | 1991-01-01 | UHC-05817-62 | 8094845272 | 4894 Highland Ave, Tucson, AZ, 85761 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-425303 | CLM | Dot Wgner | 1939-09-12 | UHC-46359-62 | 5153165960 | 9333 Sage Ct, Scottsdale, AZ, 85293 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-423360 | CLM | Makr Riley | 1951-04-23 | UHC-38683-19 | 5008850807 | 4150 Ridge Rd, Nashville, TN, 37225 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-401297 | CLM | Harold McCoy | 1956-04-13 | UHC-66918-98 | 9745926761 | 7067 Central Ave, Orlando, FL, 32827 | 0.74 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-429183 | CLM | Jennifer Williamson | 1973-12-03 | — | 6977925414 | 1510 Forest Ave, Seattle, WA, 98147 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-419863 | CLM | Samuel Marquez | 1995-12-04 | UHC-23159-56 | 2459718161 | 927 Church St, Phoenix, AZ, 85093 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| CLM-424583 | CLM | Dylan Burke | 1977-10-22 | UHC-49908-79 | — | 4906 Mountain View Dr, Las Vegas, NV, 89179 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-417524 | CLM | Jeremy Young | 1981-06-24 | — | 9063797467 | 4942 Main St, Las Vegas, NV, 89132 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-404147 | CLM | Zachary Luna | 1949-03-04 | UHC-56365-90 | 4993825921 | 8165 Harbor Blvd, Glendale, AZ, 85350 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-410699 | CLM | Brandon Armstrong | 1959-11-13 | UHC-84467-90 | — | 2641 Apache Blvd, Denver, CO, 80281 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-414879 | CLM | Alvarado Jacqueline | 1946-02-10 | UHC-56970-49 | — | 9838 Lake View Rd, San Diego, CA, 92157 | 0.74 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-423187 | CLM | Jennifer U Weaver | 1966-01-21 | UHC-23136-26 | 5179445337 | — | 0.74 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more |
| CLM-421854 | CLM | Eric Watson | 2005-01-05 | — | 6615613429 | 6608 Elm St, Fresno, CA, 93767 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-409213 | CLM | Nick Patterson | 1974-12-05 | — | 9733221182 | 9852 Washington St, Tempe, AZ, 85259 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-405563 | CLM | Shirley Burke | 1999-05-25 | UHC-99524-15 | 7857771577 | 4375 Washington St, San Diego, CA, 92123 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-412037 | CLM | Julie J Wilson | 1990-10-20 | UHC-76381-41 | — | 6638 Park Pl, Tempe, AZ, 85247 | 0.74 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| CLM-413177 | CLM | Judith Lucas | 1968-03-18 | UHC-90519-50 | 4814061967 | 3242 Maple Ave, Fresno, CA, 93791 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| CLM-415284 | CLM | Justin Perkins | 1960-04-24 | — | 4476065628 | 4260 Market St, Fresno, CA, 93714 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-422798 | CLM | Shirley R Hunter | 1958-03-17 | — | — | 4214 Spring St, San Diego, CA, 92173 | 0.74 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| CLM-406522 | CLM | Alan Montgomery | 1979-04-12 | UHC-39258-97 | 7069753185 | 8755 Jefferson Ave, Columbus, OH, 43287 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| CLM-430516 | CLM | Sara Hicks | 2001-12-23 | UHC-24394-15 | 4745795639 | 2890 Mountain View Dr, Sacramento, CA, 95867 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| CLM-406989 | CLM | Donna B Padilla | 1951-10-28 | UHC-36891-63 | 7322627317 | 6322 Bayshore Dr, Sacramento, CA, 95875 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-417595 | CLM | Raymond Reyes | 1971-11-14 | UHC-12708-34 | — | 5870 Lincoln Way, Denver, CO, 80290 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-419356 | CLM | Wei Fuller | 1965-05-22 | — | 4237503755 | 1677 Washington St, Scottsdale, AZ, 85231 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-421526 | CLM | Helen Reid | 2005-11-28 | UHC-88997-72 | 7597401091 | 463 Cedar Ln, Mesa, AZ, 85254 | 0.74 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| CLM-422073 | CLM | Sharon Vega | 1970-01-16 | UHC-51699-03 | 6665859164 | 6900 Baseline Rd, San Diego, CA, 92104 | 0.74 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-403789 | CLM | Samuel Ramirez | 1986-05-28 | UHC-35438-68 | 5425687978 | 895 Church St, Glendale, AZ, 85376 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-428508 | CLM | Frank C Lawrence | 1945-09-08 | — | 8726626050 | 6136 Harbor Blvd, Fresno, CA, 93724 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-407200 | CLM | Wei Gonzales | 1950-07-11 | UHC-13014-37 | 7722097302 | 2897 Grand Ave, Las Vegas, NV, 89180 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-407562 | CLM | Melissa Valdez | 1954-02-10 | UHC-81960-04 | 6816351928 | 962 Valley View Dr, Dallas, TX, 75228 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| CLM-425097 | CLM | Valentina White | 1946-10-18 | UHC-42715-20 | 5989153520 | 5207 Jefferson Ave, Gilbert, AZ, 85222 | 0.74 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-430932 | CLM | Mateeo Harvey | 1969-12-25 | UHC-78172-12 | — | 8811 Mountain View Dr, Las Vegas, NV, 89180 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-413384 | CLM | Aaorn Larson | 1963-12-24 | UHC-22371-27 | 8713711158 | 6922 Grand Ave, Glendale, AZ, 85321 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-405609 | CLM | Heather Black | 1983-01-18 | UHC-29594-73 | 6555486532 | 3321 Washington St, Los Angeles, CA, 90040 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-426079 | CLM | Vincent Butler | 1958-03-24 | UHC-67979-89 | 7492831037 | 966 Bayshore Dr, Miami, FL, 33177 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-402662 | CLM | Christine L Henry | 1952-04-26 | UHC-14353-96 | 9073872354 | 217 Elm St, Charlotte, NC, 28262 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-405987 | CLM | Deborah Vasquez | 1956-12-13 | — | 3792788435 | 6123 Highland Ave, San Diego, CA, 92150 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| CLM-418636 | CLM | Ahmed Chen | 1939-08-07 | UHC-08584-98 | — | 3083 Church St, San Diego, CA, 92150 | 0.74 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| CLM-409745 | CLM | Aisha Mason | 2002-10-17 | UHC-99034-92 | — | 7936 Willow Ct, Seattle, WA, 98128 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-425735 | CLM | Sharon Stevens | 1948-08-04 | UHC-69450-62 | 6828459845 | 5794 Jefferson Ave, Los Angeles, CA, 90084 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-428361 | CLM | Bradley Warren | 2005-07-23 | — | 5883727120 | 93 Valley View Dr, Atlanta, GA, 30385 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-426489 | CLM | Tommy E Syms | 1971-03-19 | UHC-88422-90 | 9817131418 | 4750 Grand Ave, Orlando, FL, 32898 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-430373 | CLM | Joe Welch | 1968-07-21 | UHC-35283-22 | — | 2893 Harbor Blvd, Atlanta, GA, 30331 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-422428 | CLM | Doris N Ford | 1978-03-15 | — | 4094082386 | 616 Lincoln Way, Eden Prairie, MN, 55303 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-402143 | CLM | Kenneth Pierce | 1955-08-04 | UHC-21426-20 | 5406534124 | 5052 Mountain View Dr, Tempe, AZ, 85251 | 0.74 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-428518 | CLM | Long Crolyn | 1953-09-13 | UHC-35911-04 | 7446688772 | 5275 Harbor Blvd, Tempe, AZ, 85274 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-407531 | CLM | Roger White | 1948-08-05 | UHC-38078-45 | — | 1413 Meadow Ln, Miami, FL, 33135 | 0.74 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-407530 | CLM | Roger White | 1948-08-05 | UHC-38078-45 | — | 1413 Meadow Ln, Miami, FL, 33135 | 0.74 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |