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-53954TPADiane Phillips2007-01-16——6808 Willow Ct, Fresno, CA, 937470.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-50314TPABetty Simpson1985-03-11——3543 Elm St, Plano, TX, 750100.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-51454TPARoger L Ryan1975-08-28UHC-35596-61—5731 Ridge Rd # 723, Minneapolis, MN, 554630.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61994TPAGrace Davis2000-05-18——436 Spring St Apt 1, Denver, CO, 802850.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-60359TPAAnn Lawrence———8405 Apache Blvd, Miami, FL, 331250.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-60248TPARobert P Mooore1975-11-08—23547297363363 Meadow Ln, Tucson, AZ, 857250.64Name re-casedPhone reformattedCity re-casedState name converted to code+2 more
TPA-51626TPAShirley Perkins1945-11-26—75920363896527 Jefferson Ave, Mesa, AZ, 852080.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57026TPAJudith Mills1943-05-28——7674 Pine Dr, Denver, CO, 802050.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51131TPACarl Rivera1970-04-01UHC-56976-80—2998 Canyon Rd # 815, Charlotte, NC, 282120.64Name re-casedUnit split from streetCity re-casedState name converted to code+2 more
TPA-51132TPACarl Rivera1970-04-01UHC-56976-80—2998 Canyon Rd # 815, Charlotte, NC, 282120.64Name re-casedUnit split from streetCity re-casedState name converted to code+2 more
TPA-53159TPABobby Rose2003-06-22UHC-53186-5657363963533038 Indian School Rd, Seattle, WA, 981460.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55197TPAZachary Z Simpson1964-12-08——5711 Church St, Miami, FL, 331830.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61816TPARoger Nguyen1946-11-14—96077349424808 Highland Ave, Glendale, AZ, 853810.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52739TPADonna G Mitcell1947-08-01UHC-84277-54—1369 Canyon Rd, Gilbert, AZ, 852900.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63014TPAJack Smith1974-06-11——742 Bayshore Dr, Las Vegas, NV0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-58447TPARoger Palmer1996-09-07——8924 Sage Ct, Nashville, TN, 372510.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54594TPAMarilyn Hilll1991-04-08—27865831278995 Desert Sky Blvd, Tucson, AZ, 857920.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-54715TPAAshley N Hayyes1970-03-20—48428029162850 Valley View Dr, Chandler, AZ, 852300.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58817TPANicholas Sanchez1985-04-16—20549602383184 Canyon Rd, San Antonio, TX, 782640.64Name re-casedPhone reformattedZIP+4 trimmedGender normalised+2 more
TPA-57357TPAKelly Espinoza1999-11-27——2936 Canyon Rd, Sacramento, CA, 958580.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-58154TPAJonathan Phillips1973-02-12—9225484648984 Union St, Tempe, AZ, 852060.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59233TPAJesse Perkins1985-04-16—73296916716341 Willow Ct, Nashville, TN, 372250.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50401TPARalph Kim1948-04-13——6508 Church St, Sacramento, CA, 958930.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-62767TPABarbara Weber1948-01-25—34990604154863 Ocean Ave, Eden Prairie, MN, 553360.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60684TPAMariana Hart1940-09-21—59061396194802 Union St, Gilbert, AZ, 852650.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-52600TPAEmily Perez1997-04-28—407559876674 Jefferson Ave, Columbus, OH, 432440.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61433TPABryan Dominguez1939-12-26—97085448692269 Sage Ct, Minneapolis, MN, 554420.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59101TPALaura Little2001-07-05—83247712275519 Willow Ct Apt 33, Chandler, AZ, 852190.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-50801TPACarollyn Jimenez1942-02-17—44182283487201 Meadow Ln, Houston, TX, 770540.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55881TPAAna Mills1998-06-13—78228496237015 Union St, Las Vegas, NV, 891760.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53040TPAMelissa C Salazar1994-04-25——8316 Apache Blvd, Sacramento, CA, 958850.64Name re-casedDate of birth reformattedCity re-casedState name converted to code+2 more
TPA-53252TPAGeorge Morrison1981-02-22—60163410745509 Ridge Rd Apt 32, Phoenix, AZ, 850260.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-50664TPARalph F Gonzalez1994-03-16—73088119167003 Jefferson Ave, Las Vegas, NV, 891890.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53592TPABruce W Sanchez1938-09-19——7349 Highland Ave, Eden Prairie, MN, 553440.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51974TPALawrence Ferguson1995-02-09——8245 Canyon Rd, Dallas, TX, 752890.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51814TPAHarold Berry1971-02-16——8670 River Rd, Sacramento, CA, 958290.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53965TPAAshley Williams1985-01-03——9230 Central Ave, Orlando, FL, 328940.64Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-50968TPAOlivia Hart1976-10-26UHC-78547-4586383728539622 Highland Ave, Houston, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61723TPASusan Harris1979-02-09UHC-09269-29—7073 Willow Ct # 317, Scottsdale, AZ, 852470.64Name re-casedUnit split from streetCity re-casedGender normalised+2 more
TPA-54657TPACampbell Keith1962-05-19—48439882975441 Meadow Ln, Nashville, TN, 372340.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53456TPAGloria Kim1953-04-30—44090549054694 Sunset Blvd, Tempe, AZ, 852370.64Phone reformattedCity re-casedZIP+4 trimmedGender normalised+2 more
TPA-51111TPASofia Li1948-12-18——1674 Ridge Rd, Jacksonville, FL, 322940.64Name re-casedTwo-digit birth yearCity re-casedGender normalised+2 more
TPA-51319TPAKimberly Parker2002-12-14——7164 Elm St Apt 11, Chandler, AZ, 852270.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-59893TPAHelen Williams1978-04-25—38142719211803 Bayshore Dr, San Antonio, TX, 782080.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56771TPADaniel Myers——32487928632242 Camelback Rd, Gilbert, AZ, 852580.64Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
TPA-55129TPAValentina Ortiz1958-09-28——2148 Willow Ct, Columbus, OH, 432850.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-51324TPAJacqueline Herrera1969-10-14——8269 Palm Dr, San Diego, CA, 921410.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54552TPAKelly Miller1977-09-23—77487671471236 Sage Ct, Gilbert, AZ, 852630.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56261TPALarry Oliver1972-03-28—28956957531583 Union St, Denver, CO, 802250.64Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
TPA-62039TPAJohn Freeman1946-07-23——2736 Lake View Rd, San Antonio, TX, 782940.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
14,474 rows, page 59 of 290PreviousNext