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-23664 | PRV | Frank West | 2008-07-19 | — | 3652722280 | 9071 Cedar Ln Apt 4, Tempe, AZ, 85266 | 0.78 | Name re-casedDate of birth reformattedUnit split from streetPlan code upper-cased+1 more |
| PRV-29216 | PRV | Roger Reid | 1961-06-04 | UHC-97347-56 | 3157127510 | 9877 Valley View Dr, Sacramento, CA, 95880 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25833 | PRV | Marcus G Phillips | 1947-07-07 | UHC-71760-25 | 5468921111 | 1165 Indian School Rd, Denver, CO, 80293 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29210 | PRV | Emily Dean | 1938-09-11 | UHC-59103-27 | 8095753906 | 45 Oak St, Denver, CO, 80259 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+1 more |
| PRV-28531 | PRV | Margart Stewart | 1978-04-20 | — | 6209068342 | 3045 Willow Ct, Phoenix, AZ, 85088 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23838 | PRV | Russell V Ramos | 1982-11-04 | — | — | 241 Lincoln Way, San Diego, CA, 92171 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+1 more |
| PRV-23618 | PRV | Adam Gibson | 1991-01-08 | — | 9115456638 | 7686 Sunset Blvd, Sacramento, CA, 95867 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+1 more |
| PRV-21135 | PRV | Brenda Dominguez | 1938-09-27 | — | 9774373997 | 2854 Maple Ave, Miami, FL, 33120 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-24548 | PRV | Carolyn Jordan | 1952-10-12 | — | 9293703365 | 3878 Market St, Charlotte, NC, 28245 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-23958 | PRV | Justin Franklin | 1985-09-14 | UHC-39521-81 | — | 1730 Sage Ct, Atlanta, GA, 30378 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25890 | PRV | Adam Hughes | 1974-04-05 | — | 7572253575 | 4667 Sunset Blvd, Sacramento, CA, 95821 | 0.78 | Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-28913 | PRV | Nicholas Oliver | 1967-01-18 | — | 3179898853 | 7570 Lake View Rd, Houston, TX, 77050 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21511 | PRV | Ryan Warren | 1981-09-17 | — | 8912743852 | 8565 Desert Sky Blvd, Las Vegas, NV, 89165 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25994 | PRV | Raymond Elliott | 1956-04-25 | UHC-34636-62 | 8403759083 | 8816 Forest Ave, Denver, CO | 0.78 | Name re-casedPhone reformattedZIP missingWhitespace trimmed+1 more |
| PRV-26391 | PRV | Marcus Bell | 1956-07-02 | UHC-55171-32 | — | 4720 Park Pl, Dallas, TX, 75237 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23164 | PRV | Mari A Vazquez | 1980-02-04 | — | 2478364773 | 1782 Bayshore Dr, Plano, TX, 75098 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-29422 | PRV | Julie N Knight | 1989-05-17 | — | 7629966026 | 9298 Lake View Rd, Tucson, AZ, 85745 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27782 | PRV | Rachel Kennedy | 1975-07-09 | — | 9426240881 | 8703 Park Pl, Phoenix, AZ, 85029 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25151 | PRV | Gary Hunt | 1959-05-19 | UHC-01749-02 | 3153862451 | 9561 Lincoln Way # 196, Miami, FL, 33112 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+1 more |
| PRV-25913 | PRV | Omar Bell | — | — | 7913942176 | — | 0.78 | Date of birth missingPhone reformattedPlan code upper-casedWhitespace trimmed+1 more |
| PRV-22415 | PRV | Sufia Smith | 1978-12-13 | — | 8097645285 | 7046 Market St, Las Vegas, NV, 89158 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-20201 | PRV | Paul Jimenez | 1977-10-17 | — | — | 1194 Pine Dr, Tempe, AZ, 85257 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-20250 | PRV | Camila Tran | 1973-11-02 | — | 8637311081 | 5949 Park Pl, Mesa, AZ, 85228 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-28906 | PRV | Daniel J Robertson | 1966-08-04 | — | 3075974977 | 2584 Sunset Blvd, Chandler, AZ, 85259 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-23024 | PRV | Sean Z Bishop | 1972-02-13 | — | 3277683915 | 1837 Grand Ave, Los Angeles, CA, 90082 | 0.78 | Date of birth reformattedPhone reformattedSSN last four extractedWhitespace trimmed+1 more |
| PRV-25408 | PRV | Mark Green | 1989-09-03 | — | 8669707947 | 9414 Pine Dr, Sacramento, CA, 95881 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20725 | PRV | Mei G Torres | 1955-05-20 | — | 2147934215 | 6149 Central Ave, Austin, TX, 78736 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-29207 | PRV | Lerry Hunt | 2006-04-09 | — | 5292811209 | 7696 Desert Sky Blvd, San Antonio, TX, 78273 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-29206 | PRV | Lerry Hunt | 2006-04-09 | — | 5292811209 | 7696 Desert Sky Blvd, San Antonio, TX, 78273 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20860 | PRV | Noah M Morales | 1958-04-26 | UHC-68816-49 | 3374582516 | 8322 Maple Ave, San Antonio, TX, 78212 | 0.78 | Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more |
| PRV-20767 | PRV | Roy Payne | 1987-01-20 | UHC-52043-76 | 2617780795 | 5791 Baseline Rd, Columbus, OH, 43228 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24615 | PRV | Theresa Payne | 1978-09-05 | — | 5907677118 | 9004 Sage Ct, Charlotte, NC, 28269 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more |
| PRV-28819 | PRV | Frank Yang | 1954-06-13 | UHC-01242-71 | 6147452696 | 4140 Jefferson Ave, Nashville, TN, 37272 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26716 | PRV | Bobby R Simpson | 1980-03-27 | UHC-39775-45 | 6924850062 | 4772 Highland Ave, Tempe, AZ, 85220 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28184 | PRV | Wei Johnson | 1980-11-23 | UHC-52953-76 | 8263425733 | 9776 Forest Ave, Sacramento, CA, 95855 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22812 | PRV | Donna Coleman | 1942-10-15 | UHC-56324-15 | 6245065244 | 7430 Palm Dr, Sacramento, CA, 95848 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20244 | PRV | Linda A Bishop | 1974-01-25 | — | 3506569452 | 2829 Pine Dr, Tampa, FL, 33684 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25338 | PRV | Austin Thomas | 2004-05-28 | UHC-15598-86 | 2043320144 | 9416 Ocean Ave, Sacramento, CA, 95859 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-23041 | PRV | Ethan Morrison | 1978-12-19 | UHC-86725-04 | 4174832668 | 8293 Harbor Blvd, Fresno, CA, 93715 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25997 | PRV | Nancy George | 1979-06-04 | UHC-95306-31 | 4115147965 | 436 Bayshore Dr, San Antonio, TX, 78234 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24734 | PRV | Madison D Bryant | 2006-08-09 | — | 8817913094 | 2645 Union St, Denver, CO, 80298 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22635 | PRV | Jean W Carr | 1969-06-27 | — | 9024075205 | 901 Central Ave, Los Angeles, CA, 90095 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-20317 | PRV | Jaun Thompson | 1963-12-24 | — | 6842047158 | 660 Willow Ct, Phoenix, AZ, 85031 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-22904 | PRV | Lisa Hayes | 1997-11-16 | UHC-48433-58 | 6132327411 | 3266 Mountain View Dr, Plano, TX, 75053 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21895 | PRV | Helen Webb | 1971-02-27 | — | 2317395609 | 8349 Broadway # 599, Los Angeles, CA, 90035 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedUnit split from street+1 more |
| PRV-22753 | PRV | Olivia Campbell | 1986-10-04 | — | 6424320170 | 5315 Indian School Rd, Glendale, AZ, 85319 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-20879 | PRV | Maria J Perez | 2000-02-01 | — | 5874100049 | 4692 Grand Ave, Denver, CO, 80296 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-25451 | PRV | Jerry I Patel | 1984-07-01 | UHC-16622-15 | 5747010969 | 3705 Washington St, Miami, FL, 33171 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-21816 | PRV | Jessica Mendez | 1958-11-24 | UHC-94335-21 | 2742227518 | 1455 Meadow Ln, Phoenix, AZ, 85016 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24164 | PRV | Ronad Valdez | 1995-11-13 | — | 6709085317 | 1195 Jefferson Ave, Nashville, TN, 37231 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |