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-62535TPADaniel Yagn1950-03-26——8826 Valley View Dr, Tucson, AZ, 857350.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-63895TPAPamela Young———3553 River Rd, Columbus, OH0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-53736TPAJoe Matthews1945-05-09——1238 Willow Ct, Las Vegas, NV, 891830.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-52319TPADennis Lane2006-01-24——5757 Oak St, Las Vegas, NV, 891120.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-62987TPAChristina Robinson1984-12-26UHC-12497-27—9312 Apache Blvd, Minneapolis, MN, 554150.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60578TPAPamela Sanders1960-06-11——5409 Washington St, Nashville, TN, 372300.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-62409TPARoger Hrrison1992-07-11UHC-03161-3339355960059840 Central Ave Apt 18, Glendale, AZ, 853890.52Name split from “Last, First”Member ID reformattedUnit split from streetState name converted to code+2 more
TPA-59336TPAAustin Franklin1944-05-04——8689 Bayshore Dr, Tempe, AZ, 852120.52Name re-casedDate of birth reformattedState name converted to codeZIP+4 trimmed+2 more
TPA-51269TPAWillie Williamson1980-02-11—47464656267994 Canyon Rd Apt 10, San Antonio, TX, 782390.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-53759TPADiane Butler1984-02-05—4077191224309 Hillcrest Rd, Charlotte, NC0.52Phone reformattedState name converted to codeZIP missingEmail lower-cased+2 more
TPA-51385TPAHenry T Bishop1969-11-06——1886 Church St, Atlanta, GA0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
TPA-62799TPAWillie Gardner1989-02-19UHC-17309-82—3227 Central Ave, Atlanta, GA, 303880.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-54791TPAKathy Garza1962-07-25——5978 Elm St # 673, San Diego, CA, 921130.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62418TPAWilliam Hamilton1950-11-11—24534299743320 Meadow Ln, Fresno, CA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-60979TPATucker Mei—UHC-96295-4075147223705689 Spring St, Austin, TX, 787920.52Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-55557TPAWilliam Hansen1981-06-28—54167831142079 Jefferson Ave, Austin, TX0.52Phone reformattedState name converted to codeZIP missingGender normalised+2 more
TPA-60808TPAPeter Hill1940-12-17—87645941721619 Central Ave # 869, Tucson, AZ, 857810.52Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
TPA-57666TPAEric Bailey1988-04-01——2012 Mountain View Dr, Atlanta, GA, 303150.52Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-53323TPAHannah Clark1981-05-15——2713 Jefferson Ave, Fresno, CA0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
TPA-54236TPAMegan Reed2005-11-11——8402 Mesa Dr # 666, Sacramento, CA, 958120.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-58877TPABobby Vasquez1987-08-27——776 Sunset Blvd, Atlanta, GA, 303470.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59559TPALaura Bennett1964-02-07—73072011923622 Desert Sky Blvd, Dallas, TX, 752380.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62780TPAMark Wang1989-10-27—93548794051548 River Rd Apt 28, Tempe, AZ, 852350.52Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
TPA-59205TPARussell Bell2006-04-02——2688 Jefferson Ave, Atlanta, GA, 303800.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
TPA-61420TPAEthan Contreras1974-12-03——3510 Grand Ave, Dallas, TX, 752870.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-51780TPAJean M Kelly1954-06-06——5987 Central Ave, Seattle, WA, 981240.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63923TPASophia Gonzales1944-04-12——9811 Ocean Ave, Minneapolis, MN, 554540.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-54007TPALogan Hamilton1972-01-12——7925 Pine Dr, Charlotte, NC0.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-57810TPAAmy Evans1967-05-21—42071419036124 Hillcrest Rd # 556, Orlando, FL, 328850.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-51567TPAJoseph Cunningham1939-09-10—9199684150979 Bayshore Dr, Minneapolis, MN, 554950.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57275TPAMargaret Tucker1993-08-05——3606 Mesa Dr, San Diego, CA, 921460.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-63163TPADensie Lynch1965-06-12—87062804984354 Sunset Blvd, Phoenix, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57935TPADebra Hudson1999-06-22——8828 Union St Apt 14, Atlanta, GA, 303270.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57651TPAMichael Flores2000-05-13—71631718867802 Oak St Apt 14, Charlotte, NC0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-50085TPASahron Patel1955-09-08——400 Washington St, Chandler, AZ, 852070.52Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+2 more
TPA-62448TPADylan King1938-09-20—42764989072534 Market St, Columbus, OH, 432750.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62805TPAPamela Gibsson1956-08-17UHC-70252-36—5051 Willow Ct, Phoenix, AZ, 850760.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-52438TPAAlexis A Johnsson1980-05-11——6585 Church St, Dallas, TX, 752300.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-52439TPAAlexis A Johnsson1980-05-11——6585 Church St, Dallas, TX, 752300.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62590TPACarol Pena1959-05-16UHC-65801-28—656 Maple Ave, Eden Prairie, MN, 553750.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-58173TPASusan Wang2008-01-18——4062 Central Ave # 224, Orlando, FL, 328470.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61598TPAAdam Carlson1990-04-20——2767 Lake View Rd, Denver, CO, 802810.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63938TPALarry Wong2001-10-02——5452 Ridge Rd, Orlando, FL, 328860.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-58375TPAEthan T Mitchell1954-08-17——4533 Valley View Dr Apt 13, Atlanta, GA, 303720.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61957TPALauren Reyes1969-12-25—63245817666923 Main St Apt 21, Las Vegas, NV, 891230.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62240TPACarol Brooks1953-08-03UHC-66153-3921054151313003 Oak St, Dallas, TX, 752660.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50620TPASophia Pierce1973-09-23—47666937776744 Desert Sky Blvd # 732, Glendale, AZ, 853820.52Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
TPA-59777TPAMark Payne1972-10-19——3285 Desert Sky Blvd, Plano, TX, 750870.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60404TPADoris Torres———7807 Sunset Blvd, Phoenix, AZ, 850710.52Name split from “Last, First”Date of birth missingCity re-casedState name converted to code+2 more
TPA-63999TPACarol J Lane1971-04-14—48267301671038 Apache Blvd, Dallas, TX, 752070.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 20 of 290PreviousNext