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-406217CLMFrank Armsrong1977-11-07———0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-421662CLMHeather F Duncan1946-05-05UHC-86333-1079398818377012 Central Ave, Mesa, AZ, 852310.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-411185CLMAlan G Hoffman1983-06-23UHC-11329-1264965406883527 Bayshore Dr, Fresno, CA0.66Two-digit birth yearPhone reformattedZIP missingWhitespace trimmed+1 more
CLM-417859CLMKevin V Walker1985-12-27UHC-67304-99—8453 Washington St, Los Angeles, CA, 900850.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419165CLMAnthony Wells1955-06-12UHC-46535-8189362213468883 Central Ave, Glendale, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-419580CLMVincent Tran1989-08-14UHC-61998-9648398172733950 Harbor Blvd, San Diego, CA, 921720.66Phone reformattedSSN last four extractedZIP+4 trimmedWhitespace trimmed+1 more
CLM-429619CLMPatrcia Murray1950-05-27UHC-35124-0180661146089786 Ridge Rd, San Diego, CA, 921520.66Two-digit birth yearPhone reformattedState code upper-casedGender normalised+1 more
CLM-429618CLMPatrcia Murray1950-05-27UHC-35124-0180661146089786 Ridge Rd, San Diego, CA, 921520.66Two-digit birth yearPhone reformattedState code upper-casedGender normalised+1 more
CLM-404536CLMJohn West1938-01-22UHC-39164-0177499196688348 Market St, Austin, TX, 787480.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-415700CLMJudy Burns1980-12-09——3367 Maple Ave, Seattle, WA, 981090.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-416936CLMAmber Vasquez1950-05-03——3362 Pine Dr, San Antonio, TX, 782520.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-400255CLMMarcus Garcai1986-01-10—38193134103958 Mesa Dr, Tempe, AZ, 852460.66Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed+1 more
CLM-416768CLMSamuel H Montgomery1946-10-24UHC-58307-57—1004 Pine Dr, Sacramento, CA, 958790.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-417634CLMAdam Ruiz2002-03-19——4394 Apache Blvd, Charlotte, NC, 282510.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-418637CLMNatalie Hoffman1973-05-14UHC-91848-90—4436 Highland Ave, Mesa, AZ, 852170.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402544CLMPatricia Bryant1959-03-10UHC-41750-1643147581741618 Central Ave, Houston, TX, 770760.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-416246CLMNicholas Alexander1989-04-25—79163543006192 Canyon Rd, Mesa, AZ, 852820.66Name re-casedPhone reformattedState name converted to codeGender normalised+1 more
CLM-404412CLMJeffrey Jordan1968-06-26——5488 Canyon Rd, Atlanta, GA, 303890.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421707CLMLauren D Montgomery1963-12-10UHC-09615-9074283554492528 Desert Sky Blvd, Minneapolis, MN, 554950.66Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-415417CLMWilliam J Reynolds1951-06-25UHC-07356-49—8589 Harbor Blvd, Minneapolis, MN, 554490.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407966CLMRyan Howall1982-04-25UHC-91148-6667254808554377 Forest Ave, Miami, FL, 331760.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413020CLMJuan Guerrero1963-05-04——7648 Broadway, Atlanta, GA, 303000.66Phone missing area codeAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-403034CLMNoah M Morales———8322 Maple Ave, San Antonio, TX, 782120.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407712CLMNatalie Wagner1964-07-26UHC-26872-91—9743 Sunset Blvd, Orlando, FL, 328180.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-428043CLMAustin B Santos1979-06-09UHC-34443-43—457 Oak St, Chandler, AZ, 852370.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-428044CLMAustin B Santos1979-06-09UHC-34443-43—457 Oak St, Chandler, AZ, 852370.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-414228CLMJesse Reyes2006-02-10—27221199433997 Canyon Rd, Mesa, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-410016CLMNoah Estrada2005-04-15——6764 Hillcrest Rd, Scottsdale, AZ, 852660.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-408561CLMCynthia Chen2008-03-08UHC-28065-94—7374 Lake View Rd, Charlotte, NC, 282000.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-415858CLMBrittany I Knight————0.66Name re-casedDate of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-426487CLMRoy T Henyr1976-06-24—3563988381256 Desert Sky Blvd, Plano, TX, 750540.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-401415CLMDoonald Butler1960-09-20UHC-55767-802833782540321 Jefferson Ave, Tampa, FL, 336480.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-427695CLMBilly Henderson1995-12-27UHC-53069-3861266030991253 Lake View Rd, Eden Prairie, MN, 553420.66Phone reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-415621CLMAna Walker1993-07-26—23958515208185 Camelback Rd, Fresno, CA, 937830.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412954CLMRachel I Diaz1999-12-10——9301 Highland Ave, Nashville, TN, 372320.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407409CLMAmber Z Moreno1975-03-12UHC-42609-25—7167 Elm St, Chandler, AZ, 852400.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-417009CLMCharles Porter2004-04-09UHC-37973-20—9313 Forest Ave, Sacramento, CA, 958290.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-420042CLMDaniel Parker1977-04-03——5608 Canyon Rd, Tucson, AZ, 857590.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-406550CLMRoneld Mason2007-07-18UHC-00287-86—8350 Desert Sky Blvd, Charlotte, NC, 282800.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-411650CLMAlice Red1960-03-07——11 Forest Ave, Los Angeles, CA, 900210.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
CLM-422237CLMJoseph Daniels1995-07-13——9477 Bayshore Dr # 821, Phoenix, AZ, 850370.66Name re-casedTwo-digit birth yearUnit split from streetWhitespace trimmed+1 more
CLM-401003CLMCharles Kelly1969-05-21——7308 Park Pl, Charlotte, NC0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-409660CLMSantiago Rios1946-05-18UHC-40928-4243774577588884 Pine Dr, Tucson, AZ, 857970.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-430732CLMSharon M Banks1989-05-03—95234857203155 Grand Ave, Charlotte, NC, 282260.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-402943CLMRalph F Little1971-04-28——8807 Jefferson Ave, Plano, TX, 750350.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-400750CLMVictoria Greene1976-07-22UHC-12466-94—7520 Church St, Seattle, WA, 981850.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-420237CLMKatherine Z Patel1968-05-21UHC-80935-14—4167 Main St, Houston, TX, 770920.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-416971CLMJose Williamson1947-04-24UHC-42690-5951772438566243 Ridge Rd, Tucson, AZ0.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-420633CLMCamila Hart1953-08-18UHC-37443-96—4743 Camelback Rd, Fresno, CA, 937340.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-414386CLMKayla Flores1968-07-09—32674041909041 Central Ave # 308, Eden Prairie, MN, 553090.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
32,829 rows, page 158 of 657PreviousNext