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-61640TPAHiiroshi H Smith1993-06-06—35587482753852 Elm St, Las Vegas, NV, 891110.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63506TPAChristian Hansen1941-01-12UHC-24650-3679731505475586 Church St, Glendale, AZ, 853670.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63661TPAMegan Vargas2001-01-27——7543 Grand Ave, San Antonio, TX, 782660.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55874TPAMarcus Whte1984-02-10UHC-00927-1585583031113172 Main St, Scottsdale, AZ, 852990.76Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more
TPA-63639TPAKaren Young1971-06-26UHC-94385-95—2949 Hillcrest Rd, San Diego, CA, 921640.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51043TPABeverly Miller1938-01-27—77324127027645 Central Ave, San Diego, CA, 921800.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55525TPAThumas Webb1966-07-03——5126 Cedar Ln, Scottsdale, AZ, 852200.76Name re-casedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
TPA-63754TPAPhilip Day1968-03-15—72888145646956 Washington St, Miami, FL, 331190.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59397TPADylan Bowman1984-06-22—43869764322383 Cedar Ln, Jacksonville, FL, 322370.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63710TPADeniel Mejia1965-07-17UHC-18153-4287664203447763 Ocean Ave # 518, Columbus, OH, 432220.76Name re-casedPhone reformattedMember ID reformattedUnit split from street+2 more
TPA-54615TPABradley Perkins2003-08-26———0.76Name re-casedDate of birth reformattedEmail lower-casedGender normalised+2 more
TPA-57215TPABeverly Aguilar1992-04-15—88937266185561 Main St, Minneapolis, MN, 554800.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56797TPAKevin Austin1961-08-28——5743 Union St, Scottsdale, AZ, 852700.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61043TPASean Campbell1982-12-12UHC-19745-753667000422—0.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-59344TPAJuan Dean1979-07-12—91920938117400 Church St, Glendale, AZ, 853760.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62473TPARoy Vargas1985-08-04UHC-67291-40—4832 Canyon Rd, Los Angeles, CA, 900370.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54147TPAStephanie Nichols1973-03-28——6263 Ocean Ave, Gilbert, AZ, 852520.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59619TPAAndrea Marquez2008-10-18UHC-63854-8664736183727039 Grand Ave, Houston, TX, 770560.76Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
TPA-58893TPARebecca Foster1972-09-20—37556381062598 Oak St, San Diego, CA, 921980.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58291TPAAlike Herrera1980-06-25——4802 Camelback Rd, Tucson, AZ, 857830.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51890TPAAmy Hanson1938-10-03——8796 Bayshore Dr, Columbus, OH, 432400.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-59125TPASantiago U Bishop1969-09-14——5634 Bayshore Dr, Atlanta, GA, 303670.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63722TPAEmma Willis1983-08-20—93099121092116 Pine Dr, Los Angeles, CA, 900540.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51944TPALogan N Bell1970-08-22—22475983458447 River Rd, Miami, FL, 331450.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55279TPABrian Hoffman1965-06-22——3389 Baseline Rd, Gilbert, AZ, 852450.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58885TPAWei Griffin1983-07-13——6937 Union St, Houston, TX, 770010.76Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-56313TPAArthur Wagner1938-09-25UHC-67545-5541625326539144 Desert Sky Blvd, Orlando, FL, 328600.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57587TPAHannah Lucas1986-12-09UHC-54951-70—9358 Mountain View Dr, Plano, TX, 750670.76Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56277TPAPhilip Valdez1996-03-02—7198936030713 Camelback Rd, Denver, CO, 802340.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59113TPAShirley Brooks2008-01-09—58985717799548 Washington St, Atlanta, GA, 303960.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51637TPADebra Fernandez1970-12-20—72644206929207 River Rd, Austin, TX, 787220.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57475TPABradley Sims2006-09-04—79738646405554 Cedar Ln, Atlanta, GA, 303000.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51321TPAFatima Ryan1959-08-24——9612 Ridge Rd, Austin, TX, 787670.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64189TPADiana Mendez1939-03-19—31830132034576 Canyon Rd, Sacramento, CA, 958150.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51602TPAJanice Ramirez1972-02-17——4673 Sunset Blvd, Eden Prairie, MN, 553580.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51601TPAJanice Ramirez1972-02-17——4673 Sunset Blvd, Eden Prairie, MN, 553580.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50425TPACamila Cruz1998-04-14—50883375273842 Ocean Ave, Atlanta, GA, 303460.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63648TPADiana Cruz1984-05-15——2273 Main St, Orlando, FL, 328080.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55266TPAHeather Graahm1970-05-06—54462433213412 Mountain View Dr, Houston, TX, 770730.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55526TPAThomas H Webb1966-07-03——5126 Cedar Ln, Scottsdale, AZ, 852200.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63254TPAMartha J Marquez2002-07-06—88074056556570 Mesa Dr, Phoenix, AZ, 850530.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64101TPAAlbert Herrera1941-05-20—82025111685804 Lake View Rd, Plano, TX, 750630.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60441TPALinda Barnes1984-10-21UHC-93776-9945234078631023 Palm Dr, Chandler, AZ, 852520.76Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more
TPA-50253TPAMateo Espinoza1979-03-21UHC-22304-7371773468222755 Central Ave, Austin, TX, 787980.76Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
TPA-59226TPAAngela Williamson1947-10-26——6565 Baseline Rd, Phoenix, AZ, 850720.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-60145TPAOlivia Coopper1981-09-05—6877811662683 Bayshore Dr, Minneapolis, MN, 554920.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64307TPAJustin Cruz1944-09-18—41967781482917 Ridge Rd, San Antonio, TX, 782730.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62068TPAHenry Miller1973-10-09UHC-88772-0334027772165855 Ocean Ave, Plano, TX, 750100.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53775TPAAndrew Phillips1946-03-28—90768287084171 Harbor Blvd, Columbus, OH, 432260.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59884TPABob Marquez1950-08-05——590 Palm Dr, Scottsdale, AZ, 852000.76Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
14,474 rows, page 119 of 290PreviousNext