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-59764TPALawrence Larry1962-08-16——891 Indian School Rd, Glendale, AZ, 853940.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59277TPARyan Li1963-09-10——5648 Elm St, Fresno, CA, 937350.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
TPA-52637TPAMari Daniels1982-10-09——5183 Sunset Blvd, Fresno, CA, 937830.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-56382TPAWalter Murphy1962-03-01UHC-07820-82—3903 Palm Dr, Glendale, AZ, 853150.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-51891TPARaymond H Hanson1990-05-20—71439117753321 Grand Ave, Atlanta, GA, 303880.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
TPA-59519TPARichard Hamilton2001-10-03—21560535284119 Highland Ave Apt 15, Columbus, OH, 432010.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-58295TPANanccy N Morgan1988-01-04——1598 Canyon Rd, Minneapolis, MN0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
TPA-52139TPAAnna Z Long———9582 Jefferson Ave, Orlando, FL, 328330.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64230TPADanielle Herrera1964-01-22——9155 Bayshore Dr, Phoenix, AZ, 850830.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-58135TPATricia P Bennett1940-07-21——8570 Valley View Dr, San Diego, CA, 921310.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-50628TPAJanice Rice1938-12-26—26739628178888 Palm Dr Apt 4, Tucson, AZ, 857480.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-61046TPACarol A Moore1991-02-19——851 Indian School Rd, Atlanta, GA, 303440.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58842TPADaniel Parker1977-04-03——5608 Canyon Rd Apt 7, Tucson, AZ, 857590.66Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55422TPABrian Jordan1996-11-12——3595 Hillcrest Rd # 650, Eden Prairie, MN, 553820.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-60096TPAAnna Vega———7331 Forest Ave, Nashville, TN, 372310.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57917TPAMary Cox1974-07-26——8749 Indian School Rd, Seattle, WA, 981510.66Name re-casedTwo-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
TPA-57916TPAMary Cox1974-07-26——8749 Indian School Rd, Seattle, WA, 981510.66Name re-casedTwo-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
TPA-56349TPAAshley Rios1975-01-01——4034 Ridge Rd # 268, San Diego, CA, 921440.66Name re-casedDate of birth reformattedUnit split from streetState name converted to code+1 more
TPA-60617TPAEdward George1983-06-17——3180 Elm St, Austin, TX, 787420.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-52291TPACarl V Stephens2003-10-16—80193467636387 Forest Ave, Jacksonville, FL0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-62820TPADenise Tran1994-09-08——7545 Spring St, San Antonio, TX, 782640.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-54366TPAStephen McCoy1976-03-10——8878 Market St, Scottsdale, AZ, 852600.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-62343TPANick M Garcia1964-11-11——9584 Hillcrest Rd, Eden Prairie, MN, 553700.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-62568TPATyler Meyer1964-04-20—53890454162469 Harbor Blvd, Mesa, AZ, 852680.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-56581TPASteve Nichols1945-05-04—95525396073615 Sunset Blvd, Los Angeles, CA, 900380.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62203TPAMaadison Taylor1940-07-08UHC-46048-4029379958443153 Oak St, Fresno, CA, 937510.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-51450TPAJames M Espinoza1998-01-19——5887 Central Ave, San Antonio, TX, 782680.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-56502TPAAlice Marquez1978-07-18——664 Oak St, Jacksonville, FL, 322290.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-55839TPAJulia Patel1979-04-13——531 Mountain View Dr, Minneapolis, MN, 554080.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-50308TPADylan B Scott1971-07-22——450 Pine Dr, Houston, TX, 770480.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61117TPALuri Stewart1983-03-27—33821183398167 Desert Sky Blvd, Charlotte, NC0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-55055TPAMichelleJunk1939-03-18——888 Cedar Ln, Tucson, AZ, 857410.66Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
TPA-55293TPAAnn Morgan1979-01-26—82469908034333 Apache Blvd, Chandler, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-61225TPAWilson Denise1987-11-14——420 Hillcrest Rd, San Diego, CA, 921710.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62394TPASharon R Hoffman1974-03-02——342 Baseline Rd, Mesa, AZ, 852090.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-56442TPAJacob Martinez2005-03-05——922 Camelback Rd, Dallas, TX, 752580.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62041TPARandy T Burton1938-03-02UHC-32006-0330156304178838 Market St, Fresno, CA, 937240.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63607TPAMelissa Patterson1982-09-23——6288 Harbor Blvd, Austin, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-62589TPAWalter Knight2002-07-25——7563 Ocean Ave, Fresno, CA, 937850.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-50696TPADouglas Shaw2007-05-05——2059 Valley View Dr, Charlotte, NC, 282850.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-51112TPAEmma A Perez1997-09-25UHC-52568-47—5635 Oak St, Gilbert, AZ, 852410.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
TPA-58684TPAVirginia Black1959-02-23—50741298465876 Desert Sky Blvd, Mesa, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-60340TPARachel H Carr1969-09-16——6128 Central Ave, Seattle, WA, 981650.66Name split from “Last, First”City re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-50144TPAElizabeth Munoz1982-02-13—49768820994165 Willow Ct, Columbus, OH0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-53603TPAMadison W Lopez1970-08-17——3579 Willow Ct, Miami, FL, 331040.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-59800TPANoah Woods1969-10-02——3225 Church St, Glendale, AZ, 853370.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-63762TPAHelen Munoz——65057005917417 Forest Ave Apt 27, San Diego, CA, 921460.68Date of birth unreadablePhone reformattedUnit split from streetPlaceholder values cleared
TPA-62829TPASharon Ruiz1996-02-26UHC-05868-0266688562602788 Washington St, Tampa, FL0.68Name split from “Last, First”Phone reformattedZIP missingPlaceholder values cleared
TPA-52693TPASara Burotn1938-03-28——2589 Canyon Rd, Atlanta, GA, 303280.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-56406TPAMariana Evans1997-10-27——9718 River Rd, Nashville, TN, 372510.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 90 of 290PreviousNext