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-139720ENRSteven M Griffin2008-09-14UHC-95954-44—1826 Central Ave, Sacramento, CA, 958390.54Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-126812ENRAhmed Reid1947-12-15UHC-00042-2591923527533342 Grand Ave, Glendale, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-131422ENRFatiima Hernandez—UHC-60097-8171440032978969 Apache Blvd, Mesa, AZ0.54Name split from “Last, First”Date of birth missingPhone reformattedCity re-cased+1 more
ENR-114339ENRMariana T McDonald1963-02-15UHC-89548-2639131929296528 Sunset Blvd, Minneapolis, MN, 554590.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-134740ENRJennifer Williamson1977-01-02UHC-04711-3794041445315587 Apache Blvd Apt 18, Denver, CO, 802900.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-103252ENRPeter Scott1950-11-02UHC-43722-10—2722 Mesa Dr, Scottsdale, AZ, 852170.54Phone missing area codeSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-422463CLMDiana Cooper1993-02-21UHC-93659-248206167600855 Pine Dr, Phoenix, AZ, 850470.54Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-405452CLMAustin Simmons1962-02-28UHC-19960-7864453050031678 Palm Dr, Scottsdale, AZ, 852490.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-108797ENRAna F Rojas1971-07-05UHC-82015-88—2168 Meadow Ln Apt 31, Mesa, AZ, 852140.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-413741CLMChristian Y Burton1976-03-16UHC-48813-22—3628 Lake View Rd, Miami, FL0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-141798ENREdward O Santos1980-10-27UHC-53994-50—7324 River Rd, Charlotte, NC, 282490.54Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-117509ENRSharon G Andrews1986-06-02UHC-97557-33—8169 Main St, Fresno, CA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-139674ENRGary Wagner1964-06-27UHC-71648-5788434145977160 Desert Sky Blvd, San Antonio, TX, 782610.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
ENR-100769ENRAnthony Y Nunze1991-07-06UHC-25307-4679370436546717 Valley View Dr, Austin, TX, 787070.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-427703CLMJacqueline Mitchell1984-06-10——7226 Broadway, Denver, CO, 802230.54Name split from “Last, First”Two-digit birth yearAddress re-casedGender normalised+1 more
CLM-400268CLMDonald Ruiz1956-07-18UHC-28641-21—7520 Cedar Ln Apt 1, Tempe, AZ, 852460.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-415415CLMCarolyn Jordan1952-10-12——3878 Market St, Charlotte, NC, 282450.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-104847ENRJennifer Anderson1975-07-27UHC-24465-0742344909213368 Willow Ct, Orlando, FL, 328930.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-29294PRVAisha T Hughes2002-02-24——3610 Oak St, Las Vegas, NV, 891820.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-415798CLMJoe Diaz2001-03-25——3111 Maple Ave, Glendale, AZ0.54Two-digit birth yearZIP missingGender normalisedWhitespace trimmed+1 more
ENR-110524ENRAshey O Fernandez2003-03-19UHC-00933-5937768500036961 Lake View Rd Apt 31, Fresno, CA, 937930.54Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+1 more
CLM-406596CLMHiroshi Lewis1954-09-13——3962 Main St, Scottsdale, AZ0.54Name split from “Last, First”Two-digit birth yearZIP missingWhitespace trimmed+1 more
CLM-406093CLMAmber Valdez1954-09-28UHC-35139-2678097882087773 Highland Ave, Miami, FL, 331030.54Name split from “Last, First”Two-digit birth yearPhone reformattedState name converted to code+1 more
ENR-137999ENRWalter Payne1960-04-08UHC-73011-94—1587 Camelback Rd Apt 33, Tempe, AZ, 852290.54SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-423053CLMDennis G Ward———9793 Harbor Blvd, Plano, TX, 750670.54Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-21789PRVJake Kim—UHC-20478-9361766438229324 Indian School Rd, Charlotte, NC0.54Date of birth missingPhone reformattedState name converted to codeZIP missing+1 more
CLM-411493CLMGerald Marquez1943-05-27——7247 Valley View Dr, Tempe, AZ, 852790.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-54640TPASara Ortiz1979-04-07—30524940466585 Lake View Rd, Minneapolis, MN, 554110.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-126160ENRGery Q Nelson1968-12-10UHC-97451-6791661211821869 Oak St, San Diego, CA, 921560.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-50529TPADanielle Young1954-06-21—67338143393852 Market St, Scottsdale, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-63756TPANathan Thompson1947-04-04——8222 Jefferson Ave, Denver, CO0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-116253ENRMarcus B Cooper1952-08-23UHC-91372-6081079172101213 Indian School Rd, Glendale, AZ, 853150.54Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
PRV-21255PRVGregory Smith1984-03-20—51179602696641 Mesa Dr, Seattle, WA, 981500.54Name split from “Last, First”City re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-402008CLMArthur M Grant1960-10-23UHC-68341-6360573983633750 Sunset Blvd, Nashville, TN, 372210.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-21529PRVCarolyn Barnes—UHC-31715-5934525638708801 Broadway # 849, Plano, TX, 750340.54Date of birth unreadablePhone reformattedUnit split from streetGender normalised+1 more
ENR-109412ENRSara L Fields—UHC-44926-42—1134 Union St, Austin, TX, 787070.54Name re-casedDate of birth unreadablePhone missing area codeGender normalised+1 more
CLM-401561CLMJessica Elllis1963-07-27—88863215492220 Central Ave, Fresno, CA, 937810.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-407074CLMAngela Sanders1975-04-10——2301 Grand Ave, Jacksonville, FL, 322170.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-27650PRVJoseph Reynolds1960-03-27—27342483846878 Grand Ave, Fresno, CA0.54Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+1 more
CLM-400608CLMKenneth Dunn1950-03-15——345 Harbor Blvd # 650, Atlanta, GA, 303900.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-63133TPATimothy Simmons———4725 Ocean Ave # 843, Orlando, FL, 328720.54Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-419188CLMZachary Payne1948-03-24UHC-70686-74—4827 Baseline Rd, Eden Prairie, MN, 553980.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407888CLMRebecca F Hughes1982-04-18UHC-55608-51—6044 Palm Dr, San Diego, CA, 921700.54Two-digit birth yearState name converted to codeGender normalisedWhitespace trimmed+1 more
ENR-104840ENRDiane Y Robinson1940-05-24UHC-27610-05—6707 Spring St # 180, Orlando, FL, 328060.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-54529TPAElizabeth Morrison1967-12-24——7434 Sunset Blvd, Fresno, CA, 937230.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-118983ENRDiego F Ramos2004-01-13UHC-29121-61—4134 Maple Ave, Sacramento, CA, 958010.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-100449ENRKeyla Coleman1975-01-03UHC-81024-3561525513141530 Apache Blvd, Tampa, FL, 336060.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22275PRVValentina Price2004-04-24——9812 Meadow Ln # 599, Phoenix, AZ, 850320.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-427312CLMDouglas Edwards1996-09-28UHC-70622-63—1861 Bayshore Dr, Sacramento, CA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-405464CLMEthan Hill1966-05-05UHC-93821-06—9861 Bayshore Dr Apt 14, Mesa, AZ, 852320.54Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
100,000 rows, page 216 of 2,000PreviousNext