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-408812CLMMary J Burton2008-01-03——6287 Palm Dr, Atlanta, GA, 303360.64Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-408851CLMHiroshi B Welch1962-06-24——5244 Forest Ave, Tucson, AZ, 857760.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400586CLMHenry Lane1940-09-11UHC-78055-45—1172 Lincoln Way, Los Angeles, CA, 900680.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415790CLMWalter Davis1950-11-05UHC-83207-2689695900175197 Cedar Ln # 998, Las Vegas, NV, 891090.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-412106CLMMarilyn H Li1995-02-24—35932091892881 Camelback Rd, Phoenix, AZ, 850520.64Two-digit birth yearPhone reformattedCity re-casedGender normalised+2 more
CLM-426838CLMCarolyn Y Jimenez1945-05-14—33264579743996 Baseline Rd # 490, San Diego, CA, 921980.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-417925CLMSean H Dixon2000-10-04UHC-62395-04—3247 Mountain View Dr Apt 13, Nashville, TN, 372640.64Name split from “Last, First”Date of birth reformattedUnit split from streetPlan code upper-cased+2 more
CLM-420452CLMYuki Elliott2007-03-18—28323856726045 Oak St, Austin, TX0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407415CLMAmanda Walker1981-01-27—58556058446447 Pine Dr, Jacksonville, FL, 322140.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431504CLMMartha J Harvey1988-01-08—80389147346664 Union St, Denver, CO, 802820.64Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428269CLMWillie Sanchez1971-01-27UHC-64820-0460540294312285 Central Ave, Tucson, AZ, 857270.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427740CLMGloria Grant1952-08-13UHC-18393-2166241982446583 Ridge Rd # 273, Las Vegas, NV, 891870.64Name split from “Last, First”Date of birth reformattedUnit split from streetEmail lower-cased+2 more
CLM-409370CLMGearld W Ramirez1975-05-28——7735 Ridge Rd Apt 26, Nashville, TN, 372360.64Name re-casedDate of birth reformattedUnit split from streetState name converted to code+2 more
CLM-428031CLMKayla Perkins1982-05-07UHC-03779-6420449202338440 Central Ave, Scottsdale, AZ, 852640.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406435CLMAshley Reid—UHC-23123-7231464966147945 Central Ave, Dallas, TX, 752700.64Name re-casedDate of birth unreadablePhone reformattedGender normalised+2 more
CLM-427012CLMChristian Clark1953-09-17——2938 Maple Ave, Chandler, AZ, 852390.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-407309CLMRachel Watson1942-09-23UHC-77213-11—1928 Camelback Rd, San Diego, CA, 921320.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407308CLMRachel Watson1942-09-23UHC-77213-11—1928 Camelback Rd, San Diego, CA, 921320.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430109CLMRoger Carroll2003-09-20UHC-99287-9255079488428485 Meadow Ln, Minneapolis, MN, 554020.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413593CLMMark C Arnold2004-12-05——3979 Camelback Rd, Los Angeles, CA0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-415754CLMYuki U Mitchell2000-09-18—31649676682935 Valley View Dr, Phoenix, AZ, 850440.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-415256CLMBarbara Carter1941-08-17UHC-44811-1283087631825676 Ridge Rd, Chandler, AZ, 852900.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408449CLMChristian J Marshall1994-01-04UHC-58093-69—5719 Sunset Blvd, Minneapolis, MN, 554780.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427762CLMBarbara Kim2001-11-12UHC-55893-6997329992561784 Central Ave, Miami, FL, 331890.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401926CLMDanny U Mendez——91145525372559 Jefferson Ave, Gilbert, AZ, 852990.64Date of birth unreadablePhone reformattedCity re-casedState name converted to code+2 more
CLM-430621CLMAngela M Brown1946-05-27UHC-61297-6263244998717762 Mesa Dr, San Antonio, TX, 782590.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-421932CLMMaria J Wells2005-07-01—53185863252693 Highland Ave, Eden Prairie, MN, 553640.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401315CLMAbigail Berry1966-02-26——9149 Lincoln Way # 622, Tampa, FL, 336700.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-417876CLMJessica H Garza1962-01-08——5622 Harbor Blvd, Minneapolis, MN, 554200.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431668CLMJeremy Weaver1945-04-15UHC-70862-1856098156797375 Ridge Rd, Scottsdale, AZ, 852840.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432248CLMAlan Lynch1959-07-02UHC-97250-45—7020 Elm St, Orlando, FL, 328860.64Name re-casedDate of birth reformattedCity re-casedZIP+4 trimmed+2 more
CLM-408818CLM—Junk1967-12-27—77055299034392 Elm St, Scottsdale, AZ, 852790.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418448CLMScott Alvrado1974-09-21UHC-03782-0496492973885896 Hillcrest Rd, Glendale, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405112CLMSophia Wilson1958-01-14UHC-22018-0294469331103631 Market St, Nashville, TN, 372190.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-407555CLMJohn Ray1943-10-02UHC-32122-35—4554 Meadow Ln # 153, Phoenix, AZ0.64Name re-casedUnit split from streetCity re-casedZIP missing+2 more
CLM-416075CLMJordan V Lee1969-03-03UHC-83908-16—3342 Grand Ave, Los Angeles, CA, 900090.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420362CLMDennis Cole1950-01-09UHC-96366-6275092489164920 Pine Dr, Phoenix, AZ0.64Name re-casedTwo-digit birth yearPhone reformattedZIP missing+2 more
CLM-409396CLMSusan Greene1948-04-19—47822215773327 Cedar Ln, Dallas, TX, 752600.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424486CLMSamuel Simmons1945-05-25UHC-47169-698474100580519 Grand Ave, Orlando, FL, 328850.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426223CLMJoshua Armstrong1990-12-04UHC-90508-7027088965201069 Central Ave, Sacramento, CA, 958450.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419217CLMJerry Martin———1696 Highland Ave, Jacksonville, FL, 322230.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-412234CLMSophia Y Vazquez1992-09-24UHC-24298-3993084384464625 Indian School Rd, Scottsdale, AZ, 852050.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402521CLMMary Shaw1961-12-27UHC-19721-0751659500213392 Forest Ave, Scottsdale, AZ, 852700.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432431CLMYki Dominguez1975-05-28UHC-43448-7270192357656273 Bayshore Dr, Charlotte, NC, 282620.64Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+2 more
CLM-406370CLMCarlos Austn1990-08-02——7112 Mesa Dr, Phoenix, AZ, 850260.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400000CLMJudy Herrera1977-04-07——2759 Sage Ct, Mesa, AZ, 852640.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-416525CLMAngela G Franklin1977-10-14UHC-52034-94—2488 Mountain View Dr, Eden Prairie, MN, 553620.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401564CLMIsabella Hudson1970-08-08—50979108744880 Baseline Rd, Nashville, TN, 372990.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-430326CLMNatalie Jensen1953-01-17UHC-91990-7530692021691309 Ocean Ave, Chandler, AZ, 852100.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-405677CLMBarb Hanson1969-12-18—48523079034769 Spring St, Austin, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
32,829 rows, page 131 of 657PreviousNext