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-425875CLMKayla X Aguilar1976-03-22UHC-82478-7129236054116304 Indian School Rd, Minneapolis, MN, 554090.66Middle initial moved out of first namePhone reformattedState name converted to codeWhitespace trimmed+1 more
CLM-425384CLMJoan Santos1978-01-04—53354372949445 Park Pl, Scottsdale, AZ, 852160.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-419367CLMTyler Obrien1961-04-24UHC-95482-3186953925321107 Pine Dr, Orlando, FL, 328280.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-430608CLMMateo Patel1961-03-05UHC-36080-99—8109 Canyon Rd, San Antonio, TX, 782530.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-413211CLMAna Boyd1955-12-23UHC-37481-6354155059768426 Central Ave, Mesa, AZ, 852950.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-413661CLMDaniel Sanchez2004-03-03UHC-64552-91—6681 Lake View Rd, Austin, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-417763CLMMasno Rose1948-06-12——1468 Central Ave, Phoenix, AZ, 850210.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-401205CLMKatherine Carpenter1949-04-23UHC-20620-5967068394294824 Lake View Rd, Plano, TX, 750460.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-429665CLMNicholas Sanchez2008-03-10——571 Canyon Rd, Tucson, AZ, 857280.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-424385CLMOmar Perez—UHC-67246-08—5497 Canyon Rd, Las Vegas, NV, 891460.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-428662CLMAdam Hicks1979-05-03UHC-61952-26—5348 Mountain View Dr, Denver, CO, 802820.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425739CLMLuis Dominguez1955-05-24—393796872542 Washington St, Los Angeles, CA, 900340.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-430916CLMJustin Le1977-05-22UHC-43468-0447992296621662 Market St, Phoenix, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-429067CLMMaria Park1966-12-14UHC-61009-6030848395884421 Mountain View Dr, Nashville, TN, 372710.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-406146CLMJoyce Griffin1968-07-25——6425 Ocean Ave, Tampa, FL, 336760.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422687CLMHeather P Cook1973-01-10——6040 Mountain View Dr, Tampa, FL, 336720.66Name re-casedTwo-digit birth yearState name converted to codeWhitespace trimmed+1 more
CLM-411697CLMJean G Oliver1943-02-20UHC-69298-44—6181 Sunset Blvd, Nashville, TN0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-423494CLMRachel Carr1969-09-16UHC-98318-41—6128 Central Ave, Seattle, WA, 981650.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421564CLMJulie M Singh1975-08-19UHC-47477-3482579441274749 Maple Ave, Fresno, CA, 937210.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-416261CLMHeather Burton2002-06-15UHC-68676-398534239768308 Central Ave, Miami, FL, 331130.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
CLM-408775CLMGary Jimenez1976-03-26——4951 Jefferson Ave, Tampa, FL0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-414394CLMJackkie Spencer1958-06-24UHC-18603-5949724763861667 Camelback Rd, Tampa, FL0.66Name re-casedPhone reformattedState name converted to codeZIP missing+1 more
CLM-400606CLMMarcus Hall1947-12-15UHC-89525-68——0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-430926CLMPatricia P King1967-06-23UHC-26700-94—3113 River Rd, Orlando, FL, 328410.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-419235CLMElizabeth Dunn2007-08-01—72670373369639 Bayshore Dr, Austin, TX0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-422363CLMMary Bennett1992-08-27UHC-46137-46—9251 Sunset Blvd, Atlanta, GA, 303540.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-405839CLMRuth Stephens1956-11-26UHC-49733-39—3218 Grand Ave, Denver, CO, 802920.66Two-digit birth yearCity re-casedState name converted to codeWhitespace trimmed+1 more
CLM-429199CLMDaniel N Alexander1961-03-27——100 Oak St, Nashville, TN, 372280.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407095CLMAhmed Ortiz1963-02-05——210 Maple Ave, San Antonio, TX, 782450.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-417679CLMJanice Marquez1938-09-08UHC-17144-8065097373728672 Cedar Ln, Chandler, AZ, 852530.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-413274CLMJoe Peters1999-06-14UHC-86752-6222358465596645 Palm Dr, Los Angeles, CA, 900800.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-413985CLMRaymond Gilbert1995-07-08UHC-47520-61—6778 Sage Ct, Plano, TX, 750540.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-431591CLMEthan V Kim1972-01-09——3734 Grand Ave, Gilbert, AZ, 852130.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-422679CLMKathryn Berry1945-05-22UHC-89770-5488130038876986 Washington St, Houston, TX, 770520.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-408956CLMAndrea Carroll———6828 Oak St, Sacramento, CA, 958780.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-408972CLMDonald Stone1967-03-17UHC-18714-2348731121504661 Bayshore Dr, Denver, CO, 802890.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-427191CLMKayla Vazquez1948-06-13—94771326382691 Indian School Rd, Columbus, OH, 432140.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-414068CLMMaria Jordan1956-08-02UHC-38848-23—9605 Cedar Ln, Austin, TX, 787450.66Member ID reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-406607CLMNancy Andrews1983-12-26UHC-15983-34—627 Grand Ave, Glendale, AZ, 853550.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-416286CLMMei Turner1941-10-09UHC-49851-73—9888 Sunset Blvd Apt 2, Scottsdale, AZ, 852190.66Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-432673CLMAmber Griffin1939-12-09UHC-63625-5040689143676088 Desert Sky Blvd, San Diego, CA, 921930.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
CLM-426767CLMVirginia Green1963-10-26UHC-24354-6122920474998700 Sunset Blvd Apt 2, San Diego, CA, 921260.66Name re-casedPhone reformattedUnit split from streetState name converted to code+1 more
CLM-410509CLMPatrick Gutierrez1972-12-13UHC-95777-12—8668 Mesa Dr, Los Angeles, CA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-416049CLMRaymond Thomas—UHC-02723-41—7605 Harbor Blvd, Phoenix, AZ, 850070.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407386CLMKatherine James2001-09-14UHC-01774-66—6636 Highland Ave, Miami, FL, 331800.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-406163CLMTerry Berry1992-11-05UHC-47331-4865275575657774 Maple Ave, Houston, TX, 770910.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-428047CLMRoger R Arnold1998-06-21UHC-95060-50—1890 Meadow Ln, Fresno, CA, 937090.66Two-digit birth yearState code upper-casedGender normalisedWhitespace trimmed+1 more
CLM-410796CLMNancy Carroll1979-05-04UHC-31589-42—6414 Meadow Ln, Phoenix, AZ, 850910.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404037CLMJese Ryan1984-11-25UHC-71476-43—1048 Mesa Dr, Glendale, AZ, 853030.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-416388CLMRoy W Miller1990-05-01UHC-67866-0923369655215616 Ridge Rd, Chandler, AZ, 852130.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
32,829 rows, page 168 of 657PreviousNext