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-25915 | PRV | Wayne Ray | 1973-12-03 | — | 9297003107 | 7029 Cedar Ln, Jacksonville, FL | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-23157 | PRV | Sara Lucas | 1982-04-18 | — | — | 6230 Union St, Scottsdale, AZ, 85250 | 0.82 | Name re-casedGender normalisedPlaceholder values cleared |
| PRV-24127 | PRV | Ralph Wang | 1957-12-03 | UHC-14239-31 | 9104336575 | 5835 Washington St, Chandler, AZ, 85295 | 0.82 | Phone reformattedState name converted to codeWhitespace trimmed |
| PRV-29304 | PRV | Russell Rjas | 1966-11-19 | — | — | 1584 Broadway Apt 17, Houston, TX, 77069 | 0.82 | Unit split from streetWhitespace trimmedPlaceholder values cleared |
| PRV-22818 | PRV | Danielle Torres | 2003-09-16 | — | 8558324572 | 3202 Central Ave, Orlando, FL | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-26382 | PRV | Robert Walsh | — | UHC-24675-76 | 9523490553 | 984 Forest Ave, Sacramento, CA, 95812 | 0.82 | Date of birth unreadableEmail lower-casedPlaceholder values cleared |
| PRV-21942 | PRV | Rachel Lopez | 1939-02-07 | UHC-36747-79 | — | 8989 Valley View Dr, Chandler, AZ, 85236 | 0.82 | Phone missing area codeWhitespace trimmedPlaceholder values cleared |
| PRV-24416 | PRV | Mei S Harvey | 1985-04-19 | UHC-52374-70 | 9858983921 | 7910 Cedar Ln, Houston, TX, 77043 | 0.82 | Name split from “Last, First”Date of birth reformattedPlaceholder values cleared |
| PRV-26767 | PRV | Rendy Stewart | 1955-03-05 | UHC-05456-20 | 2529828935 | — | 0.82 | Name split from “Last, First”Whitespace trimmedPlaceholder values cleared |
| PRV-23460 | PRV | Angela Grene | 1952-05-01 | — | — | 3078 Sage Ct, San Antonio, TX | 0.82 | City re-casedZIP missingPlaceholder values cleared |
| PRV-24024 | PRV | Christian Owens | 1962-06-09 | — | — | 1675 Sage Ct, Denver, CO, 80281 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-21582 | PRV | Camila Knight | 1977-12-26 | UHC-37268-86 | 8666637272 | — | 0.82 | Two-digit birth yearWhitespace trimmedPlaceholder values cleared |
| PRV-23926 | PRV | Noah Padilla | 1984-09-20 | — | 4128831061 | — | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-28049 | PRV | Brittany M Marquez | — | — | 2633799907 | 4717 Spring St, Columbus, OH, 43249 | 0.82 | Date of birth missingPhone reformattedPlaceholder values cleared |
| PRV-20607 | PRV | Kiimberly Vazquez | 1971-03-08 | — | 2569427753 | 866 Maple Ave, Nashville, TN, 37263 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-27618 | PRV | Matt Morrison | 1950-04-22 | UHC-11689-47 | 4068912755 | 9655 Sunset Blvd, Eden Prairie, MN | 0.82 | Member ID reformattedZIP missingPlaceholder values cleared |
| PRV-20309 | PRV | Gary Sullivan | 1965-11-03 | — | 7709632432 | 4564 Baseline Rd, Atlanta, GA, 30334 | 0.82 | Name split from “Last, First”Date of birth reformattedPlaceholder values cleared |
| PRV-26642 | PRV | Helen Williams | 1978-04-25 | UHC-69324-22 | 3814271921 | 1803 Bayshore Dr, San Antonio, TX, 78208 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| PRV-22897 | PRV | Marcus Bryant | 1970-06-24 | UHC-24560-06 | 3754172797 | 7423 Spring St # 682, Fresno, CA, 93766 | 0.82 | Name re-casedUnit split from streetPlaceholder values cleared |
| PRV-20573 | PRV | Sarah D Grant | 1999-01-04 | UHC-93690-53 | 3543233551 | 4672 Canyon Rd, Minneapolis, MN, 55413 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-21034 | PRV | Rachel K Fernandez | 1965-06-19 | — | 4387420693 | 2170 Hillcrest Rd, Sacramento, CA, 95830 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-24257 | PRV | Mariana Walker | 1961-05-06 | — | 7009690386 | 9604 River Rd, Charlotte, NC, 28243 | 0.82 | Phone reformattedZIP+4 trimmedPlaceholder values cleared |
| PRV-28679 | PRV | Diane P Snyder | 1952-05-14 | — | — | 2666 Spring St, Austin, TX, 78738 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| PRV-23257 | PRV | Frannk Lawrence | 1979-09-09 | UHC-94025-69 | — | 8715 Grand Ave, Atlanta, GA, 30364 | 0.82 | Phone missing area codeWhitespace trimmedPlaceholder values cleared |
| PRV-21811 | PRV | Kathryn Ramirez | 1944-05-02 | UHC-00624-02 | 8616212548 | 9294 Park Pl Apt 1, Gilbert, AZ, 85281 | 0.82 | Phone reformattedUnit split from streetPlaceholder values cleared |
| PRV-23770 | PRV | Ana Rose | 1948-12-04 | — | 9875724445 | 21 Cedar Ln # 835, Columbus, OH, 43286 | 0.82 | Phone reformattedUnit split from streetPlaceholder values cleared |
| PRV-21257 | PRV | Denny Simmons | 1983-04-07 | — | 8409043209 | 2133 Apache Blvd, Austin, TX, 78720 | 0.82 | State name converted to codeWhitespace trimmedPlaceholder values cleared |
| PRV-22634 | PRV | Kathryn Bailey | 1952-03-04 | — | — | — | 0.82 | Email lower-casedGender normalisedPlaceholder values cleared |
| PRV-29549 | PRV | Amber G Griffin | 1939-12-09 | UHC-63625-50 | — | 6088 Desert Sky Blvd, San Diego, CA, 92193 | 0.82 | Date of birth reformattedGender normalisedPlaceholder values cleared |
| PRV-25875 | PRV | Anna Grant | 1985-06-28 | UHC-58902-34 | 2085096051 | 9801 Jefferson Ave, Columbus, OH, 43214 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| PRV-26037 | PRV | Ann Gilbert | 1953-06-03 | UHC-82848-70 | 8313202868 | — | 0.82 | Name split from “Last, First”Date of birth reformattedPlaceholder values cleared |
| PRV-21280 | PRV | Logan Bell | 1970-08-22 | — | 2247598345 | 8447 River Rd, Miami, FL, 33145 | 0.82 | Phone reformattedStreet suffix standardisedAddress re-cased |
| PRV-24895 | PRV | Eugene Crawford | 1979-05-03 | UHC-32157-94 | 3296627470 | — | 0.82 | Name re-casedTwo-digit birth yearPlaceholder values cleared |
| PRV-24812 | PRV | Timothy B Freeman | 1992-07-09 | UHC-34025-60 | 9316966389 | — | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-29345 | PRV | Michael Garrett | 2003-11-10 | UHC-15377-59 | — | 2144 Apache Blvd, Scottsdale, AZ, 85248 | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-28309 | PRV | Michelle Harirson | 2000-04-28 | UHC-04552-01 | 7899307291 | 2767 Indian School Rd, Jacksonville, FL, 32204 | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-27438 | PRV | Sandoval V Deborah | 1948-06-07 | — | 3176322535 | 7276 Willow Ct, Minneapolis, MN, 55467 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| PRV-27218 | PRV | Tyler V Fields | 1989-07-21 | UHC-95562-84 | — | 1101 Jefferson Ave, Houston, TX, 77066 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-23215 | PRV | Alice J Vasquez | 2002-04-17 | — | 6905211382 | 3626 Canyon Rd, Fresno, CA, 93742 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-27054 | PRV | Vasquez Sandra | 1987-08-10 | — | 8475877055 | 1056 Mesa Dr, Nashville, TN, 37296 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-28221 | PRV | Robinson Carolyn | 1976-07-13 | UHC-30018-72 | — | 3675 Grand Ave, Tempe, AZ, 85273 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-25354 | PRV | Karen Hawkins | 1994-05-18 | UHC-25363-23 | — | 2740 Meadow Ln, Plano, TX, 75044 | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-20279 | PRV | Ethan Hudson | 1939-04-27 | — | — | 7173 Baseline Rd, Houston, TX, 77029 | 0.82 | Date of birth reformattedGender normalisedPlaceholder values cleared |
| PRV-20565 | PRV | Camila F Gutierrez | 1981-01-01 | — | 8184289736 | 4059 Maple Ave, Glendale, AZ, 85343 | 0.82 | Name split from “Last, First”Whitespace trimmedPlaceholder values cleared |
| PRV-24273 | PRV | Olivia Espinoza | 1945-12-04 | — | 2054054111 | 1329 Meadow Ln, San Diego, CA, 92101 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-22638 | PRV | Theresa T Morrison | 1942-12-17 | UHC-09600-88 | 4987511810 | 9222 Baseline Rd, Las Vegas, NV, 89165 | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-27789 | PRV | Joan Brooks | 1964-05-03 | UHC-26997-72 | 6432077408 | — | 0.82 | Date of birth reformattedGender normalisedPlaceholder values cleared |
| PRV-26311 | PRV | Timothy Santiago | 1997-05-10 | UHC-53349-30 | — | 720 Church St, Tampa, FL, 33634 | 0.82 | Date of birth reformattedPhone missing area codePlaceholder values cleared |
| PRV-27012 | PRV | Dennis Alvarez | 1979-08-21 | — | — | 3110 Desert Sky Blvd, Plano, TX, 75063 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| PRV-27051 | PRV | Albert Garrett | 1982-08-01 | — | 9533020547 | 9517 Desert Sky Blvd, Eden Prairie, MN | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |