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-23376 | PRV | Yuki Peters | 1998-05-08 | — | 8272615075 | 890 Oak St, Austin, TX, 78744 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-22915 | PRV | Debra Rojas | 1941-07-15 | UHC-41714-20 | 7817565985 | 2800 Sage Ct, Las Vegas, NV, 89182 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| PRV-21813 | PRV | Pamela Hill | 1943-02-01 | UHC-49585-16 | 6119927648 | 2806 Forest Ave, Fresno, CA, 93749 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-25346 | PRV | Katherine Holmes | 1985-04-10 | — | 8584334280 | 3359 Jefferson Ave, Houston, TX, 77016 | 0.72 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-22905 | PRV | Mariana Chavez | 2005-11-01 | — | 9555527673 | 3008 Sunset Blvd, Houston, TX, 77018 | 0.72 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-27058 | PRV | Helen Peters | 1941-05-16 | UHC-13869-39 | 8626777215 | 7041 Ridge Rd, Scottsdale, AZ, 85268 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24750 | PRV | Terry T Meyer | 1989-09-11 | — | 6599944418 | 8620 Ridge Rd, Eden Prairie, MN, 55361 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-22779 | PRV | Eric Freeman | 1962-05-09 | UHC-17531-99 | 3566904311 | 8096 Spring St, Minneapolis, MN, 55421 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24568 | PRV | Jacob R Gerene | 1984-10-02 | UHC-35926-22 | 3149657945 | 9893 Meadow Ln, Jacksonville, FL, 32211 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-26252 | PRV | Judy Santiago | 1999-05-13 | — | 8664182162 | 132 Pine Dr, Tempe, AZ, 85248 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-22391 | PRV | Sarah Marshall | 1941-06-20 | — | 5417891031 | 4580 River Rd, Tucson, AZ, 85708 | 0.72 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-22392 | PRV | Sarah Marshall | 1941-06-20 | — | 5417891031 | 4580 River Rd, Tucson, AZ, 85708 | 0.72 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26968 | PRV | Charlotte N Fowler | 1967-11-27 | UHC-76075-73 | 8238044717 | 9467 Indian School Rd, Gilbert, AZ, 85247 | 0.72 | Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-20515 | PRV | Dorothy Jacobs | 1942-02-04 | — | 4322011656 | 2626 River Rd, Fresno, CA, 93771 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-21978 | PRV | Daniel V Miller | 1964-11-11 | UHC-96988-93 | 2362954985 | 7620 Palm Dr, Tucson, AZ, 85746 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-21194 | PRV | Austin Williamson | 1994-05-28 | — | 3649752513 | 6313 Bayshore Dr, Tempe, AZ, 85292 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-29595 | PRV | Zachary Mendez | 2003-01-26 | UHC-28618-02 | 8337141304 | 8894 Lake View Rd, Atlanta, GA, 30373 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-22227 | PRV | Virginia G Yang | 1988-08-28 | UHC-41415-62 | 6856039563 | 200 Jefferson Ave, Mesa, AZ, 85287 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24123 | PRV | Daniel G Bennett | 2008-08-12 | UHC-66829-88 | 3279523910 | 9592 Market St, Glendale, AZ, 85308 | 0.72 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-20224 | PRV | Patrick Robinson | 1977-04-11 | — | 2776456911 | 7387 Bayshore Dr, Sacramento, CA, 95862 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-28889 | PRV | Charles Butler | 1963-10-19 | UHC-33196-93 | 8462801030 | 7058 Central Ave, Miami, FL, 33187 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedCity re-cased+4 more |
| PRV-28395 | PRV | Brittany Fuller | 1965-12-07 | UHC-81567-13 | 5543874972 | 799 Elm St, Las Vegas, NV, 89109 | 0.72 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-22947 | PRV | Luis Hall | 1973-09-26 | UHC-09047-55 | 7395664678 | 136 Ocean Ave, Columbus, OH, 43201 | 0.72 | Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-22590 | PRV | Sullivan E Michelle | 1950-10-26 | — | 6344746191 | 2442 Market St, Dallas, TX, 75255 | 0.72 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-29562 | PRV | Mary McCoy | 2002-02-19 | UHC-45825-03 | 7553936940 | 52 Harbor Blvd, Phoenix, AZ, 85079 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-21757 | PRV | Josse Ruiz | — | — | 9006602747 | 1145 Mountain View Dr, Sacramento, CA, 95899 | 0.72 | Name split from “Last, First”Date of birth unreadable |
| PRV-26237 | PRV | Sarah C Murphy | 1964-06-03 | — | 5473549016 | 7273 Palm Dr, Scottsdale, AZ, 85237 | 0.72 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26779 | PRV | Barbara Collins | 2004-05-17 | — | 9139945612 | 647 Market St, Minneapolis, MN, 55468 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-20808 | PRV | Ruth E Wells | 2003-12-08 | UHC-16007-69 | 8227708183 | 7402 Sage Ct, Tempe, AZ, 85264 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| PRV-28083 | PRV | Saniago Willis | 2005-07-22 | — | 3459769221 | 6570 Mesa Dr, Scottsdale, AZ, 85293 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-23008 | PRV | Elijah Washington | 1979-09-07 | UHC-16414-38 | 9886230862 | 959 Mesa Dr, Austin, TX, 78748 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-20234 | PRV | Victoria Greene | 1976-07-22 | UHC-12466-94 | 3705144850 | 7520 Church St, Seattle, WA, 98185 | 0.72 | Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-25422 | PRV | Laura Chavez | 2006-02-02 | — | — | 1179 Lake View Rd, Denver, CO, 80251 | 0.72 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-20633 | PRV | Luis R Freeman | 1981-07-01 | — | 4378136234 | 147 Central Ave, Tucson, AZ, 85797 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-25301 | PRV | Paul Lucas | 1946-06-15 | — | 7796597606 | 3616 Camelback Rd, Jacksonville, FL, 32262 | 0.72 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-26902 | PRV | Grace B Davis | 1944-10-19 | UHC-06537-09 | 5339720897 | 7504 Ridge Rd, Austin, TX, 78794 | 0.72 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-28875 | PRV | Laura Warren | 2001-07-17 | UHC-80409-15 | 2382379361 | 3061 Cedar Ln, Chandler, AZ, 85214 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more |
| PRV-26090 | PRV | Patricia Maldonado | 1988-01-25 | UHC-13370-92 | 5303491512 | 599 Apache Blvd, Fresno, CA, 93760 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24301 | PRV | Doris D Watson | 1951-12-05 | UHC-23249-96 | 5264765344 | 6258 Forest Ave, Charlotte, NC, 28267 | 0.72 | Middle initial moved out of first nameZIP+4 trimmed |
| PRV-25790 | PRV | Justin Murphy | 1952-10-21 | UHC-52723-74 | 3747576957 | 3207 Union St, Tucson, AZ, 85764 | 0.72 | Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-28472 | PRV | Keith Millre | — | UHC-21541-75 | — | — | 0.72 | Date of birth unreadableSSN last four extracted |
| PRV-21134 | PRV | Steven Guzman | 2001-11-20 | UHC-15163-18 | 6762258210 | 6461 Mesa Dr, Las Vegas, NV, 89120 | 0.72 | Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-27446 | PRV | Patrick Collins | 1974-11-27 | — | 7308391245 | 1406 Maple Ave, Jacksonville, FL, 32222 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-22081 | PRV | Charlotte Coleman | 1994-05-05 | — | 7035761622 | 4598 Baseline Rd, Nashville, TN, 37221 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-26942 | PRV | Harold Franklin | 1980-02-23 | UHC-93681-23 | 8705539675 | 8586 Sage Ct, Scottsdale, AZ, 85291 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-28563 | PRV | Brandon Andrews | 1956-02-04 | UHC-68112-03 | 5848021755 | 414 Oak St, Tucson, AZ, 85712 | 0.72 | Date of birth reformattedPhone reformattedMember ID reformattedCity re-cased+4 more |
| PRV-22995 | PRV | Kathy S Simmons | 1985-07-17 | UHC-12054-24 | 3328713836 | 1289 Main St, Scottsdale, AZ, 85260 | 0.72 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |
| PRV-29085 | PRV | Kayla Hofffman | 1944-05-06 | — | 5343459050 | 8332 Camelback Rd, Houston, TX, 77010 | 0.72 | Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more |
| PRV-24042 | PRV | Luis F Dunn | 1950-11-21 | UHC-69678-10 | 2909559837 | 5311 Desert Sky Blvd, Charlotte, NC, 28275 | 0.72 | Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more |
| PRV-22952 | PRV | Nancy Lynch | 1970-02-10 | UHC-62977-75 | 8325056289 | 1365 Spring St, Denver, CO, 80289 | 0.72 | Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more |