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-426156 | CLM | Russell Schultz | 1964-07-04 | UHC-11427-28 | — | 1372 Forest Ave, Plano, TX, 75033 | 0.74 | Name re-casedDate of birth reformattedMember ID reformattedCity re-cased+3 more |
| CLM-402296 | CLM | Esspinoza P Amber | 1948-01-22 | UHC-65231-24 | — | 9369 Valley View Dr, Columbus, OH, 43256 | 0.74 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-414581 | CLM | Denise Roberts | 1972-02-15 | UHC-19669-31 | 8075736788 | 5846 Indian School Rd, Houston, TX, 77037 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-417462 | CLM | Danielle Gomez | 1962-01-04 | UHC-89338-09 | 4966169025 | 9496 Cedar Ln, Jacksonville, FL, 32223 | 0.74 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| CLM-404957 | CLM | Katherine R Austin | 1964-01-09 | — | 6152244394 | 8602 Main St, Jacksonville, FL, 32240 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-416658 | CLM | Simpson Judith | 1986-04-27 | UHC-21051-13 | 9284809622 | 2933 Pine Dr, Tempe, AZ, 85207 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-422176 | CLM | Vincent Holmes | 1942-09-03 | UHC-45761-46 | 6069749908 | 2193 Maple Ave Apt 9, Seattle, WA, 98170 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| CLM-406308 | CLM | Michhael Peters | 1951-07-01 | UHC-46427-71 | 7846759366 | 5547 Mountain View Dr, Scottsdale, AZ, 85228 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-405610 | CLM | Larry F Jackson | 1943-03-16 | — | 9178940301 | 9602 Church St, Seattle, WA, 98124 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-412326 | CLM | Juan Harris | 1965-11-17 | — | 7794991234 | 5790 Cedar Ln, Sacramento, CA, 95802 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-420371 | CLM | Gabriel Thompson | 1953-09-15 | — | 4973179802 | 1380 Washington St, Nashville, TN, 37220 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-424612 | CLM | Peter Patel | 1945-04-20 | UHC-99963-63 | — | 981 Union St, Chandler, AZ, 85264 | 0.74 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-426841 | CLM | Danielle Reynolds | 1993-03-13 | — | 5333609829 | 3938 Pine Dr, Atlanta, GA, 30348 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-401273 | CLM | Mason Porter | 1984-11-16 | — | 2927756233 | 9563 Ocean Ave, Scottsdale, AZ, 85220 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-401272 | CLM | Mason Porter | 1984-11-16 | — | 2927756233 | 9563 Ocean Ave, Scottsdale, AZ, 85220 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-418975 | CLM | Juan C Powell | 1986-03-20 | UHC-26955-36 | 7077265948 | 3389 Pine Dr, Fresno, CA, 93736 | 0.74 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| CLM-411270 | CLM | Debra Ramos | 1992-04-19 | — | 3954296772 | 431 Cedar Ln, Minneapolis, MN, 55457 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-415185 | CLM | Walter X Carter | 2003-10-18 | — | 7006404970 | 2950 Bayshore Dr, Austin, TX, 78708 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-411941 | CLM | Alexander Anderson | 1950-05-14 | UHC-79887-28 | 4783200973 | 1045 Ocean Ave, Orlando, FL, 32883 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-422161 | CLM | Paul Rommero | 1971-11-27 | UHC-28842-64 | 3842538140 | 8261 Harbor Blvd, Miami, FL, 33132 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-405041 | CLM | Judy Sanders | 1961-06-20 | — | 6016220859 | 8196 Ridge Rd, Los Angeles, CA, 90032 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-416156 | CLM | Priya Welch | 1991-08-20 | — | 8995936937 | 8413 Ocean Ave, Nashville, TN, 37244 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-406730 | CLM | Brenda Day | 1975-08-25 | UHC-90446-52 | 9707146699 | 8929 Willow Ct, Tucson, AZ, 85752 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-431626 | CLM | Gabriel Rios | 1960-07-09 | UHC-91956-10 | 4886347198 | 4839 Ocean Ave, San Antonio, TX, 78264 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-422480 | CLM | Zachary Gaorge | 1982-02-19 | — | — | 8626 Ridge Rd, Seattle, WA, 98123 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-414634 | CLM | Rebecca Bennnett | 1948-04-27 | UHC-21274-89 | 8297418145 | 5990 Camelback Rd, Gilbert, AZ, 85268 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| CLM-402686 | CLM | Noah Lawrence | 1965-07-20 | UHC-16878-36 | 2895613596 | 169 Baseline Rd, Minneapolis, MN, 55443 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-407310 | CLM | Christopher B Cooper | 1968-04-23 | UHC-06864-83 | 2415390900 | 3094 Willow Ct, Columbus, OH, 43264 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| CLM-412847 | CLM | Jerry Romero | 1964-03-24 | — | — | 855 Lake View Rd, Tucson, AZ, 85786 | 0.74 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| CLM-405728 | CLM | Bradley Carroll | 1978-04-11 | UHC-55821-47 | 8897810735 | 9524 Palm Dr, Eden Prairie, MN, 55384 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-412015 | CLM | Jerry Price | 1957-10-17 | UHC-62204-46 | — | 563 Desert Sky Blvd, Glendale, AZ, 85340 | 0.74 | Name re-casedDate of birth reformattedMember ID reformattedCity re-cased+3 more |
| CLM-416115 | CLM | Jack Sims | 1983-09-21 | UHC-08090-72 | 8249894889 | 8391 Harbor Blvd, Plano, TX, 75073 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| CLM-412990 | CLM | Jeremy Castillo | 1981-09-28 | UHC-29703-02 | 6125163836 | 3847 Grand Ave, Tempe, AZ, 85235 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| CLM-411744 | CLM | Ashley U Perry | 1987-02-07 | UHC-75552-09 | — | 3205 Ridge Rd, Atlanta, GA, 30359 | 0.74 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| CLM-429566 | CLM | Alexis Armsrtong | 2004-09-05 | UHC-43400-99 | 4566033923 | 9668 Lincoln Way, Scottsdale, AZ, 85212 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-419773 | CLM | Deborah Sanders | 1957-09-13 | UHC-37538-29 | 7423787788 | 3107 Market St, Atlanta, GA, 30377 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-402585 | CLM | Russell Le | 1941-05-10 | UHC-19416-53 | 7007392456 | — | 0.74 | Name re-casedPhone reformattedMember ID reformattedGender normalised+3 more |
| CLM-419652 | CLM | Jennifer Russell | 2003-03-03 | UHC-52480-15 | 2147576362 | 8600 Ridge Rd, Chandler, AZ, 85287 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-427767 | CLM | Anthony Harris | 2002-11-20 | UHC-93261-88 | 8364390145 | 6767 Palm Dr, Orlando, FL, 32833 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-423117 | CLM | Sam Dean | 2004-11-26 | UHC-17723-18 | 7555663797 | 8064 Indian School Rd, Dallas, TX, 75280 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-400237 | CLM | Angela Espinooza | 1979-07-09 | — | 2506932916 | 6531 Ocean Ave, Fresno, CA, 93743 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-416817 | CLM | Sara Ramos | 2008-11-19 | — | 4216854586 | 2967 Highland Ave, San Diego, CA, 92123 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-418128 | CLM | Shirley Le | 2002-03-28 | UHC-24005-09 | 9148077555 | 7260 Market St, Mesa, AZ, 85220 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-409226 | CLM | Megan Meyer | 1945-04-12 | UHC-75159-75 | 7098695661 | 4769 Park Pl, Atlanta, GA, 30330 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-421641 | CLM | Sarah Richards | 1969-07-06 | — | 8643960585 | 5747 Palm Dr, Scottsdale, AZ, 85223 | 0.74 | Name re-casedCity re-casedState code upper-casedGender normalised+3 more |
| CLM-426435 | CLM | Jennifer Carroll | 1946-04-23 | UHC-60488-61 | 7942064822 | 4830 River Rd, Las Vegas, NV, 89128 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-411841 | CLM | Richards Theresa | 1968-04-08 | UHC-25205-29 | 4569637577 | 5657 Ridge Rd, Las Vegas, NV, 89140 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-422359 | CLM | Nancy G Williamson | 1962-04-06 | — | — | 1452 Cedar Ln, Glendale, AZ, 85379 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| CLM-417713 | CLM | Lori Contreras | 1964-02-14 | — | 8594720235 | 5981 Maple Ave, Dallas, TX, 75273 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| CLM-425942 | CLM | Ralph Andrews | 1953-09-20 | UHC-85599-20 | 2122278055 | 8747 Desert Sky Blvd, Miami, FL, 33144 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |