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-418453CLMJulia Jackson1987-05-03UHC-00538-03—9856 Maple Ave, San Antonio, TX, 782520.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412200CLMKaren Y Jackson1949-11-02——1976 Main St, Tempe, AZ0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
ENR-117379ENRRyan K Edwards—UHC-00951-1225222587067275 Harbor Blvd, Glendale, AZ, 853670.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141428ENRHannah G Luna1948-02-25UHC-64545-1995747527307909 Spring St, Dallas, TX, 752120.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23359PRVWayne Rice1999-12-05—3802391706103 Sunset Blvd, Fresno, CA, 937290.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135044ENRJennifer Bishop1971-11-19UHC-66354-2872993198618524 Lake View Rd # 125, Charlotte, NC, 282650.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
PRV-26445PRVDennis Diaz2005-06-03—93034902236178 Ocean Ave, Las Vegas, NV, 891290.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27914PRVElijah Campbell1959-10-22—34096784476580 Central Ave, Sacramento, CA, 958860.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58331TPAEthan Perry2007-06-27UHC-68803-96—124 Park Pl, Eden Prairie, MN, 553570.50Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
ENR-133032ENRKyle R Allen1975-06-13UHC-18084-5635189176861239 Sage Ct, Tempe, AZ, 852600.50Two-digit birth yearMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-409431CLMAhmed T Le2003-06-10UHC-34122-14—1420 Washington St # 228, Las Vegas, NV0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-131702ENRBetty W Perez1993-11-02UHC-48568-7364042208797980 Sage Ct, Houston, TX, 770450.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138358ENRAlice R Gibson1952-08-03UHC-06859-9295695657043399 Palm Dr, Los Angeles, CA0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-418744CLMMarilyn Barnes1997-03-01UHC-46631-1495466933171252 Mountain View Dr, Chandler, AZ, 852750.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430555CLMBilly Reid1999-03-09UHC-17079-68—2250 Apache Blvd, Eden Prairie, MN, 553760.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-430095CLMJean O Nelson1987-09-12UHC-20738-64—5776 Ridge Rd, Charlotte, NC, 282360.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-121858ENRMarcus Johnston1957-01-12UHC-13149-5042343056557914 Meadow Ln, Las Vegas, NV, 891670.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140952ENRMarilyn Hart1964-01-17UHC-50479-15—448 Highland Ave, Eden Prairie, MN, 553760.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-113849ENRKaren Jones2002-07-28UHC-76594-767426539630203 Washington St, Los Angeles, CA, 900290.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-142250ENRCarol X Hoffman1961-10-11UHC-22754-1861554332542719 Elm St, Mesa, AZ, 852490.50Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
ENR-106297ENRWilliam Fox1961-11-11UHC-95380-9737534896702561 Spring St, Charlotte, NC, 282430.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55115TPAAhmed Patel2005-02-09UHC-86063-13—7258 Apache Blvd Apt 7, Austin, TX, 787660.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-136311ENRAmy Fernandez1948-03-16UHC-54769-5128972047603078 Lake View Rd, Los Angeles, CA, 900290.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414674CLMRachel Ray1956-09-26——4441 Palm Dr, Fresno, CA0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-124285ENRJulia N Jackson1986-05-03UHC-00538-0377790585409856 Maple Ave, San Antonio, TX0.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101932ENRMary B Simmons1941-09-06UHC-87003-6655594995805610 River Rd, San Diego, CA0.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-106566ENRJanet D Rios1994-08-18UHC-21359-1244438763822984 Canyon Rd, Orlando, FL, 328010.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-56270TPAWeber Danielle1961-11-12—46936340009546 Valley View Dr, Scottsdale, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-128695ENRNancy Williamson1948-03-24UHC-86218-7582451174668444 Apache Blvd # 354, Fresno, CA, 937810.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
TPA-60295TPAHiroshi A Greene1999-03-25——2623 Maple Ave, Las Vegas, NV, 891760.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-139692ENRWayne Z Wells1995-08-28UHC-44029-8620152920381864 Oak St Apt 8, Nashville, TN, 372100.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402907CLMPeter Brooks1965-09-18—24746979062138 Union St, Seattle, WA, 981640.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-114201ENRDorothy Q Mason1997-01-28UHC-16584-13—8937 Desert Sky Blvd, Glendale, AZ, 853400.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50080TPAAlbert Mongomery1971-02-03——7534 Cedar Ln, Glendale, AZ0.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-135387ENRMartha P Jenkins1987-01-15UHC-38108-7329447690828650 Apache Blvd, Sacramento, CA, 958210.50Name re-casedPhone reformattedSSN last four extractedState name converted to code+3 more
CLM-400842CLMNancy Lane1944-12-15UHC-50508-5180128626617624 Main St, Columbus, OH0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55544TPASadra Nelson1965-05-01——699 Desert Sky Blvd, Fresno, CA, 937710.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-424868CLMHiroshi Brooks1990-08-15UHC-65032-3343857371302677 Washington St, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-117485ENRAlbert Chavez1977-02-08UHC-43543-7532060296936905 Maple Ave Apt 25, Fresno, CA, 937830.50Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-139771ENRJuan Owens1990-04-23UHC-80301-1596653142579414 Hillcrest Rd # 736, Orlando, FL, 328190.50Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+3 more
TPA-64095TPAJacqueline Sandoval1955-11-17UHC-05415-4870521892751902 Canyon Rd, Dallas, TX, 752370.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-112646ENRChristina Allen1957-02-22UHC-12140-6832334749325023 Apache Blvd, Charlotte, NC, 282050.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
CLM-423629CLMJoan Knight1997-11-15UHC-05751-1594147038453802 Highland Ave, Fresno, CA, 937960.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-20117PRVChristine Bennett1991-08-23UHC-46148-5964251554251835 Sunset Blvd, Glendale, AZ, 853040.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-143021ENRTyler S Anderson2002-09-16UHC-60331-66—7392 Main St, Sacramento, CA0.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-53566TPACarlos M Thomas1983-01-24——1777 Highland Ave, Houston, TX, 770340.50Name re-casedDate of birth reformattedState name converted to codeZIP+4 trimmed+3 more
ENR-107863ENRRoger Gonzalez1979-03-28UHC-13173-01—4584 Central Ave, Los Angeles, CA, 900570.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-107864ENRRoger Gonzalez1979-03-28UHC-13173-01—4584 Central Ave, Los Angeles, CA, 900570.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-422993CLMBetty G Gomez1977-06-09—3774138090347 Main St, Tampa, FL, 336320.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-102909ENRChristina Y Bradley1958-08-26UHC-61892-189852474058934 Apache Blvd Apt 11, Plano, TX, 750780.50Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+3 more
100,000 rows, page 138 of 2,000PreviousNext