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-59754TPAJoyce K Reynolds1963-10-28——3813 Harbor Blvd, Sacramento, CA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-63561TPAVirginia Simmons1960-12-20——4459 Canyon Rd, Minneapolis, MN, 554070.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-62912TPADavid Mason1997-04-19—47167760728973 Cedar Ln, Seattle, WA, 981810.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59842TPAAndrew Carr1974-06-15——1806 Church St, Houston, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
TPA-58813TPATerry Rodriguez1984-06-25——7763 Mountain View Dr, Gilbert, AZ, 852640.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-64065TPALisa White1939-07-16——6103 Hillcrest Rd, Tucson, AZ, 857680.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-64066TPALisa White1939-07-16——6103 Hillcrest Rd, Tucson, AZ, 857680.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-53094TPASantiago Lewis1973-11-02——1083 Sage Ct, Fresno, CA, 937760.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60968TPAKenneth West1989-04-08——8925 Pine Dr, Austin, TX0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
TPA-60967TPAKenneth West1989-04-08——8925 Pine Dr, Austin, TX0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
TPA-60849TPAAmy Collins1970-09-28——4997 Maple Ave # 315, Minneapolis, MN, 554930.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61958TPASofia U Andrews1996-02-17——377 Spring St # 447, Charlotte, NC, 282180.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-55086TPARachel Harrison1956-09-25——5938 Cedar Ln, Eden Prairie, MN, 553660.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-52041TPAKeith Hall1966-04-03——1725 Cedar Ln # 423, Dallas, TX, 752430.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56485TPATyler Jones1946-04-21——4500 Indian School Rd, Phoenix, AZ, 850690.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60389TPAPatrick Knight1978-08-19——4240 Indian School Rd, Plano, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-55047TPATerry N Arnold1952-02-27——5298 Elm St, Sacramento, CA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-63449TPARalph Phillips1983-08-09——6178 Park Pl, Austin, TX, 787120.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-61097TPAAmber Lawson1989-08-18——6226 Indian School Rd, Orlando, FL, 328720.52Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-58059TPAEvelyn Evans1988-03-04——549 Grand Ave, Gilbert, AZ, 852490.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-58258TPAAisha Snyder1967-03-11——7756 Hillcrest Rd, Atlanta, GA0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
TPA-51701TPAMargaret Kelley———6289 Jefferson Ave, Las Vegas, NV, 891380.52Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-57171TPAValentina Harvey1979-04-11——3650 River Rd, Austin, TX, 787590.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-63705TPAMadison Spencer1973-01-18—94899719188387 River Rd, Denver, CO0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62607TPAMichael Johnston1994-08-25——9651 Ocean Ave, Charlotte, NC, 282510.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-58647TPACarolyn Gordn1956-11-16UHC-62649-12—5433 Desert Sky Blvd, Scottsdale, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-51736TPADiana Russell1999-01-05——3778 Apache Blvd, Tempe, AZ, 852280.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-59407TPAJeffrey X Prk1938-06-15——5894 Pine Dr, Chandler, AZ0.52Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
TPA-53833TPARandy Thompson1994-11-20——4277 Elm St, Houston, TX, 770810.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55887TPAEric Jenkinns2004-02-27—40142514838967 Pine Dr, Nashville, TN0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59387TPALarry Bradley2001-10-13——3299 Pine Dr, Eden Prairie, MN, 553910.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57875TPAAndrea Carter1968-01-14——589 Bayshore Dr, Houston, TX, 770820.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-51518TPABetty Carlson1976-12-24——3306 River Rd, Seattle, WA, 981350.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61568TPABarbara Dunn2007-01-04UHC-34994-98—8620 Cedar Ln, Miami, FL, 331980.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-58589TPACarolyn Ortiz1983-01-27——4744 Cedar Ln, Miami, FL, 331790.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-64470TPAWayne Simmons———2699 Ocean Ave Apt 3, Seattle, WA, 981480.52Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+2 more
TPA-61374TPAJoan Soto1981-05-17——1004 Apache Blvd Apt 14, Los Angeles, CA, 900000.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-55327TPAHirohsi Hanson1939-12-11——6791 Baseline Rd, Minneapolis, MN, 554250.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-56677TPAPaul Garza1980-09-17——9746 Forest Ave, Austin, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61520TPASamantha Wang1995-09-10——570 Ridge Rd, Charlotte, NC, 282020.52Name split from “Last, First”Date of birth reformattedState name converted to codeGender normalised+2 more
TPA-52646TPAHarold Carr1978-01-16——7475 Pine Dr, Denver, CO, 802470.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-50837TPAKyle Z Phillips1964-08-19——4114 Cedar Ln, Chandler, AZ0.52Name re-casedTwo-digit birth yearZIP missingGender normalised+2 more
TPA-51163TPACarl George1959-08-09——2222 Oak St, Tucson, AZ, 857390.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-61307TPAMason McDonaald1974-03-23UHC-56620-7986895198162651 Mountain View Dr, Glendale, AZ0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58643TPADennis Bowman2001-08-12UHC-53395-8087663622454292 Market St Apt 8, Charlotte, NC, 282580.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54871TPAElijah Sullivan1941-04-26—34959929447717 Lake View Rd, Eden Prairie, MN, 553730.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58356TPABradley Soto1989-06-17——4949 Lake View Rd, Los Angeles, CA, 900930.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-64228TPALisa Graham1951-12-26——4093 Ridge Rd, Tampa, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-52868TPALinda Myers1975-11-06—24658365218146 Church St, Phoenix, AZ, 850390.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-58815TPAJeremy A Roberts1994-12-02——9863 Sage Ct, Columbus, OH0.52Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
14,474 rows, page 22 of 290PreviousNext