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-107661ENRSara Carr1982-05-24UHC-76869-4541341001173915 Washington St, Nashville, TN, 372930.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111687ENRMratha B Soto1957-12-05UHC-45087-6350147086722000 Harbor Blvd, Austin, TX, 787000.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-137038ENRGaary Herrera1983-11-17UHC-69117-245483689686589 Mountain View Dr, Plano, TX, 750170.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59387TPALarry Bradley2001-10-13——3299 Pine Dr, Eden Prairie, MN, 553910.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-122979ENRDiane L Armstrong2004-04-20UHC-42308-2420153999993013 Forest Ave # 864, Charlotte, NC, 282460.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-125738ENRJustin Q Murphy—UHC-52723-7437475769578829 Pine Dr, Dallas, TX, 752790.52Date of birth reformattedDate of birth unreadablePhone reformattedSSN last four extracted+2 more
PRV-27686PRVDouglas R Woods1940-01-07——2430 Elm St, Columbus, OH0.52Middle initial moved out of first namePhone missing area codeState code upper-casedZIP missing+2 more
TPA-57875TPAAndrea Carter1968-01-14——589 Bayshore Dr, Houston, TX, 770820.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-51518TPABetty Carlson1976-12-24——3306 River Rd, Seattle, WA, 981350.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24157PRVLisa Huughes2005-08-28—43355631723596 Main St # 498, Las Vegas, NV, 891780.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-105592ENRSantiago Herrera1965-05-20UHC-36829-7429753367139406 Washington St, Mesa, AZ, 852670.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-116179ENRJacob L Evans1966-12-02UHC-47768-2490068801737447 Baseline Rd, Fresno, CA, 937590.52Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+2 more
TPA-61568TPABarbara Dunn2007-01-04UHC-34994-98—8620 Cedar Ln, Miami, FL, 331980.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-430118CLMAustin Bowman1959-10-02UHC-22804-98—4575 Jefferson Ave, Houston, TX0.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27794PRVMark Morgan1981-04-13UHC-34154-2352427336092340 Pine Dr # 761, Tampa, FL, 336070.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-431520CLMJoan F Harris1994-07-26UHC-53549-8537845269142628 Lincoln Way, Minneapolis, MN, 554460.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-25862PRVJudy Schmidt2002-02-05—63739236454339 Park Pl Apt 12, Tempe, AZ, 852330.52Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+2 more
ENR-142058ENRTimothy G Bennett1940-11-17UHC-58565-8337444606471538 Harbor Blvd # 855, Tempe, AZ, 852340.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-58589TPACarolyn Ortiz1983-01-27——4744 Cedar Ln, Miami, FL, 331790.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-423458CLMPatricia Cooper1938-05-02—51892993343209 Baseline Rd, Fresno, CA, 937920.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412688CLMIsabella P Wilson2003-04-02UHC-32664-9827859961028501 Spring St, San Diego, CA, 921130.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402877CLMAmanda Austin1998-09-20—22367823828867 Elm St, Plano, TX, 750750.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127425ENRDonna Cook1978-02-12UHC-07640-0687987082986772 Desert Sky Blvd, Nashville, TN, 372760.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-101139ENRBrandoon J Munoz1965-08-06UHC-24440-974199034858466 Desert Sky Blvd, Jacksonville, FL, 322530.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-429612CLMKaren Richardson1962-12-14UHC-37708-18—1730 Central Ave, Nashville, TN, 372480.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-138758ENRDorothy Y Banks1968-02-22UHC-45975-3877967588292711 Baseline Rd, Orlando, FL, 328540.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-411938CLMKeith Ramirez1954-06-19UHC-39559-25—9683 Grand Ave, Tempe, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-409834CLMAmber Green1976-03-15UHC-30412-77—2929 Maple Ave, Seattle, WA, 981040.52Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-28784PRVJulia Z Nelson1997-06-11—81421350206787 Maple Ave, Tucson, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-104227ENRAdam H Buurke1940-09-04UHC-31213-7459248432771835 Hillcrest Rd, Nashville, TN, 372490.52Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+2 more
TPA-64470TPAWayne Simmons———2699 Ocean Ave Apt 3, Seattle, WA, 981480.52Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+2 more
ENR-125825ENRAaron V Berry1972-03-04UHC-34568-5163292085213935 Market St, Chandler, AZ, 852860.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-25229PRVMatthew P Riec1999-03-22—86894716316058 Apache Blvd, Houston, TX, 770660.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-418419CLMHenry S Wells1938-11-01UHC-53311-49—539 Lincoln Way, Plano, TX, 750920.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-132095ENRJacob Peterson1947-11-04UHC-66053-3927574342171241 Washington St Apt 40, Tucson, AZ, 857640.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414365CLMFrank C Garrett1994-06-20——9348 Mesa Dr, Charlotte, NC0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-118202ENRGrace I Ramos1991-08-09UHC-74116-697933245860683 Hillcrest Rd, Charlotte, NC, 282310.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-134581ENRLinda L Washington—UHC-77668-4827576238205949 Sage Ct, Houston, TX, 770730.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122172ENRNoah C Oliver2008-12-05UHC-30408-5826355533756736 Grand Ave, Dallas, TX0.52Name split from “Last, First”Two-digit birth yearPhone reformattedZIP missing+2 more
CLM-406482CLMLogan Powell1961-06-22——9821 Cedar Ln, Sacramento, CA, 958450.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-121713ENRNicholas W Armstronng1968-08-14UHC-86103-0330061829343483 Willow Ct Apt 19, Tucson, AZ, 857190.52Middle initial moved out of first nameDate of birth reformattedSSN last four extractedUnit split from street+2 more
CLM-417006CLMMadison Taylor1957-06-12UHC-49436-3288177844554368 Sage Ct # 282, Sacramento, CA0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61374TPAJoan Soto1981-05-17——1004 Apache Blvd Apt 14, Los Angeles, CA, 900000.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418585CLMChristian Chavez1996-01-20UHC-18389-7350379203667834 Oak St # 917, Seattle, WA, 981130.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418584CLMChristian Chavez1996-01-20UHC-18389-7350379203667834 Oak St # 917, Seattle, WA, 981130.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-120486ENRJack Wallae1988-04-23UHC-64103-8959522036993117 River Rd, Plano, TX0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419741CLMBeverly Young1994-03-25UHC-66215-27—2556 Sunset Blvd, Minneapolis, MN, 554920.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-131774ENRMendoza Frank1981-10-06UHC-46190-1493870766349694 Oak St, Charlotte, NC, 282250.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-108112ENRNick Harrison1986-01-22UHC-96747-2057790840108587 Maple Ave, Dallas, TX, 752620.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400156CLMHarold Bursn1974-12-10——8011 Ocean Ave, Miami, FL, 331500.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
100,000 rows, page 173 of 2,000PreviousNext