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-404662CLMSandra Lewis1994-04-02UHC-69787-0695653292942873 Maple Ave, Jacksonville, FL, 322140.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-429356CLMJanet Weaver1995-02-05——9551 Lake View Rd, Atlanta, GA, 303070.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-426418CLMDoorthy Wong1959-04-25UHC-61229-847426311683—0.64Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+2 more
CLM-421423CLMDenise Wang2005-07-13UHC-08918-74—1095 Bayshore Dr # 855, Sacramento, CA, 958630.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-423106CLMJudy G Welch1968-06-08UHC-74292-52—5041 Palm Dr, Phoenix, AZ, 850550.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-414131CLMKaren Welch1955-01-05UHC-51273-0255681198965842 Washington St # 502, Plano, TX, 750960.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-402508CLMWilliam Simmons1972-06-17UHC-76744-1542134308683955 Oak St, Miami, FL, 331340.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420180CLMArthur Espinoza1991-10-23UHC-03984-9351547279682783 Market St, Gilbert, AZ, 852840.64Two-digit birth yearPhone reformattedState code upper-casedZIP+4 trimmed+2 more
CLM-401576CLMNoah Le1974-11-02—51453127472400 Meadow Ln, Dallas, TX, 752850.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-408293CLMGeorge Moreno1990-12-12UHC-81999-54—5556 Camelback Rd Apt 23, San Diego, CA, 921940.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-401401CLMGabriel Robertson1946-05-09UHC-65311-64—5918 Mountain View Dr, Glendale, AZ, 853350.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409190CLMJerry Rojas1995-09-22UHC-85772-60—4528 Maple Ave, Mesa, AZ, 852930.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429894CLMRalph Fowler1998-08-16UHC-37591-35—3163 Oak St, Miami, FL0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-429136CLMJuan O Murray1959-12-26UHC-76789-1039226794009062 Park Pl, Gilbert, AZ, 852630.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429135CLMJuan O Murray1959-12-26UHC-76789-1039226794009062 Park Pl, Gilbert, AZ, 852630.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-405106CLMMary A Miller1961-10-25UHC-64703-56—870 Market St, Orlando, FL, 328320.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-423225CLMSarah Long1977-08-16UHC-37791-64—2128 Ocean Ave, Nashville, TN, 372840.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430496CLMSean Schmidt1984-12-05—48220371224144 Sage Ct, Fresno, CA, 937150.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-432632CLMMateo Black1994-09-12UHC-06260-4531261949051266 Jefferson Ave, Tucson, AZ, 857220.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-416147CLMHarold Greene1994-12-16UHC-22101-8195954398917545 Ocean Ave, Seattle, WA, 981320.64Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-411566CLMSteven Ray1978-07-26UHC-45059-0683426543574497 Forest Ave Apt 28, Gilbert, AZ, 852550.64Phone reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more
CLM-431534CLMAmanda Li1968-03-22UHC-98440-07—8177 Ridge Rd, Gilbert, AZ, 852820.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426905CLMDouglas Gray1992-08-04UHC-82303-97——0.64Date of birth reformattedSSN last four extractedGender normalisedPlan code upper-cased+2 more
CLM-401533CLMDona Myers1972-10-07——6906 Desert Sky Blvd, Houston, TX, 770200.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-432386CLMMargaret Ramos1995-07-26UHC-40021-8860143713524658 Mesa Dr, Columbus, OH, 432220.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426612CLMElizabeth G Reed1950-03-08—93256606098057 Palm Dr, Tempe, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-413380CLMOlivia Robertson1950-11-13—5592256717—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-424595CLMJeryr Thomas1975-09-28UHC-77632-1548542509518244 Washington St, Sacramento, CA, 958890.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411366CLMElizabeth Ray1992-01-25——7416 Oak St, Las Vegas, NV, 891860.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-420981CLMAndrew Fernandez1954-12-06——3013 Pine Dr, Dallas, TX, 752800.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-416922CLMAnthony Garcia2008-06-19UHC-44396-5363966369391099 Baseline Rd, Denver, CO0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-411372CLMPeter P Edwards1948-09-12—37743162106925 Pine Dr, Mesa, AZ, 852570.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-423879CLMDiane Austn1955-11-21UHC-03189-68—2127 Maple Ave, Eden Prairie, MN, 553020.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-410114CLMGerald Chavez—UHC-99698-9142682732566886 Central Ave, Seattle, WA, 981860.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407228CLMBruce Wagner1982-02-16—46597204427740 Palm Dr, Seattle, WA, 981920.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-423128CLMSandra Banks2000-12-28UHC-77872-4858443525337841 Park Pl, Tucson, AZ, 857360.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419528CLMBilly M Cook1978-11-21—35897219025824 Willow Ct, Scottsdale, AZ, 852080.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-408871CLMWalter Clark1980-03-06UHC-73064-35—3926 Lincoln Way, Jacksonville, FL, 322980.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407188CLMLinda Obrien1944-04-01——3414 Canyon Rd, Nashville, TN, 372920.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-407189CLMLinda Obrien1944-04-01——3414 Canyon Rd, Nashville, TN, 372920.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-403978CLMTimothy Arnold1957-04-13UHC-51075-25—7089 Mesa Dr, Charlotte, NC, 282270.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432222CLMFatima Jacobs1974-02-04UHC-41356-33—4275 Union St, Mesa, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-416773CLMMelissa Guzman1939-11-15UHC-18796-23—998 Broadway, Minneapolis, MN, 554590.64Name re-casedTwo-digit birth yearAddress re-casedCity re-cased+2 more
CLM-431924CLMMari Moore1952-08-07UHC-35971-23—3317 Lincoln Way, Atlanta, GA0.64Name re-casedTwo-digit birth yearMember ID reformattedZIP missing+2 more
CLM-421427CLMKatherine F Lucas1946-05-19UHC-42065-6222491498001463 Cedar Ln # 249, Gilbert, AZ, 852540.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-427750CLMGary Z Burns1984-11-19UHC-59403-81—5738 Meadow Ln, Mesa, AZ, 852530.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424439CLMAndrea Howell1951-10-20UHC-41300-7835079655897160 Ocean Ave, Columbus, OH, 432270.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-424440CLMAndrea Howell1951-10-20UHC-41300-7835079655897160 Ocean Ave, Columbus, OH, 432270.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-402538CLMBilly Green1951-07-15—63591761213510 Sage Ct, San Antonio, TX, 782670.64Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-423785CLMDouglas I Reynolds2008-01-12—27365200408095 Highland Ave Apt 3, Minneapolis, MN, 554140.64Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+2 more
32,829 rows, page 129 of 657PreviousNext