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-60971TPAJeff Lewis1986-09-17—23296336586230 Hillcrest Rd, Dallas, TX, 752680.64Phone reformattedState name converted to codeGender normalisedPlan code upper-cased+2 more
TPA-59230TPAPeter Fowler1990-09-28——1031 Central Ave, Mesa, AZ, 852430.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57030TPANancy Freeman2005-06-03—81766478553985 Washington St, Fresno, CA, 937860.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-62210TPAJustin Barnes1967-11-25—72534773367470 Valley View Dr, Seattle, WA, 981150.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50270TPAAbigail Hayes2004-06-12—82966467164247 Hillcrest Rd, Austin, TX, 787920.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63169TPAMark Parker1995-01-16——5873 Mountain View Dr, Atlanta, GA, 303960.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55356TPASharon J Duncan1994-04-22—85867557961226 Mountain View Dr, Gilbert, AZ, 852280.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59053TPASandra Bell1952-11-28—23290430783064 Oak St, Miami, FL, 331850.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-63869TPAJerry Roberts2005-11-21—51988628698059 Valley View Dr, Scottsdale, AZ, 852720.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56064TPAAlexander V Williamson——71660952095393 Ridge Rd, Las Vegas, NV, 891460.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-61254TPARoger Hawkins1973-01-24——1000 Baseline Rd, Las Vegas, NV, 891730.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-53747TPASusan Sims1958-07-18——2297 Elm St, Austin, TX, 787420.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-55317TPAElizabeth Munoz1946-03-11UHC-50406-95—4796 Spring St, Columbus, OH0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-56876TPAHelen Vega1965-02-17UHC-30224-1976360332156800 Ocean Ave, Gilbert, AZ, 852570.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58941TPAMason Foster1975-03-14UHC-91690-75—3701 Harbor Blvd, Nashville, TN, 372290.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-60376TPAHarold Franklin1980-02-23—87055396758586 Sage Ct # 900, Scottsdale, AZ, 852910.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-53625TPARachel Bowman1962-03-21——6730 Sunset Blvd, Jacksonville, FL, 322920.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59940TPASarah McDonald1956-05-05UHC-91367-2870455183826759 River Rd, Miami, FL, 331620.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51031TPAJames Chen1961-02-13——2201 River Rd, Tucson, AZ, 857040.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56048TPAMaria Mills2002-02-20—95589961134692 Park Pl, Columbus, OH, 432110.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-50908TPADanielle U Porter1946-08-16UHC-05123-5166596598574668 Apache Blvd, Las Vegas, NV, 891730.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50241TPAMatt Lawson1995-05-15——4892 Pine Dr, Mesa, AZ0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
TPA-63792TPARussell Williamson1990-12-09UHC-62850-7845655713698828 Ocean Ave, Eden Prairie, MN, 553850.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55434TPAElizabeth Hernandez1945-01-01—33049323764988 Baseline Rd, Tucson, AZ, 857570.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-60994TPAOmar Ros1953-05-22——8413 Canyon Rd, Columbus, OH, 432150.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54802TPAAngela Vargas1955-09-02—77769728543465 Forest Ave Apt 13, Scottsdale, AZ, 852660.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-60738TPAJordan D Cooper1948-02-07——1981 Mountain View Dr, Columbus, OH, 432350.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60611TPAWei Austin1994-08-27—61586034651250 River Rd, Orlando, FL, 328140.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54635TPAMadison Wheeler2008-01-14——4424 Forest Ave, Columbus, OH, 432760.64Phone missing area codeStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
TPA-54634TPAMadison Wheeler2008-01-14——4424 Forest Ave, Columbus, OH, 432760.64Phone missing area codeStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
TPA-52348TPASophia Hughs2006-11-23——2143 Bayshore Dr, Tempe, AZ, 852300.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60232TPAMichelle Mendez1967-12-20——1553 Hillcrest Rd, Sacramento, CA, 958200.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-51475TPABrian P Allen1951-05-13—26223485599215 Lincoln Way, Austin, TX, 787360.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-60651TPAJohn Weber1984-05-24——4227 Washington St, Houston, TX, 770260.64Name re-casedCity re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-53512TPAJudy Lawrence2008-01-26——6788 Lincoln Way, Miami, FL, 331970.64Name split from “Last, First”Date of birth reformattedCity re-casedState name converted to code+2 more
TPA-62510TPAJerry Snyder2003-07-14——2995 Ridge Rd, Fresno, CA, 937910.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53730TPAMei Jackson2002-05-19——3669 Market St, Mesa, AZ, 852250.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-59200TPAArnold Pamela1973-11-19—23993554201082 Maple Ave, San Diego, CA, 921840.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-63718TPARichard Espinoza1964-11-08——2138 Spring St, Sacramento, CA, 958820.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57840TPAShirley Jackson1969-06-04——9537 Spring St, Plano, TX, 750090.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53967TPARandy Washington1956-04-20—22583251167571 Camelback Rd, Chandler, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57036TPALori George1947-08-05——6812 Broadway # 590, Tempe, AZ0.64Name re-casedUnit split from streetAddress re-casedZIP missing+2 more
TPA-62688TPAIsabella Waang1990-08-06——600 Church St # 193, Minneapolis, MN, 554330.64Name re-casedDate of birth reformattedUnit split from streetCity re-cased+2 more
TPA-60883TPAJoyce Sanchez1966-10-24——2620 Market St # 661, Las Vegas, NV, 891040.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-60884TPAJoyce Sanchez1966-10-24——2620 Market St # 661, Las Vegas, NV, 891040.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-51148TPAAaron Harevy2001-07-05——5852 Apache Blvd, Glendale, AZ, 853730.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-52290TPACharlotte Snyder1952-11-17—43492727054879 Maple Ave, Sacramento, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-54323TPALaura Harrison1977-08-02—54623384718033 Apache Blvd # 384, Austin, TX, 787720.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-60779TPAAmy Y Simpson1940-12-05—58768534567977 Bayshore Dr, Jacksonville, FL, 322600.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61716TPARalph G Estrada1976-01-02UHC-70370-7290071982094738 Canyon Rd, Tempe, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
14,474 rows, page 53 of 290PreviousNext