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-56672TPAAaron Webb1951-01-24——4854 Forest Ave, Phoenix, AZ, 850840.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61144TPAAisha Montgomery1940-08-14——6702 River Rd, Las Vegas, NV, 891250.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52889TPACamila Santiago1940-08-03——1728 Valley View Dr, Scottsdale, AZ, 852550.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52108TPABrenda X Johnston1996-01-24——1490 River Rd, Tampa, FL, 336560.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60413TPAEiljah Hunter1992-05-21——9432 Broadway, Minneapolis, MN, 554660.78Name re-casedTwo-digit birth yearPlan code upper-casedWhitespace trimmed+1 more
TPA-56080TPAKathryn Y Hart1950-12-28—7066007087—0.78Middle initial moved out of first nameName re-casedPhone reformattedWhitespace trimmed+1 more
TPA-60925TPAKeith Sliva1987-02-11—95966050103056 Jefferson Ave, Las Vegas, NV, 891600.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62793TPAPriya Rios1918-02-14——610 Desert Sky Blvd, Eden Prairie, MN, 553870.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-58954TPAAhmd Murray2003-08-15——9035 Palm Dr, Dallas, TX, 752860.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-54420TPARuth Herrera1960-02-24——6473 Cedar Ln, Minneapolis, MN, 554770.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57513TPAJonathan Ford1955-02-08——1229 Broadway, Nashville, TN, 372790.78Name re-casedDate of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-63420TPABeverly Reid1967-12-17——6813 Sunset Blvd, Austin, TX, 787050.78Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-54952TPAStephanie Hayes1982-06-25—49041018856718 Elm St, Scottsdale, AZ, 852320.78Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-61711TPAAmanda U McDonald1961-09-28——6337 Apache Blvd, Miami, FL, 331780.78Date of birth reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-50236TPABrian Vargas1977-11-09—35722510325424 Lincoln Way, Tucson, AZ, 857170.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-61130TPAPaul Lee1963-01-17—7956322109129 Canyon Rd, Dallas, TX, 752440.78Phone reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-64216TPAHelen Jacobs1998-02-04——2811 Desert Sky Blvd # 709, Las Vegas, NV, 891600.78Date of birth reformattedUnit split from streetCity re-casedWhitespace trimmed+1 more
TPA-63177TPALisa Stevens1986-09-28—64763788288250 Highland Ave Apt 24, Chandler, AZ, 852050.78Date of birth reformattedPhone reformattedUnit split from streetWhitespace trimmed+1 more
TPA-53470TPAAlan U Patterson2007-11-15—86633598025417 Baseline Rd, Seattle, WA, 981400.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62399TPAMarcus Y Webb1953-10-21—83154781285736 Church St, Sacramento, CA, 958090.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58920TPAJanice Lucas1943-11-03——4330 Oak St, Fresno, CA, 937590.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56071TPABetyt Kelly1961-06-07——338 Meadow Ln, San Diego, CA, 921650.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57232TPABrian Bell1963-01-06—7235787441784 Camelback Rd, San Diego, CA, 921920.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59588TPAAshley L Watkins1991-02-15—851734541235 Central Ave, San Diego, CA, 921650.78Name re-casedPhone reformattedSSN last four extractedWhitespace trimmed+1 more
TPA-52164TPAKatherine R Austin1964-01-09—61522443948602 Main St, Jacksonville, FL, 322400.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61928TPAChristian Clark1953-09-17——2938 Maple Ave, Chandler, AZ, 852390.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53109TPAPamela Mitchell1997-11-08—7883541894—0.78Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more
TPA-56925TPASharon Herrera1966-02-01——8230 Market St, Jacksonville, FL, 322910.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57776TPAJason Garrett1978-04-08—65740362347286 Baseline Rd, Phoenix, AZ, 850810.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-51228TPAWayne McDonald1994-06-22——7309 Baseline Rd, Eden Prairie, MN, 553000.78Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-54490TPABradely Hall1978-05-24—88864473951877 Lincoln Way, Phoenix, AZ, 850540.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61630TPABrittany Walsh1984-05-09——6263 Forest Ave, Denver, CO, 802200.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-60050TPADouglas Matthews1976-06-02—31191338191722 Canyon Rd, Tampa, FL, 336010.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-51298TPABrittany Kim1958-12-16—3514706707—0.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-50687TPARichard Stewart1997-01-27——524 Mountain View Dr, Miami, FL, 331060.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-63380TPAPamela Wallace1988-03-20——8337 Bayshore Dr, Tempe, AZ, 852980.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59099TPACarolyn Kennedy1948-08-06UHC-02309-97—5655 Main St, Glendale, AZ, 853360.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53054TPADorothy Rios1993-07-17UHC-82073-07—963 Canyon Rd, Mesa, AZ, 852360.78Name split from “Last, First”Member ID reformattedCity re-casedWhitespace trimmed+1 more
TPA-59441TPASamantha Ray1990-09-03——464 Jefferson Ave, Denver, CO0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-50975TPACarol King2002-07-03——9307 Apache Blvd, Tucson, AZ, 857240.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55210TPAWillie Black2001-09-22UHC-22972-7054148316374399 Sunset Blvd, Tucson, AZ, 857890.78Date of birth reformattedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-52232TPAAlbert Hoffman1961-07-26—79088084639423 Hillcrest Rd, Los Angeles, CA, 900020.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-56194TPAOmar Woods1980-09-05——6776 Mountain View Dr Apt 20, San Diego, CA, 921460.78Name re-casedDate of birth reformattedUnit split from streetCity re-cased+1 more
TPA-56195TPAOmar Woods1980-09-05——6776 Mountain View Dr Apt 20, San Diego, CA, 921460.78Name re-casedDate of birth reformattedUnit split from streetCity re-cased+1 more
TPA-56410TPAPaul Cooper1984-05-19——732 Camelback Rd, San Antonio, TX, 782830.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54749TPALarry Fuller1978-03-07—92053108699464 Forest Ave, Austin, TX, 787130.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63050TPAGeorge Park2001-08-22UHC-72658-41—2626 Washington St, Plano, TX, 750800.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57157TPAEmily Dunn2005-06-10——2401 Union St, Tempe, AZ, 852510.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62531TPAVictoria Evans1962-08-16——5865 Palm Dr, Tempe, AZ, 852300.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-53904TPAMarcus Gutierrez1963-04-16—29562423737640 Harbor Blvd, Glendale, AZ, 853610.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
14,474 rows, page 155 of 290PreviousNext