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

Claims, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-419083CLMScott H Tran1976-08-06UHC-47745-73——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-428541CLMJohn Marshall2000-04-14———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-402751CLMGeorge Knight1998-04-09——7834 Canyon Rd, Los Angeles, CA, 900700.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-410453CLMCharrlotte O Warren1953-12-28UHC-20880-69——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-421464CLMDenise Arnold1939-08-26UHC-66715-60—1440 Ridge Rd, Fresno, CA, 937470.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-415863CLMAmber C Jones1998-10-18UHC-67006-6575946118658598 Sage Ct, Nashville, TN, 372230.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-403303CLMOmr Murray1960-02-04UHC-31124-86—8437 River Rd, Denver, CO, 802150.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-404150CLMPaul Crawford1973-04-11UHC-49265-38——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-426815CLMKeith Watson1991-02-08UHC-99757-95——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-426072CLMWard N Emily1981-03-05UHC-88538-10——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-418754CLMJanice Holmes1961-11-07UHC-79640-77——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-405566CLMJacqueline Reynolds1982-11-20UHC-88771-8728699031275254 Main St, Las Vegas, NV, 891740.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-422755CLMArjun Anderson1985-07-05UHC-56313-596009315274—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-409583CLMJennifer Riley1988-04-14—61973319874639 Baseline Rd, Jacksonville, FL, 322860.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-402402CLMHenry K Grant1988-06-07UHC-26219-75——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-402609CLMSarah J Garcia1989-11-08UHC-65698-65—1910 Broadway, Scottsdale, AZ, 852970.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-400921CLMKeith S Duncan1970-02-04UHC-01148-158607079713—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-425291CLMSantiago Baker1991-02-27UHC-82806-0154886198393643 Park Pl, Los Angeles, CA, 900270.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-424590CLMJacob Alvarez1972-04-09UHC-66933-025552937460—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-419447CLMJose L Schultz1998-12-25UHC-22544-02——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-400883CLMMary Payne1948-01-25UHC-97356-173318008869—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-423411CLMJoshua Morales1986-07-14UHC-14391-17—2252 Spring St, Seattle, WA, 981660.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-423190CLMJesse Armstrong1941-04-03UHC-52920-63——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-407002CLMPriya T Price1961-02-12———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-423732CLMTeresa P Burton1956-04-24UHC-61347-459006131141—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-414163CLMMarcus Maldonado1997-02-02UHC-34997-7066980876901072 Central Ave, Mesa, AZ, 852330.82Name split from “Last, First”Phone reformattedState code upper-cased
CLM-431275CLMJule Palmer1948-07-04—49088708562721 Palm Dr, Chandler, AZ, 852930.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-409478CLMBryan Owens1952-11-02———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-425415CLMWillie Roberts1980-05-25———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-416727CLMAhmed N Marshall1944-10-12UHC-12592-1097058127846570 Lincoln Way, Glendale, AZ, 853350.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-422187CLMMarilyn Hoffman1954-01-12UHC-37385-12——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-400854CLMKeiht Fisher1965-10-14UHC-11065-1577241524103741 Washington St, Miami, FL, 331570.82Name split from “Last, First”Phone reformattedCity re-cased
CLM-416693CLMDeborah D Webb1956-10-16UHC-83661-453873581411—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-431769CLMJose Rodriguez1970-01-05——6126 Camelback Rd, Houston, TX, 770740.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-424168CLMAmber Reed1964-04-03UHC-27473-207327559423—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-416757CLMWalter Blck1952-02-19UHC-18775-66—5693 Palm Dr, Glendale, AZ, 853360.82Name split from “Last, First”Member ID reformattedPlaceholder values cleared
CLM-401109CLMKathryn Holmes1939-02-10UHC-21580-23—1223 Canyon Rd, Austin, TX, 787170.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-420454CLMSharon E Haarper2006-12-17—62695669369284 Highland Ave, Atlanta, GA, 303220.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-410068CLMNatalie McCoy2001-10-02UHC-26564-74—7730 Hillcrest Rd, Charlotte, NC, 282370.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-416434CLMRay Lynch2004-11-18———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-408678CLMJanice K Burton1955-04-03UHC-20074-87——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-421815CLMWillie Allen1989-10-21—89477696544882 Highland Ave, Denver, CO, 802910.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-425102CLMMrk Z Jimenez1974-06-08UHC-85724-40——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-432022CLMAshley Gordon1943-03-21———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-407944CLMJeremy Hill1999-12-10UHC-25891-17——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-423370CLMJuan Sandovaal1980-02-06UHC-24554-885887061964—0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-423776CLMDouglas Guzman1939-05-04—41432939664355 Mountain View Dr, Tempe, AZ, 852990.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
CLM-427315CLMBarb Le1992-08-02———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-410298CLMWillie Mejia1938-08-19UHC-65942-13——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-412151CLMNancy Lewis1984-11-14UHC-97623-93—6223 Valley View Dr, Austin, TX, 787320.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
3,226 rows, page 58 of 65PreviousNext