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-61755TPARussell Tran1946-10-01——8161 Valley View Dr, Mesa, AZ, 852880.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53028TPAJonathan Johnson1946-02-08——2808 Broadway, Dallas, TX0.76Name re-casedDate of birth reformattedCity re-casedZIP missing+2 more
TPA-52069TPAAnn R Cook2002-01-18—40528812466761 Park Pl, Fresno, CA, 937460.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-57726TPABobby T Mendez1987-11-04——5296 Central Ave, Atlanta, GA, 303430.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59319TPACamila Hunt2001-04-21UHC-41725-5955779911742756 Union St, Tampa, FL, 336590.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62625TPAGary Vargas1949-09-07——4106 Canyon Rd, Houston, TX, 770570.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59911TPAKeith Foster1973-01-10—84669712323575 Oak St, Phoenix, AZ, 850430.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62738TPAFrances Riley1976-07-17UHC-22768-5128662626542157 Maple Ave, Nashville, TN, 372510.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63240TPAMichelle Dean1957-09-09—2662021352615 Washington St, Denver, CO, 802480.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53521TPARichard Herrera1984-08-28——9847 Maple Ave, Tucson, AZ, 857550.76Name re-casedDate of birth reformattedCity re-casedGender normalised+2 more
TPA-50136TPAChristina O Gray1982-06-23—21161837638282 Cedar Ln, Charlotte, NC, 282850.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50927TPABradley Anderson1976-07-24—40630212715819 Forest Ave, Las Vegas, NV, 891200.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61392TPALucia V Weaver2000-08-24——4920 Lake View Rd, Columbus, OH, 432960.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58060TPAKenneth Sims1999-06-16UHC-30731-182473060141392 Indian School Rd, Phoenix, AZ, 850960.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53307TPADiana X Murphy1963-09-13—7635285128800 Market St, Mesa, AZ, 852600.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52158TPAZahary Ortega1947-11-11——7811 Washington St, Fresno, CA, 937780.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58779TPALinda X Wagner1994-05-17—31792763893653 Pine Dr, Atlanta, GA, 303380.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64049TPAJulie Evans1978-10-16UHC-51135-08—847 Sage Ct, Tucson, AZ0.76Date of birth reformattedMember ID reformattedCity re-casedZIP missing+2 more
TPA-60747TPAPeggy Taylor1962-04-12—4423596196—0.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-52692TPAZachary F Hudson1952-12-12——3391 Jefferson Ave, Gilbert, AZ, 852880.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50166TPACristopher Pierce1944-11-18—90892033433313 Desert Sky Blvd, Minneapolis, MN, 554050.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62964TPAEric Hernadez1979-04-17—68634434405841 Forest Ave, Los Angeles, CA, 900340.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51331TPADoris Weber1959-08-24UHC-86325-71—851 Mountain View Dr, Chandler, AZ, 852360.76Member ID reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-55111TPAChristopher West2008-09-19—70299515079858 Spring St, Tucson, AZ, 857450.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63950TPAMiller Dick1966-07-22——1979 Hillcrest Rd, Miami, FL, 331540.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57082TPAMason Morales1941-08-10——3768 Maple Ave, San Diego, CA, 921690.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56092TPASophia Cole1987-02-06UHC-35994-13—2155 Spring St, Atlanta, GA, 303540.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-51246TPARoy Tucker1946-01-17UHC-34706-33—7341 Oak St, Atlanta, GA, 303000.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51245TPARoy Tucker1946-01-17UHC-34706-33—7341 Oak St, Atlanta, GA, 303000.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59126TPAMason Stevens2005-09-23UHC-89948-35—2997 Mountain View Dr, Minneapolis, MN, 554180.76Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54209TPAEugene Coleman1986-01-20——9066 Ocean Ave, Austin, TX, 787480.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60070TPASean Ray1970-02-01—57454525148684 Desert Sky Blvd, Columbus, OH, 432240.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-53185TPAAbby Stone2008-12-07—70962895699054 Mesa Dr, Tampa, FL, 336810.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60546TPADiego Ramos2004-03-13—40760075546810 Highland Ave, Tucson, AZ, 857250.76Name split from “Last, First”Date of birth reformattedPhone reformattedState code upper-cased+2 more
TPA-53125TPAHannah Rose1969-11-16—24653558093727 Sunset Blvd, Denver, CO, 802800.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62443TPABruce Gaarrett1950-06-24——9636 Bayshore Dr, Columbus, OH, 432990.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63114TPASteve Kelley1976-11-11—68270898883639 Camelback Rd, Jacksonville, FL, 322830.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59107TPACheryl Woods1941-05-03—79337164743117 Union St, Plano, TX, 750050.76Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-63514TPADenise Thomas2003-03-03—2108459799983 Palm Dr, Atlanta, GA, 303010.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50368TPASofia Chavez1996-12-23—48166723973709 Sunset Blvd, Los Angeles, CA, 900670.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60357TPADiane Patel1948-10-01——8529 Mountain View Dr, Austin, TX, 787790.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63344TPAKaren Alexander1975-02-26—50693899026849 Cedar Ln, Nashville, TN, 372540.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59425TPADavid Hill1969-02-17——2886 Mountain View Dr, San Diego, CA, 921730.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51755TPARoger Watson1948-04-27—43679147756246 Forest Ave, Minneapolis, MN, 554290.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59376TPAAnthony Parker1987-01-26——6120 River Rd, Denver, CO, 802620.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-57353TPANathan Pena1944-03-17——5239 Maple Ave, Glendale, AZ, 853030.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63088TPAHeather Rodriguez1942-02-16——460 Washington St, Mesa, AZ, 852760.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64237TPASara Warren1960-10-23—73766975231795 Desert Sky Blvd, Dallas, TX, 752830.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51492TPAAnthony Salazar2004-01-25——3940 Hillcrest Rd, Plano, TX, 750070.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59540TPAAustin Mariana1967-10-15——5576 Oak St, Denver, CO, 802820.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 124 of 290PreviousNext