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-57596TPACharlotte M Haansen———2692 Palm Dr, Scottsdale, AZ, 852710.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-53929TPACheryl Dunn1987-12-14——6313 Highland Ave, Eden Prairie, MN, 553630.54Name split from “Last, First”Two-digit birth yearCity re-casedState name converted to code+1 more
TPA-62377TPADrew James1939-01-24——7426 Forest Ave, Jacksonville, FL, 322210.54Name split from “Last, First”State code upper-casedZIP+4 trimmedGender normalised+1 more
TPA-53255TPASarah Vazquez1982-04-20—21925582807529 Grand Ave, Tucson, AZ, 857320.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-57968TPACynthia Carroll2004-07-27——7925 Mountain View Dr Apt 10, Las Vegas, NV0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-57252TPAJanet U Dean———8717 Palm Dr # 330, Phoenix, AZ, 850370.54Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-55603TPANicole Weber2008-04-01——8660 Broadway, Glendale, AZ, 853540.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-54545TPAFrank S Garrett1984-11-11——9229 Sunset Blvd, Tampa, FL, 336180.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-63328TPANancy B Gilbert1976-03-20——4914 Forest Ave, San Antonio, TX, 782060.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-58652TPAShirley Rogers1944-05-12——6321 Harbor Blvd, Scottsdale, AZ, 852920.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-52683TPAGary Hernandez—UHC-48744-09—8374 Central Ave # 180, Tempe, AZ, 852080.54Name re-casedDate of birth unreadableUnit split from streetGender normalised+1 more
TPA-56809TPAKatherine Hawkins2002-12-12——7014 Valley View Dr, Austin, TX, 787880.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-62231TPAWayne Fernandez1941-12-03——6873 Canyon Rd, Jacksonville, FL, 322690.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-50856TPATylre Gurrero1989-03-25—25587712043570 Park Pl, Phoenix, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-60399TPAEric Simposn1998-10-18——8776 Canyon Rd, Columbus, OH, 432890.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-58670TPASarah Nelson———2553 Canyon Rd Apt 19, Eden Prairie, MN, 553450.54Name re-casedDate of birth unreadableUnit split from streetState name converted to code+1 more
TPA-57216TPABenjamin Lee2006-09-23——5582 Valley View Dr, Houston, TX, 770950.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-51056TPAMary Allen1974-10-02UHC-94733-16—4111 Grand Ave # 224, Eden Prairie, MN, 553680.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-53366TPABrittany Knight1950-10-10——3394 Mesa Dr, Columbus, OH, 432810.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-60026TPADiane Hunt1974-07-11——772 Bayshore Dr, Austin, TX, 787810.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-64421TPAPatrick Jacobs1952-01-27——2015 Sage Ct # 158, Las Vegas, NV0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-54337TPAEvelyn Gardner1981-08-14——7508 Highland Ave, Los Angeles, CA, 900200.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-58553TPABarbara Chavez1984-04-28——6126 Indian School Rd, San Antonio, TX0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-50646TPARobert Alexander1959-03-08UHC-08776-212725843105814 Camelback Rd, Orlando, FL, 328660.54Name re-casedTwo-digit birth yearState name converted to codeGender normalised+1 more
TPA-60001TPADaniel Reid1980-05-26——7481 Park Pl, Houston, TX, 770460.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-56223TPAFatima Y Nunez———9002 Maple Ave, Glendale, AZ, 853070.54Date of birth missingState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
TPA-52929TPAPamela Q Black1969-01-06——8059 Park Pl, Denver, CO, 802570.54Name split from “Last, First”Phone missing area codeState name converted to codeWhitespace trimmed+1 more
TPA-53599TPALerry Patterson1993-11-15——8912 Ocean Ave # 624, San Antonio, TX0.54Phone missing area codeUnit split from streetZIP missingWhitespace trimmed+1 more
TPA-56606TPABurke I Charles———3100 Lake View Rd, Atlanta, GA, 303020.54Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+1 more
TPA-56605TPABurke I Charles———3100 Lake View Rd, Atlanta, GA, 303020.54Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+1 more
TPA-61299TPAPeter G Fox2000-02-11UHC-43855-3237894760215462 Forest Ave, Houston, TX, 770830.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-55039TPABen Montgomery2002-01-13——1185 Central Ave, Glendale, AZ, 853060.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-54270TPATom Walsh1959-02-19——6258 Mountain View Dr, Charlotte, NC, 282640.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
TPA-60932TPACharles Reid1996-06-14——3202 Lincoln Way, Tempe, AZ, 852110.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-59060TPAElijah Cruz1962-02-05UHC-01148-98—8081 Central Ave Apt 10, Columbus, OH, 432400.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-55978TPARamirez Heather1985-09-07——3843 Main St Apt 18, Plano, TX, 750500.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-61024TPAJulia Wright1994-05-15——5217 Main St, Dallas, TX, 752410.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
TPA-61915TPAJordan Herrera1994-01-02——8958 Indian School Rd, Phoenix, AZ, 850530.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-51711TPABrayn Saners1968-09-27—47577421854575 Broadway # 865, Los Angeles, CA, 900130.54Name re-casedUnit split from streetState name converted to codeGender normalised+1 more
TPA-50991TPALauren O Stephens1994-01-02UHC-21092-63—8542 Valley View Dr, Tempe, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-60845TPAAshley Perry1968-03-26UHC-37171-052574365078697 Park Pl, Fresno, CA0.54Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+1 more
TPA-53794TPAMateo Ortega1956-01-09UHC-99277-69—7123 Lincoln Way, Houston, TX, 770270.54Name split from “Last, First”Two-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
TPA-50988TPAAnn Perez1999-12-05——352 Elm St, Denver, CO, 802290.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
TPA-64446TPASara Butron1983-02-21——5709 Sage Ct, San Diego, CA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-52234TPAArthur Greene2006-06-20——4014 Cedar Ln, Atlanta, GA0.54Name split from “Last, First”Date of birth reformattedState name converted to codeZIP missing+1 more
TPA-63232TPAKatherine Q Stephens1973-12-22——7018 Valley View Dr, Mesa, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-55752TPAKathryn Moreno1988-12-02—55875992299188 Grand Ave, Columbus, OH, 432390.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
TPA-61677TPAJeremy O Boyd1997-12-10——9081 Lake View Rd, Miami, FL0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-64103TPAFrances Williamson1960-12-08UHC-12909-32—3123 Mountain View Dr, Nashville, TN, 372780.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-58810TPAWillie Lynch1987-06-03——3720 Park Pl # 603, Glendale, AZ, 853800.54Name split from “Last, First”Unit split from streetCity re-casedGender normalised+1 more
14,474 rows, page 26 of 290PreviousNext