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-50454TPAMaria Harrison1998-01-02——2840 Oak St, Columbus, OH, 432970.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51546TPATeresa Wilson1977-09-18UHC-45385-63—456 Canyon Rd, Tucson, AZ, 857750.68Name split from “Last, First”Member ID reformattedState name converted to codePlaceholder values cleared
TPA-61918TPAChristine Hunter——43345378507386 Forest Ave, Jacksonville, FL, 322280.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-53183TPABruce Vega1989-04-11—90932213463482 Maple Ave, Denver, CO, 802770.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
TPA-55388TPAJennifer Le1952-03-04———0.68SSN last four extractedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50572TPAAmy Hayes1953-06-10——8700 Maple Ave, Atlanta, GA, 303920.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60047TPARuth K Aguilar1995-07-04—63299858887008 Cedar Ln, Mesa, AZ, 852070.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-55173TPAKelly Martinez1999-11-10——2305 Apache Blvd, Seattle, WA, 981600.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53417TPAPaul P Ortega1951-04-19—79298313437282 Cedar Ln, Los Angeles, CA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-50763TPAJulia Hudson1973-04-10—5103754706—0.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
TPA-59668TPAOlivia Reed———9635 Forest Ave, San Antonio, TX, 782760.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58627TPAChristine Fuller1976-04-25UHC-04747-15—9726 Valley View Dr Apt 12, Glendale, AZ, 853230.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62087TPALaura Simpson1948-01-26——7788 Sunset Blvd, Chandler, AZ, 852710.68Name re-casedState name converted to codeGender normalisedPlaceholder values cleared
TPA-57928TPAJudy Hart2006-05-28UHC-11656-07—2376 Meadow Ln, Scottsdale, AZ, 852630.68City re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-51520TPAMichael Kelly———9662 Willow Ct, Dallas, TX, 752000.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61737TPAArjun Wright1982-09-07——8140 Washington St, Charlotte, NC, 282270.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-62121TPAMartha Campbell1970-12-14—41760779193970 Harbor Blvd, Gilbert, AZ, 852010.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63591TPAJerry Knight1993-08-06——2251 Forest Ave, Los Angeles, CA, 900320.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-55067TPATeresa Lewwis2000-06-26——7045 Meadow Ln, Dallas, TX, 752820.68Two-digit birth yearZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-55258TPASophia Montgomery1947-01-08—72228113802573 Oak St, Austin, TX, 787080.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-55257TPASophia Montgomery1947-01-08—72228113802573 Oak St, Austin, TX, 787080.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-55313TPAMariana Scott1995-02-26UHC-73872-667708316082221 River Rd, Eden Prairie, MN, 553100.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
TPA-64279TPAJlie Hall1956-08-14——1783 Union St, Jacksonville, FL, 322020.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-56769TPACheryl Walker1944-07-15——4512 Oak St, Tucson, AZ, 857330.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61064TPAMartha Y Dixno2007-02-09———0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-54059TPAAaron Campbell1975-11-03——9770 Park Pl, Austin, TX, 787080.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54455TPAGabriel N Evaans1964-09-06UHC-98530-62—9838 Indian School Rd, Phoenix, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-53980TPAWei Nelson———5374 Mesa Dr, Tampa, FL, 336290.68Date of birth missingCity re-casedZIP+4 trimmedPlaceholder values cleared
TPA-63574TPAMateo Salazar1965-05-19——4525 Highland Ave, Mesa, AZ, 852150.68City re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-50053TPANathan Q Yang1989-12-19——7436 River Rd Apt 16, Seattle, WA, 981900.68Name split from “Last, First”Date of birth reformattedUnit split from streetPlaceholder values cleared
TPA-63057TPAMarya Stone1970-12-01——2623 Church St, San Diego, CA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-58417TPAGary Jordan1977-03-09———0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61481TPADorothy Salazar————0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-57707TPAAngela A Martin2006-02-23——3353 Ridge Rd, Tucson, AZ, 857950.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-63251TPACarolyn Li1947-07-28——6525 Highland Ave, Nashville, TN, 372050.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63252TPACarolyn Li1947-07-28——6525 Highland Ave, Nashville, TN, 372050.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50949TPALarry Bryant1996-10-10UHC-63283-73—3207 Camelback Rd, Las Vegas, NV, 891480.68Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised
TPA-62694TPAHiroshi Herrera1979-01-23——4577 Union St, Plano, TX, 750180.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57107TPALinda Little1986-10-25——7194 Main St, Denver, CO, 802200.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-60171TPABobby Adams1972-01-12—20825047978522 Spring St Apt 23, Plano, TX, 750700.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
TPA-55076TPAJudith Castillo——43165286245562 Pine Dr, Tucson, AZ, 857930.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53430TPAScott L Cooper2008-02-08——9015 Church St, Glendale, AZ, 853520.68Two-digit birth yearState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-52204TPAJoyce Q Gibson1984-04-10——2946 Ocean Ave, Las Vegas, NV, 891130.68Date of birth reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-62553TPAJoyce Murray1984-04-01—4663273964—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-52022TPALinda Gomez1994-04-14——8638 River Rd, Jacksonville, FL, 322510.68Name re-casedTwo-digit birth yearState name converted to codeWhitespace trimmed
TPA-55116TPAFrank Moreno1941-03-07——2391 Lincoln Way # 874, Sacramento, CA, 958060.68Date of birth reformattedPhone missing area codeUnit split from streetPlaceholder values cleared
TPA-53158TPAChristine Munoz——2215303664—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-52002TPAScott Richardson———5331 Highland Ave, Gilbert, AZ, 852970.68Date of birth unreadablePhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-50905TPAAnthony Z Gray1947-05-21—49841691693721 Park Pl, Miami, FL, 331020.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58646TPAValentina Santiago1994-10-02——5323 Broadway, Las Vegas, NV, 891750.68Name re-casedState name converted to codeGender normalisedPlaceholder values cleared
14,474 rows, page 94 of 290PreviousNext