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-55670TPAJoe Richards1945-09-03——5655 Ridge Rd, Minneapolis, MN, 554040.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60239TPAAmy Berry1942-11-21——2566 Lake View Rd, Glendale, AZ, 853040.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51276TPAKathryn Harrison1974-01-11—27977031672953 Elm St, Orlando, FL, 328550.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51478TPAWayne Luna1942-05-16—73486624579591 Jefferson Ave, Denver, CO, 802320.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50691TPAVincent M Dixon1965-12-09—39879355632436 Maple Ave, Austin, TX, 787000.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51280TPAVirgginia F Delgado1962-04-03UHC-25625-2456763920008879 Ocean Ave, Denver, CO, 802150.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-58193TPASean Adams1968-12-24UHC-01130-2983576269256127 Indian School Rd, Los Angeles, CA, 900010.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-54012TPAJoshua Roberts1963-03-27——9038 Washington St, Columbus, OH, 432020.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50694TPARussell Aguilar2004-04-06—66630065327938 Elm St, Jacksonville, FL, 322810.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64018TPAHiroshi Day1998-11-02—21433668189870 Apache Blvd, Mesa, AZ, 852780.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50713TPACharles Marquez1991-05-09—5675652015357 Willow Ct, Miami, FL, 331450.74Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more
TPA-56497TPASandra Obrien1985-10-07—90091666397731 Spring St, Atlanta, GA, 303200.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-63831TPAMarcus Valdez1964-02-25——7713 Ridge Rd, Scottsdale, AZ, 852640.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63812TPAKim Hill1945-12-18—77074823011065 Camelback Rd, San Antonio, TX, 782640.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50860TPASean Alvarado1974-11-08——3881 Palm Dr, Los Angeles, CA, 900000.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55130TPABrandon A Park1957-07-13—62490682801620 Willow Ct, Scottsdale, AZ, 852940.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-57941TPACarl N Valdez1964-02-03——6049 Forest Ave, Atlanta, GA, 303800.74Name re-casedDate of birth reformattedCity re-casedState name converted to code+3 more
TPA-57539TPAMargaret Moore1965-02-17—28751696485409 Canyon Rd, Sacramento, CA, 958150.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-63681TPASean Brown2003-10-25—36440516149064 Jefferson Ave, Fresno, CA, 937350.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63796TPABetty Owens1990-04-28—45046281125241 Maple Ave, Nashville, TN, 372640.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61531TPADanielle Schultz1941-07-01UHC-73966-9495959068717494 Union St, Eden Prairie, MN, 553020.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-55739TPAKathyn Henry2002-02-12——7738 Broadway, Tampa, FL, 336570.74Name re-casedDate of birth reformattedAddress re-casedCity re-cased+3 more
TPA-63224TPABetty Sandoval1944-09-25——1080 Desert Sky Blvd, Dallas, TX, 752270.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55026TPAWei Hanson1956-02-20—57630198047792 Spring St, Nashville, TN, 372380.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52233TPAMargaret Warren1988-11-03——1560 Washington St, Atlanta, GA, 303440.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61661TPADot Alexander1946-07-26——4659 Ocean Ave, Atlanta, GA, 303030.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50855TPATyler Guerrero1989-03-25—25587712043570 Park Pl, Phoenix, AZ, 850260.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54525TPALuis Q Campbell1987-10-16—83942780354276 Washington St, Denver, CO, 802240.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-62586TPAHannah G Moore1963-03-27——4706 Central Ave, Minneapolis, MN, 554350.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62587TPAHannah G Moore1963-03-27——4706 Central Ave, Minneapolis, MN, 554350.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-63954TPAAshley Carpenter1967-01-15—90560090293832 Ocean Ave, Denver, CO, 802550.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
TPA-50540TPAPamela Garrett1944-12-07—96140467059254 Grand Ave, Chandler, AZ, 852650.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61260TPAJoran Rivera1943-06-02——1873 Bayshore Dr, Dallas, TX, 752610.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63419TPAJessica A George1949-12-04UHC-93474-84—5100 Valley View Dr, Seattle, WA, 981420.74Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-59528TPAPaul Bryant1975-01-19——7916 Meadow Ln, Denver, CO, 802360.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50319TPACheryl Parker1988-06-09—74626169928286 Bayshore Dr, Tampa, FL, 336490.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56137TPAWilliam Thomas1963-02-12—48931243106444 Ridge Rd, Scottsdale, AZ, 852800.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61398TPAGary N Kelly1969-12-25—90059105749565 Valley View Dr, San Antonio, TX, 782370.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60975TPAAlan Obrien1961-03-02—54134509562792 Bayshore Dr, Atlanta, GA, 303910.74Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
TPA-50828TPAStephanie Cole1997-09-22——4353 Ocean Ave, Houston, TX, 770310.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54671TPARachel Patterson1941-11-27—89175136258143 Mountain View Dr, Tampa, FL, 336860.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-62769TPAMatthew Kelly1981-02-20—33339503055109 Hillcrest Rd, Sacramento, CA, 958840.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-53321TPACollins Heather2000-11-25—39330724027770 Meadow Ln, Eden Prairie, MN, 553570.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-64459TPASantiago Powell1985-08-20——6590 Canyon Rd, Columbus, OH, 432540.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61114TPAMary Smith1945-07-09—56926567921344 Apache Blvd, Austin, TX, 787040.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51080TPALucia Hansen1985-01-22—3357434090671 Maple Ave, Mesa, AZ, 852930.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63023TPABobby Salazar1978-06-09—92739112696704 Main St, Seattle, WA, 981940.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55410TPATerry Elliott1980-05-20UHC-43012-07—6936 Willow Ct, Tempe, AZ, 852600.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58798TPAMateo Hansen1997-01-23UHC-39094-5254533870791668 Jefferson Ave, Chandler, AZ, 852430.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52436TPAJesse Tucker1983-05-04—59773298544341 Church St, Glendale, AZ, 853150.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
14,474 rows, page 108 of 290PreviousNext