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-24472 | PRV | Frank Nelson | 1997-09-14 | UHC-41067-77 | 7286510565 | 9185 Elm St, Chandler, AZ, 85222 | 0.76 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-20246 | PRV | Roy G Fisher | 1967-07-02 | — | — | 323 Baseline Rd, Tampa, FL, 33699 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22630 | PRV | Juan Powell | 1975-01-22 | — | 4517712270 | 1179 Bayshore Dr, Los Angeles, CA, 90058 | 0.76 | Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+2 more |
| PRV-24676 | PRV | Diaz Joe | 2001-03-25 | UHC-07594-37 | 6016201229 | 3111 Maple Ave, Glendale, AZ, 85353 | 0.76 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-28883 | PRV | Theresa M Munoz | 1962-04-06 | — | 8933039828 | 2470 Camelback Rd, Atlanta, GA, 30364 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21279 | PRV | Kelly G Baker | 2006-08-28 | UHC-48249-92 | 2786859756 | 4218 Sunset Blvd, San Diego, CA | 0.76 | Date of birth reformattedPhone reformattedCity re-casedZIP missing+2 more |
| PRV-26439 | PRV | Billy Hamilton | 1962-12-26 | UHC-77514-16 | 5469013469 | 2692 Meadow Ln, Phoenix, AZ, 85025 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21619 | PRV | Raymond U Burns | 1943-08-03 | — | 4703169493 | 2658 Hillcrest Rd, Austin, TX, 78700 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21480 | PRV | Diane Knight | 1942-11-18 | UHC-54183-65 | 2424683030 | 2976 Market St, Tucson, AZ, 85760 | 0.76 | Date of birth reformattedPhone reformattedCity re-casedGender normalised+2 more |
| PRV-21397 | PRV | Nicole K Ortega | 2005-09-13 | — | — | 376 Baseline Rd, Chandler, AZ, 85283 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-26928 | PRV | Joe Salazar | 1994-01-16 | UHC-89970-58 | 8732759175 | 2559 Mountain View Dr, Dallas, TX, 75260 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26960 | PRV | Laarry Cox | 1983-06-01 | UHC-25922-95 | 9553706658 | 4973 Grand Ave, Tampa, FL, 33619 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26266 | PRV | Jordan Carroll | 1963-04-26 | UHC-34809-76 | 8036358972 | 7063 Sage Ct, Tucson, AZ, 85714 | 0.76 | Member ID reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-24965 | PRV | Danielle Garza | 1978-11-07 | — | 9648631091 | 2118 Desert Sky Blvd, Charlotte, NC, 28241 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more |
| PRV-22503 | PRV | Brandon V Rose | 1970-04-09 | — | 9489835891 | 202 Ridge Rd, Seattle, WA, 98103 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26599 | PRV | Dorothy Richards | 1979-02-07 | — | 8163835314 | 4171 Spring St, Scottsdale, AZ, 85253 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21877 | PRV | Ruth U McCoy | 2001-01-03 | — | 5822604573 | 1090 Maple Ave, San Antonio, TX, 78253 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-28335 | PRV | Patricia Rodriguez | 1970-07-28 | — | — | 8202 Willow Ct, Gilbert, AZ, 85200 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-27974 | PRV | Kenneth Burton | 1950-06-10 | — | 2767546196 | 8977 Central Ave, Fresno, CA | 0.76 | Name re-casedPhone reformattedCity re-casedZIP missing+2 more |
| PRV-27857 | PRV | Julie Hunter | 1961-07-12 | — | — | 5231 Harbor Blvd, Miami, FL, 33196 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22297 | PRV | Charlotte Reyes | 1942-10-20 | UHC-26687-68 | 6242936807 | 2567 Canyon Rd, Charlotte, NC, 28296 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20876 | PRV | Gerald Cunningham | 1951-07-23 | UHC-47203-81 | 7875677578 | 3051 Washington St, Scottsdale, AZ, 85257 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-29089 | PRV | Theresa Yaang | 1991-04-03 | — | 3749490510 | 6217 Bayshore Dr, Plano, TX, 75085 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28192 | PRV | Denise S Little | 1975-11-22 | UHC-01972-71 | 7135072421 | 3747 Market St, Mesa, AZ, 85207 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-20304 | PRV | Brandon Duncan | 1940-09-27 | UHC-13760-68 | 7486564965 | 5044 Market St, Scottsdale, AZ, 85242 | 0.76 | Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+2 more |
| PRV-24697 | PRV | Judy Cox | 1985-03-11 | UHC-31243-27 | 7014580447 | 1767 Meadow Ln, Sacramento, CA, 95871 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28584 | PRV | Dennis Meyer | 1988-09-15 | — | 2874045819 | 9097 Spring St, Seattle, WA, 98166 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25307 | PRV | Mariana Ray | 1981-12-14 | — | 4435063290 | 5557 Hillcrest Rd, Minneapolis, MN, 55417 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28757 | PRV | Stephen R Freeman | 1991-10-18 | — | 4962753492 | 1765 Spring St, Atlanta, GA, 30398 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27820 | PRV | Steven Spencr | 1937-06-20 | — | 3259185673 | 7438 Cedar Ln, San Diego, CA, 92179 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22442 | PRV | Nathan Olson | 1977-08-18 | — | 8935064456 | 7553 Central Ave, Houston, TX, 77034 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-20640 | PRV | Catherine L Phillips | 1981-08-26 | UHC-13217-11 | 5992624121 | 8247 Desert Sky Blvd, Seattle, WA, 98164 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-27655 | PRV | Steven Edwards | 1943-10-14 | UHC-25642-74 | 6739835407 | 1488 Hillcrest Rd, San Diego, CA, 92172 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20994 | PRV | Sue Fuller | 1956-09-15 | — | 6545469134 | 1486 Main St, Tampa, FL, 33699 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26149 | PRV | Laura Mendoza | 2001-04-10 | UHC-72770-86 | — | 5539 Ocean Ave, Mesa, AZ, 85297 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27918 | PRV | Billy Mills | 1946-11-11 | — | — | 8661 Indian School Rd, Plano, TX, 75097 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21264 | PRV | Matthew White | 1973-02-19 | UHC-78331-45 | — | 8059 Valley View Dr, Gilbert, AZ, 85224 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-25527 | PRV | Bradley U Weaver | 1982-07-14 | UHC-09294-02 | 4022615401 | 7945 Grand Ave, Atlanta, GA, 30318 | 0.76 | Name re-casedDate of birth reformattedCity re-casedGender normalised+2 more |
| PRV-20079 | PRV | Arthur Torres | 1941-08-23 | UHC-50812-37 | 8169079232 | 5706 River Rd, Tucson, AZ, 85704 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more |
| PRV-26192 | PRV | Geerald T Larson | 1986-02-15 | — | 4435153502 | 8163 Valley View Dr, Atlanta, GA, 30381 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21486 | PRV | Dorothy Johnston | 1970-12-11 | UHC-64629-02 | — | 5559 Mountain View Dr, Houston, TX, 77072 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29087 | PRV | Karen Yeng | 1977-08-27 | UHC-84529-42 | 9749064192 | 1854 Elm St, Orlando, FL, 32873 | 0.76 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25468 | PRV | Martha J Gonzales | 1950-02-07 | UHC-87872-07 | 3638174099 | 8970 Spring St, Sacramento, CA, 95806 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26900 | PRV | Hiroshi A Greene | 1999-03-25 | — | 7598521273 | 2623 Maple Ave, Las Vegas, NV, 89176 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-24580 | PRV | Maria Vazquez | 1954-10-10 | — | 2385506675 | 6910 Jefferson Ave, Miami, FL, 33150 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-20738 | PRV | Bruce Myers | 1997-07-10 | — | 6239787690 | 162 Ridge Rd, San Antonio, TX, 78202 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-28322 | PRV | Bradley J Warren | 2005-07-23 | — | 5883727120 | 93 Valley View Dr, Atlanta, GA, 30385 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20186 | PRV | Emily Lewis | 1993-11-02 | UHC-88929-09 | 4795943555 | 8519 Willow Ct, Glendale, AZ, 85337 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+2 more |
| PRV-22134 | PRV | Carl S Knight | 1965-02-06 | UHC-18875-60 | 2162957397 | 6964 Main St, Charlotte, NC, 28295 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22541 | PRV | Susan Murphy | 1996-06-03 | — | 7576674321 | 1234 Broadway, Tempe, AZ | 0.76 | Date of birth reformattedPhone reformattedZIP missingEmail lower-cased+2 more |