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-52096TPAAlice G Perry1943-04-24UHC-53984-3520967149019138 Harbor Blvd, Denver, CO, 802190.64Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
TPA-55177TPAOmar Simpson1999-11-26——7949 Central Ave, Charlotte, NC, 282730.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
TPA-64091TPACharles U Jordan1963-03-19UHC-52017-51—9327 Pine Dr, Las Vegas, NV, 891680.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59480TPABeverly Taylor1952-11-03UHC-23926-10—294 Market St, Fresno, CA, 937900.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-58770TPABrian Walsh1969-11-11—83358838138536 Union St, Tucson, AZ, 857330.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56163TPALuis Waler1980-06-17—67054913229567 Canyon Rd, Seattle, WA, 981550.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52331TPAChristine Hicks1996-10-24——4361 Canyon Rd, Scottsdale, AZ, 852770.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-52017TPALarry Barnes1983-06-16—34046357827235 Washington St, Las Vegas, NV, 891820.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58276TPADieggo Franklin1984-03-24——8107 Jefferson Ave, Miami, FL0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54216TPADanielle Torrees—UHC-36695-308558324572—0.64Date of birth missingPhone reformattedGender normalisedPlan code upper-cased+2 more
TPA-54062TPABradley Reynolds1960-03-11—72879815203365 Elm St # 847, San Antonio, TX, 782110.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-52207TPAAnna Martin1966-05-02UHC-56138-06—766 Park Pl, Chandler, AZ, 852610.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61692TPARebecca Dixon1938-04-13——8865 Maple Ave, Eden Prairie, MN, 553870.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63471TPAOmar Espinoza2006-08-05——9085 Baseline Rd, Chandler, AZ, 852530.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64295TPABeverly K Carlson1981-05-25—33727374877248 Grand Ave, Austin, TX, 787470.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57794TPABrittany Romero—UHC-16853-4352893860551928 Maple Ave, Austin, TX0.64Date of birth unreadablePhone reformattedZIP missingEmail lower-cased+2 more
TPA-55811TPAMatthew S Medina1961-09-14—64427521679132 Spring St, Houston, TX, 770610.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59594TPAMartha Morgan1992-06-22——9387 Elm St, Denver, CO, 802490.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56775TPALawrence Richards1964-11-21——6040 Main St, Columbus, OH0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-61293TPACharles Morales1996-07-06—88436962641061 Mesa Dr, Charlotte, NC, 282440.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-64419TPARoger Knight1977-11-15——6386 River Rd, Chandler, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-50137TPAPhilip N Le1980-02-05—40162381176056 Union St, San Diego, CA, 921120.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-61054TPACaamila McDonald1988-10-08——2173 Ocean Ave, Houston, TX, 770130.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59670TPAEddie Sancez1951-09-13—92258852929732 Market St, Nashville, TN, 372680.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59245TPAMari X Rivera1989-09-25——6492 River Rd # 541, Glendale, AZ, 853530.64Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-53117TPAChristian Yang1945-08-01——8005 Willow Ct, Austin, TX, 787850.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-59932TPALawrence M Gonzalez1989-09-19—31140868874187 Spring St, Phoenix, AZ, 850360.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62159TPAElizabeth Taylor———9091 Forest Ave, Gilbert, AZ, 852370.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
TPA-58715TPAOlivia Fuller2000-11-15UHC-49543-7159372643663435 Ridge Rd, Plano, TX, 750790.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55617TPAEmily Murray1992-02-20UHC-96474-99—8357 Spring St # 750, Charlotte, NC, 282930.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61631TPABrittany Walsh1984-05-09UHC-72666-02—6263 Forest Ave, Denver, CO, 802200.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56039TPAPamela Gutierrez2005-08-08——6224 Meadow Ln, Las Vegas, NV, 891910.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51882TPADaniel Fuller1953-01-25—88289323495148 Mesa Dr, Austin, TX, 787560.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-59377TPAPaul Payne1949-06-04—38153527331440 Mesa Dr, Eden Prairie, MN0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63615TPAAndrea Harrison1956-06-22UHC-14709-75—1180 Meadow Ln, Phoenix, AZ, 850540.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-53916TPAAmanda Ortiz1971-11-28——9163 Desert Sky Blvd, Atlanta, GA, 303610.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-53820TPAJudith I Black1993-05-25——198 Ridge Rd, Seattle, WA, 981820.64Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+2 more
TPA-62570TPAGeorge Munoz1969-01-10——918 Sunset Blvd, San Diego, CA, 921700.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
TPA-55631TPAJutin Jenkins2001-04-23UHC-39390-6378031434922202 Harbor Blvd, Dallas, TX, 752770.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59362TPAHelen Guerrero1991-08-23—76428525613231 Baseline Rd, Glendale, AZ, 853290.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-57680TPAJeremy Austin1956-05-06—51554252071708 Apache Blvd, Minneapolis, MN, 554410.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63832TPAJack Jordan1967-12-26—81236203547965 Washington St, Houston, TX, 770070.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59936TPAThomas Day1944-02-21——1025 Mesa Dr, Miami, FL, 331710.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60108TPAAshley Castro1952-07-15UHC-81991-6352067889362511 Camelback Rd, Denver, CO, 802650.64Name re-casedPhone reformattedZIP+4 trimmedGender normalised+2 more
TPA-56676TPAIsabella Robertson1985-02-04——1814 Jefferson Ave, Houston, TX, 770580.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-58002TPAAisha Padilla1998-08-02——1443 Camelback Rd, Atlanta, GA, 303180.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58605TPAGabriel Ward1943-02-02—3307013173998 Pine Dr, San Antonio, TX, 782500.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53888TPABruce Perkins1968-04-02—38195979537248 Grand Ave, Jacksonville, FL, 322570.64Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-63452TPASandra N Reynolds1971-06-18—47930725645740 Indian School Rd, Scottsdale, AZ, 852290.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-53151TPARalph Perry1979-12-08UHC-71340-83—9310 Lake View Rd, Jacksonville, FL, 322470.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
14,474 rows, page 60 of 290PreviousNext