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
ENR-139554ENRAngela Carroll1941-10-15UHC-74951-15—1441 Indian School Rd, Seattle, WA, 981310.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-110736ENRPaul Padilla1957-12-06UHC-43955-026535784633—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-56414TPASofia Anderson1984-01-21—3165778943—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-401253CLMCarlos Scott1943-08-20—37668146396908 Harbor Blvd, Los Angeles, CA, 900930.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-117710ENRBradley Johnson1940-08-14UHC-61999-90—5772 Ocean Ave, Mesa, AZ, 852920.82Name split from “Last, First”City re-casedPlaceholder values cleared
CLM-431206CLMGary Montgomery1958-03-17—2532302813—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-427831CLMKelyl Vazquez1940-03-23UHC-86573-18——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-432060CLMMaariana P Heerrera1945-03-28—9125499324—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-416465CLMJoyce Hunt1951-05-13UHC-05477-22——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-419094CLMHelne Estrada1944-12-08—2865999236—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-56006TPABetty Simmons1972-11-14——797 Maple Ave, San Diego, CA, 921700.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-115799ENRLisa O Walker1960-01-24UHC-66353-784962548510—0.82Name split from “Last, First”Phone reformattedWhitespace trimmed
CLM-410816CLMStephen Graham1938-09-27———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-407455CLMJose Reyes1982-09-22—2755605024—0.82Name split from “Last, First”Plan code upper-casedPlaceholder values cleared
CLM-423093CLMOlivia Cooper1981-09-05—6877811662—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-408797CLMJohn Estrada1998-09-14———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-116939ENRRussell G Smith2002-07-05UHC-62805-28—8088 Ridge Rd, Eden Prairie, MN, 553770.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-135877ENRLori I Armstrong1939-08-17UHC-85173-78—319 River Rd, Charlotte, NC, 282250.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-422225CLMPatrick Ortega2001-07-20UHC-45462-688212622405348 Cedar Ln, Atlanta, GA, 303050.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-406769CLMMarcus Romero1990-03-08UHC-49692-40—7791 Indian School Rd, Denver, CO, 802320.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-408002CLMThomas I Sullivan1982-02-28——8589 Indian School Rd, Denver, CO, 802850.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-424469CLMTyler Wagner1977-08-17UHC-29723-33—8116 Willow Ct, San Antonio, TX, 782390.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-53760TPAYuki Gibson2005-09-19—30845094054005 Main St, Glendale, AZ, 853460.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-52145TPAMargaret Gonzalez2005-07-08———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-416349CLMArjun Anderson2006-04-21———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-403875CLMDenise Adams2001-05-06UHC-45015-9064197111574206 Lincoln Way, Columbus, OH, 432620.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-52920TPAJoe Stephens2008-02-05———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-57356TPAJerry F Willis1998-02-11——5985 Camelback Rd, Glendale, AZ, 853960.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-109297ENRSharon Rogers1971-03-15UHC-06338-10—6906 Apache Blvd, Houston, TX, 770800.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-408848CLMLauren Morrison1978-08-20UHC-90176-41——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-429158CLMPeter Baker1945-12-21UHC-62009-75——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-412251CLMKaen Young2008-03-15UHC-48759-81——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-430610CLMAnn Robertson1968-08-11UHC-98509-15—2551 Willow Ct, Seattle, WA, 981540.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
ENR-136239ENRSofia Arnold1973-09-13UHC-41265-38—423 Market St, Sacramento, CA, 958430.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-413208CLMMatthew F Burke1982-01-07———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-408116CLMKymberly Cox1993-05-03———0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
CLM-427754CLMRtuh Ortiz1990-11-22UHC-29847-48—8190 Grand Ave, Los Angeles, CA, 900680.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
ENR-100403ENRGary P Santos2006-02-11UHC-77735-4938138191489017 Bayshore Dr, Jacksonville, FL, 322040.82Name split from “Last, First”Date of birth reformattedPhone reformatted
ENR-126592ENRRaymond R Elliott1956-04-25UHC-34636-6284037590838816 Forest Ave, Denver, CO, 802840.82Name split from “Last, First”Date of birth reformattedCity re-cased
PRV-21990PRVGary Harvey1955-02-26UHC-53525-0170393082153688 River Rd, Gilbert, AZ, 852220.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-422043CLMDougglas Q Perry1979-03-18UHC-12328-71—1326 Apache Blvd, Austin, TX, 787720.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-137793ENRChristupher D Moreno1982-03-18UHC-90490-5881399206537662 Cedar Ln, Seattle, WA, 981040.82Name split from “Last, First”Phone reformattedWhitespace trimmed
TPA-58074TPADenise Ward1959-07-06—96943747728358 Lake View Rd, Miami, FL, 331130.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-413324CLMGloria Bowman1993-07-05UHC-30916-26——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-23141PRVEdward Powell1968-08-27UHC-15445-6070086648251518 Indian School Rd, Tucson, AZ, 857310.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-59108TPARoy Andrewws1942-06-18—4702131669—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-132141ENRJerry I Perkins1960-02-18UHC-57735-9349631836251106 Mesa Dr, Nashville, TN, 372120.82Name split from “Last, First”Phone reformattedEmail lower-cased
TPA-54616TPABradley Perkins2003-08-26—4055901924616 Lincoln Way, Sacramento, CA, 958980.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-55989TPAHannah Day1991-08-23——914 Indian School Rd, Minneapolis, MN, 554690.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-401517CLMChristine Snyder1989-08-27UHC-44691-785494319437—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
9,980 rows, page 187 of 200PreviousNext