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
Provider network, lowest dq score first
| Record | Source | Name | DOB | Member ID | Phone | Address | Quality score | Flags |
|---|---|---|---|---|---|---|---|---|
| PRV-22272 | PRV | Patricia G Aguilar | 1953-02-23 | UHC-00064-32 | — | 5789 River Rd, Nashville, TN, 37202 | 0.84 | Name split from “Last, First”Placeholder values cleared |
| PRV-28211 | PRV | Shirley T Carr | 1938-09-16 | — | — | 281 Meadow Ln # 541, Fresno, CA, 93770 | 0.84 | Unit split from streetPlaceholder values cleared |
| PRV-28212 | PRV | Shirley T Carr | 1938-09-16 | — | — | 281 Meadow Ln # 541, Fresno, CA, 93770 | 0.84 | Unit split from streetPlaceholder values cleared |
| PRV-21211 | PRV | Charlotte Dunn | 1987-10-01 | — | — | 6874 Broadway, Denver, CO, 80250 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-21518 | PRV | Jason Duncan | 1996-06-16 | UHC-47431-54 | — | 783 Washington St, Houston, TX, 77091 | 0.84 | Date of birth reformattedState name converted to code |
| PRV-21283 | PRV | Shirley Alvarez | 1986-07-17 | UHC-51388-98 | — | — | 0.84 | Name split from “Last, First”Placeholder values cleared |
| PRV-20011 | PRV | Sara J Contreras | 1973-04-10 | UHC-46492-52 | — | 4401 River Rd, Seattle, WA, 98159 | 0.84 | Street suffix standardisedAddress re-cased |
| PRV-23067 | PRV | Stephen Smith | 1942-12-05 | UHC-26563-91 | 7103129215 | 2624 Mountain View Dr, San Diego, CA, 92113 | 0.86 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-21782 | PRV | Alan Tran | 1970-06-06 | UHC-55420-11 | 4134792832 | 7475 Valley View Dr, Nashville, TN, 37292 | 0.86 | State name converted to code |
| PRV-25110 | PRV | Carolyn F Munoz | 1980-10-27 | UHC-01180-77 | 5032763388 | 9026 Maple Ave, San Antonio, TX, 78219 | 0.86 | Date of birth reformattedPhone reformattedMember ID reformattedCity re-cased+3 more |
| PRV-23089 | PRV | Aaron Reid | 1996-12-22 | — | 7123040949 | 9152 Jefferson Ave, Mesa, AZ, 85276 | 0.86 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-22031 | PRV | Gerald Davis | 1959-07-13 | UHC-68736-64 | — | 7154 Pine Dr, Tempe, AZ, 85215 | 0.86 | Name split from “Last, First” |
| PRV-21088 | PRV | Adrea U Brown | 1977-01-22 | UHC-38340-41 | 3447577223 | 2828 Desert Sky Blvd, San Diego, CA, 92105 | 0.86 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| PRV-23017 | PRV | Melissa P Stevens | 1956-02-18 | UHC-08975-82 | 2935934937 | 4400 Broadway, Plano, TX, 75091 | 0.86 | Name re-casedDate of birth reformattedPhone reformattedAddress re-cased+3 more |
| PRV-26922 | PRV | Amber L Roberts | 1973-04-15 | UHC-83489-16 | — | 9583 Broadway, Tempe, AZ, 85295 | 0.88 | Name re-casedAddress re-casedCity re-casedState code upper-cased+2 more |
| PRV-23407 | PRV | Ashley Reyes | 1948-10-05 | — | 5437765037 | 6513 Central Ave, Scottsdale, AZ, 85236 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-27797 | PRV | Evelyn P Palmer | 1997-04-03 | — | 6092390924 | 8011 Church St, Tucson, AZ, 85758 | 0.88 | Name re-casedPhone reformattedCity re-casedState code upper-cased+2 more |
| PRV-25105 | PRV | Mariana Taylor | 2005-04-02 | UHC-39730-46 | 2036779596 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| PRV-22626 | PRV | Mariana Mason | 1965-12-17 | — | 4572467847 | 7478 Mountain View Dr, Jacksonville, FL, 32270 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-28272 | PRV | Timothy L Walker | 1987-09-04 | UHC-34814-20 | 5833028834 | 9048 Washington St, Plano, TX, 75044 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-27635 | PRV | Kathryn Warren | 1959-03-12 | UHC-71018-94 | 3167136460 | 6289 Jefferson Ave, Los Angeles, CA, 90013 | 0.88 | Name re-casedPhone reformattedCity re-casedEmail lower-cased+2 more |
| PRV-21147 | PRV | Lauren Wong | 1955-10-13 | — | 5612442592 | 7046 Lincoln Way, Eden Prairie, MN, 55329 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-23327 | PRV | Betty A Roe | 2004-02-14 | UHC-23050-58 | 8767136718 | 1454 Grand Ave, Glendale, AZ, 85332 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-29252 | PRV | Blily R Fisher | 1980-06-20 | UHC-98030-27 | 6996269135 | 1611 Hillcrest Rd, Seattle, WA, 98155 | 0.88 | Name re-casedDate of birth reformattedMember ID reformattedEmail lower-cased+2 more |
| PRV-23683 | PRV | Omar K Ortega | 1966-08-02 | — | 3453747533 | 724 Washington St, San Antonio, TX, 78224 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-23854 | PRV | Susan L King | 1980-11-07 | UHC-87239-11 | 5216262677 | 7530 Apache Blvd, Scottsdale, AZ, 85212 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more |
| PRV-20469 | PRV | Alice Le | 1943-01-22 | UHC-49554-66 | 5785317456 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more |
| PRV-22876 | PRV | Jeremy James | 1956-12-08 | UHC-33338-98 | 3452840548 | 4486 Union St, Eden Prairie, MN, 55334 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-23146 | PRV | Priya Jimenez | 1962-12-10 | UHC-55791-82 | 7085574452 | 1209 Central Ave, Dallas, TX, 75242 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more |
| PRV-22928 | PRV | Bob Hunter | 1967-12-10 | UHC-35728-26 | 9448457328 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| PRV-29180 | PRV | Vincent E Herrera | 1954-11-26 | — | 2224323252 | 6704 Lincoln Way, Charlotte, NC, 28229 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-25187 | PRV | Richard E Kelley | 1963-12-07 | — | 2502272678 | 68 Desert Sky Blvd, Tucson, AZ, 85719 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-21345 | PRV | Roger Payne | 2005-04-06 | UHC-87094-74 | 2286699152 | 2210 Ridge Rd, Chandler, AZ, 85210 | 0.88 | Name re-casedPhone reformattedMember ID reformattedEmail lower-cased+2 more |
| PRV-25309 | PRV | Valentina M Hayes | 1952-04-28 | UHC-86120-56 | 2417407827 | 6380 Washington St, Scottsdale, AZ, 85229 | 0.88 | Date of birth reformattedMember ID reformattedCity re-casedEmail lower-cased+2 more |
| PRV-24728 | PRV | Daniel Ramirez | 1992-09-15 | UHC-57427-66 | 6727715403 | 815 Sunset Blvd, Miami, FL, 33128 | 0.88 | Date of birth reformattedPhone reformattedCity re-casedEmail lower-cased+2 more |
| PRV-20029 | PRV | Nancy B Morrison | 1972-05-15 | — | 5985164419 | 9818 Camelback Rd, Houston, TX, 77089 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-28683 | PRV | Kevin Burton | 1974-02-28 | UHC-40231-03 | 8846081503 | 6383 Mountain View Dr, Gilbert, AZ, 85246 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more |
| PRV-20649 | PRV | Gloria Hamilton | 2008-01-22 | UHC-19298-24 | 9117047508 | — | 0.88 | Name re-casedPhone reformattedMember ID reformattedEmail lower-cased+2 more |
| PRV-22770 | PRV | Mariana O Johnson | 1997-03-21 | UHC-60276-16 | 4404821064 | 1867 Mountain View Dr, Dallas, TX, 75206 | 0.88 | Name re-casedPhone reformattedState code upper-casedEmail lower-cased+2 more |
| PRV-24168 | PRV | Betty Pena | 1953-10-03 | UHC-15755-28 | 5886663083 | 8194 Maple Ave, Nashville, TN, 37272 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-24590 | PRV | Brian S Larson | 1984-01-01 | — | 7875491229 | — | 0.88 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| PRV-22471 | PRV | Ronald Dunn | 1949-01-14 | UHC-38783-47 | 7947678863 | 1118 Desert Sky Blvd, Fresno, CA, 93772 | 0.88 | Phone reformattedMember ID reformattedState code upper-casedEmail lower-cased+2 more |
| PRV-21709 | PRV | Madison Foster | 1955-03-28 | UHC-63068-07 | 6799727683 | 8828 Spring St, Atlanta, GA, 30393 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more |
| PRV-20923 | PRV | Ann Elliott | 1990-05-15 | — | 2843122218 | 3996 Broadway, Glendale, AZ, 85361 | 0.88 | Date of birth reformattedPhone reformattedEmail lower-casedPlan code upper-cased+2 more |
| PRV-20700 | PRV | Helen Harvey | 1942-02-24 | — | 3364512165 | 9675 Broadway, Nashville, TN, 37203 | 0.88 | Name re-casedPhone reformattedAddress re-casedEmail lower-cased+2 more |
| PRV-25612 | PRV | Denise Garza | 1982-10-16 | — | 4135593814 | 7798 Central Ave, Phoenix, AZ, 85027 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-26947 | PRV | Kevin O Singh | 1994-08-20 | UHC-44191-84 | 6593986444 | 8045 Broadway, Mesa, AZ, 85252 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-26125 | PRV | Gregory Pena | 1998-08-02 | UHC-97760-95 | 6476280949 | 8328 Bayshore Dr, Dallas, TX, 75250 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-24347 | PRV | Christine Garcia | 1960-03-06 | — | 3934424041 | 2995 Broadway, Minneapolis, MN, 55477 | 0.88 | Name re-casedPhone reformattedAddress re-casedCity re-cased+2 more |
| PRV-22531 | PRV | Diane A Butler | 1984-02-05 | UHC-36876-56 | 4077191224 | 309 Hillcrest Rd, Charlotte, NC, 28299 | 0.88 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |