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-114455ENRNancy J Day—UHC-45854-2121248885707061 Jefferson Ave, Columbus, OH, 432950.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414938CLMTyler D Gray2005-10-24UHC-40253-8871079610233159 Harbor Blvd, Glendale, AZ, 853260.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-413772CLMNathan L Smith1967-01-13—65723940617425 Ridge Rd, Mesa, AZ, 852150.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-118468ENRCarol I Gardner—UHC-82456-8750890130892681 Washington St, Tampa, FL, 336670.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-140703ENRAmanda Andrews1971-10-25UHC-57948-9573750281487758 Central Ave, Chandler, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-140702ENRAmanda Andrews1971-10-25UHC-57948-9573750281487758 Central Ave, Chandler, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-430154CLMDiane Carter1974-06-22UHC-52209-86—663 Main St, San Diego, CA, 921730.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-407815CLMDinae Mendez1937-12-13UHC-02276-61—6371 Grand Ave, Las Vegas, NV, 891910.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-411280CLMBruce Morgan—UHC-19389-2434971624385416 Camelback Rd, Gilbert, AZ, 852520.54Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-142465ENRAmy M Powell1969-10-25UHC-60786-0677753883364435 Apache Blvd, Houston, TX, 770200.54Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-119487ENRIsabella Burton1980-11-25UHC-09055-5079385881033009 Apache Blvd, Tempe, AZ, 852380.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-411170CLMRussell Andrews1989-04-11UHC-37663-59—2725 Pine Dr, Chandler, AZ, 852270.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-126571ENRSharon Woods2002-07-05UHC-33271-3678424775706811 Lake View Rd, Plano, TX0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-135668ENRKein X Wilson1960-09-02UHC-38865-86—2872 Willow Ct, Phoenix, AZ, 850950.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-101500ENRSantiago L Freeman1970-08-14UHC-18981-3769921515068797 Desert Sky Blvd # 706, Houston, TX, 770540.54Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-142388ENRJoyce B Tucker1950-08-04UHC-62211-22—3464 Valley View Dr, Los Angeles, CA, 900580.54Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more
PRV-26323PRVBobby Peterson1965-06-27UHC-08242-6389437715019031 Jefferson Ave, Austin, TX, 787570.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-135941ENRBrian F Thomas1956-12-02UHC-07672-9180938373941654 Baseline Rd, Chandler, AZ, 852740.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-127029ENRKevin Chen1994-04-03UHC-92993-91—4242 Forest Ave, Nashville, TN, 372160.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-402711CLMKayla Gardner1963-11-25—95529600367259 Sunset Blvd, Phoenix, AZ, 850050.54Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+1 more
ENR-125818ENRFrances I George1939-02-15UHC-23464-3381026167754849 Lincoln Way, Minneapolis, MN0.54SSN last four extractedState name converted to codeZIP missingEmail lower-cased+1 more
ENR-106059ENREugane W Tucker—UHC-26271-1379553071729002 Maple Ave, Glendale, AZ, 853800.54Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-402117CLMMary Pena2004-08-06——1649 Indian School Rd, Houston, TX, 770170.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-413505CLMJulie B Parker1969-01-20—60279675805927 Camelback Rd, Minneapolis, MN, 554020.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-137381ENRFreeman Diana2005-02-21UHC-59043-7343836088158283 Ocean Ave, San Diego, CA0.54Name re-casedTwo-digit birth yearState name converted to codeZIP missing+1 more
ENR-117054ENROlivia Washington1982-05-10UHC-79196-55—4213 Lake View Rd, Glendale, AZ0.54Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-428979CLMDaniel K Garcia1979-10-23UHC-19096-6580580445847751 Union St, Seattle, WA, 981520.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-61591TPAThomas Andrson1943-05-21—65149955721774 Willow Ct, Seattle, WA, 981100.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-107785ENRMichael Reed1963-04-28UHC-36196-4533233627584804 Sage Ct, Denver, CO0.54Phone reformattedState name converted to codeZIP missingGender normalised+1 more
CLM-412977CLMRuth Vazquez2006-09-08UHC-11615-5624396177941207 Lincoln Way, Charlotte, NC, 282440.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
ENR-142091ENRDavid Green1962-05-06UHC-37765-37—3728 Jefferson Ave, Tucson, AZ, 857330.54Name re-casedTwo-digit birth yearState name converted to codeGender normalised+1 more
TPA-57290TPADebra Wagner1967-06-21——4557 Canyon Rd, San Antonio, TX, 782400.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-115177ENRNoeh H Miller1962-11-10UHC-78031-2559687601065151 Pine Dr, Glendale, AZ, 853960.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-109103ENRNicole S Daniels—UHC-40675-5647837347181019 Bayshore Dr, Nashville, TN, 372580.54Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+1 more
TPA-60251TPANathan Turner1987-05-06——528 Market St, Gilbert, AZ, 852750.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-20324PRVKelly Larson1965-12-05—82290956473092 Washington St # 572, Chandler, AZ, 852210.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-59492TPADiana Webb1967-05-27——5776 Oak St, Scottsdale, AZ0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-423088CLMEmily O Fox1945-09-08—7092720143121 Church St, Phoenix, AZ0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-116584ENRAustin Dean1970-06-23UHC-56519-5883629324084643 Church St, San Diego, CA, 921760.54Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-22142PRVDeborah Y Jackson1951-07-21UHC-89997-7065171705078786 Jefferson Ave Apt 11, Las Vegas, NV0.54Name split from “Last, First”Phone reformattedUnit split from streetZIP missing+1 more
ENR-130963ENRBrenda Q Allen1952-03-07UHC-73574-9791758856642354 Apache Blvd, Atlanta, GA, 303450.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-124789ENRBobby U Kelley1961-12-26UHC-42869-80—7569 Camelback Rd, Fresno, CA0.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-103002ENRFrances Vargas1957-12-07UHC-44264-2342866443736476 Maple Ave, Minneapolis, MN, 554800.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
TPA-59744TPARaymond Robinson1942-04-12UHC-17881-72—1979 Union St, Atlanta, GA0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-141927ENRDiane Gonzalez1939-04-13UHC-47195-7066699877371437 River Rd Apt 1, Miami, FL, 331560.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-64256TPAAustin Morgan2003-05-17——6020 Sunset Blvd, Dallas, TX, 752250.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-111616ENRJames Park2008-04-11UHC-67554-4482949951235255 Church St Apt 20, Seattle, WA, 981130.54Unit split from streetState name converted to codeGender normalisedWhitespace trimmed+1 more
ENR-110869ENRJerry Oliver1986-02-24UHC-41721-6737039640933207 Bayshore Dr, Fresno, CA, 937130.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-134483ENRPhilip Freeman—UHC-41323-38—3882 Central Ave, Phoenix, AZ0.54Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-108771ENRSarrah G Jams1984-12-20UHC-76376-8137924693443221 Spring St, Atlanta, GA, 303810.54Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
100,000 rows, page 214 of 2,000PreviousNext