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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-428272CLMBruce G Wells2006-05-17UHC-57727-467366220522—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-121710ENRArjun E Fuller1999-03-20UHC-96702-7870794761073465 Forest Ave, Sacramento, CA, 958780.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-413448CLMEmily Sanders1943-06-20———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-109294ENRJesse Spencer1943-11-24UHC-33209-0957777045465080 Harbor Blvd, Seattle, WA, 981070.80Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased
CLM-425946CLMJustin Bennett1996-11-06UHC-31433-795368336101—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-417891CLMCharles Mithcell2008-12-26UHC-47452-548942419102—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-106850ENRJeremy Meyer1963-04-07UHC-94721-5354799135258223 Spring St, Chandler, AZ, 852770.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-63794TPAZachary Armmstrong1978-01-27——5977 Broadway, Phoenix, AZ, 850970.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-63262TPAVirginia Santiago1992-03-13—2234022365—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50755TPACamila James1990-08-22—91261685835779 Lincoln Way, Charlotte, NC, 282610.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-50754TPACamila James1990-08-22—91261685835779 Lincoln Way, Charlotte, NC, 282610.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
CLM-414420CLMGloria Richardson1981-06-07UHC-97404-89—920 Meadow Ln, Tempe, AZ, 852930.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
TPA-57970TPASofia Richards1987-11-21UHC-23021-94—2580 Desert Sky Blvd, Plano, TX, 750200.80Name split from “Last, First”Date of birth reformattedMember ID reformattedCity re-cased
ENR-104066ENRMargaret Bailey1998-01-13UHC-09162-9983159145019793 Elm St, Orlando, FL, 328040.80Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed
TPA-56741TPANanyc Boyd1967-04-18—42953820347848 Grand Ave, Glendale, AZ, 853010.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-26404PRVDebra I Holmes2003-01-12UHC-55286-1660247963036762 River Rd, Eden Prairie, MN, 553260.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-52809TPABrian Hawkins1978-08-10—65736120301350 Sage Ct, Tucson, AZ, 857830.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
PRV-26563PRVPat Ortega2001-07-20UHC-45462-68—348 Cedar Ln, Atlanta, GA, 303050.80Name split from “Last, First”Date of birth reformattedState code upper-casedPlaceholder values cleared
CLM-400655CLMPaul Jimenez1977-10-17———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-422730CLMBenjamin Fuller1964-03-15—21627390174702 Spring St, Nashville, TN, 372370.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-126414ENREugene P Soto1943-10-12UHC-95539-6473428402395141 Main St, Plano, TX, 750090.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57219TPAVirginia J Morgan1998-09-03——337 Elm St, Mesa, AZ, 852520.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55005TPAPamela Burns1944-05-11——6099 Mesa Dr, Miami, FL, 331400.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-421135CLMAmber Larson1943-12-22——9158 Washington St, Atlanta, GA, 303790.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-142630ENROmar Griffin1943-12-18UHC-82138-992444687052—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-140510ENRRonald Silva1946-07-18UHC-17595-9584054501441710 Harbor Blvd, Glendale, AZ, 853990.80Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed
TPA-60136TPAAmanda Santos1939-03-09—2179055139—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-411857CLMJson Murray1974-12-13—30190261654070 Lake View Rd, Tempe, AZ, 852730.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-123431ENRRachel L Knight1952-08-19UHC-02024-6359622986032133 Grand Ave, Fresno, CA, 937350.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-138777ENRRonald Porter2005-09-09UHC-07489-348736252727786 Mesa Dr, Eden Prairie, MN, 553390.80Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed
PRV-27573PRVDavis Zechary1984-02-12—82096050836064 Main St, Charlotte, NC, 282930.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
CLM-424949CLMAndrew Palmer1939-02-02UHC-25445-684727111552—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-402351CLMFrances Porter1949-01-13—6076977962173 Broadway, Tempe, AZ, 852300.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
CLM-401525CLMJean Bell2006-05-09UHC-44976-64—5048 Palm Dr, Chandler, AZ, 852090.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-401631CLMJerry Walsh1995-09-24UHC-81721-076004562286—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-136155ENRJanet S Vasquez1993-06-15UHC-66371-336954664670154 Desert Sky Blvd, Dallas, TX, 752020.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-107909ENRGeorge Hawkins1952-08-07UHC-45207-7978126243406268 Ridge Rd, Chandler, AZ, 852740.80Name split from “Last, First”Phone reformattedMember ID reformattedWhitespace trimmed
ENR-127336ENRJanice L Parker1999-11-16UHC-98137-0389340490225557 Union St, Las Vegas, NV, 891060.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-125103ENRTimothy Weaver1963-06-05UHC-19209-2654769056225192 Park Pl, Plano, TX, 750640.80Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased
ENR-127985ENRAisha Morgan1988-12-27UHC-38996-1484694965657101 Lincoln Way, Tempe, AZ, 852150.80Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed
PRV-22599PRVJack Mitchell1965-09-25—7042190444—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28247PRVRuth Meier2005-06-19UHC-88349-278647358107—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-418861CLMLuis Knight1994-04-22—55326697594894 Bayshore Dr, Dallas, TX, 752830.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
ENR-129177ENRElizabeth Walker2006-11-15UHC-77635-2372497616694254 Sage Ct, Fresno, CA, 937430.80Name split from “Last, First”Date of birth reformattedEmail lower-casedWhitespace trimmed
TPA-52968TPAEugene Elliott1945-03-11UHC-77796-837748269784—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52969TPAEugene Elliott1945-03-11UHC-77796-837748269784—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-129732ENRRussell Spencer1983-09-17UHC-70361-3424297252577801 Bayshore Dr, Austin, TX, 787660.80Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed
ENR-112199ENRMichelle X Alvarado1972-01-27—68148290363187 Harbor Blvd, Minneapolis, MN, 554610.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27987PRVSandra L Wilson1938-12-11—39980360073901 Forest Ave, Dallas, TX, 752450.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-52211TPAMichelle M Smith2003-05-10——5366 Main St, Fresno, CA, 937690.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
9,980 rows, page 172 of 200PreviousNext