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-20339 | PRV | Angela Mills | 1973-10-09 | UHC-64081-98 | 7142756815 | 3753 Harbor Blvd, Tucson, AZ | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28985 | PRV | Ketherine G Black | 1997-07-25 | UHC-68969-40 | 2322677319 | 45 Palm Dr, Tucson, AZ, 85765 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23937 | PRV | Jacqueline Padilla | 1985-07-25 | UHC-58059-62 | 6917465292 | 8450 Cedar Ln Apt 34, Fresno, CA, 93782 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-25822 | PRV | Arthur Sanders | 1946-01-06 | — | 7082885927 | 8522 Main St # 670, Orlando, FL, 32809 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-24113 | PRV | —Junk | 2004-11-27 | — | 5989373221 | 1699 Hillcrest Rd, Miami, FL, 33123 | 0.62 | Two-digit birth yearPhone reformattedCity re-casedEmail lower-cased+3 more |
| PRV-26561 | PRV | Dylan King | 1987-06-20 | — | 4903523959 | 1249 Washington St # 678, Austin, TX, 78754 | 0.62 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-20177 | PRV | Harold X West | 2003-10-12 | — | 3109956201 | 9739 Pine Dr, Mesa, AZ, 85270 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-21601 | PRV | Wayne Gutierrez | 1982-11-13 | — | 4287131616 | 7979 Park Pl, Miami, FL, 33196 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25148 | PRV | Diane Kim | 1961-07-22 | — | 2785322639 | 7258 Spring St, Los Angeles, CA, 90069 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23047 | PRV | Harodl P Rojas | 1972-04-17 | — | 4998740265 | 8669 Union St, Tempe, AZ, 85224 | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25382 | PRV | Bobby Banks | 1976-05-12 | — | 4622759381 | 5703 Valley View Dr # 468, Eden Prairie, MN, 55306 | 0.62 | Name re-casedPhone reformattedUnit split from streetEmail lower-cased+3 more |
| PRV-29583 | PRV | Steve Marquez | 2002-01-24 | UHC-20259-21 | 8772854623 | 1142 Hillcrest Rd, Sacramento, CA, 95864 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20965 | PRV | Rachel Hughes | 1969-06-06 | — | 5384126473 | 3782 Meadow Ln, Glendale, AZ, 85328 | 0.62 | Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25189 | PRV | Jeremy Young | 1981-06-24 | — | 9063797467 | 4942 Main St, Las Vegas, NV, 89132 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27060 | PRV | Cynthia N Elliott | 2006-11-12 | — | 3158330590 | 9783 Grand Ave, Scottsdale, AZ | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27799 | PRV | Gerald K Robertson | 1945-09-20 | — | 3807900615 | 2789 Palm Dr, Phoenix, AZ, 85083 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26077 | PRV | Maria W Romero | 1964-03-15 | UHC-35666-67 | 8954560231 | 4347 Willow Ct Apt 31, Dallas, TX, 75275 | 0.62 | Name re-casedPhone reformattedUnit split from streetCity re-cased+3 more |
| PRV-27729 | PRV | Lauren Nunz | 1981-10-25 | — | 7892727876 | 4391 Oak St, Nashville, TN, 37213 | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more |
| PRV-24380 | PRV | Dennis Dunn | 1984-08-27 | UHC-10436-45 | 2045820357 | 8612 Central Ave, Fresno, CA, 93783 | 0.62 | Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+3 more |
| PRV-28709 | PRV | Michael Romero | 1944-04-01 | — | 9586948183 | 118 Washington St, Tucson, AZ | 0.62 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-26868 | PRV | Sean S James | 1978-05-06 | — | 9112757314 | 7309 Mountain View Dr, Tucson, AZ, 85758 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22261 | PRV | Samantha L Nelson | 1986-06-05 | — | 3894137288 | 5634 Bayshore Dr, Sacramento, CA, 95855 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24830 | PRV | Jerry P Weaver | 1993-07-21 | UHC-19409-86 | 3339887182 | 1888 Union St, Charlotte, NC, 28240 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24091 | PRV | Jesse Ward | 2002-03-04 | — | 2216734126 | 1208 Elm St, Nashville, TN, 37290 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-26402 | PRV | Mariana Auztin | 1967-10-15 | UHC-60247-95 | 7875392929 | 5576 Oak St, Denver, CO, 80282 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-29051 | PRV | Richard Park | 2000-11-22 | UHC-05141-79 | 4204467255 | 3576 Lincoln Way, Orlando, FL, 32872 | 0.62 | Two-digit birth yearPhone reformattedMember ID reformattedCity re-cased+3 more |
| PRV-29571 | PRV | Jacob Thompsun | — | UHC-30058-05 | 5192541939 | 5028 Sunset Blvd, Scottsdale, AZ, 85244 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| PRV-29088 | PRV | Jose Chapman | 1986-04-28 | UHC-83579-02 | 6678876082 | 4506 Park Pl, San Diego, CA | 0.62 | Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+3 more |
| PRV-24408 | PRV | Aaron Stone | 1966-01-28 | — | 7802243948 | 14 Park Pl Apt 6, Gilbert, AZ, 85205 | 0.62 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-25564 | PRV | Kathyn X Mills | 2008-02-24 | — | 9339949389 | 2641 Ocean Ave, Miami, FL, 33111 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23640 | PRV | Karen V Pierce | 1989-09-28 | UHC-84649-94 | 3976905635 | 6535 Grand Ave Apt 10, San Antonio, TX, 78223 | 0.62 | Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-23085 | PRV | Joshua Rogers | 1964-01-23 | — | 7892493354 | 7625 Maple Ave, San Diego, CA, 92187 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-21864 | PRV | Judith H Collins | 1940-07-01 | — | 8037802188 | 7317 Sage Ct # 494, Minneapolis, MN, 55427 | 0.62 | Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-28244 | PRV | Eugene K Gylbert | 1987-07-03 | UHC-27936-75 | 7022805732 | 3071 Maple Ave, Minneapolis, MN, 55412 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28377 | PRV | Lisa Lane | 1949-06-28 | — | 2746520307 | 9503 Meadow Ln, Las Vegas, NV, 89147 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27680 | PRV | Logan T Snyder | 1966-08-02 | UHC-28743-44 | 7504947853 | 6657 Jefferson Ave, Columbus, OH | 0.62 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-29300 | PRV | Camila Fuller | 1989-01-15 | — | 6003770152 | 5726 Church St, Sacramento, CA, 95831 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28356 | PRV | Joan K Allen | 1967-12-22 | UHC-42345-40 | 8603679884 | 7075 Harbor Blvd, Orlando, FL | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29057 | PRV | Bobby Arnold | 1987-06-23 | UHC-31712-74 | 7503559603 | 9386 Harbor Blvd, Columbus, OH, 43263 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25648 | PRV | Ashley Hall | 2002-03-15 | — | 2685977492 | 5373 Jefferson Ave # 694, Nashville, TN, 37281 | 0.62 | Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more |
| PRV-27504 | PRV | Ethan Spencer | 2002-01-09 | UHC-46162-88 | 2807486166 | 8718 Ocean Ave, Atlanta, GA, 30361 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27503 | PRV | Ethan Spencer | 2002-01-09 | UHC-46162-88 | 2807486166 | 8718 Ocean Ave, Atlanta, GA, 30361 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22416 | PRV | Anthony Torres | 1940-10-14 | — | 8453167535 | 6430 Palm Dr Apt 8, Sacramento, CA, 95812 | 0.62 | Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more |
| PRV-28026 | PRV | Gregry Sandoval | 1980-02-21 | — | 3753785007 | 1634 Mesa Dr, Jacksonville, FL, 32266 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23418 | PRV | Juan Coleman | 2008-05-26 | — | 9683616772 | 8188 Desert Sky Blvd, Sacramento, CA, 95880 | 0.62 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20038 | PRV | Betty Weaver | — | — | 5137176082 | 662 Palm Dr, Glendale, AZ, 85395 | 0.62 | Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more |
| PRV-23992 | PRV | Henry Q Dan | 1970-09-10 | UHC-91438-57 | 6778814211 | 2175 Jefferson Ave, Glendale, AZ, 85347 | 0.62 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25259 | PRV | Joyce M Webb | 1940-07-21 | UHC-86059-45 | 4087064188 | 4877 Grand Ave, Seattle, WA, 98187 | 0.62 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27509 | PRV | Virginia F Graham | 1965-09-01 | UHC-41763-34 | 2764573892 | 4219 Mesa Dr, Austin, TX | 0.62 | Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+3 more |
| PRV-25403 | PRV | Vincent Silva | 1964-12-23 | — | 2332513398 | 1724 Valley View Dr, Miami, FL, 33182 | 0.62 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |