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-56832TPACarolyn Stevens2005-09-16—55399154285431 Forest Ave, Seattle, WA, 981760.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-54535TPAMatthew Perrez1960-08-09—68270987703837 Camelback Rd, Seattle, WA, 981930.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56122TPAJulia X Cunningham1954-05-28——3668 Spring St, Austin, TX, 787250.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61076TPALauren Huffman1941-01-11UHC-50586-2682680418537071 Mesa Dr, Tucson, AZ, 857370.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-60235TPAKatherine W Carpenter1977-08-22——2630 Harbor Blvd, Tampa, FL, 336590.78Name re-casedDate of birth reformattedCity re-casedZIP+4 trimmed+1 more
TPA-60071TPASean Ray1970-02-01—57454525148684 Desert Sky Blvd, Columbus, OH, 432240.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-61985TPASantiago Sandoval1958-10-12——8497 Camelback Rd, San Antonio, TX, 782130.78Date of birth reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+1 more
TPA-53731TPAStephanie Valdez1982-02-19——6959 River Rd, Gilbert, AZ, 852230.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55814TPAEmma Washington1985-07-26UHC-86378-61—6403 Park Pl, Miami, FL, 331430.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-58998TPAMara Romero1964-03-15——4347 Willow Ct, Dallas, TX, 752750.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60343TPAWei Soto1961-10-08UHC-13631-55—6071 Valley View Dr, Columbus, OH, 432400.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-64144TPAEthan Lopez1972-07-10——992 Sage Ct, San Diego, CA, 921480.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50850TPAJordan McCoy1995-02-04—63858885891084 Canyon Rd, Seattle, WA, 981720.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-60276TPAStephen Fernandez1944-08-17——5103 Lake View Rd, Phoenix, AZ, 850720.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52617TPAJose Ellitt2004-11-26——1677 Oak St, San Diego, CA, 921720.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54174TPAWilliam Cook1987-08-04—2865790529—0.78Name split from “Last, First”Phone reformattedPlan code upper-casedWhitespace trimmed+1 more
TPA-55107TPAThomas Dean1982-06-08——8694 Ocean Ave, Miami, FL, 331630.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-64383TPAChhristina Williams1996-12-21—44275251759383 Ocean Ave, Tucson, AZ, 857050.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-64132TPAMateo Sims1980-03-12——4897 Canyon Rd, San Diego, CA, 921870.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53992TPANicole Carter1978-02-06——5698 Grand Ave, Houston, TX, 770480.78Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-59593TPAPhilip Owens2004-08-19—8437819909391 Sunset Blvd, Fresno, CA, 937970.78Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-52923TPAWalter Patel2005-07-01UHC-76743-894442800558—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-54330TPAKyle U Sanchez1963-05-16UHC-85114-93—878 Ridge Rd, Minneapolis, MN, 554560.78Name re-casedPhone missing area codeMember ID reformattedWhitespace trimmed+1 more
TPA-53846TPAKenneth Evans1972-06-04——7384 Harbor Blvd, Houston, TX, 770450.78Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-56004TPAWei Cooper1980-10-26—92483589129846 Washington St, Columbus, OH, 432110.78Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-58357TPADoglas McDonald1959-11-11——6907 Valley View Dr, Austin, TX, 787040.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59203TPATom Bnks1970-05-19——707 Meadow Ln, San Antonio, TX, 782100.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-55230TPARoy Park1962-04-11——675 Church St, Las Vegas, NV, 891280.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-58341TPABeverly I Martinez1985-09-20—3366673465127 Valley View Dr, Phoenix, AZ, 850450.78Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-61708TPAThomas Sims1971-03-19—98171314184750 Grand Ave, Orlando, FL, 328980.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59959TPAEdward Duncan1961-06-25—8545193167619 Market St, Denver, CO, 802800.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-58554TPASamantha Burns1993-07-27——9661 Main St, Nashville, TN, 372480.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-54482TPAEdward Robinson1999-06-06—21588167793550 Maple Ave, Miami, FL, 331360.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-54126TPATimothy S Santos1980-07-26—95620940535827 Camelback Rd, Seattle, WA, 981800.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55007TPAHeather Garza1983-04-15——7382 Baseline Rd, Phoenix, AZ, 850130.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51066TPAOlivia Hunt1987-09-16—53557229904796 Hillcrest Rd, Atlanta, GA, 303020.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-51366TPAHannah Sims1983-06-23——3516 Lake View Rd, Tampa, FL, 336630.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53857TPAEugene Arnold1945-12-07——8379 Valley View Dr, Gilbert, AZ, 852040.78Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+1 more
TPA-58852TPADaniel Webb1951-10-12—39485211624456 Harbor Blvd, Denver, CO, 802310.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58122TPAMegan Ford2008-05-18——1688 Bayshore Dr, Columbus, OH, 432310.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57763TPAHnry Graham1969-04-04UHC-16030-05—46 Grand Ave, Plano, TX, 750230.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55493TPADorothy Padilla2002-12-01——412 River Rd, Tucson, AZ, 857510.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-59208TPAHenry Fernandez1963-09-11—38772963618236 Canyon Rd, Dallas, TX, 752080.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55855TPAAmbber Brown1948-01-04—77328694315547 Hillcrest Rd, Tucson, AZ, 857430.78Date of birth reformattedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-54468TPAKevin Wilson1995-09-15—78357026702944 Valley View Dr, Minneapolis, MN, 554100.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54469TPAKevin Wilson1995-09-15—78357026702944 Valley View Dr, Minneapolis, MN, 554100.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52768TPAPeggy Hill1946-11-12—22582031077893 Lake View Rd, Charlotte, NC, 282780.78Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-55183TPALuis Munoz1963-10-07—56831135368503 Oak St, Atlanta, GA, 303540.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60088TPALoggan Simmons1959-06-11—92479511548239 Forest Ave, Fresno, CA, 937860.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-50920TPAJoe Nguyen1961-12-10——5618 Hillcrest Rd, Plano, TX, 750460.78Name re-casedDate of birth reformattedState name converted to codeWhitespace trimmed+1 more
14,474 rows, page 141 of 290PreviousNext