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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-62656TPAMartha Davis1983-01-03—72373251121368 Harbor Blvd, San Antonio, TX, 782710.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
TPA-51707TPABrian Bishop1959-01-02—23832514531478 Lincoln Way, Plano, TX, 750570.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-59518TPARichard Hamilton2001-10-03——7349 Bayshore Dr, Plano, TX, 750990.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-57932TPARoger Arnold2005-06-25——2065 Lake View Rd, Denver, CO, 802130.68Name split from “Last, First”Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-54205TPAKevyn Willis1965-03-08—33498203883862 Washington St, Denver, CO, 802310.68Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-58157TPAGerald Ortega———8711 Cedar Ln Apt 29, Columbus, OH, 432910.68Name re-casedDate of birth unreadableUnit split from streetPlaceholder values cleared
TPA-58156TPAGerald Ortega———8711 Cedar Ln Apt 29, Columbus, OH, 432910.68Name re-casedDate of birth unreadableUnit split from streetPlaceholder values cleared
TPA-59767TPARichard Shultz1960-09-04—67657226493637 Union St, Tempe, AZ, 852640.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55494TPADorothy Padilla2002-12-01—5543601961412 River Rd, Tucson, AZ, 857510.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61599TPAAdam Carlson1990-04-20——2767 Lake View Rd, Denver, CO, 802810.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-61315TPALoagn Gibson1961-12-08——5444 Union St, Sacramento, CA, 958150.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-56684TPATerry Z Diaz2005-09-08——1888 Lincoln Way, San Diego, CA, 921660.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-60036TPAJulia Baker1975-07-01——659 Central Ave # 111, Glendale, AZ, 853210.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
TPA-60080TPAArthur Mendoza1978-08-19——4435 Sage Ct, Tampa, FL, 336150.70Name split from “Last, First”State name converted to codePlaceholder values cleared
TPA-62600TPAAbigail Morris————0.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
TPA-57989TPAMargaret Mills1980-01-24UHC-42099-41——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-50785TPASarah Lawson———3210 Market St, Nashville, TN0.70Date of birth unreadableZIP missingPlaceholder values cleared
TPA-61096TPAJames Richardson1943-05-17——4127 Highland Ave, Gilbert, AZ, 852290.70Two-digit birth yearGender normalisedPlaceholder values cleared
TPA-62116TPADiane Meendoza1967-08-13——3454 Bayshore Dr, Mesa, AZ, 852160.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-55717TPABryan C Soto1986-10-28——1605 Lincoln Way, San Antonio, TX, 782210.70State name converted to codeZIP+4 trimmedPlaceholder values cleared
TPA-64408TPAMei W McCoy1955-01-23UHC-65566-67——0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
TPA-53386TPAPaul Little———7967 Sage Ct, Tampa, FL, 336670.70Date of birth unreadableGender normalisedPlaceholder values cleared
TPA-61953TPABrittany Watson1971-04-25——3073 Market St Apt 7, Sacramento, CA, 958740.70Two-digit birth yearUnit split from streetPlaceholder values cleared
TPA-63386TPATerry Salazar1946-12-06UHC-65903-57——0.70Two-digit birth yearGender normalisedPlaceholder values cleared
TPA-52657TPAZachary Romero——9163739317—0.70Name split from “Last, First”Date of birth missingPlaceholder values cleared
TPA-53016TPASusan Edwards1977-01-25——1215 Ridge Rd, Orlando, FL, 328670.70Name split from “Last, First”State name converted to codePlaceholder values cleared
TPA-52579TPAJanet Ryan——34592330617220 Market St, Orlando, FL0.70Date of birth unreadableZIP missingPlaceholder values cleared
TPA-58830TPAAlice Willis1944-06-18——5380 Willow Ct, Nashville, TN, 372410.70Two-digit birth yearGender normalisedPlaceholder values cleared
TPA-55831TPAThomas Mendoza2007-04-23UHC-73410-84——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-57444TPAMatthew Green1993-09-16——1531 Oak St, Gilbert, AZ0.70ZIP missingGender normalisedPlaceholder values cleared
TPA-50616TPAYuki Green1907-08-13——6180 Jefferson Ave, San Antonio, TX, 782230.70Name split from “Last, First”ZIP+4 trimmedPlaceholder values cleared
TPA-55274TPAJulia Vega———8225 Highland Ave, Scottsdale, AZ, 852290.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
TPA-62055TPADouglas Edwards1996-09-28UHC-70622-634089910490—0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
TPA-56035TPAChristian Y Burton1976-03-16———0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-62711TPAJoan Coleman———6592 Willow Ct Apt 11, Tampa, FL, 336360.70Date of birth unreadableUnit split from streetPlaceholder values cleared
TPA-58488TPAMichelle Jenkins1979-10-13UHC-18507-38——0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
TPA-61615TPAMarc X Herrera1956-12-27——9213 Cedar Ln, Denver, CO, 802090.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-51635TPAMateo T Henderson1947-03-13——2138 Central Ave, Chandler, AZ, 852270.70Two-digit birth yearState name converted to codePlaceholder values cleared
TPA-54456TPANancy Lynch1970-02-10——1365 Spring St, Denver, CO, 802890.70Name split from “Last, First”ZIP+4 trimmedPlaceholder values cleared
TPA-63746TPAAdam Alexander1994-02-24—40567623591034 Harbor Blvd, Eden Prairie, MN0.70State name converted to codeZIP missingPlaceholder values cleared
TPA-59963TPAWei Morris1970-02-14——9555 Central Ave, Mesa, AZ, 852530.70Name split from “Last, First”ZIP+4 trimmedPlaceholder values cleared
TPA-56369TPANicole K Banks1996-12-26——2517 Mountain View Dr, Mesa, AZ0.70Two-digit birth yearZIP missingPlaceholder values cleared
TPA-62160TPAElizabeth Taylor1988-03-18——9091 Forest Ave, Gilbert, AZ, 852370.70Name split from “Last, First”Phone missing area codePlaceholder values cleared
TPA-60402TPAAustin Kelly1978-10-18———0.70Two-digit birth yearGender normalisedPlaceholder values cleared
TPA-60048TPAGabriel Price1959-11-11—75598181329889 Washington St, Minneapolis, MN, 554450.70Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-64180TPAJeffrey O Arnold1996-06-16UHC-02477-34—838 River Rd, Sacramento, CA, 958250.70State name converted to codeGender normalisedPlaceholder values cleared
TPA-59235TPARuth Mills2005-05-13——6713 Market St, Tampa, FL, 336180.70Two-digit birth yearZIP+4 trimmedPlaceholder values cleared
TPA-51580TPAElijah Stephens1960-12-16——6193 Cedar Ln Apt 5, Eden Prairie, MN, 553930.70Unit split from streetZIP+4 trimmedPlaceholder values cleared
TPA-54929TPADaniel Martinez1990-03-07——8221 Willow Ct, Phoenix, AZ, 850010.70Two-digit birth yearState name converted to codePlaceholder values cleared
TPA-61092TPABetty Miller1965-05-22——4060 Indian School Rd, Tampa, FL, 336710.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
14,474 rows, page 101 of 290PreviousNext