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-421012CLMJoan Maldonado1990-12-10UHC-93987-6495474562091564 Ridge Rd, Tampa, FL0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58572TPAKelly Hernandez1968-02-05—36444542955878 Lake View Rd, Atlanta, GA, 303560.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23539PRVRalph K Guerrero1991-04-08—89159892263786 Palm Dr, Plano, TX, 750100.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
ENR-133524ENRFatima A Yang1960-09-27UHC-58698-1379031760004261 Washington St Apt 2, Dallas, TX, 752510.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
CLM-400383CLMEthan Burton1962-07-06UHC-46365-9873653725601411 Desert Sky Blvd, Phoenix, AZ, 850650.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-101239ENRBrandon Gonzeles1966-05-07UHC-09464-7279260315621764 Ocean Ave, Plano, TX, 750600.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-139853ENRMariana Garrett2003-11-15UHC-39140-7282973563536949 Sunset Blvd, Mesa, AZ, 852580.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417213CLMOmar Adams1972-10-03UHC-62737-7166192101108093 Canyon Rd, San Antonio, TX, 782340.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-117854ENRVincent A Wilson1981-02-24UHC-67482-9923184123373708 Jefferson Ave Apt 27, Eden Prairie, MN, 553670.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-108171ENRJerry V Chavez2003-09-16UHC-59936-83—5132 Baseline Rd, Phoenix, AZ0.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-406298CLMSarah Scott1944-05-16UHC-34036-5744646593959320 Maple Ave, Orlando, FL0.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-104628ENRMarilyn Z Elliott2008-05-15UHC-08946-0921287837191704 Union St, Atlanta, GA, 303420.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-20111PRVShirley Watson1997-06-09—73325866507724 Canyon Rd, Minneapolis, MN, 554990.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-105180ENRAlbert V Meyer1986-10-17UHC-06373-4726335904867078 Cedar Ln, Orlando, FL, 328560.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-407468CLMChristian Reynoolds1969-04-15——836 Bayshore Dr, Plano, TX, 750010.48Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
ENR-100887ENRPaul Z Jimenez1977-10-17UHC-80721-0275255587631194 Pine Dr Apt 28, Tempe, AZ, 852570.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-137559ENRValentina Scott1983-10-26UHC-56762-0134522603996070 Elm St, Gilbert, AZ, 852200.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-118232ENRNicholas Jacobs1982-08-08UHC-67353-83—9067 Meadow Ln Apt 7, Nashville, TN, 372650.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-411752CLMEmily Thompson1964-02-27UHC-60492-2285835602607291 Mesa Dr Apt 35, Charlotte, NC, 282160.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-411751CLMEmily Thompson1964-02-27UHC-60492-2285835602607291 Mesa Dr Apt 35, Charlotte, NC, 282160.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-109987ENRMateo L Rivera1958-11-09UHC-49017-4481380822223705 Spring St, Atlanta, GA, 303070.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-425818CLMChristine Wagner1989-02-28—74668063518466 Jefferson Ave, Tucson, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-115491ENRAlbert N Guzman1968-01-08UHC-34549-4940092298532821 Highland Ave, Glendale, AZ0.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133876ENRSamantha Murphy1977-09-03UHC-20022-7370034723542756 Hillcrest Rd # 384, Las Vegas, NV, 891950.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-64148TPABobyb Bailey1943-08-01——2275 Baseline Rd Apt 37, Plano, TX, 750320.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-20512PRVKing Carl1958-02-06UHC-56378-0126334047446441 Mesa Dr, Houston, TX, 770500.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-132086ENRDouglas Grant2005-04-15UHC-69967-8774527039084836 Spring St, Gilbert, AZ, 852680.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-411037CLMHeather H Lynch1996-05-02UHC-37423-636293745670695 Highland Ave, Plano, TX0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24637PRV—Junk1969-06-02UHC-33144-5280665663651367 Mountain View Dr Apt 31, Glendale, AZ, 853400.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-63664TPADylan R Stephens1982-08-03—38780700188540 Meadow Ln, Plano, TX, 750480.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-121156ENRDanielle G Fosetr1954-06-27UHC-72462-6683753954814979 Sage Ct, Orlando, FL, 328040.48Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
ENR-131463ENRPatricia C Lane1953-09-16UHC-02304-1667668950267476 Main St, Eden Prairie, MN, 553320.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133835ENRJudy Rogers—UHC-61450-8145937371431643 Bayshore Dr, Plano, TX, 750480.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-135993ENRMaria Z Patterson1984-10-12UHC-97217-2179775093522117 Lake View Rd, San Antonio, TX, 782360.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-101839ENRAmanda M Daniels1938-08-18UHC-10897-7858899865728322 Sage Ct, Nashville, TN, 372160.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101840ENRAmanda M Daniels1938-08-18UHC-10897-7858899865728322 Sage Ct, Nashville, TN, 372160.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101370ENRSndra C Burtun1954-10-04UHC-31035-2341152750356978 Willow Ct # 374, Tucson, AZ, 857900.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-109320ENRLinda Torres1990-08-06UHC-86330-69—6469 Palm Dr, Dallas, TX, 752000.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-128424ENRJanet V Marquez1965-01-24UHC-22058-1545934652386561 Maple Ave # 836, Tampa, FL, 336750.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-60639TPAJudy X Reed1995-10-25UHC-47525-60—7590 Grand Ave, Atlanta, GA, 303780.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-121423ENRLinda Berry1952-07-22UHC-94854-1690856517145051 Sunset Blvd, Minneapolis, MN, 554130.48Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-136912ENRAisha Moreno1979-05-12UHC-22386-72—8472 Mesa Dr, Phoenix, AZ, 850400.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-413581CLMStephen Hansen1985-08-18UHC-90531-9651944571553118 Sunset Blvd, Nashville, TN0.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-28265PRVRebecca Campbell1938-06-11—58777509287151 Church St, Austin, TX, 787760.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-430179CLMCarolyn I Li1943-09-13UHC-24165-9350944476902737 Lake View Rd, Minneapolis, MN0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-419905CLMChristine K Hawkins1963-02-21—47132140891463 Palm Dr, Miami, FL, 331380.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402892CLMGrace Hawkins1938-07-27UHC-70840-0658897328401559 Willow Ct, Fresno, CA, 937010.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-109549ENRSophia Edwards1955-10-02UHC-28031-9952455148394035 Spring St Apt 39, Los Angeles, CA, 900090.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-102895ENRDnenis C Sanders—UHC-72206-49—4095 Meadow Ln, Nashville, TN, 372590.48Name re-casedDate of birth unreadablePhone missing area codeMember ID reformatted+4 more
TPA-64379TPAEily Hamilton1958-04-24——1869 Apache Blvd Apt 16, San Antonio, TX, 782780.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 79 of 2,000PreviousNext