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-403735CLMMunoz Jeremy2005-08-02UHC-17752-21—4774 Spring St, Seattle, WA, 981820.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-423466CLMAna Thomas1983-07-19—32849167618738 Camelback Rd, Scottsdale, AZ, 852280.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410976CLMDenny Hamilton—UHC-00203-2778187750654256 Ocean Ave, Columbus, OH0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-429768CLMEric A Burke1976-06-20——5360 Valley View Dr # 611, San Diego, CA, 921940.50Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-102180ENRDonald G Ross1997-12-09UHC-84152-83—223 Indian School Rd, Charlotte, NC, 282010.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
ENR-116797ENRSophia K Robertson1942-08-12UHC-82419-72—5540 Hillcrest Rd, Austin, TX, 787030.50Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+3 more
PRV-26497PRVJudy A Edwards1992-08-01——501 Palm Dr, Gilbert, AZ0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411007CLMJeffrey Stewart1995-03-24UHC-18721-5520695388876049 Grand Ave, Columbus, OH, 432890.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-110260ENRPeter M Gonzalez1995-02-07UHC-67948-80—6218 Mesa Dr Apt 12, Scottsdale, AZ, 852460.50Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
ENR-102257ENRAlex R Marquez1969-06-04UHC-60235-8275528374495581 Lincoln Way, Minneapolis, MN, 554130.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22633PRVKathryn Bailey1952-03-04—38866207374062 Baseline Rd # 826, Tampa, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-130510ENRAhmed I Hayes1998-05-03UHC-61342-464545116766896 Bayshore Dr Apt 38, Plano, TX, 750560.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-107657ENRBryan V Carr1959-11-01UHC-84837-9593848822317382 Pine Dr, Atlanta, GA, 303490.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-129663ENRDeborah W Willis1975-02-17UHC-78282-1321167272612399 Harbor Blvd, Miami, FL0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133627ENRRoger E Ortiz1980-03-26UHC-11679-6151073343643575 Baseline Rd, Austin, TX0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-120166ENRDanielle Sims1961-10-28UHC-89107-0123947570393165 Willow Ct Apt 40, Tampa, FL, 336070.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-62800TPAHarold Olson1982-04-21——2989 Baseline Rd Apt 30, Tucson, AZ, 857640.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-128771ENRJeffrey W Harrison1942-09-28UHC-17502-0755929090246635 Canyon Rd, Las Vegas, NV0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419431CLMChristine Stevens1983-06-13—41594417399540 Broadway, San Antonio, TX, 782150.50Name split from “Last, First”Two-digit birth yearPhone reformattedAddress re-cased+3 more
TPA-59117TPAChristina Nichols———749 Forest Ave, Fresno, CA, 937490.50Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-141061ENRMargaret T Watson2007-04-27UHC-53720-0475224041245608 Elm St # 807, Orlando, FL, 328830.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-139380ENROlivia S Jackson1939-08-05UHC-00850-9456266985098395 Highland Ave # 437, Dallas, TX, 752860.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-55642TPATheresa Campbell1986-01-26—96696686957253 Ocean Ave # 451, Seattle, WA, 981950.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-134762ENRNathan S Kennedy1971-07-24UHC-94717-3195242106451676 Spring St, Mesa, AZ, 852440.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-137919ENRHannah Valdez1969-03-27UHC-12876-94—4569 Baseline Rd, Glendale, AZ, 853570.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107574ENRBilly W King1968-10-17UHC-34428-447933475889381 Sage Ct, Houston, TX, 770980.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141175ENRElizabeth D Matthews1994-08-26UHC-83163-5962575997988220 Bayshore Dr, Orlando, FL, 328550.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415766CLMMason Castro1957-09-28UHC-01653-7276440396754926 Main St, Austin, TX0.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-115274ENRAndrea A Espinoza1995-10-20UHC-38500-6182480331904990 Church St Apt 14, Eden Prairie, MN, 553120.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
TPA-54783TPAChristian Le1971-11-18—75892277887506 Mountain View Dr, San Diego, CA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-142613ENRDouglas L Lucas1944-09-12UHC-56127-3778370589632791 Forest Ave Apt 37, Las Vegas, NV, 891770.50Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-63628TPAJulie C Walsh1980-09-08—78531364714721 Meadow Ln, Fresno, CA, 937560.50Date of birth reformattedPhone reformattedSSN last four extractedState name converted to code+3 more
ENR-126444ENRDonna Z Mitchell1966-06-07UHC-43058-432985896706723 Camelback Rd, Chandler, AZ0.50Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-139273ENRLawrence D Rojas1948-07-10UHC-94431-484986509324856 Church St, Orlando, FL, 328490.50Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-410161CLMAlexander Carpenter1948-07-15UHC-30993-74—1607 Oak St, Orlando, FL, 328110.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111394ENRAnthony OJunk1950-11-25UHC-06142-4756934138867510 Camelback Rd, Dallas, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428453CLMMatao Prak2002-04-13UHC-21681-06—5295 River Rd, Denver, CO0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-130226ENRMychelle Gordon1948-04-16UHC-80137-39—470 Valley View Dr, Houston, TX, 770490.50Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+3 more
PRV-22278PRVHenry Palmer2001-07-28UHC-86219-27—6770 Sage Ct Apt 28, Tucson, AZ, 857210.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-63278TPAJoyce Berry1984-05-17—61687456445274 Palm Dr, Gilbert, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-50821TPAEthan A Stephens1996-04-21——7458 Washington St, Eden Prairie, MN, 553370.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135944ENRChristian Holmes1951-08-01UHC-55279-9854948752854067 Highland Ave Apt 4, Minneapolis, MN, 554740.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-128320ENREmily A Wagner1940-01-05UHC-20500-138417400837956 Pine Dr, Glendale, AZ, 853070.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59855TPAWayne Thmas1954-02-10UHC-60306-66—4016 Jefferson Ave, Seattle, WA, 981680.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-138354ENRJulie N Gray1940-07-17——9882 Hillcrest Rd, Miami, FL, 331430.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-114254ENRAmy Soto1985-05-18UHC-23381-5183166484874411 Sunset Blvd, Minneapolis, MN, 554730.50Two-digit birth yearPhone reformattedMember ID reformattedSSN last four extracted+3 more
ENR-142567ENRChristina P Williamson1977-02-26UHC-18331-3832723712182552 Apache Blvd, Minneapolis, MN, 554220.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
PRV-25476PRVLawrence Morris1965-03-05—95221469726621 Central Ave Apt 5, Jacksonville, FL, 322580.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-64410TPAMary Foster1978-06-27UHC-70030-6896725936974855 Mesa Dr # 101, San Diego, CA0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-422165CLMBilly R Collins1941-06-06——1834 Mountain View Dr, Austin, TX, 787620.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
100,000 rows, page 118 of 2,000PreviousNext