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-426794CLMGeorge Ford1991-12-01—46481327278138 Spring St, Scottsdale, AZ, 852800.66Two-digit birth yearPhone reformattedCity re-casedState name converted to code+1 more
CLM-422265CLMMark Payne1972-10-19——3285 Desert Sky Blvd Apt 23, Plano, TX, 750870.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404783CLMArthur Alexander1956-08-20UHC-11557-51—4818 Market St, Nashville, TN, 372730.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-428593CLMSara Adams1958-07-08——7110 Central Ave, Phoenix, AZ, 850600.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-418315CLMJulia Collins1945-11-09UHC-49715-81—3643 Sunset Blvd, Mesa, AZ, 852670.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-406694CLMArjun Hunt———3349 Spring St, Eden Prairie, MN, 553090.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-428969CLMDorothy Hicks1946-08-25UHC-74134-54—7841 River Rd # 482, Tucson, AZ, 857550.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-413181CLMVincnet McDonald1971-06-09—95781390176869 Washington St, Tucson, AZ, 857550.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-423068CLMDenny Phillips1996-12-07—7066237718725 Grand Ave, Orlando, FL, 328220.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-430490CLMLucia P Welch1987-03-03—50145144267565 Maple Ave, Plano, TX, 750300.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425392CLMIsabella Reed1960-09-07——4548 Mesa Dr, Tucson, AZ, 857860.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-428643CLMMelissa Y Phillips2008-08-03——9369 Sage Ct # 529, Seattle, WA, 981670.66Name split from “Last, First”Unit split from streetCity re-casedEmail lower-cased+1 more
CLM-427616CLMMatthew Walker1971-05-21——8815 Harbor Blvd, Minneapolis, MN, 554770.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-427647CLMSofia Arnold1973-09-13—6218378889423 Market St, Sacramento, CA, 958430.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-404263CLMLucia Hoffman1940-02-12UHC-31201-993569658725836 Desert Sky Blvd, Seattle, WA, 981950.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-419797CLMTyler I Rice1994-08-12UHC-71226-29—9763 Spring St, Orlando, FL, 328550.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404797CLMAlice Perry—UHC-53984-3520967149019138 Harbor Blvd, Denver, CO, 802190.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-423782CLMSam Andrews2009-11-08——7446 Washington St, Las Vegas, NV, 891290.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-429341CLMEric Gonzales2001-08-13UHC-63564-60—2240 Park Pl, Mesa, AZ, 852260.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-408055CLMRuth Harper1949-07-03UHC-27779-17—2411 Mesa Dr, Miami, FL, 331650.66Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407807CLMSamantha Morris1995-01-25UHC-43300-11—921 Church St, Tucson, AZ, 857760.66Street suffix standardisedAddress re-casedState code upper-casedGender normalised+1 more
CLM-412104CLMKenneth Riley1957-05-05UHC-28168-1795992010648254 Church St, Mesa, AZ, 852440.66Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+1 more
CLM-415296CLMBrandon Watson1999-08-03UHC-65481-98—3953 River Rd, Fresno, CA, 937560.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-417343CLMKimberly Austin1999-02-22—98142867981735 Church St, Charlotte, NC, 282680.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-401464CLMLawrence Tucker1983-12-11——1664 Valley View Dr Apt 37, Plano, TX, 750240.66Name re-casedTwo-digit birth yearUnit split from streetWhitespace trimmed+1 more
CLM-427094CLMJoan Ross1959-10-25UHC-79586-2692637648001875 Elm St, Sacramento, CA, 958220.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-404667CLMMargaret Smith1976-01-15UHC-25071-63—1446 Ridge Rd, Chandler, AZ, 852480.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-401742CLMLarry Gutierrez1974-05-23UHC-44338-82—8354 Indian School Rd, Houston, TX, 770120.66Name split from “Last, First”Member ID reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-413082CLMYuki Maldonado1942-09-18—70586507409197 Baseline Rd, Jacksonville, FL, 322090.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-426462CLMMartha Q Soto———1011 Lincoln Way, Glendale, AZ, 853370.66Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-406147CLMJoyce Griffin1968-07-25UHC-02702-65—6425 Ocean Ave, Tampa, FL, 336760.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-413209CLMJordan Walsh1982-05-11UHC-64695-37—8634 Church St, San Diego, CA, 921320.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410605CLMJudy Jimenez1997-08-13UHC-32177-75—8620 River Rd # 264, Phoenix, AZ, 850700.66Date of birth reformattedPhone missing area codeMember ID reformattedUnit split from street+1 more
CLM-407719CLMNatalie Wallace1940-08-15UHC-21792-24—406 Church St, Sacramento, CA, 958560.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-415817CLMPatricia Payne2003-11-14UHC-57067-49—4502 Cedar Ln, Minneapolis, MN0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-420840CLMWayne B Medina2006-04-08UHC-58594-374859006756—0.66Name split from “Last, First”Phone reformattedMember ID reformattedGender normalised+1 more
CLM-421970CLMJonathan M Gibson1978-02-08UHC-88509-08—3380 Lake View Rd, Seattle, WA0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-401701CLMJack C Estrada1991-01-14—92885052423522 Market St, Miami, FL, 331850.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-431289CLMRoy U Ortiz1995-04-07UHC-61154-1575666822156507 Bayshore Dr, Austin, TX, 787370.66Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-413997CLMChris M Stevens1994-08-02UHC-11824-83—167 Hillcrest Rd, Austin, TX, 787490.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-415424CLMAhmed Hernandez1942-04-15—8757447817—0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-403347CLMSofia C Vargas1954-02-16—53421425082814 Central Ave, Tucson, AZ, 857060.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-414470CLMCynthia Perkins1972-09-09UHC-19178-80—6645 Highland Ave, Denver, CO, 802020.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-417568CLMDon Richardson2000-06-11UHC-97967-6282570487943305 Valley View Dr, Tampa, FL, 336820.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-418168CLMRonald Hoffman1979-03-11UHC-79889-87—5161 Elm St, Scottsdale, AZ, 852150.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-405961CLMJudy Wells1938-01-11UHC-84471-03—9036 Valley View Dr, Tempe, AZ, 852110.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-424923CLMBobby Carroll1953-10-03UHC-95688-41—5749 Mountain View Dr Apt 37, Charlotte, NC, 282930.66Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-430959CLMAmber Diaz1955-11-26UHC-29467-25—5873 Central Ave, Dallas, TX, 752730.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-413362CLMAshley N Griffin1996-03-05——7288 Market St, Houston, TX, 770620.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-413759CLMGeorge H Reynolds1989-10-21—51289490937003 Valley View Dr, Glendale, AZ, 853290.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
32,829 rows, page 191 of 657PreviousNext