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-412578CLMJoe Ford1978-09-19UHC-43516-61—1902 Highland Ave Apt 17, Chandler, AZ, 852010.54SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-420632CLMBeverly Y Pierce1977-11-04——1374 Central Ave, Austin, TX0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-432042CLMVirginia Carlson1993-03-18UHC-04926-88—4591 Valley View Dr Apt 18, Dallas, TX, 752410.54Unit split from streetState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-404022CLMGeorge Hoffman1962-10-01UHC-52151-87—1238 Palm Dr Apt 10, Houston, TX, 770120.54Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-407722CLMRay Banks2004-07-09UHC-53680-51—2102 Central Ave, Denver, CO, 802360.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-412318CLMJohn Burke1977-07-17——126 Main St, Tempe, AZ0.54Two-digit birth yearState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-412317CLMJohn Burke1977-07-17——126 Main St, Tempe, AZ0.54Two-digit birth yearState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-412016CLMStephanieJunk1941-07-06UHC-12127-52—478 Oak St, Mesa, AZ, 852590.54Name re-casedPhone missing area codeZIP+4 trimmedPlaceholder values cleared+1 more
CLM-430428CLMSophia Welch1938-07-16UHC-08969-87—9297 Church St, San Diego, CA, 921710.54State name converted to codeZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-431046CLMChristine Sullivan2007-09-24UHC-86497-82—4856 Indian School Rd, Eden Prairie, MN, 553320.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-430640CLMCynthia Stone1942-04-06UHC-70398-69—3601 Canyon Rd, Fresno, CA, 937540.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-408274CLMNathan Olsoon1977-08-18UHC-73329-39—7553 Central Ave, Houston, TX, 770340.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-421816CLMWillie Y Allen1989-10-21UHC-31609-15—4882 Highland Ave, Denver, CO, 802910.54Name split from “Last, First”State name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-428771CLMSandra Bradley1970-05-25UHC-59697-997829315135216 Lake View Rd, Denver, CO0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-407929CLMBryan Ryan—UHC-05334-68—1607 Desert Sky Blvd, Sacramento, CA, 958580.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-403112CLMChristina Meyer1954-03-22UHC-19804-16—2100 Meadow Ln, Los Angeles, CA, 900390.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-415094CLMAbigail Berry2007-12-02——1668 Harbor Blvd, Columbus, OH, 432270.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-418869CLMDuncan Kathryn1966-07-24UHC-43519-95—8671 Forest Ave, Atlanta, GA, 303360.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-428774CLMMichael Duncan———1692 Central Ave, Charlotte, NC, 282850.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425362CLMSteven Park2007-11-17UHC-63840-34—9470 Pine Dr Apt 18, Austin, TX, 787510.54Name re-casedTwo-digit birth yearUnit split from streetZIP+4 trimmed+1 more
CLM-405048CLMTim Lopez1946-01-15UHC-58975-81—9308 Meadow Ln # 186, Nashville, TN, 372710.54Name split from “Last, First”Unit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-421559CLMGreg S Luna1953-02-15UHC-66734-89—7307 Camelback Rd, Minneapolis, MN, 554950.54Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+1 more
CLM-430167CLMWillie Chavez1952-10-12—86558015752780 Desert Sky Blvd, Plano, TX, 750960.54Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-409143CLMMaria Castillo1949-05-11UHC-29981-057092147452696 Indian School Rd, Tucson, AZ, 857110.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-425838CLMEvelyn Chavez2007-03-15UHC-98599-23—9644 River Rd, Nashville, TN, 372010.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-414026CLMBruce Bradley1978-04-08UHC-17909-89—9096 Washington St, Glendale, AZ, 853820.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-414903CLMDoris Carroll1985-10-24UHC-14268-87—5143 Indian School Rd, Dallas, TX, 752950.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-416503CLMJesse R Barnes1969-03-23UHC-14334-26—2923 Church St, Miami, FL, 331460.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-422104CLMJeff Dominguez1962-05-18UHC-23167-87—6186 Baseline Rd, Sacramento, CA, 958510.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-418575CLMKeith Hicks1951-08-22UHC-44307-53—6882 Oak St, Eden Prairie, MN0.54Name re-casedState name converted to codeZIP missingGender normalised+1 more
CLM-421768CLMPatricia Li1970-12-22UHC-70875-6328780809257272 Palm Dr, Las Vegas, NV, 891840.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-402449CLMBetsy V Freeman1945-09-03——3288 Valley View Dr, Denver, CO, 802000.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-404272CLMGary Welch1940-12-20UHC-29174-76—1042 Church St, Tampa, FL, 336210.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-412062CLMEmily Schuultz1940-12-09——8124 Park Pl, Denver, CO0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-426935CLMAshley Garza1971-09-10——6125 Park Pl, Plano, TX, 750860.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-427044CLMHiroshi Martinez1993-08-16UHC-21659-3489927145136792 Valley View Dr # 147, Fresno, CA, 937560.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-408860CLMJoan T Hoffman1968-09-13UHC-43415-86—8411 Ridge Rd, Mesa, AZ, 852750.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-423741CLMWilliam Dean1997-11-24UHC-03327-76—3731 Bayshore Dr, Miami, FL, 331940.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-403374CLMRachel Hughes1969-06-06UHC-06997-78—3782 Meadow Ln, Glendale, AZ, 853280.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-428715CLMFrances Spencer1992-07-12———0.54Two-digit birth yearPhone missing area codeGender normalisedWhitespace trimmed+1 more
CLM-405994CLMMei B White—UHC-02392-26—8916 River Rd, Jacksonville, FL, 322730.54Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-405620CLMJessica Taylor1951-02-22UHC-33596-1234489004712381 Lincoln Way # 287, Nashville, TN0.54Phone reformattedUnit split from streetZIP missingGender normalised+1 more
CLM-403892CLMBetty Willis2006-05-12UHC-26725-4394133196437434 Canyon Rd, Gilbert, AZ0.54Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-418058CLMBrittany Nnez2006-06-06UHC-13686-89—2966 Cedar Ln, Seattle, WA, 981950.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-403325CLMHelen Snyder1982-06-03UHC-87519-986307396842455 Grand Ave # 189, Jacksonville, FL, 322760.54Two-digit birth yearPhone reformattedUnit split from streetGender normalised+1 more
CLM-412933CLMCheryl K Guzman2008-10-09UHC-71613-4296771662589620 Main St Apt 28, Minneapolis, MN, 554220.54Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-418384CLMBrenda U Hernandez1996-04-12UHC-85229-30—1513 Bayshore Dr Apt 5, Seattle, WA, 981460.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-404006CLMDonna Palmer1975-06-23UHC-21096-27—7728 Market St, Eden Prairie, MN, 553930.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-401597CLMBrandon E Porter——75759763247764 Pine Dr, Miami, FL0.54Name split from “Last, First”Date of birth unreadablePhone reformattedZIP missing+1 more
CLM-407977CLMEvelyn Griffin1980-12-09UHC-10238-52—5030 Market St, Columbus, OH, 432690.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
32,829 rows, page 57 of 657PreviousNext