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-59120TPASara Santiago1996-01-19——2345 Valley View Dr Apt 19, Denver, CO, 802510.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52764TPAElijah Ryan1991-11-22UHC-60945-02—1873 Meadow Ln, Austin, TX, 787910.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52157TPAAmy McDonald1991-08-25—79178476223775 Valley View Dr, Sacramento, CA, 958490.68Name split from “Last, First”Phone reformattedState name converted to codePlaceholder values cleared
TPA-62138TPASusan Diaz1968-04-05—89461744295538 Grand Ave, Scottsdale, AZ, 852990.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-50590TPADeborah Stephens1998-04-13——2776 Mesa Dr, Chandler, AZ, 852030.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-63406TPADonna Lawson1973-12-08——112 Grand Ave, Phoenix, AZ, 850300.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-58219TPADouglas Day1946-08-13——3209 Washington St, Orlando, FL, 328140.68Date of birth reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-56850TPABradley X Vazquez1989-07-07——1527 Cedar Ln Apt 37, Plano, TX, 750440.68Unit split from streetState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-64414TPABobby Myers1956-05-09UHC-26951-75—4441 Mesa Dr # 139, Phoenix, AZ, 850410.68Unit split from streetGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57463TPABill Wallace————0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62256TPAAbigail Daniels1969-05-18UHC-73907-78—6875 Indian School Rd, Los Angeles, CA, 900590.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53957TPAJacob Fowler1940-06-26——2147 Valley View Dr, Miami, FL, 331400.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61846TPAMatthew Warren1958-10-03——6845 Lake View Rd, San Diego, CA, 921540.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
TPA-59401TPANoah Cook1966-08-22—7552284724—0.68Phone reformattedSSN last four extractedGender normalisedPlaceholder values cleared
TPA-56843TPALinda Green1970-08-10——8032 Valley View Dr, Los Angeles, CA, 900380.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-52219TPAHannah Andrews1966-05-25——8163 Bayshore Dr, Orlando, FL, 328690.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-57893TPAPaul Luucas1946-06-15——3616 Camelback Rd, Jacksonville, FL, 322620.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58215TPADeborah Simpson1939-04-23——5622 Forest Ave, Nashville, TN0.68Name re-casedZIP missingGender normalisedPlaceholder values cleared
TPA-51727TPACharlotteJunk———8125 Canyon Rd, Austin, TX, 787650.68Date of birth unreadableState code upper-casedPlaceholder values clearedNo usable name (quarantined)
TPA-52397TPA—Junk1938-03-26——2266 Washington St, Nashville, TN, 372130.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
TPA-62043TPAOlivia Lynch1991-07-18——4811 Central Ave, Dallas, TX, 752430.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57661TPAKelly Morris1994-11-22——6358 Sage Ct, Orlando, FL, 328560.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53740TPAKenneth U Larson1982-07-22—32243866803899 Central Ave, Tempe, AZ, 852670.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-54202TPAWei Jenkiins1985-01-01—62576164002854 Elm St, Nashville, TN, 372530.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-51932TPABrandon Salazar1965-01-21——4338 River Rd, Mesa, AZ, 852680.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-50560TPAAnthony Johnson1959-04-12——4195 Meadow Ln, Orlando, FL, 328720.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50561TPAAnthony Johnson1959-04-12——4195 Meadow Ln, Orlando, FL, 328720.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56757TPAWalter Aguilar2001-02-15——2327 Ridge Rd, Dallas, TX, 752470.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-57876TPAJoan Kennedy1999-02-03——1032 Highland Ave, Minneapolis, MN0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-53896TPAKathryn S Bailey1952-03-04——4062 Baseline Rd, Tampa, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-53132TPAIsabella L Davis1976-08-21——3286 Bayshore Dr # 449, Atlanta, GA, 303330.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64048TPAJulie Evans1978-10-16——847 Sage Ct, Tucson, AZ0.68Two-digit birth yearZIP missingWhitespace trimmedPlaceholder values cleared
TPA-60643TPAPriya Ford1969-05-03——6295 Indian School Rd, Denver, CO, 802560.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-54667TPAMartin Mei1966-04-22——9829 Hillcrest Rd, San Antonio, TX, 782280.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58675TPABryan Jenkins1945-05-18—78042105385150 Cedar Ln, San Diego, CA, 921390.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62502TPAWayne Ray2003-12-15——1480 Jefferson Ave, Dallas, TX, 752960.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-53622TPA—Junk1951-06-04UHC-52905-0951645722565492 Highland Ave, Seattle, WA, 981980.68Phone reformattedCity re-casedZIP+4 trimmedNo usable name (quarantined)
TPA-57150TPAKatharine Schultz1955-09-26——2397 Pine Dr, Plano, TX, 750660.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63672TPADeborah Hughes1956-01-10——7923 Lake View Rd, San Antonio, TX, 782240.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63673TPADeborah Hughes1956-01-10——7923 Lake View Rd, San Antonio, TX, 782240.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60558TPAKelly Fox1996-01-15——4171 River Rd, Plano, TX, 750130.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53632TPAJanice V Stone1974-07-18—96384378886480 Ocean Ave # 122, Chandler, AZ, 852900.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61586TPASamuel George2008-12-03——2754 Cedar Ln, Denver, CO, 802220.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58841TPAVirginia Wilson1999-05-18——7763 Oak St # 196, San Antonio, TX, 782680.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60487TPAMarcus O Coleman1964-04-27—61951912169477 Highland Ave # 144, Sacramento, CA, 958200.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62325TPAAaron Knight1983-07-13UHC-95721-09—8293 Spring St, Nashville, TN, 372190.68Date of birth reformattedState name converted to codeZIP+4 trimmedPlaceholder values cleared
TPA-63040TPARaymond Duncan1952-03-16——7105 Park Pl # 607, Orlando, FL, 328330.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51126TPAGregory Richardson1960-04-11——1687 Palm Dr, Dallas, TX, 752710.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-51511TPASharon Boyd———4822 Camelback Rd, Minneapolis, MN, 554710.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63638TPABrenda H Gordoon1965-06-14——6342 Harbor Blvd # 325, Jacksonville, FL, 322270.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 96 of 290PreviousNext