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-415847CLMFatima C Ruiz1998-12-07UHC-33575-1690635767726908 Forest Ave, Tampa, FL, 336360.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404324CLMJames S Watson—UHC-27018-46——0.50Middle initial moved out of first nameName re-casedDate of birth unreadableEmail lower-cased+3 more
CLM-423402CLMCarolyn J Martin1986-03-17UHC-41069-5242827904625919 Church St, Plano, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432596CLMEmily B Hamilton——79277847351869 Apache Blvd, San Antonio, TX, 782780.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-410708CLMEvelyn M Williams2008-09-27UHC-96663-83—8149 Bayshore Dr, Tempe, AZ, 852700.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427136CLMDeb Holmes1955-02-13UHC-69891-6576453841074331 Grand Ave Apt 27, Nashville, TN, 372360.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
CLM-426033CLMDanielle K Palmer—UHC-01567-87—9568 Maple Ave # 156, San Diego, CA, 921620.50Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+3 more
CLM-413968CLMMariana Webb1981-01-23UHC-95353-72—4877 Mountain View Dr, Seattle, WA, 981190.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428365CLMJonathan Brooks1999-03-20UHC-27135-67—4731 Sunset Blvd, Los Angeles, CA0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-406129CLMBenjamin Fowler1956-05-27——8779 Spring St, Charlotte, NC, 282730.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-425852CLMAlexis Mitchell1973-02-06——1919 Park Pl, Jacksonville, FL, 322090.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-421705CLMLuis Dominguez1998-11-25UHC-35367-0390268519465547 Baseline Rd # 215, Plano, TX, 750090.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-428462CLMBetty Weber1956-07-23UHC-81512-0155079619979852 Spring St Apt 40, Miami, FL, 331180.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-431724CLMBeverly Carlson1998-10-09UHC-97520-90—834 Grand Ave Apt 27, Fresno, CA, 937080.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402916CLMRoy Tucker1946-01-17UHC-34706-33—7341 Oak St, Atlanta, GA, 303000.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-420652CLMChristopher Russell1958-05-19UHC-40318-8476788807641159 Willow Ct, Houston, TX, 770050.50Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
CLM-421621CLMOlivia Gonzales1943-12-08UHC-00411-1896829946438846 Apache Blvd, Seattle, WA, 981510.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406107CLMAdam R Collins1975-06-08—39958480232667 Canyon Rd, Tucson, AZ, 857650.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423720CLMJoran B Thomas1947-07-03UHC-53826-54—1659 Desert Sky Blvd Apt 24, Tampa, FL, 336020.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-414712CLMEmily Matthews1969-03-01UHC-29986-98—7506 Indian School Rd # 467, Houston, TX0.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-416393CLMEric Schmidt1945-11-23——2124 Forest Ave, Sacramento, CA, 958290.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-403480CLMHiroshi Wood1960-10-20UHC-74279-3493543018958320 River Rd, Eden Prairie, MN, 553500.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-416027CLMBrenda Nguyen1950-10-10UHC-96686-39—5028 Harbor Blvd, San Diego, CA, 921460.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400028CLMKathryn Austin1955-03-27UHC-56978-4920137662358582 Union St, Tampa, FL, 336030.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432087CLMBruce Collins1964-06-23——8936 Desert Sky Blvd, Gilbert, AZ, 852900.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432088CLMBruce Collins1964-06-23——8936 Desert Sky Blvd, Gilbert, AZ, 852900.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-412124CLMJeffrey Gonzalez1980-02-24——4581 Meadow Ln, Austin, TX0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
CLM-419853CLMRoy Mils1963-12-12UHC-46354-30—5385 Elm St, Minneapolis, MN, 554730.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424756CLM—Junk1948-08-09UHC-15768-9566529518291765 Mesa Dr, Minneapolis, MN, 554620.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422216CLMYuki Smith1995-02-28UHC-02831-9542155422418941 Highland Ave, Phoenix, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-415816CLMPatricia M Payne2003-11-14UHC-57067-49—4502 Cedar Ln, Minneapolis, MN, 554270.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-407379CLMJoyce Vargas1953-08-24—93745524406679 Spring St, Nashville, TN, 372220.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428697CLMJoyec Hanson1963-01-25UHC-16292-82—7610 Mountain View Dr Apt 21, Plano, TX, 750190.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-429116CLMBrian Dixon—UHC-02163-23—8209 Maple Ave, Gilbert, AZ0.50Name re-casedDate of birth unreadableMember ID reformattedStreet suffix standardised+3 more
CLM-400548CLMAmy Wong1972-07-16UHC-19081-1686844642075871 Baseline Rd Apt 27, Glendale, AZ, 853200.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-406409CLMAlexis Welch1950-05-21UHC-42203-08—6563 Canyon Rd, Phoenix, AZ, 850680.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-421461CLMJuan Kelly1945-10-24—89637628032386 Central Ave Apt 30, Phoenix, AZ, 850570.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410930CLMAlice Armstrong——34429207127640 Forest Ave, Columbus, OH0.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415071CLMKaren Roberts1944-08-03UHC-49232-3145153527453071 Cedar Ln, San Diego, CA, 921600.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430195CLMSara Cox1961-08-17UHC-33317-40—7281 Ocean Ave, Seattle, WA, 981640.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-406639CLMHarold N Vega—UHC-62854-39—9470 Highland Ave, Orlando, FL, 328420.50Name re-casedDate of birth unreadableCity re-casedState name converted to code+3 more
CLM-432090CLMBrittany I Garrett1970-01-05UHC-07264-35—3896 Hillcrest Rd, Los Angeles, CA, 900310.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-409987CLMNicole Hayes1939-04-16UHC-32516-687178720107695 Apache Blvd, Plano, TX0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-409969CLMAustin Dominguez1954-04-10UHC-89799-5857923644027136 Cedar Ln, Tampa, FL, 336010.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-419688CLMRyn Wong1941-03-06—47727071956303 River Rd # 514, Atlanta, GA, 303370.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-426564CLMPaul Luna1961-02-24——9527 Grand Ave, Fresno, CA, 937650.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431825CLMCharles Burke1944-01-12—67464967417974 Meadow Ln, Austin, TX0.50Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+3 more
CLM-414924CLMGabriel Sullivan1967-12-04—80382234668840 Highland Ave, Austin, TX, 787970.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-408237CLMAbby Vasquez1992-01-02UHC-90186-6368532445146809 Bayshore Dr, Houston, TX, 770440.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403560CLMHannah Little1995-12-08UHC-90419-65—4288 Park Pl, Plano, TX, 750960.50Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+3 more
32,829 rows, page 36 of 657PreviousNext