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, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-133727ENRZachary U Morris1985-09-28UHC-13938-46—6613 Pine Dr, Fresno, CA, 937230.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-105726ENRUJunk1966-03-12UHC-76518-547278331495733 Spring St, Los Angeles, CA, 900890.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112856ENRPatrick Marquez1995-05-22UHC-59828-3655224019614295 Apache Blvd, Austin, TX, 787540.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-409969CLMAustin Dominguez1954-04-10UHC-89799-5857923644027136 Cedar Ln, Tampa, FL, 336010.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-419688CLMRyn Wong1941-03-06—47727071956303 River Rd # 514, Atlanta, GA, 303370.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136457ENRBenjamin Mills1962-04-28UHC-47258-4760865574764151 Desert Sky Blvd, Orlando, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426564CLMPaul Luna1961-02-24——9527 Grand Ave, Fresno, CA, 937650.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116683ENRTyler Barnes1942-05-11UHC-01576-4157261236377124 Market St # 346, Chandler, AZ0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50292TPAYuki E Berry1953-01-02——5752 Lincoln Way, Atlanta, GA, 303540.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-26580PRVMaria Cunningham1959-10-20—89880858327075 Pine Dr, Los Angeles, CA, 900080.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-431825CLMCharles Burke1944-01-12—67464967417974 Meadow Ln, Austin, TX0.50Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+3 more
CLM-414924CLMGabriel Sullivan1967-12-04—80382234668840 Highland Ave, Austin, TX, 787970.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-408237CLMAbby Vasquez1992-01-02UHC-90186-6368532445146809 Bayshore Dr, Houston, TX, 770440.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131549ENRLori WJunk1951-03-15UHC-50744-7144565177973221 Canyon Rd, Minneapolis, MN, 554060.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-29504PRVSophia Reid1987-11-27—92831380424481 Bayshore Dr Apt 28, Las Vegas, NV, 891210.50Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+3 more
CLM-403560CLMHannah Little1995-12-08UHC-90419-65—4288 Park Pl, Plano, TX, 750960.50Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+3 more
ENR-134815ENRJoe B Cox1954-06-17UHC-98294-1072634140215787 Sunset Blvd Apt 20, Orlando, FL, 328390.50Phone reformattedUnit split from streetState name converted to codeEmail lower-cased+3 more
CLM-409165CLMJuan Murphy——6846278951147 Canyon Rd, Tampa, FL, 336680.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118974ENRJanice K Richards1938-06-13UHC-36443-2360433172162622 Jefferson Ave, Charlotte, NC, 282540.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-138153ENRJerry Rosss1979-06-17UHC-06332-38—7056 Palm Dr, Charlotte, NC, 282710.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-61823TPADeborah Wallace1971-01-20—72736635537441 Ocean Ave, Nashville, TN, 372270.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-135731ENRIsabella R Wong2002-04-02UHC-26829-4021439312057567 Sage Ct, Gilbert, AZ, 852630.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140883ENRSopia E Spencer1939-06-15UHC-86480-2830847571717663 Ocean Ave, Houston, TX, 770130.50Middle initial moved out of first nameStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-25207PRVFatima Daniels2007-06-08UHC-51636-636599382100500 Desert Sky Blvd # 185, Plano, TX0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-58133TPABradley Powell1988-12-02——5426 Camelback Rd, Plano, TX, 750590.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117604ENRHamilton U Doris1949-03-21UHC-29716-4387551746728807 Indian School Rd Apt 14, Los Angeles, CA, 900630.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-135962ENRHenry V Obrien—UHC-71537-8024091651201614 Camelback Rd # 839, Atlanta, GA, 303720.50Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
ENR-134817ENRDouglas O Harris1965-08-21UHC-03403-79—4687 Main St, Nashville, TN, 372550.50Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
ENR-112543ENRNancy I Salazar1981-03-05UHC-90313-6583466638055548 Sage Ct, Columbus, OH, 432960.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-407551CLMSamantha Greene1976-09-02UHC-56755-0822792611661516 Highland Ave # 290, San Diego, CA, 921510.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-416377CLMBruce T Torres1958-06-07UHC-04706-642874096040974 Forest Ave, Houston, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104202ENRRuth M Hill—UHC-49852-183805349906557 Jefferson Ave, Plano, TX, 750280.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426115CLMMato P Sims1959-11-11—95443726087841 Bayshore Dr, Phoenix, AZ, 850070.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-101507ENRAnna Lawrence1983-12-17UHC-95417-06—9750 Sage Ct, Las Vegas, NV0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
ENR-101506ENRAnna Lawrence1983-12-17UHC-95417-06—9750 Sage Ct, Las Vegas, NV0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
CLM-430330CLMAshley Hunter1962-01-15UHC-27397-7995759981854675 Mesa Dr, Columbus, OH, 432030.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21706PRVPaul Patel—UHC-58061-8526491382173976 Park Pl, Tampa, FL, 336460.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429462CLMLucia Le1959-09-08—51047092117725 Pine Dr, Las Vegas, NV, 891680.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-64015TPAWilliam Rodriguez1993-05-23UHC-66982-37—2554 Market St, Columbus, OH, 432960.50Name split from “Last, First”Member ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-403696CLMChristina Burke1976-06-13——5791 Cedar Ln, Glendale, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-141186ENRAnthony Ward1982-02-06UHC-87149-6494070492381081 Pine Dr, Atlanta, GA, 303970.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-24205PRVWei Castillo——90624394682397 Willow Ct, Eden Prairie, MN, 553920.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421272CLMBrittany Mendez1946-05-27UHC-75234-10—5701 Baseline Rd, Columbus, OH, 432340.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122538ENROmar D Johnson1962-12-05UHC-46064-4369026193853316 Forest Ave, Phoenix, AZ, 850080.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423650CLMMason Vasquez1952-12-01——7154 Maple Ave, Los Angeles, CA, 900970.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-140009ENRVincent Delgado1960-02-12UHC-58815-2574021267745442 Sunset Blvd, Miami, FL, 331620.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-139562ENRWillie Chavez1952-10-12UHC-99334-3386558015752780 Desert Sky Blvd, Plano, TX, 750960.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26425PRVNancy J Graham—UHC-43007-2270946051284350 Apache Blvd # 543, Seattle, WA, 981970.50Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-114231ENRAlbert O Santos1985-08-12UHC-10621-5066597909402953 Union St, Chandler, AZ, 852210.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-51818TPAWilliam Garrett1993-12-01—6318431022368 Desert Sky Blvd, Tucson, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 132 of 2,000PreviousNext