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-416749CLMLauren Riley1952-01-08UHC-01311-77—1156 Hillcrest Rd, Minneapolis, MN0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426515CLMKevin Freeman1953-09-01UHC-75530-9854658024167508 Oak St, Mesa, AZ, 852470.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-418074CLMKelly Powell1984-05-14UHC-57639-35—1647 Oak St, Gilbert, AZ, 852120.64Date of birth reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-428313CLMAndrew M McCoy1985-06-03——343 Pine Dr Apt 22, Tempe, AZ, 852100.64Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-418091CLMBrian M McCoy1958-07-15UHC-72352-98—8242 Union St, Tempe, AZ, 852380.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-428588CLMAna Carr1981-08-17—58983739193689 Pine Dr, Los Angeles, CA, 900740.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426191CLMRebecca Hoffman1965-07-25—6915617525218 Apache Blvd # 191, Las Vegas, NV, 891760.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-411132CLMLori T Garcia1993-06-24——988 Sage Ct, Tampa, FL, 336910.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418890CLMEmily Young—UHC-47480-6085834362088117 Apache Blvd, Mesa, AZ, 852370.64Date of birth missingPhone reformattedCity re-casedGender normalised+2 more
CLM-405075CLMJoyce Rice1943-05-25UHC-64786-05—2028 Baseline Rd, Mesa, AZ, 852730.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-405320CLMAmy Washington1964-07-27UHC-41659-76—8281 Mountain View Dr, Fresno, CA, 937100.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-427200CLMSharon H Black1957-01-15—30653556217161 Main St, Tempe, AZ, 852600.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409822CLMFrances Graham1971-04-22UHC-93802-8246451936461867 Ocean Ave, Nashville, TN0.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417276CLMWei Hamilton—UHC-96684-93—449 Grand Ave, Jacksonville, FL, 322090.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-405625CLMTimothy Howell1953-09-28—55269157755103 Oak St, Plano, TX, 750620.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407636CLMAna Mason2002-01-10UHC-43455-67—8872 Highland Ave, Charlotte, NC, 282240.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-408604CLMRobert Palmer1968-04-05——7598 Meadow Ln, Seattle, WA, 981620.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408187CLMAbigail Woods1967-06-22——8938 Camelback Rd, Jacksonville, FL, 322620.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-423399CLMVirginia Guerrero1945-06-21UHC-61356-3951281714856889 Oak St, Gilbert, AZ, 852650.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428075CLMChristian King1952-07-18UHC-48234-46—5526 Sunset Blvd, Tempe, AZ, 852150.64Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-429525CLMCarol A Shaw2002-10-06UHC-74988-5954471739921968 Willow Ct, Orlando, FL, 328260.64Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
CLM-422391CLMJosh Payne1938-09-03UHC-40350-5028931056975146 Cedar Ln, Sacramento, CA, 958710.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412256CLMJacob Chen1968-10-20—90562459108375 Camelback Rd, Eden Prairie, MN, 553540.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-401422CLMSandra Z Davis1953-01-05——7452 Elm St, Plano, TX, 750000.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-430769CLMGerald Simpson1942-12-15UHC-08297-98—3721 Jefferson Ave, Nashville, TN, 372670.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-428420CLMJeremy Rios1938-12-24UHC-43577-4747384854391519 Market St, Phoenix, AZ, 850300.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429848CLMSamuel Daniels1977-11-16UHC-29400-17—8484 Meadow Ln, Tampa, FL, 336410.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-401712CLMNanncy Hall1945-10-06UHC-34097-24—4636 Harbor Blvd, Atlanta, GA, 303880.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428701CLMSusan Hamilton1983-12-09UHC-49973-47—4288 Church St, Sacramento, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-419811CLMVictoria Harper1955-09-05UHC-33397-2563042720183308 Baseline Rd # 811, Phoenix, AZ, 850890.64Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-421527CLMMaria Montgomery1949-04-12—63237463599106 Main St, Austin, TX, 787880.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-427265CLMDoris Ryan1981-08-24—35969099502666 Sage Ct, Minneapolis, MN, 554800.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411033CLMAlice Jamas—UHC-50230-34—1005 Forest Ave # 764, Phoenix, AZ, 850360.64Name re-casedDate of birth unreadableMember ID reformattedUnit split from street+2 more
CLM-428304CLMJanice Soto1955-05-28—27727194953265 Mountain View Dr, Las Vegas, NV, 891270.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403523CLMDiego Castillo2007-02-09UHC-69309-4485244904563312 Maple Ave, Houston, TX, 770380.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-417607CLMJonathan Reinolds1976-03-22UHC-90138-55—2310 Lincoln Way, Eden Prairie, MN, 553850.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412856CLMBarbara M Fox1964-06-23UHC-19091-6995952974624433 Ridge Rd, Tempe, AZ, 852880.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410338CLMEvelyn McDonald1960-11-01——1973 Sage Ct # 459, Chandler, AZ, 852420.64Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-400776CLMMelissa J Alexander1944-12-03—33325051688745 Ocean Ave, Charlotte, NC, 282100.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-401225CLMAnn S Lopez1940-11-23—860959620761 Sunset Blvd, Plano, TX, 750610.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418953CLMOar Hunt1938-05-20UHC-97434-5145436298659314 Bayshore Dr, Los Angeles, CA0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408182CLMAlice P Wang1938-03-05UHC-19783-6376668826339104 River Rd, Austin, TX, 787390.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424228CLMMichael Porer2003-09-12UHC-50791-32—5538 Elm St, Houston, TX, 770790.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407621CLMTeressa Z Porter1983-10-23—73163884418615 Hillcrest Rd, Chandler, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-402177CLMArthur Reynolds1984-05-13——9016 Elm St, Tampa, FL, 336960.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-428542CLMJohn O Marshall2000-04-14—37725591932707 Grand Ave, Las Vegas, NV, 891700.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410361CLMAlxeander Murphy1997-10-13UHC-15436-47422894648081 Church St, Minneapolis, MN, 554080.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-409065CLMKenneth X Carroll1972-07-18—27766743975265 Maple Ave, Dallas, TX, 752980.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431698CLMKathryn Black1962-06-13UHC-47024-45—3202 River Rd, Nashville, TN, 372610.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428290CLMGregory Cruz1974-01-27UHC-66888-1798658435535351 Market St Apt 25, Jacksonville, FL, 322550.64Phone reformattedUnit split from streetCity re-casedState name converted to code+2 more
32,829 rows, page 146 of 657PreviousNext