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-432241 | CLM | Priiya Wiliams | 1972-03-23 | — | 3822537248 | 6515 Willow Ct, Charlotte, NC, 28247 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-401248 | CLM | Kevin Gray | 1944-07-03 | UHC-41944-42 | — | 2932 Church St, Dallas, TX, 75282 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-414685 | CLM | Alice Gutierrez | 2008-02-02 | — | 9764512274 | 8084 Baseline Rd # 744, Tampa, FL, 33626 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| CLM-400113 | CLM | Joseph Richardson | 1962-04-11 | — | 2944170525 | 766 Indian School Rd, Glendale, AZ | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| CLM-407661 | CLM | Dylan Guerrero | 1944-04-17 | UHC-70949-33 | — | 9202 Spring St, Las Vegas, NV, 89119 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-428411 | CLM | Lauren Phillips | 1966-01-01 | UHC-19206-41 | 3512567156 | 8819 Sunset Blvd, Seattle, WA, 98177 | 0.62 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-401380 | CLM | Jose Olson | 2003-05-28 | UHC-32021-76 | — | 5299 Elm St, Jacksonville, FL, 32210 | 0.62 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more |
| CLM-428124 | CLM | Megan Z Marquez | 1990-06-14 | UHC-86538-02 | 7964673988 | 4790 Washington St, Mesa, AZ, 85238 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-420475 | CLM | Bruce Nelson | 1993-03-13 | UHC-72135-31 | 2429460806 | 9238 Oak St, Nashville, TN, 37297 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more |
| CLM-429657 | CLM | Nancy Watkins | — | — | — | 2027 Mesa Dr, Mesa, AZ, 85204 | 0.62 | Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+3 more |
| CLM-411703 | CLM | Kayla Vargas | 1987-08-09 | UHC-09167-84 | 6776316839 | 9824 Elm St, Scottsdale, AZ | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-432329 | CLM | Carlos R Walker | 1987-12-15 | UHC-39806-08 | 5453381271 | 9720 Ocean Ave, Scottsdale, AZ, 85221 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| CLM-407606 | CLM | Richard Q Washington | 2006-06-16 | UHC-88336-76 | 5408400677 | 8427 Camelback Rd, Glendale, AZ, 85357 | 0.62 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-432622 | CLM | Jacqueline X Rogers | 1972-07-03 | UHC-40625-48 | 9178587586 | 8721 Ridge Rd, Scottsdale, AZ, 85297 | 0.62 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-429664 | CLM | Shirley Q Rojas | 1966-01-02 | — | — | 4695 Indian School Rd, Fresno, CA, 93760 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| CLM-405551 | CLM | Ryan K Bailey | 1966-12-17 | UHC-26020-38 | 7466743797 | 7468 Indian School Rd, Minneapolis, MN, 55493 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| CLM-411097 | CLM | Roger T Robertson | 1977-02-25 | — | 7985157830 | 7470 Baseline Rd, Chandler, AZ, 85260 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-425717 | CLM | Teresa Fisher | 1959-04-26 | — | — | 5150 Main St, Scottsdale, AZ, 85299 | 0.62 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| CLM-409947 | CLM | Mason McDonald | 2003-08-20 | UHC-59502-09 | — | 2210 Cedar Ln, Atlanta, GA, 30379 | 0.62 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more |
| CLM-426077 | CLM | Lauren Peters | 1984-07-16 | UHC-23575-28 | — | 1420 Oak St, Glendale, AZ, 85392 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| CLM-400956 | CLM | Camila Santos | 1951-11-20 | UHC-31286-37 | 6823136559 | 4386 Lake View Rd Apt 25, Seattle, WA, 98115 | 0.62 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more |
| CLM-418287 | CLM | Natalie Stewart | 1967-01-15 | — | 8013968414 | 4853 Jefferson Ave Apt 4, Mesa, AZ, 85231 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| CLM-422473 | CLM | Sean Gardner | 1964-07-20 | UHC-33476-72 | 7313075480 | 9447 Lake View Rd, Seattle, WA | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedCity re-cased+3 more |
| CLM-418767 | CLM | Sean Reynolds | 1989-10-25 | UHC-33152-78 | 5782881671 | 7232 Broadway, Charlotte, NC, 28298 | 0.62 | Name re-casedPhone reformattedAddress re-casedState name converted to code+3 more |
| CLM-414293 | CLM | Camila I Ortiz | 2008-06-21 | — | 3833706828 | 8674 Cedar Ln, Houston, TX, 77047 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| CLM-428484 | CLM | Carol C King | 1986-01-28 | — | 2513178594 | 854 Lake View Rd, Jacksonville, FL | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-429274 | CLM | Howard Joyce | 1969-01-06 | — | 7123839741 | 9252 Lake View Rd, Houston, TX, 77044 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-414863 | CLM | Gloria D Ramirez | 2008-09-21 | — | 6735669244 | 6554 Highland Ave, Seattle, WA, 98133 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-431310 | CLM | Dana L Ramos | 1986-05-16 | UHC-53674-02 | 4282570259 | 3376 Sunset Blvd, Los Angeles, CA, 90058 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-404549 | CLM | Teresa Washington | 1954-06-04 | — | 2638790736 | 7191 Church St, San Antonio, TX, 78279 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| CLM-414269 | CLM | Betty Pena | 1953-10-03 | UHC-15755-28 | 5886663083 | 8194 Maple Ave Apt 5, Nashville, TN, 37272 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| CLM-407234 | CLM | Sean Bowman | 1957-05-18 | UHC-27509-22 | — | 4985 Canyon Rd, Austin, TX, 78724 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-404327 | CLM | Ana R Banks | 1968-01-12 | UHC-34703-52 | — | 5264 Elm St, Minneapolis, MN, 55474 | 0.62 | Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more |
| CLM-402327 | CLM | Pamela Vzaquez | 1976-04-22 | UHC-24088-91 | 2657718014 | 2062 Park Pl, Fresno, CA, 93758 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-430605 | CLM | Patrricia Dunn | 1939-09-19 | — | — | 9685 Camelback Rd, Miami, FL, 33169 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-404103 | CLM | Chris Park | 1989-05-03 | UHC-85719-74 | 8203435933 | 2104 Market St, Scottsdale, AZ | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-415501 | CLM | Ryan Mendez | 1950-05-28 | UHC-79204-52 | — | 2824 Valley View Dr, Jacksonville, FL, 32252 | 0.62 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| CLM-420385 | CLM | Beverly Payne | 2004-06-27 | — | 2772214739 | 5544 Mountain View Dr, Sacramento, CA, 95808 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-402200 | CLM | Rebecca Sandoval | 1971-06-04 | UHC-77395-37 | 3009172124 | 7321 Pine Dr, Eden Prairie, MN, 55362 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-410107 | CLM | Sara F Padilla | 1982-02-02 | — | 5183584426 | 7342 Spring St, Glendale, AZ, 85369 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| CLM-428696 | CLM | Joyce Hanson | 1963-01-25 | UHC-16292-82 | — | 7610 Mountain View Dr, Plano, TX, 75019 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-411630 | CLM | Larry Morrison | 1999-12-14 | UHC-07583-42 | 4582223819 | 8003 Canyon Rd, Sacramento, CA, 95871 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-409131 | CLM | Stephen Miller | 1998-05-04 | UHC-10946-99 | 5813978980 | 8460 Baseline Rd, Jacksonville, FL, 32210 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more |
| CLM-402347 | CLM | Alexander Munoz | 1998-07-01 | UHC-78751-46 | — | 626 Maple Ave # 308, Austin, TX, 78742 | 0.62 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more |
| CLM-412529 | CLM | Jason Gutierrez | 1971-06-19 | UHC-26533-02 | — | 4563 Mesa Dr, Glendale, AZ, 85302 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-421168 | CLM | Priya T Ortega | 1998-10-25 | UHC-14105-31 | 4057265347 | 2401 Park Pl, Charlotte, NC, 28297 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-424256 | CLM | Kimberly Jimenez | 1952-12-05 | UHC-97816-87 | — | 9412 Ocean Ave, Denver, CO, 80249 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| CLM-417217 | CLM | Kate T Murphy | 2001-09-02 | — | 3446262127 | 5536 Main St, Miami, FL, 33178 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-420189 | CLM | Wei Gomez | 2005-03-13 | UHC-05045-78 | — | 3593 Ocean Ave, Austin, TX | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-430849 | CLM | Hannah Butler | 1987-06-26 | UHC-70941-53 | 8963884504 | 5044 Union St, San Antonio, TX, 78212 | 0.62 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |