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
TPA-58311TPAJake Mdina1968-08-23—69546156168514 Park Pl, Tempe, AZ, 852430.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-133819ENRMichelle Brooks2000-08-08UHC-54189-8023731083613193 Bayshore Dr Apt 27, Tempe, AZ, 852250.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-102682ENRCharlotte B Smith1992-12-17UHC-45559-7956677965742953 Cedar Ln, Tampa, FL, 336990.46Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-128578ENRCarolyn M Santiago2007-03-10UHC-51828-3628262625854033 Hillcrest Rd, Phoenix, AZ, 850830.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-126742ENRMason P Foster1975-03-14UHC-91690-7546627599373701 Harbor Blvd # 266, Nashville, TN0.46Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more
ENR-104898ENRMason Kelley1984-11-26UHC-62790-8163160060277795 Harbor Blvd, Austin, TX, 787680.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-125661ENRElizabeth M Maldonado1986-04-01UHC-49167-2558935083483871 Park Pl Apt 40, Charlotte, NC, 282770.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-121954ENRElijah J Torres1968-03-21UHC-90396-6498833702117315 Church St, Eden Prairie, MN0.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-405667CLMJacqueline V Fowler1999-12-16—27528651461885 Central Ave, Jacksonville, FL, 322210.46Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-50222TPAIsabella Harrison1987-09-12—93334127194153 Ridge Rd, Sacramento, CA, 958830.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-114976ENRMateo Medina1950-03-15UHC-80796-7277495302095639 Willow Ct, Sacramento, CA, 958050.46Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-114975ENRMateo Medina1950-03-15UHC-80796-7277495302095639 Willow Ct, Sacramento, CA, 958050.46Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-101153ENRTimothy Kelly1989-07-01UHC-36460-9648931001292193 Mountain View Dr, Seattle, WA0.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-101814ENRBenjamin Harris1978-11-02UHC-55813-9374142890561764 Mountain View Dr, Las Vegas, NV0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-407637CLMAna T Mason2002-01-10UHC-43455-6731222460698872 Highland Ave, Charlotte, NC, 282240.46Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
TPA-57313TPAButler Dylan1971-06-18—24563841485807 Church St, Houston, TX, 770950.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-424073CLMJustin Williams1980-03-09UHC-22721-4895326415476948 Mesa Dr, Plano, TX, 750060.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-132785ENRElijah X Williams1959-10-23UHC-93427-2359332600496333 Harbor Blvd, Seattle, WA0.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-120228ENRSofia Wilson2004-06-18UHC-06608-4159029981213482 River Rd, San Diego, CA, 921380.46Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+5 more
CLM-426550CLMAmanda R Hill2001-08-08UHC-75623-6493280614066405 Desert Sky Blvd # 144, Charlotte, NC, 282990.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-111999ENROmar Carter1940-09-08UHC-59754-7086989247626152 Camelback Rd, Seattle, WA, 981880.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-64299TPAMichelle Z Alvarez2007-03-11—98827350279370 Hillcrest Rd, Tempe, AZ, 852350.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-120956ENRJudith Lucas—UHC-82017-3542840501955675 Bayshore Dr # 815, Orlando, FL, 328940.46Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more
ENR-102408ENRCynthia I Wagner1967-01-07UHC-51467-9134454326465775 Park Pl, Orlando, FL0.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-116284ENRLauren Ford1955-06-13UHC-21692-03880780269551 Union St, Minneapolis, MN, 554020.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-127875ENRMike Simmons1978-04-13UHC-43803-7678555547937323 Park Pl, Dallas, TX, 752060.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-22637PRVBrandon G Jacobs1955-08-05UHC-10592-7285197385499500 Grand Ave Apt 1, Orlando, FL, 328250.46Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
TPA-61959TPAKim Hernandez1945-12-13UHC-62431-46—4884 Pine Dr # 316, Phoenix, AZ, 850230.46Name split from “Last, First”Date of birth reformattedMember ID reformattedUnit split from street+5 more
CLM-405836CLMVincent N Diaz1982-11-18——8142 Oak St # 687, Fresno, CA, 937350.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
PRV-21944PRVAmy Daniels2007-04-08—75680229921993 Main St, San Antonio, TX0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-117210ENRKenneth S Perkins2003-07-24UHC-16787-9530463707854677 Valley View Dr, Scottsdale, AZ, 852660.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
ENR-116715ENRCheryl Carr1953-08-27—23462115321857 Valley View Dr, Scottsdale, AZ0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-420137CLMAlexander Patterson1965-06-14——5599 Desert Sky Blvd, Glendale, AZ, 853460.46Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
ENR-118126ENRGloria Tran1999-12-15UHC-60806-43—5239 River Rd, Sacramento, CA, 958440.46Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-21538PRVScott AJunk1991-10-09UHC-85790-90—3667 River Rd, Gilbert, AZ, 852160.46Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+5 more
CLM-420464CLMPatrick Valdez1950-04-27UHC-71408-63—5078 Canyon Rd Apt 38, Minneapolis, MN, 554320.46Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+5 more
ENR-115512ENRArjun Davis1957-09-09UHC-79014-9957695850636398 Union St, Denver, CO, 802810.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-137533ENRDiego Ford—UHC-42855-5277052624083131 Apache Blvd, Tempe, AZ, 852710.46Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more
CLM-412436CLMBobby Wetson1997-02-10UHC-36535-02—9708 Palm Dr, Tampa, FL, 336560.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-406828CLMVincent Hudson1943-07-18UHC-97933-5236252376748952 Market St # 836, Fresno, CA, 937020.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-140551ENRScott V Turner1951-05-21UHC-29656-3243458395653002 Lake View Rd Apt 35, Tampa, FL, 336680.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
TPA-60760TPABruce Smith1994-02-20—9353156705959 Baseline Rd, Eden Prairie, MN0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-130169ENRJanice Welch1945-03-17UHC-30440-0388693197684837 Union St # 134, Houston, TX0.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
TPA-57905TPABradley Herrera2006-02-10—79258013843645 Mountain View Dr, Scottsdale, AZ, 852860.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-25727PRVMaria J Oliver1982-04-02UHC-92965-7894881596698314 Willow Ct # 843, Miami, FL0.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-126072ENRAhmed W Perez2004-09-18UHC-29273-0595220314863808 Elm St Apt 33, Scottsdale, AZ, 852860.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
PRV-23446PRVJanet Sullivan1964-11-13—39349030351756 Lake View Rd, Phoenix, AZ, 850390.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-131978ENRRachel C Lawson1942-03-23UHC-27077-9920482652828742 Pine Dr, Houston, TX, 770870.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-133326ENRRalph K Medina1953-12-04UHC-86664-2362772548597492 Palm Dr, Tucson, AZ0.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-121990ENRSantiago Patterson1960-06-28UHC-88650-7059134201339129 Ocean Ave, Tampa, FL0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
100,000 rows, page 49 of 2,000PreviousNext