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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-61484TPAMark Padilla1968-04-28——7838 Harbor Blvd, Fresno, CA, 937480.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57351TPALuis Delgado1999-05-08—5032223372—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-57854TPAJustin Gordon1958-09-10——8913 Mountain View Dr, Phoenix, AZ, 850690.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-55581TPAMaria Schmidt2002-05-17——4327 River Rd, Los Angeles, CA, 900700.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62581TPAJames J Jack1957-03-03——1297 Maple Ave, Tampa, FL, 336620.80Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-53564TPAJudith Peters1972-01-24——1591 Canyon Rd, Dallas, TX, 752190.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60228TPAPhilip R Robinson1977-01-04——9046 Valley View Dr, Dallas, TX, 752490.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
TPA-53588TPAPhilip Black1955-02-06——1873 Forest Ave, Houston, TX, 770150.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63595TPASarah Simpson1949-03-19——7775 Valley View Dr, Austin, TX0.80Date of birth reformattedCity re-casedZIP missingPlaceholder values cleared
TPA-62941TPALucia Ellis1972-09-15——1316 Sage Ct, Chandler, AZ, 852520.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61878TPAAlex Estrada2004-12-02——2506 Indian School Rd, Houston, TX, 770360.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56138TPAMartha Boyd1982-10-10——1811 Spring St, Las Vegas, NV, 891080.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62419TPAStephen Padilla1989-03-27——212 Church St, Jacksonville, FL, 322360.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60158TPANatthan Spencer1960-01-09——3988 Sage Ct, San Antonio, TX, 782150.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61732TPAGrace Ray1949-08-27—81398788018858 Baseline Rd, Tampa, FL, 336860.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60113TPAHannah S Bailey1947-05-14—70084091881908 Forest Ave, Houston, TX, 770760.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54804TPABryan Reynolds1958-08-23——1616 Desert Sky Blvd, Glendale, AZ, 853760.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54157TPADonald Valdez1994-07-24—7849260706—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-63516TPATricia Dunn1939-09-19—49299152959685 Camelback Rd Apt 30, Miami, FL, 331690.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-62074TPANicholas Kim1960-03-04—62324707893831 Grand Ave, Miami, FL, 331190.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61628TPAJmaes Williams2008-09-26——7942 Central Ave, Austin, TX, 787900.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-54453TPAAlex Carpenter1948-07-15UHC-30993-74—1607 Oak St, Orlando, FL, 328110.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51452TPAAna Santos1940-10-17UHC-93279-73—7064 Indian School Rd # 292, Tucson, AZ, 857790.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-51649TPAMateo Wallace1968-04-26——5689 Sage Ct, Minneapolis, MN, 554980.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51050TPABryan Fernandez1985-05-08—37161411271556 Canyon Rd, Minneapolis, MN, 554320.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
TPA-58111TPABrian Ford1997-05-10—8665321931—0.80Phone reformattedSSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-55110TPAWei Crawford1994-12-28—6694884393744 Grand Ave, Minneapolis, MN, 554280.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58723TPAMargareet Gutierrez1990-06-05UHC-61468-65—6810 Ridge Rd, Fresno, CA, 937920.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50110TPANoah Alvarez1953-03-24——7184 Sunset Blvd, Fresno, CA, 937150.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50335TPAAna Ward———5148 Broadway, Austin, TX, 787240.80Date of birth missingAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55677TPASusan Watson1941-02-08——2514 Broadway, Atlanta, GA, 303350.80Address re-casedCity re-casedGender normalisedWhitespace trimmed
TPA-51500TPAJoan Mitchell1977-11-24——315 Hillcrest Rd, Los Angeles, CA, 900880.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58903TPASusan Ross1983-01-02——5344 Mountain View Dr, Houston, TX, 770960.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51067TPAJuliaJunk1999-09-26——9413 Jefferson Ave, Denver, CO, 802810.80Name re-casedDate of birth reformattedPlaceholder values clearedNo usable name (quarantined)
TPA-63110TPAChristine Moore1954-06-10——8018 Maple Ave, Scottsdale, AZ, 852670.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-51833TPADaniel Matthews1943-11-06——6458 Washington St Apt 22, Miami, FL, 331900.80Unit split from streetState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-56052TPACatherine B Estrada1985-11-03UHC-58863-99—2694 Canyon Rd, Los Angeles, CA, 900630.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63137TPAKathryn Burton1973-11-08UHC-99290-3593539969767243 Ocean Ave, Houston, TX, 770460.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-60839TPACynthia Bowman1956-03-14—66126014455228 Market St, San Diego, CA, 921230.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58838TPAEvelyn Delgado1961-10-05UHC-46372-433543686826495 Church St, Plano, TX, 750740.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-56889TPAJudth Henry1942-04-05——2027 Central Ave, Charlotte, NC, 282710.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-62692TPAGregory Pena1944-04-24—5237698601—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60576TPAKyle Cruz1947-05-02——2342 Church St, Jacksonville, FL, 322260.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54019TPADouglas Harris1941-12-09—90699378455994 Church St, Fresno, CA, 937810.80Phone reformattedZIP+4 trimmedEmail lower-casedPlaceholder values cleared
TPA-63820TPABilly Reynolds1969-01-20——6808 Mesa Dr, Scottsdale, AZ, 852130.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62019TPAEdawrd J Hayes1962-01-02——4374 Palm Dr, Jacksonville, FL, 322980.80Two-digit birth yearCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-54103TPAAisha Price1939-08-27——2027 Ocean Ave, Miami, FL, 331240.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53496TPAEugene Bailey1986-04-04—71963591509334 Bayshore Dr, Austin, TX, 787650.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54521TPAPatricia Hayes1993-05-27——6331 Hillcrest Rd, Sacramento, CA, 958130.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56634TPAAlbert Hall1981-10-24——8750 Central Ave, Tampa, FL, 336540.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 188 of 290PreviousNext