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-412991CLMJason Lopez1994-12-09UHC-54594-32—5705 Desert Sky Blvd, Minneapolis, MN, 554590.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-429735CLMJose Lynch1976-07-03UHC-32183-5933050129551938 Harbor Blvd, Glendale, AZ, 853300.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-426050CLMSarah E Carlson1943-02-20—68761159759655 River Rd, Gilbert, AZ, 852750.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-432002CLMMaark Johnson1938-08-27—66265388323509 Main St, Fresno, CA, 937750.66Name split from “Last, First”City re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-432030CLMMatthew Banks—UHC-11963-65—8415 Desert Sky Blvd, Seattle, WA, 981980.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-400622CLMDiane Hart2008-02-04UHC-90073-96—7848 Ridge Rd, Miami, FL, 331590.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-411131CLMLisa Black1961-12-27UHC-50463-40—5705 Lincoln Way, Austin, TX, 787530.66Date of birth reformattedMember ID reformattedSSN last four extractedState name converted to code+1 more
CLM-424982CLMOlivia King1954-02-21UHC-33741-51—6000 Cedar Ln # 653, Scottsdale, AZ, 852810.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-407238CLMGerald E Pierce1996-11-14——1752 Lake View Rd, Phoenix, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-423136CLMSteven Gordon1941-01-06UHC-13949-6740346591664531 Broadway, Seattle, WA, 981870.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
CLM-407061CLMChristopher Duncan2003-06-26UHC-75482-87—5806 Oak St, Dallas, TX, 752230.66Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+1 more
CLM-400865CLMYuki V Knight1961-10-06——4572 Harbor Blvd, Tucson, AZ, 857770.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407532CLMRoger White1948-08-05UHC-38078-4533745702521413 Meadow Ln, Miami, FL, 331350.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430042CLMBlly Medina1980-05-23UHC-03106-77—2742 Church St # 462, Jacksonville, FL, 322930.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-424999CLMGlooria Contreras1961-05-03UHC-42648-27—3733 Valley View Dr, Seattle, WA, 981560.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431913CLMMichelle P Gutierrez1964-12-17—8915690539118 River Rd, Mesa, AZ, 852540.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-415131CLMMadison M Cole1952-05-22UHC-18386-41—2211 Central Ave, Plano, TX, 750050.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415130CLMMadison M Cole1952-05-22UHC-18386-41—2211 Central Ave, Plano, TX, 750050.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-401560CLMJessica Elliis1963-07-27UHC-59698-55—1791 Palm Dr, Atlanta, GA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-426908CLMFrakn Garcia1940-07-01UHC-99822-5173675143899059 Market St # 371, Denver, CO0.66Phone reformattedUnit split from streetZIP missingWhitespace trimmed+1 more
CLM-401584CLMWayne Santiago1999-03-04—64743401871288 Highland Ave, Charlotte, NC, 282530.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425715CLMTeresa H Fishher1959-04-26UHC-20504-8153576863085150 Main St, Scottsdale, AZ, 852990.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-419296CLMIsabella H Walsh1979-06-04UHC-12076-16—8165 Camelback Rd, Orlando, FL, 328270.66Two-digit birth yearMember ID reformattedCity re-casedZIP+4 trimmed+1 more
CLM-405616CLMLauren Q Hawkins1983-10-25UHC-71458-08—6596 Elm St, Denver, CO, 802980.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-414834CLMMary Clark2004-05-11UHC-63821-243718954354343 Broadway, Los Angeles, CA, 900350.66Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+1 more
CLM-411916CLMNathan W Robertson1995-01-26UHC-43232-11—1798 Desert Sky Blvd, Fresno, CA, 937440.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-423920CLMRalph Burke1945-09-14——7792 Lake View Rd, Denver, CO, 802620.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402509CLMOlivia Vasquez1939-01-14——8259 Ocean Ave, Las Vegas, NV, 891560.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-409577CLMKathryn Guzman1939-11-14—3979915488200 River Rd, Scottsdale, AZ, 852600.66Name re-casedDate of birth reformattedZIP+4 trimmedGender normalised+1 more
CLM-404521CLMKathryn Perez1986-11-13UHC-05255-47—1011 Indian School Rd, Seattle, WA, 981170.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404688CLMAshley Bowman1978-06-17UHC-45993-85—6982 Mountain View Dr, Glendale, AZ, 853710.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-430637CLMDiego Fernandez1977-01-18UHC-16388-50—3175 Sunset Blvd Apt 9, Eden Prairie, MN, 553550.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-410788CLMDeborah McDonald————0.66Name re-casedDate of birth missingGender normalisedPlan code upper-cased+1 more
CLM-414956CLMAndrea Holmes1945-11-07UHC-14059-4647948714954112 Sage Ct, Dallas, TX, 752210.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-418544CLMJerry Greeen—UHC-67734-23—9486 Baseline Rd, Eden Prairie, MN, 553200.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-432385CLMStephen O Harris2001-01-28UHC-18624-69—6491 Grand Ave, Plano, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-423232CLMVirginia Barnes2007-04-02UHC-21509-5638278172156404 Sage Ct, Atlanta, GA0.66Name re-casedPhone reformattedZIP missingGender normalised+1 more
CLM-415711CLMGeorge Weaver1982-06-25UHC-02449-5543843784631304 Bayshore Dr, Nashville, TN, 372810.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-400159CLMScott Ortega1964-08-05UHC-63453-39—7581 Ocean Ave, Tempe, AZ, 852950.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-414328CLMGregory Peters1955-04-11UHC-87115-20—2462 Oak St, Dallas, TX, 752000.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-424842CLMJohn Bll1957-01-01UHC-95187-29—8461 Union St, Los Angeles, CA, 900400.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-421955CLMHannahJunk1957-11-20UHC-14893-54—2563 Forest Ave, Charlotte, NC, 282770.66Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
CLM-423496CLMYuki Harris1950-10-26UHC-23626-3983892770183874 Sage Ct, Austin, TX, 787200.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-403619CLMBrandon Lopez1955-02-03UHC-50184-1532931678664254 Desert Sky Blvd, Seattle, WA, 981670.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415114CLMCharles Hill1994-12-10UHC-05062-59—7232 Grand Ave Apt 22, Denver, CO, 802390.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412843CLMJerry Romero1964-03-24UHC-98312-992679081891855 Lake View Rd, Tucson, AZ, 857860.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-425372CLMBilly Welch—UHC-56313-40—1708 Hillcrest Rd, Eden Prairie, MN, 553090.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419865CLMSamuel Marquez1995-12-04UHC-23159-56—927 Church St, Phoenix, AZ, 850930.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-423944CLMMichelle Martin1980-04-09UHC-00811-86—4748 Central Ave, Jacksonville, FL, 322630.66Name re-casedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-416185CLMLaura F Little1991-07-09UHC-22772-24—5722 Grand Ave # 516, Las Vegas, NV, 891460.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
32,829 rows, page 182 of 657PreviousNext