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-50258TPAAnthony Nunez1991-07-06——6925 Lake View Rd, Chandler, AZ, 852050.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-62260TPACamila Parker1957-05-01——4559 Bayshore Dr Apt 13, Chandler, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-51820TPADebra Lawson1939-08-19—98042912476946 Market St, Dallas, TX, 752700.54Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+1 more
TPA-54773TPADanielle Reid1999-03-23—53291083101276 Baseline Rd, Seattle, WA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-52141TPADiana Henry———9167 Camelback Rd, Eden Prairie, MN0.54Name split from “Last, First”Date of birth unreadableState code upper-casedZIP missing+1 more
TPA-60678TPAJulie Arnold1981-09-06——9290 Oak St, Tempe, AZ, 852610.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-57097TPAAmanda I Hayes1991-04-02—44151561895103 River Rd, Denver, CO, 802040.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
TPA-58530TPAOrtega Raymond———6056 Valley View Dr, Chandler, AZ, 852630.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-52771TPAMichelle Garza1964-01-08UHC-34895-65—6394 Indian School Rd, Tucson, AZ0.54Name re-casedPhone missing area codeZIP missingGender normalised+1 more
TPA-53971TPACarlos Nguyen1985-03-23UHC-33573-55—4442 Desert Sky Blvd Apt 30, San Antonio, TX, 782850.54Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-51732TPABrenda Ramos1979-01-12——4632 Spring St, Tampa, FL, 336590.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-54890TPACamila Jones2007-03-06——4149 Bayshore Dr, Tampa, FL, 336330.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
TPA-56352TPADouglas Mendez1947-12-11UHC-96845-13—5921 Washington St, Miami, FL, 331880.54Two-digit birth yearState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
TPA-58558TPADiane Schmidt1938-12-10——2641 Broadway, Miami, FL, 331660.54State name converted to codeZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-58823TPASteen Turner1940-04-27——7023 River Rd, Gilbert, AZ0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
TPA-63430TPAOmar V Fisher1995-03-19——8386 Ocean Ave, Las Vegas, NV0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-56464TPASusan Carr2005-06-19——8577 Spring St # 747, Charlotte, NC, 282630.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-63098TPAAmber Delgado1972-11-06——1854 Union St, Seattle, WA, 981500.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-59076TPANicholas V Campbell2004-08-21——5205 Elm St, Scottsdale, AZ, 852020.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-53590TPAAustin Tucker2003-03-02—87855712336741 Cedar Ln, Tampa, FL0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
TPA-59062TPACarlos S Schmidt1942-01-28—6087291157886 Ridge Rd Apt 3, Atlanta, GA0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-55323TPAGrace Sandoval———9578 Camelback Rd, Columbus, OH, 432450.54Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-64319TPADouglas Lukas1944-09-12—78370589632791 Forest Ave, Las Vegas, NV, 891770.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
TPA-59511TPAVictoria Barnes2003-11-26——1900 Ocean Ave, Charlotte, NC, 282510.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-52691TPAHanneh Green1981-12-16——9332 Camelback Rd, Dallas, TX, 752930.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-50209TPAJudith Ortiz1981-01-05——9287 Camelback Rd, Gilbert, AZ, 852160.54Name split from “Last, First”Date of birth reformattedPhone missing area codeGender normalised+1 more
TPA-50210TPAJudith Ortiz1981-01-05——9287 Camelback Rd, Gilbert, AZ, 852160.54Name split from “Last, First”Date of birth reformattedPhone missing area codeGender normalised+1 more
TPA-52932TPABradley Rodriguez1959-01-01——682 Pine Dr, Las Vegas, NV, 891940.54Name re-casedTwo-digit birth yearPhone missing area codeState name converted to code+1 more
TPA-61093TPAKelly Baker1953-02-17———0.54Name split from “Last, First”Two-digit birth yearEmail lower-casedGender normalised+1 more
TPA-59038TPALinda B McDonald1980-04-09——6056 Highland Ave, Atlanta, GA, 303850.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
TPA-62756TPAAisha Hudson1969-07-28—35159303067330 Sunset Blvd # 237, Tucson, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-62755TPAAisha Hudson1969-07-28—35159303067330 Sunset Blvd # 237, Tucson, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-62865TPARoy Wood1950-08-01—76557545815991 Church St # 616, Sacramento, CA, 958810.54Name split from “Last, First”Phone reformattedUnit split from streetGender normalised+1 more
TPA-55633TPABrian Burke1995-01-24——6480 Valley View Dr, Austin, TX, 787760.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-63700TPAFatima Price1945-11-18——3822 Lincoln Way, San Diego, CA, 921740.54State name converted to codeZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-61318TPALarry Grant1947-01-22UHC-85640-98—5685 Washington St, Austin, TX, 787850.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
TPA-58826TPAGloria Torres1991-11-21——156 Sunset Blvd # 548, Charlotte, NC, 282680.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-54848TPANicole Sandoval1956-12-15—65743447855628 Ridge Rd, Atlanta, GA, 303160.54Two-digit birth yearPhone reformattedState name converted to codeZIP+4 trimmed+1 more
TPA-58087TPAMelissa Peters1963-11-08—30292776971103 Forest Ave # 117, Eden Prairie, MN, 553860.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-50922TPAAshley Turner1982-08-20UHC-15343-73—7867 Elm St, Atlanta, GA, 303900.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-61426TPAJuhn Dean1983-06-25——2971 Broadway, Fresno, CA, 937000.54Name split from “Last, First”Date of birth reformattedState name converted to codeGender normalised+1 more
TPA-62754TPAStephen Schmidt1939-11-16——8679 Grand Ave # 319, Tampa, FL, 336680.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-52029TPAAlexander Allen1972-06-07——6316 Spring St, Tucson, AZ, 857130.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-57846TPAWei Shaw1947-06-24——5446 Market St, Plano, TX0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-63824TPABrittany Jenkins1948-10-02—84557394594783 Ocean Ave, Charlotte, NC, 282730.54Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+1 more
TPA-53533TPAJoe Coleman1952-07-16—21361320675241 Cedar Ln, Mesa, AZ0.54Two-digit birth yearPhone reformattedState name converted to codeZIP missing+1 more
TPA-59596TPAKatherine Wilson1991-03-22——9140 Union St, Nashville, TN, 372720.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-51804TPAChritsina Austin1968-05-12——1879 Forest Ave Apt 39, Orlando, FL, 328800.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-61706TPAThomas Sims1971-03-19——4750 Grand Ave Apt 26, Orlando, FL, 328980.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-54471TPADanielle Bell1959-12-08——7586 Spring St, Orlando, FL, 328070.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
14,474 rows, page 27 of 290PreviousNext