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-426156CLMRussell Schultz1964-07-04UHC-11427-28—1372 Forest Ave, Plano, TX, 750330.74Name re-casedDate of birth reformattedMember ID reformattedCity re-cased+3 more
CLM-402296CLMEsspinoza P Amber1948-01-22UHC-65231-24—9369 Valley View Dr, Columbus, OH, 432560.74Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414581CLMDenise Roberts1972-02-15UHC-19669-3180757367885846 Indian School Rd, Houston, TX, 770370.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-417462CLMDanielle Gomez1962-01-04UHC-89338-0949661690259496 Cedar Ln, Jacksonville, FL, 322230.74Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-404957CLMKatherine R Austin1964-01-09—61522443948602 Main St, Jacksonville, FL, 322400.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416658CLMSimpson Judith1986-04-27UHC-21051-1392848096222933 Pine Dr, Tempe, AZ, 852070.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422176CLMVincent Holmes1942-09-03UHC-45761-4660697499082193 Maple Ave Apt 9, Seattle, WA, 981700.74Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-406308CLMMichhael Peters1951-07-01UHC-46427-7178467593665547 Mountain View Dr, Scottsdale, AZ, 852280.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-405610CLMLarry F Jackson1943-03-16—91789403019602 Church St, Seattle, WA, 981240.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412326CLMJuan Harris1965-11-17—77949912345790 Cedar Ln, Sacramento, CA, 958020.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-420371CLMGabriel Thompson1953-09-15—49731798021380 Washington St, Nashville, TN, 372200.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424612CLMPeter Patel1945-04-20UHC-99963-63—981 Union St, Chandler, AZ, 852640.74Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426841CLMDanielle Reynolds1993-03-13—53336098293938 Pine Dr, Atlanta, GA, 303480.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-401273CLMMason Porter1984-11-16—29277562339563 Ocean Ave, Scottsdale, AZ, 852200.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401272CLMMason Porter1984-11-16—29277562339563 Ocean Ave, Scottsdale, AZ, 852200.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418975CLMJuan C Powell1986-03-20UHC-26955-3670772659483389 Pine Dr, Fresno, CA, 937360.74Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-411270CLMDebra Ramos1992-04-19—3954296772431 Cedar Ln, Minneapolis, MN, 554570.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-415185CLMWalter X Carter2003-10-18—70064049702950 Bayshore Dr, Austin, TX, 787080.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-411941CLMAlexander Anderson1950-05-14UHC-79887-2847832009731045 Ocean Ave, Orlando, FL, 328830.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422161CLMPaul Rommero1971-11-27UHC-28842-6438425381408261 Harbor Blvd, Miami, FL, 331320.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-405041CLMJudy Sanders1961-06-20—60162208598196 Ridge Rd, Los Angeles, CA, 900320.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416156CLMPriya Welch1991-08-20—89959369378413 Ocean Ave, Nashville, TN, 372440.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406730CLMBrenda Day1975-08-25UHC-90446-5297071466998929 Willow Ct, Tucson, AZ, 857520.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431626CLMGabriel Rios1960-07-09UHC-91956-1048863471984839 Ocean Ave, San Antonio, TX, 782640.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422480CLMZachary Gaorge1982-02-19——8626 Ridge Rd, Seattle, WA, 981230.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414634CLMRebecca Bennnett1948-04-27UHC-21274-8982974181455990 Camelback Rd, Gilbert, AZ, 852680.74Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
CLM-402686CLMNoah Lawrence1965-07-20UHC-16878-362895613596169 Baseline Rd, Minneapolis, MN, 554430.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407310CLMChristopher B Cooper1968-04-23UHC-06864-8324153909003094 Willow Ct, Columbus, OH, 432640.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-412847CLMJerry Romero1964-03-24——855 Lake View Rd, Tucson, AZ, 857860.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405728CLMBradley Carroll1978-04-11UHC-55821-4788978107359524 Palm Dr, Eden Prairie, MN, 553840.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-412015CLMJerry Price1957-10-17UHC-62204-46—563 Desert Sky Blvd, Glendale, AZ, 853400.74Name re-casedDate of birth reformattedMember ID reformattedCity re-cased+3 more
CLM-416115CLMJack Sims1983-09-21UHC-08090-7282498948898391 Harbor Blvd, Plano, TX, 750730.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
CLM-412990CLMJeremy Castillo1981-09-28UHC-29703-0261251638363847 Grand Ave, Tempe, AZ, 852350.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-411744CLMAshley U Perry1987-02-07UHC-75552-09—3205 Ridge Rd, Atlanta, GA, 303590.74Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-429566CLMAlexis Armsrtong2004-09-05UHC-43400-9945660339239668 Lincoln Way, Scottsdale, AZ, 852120.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419773CLMDeborah Sanders1957-09-13UHC-37538-2974237877883107 Market St, Atlanta, GA, 303770.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-402585CLMRussell Le1941-05-10UHC-19416-537007392456—0.74Name re-casedPhone reformattedMember ID reformattedGender normalised+3 more
CLM-419652CLMJennifer Russell2003-03-03UHC-52480-1521475763628600 Ridge Rd, Chandler, AZ, 852870.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427767CLMAnthony Harris2002-11-20UHC-93261-8883643901456767 Palm Dr, Orlando, FL, 328330.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423117CLMSam Dean2004-11-26UHC-17723-1875556637978064 Indian School Rd, Dallas, TX, 752800.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-400237CLMAngela Espinooza1979-07-09—25069329166531 Ocean Ave, Fresno, CA, 937430.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416817CLMSara Ramos2008-11-19—42168545862967 Highland Ave, San Diego, CA, 921230.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-418128CLMShirley Le2002-03-28UHC-24005-0991480775557260 Market St, Mesa, AZ, 852200.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409226CLMMegan Meyer1945-04-12UHC-75159-7570986956614769 Park Pl, Atlanta, GA, 303300.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-421641CLMSarah Richards1969-07-06—86439605855747 Palm Dr, Scottsdale, AZ, 852230.74Name re-casedCity re-casedState code upper-casedGender normalised+3 more
CLM-426435CLMJennifer Carroll1946-04-23UHC-60488-6179420648224830 River Rd, Las Vegas, NV, 891280.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411841CLMRichards Theresa1968-04-08UHC-25205-2945696375775657 Ridge Rd, Las Vegas, NV, 891400.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422359CLMNancy G Williamson1962-04-06——1452 Cedar Ln, Glendale, AZ, 853790.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417713CLMLori Contreras1964-02-14—85947202355981 Maple Ave, Dallas, TX, 752730.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-425942CLMRalph Andrews1953-09-20UHC-85599-2021222780558747 Desert Sky Blvd, Miami, FL, 331440.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
32,829 rows, page 231 of 657PreviousNext