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-24396 | PRV | Jimmy Gray | 1952-01-18 | — | 2823275553 | 5047 Union St, Charlotte, NC, 28266 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22340 | PRV | Alexis Burton | 1975-10-05 | UHC-80754-22 | — | 6768 Oak St, Dallas, TX, 75278 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28719 | PRV | Carolyyn Bennett | 1940-02-08 | UHC-56432-79 | 2295118147 | 8185 Lincoln Way, Houston, TX, 77073 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22062 | PRV | Ruth Weaver | 1986-01-08 | UHC-27012-03 | 3148644818 | 7988 Mesa Dr, San Antonio, TX, 78217 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21087 | PRV | Kyle Z Wong | 1953-12-09 | UHC-64030-81 | — | 1353 Lake View Rd, Mesa, AZ, 85242 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-25265 | PRV | Christina Howard | 1958-07-15 | — | 5656436864 | 5406 Main St, Columbus, OH, 43209 | 0.78 | Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-29187 | PRV | Wei Cooper | 1953-10-25 | UHC-84241-56 | 7056088883 | 5751 River Rd, Chandler, AZ, 85261 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27996 | PRV | Medina Billy | 1947-04-11 | — | 7316851904 | 3674 Canyon Rd, Gilbert, AZ, 85239 | 0.78 | Name re-casedState code upper-casedGender normalisedWhitespace trimmed+1 more |
| PRV-27086 | PRV | Jessica I Dean | 1966-03-14 | UHC-39196-24 | 5267489559 | 55 Desert Sky Blvd, San Diego, CA | 0.78 | Phone reformattedMember ID reformattedZIP missingWhitespace trimmed+1 more |
| PRV-25357 | PRV | Joshua S Chapman | 1975-07-02 | — | 8886973592 | — | 0.78 | Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-20559 | PRV | Terry Ruiz | 1973-02-25 | UHC-41911-95 | 7406985487 | 1220 Camelback Rd, Los Angeles, CA, 90053 | 0.78 | Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-21595 | PRV | Stephen D Fields | 1988-05-24 | — | 7257173083 | 3886 Cedar Ln, Charlotte, NC, 28264 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24146 | PRV | Lucia Banks | 1952-09-01 | — | — | 2860 Jefferson Ave, Chandler, AZ, 85277 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-26864 | PRV | Virginia Barnes | 2007-04-02 | — | 3827817215 | 6404 Sage Ct, Atlanta, GA, 30375 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-23938 | PRV | Ahmed Hayes | 1995-10-10 | UHC-59600-25 | 2407723846 | 1557 Baseline Rd, Fresno, CA, 93702 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28638 | PRV | Wayne Lucas | 1983-03-12 | — | 9708229486 | 7615 Indian School Rd, Fresno, CA, 93770 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22306 | PRV | Sandra Yang | 1961-10-20 | UHC-18320-22 | 3794997151 | 4320 Ridge Rd, Tampa, FL, 33693 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+1 more |
| PRV-23669 | PRV | Abigail Alexander | 1940-03-04 | UHC-74593-20 | — | 6190 Indian School Rd, Atlanta, GA, 30392 | 0.78 | Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more |
| PRV-27183 | PRV | Joe Bishop | 1988-10-18 | — | 5279154620 | 6422 Harbor Blvd, Nashville, TN, 37273 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28656 | PRV | Bruce Black | 1996-05-13 | — | 5085030697 | 1170 Cedar Ln, Seattle, WA, 98165 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-22385 | PRV | Diego Mason | 1987-05-07 | — | 4955427071 | 1960 Willow Ct, Houston, TX, 77038 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20875 | PRV | Christina U Meyer | 1955-03-22 | UHC-19804-16 | 7786279588 | 2100 Meadow Ln, Los Angeles, CA, 90039 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24999 | PRV | Julia Carpenter | 1939-09-16 | — | 8972660610 | 997 Baseline Rd, Mesa, AZ | 0.78 | Date of birth reformattedCity re-casedZIP missingWhitespace trimmed+1 more |
| PRV-20353 | PRV | John Hart | 1995-04-13 | — | 2114024386 | 3453 Apache Blvd, Nashville, TN, 37292 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-23816 | PRV | Logan Phillips | 1966-04-21 | — | 4609196479 | 3710 Mountain View Dr, Orlando, FL, 32851 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26690 | PRV | William Miller | 1998-08-23 | — | 4062911484 | 1812 Bayshore Dr, Eden Prairie, MN, 55378 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23363 | PRV | Melissa Coper | 1938-05-15 | UHC-12129-19 | 8885355416 | 2787 Broadway, Denver, CO, 80277 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-22075 | PRV | John Palmer | 1947-08-26 | — | 6617058209 | 9519 Oak St, Nashville, TN, 37229 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22858 | PRV | Priya Roberts | 1949-04-22 | UHC-42307-61 | 5755388631 | 7499 Market St # 608, Las Vegas, NV, 89101 | 0.78 | Name re-casedPhone reformattedUnit split from streetWhitespace trimmed+1 more |
| PRV-29450 | PRV | Arjn Kennedy | 1955-04-24 | UHC-46594-12 | 5762675777 | — | 0.78 | Name re-casedTwo-digit birth yearMember ID reformattedWhitespace trimmed+1 more |
| PRV-21752 | PRV | Heather Taylor | 1945-07-23 | — | 5308836062 | 753 Camelback Rd, Mesa, AZ, 85209 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27106 | PRV | Gerald Ellis | 1997-07-28 | UHC-40481-26 | — | 3286 Washington St, Phoenix, AZ, 85033 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more |
| PRV-28358 | PRV | Matthew P Rodriguez | 1955-09-11 | — | 6838754255 | 9408 Bayshore Dr, Minneapolis, MN, 55447 | 0.78 | Phone reformattedState code upper-casedGender normalisedWhitespace trimmed+1 more |
| PRV-28038 | PRV | Madison Reyes | 1946-04-18 | — | 3839294814 | 6130 Elm St, Orlando, FL, 32897 | 0.78 | Phone reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more |
| PRV-27239 | PRV | Phiilip Maldonado | 1995-01-07 | — | 2824773887 | 7707 Palm Dr, Tempe, AZ, 85228 | 0.78 | Phone reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more |
| PRV-20130 | PRV | Jseph Silva | 1979-05-07 | UHC-84565-25 | 7105982586 | 2092 Spring St, Mesa, AZ, 85285 | 0.78 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23199 | PRV | Johua Brown | 1974-08-18 | — | 5856525206 | 6299 Meadow Ln, Glendale, AZ, 85311 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23048 | PRV | Joyce Morrison | 2008-07-04 | UHC-87643-47 | 3208896267 | 2570 Lake View Rd, Nashville, TN, 37262 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+1 more |
| PRV-26267 | PRV | Natalie Contreras | 1994-03-21 | UHC-72727-37 | — | 2007 Highland Ave, Las Vegas, NV, 89196 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26712 | PRV | Patrick Armstrong | 1974-06-07 | UHC-97021-81 | 4893923571 | 9026 Willow Ct, Glendale, AZ, 85376 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-25140 | PRV | Jerry Ramos | 1974-10-07 | UHC-14545-99 | 3894092273 | 5136 Elm St, Sacramento, CA, 95880 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25843 | PRV | Dorothy Lawrence | 1966-04-11 | — | 4442115814 | 1167 Canyon Rd, Los Angeles, CA, 90087 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23434 | PRV | Robert Q Day | 1942-07-06 | — | 3034224257 | 5242 River Rd, Scottsdale, AZ, 85251 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22468 | PRV | Ana Q Allen | 1938-05-27 | UHC-40301-04 | 9216508923 | 94 Spring St, Miami, FL, 33168 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26695 | PRV | Billy Bradley | 1998-05-18 | UHC-31626-51 | 8413834471 | 2621 Palm Dr, Atlanta, GA, 30374 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22511 | PRV | Stephanie Valdez | 1982-02-19 | — | — | 6959 River Rd, Gilbert, AZ, 85223 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25993 | PRV | Lgoan R Park | 1943-12-09 | — | 5322791353 | 8579 Highland Ave, Sacramento, CA | 0.78 | Name re-casedDate of birth reformattedPhone reformattedZIP missing+1 more |
| PRV-28565 | PRV | Ken H Hunter | 1940-12-05 | — | 2818831642 | 5984 Lake View Rd, Atlanta, GA, 30334 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25967 | PRV | Hiroshi F Little | 1951-07-08 | UHC-78883-18 | 6557404130 | 7461 Sage Ct, Sacramento, CA, 95845 | 0.78 | Middle initial moved out of first nameDate of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-20498 | PRV | PamelaJunk | 1975-11-08 | — | 4529523413 | — | 0.78 | Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared+1 more |