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-128049ENRStephen K Jimenez2006-09-27UHC-39923-61—3249 Bayshore Dr, Denver, CO, 802540.52Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-105513ENRMartha Willis1949-05-10UHC-02418-70—1641 Sage Ct Apt 2, Eden Prairie, MN, 553510.52Phone missing area codeUnit split from streetState code upper-casedGender normalised+2 more
ENR-128575ENRSandra G Franklin—UHC-25678-83—8987 Palm Dr, Jacksonville, FL, 322570.52Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+2 more
ENR-127463ENRAna Ortiz1959-05-28UHC-28766-2662474251181779 Central Ave, Atlanta, GA, 303360.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-428926CLMKimberly Bell2003-09-01—59790337043424 Central Ave, Tempe, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408793CLMNancy Simpson1956-04-01—20595855065617 Jefferson Ave # 110, Sacramento, CA, 958280.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-138825ENRKathleen Scott1963-06-18UHC-56889-1749632455315214 Meadow Ln Apt 13, Jacksonville, FL, 322400.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405585CLMJacqueline Brooks1964-10-04UHC-71813-5241022467586927 Park Pl Apt 39, Columbus, OH, 432780.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405584CLMJacqueline Brooks1964-10-04UHC-71813-5241022467586927 Park Pl Apt 39, Columbus, OH, 432780.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-113729ENRMariana Y Hoffman1965-05-16UHC-96797-9168430721897221 Desert Sky Blvd, Sacramento, CA0.52Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more
TPA-53091TPAAngela Cook1957-11-18——2908 Highland Ave # 989, Plano, TX, 750000.52Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-103020ENRPhilip O Morgan—UHC-74681-7929097338615281 River Rd, Minneapolis, MN0.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54566TPAMichelle Cunningham2007-07-25——1038 Main St # 290, Gilbert, AZ, 852500.52SSN last four extractedUnit split from streetCity re-casedZIP+4 trimmed+2 more
TPA-59955TPABilly Bradley1998-05-18——2621 Palm Dr Apt 25, Atlanta, GA, 303740.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21241PRVGeorge Bradley1978-09-01UHC-28120-866594321783114 Highland Ave, Denver, CO, 802260.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408172CLMVirginia Hanson1953-08-12——2261 Willow Ct, Jacksonville, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-431805CLMChristine Cooper1963-04-27UHC-90180-01—4649 Camelback Rd, Tampa, FL, 336460.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-28387PRVMegan Morgan1997-09-07——9294 Lake View Rd, Tempe, AZ, 852520.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-116653ENRGreg Sanders1978-01-20UHC-11903-3977081267552084 Sage Ct, Sacramento, CA, 958260.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-106037ENRBryn P Kelly1978-10-05UHC-84004-3844277562964508 Ocean Ave, Glendale, AZ, 853750.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21206PRVNancy Oliver1944-10-25UHC-38921-64—8923 Baseline Rd, Plano, TX, 750660.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-126093ENRVicky Harper1955-09-05UHC-33397-2563042720183308 Baseline Rd, Phoenix, AZ, 850890.52Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-406433CLMPhilip Bradley1945-06-28UHC-47879-82—2457 Hillcrest Rd, Minneapolis, MN0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-51379TPAJacob Wong1982-10-02——5567 Palm Dr, Houston, TX, 770490.52Name split from “Last, First”Two-digit birth yearEmail lower-casedGender normalised+2 more
ENR-124077ENRJulie B Riley1941-02-10UHC-35425-2573186099886520 Central Ave, Gilbert, AZ0.52Name re-casedPhone reformattedState name converted to codeZIP missing+2 more
ENR-128064ENRKatherine Hughes1964-08-18UHC-58411-5395737486973745 Maple Ave # 391, San Diego, CA, 921140.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-54944TPAEveyln Castro1965-08-12——1347 Ocean Ave, Columbus, OH, 432860.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-422630CLMHeenry Espinoza1955-08-15UHC-50850-98—1526 Spring St, Tucson, AZ0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-402990CLMGary Cook1970-06-01UHC-97450-5656153351226769 Central Ave, Las Vegas, NV, 891480.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-54069TPAZachary Perkins2003-04-25——9138 Grand Ave, Tucson, AZ, 857300.54Name split from “Last, First”Two-digit birth yearGender normalisedWhitespace trimmed+1 more
ENR-114208ENRDorothy D Garcia1949-05-15UHC-92624-4882493234994613 Bayshore Dr, San Antonio, TX, 782800.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-432289CLMCheryl X Johnson1973-02-07UHC-75959-53—101 Palm Dr, Sacramento, CA, 958210.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-111544ENROmar T Freeman1939-09-04UHC-55803-5034783491997187 Desert Sky Blvd Apt 7, Denver, CO0.54Date of birth reformattedPhone reformattedUnit split from streetZIP missing+1 more
ENR-116053ENRStephanie Y Ruiz1999-01-26UHC-28633-53—1752 Main St, Eden Prairie, MN, 553290.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-403094CLMAnn O Adams—UHC-49487-8994766135654774 Broadway # 640, Scottsdale, AZ, 852440.54Name split from “Last, First”Date of birth unreadablePhone reformattedUnit split from street+1 more
CLM-418412CLMJudy D Soto1981-01-26——9496 Ridge Rd, Glendale, AZ, 853220.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-109808ENRRonald V Sandoval1996-04-08UHC-16953-93—6996 Mountain View Dr, Chandler, AZ, 852990.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-53716TPABrenda Garrett1984-09-28———0.54Name re-casedPhone missing area codeSSN last four extractedGender normalised+1 more
CLM-409514CLM—Junk1945-06-27UHC-74702-5973949978413460 Forest Ave, Minneapolis, MN, 554480.54Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared+1 more
TPA-54430TPAKarren Guerrero1980-06-26—37237713397928 Bayshore Dr, Orlando, FL, 328540.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-108000ENRBrandon Hill1984-07-26UHC-22856-4221541264359744 Maple Ave, Scottsdale, AZ0.54Name re-casedTwo-digit birth yearPhone reformattedZIP missing+1 more
ENR-109628ENRDorothy V Holmes1970-11-14UHC-54912-3582955695648960 Spring St, Nashville, TN, 372250.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-109627ENRDorothy V Holmes1970-11-14UHC-54912-3582955695648960 Spring St, Nashville, TN, 372250.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-426256CLMMarc K Matthews1990-03-08UHC-28870-27—4840 Market St, Austin, TX, 787550.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-58438TPARebecca Williams1980-04-20——1967 Union St, Charlotte, NC, 282780.54Name re-casedSSN last four extractedState name converted to codeZIP+4 trimmed+1 more
ENR-133197ENRPhilip Tucker1982-02-21UHC-65487-8273263632699361 Jefferson Ave, Orlando, FL, 328730.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-405145CLMAlexis Q Ramirez1964-04-18——7736 Ocean Ave, Gilbert, AZ, 852570.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-405144CLMAlexis Q Ramirez1964-04-18——7736 Ocean Ave, Gilbert, AZ, 852570.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-64037TPALogan Lnch1967-08-25——6009 Palm Dr, Fresno, CA, 937550.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-122631ENRSofia G Peters2004-01-06UHC-10758-5955495606384510 Pine Dr Apt 8, Houston, TX, 770940.54Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
100,000 rows, page 194 of 2,000PreviousNext