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-59781TPALuis Tucker1953-09-13UHC-25918-17—4409 Hillcrest Rd, Atlanta, GA, 303070.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57509TPAEdward Sandoval1982-04-22——6632 Broadway, Minneapolis, MN, 554640.82Address re-casedState name converted to codePlaceholder values cleared
TPA-52778TPAArjun Sanders1916-05-25———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-56333TPAKayla Knight1945-02-22——3353 Highland Ave, Mesa, AZ, 852460.82Name re-casedGender normalisedPlaceholder values cleared
TPA-64455TPADeboarh Rose1955-02-05UHC-30731-01—9124 Baseline Rd, San Diego, CA, 921360.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60948TPAChristopher Contreras1951-12-19———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-57371TPAJesse Shaw1948-02-21——3852 Palm Dr, Tampa, FL, 336760.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-53822TPABilly Parker1973-06-07——1222 Baseline Rd, Chandler, AZ, 852800.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-55322TPAGrace Sandoval1986-09-25——9578 Camelback Rd, Columbus, OH, 432450.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51955TPAMaria Fields2000-02-10—45638138069137 Ocean Ave, Sacramento, CA, 958380.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50711TPAWalsh Jerry———6984 Union St, Tampa, FL, 336210.82Date of birth missingWhitespace trimmedPlaceholder values cleared
TPA-57556TPACynthia Carpenter1962-10-22UHC-16958-67—3013 River Rd, Los Angeles, CA, 900600.82Name re-casedGender normalisedPlaceholder values cleared
TPA-64363TPASandra Scott1974-11-01UHC-00116-94—3389 Harbor Blvd, Las Vegas, NV, 891580.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-63741TPAKevin Austin1968-05-06———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-56408TPAMichael Young1954-12-19—60034479742952 Palm Dr, Mesa, AZ, 852360.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-62628TPAMariana K Hanry————0.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-54606TPASam Martinez1964-04-01——6530 Cedar Ln, Glendale, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-64420TPAAmy Graham2004-10-25———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56857TPACharles Matthews1952-05-12——8323 Market St, Los Angeles, CA, 900800.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-54226TPALogan Lewis1969-06-02UHC-66714-9657579267985160 Church St, Dallas, TX, 752050.82Phone reformattedGender normalisedWhitespace trimmed
TPA-59413TPATyler Hudson1972-02-12———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-50257TPAJanice Kelley1960-05-25——5743 Pine Dr, Los Angeles, CA, 900360.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-64023TPAMarcus Coleman1994-10-28—3907759461304 Pine Dr, Plano, TX, 750450.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-57670TPAMegan Hoffman1961-11-17——7890 Maple Ave, Denver, CO, 802290.82Name re-casedGender normalisedPlaceholder values cleared
TPA-57029TPAJudith Mills1943-05-28——7674 Pine Dr, Denver, CO, 802050.82City re-casedGender normalisedPlaceholder values cleared
TPA-58014TPAMariaJunk1943-09-01———0.82Whitespace trimmedPlaceholder values clearedNo usable name (quarantined)
TPA-59284TPAArtthur Chavez——4288386557—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-54813TPAHaannah Sandoval2000-09-08——9114 Grand Ave, Tucson, AZ, 857390.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52178TPAChristina Kennedy1985-08-03—21283471881803 Central Ave, Tucson, AZ, 857060.82Phone reformattedState name converted to codePlaceholder values cleared
TPA-64203TPAKelly Gutierrez1990-10-16——6693 Maple Ave, Las Vegas, NV, 891230.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-50062TPAJen H Cole1962-10-12———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-50967TPAOlivia Hart1976-10-26—86383728539622 Highland Ave, Houston, TX, 770170.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55610TPADebra Fields1973-06-12——1358 Pine Dr, Phoenix, AZ, 850930.82City re-casedGender normalisedPlaceholder values cleared
TPA-60920TPADaniel Elliott1941-12-11——4953 Washington St, Eden Prairie, MN, 553700.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-50716TPAJudy Schultz1971-11-05——3200 Ridge Rd, Minneapolis, MN, 554580.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50266TPADaniel U Cox1941-11-23——7426 River Rd, Dallas, TX, 752150.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50391TPAAlbert Henderson2008-10-03—7557969806—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-60046TPARuth Aguilar1995-07-04—63299858887008 Cedar Ln, Mesa, AZ, 852070.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54192TPAEdward Matthews1984-03-21——3053 Baseline Rd, Orlando, FL, 328390.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58796TPARalph Jacobs1982-04-19——3178 Lincoln Way, Jacksonville, FL, 322710.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-56726TPABrittny Kelley1943-09-13———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-54692TPAAnna Oliver1950-05-12——4879 Main St, Los Angeles, CA, 900380.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-57496TPARuth Ross1973-06-03——4968 Lincoln Way, Chandler, AZ, 852850.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55972TPAKyle Dunn1951-12-01—7402838678—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-57578TPAAmber Harvey1998-10-18UHC-45573-3672662566626154 Main St, Dallas, TX0.82Date of birth reformattedMember ID reformattedZIP missing
TPA-53764TPAKenneth Pena2007-04-09UHC-19981-86—8856 Main St, Mesa, AZ0.82City re-casedZIP missingPlaceholder values cleared
TPA-53011TPAAdam Adams1969-07-05——87 Ridge Rd, Las Vegas, NV, 891910.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57813TPADenise Watkins1947-11-14——7757 Apache Blvd, Fresno, CA, 937580.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51506TPAFreeman W Joyce1965-06-18—9458006271—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-55686TPAMariana Sullivan2006-01-04——1102 Central Ave, Glendale, AZ, 853650.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
14,474 rows, page 211 of 290PreviousNext