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-29226 | PRV | Larry Wong | 2001-10-02 | UHC-68223-92 | 7385895507 | 5452 Ridge Rd, Orlando, FL, 32886 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-27122 | PRV | Madison Edwards | 1995-01-13 | — | 4356830530 | 7010 Meadow Ln, Charlotte, NC, 28277 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22059 | PRV | Jacob Kim | 1958-07-15 | UHC-18672-96 | 4877489624 | 8072 Elm St, Jacksonville, FL, 32291 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-23592 | PRV | Judy Jimenez | 2006-07-10 | UHC-73726-15 | 3739974886 | 4481 Camelback Rd, Tampa, FL, 33619 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-26881 | PRV | Harold Ramirez | 1943-04-28 | UHC-18546-96 | 7223160778 | 6606 Forest Ave, Charlotte, NC, 28260 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22851 | PRV | Hannh Lewis | 2002-06-28 | — | — | 236 Church St, Denver, CO, 80227 | 0.74 | Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-29335 | PRV | Logan Flores | 1967-12-06 | UHC-41865-47 | 6116988988 | 7165 Sunset Blvd, Sacramento, CA, 95876 | 0.74 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27453 | PRV | Kayla Martin | 1981-02-09 | — | 7303882240 | 2860 Spring St, Nashville, TN, 37218 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20218 | PRV | Jake Obrien | 1952-12-07 | UHC-35819-35 | 8974392985 | 6666 Mountain View Dr Apt 37, Dallas, TX, 75200 | 0.74 | Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more |
| PRV-20502 | PRV | Austin Torres | 1970-06-15 | — | 3243602250 | 6803 Canyon Rd, Jacksonville, FL, 32268 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28304 | PRV | Dennis O Dean | 1974-02-06 | UHC-07591-25 | 3653866925 | 863 Forest Ave, Gilbert, AZ, 85273 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26010 | PRV | Samuel Bailey | 1979-06-20 | UHC-79455-80 | 3525582651 | 1831 Spring St, Mesa, AZ, 85284 | 0.74 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-22175 | PRV | Carroll C Pat | 1986-01-15 | — | 5106489849 | 9191 Meadow Ln, San Antonio, TX, 78280 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26339 | PRV | Anna Y Greene | 1986-02-14 | — | 9875217391 | 9359 Lake View Rd, Denver, CO, 80222 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26056 | PRV | Timothy Scott | 1949-07-22 | — | 2379101779 | 449 Palm Dr, Nashville, TN, 37295 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-29392 | PRV | Julie Miller | 2007-01-20 | UHC-50358-46 | 6278406030 | 7356 Camelback Rd, Tucson, AZ, 85710 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-29420 | PRV | Catherine Romero | 1952-02-09 | UHC-95527-11 | 9445379019 | 9615 Camelback Rd, Tempe, AZ, 85263 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27127 | PRV | David Lynch | 1968-09-13 | UHC-56000-70 | 7386679694 | 7366 Union St, Tempe, AZ, 85207 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28065 | PRV | Lauren R Murphy | 1969-08-21 | — | 9237297088 | 2578 Lake View Rd, Orlando, FL, 32845 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-23862 | PRV | Cynthia Ray | 1944-07-28 | UHC-77905-14 | 9855465699 | 2807 Lake View Rd, Houston, TX, 77071 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22660 | PRV | Aaron J Bell | 1940-03-15 | UHC-97382-48 | 5158857553 | 6456 Baseline Rd, Houston, TX, 77085 | 0.74 | Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-20783 | PRV | Jarry Haart | 1992-09-03 | UHC-00989-27 | 4749430716 | 2072 Pine Dr, Los Angeles, CA, 90053 | 0.74 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28495 | PRV | Joe Burns | 1984-01-14 | UHC-76864-14 | 6398077273 | 3433 Indian School Rd, Houston, TX, 77076 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| PRV-24264 | PRV | Judith Howell | 1993-05-02 | UHC-20985-03 | 5544783967 | 5164 Park Pl, Houston, TX, 77081 | 0.74 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-22999 | PRV | Janice Dunn | 1953-04-18 | — | 6909012854 | 3591 Oak St, Denver, CO, 80249 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27616 | PRV | Richard Alvarez | 1952-08-20 | UHC-56524-96 | 2852452763 | 7885 Sunset Blvd, Phoenix, AZ, 85080 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-27342 | PRV | Sofia Smith | 1988-05-13 | UHC-24303-04 | 3829382876 | 6410 Oak St, Tempe, AZ, 85257 | 0.74 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more |
| PRV-25426 | PRV | Peter West | 1938-08-09 | — | 6856053731 | 6880 Valley View Dr, Fresno, CA, 93777 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-20170 | PRV | Stephanie Hamilton | 1986-01-08 | UHC-85850-81 | 8273998162 | 6645 Highland Ave, Phoenix, AZ, 85085 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26456 | PRV | Nancy I Williamson | 1948-03-24 | UHC-86218-75 | 8245117466 | 8444 Apache Blvd, Fresno, CA, 93781 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-27249 | PRV | Peter Fisher | 1973-04-19 | UHC-49647-84 | 5053643227 | 9503 Broadway Apt 37, Dallas, TX, 75252 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more |
| PRV-21081 | PRV | Fatima Green | 1971-01-19 | UHC-56858-96 | 8975855235 | 764 River Rd, Minneapolis, MN, 55442 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more |
| PRV-21465 | PRV | Austin V Berry | 2007-04-07 | UHC-63286-32 | 5375701799 | 9431 Central Ave, Eden Prairie, MN, 55329 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-24430 | PRV | Daniel Jackson | 1951-11-21 | UHC-96969-13 | 8817343579 | 9136 Baseline Rd, Denver, CO, 80242 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-27299 | PRV | Sofia Lucas | 1969-04-12 | UHC-89122-72 | 6606442234 | 9873 Union St, Austin, TX, 78744 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26333 | PRV | Marcus Howell | 1997-01-01 | UHC-94996-60 | 8419915857 | 337 Mesa Dr, San Antonio, TX, 78216 | 0.74 | Date of birth reformattedPhone reformattedMember ID reformattedCity re-cased+3 more |
| PRV-26539 | PRV | Bobby Sandoval | 1957-04-03 | UHC-01331-40 | 6909516499 | 8910 Harbor Blvd, Charlotte, NC, 28245 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more |
| PRV-28116 | PRV | Charlotte Z Silva | 2007-01-27 | UHC-82786-43 | 2937090294 | 822 Lake View Rd, Fresno, CA, 93739 | 0.74 | Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more |
| PRV-23867 | PRV | Nancy Santiago | 1974-03-03 | — | 7647189716 | 3929 Camelback Rd, Eden Prairie, MN, 55346 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25046 | PRV | Amy V Espinoza | 1996-03-02 | — | 6385586027 | 3957 Sage Ct, Dallas, TX, 75233 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25128 | PRV | Alexis Walker | 1962-07-15 | UHC-81179-53 | 3715679556 | 2604 Highland Ave, Phoenix, AZ, 85013 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-25961 | PRV | Isabella Barnes | 2006-03-11 | — | 4086715531 | 1853 Oak St, Mesa, AZ, 85252 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-20704 | PRV | Randy Harrison | 1985-11-20 | — | 7124552893 | 5559 Sage Ct, Chandler, AZ, 85226 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-22482 | PRV | Ahmed H Wagner | 1981-01-01 | — | 3142204944 | 212 Bayshore Dr, Seattle, WA, 98121 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-29279 | PRV | Samantha Y Thompson | 1977-08-09 | UHC-17634-87 | 7776040312 | 5712 Pine Dr, Glendale, AZ, 85306 | 0.74 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-28931 | PRV | Christian Thomas | 2005-10-19 | — | 6834476734 | 4914 Market St, Gilbert, AZ, 85274 | 0.74 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-26741 | PRV | William V Perce | 1971-02-24 | UHC-54866-35 | 6282685089 | 4291 Pine Dr, San Antonio, TX, 78228 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-22042 | PRV | Kaith Duncan | 1943-02-28 | — | 6512841016 | 1784 Sage Ct, Orlando, FL, 32826 | 0.74 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more |
| PRV-26347 | PRV | Christian Mendez | 1983-12-11 | — | — | 9346 Market St, Tucson, AZ, 85710 | 0.74 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more |
| PRV-25735 | PRV | Diaen N Yang | 2001-09-09 | UHC-11444-52 | 2616069814 | 77 Main St, San Antonio, TX, 78208 | 0.74 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more |