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-24944 | PRV | Kelly Reed | 1965-04-13 | UHC-18092-14 | 6537521335 | 1750 Grand Ave, Minneapolis, MN, 55475 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22672 | PRV | Omar J Carter | 1940-09-08 | — | 8698924762 | 6152 Camelback Rd, Seattle, WA, 98188 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25254 | PRV | Brenda Castro | 1960-04-01 | UHC-25301-78 | 3042731898 | 4199 Spring St, Glendale, AZ, 85353 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26383 | PRV | Ahmde Alexander | 1989-05-22 | — | 6583100140 | — | 0.78 | Name re-casedPhone reformattedSSN last four extractedWhitespace trimmed+1 more |
| PRV-22000 | PRV | Benjamin B Davis | 1971-12-09 | — | 9637881778 | 4361 Cedar Ln, Las Vegas, NV, 89151 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21553 | PRV | Roy Jordan | 2002-06-11 | — | 3167770903 | 3977 Main St, Miami, FL, 33122 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23072 | PRV | Eugene L Peterson | 1942-11-20 | — | 8679725228 | 2480 Ocean Ave, Minneapolis, MN, 55489 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27087 | PRV | Kathryn Holmes | 1939-03-10 | — | 2668528374 | 8055 Desert Sky Blvd, Denver, CO, 80259 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26206 | PRV | Sara Powell | 2005-02-03 | — | 4595729223 | 4148 Ocean Ave, Houston, TX, 77044 | 0.78 | Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-21900 | PRV | Judy Hughes | 1983-06-14 | UHC-26972-28 | 7409855473 | 2731 Forest Ave, Gilbert, AZ, 85239 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28134 | PRV | Kimberly Vega | 1977-08-09 | UHC-19644-11 | 9145563153 | 914 Camelback Rd, Glendale, AZ, 85367 | 0.78 | Name re-casedState code upper-casedGender normalisedWhitespace trimmed+1 more |
| PRV-27200 | PRV | Amy Y Simpson | 1940-12-05 | — | — | 7977 Bayshore Dr, Jacksonville, FL, 32260 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25808 | PRV | Dylan Robinson | 2007-07-15 | — | 5043219582 | 3396 Maple Ave, Orlando, FL, 32819 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23069 | PRV | Victoria Contreras | 1974-07-19 | UHC-26320-40 | 5102282443 | 7228 Baseline Rd, Orlando, FL, 32817 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+1 more |
| PRV-24539 | PRV | Mariana R Valdez | 1982-11-22 | — | 9142666728 | 1961 Apache Blvd, Dallas, TX, 75267 | 0.78 | Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more |
| PRV-29006 | PRV | Julie Hansen | 1947-05-27 | UHC-90762-59 | 4232319218 | 7954 Main St, Tucson, AZ, 85776 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-22022 | PRV | Walter Bryant | 1946-05-12 | — | 6013886323 | 5632 Pine Dr, Houston, TX, 77021 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-29182 | PRV | Denise Y Gibson | 1973-06-15 | — | 5727006996 | 3493 Elm St, Charlotte, NC, 28256 | 0.78 | Date of birth reformattedPhone reformattedCity re-casedState name converted to code+1 more |
| PRV-25623 | PRV | Arjun Barnes | 2000-11-01 | — | 2032452113 | — | 0.78 | Name re-casedPhone reformattedSSN last four extractedWhitespace trimmed+1 more |
| PRV-26918 | PRV | David Woods | 1938-05-26 | UHC-82071-75 | 6292712914 | 1578 Union St, Nashville, TN, 37211 | 0.78 | Phone reformattedMember ID reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-27900 | PRV | Eugene Crawford | 1954-05-05 | — | 9867989533 | 6267 Broadway, Scottsdale, AZ, 85277 | 0.78 | Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-25400 | PRV | Jean K Singh | 1951-03-25 | UHC-61363-09 | 4426005971 | 6624 Hillcrest Rd # 875, Phoenix, AZ, 85054 | 0.78 | Name re-casedUnit split from streetCity re-casedWhitespace trimmed+1 more |
| PRV-27816 | PRV | Mei Reeed | 1940-12-02 | UHC-67578-17 | 5438771739 | 8628 Forest Ave, Austin, TX, 78702 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-29242 | PRV | Pat Fisher | 2008-04-12 | UHC-39580-82 | — | 799 Church St, Dallas, TX, 75206 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24333 | PRV | Bradley Santos | 1975-08-20 | — | 8174485674 | 326 Forest Ave, San Diego, CA, 92144 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20862 | PRV | Ethan Vazquez | 1990-01-23 | UHC-36033-31 | — | 1776 Lake View Rd, Orlando, FL, 32853 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-26843 | PRV | Dennis I Guerrero | 1999-02-16 | UHC-15583-27 | 2174740533 | 6401 Mountain View Dr, Mesa, AZ, 85229 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-24203 | PRV | Henry Jeknins | 1952-06-23 | UHC-25569-64 | 8297498342 | 8487 Washington St, San Diego, CA, 92100 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedState code upper-cased+1 more |
| PRV-20679 | PRV | Bruce Fisher | 1991-10-14 | UHC-07467-66 | 9866068988 | 1939 Pine Dr, Charlotte, NC, 28268 | 0.78 | Name re-casedTwo-digit birth yearMember ID reformattedWhitespace trimmed+1 more |
| PRV-28454 | PRV | George Hicks | 1998-07-23 | UHC-48027-95 | — | 2519 Forest Ave, Sacramento, CA, 95868 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24488 | PRV | Robert Knight | 1974-11-08 | UHC-63802-23 | 7698021759 | 7235 Spring St, Minneapolis, MN, 55483 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedEmail lower-cased+1 more |
| PRV-26507 | PRV | Christian Y Garrett | 1955-04-21 | UHC-16481-13 | 3628741346 | 3870 Canyon Rd, Jacksonville, FL, 32283 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25138 | PRV | Anna Barnes | 1986-08-23 | UHC-89276-13 | 9457520541 | 6560 Lincoln Way, Fresno, CA, 93767 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-24801 | PRV | David V Davis | 1948-04-05 | UHC-44621-94 | — | 5233 Maple Ave, Mesa, AZ, 85203 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24675 | PRV | Roger Moreno | 1987-02-24 | — | 8087692396 | 8883 Meadow Ln, Sacramento, CA, 95863 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-27691 | PRV | Daniel A Edwards | 1974-01-08 | — | 2875095232 | 8072 Cedar Ln, Los Angeles, CA, 90016 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20178 | PRV | Anna Kelley | 2002-01-02 | — | 8749851574 | — | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-27506 | PRV | Carolyn Howard | 1951-05-02 | UHC-95418-97 | 9065647459 | 3359 Meadow Ln, Nashville, TN, 37262 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22462 | PRV | Janet Holems | 2001-05-05 | — | 7608132571 | 5096 River Rd, Las Vegas, NV, 89148 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21847 | PRV | Sara Carter | 1945-03-08 | — | — | 4145 Lake View Rd, Phoenix, AZ, 85097 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28947 | PRV | Wei Rojas | 1959-03-01 | UHC-02111-50 | 4474536178 | — | 0.78 | Phone reformattedMember ID reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-27771 | PRV | Priya Vldez | 1977-12-20 | — | 9829299460 | 6896 Canyon Rd, Plano, TX, 75033 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27973 | PRV | Amy Hicks | 1960-03-21 | UHC-14831-12 | — | 6886 Palm Dr, Gilbert, AZ, 85277 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-25982 | PRV | Arthur I Espinoza | 1991-10-23 | — | 5154727968 | 2783 Market St # 919, Gilbert, AZ, 85284 | 0.78 | Date of birth reformattedPhone reformattedUnit split from streetWhitespace trimmed+1 more |
| PRV-27246 | PRV | Charles P Griffin | 2003-10-08 | UHC-79368-12 | 3085847986 | 6431 Oak St, Eden Prairie, MN, 55384 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+1 more |
| PRV-25793 | PRV | Laura Evans | 1969-02-08 | UHC-98868-67 | — | 2369 Bayshore Dr, Dallas, TX, 75253 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-24797 | PRV | Brittany Ferguson | 1990-09-21 | UHC-84955-92 | — | 8269 Baseline Rd, Minneapolis, MN, 55433 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24517 | PRV | Mariana H Harrison | 2007-03-03 | UHC-02249-15 | 5877232833 | 5365 Union St, Glendale, AZ, 85337 | 0.78 | Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more |
| PRV-22517 | PRV | Bobby Dominguez | 2005-12-21 | — | 8704841361 | 1263 Canyon Rd, Dallas, TX, 75265 | 0.78 | Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-28876 | PRV | Beverly Smith | 1969-03-16 | — | 9818347806 | 5753 Apache Blvd, Dallas, TX, 75248 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |