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-24616 | PRV | Larry Mejia | 1944-06-07 | — | 8282764875 | 3854 Desert Sky Blvd Apt 20, Jacksonville, FL, 32222 | 0.64 | Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more |
| PRV-22228 | PRV | Kelley Abgail | 1987-10-27 | UHC-49343-30 | 2325778514 | 3540 Harbor Blvd, Seattle, WA, 98172 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24332 | PRV | Eugene Crawford | 1980-09-21 | — | 8894951061 | 2129 Indian School Rd # 429, Scottsdale, AZ, 85202 | 0.64 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| PRV-28154 | PRV | Teresa Z Coleman | 2005-06-26 | — | 8149449845 | 5737 Maple Ave, Phoenix, AZ, 85029 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26944 | PRV | Ethan Phillips | 1996-03-07 | UHC-99113-47 | 5539981186 | 8497 Oak St, Gilbert, AZ, 85282 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27041 | PRV | Judy Montgomery | 1962-02-14 | UHC-91198-73 | 7003875748 | 6221 Central Ave, Eden Prairie, MN, 55388 | 0.64 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more |
| PRV-27074 | PRV | Denise Z Jackson | 1949-03-07 | — | 6568391082 | 3077 Valley View Dr, Tampa, FL, 33626 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-25705 | PRV | Gerald Banks | 1998-10-17 | — | 6513665118 | 1424 Desert Sky Blvd, Mesa, AZ, 85258 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27116 | PRV | George Estrada | 1998-05-24 | — | 2219716731 | 958 Church St, Tempe, AZ | 0.64 | Two-digit birth yearPhone reformattedCity re-casedZIP missing+2 more |
| PRV-24532 | PRV | Jason Nelson | 1940-05-07 | — | 2235692840 | 563 Church St, Sacramento, CA, 95840 | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-23481 | PRV | Frances Y Carter | 1961-01-06 | UHC-52031-78 | 2495772154 | 2331 Lincoln Way, Charlotte, NC | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-23985 | PRV | Catherine Robertson | 1941-07-02 | — | 4203820793 | 4634 Desert Sky Blvd, Fresno, CA, 93766 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-22378 | PRV | Logan Walsh | 1984-05-12 | UHC-23715-26 | — | 1129 Lake View Rd, Tucson, AZ | 0.64 | Name re-casedDate of birth reformattedZIP missingGender normalised+2 more |
| PRV-27454 | PRV | Timothy Hicks | 1997-03-13 | UHC-44481-21 | 7662384445 | — | 0.64 | Name split from “Last, First”Two-digit birth yearPhone reformattedEmail lower-cased+2 more |
| PRV-22996 | PRV | Walter S Moreno | 1992-12-06 | — | 9563890151 | 7959 Canyon Rd, Sacramento, CA, 95880 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-23241 | PRV | Gabriel Castillo | 1990-10-01 | — | 3968841043 | 1163 Church St, Plano, TX, 75066 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-21989 | PRV | Maria Robinson | 1962-12-03 | UHC-39058-94 | 2829200240 | 717 Grand Ave, Columbus, OH | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-28731 | PRV | Noah A Tucker | 1993-06-02 | — | — | 2659 Park Pl, Columbus, OH, 43219 | 0.64 | Name split from “Last, First”City re-casedEmail lower-casedGender normalised+2 more |
| PRV-23844 | PRV | Frank Q Bailey | 1949-06-25 | UHC-20314-33 | — | 7687 Indian School Rd Apt 20, Las Vegas, NV, 89150 | 0.64 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-29065 | PRV | Sarah Dunn | 1966-04-16 | — | 2545140687 | 4136 Grand Ave, Dallas, TX, 75268 | 0.64 | Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more |
| PRV-24404 | PRV | Laura Stone | 1995-02-17 | — | 8614098541 | 9078 Canyon Rd, Tampa, FL, 33658 | 0.64 | Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more |
| PRV-24862 | PRV | Lori Walsh | 1995-11-06 | — | 8303002309 | 3222 Meadow Ln, Dallas, TX, 75264 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-23250 | PRV | Mark Powell | 1998-09-12 | UHC-33325-83 | 2834216239 | 9187 Ocean Ave, Plano, TX, 75022 | 0.64 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-20980 | PRV | Armstrong Ryen | 1961-12-15 | UHC-91572-43 | 6582708039 | 608 Spring St, Tampa, FL | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27605 | PRV | Donna Silva | 1989-10-06 | UHC-90917-79 | — | 9374 Sage Ct # 789, Las Vegas, NV, 89168 | 0.64 | Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more |
| PRV-21898 | PRV | Virginia N Greene | 2005-06-22 | — | 2655524091 | 4747 Willow Ct, San Diego, CA, 92152 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more |
| PRV-28204 | PRV | Mateo Miller | 2000-08-15 | UHC-99133-72 | 7718582429 | 1423 Spring St Apt 40, Nashville, TN, 37299 | 0.64 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more |
| PRV-25587 | PRV | Donald Burton | 1973-02-10 | — | 8252467993 | 8911 Sunset Blvd, Houston, TX, 77089 | 0.64 | Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+2 more |
| PRV-21964 | PRV | Douglas Q Schultz | 1954-10-05 | — | 3506044122 | 3506 Baseline Rd, Miami, FL, 33103 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-21935 | PRV | Douglas F Garza | 1946-09-15 | UHC-82645-48 | 2734276134 | 1168 Cedar Ln, Phoenix, AZ, 85069 | 0.64 | Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-21232 | PRV | Bell M Emily | 2008-06-26 | — | 8886001377 | 1694 Harbor Blvd, Nashville, TN, 37238 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |
| PRV-26504 | PRV | Daniel Kim | 1958-09-25 | — | 5024941594 | 3734 Mesa Dr, Nashville, TN, 37231 | 0.64 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-29309 | PRV | Roy James | 2008-11-12 | — | 5557193929 | 6635 Park Pl, Las Vegas, NV, 89178 | 0.64 | Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more |
| PRV-25020 | PRV | Diane G Rogers | 2004-10-08 | UHC-26032-76 | 9448180415 | 7771 Maple Ave, Gilbert, AZ, 85215 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-28573 | PRV | Christine Vega | 1995-04-02 | UHC-51289-46 | — | 3340 Willow Ct, Atlanta, GA, 30342 | 0.64 | Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more |
| PRV-27247 | PRV | Bradley Russell | 1976-02-07 | — | 5219562117 | 3277 Bayshore Dr, Sacramento, CA, 95833 | 0.64 | Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more |
| PRV-27827 | PRV | Judith Grant | 1968-06-16 | UHC-73698-48 | 5394379731 | 7974 Ridge Rd, Sacramento, CA, 95824 | 0.64 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-22580 | PRV | Judith H Lopez | 1955-12-23 | UHC-71589-82 | 8656504963 | 7203 Market St, Columbus, OH, 43283 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-25958 | PRV | Madison C Flores | — | UHC-58663-08 | 4069253912 | 4481 Mountain View Dr, Gilbert, AZ, 85252 | 0.64 | Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased+2 more |
| PRV-26950 | PRV | Paul T Morgan | 1948-09-10 | — | — | 4504 Lake View Rd, Phoenix, AZ, 85044 | 0.64 | Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more |
| PRV-27830 | PRV | Ruth Spencer | 2002-07-12 | — | 4788432334 | 1966 Main St, Tempe, AZ, 85241 | 0.64 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-26893 | PRV | Eugene C Padilla | 2007-06-27 | UHC-02340-28 | 5378633073 | 1804 Ridge Rd, Chandler, AZ | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-23033 | PRV | Kayla Bailey | — | — | 6419740117 | 5758 Pine Dr, Columbus, OH, 43256 | 0.64 | Date of birth missingPhone reformattedState name converted to codeEmail lower-cased+2 more |
| PRV-22396 | PRV | Helen Austin | 2003-09-10 | UHC-03615-98 | 5828197153 | 9204 Ridge Rd, Glendale, AZ | 0.64 | Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more |
| PRV-26172 | PRV | Brenda Jenkins | 1998-06-28 | — | 4452347436 | 8124 Ridge Rd, Las Vegas, NV, 89173 | 0.64 | Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24445 | PRV | Jacob Banks | 1988-07-10 | UHC-77320-90 | 4548488407 | 5849 Cedar Ln, Mesa, AZ | 0.64 | Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more |
| PRV-24419 | PRV | Gerald Tucker | 1941-04-21 | UHC-93483-60 | — | 3156 Canyon Rd, Tucson, AZ, 85768 | 0.64 | Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more |
| PRV-23899 | PRV | Debra Andrews | 1954-06-12 | UHC-65044-44 | 9074490704 | 6835 Jefferson Ave, Tempe, AZ, 85246 | 0.64 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-27663 | PRV | Charlotte H Harrison | 1984-07-09 | UHC-95450-37 | 6477884467 | 6728 Elm St, Seattle, WA, 98198 | 0.64 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more |
| PRV-24921 | PRV | Helen Mejia | 1987-01-20 | — | 9608719395 | 9445 Desert Sky Blvd, Eden Prairie, MN, 55352 | 0.64 | Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more |