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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-110731ENRKelly Park1961-01-15UHC-03415-6350060410131235 Camelback Rd # 977, Dallas, TX, 752310.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432558CLMMariana Henderson1986-11-02UHC-16259-95—8672 Highland Ave, Orlando, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-429299CLMArthur Smith1975-09-02—87726361787230 Harbor Blvd Apt 23, Nashville, TN, 372020.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-126354ENRPriya H McDonald1965-08-04UHC-72612-4469663634855136 Apache Blvd, Tempe, AZ0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-427978CLMRuth Jones1983-03-16UHC-19292-4143799211225065 Sage Ct, Fresno, CA, 937200.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140839ENRAlexis B Murray1990-12-15UHC-07375-7758080168735747 Camelback Rd, San Diego, CA, 921310.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121674ENRAan C Scott1949-04-18UHC-37761-0366647921257774 Forest Ave, Chandler, AZ, 852820.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-140642ENRKayla Fowler1995-02-26UHC-42064-1354459476872690 Willow Ct Apt 13, Gilbert, AZ, 852840.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62453TPASamantha Riely1965-12-27——5302 Hillcrest Rd, Orlando, FL, 328280.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406287CLMIsabella Carrr1960-06-13UHC-32279-06—1829 Mountain View Dr Apt 17, Phoenix, AZ, 850080.52Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+2 more
ENR-141744ENRJlie M Schultz1939-07-02UHC-27359-582414707208415 Pine Dr, Austin, TX, 787390.52Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
ENR-125990ENREvelynJunk1943-05-11UHC-35484-1854836913404609 Desert Sky Blvd, Tempe, AZ, 852130.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-128568ENRLarry N Hanson1959-07-28UHC-36825-92—5391 Mountain View Dr, Seattle, WA, 981330.52Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
ENR-139810ENRTyler F Baker—UHC-11302-8238188001884303 Elm St, Glendale, AZ, 853680.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-418270CLMKenneth Sims1999-06-16UHC-30731-182473060141392 Indian School Rd, Phoenix, AZ, 850960.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-52470TPALarry Jackson1943-03-16UHC-86916-4191789403019602 Church St, Seattle, WA, 981240.52Phone reformattedSSN last four extractedZIP+4 trimmedGender normalised+2 more
CLM-423697CLMRonald West—UHC-21226-6934990132551699 Union St, Minneapolis, MN, 554670.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420054CLMTeresa Snyder2006-03-14UHC-84654-02—750 Church St, Chandler, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-407067CLMMariana Roberts1979-06-21UHC-18824-99—3135 Market St # 785, San Diego, CA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-110840ENRJulia U Carroll1972-07-10UHC-35780-708312837561—0.52Name split from “Last, First”Two-digit birth yearPhone reformattedEmail lower-cased+2 more
ENR-119504ENRLucia Smith1998-06-16UHC-11040-64—2181 Forest Ave, Houston, TX, 770070.52Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+2 more
ENR-100644ENRGrace A Taylor1971-09-23—41541491727577 Camelback Rd, Atlanta, GA, 303390.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103276ENRAmanda K McDonald1959-05-10UHC-18011-8966443906052036 Indian School Rd Apt 28, Seattle, WA, 981060.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-424207CLMLinda S Wong1986-02-05—61428967882390 Apache Blvd, Tampa, FL, 336810.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-135465ENRCarol S Jamas1962-09-01UHC-43610-588942674287444 Park Pl, Eden Prairie, MN0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29191PRVGerald Gardner——86487055542107 Willow Ct, San Antonio, TX0.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-426897CLMSteve P Lawrence1974-12-08——5363 Park Pl Apt 38, Plano, TX, 750870.52Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
CLM-423107CLMRaymond Collins1971-03-26—35349012446254 Forest Ave, Seattle, WA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-104590ENRPatrick M Weaver—UHC-07386-91—8123 Elm St, Fresno, CA, 937290.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59046TPABeverly Chapman1975-07-20——2771 Lake View Rd, Las Vegas, NV, 891800.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-140151ENRNancy O Carpenter1980-06-07UHC-82726-7765966438537629 Ocean Ave, Dallas, TX, 752460.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26718PRVAhmed Castillo1996-09-28UHC-03994-9392952623765587 Meadow Ln, Sacramento, CA, 958070.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-426178CLMJose Jordan1947-12-06UHC-22708-9256280540752093 Oak St, Dallas, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-119817ENRPaul G Bishop1984-08-28UHC-76605-0639432165051665 Lincoln Way, Dallas, TX0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117141ENRCarlos Myers1958-01-13UHC-75972-29—302 Bayshore Dr Apt 5, Las Vegas, NV, 891010.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-55673TPAAmy Dominguez1976-03-19UHC-21901-22—2826 Union St, Sacramento, CA, 958850.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-51865TPAGary Welch1940-12-20——1042 Church St, Tampa, FL, 336210.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-123006ENRAlice Harper1979-06-01UHC-67117-89—6995 Meadow Ln, Plano, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413262CLMEdward Alvarez1948-01-05UHC-92725-8887861784849770 Highland Ave, Fresno, CA0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119987ENRMatthews Lori2000-11-13UHC-03231-10—6793 Market St, Mesa, AZ, 852180.52Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+2 more
CLM-415799CLMAlan Ramos———3586 Bayshore Dr, Chandler, AZ, 852550.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-133252ENRJerry G Sanchez1988-09-27UHC-29270-333656995693322 Meadow Ln, Denver, CO, 802400.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-135325ENRCarolyn Williamson1948-01-27UHC-33058-2262768777521659 Hillcrest Rd, Eden Prairie, MN, 553130.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-100678ENRRoy Butler—UHC-98340-5028568955789411 Desert Sky Blvd, Glendale, AZ, 853100.52Name split from “Last, First”Date of birth missingPhone reformattedMember ID reformatted+2 more
TPA-57913TPAAnn Ford1943-01-09——3659 Ridge Rd, Houston, TX, 770810.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-142459ENRRoy Hudson—UHC-66699-3059786388736067 Mountain View Dr, Scottsdale, AZ, 852320.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414916CLMAndrea Pena2004-03-16——5974 Grand Ave # 240, Nashville, TN, 372840.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426899CLMEthan Rogers1938-12-18——1672 Spring St, San Antonio, TX, 782510.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-126089ENRBrian Hart1971-08-20—63851265691729 Highland Ave, San Antonio, TX0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-121535ENRSean W Estrada1976-12-02UHC-36955-3667585540426902 Washington St, Atlanta, GA0.52Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more
100,000 rows, page 150 of 2,000PreviousNext