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-110683ENRZachary Harvey2004-08-10UHC-58981-2884261072398928 Apache Blvd, Tempe, AZ, 852390.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422224CLMWilliam Mroales1997-12-01—9632818563342 Grand Ave # 276, Miami, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-56862TPAJosh Harris1945-03-05——7597 Hillcrest Rd, Dallas, TX, 752700.50Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-430458CLMBenjamin Ferguson———6269 Willow Ct, Eden Prairie, MN, 553250.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-423596CLMWayne Nelson2003-08-18UHC-16289-79—4213 Spring St, Charlotte, NC0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127564ENRDeborah Barnes1995-03-09UHC-31108-3155341121078022 Hillcrest Rd, Minneapolis, MN, 554600.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-422615CLMJudith Simmons1980-07-16UHC-35607-9974439036788104 Maple Ave, Fresno, CA, 937280.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-418923CLMMary Miller1940-11-17UHC-95565-83—9265 Sunset Blvd, Minneapolis, MN, 554760.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-59905TPAPamela Tran—UHC-02051-22—4889 Spring St, Sacramento, CA0.50Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137139ENRJames Johnson1955-03-03UHC-45826-69—4782 Main St, San Antonio, TX, 782360.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-413363CLMAndrew Ramos1951-09-27——2590 Market St, Dallas, TX, 752110.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-113564ENRCarl K Payne1955-10-25UHC-04139-14—3575 Willow Ct, Los Angeles, CA, 900520.50Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-61897TPAMason Fuller2007-01-11—82224182226548 Washington St # 485, Austin, TX, 787000.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-103376ENRBryan Yang1961-08-06UHC-24123-4833598303238243 Market St Apt 9, Sacramento, CA, 958500.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130924ENRDoris X Torres1988-08-17UHC-69907-9652439115237807 Sunset Blvd, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-143091ENRJacob V Murray1995-11-28UHC-20446-3723347645461235 Highland Ave # 328, Tucson, AZ, 857470.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-29337PRVRalph Wood1959-08-19UHC-68877-1129082996885440 Lake View Rd, Charlotte, NC, 282500.50Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more
ENR-136498ENRAnthony Myers1978-05-08UHC-74006-3734224055154764 Sunset Blvd # 930, Eden Prairie, MN, 553340.50Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more
TPA-50371TPALaura A Sullivan1974-11-11—65671790831021 Highland Ave, Atlanta, GA, 303780.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419104CLMJoan Cooper1994-06-27UHC-48751-848585513148572 Forest Ave, Scottsdale, AZ0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106744ENRRobert K Boyd2003-05-28UHC-91770-2651496064489733 Highland Ave # 625, Miami, FL, 331680.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-417478CLMWillie R Woods1981-12-09—29947572339597 Main St, Austin, TX, 787520.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50052TPADiane A Scott1964-07-16—50667988426799 Main St, Los Angeles, CA, 900100.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
CLM-429327CLMCarl Yang1971-09-16—57327091267828 Central Ave, Plano, TX, 750170.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115948ENRHannah Lawrence1956-04-21UHC-97630-8444793702951116 Desert Sky Blvd, Mesa, AZ, 852940.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57189TPAJohn Ramos1991-11-26—2058026242626 Grand Ave, Tampa, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-53165TPAJason F Ryyan1993-06-10——1933 Lake View Rd, Gilbert, AZ, 852070.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-59790TPAHeather Waston1998-02-19——310 Main St, Plano, TX0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-130422ENRMichelle Mendez1967-12-20UHC-48161-41—1553 Hillcrest Rd, Sacramento, CA, 958200.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-125696ENRNicole P Luna2006-03-22UHC-74735-6343036911959760 Washington St, Tempe, AZ, 852560.50Middle initial moved out of first namePhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-432209CLMRaymond Maldonado1969-10-23UHC-59420-59—4552 Market St, Columbus, OH, 432850.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-62023TPASantiago Weber1961-05-14—32078469091914 Forest Ave, Austin, TX, 787030.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123745ENRDorothy Austin1949-11-11UHC-48631-1446253374698657 Oak St, Los Angeles, CA, 900680.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140898ENRRaymond C Lee—UHC-27065-5537468310242487 River Rd, Las Vegas, NV, 891710.50Name re-casedDate of birth unreadablePhone reformattedCity re-cased+3 more
ENR-140899ENRRaymond C Lee—UHC-27065-5537468310242487 River Rd, Las Vegas, NV, 891710.50Name re-casedDate of birth unreadablePhone reformattedCity re-cased+3 more
PRV-28542PRVYuki O Maldonado1980-05-26—6806785902647 Church St, Orlando, FL, 328020.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-53742TPAVincent Stevens1975-10-05—47239524321528 Baseline Rd, Sacramento, CA0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62147TPAWeyne Williamson1983-05-16UHC-45751-58—4055 Apache Blvd, Seattle, WA, 981840.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-421416CLMRebecca Mason———5546 Broadway, Glendale, AZ, 853930.50Name re-casedDate of birth unreadablePhone missing area codeAddress re-cased+3 more
CLM-424070CLMJackie Yang1938-05-18——3618 Pine Dr, Jacksonville, FL, 322740.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23194PRVSusan Hayes1957-09-13UHC-57014-2522875701862422 Sunset Blvd, Phoenix, AZ, 850530.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-114172ENRJacob Lucas1981-01-16UHC-13277-60—4313 Desert Sky Blvd, Columbus, OH, 432110.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122368ENRAbigail H Gomez1954-05-20UHC-76184-5423423804989733 Apache Blvd, Tempe, AZ, 852560.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58974TPADavid Rogers1950-12-15—69374973995317 Washington St, Mesa, AZ, 852180.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-400070CLMAmbber Wells1979-06-25—2665950799299 Meadow Ln, Houston, TX, 770140.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417500CLMDennis Parker1972-05-03UHC-00717-4950534509103033 Washington St Apt 33, Mesa, AZ0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-63488TPARachel Griffin1997-03-14—59598754038748 Hillcrest Rd, Atlanta, GA, 303900.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135189ENRLinda Mendez1987-05-08UHC-91612-2295844148849362 Willow Ct, Tempe, AZ, 852260.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-421422CLMKatherine Hughes1964-08-18UHC-58411-5395737486973745 Maple Ave # 784, San Diego, CA, 921140.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-103503ENRWayne Lawrence—UHC-78593-0549593151406617 Hillcrest Rd, Chandler, AZ, 852280.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 120 of 2,000PreviousNext