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-410741CLMAnna Scott1966-07-27UHC-14025-28—2964 Central Ave, Columbus, OH, 432930.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-409055CLMDanielle K Ward2003-09-25UHC-81974-47—8315 Central Ave Apt 30, Scottsdale, AZ, 852620.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-114193ENRMason N Jenkins1971-02-08UHC-44213-3140386435112754 Meadow Ln, Minneapolis, MN0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424290CLMMartha Y Patterson1991-05-22—95239053517089 River Rd, Tempe, AZ, 852390.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54236TPAMegan Reed2005-11-11——8402 Mesa Dr # 666, Sacramento, CA, 958120.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-58877TPABobby Vasquez1987-08-27——776 Sunset Blvd, Atlanta, GA, 303470.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59559TPALaura Bennett1964-02-07—73072011923622 Desert Sky Blvd, Dallas, TX, 752380.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-104598ENRDiego Castillo2007-02-09UHC-69309-4485244904563312 Maple Ave Apt 35, Houston, TX, 770380.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-401697CLMStephen Jensen1981-11-03——5564 Washington St, Minneapolis, MN, 554300.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-120713ENRBrian Wells2001-07-16UHC-78951-3134335266117743 Market St, Tampa, FL0.52Name split from “Last, First”Phone reformattedMember ID reformattedZIP missing+2 more
CLM-417866CLMJacqueline Maldonado1983-10-05UHC-29559-7244876025185838 Apache Blvd, Glendale, AZ, 853000.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-62780TPAMark Wang1989-10-27—93548794051548 River Rd Apt 28, Tempe, AZ, 852350.52Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
CLM-402235CLMJack Jimenez1965-07-22UHC-31944-66—1751 Apache Blvd # 717, Tucson, AZ, 857250.52Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
CLM-429311CLMJessica Meyer1990-09-22UHC-76285-11—2783 Union St, Glendale, AZ0.52Name re-casedDate of birth reformattedState name converted to codeZIP missing+2 more
TPA-59205TPARussell Bell2006-04-02——2688 Jefferson Ave, Atlanta, GA, 303800.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
ENR-140506ENRJesse K Kim1995-01-28UHC-52083-96—8917 Maple Ave, Phoenix, AZ, 850020.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-423854CLMLawrence Braynt1966-11-21UHC-35899-6061644980977082 Central Ave, Austin, TX, 787840.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-110254ENREmily B Gibson1977-10-15UHC-33914-455169147893960 Palm Dr Apt 15, Fresno, CA, 937440.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-27464PRVBetty Watkins1994-07-17UHC-83199-3839320355046891 Palm Dr, Tempe, AZ, 852860.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-61420TPAEthan Contreras1974-12-03——3510 Grand Ave, Dallas, TX, 752870.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-406088CLMLinda V Fields—UHC-49146-78—1120 Pine Dr, Phoenix, AZ, 850810.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-27520PRVAdnrea Salazar——60688652638269 Mesa Dr, Columbus, OH, 432700.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-51780TPAJean M Kelly1954-06-06——5987 Central Ave, Seattle, WA, 981240.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-420712CLMDennis N Ray1961-07-12——959 Sunset Blvd, Atlanta, GA, 303680.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63923TPASophia Gonzales1944-04-12——9811 Ocean Ave, Minneapolis, MN, 554540.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-140434ENRSandra C Young1938-09-22UHC-48035-6022471654228637 Mountain View Dr, San Antonio, TX0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423780CLMGloria Miller1950-12-10——58 Forest Ave, Plano, TX, 750230.52Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+2 more
ENR-107266ENRKenneth Gonzalz1964-05-07UHC-04241-4421052889731000 Hillcrest Rd, Dallas, TX, 752470.52Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-102607ENRJudy K Kelly1959-11-11UHC-32707-8572146543186312 Indian School Rd, Fresno, CA, 937810.52Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
CLM-432086CLMArthur Wilson———8847 Ridge Rd, Chandler, AZ, 852840.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-54007TPALogan Hamilton1972-01-12——7925 Pine Dr, Charlotte, NC0.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-416912CLMJesse Mendez1971-07-20——7000 Mesa Dr, Chandler, AZ, 852860.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-427075CLMJack Jordna1957-07-13UHC-50049-2441729643006754 Canyon Rd, Columbus, OH, 432780.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
PRV-21559PRVRyan Z Warren1946-08-13UHC-88581-012195835859243 Sunset Blvd Apt 12, Nashville, TN0.52Name split from “Last, First”Phone reformattedUnit split from streetZIP missing+2 more
CLM-426573CLMTerry A Butlr2008-10-10UHC-98914-4125866415755887 Jefferson Ave Apt 16, Plano, TX, 750410.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-124842ENRAna X Luna1970-06-08UHC-91289-4528752962626915 Lake View Rd # 611, Nashville, TN, 372800.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-20952PRVAlexis Garcia——78472617609065 Desert Sky Blvd, Charlotte, NC, 282150.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407504CLMJulie Lee1985-06-28—96248479557238 Main St # 929, Tucson, AZ0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-124986ENRElizabethJunk1985-06-17UHC-07694-8992576537549041 Baseline Rd, Fresno, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-125890ENRKimberly W Henderson1980-02-01UHC-76058-1645091116855226 Desert Sky Blvd, Austin, TX, 787720.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122638ENRCarolyn E Olson1966-07-08UHC-95316-3152943355597469 Camelback Rd, Houston, TX, 770180.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-425930CLMDanel Snyder1965-05-24—55367407872733 Grand Ave Apt 21, Minneapolis, MN, 554740.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57810TPAAmy Evans1967-05-21—42071419036124 Hillcrest Rd # 556, Orlando, FL, 328850.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-418129CLMAmber Cox1970-12-21UHC-11328-7641279572442746 Park Pl, Glendale, AZ0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421837CLMBilly Griffin1963-04-04UHC-50393-25—4415 Union St, Las Vegas, NV, 891200.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428014CLMTerry Z Perkins1970-06-03—85334857109150 Hillcrest Rd, Los Angeles, CA, 900550.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26882PRVSara K Roberts1950-08-19—53888982227982 Maple Ave, Fresno, CA, 937990.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-132529ENRCeryl D Thomas2004-07-05UHC-65987-5534585429948717 Ridge Rd, Houston, TX, 770470.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51567TPAJoseph Cunningham1939-09-10—9199684150979 Bayshore Dr, Minneapolis, MN, 554950.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57275TPAMargaret Tucker1993-08-05——3606 Mesa Dr, San Diego, CA, 921460.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 157 of 2,000PreviousNext