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-125373ENRAna Z Williams1973-07-06UHC-30342-787924247133427 Lincoln Way, Miami, FL, 331190.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
ENR-105863ENRGeorge Moreno1975-07-02UHC-65364-3558586321109621 Cedar Ln, Phoenix, AZ, 850260.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
TPA-52109TPALinda Padilla1947-02-20UHC-69153-86——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
ENR-108884ENRTeresa O Hunt1976-08-13UHC-72508-0980980775146343 Lake View Rd, Chandler, AZ, 852060.82Name split from “Last, First”City re-casedEmail lower-cased
CLM-430451CLMHenry Riley1989-05-22UHC-56379-279583325527—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-407613CLMWillie V Robinson1992-04-01—5023689952—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-418724CLMHeather Armstrong1948-05-11UHC-08049-74——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-430394CLMDouglas Phillips1976-03-27——4676 Broadway, San Antonio, TX, 782510.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-432139CLMRoger Wang1950-02-04UHC-97290-31——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-26037PRVAnn Gilbert1953-06-03UHC-82848-708313202868—0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-424199CLMAlan Fernandez1939-07-11UHC-10140-97—5387 Baseline Rd, San Antonio, TX, 782970.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-61326TPAWayne Perkins1943-09-07——5373 Highland Ave, Mesa, AZ, 852120.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-133025ENRArthur Greene1942-11-16UHC-13551-4949146549234951 Canyon Rd, Los Angeles, CA, 900850.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
ENR-139451ENRRebecca Chavez1971-11-09UHC-48366-81—8617 Lincoln Way, Plano, TX, 750580.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-425810CLMGary Kelly1969-12-25UHC-44852-79——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-62479TPAAustin Welch1963-04-23——278 Palm Dr, Gilbert, AZ, 852770.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
ENR-129524ENRWayne Payne1943-03-23UHC-02376-169117240489—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
ENR-117360ENRRussell V Ramos1982-11-04UHC-49186-406403443578241 Lincoln Way, San Diego, CA, 921710.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-431554CLMYuki Simpson1964-09-27—2542366654—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-401045CLMMartha Bailey1972-11-04UHC-06979-995147272912—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-404010CLMDiana J Russell1999-01-05UHC-52397-34——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-126474ENRZachary T Marshall2001-11-21UHC-03354-043529053357—0.82Name split from “Last, First”Date of birth reformattedPhone reformatted
CLM-416186CLMLaura F Little1991-07-09UHC-22772-24—5722 Grand Ave, Las Vegas, NV, 891460.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-108564ENRCharles Hart1949-04-16UHC-25726-23——0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
PRV-20565PRVCamila F Gutierrez1981-01-01—81842897364059 Maple Ave, Glendale, AZ, 853430.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-64375TPAChris Sims1992-06-03UHC-77833-63——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-411702CLMWei Robinson1985-07-06———0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
ENR-106616ENRSantiago Torres1961-06-15UHC-99531-692596244074—0.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
TPA-50017TPALogan M Hamilton1967-05-17—88452280728066 Canyon Rd, Sacramento, CA, 958090.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-420351CLMHelen Wright1968-04-24UHC-67550-86—1666 Sunset Blvd, Phoenix, AZ, 850190.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-425963CLMAlan Lee1989-07-13———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-407862CLMMarilyn Hunt2000-04-25UHC-87899-87——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-64286TPABrandon Martin2003-01-17——2141 Willow Ct, Eden Prairie, MN, 553620.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-422860CLMCynthia Ortega2002-07-08—25744577243415 Canyon Rd, Nashville, TN, 372990.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-407272CLMTheresa Stevens1954-10-25UHC-14306-89—9388 Church St, Eden Prairie, MN, 553770.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-52815TPAAlexis Welch1950-05-21—89577784172207 Meadow Ln, Fresno, CA, 937250.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-418402CLMEugene Lane1976-10-05UHC-40068-8151368811538792 Main St, Charlotte, NC, 282860.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-416581CLMMason Raamirez1988-07-17—96998183557429 Bayshore Dr, Jacksonville, FL, 322960.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-416580CLMMason Raamirez1988-07-17—96998183557429 Bayshore Dr, Jacksonville, FL, 322960.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-58717TPACatherine Dais1961-02-12——6282 Ridge Rd, Miami, FL, 331470.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-53358TPAEdward Rojas2001-02-15——1525 Apache Blvd, Chandler, AZ, 852350.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
CLM-412442CLMLaura Park1993-08-21UHC-74626-53—2212 Lincoln Way, Austin, TX, 787220.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-412443CLMLaura Park1993-08-21UHC-74626-53—2212 Lincoln Way, Austin, TX, 787220.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-418959CLMNicole Carr1961-06-14UHC-85502-91—7331 Pine Dr, Phoenix, AZ, 850530.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-416250CLMChristian Castillo1973-10-17UHC-97898-44——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-59466TPADanielle H Weaver1975-04-25———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-52299TPAKeith Harnandez1998-11-21UHC-09533-29——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
CLM-411322CLMSean K Moore1955-11-21UHC-28439-67——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
ENR-132197ENRSam Larson2003-07-11UHC-57072-3726996930308082 Hillcrest Rd, San Antonio, TX, 782260.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
ENR-138168ENRAustin Aguilar1952-06-01UHC-59196-4665845652264106 Hillcrest Rd, Charlotte, NC, 282680.82Name split from “Last, First”Phone reformattedWhitespace trimmed
9,980 rows, page 192 of 200PreviousNext