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-20007 | PRV | Nancy Campbell | 1991-05-20 | — | 7332381159 | 3517 Baseline Rd, Jacksonville, FL, 32266 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-25409 | PRV | Mariana V Fowler | 1986-11-05 | UHC-92162-53 | 3238211928 | 6958 Mountain View Dr, Scottsdale, AZ | 0.60 | Name re-casedPhone reformattedMember ID reformattedCity re-cased+4 more |
| PRV-26202 | PRV | Gregory Walker | 1959-11-26 | UHC-01696-10 | 4745571305 | 6576 Oak St, Glendale, AZ, 85333 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| PRV-21963 | PRV | Keith Dixon | 2004-11-24 | — | 2945856444 | 8405 Meadow Ln, Las Vegas, NV, 89176 | 0.60 | Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more |
| PRV-24984 | PRV | Kathy Howard | 1986-01-21 | — | 7907765295 | 3370 Oak St, Houston, TX | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24599 | PRV | Ray R Prriya | 1962-05-28 | — | 9709037558 | 7268 Cedar Ln, Gilbert, AZ, 85287 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-20756 | PRV | Sofia B Li | 1948-12-18 | — | 3213585049 | 1674 Ridge Rd, Jacksonville, FL, 32294 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-25102 | PRV | Kathryn L Burke | 1952-10-06 | UHC-37727-05 | 8855054340 | 5009 Grand Ave # 402, Glendale, AZ, 85394 | 0.60 | Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more |
| PRV-26625 | PRV | Amanda Alexander | 1938-02-27 | UHC-10695-82 | 9336832337 | 879 Sunset Blvd, Houston, TX | 0.60 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26174 | PRV | Patrick Henderson | 1968-09-17 | UHC-63091-04 | 7089560937 | 5981 Park Pl, Tampa, FL | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-23612 | PRV | Marrcus Stephens | 1983-05-18 | — | 8114622134 | 3957 Sage Ct Apt 22, Eden Prairie, MN, 55338 | 0.60 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more |
| PRV-20684 | PRV | Frank Leewis | 1956-08-06 | UHC-19885-12 | 4966259234 | 5170 Harbor Blvd, Glendale, AZ | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-22697 | PRV | Arjun Mason | 1976-04-14 | — | 3294134279 | 9507 Meadow Ln, Las Vegas, NV, 89152 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| PRV-29334 | PRV | Sean Watson | 1998-06-23 | UHC-89921-87 | 9307044332 | 9192 Apache Blvd, Columbus, OH, 43218 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-29298 | PRV | WJunk | 1989-03-17 | UHC-21985-17 | 8814692770 | 8197 Mesa Dr, Tempe, AZ, 85263 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-24311 | PRV | Alexander C Washington | 1959-07-09 | — | 2614249268 | 5736 River Rd, San Antonio, TX, 78247 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-22973 | PRV | Dylan F Wheeler | 2000-01-26 | UHC-34756-24 | 7058103344 | 5635 Palm Dr, Eden Prairie, MN, 55303 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-25980 | PRV | Grace Shaw | 1961-11-20 | UHC-49338-06 | 3388619459 | 3793 Market St, Seattle, WA, 98139 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-26173 | PRV | Willie S Park | 1944-02-21 | UHC-43463-73 | 2909473765 | 3730 Elm St, Denver, CO, 80249 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-29352 | PRV | Ralph R Andrews | 1985-06-10 | — | — | 3086 Desert Sky Blvd, Fresno, CA, 93728 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26221 | PRV | Jeremy Garcia | 1967-05-14 | UHC-83726-54 | 6663163964 | 5842 Forest Ave, Sacramento, CA, 95862 | 0.60 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-22694 | PRV | Dick Mendez | 1960-12-03 | — | 7587854571 | 2643 Desert Sky Blvd Apt 33, Gilbert, AZ, 85235 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| PRV-27907 | PRV | Philip Thomas | 1993-02-09 | UHC-59106-02 | 9676717345 | 4175 Apache Blvd, Orlando, FL, 32868 | 0.60 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-21516 | PRV | Thomas Boyd | 1984-09-28 | — | 4789265496 | 7546 Sunset Blvd, Sacramento, CA, 95883 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24092 | PRV | Kayla P Patel | 1964-09-08 | UHC-00656-58 | 4189011716 | 4595 Bayshore Dr, Tampa, FL | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-25197 | PRV | Billy Weaver | 1975-06-25 | UHC-25544-03 | 7517946640 | 2855 Bayshore Dr, Scottsdale, AZ, 85267 | 0.60 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more |
| PRV-23695 | PRV | Ralph Jenkins | 2001-12-18 | UHC-92101-65 | 5222883803 | 525 Sage Ct # 882, Fresno, CA, 93709 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| PRV-27169 | PRV | Sofia Patel | 2000-03-25 | — | 2619156113 | 5736 Ocean Ave # 100, Chandler, AZ, 85298 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| PRV-21812 | PRV | Kathryn Ramirez | 1944-05-02 | — | 8616212548 | 9294 Park Pl, Gilbert, AZ, 85281 | 0.60 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-27675 | PRV | —Junk | 1969-05-14 | — | 7488000987 | 4195 Ocean Ave, Denver, CO, 80281 | 0.60 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more |
| PRV-20199 | PRV | Arjun Lucas | 1993-03-09 | UHC-83630-69 | 2897502616 | 7452 Indian School Rd, Nashville, TN, 37237 | 0.60 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-24757 | PRV | Melissa Rodriguez | 1943-03-11 | UHC-87826-91 | 6044501001 | 2585 Ocean Ave, Charlotte, NC, 28287 | 0.60 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-24932 | PRV | Charlotte White | — | UHC-56376-07 | — | 4157 Mountain View Dr, Miami, FL, 33198 | 0.60 | Name re-casedDate of birth missingMember ID reformattedStreet suffix standardised+4 more |
| PRV-22160 | PRV | Seven Vasquez | 1957-06-27 | UHC-60190-71 | 2184048209 | 6946 Meadow Ln, Orlando, FL, 32826 | 0.60 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-27081 | PRV | Grace W Cooper | 1975-11-17 | — | 3647852882 | 5629 Palm Dr, Glendale, AZ, 85321 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-21375 | PRV | Lisa Jimenez | 1985-04-16 | UHC-89522-53 | 4492953475 | 8398 Indian School Rd, Los Angeles, CA, 90009 | 0.60 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-23010 | PRV | Sophia Jenkins | 1964-12-06 | UHC-20692-63 | 9223981116 | 1597 Bayshore Dr # 231, Miami, FL, 33141 | 0.60 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more |
| PRV-22989 | PRV | Charles Garza | 1956-06-28 | — | 4629683657 | 4858 Indian School Rd, San Diego, CA, 92125 | 0.60 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-24324 | PRV | Nathan Watkins | 1982-09-26 | UHC-78419-09 | 8563790874 | 7109 Central Ave, Phoenix, AZ, 85034 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21292 | PRV | Bryan N Freeman | 1951-11-21 | — | 7866862770 | 7670 Valley View Dr, Plano, TX, 75079 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26432 | PRV | Teresa D Simpson | 1957-04-18 | UHC-58968-10 | 5189591430 | 1259 Mountain View Dr, Orlando, FL, 32820 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27606 | PRV | Luis Willis | 1981-11-19 | UHC-03152-84 | 4072630254 | 8903 Desert Sky Blvd, Denver, CO, 80210 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-23626 | PRV | Jason E Gutirerez | 1971-06-19 | UHC-26533-02 | 3714187582 | 4563 Mesa Dr, Glendale, AZ, 85302 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more |
| PRV-27703 | PRV | Patricia Thompson | 1945-12-24 | UHC-18570-72 | 6438668849 | 2201 Desert Sky Blvd, Jacksonville, FL, 32245 | 0.62 | Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-27637 | PRV | Christopher C Thomas | 2003-09-08 | — | 3424954941 | 2590 Ocean Ave, Chandler, AZ, 85296 | 0.62 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more |
| PRV-21733 | PRV | James M Hamilton | 1994-09-27 | — | 4663256249 | 2485 Mountain View Dr, Los Angeles, CA | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27304 | PRV | Joshua Morales | 1994-08-01 | — | 7135402824 | 9767 Sunset Blvd # 107, Phoenix, AZ, 85004 | 0.62 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more |
| PRV-28000 | PRV | Charlotte Q Sullivan | 1954-08-24 | UHC-97098-75 | 9856593353 | 1460 Willow Ct, Austin, TX, 78770 | 0.62 | Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-28595 | PRV | Ann Sims | 1992-02-16 | UHC-84909-39 | 4029507313 | 2701 Pine Dr # 847, Gilbert, AZ, 85233 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-27457 | PRV | Julia Ryan | 1988-04-08 | — | 7123874597 | 2161 Hillcrest Rd, Sacramento, CA, 95881 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |