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-409118CLMFreeman Joe2007-11-17UHC-44075-78—7788 Meadow Ln, Miami, FL, 331280.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-432293CLMNathan Hernandez1961-02-12UHC-99827-0674690679897224 Cedar Ln, Columbus, OH, 432270.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-417455CLMPamela Chavez1999-06-02——3249 Forest Ave, Dallas, TX, 752840.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-407978CLMEdward X Cunningham1941-03-16UHC-34122-9861775544702332 Broadway, Dallas, TX, 752400.66Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
CLM-412727CLMAnn Welch1990-11-23UHC-96949-18—5773 Grand Ave, Seattle, WA, 981730.66Street suffix standardisedAddress re-casedGender normalisedPlan code upper-cased+1 more
CLM-403643CLMElijah Stephens1961-12-16UHC-35712-96—6193 Cedar Ln, Eden Prairie, MN, 553930.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421034CLMBraddley M Lane1938-01-06UHC-88564-9997525653499269 Valley View Dr, Sacramento, CA, 958180.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-416880CLMRichard Grant—UHC-86197-7661180381667735 Market St, Houston, TX, 770890.66Date of birth unreadablePhone reformattedState name converted to codeWhitespace trimmed+1 more
CLM-422169CLMSandra Alexander1950-04-13UHC-52523-4377630193968420 Forest Ave, Fresno, CA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-405403CLMJerry X Franklin1963-04-23—39753399012202 Apache Blvd, Houston, TX, 770320.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-407940CLMDonald R Castro1984-06-20——1823 Mountain View Dr, Tampa, FL, 336070.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-414001CLMKathryn Ortega1944-08-18UHC-71038-1588199349477208 Union St, Plano, TX, 750250.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414413CLMBobby Sandoval1998-07-13——8161 Ocean Ave, Mesa, AZ, 852980.66Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+1 more
CLM-413218CLMAlbert Fisher1971-06-06UHC-40609-8256197619148806 Park Pl, San Antonio, TX, 782120.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-424398CLMHeather Lane1983-07-19UHC-33557-34—7827 Valley View Dr # 196, Scottsdale, AZ, 852130.66Name re-casedTwo-digit birth yearUnit split from streetWhitespace trimmed+1 more
CLM-419408CLMMary Torres1951-03-26——5562 Highland Ave, Columbus, OH, 432980.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-417135CLMLisa Hernandez1992-11-25UHC-98334-1998555473604517 Grand Ave # 310, San Antonio, TX, 782070.66Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+1 more
CLM-404173CLM—Junk1957-12-22UHC-14266-65—5404 Market St, Houston, TX, 770690.66Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-417907CLMPatricia V Bradley2000-08-04—48784399965690 Forest Ave, Houston, TX, 770230.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-408148CLMSofia Porter2002-07-04UHC-53417-68—1396 Apache Blvd, Austin, TX, 787080.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-424661CLMHenry Jackson1964-04-28——6329 River Rd, Las Vegas, NV0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-405502CLMMelissa Ruiz1940-12-02UHC-05094-92—6270 Union St # 710, Seattle, WA, 981810.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-428594CLMAdam Baker1998-11-08UHC-26096-08—1209 Park Pl, Eden Prairie, MN, 553240.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-404860CLMVirginia Munoz1964-08-23UHC-21025-48—4537 Oak St, Los Angeles, CA, 900180.66Member ID reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-427552CLMCynthia Burke1950-06-14UHC-33647-6895080556805687 Central Ave, Fresno, CA, 937320.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-403679CLMFrank Williamson1938-10-13—30874282825825 Forest Ave, Los Angeles, CA0.66Phone reformattedCity re-casedZIP missingGender normalised+1 more
CLM-400945CLMAmy Torres1959-05-04UHC-10546-5376545563885688 Cedar Ln, Austin, TX, 787830.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-421465CLMSean Ramirez1951-04-28UHC-87258-34—1056 Apache Blvd, San Diego, CA, 921400.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-431471CLMRebecca Jones1967-05-27UHC-46908-5375358338037642 Lincoln Way Apt 8, Seattle, WA0.66Phone reformattedUnit split from streetZIP missingWhitespace trimmed+1 more
CLM-417539CLMCarl K Duncan1971-02-08UHC-95895-028413458253—0.66Name split from “Last, First”Phone reformattedSSN last four extractedWhitespace trimmed+1 more
CLM-425477CLMNnacy Gibson1977-06-23UHC-33101-19—8766 Indian School Rd, Las Vegas, NV0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-419871CLMSoffia Kelley1956-01-22—41264281217324 Sage Ct, Tampa, FL, 336140.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-427512CLMKimberly Gordon2006-12-28UHC-89560-9578458452601992 Mountain View Dr, Charlotte, NC, 282880.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-413138CLMChris S Hamilton1984-10-03——1418 Broadway, Seattle, WA, 981080.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-413137CLMChris S Hamilton1984-10-03——1418 Broadway, Seattle, WA, 981080.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-404492CLMJonathan V Cunningham1988-01-15UHC-32520-9185281823738972 Union St, Minneapolis, MN, 554700.66Name split from “Last, First”Phone reformattedCity re-casedGender normalised+1 more
CLM-410213CLMFrances Diaz1978-07-05——8921 River Rd # 970, Eden Prairie, MN, 553750.66Unit split from streetCity re-casedGender normalisedWhitespace trimmed+1 more
CLM-432676CLMRachel Espinoza1979-08-22UHC-88110-90—7895 Park Pl, Gilbert, AZ, 852190.66Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-406199CLMChristine Murray2002-03-11UHC-13605-8847965311143663 Oak St # 573, Tempe, AZ, 852020.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-405650CLMRaymond Patel1947-12-18UHC-94437-2562798952405334 Meadow Ln, Denver, CO, 802920.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-401280CLMCharlotte C Guzman1985-05-17UHC-77788-7356053039999180 Oak St, Miami, FL, 331290.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-422156CLMDouglas Jensen1974-04-27UHC-04832-1972629983443849 Valley View Dr, San Diego, CA, 921690.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-405192CLMBenjamin Hunt1993-07-05——8179 Indian School Rd, Atlanta, GA, 303720.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-431842CLMJuan Williams1981-08-04—84323270177824 Sunset Blvd, Los Angeles, CA, 900490.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-420642CLMCrl Ross1984-10-05UHC-17816-38—9633 Pine Dr, Los Angeles, CA, 900830.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-403580CLMBrittany Cruz1964-02-22—30473071152650 Market St, Gilbert, AZ, 852970.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-403579CLMBrittany Cruz1964-02-22—30473071152650 Market St, Gilbert, AZ, 852970.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-405490CLMJacob Rivera2005-08-21UHC-66815-3245629572225445 Union St, Columbus, OH, 432550.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
CLM-402923CLMBenjamin Evans1975-07-16UHC-28667-26—2265 Cedar Ln Apt 12, San Diego, CA, 921800.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-401126CLMJordan B Wellch2001-11-13UHC-43144-83—2704 Maple Ave, Denver, CO, 802260.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
32,829 rows, page 180 of 657PreviousNext