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-21333 | PRV | Sophia Howell | 1997-04-28 | — | 4924674792 | 2377 Apache Blvd, San Diego, CA, 92144 | 0.78 | Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-25217 | PRV | Olivia Owes | 1991-09-11 | — | 9415262112 | 275 Oak St, Jacksonville, FL, 32248 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24375 | PRV | Stephen Ncihols | 1945-05-04 | UHC-56677-05 | 9552539607 | 3615 Sunset Blvd, Los Angeles, CA, 90038 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26381 | PRV | Gerald G Lucas | 1969-11-12 | — | 5664143598 | 9328 Ocean Ave, Columbus, OH, 43234 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27312 | PRV | Mei N Tucker | 1974-09-28 | UHC-96295-40 | 7514722370 | 5805 Market St, Atlanta, GA, 30300 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23551 | PRV | Alice Porter | 1989-06-20 | UHC-37723-15 | — | 1574 River Rd, Jacksonville, FL | 0.78 | Name re-casedDate of birth reformattedState code upper-casedZIP missing+1 more |
| PRV-26701 | PRV | Emily Harper | 1972-02-15 | — | 5724563674 | 5798 Valley View Dr, San Diego, CA, 92124 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26954 | PRV | Steven Hunt | 1959-08-22 | — | 3426914413 | 2211 Willow Ct, Charlotte, NC, 28208 | 0.78 | Name re-casedDate of birth reformattedCity re-casedGender normalised+1 more |
| PRV-26184 | PRV | Alexander F Ellis | 1979-08-14 | — | 7955709797 | 219 Lincoln Way, Denver, CO, 80234 | 0.78 | Date of birth reformattedCity re-casedZIP+4 trimmedEmail lower-cased+1 more |
| PRV-25916 | PRV | Raymond Ortiz | 1965-04-04 | — | 8676294665 | 9314 Hillcrest Rd, Fresno, CA, 93776 | 0.78 | Name re-casedDate of birth reformattedSSN last four extractedWhitespace trimmed+1 more |
| PRV-27822 | PRV | Kimberly Banks | 1973-08-14 | UHC-47323-56 | 2288029057 | 1608 Pine Dr, Miami, FL, 33145 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28458 | PRV | Jose B Long | 1972-08-05 | UHC-18259-67 | 4684573172 | 8334 Canyon Rd, Nashville, TN, 37269 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-20594 | PRV | Raymond Hall | 1978-08-11 | UHC-66052-13 | 8547646325 | 3690 Elm St, San Antonio, TX, 78298 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27141 | PRV | Julie Arnold | 1981-09-06 | UHC-68011-71 | 6902193859 | 9290 Oak St, Tempe, AZ, 85261 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25600 | PRV | Young Carlos | 1958-03-14 | UHC-22068-37 | 7564710943 | 8579 Spring St, Tampa, FL, 33678 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22329 | PRV | Marilyn Hunt | 2000-04-25 | UHC-87899-87 | — | 2638 Indian School Rd, Nashville, TN, 37286 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21685 | PRV | Christina K Washington | 1957-03-02 | — | 4935563798 | 6381 Palm Dr, Las Vegas, NV, 89126 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-20682 | PRV | Arthur Mills | 1986-10-20 | UHC-01562-20 | 7347440962 | 9837 Jefferson Ave, Atlanta, GA, 30303 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23620 | PRV | Lauren A Sims | 2007-05-19 | UHC-90640-63 | 8537240105 | 8513 Lincoln Way, Atlanta, GA, 30306 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-21318 | PRV | Russell Elliott | 2002-09-26 | — | 7635165615 | 8498 Camelback Rd, San Diego, CA, 92156 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27646 | PRV | Karen E Romero | 1986-03-19 | — | 6014145517 | 6696 Spring St, Denver, CO, 80276 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+1 more |
| PRV-20534 | PRV | David Turner | 1940-04-17 | UHC-15533-67 | 7333995098 | 9519 Jefferson Ave, Charlotte, NC, 28209 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22445 | PRV | Russell Meyer | 1974-02-15 | — | 9374545520 | 9097 Elm St, Austin, TX, 78738 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24796 | PRV | Brittany Bennett | 1976-03-01 | UHC-13990-39 | 2598768170 | 8266 Central Ave, Gilbert, AZ, 85298 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+1 more |
| PRV-27031 | PRV | Nunez Omar | 1982-10-16 | UHC-16297-37 | 9632593298 | 518 Baseline Rd, Mesa, AZ, 85227 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24709 | PRV | Diego Lane | 1943-06-06 | — | 6715745117 | 1277 Baseline Rd, San Diego, CA, 92186 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24064 | PRV | Mariana Santiago | 2007-11-22 | UHC-36282-56 | 5317807023 | 4386 Jefferson Ave, Tucson, AZ, 85737 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25234 | PRV | Cynthia Ford | 1986-06-11 | — | — | 3753 Lincoln Way, Fresno, CA, 93791 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28659 | PRV | Betty Murray | 1986-04-20 | UHC-79482-59 | 5942915107 | 6683 Market St, Columbus, OH, 43273 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-25192 | PRV | Jose Ryan | 1948-06-08 | — | 7073531374 | 5976 Market St, Gilbert, AZ, 85281 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-23555 | PRV | Ralph Salazar | 1996-04-23 | — | 9403806927 | 1632 Pine Dr, Glendale, AZ, 85335 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21411 | PRV | Ryan T Rose | 1940-10-15 | UHC-20347-39 | 5939827627 | 3781 Lake View Rd, Nashville, TN, 37221 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25209 | PRV | Fatima Daniels | 2007-06-08 | UHC-51636-63 | 6599382100 | 500 Desert Sky Blvd, Plano, TX, 75014 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23774 | PRV | Alexis I Willis | 1980-05-20 | — | 3188242364 | 2662 Valley View Dr, Tempe, AZ, 85267 | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-28695 | PRV | Gabriel Howell | 1943-02-05 | UHC-87332-44 | 5866676679 | 2866 Harbor Blvd, Seattle, WA, 98157 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23575 | PRV | Bobby Schultz | 1958-07-18 | UHC-06876-95 | 2563073168 | 1371 Maple Ave, Seattle, WA, 98198 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-20997 | PRV | Luis Richars | 1961-02-26 | — | — | 810 Jefferson Ave, Orlando, FL, 32859 | 0.78 | Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more |
| PRV-28622 | PRV | Mason Walsh | 1973-11-18 | UHC-13566-73 | — | 3634 Meadow Ln, San Antonio, TX, 78263 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21932 | PRV | Heather Hawkins | 1940-09-04 | — | 7528600942 | 4643 Apache Blvd, Tempe, AZ, 85234 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more |
| PRV-22649 | PRV | Megan Bradley | 1967-01-09 | UHC-27109-52 | 3104679452 | 251 Grand Ave, Fresno, CA, 93769 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24600 | PRV | Ray R Priya | 1962-05-28 | — | — | 7268 Cedar Ln, Gilbert, AZ, 85287 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-27198 | PRV | Charles C Reynolds | 1961-09-26 | UHC-64561-81 | — | 6382 Apache Blvd, Orlando, FL, 32824 | 0.78 | Name re-casedCity re-casedState name converted to codeWhitespace trimmed+1 more |
| PRV-22855 | PRV | Santiago Munoz | 2005-03-19 | UHC-00179-07 | 3053367010 | 6165 Palm Dr, Chandler, AZ, 85262 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24863 | PRV | Theresa Gutierrez | 1996-02-01 | — | 8984441622 | 2091 Harbor Blvd, Minneapolis, MN, 55445 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22474 | PRV | Aisha H Scott | 1950-09-05 | UHC-97838-17 | 9789081586 | 8705 Ridge Rd, Orlando, FL, 32885 | 0.78 | Name re-casedPhone reformattedCity re-casedGender normalised+1 more |
| PRV-29553 | PRV | Isabella Gonzales | 1983-10-21 | — | 3885238477 | 4192 Apache Blvd, Fresno, CA, 93704 | 0.78 | Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-29181 | PRV | Mark Edwards | 1956-10-11 | UHC-45206-33 | — | 7708 Highland Ave, Eden Prairie, MN, 55339 | 0.78 | Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-20618 | PRV | Valentina H Cunningham | 1949-12-02 | — | 6748773395 | 5317 Mesa Dr, Atlanta, GA | 0.78 | Name re-casedDate of birth reformattedPhone reformattedZIP missing+1 more |
| PRV-26029 | PRV | Theresa Green | 1989-06-17 | — | — | 3471 Hillcrest Rd, Chandler, AZ, 85238 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-22199 | PRV | Patricia Hayes | 2000-07-03 | — | 9128890503 | 5615 Grand Ave, Jacksonville, FL, 32275 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |