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-60629TPASofia Walker1997-10-01——3784 Oak St, Mesa, AZ, 852770.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-57599TPAJeck Campbell1968-03-16UHC-15180-41—1440 Grand Ave, Las Vegas, NV, 891330.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62013TPAIsabella H Shaw———9248 Park Pl, Las Vegas, NV, 891390.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59257TPAJordan Murphy1986-12-16——621 Indian School Rd, Gilbert, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61796TPAMills Sophia1991-10-20——1708 Union St, Los Angeles, CA, 900850.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63043TPA—Junk1975-03-16——4120 River Rd, Jacksonville, FL0.52Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+2 more
TPA-55394TPAKathleen Hill1999-03-18——8010 Oak St, Fresno, CA, 937460.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-58762TPAJulie Maldonado—UHC-32095-9436766134602499 Cedar Ln # 572, Tampa, FL, 336550.52Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-60761TPARoy Gilbert1957-01-25——5220 Market St, San Antonio, TX, 782210.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-59061TPAAisha Nichols1996-07-14——9422 Baseline Rd, Orlando, FL, 328260.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51249TPAGrace V Salazar1946-06-19—65599642756117 Mountain View Dr, Glendale, AZ, 853940.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-50829TPACloe Stephanie1997-09-22——4353 Ocean Ave # 180, Houston, TX, 770310.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-57264TPAJanet X Henderson1976-07-16—98430869937039 Mountain View Dr Apt 28, Houston, TX0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-52057TPARonald Broooks1990-04-28——7486 Union St, Glendale, AZ, 853820.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-52306TPADylan Hill1962-01-21UHC-19089-37—5307 Valley View Dr, Charlotte, NC, 282510.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-55780TPADiana Dixon1963-04-18—58188241635701 Union St, Nashville, TN0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-64272TPABenjamin Walker1995-12-12——4431 Union St Apt 10, Jacksonville, FL0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-56319TPAElijah Stone1944-04-03——250 Washington St # 471, Tempe, AZ, 852060.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-52465TPASandra Smith1977-06-05—40950111272383 Park Pl, Chandler, AZ, 852040.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-51983TPATimothy Tran1958-04-25—46576453555906 Apache Blvd, Glendale, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56322TPAHeather Nelson1950-11-11—35841978717856 Jefferson Ave, Houston, TX, 770330.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-54497TPAMark F Owens1946-08-06——6488 Cedar Ln, Fresno, CA, 937800.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-50028TPAFatima Lynnch2001-08-22——7675 Harbor Blvd, Columbus, OH, 432000.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-59147TPAJacob Jensen———5608 Meadow Ln, Denver, CO, 802600.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-53986TPAJacqueline E Truner2000-11-12UHC-69964-16—898 Lincoln Way, Austin, TX, 787890.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-56960TPANoah Burton1959-02-27——6852 Meadow Ln # 186, Jacksonville, FL, 322590.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-50034TPAChristian W Contreras1983-07-26——5376 Desert Sky Blvd, Miami, FL, 331720.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-58436TPAGerald Little1996-11-14UHC-94042-51—3476 Ocean Ave, Columbus, OH, 432970.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
TPA-56053TPAJean L Edwards1956-04-04—45273664688902 Central Ave, Mesa, AZ, 852380.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53091TPAAngela Cook1957-11-18——2908 Highland Ave # 989, Plano, TX, 750000.52Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-54566TPAMichelle Cunningham2007-07-25——1038 Main St # 290, Gilbert, AZ, 852500.52SSN last four extractedUnit split from streetCity re-casedZIP+4 trimmed+2 more
TPA-59955TPABilly Bradley1998-05-18——2621 Palm Dr Apt 25, Atlanta, GA, 303740.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51379TPAJacob Wong1982-10-02——5567 Palm Dr, Houston, TX, 770490.52Name split from “Last, First”Two-digit birth yearEmail lower-casedGender normalised+2 more
TPA-54944TPAEveyln Castro1965-08-12——1347 Ocean Ave, Columbus, OH, 432860.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-54069TPAZachary Perkins2003-04-25——9138 Grand Ave, Tucson, AZ, 857300.54Name split from “Last, First”Two-digit birth yearGender normalisedWhitespace trimmed+1 more
TPA-53716TPABrenda Garrett1984-09-28———0.54Name re-casedPhone missing area codeSSN last four extractedGender normalised+1 more
TPA-54430TPAKarren Guerrero1980-06-26—37237713397928 Bayshore Dr, Orlando, FL, 328540.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-58438TPARebecca Williams1980-04-20——1967 Union St, Charlotte, NC, 282780.54Name re-casedSSN last four extractedState name converted to codeZIP+4 trimmed+1 more
TPA-64037TPALogan Lnch1967-08-25——6009 Palm Dr, Fresno, CA, 937550.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-50364TPAAgela R Yang1970-01-18——7662 Oak St, Austin, TX, 787020.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-63287TPANathan Campbell1985-11-19UHC-33373-4385252580318466 Lake View Rd, Seattle, WA, 981030.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-52092TPABradley Schmidt1954-04-16———0.54Name split from “Last, First”Two-digit birth yearGender normalisedWhitespace trimmed+1 more
TPA-55164TPALaura Jensen2003-06-19——6137 Indian School Rd, Sacramento, CA, 958760.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-58587TPARandy Long1990-01-25——3698 River Rd, San Diego, CA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-58030TPANoah Wallace1952-12-09UHC-53723-54—3878 Main St, Minneapolis, MN, 554700.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-59545TPAJesse Rios1905-07-02——8321 Apache Blvd, Miami, FL, 331930.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-59307TPAFrances Diaz1972-11-19——5477 Hillcrest Rd, Houston, TX, 770710.54Name split from “Last, First”Date of birth reformattedState name converted to codeZIP+4 trimmed+1 more
TPA-58971TPAGloria Tran1945-05-04——403 Lake View Rd, Tampa, FL0.54Name split from “Last, First”ZIP missingGender normalisedWhitespace trimmed+1 more
TPA-55069TPAJoshua Ramos1952-07-04——1749 Broadway # 313, Minneapolis, MN0.54Name split from “Last, First”Unit split from streetZIP missingWhitespace trimmed+1 more
TPA-58371TPASofia Garrett1987-05-08UHC-60736-866707143325256 Ocean Ave, Seattle, WA, 981970.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
14,474 rows, page 25 of 290PreviousNext