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-405591CLMJose Lawrence1967-12-22UHC-16741-1523388996044669 Lincoln Way, Plano, TX, 750400.66Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-407125CLMCharles Richards1999-10-04UHC-80345-1631933321987872 Hillcrest Rd, San Antonio, TX, 782010.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-432099CLMRachel O Vazquez1983-01-11—38597294987668 Central Ave, Atlanta, GA0.66Middle initial moved out of first nameName re-casedCity re-casedZIP missing+1 more
CLM-429579CLMJacob Peters1997-09-09UHC-44382-28—7610 Highland Ave, Denver, CO0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-432704CLMPatrick Wells1969-09-19UHC-81827-1167458040758113 Church St, Nashville, TN, 372970.66Name split from “Last, First”Phone reformattedSSN last four extractedWhitespace trimmed+1 more
CLM-417473CLMGrace Coleman1983-09-28UHC-12992-5974086695579679 Meadow Ln, Tucson, AZ, 857110.66Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+1 more
CLM-403098CLMSam Jensen1962-07-24—73755935538073 Central Ave, Fresno, CA, 937390.66Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+1 more
CLM-420307CLMTyler Mendez1984-07-19UHC-76563-32—8168 Church St, Tampa, FL0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-415970CLMJenny Hayes2004-01-09—6818982160314 Maple Ave, Phoenix, AZ, 850210.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-425712CLMRonald Moralse1948-01-28——2228 Church St Apt 35, Phoenix, AZ0.66Unit split from streetCity re-casedZIP missingWhitespace trimmed+1 more
CLM-410926CLMRachel Willis1975-12-03UHC-19492-19—12 Ocean Ave, Charlotte, NC, 282790.66Date of birth reformattedState code upper-casedZIP+4 trimmedGender normalised+1 more
CLM-431061CLMJonathan Hunt1991-05-28——7735 Valley View Dr, Plano, TX, 750230.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-428724CLMVictoria Peters1974-07-28—68190615332121 Sage Ct, Miami, FL, 331520.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-428980CLMCarol O Bryant1951-09-03——2505 Meadow Ln, Jacksonville, FL, 322920.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425586CLMBetty Griffin1981-06-15UHC-94146-5073589293073605 Washington St, Houston, TX, 770960.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-420324CLMDianaJunk1996-05-28———0.66Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared+1 more
CLM-420118CLMJose Mejia1978-12-13UHC-36493-0398490501684197 Indian School Rd, Fresno, CA, 937110.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425452CLMJeffrey Myers—UHC-57569-287898148784—0.66Name split from “Last, First”Date of birth unreadablePhone reformattedWhitespace trimmed+1 more
CLM-402182CLMAlexis T Harrison1954-01-19UHC-84201-75—6782 Sunset Blvd, Los Angeles, CA, 900910.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-417898CLMAlbert McDonald1964-10-20UHC-92730-31—9197 Canyon Rd Apt 23, Columbus, OH, 432640.66Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+1 more
CLM-416024CLMBrnda Nelson1946-06-04UHC-04067-06—1315 Market St, Gilbert, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
CLM-416023CLMBrnda Nelson1946-06-04UHC-04067-06—1315 Market St, Gilbert, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
CLM-401798CLMGibson Y Matthew1973-03-05—36126789887642 Market St, Sacramento, CA, 958160.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-409661CLMSantiago Rios1946-05-18UHC-40928-4243774577588884 Pine Dr, Tucson, AZ, 857970.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-415595CLMJackie Wang1977-10-24UHC-85294-14—6566 Indian School Rd, Tempe, AZ, 852660.66Two-digit birth yearCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-412414CLMHarold Smith1965-12-25——6838 Camelback Rd, Denver, CO, 802140.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-420204CLMAlexis A Armstrong1996-08-18UHC-63561-95—1658 Canyon Rd, Austin, TX, 787330.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-416598CLMRussell Rogers1965-10-12UHC-45195-24—387 Camelback Rd, Sacramento, CA, 958700.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-427267CLMDoris Ryan1981-08-24UHC-04166-3335969099502666 Sage Ct # 632, Minneapolis, MN, 554800.66Phone reformattedMember ID reformattedUnit split from streetState name converted to code+1 more
CLM-429348CLMTerry Wlsh———528 Willow Ct, San Diego, CA, 921730.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-401876CLMIsabella Bowman1953-10-22UHC-75417-1024887542591711 Union St, Chandler, AZ, 852380.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425169CLMBety D Miller1965-05-22UHC-10655-7658085335234060 Indian School Rd, Tampa, FL, 336710.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-432268CLMKyle Q Wells1988-04-04UHC-72557-1873237381055026 Sage Ct, Sacramento, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-425542CLMHeather Carr1966-07-04UHC-15089-19—3767 Camelback Rd, Nashville, TN, 372480.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-420335CLMChristian Armstrong1980-05-16UHC-92644-6432385469691291 Jefferson Ave Apt 37, Tampa, FL, 336680.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-411066CLMSandra Morgan1939-05-20——1706 Palm Dr, Denver, CO, 802870.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-418884CLMAmanda Campbell1968-08-28UHC-76091-62—3611 Central Ave, San Diego, CA, 921120.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-402049CLMStephanie Allen1995-11-20UHC-51810-47—8645 Apache Blvd, Tempe, AZ, 852100.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-403762CLMAliec Robinson1955-12-26UHC-97366-44—8625 Spring St, Eden Prairie, MN, 553650.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
CLM-413680CLMBrian F Wilson1983-10-03UHC-08927-59—955 Cedar Ln Apt 20, Miami, FL, 331070.66Member ID reformattedUnit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-428734CLMMary Hamilton1961-07-01—3598889997391 Union St, Tucson, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-432803CLMCharles Gordon1943-09-21UHC-54101-1749532687252811 Desert Sky Blvd, Sacramento, CA, 958300.66Name split from “Last, First”Date of birth reformattedState name converted to codeWhitespace trimmed+1 more
CLM-422261CLMOmar C Obiren1976-06-22—58641086163990 Meadow Ln, Chandler, AZ, 852450.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-428399CLMHeaher Castillo1970-03-18UHC-37392-76—6411 Main St, Scottsdale, AZ, 852550.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-409338CLMBryan Boyd1956-09-28——4755 Central Ave # 638, Nashville, TN, 372880.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-421843CLMGreg Romero1946-11-20UHC-97200-0820228466188178 Sage Ct, Orlando, FL, 328440.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415835CLMKenneth Thompson1952-02-21——2624 Central Ave, San Antonio, TX, 782700.66Name re-casedDate of birth reformattedZIP+4 trimmedGender normalised+1 more
CLM-422794CLMVincent Russell1998-07-01UHC-99059-22—1656 Maple Ave, Eden Prairie, MN, 553190.66Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+1 more
CLM-425634CLMJoyce Williams1955-08-15UHC-83998-13—2809 Union St, Seattle, WA, 981440.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419643CLMDanielle Cox1943-04-12UHC-81480-3671340072975635 Spring St, Sacramento, CA0.66Phone reformattedZIP missingGender normalisedWhitespace trimmed+1 more
32,829 rows, page 167 of 657PreviousNext