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-22836 | PRV | Ethan Jordan | 1955-03-04 | — | 8715906335 | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-23394 | PRV | Carl Watson | 1947-06-09 | UHC-46114-22 | 6356141072 | 4297 Palm Dr, Miami, FL, 33100 | 0.84 | Name split from “Last, First”Placeholder values cleared |
| PRV-24884 | PRV | Ruth Mills | 1958-02-08 | UHC-76487-98 | 7223504715 | 6603 Elm St, Nashville, TN, 37205 | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-21502 | PRV | Richard Hudson | 1974-01-08 | — | 7017400006 | 7415 Sage Ct, Seattle, WA, 98183 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |
| PRV-24158 | PRV | Wei Moore | 1956-10-25 | — | — | — | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-28503 | PRV | Hiroshi O Howell | 1963-09-13 | — | 6724067669 | — | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-23807 | PRV | Jonathan Q Ruiz | 1954-10-10 | UHC-38105-67 | — | 5460 Broadway, Plano, TX, 75096 | 0.84 | Phone missing area codePlaceholder values cleared |
| PRV-27355 | PRV | Patrick H Jordan | 1948-08-20 | UHC-27638-29 | — | — | 0.84 | Middle initial moved out of first namePlaceholder values cleared |
| PRV-28079 | PRV | Brian Patel | 1955-12-13 | — | 8403111600 | 2765 Lincoln Way, Charlotte, NC, 28200 | 0.84 | Name split from “Last, First”Placeholder values cleared |
| PRV-20100 | PRV | Marcus Luna | 1991-11-07 | UHC-28607-59 | 3503922594 | 4042 Desert Sky Blvd, Scottsdale, AZ, 85225 | 0.84 | Street suffix standardisedAddress re-cased |
| PRV-25754 | PRV | Olivia Franklin | 2003-08-18 | — | 2308304907 | 2718 Palm Dr, Seattle, WA, 98101 | 0.84 | Street suffix standardisedAddress re-cased |
| PRV-22575 | PRV | Paul E Hollmes | — | UHC-05951-73 | 4465412660 | 5401 Forest Ave, Scottsdale, AZ, 85254 | 0.84 | Date of birth missingPhone reformatted |
| PRV-28824 | PRV | Zachary Harvey | 1981-02-22 | UHC-43673-22 | 9485635188 | — | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-26913 | PRV | Laauren Sandoval | 1955-08-17 | UHC-88391-59 | — | 3650 Willow Ct, Tucson, AZ, 85701 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-29502 | PRV | Noah N Fuller | 1992-09-24 | UHC-26908-10 | 5162435322 | 443 Broadway, Houston, TX, 77060 | 0.84 | State name converted to codePlaceholder values cleared |
| PRV-24125 | PRV | Mateo Wright | 1949-05-26 | — | — | 4302 Harbor Blvd, Columbus, OH, 43234 | 0.84 | State name converted to codePlaceholder values cleared |
| PRV-29120 | PRV | Alexis Elliott | 1965-02-04 | UHC-73306-15 | — | 9576 Cedar Ln, Atlanta, GA, 30344 | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-27754 | PRV | Martha U Richardson | 2002-07-26 | — | — | 3299 Ocean Ave, Glendale, AZ, 85360 | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-24120 | PRV | Wayne Richardson | — | — | 8955215588 | — | 0.84 | Date of birth unreadablePlaceholder values cleared |
| PRV-27732 | PRV | Olivia Chapman | 1956-02-05 | UHC-95278-33 | 5139680812 | 8780 Broadway, Orlando, FL, 32881 | 0.84 | Phone reformattedGender normalised |
| PRV-27915 | PRV | Ranndy Munoz | 2003-09-18 | UHC-21023-01 | 3436893410 | — | 0.84 | Name split from “Last, First”Phone reformatted |
| PRV-22145 | PRV | Lori S Williams | 1984-07-03 | UHC-29788-73 | 2018001039 | 7541 Washington St, Fresno, CA, 93734 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-29235 | PRV | Catherine Q Wright | 1952-12-03 | — | — | 4260 Lake View Rd, Jacksonville, FL, 32256 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |
| PRV-20314 | PRV | Kenneth Wong | 1994-06-21 | — | — | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-25252 | PRV | Cheryl Cunningham | 1963-02-20 | — | — | 9223 Elm St, Seattle, WA, 98192 | 0.84 | State name converted to codePlaceholder values cleared |
| PRV-24643 | PRV | George A Bryant | — | UHC-88695-40 | — | 2407 Bayshore Dr, San Diego, CA, 92181 | 0.84 | Date of birth missingPlaceholder values cleared |
| PRV-26600 | PRV | Martha Dixon | 1980-12-27 | — | 7392825747 | 6794 Park Pl, Atlanta, GA, 30377 | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-21814 | PRV | Kathryn W Perkins | 1957-12-14 | — | — | 4850 Park Pl, Columbus, OH, 43281 | 0.84 | Middle initial moved out of first namePlaceholder values cleared |
| PRV-26498 | PRV | —Junk | 1956-12-06 | UHC-73484-68 | 2032903503 | 6838 Maple Ave, Dallas, TX, 75299 | 0.84 | Placeholder values clearedNo usable name (quarantined) |
| PRV-26095 | PRV | Linda McDonald | 1980-04-09 | UHC-70228-56 | 6556550558 | 6056 Highland Ave, Atlanta, GA, 30385 | 0.84 | State name converted to codeWhitespace trimmed |
| PRV-27772 | PRV | Raymond D West | 1959-12-27 | — | — | 451 Union St, Columbus, OH, 43207 | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-22839 | PRV | George Banks | 1987-07-19 | UHC-71568-86 | 2085759809 | 8067 Washington St, Columbus, OH, 43209 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |
| PRV-27556 | PRV | Wayne Perkins | 1943-09-07 | UHC-83686-34 | 9098771961 | 5373 Highland Ave, Mesa, AZ, 85212 | 0.84 | Name split from “Last, First”Placeholder values cleared |
| PRV-28520 | PRV | Emily Nichols | — | — | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| PRV-28768 | PRV | Janice Smith | 1961-08-04 | — | — | 7340 Desert Sky Blvd, Tucson, AZ, 85721 | 0.84 | Name split from “Last, First”Placeholder values cleared |
| PRV-27300 | PRV | John Sanders | 1938-09-06 | — | 3628479163 | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-20932 | PRV | Teresa Wang | 1980-01-09 | — | — | 1451 Spring St, Los Angeles, CA, 90051 | 0.84 | SSN last four extractedPlaceholder values cleared |
| PRV-20316 | PRV | Juan Thompson | 1963-12-24 | — | 6842047158 | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-23489 | PRV | Hannah Sims | 1985-11-24 | UHC-61845-14 | — | 9768 Sunset Blvd, Dallas, TX, 75256 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-25288 | PRV | Anthony Bradley | 1982-07-03 | — | 9296947919 | 6735 Union St, Plano, TX, 75084 | 0.84 | State name converted to codePlaceholder values cleared |
| PRV-20853 | PRV | Frances Q Jamees | 1971-05-02 | UHC-12248-93 | 5543472192 | 947 Highland Ave Apt 31, Phoenix, AZ, 85020 | 0.84 | Unit split from streetPlaceholder values cleared |
| PRV-28559 | PRV | Kathy Le | 1987-06-08 | — | 9124584030 | 8323 Bayshore Dr, Tucson, AZ, 85782 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |
| PRV-21695 | PRV | Lauren Rivera | 1962-11-07 | UHC-27701-96 | 3962587334 | 3282 Canyon Rd, Austin, TX, 78734 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-28243 | PRV | Lauren Dunn | 1950-02-24 | UHC-63768-04 | — | 5143 Meadow Ln, Las Vegas, NV, 89119 | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-27433 | PRV | Omar Mendez | 1980-09-18 | — | 8877150749 | 6109 Broadway, Phoenix, AZ, 85004 | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-28886 | PRV | Kayla O Williamson | 1993-02-05 | — | 9517136921 | 5310 Indian School Rd, San Diego, CA, 92184 | 0.84 | State name converted to codePlaceholder values cleared |
| PRV-22348 | PRV | Bryan Ryan | 1983-06-11 | — | 9684781122 | — | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-22296 | PRV | Samantha Smith | 1958-06-16 | — | — | — | 0.84 | Phone missing area codePlaceholder values cleared |
| PRV-27582 | PRV | Theresa Andresw | 2005-05-21 | — | 3275187034 | 4366 Spring St, Charlotte, NC, 28247 | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-20426 | PRV | Willie F Valdez | 1943-12-12 | — | 5905463036 | 4034 River Rd # 223, Minneapolis, MN, 55475 | 0.84 | Unit split from streetPlaceholder values cleared |