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-115479ENRChris D Hoffman1946-05-04UHC-47909-7292430900196080 Baseline Rd, Houston, TX, 770220.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53894TPABenjamin Rivera1938-09-23—46390572812529 Cedar Ln, San Diego, CA, 921950.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-26441PRVDiane Henry1975-02-03—27690779132927 Ridge Rd Apt 7, Chandler, AZ, 852680.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-128121ENRCheryl Knight1961-08-03UHC-48893-1427021084597882 Lake View Rd Apt 9, San Diego, CA, 921280.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-431584CLMAshley N Carpenter1967-01-15UHC-08657-9490560090293832 Ocean Ave, Denver, CO0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-125135ENRSamuel Salazar1980-09-13UHC-29299-5246665355338284 Harbor Blvd, Sacramento, CA, 958510.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24907PRVJerry Bowman1954-04-03UHC-10796-0621575522305417 Oak St, Eden Prairie, MN, 553470.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126342ENRJulie Parker1957-11-17UHC-17844-1086689983775167 Main St, Nashville, TN0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122315ENRPamela Howell1958-11-20UHC-60374-8381990480048664 Mountain View Dr, Plano, TX, 750050.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138085ENROmar Santos—UHC-67223-7746876982897590 Willow Ct, Denver, CO, 802470.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-420262CLMMarha Nichols1989-04-27UHC-63051-7246476088881787 Jefferson Ave, Mesa, AZ0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-132861ENRMray P Olson1959-05-05UHC-41659-114605878102853 Forest Ave # 785, Orlando, FL, 328300.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
TPA-55345TPACarl Cole1962-09-09——7658 Oak St, Austin, TX0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
CLM-415834CLMAustin Simmons1962-05-06UHC-84270-5930227418324773 Palm Dr, Denver, CO0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137047ENRMark Y Hicks1990-04-12UHC-61038-6831080236242633 Hillcrest Rd, Austin, TX, 787180.50Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more
TPA-58653TPADebra Ray1970-06-16——9349 Meadow Ln, San Diego, CA, 921060.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418753CLMJanice Holmes1962-11-07UHC-79640-77—8847 Mesa Dr # 370, Tucson, AZ, 857620.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-416969CLMSara C Burton1941-10-24——9018 Bayshore Dr, Gilbert, AZ, 852850.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-108469ENRJoan X Bryant1976-01-01UHC-90182-1934777816337618 Meadow Ln, Tucson, AZ, 857260.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-120882ENRSamanha Crawford2006-05-16UHC-50412-8852730363195510 Highland Ave, Tampa, FL, 336850.50Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-140930ENRElizabeth D Myers1981-12-18UHC-25672-9236636429339332 Ridge Rd, Dallas, TX, 752920.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-54760TPAKayla Thompson1963-09-26—711953873989 Park Pl # 442, Mesa, AZ, 852760.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-52302TPAMegan Watkins1997-10-10—20867083432995 Mountain View Dr, San Diego, CA, 921320.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100557ENRJoohn Gardner1947-11-06UHC-45824-4970448092296299 Desert Sky Blvd Apt 3, Austin, TX, 787220.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-423969CLMRalph Hoffman1984-12-26UHC-55886-66—2087 Indian School Rd, Los Angeles, CA, 900770.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-115044ENRAngela M Spencer1957-03-27UHC-26327-0755596950813030 Indian School Rd, Columbus, OH, 432000.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-114257ENRDot H Elliott1963-04-10UHC-67017-3162386753876036 Highland Ave, Plano, TX, 750480.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-126145ENRBryan S Ramirez1996-01-11UHC-62667-4627188445859889 Indian School Rd, Plano, TX, 750090.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50723TPAMartha Harrison1980-03-26——7138 Lincoln Way, Denver, CO, 802880.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-427788CLMEmilly Lane2002-08-21UHC-37845-55—6688 Washington St # 687, Glendale, AZ, 853250.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-117607ENRAbigail O Walker1944-08-21UHC-24452-0486833177839062 Ridge Rd Apt 36, Sacramento, CA0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-120577ENRHannah Wlliams1987-08-16UHC-36369-6942148693417355 Camelback Rd, Tucson, AZ, 857680.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-401089CLMAmy Vargas1949-09-27—78971778988448 Mesa Dr, Chandler, AZ, 852950.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-128749ENRJustin Mejia1982-04-05UHC-92003-9698078228137815 Forest Ave, Minneapolis, MN0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21681PRVAhmed Munoz1980-06-16—38277641973355 River Rd, Plano, TX, 750540.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
PRV-28847PRVChristian I Simmons1996-09-04UHC-30204-7440085924998494 Central Ave Apt 38, Phoenix, AZ, 850920.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-140248ENRBryan Wallace—UHC-43200-366908774170399 Desert Sky Blvd, Nashville, TN, 372260.50Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141676ENRBrenda Gilbert1964-04-10UHC-88402-7678341107075169 Spring St Apt 6, Nashville, TN, 372090.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61476TPAAisha Wilson1964-02-01——2473 Bayshore Dr, Nashville, TN, 372290.50SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-133545ENRJonathan Roberts1942-08-19UHC-96363-5878834184932139 Ocean Ave, Fresno, CA, 937790.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-142798ENRLuis O Montgomery1992-02-03UHC-06571-5137071249363225 Harbor Blvd, Houston, TX, 770580.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414501CLMBrandon Torres1955-11-27UHC-26652-2028688748404878 Canyon Rd # 700, Chandler, AZ0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-109539ENRJacqueline Ward2005-10-19UHC-85118-854097503030523 Lake View Rd, Tucson, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-409757CLMAaron Lee1997-12-14—59965993039253 Spring St, Tucson, AZ, 857480.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400636CLMMatthew Vgea1998-08-17UHC-91944-194834304551789 River Rd, Dallas, TX, 752350.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-103963ENRJuan A Washington1959-11-14UHC-91717-9237654764802948 Highland Ave, Chandler, AZ, 852820.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-101543ENRKate Fiels—UHC-27585-3585377933027998 Spring St, Mesa, AZ, 852050.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-142716ENRGeorge Coleman—UHC-22944-3228692101127711 Valley View Dr, Sacramento, CA, 958960.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121764ENRStephanie Lane1941-06-10UHC-25162-8444749423327072 Baseline Rd, Atlanta, GA, 303150.50Two-digit birth yearMember ID reformattedSSN last four extractedState code upper-cased+3 more
CLM-405952CLMCarlos Salazar1992-08-07UHC-04052-2140797028872954 Canyon Rd # 744, Phoenix, AZ0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
100,000 rows, page 90 of 2,000PreviousNext