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-61405TPAHarold Porer1942-05-01——2658 Grand Ave, Glendale, AZ, 853720.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56123TPAMateo Berry1954-09-13—43888171333004 Hillcrest Rd, Las Vegas, NV, 891590.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63601TPAJose Owens1982-09-22UHC-76682-96—2057 Indian School Rd, Seattle, WA, 981910.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59896TPAMargaret Griffin1947-10-20UHC-40806-56—3342 River Rd, San Diego, CA, 921580.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-57545TPAAlan Lane1982-06-10——3933 Pine Dr, Plano, TX, 750960.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-61211TPAWayne M Bennett1948-01-25——4348 Maple Ave, Tampa, FL, 336020.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-55427TPABarbara Schultz1997-02-25—73034326271266 Spring St, Dallas, TX, 752940.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57048TPAYuki Marquez1975-11-13——5165 Mountain View Dr, Houston, TX0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51083TPAJordan Porter1970-07-21——214 Washington St, Los Angeles, CA, 900990.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61380TPADoris Kelly1957-03-07—39527269809827 Highland Ave, Seattle, WA, 981620.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56883TPAMateo Coleman1963-10-03—91494320787528 Lincoln Way, Glendale, AZ, 853030.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57277TPAStephanie Lane1941-06-10——7072 Baseline Rd, Atlanta, GA, 303150.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-59011TPAFatima Scott1942-06-24—59879586887415 Lake View Rd, Plano, TX, 750910.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-55340TPASean Gonzales1961-07-11——1173 Willow Ct, Los Angeles, CA, 900210.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-53936TPAGrace Hill1995-03-20——8723 Harbor Blvd, Plano, TX, 750860.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55816TPAKathryn Braley1997-02-02—57858307361751 Oak St, Jacksonville, FL, 322390.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-51880TPAGarald Robertson——61751383264482 Grand Ave # 370, San Antonio, TX, 782510.64Name re-casedDate of birth unreadablePhone reformattedUnit split from street+2 more
TPA-55196TPAZachary Simpson1964-12-08——5711 Church St, Miami, FL, 331830.64Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+2 more
TPA-60624TPARoy Harvey2005-09-04UHC-56060-8641122462752684 Mountain View Dr, Gilbert, AZ, 852650.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62054TPAMichelle Hart1972-04-06——2271 Lake View Rd, Houston, TX, 770960.64Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-56075TPATimothy Gonzalez1941-09-16——9092 Willow Ct, Minneapolis, MN, 554940.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-63267TPARoger Marquez1964-12-22——5303 Elm St Apt 14, Minneapolis, MN, 554070.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57804TPAJennifer Fisher1960-11-02UHC-08664-81—4602 Spring St, Dallas, TX, 752860.64Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-53354TPAEric Bannks1956-02-08—9595534496776 Central Ave, Gilbert, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-59648TPASean Y Chen1972-03-10——4854 Pine Dr, Las Vegas, NV, 891650.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-60219TPADaniel Crawford1971-10-07——9650 Apache Blvd, Nashville, TN, 372620.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-58036TPAJuan Stephens——20238530589366 Indian School Rd, Jacksonville, FL, 322730.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55298TPAAlexander J Watkins1951-01-04UHC-16468-6079050658664141 Meadow Ln, Columbus, OH, 432140.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60587TPALaura Q Jordan1961-07-06UHC-59863-10—7326 Elm St, Phoenix, AZ, 850200.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-62659TPAPamela A Herrera1962-07-27——9282 Indian School Rd, Glendale, AZ, 853310.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60216TPALia Andesron1951-12-09—86965588562347 Market St # 993, Jacksonville, FL, 322160.64Date of birth reformattedPhone reformattedUnit split from streetGender normalised+2 more
TPA-55150TPAEmma Washingtn1949-12-01UHC-20115-01—2206 Maple Ave, San Antonio, TX, 782220.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52524TPALuis Richardson1990-06-10——7253 Elm St, Los Angeles, CA, 900800.64Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+2 more
TPA-64301TPAJass Butler1961-06-06——1637 Sage Ct, Plano, TX, 750500.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-59439TPAGloria M Stewart1979-03-28——7869 Indian School Rd, Jacksonville, FL, 322000.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58022TPARonald Hoffman1979-03-11—86521598004022 Park Pl, Austin, TX, 787920.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59345TPAMichael Simmons1978-04-13——7323 Park Pl # 618, Dallas, TX, 752060.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-52134TPAJulie Brooks2000-01-15——2139 Park Pl, Scottsdale, AZ, 852690.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-52039TPALori Le1962-06-12——7963 Jefferson Ave, Minneapolis, MN, 554850.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58171TPAMark Lynch1997-12-19——5482 Main St, Orlando, FL, 328380.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-55229TPAAisha Kelley1946-11-03——5803 Spring St, Las Vegas, NV, 891310.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-51373TPABrenda Estrada1963-12-15——8397 Canyon Rd, Tucson, AZ, 857380.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-53218TPAMadison Garrett———8801 Desert Sky Blvd, Dallas, TX, 752290.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-52210TPABryan Mrshall1959-12-05——4458 Spring St, Houston, TX, 770770.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60351TPAEugene K Nguyen1992-09-24——6870 Camelback Rd, Dallas, TX, 752490.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-54792TPARonald Patel1946-12-02—4264301569795 Jefferson Ave # 478, Denver, CO0.64Name re-casedPhone reformattedUnit split from streetZIP missing+2 more
TPA-58996TPA—Junk1971-03-18——455 Central Ave, Tampa, FL, 336330.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52562TPADoris Robertson1951-03-03—62681738021581 Canyon Rd, Houston, TX, 770970.64Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
TPA-57580TPAJudith Cole1994-02-04—53743402684995 Mountain View Dr, Denver, CO, 802410.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55929TPANoah Moreno1950-01-19—62377460582347 Bayshore Dr, Charlotte, NC, 282830.64Phone reformattedState code upper-casedZIP+4 trimmedGender normalised+2 more
14,474 rows, page 63 of 290PreviousNext