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-413291CLMCarl Park1963-01-14UHC-65013-1963725633939297 Ocean Ave, Fresno, CA, 937410.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-411719CLMElijah Jones1972-02-16—79664349099888 Jefferson Ave, Tampa, FL, 336780.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410759CLMAhmed Wells1988-02-11UHC-76495-59—7072 Central Ave, Columbus, OH, 432980.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-407579CLMAlice Murphy1967-09-28——6768 Baseline Rd, Tampa, FL, 336400.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-410246CLMBradley Hall1978-05-24——1877 Lincoln Way Apt 39, Phoenix, AZ0.66Name re-casedUnit split from streetZIP missingWhitespace trimmed+1 more
CLM-431904CLMMarilyn Bradley1966-09-13UHC-97072-12—901 Forest Ave, Seattle, WA, 981660.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-431905CLMMarilyn Bradley1966-09-13UHC-97072-12—901 Forest Ave, Seattle, WA, 981660.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-426450CLMEvelyn Palmer1997-04-03UHC-50583-39—8011 Church St, Tucson, AZ, 857580.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-412001CLMJoshua Sanders1952-06-07UHC-21780-50——0.66Name split from “Last, First”Two-digit birth yearMember ID reformattedWhitespace trimmed+1 more
CLM-417424CLMJames Crawford1974-01-28UHC-30066-13—3463 Washington St, Tampa, FL, 336700.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-403054CLMPeter Ryan1976-02-24UHC-07246-0555172287055547 River Rd, Tampa, FL, 336960.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-412482CLMWayne Sanchez1962-10-15UHC-45559-54—8639 Cedar Ln, Las Vegas, NV, 891260.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-420565CLMFrances Guerrero1961-08-23UHC-33432-90—3108 Pine Dr, San Diego, CA, 921230.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419201CLMKyle Carroll1954-06-25—52736837763655 Indian School Rd, Chandler, AZ, 852880.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-408949CLMIsabella U Kyng1952-06-10UHC-11199-17—6375 Desert Sky Blvd, Nashville, TN0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-402844CLMWill L Chavez2002-04-28UHC-79231-34—8109 Valley View Dr, Minneapolis, MN, 554910.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-401570CLMDavid X Graham2003-09-12——2470 Lincoln Way, Plano, TX, 750310.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410327CLMBrian Robets1986-09-26——750 Highland Ave, Tempe, AZ, 852970.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-422988CLMArthur J Soto1963-03-10UHC-76728-295419202237487 Maple Ave, Austin, TX, 787960.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-424638CLMCharles Griffin2003-10-08UHC-79368-12—6431 Oak St, Eden Prairie, MN0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-424966CLMJoseph R Contreras—UHC-21100-34—5165 Lincoln Way, Tampa, FL, 336370.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-403539CLMAhmed Moore1988-10-26UHC-96359-72—5163 Valley View Dr, Houston, TX, 770250.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-427139CLMJulia E Brown1989-05-17UHC-01468-2195023038138084 Main St, Sacramento, CA, 958850.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-427145CLMPriya D Coleman1979-02-22UHC-29997-83—8189 Canyon Rd, Phoenix, AZ, 850270.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-428822CLMCarlos Bryant1954-09-18UHC-52690-27—6753 Hillcrest Rd, Tampa, FL, 336090.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-408486CLMPhilip Carlson1949-02-09——7382 Highland Ave, Tempe, AZ, 852580.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-431288CLMNicholas B Perkins1956-11-05UHC-71520-80—1304 Meadow Ln, Plano, TX, 750990.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-432323CLMKathleen Anderson1957-02-05UHC-30623-8949428753696950 River Rd, Dallas, TX, 752980.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-422747CLMElizabeth S Reeyes1944-11-12——6171 Spring St, Fresno, CA, 937330.66Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-413855CLMCruz Sandra1939-07-06—2958452158649 Elm St, San Diego, CA, 921010.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-424605CLMBoyd Frrances1980-05-19——1016 Mesa Dr, Seattle, WA, 981130.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-401018CLMHarold Lawson2007-10-22UHC-63818-42—4766 Bayshore Dr, San Antonio, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-420960CLMBilly Freeman——8858555367765 Highland Ave, Plano, TX0.66Date of birth missingPhone reformattedZIP missingWhitespace trimmed+1 more
CLM-416548CLMValentina Cooper1984-09-18UHC-46542-88—5188 Main St, Fresno, CA, 937620.66City re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-409270CLMSam Hernandez1980-10-22UHC-94074-2479972288056839 Jefferson Ave, Orlando, FL, 328890.66Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411032CLMAdam Mendez1974-12-26UHC-06210-34—2377 Ridge Rd # 194, Orlando, FL, 328640.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415053CLMJulia T Garcia1989-03-14UHC-18000-2438636883915786 Elm St, Glendale, AZ, 853870.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-408731CLMKathleen Harris1996-05-02——7651 Ocean Ave, Charlotte, NC, 282970.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-426076CLMDorothy Peterson1947-10-04UHC-20813-4173071231771631 Camelback Rd, Phoenix, AZ, 850620.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-416712CLMElijah Torres1968-03-21UHC-90396-6498833702116944 Spring St, Jacksonville, FL, 322900.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412723CLMSteven Schmidt1986-09-25UHC-10816-6262867390372572 Ridge Rd, Plano, TX, 750590.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-428023CLMSaron S Day1962-01-26——4771 Indian School Rd, Charlotte, NC, 282320.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-424030CLMNicole Weber1973-04-22——9692 Indian School Rd, Jacksonville, FL, 322700.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-430935CLMKenneth Garrett1999-04-11UHC-93400-76—4405 Willow Ct # 235, Chandler, AZ, 852770.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-402155CLMRachel C Espinoza1955-09-10——4838 Hillcrest Rd, Los Angeles, CA, 900520.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-425768CLMAdam K Veag1992-02-01UHC-59055-13—3499 Canyon Rd, Chandler, AZ, 852050.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-430237CLMJoan Meyer1992-11-20UHC-56059-70—483 Desert Sky Blvd, Charlotte, NC, 282110.66Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-431138CLMJulia Chavez—UHC-90166-606835403604—0.66Date of birth unreadablePhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-432171CLMBetty Carter1951-10-06UHC-07539-8357448181925996 Broadway, Tucson, AZ, 857120.66Name split from “Last, First”Phone reformattedSSN last four extractedWhitespace trimmed+1 more
CLM-400066CLMLawrence H Kelly2008-02-22UHC-78966-4898178525717196 Oak St, Columbus, OH0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
32,829 rows, page 171 of 657PreviousNext