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-22210 | PRV | Natalie Bihop | 1987-04-25 | — | 6973601068 | 5678 Baseline Rd, Fresno, CA, 93770 | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-25029 | PRV | Ana Woods | 1999-12-10 | — | 3853935205 | 9524 Broadway, Las Vegas, NV, 89124 | 0.82 | Name split from “Last, First”Whitespace trimmedPlaceholder values cleared |
| PRV-25028 | PRV | Ana Woods | 1999-12-10 | — | 3853935205 | 9524 Broadway, Las Vegas, NV, 89124 | 0.82 | Name split from “Last, First”Whitespace trimmedPlaceholder values cleared |
| PRV-23614 | PRV | Wayne Sanchez | 1962-10-15 | UHC-45559-54 | 2393987526 | 3186 Harbor Blvd, Los Angeles, CA, 90080 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-20136 | PRV | Vincent Espinoza | 1986-11-16 | — | 7908805643 | 6278 Apache Blvd, Columbus, OH, 43266 | 0.82 | ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared |
| PRV-23637 | PRV | Hiroshi S Mason | 1963-11-06 | — | 8542356009 | 410 Cedar Ln, Eden Prairie, MN | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-24953 | PRV | Mark Mills | 1962-04-06 | — | 6477423538 | 5792 Broadway, Glendale, AZ | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-24952 | PRV | Mark Mills | 1962-04-06 | — | 6477423538 | 5792 Broadway, Glendale, AZ | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-20583 | PRV | Catherine Robinson | 1945-09-28 | — | 4729579668 | 1847 Willow Ct, San Diego, CA | 0.82 | ZIP missingWhitespace trimmedPlaceholder values cleared |
| PRV-25542 | PRV | Carl Banks | 1979-07-28 | UHC-44122-85 | 7795715705 | 7792 Jefferson Ave, Fresno, CA, 93782 | 0.82 | Two-digit birth yearWhitespace trimmedPlaceholder values cleared |
| PRV-27419 | PRV | Brittany Pierce | 1996-11-11 | UHC-41280-08 | — | 2934 Highland Ave, Austin, TX | 0.82 | Date of birth reformattedZIP missingPlaceholder values cleared |
| PRV-22453 | PRV | Deborha Alvarado | 2006-02-04 | — | — | 5707 Oak St, Nashville, TN, 37245 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-23472 | PRV | Douglas Obrien | 1966-08-26 | UHC-37735-01 | 2259087231 | 6471 Church St, Chandler, AZ, 85231 | 0.82 | Name split from “Last, First”Name re-casedPlaceholder values cleared |
| PRV-26440 | PRV | Janet Hunter | 2005-01-06 | — | — | 5117 Lake View Rd, Charlotte, NC, 28256 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-26940 | PRV | Jessica Elliott | 2005-07-04 | UHC-51147-59 | 7989824634 | 2452 Maple Ave, Tempe, AZ, 85284 | 0.82 | SSN last four extractedWhitespace trimmedPlaceholder values cleared |
| PRV-27347 | PRV | Samantha R Gonzales | 2008-03-06 | UHC-82018-07 | 5262306122 | 1965 Meadow Ln, San Diego, CA, 92159 | 0.82 | Name split from “Last, First”Phone reformattedPlaceholder values cleared |
| PRV-24770 | PRV | Angela Fernandez | 2007-09-26 | UHC-71368-61 | — | 2503 Church St, Miami, FL | 0.82 | ZIP missingWhitespace trimmedPlaceholder values cleared |
| PRV-26177 | PRV | Beverly Soto | 1981-08-25 | UHC-36735-65 | — | 5451 Camelback Rd, Fresno, CA, 93714 | 0.82 | Date of birth reformattedGender normalisedPlaceholder values cleared |
| PRV-22356 | PRV | Ahmed J Phillips | 1944-01-07 | UHC-63412-32 | 9868312555 | 324 Park Pl, Gilbert, AZ | 0.82 | Phone reformattedZIP missingPlaceholder values cleared |
| PRV-26876 | PRV | Richard Boyd | 1960-01-03 | — | 2893718455 | 3990 Oak St, Tucson, AZ, 85789 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-27159 | PRV | John Rice | 2000-08-08 | — | — | 9658 Elm St, Orlando, FL, 32827 | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-26568 | PRV | Janice R Wong | 1966-03-21 | — | — | 3914 Sunset Blvd, Fresno, CA, 93741 | 0.82 | City re-casedGender normalisedPlaceholder values cleared |
| PRV-22646 | PRV | Walter Peterson | 1965-10-07 | — | — | 4110 Spring St, Seattle, WA, 98144 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-20374 | PRV | Carolyn L Bell | 1969-03-05 | UHC-32776-84 | 4494201473 | 2347 Mesa Dr, Charlotte, NC | 0.82 | ZIP missingWhitespace trimmedPlaceholder values cleared |
| PRV-22657 | PRV | Anthony Jackson | 1944-11-05 | UHC-65660-68 | 9219517579 | 561 Main St, Los Angeles, CA, 90035 | 0.82 | City re-casedState name converted to codePlaceholder values cleared |
| PRV-25851 | PRV | Sean Morgan | 2005-10-24 | — | 6436372880 | 2936 Canyon Rd, Las Vegas, NV, 89133 | 0.82 | Phone reformattedGender normalisedPlaceholder values cleared |
| PRV-26821 | PRV | Juna S Bradley | 1951-04-10 | — | 2158354537 | 8530 Hillcrest Rd, Charlotte, NC, 28274 | 0.82 | Middle initial moved out of first nameWhitespace trimmedPlaceholder values cleared |
| PRV-28894 | PRV | Frances Rice | 1939-04-09 | UHC-56562-77 | — | 817 Washington St, Las Vegas, NV, 89154 | 0.82 | Member ID reformattedGender normalisedPlaceholder values cleared |
| PRV-24107 | PRV | Jesse M Sandoval | 1962-10-14 | UHC-22226-32 | 8762674493 | 2084 Jefferson Ave, Jacksonville, FL, 32286 | 0.82 | Two-digit birth yearPhone reformattedPlaceholder values cleared |
| PRV-28349 | PRV | Shirley Gordon | 1945-10-15 | UHC-16318-59 | — | 734 Park Pl, Los Angeles, CA, 90082 | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-26604 | PRV | Paul Arnold | 2008-11-11 | — | — | 4396 Jefferson Ave, Miami, FL, 33145 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-27442 | PRV | Carol Payne | 1945-09-02 | — | 3997799243 | 9850 Mountain View Dr, Seattle, WA, 98130 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-28450 | PRV | Bobby Ward | 1955-10-01 | UHC-67393-89 | 9548406979 | 5410 Ocean Ave, Nashville, TN, 37255 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-27960 | PRV | Julia Brown | 1989-05-17 | — | 9502303813 | 8084 Main St # 202, Sacramento, CA, 95885 | 0.82 | Date of birth reformattedUnit split from streetPlaceholder values cleared |
| PRV-21617 | PRV | Sofia Sims | 1955-06-06 | — | — | — | 0.82 | Name split from “Last, First”Whitespace trimmedPlaceholder values cleared |
| PRV-28750 | PRV | Kyle Contreras | 1962-06-10 | UHC-17396-44 | 5368965463 | 7575 Canyon Rd, Denver, CO, 80251 | 0.82 | Phone reformattedZIP+4 trimmedPlaceholder values cleared |
| PRV-23260 | PRV | Bruce R Morgan | 2006-11-24 | UHC-19389-24 | 3497162438 | 5416 Camelback Rd, Gilbert, AZ, 85252 | 0.82 | ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared |
| PRV-25909 | PRV | Linda Hill | 1999-06-21 | UHC-06589-71 | 6657552053 | 1446 Bayshore Dr, Denver, CO, 80222 | 0.82 | Phone reformattedStreet suffix standardisedAddress re-cased |
| PRV-21110 | PRV | Amy Wagner | — | UHC-05819-84 | 6112867706 | 1324 Bayshore Dr, Columbus, OH, 43269 | 0.82 | Date of birth missingPhone reformattedPlaceholder values cleared |
| PRV-27290 | PRV | Lauren K James | 1978-08-05 | UHC-83197-90 | 4453468381 | — | 0.82 | Two-digit birth yearPhone reformattedWhitespace trimmed |
| PRV-24057 | PRV | Olivia Huunt | 2002-12-18 | UHC-49329-86 | 2317836571 | 1027 Oak St, Mesa, AZ, 85241 | 0.82 | Street suffix standardisedAddress re-casedPlaceholder values cleared |
| PRV-28063 | PRV | Brittany Murray | 1994-03-07 | UHC-32349-76 | — | — | 0.82 | Phone missing area codeWhitespace trimmedPlaceholder values cleared |
| PRV-25585 | PRV | Bryan Morris | 1944-12-09 | UHC-75126-91 | 3758720481 | — | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-27723 | PRV | Jackie F Stewart | 1963-11-10 | — | 2274808705 | — | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-28855 | PRV | Adam Sanders | 1948-02-04 | UHC-93095-79 | — | 1697 Broadway, Tempe, AZ, 85279 | 0.82 | Gender normalisedWhitespace trimmedPlaceholder values cleared |
| PRV-21943 | PRV | Priya N Adams | 2008-05-26 | — | — | 8489 Washington St, Orlando, FL | 0.82 | Date of birth reformattedZIP missingPlaceholder values cleared |
| PRV-27017 | PRV | Christine E Cunningham | 2002-02-17 | UHC-89978-63 | 2123102804 | 5620 Canyon Rd, Chandler, AZ, 85224 | 0.82 | Street suffix standardisedAddress re-casedWhitespace trimmed |
| PRV-26318 | PRV | Katherine Hughes | 1964-08-18 | — | 9573748697 | 3745 Maple Ave Apt 17, San Diego, CA, 92114 | 0.82 | Phone reformattedUnit split from streetPlaceholder values cleared |
| PRV-22775 | PRV | Becky Campbell | — | UHC-35903-72 | 7623964285 | 5109 Indian School Rd, Dallas, TX, 75253 | 0.82 | Name re-casedDate of birth unreadablePlaceholder values cleared |
| PRV-29460 | PRV | Melissa Gibson | 1946-03-15 | — | 9548196908 | 8469 Oak St, Columbus, OH, 43204 | 0.82 | Two-digit birth yearCity re-casedPlaceholder values cleared |