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-64469TPAVirginia Guerrero1939-07-02——7836 Ocean Ave, Miami, FL, 331460.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-50661TPARonald Gonzales1951-05-19——2738 Central Ave, Jacksonville, FL0.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-56125TPANatalie Park2004-04-25——3479 Ocean Ave, Gilbert, AZ, 852400.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-53945TPAMike Carter1956-09-01—75427500983476 Bayshore Dr, Columbus, OH, 432350.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51842TPAJean Gonzales1989-11-19——6660 Lake View Rd, Sacramento, CA, 958530.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-52526TPAChristine Elliott1956-03-08——2209 Hillcrest Rd, Charlotte, NC0.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-54858TPAArthur Franklin1949-08-05——350 Lake View Rd Apt 13, Denver, CO, 802890.40Name split from “Last, First”Unit split from streetZIP+4 trimmedGender normalised+2 more
TPA-60898TPAGrace Owens1972-01-25——685 Apache Blvd # 542, Dallas, TX, 752110.40Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63709TPABruce K Turner1996-12-12——7712 Park Pl, San Diego, CA, 921680.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-53689TPAShron Johnston1938-02-26——1670 Meadow Ln, Tempe, AZ0.40Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56782TPALucia W Porter1944-02-23——8965 Canyon Rd, San Antonio, TX, 782340.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-56783TPALucia W Porter1944-02-23——8965 Canyon Rd, San Antonio, TX, 782340.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-50945TPARyan Cooepr1995-07-25——9896 Sunset Blvd, Tampa, FL, 336040.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-62508TPAIsabella Mjia1963-12-17——9832 Washington St, Phoenix, AZ, 850750.40Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-56838TPACheryl Nunez1974-03-17—80048729223118 Elm St # 727, Scottsdale, AZ, 852550.40Name split from “Last, First”Two-digit birth yearUnit split from streetCity re-cased+2 more
TPA-57664TPACharlotte Austin———4548 Spring St # 115, Jacksonville, FL, 322690.40Name split from “Last, First”Date of birth unreadableUnit split from streetCity re-cased+2 more
TPA-58379TPAArjun Banes2000-11-01——8922 Mountain View Dr, Scottsdale, AZ, 852180.40Name split from “Last, First”Two-digit birth yearPhone missing area codeStreet suffix standardised+2 more
TPA-52036TPAEric Bowman1954-03-13—84868864553834 Spring St, Denver, CO, 802510.40Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57546TPAStephen Martinez———6738 Indian School Rd, Tampa, FL, 336650.40Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-57694TPAJoseJunk1965-08-18——7293 Camelback Rd, Plano, TX, 750650.40Name re-casedState name converted to codeZIP+4 trimmedGender normalised+2 more
TPA-52346TPAArjun Nunez1967-01-13—58991435371279 Bayshore Dr, Nashville, TN, 372140.40Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63594TPATeresa Chen1943-11-11—58332527142986 Apache Blvd, Houston, TX, 770590.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-56766TPAKeith Williamson1976-03-27—30087778321299 Valley View Dr, Phoenix, AZ0.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-61151TPAJosh Ellis1998-09-02UHC-44602-44—1169 Grand Ave, Los Angeles, CA, 900700.40Two-digit birth yearPhone missing area codeSSN last four extractedStreet suffix standardised+2 more
TPA-55475TPAAlice L Henry1942-11-22——4514 Indian School Rd, Denver, CO, 802960.40Name split from “Last, First”Middle initial moved out of first nameTwo-digit birth yearStreet suffix standardised+2 more
TPA-61504TPASara Willis1952-11-05—31042399683782 Valley View Dr, Scottsdale, AZ, 852450.40Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+2 more
TPA-55902TPALinda Martinez1949-11-21——9175 Elm St Apt 28, Seattle, WA, 981720.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61970TPAArjun P Morrison——86651698422175 Camelback Rd Apt 32, Austin, TX, 787350.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-53658TPAShirley Hamilton1967-04-03——7867 Canyon Rd, Jacksonville, FL, 322070.40Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-52980TPAJacqueline Burke1994-12-08——904 Baseline Rd Apt 33, Tucson, AZ, 857020.42Name split from “Last, First”Unit split from streetZIP+4 trimmedGender normalised+1 more
TPA-54949TPADaniel Austin1967-05-16——7940 Mesa Dr Apt 37, Scottsdale, AZ0.42Name split from “Last, First”Unit split from streetState name converted to codeZIP missing+1 more
TPA-54953TPAJudy J Nichols1977-03-04——468 Spring St Apt 17, Phoenix, AZ, 850030.42Name split from “Last, First”Two-digit birth yearUnit split from streetGender normalised+1 more
TPA-53704TPAJason Davis2008-11-02UHC-10468-5888862584198435 Pine Dr, Gilbert, AZ, 852880.42Phone reformattedSSN last four extractedState name converted to codeZIP+4 trimmed+1 more
TPA-50092TPAKayla Park1963-12-07——976 Camelback Rd, Los Angeles, CA, 900010.42Two-digit birth yearPhone missing area codeState name converted to codeGender normalised+1 more
TPA-57573TPACarlos I Berry———2017 Palm Dr, Mesa, AZ, 852950.42Middle initial moved out of first nameDate of birth unreadableState name converted to codeGender normalised+1 more
TPA-50201TPAChristina U Holmes1943-10-03—22191249931045 Indian School Rd, Houston, TX, 770900.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
TPA-50089TPAMike Dunn2006-08-16—55497733347975 Church St, Glendale, AZ, 853290.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
TPA-62493TPACheryl Yang2003-02-03—74729064483370 Bayshore Dr Apt 21, Jacksonville, FL, 322350.44Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+6 more
TPA-61951TPADebbie Obrien1991-02-05—49484774326867 Main St, Los Angeles, CA0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-60991TPAAmanda Little1953-02-07—42427398243360 Canyon Rd, Las Vegas, NV, 891160.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-58448TPADonna Stone1996-10-18——8866 Grand Ave # 816, Jacksonville, FL, 322590.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
TPA-58831TPAAlice Willis1944-06-18—70880544496140 Forest Ave, Chandler, AZ, 852570.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
TPA-55793TPAKathleen Z Simpson1999-07-27——9520 Central Ave, Columbus, OH, 432440.46Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-63881TPAChristina Maldonado1968-01-13UHC-10398-3064155008007835 Grand Ave Apt 31, Austin, TX, 787630.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
TPA-63862TPAAlbert P Howard2004-09-11—24264380106203 Park Pl, Gilbert, AZ0.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
TPA-63148TPABruce Patterson1944-07-05UHC-92614-9820382578389161 Lake View Rd, Mesa, AZ, 852610.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
TPA-60163TPARaymond Turner1999-09-09—9878746251321 Grand Ave # 314, Denver, CO, 802080.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
TPA-59541TPAMateo Silva2008-01-02——4577 Camelback Rd Apt 22, Columbus, OH, 432100.46Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+5 more
TPA-57435TPABeverly Bannett1948-08-14UHC-99014-61—4158 Indian School Rd, Denver, CO, 802910.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-60902TPAGabriel Phillips1980-01-03——5932 Sage Ct # 795, San Antonio, TX0.46Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
14,474 rows, page 5 of 290PreviousNext