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-110213ENRAna Ward2001-06-13UHC-74459-0355240162212271 Mountain View Dr, Minneapolis, MN, 554350.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-134698ENRCynthia Carlson1997-07-15UHC-39422-61—4545 Park Pl, Chandler, AZ, 852970.52Name split from “Last, First”Date of birth reformattedPhone missing area codeState name converted to code+2 more
CLM-404963CLMGary Hughes1947-06-17UHC-42310-5651453581306761 Cedar Ln, Mesa, AZ, 852350.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411041CLMCharlotte I Payne2005-01-13——2382 Grand Ave, Glendale, AZ, 853540.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430336CLMDiego Contreras1948-02-23UHC-46032-06—2310 Forest Ave # 235, Eden Prairie, MN, 553600.52SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432513CLMHarold Pierce1958-09-17UHC-59853-76—5371 Park Pl, Glendale, AZ, 853700.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63587TPARuth B Price1965-03-04—73050573931483 Maple Ave, Minneapolis, MN, 554980.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-107891ENRElijah Moore2002-01-06UHC-84075-7996298558469244 Sunset Blvd, Seattle, WA, 981850.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142795ENREugene B Martinez1992-01-17UHC-33187-4823226440185914 Canyon Rd Apt 30, Austin, TX0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431751CLMAlan Gilbert1966-08-18UHC-57392-18—5697 Camelback Rd, Charlotte, NC, 282480.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-412643CLMAndrea Sanders1976-03-15—87566136606103 Market St, Columbus, OH, 432480.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-112504ENRSharon P Mendez1974-04-01UHC-87920-2521867488026167 Ocean Ave, Phoenix, AZ, 850800.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-131070ENRGary Wells2005-02-20UHC-91876-7486886622383046 Spring St, San Diego, CA, 921890.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-128228ENRMeyer C Scott—UHC-86113-05—7628 Sage Ct, Phoenix, AZ, 850830.52Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-28780PRVChristopher L Aguilar1967-09-11UHC-33800-17—3042 Sage Ct, Plano, TX, 750140.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-121324ENRGerald H Murphy1940-12-23UHC-39938-7394872201266591 River Rd, Tampa, FL0.52Two-digit birth yearPhone reformattedState name converted to codeZIP missing+2 more
ENR-124869ENRJoan O Sanders1956-07-08UHC-39294-5181194153176335 Bayshore Dr, Dallas, TX, 752120.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109617ENRJoshua C Nelson1975-02-24UHC-27770-8561437234541628 Camelback Rd, Denver, CO, 802380.52Name re-casedTwo-digit birth yearCity re-casedState name converted to code+2 more
TPA-61964TPAOlivia Grant2003-08-15UHC-01709-43—4874 Willow Ct, San Diego, CA, 921650.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-61140TPACatherine Day1943-07-04——5538 Grand Ave, Plano, TX0.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-135336ENRKatheerine E Butler1938-10-05UHC-58714-0979054446687504 Desert Sky Blvd, Houston, TX, 770990.52Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61173TPAGloria Clark1976-08-27UHC-28114-30—5774 Indian School Rd, Sacramento, CA0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-411892CLMRyan Fuller1965-12-23—71763955109460 Elm St, Columbus, OH0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418815CLMRichard Boyd1945-02-02—98966953632919 Jefferson Ave Apt 29, Scottsdale, AZ, 852580.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-140180ENRJennifer Stone1944-01-13UHC-97396-923432564579405 Sunset Blvd # 177, Fresno, CA, 937620.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-128643ENRSamuel U Rivera1944-10-26UHC-03534-3254048420285200 Palm Dr # 470, Tucson, AZ, 857490.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-113494ENRAmanda West1999-10-16UHC-07852-5156855071002723 Lincoln Way, Tempe, AZ, 852630.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-102981ENRRussell U Jensen1960-08-26UHC-60553-9786462834163170 Main St, Scottsdale, AZ, 852740.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-136433ENRAnthony Murray1940-07-20UHC-01079-25—2175 Washington St, Houston, TX, 770060.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-112739ENRAlice Foster1950-02-28UHC-58749-30350544971061 Lake View Rd, Columbus, OH, 432740.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415141CLMJacqueline Munoz1961-08-13UHC-96980-7430461477329815 Ocean Ave # 632, Chandler, AZ0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-114540ENRMadison G Baker1940-06-12UHC-84526-6862559354964020 Harbor Blvd, San Antonio, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-59999TPAJoe Obrrien———832 Oak St, Jacksonville, FL, 322880.52Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+2 more
ENR-142804ENRDenise C Sullivan1965-08-05—83779444927428 Lincoln Way Apt 28, Chandler, AZ, 852720.52Two-digit birth yearPhone reformattedUnit split from streetGender normalised+2 more
TPA-63847TPARaymond V McDonald——34923466309897 Canyon Rd, Atlanta, GA, 303620.52Name split from “Last, First”Date of birth missingPhone reformattedState name converted to code+2 more
CLM-425545CLMSophia Foster1939-02-09UHC-38274-5798390742737330 Canyon Rd, Nashville, TN, 372410.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-424862CLMBen Rose2007-04-19UHC-01453-15—3350 Maple Ave, Scottsdale, AZ, 852160.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55264TPADonald Park1972-01-09——1942 Forest Ave # 852, Gilbert, AZ0.52Date of birth reformattedUnit split from streetState name converted to codeZIP missing+2 more
CLM-401286CLMEmma Valdez—UHC-16477-14—5102 Cedar Ln, Seattle, WA, 981920.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-111775ENRTheresa Morrison1942-12-17UHC-09600-8849875118109222 Baseline Rd, Las Vegas, NV0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-126251ENRCharles K Baker1979-05-09UHC-20459-987306289105784 Park Pl, Tucson, AZ, 857050.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103453ENRAnthoony Martin1982-10-23UHC-47088-1537723177972343 Oak St Apt 31, Phoenix, AZ, 850450.52Phone reformattedMember ID reformattedSSN last four extractedUnit split from street+2 more
TPA-61320TPAMadison Rose1966-11-16UHC-58752-22—3811 Bayshore Dr, Scottsdale, AZ, 852910.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-126713ENRMichelle Y Spencer2002-07-28UHC-58399-69—4328 Pine Dr # 939, Plano, TX, 750940.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-110471ENRJulia X Soot1986-12-17UHC-52203-0156966916719040 Mountain View Dr, Minneapolis, MN, 554860.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-142777ENRAustin Hughes2000-10-06UHC-15363-444455878753576 Highland Ave, Tampa, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-432405CLMMicehlle Alvarez2007-03-11UHC-56884-74—9370 Hillcrest Rd, Tempe, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-423587CLMVictoria Herrera1944-07-22UHC-21655-7483462154196228 Bayshore Dr Apt 10, Tempe, AZ0.52Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+2 more
TPA-62194TPARussell Duncan1988-08-26——9339 Apache Blvd, Scottsdale, AZ, 852450.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-135843ENRDiana Z Lng2007-11-05UHC-77612-5535621538407104 Sage Ct, Houston, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
100,000 rows, page 152 of 2,000PreviousNext