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-63628TPAJulie C Walsh1980-09-08—78531364714721 Meadow Ln, Fresno, CA, 937560.50Date of birth reformattedPhone reformattedSSN last four extractedState name converted to code+3 more
TPA-63278TPAJoyce Berry1984-05-17—61687456445274 Palm Dr, Gilbert, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-50821TPAEthan A Stephens1996-04-21——7458 Washington St, Eden Prairie, MN, 553370.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59855TPAWayne Thmas1954-02-10UHC-60306-66—4016 Jefferson Ave, Seattle, WA, 981680.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-64410TPAMary Foster1978-06-27UHC-70030-6896725936974855 Mesa Dr # 101, San Diego, CA0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-56851TPAMaria Ryos—UHC-61386-4442969158389019 Cedar Ln, Sacramento, CA, 958030.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58950TPACynthia Silva1957-06-20——434 Highland Ave, Nashville, TN, 372330.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-54363TPACharlotte Gordon1983-07-13——4034 Mountain View Dr Apt 36, Orlando, FL, 328790.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
TPA-56401TPAJesse H Collins1987-04-01——7476 Grand Ave # 511, Columbus, OH, 432120.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-56862TPAJosh Harris1945-03-05——7597 Hillcrest Rd, Dallas, TX, 752700.50Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
TPA-59905TPAPamela Tran—UHC-02051-22—4889 Spring St, Sacramento, CA0.50Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61897TPAMason Fuller2007-01-11—82224182226548 Washington St # 485, Austin, TX, 787000.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50371TPALaura A Sullivan1974-11-11—65671790831021 Highland Ave, Atlanta, GA, 303780.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50052TPADiane A Scott1964-07-16—50667988426799 Main St, Los Angeles, CA, 900100.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
TPA-57189TPAJohn Ramos1991-11-26—2058026242626 Grand Ave, Tampa, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-53165TPAJason F Ryyan1993-06-10——1933 Lake View Rd, Gilbert, AZ, 852070.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-59790TPAHeather Waston1998-02-19——310 Main St, Plano, TX0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62023TPASantiago Weber1961-05-14—32078469091914 Forest Ave, Austin, TX, 787030.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53742TPAVincent Stevens1975-10-05—47239524321528 Baseline Rd, Sacramento, CA0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62147TPAWeyne Williamson1983-05-16UHC-45751-58—4055 Apache Blvd, Seattle, WA, 981840.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-58974TPADavid Rogers1950-12-15—69374973995317 Washington St, Mesa, AZ, 852180.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-63488TPARachel Griffin1997-03-14—59598754038748 Hillcrest Rd, Atlanta, GA, 303900.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55550TPAAustin Dean1970-06-23——4643 Church St # 208, San Diego, CA, 921760.50Name re-casedTwo-digit birth yearUnit split from streetCity re-cased+3 more
TPA-54454TPABeverly P Austin———9889 Apache Blvd, Scottsdale, AZ, 852140.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-53699TPAJacqueline Adams1996-06-09—45172231825404 Spring St, Houston, TX, 770670.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60987TPAHenry Fisher2005-06-18——409 Park Pl, Atlanta, GA, 303880.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-51743TPAMartha Bell1965-09-21——1624 Palm Dr, Mesa, AZ, 852220.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-64288TPAAna Mendoza1983-03-07——2702 Lake View Rd Apt 35, Atlanta, GA, 303070.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-56054TPAJean Edwards1956-04-04—45273664688902 Central Ave, Mesa, AZ, 852380.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61760TPACharlotte Rogers1996-03-20——7069 Cedar Ln, Houston, TX0.50Street suffix standardisedAddress re-casedState code upper-casedZIP missing+3 more
TPA-61388TPABill Ellis2001-02-14——8506 Sunset Blvd, Gilbert, AZ, 852720.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-58737TPABrian Hart1972-08-20—63851265691729 Highland Ave Apt 26, San Antonio, TX, 782580.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61042TPATyler Jenkins1999-10-06——7396 Ridge Rd, Fresno, CA, 937430.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61972TPACarolyn Long1941-01-20——2878 Market St, Austin, TX, 787420.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-59494TPAFrank Carpenter1999-02-27——1999 Cedar Ln, Austin, TX, 787370.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50063TPAJennifer H Cole1962-10-12—63965727175396 Elm St, Charlotte, NC0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-56361TPAGeorge M Torres1964-05-20UHC-42020-0992941626494804 Market St, Mesa, AZ, 852670.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57982TPAKayla Perez1964-12-11——5951 Forest Ave, Plano, TX, 750250.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-54367TPASteve McCoy1976-03-10—46375248888878 Market St, Scottsdale, AZ, 852600.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-52872TPACarl Pnea1953-07-21——6299 Central Ave, Tempe, AZ, 852830.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50700TPABrandon E Porter1947-04-22—75759763247764 Pine Dr, Miami, FL, 331650.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
TPA-53002TPAMary Cox1963-06-09—44655565362441 Canyon Rd, Eden Prairie, MN, 553750.50Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more
TPA-56327TPALuis Riley1971-06-19——8644 Apache Blvd, Los Angeles, CA0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-54093TPAAhmed T Le2003-06-10—25292967838017 Indian School Rd Apt 26, Tucson, AZ, 857420.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
TPA-53382TPARoger George1983-01-10—45334726181902 Washington St, Atlanta, GA, 303620.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63518TPAKimberly Vega1961-03-18——9577 Spring St, Nashville, TN, 372170.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-51542TPAAhmed Moore1988-10-26—47279633805163 Valley View Dr, Houston, TX, 770250.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60016TPANatalie Ferguson1942-05-16——8350 Hillcrest Rd, Tempe, AZ, 852060.50Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+3 more
TPA-54776TPAJoseph Ortiz1949-11-19—8324242760793 Central Ave, Mesa, AZ, 852600.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-60785TPASara Oliver1957-09-03——9299 Highland Ave, Scottsdale, AZ, 852680.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
14,474 rows, page 15 of 290PreviousNext