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.

Normalised records

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-141367ENRMatthew Y Cruz1982-02-15UHC-51746-95—5680 Hillcrest Rd, Sacramento, CA, 958790.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-103073ENRSharon A Garza1965-03-01UHC-87804-9643455976836519 Union St, Denver, CO, 802470.60Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
ENR-101552ENRSamuel E Matthews1944-09-02UHC-46320-2831226691087941 Elm St, Plano, TX, 750440.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110481ENRRachel L Bradley1943-10-26UHC-97573-464488784946446 Central Ave, Dallas, TX, 752620.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-109720ENRMariana Howell1972-11-18UHC-32155-7686844489705535 Meadow Ln Apt 28, Columbus, OH, 432200.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-122277ENRDenise X Padilla1961-11-02UHC-97647-24—1651 Hillcrest Rd, Denver, CO, 802130.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-119004ENRNancy Wright1984-01-05UHC-03765-7860737732188257 Mountain View Dr, Plano, TX, 750670.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-104098ENRKatherine S Williamson1974-04-22UHC-03866-4737831714595607 Central Ave, Plano, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-128957ENRJean Chavez1965-06-07UHC-97809-2276733133541806 River Rd, San Diego, CA0.60Name re-casedDate of birth reformattedPhone reformattedState code upper-cased+4 more
ENR-121226ENRFrances Z Rogers1953-05-25UHC-18099-218117742862131 Lake View Rd, Sacramento, CA, 958680.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-105155ENRMelissa B Jacobs1955-02-20UHC-37569-8886987797732514 Grand Ave, Austin, TX, 787380.60Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-109635ENRRobert Patel1998-01-08UHC-85449-5560046370697450 Lake View Rd, Seattle, WA, 981460.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129422ENRRoger Lawson1955-03-01UHC-72270-4324349810004540 Meadow Ln, Las Vegas, NV0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-139704ENRWei C Johnson1973-02-12UHC-77276-315898413733474 Canyon Rd, Tampa, FL, 336730.60Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-104060ENRWei X Bailey1963-09-25UHC-00260-6834691242848300 Park Pl, Mesa, AZ, 852140.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-116115ENRAna Alvarado1967-06-19UHC-55845-1989731059805209 Ocean Ave, Chandler, AZ, 852090.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127137ENRTeresa K Meyer1943-03-14UHC-07697-7335035890222292 Canyon Rd, Los Angeles, CA, 900130.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-124134ENRBobby Wright1994-04-03UHC-74847-84—8097 Central Ave, Eden Prairie, MN0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-137864ENRStephen Schmidt1939-11-16UHC-90450-8223890997668679 Grand Ave, Tampa, FL, 336680.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-137225ENRCheryl N Bradley1981-08-26UHC-91491-2183380272791119 Lake View Rd, Orlando, FL, 328580.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-133307ENRAshley W Richardson1965-01-18UHC-96287-8484122045585796 Sage Ct, Orlando, FL0.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-127861ENRBarbara P Aguilar1997-08-24UHC-82036-5577623068814233 Ocean Ave, Seattle, WA0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114383ENRRichard K Ferguson1949-12-18UHC-78818-7856886797994772 Central Ave, Tucson, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-116767ENREthan U Turner1979-07-21UHC-63512-8247257987083909 Central Ave, Seattle, WA, 981190.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-101623ENRSara Y Bryant2008-07-23UHC-95119-0389075369792128 Maple Ave, Jacksonville, FL, 322110.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-135308ENRMark I Hunt1979-01-24UHC-14722-6780075957296380 Lake View Rd, Charlotte, NC, 282570.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124943ENRTheresa Thompson1998-04-21UHC-43516-1130653721277858 Palm Dr, Plano, TX, 750160.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120263ENRScott L Obrien1979-03-15UHC-07659-6089175615373693 Camelback Rd, Atlanta, GA, 303150.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-107381ENRMariana L Lane1972-09-10UHC-44784-7145127994083982 Cedar Ln, Denver, CO0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-117968ENRJeffrey U Alvarado1996-06-06UHC-07952-9732976820184090 Apache Blvd Apt 12, Orlando, FL, 328600.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-130773ENRDeborah A Hoffman1955-12-20UHC-58070-096522655625551 Spring St, Chandler, AZ, 852020.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-121169ENRRoger L Mills1945-04-01UHC-89961-1755659780958121 Central Ave, Eden Prairie, MN, 553500.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-104777ENRAnthony Petterson1968-05-22UHC-92064-2031521827161392 Ocean Ave, Scottsdale, AZ, 852510.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-112224ENRSandra M Fox1971-01-19UHC-53823-2623528751578751 Washington St, Las Vegas, NV0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-128571ENRSara Harper1997-12-08UHC-57874-4521583924137599 Oak St, Minneapolis, MN, 554470.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-128595ENRZachaary S Schmidt1956-03-03UHC-39649-8753897243319274 Canyon Rd, Houston, TX, 770670.60Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
ENR-113276ENRBarbara Alvarado1944-05-24UHC-81114-7989873270855105 Lake View Rd, Tempe, AZ, 852330.60Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-123843ENRWallter B Guzman1980-07-20UHC-84623-4192688437989478 Washington St, Tucson, AZ, 857870.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-105060ENRKathleen Castro1957-10-03UHC-48032-7896774821717302 Apache Blvd, Gilbert, AZ0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107150ENRDiana G Hannson1989-01-07UHC-23006-2866848915502739 Hillcrest Rd, Fresno, CA, 937300.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-117295ENRRichard T Alvarez1969-07-23UHC-81323-2581629298785615 Oak St, Tampa, FL0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141358ENRColeman Justin1977-12-02UHC-72290-9587841737506753 Baseline Rd, San Diego, CA, 921380.60Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-125861ENRDiego Franklin1969-08-08UHC-43190-3346593813117314 Union St, Mesa, AZ0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120866ENRKayla E Simmons1946-05-05UHC-87921-3447790480635269 Ridge Rd, Gilbert, AZ, 852230.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-112244ENRLori Ells2005-08-15UHC-21885-6688876339815821 Union St, Orlando, FL, 328790.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-118527ENRRobert Z Jensen2007-07-06UHC-59264-904962551741396 Apache Blvd, Nashville, TN, 372280.60Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-106092ENRTeresa Mendez1987-06-26UHC-99599-8480742008184688 Willow Ct, Chandler, AZ, 852580.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-139978ENRJose Lane1940-11-14UHC-60274-3229360645405125 Cedar Ln, Seattle, WA, 981590.60Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-131097ENRDouglas Z Guzman1939-05-04UHC-59096-8841432939664355 Mountain View Dr, Tempe, AZ, 852990.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107184ENRRachel A Peters1970-12-15UHC-21109-4442844239088979 Market St, Austin, TX, 787510.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
43,101 rows, page 126 of 863PreviousNext