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-63706TPAMadison Dunn2008-10-06—87882284831892 Market St, Seattle, WA, 981840.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60435TPADeborah Hendesron2008-03-10——2283 Grand Ave, Scottsdale, AZ, 852380.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55602TPAMateo Y Mitchell1983-09-13—2917080633—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-59495TPAFrank Crapenter1999-02-27—7222778346—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63750TPAJoe Vargas1973-02-28—77451754594634 Lake View Rd, Dallas, TX, 752140.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52218TPADorothy X Hicks1941-08-16———0.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51788TPAAlbert I Kim1989-09-03———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-63510TPAStephanie Burke1974-03-25——3226 River Rd, Tampa, FL, 336870.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62638TPASara Evans1998-10-06——2141 Union St, Charlotte, NC, 282420.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50759TPAJoe Rivera1952-07-18UHC-05846-87——0.80Name re-casedMember ID reformattedGender normalisedPlaceholder values cleared
TPA-57427TPAJean Collins1971-03-07—3415528863—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
TPA-58178TPACamila Howell1993-08-02—2122468677882 Harbor Blvd, Phoenix, AZ, 850360.80Two-digit birth yearPhone reformattedCity re-casedPlaceholder values cleared
TPA-59295TPAArthur Parker1971-03-13—9207608700—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53617TPAJudith Little1976-12-20—42536715363029 Elm St, Mesa, AZ, 852030.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-56060TPAWillie Robinson1967-08-05——5548 Valley View Dr, Jacksonville, FL, 322950.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50705TPASandra Boyd1973-03-18——1044 Spring St, Tucson, AZ, 857370.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-61281TPAMarri Stone1995-09-12UHC-60339-879434534428459 Main St, Phoenix, AZ, 850280.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56999TPAJoseph Coe1986-04-16——427 Pine Dr, San Antonio, TX, 782380.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-58206TPAVictoria Q Fowler1988-03-09——6435 Washington St, Orlando, FL, 328470.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-60784TPAKyle Dean1965-08-09——7843 Baseline Rd, Fresno, CA, 937660.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58102TPARebecca Fuller1939-08-19——3291 Valley View Dr, Las Vegas, NV, 891430.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-50207TPAAndrea Jordan1938-12-18——9521 Ocean Ave, Fresno, CA, 937550.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62432TPAJack Bishop1944-04-02——411 Washington St, San Antonio, TX, 782800.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59969TPADiego Richardson1943-08-13——9038 Cedar Ln, San Antonio, TX, 782140.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58615TPABrenda Valdez1942-10-14—2533758858570 River Rd, Nashville, TN, 372420.80Date of birth reformattedPhone reformattedState name converted to codePlaceholder values cleared
TPA-55216TPAJuan Freeman1958-02-23—28755875354017 Forest Ave, Orlando, FL, 328230.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56040TPAKayla Perkins——89536547519256 Sunset Blvd, Seattle, WA, 981680.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60980TPAIsabella L Harrt1975-03-17UHC-19333-94—4604 Jefferson Ave, Glendale, AZ, 853720.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59751TPAScott Spencer1986-04-25——8322 Apache Blvd, Jacksonville, FL, 322550.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51058TPAVincent Hernandez1970-11-27——4259 Canyon Rd, Chandler, AZ, 852170.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56348TPAAlice Morris1990-01-24——1934 Indian School Rd, Mesa, AZ, 852520.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57007TPABryan Evans2007-08-25——4502 Canyon Rd, Los Angeles, CA, 900940.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62350TPAChristine I Young1978-10-04——8138 Spring St, Tampa, FL, 336180.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56888TPAVincent Green1988-04-03——4739 Church St, Houston, TX, 770980.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52437TPAGary Vega2006-02-20UHC-86681-75—478 Park Pl, Seattle, WA, 981260.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54145TPABeverly Bailey1986-04-20——5723 Spring St, Gilbert, AZ, 852220.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55004TPAPeter Edwards1948-09-12—37743162106925 Pine Dr # 517, Mesa, AZ, 852570.80Phone reformattedUnit split from streetCity re-casedPlaceholder values cleared
TPA-53548TPAMary I Thompson1977-02-25——9404 Meadow Ln, Austin, TX, 787540.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60065TPAElijah Rodriguez1943-10-08—88893134535994 Union St, Charlotte, NC, 282800.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57014TPADorys Anderson1940-06-16—47646832275796 Broadway, Sacramento, CA, 958280.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-62895TPAPamela N Sullivan1944-05-24——6071 Harbor Blvd, Jacksonville, FL0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-52442TPAOlivia Mason2005-01-07——9078 Sunset Blvd, Tucson, AZ, 857700.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56436TPAMichelle Martin1959-02-08——7357 Maple Ave, Minneapolis, MN, 554260.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51958TPAMason Dunan1984-04-28——3258 Hillcrest Rd, Gilbert, AZ0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-53178TPAJon F Coleman1983-08-19UHC-64736-32—1446 Spring St, Denver, CO, 802480.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62115TPADavvid Henry1938-09-08—45847787677188 Broadway, San Diego, CA, 921090.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62847TPALauren Silav1946-07-01——7322 Ocean Ave, Phoenix, AZ, 850990.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58490TPAKenneth Bailey2002-01-05—5536167156203 Camelback Rd, Plano, TX, 750110.80Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased
TPA-53647TPAAlice B Owens1997-06-09——591 Camelback Rd, Seattle, WA, 981510.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-57754TPAMarc Alvarado1949-06-12UHC-99938-50—53 Union St, San Antonio, TX, 782720.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
14,474 rows, page 195 of 290PreviousNext