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-23630 | PRV | Roy X Sanders | 1941-06-11 | UHC-81923-33 | — | 4426 Harbor Blvd, Fresno, CA, 93720 | 0.78 | Name re-casedDate of birth reformattedCity re-casedState name converted to code+1 more |
| PRV-24644 | PRV | Joe Jensen | 1986-02-13 | UHC-10382-91 | 2734920821 | 3667 Camelback Rd, Phoenix, AZ, 85057 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24094 | PRV | Natalie Collins | 1957-07-26 | — | 4856365413 | 8209 River Rd Apt 13, Las Vegas, NV, 89157 | 0.78 | Name re-casedDate of birth reformattedUnit split from streetWhitespace trimmed+1 more |
| PRV-24496 | PRV | Judy Ortega | 1997-11-23 | — | 2342283457 | 2089 Camelback Rd, San Diego, CA, 92136 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-28740 | PRV | Luis Y Stevens | 2002-07-18 | — | 3082697885 | 7599 Grand Ave, Sacramento, CA, 95850 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23000 | PRV | Alice Marshall | 1988-11-22 | — | 6698641806 | 5036 Bayshore Dr, Plano, TX, 75009 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23430 | PRV | Roy Vargas | 1995-02-27 | UHC-80446-31 | — | 8851 Maple Ave, Los Angeles, CA, 90066 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+1 more |
| PRV-20918 | PRV | Nancy N Brooks | 2002-03-20 | — | 8553099739 | 4433 Ocean Ave, San Diego, CA, 92148 | 0.78 | Date of birth reformattedPhone reformattedState code upper-casedZIP+4 trimmed+1 more |
| PRV-27480 | PRV | Theresa Flores | 1941-05-14 | — | 8535989960 | 3624 Harbor Blvd, Mesa, AZ, 85298 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-25166 | PRV | Sean Carpenter | 1955-10-05 | — | 3493704324 | 4917 Lake View Rd, Seattle, WA, 98103 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-26733 | PRV | Arthur Matthews | 2006-07-12 | UHC-68724-72 | 9069513209 | 5542 Pine Dr, Los Angeles, CA, 90052 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-29497 | PRV | Linda Walsh | 1947-06-04 | UHC-51831-20 | — | 3155 Valley View Dr, Tucson, AZ, 85767 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22641 | PRV | Rebecca Salazar | 1969-02-21 | UHC-27424-29 | 4813777076 | 6842 Sunset Blvd, Houston, TX, 77084 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22133 | PRV | Kimberly Munoz | 2007-12-22 | UHC-59562-45 | 5384042562 | 5212 Spring St, Jacksonville, FL, 32237 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23641 | PRV | Jerry Burke | 1976-08-18 | UHC-38441-26 | 6716059679 | 8032 Valley View Dr, Nashville, TN, 37248 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22937 | PRV | Brandon West | 1996-07-03 | — | — | 5984 Valley View Dr, Houston, TX, 77070 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-25392 | PRV | Larry Burke | 1976-07-03 | UHC-81346-65 | 6168760776 | 4801 Willow Ct, Tucson, AZ, 85722 | 0.78 | Name split from “Last, First”Phone reformattedState code upper-casedWhitespace trimmed+1 more |
| PRV-22794 | PRV | Jess Bennett | 1991-05-02 | UHC-98542-11 | 9145260374 | 5439 Camelback Rd, Denver, CO, 80206 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-23777 | PRV | Judy Stevens | 1962-08-11 | UHC-82487-20 | 4019688917 | 3652 Palm Dr, Los Angeles, CA, 90041 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27297 | PRV | Lawrence Ramirez | 1971-02-09 | UHC-73167-84 | 7125755715 | 863 Bayshore Dr, Los Angeles, CA, 90061 | 0.78 | Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more |
| PRV-27439 | PRV | Judith Larson | 1990-08-18 | — | 5634462235 | 7789 Sunset Blvd, San Diego, CA | 0.78 | Phone reformattedCity re-casedZIP missingWhitespace trimmed+1 more |
| PRV-21376 | PRV | Sofia Fernandez | 1968-12-20 | — | 9765276749 | 2511 Grand Ave, Plano, TX, 75046 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25063 | PRV | Ruth T Martin | 1995-04-11 | — | 7974100469 | 3526 Maple Ave, Tucson, AZ, 85762 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+1 more |
| PRV-28911 | PRV | Frank Z Bailey | 1963-12-16 | UHC-35199-95 | 3979114661 | 4978 Pine Dr, Dallas, TX, 75292 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+1 more |
| PRV-28494 | PRV | Joe Burns | 1984-01-14 | — | 6398077273 | 3433 Indian School Rd, Houston, TX, 77076 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24587 | PRV | Olivia Parker | 1982-07-27 | UHC-73080-77 | 6079777656 | 4826 Cedar Ln, Glendale, AZ, 85360 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25813 | PRV | Carol Fuller | 2001-04-27 | — | 5318646134 | 6091 Cedar Ln, San Antonio, TX, 78280 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29591 | PRV | Sarah Harvey | 1994-03-07 | UHC-63568-85 | 2548181830 | 9589 Church St, Phoenix, AZ, 85073 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22559 | PRV | Ruth Robertsno | 1944-11-19 | UHC-18376-75 | 9714784272 | 9595 Ridge Rd, Phoenix, AZ, 85049 | 0.78 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27847 | PRV | Jeffrey Gordon | 1944-07-06 | — | — | 7623 Spring St, Sacramento, CA, 95836 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28795 | PRV | Mei Walsh | 1980-04-15 | UHC-98864-36 | — | 6193 Church St, Orlando, FL, 32806 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23127 | PRV | Eddie Daniels | 1985-10-27 | UHC-52432-11 | 3343172163 | 8035 Central Ave, Tampa, FL, 33615 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25586 | PRV | Elijah B Ruiz | 1981-01-18 | — | 2414150805 | 1368 Grand Ave, Mesa, AZ, 85249 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22538 | PRV | Charlotte Owens | 1940-02-25 | UHC-49048-55 | 2747782087 | 1858 Jefferson Ave, Orlando, FL, 32867 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20597 | PRV | Bryan Davis | 1959-09-09 | — | 2787992735 | 2320 Union St, Miami, FL, 33104 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23519 | PRV | Peter Gomez | 2006-03-07 | — | 8544406564 | 7109 Apache Blvd, Tampa, FL, 33676 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26862 | PRV | Aan Rios | 1956-06-13 | UHC-34823-98 | 7792994397 | 7829 Union St, Nashville, TN, 37200 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21265 | PRV | Alan Torres | 1966-05-03 | — | 7945164440 | 2033 Maple Ave, Nashville, TN, 37205 | 0.78 | Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-27215 | PRV | James Y Delgdo | 1967-08-17 | — | 5082635398 | 3875 Mountain View Dr, Orlando, FL, 32838 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22781 | PRV | Ashley Scott | — | UHC-15919-77 | 4444432041 | 5892 Highland Ave, Houston, TX, 77016 | 0.78 | Date of birth missingPhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-26874 | PRV | Robert Moore | 1975-11-08 | — | 2354729736 | 3363 Meadow Ln, Tucson, AZ, 85725 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26591 | PRV | Brittany Taylor | 1947-06-20 | UHC-87089-87 | 4506778727 | 5296 Sage Ct # 765, Gilbert, AZ, 85274 | 0.78 | Phone reformattedUnit split from streetCity re-casedWhitespace trimmed+1 more |
| PRV-24403 | PRV | Arjun X Rojas | 1996-08-22 | — | — | 1443 Lake View Rd, Sacramento, CA, 95853 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23679 | PRV | Dick Cook | 1966-07-15 | UHC-12079-07 | 7724575059 | 3480 Mountain View Dr, Tampa, FL, 33695 | 0.78 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24681 | PRV | Jeremy U Duncan | 1969-05-17 | UHC-64116-48 | 7568930325 | 6026 Main St, Fresno, CA, 93731 | 0.78 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21548 | PRV | Robert Hoffman | 1985-03-22 | — | 5276517126 | 17 Palm Dr, Mesa, AZ, 85243 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-20939 | PRV | Jordan Jenkins | 1964-07-24 | — | 4787216624 | 1038 Park Pl, Atlanta, GA | 0.78 | Date of birth reformattedPhone reformattedZIP missingWhitespace trimmed+1 more |
| PRV-23686 | PRV | Henry Tucker | 1952-11-16 | — | 7985451731 | 242 Washington St, Nashville, TN, 37277 | 0.78 | Street suffix standardisedAddress re-casedState code upper-casedPlan code upper-cased+1 more |
| PRV-20039 | PRV | Mark Lawrence | 1943-03-17 | UHC-20563-33 | 5822177500 | 358 Baseline Rd, Denver, CO, 80295 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25511 | PRV | Lucia Benntet | 1946-12-08 | UHC-47654-57 | 7223619686 | — | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |