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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-110925ENRHelen Spencer1939-09-05UHC-12971-4239453721243371 Meadow Ln Apt 40, Orlando, FL, 328070.46Name re-casedPhone reformattedSSN last four extractedUnit split from street+5 more
ENR-118764ENRJeremy J Ortega2002-08-07UHC-18231-8730098129354675 Indian School Rd, Charlotte, NC, 282780.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-139950ENRBrandon M Hamilton1965-04-13UHC-11844-8066792839388869 Mountain View Dr, Tucson, AZ0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-119744ENRLaura Watkins1961-02-15UHC-86062-5429472844132762 Willow Ct Apt 17, Mesa, AZ, 852310.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-113079ENRKatherine B Larson1972-09-17UHC-24304-5049124070454444 Main St, Los Angeles, CA0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-123016ENRMelissa Hart1959-12-19—57192690511003 Apache Blvd, San Diego, CA, 921750.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-124183ENRSantiago Z Dominguez1963-04-09UHC-05052-5759926377809297 Forest Ave, Dallas, TX, 752140.46Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+5 more
ENR-113586ENRJulia S Nguyen1969-11-02UHC-27419-7946580314785776 Meadow Ln Apt 20, Charlotte, NC, 282930.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-100026ENRNancy O Campbell1991-05-20UHC-10392-0473323811593517 Baseline Rd # 391, Jacksonville, FL, 322660.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-102206ENRArthur N Mason1975-07-11UHC-95789-7433739743675652 Jefferson Ave # 776, San Antonio, TX, 782660.46Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more
ENR-110807ENRKathleen Wganer1990-12-17UHC-97845-1677163068609711 Spring St # 709, Tampa, FL, 336530.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-129468ENRTyler M Mason—UHC-65746-0572761996884287 Union St, San Diego, CA, 921340.46Middle initial moved out of first nameName re-casedDate of birth missingPhone reformatted+5 more
ENR-127727ENRKatherine V Wagner1962-05-06UHC-22531-1376220184141301 Ocean Ave, Columbus, OH, 432730.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-136373ENRDoris X James1957-05-03—50856012261527 Elm St, Plano, TX, 750870.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-134771ENRAlan Smith2004-11-04UHC-62253-6492266687868017 Highland Ave, Glendale, AZ, 853460.46Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
ENR-137757ENRAnn Santiago1990-01-07UHC-72018-8943134141034669 Main St, Glendale, AZ, 853380.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-122059ENRFrank Weber1956-03-02UHC-60254-7580281704143595 Valley View Dr, Glendale, AZ, 853110.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-120615ENRSamantha Z Dunn1938-03-25UHC-02275-683393534169627 Lake View Rd # 972, Tempe, AZ, 852980.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-127192ENRMary G Nunez1967-06-23UHC-30029-904078082756326 Willow Ct, Houston, TX, 770490.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-115999ENRRoy Mills1949-09-10UHC-24316-2052125297071396 Union St, Sacramento, CA, 958030.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-129890ENRAna N Gilbert1979-03-17UHC-96425-4633869532635440 Valley View Dr # 433, Austin, TX, 787250.46Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+5 more
ENR-129889ENRAna N Gilbert1979-03-17UHC-96425-4633869532635440 Valley View Dr # 433, Austin, TX, 787250.46Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+5 more
ENR-101177ENRKenneth Valdez2007-03-07UHC-31713-5180254182698917 Apache Blvd, Fresno, CA, 937190.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-112933ENRJustin Warren1970-02-02UHC-50704-5369025884026843 Mountain View Dr Apt 30, Glendale, AZ, 853500.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-134131ENRAlexander N Marquez1978-08-01UHC-84217-4969967624988121 Park Pl, Denver, CO, 802150.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-130849ENRRyan Howard1976-12-22UHC-33587-0244842025856625 Market St, Dallas, TX, 752300.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-115906ENRLee V Joan1984-11-22UHC-28497-1079647829477316 Elm St, San Antonio, TX, 782180.46Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-142576ENRZachary X Maldonado1967-10-02UHC-32396-9438839005971940 Desert Sky Blvd Apt 7, Fresno, CA, 937140.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-107499ENRAnna Q Carpenter1952-02-03UHC-11448-9390696220135759 River Rd, Jacksonville, FL0.46Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+5 more
ENR-126029ENR—Junk1959-09-06UHC-21710-9978059072795221 Canyon Rd, Columbus, OH, 432970.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-117122ENRBrian Peterson1984-01-16UHC-97293-3169761980151670 Market St, Plano, TX, 750090.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-102855ENRBradley HJunk1987-08-15UHC-35169-5386169572273152 Harbor Blvd, Atlanta, GA, 303250.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-102854ENRBradley HJunk1987-08-15UHC-35169-5386169572273152 Harbor Blvd, Atlanta, GA, 303250.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-107565ENRDebra G Patel1948-01-07UHC-55850-0823882163403271 River Rd, Orlando, FL, 328350.46Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
ENR-114988ENRJoshua Walsh—UHC-13971-3652527646973202 Pine Dr, Denver, CO, 802860.46Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more
ENR-105490ENRAustin X Grant1947-04-20UHC-51653-6720976302633805 Central Ave, Atlanta, GA0.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-139138ENRKeith T Herrera1956-03-18UHC-35510-3721020881651213 Palm Dr, Plano, TX, 750430.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-108462ENRDJunk1950-03-04UHC-22102-23—8121 Camelback Rd, Jacksonville, FL, 322230.46Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-132165ENRHeather Q Moreno1963-08-07UHC-49093-3487346127172841 Lake View Rd, San Diego, CA, 921910.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-109432ENRRichard R Medina1988-06-20UHC-01593-3856695527399218 Highland Ave, Eden Prairie, MN0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-113870ENRJuustin D Wevaer1975-01-26UHC-21503-2320368358677373 Palm Dr, Sacramento, CA, 958700.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-108215ENREugene P Freeman1938-02-14—20191558248811 Sage Ct, Scottsdale, AZ0.46Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-118080ENRKaren Gibson1976-02-21UHC-49708-5653482881526786 Grand Ave Apt 2, Denver, CO, 802990.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-115287ENRRoger J Chavez1990-11-09UHC-74003-193275114423148 Jefferson Ave, Los Angeles, CA, 900770.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-136907ENRMei L Claark1987-03-09UHC-15546-2076589629294102 Sunset Blvd, Glendale, AZ, 853290.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-101924ENRAmanda E Walsh1965-11-10UHC-09751-1070035843699882 Cedar Ln Apt 13, Orlando, FL0.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-142550ENRJeffrey J Edwards1993-02-09UHC-98325-8097189372584979 Bayshore Dr, Plano, TX, 750320.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-113205ENRDebra Rojas1943-07-15UHC-41714-2078175659858068 Meadow Ln, Tampa, FL, 336880.46Date of birth reformattedPhone reformattedSSN last four extractedCity re-cased+5 more
ENR-116159ENRChristopher A Rivera1982-06-16UHC-38401-49—7584 Grand Ave, Tucson, AZ0.46Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+5 more
ENR-110209ENRCharles O Ellis1972-11-13UHC-01634-6776571036379432 Church St, San Diego, CA, 921520.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
43,101 rows, page 24 of 863PreviousNext