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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-57849TPARoger Nelson1989-06-14——1103 Desert Sky Blvd, Tucson, AZ, 857330.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-51104TPAEric W Wright1939-06-11——5338 Main St, Mesa, AZ, 852390.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-55442TPAHarold Rogers2005-10-15——955 Lake View Rd, Eden Prairie, MN, 553010.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-54111TPAMariana Jimenez1965-07-21——4008 Church St, Miami, FL0.68Name split from “Last, First”City re-casedZIP missingPlaceholder values cleared
TPA-57891TPABetty Paetl1959-02-07UHC-54842-2374277946311321 River Rd Apt 2, Charlotte, NC, 282910.68Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased
TPA-57218TPACastro Priya——84832562711086 Oak St, Seattle, WA, 981560.68Date of birth unreadableZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-59317TPAJeremy Nguyen1990-03-26——5719 Jefferson Ave, Atlanta, GA, 303080.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52699TPALisa Fster1995-08-24——1012 Broadway, Houston, TX0.68SSN last four extractedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-56341TPAArjun Arnold1960-06-05UHC-91721-44—9660 Broadway, Orlando, FL0.68Name re-casedState name converted to codeZIP missingPlaceholder values cleared
TPA-57045TPAJoan Q Padilla1968-09-01———0.68Middle initial moved out of first nameName re-casedTwo-digit birth yearPlaceholder values cleared
TPA-59520TPADick H Hamilton2000-10-03UHC-08968-49—4119 Highland Ave # 996, Columbus, OH0.68Name re-casedUnit split from streetZIP missingPlaceholder values cleared
TPA-54737TPARaymond Flores2007-11-09——147 Apache Blvd, Eden Prairie, MN, 553570.68Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased
TPA-57992TPABrian McCoy1958-07-15——8242 Union St, Tempe, AZ, 852380.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57993TPABrian McCoy1958-07-15——8242 Union St, Tempe, AZ, 852380.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53269TPAJoseph C King——70383629469130 Broadway, Jacksonville, FL, 322900.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
TPA-53234TPAEric Palmer1964-11-24——7424 Palm Dr Apt 22, Los Angeles, CA, 900250.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63480TPARay A Meyer1983-01-04——5905 Mountain View Dr, Gilbert, AZ, 852210.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62346TPAArthur Kelley2008-10-01——7852 Union St, Charlotte, NC, 282530.68Two-digit birth yearZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-52413TPAShirley Estrada1982-10-07——1380 Mountain View Dr, Tempe, AZ, 852020.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64302TPAJuan Wallace1954-02-27UHC-92362-72—5508 Union St, Columbus, OH, 432540.68Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased
TPA-53393TPABilly Hat1986-01-16——6343 Ridge Rd, San Antonio, TX, 782880.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63399TPAJudith Davis1977-06-09UHC-83672-30—5600 Meadow Ln, Glendale, AZ, 853610.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64347TPARobert Lewis1938-06-12——1524 Oak St, Sacramento, CA, 958580.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54327TPAAlan Nunez2003-08-05—94333058226551 Maple Ave, Tampa, FL, 336440.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-51286TPAMason Santos1964-03-21——8308 Canyon Rd, Glendale, AZ, 853850.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-59850TPASara Matthews————0.68Name re-casedDate of birth unreadableSSN last four extractedPlaceholder values cleared
TPA-55017TPABeverly Schultz1980-07-15———0.68Two-digit birth yearEmail lower-casedGender normalisedPlaceholder values cleared
TPA-53627TPAJerry King1983-09-23——2993 Ocean Ave, Tampa, FL, 336320.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63856TPAJennifer X Wong1956-10-21—42447429483291 Sunset Blvd, Gilbert, AZ, 852590.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62126TPAJulie Garrtt1940-06-04UHC-79164-9223331351395021 Pine Dr, San Antonio, TX, 782210.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
TPA-61999TPA—Junk1960-03-21—9596542063—0.68Date of birth reformattedPhone reformattedGender normalisedNo usable name (quarantined)
TPA-55479TPAAhmed Wright1972-11-22UHC-78812-39—617 Camelback Rd, Chandler, AZ, 852140.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50775TPAWalter I Washington1944-03-04——2644 Hillcrest Rd, San Diego, CA, 921270.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64456TPAMason V Payne1979-11-17—32383535515013 Forest Ave, Atlanta, GA, 303850.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55700TPAJanice Hunt——85690034045192 Lincoln Way, Charlotte, NC, 282680.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
TPA-55463TPAAmy Wiliamson1982-11-20——7943 Desert Sky Blvd, Jacksonville, FL, 322010.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-58855TPAPaul Medina1979-09-11——6454 Forest Ave, Orlando, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-58091TPAGary Hart1983-01-04——5166 Ridge Rd, Mesa, AZ, 852720.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-52850TPALogan Powell1961-06-22——9821 Cedar Ln, Sacramento, CA, 958450.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-59259TPAMadison Tucker1963-10-17——5673 River Rd, Columbus, OH0.68Two-digit birth yearZIP missingWhitespace trimmedPlaceholder values cleared
TPA-50338TPAMargaret Pena1985-10-06——978 Market St, Eden Prairie, MN, 553190.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54662TPACynthia Ryan1948-04-19—81473367861187 Broadway, San Antonio, TX, 782000.68Two-digit birth yearState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-50411TPAEmily O Hudson1963-09-10——7372 Grand Ave, Fresno, CA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-59143TPAEmily Jones———9687 Valley View Dr, Orlando, FL, 328080.68Date of birth missingCity re-casedState name converted to codePlaceholder values cleared
TPA-60286TPAPatrick Hawkins2007-10-27UHC-18890-29—4154 Baseline Rd, Charlotte, NC, 282070.68Name re-casedState name converted to codeZIP+4 trimmedPlaceholder values cleared
TPA-57609TPAAndrea Anderson1945-09-25——1436 Cedar Ln, San Antonio, TX, 782500.68Date of birth reformattedState name converted to codeGender normalisedPlaceholder values cleared
TPA-57368TPASandra Vega1949-12-23UHC-13934-86——0.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
TPA-56208TPARuszell Le1946-09-18——509 Central Ave, Dallas, TX, 752750.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-51931TPAHannah Pierce1997-06-26——340 Indian School Rd, Orlando, FL, 328570.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-50657TPAAmanda Lee1944-07-18——114 Mesa Dr, Atlanta, GA, 303380.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
14,474 rows, page 98 of 290PreviousNext