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-52611TPAChris Nelson1961-09-24UHC-65673-315055761014982 Maple Ave, Houston, TX, 770030.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52180TPALinda James1949-08-16—63361835001598 Park Pl, Fresno, CA, 937840.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54029TPAJimmy S Ruiz1985-06-20——7055 Bayshore Dr # 520, Columbus, OH, 432660.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-58568TPANicole I Barnes1993-01-26——480 Washington St, Nashville, TN, 372880.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55029TPAAna Mendoza1996-01-08—91882060652269 Bayshore Dr, Seattle, WA, 981620.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55504TPADonnaJunk1975-08-12—83393357338277 Camelback Rd, Tempe, AZ, 852370.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63947TPALarry Fowler1954-06-14——7770 Mountain View Dr, Seattle, WA, 981070.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53671TPANicholas Obrien1958-09-02——4628 Sunset Blvd Apt 9, Las Vegas, NV, 891250.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-52428TPAMariana Sanders1991-09-09—81172235212727 Willow Ct, Tempe, AZ0.62Name re-casedPhone reformattedZIP missingEmail lower-cased+3 more
TPA-59088TPASandra W Owens1972-03-03—48852781527000 Harbor Blvd, Chandler, AZ, 852710.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55850TPAFrank Alexander1999-12-26—79450346762263 Washington St, Phoenix, AZ, 850220.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52813TPAElijah West1967-12-05—53992641641172 Mesa Dr, Tampa, FL, 336580.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58259TPACynthia Yang1951-06-03——4626 Spring St, Chandler, AZ, 852890.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51917TPABarbara Collins2001-11-01——7634 Pine Dr, Eden Prairie, MN, 553710.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59177TPAChristine Simmons1969-07-11—86575417045236 Cedar Ln, Mesa, AZ, 852810.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58121TPAEvelyn Rodriguez1963-06-17—97693762829796 Union St, Fresno, CA, 937650.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-62744TPAArjun Lopez1968-03-16—34479708893719 Baseline Rd, Charlotte, NC, 282860.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53487TPARichard Allen1992-07-27—79741520003888 Mountain View Dr, Scottsdale, AZ, 852650.62Name re-casedStreet suffix standardisedAddress re-casedGender normalised+3 more
TPA-57740TPAHannah V Bradley1967-01-01—64746761527774 Oak St, Los Angeles, CA0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59569TPABradley Mendoza1988-06-16——2384 Church St, Charlotte, NC, 282450.62Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more
TPA-58195TPALawrence Alvarado1956-02-11UHC-24233-9584781938828480 Valley View Dr, Minneapolis, MN, 554940.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62250TPADaniel Thompson1954-07-13——3387 Baseline Rd, Las Vegas, NV0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58508TPAMaria Oliver1982-04-02——8314 Willow Ct, Miami, FL, 331380.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57544TPALroi Meyer1993-05-01——8137 Highland Ave, Scottsdale, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59838TPAJack F Garza1966-10-12UHC-71666-675512424663363 Bayshore Dr Apt 18, Las Vegas, NV, 891780.62Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more
TPA-55297TPAJarry Y Price1957-10-17—4324037551563 Desert Sky Blvd, Glendale, AZ, 853400.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57924TPAAndrew L Simmons1996-11-15—40386888291958 Valley View Dr, Denver, CO, 802410.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-63038TPAPeter Patterson2005-03-14UHC-20937-46—6888 Oak St, Eden Prairie, MN, 553890.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53367TPAChristian Porter1976-04-05——7314 Valley View Dr, Los Angeles, CA, 900910.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56265TPADonna Howard1944-07-27UHC-14213-4632862224345111 Bayshore Dr Apt 37, Tampa, FL, 336750.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-53199TPASctot Simmons1976-01-09—87689321582254 Lake View Rd, Mesa, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59747TPAMichael Webb1984-07-09—63661999935189 Camelback Rd, Tucson, AZ0.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-53128TPA—Junk1969-11-13——1139 Willow Ct # 661, Mesa, AZ, 852540.62Unit split from streetCity re-casedState code upper-casedEmail lower-cased+3 more
TPA-52610TPAMadison Gray1978-01-25UHC-81442-5328397979521612 Baseline Rd, San Antonio, TX, 782310.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57051TPAKathryn Peterson1958-11-23—2235735208595 Church St, Charlotte, NC, 282340.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51140TPAAlice Taylor1950-12-28—68185594768487 Lake View Rd, Tucson, AZ, 857640.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-62643TPANancy G Harvey1994-03-19—24373229284513 Palm Dr, San Diego, CA, 921690.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51516TPASarah Welch1949-09-22——8987 Sage Ct, Phoenix, AZ, 850720.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55188TPAEthan Kennedy2000-09-12—35594992142663 Hillcrest Rd, Mesa, AZ, 852970.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54288TPARaymond Payne1967-06-01—38084789377626 Broadway, Denver, CO0.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
TPA-62873TPAJuan Murray1960-12-26UHC-76789-1039226794009062 Park Pl, Gilbert, AZ, 852630.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56572TPAEmma Weaver———5025 Lincoln Way, Jacksonville, FL, 322650.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-55817TPAAna L Boyd1955-12-23UHC-37481-63—8426 Central Ave, Mesa, AZ, 852950.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-54838TPABarbara Espinoza2001-10-25——4396 Valley View Dr, Tempe, AZ, 852240.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54868TPAAisha G Barnes1986-05-05—20829162326083 Main St # 373, San Diego, CA, 921630.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-57443TPARichard Grant1946-12-07UHC-86197-76—7735 Market St # 999, Houston, TX, 770890.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-56385TPAKathryn Chavez1983-04-09—49156812778913 Jefferson Ave # 789, Minneapolis, MN, 554540.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-60912TPAJoseph Olson1951-01-23UHC-17116-8145544624538346 Desert Sky Blvd, San Diego, CA, 921150.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-56646TPADaniel Jacckson1951-11-21—88173435799136 Baseline Rd, Denver, CO, 802420.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63299TPAJennifer George1999-11-04——2137 Sage Ct, Seattle, WA, 981920.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
14,474 rows, page 45 of 290PreviousNext