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, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-417265CLMJack Alexaander1971-04-20UHC-89498-087237404966—0.66Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed+1 more
CLM-401546CLMMichael Clark1966-05-02——3630 Maple Ave, Denver, CO, 802320.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-400808CLMKathleen Soto1939-10-26UHC-10461-058439704719—0.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
CLM-412072CLMKevin Z Mejia1989-03-13UHC-05080-5787490239626452 Ridge Rd, Minneapolis, MN, 554860.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-424492CLMRyan Ramirez1940-06-16UHC-68274-91—2106 Cedar Ln Apt 4, Sacramento, CA, 958450.66Name split from “Last, First”Date of birth reformattedUnit split from streetWhitespace trimmed+1 more
CLM-403192CLMMary U Daniels1969-09-15UHC-02753-64—3406 Market St, Denver, CO, 802590.66Street suffix standardisedAddress re-casedState code upper-casedGender normalised+1 more
CLM-427121CLMJordan Padilla2000-03-12UHC-26828-2739546947041639 Baseline Rd, Phoenix, AZ, 850320.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-426822CLMRebecca Rodriguez1964-11-20UHC-98034-1069477123265378 Harbor Blvd Apt 1, Seattle, WA, 981460.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-427420CLMJerry Weaver2001-11-04UHC-98671-03—4457 Central Ave, Atlanta, GA, 303400.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-413087CLMSteve Davis1973-10-19UHC-99945-24—907 Main St, Nashville, TN, 372470.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-409767CLMGloria Snyder1959-11-08UHC-20521-89—8929 Mountain View Dr Apt 13, Fresno, CA, 937880.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-411357CLMTheresa Ferguson2000-05-07UHC-58580-76—9633 Palm Dr, Tucson, AZ, 857120.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-410928CLMJooyce A Herrera1942-06-21UHC-61035-8857574030812531 Ridge Rd, Dallas, TX0.66Phone reformattedState code upper-casedZIP missingGender normalised+1 more
CLM-418642CLMCamila Gomez1964-07-01UHC-71049-16—995 Indian School Rd, Glendale, AZ, 853640.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-413099CLMSofia Lewis1938-03-27UHC-91831-67—3032 Valley View Dr, Mesa, AZ, 852610.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-408553CLMMariana Anderson2000-10-14UHC-20476-188244073420340 Ocean Ave, Columbus, OH, 432740.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425055CLMPatricia Martin1947-04-24UHC-85046-13—1060 Desert Sky Blvd # 860, San Antonio, TX, 782640.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-430586CLMLaura N McDonald1991-03-11UHC-97504-92—8336 Market St, Miami, FL, 331460.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-414829CLMHenry Perkis1980-07-05—45190605105280 Camelback Rd, Miami, FL, 331290.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-427358CLMRuth Garrett2003-10-09UHC-34655-4395291436823904 Baseline Rd, Orlando, FL, 328820.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-432111CLMPatricia Z Watson1939-08-16—67881581355752 Desert Sky Blvd, Eden Prairie, MN, 553520.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-428599CLMNancy Harvey1994-03-19UHC-47422-6024373229284513 Palm Dr, San Diego, CA, 921690.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-427594CLMNathan H Wong2001-08-11UHC-21440-4276224124397166 Sage Ct, Phoenix, AZ0.66Phone reformattedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-429900CLMDiego M Knight1939-10-11UHC-87115-853115284149—0.66Name split from “Last, First”Two-digit birth yearPhone reformattedPlan code upper-cased+1 more
CLM-404924CLMNoah Oliver1942-01-05UHC-49295-92—8554 Mountain View Dr, Minneapolis, MN, 554240.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-407140CLMAlice N Spencer1967-03-01—54421205084684 Mountain View Dr, Houston, TX, 770170.66Two-digit birth yearCity re-casedState name converted to codeWhitespace trimmed+1 more
CLM-411486CLMNathan Palmer1974-01-04UHC-78327-0942057279837701 Ocean Ave Apt 18, Tampa, FL, 336690.66Phone reformattedUnit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-413586CLMChristian Gonzalez1979-07-21UHC-05076-98—8471 Sage Ct, Tucson, AZ, 857350.66Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-406866CLMAlexander Davis1979-12-27UHC-21797-46—8974 Elm St, Scottsdale, AZ, 852950.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-431934CLMAustin Bradley1943-08-01—76260664299838 Palm Dr, Austin, TX0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-408479CLMSharon Maldonado1972-08-13UHC-56381-23—3759 Maple Ave, Mesa, AZ, 852810.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-407104CLMEmmma Harrison1966-03-10UHC-63140-98—344 Grand Ave, Tampa, FL, 336260.66Name re-casedPhone missing area codeCity re-casedGender normalised+1 more
CLM-406963CLMDiana Ramos1994-10-07UHC-98291-0970074480068705 Pine Dr, Atlanta, GA, 303350.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-407464CLMMateo Ryan1956-10-22UHC-46740-85——0.66Name re-casedPhone missing area codeGender normalisedWhitespace trimmed+1 more
CLM-413607CLMDavid Shaw1953-04-17UHC-39003-1259838593698652 Main St, Miami, FL, 331650.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-418035CLMWilliam Williams1953-12-19——6941 Elm St, Scottsdale, AZ, 852390.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-418049CLMSamantha X Olson1980-08-18UHC-70649-18—23 Desert Sky Blvd, Fresno, CA, 937680.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-419762CLMCynthia Carlson1994-02-25UHC-58426-35—7120 Oak St # 464, Las Vegas, NV, 891100.66Name re-casedDate of birth reformattedUnit split from streetGender normalised+1 more
CLM-404466CLMDan Carroll2008-09-22UHC-28665-19—4534 Highland Ave, Charlotte, NC, 282860.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-430584CLMTheresa U Johnson2004-05-10——8060 Desert Sky Blvd # 308, Charlotte, NC, 282540.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412818CLMLisaJunk1985-07-09UHC-46841-84459444979233 Grand Ave, Gilbert, AZ, 852560.66Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
CLM-430790CLMCamila Russell2008-11-10—94177435864980 Valley View Dr, Mesa, AZ, 852400.66Two-digit birth yearPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-422895CLMAustin L Contreras1946-03-21—36522391381920 Pine Dr, Miami, FL0.66City re-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-413111CLMCarol Fowler1995-04-09UHC-12538-47—7684 Lincoln Way, Sacramento, CA, 958210.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-418416CLMRyan Hunter1965-10-05UHC-48235-6397264298277479 Forest Ave, Charlotte, NC, 282090.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419864CLMSamuel N Maqruez1995-12-04UHC-23159-56—927 Church St # 957, Phoenix, AZ, 850930.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-422213CLMDiana Spencer1942-08-19UHC-15396-79—1835 Oak St, Denver, CO, 802190.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-426267CLMOlivia L Soto1941-06-17—59366361808769 Grand Ave, Dallas, TX, 752540.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407903CLMDanielle A Murphy2000-11-26UHC-76083-23—6064 Grand Ave, Tampa, FL, 336050.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-428603CLMAisha Rojas1956-12-18UHC-94886-3329882192866374 Ocean Ave, Dallas, TX0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
32,829 rows, page 195 of 657PreviousNext