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-63989TPAJason S Bailey1938-02-16UHC-32640-85—4995 Harbor Blvd, Minneapolis, MN, 554630.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63262TPAVirginia Santiago1992-03-13—2234022365—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51285TPAYuki White————0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-56580TPAStephen Nichols1945-05-04——3615 Sunset Blvd, Los Angeles, CA, 900380.80Name re-casedState code upper-casedGender normalisedPlaceholder values cleared
TPA-63878TPAVictoria Clark1992-04-16——5078 Forest Ave, Mesa, AZ, 852970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58719TPARoger Ferguson1960-04-12UHC-15165-36—4199 Church St, Glendale, AZ, 853490.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-50755TPACamila James1990-08-22—91261685835779 Lincoln Way, Charlotte, NC, 282610.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-50754TPACamila James1990-08-22—91261685835779 Lincoln Way, Charlotte, NC, 282610.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-52456TPARaymond Burns1943-08-03——2658 Hillcrest Rd, Austin, TX, 787000.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60963TPAJesse N Dunn1939-01-26—40983228137126 Sage Ct, Phoenix, AZ, 850290.80Name re-casedState code upper-casedZIP+4 trimmedPlaceholder values cleared
TPA-56885TPASusan Z Martin2006-12-27——5676 Central Ave, Seattle, WA, 981030.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59280TPAScott Hansen1943-04-11—3289783314212 Meadow Ln, Minneapolis, MN0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
TPA-57970TPASofia Richards1987-11-21UHC-23021-94—2580 Desert Sky Blvd, Plano, TX, 750200.80Name split from “Last, First”Date of birth reformattedMember ID reformattedCity re-cased
TPA-56741TPANanyc Boyd1967-04-18—42953820347848 Grand Ave, Glendale, AZ, 853010.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-62153TPAEmma X Diaz1978-08-04—20247597673374 Spring St, Fresno, CA, 937730.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52857TPAMateo Vazquez1964-10-05UHC-94454-99—5141 Church St # 719, Orlando, FL, 328000.80Date of birth reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-56237TPAAaron Lewis1947-03-24——2428 Lake View Rd, Denver, CO, 802750.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53546TPAStephanie Ryan1999-09-22—30375254324072 Market St, Miami, FL, 331850.80Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased
TPA-57196TPALogan Wang2000-11-20——7493 Ridge Rd, Scottsdale, AZ, 852450.80Date of birth reformattedZIP+4 trimmedPlan code upper-casedPlaceholder values cleared
TPA-56470TPAMariana Z Luna1951-12-20———0.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
TPA-55167TPAAmy Wong1962-10-13——336 Market St, Chandler, AZ, 852540.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-62948TPAVincent Ramirez1944-02-21———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61856TPAVincent King1948-08-14——5963 Valley View Dr, Tucson, AZ, 857120.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52809TPABrian Hawkins1978-08-10—65736120301350 Sage Ct, Tucson, AZ, 857830.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-64350TPADonald Wallace1966-05-22——3382 Main St, Austin, TX, 787630.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53195TPADebra Jorden1984-10-12—46989386831275 Lake View Rd, Jacksonville, FL, 322410.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-63179TPAJeffrey Cox1998-05-27——2169 Desert Sky Blvd, Sacramento, CA, 958420.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58500TPAGabriel Z Espinoza1939-11-25UHC-49887-4023977412396048 Lake View Rd, Glendale, AZ, 853300.80Date of birth reformattedPhone reformattedCity re-casedState name converted to code
TPA-57219TPAVirginia J Morgan1998-09-03——337 Elm St, Mesa, AZ, 852520.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54045TPAKevin Kennedy1964-11-08—2117832212—0.80Phone reformattedEmail lower-casedGender normalisedPlaceholder values cleared
TPA-54133TPAGeorge Garrett1959-09-12UHC-32639-89—107 Ocean Ave, Miami, FL, 331660.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-51864TPATeresa King1992-12-11—57268558786187 Hillcrest Rd Apt 40, Glendale, AZ, 853740.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-55005TPAPamela Burns1944-05-11——6099 Mesa Dr, Miami, FL, 331400.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57956TPALinda Lucas—UHC-20791-8340027111366009 Bayshore Dr, Eden Prairie, MN, 553260.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60019TPAJonathan Johnston1977-03-04——3559 Meadow Ln, Orlando, FL, 328330.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53458TPAKevin Chapman1968-09-13——3206 Meadow Ln, Scottsdale, AZ, 852050.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61393TPARobert Guerrero1947-06-24——8843 Ocean Ave, Seattle, WA, 981840.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57292TPAEvelyn Baker1953-06-08—51829718352621 Union St, Columbus, OH, 432760.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54477TPATeresa T Yang1939-07-03——1298 River Rd, Tempe, AZ, 852450.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50216TPALawrence Lawrence1958-03-28UHC-77463-23—8284 Palm Dr, Tempe, AZ, 852860.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56590TPABrenda Reed1974-02-24——3928 Hillcrest Rd, Eden Prairie, MN, 553200.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56589TPABrenda Reed1974-02-24——3928 Hillcrest Rd, Eden Prairie, MN, 553200.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61000TPAAdam Rojas1992-07-15——9838 Spring St, Tempe, AZ, 852970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60541TPARaymond Woods1996-04-12——2178 Washington St, Minneapolis, MN, 554970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51856TPAMelissa Thomppson1976-02-10——7633 Washington St, Scottsdale, AZ, 852050.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53633TPAAlexander Gutierrez1969-08-03—65626872803809 Oak St, Sacramento, CA, 958110.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60136TPAAmanda Santos1939-03-09—2179055139—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60894TPAKathryn Medina1989-04-08——9619 Camelback Rd, Miami, FL, 331940.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50362TPASamuel Price1987-11-25——3203 Central Ave, Atlanta, GA, 303650.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53238TPAArthur Gilbert1963-09-27—4344045344—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
14,474 rows, page 183 of 290PreviousNext