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-61044TPAKyle Miller———436 Union St, Minneapolis, MN, 554580.66Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59533TPAAisha Turner1998-07-10——764 Forest Ave, Austin, TX, 787640.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52419TPAGrace Ramos1989-10-27UHC-17338-10—8508 Maple Ave, Minneapolis, MN, 554920.66Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-54997TPAAhmed Johnson1980-07-19——1865 Ocean Ave, Columbus, OH, 432970.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-51906TPATeresa George1971-06-02—49856032091320 Ridge Rd, San Diego, CA, 921240.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-59774TPAJustin K West2004-07-24—91188909653096 Canyon Rd, Tucson, AZ, 857450.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-62383TPABenjamin Simmons1971-06-14——8450 Camelback Rd, Gilbert, AZ, 852240.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-50803TPAHiroshi I Reynolds1965-06-21UHC-14204-71—2054 Sunset Blvd, Sacramento, CA, 958970.66Name re-casedDate of birth reformattedSSN last four extractedZIP+4 trimmed+1 more
TPA-52307TPADylan Hill1962-01-21——5307 Valley View Dr, Charlotte, NC0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-57205TPANoah Woods1999-05-23——6006 Maple Ave, San Antonio, TX0.66City re-casedZIP missingGender normalisedWhitespace trimmed+1 more
TPA-60654TPAAisha Harvey———4208 Main St, Dallas, TX, 752110.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54307TPASantiago Garza1994-07-26———0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-55395TPAKaren Young2008-03-15—29044510477441 Bayshore Dr Apt 14, Glendale, AZ, 853240.66Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+1 more
TPA-51473TPAEmily Stone1960-03-28——2674 Baseline Rd, Los Angeles, CA, 900760.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-61864TPAKathryn Thompson1988-02-25—38499092399214 Forest Ave, Minneapolis, MN, 554160.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-62163TPADougls Ortega1991-01-22———0.66Date of birth reformattedSSN last four extractedGender normalisedWhitespace trimmed+1 more
TPA-59756TPALuis Freeman1999-10-21——7776 Indian School Rd, Chandler, AZ, 852930.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60812TPASantiago Silva1955-12-21——2852 Valley View Dr, Tampa, FL, 336150.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63168TPANancy Porter1940-07-15——6331 Ocean Ave, Dallas, TX, 752910.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-62470TPAScott Phillips1981-08-18—88831902064082 River Rd Apt 13, Sacramento, CA0.66Name re-casedPhone reformattedUnit split from streetZIP missing+1 more
TPA-62569TPADennis Y Parker1962-03-23—74238165399885 Hillcrest Rd, Phoenix, AZ, 850890.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63795TPAZachary I Armstrong1978-01-27——9095 Pine Dr # 396, Nashville, TN, 372280.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-55582TPAMaria T Schmidt2002-05-17——4327 River Rd, Los Angeles, CA, 900700.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-64033TPATyler D Garza1981-11-03UHC-04182-5161536947462887 Maple Ave, Gilbert, AZ, 852680.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
TPA-61835TPASusan Ward1976-10-13——1262 Canyon Rd, Columbus, OH, 432200.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-56350TPAKayla Kelley1951-11-09—57566947712969 Palm Dr, San Diego, CA, 921140.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60572TPAKenneth B Pierce1955-03-28—95228792903947 Harbor Blvd, Dallas, TX, 752160.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55420TPAJacob James———7327 Ridge Rd, Glendale, AZ, 853810.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53718TPAYuki M Allen2003-05-22——8029 Grand Ave, Sacramento, CA, 958030.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-60481TPAChristine Powell1984-11-14—96198442211042 Maple Ave Apt 16, Houston, TX, 770000.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59372TPADiana Lane1990-09-25——3391 Indian School Rd, Mesa, AZ, 852650.66Date of birth reformattedCity re-casedState name converted to codeGender normalised+1 more
TPA-59154TPA—Junk1971-06-08——7465 Forest Ave, Austin, TX, 787790.66Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared+1 more
TPA-56787TPAJack Barnes1979-04-24—76667693323185 Washington St, Las Vegas, NV, 891250.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-59787TPAJudith Palmer1997-02-02——4983 Pine Dr, Orlando, FL, 328910.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-61036TPARalph Morris1971-12-28—47197397932055 Forest Ave, Austin, TX, 787180.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-50566TPAMei Long———3847 Forest Ave, Dallas, TX, 752360.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57210TPADouglas Burns1994-09-24——344 Church St, Fresno, CA0.66Name split from “Last, First”City re-casedZIP missingWhitespace trimmed+1 more
TPA-60438TPADiego X Morales1963-05-24——890 Hillcrest Rd, Tampa, FL0.66Street suffix standardisedAddress re-casedState code upper-casedZIP missing+1 more
TPA-60708TPAOmar Obrien1953-12-16——8422 Washington St, San Diego, CA, 921350.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-54165TPAMarilyn Tucker2003-02-22——9692 Apache Blvd, Tempe, AZ, 852210.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51877TPAAngela Wagner1951-05-16——2618 Camelback Rd # 624, San Diego, CA, 921750.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-53414TPAJaince Moreno1950-12-06UHC-99841-47—4861 Grand Ave, Sacramento, CA, 958130.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-61699TPAJordan Greene1982-01-27——2298 Camelback Rd, Scottsdale, AZ, 852550.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61906TPAAhmed Vega1953-09-25—97736008605743 Bayshore Dr # 530, Scottsdale, AZ, 852450.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-54701TPADiana Reynolds1970-07-19——6536 Lake View Rd # 545, Fresno, CA0.66Date of birth reformattedUnit split from streetZIP missingWhitespace trimmed+1 more
TPA-54700TPADiana Reynolds1970-07-19——6536 Lake View Rd # 545, Fresno, CA0.66Date of birth reformattedUnit split from streetZIP missingWhitespace trimmed+1 more
TPA-60349TPAAlan Simmons1995-04-25UHC-07767-31—4788 Indian School Rd, Gilbert, AZ, 852600.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-61995TPAHeather Austin1994-10-27UHC-79946-28—4774 Harbor Blvd, Gilbert, AZ, 852440.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58848TPARoberts W Henry1947-04-05——709 Camelback Rd, Phoenix, AZ, 850590.66Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-59889TPATheresa K Franklin1944-11-18——7509 Willow Ct, Seattle, WA, 981490.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
14,474 rows, page 88 of 290PreviousNext