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-414384CLMDouglas Mendez1947-12-11——5921 Washington St, Miami, FL, 331880.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424253CLMKelly Evans1943-06-21UHC-73587-3387625467084317 Grand Ave, Miami, FL, 331880.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405196CLMJeremy T Garrett1996-11-08UHC-85404-2693538643712455 Pine Dr, Nashville, TN, 372790.62Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-420734CLMChristopher Lucas1946-01-07——6316 Lincoln Way, Minneapolis, MN, 554290.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431089CLMDina V Dixon1999-02-21UHC-36805-2470650565556630 Washington St, San Antonio, TX, 782460.62Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
CLM-428485CLMTerry Hughes2002-02-18UHC-96369-8921589558113241 Valley View Dr, Phoenix, AZ, 850180.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405410CLMDiego J Bradley1981-06-15—94059488894128 Sunset Blvd, Sacramento, CA0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-409391CLMAbigail Holmes1993-03-16UHC-14169-2740835969516461 Main St, Denver, CO, 802000.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429749CLMBradley Santiago1976-02-23UHC-26632-7792792464039398 Spring St, Fresno, CA, 937760.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429750CLMBradley Santiago1976-02-23UHC-26632-7792792464039398 Spring St, Fresno, CA, 937760.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-402572CLMKayla Soto1948-08-02UHC-34616-97—5011 Harbor Blvd Apt 25, Fresno, CA, 937000.62Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-411082CLMGabriel Harrison1947-08-24—62824268382663 Meadow Ln, Jacksonville, FL, 322910.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400777CLMMelissa Alexander—UHC-11511-21—8745 Ocean Ave, Charlotte, NC, 282100.62Name re-casedDate of birth unreadableMember ID reformattedCity re-cased+3 more
CLM-429459CLMTimothy U Jacobs1944-08-19UHC-20013-0248355369192140 Palm Dr, Gilbert, AZ, 852400.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-416742CLMAhmed V Gibson1976-03-13UHC-32423-1825988420178166 Desert Sky Blvd, Orlando, FL, 328170.62Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-414173CLMEric Freeman—UHC-11481-11—533 Highland Ave, Dallas, TX, 752520.62Date of birth missingMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426765CLMKatherine Bryant1946-11-11——7987 Apache Blvd, Phoenix, AZ0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426764CLMKatherine Bryant1946-11-11——7987 Apache Blvd, Phoenix, AZ0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403859CLMEthan Murray1990-12-01UHC-41636-07—601 Jefferson Ave, Sacramento, CA, 958240.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414965CLMLucia Vega2006-09-16UHC-56461-2163856829511004 Willow Ct, Nashville, TN, 372270.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-401101CLMHannah D Padilla1982-06-18—30864589671746 Spring St, Dallas, TX, 752840.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408905CLMKevin A Rice1999-08-06UHC-54331-4923321871978670 Main St, Chandler, AZ, 852650.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-404184CLMBrenda G Perkins1948-01-03UHC-78467-81—1719 Spring St, Austin, TX, 787040.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-432758CLMAdam Williamson1957-09-07—20623765996488 Central Ave, Fresno, CA, 937720.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-410526CLMAnn W Hudson1944-06-11UHC-45319-6048726901601546 Highland Ave # 211, Nashville, TN, 372780.62Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more
CLM-428921CLMAndrea Griffin1985-06-07——5822 Bayshore Dr Apt 1, Charlotte, NC, 282030.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-415157CLMMartha Green1962-09-08—60067519076176 Harbor Blvd, Dallas, TX, 752580.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404628CLMEvelyn Wilson1962-02-16UHC-19839-1993754499779772 Forest Ave, Plano, TX0.62Two-digit birth yearPhone reformattedState code upper-casedZIP missing+3 more
CLM-430913CLMJose Alexander1974-01-13UHC-74261-4150965831893114 Highland Ave, Nashville, TN, 372770.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-407816CLMDiane Mendez1973-12-13UHC-02276-61—6371 Grand Ave, Las Vegas, NV, 891910.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403567CLMJoe Richardson1943-10-04UHC-53594-5969064913445386 Apache Blvd, Nashville, TN, 372040.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428763CLMElizabeth Roose2006-10-22UHC-27150-81—4365 Baseline Rd, San Antonio, TX, 782350.62Name re-casedPhone missing area codeCity re-casedState code upper-cased+3 more
CLM-404284CLMBenjamin Richardson1958-04-17UHC-80303-6956064468796480 Indian School Rd, Dallas, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414902CLMGloia A Nguyen1948-12-13UHC-36381-18—242 Desert Sky Blvd, Denver, CO, 802230.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-414753CLMAndrea Davis1979-07-08UHC-58349-43—5797 Spring St, Denver, CO, 802050.62Name split from “Last, First”Date of birth reformattedMember ID reformattedGender normalised+3 more
CLM-408191CLMGregory Wang1960-03-23UHC-40108-707148345056934 Ocean Ave, Columbus, OH, 432480.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424691CLMJulia Dean1987-06-17——5101 Central Ave, Gilbert, AZ, 852210.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419138CLMAngela Murray2004-11-25UHC-17948-28942247295753 Elm St, Nashville, TN, 372150.62Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
CLM-426184CLMJessica B Pierce1960-03-20——1226 Jefferson Ave, Los Angeles, CA, 900200.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412210CLMNatalie Medina1987-05-27UHC-13431-9151578065126608 Maple Ave, Charlotte, NC, 282620.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-422782CLMJudy S Wang1985-04-05UHC-93720-28—6688 Washington St, Houston, TX, 770950.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-429594CLMMartha Watkins—UHC-39674-4579844429456223 Spring St, Seattle, WA, 981270.62Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-426890CLMNathan Sanchez1961-05-19UHC-99030-1886982036079173 Cedar Ln, Las Vegas, NV, 891940.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-419026CLMJack Jenkins—UHC-75461-96—7076 Church St, Atlanta, GA, 303290.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-419028CLMNatalie Ramos1958-04-23—74775564807803 Washington St Apt 2, Phoenix, AZ, 850460.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-422914CLMJeffrey Dixon1990-09-22UHC-96821-69—9173 Grand Ave, Miami, FL0.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411539CLMJoseph P Walsh1946-09-24—35650003946650 Indian School Rd, San Diego, CA0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-404082CLMAna X Fuller1978-10-18——9872 Spring St, Phoenix, AZ, 850420.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432219CLMDoris S Salazar1956-03-05UHC-06432-6785625774708525 Main St, Los Angeles, CA, 900510.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417384CLMChristian Nguyen1978-12-13UHC-03910-55—5012 Ocean Ave, Dallas, TX0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
32,829 rows, page 91 of 657PreviousNext