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 |
|---|---|---|---|---|---|---|---|---|
| PRV-21330 | PRV | Rebecca Munoz | 1958-09-21 | — | 3485736847 | 8264 Hillcrest Rd # 969, Charlotte, NC, 28260 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more |
| PRV-23458 | PRV | Michelle Haansen | 1952-03-09 | UHC-96691-01 | 5872364637 | 4178 Baseline Rd, Charlotte, NC, 28274 | 0.44 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+6 more |
| PRV-27404 | PRV | Wei Knight | 2003-01-13 | — | 6565121326 | 5983 Harbor Blvd # 742, Minneapolis, MN, 55440 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more |
| CLM-409594 | CLM | Isabella Parker | 1955-02-11 | UHC-22975-41 | 3803155498 | 3506 Grand Ave, Glendale, AZ | 0.44 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+6 more |
| ENR-134675 | ENR | Nancy Sims | 2000-10-07 | UHC-83909-97 | 7729925748 | 8212 Market St Apt 7, Seattle, WA | 0.44 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more |
| CLM-406806 | CLM | Patty Hart | 1974-05-14 | — | 2888272392 | 6473 Jefferson Ave, Phoenix, AZ | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-142678 | ENR | Isabbella Gordon | 2007-08-24 | UHC-44059-85 | — | 752 Mountain View Dr, Los Angeles, CA | 0.44 | Name split from “Last, First”Two-digit birth yearZIP missingGender normalised |
| PRV-28219 | PRV | Deborah Ray | 1944-02-03 | UHC-55168-60 | 7986907373 | 596 Indian School Rd, Sacramento, CA, 95884 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| ENR-124209 | ENR | Brittany Ferguson | 1960-11-14 | UHC-34165-52 | 2619062973 | 8443 Valley View Dr, Fresno, CA, 93729 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more |
| ENR-127264 | ENR | Carol X Rogers | 1973-06-14 | UHC-29452-56 | 6437676642 | 6820 Hillcrest Rd, Minneapolis, MN, 55427 | 0.44 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more |
| CLM-410506 | CLM | Joyce Roberts | 2007-01-12 | UHC-91571-60 | 3377074840 | 2751 Jefferson Ave, Los Angeles, CA, 90046 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| CLM-406590 | CLM | Mateo Castro | 1969-09-04 | — | 6102596581 | 8933 Bayshore Dr, Mesa, AZ, 85278 | 0.44 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more |
| CLM-422843 | CLM | Kathleen Alvarado | 2006-09-04 | UHC-63954-89 | 9107986533 | 1905 Sage Ct, Columbus, OH, 43226 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more |
| ENR-106041 | ENR | Amber White | 1962-10-21 | UHC-86611-68 | 8209117647 | 2131 Sunset Blvd, Miami, FL | 0.46 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more |
| CLM-400939 | CLM | Roger Clark | 1985-04-20 | — | 7485158732 | 1018 Grand Ave # 590, Nashville, TN, 37221 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| ENR-116462 | ENR | Lauren G Holmes | 1992-02-16 | UHC-98314-28 | 2107885949 | 8144 Camelback Rd, Austin, TX, 78749 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-22608 | PRV | Barbara T Austin | 1980-07-02 | UHC-09800-59 | 2343011820 | 4185 Bayshore Dr, Tampa, FL | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more |
| CLM-419121 | CLM | Jake Espinoza | 1942-06-20 | UHC-07841-77 | 5704838208 | 2984 Desert Sky Blvd # 755, Tempe, AZ | 0.46 | Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+5 more |
| CLM-419178 | CLM | Jordan P Flores | 1964-08-10 | — | 8037133806 | 8436 Jefferson Ave, Tempe, AZ, 85230 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-119401 | ENR | Sophia P Dunn | 1968-06-01 | — | 3682036313 | 3089 Grand Ave # 798, Miami, FL, 33123 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-128529 | ENR | Jacqueline Stone | 1970-04-24 | UHC-69765-49 | 8124567795 | 607 Apache Blvd, Nashville, TN | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-138630 | ENR | Kevin Mills | 1948-08-03 | UHC-92487-72 | 6254216797 | 7712 Mountain View Dr # 836, Scottsdale, AZ, 85209 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more |
| TPA-61951 | TPA | Debbie Obrien | 1991-02-05 | — | 4948477432 | 6867 Main St, Los Angeles, CA | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-103640 | ENR | Theresa M Weaver | 2001-03-15 | UHC-34492-56 | 6742434258 | 1689 Indian School Rd, Tampa, FL, 33682 | 0.46 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| PRV-23062 | PRV | Carol Hart | 1945-05-28 | — | 3812420123 | 7981 Pine Dr Apt 13, Austin, TX, 78789 | 0.46 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| CLM-426877 | CLM | Alexander Estrada | 2004-12-02 | UHC-81386-36 | 8435691803 | 2506 Indian School Rd, Houston, TX, 77036 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| TPA-60991 | TPA | Amanda Little | 1953-02-07 | — | 4242739824 | 3360 Canyon Rd, Las Vegas, NV, 89116 | 0.46 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-127999 | ENR | Alan Lynch | 1993-06-03 | — | 8462609334 | 8507 Bayshore Dr, Tampa, FL, 33662 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| ENR-130771 | ENR | Pamla Y Hunt | 2001-10-27 | UHC-01030-03 | 8318026467 | 8873 River Rd, Plano, TX, 75042 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more |
| ENR-107224 | ENR | Sandra E Owens | 1978-11-16 | UHC-89246-62 | 8853856982 | 6957 Bayshore Dr, Seattle, WA, 98175 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| TPA-58448 | TPA | Donna Stone | 1996-10-18 | — | — | 8866 Grand Ave # 816, Jacksonville, FL, 32259 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-114125 | ENR | Alice A McDonald | 1963-06-01 | UHC-51908-02 | 9589190958 | 4905 Jefferson Ave, Tucson, AZ, 85722 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| ENR-131356 | ENR | Roger Fox | 1990-07-18 | UHC-96985-70 | 6404148100 | 5466 Maple Ave # 686, Tampa, FL, 33680 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| TPA-58831 | TPA | Alice Willis | 1944-06-18 | — | 7088054449 | 6140 Forest Ave, Chandler, AZ, 85257 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| CLM-420211 | CLM | Denise Berry | 1943-01-02 | UHC-93903-61 | 7039931159 | 6018 Maple Ave, Nashville, TN | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more |
| CLM-411775 | CLM | Eric Elliott | 1950-09-19 | — | 3773931327 | 6054 Forest Ave Apt 37, Las Vegas, NV, 89146 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| CLM-408173 | CLM | Kenneth Kellly | 1966-06-27 | UHC-11325-94 | 4895881399 | 6640 Indian School Rd # 198, Tucson, AZ, 85722 | 0.46 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more |
| ENR-125315 | ENR | Mari O Campbell | 1986-11-08 | UHC-54075-92 | 2086846093 | 3520 Lincoln Way, Charlotte, NC, 28219 | 0.46 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more |
| ENR-119598 | ENR | Lawrence Carter | 1993-01-26 | UHC-42533-01 | — | 1881 Jefferson Ave, Scottsdale, AZ, 85206 | 0.46 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more |
| ENR-119597 | ENR | Lawrence Carter | 1993-01-26 | UHC-42533-01 | — | 1881 Jefferson Ave, Scottsdale, AZ, 85206 | 0.46 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more |
| CLM-409127 | CLM | Robert Pierce | 1988-03-04 | — | 2443713021 | 3041 Hillcrest Rd, Houston, TX, 77072 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| CLM-426990 | CLM | Martah P Jenkins | — | UHC-38108-73 | 2944769082 | 8650 Apache Blvd Apt 4, Sacramento, CA, 95821 | 0.46 | Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more |
| TPA-55793 | TPA | Kathleen Z Simpson | 1999-07-27 | — | — | 9520 Central Ave, Columbus, OH, 43244 | 0.46 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more |
| ENR-102299 | ENR | Angela Fowler | 1969-11-24 | UHC-91761-70 | 4055581516 | 1269 Sage Ct, Tempe, AZ, 85283 | 0.46 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more |
| CLM-408088 | CLM | Kathryn Perry | 1971-07-27 | UHC-90777-05 | 7694911117 | 4230 Pine Dr, Atlanta, GA | 0.46 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more |
| ENR-128634 | ENR | Haroold Rivera | 1954-10-21 | UHC-92156-95 | 6767250850 | 2799 Cedar Ln # 734, Orlando, FL, 32849 | 0.46 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more |
| TPA-63881 | TPA | Christina Maldonado | 1968-01-13 | UHC-10398-30 | 6415500800 | 7835 Grand Ave Apt 31, Austin, TX, 78763 | 0.46 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more |
| CLM-425287 | CLM | Ana A Banks | 1964-10-09 | — | 6217960533 | 2552 Union St, Houston, TX, 77045 | 0.46 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more |
| ENR-134939 | ENR | Willie Franklin | 1974-09-24 | UHC-39455-06 | — | 5953 Bayshore Dr, Dallas, TX, 75226 | 0.46 | Date of birth reformattedPhone missing area codeSSN last four extractedStreet suffix standardised+5 more |
| CLM-419750 | CLM | Gerald Maldonado | 1946-04-17 | — | — | 3295 Pine Dr # 915, Charlotte, NC | 0.46 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more |