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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-23400PRVGary V Espinoza1948-04-18UHC-84150-579606425868—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-405611CLMMariana L Lane1972-09-10——3982 Cedar Ln, Denver, CO, 802540.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-60355TPATerry Wood1938-04-05—30980664209822 Meadow Ln, Gilbert, AZ, 852640.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-416369CLMRice Lisa1975-07-12UHC-13130-092534550759—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
ENR-120711ENRMadison K Castro1952-02-01UHC-96414-2122346755368120 Main St, Jacksonville, FL, 322230.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-410519CLMDiego Martin2007-10-15UHC-39798-526817532472—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-429840CLMLauren Ramos1955-07-01——5403 Maple Ave, Miami, FL, 331330.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-411268CLMDaniel Austin1967-05-16———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-52778TPAArjun Sanders1916-05-25———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-407446CLMJoseph King1982-12-04UHC-46651-1170383629469130 Broadway, Jacksonville, FL, 322900.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-427692CLMAmy Fernandez1948-03-16UHC-54769-51——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-119284ENRJustin Robinson1958-03-27UHC-19573-0439585503106820 Broadway, Tempe, AZ, 852130.82Name split from “Last, First”Date of birth reformattedPhone reformatted
TPA-57371TPAJesse Shaw1948-02-21——3852 Palm Dr, Tampa, FL, 336760.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-425935CLMBrenda Robinson1998-02-20—2639247657—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-26734PRVJoseph Walsh1997-05-25UHC-54154-912296377020—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-64023TPAMarcus Coleman1994-10-28—3907759461304 Pine Dr, Plano, TX, 750450.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-408638CLMLori F Dominguez2000-09-04——730 Sage Ct, Miami, FL, 331430.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-425869CLMKathleen Jacobs1999-02-07—56522880692475 Harbor Blvd, Houston, TX, 770740.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
ENR-142418ENRYuki Jacobs1940-04-28UHC-65496-7665425971644067 Meadow Ln, Dallas, TX, 752820.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-418788CLMLarry Green1958-08-24—9053069190—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-132613ENRKelly Hicks1952-05-07UHC-88193-3873124445393726 Baseline Rd, Gilbert, AZ, 852250.82Name split from “Last, First”Phone reformattedWhitespace trimmed
PRV-28424PRVJordan L Sullivan2001-02-14—66985032922637 Ocean Ave, Gilbert, AZ, 852530.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-432490CLMRoger G Martinez1990-03-15UHC-40330-54——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-56726TPABrittny Kelley1943-09-13———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-55972TPAKyle Dunn1951-12-01—7402838678—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-104170ENRCarl Chavez1973-09-25UHC-14542-9488367328419462 Sunset Blvd, Gilbert, AZ, 852530.82Name split from “Last, First”Email lower-casedWhitespace trimmed
CLM-418358CLMNicholas Adams1947-10-04UHC-35449-2656559758799388 Park Pl, Nashville, TN, 372020.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-51506TPAFreeman W Joyce1965-06-18—9458006271—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-55686TPAMariana Sullivan2006-01-04——1102 Central Ave, Glendale, AZ, 853650.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-412905CLMAmanda Cook1976-05-04UHC-27610-61——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-130616ENRHannah O Brown1943-07-08UHC-97609-2329481101918925 Church St, Nashville, TN, 372990.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-406798CLMDoris Y Cooper1969-06-21UHC-46929-193228304402—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-406904CLMJoshua White1984-09-10UHC-58233-88——0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
CLM-422127CLMMary Walker1979-11-20———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-420225CLMRaymond R Elliott1956-04-25UHC-34636-62—8816 Forest Ave, Denver, CO, 802840.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-403167CLMAnn Gilbert2004-10-07UHC-20636-06—2196 Sage Ct, Chandler, AZ, 852740.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-61149TPAMariana Campbell2008-05-15——2470 Palm Dr, Minneapolis, MN, 554000.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-421579CLMMichael Hanson1983-07-01——3342 Sage Ct, Fresno, CA, 937380.82Name split from “Last, First”Plan code upper-casedPlaceholder values cleared
PRV-23542PRVThomas Richards1945-02-21UHC-76708-2897429606534221 Oak St, Las Vegas, NV, 891290.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-51199TPAElijah Lopez1963-03-01——9012 Lake View Rd, Columbus, OH, 432450.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-100581ENRDennis Warren2007-05-11UHC-29646-2473523963224604 Washington St, Eden Prairie, MN, 553050.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-426110CLMMarcus D Gilbert1994-03-03UHC-89377-66—6817 Forest Ave, Glendale, AZ, 853580.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
ENR-122719ENRJoyce Santtiago2000-08-25UHC-78000-992348295751832 Highland Ave, Los Angeles, CA, 900080.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
PRV-22776PRVTimothy S Santus1980-07-26—9562094053—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-410261CLMMaria Watkins1943-09-15——7679 Central Ave, Tampa, FL, 336660.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-415183CLMKathryn I Price1987-02-12———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-59548TPASean Lee2001-11-20—59187092153969 Forest Ave, Charlotte, NC, 282310.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-57430TPATerry Rychardson1984-07-04UHC-96410-44—6145 Park Pl, San Antonio, TX, 782860.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-414778CLMAlexis Moore1995-12-09UHC-10333-27——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-411801CLMDonald Soto1959-11-02UHC-45288-97——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
9,980 rows, page 189 of 200PreviousNext