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-410813CLMArjun Russell1978-03-14UHC-27441-79—3080 Palm Dr, Sacramento, CA, 958580.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-415451CLMJacqueline Young1969-01-27UHC-67667-24—5905 Maple Ave, Glendale, AZ, 853480.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-424380CLMNicole Bryant1973-03-24UHC-87960-1641866863518509 Valley View Dr, Dallas, TX, 752080.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414792CLMScott Ward—UHC-40403-019702470172468 Pine Dr, Jacksonville, FL, 322510.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-401326CLMKeith Brooks1986-03-26UHC-63341-37—5724 Pine Dr, Denver, CO, 802990.66Name split from “Last, First”Two-digit birth yearCity re-casedWhitespace trimmed+1 more
CLM-404770CLMLuis Park1950-09-14——759 Forest Ave, Houston, TX0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-403106CLMEthan Stevens1961-05-25UHC-83036-06—7486 River Rd, Dallas, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-419113CLMJacqueline Nelosn1956-08-17UHC-14047-09—9235 Jefferson Ave, Los Angeles, CA, 900260.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-402390CLMLinda Ryan1952-06-11—66555727303595 Elm St, Scottsdale, AZ, 852970.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-418447CLMMaria Castillo1955-10-06UHC-23443-73—3511 Ocean Ave, Seattle, WA, 981610.66Two-digit birth yearPhone missing area codeCity re-casedWhitespace trimmed+1 more
CLM-415223CLMPhilip A Gant1990-09-27UHC-64888-16—5762 Main St, Mesa, AZ, 852270.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412716CLMAmy Hawins1967-04-16UHC-23477-6970774729181162 Grand Ave, Minneapolis, MN, 554060.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-412715CLMAmy Hawins1967-04-16UHC-23477-6970774729181162 Grand Ave, Minneapolis, MN, 554060.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-408698CLMShirley Hunt1958-09-01UHC-53979-1050924605011390 Indian School Rd, Fresno, CA, 937890.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-424037CLMJerry Martin1994-11-16UHC-95865-4432933102009420 Baseline Rd, Houston, TX, 770250.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-410722CLMRalph Buurns1962-07-13UHC-48557-352276157714679 Palm Dr, Jacksonville, FL, 322140.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410376CLMArujn Larson1991-01-24UHC-89929-2498544054541443 Mesa Dr, Plano, TX, 750590.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-424759CLMThomas Matthews2005-09-23UHC-54543-7279825424446278 Central Ave, Nashville, TN0.66Street suffix standardisedAddress re-casedState code upper-casedZIP missing+1 more
CLM-430417CLMValentina Guerrero1977-09-18——7765 Grand Ave, Columbus, OH, 432320.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-406045CLMNicole Sullivan2005-09-21UHC-05239-58—5598 Valley View Dr, Tempe, AZ, 852350.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402495CLMEvelyn P Fisher2005-10-08UHC-52353-84—489 Highland Ave, Sacramento, CA, 958260.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-417552CLMAlbert Cruz1992-04-19——8046 Camelback Rd, Seattle, WA, 981370.66Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-418125CLMDonald Weber1977-01-24UHC-71132-5280476084224064 Indian School Rd, Minneapolis, MN, 554600.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-423695CLMFatima Bell1997-02-17—37839624603325 Harbor Blvd, Miami, FL, 331790.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-416965CLMJulia Flres1972-07-03UHC-63679-633518716314663 Sage Ct, Charlotte, NC, 282650.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413963CLMJanet Stone1994-05-27—21769283825916 Sage Ct, Sacramento, CA, 958880.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425559CLMDonan Cole1963-10-15UHC-91826-55—5655 Apache Blvd, Chandler, AZ, 852310.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-429142CLMLuis Gray2000-03-07UHC-13868-7084236080141486 Willow Ct Apt 21, Denver, CO, 802160.66Member ID reformattedUnit split from streetCity re-casedGender normalised+1 more
CLM-430452CLMJuan Munoz1945-07-17UHC-06071-85—7445 Washington St, Houston, TX, 770640.66Date of birth reformattedPhone missing area codeEmail lower-casedGender normalised+1 more
CLM-425321CLMBenjamin Stone1986-11-28UHC-33045-31—8811 Palm Dr, Tampa, FL, 336450.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-410754CLMJordan George1969-09-21——274 Desert Sky Blvd, Austin, TX, 787700.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-403889CLMHenry M Tran1977-01-13UHC-54488-12—4058 Palm Dr, Miami, FL, 331240.66Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more
CLM-426869CLMWei O Garza1973-05-16UHC-65237-7483161129264564 Ocean Ave, Atlanta, GA, 303060.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-403940CLMDiego Pena1993-08-12UHC-86712-48—43 Washington St, Atlanta, GA, 303750.66Name re-casedTwo-digit birth yearMember ID reformattedGender normalised+1 more
CLM-410551CLMVincent Day1994-01-23UHC-43106-965384793763—0.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-426134CLMScott Shaw1958-03-02UHC-40662-50—504 Camelback Rd, Dallas, TX, 752710.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
CLM-414913CLMHamilton Dennis1938-08-11——7037 Highland Ave, Nashville, TN, 372990.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-408508CLMBrenda P Obrien2004-09-12——2758 Jefferson Ave, Denver, CO, 802630.66Name split from “Last, First”Name re-casedStreet suffix standardisedAddress re-cased+1 more
CLM-419763CLMKathy Gomze2004-01-22UHC-29714-2044446977914910 Hillcrest Rd Apt 4, Minneapolis, MN, 554020.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-415031CLMAndrew Garza1959-11-02UHC-05082-55—6156 Lincoln Way, Orlando, FL, 328880.66Date of birth reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-425118CLMAlice Morrison1965-01-13—22939689387940 Sage Ct, San Antonio, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-403133CLMJose Richardson1960-08-27UHC-61622-1160461867089388 Cedar Ln, Nashville, TN, 372750.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430823CLMRoy Coleman1950-10-13—22133935728107 Camelback Rd, Phoenix, AZ, 850400.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-409412CLMKathleen X Watson1958-07-27UHC-89150-20—2694 Maple Ave Apt 11, Dallas, TX, 752040.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-425506CLMRoger H Hawkins1973-01-24UHC-17742-30—7741 Central Ave, Phoenix, AZ, 850040.66Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more
CLM-431644CLMBrian E Burke1969-10-08UHC-98758-7572275418401203 Church St, San Diego, CA, 921960.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-416069CLMRachel Coleman1981-12-28UHC-96750-71660953506793 Ocean Ave, Jacksonville, FL, 322620.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-423857CLMJacob Turner1993-10-01——5366 Church St, Nashville, TN, 372340.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-417911CLMChristina D Hernandez1977-03-26——3872 Indian School Rd, Atlanta, GA, 303740.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-429010CLMAndrea Powell1943-09-24—70450517007729 Ocean Ave, Dallas, TX, 752670.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
32,829 rows, page 192 of 657PreviousNext