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-25315 | PRV | Ann Ford | 1943-01-09 | UHC-08240-81 | — | 3659 Ridge Rd, Houston, TX, 77081 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone missing area codeMember ID reformatted+3 more |
| PRV-28704 | PRV | Betty Burke | 1966-02-08 | — | 3842806656 | 4250 Mountain View Dr, Phoenix, AZ, 85086 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20775 | PRV | Terry Elliott | 1980-07-19 | UHC-19456-25 | 6812696009 | 610 Oak St, Dallas, TX, 75226 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20759 | PRV | Amy Montgomery | 1969-05-19 | — | 9546973499 | 375 Mesa Dr, Phoenix, AZ | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22234 | PRV | Larry Ortega | 1967-02-18 | — | 8462904302 | 2939 Sage Ct, Plano, TX, 75014 | 0.62 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more |
| PRV-28705 | PRV | Joseph Brooks | 1949-02-20 | UHC-78973-47 | 4986566407 | 4944 Lake View Rd, Tampa, FL, 33658 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-28166 | PRV | Jacqueline Young | 1991-01-01 | — | 4195696266 | 5721 Valley View Dr, Gilbert, AZ, 85223 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27210 | PRV | Wei H Sanders | 1961-05-27 | UHC-34725-21 | 8345113721 | 1824 Broadway, Jacksonville, FL | 0.62 | Date of birth reformattedCity re-casedZIP missingGender normalised+3 more |
| PRV-23873 | PRV | Keith Smith | 1997-05-06 | UHC-42383-68 | 4134845736 | 8139 Washington St, Jacksonville, FL, 32275 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-23819 | PRV | Steven C Carlson | 1961-09-04 | UHC-37154-70 | 4694722563 | 4558 Harbor Blvd, Houston, TX, 77065 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21793 | PRV | Jacqueline U Payne | 1952-08-12 | — | 7664821145 | 8478 Sunset Blvd, Plano, TX | 0.62 | Date of birth reformattedPhone reformattedCity re-casedZIP missing+3 more |
| PRV-23207 | PRV | Aln Morgan | 1976-06-02 | — | 2845116754 | 9755 Elm St, Glendale, AZ, 85398 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22840 | PRV | Hannah Riley | 1964-12-11 | — | 8008131959 | 2847 Sage Ct Apt 7, Houston, TX, 77074 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-21871 | PRV | Marcus Turner | 1974-12-07 | — | 6646179546 | 5655 Bayshore Dr, Columbus, OH, 43262 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28965 | PRV | Diane R Schultz | 1948-08-24 | UHC-38918-12 | 4099193242 | 7348 Bayshore Dr, Columbus, OH, 43211 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| PRV-29214 | PRV | Ana Wilson | — | — | 9572687427 | 6492 Jefferson Ave, Chandler, AZ, 85258 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| PRV-25930 | PRV | Dorothy Alvarado | 1954-03-14 | — | 8917234380 | 6812 Park Pl, Jacksonville, FL, 32212 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21699 | PRV | Jacob Sullivan | 2008-05-24 | — | — | 1349 Ocean Ave, Scottsdale, AZ, 85292 | 0.62 | Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more |
| PRV-25092 | PRV | Austin Hayes | 1955-04-20 | UHC-88677-05 | 7272455654 | 8554 Oak St, Jacksonville, FL, 32285 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20188 | PRV | Brian Cole | — | — | 8247148547 | 8635 Market St Apt 13, Miami, FL, 33182 | 0.62 | Name re-casedDate of birth missingPhone reformattedUnit split from street+3 more |
| PRV-26823 | PRV | Megan Rios | — | UHC-47867-27 | 8323654987 | 9068 Central Ave, Atlanta, GA, 30361 | 0.62 | Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more |
| PRV-28532 | PRV | Fatima X Duncan | 2001-09-26 | — | 5236513541 | 2074 Cedar Ln, Los Angeles, CA, 90070 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25583 | PRV | Alice Jackson | 1968-01-20 | UHC-04889-09 | 4414694338 | 3218 Elm St, Denver, CO, 80247 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23826 | PRV | Sarah McCoy | 1955-12-01 | UHC-25246-54 | 3554600160 | 7068 Pine Dr Apt 32, Phoenix, AZ, 85057 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-22801 | PRV | Aisha Stephens | 1996-04-17 | — | 7065044094 | 2778 Valley View Dr, Minneapolis, MN | 0.62 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more |
| PRV-27927 | PRV | Jose Mendez | 1975-02-15 | — | 6693119260 | 2541 Canyon Rd, Orlando, FL, 32862 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20135 | PRV | Paul L Gutierrez | 1939-11-28 | UHC-28321-70 | 6632701366 | 167 Main St, Plano, TX, 75032 | 0.62 | Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23884 | PRV | Jerry Sandoval | 1996-07-10 | UHC-15546-21 | 6985390081 | 5046 Maple Ave, Minneapolis, MN, 55429 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-24233 | PRV | Margaret U Vazquez | 1999-05-22 | UHC-51429-18 | — | 5357 Central Ave, San Antonio, TX, 78296 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-24738 | PRV | Marilyn L Walker | 1999-12-09 | — | 5236517965 | 721 River Rd, Minneapolis, MN, 55443 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-21082 | PRV | Catherine Richardson | 2005-08-26 | UHC-15592-78 | 8617857017 | 2274 Church St, Scottsdale, AZ, 85238 | 0.62 | Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more |
| PRV-27870 | PRV | Charlotte X Jordan | 1983-07-23 | UHC-36937-84 | 7169515293 | 4790 Bayshore Dr, San Diego, CA | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20644 | PRV | Bradley Anderson | 1976-07-24 | — | 4063021271 | 5819 Forest Ave, Las Vegas, NV | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more |
| PRV-22316 | PRV | Christopher Santos | 1995-05-06 | UHC-66123-93 | — | 609 Spring St, Eden Prairie, MN, 55332 | 0.62 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27671 | PRV | Reed T Cheryl | 1984-06-12 | — | — | 984 Meadow Ln, Nashville, TN, 37207 | 0.62 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29092 | PRV | Stephanie Lopez | 1943-10-18 | UHC-95228-95 | 6445980421 | 1921 Washington St, Gilbert, AZ, 85201 | 0.62 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-21454 | PRV | Camila Murphy | 1977-05-27 | — | 7648076360 | 7655 Forest Ave, Scottsdale, AZ, 85253 | 0.62 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-20844 | PRV | Carol Snyder | 1966-06-27 | — | — | 6212 Baseline Rd, Las Vegas, NV, 89100 | 0.62 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| PRV-25814 | PRV | Lawrence P Harvey | 1948-01-13 | — | 3252292733 | 455 Canyon Rd, Los Angeles, CA, 90051 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27467 | PRV | Jean Long | 1952-07-08 | — | 2228756796 | 6765 Spring St, Mesa, AZ, 85238 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27466 | PRV | Jean Long | 1952-07-08 | — | 2228756796 | 6765 Spring St, Mesa, AZ, 85238 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22335 | PRV | Kathleen Powell | 1958-08-22 | — | 3483706554 | 930 Forest Ave, San Diego, CA, 92199 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28130 | PRV | Melissa V Simmons | 1993-10-05 | UHC-31521-24 | 3114715238 | 3474 Sage Ct, Atlanta, GA, 30381 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24353 | PRV | Gregory Palmer | 1986-02-26 | UHC-33450-51 | 3146198561 | 8004 Church St, Scottsdale, AZ, 85256 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-21671 | PRV | Anthony Fox | 1958-07-09 | — | 9792049229 | 3622 Desert Sky Blvd, Eden Prairie, MN | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25835 | PRV | Sharon Weber | 2006-09-08 | UHC-02965-50 | 4403387593 | 6745 Apache Blvd, San Diego, CA, 92173 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25834 | PRV | Sharon Weber | 2006-09-08 | UHC-02965-50 | 4403387593 | 6745 Apache Blvd, San Diego, CA, 92173 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22880 | PRV | Jessica Fox | 1991-05-08 | UHC-31731-49 | 4932291787 | 2148 Apache Blvd, Jacksonville, FL, 32241 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23208 | PRV | Alan Morgan | 1976-06-02 | UHC-68605-81 | 2845116754 | 9755 Elm St, Glendale, AZ, 85398 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26492 | PRV | Christina Graham | 2000-01-21 | UHC-41760-03 | 7554538929 | 6748 Camelback Rd, Jacksonville, FL, 32250 | 0.62 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |