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-22313 | PRV | Willie Matthews | 1983-07-16 | — | 9876586293 | 3649 Mountain View Dr, Jacksonville, FL, 32209 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24428 | PRV | Mariana M Robertson | 2004-08-20 | UHC-59750-05 | — | 5340 Desert Sky Blvd, Denver, CO, 80211 | 0.64 | Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28400 | PRV | Maria Y Jackson | 1958-12-04 | UHC-58867-15 | 2334720836 | 6174 Apache Blvd, Tucson, AZ, 85770 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23352 | PRV | Santiago Henry | 1995-11-06 | UHC-14707-79 | — | 226 Canyon Rd, Mesa, AZ, 85255 | 0.64 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29569 | PRV | Stephen Ruiz | 1952-07-01 | UHC-29193-51 | — | 2175 Highland Ave, Tampa, FL, 33605 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-25628 | PRV | Sophia O Turner | 1947-01-18 | — | 9435633376 | 4569 Harbor Blvd, Columbus, OH, 43266 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-25627 | PRV | Sophia O Turner | 1947-01-18 | — | 9435633376 | 4569 Harbor Blvd, Columbus, OH, 43266 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-23673 | PRV | Andrea T Collins | 1946-06-16 | UHC-15673-23 | 9066617904 | 1925 Forest Ave, Chandler, AZ, 85211 | 0.64 | Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more |
| PRV-24967 | PRV | Mark Sandoal | 2006-03-22 | — | 9629371862 | 6181 Mountain View Dr, Houston, TX, 77048 | 0.64 | Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+2 more |
| PRV-25788 | PRV | Vincent Guerrero | 1965-09-01 | UHC-79757-63 | — | 4646 Baseline Rd, Minneapolis, MN, 55483 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-26328 | PRV | Peter Ferguson | 1948-03-25 | — | 4004185678 | 1560 Central Ave, Houston, TX, 77066 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27738 | PRV | Julia Carlson | 1963-11-18 | UHC-47137-69 | 7506452381 | 4096 Central Ave, Gilbert, AZ, 85215 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-27147 | PRV | Donald Lee | 1994-09-19 | UHC-53065-99 | 8532696375 | 8388 Desert Sky Blvd, Plano, TX, 75019 | 0.64 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-24758 | PRV | Marcus Tucker | 2000-11-21 | UHC-60936-79 | — | 6343 Palm Dr, Austin, TX, 78799 | 0.64 | Name re-casedDate of birth reformattedSSN last four extractedEmail lower-cased+2 more |
| PRV-21046 | PRV | Michael Fields | 1967-07-20 | — | 8716336458 | 2411 Forest Ave, Plano, TX, 75028 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29007 | PRV | Carolyn D Simmons | 1960-04-05 | UHC-93810-96 | 8766516529 | 7621 Camelback Rd, Jacksonville, FL, 32270 | 0.64 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| PRV-23721 | PRV | Natalie H Fowler | 1939-10-01 | — | 6028297759 | 1112 Willow Ct, Dallas, TX, 75214 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-20558 | PRV | Samuel Burns | 2001-12-03 | — | 6133657225 | 3883 Canyon Rd, Seattle, WA, 98162 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-27903 | PRV | Melissa N Bennett | 1966-01-21 | UHC-74500-76 | 7775805824 | 9773 Indian School Rd Apt 39, Los Angeles, CA, 90071 | 0.64 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| PRV-28558 | PRV | Kathleen Le | 1987-06-08 | UHC-95340-31 | — | 8323 Bayshore Dr, Tucson, AZ, 85782 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-27171 | PRV | Evelyn Lawon | 1997-12-10 | — | 4807609382 | 2187 Willow Ct # 675, Minneapolis, MN, 55402 | 0.64 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| PRV-22325 | PRV | Ronald Espinoza | 1981-09-20 | UHC-88715-46 | — | 763 Oak St, Atlanta, GA, 30355 | 0.64 | Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more |
| PRV-26070 | PRV | Patrick Boyd | 1977-05-24 | UHC-93836-29 | 2188913290 | 7545 Mesa Dr, Mesa, AZ, 85230 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-27162 | PRV | Heather Z Medina | 2001-09-21 | — | 6528269794 | 7546 Baseline Rd, Charlotte, NC, 28257 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-27394 | PRV | Theresa Taylor | 1982-04-11 | UHC-55739-27 | 5392222883 | 2310 Mesa Dr, Los Angeles, CA, 90081 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27061 | PRV | Gloria Brown | 2005-05-04 | — | 8397677849 | 3815 Church St, Scottsdale, AZ | 0.64 | Two-digit birth yearPhone reformattedCity re-casedZIP missing+2 more |
| PRV-22738 | PRV | Cynthia I Diaz | 2002-12-02 | UHC-72241-56 | 8586064607 | 4342 Baseline Rd, Denver, CO, 80274 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23076 | PRV | Amanda Foster | 1974-01-09 | UHC-46520-48 | 7287197021 | 395 Washington St, San Diego, CA, 92199 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-24610 | PRV | Steven Ruiz | 1950-07-10 | UHC-52473-73 | 7272466796 | 6429 Sage Ct, Chandler, AZ, 85280 | 0.64 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28743 | PRV | Alan Olson | 1953-01-19 | UHC-34288-51 | 4032249395 | 9036 Ridge Rd, San Antonio, TX, 78201 | 0.64 | Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23987 | PRV | Theresa Mendez | 1976-12-25 | — | 4758232018 | 7707 River Rd, Miami, FL, 33156 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25384 | PRV | Christopheer Cunningham | 1990-03-02 | — | 8775872086 | 9136 Apache Blvd # 867, Seattle, WA, 98120 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-21159 | PRV | Carol Stevens | — | UHC-34223-83 | 7206056203 | 8254 Spring St, Nashville, TN, 37250 | 0.64 | Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23315 | PRV | Carl McCoy | 2008-07-20 | UHC-90578-64 | 4023918125 | 9103 Palm Dr, Tampa, FL, 33697 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-24811 | PRV | Theresa Hawkins | 2007-04-19 | UHC-64409-76 | 4592437844 | 9763 Central Ave, Austin, TX, 78741 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-28999 | PRV | Brandon J Edwards | 1948-04-23 | — | 5549175741 | 3531 Church St, Sacramento, CA, 95850 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-23705 | PRV | George M Padilla | 2005-01-20 | UHC-53198-74 | 9417304308 | 7600 Valley View Dr, Charlotte, NC, 28274 | 0.64 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21371 | PRV | Luis Jimenez | 1980-12-13 | — | 9715252727 | 494 Harbor Blvd, Plano, TX | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-29488 | PRV | Harold Fields | 1977-12-15 | UHC-15310-75 | 5677196437 | 3836 Indian School Rd, Tempe, AZ, 85201 | 0.64 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| PRV-20312 | PRV | William Daniels | 1941-08-01 | — | 5252377028 | 1798 Ridge Rd Apt 11, Austin, TX, 78778 | 0.64 | Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-21750 | PRV | Shirley Hal | — | — | — | 8151 Jefferson Ave, Sacramento, CA, 95837 | 0.64 | Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more |
| PRV-24256 | PRV | Julia Vasquez | 1956-12-05 | — | — | 7887 Indian School Rd, Minneapolis, MN | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-20873 | PRV | Denise Bennett | 2003-06-18 | — | 3614947193 | 3143 Mountain View Dr Apt 33, Denver, CO, 80286 | 0.64 | Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+2 more |
| PRV-29456 | PRV | Jesse Daniels | 1960-11-24 | UHC-34721-77 | 6987582646 | 5751 Elm St, Charlotte, NC, 28238 | 0.64 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26780 | PRV | Isabella P Freeman | 1965-09-13 | — | 8605143057 | 2072 Market St, Los Angeles, CA, 90059 | 0.64 | Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+2 more |
| PRV-20152 | PRV | Amy Hanson | 1987-10-08 | — | — | 62 Lake View Rd, Tucson, AZ | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-23238 | PRV | Justin Garcia | 1993-09-18 | — | 8808093661 | 6008 Cedar Ln, Scottsdale, AZ, 85274 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-28056 | PRV | Lori Ellis | 1947-10-21 | — | — | 7470 Bayshore Dr, Scottsdale, AZ | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-28101 | PRV | Eryc Wheeler | 1997-06-10 | — | 2015855404 | 2403 Canyon Rd, Orlando, FL | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-27285 | PRV | Sam Elliott | 1990-03-17 | UHC-79245-67 | 3112686874 | 6721 Sunset Blvd Apt 34, Las Vegas, NV, 89105 | 0.64 | Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more |