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-22330 | PRV | Judith Gardner | 1996-07-24 | UHC-21987-43 | 7439028198 | 9762 Main St, Phoenix, AZ, 85077 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-22496 | PRV | Sean V Sanders | 2004-02-05 | UHC-48053-23 | 7125336877 | 3327 Grand Ave, Scottsdale, AZ, 85264 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29317 | PRV | Lauren Jackson | 2004-04-04 | — | 8903456751 | 7895 Harbor Blvd, Houston, TX, 77066 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20151 | PRV | Bobby Rios | 1977-09-18 | — | 8625484940 | 6800 Mesa Dr, San Antonio, TX, 78216 | 0.78 | Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more |
| PRV-21648 | PRV | Christopher F Payne | 2000-05-20 | UHC-95023-02 | 6947650155 | 6425 Desert Sky Blvd, Miami, FL, 33151 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27627 | PRV | Samantha Murphy | 1977-09-03 | UHC-20022-73 | 7003472354 | 2756 Hillcrest Rd, Las Vegas, NV, 89195 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more |
| PRV-25270 | PRV | Ahmed Y Davis | 2007-08-17 | — | 6013043745 | 1495 Union St # 517, Tucson, AZ, 85700 | 0.78 | Name re-casedDate of birth reformattedUnit split from streetWhitespace trimmed+1 more |
| PRV-20026 | PRV | Amber Wells | 1979-06-25 | — | 2665950799 | 4421 Ocean Ave, Tampa, FL, 33680 | 0.78 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-24467 | PRV | Daniel Hunter | 1990-12-19 | — | — | 3802 Mesa Dr, Nashville, TN, 37296 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-24446 | PRV | Jacob Bnaks | 1988-07-10 | — | — | 5849 Cedar Ln, Mesa, AZ, 85267 | 0.78 | Name re-casedDate of birth reformattedPhone missing area codeWhitespace trimmed+1 more |
| PRV-23425 | PRV | Anna Phillips | 1969-09-13 | UHC-63056-45 | 5015512182 | 7473 Camelback Rd # 928, Austin, TX, 78794 | 0.78 | Name re-casedPhone reformattedUnit split from streetCity re-cased+1 more |
| PRV-27115 | PRV | Joshua N Vasquez | 1966-07-05 | UHC-78452-70 | 6376371994 | 9356 Park Pl, Atlanta, GA, 30380 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-22683 | PRV | Zachary O Nichols | 1973-09-11 | UHC-39053-23 | 6344942060 | 7771 Harbor Blvd, Atlanta, GA, 30378 | 0.78 | Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more |
| PRV-26349 | PRV | Megan Medina | 1944-10-12 | — | 3529675550 | 3116 Hillcrest Rd, Jacksonville, FL, 32245 | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-24762 | PRV | Thomas A Raymond | — | UHC-02723-41 | 8274614635 | 7605 Harbor Blvd, Phoenix, AZ, 85007 | 0.78 | Date of birth missingPhone reformattedMember ID reformattedWhitespace trimmed+1 more |
| PRV-23775 | PRV | Juudy Stevens | 1962-08-11 | UHC-82487-20 | 4019688917 | 3652 Palm Dr, Los Angeles, CA, 90041 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25744 | PRV | Valentina King | 2007-06-23 | — | 8446694586 | 5606 Grand Ave, Columbus, OH, 43291 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-25698 | PRV | Angela Gilbert | 1953-10-11 | UHC-84008-87 | — | — | 0.78 | Name re-casedTwo-digit birth yearPlan code upper-casedWhitespace trimmed+1 more |
| PRV-21665 | PRV | Dan Herrera | 1975-02-05 | — | — | 1962 Church St, Plano, TX, 75096 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-27367 | PRV | Carol Moore | 1991-02-19 | — | 5409877375 | 851 Indian School Rd # 443, Atlanta, GA, 30344 | 0.78 | Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+1 more |
| PRV-20091 | PRV | Kenneth Rivera | 1965-01-14 | — | 2203600906 | 6922 Park Pl, Fresno, CA, 93706 | 0.78 | Two-digit birth yearPhone reformattedEmail lower-casedWhitespace trimmed+1 more |
| PRV-24899 | PRV | Martha Flores | 1956-10-16 | UHC-46994-53 | 7377016721 | — | 0.78 | Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-24898 | PRV | Martha Flores | 1956-10-16 | UHC-46994-53 | 7377016721 | — | 0.78 | Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-25260 | PRV | Grace S Romero | 1978-08-24 | — | 6328209186 | 6656 Lincoln Way, Nashville, TN, 37237 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28476 | PRV | Sandra Stewart | 1955-07-25 | UHC-38871-63 | 8257557553 | 7198 Harbor Blvd, Seattle, WA, 98140 | 0.78 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-27034 | PRV | Kevvin Fowler | 1963-10-01 | UHC-05853-80 | 8745722321 | 5151 Valley View Dr, Chandler, AZ, 85203 | 0.78 | Name split from “Last, First”Phone reformattedMember ID reformattedWhitespace trimmed+1 more |
| PRV-26825 | PRV | Raymond Collins | 1971-03-26 | UHC-04176-72 | — | 6254 Forest Ave, Seattle, WA, 98140 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28620 | PRV | Michelle Lyynch | 1944-05-17 | — | 8346145726 | 7066 Central Ave, Jacksonville, FL, 32227 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-20027 | PRV | Fatima A Lynch | 2000-08-22 | UHC-78829-59 | 3518682231 | 7675 Harbor Blvd, Columbus, OH, 43200 | 0.78 | Name re-casedPhone reformattedCity re-casedGender normalised+1 more |
| PRV-25620 | PRV | Carl Marshall | 1963-07-22 | UHC-27566-03 | 6894527111 | 1078 Forest Ave, Gilbert, AZ | 0.78 | Name re-casedDate of birth reformattedPhone reformattedZIP missing+1 more |
| PRV-20164 | PRV | Anthony Riley | 1961-09-02 | — | 3408448924 | 4452 Harbor Blvd, San Diego, CA, 92151 | 0.78 | Phone reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more |
| PRV-23074 | PRV | Albert Q Delgado | 1951-04-25 | UHC-21429-15 | 8015219221 | 1506 Broadway, San Diego, CA | 0.78 | Date of birth reformattedPhone reformattedZIP missingWhitespace trimmed+1 more |
| PRV-22547 | PRV | Arthur K Lucas | 1982-09-11 | — | — | 2547 Ocean Ave, Nashville, TN, 37228 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26672 | PRV | Arthur Ryan | 1964-06-17 | — | 6007025020 | 2777 Oak St, Tampa, FL, 33672 | 0.78 | Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |
| PRV-25216 | PRV | Theresa Mejia | 1950-03-10 | — | 5379148304 | — | 0.78 | Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more |
| PRV-27244 | PRV | Dylan Welch | 1956-07-05 | UHC-40221-33 | 6029260546 | 5659 Ocean Ave, San Diego, CA, 92115 | 0.78 | Name re-casedPhone reformattedCity re-casedState name converted to code+1 more |
| PRV-23112 | PRV | Sharon O Gibson | 1980-08-13 | — | 5545494790 | 2123 Jefferson Ave, Jacksonville, FL, 32237 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-29021 | PRV | Ana E King | 1983-04-14 | UHC-25436-16 | 3803949632 | 5915 Park Pl, Orlando, FL, 32850 | 0.78 | Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more |
| PRV-27327 | PRV | Alice V Butler | 1984-01-25 | UHC-00725-73 | 8553256161 | 7764 Main St, Austin, TX, 78749 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more |
| PRV-26230 | PRV | Thomas Wang | 1959-12-08 | UHC-80935-49 | 8855269941 | 2879 Hillcrest Rd, San Antonio, TX, 78296 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-28014 | PRV | Austin R Medina | 1954-03-06 | UHC-50918-06 | 8027098372 | 4470 Main St Apt 26, Fresno, CA, 93780 | 0.78 | Phone reformattedMember ID reformattedUnit split from streetWhitespace trimmed+1 more |
| PRV-29468 | PRV | Jeff J Edwards | 1993-02-09 | — | 9718937258 | 4979 Bayshore Dr, Plano, TX, 75032 | 0.78 | Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21715 | PRV | Logan Ryan | 1969-09-04 | — | 7106752319 | 4749 Forest Ave, Tampa, FL, 33657 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-23685 | PRV | Tucker E Henry | 1952-11-16 | — | 7985451731 | 242 Washington St, Nashville, TN, 37277 | 0.78 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more |
| PRV-26526 | PRV | Raymond Wong | 1994-04-14 | — | 8573971127 | 6869 Union St, Los Angeles, CA, 90038 | 0.78 | Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-26201 | PRV | Daniel Jimenez | 1956-02-18 | — | 6512437620 | 4505 Hillcrest Rd, Sacramento, CA, 95817 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-29101 | PRV | Dennis Lynch | 1973-01-03 | — | 3454814972 | 6422 Lincoln Way, Houston, TX, 77030 | 0.78 | Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more |
| PRV-21160 | PRV | Ahmed Robertson | 1994-02-11 | UHC-07829-56 | 2277087311 | 986 Broadway, Plano, TX | 0.78 | Phone reformattedAddress re-casedZIP missingWhitespace trimmed+1 more |
| PRV-24556 | PRV | Randy K Soto | 1969-03-03 | — | 7264909914 | 368 Ridge Rd, Tucson, AZ, 85782 | 0.78 | Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more |
| PRV-21352 | PRV | Olivia F Mendoza | 1950-08-20 | — | 3092677353 | 5633 Willow Ct, Mesa, AZ, 85279 | 0.78 | Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more |