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
All sources, flag “SSN last four extracted”, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| ENR-125272 | ENR | Nancy H Dixon | 1946-03-13 | UHC-18593-21 | 7704212054 | 9305 Ridge Rd, Charlotte, NC, 28215 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| ENR-125733 | ENR | Marilyn U Patel | 1962-10-23 | UHC-01102-59 | 4424205948 | 7087 Camelback Rd, Los Angeles, CA, 90079 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| CLM-425707 | CLM | Ahmed Watkins | 1943-02-12 | UHC-52231-59 | — | 439 Apache Blvd, San Antonio, TX, 78285 | 0.82 | SSN last four extractedCity re-casedPlaceholder values cleared |
| ENR-116080 | ENR | Dennis I Salazar | 1987-01-01 | UHC-90264-58 | 5807510726 | 1001 Mesa Dr, Nashville, TN, 37293 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| ENR-131477 | ENR | Ronadl Smith | 1951-01-23 | UHC-41571-65 | 2564143688 | 6968 Central Ave, Los Angeles, CA, 90025 | 0.82 | Date of birth reformattedPhone reformattedSSN last four extracted |
| ENR-122105 | ENR | Priya Z Reynolds | 1995-05-20 | UHC-03653-51 | 3755415656 | 3380 Camelback Rd, Tucson, AZ, 85754 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| ENR-126367 | ENR | Alice Y Willis | 1944-06-18 | UHC-52240-26 | 7088054449 | 5380 Willow Ct, Nashville, TN, 37241 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| TPA-54842 | TPA | Alice J Vasquez | 2002-04-17 | — | — | — | 0.82 | Date of birth reformattedSSN last four extractedPlaceholder values cleared |
| ENR-134985 | ENR | Racehl D Fowler | 1961-06-04 | UHC-31365-37 | 9838192153 | 8131 Sunset Blvd, Phoenix, AZ, 85069 | 0.82 | Phone reformattedSSN last four extractedEmail lower-cased |
| TPA-54204 | TPA | Jessica Grant | 2004-10-17 | — | — | — | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| TPA-61797 | TPA | Jacob Stone | 1974-08-15 | — | — | 3481 River Rd, Atlanta, GA, 30379 | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| TPA-62967 | TPA | Bryan C Rose | 1991-01-28 | — | 4813886338 | 3255 Broadway, Chandler, AZ, 85255 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| ENR-115171 | ENR | Mariana Alvarez | 1951-04-01 | UHC-81390-02 | 8235937971 | 8423 Desert Sky Blvd, Eden Prairie, MN, 55335 | 0.82 | Phone reformattedMember ID reformattedSSN last four extracted |
| ENR-112172 | ENR | Emma Robertson | 1974-03-04 | UHC-78323-03 | 7425016743 | 434 Pine Dr, Tempe, AZ, 85242 | 0.82 | Date of birth reformattedSSN last four extractedWhitespace trimmed |
| ENR-112171 | ENR | Emma Robertson | 1974-03-04 | UHC-78323-03 | 7425016743 | 434 Pine Dr, Tempe, AZ, 85242 | 0.82 | Date of birth reformattedSSN last four extractedWhitespace trimmed |
| CLM-432647 | CLM | Priya Ellis | 1997-01-20 | UHC-18180-64 | — | — | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| ENR-104237 | ENR | Keith D Price | 1997-10-13 | UHC-07851-61 | 8287261678 | — | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| ENR-104238 | ENR | Keith D Price | 1997-10-13 | UHC-07851-61 | 8287261678 | — | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| PRV-26940 | PRV | Jessica Elliott | 2005-07-04 | UHC-51147-59 | 7989824634 | 2452 Maple Ave, Tempe, AZ, 85284 | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| ENR-132341 | ENR | Edward Hunter | 1959-05-04 | UHC-02646-40 | 5257953461 | 452 Central Ave, Seattle, WA, 98113 | 0.82 | Date of birth reformattedSSN last four extractedWhitespace trimmed |
| ENR-136423 | ENR | Sean Campbell | 2004-05-09 | UHC-72935-03 | 7992053462 | 1432 Lincoln Way, Orlando, FL, 32803 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| ENR-116504 | ENR | Andrea T King | 1981-08-14 | UHC-59243-19 | 3575903094 | 1431 Broadway, Minneapolis, MN, 55482 | 0.82 | SSN last four extractedAddress re-casedEmail lower-cased |
| CLM-424770 | CLM | Sophia I Cole | 1979-10-03 | — | 5545466776 | — | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| ENR-140468 | ENR | Jacob Rose | 1989-01-02 | UHC-83239-78 | 4309787580 | 933 Jefferson Ave, Houston, TX, 77057 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| ENR-107113 | ENR | Keith Ortega | 1978-12-20 | UHC-38565-14 | 5204163841 | — | 0.82 | Phone reformattedSSN last four extractedEmail lower-cased |
| CLM-410254 | CLM | Frank Carter | 1947-02-18 | — | — | 8754 Meadow Ln, Tempe, AZ, 85277 | 0.82 | SSN last four extractedCity re-casedPlaceholder values cleared |
| CLM-405748 | CLM | Jacob Obrien | 1949-07-03 | — | — | — | 0.82 | Name re-casedSSN last four extractedPlaceholder values cleared |
| TPA-61478 | TPA | Joan Brooks | 1997-11-12 | — | — | — | 0.82 | Name re-casedSSN last four extractedPlaceholder values cleared |
| CLM-413825 | CLM | Betty Kelly | 1961-06-07 | — | 4507602702 | — | 0.82 | Phone reformattedSSN last four extractedPlaceholder values cleared |
| CLM-410719 | CLM | Hannah Watson | 1995-07-27 | UHC-44586-69 | 7182887677 | — | 0.82 | Phone reformattedSSN last four extractedPlaceholder values cleared |
| ENR-110269 | ENR | Maria Nunez | 1946-01-24 | UHC-05838-12 | 8092197412 | 5440 Camelback Rd, Atlanta, GA, 30342 | 0.82 | Date of birth reformattedPhone reformattedSSN last four extracted |
| CLM-425154 | CLM | Evans Stephanie | 1957-09-08 | UHC-75128-15 | — | — | 0.82 | Date of birth reformattedSSN last four extractedPlaceholder values cleared |
| ENR-113516 | ENR | Catherine M McCoy | 1960-03-19 | UHC-63901-64 | 3055153179 | 1175 Lincoln Way, Columbus, OH, 43286 | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| TPA-51156 | TPA | Rebecca Mitchell | 1963-07-21 | — | — | 6206 Bayshore Dr, Houston, TX, 77099 | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| ENR-141904 | ENR | Richard U Green | 1944-05-14 | UHC-91416-11 | 8105680913 | 8231 Union St, Minneapolis, MN, 55428 | 0.82 | Name re-casedPhone reformattedSSN last four extracted |
| ENR-127658 | ENR | Helen O Parker | 1993-11-12 | UHC-81686-86 | — | 3784 Ocean Ave, Miami, FL, 33106 | 0.82 | Name re-casedDate of birth reformattedSSN last four extracted |
| ENR-108042 | ENR | Benjamin Fowler | 1956-05-27 | UHC-67914-70 | 7987229866 | 8779 Spring St, Charlotte, NC, 28273 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| ENR-124809 | ENR | Santiago R Rodiguez | 1956-01-05 | UHC-07549-37 | 4002827444 | — | 0.82 | Name re-casedPhone reformattedSSN last four extracted |
| ENR-106433 | ENR | Catherine L Dean | 1996-07-17 | UHC-12425-81 | 7389942638 | — | 0.82 | Date of birth reformattedSSN last four extractedWhitespace trimmed |
| ENR-102342 | ENR | Scott K Guerrero | 1984-09-24 | UHC-00718-51 | 2436404501 | 2116 Cedar Ln, Denver, CO, 80223 | 0.82 | Date of birth reformattedPhone reformattedSSN last four extracted |
| ENR-116874 | ENR | Ryan Grant | 1989-09-27 | UHC-15044-36 | 7404363040 | 6174 Valley View Dr, Tucson, AZ, 85708 | 0.82 | Name re-casedPhone reformattedSSN last four extracted |
| ENR-116875 | ENR | Ryan Grant | 1989-09-27 | UHC-15044-36 | 7404363040 | 6174 Valley View Dr, Tucson, AZ, 85708 | 0.82 | Name re-casedPhone reformattedSSN last four extracted |
| CLM-416287 | CLM | Bryan Gonzales | 1982-09-28 | UHC-98234-91 | 4257360730 | — | 0.82 | Name re-casedSSN last four extractedWhitespace trimmed |
| ENR-121218 | ENR | Vincent Romero | 1993-07-13 | UHC-61388-10 | 8163916132 | 6976 Apache Blvd, Seattle, WA, 98171 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| CLM-410252 | CLM | David Wheeler | 1980-07-27 | — | — | — | 0.82 | Name re-casedSSN last four extractedPlaceholder values cleared |
| ENR-108243 | ENR | Keith F Nelson | 1944-03-05 | UHC-26507-51 | 4846628345 | 8933 Canyon Rd, Orlando, FL, 32843 | 0.82 | Phone reformattedSSN last four extractedEmail lower-cased |
| CLM-424171 | CLM | May Burke | 1966-08-04 | UHC-56530-83 | — | — | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| ENR-102199 | ENR | Wayne R Foster | 1947-07-26 | UHC-28717-73 | 3975222620 | 2140 Main St, Plano, TX, 75086 | 0.82 | Phone reformattedSSN last four extractedWhitespace trimmed |
| ENR-119164 | ENR | Billy Wells | 1979-07-19 | UHC-39302-23 | 4726128768 | 1325 Church St, Phoenix, AZ, 85091 | 0.82 | Phone reformattedSSN last four extractedCity re-cased |
| ENR-129435 | ENR | Julia H Carter | 1993-12-09 | UHC-90536-94 | 9317671667 | 7784 Apache Blvd, Columbus, OH, 43266 | 0.82 | Name re-casedPhone reformattedSSN last four extracted |