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-27928 | PRV | Barbara Carr | 2000-03-19 | — | 5953887054 | 4270 Jefferson Ave, Orlando, FL, 32845 | 0.78 | Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-20726 | PRV | Camila Woods | 1994-01-23 | UHC-11477-78 | 5385908180 | 1429 Lincoln Way, Jacksonville, FL, 32284 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-23181 | PRV | Jimmy Watkins | — | UHC-77031-08 | — | 3160 Union St, Austin, TX, 78716 | 0.78 | Name re-casedDate of birth unreadableCity re-casedWhitespace trimmed+1 more |
| PRV-20659 | PRV | William Taylor | 2007-10-14 | UHC-44116-66 | 9714944605 | 5581 Ridge Rd, Las Vegas, NV, 89142 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-21467 | PRV | Jason Waker | 1958-07-11 | UHC-52858-40 | 9198299272 | 8763 Lincoln Way, Orlando, FL, 32826 | 0.78 | Phone reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more |
| PRV-26742 | PRV | Russell F Lee | 1966-02-19 | UHC-71483-82 | 5723182318 | 336 Forest Ave, Denver, CO, 80279 | 0.78 | Phone reformattedMember ID reformattedEmail lower-casedGender normalised+1 more |
| PRV-21398 | PRV | Steven Estrada | 1940-10-15 | UHC-77984-19 | 8139704382 | 6415 Baseline Rd, Houston, TX, 77090 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21873 | PRV | Maria Marquez | 1967-08-01 | UHC-91326-09 | 3512180185 | 8371 Spring St, Atlanta, GA, 30325 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-21872 | PRV | Maria Marquez | 1967-08-01 | UHC-91326-09 | 3512180185 | 8371 Spring St, Atlanta, GA, 30325 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-29458 | PRV | Teresa Woods | 1968-09-17 | — | — | 4912 Hillcrest Rd, Chandler, AZ, 85221 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26953 | PRV | Janet Hawkins | 1996-03-26 | UHC-30047-18 | 5695896314 | 7647 Mesa Dr, Tucson, AZ, 85704 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25203 | PRV | Mariana Gutierrez | 1999-07-23 | — | — | 8486 Central Ave, Mesa, AZ, 85228 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-27001 | PRV | Vigrinia Maldonado | — | — | 8846301812 | 4553 Main St, Sacramento, CA, 95889 | 0.78 | Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed+1 more |
| PRV-28979 | PRV | Hiroshi Sims | 1972-10-22 | — | 8352798010 | 393 Lincoln Way, Fresno, CA, 93766 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-29091 | PRV | Alexis B Murray | 1990-12-15 | UHC-07375-77 | 5808016873 | 5747 Camelback Rd, San Diego, CA, 92131 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22800 | PRV | Alert P Hayes | 1944-07-03 | — | 7195431617 | 7339 Hillcrest Rd, Plano, TX, 75091 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22975 | PRV | Omar V Estrada | 1955-07-13 | — | — | 5347 Sunset Blvd, Minneapolis, MN, 55405 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21822 | PRV | Natalie Hanson | 1962-09-17 | UHC-59968-41 | 9593110005 | 5459 Broadway, Seattle, WA, 98151 | 0.78 | Phone reformattedState code upper-casedGender normalisedWhitespace trimmed+1 more |
| PRV-22821 | PRV | Alan Ramos | 1971-09-24 | UHC-81866-57 | 9793426863 | 34 Washington St, Seattle, WA, 98132 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-20735 | PRV | Douglas Morgan | 1974-01-02 | UHC-20227-50 | 7783900003 | 4328 Grand Ave, Chandler, AZ, 85207 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-25837 | PRV | Chrs Morgan | 2007-09-01 | — | 3988679277 | 469 Pine Dr, Austin, TX, 78759 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21519 | PRV | Ryan Green | 1995-12-03 | — | 5993419936 | 1735 Sunset Blvd, Phoenix, AZ, 85035 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22884 | PRV | Mateo S Simpson | 1938-10-27 | UHC-06246-32 | 7148458844 | 2852 Camelback Rd, Columbus, OH, 43292 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23149 | PRV | Chreyl Kennedy | 1982-09-19 | UHC-14493-37 | 3162792853 | 2547 Washington St, Plano, TX, 75005 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25220 | PRV | Austin K Matthews | 1990-10-24 | UHC-02623-23 | 9675973970 | 7181 River Rd, San Diego, CA, 92180 | 0.78 | Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28327 | PRV | Evelyn Simpson | 1979-01-11 | UHC-33527-89 | 3386129001 | 6787 Forest Ave, Dallas, TX, 75241 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24968 | PRV | Chris Thompson | 1939-09-01 | — | 2637976993 | 9639 Broadway, Mesa, AZ, 85258 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+1 more |
| PRV-21426 | PRV | Bobby Rodriguez | 1953-05-08 | UHC-68797-41 | 3869332186 | 2710 Lincoln Way, Fresno, CA, 93791 | 0.78 | Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29259 | PRV | Amber G Walker | 1987-09-21 | — | — | 6375 River Rd, Miami, FL, 33158 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23503 | PRV | Laura Alvarado | 1944-03-03 | — | 5424878919 | 1141 Jefferson Ave, Houston, TX, 77096 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23405 | PRV | Roy T Ellis | 1948-12-11 | UHC-77583-75 | 4656640157 | 4326 Camelback Rd, Houston, TX, 77063 | 0.78 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20410 | PRV | Ann Lynch | 1985-05-23 | — | 3372873236 | 3431 Camelback Rd, Eden Prairie, MN, 55324 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-25416 | PRV | Megan Pena | 1960-01-27 | — | — | 2843 Oak St, Plano, TX, 75015 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22450 | PRV | Julia Jenseen | 1958-06-21 | UHC-89834-38 | 3894618707 | 8583 Sage Ct, Fresno, CA, 93784 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-24973 | PRV | Anthony Jackson | 1996-11-11 | — | 7084971104 | 7175 Mesa Dr, Dallas, TX, 75263 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25324 | PRV | Lori Parker | 1989-05-13 | — | 2246029121 | — | 0.78 | Name re-casedPhone reformattedEmail lower-casedGender normalised+1 more |
| PRV-21013 | PRV | Harold Adams | 1940-04-08 | — | — | 2472 Spring St, Atlanta, GA, 30396 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-25823 | PRV | Jacob Herrera | 1962-03-22 | — | — | 8167 Highland Ave, Nashville, TN, 37298 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28055 | PRV | Kathryn Hart | 1947-01-10 | — | 4636167714 | 1306 Pine Dr, Atlanta, GA, 30303 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28410 | PRV | Gabriel Riley | 1973-07-26 | UHC-30685-65 | 7886189483 | 7975 Washington St, Miami, FL, 33140 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-20764 | PRV | Gregory Richardson | 1960-04-11 | — | 2909667947 | 1687 Palm Dr, Dallas, TX, 75271 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-20215 | PRV | Yuki Nichols | 2006-11-24 | — | 3827090440 | 2072 Lincoln Way, Denver, CO, 80237 | 0.78 | Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-24742 | PRV | Jesse Kelley | 1954-06-03 | — | 9762097230 | 6169 Camelback Rd, San Antonio, TX, 78217 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21835 | PRV | William M Gibson | 1955-09-23 | — | 9477235664 | 9176 Church St, Nashville, TN, 37264 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-21449 | PRV | Billy Mendez | 1959-05-15 | — | 7938147936 | 1872 Willow Ct, Miami, FL, 33100 | 0.78 | Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-29083 | PRV | Pamela Z Bailey | 1976-09-06 | UHC-35929-69 | 4677602086 | 3492 Meadow Ln, Eden Prairie, MN, 55373 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20074 | PRV | Madison Boyd | 1997-10-09 | — | 4957631430 | 5761 Central Ave, Nashville, TN, 37230 | 0.78 | Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more |
| PRV-28091 | PRV | Jennifer Price | — | UHC-20738-60 | 3973788524 | 5802 Washington St, Phoenix, AZ, 85030 | 0.78 | Name re-casedDate of birth missingCity re-casedWhitespace trimmed+1 more |
| PRV-25465 | PRV | Aaron Bell | 1965-07-04 | — | 5996254481 | 5517 Desert Sky Blvd, Miami, FL, 33162 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-27872 | PRV | Robert Harper | 1995-09-18 | UHC-35694-15 | 6283139197 | 4989 Main St, Chandler, AZ, 85219 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |