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-22501 | PRV | Margaret Hunter | 2005-01-01 | — | 8467827683 | 5534 Union St, Denver, CO, 80290 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26283 | PRV | Hiroshi Z Pierce | 2005-12-01 | UHC-54268-51 | 4444619104 | 3552 Apache Blvd, Denver, CO, 80228 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-26284 | PRV | Hiroshi Z Pierce | 2005-12-01 | UHC-54268-51 | 4444619104 | 3552 Apache Blvd, Denver, CO, 80228 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-22087 | PRV | Emma Tucker | 1955-10-18 | UHC-67045-13 | — | 4116 Market St, Mesa, AZ, 85245 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27882 | PRV | Steven Foster | 1976-12-16 | — | 9228164470 | 2034 Broadway, Jacksonville, FL, 32297 | 0.78 | Two-digit birth yearPhone reformattedAddress re-casedEmail lower-cased+1 more |
| PRV-21023 | PRV | Jacob Brown | 1984-09-17 | UHC-55032-13 | — | 2479 Camelback Rd, Dallas, TX, 75297 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28635 | PRV | Kyle Richardson | 1976-01-01 | — | 9023234080 | 4860 Willow Ct, Scottsdale, AZ, 85278 | 0.78 | Name re-casedPhone reformattedCity re-casedGender normalised+1 more |
| PRV-24555 | PRV | Samuel Castro | 1975-05-08 | — | — | 5853 Market St, Fresno, CA, 93729 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-24009 | PRV | Dennis Spencer | 1993-03-21 | — | 2505984817 | 230 Sunset Blvd, Austin, TX, 78739 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-24509 | PRV | Fatima Myers | 1948-02-05 | — | 9485978728 | — | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-29189 | PRV | Frances R Bowman | 1966-06-16 | — | 4054600635 | 6951 Union St, Gilbert, AZ, 85266 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-24170 | PRV | Aam Chapman | 1985-07-19 | UHC-28802-93 | 5739619826 | 8709 Sage Ct, Eden Prairie, MN, 55360 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24503 | PRV | Hiroshi Baker | 1982-11-19 | UHC-72853-63 | — | 4990 Harbor Blvd, Orlando, FL, 32847 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more |
| PRV-28869 | PRV | Deborah Gordon | 1995-09-18 | — | — | 5176 Mesa Dr, San Diego, CA, 92158 | 0.78 | Two-digit birth yearCity re-casedState code upper-casedWhitespace trimmed+1 more |
| PRV-20125 | PRV | Brian Nunez | 1952-03-16 | UHC-67413-60 | 7507922554 | 4829 Mountain View Dr, Orlando, FL, 32825 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-27015 | PRV | Carlos Jensen | 1988-06-19 | UHC-53640-66 | — | 5801 Canyon Rd, Tucson, AZ, 85700 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25019 | PRV | Diane Rogers | 2004-10-08 | UHC-26032-76 | 9448180415 | 7771 Maple Ave, Gilbert, AZ, 85215 | 0.78 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28342 | PRV | Merilyn N Vazquez | 1941-05-20 | — | 7948827844 | 8011 Meadow Ln, Gilbert, AZ, 85241 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25427 | PRV | Larwence W Lanne | 2006-08-09 | — | — | 2237 Camelback Rd, Los Angeles, CA, 90083 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-23032 | PRV | Julie X Cox | 1948-06-25 | — | 3418386041 | 4661 Market St, Austin, TX, 78737 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20028 | PRV | Morales Debra | 1999-05-17 | — | 4627541837 | 6145 Elm St, Las Vegas, NV, 89152 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22185 | PRV | Ahmed K Fox | 1977-08-23 | UHC-86795-06 | 4315376219 | 7853 Harbor Blvd, Las Vegas, NV, 89187 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+1 more |
| PRV-26578 | PRV | Henry Burton | — | — | 6458435996 | — | 0.78 | Name re-casedDate of birth reformattedDate of birth unreadableEmail lower-cased+1 more |
| PRV-28411 | PRV | Carlos Henry | 1980-07-13 | — | 7703973382 | 1706 Jefferson Ave, Minneapolis, MN | 0.78 | Name re-casedDate of birth reformattedPhone reformattedZIP missing+1 more |
| PRV-26845 | PRV | Wong A Fraces | 1997-11-20 | — | 7178921720 | 6245 Broadway, Denver, CO, 80235 | 0.78 | Two-digit birth yearPhone reformattedAddress re-casedWhitespace trimmed+1 more |
| PRV-25872 | PRV | Kathryn S Payne | 1963-06-10 | — | 7187472042 | 3681 Main St, Atlanta, GA, 30317 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27981 | PRV | Nicholas H Le | 1977-05-15 | — | 8577396860 | 4494 Spring St, Orlando, FL, 32812 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27980 | PRV | Nicholas H Le | 1977-05-15 | — | 8577396860 | 4494 Spring St, Orlando, FL, 32812 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24945 | PRV | Jose Hall | 1944-09-22 | — | 5253464344 | 8803 Church St, Austin, TX, 78753 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26176 | PRV | Brittany H Parker | 1966-10-13 | UHC-15235-59 | 5033064629 | 7950 River Rd, Scottsdale, AZ, 85213 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20183 | PRV | Kenneth Dunn | 1950-03-15 | — | 4216669973 | — | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-21065 | PRV | Mei O Matthews | — | UHC-74503-34 | — | — | 0.78 | Name re-casedDate of birth unreadablePlan code upper-casedWhitespace trimmed+1 more |
| PRV-25908 | PRV | Jacob Brooks | 1980-04-10 | UHC-39223-34 | 8776605057 | 6477 Broadway, Tempe, AZ, 85240 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-25213 | PRV | Mark Ford | 1956-12-04 | — | 8387637311 | 2379 Lake View Rd Apt 9, Eden Prairie, MN, 55352 | 0.78 | Name re-casedPhone reformattedUnit split from streetWhitespace trimmed+1 more |
| PRV-22823 | PRV | Grace Ortega | 1965-11-15 | — | 8504233760 | 6367 Elm St, Los Angeles, CA, 90082 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-27867 | PRV | Teresa Woods | 1993-02-08 | — | 7694075803 | 6410 Forest Ave, Eden Prairie, MN, 55330 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27551 | PRV | Logan R Gibson | 1961-12-08 | UHC-11992-08 | 5549025162 | 5444 Union St # 140, Sacramento, CA, 95815 | 0.78 | Date of birth reformattedPhone reformattedUnit split from streetWhitespace trimmed+1 more |
| PRV-23870 | PRV | Ryan H Schultz | 1982-05-15 | UHC-89183-96 | 5647067001 | 7856 Elm St, Glendale, AZ, 85345 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-20999 | PRV | Marc A Nichols | 2004-08-26 | UHC-44150-48 | 7788749468 | 7644 Ridge Rd, Minneapolis, MN | 0.78 | Name re-casedPhone reformattedCity re-casedZIP missing+1 more |
| PRV-22717 | PRV | Sandra Fox | 1971-01-19 | — | 2352875157 | 8751 Washington St, Las Vegas, NV, 89156 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27752 | PRV | Ruth K Collins | 1938-02-06 | UHC-81446-80 | 4306046951 | 4725 Harbor Blvd, Charlotte, NC, 28279 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29465 | PRV | Lucia Jimenez | 1971-07-28 | — | 6463949096 | 4373 Union St, San Diego, CA, 92136 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26991 | PRV | Isabella Silva | 1973-11-18 | UHC-93649-89 | 8843186465 | 9728 Harbor Blvd, Austin, TX, 78792 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24737 | PRV | Joan Lee | 1994-08-13 | UHC-59669-36 | — | 4173 Apache Blvd, Jacksonville, FL, 32226 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25906 | PRV | Luca Thompson | 1985-12-14 | — | 2434166660 | 19 Pine Dr, San Antonio, TX, 78223 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27921 | PRV | Jessica Butler | 1982-09-01 | UHC-12602-12 | 4279139611 | 2868 Maple Ave, Phoenix, AZ, 85006 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-29489 | PRV | Eveln H Wright | 1986-04-13 | — | — | 7919 Harbor Blvd, Jacksonville, FL, 32236 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23018 | PRV | Melissa Stevens | 1956-02-18 | UHC-08975-82 | 2935934937 | 4400 Broadway, Plano, TX, 75091 | 0.78 | Name split from “Last, First”Date of birth reformattedAddress re-casedWhitespace trimmed+1 more |
| PRV-28746 | PRV | Catherine Lasron | 1971-12-20 | — | 6422852095 | 2721 Sunset Blvd, San Diego, CA, 92109 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21469 | PRV | Brian Little | 1946-02-09 | UHC-65114-56 | 9865881087 | 9016 Maple Ave, Mesa, AZ, 85278 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |