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-52859TPACynthia Pirce1941-10-01——2275 Mountain View Dr, Los Angeles, CA, 900630.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51353TPAMarcus Fields1996-03-03—61330795378621 Oak St, Nashville, TN, 372410.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56184TPAMark Garza1946-07-07—52687559307320 Washington St, Charlotte, NC, 282010.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50924TPACatherine Silva1991-10-18UHC-28183-5525834958421651 Oak St, Austin, TX, 787560.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51587TPAOlivia Cox1964-01-06UHC-84543-81—4346 Washington St, Jacksonville, FL, 322010.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-64039TPAVincent Fernandez1943-04-02——6169 Elm St, Denver, CO, 802110.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55622TPAKeith Burns1988-09-16—33883097759209 Lake View Rd, Phoenix, AZ, 850100.76Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more
TPA-58487TPAKevin Roberts1962-03-24——4395 Maple Ave, Las Vegas, NV, 891560.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57142TPALuis Gonzalez1939-04-05——5883 Harbor Blvd, Mesa, AZ, 852450.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60588TPALaura Jordan1961-07-06—98248774377326 Elm St, Phoenix, AZ, 850200.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50356TPAWei Patterson1949-07-04UHC-24216-61—4830 Elm St, San Antonio, TX, 782350.76Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56321TPAAngela Woods1977-08-26——3702 Central Ave, Los Angeles, CA, 900470.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57166TPAMark Larson1965-08-15—39629692702160 Hillcrest Rd, Denver, CO, 802450.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51540TPACharlotte Lewis1962-09-15UHC-84126-9630751570871093 Church St, Denver, CO, 802910.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57990TPAEmily Chen1949-03-07UHC-23290-4966238597418476 Palm Dr, Glendale, AZ, 853810.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
TPA-50993TPAAnn Alexander1989-06-18—64351552758659 Ocean Ave, Columbus, OH, 432670.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-52194TPAAlan Wagner1970-03-01—50551284456466 Broadway, Los Angeles, CA, 900630.76Name re-casedPhone reformattedAddress re-casedGender normalised+2 more
TPA-51634TPAJonathan Valdez1938-07-06UHC-09612-4044581088771279 Bayshore Dr, Nashville, TN, 372860.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50025TPAValentina Warren1959-11-17UHC-64240-8173753669019049 Maple Ave, Dallas, TX, 752250.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-64236TPASara Warren1960-10-23—73766975231795 Desert Sky Blvd, Dallas, TX, 752830.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52702TPAStephen Maldonado1941-06-16——5247 Hillcrest Rd, Sacramento, CA, 958390.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54602TPADanyel Hawkinns2006-06-15——6882 Harbor Blvd, Gilbert, AZ, 852210.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54603TPADanyel Hawkinns2006-06-15——6882 Harbor Blvd, Gilbert, AZ, 852210.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59672TPAMason Sanchez1944-03-26—86668267793167 Market St, Las Vegas, NV, 891740.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54837TPABarbara R Espinosa2001-10-25——4396 Valley View Dr, Tempe, AZ, 852240.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63032TPANoah Kim1957-04-28——4631 River Rd, Charlotte, NC, 282580.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63921TPABeverly Sullivan1990-01-27—75088813126770 Ocean Ave, Sacramento, CA, 958030.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57450TPAElijah Myers1989-12-09—55062433733062 Highland Ave, Dallas, TX, 752330.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-53942TPABrittany Hawkins1982-05-12——2844 Meadow Ln, Los Angeles, CA, 900980.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60600TPAPetar Chavez1986-01-16UHC-11335-2033358786547706 Lake View Rd, Tucson, AZ, 857610.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-50438TPAPatricia Le1963-01-08—74360805939221 Sunset Blvd, Atlanta, GA, 303670.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-63684TPASimmons Jonathan1988-05-11—79151502084316 Mesa Dr, Nashville, TN, 372520.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-58805TPAEmma Gardner1951-08-19—74995490256009 Maple Ave, Miami, FL, 331920.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-53813TPAPaul Holmes1953-01-28——5401 Forest Ave, Scottsdale, AZ0.76Date of birth reformattedCity re-casedZIP missingEmail lower-cased+2 more
TPA-62491TPABobby Gardner1994-01-28——5754 Apache Blvd, Minneapolis, MN, 554910.76Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-51918TPABradly Marquez2003-05-02—70130528687375 Lake View Rd, Chandler, AZ, 852540.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58915TPAMarcus S Wong1988-04-10—80345933813182 Union St, Gilbert, AZ, 852110.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51911TPADanielle Long1998-01-10——105 Ocean Ave, Los Angeles, CA, 900770.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57342TPADanielle Hill1995-12-09——1649 Desert Sky Blvd, Orlando, FL, 328120.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58275TPAKeith Vaquez1956-11-01—42650388841466 Broadway, Plano, TX0.76Phone reformattedAddress re-casedCity re-casedZIP missing+2 more
TPA-53741TPAVincent J Stevens1975-10-05——1528 Baseline Rd, Sacramento, CA, 958450.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52377TPALucia King1947-06-23——1729 Cedar Ln, Seattle, WA, 981740.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59914TPARyan Harrison1958-11-16—57036126682325 Washington St, Atlanta, GA, 303530.76Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
TPA-54424TPAGary Rodriguez1952-11-10—66674426021707 Mesa Dr, Chandler, AZ, 852880.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55821TPAAlbert Mendez1972-10-21—39386633021232 Desert Sky Blvd, Houston, TX, 770040.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56778TPAJuan Franklin1963-03-08——5848 Maple Ave, Sacramento, CA, 958700.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50012TPASara J Contreras1973-04-10UHC-46492-5232842895844401 River Rd, Seattle, WA, 981590.76Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-62991TPAKevin Jimenez1992-11-03——1553 Desert Sky Blvd, Orlando, FL, 328570.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54480TPAAhed X Diaz1961-02-13——608 Main St, Fresno, CA, 937130.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58516TPAKatherine M Lucas1966-07-23UHC-29115-96—6724 Market St, Austin, TX, 787060.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 117 of 290PreviousNext