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-420168CLMCarolyn H Morales———9473 Elm St, Miami, FL, 331820.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-402389CLMLinda Ryan1952-06-11UHC-16663-5166555727303595 Elm St, Scottsdale, AZ, 852970.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-410023CLMTyler Carter1997-10-16——7468 Lake View Rd, Los Angeles, CA, 900550.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-401638CLMAaron Padilla1948-01-22UHC-23716-2036465991583528 Union St, Los Angeles, CA, 900170.64Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more
CLM-417889CLMRyan Wright1953-03-20UHC-72160-97—2436 Maple Ave, San Diego, CA0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-410188CLMCharlotte R Marquez1942-01-27UHC-49101-35—1083 Mountain View Dr, Atlanta, GA, 303580.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419120CLMLe U Jonathan1978-08-09UHC-34946-1480897832594386 Market St, Denver, CO, 802540.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412413CLMAndrew Foster1955-10-12UHC-85895-3263942653306503 Cedar Ln, Las Vegas, NV, 891730.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-411818CLMAaron Sandoval2006-04-13UHC-29436-35—8939 Valley View Dr, Jacksonville, FL, 322200.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406416CLMHeather Singh1948-01-09UHC-61064-1042443390756811 Elm St, Plano, TX, 750980.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-426312CLMCheryl Perez1963-04-01—60886397911788 Sunset Blvd, Mesa, AZ, 852480.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-400200CLMRoegr Orttiz1970-12-19UHC-26091-5423336736127441 Bayshore Dr, Minneapolis, MN, 554110.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-431859CLMRandy Rss1940-01-07—3174487162728 Spring St, Orlando, FL, 328930.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-423642CLMTimothy Franklin1968-05-13UHC-31927-61—1703 Oak St, Eden Prairie, MN, 553220.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-414585CLMSam Ross1998-03-03UHC-33174-5994023839653528 Meadow Ln Apt 33, Houston, TX, 770020.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-413821CLMLogan T Phillips1962-04-09UHC-41116-08—2237 Market St, Seattle, WA, 981180.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-424343CLMAmber Reed1938-04-08UHC-53409-603153608502715 Valley View Dr, Miami, FL, 331830.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418070CLMPerez Kayla1964-12-11——5951 Forest Ave, Plano, TX, 750250.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-411108CLMAdam Rogers1991-02-14UHC-08320-642954659419550 Valley View Dr, Tampa, FL, 336790.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-408058CLMGabriel Burns1949-04-05UHC-23008-3994094199655336 Apache Blvd, Jacksonville, FL, 322970.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408849CLMMariana Mason1965-12-17——7478 Mountain View Dr, Jacksonville, FL, 322700.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-429127CLMLauren Wagner1959-01-09—81061617866697 Highland Ave, Seattle, WA, 981720.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-409791CLMMelissa Palmer1944-12-17UHC-30104-6851272055705098 Bayshore Dr Apt 34, Los Angeles, CA, 900320.64Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+2 more
CLM-401655CLMAlbert Salaazr1970-06-22——7410 Forest Ave # 373, Los Angeles, CA, 900740.64Name re-casedDate of birth reformattedUnit split from streetState name converted to code+2 more
CLM-404063CLMJudith N Mers1946-09-27UHC-57361-7853638323277974 Ocean Ave Apt 33, Austin, TX, 787580.64Date of birth reformattedPhone reformattedUnit split from streetGender normalised+2 more
CLM-411774CLMEric XJunk1950-09-19UHC-64477-90—6054 Forest Ave, Las Vegas, NV, 891460.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-427943CLMSarah Cox1961-09-08UHC-82695-39—1726 Apache Blvd, Sacramento, CA, 958790.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-407895CLMTeresa Gutierrez2001-03-21UHC-30469-278406553103—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-423804CLMHeather M Chavez1947-10-03UHC-48341-502995580953698 Apache Blvd, Miami, FL, 331890.64Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
CLM-430822CLMKimberly Wang1988-01-05—9326759001935 Jefferson Ave, Sacramento, CA, 958090.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417215CLMJack Campbell1968-03-16UHC-15180-41—1440 Grand Ave, Las Vegas, NV0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420323CLMDanny Tucker1947-10-26——963 Willow Ct, Jacksonville, FL, 322490.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422215CLMYuki Smith1995-02-28——8941 Highland Ave, Phoenix, AZ, 850560.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420413CLMGloria Tran1945-05-04UHC-23626-7651767784996142 Apache Blvd, Jacksonville, FL, 322250.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-407417CLMRachel Munoz2004-03-17UHC-15937-0489850846667646 Bayshore Dr, Eden Prairie, MN, 553070.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432034CLMValentina Y Murray1963-06-27UHC-04164-84—306 Apache Blvd, Seattle, WA, 981880.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403848CLMCatherine I Richardson2005-08-26UHC-15592-7886178570172274 Church St, Scottsdale, AZ, 852380.64Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
CLM-403244CLMKen Martinez1966-11-26UHC-66774-9141364547506621 Sage Ct, Fresno, CA, 937350.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-427679CLMMargaret Yang1987-12-28UHC-98394-52—45 Park Pl, Tucson, AZ, 857170.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-430868CLMDennis Brown1944-05-22——5143 Cedar Ln, Minneapolis, MN, 554470.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-430867CLMDennis Brown1944-05-22——5143 Cedar Ln, Minneapolis, MN, 554470.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-404292CLMCarloos Graay1941-08-12UHC-64484-73—8227 Grand Ave, San Diego, CA, 921460.64Member ID reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-404293CLMCarloos Graay1941-08-12UHC-64484-73—8227 Grand Ave, San Diego, CA, 921460.64Member ID reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-404034CLMLogan Burton1948-06-07UHC-40551-44—3861 Lake View Rd, San Diego, CA, 921970.64Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-418503CLMRalph Montgomery1968-03-03——8841 Central Ave, Jacksonville, FL, 322230.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413200CLMAnna Waalsh1957-03-01UHC-93358-6973636340281738 Sunset Blvd, Jacksonville, FL, 322950.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412258CLMCharlutte Espinoza2002-11-21UHC-63127-6039860852522513 Oak St, Los Angeles, CA, 900420.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-412196CLMEdward Nichols1997-04-26UHC-26667-4492391423404601 Ridge Rd, Dallas, TX, 752160.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-417041CLMLawrence Greene—UHC-33689-73—2538 Sage Ct, Austin, TX, 787360.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-427451CLMKathryn M Hart1947-01-10—46361677141306 Pine Dr, Atlanta, GA, 303030.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
32,829 rows, page 130 of 657PreviousNext