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-402978CLMMson Santos1964-03-21UHC-10432-64—8308 Canyon Rd # 517, Glendale, AZ, 853850.62Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-413163CLMJanice Austin1986-05-20—89392182173077 Bayshore Dr, Columbus, OH, 432200.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419407CLMMary Torres1951-03-26—23678242975562 Highland Ave, Columbus, OH, 432980.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-431213CLMSophia Daniiels—UHC-50502-80—9788 Jefferson Ave, Denver, CO, 802750.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-413738CLMBryan Ferguson1978-11-06UHC-51134-402685940852323 Lincoln Way, Tampa, FL0.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
CLM-422183CLMMarcus Lewis1981-05-06UHC-53639-0439398273892066 Main St, Atlanta, GA, 303430.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419013CLMDennis Elliott1999-11-09UHC-76269-9283239267848507 Apache Blvd, Los Angeles, CA, 900510.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432346CLMMichael A Weber1950-11-17UHC-80019-7326652011763529 Washington St, Columbus, OH, 432700.62Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
CLM-407812CLMKeith Alvarez2001-08-18—66093615586453 Indian School Rd, Charlotte, NC, 282990.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418155CLMAlan Dean1992-09-12UHC-33697-11—5224 Camelback Rd, Fresno, CA, 937070.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403324CLMHelen Snyder1982-06-03UHC-87519-98—455 Grand Ave, Jacksonville, FL, 322760.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-413398CLMSamuel Obrien2000-10-08UHC-78534-3460037059178778 Oak St, Tampa, FL, 336930.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425004CLMLucia Daniels1982-11-22UHC-83430-1622284564166113 Market St, Las Vegas, NV, 891470.62Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more
CLM-425667CLMLisa Williamson1956-04-04—88555375556819 Park Pl, San Antonio, TX, 782530.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409783CLMGrace Ray1945-11-08—96449898443885 Market St, Nashville, TN, 372950.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-414150CLMRalph Cole1964-06-11——9782 Valley View Dr, Tucson, AZ, 857780.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402716CLMKayla Wells1985-07-02UHC-51813-94—16 Forest Ave, Glendale, AZ, 853620.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411184CLMKelly Obrien1988-04-21——3449 Camelback Rd, Columbus, OH, 432660.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415921CLMDonna Weber1951-08-05—92837915703086 Sunset Blvd, Scottsdale, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418619CLMMariana Matthews1941-02-12——241 Jefferson Ave # 948, Tempe, AZ, 852770.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-431892CLMMariana Little1943-09-05UHC-08311-8351457910284453 Market St, Chandler, AZ, 852860.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426092CLMKayla Schmidt1973-12-05——7183 Sunset Blvd, Columbus, OH, 432760.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-411443CLMAshley Sandoval1970-05-09——1920 Canyon Rd, Denver, CO0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-415476CLMPaul Little1969-06-22—51395364735292 Central Ave, Atlanta, GA, 303430.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418601CLMMarilyn Mason2003-01-23UHC-06049-0925174928847190 Baseline Rd, Plano, TX, 750710.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420597CLMJennifer Griffin—UHC-36930-8074293756194234 Market St, Chandler, AZ, 852040.62Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-402811CLMBrandon Obrien1985-10-23——2492 Forest Ave, Las Vegas, NV, 891310.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-428664CLMAdam Hicks1979-05-03UHC-61952-26—5348 Mountain View Dr, Denver, CO, 802820.62Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-428663CLMAdam Hicks1979-05-03UHC-61952-26—5348 Mountain View Dr, Denver, CO, 802820.62Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-407619CLMTimothy Kim1949-12-24——5736 Grand Ave, San Antonio, TX, 782140.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422375CLMCarlos Rios1975-03-10UHC-99107-8349641298458347 Pine Dr, Glendale, AZ, 853910.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429816CLMJacob Gomez1976-07-10UHC-45306-7125323750446461 Valley View Dr, Atlanta, GA, 303800.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412242CLMVictoria Ross1978-06-16UHC-40023-8238068059128429 Camelback Rd, Dallas, TX, 752510.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-400902CLMAlan Johnston1988-08-13UHC-44462-0425247385871486 Central Ave, Seattle, WA, 981920.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429603CLMJack Robinson1956-12-10UHC-10590-6844792470187370 Washington St, Tempe, AZ, 852780.62Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-409376CLMLori Graham1968-06-02UHC-89319-70—4806 Palm Dr, Jacksonville, FL0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424274CLMCharles P Murraay1952-01-15UHC-35400-6667032950308544 Apache Blvd, Nashville, TN, 372080.62Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more
CLM-426736CLMRobert Harper1995-09-18UHC-35694-1562831391974989 Main St Apt 24, Chandler, AZ, 852190.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413256CLMJames Owens1980-03-02UHC-46110-3421690357696467 Camelback Rd, Plano, TX, 750860.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405140CLMRaymond Schmidt1954-07-01UHC-32279-47—8835 Valley View Dr, Jacksonville, FL, 322610.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429662CLMShirley Rojas1966-01-02UHC-61087-9170650697544695 Indian School Rd, Fresno, CA, 937600.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-429663CLMShirley Rojas1966-01-02UHC-61087-9170650697544695 Indian School Rd, Fresno, CA, 937600.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406761CLMAlexis Fernandez1944-09-25UHC-19671-7283294217194367 Valley View Dr, Scottsdale, AZ0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431011CLMMelissa Garratt1953-04-26UHC-66082-8185276667869896 Highland Ave, Glendale, AZ, 853070.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431010CLMMelissa Garratt1953-04-26UHC-66082-8185276667869896 Highland Ave, Glendale, AZ, 853070.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411069CLMBeverly S Ryan1961-02-18UHC-70614-0149772886817221 Apache Blvd, Fresno, CA, 937340.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419987CLMDenise Spenker1953-02-02UHC-47699-1864764418338865 Bayshore Dr, Los Angeles, CA, 900030.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403922CLMZachary Carlson2003-10-23UHC-05862-91—6475 Jefferson Ave, Denver, CO, 802730.62Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
CLM-416338CLMAlbert Daniels1954-05-11—69964477485558 Oak St # 547, Tampa, FL, 336810.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-414051CLMOmar Nguyen1997-06-08UHC-18431-1888025686855478 Lake View Rd Apt 2, Tampa, FL, 336210.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 101 of 657PreviousNext