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-429283 | CLM | Brittany J Richardson | 1952-12-02 | UHC-80551-30 | — | 4734 Baseline Rd, Plano, TX, 75079 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| CLM-405003 | CLM | Carl Richards | 1941-08-04 | — | 4354378572 | 9485 Hillcrest Rd, Phoenix, AZ, 85087 | 0.64 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| CLM-422718 | CLM | Bobby Simpson | 1980-03-27 | UHC-39775-45 | 6924850062 | 4772 Highland Ave # 481, Tempe, AZ, 85220 | 0.64 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| CLM-408978 | CLM | Debra Bailey | 1956-10-06 | UHC-28481-12 | 6614439082 | 817 Indian School Rd, Tampa, FL | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-401670 | CLM | Ahmed Hart | 1960-03-01 | UHC-53428-16 | — | 4445 Jefferson Ave, Los Angeles, CA | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| CLM-416907 | CLM | Bobby Gutierrez | 1954-09-11 | UHC-90316-10 | — | 4638 Broadway, Gilbert, AZ, 85238 | 0.64 | Name re-casedTwo-digit birth yearCity re-casedState name converted to code+2 more |
| CLM-429009 | CLM | Andrea Powell | 1943-09-24 | — | — | 5969 Sage Ct, Houston, TX | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| CLM-402021 | CLM | Diana Thomas | 1990-11-12 | UHC-72609-55 | 7242769111 | 785 Indian School Rd, Tucson, AZ, 85741 | 0.64 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-401356 | CLM | Jesse Kelly | 1979-05-10 | UHC-15221-74 | 6164854387 | 419 Lake View Rd # 575, San Antonio, TX, 78283 | 0.64 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| CLM-402275 | CLM | Nicole Torres | 1982-01-12 | — | — | 6945 Market St, San Diego, CA, 92103 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| CLM-431832 | CLM | Bruce S Johnson | 1979-07-16 | UHC-57855-96 | 3314492617 | 1021 Meadow Ln # 391, Plano, TX, 75019 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| CLM-402652 | CLM | Rice Brandon | 1986-03-14 | UHC-75050-61 | 5098666317 | 9531 Mountain View Dr, Fresno, CA, 93773 | 0.64 | Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more |
| CLM-425078 | CLM | Joseph Day | 1968-04-14 | UHC-62916-46 | 5583799198 | 8532 Palm Dr, Los Angeles, CA, 90076 | 0.64 | Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+2 more |
| CLM-420077 | CLM | Keith Bailey | 1986-02-12 | UHC-91055-84 | — | 1902 Park Pl, Seattle, WA, 98191 | 0.64 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| CLM-402061 | CLM | Barb R Jacobs | 1984-08-03 | UHC-84370-28 | 5343695383 | 2168 Harbor Blvd, Scottsdale, AZ | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| CLM-418057 | CLM | Nunez Brittany | 2006-06-06 | — | — | 2966 Cedar Ln, Seattle, WA, 98195 | 0.64 | Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+2 more |
| CLM-418475 | CLM | Ana A Ward | 1990-10-10 | — | 6384259388 | 5438 Church St, San Antonio, TX, 78216 | 0.64 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-415103 | CLM | Oliver Ralph | 1995-03-26 | UHC-98397-43 | — | 1949 Spring St, Los Angeles, CA, 90061 | 0.64 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more |
| CLM-427921 | CLM | Walter Duncan | 1939-05-28 | UHC-68920-96 | 7473988264 | 4410 Apache Blvd, Chandler, AZ, 85233 | 0.64 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| CLM-422915 | CLM | Maria D Reynolds | 1984-04-07 | UHC-36945-54 | 5475445772 | 6424 Lake View Rd, Tempe, AZ, 85240 | 0.64 | Name split from “Last, First”Phone reformattedCity re-casedGender normalised+2 more |
| CLM-403458 | CLM | Samuel Le | 1989-05-21 | — | 7368141823 | 8848 Cedar Ln, Columbus, OH, 43229 | 0.64 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| CLM-409159 | CLM | Evelyn Austin | 1953-04-15 | UHC-82037-47 | 6654045053 | 6261 Church St, Gilbert, AZ, 85299 | 0.64 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-400503 | CLM | Bobby J Arnold | 1993-03-03 | UHC-10974-02 | 4313031794 | 8996 River Rd, Fresno, CA, 93790 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| CLM-422285 | CLM | Mari Q Cunningham | 1959-10-20 | — | 8988085832 | 7075 Pine Dr, Los Angeles, CA, 90008 | 0.64 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-418999 | CLM | Cynthia Mitchell | 1944-10-20 | UHC-17308-74 | — | 6540 Meadow Ln # 412, Charlotte, NC, 28219 | 0.64 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| CLM-413257 | CLM | James Owens | 1980-03-02 | UHC-46110-34 | — | 6467 Camelback Rd, Plano, TX, 75086 | 0.64 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-414143 | CLM | Dennis Contreras | 1998-08-27 | UHC-23357-72 | — | 1344 Mountain View Dr, Orlando, FL, 32830 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| CLM-404009 | CLM | Virginia B Singh | 1957-04-27 | UHC-78289-57 | 7104572779 | 1609 Valley View Dr, Charlotte, NC, 28268 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-404072 | CLM | Sandra Fuller | 1983-09-17 | UHC-21692-45 | — | 2866 Bayshore Dr, Los Angeles, CA, 90064 | 0.64 | Street suffix standardisedAddress re-casedState name converted to codePlan code upper-cased+2 more |
| CLM-425645 | CLM | Roy Brooks | 2006-11-27 | — | 9293353650 | 6646 Sunset Blvd # 534, Orlando, FL, 32879 | 0.64 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| CLM-408057 | CLM | Gabbriel F Burns | 1949-04-05 | UHC-23008-39 | 9409419965 | 5336 Apache Blvd, Jacksonville, FL, 32297 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-422203 | CLM | Carol I Campbell | 1951-02-13 | UHC-26225-85 | 4195754578 | 6013 Baseline Rd, Gilbert, AZ, 85294 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-425066 | CLM | Danielle Henry | 1950-11-16 | — | — | 863 Ocean Ave, Tempe, AZ | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| CLM-418252 | CLM | Sharon K Mendoaz | 1971-11-23 | UHC-45600-90 | 7394275559 | 8627 Willow Ct # 322, Jacksonville, FL, 32294 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| CLM-420843 | CLM | Kyle Silva | 1968-07-18 | UHC-98556-49 | 8197027654 | 4890 Bayshore Dr Apt 25, Phoenix, AZ, 85019 | 0.64 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| CLM-426276 | CLM | Christopher Robinson | 1990-04-22 | — | — | 2661 Valley View Dr, Los Angeles, CA, 90006 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| CLM-400048 | CLM | Doris F Garza | 1957-12-18 | — | — | 5194 Desert Sky Blvd, Los Angeles, CA, 90000 | 0.64 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more |
| CLM-422439 | CLM | Emma Silva | 1977-06-11 | — | — | 6272 Church St Apt 4, Plano, TX, 75038 | 0.64 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| CLM-424191 | CLM | Timothy Alexander | 1961-08-04 | UHC-78547-89 | — | 4556 Desert Sky Blvd, Fresno, CA, 93724 | 0.64 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-430104 | CLM | Carol Warren | 1952-07-21 | — | — | 7040 Hillcrest Rd, Gilbert, AZ, 85266 | 0.64 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| CLM-403395 | CLM | Ahmed Y Ferguson | 1965-04-04 | — | — | 7654 Valley View Dr, Charlotte, NC, 28282 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| CLM-424421 | CLM | Dorothy Harvey | 2002-08-24 | UHC-41546-10 | 3136040690 | 4150 Apache Blvd, Glendale, AZ, 85322 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| CLM-417354 | CLM | Eric Bailey | 1988-04-01 | UHC-24801-64 | — | 2012 Mountain View Dr, Atlanta, GA, 30315 | 0.64 | Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| CLM-408128 | CLM | Christian Romero | 1957-02-08 | — | — | 3506 Ridge Rd, Dallas, TX, 75215 | 0.64 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| CLM-416504 | CLM | Joan Price | 1950-03-25 | UHC-71246-26 | 2766218860 | 390 Park Pl, Columbus, OH, 43262 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-410768 | CLM | Ahmed Soto | 1938-03-10 | UHC-22956-92 | — | 8663 Lake View Rd, Tucson, AZ, 85743 | 0.64 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more |
| CLM-432827 | CLM | Zachary Mendez | 2003-01-26 | UHC-28618-02 | 8337141304 | 8894 Lake View Rd, Atlanta, GA, 30373 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| CLM-411642 | CLM | Hiroshi Hamilton | 1978-05-02 | — | — | 2346 Harbor Blvd Apt 3, Atlanta, GA, 30368 | 0.64 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| CLM-423010 | CLM | Carolyn Long | 1977-07-03 | UHC-14882-88 | 9728219166 | 9864 Desert Sky Blvd, San Diego, CA, 92188 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| CLM-407553 | CLM | Josh Turner | 2005-08-27 | UHC-57288-86 | — | 7345 Cedar Ln # 264, Eden Prairie, MN, 55377 | 0.64 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |