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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-54024TPAJoan Phillips1945-04-28—68268290521773 Mesa Dr, Austin, TX, 787820.50Name split from “Last, First”Two-digit birth yearPhone reformattedState code upper-cased+3 more
TPA-54772TPACharlotte Valdez1991-05-01—83022176981375 Canyon Rd Apt 26, Columbus, OH, 432880.52Two-digit birth yearPhone reformattedUnit split from streetState code upper-cased+2 more
TPA-62301TPATimothy Parker1997-01-11—32663797728235 Market St, Eden Prairie, MN, 553680.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-52073TPASteven Alvarez1980-01-26—98233050996128 Oak St, Gilbert, AZ, 852770.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-56289TPAAhmed Marshall1985-05-08——4444 Canyon Rd # 987, Sacramento, CA, 958390.52Two-digit birth yearUnit split from streetCity re-casedGender normalised+2 more
TPA-60612TPASofia Barnes——41650472342982 Highland Ave Apt 36, Eden Prairie, MN, 553460.52Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+2 more
TPA-54117TPABrian Hawkins1990-02-01——9646 Spring St, Nashville, TN, 372750.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-53443TPAJudy Little2002-04-17——1140 Cedar Ln Apt 35, Columbus, OH, 432920.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-57493TPADiane Maldonado1965-07-17—61496733358807 Broadway, Minneapolis, MN0.52Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
TPA-61408TPAAlexaner Palmer1984-03-01——8899 Apache Blvd, Dallas, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61052TPADavid Rios1995-08-18UHC-78651-32—1708 Camelback Rd, San Antonio, TX, 782660.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-56810TPADay Q Denny———2557 Bayshore Dr, Tempe, AZ, 852250.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60660TPAAlexis Washington1988-02-18——4319 Camelback Rd Apt 29, Tampa, FL, 336960.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-52277TPAEmma Bryant1970-12-11——1609 Lincoln Way, Tucson, AZ, 857290.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-50879TPAChristina F Perez2000-01-20—45575448979108 Meadow Ln, Gilbert, AZ0.52Name split from “Last, First”Middle initial moved out of first nameCity re-casedZIP missing+2 more
TPA-56339TPAChristian Gonzalez1988-04-07——9250 Baseline Rd Apt 21, Nashville, TN0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-58860TPACarl Murphy1955-08-03—59934232433504 Harbor Blvd, Tucson, AZ0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63609TPAChristian Andersson1939-07-09——2042 Washington St, Orlando, FL, 328180.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-51087TPABryan Carpenter1953-01-10——3793 Harbor Blvd, Los Angeles, CA, 900750.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-63932TPAZachary Scott1949-12-24—60678269868108 Canyon Rd, Plano, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-61589TPANicholas Arnold1982-05-18——6306 Indian School Rd, Gilbert, AZ, 852260.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-59450TPAJesse Cunningham——81370649957036 Grand Ave, Tampa, FL0.52Name re-casedDate of birth unreadablePhone reformattedState name converted to code+2 more
TPA-59566TPABrian Walsh1938-10-27—50989603758446 Central Ave, Eden Prairie, MN, 553650.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-59565TPABrian Walsh1938-10-27—50989603758446 Central Ave, Eden Prairie, MN, 553650.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-62028TPALawrence Fuller2000-12-09——6647 Church St, Jacksonville, FL0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
TPA-63783TPAJason Kelley1949-01-20——4295 Palm Dr, Las Vegas, NV, 891400.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-62156TPALinda Smith1960-12-14UHC-42244-1490892529386026 Indian School Rd, Tampa, FL, 336090.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64036TPAEvelyn Guzman1990-07-11——5792 Bayshore Dr # 818, Seattle, WA, 981780.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56058TPAHenry Z Johnson1982-05-24——8640 Willow Ct, Tucson, AZ, 857570.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59444TPAWilliam Payne1942-07-04——6262 Sunset Blvd # 599, Charlotte, NC, 282040.52Name re-casedDate of birth reformattedUnit split from streetState name converted to code+2 more
TPA-58033TPAJennifer Powell1953-10-20——5942 Forest Ave, Gilbert, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-54179TPARalph D Chavez1988-12-07——8378 Ridge Rd, Denver, CO, 802580.52Name re-casedDate of birth reformattedPhone missing area codeZIP+4 trimmed+2 more
TPA-60773TPAAngela Wells1985-07-25——2563 Pine Dr Apt 6, Fresno, CA, 937150.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-58824TPAStaven Turner1940-04-27——7023 River Rd, Gilbert, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-60511TPASean Garrett1941-08-10—75095546763081 Indian School Rd, Tampa, FL, 336620.52Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-64196TPARoger Wang1950-02-04—52873107095745 Jefferson Ave, Charlotte, NC, 282710.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55934TPAJeremy X Armstrong1989-04-21——9463 Harbor Blvd, Plano, TX, 750510.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-63090TPARussell Kennedy1980-05-20——4980 Jefferson Ave, Charlotte, NC, 282110.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-60309TPAHannah Vazquez2008-07-21——5714 River Rd # 643, Dallas, TX, 752950.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57525TPAEvelyn P Coleman1987-02-14—23596813181338 Ridge Rd # 465, Gilbert, AZ, 852530.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56560TPATimothy Berry2007-12-24——1940 Cedar Ln Apt 26, Plano, TX, 750950.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56001TPAScott Powell1958-11-17——7010 Park Pl, Plano, TX0.52Name split from “Last, First”Two-digit birth yearCity re-casedZIP missing+2 more
TPA-61340TPAAaron Reyes1946-09-11—24061062597541 Canyon Rd, Charlotte, NC, 282280.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61341TPAAaron Reyes1946-09-11—24061062597541 Canyon Rd, Charlotte, NC, 282280.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61257TPAWalter Morris1945-08-18——9310 Forest Ave, Las Vegas, NV0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
TPA-57749TPAMarilyn King1970-10-14—88246655717092 Pine Dr, Houston, TX, 770780.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-50505TPATerry Fox2007-08-14——5658 Maple Ave, Las Vegas, NV, 891810.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-51016TPARalph Stephens2000-12-04——3893 Elm St, Gilbert, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-57343TPAMelissa Holmes1950-12-25——7566 Spring St # 263, San Antonio, TX0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-53606TPAMadison Valdez——67393554691204 Washington St, Gilbert, AZ, 852340.52Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+2 more
14,474 rows, page 18 of 290PreviousNext