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-25227 | PRV | Jake Walker | 1999-02-27 | — | 4869501794 | — | 0.96 | Email lower-casedPlaceholder values cleared |
| PRV-29201 | PRV | Natalie Moore | 1963-05-18 | UHC-14789-97 | 2732498869 | 1524 Valley View Dr, Austin, TX, 78776 | 0.96 | Email lower-casedPlaceholder values cleared |
| PRV-27659 | PRV | Donna Q Raamirez | 1978-07-06 | — | 3333590613 | 7362 Valley View Dr, Nashville, TN, 37254 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-27590 | PRV | Alexander Waltter | 1973-02-12 | UHC-88465-66 | — | 7153 Lincoln Way, Gilbert, AZ, 85245 | 0.96 | Email lower-casedPlaceholder values cleared |
| PRV-23919 | PRV | Richard Greene | 1997-02-19 | — | — | 1273 Spring St, Miami, FL, 33191 | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-28264 | PRV | Susan Vasquez | 1965-02-24 | — | — | 4067 Grand Ave, Columbus, OH, 43204 | 0.96 | City re-casedPlaceholder values cleared |
| PRV-28306 | PRV | Benjamin Ellitt | 1982-11-20 | UHC-21392-85 | 7113154958 | 8890 Church St, Las Vegas, NV, 89163 | 0.96 | Date of birth reformattedPlaceholder values cleared |
| PRV-29094 | PRV | Jean X McCoy | 1963-12-09 | UHC-59244-39 | 5507371454 | — | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-20680 | PRV | Daniel R Brooks | 1984-10-20 | — | 6146592557 | 5113 Cedar Ln, Phoenix, AZ, 85009 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-28123 | PRV | Amy Fernandez | 1948-03-16 | UHC-54769-51 | 2897204760 | 3078 Lake View Rd, Los Angeles, CA, 90029 | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-20803 | PRV | Alan Brown | 2004-01-08 | UHC-69982-03 | 6279760412 | — | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-29044 | PRV | Virginia N Harvey | 1955-12-22 | — | 5374730234 | 4131 Main St, Columbus, OH, 43284 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-27294 | PRV | Micelle Gutierrez | 1998-01-28 | — | — | 6253 Grand Ave, Orlando, FL, 32870 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-22524 | PRV | Bobby Gilbert | 1986-04-01 | — | 4543868857 | 8022 Ocean Ave, Mesa, AZ, 85230 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-27411 | PRV | Jose Matthews | 1956-05-12 | — | — | 2912 Hillcrest Rd, Nashville, TN, 37210 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-21326 | PRV | Bruce Mattthews | 1948-10-15 | — | — | — | 0.96 | Date of birth reformattedPlaceholder values cleared |
| PRV-26462 | PRV | Ryan Garrett | 2005-04-05 | — | 4497812983 | 7441 Market St, Minneapolis, MN, 55455 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-28236 | PRV | Melissa Hawikns | 1975-06-26 | UHC-87638-87 | — | 9255 Harbor Blvd, Chandler, AZ, 85225 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-24777 | PRV | Allan Marquez | 2020-02-16 | UHC-88620-29 | — | 2304 Central Ave, Fresno, CA, 93742 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-21770 | PRV | Nicole Sullivan | 2005-09-21 | — | 5616350718 | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-22767 | PRV | Aaron Estrada | 1988-08-23 | UHC-63672-89 | 3947125800 | 8086 Pine Dr, Scottsdale, AZ, 85208 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-20585 | PRV | Jesse Payne | 1945-07-15 | — | 8417245022 | 8235 Grand Ave, Nashville, TN, 37226 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-27371 | PRV | Ashley J Oliver | 1973-04-06 | UHC-27439-19 | 5064834373 | — | 0.96 | Date of birth reformattedPlaceholder values cleared |
| PRV-25296 | PRV | Roger Moreno | 2005-01-25 | — | — | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-20966 | PRV | Emma E Castillo | 1949-12-25 | UHC-27180-71 | 4919581776 | 382 Highland Ave, San Diego, CA, 92131 | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-23759 | PRV | Ruth A Olson | 1998-12-15 | — | — | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-27777 | PRV | Judy Delgado | 2005-03-05 | UHC-10925-71 | — | 9895 Jefferson Ave, Los Angeles, CA, 90053 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-20874 | PRV | Anndrea Fuller | 2005-03-01 | UHC-87746-30 | 3177411713 | — | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-26081 | PRV | Martha D Gardner | 1944-05-13 | — | 2579837123 | 3192 Sunset Blvd, Gilbert, AZ, 85215 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-23947 | PRV | Carlos Le | 1944-10-15 | UHC-07359-80 | 5644707042 | 7655 Lake View Rd, Charlotte, NC, 28252 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-22212 | PRV | Steven Ellis | 1944-12-28 | — | — | 6255 Park Pl, Jacksonville, FL, 32272 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-25150 | PRV | Emily Harris | 1967-10-25 | — | 9854768765 | 5568 Apache Blvd, Orlando, FL, 32860 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-25149 | PRV | Emily Harris | 1967-10-25 | — | 9854768765 | 5568 Apache Blvd, Orlando, FL, 32860 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-20812 | PRV | Juan Martin | 1963-07-17 | — | 6396137275 | 5914 Apache Blvd, Scottsdale, AZ, 85222 | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-23948 | PRV | Carlos P Le | 1944-10-15 | UHC-07359-80 | 5644707042 | — | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-26370 | PRV | Ethan Morgan | 1964-08-18 | — | — | — | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-28891 | PRV | Santiago Palmer | 2008-12-05 | — | — | 9709 Ridge Rd, Nashville, TN, 37258 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-29399 | PRV | Frank Owens | 1979-11-28 | UHC-66842-15 | — | — | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-22441 | PRV | Nathan I Olson | 1977-08-18 | — | 8935064456 | 7553 Central Ave, Houston, TX, 77034 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-23894 | PRV | Janet Stone | 1961-10-04 | — | 7022250285 | 7317 Ocean Ave, Mesa, AZ, 85212 | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-22078 | PRV | Nathan Reid | 2006-12-04 | — | — | 7874 Bayshore Dr, Tampa, FL, 33610 | 0.96 | City re-casedPlaceholder values cleared |
| PRV-26776 | PRV | Diego Tucker | 1968-05-21 | — | — | 6327 Elm St, Jacksonville, FL, 32278 | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-20501 | PRV | Jerry Walssh | 1994-09-24 | UHC-81721-07 | 6004562286 | — | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-28341 | PRV | Tyler Washington | 1941-08-11 | UHC-77864-45 | — | 4828 Harbor Blvd, Sacramento, CA, 95892 | 0.96 | Whitespace trimmedPlaceholder values cleared |
| PRV-26317 | PRV | Katherine Hughes | 1964-08-18 | UHC-58411-53 | 9573748697 | — | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-26316 | PRV | Katherine Hughes | 1964-08-18 | UHC-58411-53 | 9573748697 | — | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-23646 | PRV | Stephen Hoffman | 2007-05-08 | — | 9586336505 | — | 0.96 | Phone reformattedPlaceholder values cleared |
| PRV-21218 | PRV | Lawrence M Clark | 1996-12-10 | UHC-09797-27 | — | — | 0.96 | Name re-casedPlaceholder values cleared |
| PRV-22036 | PRV | Ralph Taylor | 1985-07-21 | — | — | 1559 Broadway, Las Vegas, NV, 89136 | 0.96 | Address re-casedPlaceholder values cleared |
| PRV-25044 | PRV | Peter Arnold | 1994-08-02 | — | 8313924397 | 1574 Oak St, Mesa, AZ, 85216 | 0.96 | Phone reformattedPlaceholder values cleared |