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-432108CLMAndrew Jacobs1990-12-11——5166 Highland Ave # 228, Austin, TX, 787200.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413062CLMCarlos W Myers1958-01-13UHC-75972-296616616502302 Bayshore Dr, Las Vegas, NV, 891010.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-428556CLM—Junk1949-05-17—62784739681303 Ocean Ave, Fresno, CA, 937930.50Date of birth reformattedPhone reformattedState name converted to codeGender normalised+3 more
CLM-418911CLMCamila Kelley1964-06-15—33287153883227 Desert Sky Blvd Apt 22, Miami, FL, 331820.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-422579CLMGerge Z Flores1959-01-16UHC-44693-88—8251 Pine Dr, Jacksonville, FL, 322800.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
CLM-426707CLMGregory Palmer1975-11-04——7816 Apache Blvd # 727, Chandler, AZ, 852090.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412719CLMCarlos Hunt1971-12-18UHC-24311-47—1181 Desert Sky Blvd, San Diego, CA, 921180.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-414593CLMKaylla N Mendez1963-06-14UHC-45096-59—3449 Forest Ave, Plano, TX0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-422597CLMKimberly Green1987-09-27UHC-75762-9082233950111921 Hillcrest Rd, Orlando, FL, 328230.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423619CLMDiane Ramos1951-10-02UHC-44594-976556412449131 Willow Ct, Glendale, AZ, 853500.50Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-402422CLMLauren Carroll1963-12-24UHC-72475-9886671074302829 Lake View Rd, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-409335CLMScottJunk1954-07-22UHC-89192-2237049541479154 Cedar Ln, Seattle, WA, 981020.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421723CLMDebra Holmes2003-01-12UHC-55286-16—6762 River Rd, Eden Prairie, MN, 553260.50Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-418881CLMAnnna Ward1958-06-16—60142151321243 Oak St, Minneapolis, MN, 554930.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420041CLMVirginia Wilson1999-05-18UHC-88267-97—7763 Oak St # 570, San Antonio, TX, 782680.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-425780CLMAlbert Sanders1975-04-25UHC-20970-55—7144 Market St, Las Vegas, NV, 891140.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403478CLMSharon Byod1957-07-20UHC-93216-37—4822 Camelback Rd, Minneapolis, MN, 554710.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-406314CLMCheryl Grant1948-07-19UHC-37922-3982071450047726 Broadway Apt 18, Gilbert, AZ, 852140.50Name split from “Last, First”Date of birth reformattedUnit split from streetAddress re-cased+3 more
CLM-424281CLMAdam Taylor1958-11-06UHC-10122-04—5074 Ocean Ave, Scottsdale, AZ, 852520.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-406138CLMDiana Berry1978-03-11UHC-53245-5368165813248859 Spring St Apt 30, Miami, FL, 331970.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-407248CLMGrace Hayes—UHC-70367-18—4935 Apache Blvd # 663, Orlando, FL, 328040.50Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+3 more
CLM-405716CLMFrances Davsi2002-03-11UHC-96294-82—6445 Washington St, San Antonio, TX, 782360.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432357CLMJose Banks1997-11-05UHC-92182-66—5571 Main St, Dallas, TX, 752750.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427524CLMJudy Price1995-04-04—71654026353123 Palm Dr, Las Vegas, NV, 891470.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413352CLMSarah M Kennedy1998-07-05——5026 Hillcrest Rd, Mesa, AZ, 852860.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-421804CLMNatalie Mason1992-08-24UHC-07376-13—3166 Market St, Las Vegas, NV, 891790.50Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+3 more
CLM-423932CLMSara I Wallace1992-04-20UHC-78913-2894076144541117 Baseline Rd, Tempe, AZ, 852020.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-427632CLMAlan Evans1941-03-07UHC-27793-94—7622 Washington St # 140, Sacramento, CA, 958270.50Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+3 more
CLM-402856CLMRobert Contreras2000-04-08UHC-89869-73—4976 Harbor Blvd, Las Vegas, NV0.50Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-414782CLMAbigail Schultz2005-12-14UHC-61086-64—2337 River Rd Apt 27, Chandler, AZ, 852320.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-428436CLMShirey Gordon1945-10-15UHC-16318-59—734 Park Pl, Los Angeles, CA, 900820.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421838CLMZachary Robertson1963-06-17—33658819479048 Jefferson Ave, Tucson, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-419124CLMRay Soto1970-08-18——9722 Spring St Apt 12, Tucson, AZ0.50Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-427556CLMKimberly Wuod1985-10-03UHC-47559-10—6099 Cedar Ln, Tucson, AZ, 857080.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-413867CLM—Junk1986-06-11UHC-27818-1691880994949669 Mountain View Dr, Scottsdale, AZ0.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419251CLMAndrea F King1960-01-13UHC-14938-2232872669452238 Sage Ct # 246, San Antonio, TX, 782130.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-419010CLMJack Mills1971-05-18UHC-22367-74—9097 Pine Dr, Dallas, TX, 752760.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422554CLMFrances Long1959-08-23——3267 Park Pl, Tucson, AZ, 857630.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-400164CLMCharlotte Wheeler—UHC-02876-57—8961 Park Pl, Sacramento, CA, 958440.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-420741CLMCarl Banks1980-11-20UHC-01367-28—6504 Mountain View Dr, Minneapolis, MN, 554670.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419611CLMLogan Miller1959-06-03UHC-02605-09—4889 River Rd, Miami, FL, 331610.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-407527CLMAlice Yang1997-02-18UHC-22171-25—3250 Forest Ave, Sacramento, CA0.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-422418CLMChristian Little1980-06-27UHC-28282-07—5811 Church St, Orlando, FL0.50Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+3 more
CLM-406319CLMAlexis Wheeler1957-05-26UHC-74384-5836397242976355 Highland Ave, Orlando, FL, 328900.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-413838CLMDylan Rivera1988-12-22UHC-21374-4035286397052045 Meadow Ln, Glendale, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426548CLMAmanda Hill2001-08-08UHC-75623-6493280614066405 Desert Sky Blvd, Charlotte, NC0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-421487CLMVictoria Vasquez1951-10-26UHC-89929-68—6241 Market St, Orlando, FL, 328790.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417759CLMStephen Guerrero1966-09-27UHC-23579-5565628493001690 Union St, San Diego, CA, 921920.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408370CLMMason Maldonado—UHC-54625-23—1570 Union St, Tampa, FL, 336040.50Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+3 more
CLM-402221CLMKim Crawford1995-10-25——3927 Ocean Ave Apt 12, Dallas, TX, 752180.50Name re-casedTwo-digit birth yearUnit split from streetCity re-cased+3 more
32,829 rows, page 25 of 657PreviousNext