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-23969 | PRV | Mary Marquez | 1981-01-20 | — | 6229091859 | 9126 Union St, Atlanta, GA, 30314 | 0.64 | Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more |
| PRV-24744 | PRV | Priya Webb | 1986-11-22 | — | 5973211335 | 5120 Main St Apt 24, Glendale, AZ, 85392 | 0.64 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-28215 | PRV | Helen Garcia | 1973-01-28 | UHC-38530-83 | 9082605200 | 8801 Forest Ave # 953, Fresno, CA, 93720 | 0.64 | Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more |
| PRV-24352 | PRV | Long D Olivia | 1997-07-15 | UHC-29266-21 | 8242742158 | 1779 Jefferson Ave, Miami, FL, 33125 | 0.64 | Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+2 more |
| PRV-23414 | PRV | Wei F Chapman | 2005-03-20 | — | 3045402131 | 5147 Pine Dr, Tempe, AZ, 85216 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-26973 | PRV | Dennis Morris | 1956-08-01 | UHC-52301-44 | 4529291801 | 1163 Willow Ct # 689, Minneapolis, MN, 55485 | 0.64 | Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+2 more |
| PRV-24743 | PRV | Albert Reed | 1972-02-19 | — | 8053194501 | 2018 Desert Sky Blvd, Tampa, FL, 33650 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-27986 | PRV | Randy Owens | 2005-12-13 | UHC-66110-46 | 9163843627 | 5875 Church St, Fresno, CA, 93795 | 0.64 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| PRV-22886 | PRV | Christine George | 2006-08-21 | — | 5859503220 | 2631 Highland Ave, Austin, TX, 78729 | 0.64 | Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more |
| PRV-23576 | PRV | Heather Berry | 1949-09-19 | — | 8427084547 | 1192 Hillcrest Rd, Scottsdale, AZ, 85284 | 0.64 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21072 | PRV | Bradley C Schmidt | 1999-09-02 | UHC-76297-90 | 5442920791 | 7157 Lincoln Way, Tampa, FL, 33616 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24736 | PRV | Ruth P Herrera | 1956-11-26 | UHC-48021-37 | 5013259208 | 8527 Park Pl, Tucson, AZ, 85713 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-29567 | PRV | Rachel I Adams | 1939-03-26 | UHC-34375-78 | 6705879506 | 5892 Oak St, Tucson, AZ, 85724 | 0.64 | Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more |
| PRV-23528 | PRV | Laura I Clark | 2003-12-25 | UHC-21114-84 | 7105808930 | 5815 Grand Ave, Fresno, CA, 93710 | 0.64 | Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+2 more |
| PRV-24522 | PRV | Wayne Jackson | 1951-12-22 | — | 2844921848 | 4411 Willow Ct, Dallas, TX, 75290 | 0.64 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-27326 | PRV | Jesse J Weaver | 1958-11-12 | UHC-76848-80 | 7494927515 | 4153 Valley View Dr, Fresno, CA, 93784 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20213 | PRV | Abby Simmons | 1953-06-10 | — | 8013629545 | 749 Canyon Rd, Jacksonville, FL, 32209 | 0.64 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22968 | PRV | James I McDonald | 1959-03-20 | UHC-97198-99 | 4352519505 | 209 Mountain View Dr, Fresno, CA | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-21818 | PRV | Timothy Flores | 1980-10-14 | UHC-53330-02 | 5772997854 | 6476 Washington St, Eden Prairie, MN, 55389 | 0.64 | Phone reformattedMember ID reformattedState name converted to codeGender normalised+2 more |
| PRV-21688 | PRV | Amanda Larson | 1946-09-26 | — | 2384766490 | 1439 Desert Sky Blvd, Tempe, AZ, 85258 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-29507 | PRV | Rob Ramos | 1946-11-20 | — | — | 5876 Indian School Rd, San Antonio, TX, 78239 | 0.64 | Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more |
| PRV-28278 | PRV | Shirley Media | 1939-03-28 | UHC-90535-74 | 2946985847 | 902 Elm St Apt 24, Glendale, AZ, 85336 | 0.64 | Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+2 more |
| PRV-21354 | PRV | Jospeh J Wood | 1987-12-20 | — | 9577963480 | 2060 Canyon Rd, Phoenix, AZ, 85037 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-22761 | PRV | Cynthia Castro | 1981-10-06 | — | — | 1248 Sunset Blvd, Seattle, WA, 98189 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-20551 | PRV | Pauul Lopez | — | UHC-40853-63 | 3739226087 | 4018 Ridge Rd, Scottsdale, AZ, 85290 | 0.64 | Date of birth unreadablePhone reformattedEmail lower-casedGender normalised+2 more |
| PRV-25759 | PRV | Carl L Castro | 1997-08-13 | — | 7056109115 | 3675 Lake View Rd # 534, Plano, TX, 75019 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-22484 | PRV | Wayne Ward | 1966-08-17 | — | 6754164628 | 503 Ridge Rd, San Antonio, TX | 0.64 | Name re-casedPhone reformattedZIP missingGender normalised+2 more |
| PRV-20380 | PRV | Donald Brown | 2008-05-16 | — | 5009602474 | 5701 Spring St # 367, Jacksonville, FL, 32207 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-22280 | PRV | Robert Weber | 1982-03-12 | UHC-94741-69 | — | 5930 Maple Ave, Chandler, AZ, 85270 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-23887 | PRV | Ana Mills | 1998-06-13 | — | 7822849623 | 7015 Union St, Las Vegas, NV, 89176 | 0.64 | Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more |
| PRV-27581 | PRV | Anthony P Foster | 1987-01-06 | — | 8388749143 | 7589 Pine Dr, Nashville, TN, 37254 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-23256 | PRV | Janice Park | 2004-10-23 | — | 9408837778 | 3497 Mountain View Dr # 811, Scottsdale, AZ, 85260 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-20660 | PRV | Linda Bowman | 1978-04-25 | UHC-84271-43 | 3676944980 | 1878 Indian School Rd # 201, Chandler, AZ, 85263 | 0.64 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-23921 | PRV | Stephen Hansen | 1939-05-11 | — | 7543598589 | 8089 Pine Dr, Fresno, CA, 93739 | 0.64 | Phone reformattedCity re-casedState name converted to codeGender normalised+2 more |
| PRV-25927 | PRV | Bobby Murpyh | 1992-04-03 | — | 3969693979 | 4556 Ridge Rd, Houston, TX, 77089 | 0.64 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-24584 | PRV | Cheryl Hoffman | 1996-11-26 | UHC-27166-87 | 5624021989 | 7863 Forest Ave, Las Vegas, NV, 89173 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27046 | PRV | Betty Rose | 1945-03-03 | — | 6003562475 | 8135 Central Ave, Columbus, OH, 43210 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26564 | PRV | Hiroshi Schultz | 1978-07-23 | — | 9873904263 | 2330 Palm Dr, Phoenix, AZ, 85079 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21945 | PRV | Harold Vega | — | UHC-62854-39 | 6169594956 | 9470 Highland Ave, Orlando, FL, 32842 | 0.64 | Name re-casedDate of birth missingPhone reformattedState name converted to code+2 more |
| PRV-23350 | PRV | Deborah Howard | 1958-08-08 | UHC-46791-90 | 4137536810 | 6384 Maple Ave, Eden Prairie, MN | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-26405 | PRV | Adam Espinoza | 2002-01-22 | UHC-31431-03 | 2726610944 | 344 Palm Dr # 785, Charlotte, NC, 28268 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-20292 | PRV | Catherine Hoffman | 1949-01-28 | — | 4744385613 | 5813 Indian School Rd # 831, San Diego, CA, 92113 | 0.64 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-24889 | PRV | Kenneth Montgomery | 1985-06-02 | — | 4746914631 | 476 Harbor Blvd, Tucson, AZ | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-28058 | PRV | Shirley Lopez | 1944-02-01 | UHC-32327-74 | 6152096793 | 3855 Palm Dr, Plano, TX, 75085 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-21700 | PRV | Scott Murphy | 1972-02-20 | UHC-06778-81 | 9566586171 | 6185 Church St, Tampa, FL, 33694 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27110 | PRV | Laura Mason | 1977-10-26 | UHC-86903-57 | — | 4702 Highland Ave, Seattle, WA | 0.64 | Name re-casedDate of birth reformattedPhone missing area codeZIP missing+2 more |
| PRV-23553 | PRV | Adam Elliott | 2008-10-01 | UHC-40799-71 | — | 4898 Church St, Glendale, AZ, 85372 | 0.64 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| PRV-20395 | PRV | Linda V Riley | 1982-07-15 | UHC-36896-26 | 7425941177 | 1557 Central Ave, Seattle, WA | 0.64 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22238 | PRV | Dean G Stephanye | 1984-06-23 | UHC-98085-12 | 9336402626 | 6137 Lake View Rd, Jacksonville, FL | 0.64 | Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-27848 | PRV | Tony Hunt | 1939-05-02 | UHC-11062-05 | 9134485813 | 7124 Mountain View Dr, Fresno, CA, 93795 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |