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

Claims, flag “Date of birth reformatted”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth reformattedClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-427218CLMLawrence Fuller2000-12-09UHC-49156-239783604569—0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-428460CLMKyle Peters1955-11-12——6379 Willow Ct, Orlando, FL, 328360.94Date of birth reformattedPlan code upper-casedPlaceholder values cleared
CLM-407528CLMJustin Little1966-06-17—65791153377591 Cedar Ln, Houston, TX, 770070.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-419257CLMSteve Torres1945-04-10UHC-87307-19484218094736 River Rd, Tempe, AZ, 852190.94Date of birth reformattedPhone reformattedCity re-cased
CLM-416140CLMKaren Cook1983-02-04—6046958693—0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-431710CLMAndrea Matthews1974-04-26UHC-26184-74——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-430598CLMNicholas F Lee1982-02-25UHC-39448-14——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-422432CLMElijah G Harper1947-09-17UHC-09620-25—4099 Ridge Rd, Tempe, AZ, 852290.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-428342CLMBetty M Oliver1971-09-12UHC-97972-6263223833887470 Church St, Denver, CO, 802580.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-406032CLMWei Jimenez1995-10-22——4995 Main St, Mesa, AZ, 852800.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-421524CLMDylan T Hansen1994-07-05——4500 River Rd, Plano, TX, 750540.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-423960CLMChristina E Franklin1966-05-21UHC-33028-02——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-413686CLMYuki Moreno1965-09-11—4614165869—0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-430280CLMRuth Baker1971-12-09———0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-402254CLMDebra Hoffman1989-03-03UHC-99555-5984271034129110 Grand Ave, Scottsdale, AZ, 852330.94Date of birth reformattedPhone reformattedWhitespace trimmed
CLM-418939CLMHelen Johnson1977-05-18——9802 Bayshore Dr, Los Angeles, CA, 900190.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-413588CLMMelissa White2000-05-10———0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-403701CLMArthur Little1954-06-05——7943 Jefferson Ave, Gilbert, AZ, 852170.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-412756CLMWayne Bell1972-01-26—87896316398916 Main St, Houston, TX, 770890.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-419344CLMJeremy Gomez1972-08-09UHC-62554-77—5315 Mesa Dr, Minneapolis, MN, 554620.94Date of birth reformattedState code upper-casedPlaceholder values cleared
CLM-423725CLMMadison Garza2005-11-04UHC-78183-734737013433—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-401921CLMStephanie Cole1997-09-22UHC-53992-59——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-408114CLMJulie A Fisher1941-03-04UHC-13284-9859325559232455 Camelback Rd, Sacramento, CA, 958760.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-425503CLMJulie Pena1975-02-28UHC-11736-494366378174—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-425562CLMJanet Franklin1990-11-14UHC-81219-755357201273—0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-418048CLMSamantha Olson1980-08-18UHC-70649-188876555252—0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-424126CLMPhilip Guzman1996-01-05UHC-22868-86—8571 Main St, Orlando, FL, 328860.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-403255CLMGary Palmer1948-08-24——4655 Meadow Ln, Los Angeles, CA, 900910.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-427411CLMRay Fox2005-05-06UHC-79354-74—9046 Desert Sky Blvd, Minneapolis, MN, 554840.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-418479CLMTheresa D Grray1969-05-05UHC-34684-202664817570—0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-421327CLMRebecca Mitchell1963-12-03UHC-70908-34——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409884CLMEmily F Burke1989-12-12UHC-42752-22——0.94Date of birth reformattedMember ID reformattedPlaceholder values cleared
CLM-406256CLMLinda Wood2007-12-16—5125269792—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-400017CLMNancy Campbell1991-05-20———0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-419703CLMGabriel Thomppson1997-11-23UHC-19883-889387982419—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-430392CLMKelly Diaz1996-08-11UHC-26056-232416917221—0.94Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-424471CLMGerald Olson2002-01-08——5297 Pine Dr, Jacksonville, FL, 322460.94Date of birth reformattedEmail lower-casedPlaceholder values cleared
CLM-425220CLMMichelle Tucker1939-07-22UHC-99041-10—5313 Broadway, Gilbert, AZ, 852690.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-401157CLMAlexander Porter1991-06-08UHC-74328-8390926334956276 Mesa Dr, Mesa, AZ, 852640.94Name re-casedDate of birth reformattedWhitespace trimmed
CLM-403583CLMFrank Thompson1992-04-06UHC-37893-53——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-423000CLMAshley Castro1952-07-15———0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-432818CLMBrittany Reyes1949-01-21UHC-87647-23——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-410689CLMAhmed Robertson1973-04-27UHC-53183-426092877561—0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-408450CLMChristian J Marshall1994-01-04UHC-58093-6984850916165719 Sunset Blvd, Minneapolis, MN, 554780.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-420358CLMDouglas Allen1953-09-20UHC-14793-72——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-429307CLMAlan Contreras1948-01-11———0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-428976CLMMadison Mendoza1979-10-28UHC-78916-73——0.94Name re-casedDate of birth reformattedPlaceholder values cleared
CLM-426749CLMRoger Nguyen1946-11-14UHC-32952-64——0.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-407789CLMKenneth Palmer1949-10-25——5068 Lake View Rd, Orlando, FL, 328100.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-417289CLMJacob Russell1961-03-27——2233 Broadway, Dallas, TX, 752840.94Date of birth reformattedWhitespace trimmedPlaceholder values cleared
10,559 rows, page 185 of 212PreviousNext