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-50397TPAJuile Webb1951-02-14——3557 Palm Dr, Eden Prairie, MN, 553310.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-51226TPAMariana Alvarado1988-05-19—370808344424 Lake View Rd, Austin, TX, 787950.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56530TPAPriya Edwards1999-07-14——2881 Bayshore Dr # 677, San Antonio, TX, 782800.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-50352TPAJennifer Hernandez1947-08-10UHC-59786-48—6284 Indian School Rd, Chandler, AZ0.64Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
TPA-56571TPAGloria Nguyen1948-12-13——242 Desert Sky Blvd # 869, Denver, CO, 802230.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57439TPARalph Vega1993-05-04——627 Ridge Rd, Phoenix, AZ, 850940.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50127TPALuis Sims1995-11-24——2483 Harbor Blvd, Chandler, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55527TPAGerald T Valdez1959-02-26——5482 Jefferson Ave Apt 13, Minneapolis, MN, 554030.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
TPA-59158TPADennis Hansen1940-05-06——9125 Jefferson Ave, Phoenix, AZ, 850580.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59656TPACarol Webb1993-12-23—45186037492396 Washington St, Chandler, AZ, 852350.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51665TPACheryl Q Contreras1986-08-24—67834042449492 River Rd, Houston, TX, 770960.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-60077TPABarbara Collins2004-05-17UHC-85662-20—647 Market St, Minneapolis, MN, 554680.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-61177TPAArthur Carter1953-09-20——7582 Washington St, Chandler, AZ, 852720.64Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more
TPA-54381TPADebra Rojas1942-07-15——8068 Meadow Ln, Tampa, FL0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
TPA-57428TPAJeffrey Mendoza—UHC-92808-1563747151969882 Washington St, Tucson, AZ, 857250.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58600TPAMark Smith1999-12-23——9291 Elm St # 521, Seattle, WA, 981080.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56135TPASamuel Richards1938-05-17UHC-77129-51—1323 Park Pl Apt 36, Seattle, WA, 981010.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-63077TPACharlotte Brown1943-09-16—80341783207125 Central Ave, Eden Prairie, MN, 553420.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63164TPABrenda Bennett1963-03-11——6951 Sunset Blvd Apt 31, San Diego, CA, 921210.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57961TPABruce Cole1952-03-11—33921781007356 Harbor Blvd, Los Angeles, CA, 900000.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-56417TPAMarilyn Martin1996-11-28——2436 Indian School Rd, Eden Prairie, MN, 553760.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-61350TPAElizabeth Soto2003-08-26——2261 Bayshore Dr, Atlanta, GA, 303030.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-59094TPARuth Hernandez1955-05-15—25970988221617 Lincoln Way, Miami, FL, 331390.64Date of birth reformattedPhone reformattedCity re-casedState name converted to code+2 more
TPA-51160TPAAnthony Mertin1982-10-23——2343 Oak St, Phoenix, AZ, 850450.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51161TPAAnthony Mertin1982-10-23——2343 Oak St, Phoenix, AZ, 850450.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50094TPASarah Sanders—UHC-10031-33—9257 Willow Ct, Phoenix, AZ, 850970.64Name re-casedDate of birth unreadableMember ID reformattedStreet suffix standardised+2 more
TPA-51519TPAJoshua Murphy1958-12-18——5303 Baseline Rd, Chandler, AZ, 852800.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63397TPANatalie Myers1963-07-27——3976 Forest Ave, Los Angeles, CA, 900300.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-50400TPARalph Kim1948-04-13—95535918426508 Church St # 602, Sacramento, CA, 958930.64Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
TPA-55984TPAJustin Gilbert1979-10-17UHC-98842-28—5876 Indian School Rd, Mesa, AZ, 852320.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61519TPAVincent Butler1958-03-24——966 Bayshore Dr, Miami, FL, 331770.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60817TPAAlexander Silva1984-08-10——5783 Pine Dr, Phoenix, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-52648TPACheryl Torres1995-02-26—89751293263902 Baseline Rd, Gilbert, AZ, 852230.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58391TPAHelen Guzman1987-05-19——7313 Maple Ave, Plano, TX, 750310.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58390TPAHelen Guzman1987-05-19——7313 Maple Ave, Plano, TX, 750310.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56879TPALucia W Russell2001-11-13UHC-89539-2365956491143497 Oak St, Tampa, FL, 336520.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50963TPASteve Ruiz1971-06-18——860 Bayshore Dr, Tucson, AZ, 857340.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57314TPABobby Rice1938-01-19—51034705948491 Desert Sky Blvd, Sacramento, CA, 958100.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-51242TPAPeter Brooks1965-09-18——2138 Union St # 748, Seattle, WA, 981640.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59920TPAGeorge Flores1959-01-16——8251 Pine Dr, Jacksonville, FL, 322800.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56858TPACheryl Jones———701 Forest Ave, Orlando, FL, 328430.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-54902TPACharles Maldonado1949-05-15UHC-76931-4238577328324005 Grand Ave, Minneapolis, MN, 554890.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52810TPAJudithJunk1940-07-01——7317 Sage Ct, Minneapolis, MN, 554270.64Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+2 more
TPA-52887TPAEvelyn Green2006-05-03——5420 Jefferson Ave Apt 22, Los Angeles, CA, 900360.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-55267TPAMartha N Gonzales2002-08-18—71948107764367 Church St, Scottsdale, AZ, 852540.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-56826TPAPriya Ray1962-05-28UHC-58523-45—7268 Cedar Ln, Gilbert, AZ, 852870.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-63900TPAHenry Jacobs1962-05-18——6411 Forest Ave # 557, Las Vegas, NV, 891880.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-58274TPAPaul White1995-03-22—91386848963950 Elm St, Seattle, WA, 981320.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56387TPAGeorge Little2001-03-14——9260 Cedar Ln, Orlando, FL, 328410.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55384TPAJoan Montgomery2006-06-07——2668 Park Pl, Glendale, AZ, 853270.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 64 of 290PreviousNext