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-421897CLMMartha Watson1963-10-20——3899 Spring St # 106, Seattle, WA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-416648CLMChristine Simpson1943-05-14——5125 Hillcrest Rd Apt 22, Phoenix, AZ, 850920.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419260CLMSteve Grant1948-05-25——2957 Desert Sky Blvd Apt 30, Las Vegas, NV, 891170.52Date of birth reformattedUnit split from streetState name converted to codeGender normalised+2 more
CLM-419259CLMSteve Grant1948-05-25——2957 Desert Sky Blvd Apt 30, Las Vegas, NV, 891170.52Date of birth reformattedUnit split from streetState name converted to codeGender normalised+2 more
CLM-412291CLMVirginia F Ross1999-07-13UHC-44106-88—6241 Main St, Orlando, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-412290CLMVirginia F Ross1999-07-13UHC-44106-88—6241 Main St, Orlando, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-406251CLMHarold Fisher1962-04-25UHC-14995-60—2037 Lake View Rd Apt 18, Mesa, AZ, 852730.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414648CLMPhilip Shaw—UHC-81336-8494922355265551 Willow Ct Apt 26, Nashville, TN, 372430.52Name re-casedDate of birth missingPhone reformattedUnit split from street+2 more
CLM-429527CLMFrances Bryant1943-02-02——1254 Jefferson Ave, Tampa, FL, 336880.52Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-404191CLMLogan Elliott1951-02-03UHC-52877-90—3366 Harbor Blvd, Los Angeles, CA0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426984CLMLucia Ross1995-11-07UHC-91262-4120881961791906 Spring St, Charlotte, NC, 282890.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-401809CLMJoyce Carlson1956-07-15UHC-05360-87—2610 Baseline Rd, Glendale, AZ, 853270.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410602CLMPaul Bailey1947-01-06UHC-74026-83—2994 Pine Dr # 188, Las Vegas, NV, 891460.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412621CLMJean Chen1989-09-10UHC-94984-08—9310 Camelback Rd # 352, Plano, TX, 750250.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-403519CLMPemela E Thompson1981-12-15——99 Valley View Dr, Glendale, AZ0.52Name split from “Last, First”Two-digit birth yearCity re-casedZIP missing+2 more
CLM-416119CLMCamila W Walsh1960-01-13UHC-89214-0277168857682775 Harbor Blvd, Tempe, AZ0.52Name split from “Last, First”Phone reformattedZIP missingGender normalised+2 more
CLM-402641CLMAnthony Hoffman1977-01-02UHC-25832-74—7546 Main St, Mesa, AZ, 852630.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430386CLMDonna Lawson——8453023316112 Grand Ave Apt 4, Phoenix, AZ, 850300.52Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+2 more
CLM-418134CLMTeresa Parker1970-03-07——4695 Ocean Ave, Gilbert, AZ, 852350.52SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-401790CLMWalter Harris1955-10-03——7654 River Rd, Plano, TX, 750180.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-423105CLMDonald B Weaver1967-07-01——9560 Valley View Dr, Columbus, OH0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-400539CLMAustin Brooks2003-06-19UHC-83271-97—749 Maple Ave, Tempe, AZ, 852610.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-420696CLMSarah Hill1954-06-20—75350014849678 Market St, Charlotte, NC, 282810.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-419145CLMSandra D Stephens2004-05-28UHC-87125-33—6751 Elm St Apt 3, Jacksonville, FL0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419144CLMSandra D Stephens2004-05-28UHC-87125-33—6751 Elm St Apt 3, Jacksonville, FL0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-410741CLMAnna Scott1966-07-27UHC-14025-28—2964 Central Ave, Columbus, OH, 432930.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-409055CLMDanielle K Ward2003-09-25UHC-81974-47—8315 Central Ave Apt 30, Scottsdale, AZ, 852620.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-424290CLMMartha Y Patterson1991-05-22—95239053517089 River Rd, Tempe, AZ, 852390.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401697CLMStephen Jensen1981-11-03——5564 Washington St, Minneapolis, MN, 554300.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-417866CLMJacqueline Maldonado1983-10-05UHC-29559-7244876025185838 Apache Blvd, Glendale, AZ, 853000.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-402235CLMJack Jimenez1965-07-22UHC-31944-66—1751 Apache Blvd # 717, Tucson, AZ, 857250.52Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
CLM-429311CLMJessica Meyer1990-09-22UHC-76285-11—2783 Union St, Glendale, AZ0.52Name re-casedDate of birth reformattedState name converted to codeZIP missing+2 more
CLM-423854CLMLawrence Braynt1966-11-21UHC-35899-6061644980977082 Central Ave, Austin, TX, 787840.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-406088CLMLinda V Fields—UHC-49146-78—1120 Pine Dr, Phoenix, AZ, 850810.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420712CLMDennis N Ray1961-07-12——959 Sunset Blvd, Atlanta, GA, 303680.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-423780CLMGloria Miller1950-12-10——58 Forest Ave, Plano, TX, 750230.52Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+2 more
CLM-432086CLMArthur Wilson———8847 Ridge Rd, Chandler, AZ, 852840.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-416912CLMJesse Mendez1971-07-20——7000 Mesa Dr, Chandler, AZ, 852860.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-427075CLMJack Jordna1957-07-13UHC-50049-2441729643006754 Canyon Rd, Columbus, OH, 432780.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426573CLMTerry A Butlr2008-10-10UHC-98914-4125866415755887 Jefferson Ave Apt 16, Plano, TX, 750410.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-407504CLMJulie Lee1985-06-28—96248479557238 Main St # 929, Tucson, AZ0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-425930CLMDanel Snyder1965-05-24—55367407872733 Grand Ave Apt 21, Minneapolis, MN, 554740.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418129CLMAmber Cox1970-12-21UHC-11328-7641279572442746 Park Pl, Glendale, AZ0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421837CLMBilly Griffin1963-04-04UHC-50393-25—4415 Union St, Las Vegas, NV, 891200.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428014CLMTerry Z Perkins1970-06-03—85334857109150 Hillcrest Rd, Los Angeles, CA, 900550.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414091CLMNatalie Collins1957-07-26UHC-61521-4048563654138209 River Rd, Las Vegas, NV0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414595CLMDiego Castillo1949-12-03UHC-99368-8580979570305556 Central Ave, Columbus, OH, 432850.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413806CLMWillie Robinson1967-08-05——5548 Valley View Dr, Jacksonville, FL, 322950.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-429098CLMEmily Ramirez1959-12-05——2364 Broadway, Tempe, AZ, 852940.52Two-digit birth yearAddress re-casedState name converted to codeGender normalised+2 more
CLM-415935CLMBen I Dunn1962-04-25—75073491603300 Oak St, Eden Prairie, MN, 553190.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 44 of 657PreviousNext