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-403917CLMWayne Marshall2002-05-04UHC-10389-42—8276 Desert Sky Blvd, Orlando, FL, 328280.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-416914CLMLiz Gordon1967-02-14—34062773334061 Camelback Rd Apt 5, Miami, FL, 331610.66Name re-casedUnit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-418658CLMSamuel Graham1999-05-06UHC-97254-5167879843502511 Valley View Dr, Phoenix, AZ0.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412342CLMKatherine W Carter1963-12-21UHC-19218-47—9532 Maple Ave, Gilbert, AZ, 852730.66Name re-casedState name converted to codeGender normalisedPlan code upper-cased+1 more
CLM-406498CLMCynthia N Price1941-10-01—86988683272275 Mountain View Dr, Los Angeles, CA, 900630.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431834CLMVicky Yang1943-09-22UHC-95449-76—2579 Hillcrest Rd, Tampa, FL, 336500.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-431833CLMVicky Yang1943-09-22UHC-95449-76—2579 Hillcrest Rd, Tampa, FL, 336500.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-423478CLMMariana C Obrien1971-10-08UHC-70943-35—884 Lake View Rd, Orlando, FL, 328000.66Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more
CLM-401457CLMTeresa Hill1990-08-22——8639 Meadow Ln, Seattle, WA, 981780.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-430784CLMCatherine Marshall1999-12-18—56557809445936 River Rd, Tucson, AZ, 857590.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-432058CLMRandy M Gonzalez1951-05-02—74664782197743 Meadow Ln Apt 22, Denver, CO, 802130.66Name split from “Last, First”Phone reformattedUnit split from streetWhitespace trimmed+1 more
CLM-405113CLMNathan Soto1986-07-23UHC-40896-79—1702 Jefferson Ave, Eden Prairie, MN, 553660.66Name split from “Last, First”Two-digit birth yearMember ID reformattedWhitespace trimmed+1 more
CLM-415831CLMSara Little1981-10-12UHC-34139-98—5850 Jefferson Ave, Plano, TX, 750860.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-426705CLMGregory Palmer1975-11-04UHC-49414-59—7816 Apache Blvd Apt 34, Chandler, AZ, 852090.66Name re-casedDate of birth reformattedUnit split from streetGender normalised+1 more
CLM-424132CLMGabriel Chen1943-12-11UHC-95467-99——0.66Name split from “Last, First”Date of birth reformattedMember ID reformattedGender normalised+1 more
CLM-424131CLMGabriel Chen1943-12-11UHC-95467-99——0.66Name split from “Last, First”Date of birth reformattedMember ID reformattedGender normalised+1 more
CLM-419022CLMKatherine Aguilar1951-01-07——3243 Grand Ave, Las Vegas, NV, 891040.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-406004CLMJanice Roberts1981-08-28UHC-08282-28—1097 Mountain View Dr, Eden Prairie, MN, 553300.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-423150CLMWillie Washington1952-03-19UHC-96039-676058602454893 Sunset Blvd Apt 21, Seattle, WA, 981470.66Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-425835CLMDonna Silva—UHC-90917-7961284822629374 Sage Ct, Las Vegas, NV0.66Date of birth unreadablePhone reformattedZIP missingWhitespace trimmed+1 more
CLM-414914CLMKaren Reid2007-11-19——8686 Bayshore Dr, Sacramento, CA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-401341CLMCatherine Ellis1939-12-19——3991 Park Pl Apt 38, Chandler, AZ, 852020.66Name re-casedUnit split from streetState code upper-casedGender normalised+1 more
CLM-416228CLMFatima T Mendez1945-07-18UHC-89648-4898685050734395 Union St, Orlando, FL, 328090.66Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed+1 more
CLM-415459CLMNoah Bryant1949-03-15UHC-89912-1267688152088174 Pine Dr, Jacksonville, FL, 322620.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411954CLMRuth Howard1974-05-10——8178 Willow Ct, Nashville, TN0.66Date of birth reformattedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-428378CLMCheryl Bradley1981-08-26——1119 Lake View Rd, Orlando, FL0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-423975CLMLuis Hunt1946-03-12UHC-94658-36—884 Washington St, Tucson, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-419453CLMJack Santos1949-11-17UHC-74335-50—8810 Grand Ave, Nashville, TN, 372550.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-418187CLMJennifer E Powell1953-10-20UHC-96996-8157168869055942 Forest Ave, Gilbert, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-424317CLMEmily Ortega1946-07-20—94257853815771 Grand Ave, Las Vegas, NV, 891790.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-402473CLMJudith Lopez1978-05-25—9455743892449 Washington St, Mesa, AZ0.66Phone reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-430604CLMElizabeth Lane1984-04-14—37249984218892 Apache Blvd # 967, Minneapolis, MN, 554830.66Phone reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
CLM-407744CLMRebecca Clark1990-06-12—94036390489740 Oak St, Jacksonville, FL, 322080.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-402883CLMDiana P Evans1997-04-15——5623 River Rd, Phoenix, AZ, 850070.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-421333CLMMarcus I Riley1964-12-07—82565580627986 Union St, Los Angeles, CA, 900990.66Middle initial moved out of first nameStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-407972CLMMargaret Hughes1954-04-12UHC-43067-83—9478 Central Ave, Mesa, AZ, 852800.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-406157CLMBeverly Freeman1963-07-23UHC-77741-84—8881 Mountain View Dr, Tucson, AZ, 857740.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-425123CLMSamantha Lawrence1940-04-12UHC-39266-7330333270117120 Washington St, Tucson, AZ, 857510.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-413914CLMArthur Marshall1979-02-09—44892073919593 Ocean Ave, Los Angeles, CA0.66Name re-casedPhone reformattedZIP missingGender normalised+1 more
CLM-416628CLMDiana Gonzales1968-05-22—5178882291230 Harbor Blvd, San Antonio, TX0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-403190CLMDouglas Tran1989-11-23UHC-80256-41—3176 Jefferson Ave, San Diego, CA, 921410.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-408297CLMAlice R Mejia1971-03-07UHC-85205-0526190449806999 Forest Ave, Jacksonville, FL, 322670.66Phone reformattedMember ID reformattedSSN last four extractedGender normalised+1 more
CLM-402222CLMKimberly Crawford1995-10-25UHC-52893-38—3927 Ocean Ave, Dallas, TX, 752180.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-407218CLMBobby Wang1988-10-27—82447972818463 Central Ave, Mesa, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-403208CLMPaul Holmes1975-10-09UHC-92596-05—8631 Canyon Rd, Scottsdale, AZ, 852450.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-404342CLMEmily Bell2008-06-26UHC-21783-69—1694 Harbor Blvd, Nashville, TN, 372380.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-413084CLMHiroshi Rogers1987-08-07UHC-98848-91—3858 Baseline Rd # 604, Miami, FL, 331730.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-419833CLMAlbert E Jacobs1994-07-04—70320012971538 Lake View Rd, Seattle, WA, 981750.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
CLM-416436CLMAnna Baker1944-10-27UHC-10154-58—3705 Palm Dr, Chandler, AZ, 852890.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412576CLMJoe Ford1978-09-19UHC-43516-61—1902 Highland Ave, Chandler, AZ, 852010.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
32,829 rows, page 160 of 657PreviousNext