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-54214TPADonna Coleman1924-10-15—62450652447430 Palm Dr, Sacramento, CA, 958480.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52303TPAMegan Watkins1997-10-10UHC-36574-7220867083432995 Mountain View Dr, San Diego, CA, 921320.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51819TPAWilliam N Garrett1993-12-01UHC-62739-0563184310225433 Oak St, San Antonio, TX, 782600.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-63842TPACarl Sims1963-06-26——3056 Indian School Rd, Tucson, AZ, 857810.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-61209TPAIsabella Rede1960-09-07——7712 Jefferson Ave, Tempe, AZ, 852120.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51894TPASantiago Ferguson1966-03-12UHC-76518-547278331495733 Spring St, Los Angeles, CA, 900890.64Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+2 more
TPA-51347TPANoah Wilson1942-07-12—48198408151183 Spring St, Nashville, TN, 372750.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-59529TPAMarc Bell1956-07-02—56355974144720 Park Pl, Dallas, TX, 752370.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
TPA-52406TPAGabriel Lawson1967-09-01—25823762282751 Union St, Eden Prairie, MN, 553010.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-63986TPAAlice Sullivan1994-08-01—54348933079252 Jefferson Ave, Gilbert, AZ, 852750.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56088TPAKyle Medina1968-03-11—72536302717906 Ridge Rd, San Diego, CA, 921490.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63096TPAWalter Nelson1983-03-25——3472 Cedar Ln, Jacksonville, FL, 322640.64Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+2 more
TPA-61948TPAAngela Ellis1999-03-03——9680 Hillcrest Rd, Phoenix, AZ, 850540.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58478TPAJeffrey Lane1941-09-24——3740 Mesa Dr, Tucson, AZ, 857910.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54022TPASam Spencer1959-02-23——1630 Lake View Rd, Dallas, TX, 752020.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53344TPABradley Morales1961-10-24UHC-19703-3830626028194309 Canyon Rd Apt 30, Scottsdale, AZ, 852310.64Phone reformattedUnit split from streetState name converted to codeEmail lower-cased+2 more
TPA-58051TPAAbigali Lawrence1988-07-20UHC-25880-454909450445—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
TPA-62273TPAWei Little1973-07-25UHC-16840-90—3110 Jefferson Ave, Phoenix, AZ, 850840.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-58758TPASusan J Rogers1959-01-02——393 Park Pl, Miami, FL, 331320.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51681TPAAndrea Brown1977-01-22——2828 Desert Sky Blvd, San Diego, CA, 921050.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-51557TPAAlan Henderson1996-06-16—94292989626293 Canyon Rd, San Antonio, TX, 782850.64Phone reformattedCity re-casedZIP+4 trimmedGender normalised+2 more
TPA-59997TPAAndrea Gomez1987-10-27—73458696319419 Sunset Blvd, Tucson, AZ, 857620.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57602TPAGeorge Webb1956-10-25—40896732818325 Park Pl, Dallas, TX, 752000.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54078TPAOlivia Gibson1956-06-01—32172018557786 Highland Ave, Plano, TX, 750760.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-50948TPAStephen E Mason1949-01-20UHC-11372-10—5037 Ocean Ave, Columbus, OH, 432240.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59962TPARichard Bennett1991-07-15——7321 River Rd, Tempe, AZ, 852650.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-51119TPALuis Vega1938-07-28—89842596192560 Ocean Ave Apt 38, Minneapolis, MN, 554580.64Name re-casedDate of birth reformattedUnit split from streetZIP+4 trimmed+2 more
TPA-57132TPACarl Q Wang1944-04-05——8827 River Rd, Orlando, FL, 328000.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-51813TPAMei Mroris1961-01-21UHC-84477-9772349832234799 Central Ave, Sacramento, CA, 958600.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59487TPANatalie Johnson1968-10-03——3759 Forest Ave, Mesa, AZ, 852120.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-61141TPARussell Powell1943-08-05——259 Union St, Miami, FL, 331680.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-57433TPASophia Watkins1947-12-21——3945 Meadow Ln, Seattle, WA, 981730.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-55171TPAMelissa J Jordan1981-10-21——1628 Central Ave Apt 9, Mesa, AZ, 852350.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
TPA-51869TPAAndrea Vazquez1978-06-12——8128 Park Pl, Sacramento, CA, 958250.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-62759TPADiane George———6546 Spring St, Houston, TX, 770770.64Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-64162TPAJeff Warren2001-02-27—64642978285097 Mountain View Dr Apt 1, Minneapolis, MN, 554640.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61573TPAAnna Payne1966-11-27—44089770653257 Market St, Austin, TX, 787860.64Name re-casedPhone reformattedSSN last four extractedState name converted to code+2 more
TPA-52734TPAJennifer S Cook1997-09-14——4635 Camelback Rd # 957, Orlando, FL, 328600.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-54199TPACarol Howell1942-02-16—43359362427900 Mesa Dr, Glendale, AZ, 853400.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56103TPAMargaret Hut1941-10-25——8780 Camelback Rd, Denver, CO, 802650.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61126TPALopez Jesse1960-09-09——3141 Apache Blvd, Las Vegas, NV, 891230.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
TPA-54878TPADavid Harvey1944-12-03——9718 Harbor Blvd # 891, Denver, CO, 802180.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-54927TPAIsabella Jimenez1993-02-04—37362678136914 Mesa Dr # 405, Minneapolis, MN, 554700.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-61986TPASantiago Sandoval1958-10-12——8497 Camelback Rd, San Antonio, TX, 782130.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57130TPAAndrea X Collins1994-03-03——4578 Market St, Sacramento, CA0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54358TPAHerny Espinoza1959-07-26—35467014321745 Church St, Austin, TX, 787950.64Name split from “Last, First”Phone reformattedState code upper-casedGender normalised+2 more
TPA-57883TPAAndrea Hanson1971-11-09——8510 Camelback Rd, Plano, TX, 750120.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62012TPAKayla Vazquez1948-06-13—94771326382691 Indian School Rd, Columbus, OH, 432140.64Name split from “Last, First”Phone reformattedEmail lower-casedGender normalised+2 more
TPA-50466TPAHarold Lawsoon2007-10-22——4766 Bayshore Dr, San Antonio, TX, 782910.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62917TPASophia Mendoza2002-02-04——2611 Lake View Rd, Gilbert, AZ, 852350.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 62 of 290PreviousNext