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-54755TPAAmanda A Rice1940-05-10——8763 Spring St, Fresno, CA, 937090.82Name split from “Last, First”City re-casedPlaceholder values cleared
TPA-64131TPAMateo I Sims1981-03-12———0.82Middle initial moved out of first nameWhitespace trimmedPlaceholder values cleared
TPA-63358TPAJesse Flores2008-11-16——7763 Hillcrest Rd, Nashville, TN, 372750.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-61503TPAEvelyn Yang1985-12-24———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-51183TPAThomas Soto1970-03-01—7869810060—0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-51419TPABeverly Stephens1996-11-18—74775165297528 Hillcrest Rd, Seattle, WA, 981040.82Phone reformattedStreet suffix standardisedAddress re-cased
TPA-57528TPABrian Gutierrez1995-03-11UHC-44758-23—6475 Central Ave, Sacramento, CA, 958740.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61898TPAMason Fuller2006-01-11——6548 Washington St, Austin, TX, 787000.82Name re-casedState name converted to codePlaceholder values cleared
TPA-60124TPAKelly Silva1965-06-28——5859 Spring St, Eden Prairie, MN, 553130.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-55124TPAAmanda Allen1954-10-20——4736 Lake View Rd, San Diego, CA, 921960.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60993TPAStephanie Collins1974-08-04UHC-85615-89—7122 Mesa Dr, Atlanta, GA, 303150.82Name re-casedPhone missing area codeWhitespace trimmed
TPA-52727TPASamantha Crawford1985-10-16——4309 Main St, Tampa, FL, 336070.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-54223TPAGeorge Baker1944-02-06——4291 Hillcrest Rd # 202, San Diego, CA, 921220.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-54224TPAGeorge Baker1944-02-06——4291 Hillcrest Rd # 202, San Diego, CA, 921220.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-50788TPASara E Ortega1954-09-16—62593262238418 Lake View Rd, Scottsdale, AZ, 852690.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-56692TPABrittany Mrris2001-01-10—4673404072—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-64075TPAIsabella Rose1991-01-19UHC-86613-44——0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-60995TPADebrah Luna1952-12-05——5251 Camelback Rd, Gilbert, AZ, 852330.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56687TPAPatricia Cook2000-07-23UHC-83160-56—1425 Valley View Dr, Sacramento, CA, 958780.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50672TPAChristian Hicks1961-12-20—6385243268444 Grand Ave, Los Angeles, CA, 900180.82Name re-casedGender normalisedPlaceholder values cleared
TPA-56458TPASantiago Wong1981-08-16——7006 Mesa Dr, Jacksonville, FL, 322430.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61712TPAGary Collns1978-09-17——3518 Mountain View Dr, Los Angeles, CA, 900370.82Date of birth reformattedSSN last four extractedPlaceholder values cleared
TPA-60752TPAIsabella Adams1984-04-08——5521 Church St, Jacksonville, FL, 322760.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-63247TPADenise Knight2005-03-02——7847 Central Ave, San Antonio, TX, 782820.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-61155TPABruce U Evans1946-06-09———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57410TPANancy Contreras1988-02-04——8194 Jefferson Ave, Denver, CO, 802640.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50347TPAStephanie Gardner1952-12-28UHC-33192-03—1154 Lincoln Way, Seattle, WA, 981590.82Name re-casedGender normalisedPlaceholder values cleared
TPA-50346TPAStephanie Gardner1952-12-28UHC-33192-03—1154 Lincoln Way, Seattle, WA, 981590.82Name re-casedGender normalisedPlaceholder values cleared
TPA-52725TPAJackie Payne1952-08-12——8478 Sunset Blvd, Plano, TX, 750910.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61756TPABarbara Johnston1973-12-10—82661397487133 Apache Blvd, Tampa, FL, 336510.82Name re-casedState name converted to codePlaceholder values cleared
TPA-62183TPADeborah Nichols1990-01-21—29847517287500 Broadway, Tampa, FL, 336010.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-55575TPAPatricia Howard1946-03-17——8106 Camelback Rd, Sacramento, CA, 958110.82Date of birth reformattedPhone missing area codePlaceholder values cleared
TPA-52539TPAValentina Thomas1972-06-05——8837 Hillcrest Rd, Gilbert, AZ, 852280.82City re-casedGender normalisedPlaceholder values cleared
TPA-59927TPABobby H Freeman1945-03-23——8006 Indian School Rd, Eden Prairie, MN, 553610.82Date of birth reformattedGender normalisedWhitespace trimmed
TPA-62076TPAKaren Lopez1992-01-05———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-54293TPAAmber Li1943-02-26——2607 Apache Blvd # 414, Eden Prairie, MN, 553970.82Name re-casedUnit split from streetPlaceholder values cleared
TPA-55551TPAPat Welch1952-01-17UHC-32323-36—8468 Indian School Rd, Tampa, FL, 336910.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-52466TPARoger Dominguez1946-05-18—4357984198668 Forest Ave, Las Vegas, NV, 891930.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-58747TPAJudy Andrews1986-09-07UHC-49978-5835465829106785 Pine Dr, Sacramento, CA, 958450.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51394TPAMichael Campbell2005-09-05——1057 Maple Ave, Austin, TX, 787310.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50498TPAJodan B Welch2001-11-13——2704 Maple Ave, Denver, CO, 802260.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62204TPAMadison Taylor1940-07-08———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-60322TPATricia Cooper1938-05-02——3209 Baseline Rd, Fresno, CA, 937920.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60099TPAJeff Payne1966-11-15——8073 Lake View Rd, Tempe, AZ, 852560.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60567TPADeborah Ball1939-04-25—77850806388886 Spring St, Austin, TX, 787350.82Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-52220TPAJoyce Rice1943-05-25——2028 Baseline Rd, Mesa, AZ, 852730.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57711TPAJonathan Lopez1975-09-28UHC-56956-03—9760 Bayshore Dr, Minneapolis, MN, 554690.82Name re-casedGender normalisedPlaceholder values cleared
TPA-59923TPACarlos Perez1980-01-24——8065 Washington St, Chandler, AZ0.82Name re-casedZIP missingPlaceholder values cleared
TPA-50091TPARanyd E Luna1946-09-28—97480470064881 Jefferson Ave, Gilbert, AZ, 852350.82Phone reformattedStreet suffix standardisedAddress re-cased
TPA-61991TPAJudith Jenkins1971-08-10——253 Highland Ave, Phoenix, AZ, 850350.82Street suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 199 of 290PreviousNext