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-429134CLMJuan Murray—UHC-76789-10—9062 Park Pl, Gilbert, AZ, 852630.64Date of birth missingStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-428292CLMBreda K Price1950-07-23UHC-49836-10—553 Forest Ave, Atlanta, GA, 303970.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416601CLMLogan Baiey2001-10-07—21868128044259 Indian School Rd, Minneapolis, MN, 554130.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424566CLMDiana Castro1977-10-11UHC-13008-27—2172 Ocean Ave, Orlando, FL, 328380.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428216CLMRebecca Hamilton1954-02-23——2665 Indian School Rd, Plano, TX, 750190.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-423351CLMMartha Z Elliott1939-10-21UHC-66010-71—2668 Ridge Rd, Orlando, FL, 328090.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-401195CLMNoah Wast2008-12-14UHC-54131-6839562484275602 Central Ave, Denver, CO, 802640.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-401194CLMNoah Wast2008-12-14UHC-54131-6839562484275602 Central Ave, Denver, CO, 802640.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-431734CLMNicholas Adams1953-12-23UHC-38542-81—8975 Grand Ave # 955, Atlanta, GA, 303940.64Name split from “Last, First”Unit split from streetCity re-casedPlan code upper-cased+2 more
CLM-431853CLMGomez Betty1969-12-05—57788857537051 Spring St, Sacramento, CA, 958480.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422776CLMDaniel Reid1980-05-26UHC-60165-93—7481 Park Pl, Houston, TX0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-403548CLMKelly Shaw1994-12-10UHC-70062-36—7662 Lake View Rd, Chandler, AZ, 852650.64Member ID reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-426180CLMSaen Crawford1993-12-28UHC-87115-6871783954612140 Maple Ave, Las Vegas, NV, 891070.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-404598CLMBrian McCoy1948-03-27UHC-41653-53—5981 Hillcrest Rd, Seattle, WA, 981020.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-409303CLMIsabella Carr1944-10-15UHC-90357-2794140018029474 Church St, Scottsdale, AZ, 852890.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422803CLMSims Sharon1954-10-15UHC-25011-43—6678 Canyon Rd, Atlanta, GA, 303490.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411666CLMHeather M Rodriguez1960-12-16—56885035375388 Valley View Dr, Houston, TX, 770980.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416469CLMRaymond C Santos1959-02-12UHC-31261-86—1830 Spring St, Atlanta, GA, 303110.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-410550CLMGracce Ortea1962-04-12——8559 Meadow Ln, Nashville, TN, 372800.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-409862CLMAbigail Vargas2005-06-26——3980 Willow Ct, Charlotte, NC, 282960.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431154CLMPatrick C Rios1957-01-19—93176990262799 Washington St, Plano, TX0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401509CLMMary Murray1979-11-05——4644 Indian School Rd, Atlanta, GA, 303580.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-414205CLMHeather Simpson—UHC-44129-0770527443714087 Apache Blvd, Plano, TX, 750050.64Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429476CLMMegan Mejia1982-04-28—38188111282979 Ridge Rd, Gilbert, AZ, 852970.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407536CLMJose Q Silva1944-11-08—3675180514—0.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-430944CLMJoan Z Santiago1960-05-03——7617 Lincoln Way Apt 9, Seattle, WA, 981240.64Middle initial moved out of first nameName re-casedUnit split from streetCity re-cased+2 more
CLM-417942CLMAndrew Matthews1977-04-05—78121819519858 Baseline Rd, Orlando, FL, 328950.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413818CLMAnn Salazar1991-01-03—75167760644627 Union St, Phoenix, AZ, 850890.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-421540CLMFrances Ruiz1994-03-16UHC-53327-52—9212 Main St, Atlanta, GA, 303530.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-423989CLMRandy Park1976-06-27—38245385623567 Cedar Ln, Tampa, FL, 336470.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-408950CLMSara Hansen1957-05-12UHC-37950-6573689021898943 Central Ave, Tampa, FL0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-408951CLMSara Hansen1957-05-12UHC-37950-6573689021898943 Central Ave, Tampa, FL0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-424901CLMFrank Robertson1984-02-24UHC-54618-2245825975283126 Lincoln Way, Atlanta, GA, 303720.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419798CLMTyler Rice1994-08-12—67337912499763 Spring St, Orlando, FL, 328550.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-431201CLMBradley Jnes1962-03-17UHC-59050-84—6499 Bayshore Dr, Houston, TX, 770640.64Name re-casedDate of birth reformattedMember ID reformattedState name converted to code+2 more
CLM-421525CLMBevery Fox1990-03-13UHC-82946-0246225872251338 Park Pl, Las Vegas, NV0.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-420837CLMKaren Martin1984-04-01UHC-08306-9924150293473754 Main St, Miami, FL, 331490.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404733CLMPatricia Simmons1963-12-19UHC-34156-49—320 Sage Ct Apt 1, Los Angeles, CA, 900290.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-410010CLMCynthia Contreras1978-03-06UHC-50913-7178677743874353 Washington St, Phoenix, AZ, 850430.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409883CLMTimothy Mills—UHC-97279-49—4893 Valley View Dr, Gilbert, AZ, 852840.64Name re-casedDate of birth unreadableCity re-casedState name converted to code+2 more
CLM-423154CLMMatthew Ferguson1995-03-20UHC-66125-48—1582 Camelback Rd, Houston, TX, 770860.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400478CLMHiroshi Ortega1979-11-11UHC-36461-06—188 Elm St, Austin, TX, 787990.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-406776CLMCarl Owens2001-01-10—82430716861298 Forest Ave, Minneapolis, MN, 554980.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429695CLMRobert Brooks1999-02-24UHC-69296-5558055955755314 Palm Dr, Fresno, CA, 937220.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-421162CLMTeresa Harrison1951-12-01—68263694158615 Palm Dr, Dallas, TX, 752430.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430478CLMNicholas Oliver1967-01-18——7570 Lake View Rd, Houston, TX, 770500.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-409995CLMJean Williamson1954-07-12——5902 Apache Blvd, Seattle, WA0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-428583CLMMelissa Valdez1958-04-10——1948 Lincoln Way # 203, Fresno, CA, 937400.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-401930CLMCamila Gutierrez1981-01-01UHC-50330-4781842897364059 Maple Ave, Glendale, AZ, 853430.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413866CLMLinda Vargas1986-06-11UHC-27818-1691880994949669 Mountain View Dr, Scottsdale, AZ, 852050.64Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
32,829 rows, page 139 of 657PreviousNext