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-58807TPAWayne Daniels1999-03-01—6363621631—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53972TPAEmma Carteer1943-02-15——2898 Church St, Austin, TX, 787580.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-62719TPAChristina Gonzalez1968-01-23UHC-26758-34—87 Sage Ct, Jacksonville, FL, 322180.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54362TPAPriya H Dixon1976-03-20—5154865831—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56193TPABrian Y Anderson1968-07-14—3617623191—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53935TPABrian Arnold1997-01-20—6864275908192 Broadway, Scottsdale, AZ, 852720.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-55478TPAAngela D Jacobs1969-08-28—85671318419636 Pine Dr, Las Vegas, NV, 891340.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59223TPADorothy Ross1994-12-28—31687974799034 Cedar Ln, Eden Prairie, MN, 553800.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50172TPARalph Elliott1993-06-26UHC-06749-67——0.92Name re-casedMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-53620TPAIsabella Herrera1938-05-17—5668649491—0.92Name re-casedPhone reformattedEmail lower-casedPlaceholder values cleared
TPA-63153TPAJulia Chapman2008-09-26———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62620TPANathan K Bryannt1962-12-05———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60985TPADiane George1953-11-21UHC-91159-53—900 River Rd, Scottsdale, AZ, 852390.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-53364TPARivera Andrea1976-05-09——7221 Valley View Dr, Denver, CO, 802590.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64111TPAAmber Garrett1965-02-08—3824190602—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54458TPACharles Rice1953-09-09——8697 Main St, Jacksonville, FL, 322450.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-56096TPAVincent Berry1966-04-10—35753936708119 Market St, Miami, FL, 331870.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-59097TPAChristopher Lucas1946-01-07—7858852136—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62120TPAGregory Santos1984-11-21—4366624051—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57721TPASantiago Romero1978-11-20—88297237932666 Forest Ave, Houston, TX, 770760.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50148TPAAisha Henry2005-07-22UHC-56044-7924696156962707 Market St, San Antonio, TX, 782680.92Name re-casedPhone reformattedMember ID reformattedWhitespace trimmed
TPA-56295TPADanielle Carroll1992-03-01——1954 Maple Ave, Gilbert, AZ, 852560.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56367TPAEvelyn Munoz1972-10-06——6463 Ocean Ave, Glendale, AZ, 853330.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-59109TPABryan Graham1999-09-04——301 Baseline Rd, Denver, CO, 802510.92Name re-casedDate of birth reformattedState code upper-casedPlaceholder values cleared
TPA-59715TPAKayla Lewis1978-06-27—71668577208719 Ocean Ave, Gilbert, AZ, 852690.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52796TPABrcue R Jacos1950-04-21—21098940726148 Sunset Blvd, Tucson, AZ, 857230.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-61172TPASarah T Parker1990-02-23———0.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-52019TPAGeorge Kim1946-06-06——4350 Church St, Denver, CO, 802360.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-59816TPALinda Ross1969-06-14——9275 Ridge Rd, Chandler, AZ, 852460.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64332TPADiego Lawrence1978-11-27—8476469423—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50251TPAEmily Shaw1952-02-06——1742 Indian School Rd, Nashville, TN, 372530.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51223TPAMason Welch1962-03-01—2346103976—0.92Phone reformattedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-63943TPAJerry R Obrien1955-01-02—87584144824060 Mesa Dr, Jacksonville, FL, 322040.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59123TPAJack Kelley1960-05-05——6336 Spring St, Austin, TX, 787360.92Name re-casedDate of birth reformattedPlan code upper-casedPlaceholder values cleared
TPA-61012TPADenise Alexander1954-06-06—40855209211316 Sunset Blvd, Nashville, TN, 372330.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53179TPASusan Estrada1958-05-10——4482 Union St, Tempe, AZ, 852000.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52191TPACatherine Alexander1944-04-27—7578050801—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62782TPADonald Cooper1989-03-11UHC-62188-4457569871064619 Central Ave, Los Angeles, CA, 900000.92Date of birth reformattedPhone reformattedMember ID reformattedPlaceholder values cleared
TPA-54685TPAElizabeth Gardner1944-03-22—8422717716—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-61527TPANatalie Obrien1969-07-27———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57310TPARachel Johnston2005-08-26UHC-09885-88—9518 Jefferson Ave, Scottsdale, AZ, 852780.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63527TPARachel Meyer1999-08-10UHC-39130-6187790048098031 Valley View Dr, Jacksonville, FL, 322470.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-59419TPAYuuki Contreras1997-03-01——4549 Broadway, Phoenix, AZ, 850460.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-62555TPANancy Rojas2007-10-03——309 Ocean Ave, Austin, TX, 787000.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55555TPAAndrea T Sanders1976-03-15—87566136606103 Market St, Columbus, OH, 432480.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57375TPASantiago Patterson1960-06-28—5913420133—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53291TPAEvelyn Lopez1979-04-27UHC-68398-2166772758538221 Meadow Ln, Eden Prairie, MN, 553470.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56374TPASteven Fuller1977-02-14UHC-48850-17—9564 Mountain View Dr, Chandler, AZ, 852920.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-61602TPAJudith Valdez1996-03-09—38361595336196 Baseline Rd, San Diego, CA, 921570.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-57246TPALogan V Jordan1963-01-14—94222435603273 Hillcrest Rd, Los Angeles, CA, 900390.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 240 of 290PreviousNext