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-428459CLMMartha Henderzon1970-11-08——4102 Forest Ave Apt 19, Chandler, AZ, 852780.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-422244CLMMegan X Castillo1955-03-05UHC-34234-24—4037 River Rd # 420, San Antonio, TX, 782430.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-427748CLMMark Valdez1980-03-27——9126 Main St, Orlando, FL, 328800.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-428963CLMLori Johnsson1990-01-12——6298 Forest Ave Apt 26, Charlotte, NC, 282510.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-409698CLMEugene Coleman1986-01-20UHC-30788-02—9066 Ocean Ave, Austin, TX, 787480.52Name re-casedSSN last four extractedState name converted to codeGender normalised+2 more
CLM-424268CLMJack Barnes1940-07-25UHC-58851-08—5734 Washington St # 920, Atlanta, GA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-409571CLMHarold Mason1940-11-11——1481 Hillcrest Rd, Gilbert, AZ, 852380.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-423690CLMAaron E Johnson1978-11-04UHC-30422-6743479224159581 Indian School Rd # 523, San Antonio, TX, 782830.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-403551CLMCarolyn O Jacckson2002-11-02——2843 Mesa Dr # 494, Atlanta, GA, 303050.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-403552CLMCarolyn O Jacckson2002-11-02——2843 Mesa Dr # 494, Atlanta, GA, 303050.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-413832CLMDoris Dominguez2001-12-16UHC-82608-31—6256 Sunset Blvd, Scottsdale, AZ, 852200.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-414318CLMCheryl U Wang1959-07-15UHC-22851-7162238087712046 River Rd, Plano, TX, 750690.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-421357CLMLarry Bradley2001-01-13——3299 Pine Dr, Eden Prairie, MN, 553910.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410139CLMSamuel Tucker1993-06-19—26897169615881 Apache Blvd, Chandler, AZ0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420183CLMAdam T Phillips1981-10-14UHC-19294-1029545015234287 Washington St Apt 39, San Antonio, TX, 782730.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-401823CLMCynthia Nelson———4108 Forest Ave Apt 7, Orlando, FL, 328580.52Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+2 more
CLM-425307CLMGloria King1976-07-02——932 Ocean Ave, Denver, CO, 802710.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-409295CLMStephenie Hamilton1963-09-04UHC-40363-22—6214 Baseline Rd, Columbus, OH, 432440.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-432702CLMJack Kelly1977-05-26UHC-23475-39—6237 Harbor Blvd, Seattle, WA, 981760.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-405184CLMAustin Watson1998-06-16UHC-30177-94—7865 Highland Ave, Minneapolis, MN, 554250.52Name re-casedTwo-digit birth yearState name converted to codeGender normalised+2 more
CLM-410535CLMEthan Morrison1978-12-19UHC-86725-0441748326688293 Harbor Blvd, Fresno, CA, 937150.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413376CLMAisha Hamilton1952-12-06UHC-91392-6439530815877189 Valley View Dr, Miami, FL, 331810.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422280CLMMaria Jones1981-12-28——5204 Spring St, Chandler, AZ, 852210.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408393CLMArjun Chavez1958-07-21—77527778633309 Elm St, Charlotte, NC, 282760.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405784CLMDoris L Robertson1951-03-03UHC-59682-46—1581 Canyon Rd, Houston, TX, 770970.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-432558CLMMariana Henderson1986-11-02UHC-16259-95—8672 Highland Ave, Orlando, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-429299CLMArthur Smith1975-09-02—87726361787230 Harbor Blvd Apt 23, Nashville, TN, 372020.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-427978CLMRuth Jones1983-03-16UHC-19292-4143799211225065 Sage Ct, Fresno, CA, 937200.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406287CLMIsabella Carrr1960-06-13UHC-32279-06—1829 Mountain View Dr Apt 17, Phoenix, AZ, 850080.52Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+2 more
CLM-418270CLMKenneth Sims1999-06-16UHC-30731-182473060141392 Indian School Rd, Phoenix, AZ, 850960.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-423697CLMRonald West—UHC-21226-6934990132551699 Union St, Minneapolis, MN, 554670.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420054CLMTeresa Snyder2006-03-14UHC-84654-02—750 Church St, Chandler, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-407067CLMMariana Roberts1979-06-21UHC-18824-99—3135 Market St # 785, San Diego, CA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-424207CLMLinda S Wong1986-02-05—61428967882390 Apache Blvd, Tampa, FL, 336810.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-426897CLMSteve P Lawrence1974-12-08——5363 Park Pl Apt 38, Plano, TX, 750870.52Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
CLM-423107CLMRaymond Collins1971-03-26—35349012446254 Forest Ave, Seattle, WA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-426178CLMJose Jordan1947-12-06UHC-22708-9256280540752093 Oak St, Dallas, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-413262CLMEdward Alvarez1948-01-05UHC-92725-8887861784849770 Highland Ave, Fresno, CA0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415799CLMAlan Ramos———3586 Bayshore Dr, Chandler, AZ, 852550.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-414916CLMAndrea Pena2004-03-16——5974 Grand Ave # 240, Nashville, TN, 372840.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426899CLMEthan Rogers1938-12-18——1672 Spring St, San Antonio, TX, 782510.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-405160CLMAlexis Fox2007-04-26UHC-32649-36—7627 Indian School Rd Apt 38, Gilbert, AZ, 852000.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414698CLMNicholas Elis1982-03-16UHC-59410-0333449271367082 Willow Ct # 712, Mesa, AZ, 852980.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405896CLMNoah Pena1977-02-21—70344085659475 Canyon Rd, Fresno, CA, 937010.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410619CLMRonald Sanders1978-08-24UHC-31632-29—7520 Church St, Minneapolis, MN, 554140.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-401136CLMKayla Mejia2003-09-22UHC-37503-44—6725 Baseline Rd, Seattle, WA, 981600.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-417846CLMSean Castro1973-07-25UHC-78224-40—9846 Bayshore Dr, Tampa, FL, 336720.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-413106CLMHenry Hanson—UHC-69978-70—8735 Bayshore Dr, Houston, TX, 770670.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-411983CLMFuller Christian1993-07-18——7702 Harbor Blvd, Minneapolis, MN, 554310.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-430924CLMEmma Baker—UHC-19416-16—2129 Market St, Chandler, AZ, 852230.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 42 of 657PreviousNext