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, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| CLM-408014 | CLM | Ana Ortega | 1951-06-23 | UHC-19282-90 | — | 2539 Palm Dr, Scottsdale, AZ, 85230 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-427134 | CLM | Carolyn Sullivan | 1992-02-06 | UHC-26152-56 | 9034196631 | 695 Indian School Rd Apt 18, Tempe, AZ, 85280 | 0.48 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| CLM-407270 | CLM | Peter W Moore | 1945-10-03 | UHC-56208-08 | 2357630756 | 1771 Canyon Rd, Miami, FL, 33140 | 0.48 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-138846 | ENR | Dylan Fernandez | 2006-08-09 | UHC-35577-71 | 8673533307 | 467 Indian School Rd # 103, Denver, CO, 80234 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-113463 | ENR | James I McDonald | 1959-03-20 | UHC-97198-99 | 4352519505 | 209 Mountain View Dr, Fresno, CA | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-421876 | CLM | Maria H Simpson | 2008-12-22 | UHC-29411-66 | — | 2468 Union St, Houston, TX, 77056 | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102039 | ENR | Ronald J Crawforrd | 1946-11-23 | UHC-31165-99 | 2464405025 | 8237 Apache Blvd Apt 16, San Antonio, TX, 78278 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-107536 | ENR | Kyle Dominguez | 1953-04-28 | UHC-47896-19 | 2809134875 | 1431 Grand Ave Apt 7, Columbus, OH, 43217 | 0.48 | Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+4 more |
| TPA-60000 | TPA | Gregory G Le | 1939-12-05 | UHC-77243-54 | 9158164062 | 3244 Spring St, San Diego, CA | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| ENR-115315 | ENR | Bruce Gordon | — | UHC-76548-65 | 9128951340 | 1965 Apache Blvd, Austin, TX, 78712 | 0.48 | Name re-casedDate of birth missingPhone reformattedCity re-cased+4 more |
| ENR-135766 | ENR | Alan Gray | 2005-10-03 | UHC-03446-34 | 3762867399 | 4622 Jefferson Ave, Atlanta, GA, 30320 | 0.48 | Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more |
| ENR-111708 | ENR | Anthony Vaga | 1969-08-01 | UHC-69881-96 | 6212547981 | 7684 Sage Ct, Charlotte, NC, 28207 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| CLM-413596 | CLM | Amanda Y McCoy | 1969-01-12 | UHC-80480-01 | 8678939961 | 428 Mesa Dr # 176, Houston, TX, 77016 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| ENR-109102 | ENR | Marilyn Hudson | 1998-12-27 | UHC-41649-59 | — | 2271 Desert Sky Blvd, Charlotte, NC, 28232 | 0.48 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+4 more |
| ENR-126083 | ENR | Ann Singh | 1944-09-18 | UHC-68432-82 | 2323236049 | 1013 Camelback Rd # 671, Fresno, CA, 93720 | 0.48 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-129229 | ENR | Jacob O Herrera | 1943-08-15 | — | 9255373957 | 3774 Palm Dr, Plano, TX | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-402888 | CLM | Mark Cole | 1958-09-01 | UHC-08276-88 | — | 9515 Sunset Blvd, Nashville, TN, 37286 | 0.48 | Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-416152 | CLM | Nathan Le | — | UHC-58783-64 | 5219134034 | 6482 Forest Ave, Las Vegas, NV, 89182 | 0.48 | Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more |
| TPA-59737 | TPA | Janet Ryan | — | — | 9558806102 | 1484 Mesa Dr, San Antonio, TX, 78203 | 0.48 | Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-136251 | ENR | Philip Perkins | 1944-08-04 | UHC-20874-77 | 8628068729 | 6656 Union St # 806, Gilbert, AZ, 85221 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more |
| CLM-420405 | CLM | Sara Harvey | 1984-02-18 | UHC-26372-60 | 6245431462 | 8811 Church St, Denver, CO | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-141329 | ENR | Becky Q Jones | 1967-05-27 | UHC-46908-53 | 7535833803 | 7642 Lincoln Way Apt 9, Seattle, WA, 98182 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| CLM-415767 | CLM | Mazon Castro | 1957-09-28 | UHC-01653-72 | 7644039675 | 4926 Main St, Austin, TX, 78768 | 0.48 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-432175 | CLM | Anthony Park | 2001-02-22 | UHC-76242-39 | 2763139632 | 379 Oak St, Dallas, TX, 75231 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| TPA-50003 | TPA | James K Hunter | 1960-03-14 | — | — | 6535 Bayshore Dr, Orlando, FL, 32832 | 0.48 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more |
| ENR-116879 | ENR | Jerry Romero | 1964-03-24 | UHC-98312-99 | 2679081891 | 855 Lake View Rd, Tucson, AZ | 0.48 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| ENR-122069 | ENR | Peter Gray | 1985-08-23 | UHC-33256-68 | 4647764297 | 876 Spring St Apt 31, Los Angeles, CA | 0.48 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| CLM-431403 | CLM | Gary Matthews | 1945-11-13 | UHC-27209-51 | 6818665792 | 4842 Pine Dr, Charlotte, NC, 28266 | 0.48 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-26050 | PRV | Carol Ortega | 1996-01-15 | UHC-51717-73 | 5967803069 | 5241 Central Ave, Tampa, FL | 0.48 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-415453 | CLM | Lawrence Richards | 1964-11-21 | UHC-84652-73 | — | 6040 Main St, Columbus, OH, 43236 | 0.48 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-418564 | CLM | George Z Li | 1955-11-01 | — | 6522542957 | 9770 Jefferson Ave, Atlanta, GA, 30349 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-102978 | ENR | Joshua Johnson | — | UHC-72422-30 | 6657950588 | 7815 Maple Ave, Tucson, AZ, 85726 | 0.48 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more |
| CLM-422951 | CLM | Bradley Bryant | 1990-12-16 | UHC-99924-03 | — | 3422 Lake View Rd, Atlanta, GA, 30370 | 0.48 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-119042 | ENR | Carolyn I Herrera | 1965-07-04 | UHC-83872-65 | 3757062283 | 7974 Washington St, Gilbert, AZ, 85261 | 0.48 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| CLM-400543 | CLM | Bryan Valdez | 1986-09-17 | — | 5189839214 | 5624 Canyon Rd, Columbus, OH, 43273 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-104033 | ENR | Gerald C Cunningham | 1951-07-23 | UHC-47203-81 | 7875677578 | 3051 Washington St, Scottsdale, AZ | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| CLM-428426 | CLM | Rachel CJunk | 1961-03-10 | — | — | 1832 Grand Ave, Seattle, WA, 98154 | 0.48 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more |
| CLM-428427 | CLM | Rachel CJunk | 1961-03-10 | — | — | 1832 Grand Ave, Seattle, WA, 98154 | 0.48 | Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more |
| PRV-22864 | PRV | Raymond Payne | 1967-06-01 | UHC-06240-95 | 3808478937 | 7626 Broadway, Denver, CO, 80272 | 0.48 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+4 more |
| ENR-132964 | ENR | Diana Little | 1976-07-05 | UHC-64760-52 | 7043619723 | 346 Jefferson Ave, Eden Prairie, MN, 55312 | 0.48 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| TPA-64070 | TPA | Vincent Riley | 1964-12-24 | — | — | 1651 Grand Ave, Atlanta, GA, 30381 | 0.48 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| CLM-403184 | CLM | Gabriel Yang | 1960-04-14 | UHC-81771-20 | — | 1130 Elm St, Columbus, OH | 0.48 | Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more |
| ENR-126849 | ENR | Roger L Howard | 2001-08-11 | UHC-32346-57 | 9205552067 | 9283 Lincoln Way, Nashville, TN, 37209 | 0.48 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| ENR-117362 | ENR | Diana A Cooper | 1952-09-12 | UHC-80204-72 | 7916680548 | 9763 Hillcrest Rd, Las Vegas, NV | 0.48 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-24148 | PRV | Philip Valdez | 1996-03-02 | UHC-84631-45 | — | 713 Camelback Rd Apt 24, Denver, CO, 80234 | 0.48 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| CLM-402040 | CLM | Mark Palmer | 2008-07-25 | — | 6604513054 | 6191 Oak St Apt 3, Gilbert, AZ, 85298 | 0.48 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| ENR-117076 | ENR | Lauren S Valdez | 1944-06-21 | UHC-73108-23 | 7699924425 | 1720 Market St # 963, Tucson, AZ, 85766 | 0.48 | Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more |
| TPA-54682 | TPA | Carlos Thompson | 2002-01-26 | — | — | 7115 Apache Blvd Apt 38, Tampa, FL, 33652 | 0.48 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more |
| ENR-142565 | ENR | Alice L Adams | 2003-11-05 | UHC-37979-98 | — | 2201 Canyon Rd, Gilbert, AZ, 85214 | 0.48 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more |
| PRV-20830 | PRV | Tyler U Crawford | 1968-08-07 | UHC-49693-64 | 7255015011 | 9252 Ridge Rd, Plano, TX, 75095 | 0.48 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more |