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
CLM-412308CLMAngela T Richardson1947-10-24UHC-54092-76—7082 Oak St, Houston, TX, 770460.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-108329ENRVirginia G Carter—UHC-07463-3384189849419246 Lake View Rd, Minneapolis, MN, 554850.54Date of birth unreadablePhone reformattedState name converted to codeZIP+4 trimmed+1 more
ENR-121057ENRTeresa Reyes1999-06-10UHC-34995-4031763481271268 Hillcrest Rd, Las Vegas, NV, 891010.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56044TPAAizha Bradley1973-12-24——6799 Spring St, Fresno, CA, 937500.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-59688TPAAlexander Turner1965-08-27——429 Pine Dr # 222, Sacramento, CA, 958970.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-112332ENRAlexis Z Armstrong1959-01-26UHC-76727-59—8444 Ridge Rd # 344, Fresno, CA, 937230.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-27645PRVBryan Lee1953-03-06UHC-60783-6697731121222721 Indian School Rd, Scottsdale, AZ, 852850.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
TPA-58668TPADanielle X Cox1943-04-12——5635 Spring St, Sacramento, CA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-58667TPADanielle X Cox1943-04-12——5635 Spring St, Sacramento, CA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
CLM-415342CLMSoia Wislon2004-06-18UHC-06608-41—3482 River Rd, San Diego, CA, 921380.54Two-digit birth yearPhone missing area codeZIP+4 trimmedWhitespace trimmed+1 more
TPA-50817TPALucia Z Campbell1947-06-23——3984 Broadway, Glendale, AZ, 853820.54Name split from “Last, First”SSN last four extractedGender normalisedWhitespace trimmed+1 more
CLM-430601CLMRandy Coko1977-02-14——185 Highland Ave, Chandler, AZ, 852010.54Name split from “Last, First”State name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
ENR-104554ENRAngela H Cooper1989-03-23UHC-93181-5924969751631514 Valley View Dr # 369, Houston, TX, 770570.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-404712CLMMery Austin1955-10-10——9469 Cedar Ln, Miami, FL0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-412545CLMShirley C Ryan1986-10-27——4300 Grand Ave, Tempe, AZ, 852430.54Name split from “Last, First”Middle initial moved out of first nameCity re-casedZIP+4 trimmed+1 more
ENR-111150ENRZachary Z Anderson1946-11-23UHC-40167-325077621452650 Mountain View Dr Apt 30, Los Angeles, CA, 900690.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-124012ENRMariana V Fowler1986-11-05UHC-92162-5332382119286958 Mountain View Dr, Scottsdale, AZ, 852920.54Name re-casedTwo-digit birth yearState name converted to codeEmail lower-cased+1 more
ENR-124790ENRAlbert Park1980-06-22UHC-07083-8364147149665831 Central Ave, Gilbert, AZ, 852200.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-116574ENRMary X Vega1986-12-03UHC-73241-9427735384697441 Jefferson Ave, Los Angeles, CA, 900590.54Name split from “Last, First”Phone reformattedSSN last four extractedCity re-cased+1 more
ENR-106236ENRJack Robertzon1995-07-17—65252592355819 Park Pl, Orlando, FL, 328650.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-118667ENRKelly Wells—UHC-80354-4883597040708309 Lake View Rd, Scottsdale, AZ0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-133062ENRBrittany X Carpenter1991-07-08UHC-31654-02—5440 Pine Dr, Austin, TX, 787710.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-119425ENRAhmed E Olson1964-06-22UHC-42356-9487966696962114 Bayshore Dr, San Diego, CA0.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-119972ENRFrances Lawsno1962-03-15UHC-98896-1131199752462728 Camelback Rd, Mesa, AZ, 852360.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-121657ENRBruce J Gray1977-11-28UHC-09823-6224621989272080 River Rd, Nashville, TN0.54Name split from “Last, First”ZIP missingEmail lower-casedGender normalised+1 more
TPA-64440TPAOmar Hoffman1946-01-16——5459 Ridge Rd, Sacramento, CA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-402720CLMStephen Harvey2002-05-23——3008 Mountain View Dr # 740, Fresno, CA, 937940.54Unit split from streetState name converted to codeGender normalisedWhitespace trimmed+1 more
ENR-103063ENRCarl O Morles1979-12-15UHC-86655-7960954665235098 Market St # 847, Orlando, FL, 328000.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-24918PRVStephen Harper——73943399174259 Pine Dr, Seattle, WA0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-129764ENRArnold Gerald1960-12-28UHC-27129-1550262100582439 Oak St, Minneapolis, MN, 554470.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-101428ENRMartha T Padilla1940-01-26UHC-51567-5339022552983228 River Rd # 710, Tempe, AZ, 852020.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-401889CLMValentina Obrien1965-06-13UHC-50153-59—5035 Oak St, Los Angeles, CA, 900860.54Name re-casedState name converted to codeZIP+4 trimmedGender normalised+1 more
ENR-119558ENRKenneth Fernandez1973-10-01UHC-00016-4791248944324810 Ridge Rd # 491, Mesa, AZ, 852860.54Two-digit birth yearPhone reformattedUnit split from streetZIP+4 trimmed+1 more
ENR-113688ENRBarbara H Peters1945-08-28UHC-20482-39—5311 Union St, Fresno, CA, 937690.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-138187ENRRalph Howard1940-12-26UHC-26532-6121545239179125 Apache Blvd Apt 31, Gilbert, AZ, 852500.54Name re-casedTwo-digit birth yearSSN last four extractedUnit split from street+1 more
CLM-419339CLMFatima Espinoza1987-11-15——27 Central Ave, Miami, FL, 331800.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-139309ENRRyan Willis1951-07-07UHC-67623-0422025785445630 Maple Ave, Jacksonville, FL, 322490.54Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50814TPAGary Walker1999-02-04—78530452096703 Cedar Ln Apt 19, San Diego, CA, 921890.54Phone reformattedUnit split from streetState name converted to codeGender normalised+1 more
ENR-104057ENRHannah M Aguilar1973-09-23UHC-74882-4176379767945872 Harbor Blvd, Minneapolis, MN, 554020.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-409682CLMJames Ashley1998-05-07UHC-24324-49—4947 Baseline Rd, Tucson, AZ, 857940.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
PRV-25246PRVAmy F Parker1948-05-10UHC-80718-0870854738463601 Jefferson Ave, Scottsdale, AZ, 852920.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-54112TPABryan Owens1952-11-02——9413 Ocean Ave, Minneapolis, MN, 554850.54Name split from “Last, First”Two-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
TPA-54153TPADaniel Lynch2001-05-17——2820 Valley View Dr, Mesa, AZ, 852240.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-400677CLMCtherine Morrison1988-12-13—83325264713792 Desert Sky Blvd, Charlotte, NC, 282910.54Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised+1 more
TPA-55546TPAChristopher Chavez1944-04-25——5415 Forest Ave, Los Angeles, CA, 900430.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-103966ENRDennis Clark1959-08-01UHC-72319-7880897422951277 Indian School Rd, Fresno, CA, 937310.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-113996ENRJoan J Simpson—UHC-14290-0947233572611841 Palm Dr, Glendale, AZ, 853450.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-52255TPAElijah X Flores1966-09-10——7879 Market St, Los Angeles, CA, 900400.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-412791CLMRobert Simmons—UHC-52762-25—1818 Maple Ave, San Diego, CA, 921570.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-412790CLMRobert Simmons—UHC-52762-25—1818 Maple Ave, San Diego, CA, 921570.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
100,000 rows, page 213 of 2,000PreviousNext