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-410840 | CLM | Amy Martin | 1950-07-24 | — | 2844651645 | 5564 Apache Blvd Apt 34, Mesa, AZ, 85212 | 0.60 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| CLM-417666 | CLM | Frank James | 1954-05-28 | — | — | 1373 Highland Ave, Miami, FL, 33150 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-408530 | CLM | Judith Dean | 1998-06-17 | UHC-47353-96 | 9897444303 | 7492 Market St, Mesa, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-404623 | CLM | Teresa Mendez | 1987-06-26 | UHC-99599-84 | 8074200818 | 4688 Willow Ct # 540, Chandler, AZ, 85258 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| CLM-427717 | CLM | Daviid D Griffin | 1958-07-13 | — | 5072899222 | 9704 Forest Ave, Scottsdale, AZ, 85264 | 0.60 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-407620 | CLM | Mateo Rivera | 1958-11-09 | UHC-49017-44 | 8138082222 | 3705 Spring St, Atlanta, GA, 30307 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-428215 | CLM | Rebecca Hamilton | 1954-02-23 | UHC-26416-03 | 2155193615 | 2665 Indian School Rd # 301, Plano, TX, 75019 | 0.60 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more |
| CLM-422980 | CLM | Anna Vega | 1983-09-27 | UHC-59908-76 | 5402561334 | 7331 Forest Ave, Nashville, TN, 37231 | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-410960 | CLM | Ynag Valentina | 1943-08-22 | — | 8609219601 | 2679 Sunset Blvd, Seattle, WA, 98131 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| CLM-402957 | CLM | Gabriel McDonald | 1947-11-21 | UHC-21533-16 | 8713805476 | 8474 Desert Sky Blvd, Plano, TX, 75012 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-415811 | CLM | Joshua Simmons | 1974-12-28 | UHC-19558-30 | 5789115047 | 1213 Main St, Seattle, WA | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-424321 | CLM | Ralph T Santiago | 1964-01-11 | UHC-93505-50 | 2875128451 | 2638 Bayshore Dr, Dallas, TX, 75240 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-424515 | CLM | Santiago Silva | 1955-12-21 | UHC-65994-67 | 3365939744 | 2852 Valley View Dr, Tampa, FL, 33615 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-419870 | CLM | Sofia Kelley | 1956-01-22 | UHC-11034-93 | 4126428121 | 7324 Sage Ct, Tampa, FL | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-401929 | CLM | Jean Contreras | 1943-05-24 | UHC-66804-04 | 6796195090 | 6390 Pine Dr # 896, Orlando, FL, 32822 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| CLM-430022 | CLM | Mason Santiago | 1989-12-06 | UHC-44962-59 | 6545214348 | 3907 Sage Ct # 696, Denver, CO, 80231 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| CLM-409892 | CLM | Shirley Jimenez | 2002-02-10 | UHC-16328-46 | 4272179330 | 2890 Ocean Ave, Minneapolis, MN, 55473 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-417933 | CLM | Larry Rogers | 1970-02-10 | UHC-32272-09 | 4189493983 | 7957 Highland Ave, Eden Prairie, MN, 55349 | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-421824 | CLM | Jeffrey Green | 1958-05-12 | UHC-73338-83 | — | 6830 Church St, Columbus, OH, 43229 | 0.60 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more |
| CLM-401776 | CLM | Tyler M Taylor | 2000-06-06 | UHC-19451-27 | 8315781085 | 9668 Hillcrest Rd, Charlotte, NC, 28271 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-415832 | CLM | Judy Wells | 1994-01-06 | UHC-36200-43 | 8396910901 | 331 Grand Ave, Seattle, WA, 98107 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-410515 | CLM | Kayla Bailey | 1981-10-10 | UHC-99784-06 | 6419740117 | 9032 Sunset Blvd, Tempe, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-415221 | CLM | Nathan L Cole | — | — | 3365112392 | 2027 Sage Ct, Denver, CO, 80288 | 0.60 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more |
| CLM-421128 | CLM | Frances Ruiz | 1949-05-28 | UHC-20383-93 | 4406663884 | 4560 Cedar Ln, Mesa, AZ, 85215 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-408779 | CLM | Bryan S Smith | 2003-10-02 | UHC-11693-40 | — | 8664 Ridge Rd, Nashville, TN, 37207 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-419302 | CLM | Adam Wheeler | 1950-10-17 | — | 7826026135 | 3569 Jefferson Ave, Houston, TX, 77056 | 0.60 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-420826 | CLM | George Foster | 1972-01-04 | — | 6028437312 | 1130 Mesa Dr Apt 10, Orlando, FL, 32826 | 0.60 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| CLM-426971 | CLM | Timothy Flores | 1980-11-12 | UHC-44991-41 | — | 9101 Baseline Rd, San Antonio, TX, 78260 | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-424944 | CLM | Kayla Simmons | 2003-07-15 | UHC-11502-95 | — | 6651 Jefferson Ave, Tampa, FL, 33686 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-424501 | CLM | Nicholas Burns | 1982-06-07 | UHC-59582-06 | — | 2447 Grand Ave, Eden Prairie, MN, 55368 | 0.60 | Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more |
| CLM-426497 | CLM | Paul Marshall | 1962-10-12 | UHC-10623-89 | 5663160388 | 980 Central Ave, Atlanta, GA, 30388 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more |
| CLM-401431 | CLM | Sophia Pierce | 1973-09-23 | UHC-04501-42 | 4766693777 | 6744 Desert Sky Blvd, Glendale, AZ, 85382 | 0.60 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| CLM-420950 | CLM | Hioshi Montgomery | 1976-04-17 | — | — | 1778 Ridge Rd, Miami, FL, 33123 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-420772 | CLM | Elijah R Gutierrez | — | UHC-69658-63 | 2325738974 | 8582 Washington St, San Antonio, TX, 78262 | 0.60 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more |
| CLM-429553 | CLM | Anna Harvey | 1968-10-09 | UHC-53608-54 | 7775745458 | 3429 Forest Ave, Chandler, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-429554 | CLM | Anna Harvey | 1968-10-09 | UHC-53608-54 | 7775745458 | 3429 Forest Ave, Chandler, AZ | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-417257 | CLM | Carl Robinson | 1991-05-20 | — | 5364521979 | 1417 Bayshore Dr, Los Angeles, CA, 90056 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-419421 | CLM | Sharon Sanchez | 1996-03-09 | — | — | 6949 Canyon Rd, Tempe, AZ, 85271 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-427317 | CLM | Larry Lee | 2005-12-19 | UHC-32257-04 | — | 3908 Canyon Rd, Nashville, TN | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-431733 | CLM | Henry Lopez | 1968-10-24 | UHC-84906-58 | 2183561751 | 1854 Central Ave, Minneapolis, MN, 55471 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-404092 | CLM | Jeremy Richards | 1990-07-11 | — | 5412552374 | 9885 Union St, Atlanta, GA, 30394 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-407081 | CLM | Andrew R Fisher | 1976-09-27 | — | — | 6348 Bayshore Dr, Tampa, FL, 33622 | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-408213 | CLM | Billy Olson | 1974-06-21 | UHC-87272-66 | 7064463924 | 2435 Main St, San Diego, CA, 92126 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-417541 | CLM | Susan Perkins | 1992-07-11 | UHC-70290-70 | 6397383695 | 1937 Central Ave, Tempe, AZ, 85289 | 0.60 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-402019 | CLM | Janice T Adams | 1960-10-20 | UHC-49605-18 | 2598933633 | 6917 Forest Ave, Gilbert, AZ, 85242 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-405984 | CLM | Brian V Perkins | 1971-11-22 | UHC-98944-17 | 8145373716 | 2848 Sage Ct, Seattle, WA, 98188 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-417804 | CLM | Saan F Wright | 2002-05-23 | UHC-54869-17 | 2489493230 | 34 Bayshore Dr, Austin, TX, 78753 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more |
| CLM-413014 | CLM | Roger Holmes | 1978-08-03 | UHC-75657-14 | 4724286696 | 289 Grand Ave, Los Angeles, CA, 90087 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-426991 | CLM | Martha Jenkins | 1987-01-15 | — | 2944769082 | 8650 Apache Blvd, Sacramento, CA | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-426873 | CLM | Joseph Berry | 1999-08-25 | — | — | 3868 Main St, Atlanta, GA, 30372 | 0.60 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |