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

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-115916ENR—Junk1972-02-26UHC-22368-0160670602383469 Park Pl, Tampa, FL, 336220.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-115832ENRJerryJunk1993-04-23UHC-13518-6266480451273258 Baseline Rd, Charlotte, NC, 282590.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-125532ENR—Junk1947-08-08UHC-10103-539273792900922 Palm Dr, Tempe, AZ, 852590.66Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
ENR-112095ENRMJunk1973-10-03—6846278951147 Canyon Rd, Tampa, FL, 336680.66Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
ENR-116931ENR—Junk1989-05-05UHC-37714-6946234907618237 Central Ave # 803, Dallas, TX, 752160.66Date of birth reformattedPhone reformattedUnit split from streetPlaceholder values cleared+1 more
ENR-113128ENRHicksJunk1974-03-26UHC-68928-7321575926486607 Desert Sky Blvd, Eden Prairie, MN, 553130.66Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-119883ENRRalph XJunk1995-03-26UHC-98397-43—1949 Spring St, Los Angeles, CA, 900610.66Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
ENR-107681ENRFJunk1992-05-19UHC-36150-6146045831913691 Lincoln Way, Minneapolis, MN, 554690.66Phone reformattedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
ENR-104430ENRElijah YJunk1998-08-01UHC-03448-1629136533845442 Desert Sky Blvd, Denver, CO, 802440.66Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
ENR-108219ENRBrandon CJunk1988-10-02UHC-70838-03—573 Canyon Rd, Gilbert, AZ, 852320.68Street suffix standardisedAddress re-casedWhitespace trimmedNo usable name (quarantined)
ENR-142595ENRShirleyJunk1949-03-16UHC-56574-4433763215984682 Ocean Ave, Columbus, OH, 432080.68Date of birth reformattedZIP+4 trimmedPlaceholder values clearedNo usable name (quarantined)
ENR-126042ENR—Junk1938-12-11UHC-29199-9880333540039265 Palm Dr, Minneapolis, MN, 554270.68Phone reformattedStreet suffix standardisedAddress re-casedNo usable name (quarantined)
ENR-106700ENRRJunk2007-10-14UHC-62604-4276940621164464 Ridge Rd, Seattle, WA, 981620.68Phone reformattedZIP+4 trimmedEmail lower-casedNo usable name (quarantined)
ENR-128658ENRMichelleJunk1987-05-23UHC-91927-632016381151272 Meadow Ln, Orlando, FL, 328000.68Street suffix standardisedAddress re-casedWhitespace trimmedNo usable name (quarantined)
ENR-137157ENRUJunk1982-11-20UHC-21392-85—8890 Church St, Las Vegas, NV, 891630.68Street suffix standardisedAddress re-casedWhitespace trimmedNo usable name (quarantined)
ENR-118000ENRBetty EJunk1943-11-15UHC-98440-2964740982381999 Meadow Ln, Seattle, WA, 981970.68Street suffix standardisedAddress re-casedWhitespace trimmedNo usable name (quarantined)
ENR-142271ENR—Junk1995-10-23UHC-41395-61—8889 Ocean Ave, Sacramento, CA, 958930.68Two-digit birth yearEmail lower-casedPlaceholder values clearedNo usable name (quarantined)
ENR-106462ENRKJunk1998-04-09UHC-66870-4625032667267026 River Rd, Chandler, AZ, 852510.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
ENR-128583ENR—Junk1948-02-14UHC-66835-6980171593194017 Palm Dr, Orlando, FL, 328960.68Phone reformattedStreet suffix standardisedAddress re-casedNo usable name (quarantined)
ENR-129051ENRJulia EJunk—UHC-52748-0632653323724899 Elm St, Tampa, FL, 336400.68Date of birth unreadablePhone reformattedWhitespace trimmedNo usable name (quarantined)
ENR-107421ENRAaron ZJunk1994-08-21UHC-70735-5574043106543158 Elm St, Tucson, AZ, 857420.68Street suffix standardisedAddress re-casedWhitespace trimmedNo usable name (quarantined)
ENR-109644ENRVJunk1983-02-19UHC-44572-224457481021296 Washington St, Jacksonville, FL, 322280.68Phone reformattedSSN last four extractedPlaceholder values clearedNo usable name (quarantined)
ENR-130786ENRBJunk1951-04-18UHC-30141-5290794920531592 Camelback Rd, Sacramento, CA, 958270.68Phone reformattedGender normalisedPlan code upper-casedNo usable name (quarantined)
ENR-135069ENRWJunk1998-01-04UHC-89508-38227517099145 Lake View Rd, Scottsdale, AZ, 852820.70Date of birth reformattedState name converted to codeNo usable name (quarantined)
ENR-124350ENR—Junk1941-04-09UHC-96615-5072560093017589 Mountain View Dr, Charlotte, NC, 282470.70Phone reformattedState name converted to codeNo usable name (quarantined)
ENR-135531ENROliviaJunk2003-08-15UHC-01709-4398654067124874 Willow Ct, San Diego, CA, 921650.70Street suffix standardisedAddress re-casedNo usable name (quarantined)
ENR-119529ENRRJunk1990-12-06UHC-66808-42—7070 Harbor Blvd, Glendale, AZ0.72ZIP missingNo usable name (quarantined)
ENR-132430ENRBJunk1951-09-02UHC-52134-965596133325—0.74Date of birth reformattedPhone reformattedMember ID reformattedEmail lower-cased+3 more
ENR-105959ENRRachelJunk1954-08-12UHC-44054-6861353679892152 Oak St, Orlando, FL, 328710.76Date of birth reformattedCity re-casedState code upper-casedWhitespace trimmed+2 more
ENR-113348ENRQJunk1994-11-06UHC-15235-1163532171204333 Spring St, Atlanta, GA, 303510.76Date of birth reformattedPhone reformattedCity re-casedWhitespace trimmed+2 more
ENR-125528ENRWei EJunk1954-08-09UHC-50630-1893029931947711 Lincoln Way, Orlando, FL, 328860.78Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more
ENR-128890ENRPeul CJunk1982-04-26UHC-98564-053729334729—0.78Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared+1 more
ENR-121082ENRBrianJunk1978-07-12UHC-08980-1122682882797222 Spring St, Columbus, OH, 432330.78Name re-casedPhone reformattedCity re-casedPlan code upper-cased+1 more
ENR-139141ENRHelen PJunk2004-10-06UHC-93664-4098625295593435 Bayshore Dr, Fresno, CA, 937390.78Date of birth reformattedPhone reformattedPlan code upper-casedWhitespace trimmed+1 more
ENR-130384ENRMark DJunk1950-01-25UHC-83933-0974482553844811 Pine Dr, Seattle, WA, 981250.78City re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared+1 more
ENR-125474ENRGJunk1984-12-03UHC-74538-9576398282459570 Sunset Blvd, Miami, FL, 331430.78Date of birth reformattedPhone reformattedMember ID reformattedPlaceholder values cleared+1 more
ENR-123721ENR—Junk1951-03-08UHC-57959-4273866499421939 Mountain View Dr, Chandler, AZ, 852270.78Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared+1 more
ENR-114673ENRCynthia YJunk1955-08-15UHC-26200-0192524218275537 Hillcrest Rd, Tampa, FL, 336520.80Date of birth reformattedMember ID reformattedWhitespace trimmedNo usable name (quarantined)
ENR-138820ENRDonnaJunk1983-01-09UHC-77847-8898963157573296 Forest Ave, Mesa, AZ, 852240.80Phone reformattedEmail lower-casedPlaceholder values clearedNo usable name (quarantined)
ENR-119654ENRBenjamynJunk1980-06-23UHC-74433-7894645556957408 Sage Ct, Gilbert, AZ, 852100.80Phone reformattedEmail lower-casedWhitespace trimmedNo usable name (quarantined)
ENR-117383ENR—Junk1943-04-24UHC-63370-0868367129644161 Apache Blvd, Columbus, OH, 432290.80Date of birth reformattedState code upper-casedEmail lower-casedNo usable name (quarantined)
ENR-125416ENRVincent EJunk1962-10-27UHC-92478-1931485044464569 Oak St, Chandler, AZ, 852080.80City re-casedWhitespace trimmedPlaceholder values clearedNo usable name (quarantined)
ENR-108660ENREJunk1982-03-14UHC-83692-9277230408563165 Central Ave, Gilbert, AZ, 852450.80Phone reformattedPlan code upper-casedWhitespace trimmedNo usable name (quarantined)
ENR-128038ENR—Junk1993-11-21UHC-84997-9226843746235506 Broadway, Las Vegas, NV, 891660.80Date of birth reformattedPhone reformattedWhitespace trimmedNo usable name (quarantined)
ENR-135476ENRChristinaJunk1942-03-08UHC-75863-4454244811348964 Maple Ave, Charlotte, NC, 282300.80Phone reformattedCity re-casedWhitespace trimmedNo usable name (quarantined)
ENR-111149ENRRoyJunk1973-06-03UHC-66622-5977322065139475 Meadow Ln, Scottsdale, AZ, 852890.80Name re-casedDate of birth reformattedPhone reformattedNo usable name (quarantined)
ENR-105769ENRRaymondJunk1952-03-09UHC-79674-32—6547 Sunset Blvd, Columbus, OH, 432760.80State code upper-casedWhitespace trimmedPlaceholder values clearedNo usable name (quarantined)
ENR-141564ENR—Junk1943-11-23UHC-29336-475773985494227 Jefferson Ave, Austin, TX, 787160.80Phone reformattedMember ID reformattedEmail lower-casedNo usable name (quarantined)
ENR-107463ENRJeanJunk1956-01-22UHC-32569-148729368152—0.80Phone reformattedWhitespace trimmedPlaceholder values clearedNo usable name (quarantined)
ENR-125406ENRAJunk2005-07-19UHC-11787-315485489458872 Willow Ct, Las Vegas, NV, 891050.80Phone reformattedWhitespace trimmedPlaceholder values clearedNo usable name (quarantined)
230 rows, page 4 of 5PreviousNext