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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-416538CLMValentina Aguilar1943-05-19UHC-88614-93—4653 River Rd, Glendale, AZ, 853760.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-402036CLMThomas Chavze1958-01-21UHC-08205-93—6626 Market St, Miami, FL, 331990.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-411337CLMMargaret Roberts————0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-419454CLMMaria Perkins2001-09-19UHC-59431-05—7167 Mountain View Dr, Tucson, AZ, 857380.68Name re-casedStreet suffix standardisedAddress re-casedGender normalised
CLM-405990CLMJoshua B Marshall1942-02-26UHC-44961-96—8078 Canyon Rd, Mesa, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-423507CLMPeter Harper1957-04-15UHC-87117-062522107241—0.68Two-digit birth yearPhone reformattedSSN last four extractedPlaceholder values cleared
CLM-424731CLMPhilip Willis1968-02-27——8286 Bayshore Dr, Seattle, WA, 981340.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-418230CLMTeresa Crawford1958-02-21UHC-27980-16—1006 Indian School Rd, Gilbert, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-418231CLMTeresa Crawford1958-02-21UHC-27980-16—1006 Indian School Rd, Gilbert, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-414331CLMLinda Weaver2008-05-21—50027178063756 Meadow Ln, Plano, TX, 750570.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
CLM-412984CLMKathy G Dixon1989-07-28——9088 Union St, San Diego, CA, 921890.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-412985CLMKathy G Dixon1989-07-28——9088 Union St, San Diego, CA, 921890.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-412080CLMGregory T Moreno1991-02-06——2887 Apache Blvd, Fresno, CA, 937270.68Middle initial moved out of first nameStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432624CLMAlice Gibson1966-05-04——4012 Elm St, Eden Prairie, MN, 553180.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-418018CLMJennifer Santos1944-02-16——4465 Hillcrest Rd, Seattle, WA, 981300.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409267CLMHiroshi Miller1979-09-12——8858 Sage Ct, Gilbert, AZ, 852630.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-405725CLMFrank Parker1971-08-04—67179403394004 Hillcrest Rd, Chandler, AZ, 852510.68Name split from “Last, First”Phone reformattedSSN last four extractedPlaceholder values cleared
CLM-406625CLMKathleen Graham2000-12-23UHC-53630-10—8422 Union St, Fresno, CA0.68State name converted to codeZIP missingWhitespace trimmedPlaceholder values cleared
CLM-421188CLMSofia Thompson1987-07-21UHC-17637-54—4099 Willow Ct, Charlotte, NC, 282680.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-402516CLMEthan K Estrada1966-04-28UHC-68529-8929136274245007 Apache Blvd # 725, Chandler, AZ, 852290.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-405617CLMHawkins Q Lauren1983-10-25UHC-71458-08—6596 Elm St, Denver, CO, 802980.68State name converted to codeEmail lower-casedGender normalisedPlaceholder values cleared
CLM-422470CLMRussell Richards1980-02-25——3926 Maple Ave, Eden Prairie, MN, 553670.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-414162CLMMaarcus Maldonado1997-02-02——1072 Central Ave, Mesa, AZ, 852330.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-413289CLMSophia Crawford1948-04-18UHC-11418-63—3120 Oak St, Los Angeles, CA, 900630.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-401927CLMGary Huhes1977-05-24UHC-90567-68—1898 Pine Dr, Los Angeles, CA, 900000.68Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed
CLM-429691CLMAshley O Ryan1982-05-26—23598435995777 Grand Ave Apt 34, Fresno, CA, 937800.68Date of birth reformattedUnit split from streetGender normalisedPlaceholder values cleared
CLM-421275CLMJanet E Brown1939-08-23UHC-78003-20—1614 Washington St, Dallas, TX, 752880.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-428400CLMJeremy Greeen1999-09-19——638 Meadow Ln Apt 14, Gilbert, AZ, 852720.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-405840CLMRuth Stephens1956-11-26UHC-49733-39——0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-430332CLMHelen Y Murphy1940-04-15UHC-97173-05—8562 Apache Blvd, Jacksonville, FL, 322060.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-402076CLMKimberly Cunningham1943-01-17UHC-50704-33—4044 Jefferson Ave, Houston, TX, 770010.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-425763CLMTheresa Olson1996-07-03UHC-42656-48—9830 Broadway, Houston, TX, 770040.68Name split from “Last, First”SSN last four extractedAddress re-casedWhitespace trimmed
CLM-430602CLMRandy Cok1977-02-14——5729 Central Ave, San Diego, CA, 921550.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-412916CLMRobert Bradley1977-07-08UHC-63686-35—3063 Desert Sky Blvd, Fresno, CA0.68Name re-casedStreet suffix standardisedAddress re-casedZIP missing
CLM-402917CLMRoy Tucker1946-01-17UHC-34706-33—7341 Oak St Apt 15, Atlanta, GA, 303000.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-416422CLMRoger Bishop1960-11-05——2419 Park Pl, Atlanta, GA, 303790.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-403138CLMMei S Brooks1986-10-23—98697313432240 Lake View Rd, Scottsdale, AZ0.68Street suffix standardisedAddress re-casedCity re-casedZIP missing
CLM-414123CLMHenry Reynolds2002-08-03UHC-89188-189764888719698 Mountain View Dr, Dallas, TX, 752730.68Phone reformattedStreet suffix standardisedAddress re-casedGender normalised
CLM-420845CLMGary Stewart2004-07-21——4203 Apache Blvd, Plano, TX, 750760.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-405409CLMDiego Bredley1981-06-15—94059488894128 Sunset Blvd, Sacramento, CA, 958380.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-426848CLMHannah Martin—UHC-93034-52—483 Central Ave, Plano, TX, 750190.68Date of birth unreadableCity re-casedGender normalisedPlaceholder values cleared
CLM-426663CLMLarry Evans1973-09-28UHC-51691-53—6969 Harbor Blvd, Mesa, AZ, 852650.68Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased
CLM-411025CLMSara Andrews1961-11-02UHC-45537-10——0.68Name split from “Last, First”Date of birth reformattedPhone missing area codePlaceholder values cleared
CLM-401879CLMPatricia Wood1957-06-24——2526 Meadow Ln, Jacksonville, FL, 322600.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-401880CLMPatricia Wood1957-06-24——2526 Meadow Ln, Jacksonville, FL, 322600.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-413381CLMNancy Kelley1945-04-16UHC-35134-7088871281919887 Mountain View Dr, Orlando, FL, 328930.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-403203CLMAnthony Knight1973-06-22—4469839018—0.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
CLM-427395CLMJustin Ruiz1979-04-22——6445 Jefferson Ave Apt 32, Austin, TX, 787150.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-415987CLMPatrick Fisher1985-08-03——7715 Baseline Rd, Mesa, AZ, 852890.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-418509CLMSteven R Bowman1941-09-01UHC-95679-56—8216 Cedar Ln, Orlando, FL, 328990.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
32,829 rows, page 216 of 657PreviousNext