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-140280ENRJessica V Wood2004-05-24UHC-42569-5755963426083017 Camelback Rd, Scottsdale, AZ, 852700.38Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-120825ENRGerald Hunter—UHC-11413-0344573388035105 Sunset Blvd, Columbus, OH0.38Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108073ENREmily Lopez2004-08-12UHC-26356-0841270162753277 Forest Ave, Seattle, WA, 981530.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106341ENRDiego S Espinoza1992-02-11UHC-74540-6846361960166172 Willow Ct, Houston, TX, 770620.38Name split from “Last, First”Two-digit birth yearSSN last four extractedStreet suffix standardised+3 more
TPA-56725TPAAmy Lawrence2003-09-23——2012 Mountain View Dr Apt 20, Denver, CO, 802470.38Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-63933TPAMary Freeman1989-10-16——2156 Highland Ave Apt 8, Sacramento, CA, 958920.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-107594ENRAhmed Munoz1980-06-16UHC-44111-0938277641972523 Bayshore Dr Apt 31, Austin, TX, 787080.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-425804CLMStephanie Chapman1961-10-04—62568836107839 Main St # 781, Gilbert, AZ, 852620.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-24130PRVBeth R Howard2001-12-10——6188 Church St, San Antonio, TX, 782140.38Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-105245ENRRichard J Thompson1994-09-10UHC-33481-1153346791144153 Jefferson Ave, Houston, TX, 770630.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-429987CLMRymond Wood1988-01-25——1485 Apache Blvd Apt 11, Glendale, AZ, 853810.38Name split from “Last, First”SSN last four extractedUnit split from streetStreet suffix standardised+3 more
CLM-429767CLMEric A Burke———5360 Valley View Dr # 904, San Diego, CA, 921940.38Name re-casedDate of birth reformattedDate of birth unreadableUnit split from street+3 more
CLM-416053CLMBian Ramirez1955-01-27UHC-95424-96—3731 Market St Apt 29, Tempe, AZ, 852860.38Name re-casedTwo-digit birth yearUnit split from streetState name converted to code+3 more
CLM-408996CLMMargaret Ramirez1942-07-20——9566 Bayshore Dr, Austin, TX0.38Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
ENR-139262ENRDanielle E Young2004-09-22UHC-09608-9797981983865918 Baseline Rd, Sacramento, CA, 958110.38Name split from “Last, First”Phone reformattedSSN last four extractedState name converted to code+3 more
TPA-54888TPAKenneth Fuller———7076 Lake View Rd, Seattle, WA, 981760.38Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+3 more
ENR-119735ENRAmber T Berry1995-05-11UHC-99791-8222941230395315 Palm Dr # 310, Atlanta, GA, 303690.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-117581ENRDiego Bowman1973-10-25UHC-16501-7698185409358183 Sunset Blvd, Charlotte, NC0.38Name split from “Last, First”Phone reformattedSSN last four extractedZIP missing+3 more
ENR-114647ENRRoy U Kim1972-11-02UHC-44848-3964837367511602 Church St # 795, Nashville, TN0.38Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-100488ENRPhilip W Cole1991-03-27UHC-87676-1441380169404018 Highland Ave, Sacramento, CA, 958370.38Name split from “Last, First”Two-digit birth yearPhone reformattedState name converted to code+3 more
ENR-141206ENRTerry Tucker1978-04-18UHC-71283-357739769186525 Meadow Ln, Minneapolis, MN, 554590.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422342CLMDorothy Richards1979-02-07—8163835314987 Willow Ct, San Antonio, TX, 782800.38Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-53079TPADavid Henry——45930830734431 Harbor Blvd, Charlotte, NC0.38Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-56774TPAHiroshi Gilbert1958-01-09——1631 Sunset Blvd Apt 3, San Antonio, TX, 782070.38Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-122676ENRGeorge E Porter1959-02-20UHC-03769-5172762869051997 Elm St, Eden Prairie, MN, 553280.38Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-50464TPAJanet Gibson1966-08-04——8053 Mesa Dr, Jacksonville, FL0.38Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-130215ENRAna Knight1992-08-10UHC-00835-2657735969684791 Harbor Blvd # 125, Glendale, AZ, 853270.38Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-425333CLMTeresa Y Davis1962-01-25UHC-40343-6770343641602133 Lake View Rd, Orlando, FL, 328410.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-104139ENRBrenda R Estrada1963-12-15UHC-89999-03—8397 Canyon Rd, Tucson, AZ, 857380.38Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-115664ENRElizabeth Q Dominguez1974-03-10UHC-35965-9367662741704119 Church St, Charlotte, NC, 282510.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109867ENRDeborah X Harvey1986-10-11UHC-95099-5596142487108313 Market St, Tampa, FL, 336490.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-115675ENRScott Z Reyes—UHC-64259-9896335127716572 Forest Ave, Houston, TX, 770110.38Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-400911CLMCarl Sandoval1998-04-01UHC-49946-01—1075 Elm St Apt 20, Plano, TX0.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-60865TPAJose Ford———7094 Jefferson Ave, Mesa, AZ, 852120.38Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-137546ENRNancy G Harveey1994-03-19UHC-47422-60—4513 Palm Dr, San Diego, CA0.38Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-407945CLMWillieJunk2000-12-12UHC-06567-1026082286419015 River Rd, Minneapolis, MN0.38Street suffix standardisedAddress re-casedZIP missingGender normalised+3 more
PRV-28133PRVBrandon T Bennett1939-08-21—83730455421280 Camelback Rd # 719, Tucson, AZ, 857320.38Middle initial moved out of first nameUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-415849CLMShirley Harper1966-05-19UHC-21504-79—9319 Church St Apt 37, Scottsdale, AZ, 852880.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-125427ENRMason Cunningham1994-06-09UHC-61288-67—5701 Apache Blvd, San Diego, CA, 921120.38Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-139459ENREric C Le1991-02-03UHC-19236-0341625091664978 Apache Blvd, Houston, TX0.38Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410426CLMEmma E Garza—UHC-80361-35—9103 Jefferson Ave, Seattle, WA, 981410.38Name split from “Last, First”Date of birth reformattedDate of birth unreadableCity re-cased+3 more
ENR-103428ENRKimberly R Patel1992-09-21UHC-12413-5145179807204322 Valley View Dr # 773, Fresno, CA, 937090.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-135027ENRSophia Mills1991-10-20UHC-74721-5722721224501708 Union St, Los Angeles, CA0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114897ENRGabriel G Peterson2006-07-26UHC-69899-2524748273943911 Lincoln Way, San Antonio, TX, 782570.38Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-133270ENRLarry Mendoza1992-09-08UHC-14829-6294344621902548 Willow Ct, Orlando, FL, 328090.38Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-132396ENRKatherine Silva1939-05-20UHC-05146-68—1542 Market St # 102, Tampa, FL0.38Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-106710ENRNicholas Cunningham1958-02-02UHC-50476-5970228817074425 Hillcrest Rd, Orlando, FL, 328070.38Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-130068ENRAnna R Wong2007-03-16UHC-73396-7172266062779280 Valley View Dr, Jacksonville, FL, 322030.38Middle initial moved out of first nameTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-63000TPATeerry Fernandez1991-06-18——2920 Pine Dr, Atlanta, GA, 303300.38Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-118551ENRRalph Cole1964-06-11UHC-07842-5725187141109782 Valley View Dr, Tucson, AZ0.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 33 of 2,000PreviousNext