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-112917ENRJerry L Nelson2005-05-26UHC-34021-9184831902734180 Apache Blvd, Charlotte, NC, 282500.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428462CLMBetty Weber1956-07-23UHC-81512-0155079619979852 Spring St Apt 40, Miami, FL, 331180.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-118372ENRDot Perry1999-05-01UHC-17361-72—769 Harbor Blvd, Minneapolis, MN, 554480.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-120712ENRWilliam O Marquez1979-01-28UHC-52616-48—8067 Apache Blvd, Tempe, AZ, 852390.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-61570TPALcuia Morrison1949-08-08——3272 Forest Ave, Dallas, TX, 752430.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-118508ENRMargaret A Olson1958-11-22UHC-41517-044358121706222 Desert Sky Blvd, Gilbert, AZ, 852840.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139685ENRKaren M Alexander1975-02-26UHC-57783-2750693899026849 Cedar Ln, Nashville, TN, 372540.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60721TPASteve Boyd2007-08-18——283 Spring St, Plano, TX, 750940.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-431724CLMBeverly Carlson1998-10-09UHC-97520-90—834 Grand Ave Apt 27, Fresno, CA, 937080.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-141316ENRPamela Young—UHC-52866-4198832374133553 River Rd Apt 38, Columbus, OH, 432800.50Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
CLM-402916CLMRoy Tucker1946-01-17UHC-34706-33—7341 Oak St, Atlanta, GA, 303000.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-116497ENRPriay Wright1951-01-21UHC-02911-9042833271256085 Baseline Rd, Jacksonville, FL, 322230.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-108247ENRCheryl N Scott1991-02-23UHC-34552-4238899889928386 Lake View Rd, Tempe, AZ, 852000.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-103251ENRCJunk1977-12-02UHC-33344-7022083981876511 Harbor Blvd, Tampa, FL, 336080.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24668PRVMarcus Gardner1991-03-10UHC-24243-4498092670869015 Meadow Ln, Sacramento, CA, 958900.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-420652CLMChristopher Russell1958-05-19UHC-40318-8476788807641159 Willow Ct, Houston, TX, 770050.50Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
CLM-421621CLMOlivia Gonzales1943-12-08UHC-00411-1896829946438846 Apache Blvd, Seattle, WA, 981510.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-133175ENRNathan Y Patterson1954-10-23UHC-45106-0790544852415732 Harbor Blvd, Los Angeles, CA, 900660.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
ENR-100410ENRKelly Hugehs1982-12-05UHC-94709-0923038099482624 Park Pl, Orlando, FL, 328920.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406107CLMAdam R Collins1975-06-08—39958480232667 Canyon Rd, Tucson, AZ, 857650.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101676ENRScott J Garrdner1995-05-09UHC-89463-2780723641227640 Central Ave Apt 36, Las Vegas, NV, 891110.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-101675ENRScott J Garrdner1995-05-09UHC-89463-2780723641227640 Central Ave Apt 36, Las Vegas, NV, 891110.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-29119PRVSusan Knight1999-02-05—60931488001461 Mesa Dr, Gilbert, AZ, 852990.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-423720CLMJoran B Thomas1947-07-03UHC-53826-54—1659 Desert Sky Blvd Apt 24, Tampa, FL, 336020.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-414712CLMEmily Matthews1969-03-01UHC-29986-98—7506 Indian School Rd # 467, Houston, TX0.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-416393CLMEric Schmidt1945-11-23——2124 Forest Ave, Sacramento, CA, 958290.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-121329ENRAnthony H Rodriguez2002-10-08UHC-83511-5968724009601004 Palm Dr, Minneapolis, MN, 554570.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-403480CLMHiroshi Wood1960-10-20UHC-74279-3493543018958320 River Rd, Eden Prairie, MN, 553500.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-416027CLMBrenda Nguyen1950-10-10UHC-96686-39—5028 Harbor Blvd, San Diego, CA, 921460.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121860ENRTerry Jensen1940-09-26UHC-66597-64—8449 Mountain View Dr # 892, Mesa, AZ, 852490.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-53188TPARihard Santos1947-06-15——7248 Main St, Mesa, AZ, 852170.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-126484ENRAnna P Watkins1983-08-25UHC-81236-85—5278 Sunset Blvd, Seattle, WA, 981290.50Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+3 more
CLM-400028CLMKathryn Austin1955-03-27UHC-56978-4920137662358582 Union St, Tampa, FL, 336030.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432087CLMBruce Collins1964-06-23——8936 Desert Sky Blvd, Gilbert, AZ, 852900.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432088CLMBruce Collins1964-06-23——8936 Desert Sky Blvd, Gilbert, AZ, 852900.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-103430ENRMelissa Hart2005-02-10UHC-06739-2333551636404588 Baseline Rd, Atlanta, GA0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-22783PRVValentina Rios1989-10-21—45177718172665 Harbor Blvd, Orlando, FL, 328870.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59830TPAMichael Reynolds2006-01-17—44272165626996 Cedar Ln, Dallas, TX, 752890.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103296ENRMateo Jackson1990-04-07UHC-48696-5094947116963971 Lincoln Way # 814, Las Vegas, NV, 891460.50Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more
CLM-412124CLMJeffrey Gonzalez1980-02-24——4581 Meadow Ln, Austin, TX0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
CLM-419853CLMRoy Mils1963-12-12UHC-46354-30—5385 Elm St, Minneapolis, MN, 554730.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424756CLM—Junk1948-08-09UHC-15768-9566529518291765 Mesa Dr, Minneapolis, MN, 554620.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103057ENRHeather G Boyd1954-10-26UHC-21223-1895199577814167 Ridge Rd, Minneapolis, MN, 554920.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-28627PRVRaymond J Day1984-07-02—83725692298570 Main St, Miami, FL, 331530.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-120155ENRJulie Allen2006-07-18UHC-71841-709586179676455 Indian School Rd, Dallas, TX, 752150.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422216CLMYuki Smith1995-02-28UHC-02831-9542155422418941 Highland Ave, Phoenix, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-110775ENRKayla Johnson1990-01-07UHC-82773-2160197145839081 River Rd, Tampa, FL, 336390.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-117553ENRMateo N Bowman—UHC-22409-0626920967154933 Bayshore Dr, Glendale, AZ, 853590.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-26744PRVCheryl Barnes1966-10-02UHC-88098-4378421844086986 Mountain View Dr, Tempe, AZ, 852860.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415816CLMPatricia M Payne2003-11-14UHC-57067-49—4502 Cedar Ln, Minneapolis, MN, 554270.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
100,000 rows, page 130 of 2,000PreviousNext