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-428465CLMLisa Yang1972-07-13UHC-51154-51—5461 Valley View Dr, Seattle, WA0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405101CLMDiane Knight1942-11-18—24246830302976 Market St, Tucson, AZ, 857600.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408624CLMDiego Campbell1975-01-09—66080877427400 Main St, Fresno, CA, 937960.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402587CLMJennifer Oliver1972-06-16—66069206589553 Highland Ave, Seattle, WA, 981530.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416213CLMTimothy Fereman1992-07-09UHC-34025-6093169663895657 Market St, Seattle, WA, 981030.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-425653CLMFrank Anderson1985-02-13—24556588329725 Desert Sky Blvd, Tempe, AZ, 852500.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-431247CLMGregory Dean1986-04-16—31590145107680 Lake View Rd, Columbus, OH, 432000.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-407780CLMBenjamin Wbb1967-03-24UHC-91181-73—9584 Hillcrest Rd, San Diego, CA, 921730.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-403528CLMMaria Chavez1966-05-25—34358272119462 Mountain View Dr, Atlanta, GA, 303180.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430002CLMChristopher LJunk1967-09-11UHC-33800-1791926670583042 Sage Ct, Plano, TX, 750140.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-425374CLMDrew D Berry2003-04-08UHC-83026-2434145963112860 Market St, Nashville, TN, 372860.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-425821CLMSantiago Price1955-09-15UHC-44765-45—6407 Bayshore Dr, Orlando, FL, 328790.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404749CLMGabriel Moreno1963-03-04—8767701307492 Pine Dr, Los Angeles, CA, 900490.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400892CLMAmber Johnston1946-08-06——1914 Maple Ave, Atlanta, GA, 303030.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-416591CLMRandy Greene1995-03-22UHC-51031-1474766140938745 Baseline Rd, Gilbert, AZ0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-423899CLMMateo Chapman1975-10-13UHC-11485-33—8884 Mountain View Dr, Austin, TX, 787900.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410918CLMAshley Espinoza1995-03-07UHC-29663-8259788855044517 Ocean Ave, Glendale, AZ, 853080.62Name re-casedPhone reformattedMember ID reformattedState name converted to code+3 more
CLM-418452CLMJulia Jackson1986-05-03UHC-00538-03—9856 Maple Ave, San Antonio, TX, 782520.62Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-424200CLMJacob B Wood1989-04-24UHC-23540-39—1377 Willow Ct, Scottsdale, AZ, 852040.62Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
CLM-414469CLMElizabeth Santiago2002-01-27UHC-41576-25—8741 Palm Dr, Tempe, AZ, 852820.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-425385CLMRoger V Warren1962-09-09UHC-99655-2326748361576569 Mountain View Dr, Nashville, TN, 372820.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-408909CLMBrandon G Jacobs1955-08-05UHC-10592-72—9500 Grand Ave, Orlando, FL, 328250.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424079CLMLucia E Padilla——77742014931051 Maple Ave, Columbus, OH, 432980.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-429181CLMMegan I Richardson1959-05-13UHC-31006-1194091385872569 Indian School Rd, Orlando, FL0.62Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more
CLM-427730CLMSusan Graham1966-04-08UHC-42834-6434939060939569 Hillcrest Rd, Phoenix, AZ, 850220.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414156CLMDanny Benett2008-08-12UHC-66829-88—9592 Market St, Glendale, AZ, 853080.62Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
CLM-401903CLMTerry Ruiz1973-02-25UHC-41911-9574069854871220 Camelback Rd # 851, Los Angeles, CA, 900530.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406825CLMGrace Kelly1992-06-04UHC-21222-79—5725 Maple Ave, San Diego, CA, 921220.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423840CLMNoah Ortiz1988-06-04—65934270283793 Park Pl, Minneapolis, MN0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425413CLMSean Perkins1943-10-17UHC-05438-9786964959342758 Harbor Blvd, Mesa, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428217CLMRebecca C Hamilton1954-02-23UHC-26416-03—2665 Indian School Rd # 658, Plano, TX, 750190.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-414854CLMDonald Gonzales2006-10-09UHC-12549-849435833336179 Forest Ave, Jacksonville, FL, 322800.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422661CLMSara Duncan—UHC-26231-7726860281712909 Pine Dr, Gilbert, AZ, 852020.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-428692CLMLucia Rios1939-04-02UHC-92720-51—5436 Camelback Rd, Denver, CO, 802480.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-432187CLMStephen Gibson1995-11-22UHC-07734-2970755741778379 Ocean Ave, San Diego, CA, 921940.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-429832CLMJesse D Lewis1976-02-19—78045422172263 Oak St, Gilbert, AZ, 852330.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412367CLMMadison Webbb—UHC-00101-5020778751072888 Market St, Tucson, AZ, 857160.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-401666CLMEmma Cole——79230698168778 Pine Dr, Denver, CO, 802500.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-416308CLMNicole Ltitle1984-04-07UHC-13450-3320725631454572 Grand Ave, Houston, TX, 770110.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421697CLMEric Morgan1995-05-07UHC-37404-897144826159798 Ocean Ave, Miami, FL0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423856CLMJacob Turner1993-10-01UHC-72094-5466225071335366 Church St, Nashville, TN, 372340.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432073CLMJonathan X Bishop1998-06-24UHC-27890-4072530084035797 Desert Sky Blvd # 747, Mesa, AZ, 852150.62Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more
CLM-401724CLMJoe Rivera1952-07-18UHC-05846-87—6829 Harbor Blvd, Gilbert, AZ, 852300.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-415360CLMSophia Williamson1944-06-09UHC-37598-10—7952 Grand Ave, Plano, TX, 750770.62Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-404083CLMJacqueline Black1990-08-17UHC-52048-14—3673 Apache Blvd, Tucson, AZ, 857210.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-411113CLMKimberly Sullivan1957-07-08——1633 Forest Ave, Scottsdale, AZ, 852210.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-411114CLMKimberly Sullivan1957-07-08——1633 Forest Ave, Scottsdale, AZ, 852210.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-423869CLMMariana Peterson1998-12-07UHC-91604-2977063620019813 Union St Apt 15, Jacksonville, FL, 322050.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-405822CLMKenneth Q Freeman1957-09-19UHC-86967-6862840050448864 Palm Dr, Plano, TX, 750320.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408414CLMJanice Diaz1987-06-13UHC-88057-73—2994 Indian School Rd, Chandler, AZ, 852670.62Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 81 of 657PreviousNext