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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-125374ENRRichard Stevens1971-02-15UHC-64127-22—885 Indian School Rd, Houston, TX, 770720.48Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more
PRV-20799PRVHiroshi S Richards1983-02-20UHC-72946-1858323471047384 Valley View Dr # 899, Glendale, AZ, 853530.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-111527ENRCarolyn Bryant1990-06-16UHC-09342-4577354732619240 Park Pl Apt 17, San Diego, CA0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-100365ENRAngela Bryant1938-04-06UHC-22165-5763150431149768 Spring St, Mesa, AZ0.48Name re-casedPhone reformattedMember ID reformattedState name converted to code+4 more
ENR-119730ENRAnthony Wilson1939-06-01UHC-13776-6998281413682727 Ridge Rd, Fresno, CA, 937780.48Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-121719ENRRussell C Cunningham1965-09-03UHC-36791-6792660087144129 Valley View Dr, Miami, FL0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141308ENRRoy O Crawford1994-04-21UHC-94638-4723845428237157 Valley View Dr, Minneapolis, MN, 554330.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-103954ENRHannah Q Peterson—UHC-35783-0777971081543908 Pine Dr, Jacksonville, FL, 322630.48Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more
CLM-421400CLMJeffrey Park1938-06-15—79036381005894 Pine Dr, Chandler, AZ, 852820.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-128134ENRFrances O Rojas1985-05-01UHC-82208-397203371205270 Willow Ct, Orlando, FL0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-135749ENRRandy T Burton1938-03-02UHC-32006-0330156304178838 Market St, Fresno, CA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24832PRVLuis B Simmons2003-04-13UHC-91105-4791671539489389 Sunset Blvd, Scottsdale, AZ0.48Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
ENR-136852ENRDaid R Hawkins1982-08-05UHC-77123-3358739238474607 Jefferson Ave, Fresno, CA, 937810.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-127467ENRGrace N Patterson1983-10-22UHC-65183-7495790548032433 Forest Ave, Jacksonville, FL, 322140.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141811ENRArthur I Simpson1989-03-06UHC-42939-6491040174027971 Indian School Rd, Dallas, TX, 752220.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-122950ENRKimberly X Mejia1985-02-21UHC-36570-1762948558465419 Park Pl # 913, Seattle, WA, 981130.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
TPA-55476TPAMaria McDonald2008-06-24—78889417518439 Elm St, Houston, TX, 770440.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-128912ENRTerry N Lawson1974-04-04UHC-03302-6944879684743688 Hillcrest Rd, Eden Prairie, MN, 553830.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-110727ENRCharlotte Simmons1961-05-14UHC-98486-1378351533571245 Ridge Rd # 702, Fresno, CA, 937020.48Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more
TPA-61119TPARonald Reed1957-07-28—62955203856289 Baseline Rd, Tucson, AZ, 857830.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-102075ENRNancy E Harper1959-06-26—50778905547991 Apache Blvd, Scottsdale, AZ, 852230.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-108342ENRDoris Perry1995-06-20UHC-81544-2552948422099693 Lincoln Way, Atlanta, GA, 303300.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-137993ENRHarold Hall—UHC-71225-3583633906514518 Union St, Dallas, TX, 752980.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-432488CLMDylan Hansen2005-12-04UHC-66853-5543326918932016 River Rd Apt 4, Tempe, AZ0.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-125049ENRJack Mills1971-05-18UHC-22367-7490178543129097 Pine Dr, Dallas, TX, 752760.48Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+4 more
CLM-403540CLMGregory Elliott1961-08-16UHC-34661-18—1131 Central Ave Apt 20, Atlanta, GA, 303320.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-133181ENRBetty I Ortega1952-05-09UHC-77561-9150361113154966 Highland Ave, Dallas, TX, 752080.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-25665PRVBradley J Reyes1949-11-12UHC-33181-94—7930 Harbor Blvd # 578, Glendale, AZ, 853300.48Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+4 more
ENR-139642ENRTeresa A Anderson1956-03-17UHC-79731-7354573762393024 Meadow Ln # 952, Seattle, WA, 981170.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-107241ENRRachel Wheeler1968-04-06UHC-03328-7679839350873159 River Rd Apt 32, Chandler, AZ0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51300TPANatalie Weber1977-12-13—84494892452493 Pine Dr, Jacksonville, FL, 322790.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123492ENRAndrea Hanson1971-11-09UHC-89587-6453374654418510 Camelback Rd, Plano, TX, 750120.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-140327ENRAmanda Riley1944-02-03UHC-25526-2498442428363827 Ocean Ave, Plano, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418711CLMJanice West1946-05-25—7406652820207 Meadow Ln, Chandler, AZ, 852570.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57557TPATimothy Wong——68341097063169 Camelback Rd, Fresno, CA, 937930.48Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+4 more
TPA-61745TPAVictoria Hill1974-05-05—40520984367117 Pine Dr Apt 11, Phoenix, AZ, 850360.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-113251ENRWillie G Espinoza—UHC-99098-6439433718976665 Harbor Blvd, Chandler, AZ, 852750.48Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more
CLM-419912CLMLinda Wagner1994-05-17UHC-79792-8731792763894845 Hillcrest Rd, San Diego, CA, 921360.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-109964ENRDebra Burke1991-04-23UHC-64755-3088182323933712 Bayshore Dr, Tampa, FL, 336190.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-103082ENRSantiago L Green—UHC-37513-7683929412857039 Church St, Los Angeles, CA0.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-120361ENRFrances V Roes1991-03-14UHC-35281-3236460728917938 Church St, Gilbert, AZ, 852600.48Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
TPA-61929TPAAaron Z Murphy1966-01-06—95773275055832 Mountain View Dr, Chandler, AZ0.48Name re-casedDate of birth reformattedPhone reformattedState name converted to code+4 more
TPA-50987TPAPamela R Vazquez1976-04-22—26577180142062 Park Pl, Fresno, CA, 937580.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-414680CLMEdward Phillips1997-07-02UHC-73690-8488335640374980 Sunset Blvd Apt 8, Columbus, OH, 432160.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-118555ENRBetty K Larson1944-06-06UHC-50271-716958636190304 Baseline Rd, Orlando, FL, 328140.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54136TPANiocle Soto1976-07-06UHC-29038-3030653248478682 Elm St, Fresno, CA0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-100045ENRRuth J Price1978-12-03UHC-48375-18—5458 Canyon Rd, Seattle, WA, 981440.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-430953CLMRandy Valdez1956-02-15UHC-86863-81—1385 Ocean Ave, Columbus, OH, 432890.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23100PRVGregory Hudson1954-02-04—53563688208058 Main St, Nashville, TN, 372620.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61624TPAAlexander M Young1952-05-28—49020036565866 Main St, Plano, TX, 750720.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 81 of 2,000PreviousNext