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-418176CLMMichael Diiaz1967-02-07UHC-32363-72—7862 Indian School Rd, Eden Prairie, MN, 553180.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432651CLMOmar Brown1963-04-25—5175460617305 Bayshore Dr, Austin, TX, 787350.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-427554CLMAnthony C Oliver1962-09-24UHC-51791-98—611 Lincoln Way, Sacramento, CA, 958330.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417236CLMDouglas Rivera1976-07-10UHC-47071-9055798845734178 Cedar Ln, Columbus, OH, 432400.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-420991CLMGregory Contreras1990-10-04UHC-39315-7582635525045978 Mesa Dr # 834, Tampa, FL, 336300.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-408645CLMNicholas G Lane2006-12-14——7666 Church St, Phoenix, AZ, 850360.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-409216CLMKyyle Day1971-05-18UHC-43152-5135448847251724 Jefferson Ave, San Diego, CA, 921880.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-425924CLMAbigail Luna1954-12-16—71485490858942 Hillcrest Rd, Dallas, TX, 752300.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410320CLMMark S Evans1965-11-08—71378971794880 Ridge Rd, Scottsdale, AZ, 852270.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-430370CLMKathryn Obrien—UHC-59533-247412632886650 Apache Blvd, Phoenix, AZ, 850220.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-413035CLMChristian Hernandez1951-03-27UHC-41092-13—1662 Pine Dr, Las Vegas, NV, 891710.62Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-427113CLMJeremy B Howell1981-03-25—42451353756008 Sage Ct, Minneapolis, MN0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410659CLMJulie Hoffman1978-05-02UHC-64890-5632637488949685 Elm St, Orlando, FL, 328720.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-407221CLMBobby Rose2003-06-22UHC-53186-5657363963533038 Indian School Rd, Seattle, WA, 981460.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428675CLMJoe Perry1940-12-09UHC-87923-8559052798244480 Willow Ct Apt 16, Denver, CO, 802750.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-416415CLMSantiago Edwards2001-03-24——1283 Main St, Dallas, TX, 752480.62Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-424671CLMKennedy Valentina1943-08-06UHC-03137-73—5500 Ocean Ave, Glendale, AZ, 853690.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430746CLMMaria Schmidt1957-04-28UHC-24260-2394899146058387 Willow Ct, Columbus, OH, 432000.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-409718CLMAisha Baker1944-03-19UHC-54571-0522580310795994 Indian School Rd Apt 16, Charlotte, NC, 282100.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-421588CLMPatty Ellis1976-10-19——8285 Church St, Fresno, CA, 937560.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413870CLMTeresa Castro1974-07-06UHC-25853-305968562151324 Ridge Rd, Tampa, FL, 336560.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426390CLMDebra Sullivan2002-06-28UHC-69005-9485189814169094 Union St # 225, San Diego, CA, 921480.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-407915CLMGabriel Y Castro1938-06-04——7898 Union St, Atlanta, GA0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-409984CLMStephen McCoy1976-03-10UHC-00347-08—8878 Market St, Scottsdale, AZ0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-415809CLMFatima Moreno1957-07-16—75822916477442 Oak St, Denver, CO, 802540.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420399CLMJustin Z Murphy1997-05-10——6689 Ridge Rd, Miami, FL0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427017CLMRichard F James1974-11-02—68546762213898 Highland Ave, Houston, TX, 770950.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429546CLMJacob C Coleman1952-08-26—26234143067965 Palm Dr # 931, Jacksonville, FL, 322680.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-406419CLMChristina Dominguez1943-07-16——2619 Highland Ave, Phoenix, AZ0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-423297CLMMadison R Brooks1973-11-20UHC-66865-2891366691094130 Desert Sky Blvd, Atlanta, GA, 303980.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404981CLMLinda Sanchez1970-03-22—44259882061796 Baseline Rd, Fresno, CA, 937320.62Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-401536CLMMcIhael Fields1969-09-14UHC-13912-97—332 Baseline Rd Apt 6, Tucson, AZ, 857560.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-407285CLMCarl G Torres1978-02-05——897 Lake View Rd, Austin, TX, 787680.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-420621CLMNathan Tran2003-06-21UHC-26240-3380033410534071 River Rd, Los Angeles, CA, 900610.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416708CLMAhmed Lewis1986-11-18UHC-62800-8679147798221864 Baseline Rd, Miami, FL0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424198CLMLucia Medina1981-09-03UHC-94530-38—8494 Indian School Rd, Plano, TX, 750030.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-417359CLMRebcca Kelley1982-09-13UHC-77338-9044724916483860 Camelback Rd, Orlando, FL, 328130.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-418578CLMKeith Hicks1951-08-22——6882 Oak St # 524, Eden Prairie, MN, 553160.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412340CLMRussell D Carter1940-10-16UHC-58996-0470059916591066 Main St Apt 21, Fresno, CA, 937050.62Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-425596CLMAisha Wallace1971-05-21—57274248967738 Highland Ave, Tucson, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428413CLMBradley William1938-04-02——766 Spring St, Tempe, AZ, 852270.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401085CLMGabriel Brokos2003-06-07—4819315738682 Pine Dr, Phoenix, AZ, 850510.62Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-423808CLMChristine E Cunningham2002-02-17UHC-89978-63—5620 Canyon Rd, Chandler, AZ, 852240.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411665CLMEmma Washington1949-12-01—75325534511408 Meadow Ln, Phoenix, AZ, 850210.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413943CLMWilliam Tran1974-06-12UHC-33437-1845539167892839 Grand Ave, Plano, TX0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-401129CLMGabriel Lane1997-11-04UHC-54367-0953452325068839 Lincoln Way, Columbus, OH, 432680.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409933CLMJeffrey Collins1963-05-16——3872 Mountain View Dr, Sacramento, CA, 958370.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-411359CLMRoger D Dixon—UHC-30886-8796765538861715 Jefferson Ave, Dallas, TX, 752430.62Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406109CLMAdam Cnotreras1973-04-05——5706 Indian School Rd, Plano, TX, 750910.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-422105CLMBobby Ellis1965-10-20UHC-24725-6884864028007921 Palm Dr, Plano, TX0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
32,829 rows, page 96 of 657PreviousNext