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-53528TPAArjun Wang2008-11-20—34365253628548 Cedar Ln, Nashville, TN, 372740.66Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+1 more
TPA-61075TPAMarcus Wallace1954-02-11——5894 Bayshore Dr, Miami, FL, 331620.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
TPA-63694TPAMichellle Phillips1946-10-01—58990447524100 Lake View Rd, Miami, FL, 331480.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-57043TPASean Walsh1940-11-14UHC-07850-72—1571 Union St, Glendale, AZ, 853470.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51629TPAArjun Knight1956-03-05UHC-04978-0796685576432859 Ridge Rd, Minneapolis, MN, 554980.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-59275TPAArthur Gray1996-05-02——4343 Spring St # 181, Nashville, TN, 372130.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-51118TPAKen Hughes1975-08-17——3248 Bayshore Dr, Miami, FL, 331150.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-53823TPABilly Parker1973-06-07—95948430691222 Baseline Rd, Chandler, AZ, 852800.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
TPA-59632TPATheresa Henry1991-12-11——8184 Meadow Ln, San Diego, CA, 921750.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51257TPAElijah Porter1950-09-15——1434 Canyon Rd, Columbus, OH, 432020.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-55416TPAVirginia Ross1999-07-13——6241 Main St, Orlando, FL, 328270.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60012TPACarlos Daniels1974-11-06——4075 Maple Ave, Denver, CO, 802060.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56912TPAIsabella K Morris2006-07-20———0.66Middle initial moved out of first nameName re-casedGender normalisedWhitespace trimmed+1 more
TPA-61070TPAAlice Morrison1965-01-13—22939689387940 Sage Ct, San Antonio, TX, 782650.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-60697TPAJacck Barnes1940-07-25UHC-58851-08—5734 Washington St, Atlanta, GA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-60698TPAJacck Barnes1940-07-25UHC-58851-08—5734 Washington St, Atlanta, GA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-63384TPAKayla X Holmes1952-10-16——7289 Canyon Rd, San Diego, CA, 921360.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-53220TPAJordan Harris1951-12-25——1233 Forest Ave, Las Vegas, NV, 891200.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62046TPAMarcus K Jensen1968-07-11——2794 Pine Dr, San Antonio, TX, 782420.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50931TPAGloria Hamilton2008-01-22——4463 Lake View Rd, Tampa, FL0.66Name split from “Last, First”Date of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-60249TPAMark Hunt1997-06-20——1061 Market St, Houston, TX, 770340.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-51527TPAMelissa Garza1988-03-28——7408 Washington St, Fresno, CA, 937490.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-51315TPAFrank Ramirez1973-09-09UHC-97290-10371324298916 Pine Dr, Fresno, CA, 937930.66Name split from “Last, First”Date of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-63941TPALinda Y Coopar1950-12-07——9108 Washington St, Eden Prairie, MN, 553070.66Name re-casedSSN last four extractedZIP+4 trimmedWhitespace trimmed+1 more
TPA-54688TPAWei Carroll1995-02-10—32658555631945 Ocean Ave # 936, Nashville, TN, 372200.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-63646TPAJeffrey Padilla1983-08-18——9574 Ridge Rd, Eden Prairie, MN, 553300.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-52647TPAMary Garrett1997-05-15UHC-41408-06—5195 Maple Ave, Tempe, AZ, 852650.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-59404TPAMason L Miller1955-12-23—5818967848825 Mountain View Dr, Houston, TX, 770050.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-58910TPAJoe Oslon1986-02-15——8847 Market St, Scottsdale, AZ, 852450.66Name re-casedPhone missing area codeGender normalisedWhitespace trimmed+1 more
TPA-57129TPANicholas Alexander1989-04-25—79163543006192 Canyon Rd, Mesa, AZ, 852820.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55808TPABruce Hcks1978-02-20——632 Sunset Blvd, Charlotte, NC0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
TPA-55157TPAFrank P Cook1975-10-03——3893 Canyon Rd, Scottsdale, AZ, 852340.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-62380TPAAndrea Q Garcia1952-09-28——7817 Washington St, Houston, TX, 770590.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-58231TPARandy Burke1948-05-15——1425 River Rd, Minneapolis, MN, 554640.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-63345TPANicholas R Wright1948-05-06——9424 Park Pl, Columbus, OH, 432040.66Name re-casedSSN last four extractedState name converted to codeWhitespace trimmed+1 more
TPA-62222TPAMargaret Jensen1954-12-27——5804 Sunset Blvd, Minneapolis, MN, 554940.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55877TPAAlbert Hayes1993-09-23——1017 Willow Ct, Tempe, AZ, 852010.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-58117TPADiego T Snyder1949-08-27——8410 Valley View Dr, Columbus, OH0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-58118TPADiego T Snyder1949-08-27——8410 Valley View Dr, Columbus, OH0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-58398TPAHelen Jimenez1975-09-22UHC-73267-49—6644 Mesa Dr, Fresno, CA, 937970.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-57995TPAVictoria I Peterson2004-03-17———0.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
TPA-53492TPABryan Ryan1983-06-11——1607 Desert Sky Blvd, Sacramento, CA, 958580.66Two-digit birth yearCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-56082TPACarlos Fields2005-11-05——9541 Ridge Rd, Jacksonville, FL, 322780.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
TPA-61946TPAMarcus Ford1973-01-02——4043 Washington St, Eden Prairie, MN, 553440.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-52780TPAFrances Mason1979-03-07——7506 Highland Ave, Scottsdale, AZ0.66Name re-casedDate of birth reformattedState name converted to codeZIP missing+1 more
TPA-60887TPAJoseph Murray1957-08-06——3641 Union St, Eden Prairie, MN, 553500.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-54758TPACarolyn Wong1977-01-09——2259 Highland Ave, Sacramento, CA, 958400.66Name re-casedTwo-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
TPA-57808TPAEugene Graham2004-10-26UHC-44398-20—1088 Maple Ave, Fresno, CA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-51938TPAWei Gardner1971-04-01—64953366507039 Apache Blvd, Columbus, OH, 432440.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-51241TPAPeter Brooks1965-09-18——2138 Union St, Seattle, WA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
14,474 rows, page 86 of 290PreviousNext