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-62480TPAKaren T Fisher1987-06-18——3938 Camelback Rd, Austin, TX, 787300.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55460TPABrandon Munoz1954-08-13——7696 Highland Ave, Tempe, AZ, 852650.76Name re-casedDate of birth reformattedCity re-casedGender normalised+2 more
TPA-61968TPAJustin Cox1948-02-24——614 Ridge Rd, Atlanta, GA, 303830.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57558TPATimothy Wong1965-08-08—68341097063169 Camelback Rd, Fresno, CA, 937930.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56732TPASteven K Welch1999-11-20UHC-45711-80—259 Broadway, Los Angeles, CA, 900000.76Name re-casedDate of birth reformattedSSN last four extractedCity re-cased+2 more
TPA-61034TPAMei Bailey1966-11-09—51655658881353 Desert Sky Blvd, Tampa, FL, 336320.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53380TPAMark Bennett1955-07-17——1506 Indian School Rd, Minneapolis, MN, 554730.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50254TPAMadison Broooks1953-05-18UHC-02160-38—4742 Willow Ct, Glendale, AZ, 853620.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56820TPASue Romero1944-11-16—4542146901357 Spring St, Los Angeles, CA, 900710.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57262TPANicholas Miller1959-05-12—92229901495983 Spring St, Tampa, FL, 336970.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50627TPAEmily Rojas1979-04-03—59930524389357 Lake View Rd, Tampa, FL, 336630.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55236TPAAhmed D Hicks1956-08-28UHC-09142-0664053430508970 Union St, Jacksonville, FL, 322820.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50299TPALinda Oliver1945-06-19——8742 Baseline Rd, Tampa, FL, 336090.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52031TPASofia Lane1964-08-03—25868653685091 Sage Ct, Scottsdale, AZ, 852830.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-62082TPAMaria Bryant1966-11-22——756 Cedar Ln, Scottsdale, AZ, 852410.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62125TPARalph Hoffman1973-07-16——1707 Pine Dr, Seattle, WA, 981420.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62016TPACarol Murray1967-04-06—875568366291 Spring St, Eden Prairie, MN, 553270.76Street suffix standardisedAddress re-casedCity re-casedPlan code upper-cased+2 more
TPA-62507TPAAliice Collins1986-05-23UHC-40643-26—2282 Jefferson Ave, San Antonio, TX, 782190.76Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53544TPARaymond Rivera1998-11-02UHC-09573-4146993800789199 Sage Ct, Seattle, WA, 981200.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58711TPABilly B Garcia1954-01-11—22429303884474 Highland Ave, San Antonio, TX, 782340.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62971TPAFrank Carroll1958-04-13——546 Forest Ave, San Diego, CA, 921080.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57386TPACarol Hansen2000-06-19——4776 Bayshore Dr, Jacksonville, FL, 322820.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58116TPAHenry Wells1938-11-01——539 Lincoln Way, Plano, TX, 750920.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-53653TPAKatherine Black1972-06-08—54845142225352 Mesa Dr, Houston, TX, 770790.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57394TPASarah Chapman1961-08-23—5957811650263 Ridge Rd, Austin, TX, 787790.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-57393TPASarah Chapman1961-08-23—5957811650263 Ridge Rd, Austin, TX, 787790.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-60392TPASteven Hunnt1959-08-22—34269144132211 Willow Ct, Charlotte, NC, 282080.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59750TPAPat Mason1954-04-24——6084 Baseline Rd, Mesa, AZ, 852210.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63739TPAElijah Owens1953-05-21—45757617188030 Cedar Ln, Mesa, AZ, 852780.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53851TPABradley Pierce1994-09-12——2723 Desert Sky Blvd, Gilbert, AZ, 852660.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61798TPACharles Robinson1973-01-24—45553140873748 Ocean Ave, Tempe, AZ, 852770.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59616TPAMelissa E Kennedy1998-11-03—46434050807833 Park Pl, Fresno, CA, 937850.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63069TPARussell Pierce2001-08-21—71578250075135 Oak St, Charlotte, NC, 282820.76Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
TPA-51333TPAThomas Harpr1963-08-11—84193015041758 Elm St, Jacksonville, FL, 322120.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53182TPAMarilyn Hunt1971-06-21UHC-38710-68—8583 Bayshore Dr, Atlanta, GA, 303700.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62645TPAKathleen Carr1968-08-02——9618 Desert Sky Blvd, Glendale, AZ, 853810.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63241TPADnny Russell1955-08-06——6057 Apache Blvd, Sacramento, CA, 958420.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60528TPAMatthew Ryan1949-09-01——5530 Forest Ave, Las Vegas, NV, 891580.76Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
TPA-52719TPAMichelle Nelson1947-08-08UHC-68864-2748948340732704 Lincoln Way, Nashville, TN, 372860.76Name re-casedPhone reformattedCity re-casedState name converted to code+2 more
TPA-59183TPASarah Morris1994-05-08—44965002734576 Harbor Blvd, Mesa, AZ, 852640.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61499TPACheryl Reed1984-06-12—6153693348—0.76Name re-casedPhone reformattedEmail lower-casedGender normalised+2 more
TPA-56390TPASandra Guzman1941-03-22UHC-31025-0530994035961098 Central Ave, Chandler, AZ, 852410.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57600TPAFatima Reyes1980-05-02——3893 Meadow Ln, Charlotte, NC, 282040.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60334TPARalph Bailey1968-01-10——9827 Elm St # 317, Houston, TX, 770970.76Name re-casedDate of birth reformattedUnit split from streetEmail lower-cased+2 more
TPA-50037TPAJoshhua Burke1994-09-03—32976273456405 Hillcrest Rd, Denver, CO, 802850.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61709TPAAigail Le1969-03-21—70284247621183 Mesa Dr, Denver, CO, 802940.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62662TPASophia O Burton2008-08-13——7187 Oak St, Scottsdale, AZ, 852440.76Name re-casedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
TPA-56568TPAJeremy Diaz2003-04-27—48277774425050 Maple Ave, San Antonio, TX, 782860.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58989TPAAaron Andrews1995-07-06—53226091004074 Central Ave, Charlotte, NC, 282690.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50708TPAArthur Barnes1939-09-18UHC-14329-2769191993714548 Apache Blvd, Tucson, AZ, 857350.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
14,474 rows, page 120 of 290PreviousNext