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-419394CLMCarl L Castro1997-08-13UHC-13801-40—7830 Willow Ct, Eden Prairie, MN0.66Name re-casedTwo-digit birth yearZIP missingWhitespace trimmed+1 more
CLM-409526CLMElizabeth Greene——2412458741—0.66Name split from “Last, First”Date of birth unreadablePhone reformattedWhitespace trimmed+1 more
CLM-421033CLMBradley Lane1938-01-06UHC-88564-99—9269 Valley View Dr # 707, Sacramento, CA, 958180.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-406144CLMJacqueline U Payne1952-08-12UHC-77839-17—8478 Sunset Blvd, Plano, TX, 750910.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-416357CLMBrittany N Sandoval1986-09-12UHC-58967-6656930494707061 Bayshore Dr, Chandler, AZ0.66Two-digit birth yearPhone reformattedZIP missingWhitespace trimmed+1 more
CLM-403979CLMTimothy Arnold1957-04-13—77198716227089 Mesa Dr Apt 37, Charlotte, NC, 282270.66Name re-casedPhone reformattedUnit split from streetGender normalised+1 more
CLM-405438CLMYuki Adams1962-03-16UHC-26446-1663261229451250 Desert Sky Blvd, Seattle, WA, 981670.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-402371CLMDebra Ray1981-11-28——2737 Meadow Ln, Miami, FL, 331230.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411534CLMMariana Alvarez1951-04-01UHC-81390-02—8423 Desert Sky Blvd, Eden Prairie, MN, 553350.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-411383CLMBrandon Vazquez1956-10-03UHC-22701-62—2328 Elm St, Austin, TX, 787890.66Name split from “Last, First”Member ID reformattedState name converted to codeWhitespace trimmed+1 more
CLM-423819CLMNiccholas Gonzalez———6958 Lincoln Way, Los Angeles, CA, 900540.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-420692CLMJuan F Gonzales1984-09-23UHC-95700-66—6894 Ocean Ave Apt 10, San Diego, CA, 921740.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-423294CLMAdam Wood1941-01-05—79552358808490 Highland Ave, Charlotte, NC, 282510.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-402887CLMMark Cole1958-09-01——9515 Sunset Blvd, Nashville, TN, 372860.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-416850CLMBradley Morrison1992-01-12——6520 Lake View Rd, Columbus, OH, 432630.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-401603CLMCynthia Ryan1992-07-22UHC-40295-5651222497704288 Union St, Minneapolis, MN, 554570.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
CLM-429727CLMMarcus R Luna1955-03-12UHC-01356-25—6306 Spring St, Nashville, TN, 372050.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425800CLMScott Ward2005-02-15——6132 Mesa Dr # 570, Sacramento, CA, 958770.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-414165CLMJessica Wang2003-01-20UHC-04085-61——0.66Name split from “Last, First”Date of birth reformattedMember ID reformattedGender normalised+1 more
CLM-431930CLMBrenda Salazar1989-06-02UHC-15544-04——0.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-417855CLMJoan Kennedy1999-02-03UHC-90448-89—1032 Highland Ave, Minneapolis, MN, 554780.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-418061CLMDorothy Austin1949-11-11——8657 Oak St, Los Angeles, CA, 900680.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-414346CLMWilliam F Parker1968-06-08UHC-63319-50—6710 Maple Ave, Mesa, AZ, 852200.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-421377CLMDylan L Bowman1984-06-22UHC-70202-7643869764322383 Cedar Ln, Jacksonville, FL, 322370.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-404763CLMRobert B Perkins1968-11-24UHC-38217-24—7520 Ocean Ave, Jacksonville, FL, 322400.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-404618CLMChristopher Mendez1967-07-10UHC-51704-1277092344232371 Union St, Gilbert, AZ, 852810.66Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+1 more
CLM-431860CLMRandy Z Ross1940-01-07—3174487162728 Spring St Apt 28, Orlando, FL, 328930.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-404442CLMGregory Ward1981-01-22UHC-42600-614227143570886 Bayshore Dr Apt 31, Miami, FL, 331590.66Unit split from streetState name converted to codePlan code upper-casedWhitespace trimmed+1 more
CLM-421438CLMPeter R Ferguson1948-03-25——1560 Central Ave, Houston, TX, 770660.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-424235CLMKayyla Perry——54255253523327 Sage Ct, Nashville, TN, 372560.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-400746CLMArthur W Stephens1950-02-25—93361062828084 Union St, Orlando, FL, 328880.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-425495CLMChristopher Graham1969-02-07UHC-23280-1370666175985309 Ridge Rd, Gilbert, AZ, 852930.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-417762CLMStephen P Salazar1991-08-14UHC-65375-07—723 Baseline Rd, Atlanta, GA, 303970.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-412881CLMDonna Morgan1989-05-05UHC-37714-6946234907618237 Central Ave, Dallas, TX, 752160.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-414860CLMNancy C Rojas1999-06-09——6782 Pine Dr, Houston, TX, 770650.66Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more
CLM-414932CLMEric Valdez1939-11-25UHC-86362-9891263758459341 Broadway # 456, Eden Prairie, MN, 553750.66Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+1 more
CLM-415399CLMDiana Hughes1975-03-01UHC-99954-4958965035158291 Palm Dr, Dallas, TX, 752540.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-431059CLMJon Hunt1991-05-28—2338932043—0.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
CLM-402329CLMHenry Porter1953-10-23UHC-33730-64—5566 Desert Sky Blvd, Columbus, OH, 432340.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-428148CLMMei Clark1987-03-09UHC-15546-20—4102 Sunset Blvd, Glendale, AZ, 853290.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-412971CLMStephanie X Chavez1946-04-09UHC-88000-54—5606 Cedar Ln, Fresno, CA, 937290.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-416428CLMRalph Dunn2001-10-20——8136 Union St # 920, Eden Prairie, MN, 553080.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-431155CLMChristopher Meyer1997-06-28UHC-42589-195812426596—0.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
CLM-426708CLMSophia Mills1991-10-20UHC-74721-5722721224501708 Union St Apt 13, Los Angeles, CA, 900850.66Name split from “Last, First”Unit split from streetCity re-casedWhitespace trimmed+1 more
CLM-427877CLMSam Cruz1999-11-24UHC-37990-5787031498754590 Bayshore Dr, Columbus, OH, 432500.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-403887CLMGabriel Fisher——33354232183157 Baseline Rd, Chandler, AZ, 852830.66Name re-casedDate of birth missingPhone reformattedState name converted to code+1 more
CLM-420793CLMDiane Lewis2003-08-05UHC-27291-777765354065566 Baseline Rd # 329, Atlanta, GA, 303280.66Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+1 more
CLM-419986CLMPhilip Williamson1938-07-04—77836010324650 Elm St, Chandler, AZ, 852550.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-405161CLMGeorge Franklin1964-06-09UHC-98768-4758736849564658 Indian School Rd, San Diego, CA0.66Two-digit birth yearPhone reformattedZIP missingWhitespace trimmed+1 more
CLM-406691CLMSofia Greene1976-05-20UHC-16642-1967369530716125 Apache Blvd, Denver, CO0.66Member ID reformattedZIP missingGender normalisedWhitespace trimmed+1 more
32,829 rows, page 179 of 657PreviousNext