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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-58072TPALawrence Lane2006-08-09—95023983032237 Camelback Rd, Los Angeles, CA, 900830.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61982TPAAndrew B Henderson1965-07-01UHC-57798-24—5559 Maple Ave, Gilbert, AZ, 852260.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-60940TPABenjamin Henry———6289 Desert Sky Blvd, Plano, TX, 750930.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60128TPAJoseph Young1950-05-13——8157 Highland Ave, Scottsdale, AZ, 852450.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-63642TPADennis Brrown1944-05-22——5143 Cedar Ln, Minneapolis, MN, 554470.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56026TPAAlexis Stephens1946-11-14——7276 Harbor Blvd, Denver, CO, 802950.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59069TPAElizabeth Daniels1976-05-23——605 Lincoln Way, Austin, TX, 787510.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56656TPAGrace Jenkins1998-10-08——4259 Sage Ct, Tampa, FL, 336080.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-52167TPARob Craford2006-02-15UHC-52692-57—4891 Meadow Ln, Sacramento, CA, 958370.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-50726TPAAhmed K Hart1960-03-01——4445 Jefferson Ave, Los Angeles, CA, 900390.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61085TPASara Hoffman1944-11-21UHC-72647-57—4871 Forest Ave, Fresno, CA, 937920.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-54008TPASteven Johnson———5694 Union St, Chandler, AZ, 852440.68Date of birth missingZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-60946TPAJoe Weaver1989-10-27——7990 Jefferson Ave, San Antonio, TX, 782450.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-53594TPAAna Richards2001-02-07——6758 Grand Ave # 689, Seattle, WA, 981310.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56824TPAOlivia K Perez1963-04-16——1737 Union St, Tampa, FL, 336890.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63325TPARonald Thomas1999-03-07——700 Grand Ave Apt 11, Los Angeles, CA, 900540.68Unit split from streetCity re-casedZIP+4 trimmedPlaceholder values cleared
TPA-54128TPAAdam Evans1989-10-10—8297865093—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58909TPAMateo Simpson1977-01-14UHC-30934-6651249014715376 Broadway, Los Angeles, CA, 900180.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-59293TPAAmber Larson—UHC-72250-8237072041269158 Washington St, Atlanta, GA, 303790.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59895TPAMargaret Griffin1947-10-20—20790492793342 River Rd, San Diego, CA, 921580.68Phone reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-53208TPAAnn Washngton1963-12-28UHC-77404-59—5383 Mountain View Dr, Gilbert, AZ, 852820.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-51106TPAAlbert Myers1959-03-01——2650 Mountain View Dr, Denver, CO, 802240.68Name re-casedState name converted to codeGender normalisedPlaceholder values cleared
TPA-60005TPAPJunk1994-02-05——9247 Highland Ave, Columbus, OH, 432980.68Gender normalisedWhitespace trimmedPlaceholder values clearedNo usable name (quarantined)
TPA-64005TPAMari Tran1982-06-18UHC-00957-09—5726 Park Pl, Phoenix, AZ, 850610.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-58566TPAJerry Lane1949-10-23——2060 Ocean Ave, Orlando, FL, 328200.68Name split from “Last, First”Date of birth reformattedPhone missing area codeWhitespace trimmed
TPA-55309TPAAmy Dunn1946-10-02UHC-41815-99—2622 Camelback Rd, Chandler, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-63875TPAPriya Santos1994-05-09——686 Canyon Rd, Tampa, FL, 336150.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-54478TPAZachary K Long1957-09-19——8115 Spring St, Tempe, AZ, 852670.68Name re-casedState name converted to codeGender normalisedPlaceholder values cleared
TPA-58134TPAHunter Carolyn1944-06-06——2682 Willow Ct, Jacksonville, FL, 322840.68Phone missing area codeState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-60582TPAMark Kelly1978-10-13—23923383489319 Main St, San Diego, CA, 921270.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62764TPAJack Espinoza—UHC-29115-37—8268 Meadow Ln, Las Vegas, NV, 891090.68Date of birth missingState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-56117TPACarol Burton1984-02-02——5385 Broadway, Orlando, FL, 328070.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-50088TPARoger X Ortiz1970-12-19——7441 Bayshore Dr, Minneapolis, MN, 554110.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-57824TPARobert Palmer1977-11-13—89032214005226 Forest Ave # 180, Tucson, AZ, 857350.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
TPA-50979TPAChristine R Andrews1951-11-11—55937987585495 Willow Ct Apt 33, Mesa, AZ, 852240.68Phone reformattedUnit split from streetGender normalisedPlaceholder values cleared
TPA-51861TPAVirginia Lopez1984-07-02——9805 Maple Ave, Charlotte, NC, 282770.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58825TPAPriya McDonald——69663634855136 Apache Blvd, Tempe, AZ, 852770.68Date of birth missingPhone reformattedGender normalisedPlaceholder values cleared
TPA-51343TPAFatima Jones1965-05-13——8055 Harbor Blvd # 778, Seattle, WA, 981670.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59373TPAValentina Q Ellis1949-10-14——3256 Market St, Tucson, AZ, 857100.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-53565TPAJudith Peters————0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
TPA-57454TPAChristina Johnston1963-07-26UHC-64381-5665224308401967 Central Ave, Jacksonville, FL, 322450.68Name re-casedTwo-digit birth yearPhone reformattedState name converted to code
TPA-57266TPAMartha Hawkins2004-12-04UHC-77244-10—3240 Baseline Rd, Houston, TX, 770210.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-51888TPACatherine Richardson1988-01-10UHC-00641-2142482231464471 Elm St, Seattle, WA, 981890.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-56669TPALisa Cruz2000-07-10—25831810276093 Hillcrest Rd # 976, Scottsdale, AZ, 852080.68Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-54151TPAJacob R Aguilar—UHC-45993-8238254392358043 Palm Dr, Tampa, FL, 336220.68Name split from “Last, First”Date of birth missingPhone reformattedPlaceholder values cleared
TPA-52653TPAJudy Wells1938-01-11——9036 Valley View Dr, Tempe, AZ, 852110.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-53448TPAAbigali Murphy1975-04-26——6723 Willow Ct # 418, Austin, TX, 787430.68Name re-casedTwo-digit birth yearUnit split from streetPlaceholder values cleared
TPA-57404TPADaniel P Patel1995-10-17——8966 Sunset Blvd, Las Vegas, NV, 891960.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50516TPAFatima Davis1997-04-15——35 Cedar Ln, Chandler, AZ, 852590.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-62472TPARoy Vargas1985-08-04—57656079754832 Canyon Rd, Los Angeles, CA, 900370.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 93 of 290PreviousNext