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-139192ENRMontgomery Judith1999-11-01UHC-20121-6092186157353781 Bayshore Dr, Charlotte, NC, 282530.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-102390ENRAnthony V Hernandez2003-01-03UHC-96290-7466823709438512 Mesa Dr, Scottsdale, AZ, 852690.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-138415ENRNoah D Marquez1954-02-05UHC-44909-1474776869863964 Cedar Ln, Columbus, OH0.54Name split from “Last, First”Two-digit birth yearPhone reformattedZIP missing+1 more
ENR-123681ENRYJunk—UHC-57515-4657934894593912 Central Ave, Los Angeles, CA, 900100.54Date of birth missingPhone reformattedGender normalisedWhitespace trimmed+1 more
ENR-133116ENRArthur P Carter1953-09-20UHC-46569-3850485826517582 Washington St, Chandler, AZ, 852720.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-136361ENRAlbert C Delgado1939-08-14UHC-47612-0265944654497963 Meadow Ln Apt 28, Plano, TX, 750950.54Name split from “Last, First”Date of birth reformattedUnit split from streetGender normalised+1 more
ENR-120142ENRJanice U Edwards1951-03-03UHC-49570-052073584379207 Park Pl Apt 30, Dallas, TX, 752390.54Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-400694CLMWlson Elizabeth1957-02-10UHC-61515-34—3145 Desert Sky Blvd, Phoenix, AZ, 850020.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-121644ENRJean P Lynch1996-12-23UHC-03327-1773586443715840 Spring St, Sacramento, CA, 958600.54Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+1 more
ENR-141637ENRCamila Cook1993-11-17UHC-38400-9054073923348990 Willow Ct, San Diego, CA, 921840.54Two-digit birth yearSSN last four extractedCity re-casedGender normalised+1 more
TPA-63328TPANancy B Gilbert1976-03-20——4914 Forest Ave, San Antonio, TX, 782060.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-104173ENRAlice Black1953-05-07UHC-76795-83—2038 Camelback Rd, Atlanta, GA, 303910.54SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-58652TPAShirley Rogers1944-05-12——6321 Harbor Blvd, Scottsdale, AZ, 852920.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-422672CLMWayne Parker1969-04-18——1698 Sage Ct, Tempe, AZ, 852570.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-425222CLMJacqueline Hayes1983-05-03———0.54Name split from “Last, First”Phone missing area codeGender normalisedWhitespace trimmed+1 more
CLM-416247CLMNicholas Alexander1989-04-25UHC-55928-14—6192 Canyon Rd, Mesa, AZ, 852820.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-133926ENRBenjamin Brown1979-03-15UHC-21896-7166089417557984 Park Pl, Tempe, AZ, 852090.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-121121ENRSean Allen1967-11-11UHC-74463-6869728926739243 Union St # 273, Seattle, WA0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-24013PRVPaul Millls2000-08-05UHC-43060-6378451701185434 Indian School Rd, Plano, TX0.54Two-digit birth yearPhone reformattedZIP missingGender normalised+1 more
ENR-135524ENRJames S Banks1999-03-22UHC-39366-9883533431742151 Ocean Ave Apt 1, Nashville, TN, 372800.54Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+1 more
ENR-140457ENRMelissa Patterson1982-09-23UHC-00168-0653779976336288 Harbor Blvd, Austin, TX, 787210.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-417596CLMEugenne Henderson1993-09-17UHC-33659-08—4184 Jefferson Ave, Chandler, AZ, 852020.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-111899ENRChristina R Daniels1975-11-09UHC-78180-71—8725 Highland Ave, Orlando, FL, 328780.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-107557ENRJanet H Tran2005-01-12UHC-47381-7144120584276574 Pine Dr, Chandler, AZ, 852680.54Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-135503ENRHannah Wallace1969-01-26UHC-22335-822517309342693 Union St # 627, San Diego, CA0.54Phone reformattedMember ID reformattedUnit split from streetZIP missing+1 more
CLM-404163CLMEmily Rojas1973-08-11——3655 Market St, Las Vegas, NV, 891010.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-52683TPAGary Hernandez—UHC-48744-09—8374 Central Ave # 180, Tempe, AZ, 852080.54Name re-casedDate of birth unreadableUnit split from streetGender normalised+1 more
ENR-127419ENRStephen M Harrison1955-03-22UHC-14162-8537528473389547 Indian School Rd, San Antonio, TX, 782260.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-138504ENRJason P Herrera—UHC-70832-1953722799344295 Oak St, Sacramento, CA, 958620.54Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
TPA-56809TPAKatherine Hawkins2002-12-12——7014 Valley View Dr, Austin, TX, 787880.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
ENR-136781ENRBerbara D Rojas1989-01-04UHC-46818-7838668489205644 Forest Ave Apt 19, Nashville, TN, 372870.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-62231TPAWayne Fernandez1941-12-03——6873 Canyon Rd, Jacksonville, FL, 322690.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-423817CLMYuki T Johnson—UHC-34539-08——0.54Name split from “Last, First”Date of birth unreadablePhone missing area codeWhitespace trimmed+1 more
ENR-130456ENRCynthia H Jensen1989-10-18UHC-41535-2143948179921517 Ridge Rd # 408, Denver, CO, 802250.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-29016PRVBrittany E Wells2001-01-14——1690 Jefferson Ave, Austin, TX0.54SSN last four extractedCity re-casedState name converted to codeZIP missing+1 more
CLM-423672CLMDorothy Ryan1973-03-15UHC-88580-12—2639 Meadow Ln # 901, Miami, FL, 331850.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-133328ENRVirginia Graham1965-09-01UHC-41763-3427645738924205 Indian School Rd, Plano, TX, 750530.54Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+1 more
CLM-432442CLMKayla James1961-06-15UHC-27390-20—3880 Park Pl, Minneapolis, MN, 554210.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-139232ENRTerry G Wells1979-08-25UHC-40621-574764683172818 Baseline Rd, Minneapolis, MN, 554970.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-110692ENRElijah Brown1957-07-13UHC-79098-8576331068029090 Palm Dr, Miami, FL, 331610.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-111235ENRTyler Thomas1948-08-01UHC-19916-1472372389776416 Pine Dr, San Antonio, TX, 782640.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-117479ENRTerry Stephens1946-12-02UHC-30868-70—156 Indian School Rd, Fresno, CA0.54Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+1 more
ENR-116958ENRAmanda Cuok1967-05-04UHC-27610-615578452757802 Sage Ct, Miami, FL, 331230.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-135491ENRBryan Bryant1940-08-23UHC-64075-409323895451625 Willow Ct, Chandler, AZ, 852530.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-117173ENRKathryn Moreno—UHC-94649-01—9188 Grand Ave Apt 13, Columbus, OH, 432390.54Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-122957ENRMaria H Baker1972-02-28UHC-25029-7865090383825242 Hillcrest Rd, Nashville, TN0.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-143078ENRAndrew Holmes1963-06-16UHC-90169-7641547916744855 Mountain View Dr, Gilbert, AZ, 852910.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
PRV-28765PRVAhmed J Singh———8556 Apache Blvd, Plano, TX0.54Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-50856TPATylre Gurrero1989-03-25—25587712043570 Park Pl, Phoenix, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-409872CLMAna Cunningham1972-03-03UHC-35095-35—1845 Desert Sky Blvd Apt 22, Scottsdale, AZ, 852990.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
100,000 rows, page 198 of 2,000PreviousNext