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-24806 | PRV | Gloria Miller | 1988-09-11 | — | 3153675577 | 7263 Cedar Ln, Columbus, OH, 43288 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28050 | PRV | Maria W Munoz | 1966-03-01 | — | 5747756207 | 8893 Sage Ct, Minneapolis, MN, 55424 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25439 | PRV | Bobby Wright | 1995-04-03 | — | — | 8097 Central Ave, Eden Prairie, MN, 55323 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22309 | PRV | Scott X Long | 2005-01-19 | — | 3365227421 | 333 Pine Dr, San Diego, CA, 92132 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26225 | PRV | Ethan T Bowman | 1986-05-20 | — | 6579669526 | 1390 Mesa Dr, San Diego, CA, 92126 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-20549 | PRV | Ana Garcia | 2003-05-13 | — | — | 7115 Ocean Ave, Denver, CO, 80252 | 0.76 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-27811 | PRV | Ahmed J Hoffman | 1987-02-08 | — | 7696889136 | 7858 Spring St, Gilbert, AZ, 85296 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-28428 | PRV | Michael Rios | 1961-08-23 | — | 2537291705 | 9120 Lake View Rd, Los Angeles, CA, 90097 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23994 | PRV | Henry Dean | 1970-09-10 | — | 6778814211 | 2175 Jefferson Ave, Glendale, AZ, 85347 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-23993 | PRV | Henry Dean | 1970-09-10 | — | 6778814211 | 2175 Jefferson Ave, Glendale, AZ, 85347 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-26275 | PRV | Douglas Padilla | 1983-05-27 | UHC-70673-95 | 6709213908 | 6987 Park Pl, Atlanta, GA, 30312 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25515 | PRV | Sofia Mendozza | 1974-07-26 | — | 6813668192 | 527 Union St, Scottsdale, AZ, 85233 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28568 | PRV | Theresa Stephens | 1963-10-20 | — | 8785544791 | 5288 Market St, Tempe, AZ, 85225 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-20750 | PRV | Megan Wells | 1981-11-20 | UHC-49630-57 | 4495837635 | 3063 Desert Sky Blvd, Tampa, FL, 33660 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27909 | PRV | Susan Morrison | 1959-02-28 | — | 8742334613 | 2746 Apache Blvd, Denver, CO, 80252 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-21196 | PRV | Arjun Stephens | 1978-12-06 | — | 3999441594 | 7955 Mesa Dr, Austin, TX, 78710 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21459 | PRV | Timothy Lopez | 1945-01-15 | — | 5136726619 | 9308 Meadow Ln, Nashville, TN, 37271 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-26185 | PRV | Russell G Bell | 2006-04-02 | — | 2987968758 | 2688 Jefferson Ave, Atlanta, GA, 30380 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26646 | PRV | Meriana Rios | 1962-04-19 | UHC-75754-51 | 8695158736 | 9238 Washington St, Orlando, FL, 32816 | 0.76 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-28205 | PRV | Beverly Williams | 1987-03-25 | — | 3174966872 | 3490 Cedar Ln, Phoenix, AZ, 85066 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26031 | PRV | Samuel Green | 2005-09-27 | — | 6314528134 | 44 Sage Ct, San Diego, CA, 92153 | 0.76 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-21256 | PRV | Sanchez V Dennis | 1955-05-06 | — | 9878442270 | 5141 Mesa Dr, Orlando, FL, 32849 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25222 | PRV | Carolyn Campbell | 1950-02-15 | — | 8255973022 | 7292 Broadway, Denver, CO, 80244 | 0.76 | Name split from “Last, First”Phone reformattedAddress re-casedCity re-cased+2 more |
| PRV-26532 | PRV | Beverly R Vega | 1973-12-09 | UHC-03703-82 | 8205195728 | 1150 Pine Dr, Glendale, AZ, 85350 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24519 | PRV | Jerry Foster | 2005-12-20 | — | 2649135799 | 1403 Ridge Rd, San Antonio, TX, 78278 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26446 | PRV | Maria Delgado | 1987-03-02 | UHC-94171-32 | 3368181307 | 5393 Grand Ave, Los Angeles, CA, 90026 | 0.76 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-26624 | PRV | Frank Fernandez | 1960-04-04 | UHC-46561-13 | 8743006582 | 6763 Mesa Dr, Glendale, AZ, 85323 | 0.76 | Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25006 | PRV | Kayla Ellis | 1953-06-22 | — | 6007909574 | 3107 Union St, Atlanta, GA, 30353 | 0.76 | Date of birth reformattedPhone reformattedCity re-casedGender normalised+2 more |
| PRV-27180 | PRV | Billy M Burns | 1994-09-28 | — | 6327330132 | 1909 River Rd, Columbus, OH, 43251 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28599 | PRV | Raymond Richards | 1962-10-21 | UHC-30938-76 | 5183840984 | 4610 Union St, Charlotte, NC, 28270 | 0.76 | Date of birth reformattedPhone reformattedEmail lower-casedGender normalised+2 more |
| PRV-29341 | PRV | Alexis Reed | 1955-03-05 | UHC-79076-73 | 2516881975 | 5473 Canyon Rd, Minneapolis, MN, 55426 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28438 | PRV | Joyce T Johnson | 1994-08-04 | — | 2222822911 | 1785 Ridge Rd, Scottsdale, AZ, 85209 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23042 | PRV | Yuki Powell | 1971-05-24 | — | 8512237099 | 402 Lincoln Way, Glendale, AZ, 85390 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21767 | PRV | Julie Obrien | 1980-03-21 | — | 7799567668 | 4488 Washington St, Charlotte, NC, 28283 | 0.76 | Name split from “Last, First”Name re-casedDate of birth reformattedPhone reformatted+2 more |
| PRV-28102 | PRV | Raymnd Phillips | 1995-01-28 | — | 4037341297 | 1479 Baseline Rd, Glendale, AZ, 85314 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28763 | PRV | Aisha H King | 1981-07-14 | UHC-01605-28 | 4604334400 | 2857 Lincoln Way, Chandler, AZ, 85208 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-26725 | PRV | Julie Banks | 1988-03-13 | UHC-67292-12 | 9616571052 | 2818 River Rd, Minneapolis, MN, 55419 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27245 | PRV | Dylan Welch | 1956-07-05 | UHC-40221-33 | 6029260546 | 5659 Ocean Ave, San Diego, CA, 92115 | 0.76 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21019 | PRV | Joyce Carroll | 1974-03-15 | UHC-18329-37 | 7862004060 | 2079 Indian School Rd, Houston, TX, 77060 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20077 | PRV | Harper Adam | 1994-06-26 | — | 4604830028 | 3915 Maple Ave, Jacksonville, FL, 32279 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21156 | PRV | Alexander F Berry | 1967-05-21 | UHC-08426-20 | 3816504355 | 806 Apache Blvd, Los Angeles, CA, 90048 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20595 | PRV | Vincent Jimenez | 1996-10-21 | UHC-80139-49 | 8059850483 | 6632 Sage Ct, Mesa, AZ, 85202 | 0.76 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23530 | PRV | Jushua Romero | 1947-12-22 | UHC-88354-80 | 6262412754 | 8508 Harbor Blvd, Sacramento, CA, 95878 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27311 | PRV | Ana Mendez | 2008-07-28 | UHC-82946-68 | 9752844269 | 5210 Jefferson Ave, Columbus, OH, 43294 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25506 | PRV | George Z Li | 1955-11-01 | — | 6522542957 | 9770 Jefferson Ave, Atlanta, GA, 30349 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-25672 | PRV | Arthur Morrison | 1988-09-03 | UHC-75672-61 | 3417974398 | 3735 Meadow Ln, Miami, FL, 33105 | 0.76 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-24702 | PRV | Aaron T Simpson | 2005-05-22 | UHC-21933-26 | 6439817281 | 659 Washington St, Miami, FL, 33175 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28808 | PRV | Jean O Nelson | 1987-09-12 | — | 4947311148 | 5776 Ridge Rd, Charlotte, NC, 28236 | 0.76 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-28319 | PRV | Michael Nunez | 1991-12-07 | UHC-34718-24 | 3704988608 | — | 0.76 | Date of birth reformattedPhone reformattedGender normalisedPlan code upper-cased+2 more |
| PRV-24993 | PRV | Waltre Cole | 1946-03-19 | UHC-18104-33 | 2673831887 | 6107 Palm Dr, Atlanta, GA, 30382 | 0.76 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |