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-414214CLMHelen Griffin1980-06-25UHC-02984-29—543 Mesa Dr, Houston, TX, 770910.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408255CLMKayla Chen1967-01-25——8289 Main St Apt 21, Nashville, TN, 372440.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-417172CLMHarold Simmons1948-07-21UHC-09892-8192186743451157 Desert Sky Blvd, Gilbert, AZ, 852270.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-418317CLMJoan Anderson1968-07-17UHC-17288-64—3501 Washington St Apt 23, Orlando, FL, 328680.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-411065CLMSandra Morgan1939-05-20UHC-28897-69—1706 Palm Dr, Denver, CO, 802870.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425262CLMOmar Mendez—UHC-18365-7088771507496109 Broadway, Phoenix, AZ, 850040.62Name re-casedDate of birth unreadablePhone reformattedAddress re-cased+3 more
CLM-408581CLMBurns Stevn1978-08-12UHC-52339-5274870367436845 Elm St, Charlotte, NC, 282720.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-404608CLMJudy Long2001-05-20UHC-14892-6480371297864143 Apache Blvd, Gilbert, AZ, 852720.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429994CLMMartha Hunter1960-05-25UHC-01122-4520270526525179 Ridge Rd, Nashville, TN, 372160.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429436CLMScutt Collins1983-05-19UHC-15395-6428257574276546 Market St, Las Vegas, NV, 891790.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-431080CLMMei Vega2008-01-22—4669632303641 Highland Ave, Gilbert, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430934CLMDeborah Hughes1956-01-10—86899295277923 Lake View Rd, San Antonio, TX, 782240.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430724CLMMateo Salazar1965-05-19—81034285094525 Highland Ave, Mesa, AZ, 852150.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410803CLMFatima Baker1982-12-22UHC-98242-1374824433937973 Apache Blvd, Chandler, AZ, 852890.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417580CLMHenry Graham1969-04-04—815263347946 Grand Ave, Plano, TX, 750230.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-417579CLMHenry Graham1969-04-04—815263347946 Grand Ave, Plano, TX, 750230.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-424767CLMDaniel Elliott1941-12-11UHC-11181-2688570909854953 Washington St, Eden Prairie, MN, 553700.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431348CLMRyan Anderson1999-10-17UHC-78959-95—1852 Main St, Las Vegas, NV, 891110.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415445CLMTyler Rojas1994-06-27UHC-99681-6484677390054070 Main St, Scottsdale, AZ, 852630.62Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-404304CLMBeverly Rodriguez1996-06-04UHC-85728-2493054457671721 Grand Ave, Glendale, AZ, 853830.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428574CLMNicholas Tran2001-01-25——4942 Hillcrest Rd, Austin, TX0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-417396CLMAhmed Howard1972-06-26—64563379068347 Church St, Las Vegas, NV, 891470.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431402CLMGary O Matthews1945-11-13——4842 Pine Dr, Charlotte, NC, 282660.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405273CLMHeather Meyer1963-07-01UHC-25788-8628845006345511 Mountain View Dr, Dallas, TX0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-416588CLMDebra Wagner1967-06-21UHC-54439-2877854719304557 Canyon Rd, San Antonio, TX, 782400.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415533CLMJerry Dunn1939-06-05—4936428640658 Washington St, Columbus, OH, 432950.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406799CLMTeresa Hunt1976-08-13UHC-72508-0980980775146343 Lake View Rd, Chandler, AZ, 852060.62Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+3 more
CLM-428026CLMDeborah Carlson———3493 Mountain View Dr, Sacramento, CA, 958940.62Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+3 more
CLM-427460CLMLori U Ellis1947-10-21UHC-66036-0366478419797470 Bayshore Dr, Scottsdale, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401241CLMLina V Riley1982-07-15—74259411771557 Central Ave, Seattle, WA, 981230.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413735CLMSantiago N Hudson1951-09-25UHC-21919-41—6607 Meadow Ln, Houston, TX, 770770.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431519CLMSamantha Cook1946-05-07UHC-28805-55—3442 Hillcrest Rd, Denver, CO0.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406643CLMJoyce Robertson1954-12-23UHC-29622-207529408338561 Ocean Ave, San Antonio, TX, 782280.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406644CLMJoyce Robertson1954-12-23UHC-29622-207529408338561 Ocean Ave, San Antonio, TX, 782280.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404553CLMJulie Fields1956-08-09UHC-68737-1031751165256025 Oak St, San Antonio, TX, 782410.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411508CLMJuan Bell1953-01-03——8862 Hillcrest Rd, Phoenix, AZ, 850210.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-425897CLMSusan Perry2003-07-18UHC-84096-5542374058275019 Meadow Ln, Orlando, FL, 328620.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421706CLMAisha Bishop1987-05-26—33034964727135 Baseline Rd, Charlotte, NC, 282350.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431490CLMAlexis Richardson1966-10-20UHC-21092-12—8579 Baseline Rd Apt 7, Nashville, TN, 372020.62Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-432776CLMMason M Washington1965-08-16UHC-11018-53—5155 Ridge Rd, Minneapolis, MN, 554670.62Name re-casedDate of birth reformattedState code upper-casedZIP+4 trimmed+3 more
CLM-402938CLMDiaz Joshua1988-04-04UHC-17950-828385028773693 Central Ave, Fresno, CA0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412371CLMCharles Y Franklin1997-06-08UHC-12070-1674680428913188 Cedar Ln, Scottsdale, AZ, 852360.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411117CLMKimberly Duncan1999-07-10—63928716076835 Jefferson Ave, Jacksonville, FL, 322840.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-400659CLMLawrence Garrett1982-07-27UHC-83755-5986067746956007 Broadway, Tampa, FL, 336870.62Date of birth reformattedPhone reformattedAddress re-casedZIP+4 trimmed+3 more
CLM-432658CLMAlice Hanson1952-11-06UHC-82049-78—6900 Spring St, Scottsdale, AZ, 852640.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413092CLMRyan Hill1961-04-14UHC-29944-94—1721 Ridge Rd Apt 3, Las Vegas, NV, 891940.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-400674CLMRandy Myers1966-01-11—60859098045633 Mesa Dr, San Antonio, TX, 782560.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430371CLMLinda Burton1956-01-25UHC-39412-86—6114 Apache Blvd, Austin, TX, 787200.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420388CLMMary M Garrett2007-12-22——2645 Lake View Rd # 668, Phoenix, AZ, 850180.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-429374CLMRussell Flores1976-11-16—58074995233714 Bayshore Dr, Fresno, CA, 937500.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
32,829 rows, page 83 of 657PreviousNext