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-417721CLMJoey V Wheeler1991-05-12——3173 Willow Ct, Sacramento, CA, 958920.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-420870CLMDonna Cook———6772 Desert Sky Blvd, Nashville, TN0.52Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-403063CLMAngela Franklin1956-01-13UHC-82634-27—8529 Lake View Rd, Scottsdale, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-425423CLMBarbara S Park1982-05-01UHC-16638-8433269726214177 Pine Dr, Scottsdale, AZ0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415320CLMMichelle Riley1941-10-16UHC-24426-58—3847 Highland Ave # 897, Plano, TX, 750090.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-407520CLMPatricia Grant1978-09-07—74859310646500 Ridge Rd Apt 27, Miami, FL, 331720.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-416997CLMAbigail H Gomez1954-05-20——9733 Apache Blvd, Tempe, AZ0.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
CLM-405600CLMJames Day1956-11-11UHC-69120-9266993764885159 Maple Ave # 115, Los Angeles, CA, 900910.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432475CLMJuan Snyder1939-04-17UHC-15581-31—7663 Spring St, Las Vegas, NV, 891640.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429355CLMIsabella Shaw1942-11-09——1072 Maple Ave, Tampa, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-406396CLMLinda U Harvey1965-12-27UHC-26634-20—8129 Central Ave, Denver, CO, 802790.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-407734CLMVincent Maldonado1997-04-01UHC-63268-01—8069 Spring St, Nashville, TN, 372050.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-412591CLMJordan Wheeer—UHC-68353-50—7792 Sage Ct, Dallas, TX0.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-431415CLMCarolyn Richards1955-06-02—45373408617689 Market St, Columbus, OH, 432660.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-412729CLMMateo Flores1975-04-04UHC-34251-40—486 Highland Ave, Jacksonville, FL, 322490.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425878CLMChavez Ethan1989-09-10—71993029377974 Lincoln Way, Denver, CO, 802500.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-419315CLMPriya Murray1978-02-02UHC-60074-18—995 Washington St, Miami, FL, 331560.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-426946CLMVega Ahmed1953-09-25UHC-03347-2697736008605743 Bayshore Dr, Scottsdale, AZ, 852450.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-424429CLMDaniel Dean1952-03-07——497 Camelback Rd, Gilbert, AZ, 852260.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-432708CLMJeremy Sims—UHC-18079-22—3402 Washington St, Chandler, AZ, 852380.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-419082CLMMagaret Parker1970-03-03UHC-49124-6081191256732902 Willow Ct, Fresno, CA0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425297CLMRoger Le1987-12-14UHC-84334-48—9800 Cedar Ln, Austin, TX, 787390.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418819CLMBeverly Martinez1985-09-20UHC-52759-66—127 Valley View Dr, Phoenix, AZ, 850450.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-404497CLMHeather Soto1972-04-28UHC-92949-9197425593714780 Union St, Tampa, FL0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403375CLMEmma Castillo—UHC-27180-71—382 Highland Ave, San Diego, CA, 921310.52Name split from “Last, First”Date of birth reformattedDate of birth unreadableStreet suffix standardised+2 more
CLM-410690CLMRobertson M Ahmed1973-04-27——9758 Valley View Dr, Sacramento, CA0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410977CLMDennis Hamilton1990-08-17UHC-00203-27—4256 Ocean Ave, Columbus, OH, 432700.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-414672CLMGrace E Cole1972-04-15——8933 Meadow Ln # 456, Glendale, AZ, 853990.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408845CLMAaron Andrews——53387952386597 Church St, San Diego, CA, 921700.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-411817CLMJason Robinson1978-02-06—52952199823577 Lake View Rd, Atlanta, GA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-425018CLMAlan Ferguson1942-03-01——8978 Grand Ave, Eden Prairie, MN, 553620.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424570CLMEugene Nichols1980-03-11——1911 Palm Dr, Phoenix, AZ, 850310.52Name split from “Last, First”Date of birth reformattedPhone missing area codeCity re-cased+2 more
CLM-423827CLMAndrea Guzman1992-05-15——4778 Sage Ct, Tucson, AZ, 857730.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-425246CLMMartha Watson1976-12-23UHC-66588-79—6159 Union St, Eden Prairie, MN, 553650.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415452CLMLawrence O Richards———6040 Main St, Columbus, OH, 432360.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-427637CLMRoy G Burns1996-01-06UHC-22217-24—1170 Church St, Denver, CO, 802960.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-418171CLMAhmed Adams2001-12-06UHC-61442-8264222621153121 Union St, Las Vegas, NV, 891390.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-417545CLMWalter D Moreno1939-07-01UHC-84396-39—597 Elm St, Denver, CO, 802620.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-403425CLMJessica Burns2007-05-20UHC-28147-73—8189 Sage Ct, Seattle, WA, 981140.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-418506CLMEmma Parker1938-04-22—63263641473226 Spring St, Tucson, AZ, 857180.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425732CLMAmber Jordan1985-02-17UHC-29175-45—1088 Sunset Blvd, Seattle, WA, 981860.52Two-digit birth yearCity re-casedZIP+4 trimmedGender normalised+2 more
CLM-413941CLMAlbert Marsshall1991-07-04—21967059398011 Maple Ave # 643, Plano, TX0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-430118CLMAustin Bowman1959-10-02UHC-22804-98—4575 Jefferson Ave, Houston, TX0.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431520CLMJoan F Harris1994-07-26UHC-53549-8537845269142628 Lincoln Way, Minneapolis, MN, 554460.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-423458CLMPatricia Cooper1938-05-02—51892993343209 Baseline Rd, Fresno, CA, 937920.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412688CLMIsabella P Wilson2003-04-02UHC-32664-9827859961028501 Spring St, San Diego, CA, 921130.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402877CLMAmanda Austin1998-09-20—22367823828867 Elm St, Plano, TX, 750750.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429612CLMKaren Richardson1962-12-14UHC-37708-18—1730 Central Ave, Nashville, TN, 372480.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-411938CLMKeith Ramirez1954-06-19UHC-39559-25—9683 Grand Ave, Tempe, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-409834CLMAmber Green1976-03-15UHC-30412-77—2929 Maple Ave, Seattle, WA, 981040.52Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 48 of 657PreviousNext