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-24401 | PRV | Wei N Foster | 1994-11-03 | — | 6534728447 | — | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-23152 | PRV | Laura W Johnsoon | 1981-01-03 | — | — | 184 Meadow Ln, San Antonio, TX, 78203 | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-25387 | PRV | Rahel Maldonado | 1992-09-16 | — | 9326109587 | 7516 Meadow Ln, Scottsdale, AZ, 85254 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-27623 | PRV | Ethan Chavez | 1989-09-10 | UHC-17655-21 | 7199302937 | 7974 Lincoln Way, Denver, CO, 80250 | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-25312 | PRV | Fatima K Grant | 1940-04-28 | UHC-54519-79 | — | — | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-22044 | PRV | Heather Duncan | 1958-11-01 | UHC-89472-32 | 6719271132 | 7625 Desert Sky Blvd, Dallas, TX, 75279 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| PRV-23738 | PRV | Bryan Murray | 1995-11-15 | UHC-67709-72 | 4107677508 | 6402 Mesa Dr # 507, Chandler, AZ, 85239 | 0.82 | Unit split from streetWhitespace trimmedPlaceholder values cleared |
| PRV-27377 | PRV | Gregory V Weaver | 1940-03-01 | — | — | 2147 Hillcrest Rd, Denver, CO | 0.82 | ZIP missingWhitespace trimmedPlaceholder values cleared |
| PRV-21984 | PRV | Patricia Mendez | 2004-07-01 | — | — | 7575 Union St, Minneapolis, MN, 55404 | 0.82 | Two-digit birth yearWhitespace trimmedPlaceholder values cleared |
| PRV-23167 | PRV | Willie V Dunn | 1967-09-07 | UHC-04570-88 | 2374412395 | 7513 Jefferson Ave, Minneapolis, MN, 55476 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-28680 | PRV | Kenneth Cox | 1953-06-17 | UHC-45864-37 | — | 3484 Maple Ave, Glendale, AZ, 85331 | 0.82 | Name re-casedState name converted to codePlaceholder values cleared |
| PRV-25952 | PRV | Christina Hunter | — | UHC-22457-29 | 6496449248 | 8080 Palm Dr, Atlanta, GA, 30331 | 0.82 | Date of birth unreadableMember ID reformattedPlaceholder values cleared |
| PRV-27305 | PRV | Benjamin Rose | 2007-04-19 | — | — | 3350 Maple Ave, Scottsdale, AZ, 85216 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-23175 | PRV | Gabriel Ferguson | 1942-03-27 | — | 3412818924 | 2571 Spring St, Mesa, AZ, 85225 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-27745 | PRV | Pamela N Reid | 1986-07-06 | UHC-83233-52 | — | 8710 Sunset Blvd, Houston, TX | 0.82 | Date of birth reformattedZIP missingPlaceholder values cleared |
| PRV-20030 | PRV | Denise E Elliott | 1948-09-26 | UHC-47105-88 | 4197073922 | — | 0.82 | Date of birth reformattedGender normalisedPlaceholder values cleared |
| PRV-22560 | PRV | Brenda K Ferguson | 1952-03-13 | UHC-73878-49 | 7465010029 | 7666 Harbor Blvd, Seattle, WA, 98150 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-25402 | PRV | Eugene Gordon | 2000-06-13 | UHC-51400-98 | 3958359187 | 3363 Forest Ave, Las Vegas, NV, 89134 | 0.82 | Phone reformattedState name converted to codePlan code upper-cased |
| PRV-24189 | PRV | Ethan Walsh | 1984-12-22 | — | 9759648932 | 1433 Sage Ct, Charlotte, NC, 28268 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-23832 | PRV | Luis I Rodriguez | 2003-04-28 | UHC-22104-96 | 7622578773 | 2126 Main St, Fresno, CA, 93734 | 0.82 | Middle initial moved out of first namePhone reformattedCity re-cased |
| PRV-29264 | PRV | Christine Wallace | 1961-08-25 | UHC-56875-41 | 2527295340 | 8665 Camelback Rd, Eden Prairie, MN, 55309 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-22256 | PRV | Kimberly Bryant | 2001-09-27 | — | 6588041763 | 9728 Lincoln Way # 837, Orlando, FL, 32888 | 0.82 | Date of birth reformattedUnit split from streetPlaceholder values cleared |
| PRV-25792 | PRV | Maria M Banks | 1962-11-18 | UHC-03666-24 | 3439996331 | — | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-25946 | PRV | Dot Weaver | 1941-10-26 | — | 3279370475 | 916 Jefferson Ave, Seattle, WA, 98185 | 0.82 | Phone reformattedState name converted to codePlaceholder values cleared |
| PRV-28989 | PRV | Randy Matthews | 1958-06-21 | UHC-30155-02 | — | 4302 Jefferson Ave, Miami, FL, 33187 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-29001 | PRV | Larry Hansen | 1999-08-13 | — | 4752587529 | 5799 Union St, Tucson, AZ, 85752 | 0.84 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+4 more |
| PRV-26813 | PRV | Judy Gordon | 1970-11-01 | UHC-42219-38 | 4996647707 | 6485 Market St, San Antonio, TX, 78232 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-24180 | PRV | Megan I Andrews | 1974-07-14 | — | 4377103717 | 9086 Palm Dr Apt 11, Columbus, OH, 43274 | 0.84 | Unit split from streetPlaceholder values cleared |
| PRV-29479 | PRV | Martha Williamson | 1995-08-06 | — | 5406969099 | 364 Broadway, Plano, TX, 75094 | 0.84 | State name converted to codePlaceholder values cleared |
| PRV-29135 | PRV | Josh Gonzales | 2001-03-06 | — | 4668332251 | 4712 Sunset Blvd, Phoenix, AZ, 85052 | 0.84 | Name split from “Last, First”Placeholder values cleared |
| PRV-21394 | PRV | Joe Anderson | 1948-09-01 | UHC-12753-63 | 9243463238 | 2779 Baseline Rd, Houston, TX, 77064 | 0.84 | Gender normalisedWhitespace trimmed |
| PRV-23466 | PRV | Mariana G Riley | 1959-06-25 | UHC-27492-53 | 2787018958 | 5620 Valley View Dr, Gilbert, AZ, 85263 | 0.84 | Date of birth reformattedGender normalised |
| PRV-21803 | PRV | —Junk | 1946-03-19 | UHC-94319-73 | 9755294351 | — | 0.84 | Whitespace trimmedNo usable name (quarantined) |
| PRV-28025 | PRV | Helen Chen | 1941-09-22 | — | 7802985905 | — | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-21067 | PRV | Christina A Rice | 1951-10-22 | UHC-34431-50 | 5904631125 | 3889 Mountain View Dr # 667, Gilbert, AZ, 85286 | 0.84 | Unit split from streetPlaceholder values cleared |
| PRV-29296 | PRV | Beverly Warren | 1949-07-15 | UHC-50109-81 | — | — | 0.84 | Phone missing area codePlaceholder values cleared |
| PRV-23028 | PRV | Amber Salazar | 1962-12-17 | — | 3498815048 | 1069 Sunset Blvd, Las Vegas, NV, 89103 | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-22734 | PRV | Charlotte G Nuenz | 1991-06-08 | UHC-60651-71 | — | 3202 Meadow Ln, Phoenix, AZ, 85016 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |
| PRV-26719 | PRV | Terry West | 1982-11-25 | — | — | — | 0.84 | Phone missing area codePlaceholder values cleared |
| PRV-27734 | PRV | Nicholas Arnold | 1982-05-18 | UHC-60710-65 | — | 6306 Indian School Rd, Gilbert, AZ, 85226 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-25394 | PRV | Ronald Price | 1983-08-01 | UHC-60219-54 | 2872778067 | — | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-20225 | PRV | Ronald Perez | 1980-01-07 | — | — | 3180 Elm St, Charlotte, NC, 28284 | 0.84 | Two-digit birth yearPlaceholder values cleared |
| PRV-22242 | PRV | Hannah Clark | 1981-05-15 | UHC-95602-29 | 6819926218 | 2713 Jefferson Ave, Fresno, CA, 93737 | 0.84 | State name converted to codePlaceholder values cleared |
| PRV-24745 | PRV | Mariana T Kelly | — | UHC-73475-49 | — | — | 0.84 | Date of birth missingPlaceholder values cleared |
| PRV-24749 | PRV | Alexaner Johnston | 2006-02-24 | — | — | 3793 Lake View Rd, Gilbert, AZ, 85247 | 0.84 | Name split from “Last, First”Placeholder values cleared |
| PRV-27792 | PRV | Joan Morales | 1945-05-09 | — | 3524229122 | 2787 Union St, Jacksonville, FL, 32218 | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-25596 | PRV | Jemes Martin | 1966-02-17 | — | — | 5807 Lincoln Way, Tampa, FL, 33651 | 0.84 | Name split from “Last, First”Placeholder values cleared |
| PRV-29387 | PRV | Jesse Coleman | 1983-02-04 | — | 3459386945 | — | 0.84 | Name split from “Last, First”Placeholder values cleared |
| PRV-28597 | PRV | Randy Torres | 1994-12-12 | UHC-32787-64 | — | — | 0.84 | Gender normalisedPlaceholder values cleared |
| PRV-25525 | PRV | Anna Edwards | 2001-12-09 | UHC-19151-80 | 8842739842 | 3858 Willow Ct, Seattle, WA, 98135 | 0.84 | ZIP+4 trimmedPlaceholder values cleared |