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-54163TPAJessica Bennett1991-05-02——5439 Camelback Rd, Denver, CO, 802060.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60439TPAWillie Griffin1973-05-18—5478550900458 Sage Ct, Phoenix, AZ, 850560.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-58015TPAMaria Webb1943-09-01——8356 Maple Ave, Miami, FL, 331200.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
TPA-51251TPADylan Ferguson1993-06-26UHC-34747-74—9126 Maple Ave, Tempe, AZ, 852000.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62370TPAEmily Sullivan1940-08-05—44576325975479 Bayshore Dr, Seattle, WA, 981810.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63994TPALucas Madison2007-12-23——9850 Baseline Rd, Austin, TX, 787960.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-53070TPAChristian Walker1970-03-18—21961021582675 Pine Dr, Tampa, FL, 336880.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62591TPAJose Powell1975-07-26——8444 Highland Ave, Chandler, AZ, 852860.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56087TPATheresa A Cook1987-01-13——8803 Mountain View Dr, Denver, CO0.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-54897TPAJose Morrison1962-08-14——3629 Park Pl, Tucson, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-61548TPARussell M Schultz——53928151531372 Forest Ave, Plano, TX0.64Date of birth missingPhone reformattedZIP missingEmail lower-cased+2 more
TPA-59582TPATim Sullivan1992-05-26UHC-76596-8439034776965317 Washington St, Charlotte, NC, 282140.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51895TPAKathleen Cruz1967-10-10——9570 Church St, San Diego, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-63081TPAMary Taylor2000-02-17——7667 Bayshore Dr, Minneapolis, MN, 554000.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-52469TPAGregory Larson1963-11-18—95737783732970 Sunset Blvd, Gilbert, AZ, 852930.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-62371TPALisa Hoffman1942-01-28UHC-60324-02—1890 Apache Blvd, Eden Prairie, MN, 553420.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52752TPAGloria Y Carroll1962-06-15—3744425197731 Washington St, Denver, CO, 802270.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52035TPAOlivia Padilla1998-05-26—64440141559203 River Rd, San Diego, CA, 921390.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53062TPASarah Warren1958-09-27——9367 Church St, Seattle, WA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-54322TPAShirley Jimenez2002-02-10UHC-16328-4642721793302890 Ocean Ave, Minneapolis, MN, 554730.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61932TPAThomas Phillips1991-03-10UHC-55322-89—175 Apache Blvd, Denver, CO, 802670.64Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55061TPAJoe Adams2008-05-04—56663613272370 Canyon Rd, Atlanta, GA0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55113TPAJulie Chen1981-10-26—69663819286058 Church St, Dallas, TX, 752590.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-58406TPAHenry Simpson1985-11-04—63263157413244 Park Pl, Fresno, CA, 937720.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54684TPAGrace H Ross1985-12-22—21527477065740 Sunset Blvd, Eden Prairie, MN, 553080.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-62442TPAJeffrey Simpson1943-04-16—60058838984147 Indian School Rd, Miami, FL, 331010.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58233TPAGary Taylor1950-05-21—96762007286786 Main St, Phoenix, AZ, 850160.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-59002TPAShirley B Washington2008-04-16UHC-05301-16—5417 Valley View Dr, San Diego, CA, 921630.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57505TPAJean Andrews1940-07-07——4756 Jefferson Ave, Miami, FL, 331510.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-63139TPALauren Franklin1954-12-22—7653473374506 Elm St, San Antonio, TX, 782120.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-54864TPASandra N Snyder1952-02-28UHC-06644-60—3716 Washington St, Las Vegas, NV, 891400.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-54282TPALauren Campbell1955-08-07——6268 Main St, Tucson, AZ, 857180.64Date of birth reformattedCity re-casedZIP+4 trimmedGender normalised+2 more
TPA-60230TPAMichelle Mendez1967-12-20——1553 Hillcrest Rd, Sacramento, CA, 958200.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-53507TPAEmily Peters1998-01-04——8187 Market St Apt 17, Tucson, AZ, 857670.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-64077TPAMelissa Medina1972-12-23——670 Sage Ct, Glendale, AZ, 853590.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-54719TPAJacqueline Rice1965-03-03—36483476408134 Lake View Rd, Atlanta, GA, 303490.64Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+2 more
TPA-59055TPAMarcus P Sims2001-04-04—93672114159274 Canyon Rd, Miami, FL, 331800.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61287TPAPaul O Richards1967-04-11—41930472675432 Pine Dr, Las Vegas, NV, 891410.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55886TPANatalie Reid1961-02-05——9381 Hillcrest Rd Apt 38, Chandler, AZ, 852090.64Name split from “Last, First”Date of birth reformattedUnit split from streetCity re-cased+2 more
TPA-50432TPATheresa Santiago1976-03-28——9056 Bayshore Dr, Phoenix, AZ, 850290.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-60844TPACarol B Stone1953-09-17UHC-11495-7960428755451957 Lake View Rd, Los Angeles, CA, 900110.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-59417TPAStephen Jimenez2006-09-27—45251009583249 Bayshore Dr # 503, Denver, CO, 802540.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-63566TPAFatima Schmidt———6559 Highland Ave, Los Angeles, CA, 900680.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-57500TPACharles O Porter2004-04-09—61763556199313 Forest Ave, Sacramento, CA, 958290.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-58695TPAPeter Weber2001-08-01—53954804587181 Canyon Rd, Houston, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-51767TPAJsoeph Pena———273 Mountain View Dr, Austin, TX, 787710.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-56798TPALisa Wang1962-01-10UHC-01264-90—5726 Indian School Rd, Scottsdale, AZ, 852820.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59327TPAWillie Ellis1995-03-19—58668883638597 Cedar Ln, San Diego, CA, 921860.64Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+2 more
TPA-59361TPAJames Gardner1963-10-04——2078 Sunset Blvd, Nashville, TN0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
TPA-57629TPAJudith Aguilaar1973-09-08—21923227927008 Hillcrest Rd, Atlanta, GA, 303030.64Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more
14,474 rows, page 54 of 290PreviousNext