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-423913CLMDaniel Patel1969-08-22UHC-04245-37—4679 Bayshore Dr, Chandler, AZ, 852670.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408590CLMGeorge Patterson1983-02-09——5376 Central Ave, San Antonio, TX, 782050.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-402698CLMCarl George1959-08-09UHC-98825-709338891224—0.64Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+2 more
CLM-402699CLMCarl George1959-08-09UHC-98825-709338891224—0.64Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+2 more
CLM-428738CLMDonald B Tran1952-02-13UHC-50361-26—3981 Maple Ave, Tampa, FL, 336510.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-429168CLMLaura Franklni1946-02-10UHC-32182-41—9718 Camelback Rd Apt 11, Phoenix, AZ, 850170.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-412544CLMShirley Ryan1986-10-27—62834900144300 Grand Ave, Tempe, AZ, 852430.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405593CLMCatherine Morrison2008-01-27——4880 Ocean Ave, Charlotte, NC0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-400869CLMFrances O Bennett1993-09-12—95856750633911 Jefferson Ave, San Diego, CA, 921170.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411771CLMNatalie Fernandez1950-09-17UHC-41735-10—9140 Bayshore Dr, Nashville, TN, 372200.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429433CLMJack Smith———742 Bayshore Dr, Las Vegas, NV, 891890.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-410512CLMBrandon Sandoval1947-03-07—34759816005758 Baseline Rd, Minneapolis, MN, 554920.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426752CLMRaymond Vargas1949-03-02UHC-85125-76—5047 Spring St, Charlotte, NC0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-407084CLMBryan Carter1973-11-26——2538 Valley View Dr, Austin, TX, 787200.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-401204CLMKatherine Carpenter1949-04-23——4824 Lake View Rd, Plano, TX, 750460.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-402271CLMKatherine Y Marquez1976-01-17UHC-21181-7092363907786413 Grand Ave, Columbus, OH0.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-406306CLMJudith Jacobs1941-10-18UHC-48697-92—5550 Lake View Rd, Gilbert, AZ0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-406305CLMJudith Jacobs1941-10-18UHC-48697-92—5550 Lake View Rd, Gilbert, AZ0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-408394CLMVincent Moreno1975-02-13UHC-16686-4090197442889606 Pine Dr, Jacksonville, FL, 322780.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-417318CLMGeorge C Mejia1981-02-28UHC-53320-70—6007 Lake View Rd, Dallas, TX, 752570.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-402134CLMLori Mejia1955-11-11——8436 Palm Dr, Tempe, AZ, 852510.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408348CLMStehen Reyes1960-07-03—66677248356423 Harbor Blvd, Mesa, AZ, 852690.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-418142CLMAlexis Ortega1967-10-25—57294788178143 Palm Dr, San Diego, CA, 921520.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429464CLMGeorge F Walker2006-09-14UHC-22901-2487294236054176 Washington St, Sacramento, CA, 958640.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430972CLMEdard Dominguez1964-02-08UHC-10224-04—4760 Mesa Dr # 841, Sacramento, CA, 958240.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414736CLMJohnny Hicks1949-02-26UHC-08693-714809016447582 Ocean Ave, Austin, TX, 787370.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400349CLMBruce Herny2001-02-18UHC-59684-259738491510415 Palm Dr, Nashville, TN, 372020.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418812CLMPhilip Scott1943-05-13UHC-89601-27—6752 River Rd, Tempe, AZ, 852400.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421600CLMShirley C Gilbert1982-10-02UHC-05399-64—8549 Lake View Rd, Minneapolis, MN, 554080.64Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415782CLMDoris Hunter1972-11-04UHC-71005-52—8898 Cedar Ln, Atlanta, GA, 303760.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411759CLMJacquleine D Soto1959-08-05UHC-59864-67—5178 Camelback Rd, Sacramento, CA0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-428578CLMTyler P Gray1939-10-16UHC-05293-42—1504 Bayshore Dr, Jacksonville, FL, 322160.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419993CLMBetty Johnston2007-07-24UHC-34962-06—5310 Maple Ave, Atlanta, GA, 303680.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-408354CLMAhmed Spencer1994-06-20—4925245904317 Park Pl, Mesa, AZ, 852440.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-410800CLMAmy Baer1941-03-15UHC-09542-0324756121911815 Oak St, Atlanta, GA, 303310.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432677CLMRachel Espinoza1979-08-22—29980875627895 Park Pl, Gilbert, AZ, 852190.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407516CLMLawrence Maldonado1994-07-20UHC-97544-20—7498 Main St, Glendale, AZ0.64Name re-casedDate of birth reformattedZIP missingGender normalised+2 more
CLM-405420CLMMaria Ramirez1999-04-23——1102 Market St Apt 29, Los Angeles, CA, 900370.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414840CLMElijah Ferguson1965-08-27UHC-23904-1682881594431718 River Rd, Fresno, CA, 937920.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411877CLMTheresa Cruz1962-06-06—80779733928152 Camelback Rd, Jacksonville, FL, 322800.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-428307CLMJerry Perkins—UHC-63351-4380975552629878 Desert Sky Blvd, Atlanta, GA, 303800.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-404363CLMMarilyn Willis1997-06-15UHC-30752-12—8924 Grand Ave, Atlanta, GA, 303340.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-432470CLMKylle Medna1968-11-28UHC-64058-26—2454 Canyon Rd, Dallas, TX, 752460.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430033CLMKeith Rogers1963-04-17—90161887784996 Palm Dr # 286, Jacksonville, FL, 322830.64Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
CLM-425406CLMLauren Franklin1961-08-23—64539198632015 Lake View Rd, Jacksonville, FL, 322030.64Name re-casedCity re-casedState name converted to codeGender normalised+2 more
CLM-424301CLMJordan Wood1979-07-09UHC-90845-16—289 Lake View Rd, Seattle, WA, 981080.64Street suffix standardisedAddress re-casedGender normalisedPlan code upper-cased+2 more
CLM-404896CLMWayne N Weaver1954-08-08UHC-84816-2128493445698045 Main St, Austin, TX, 787100.64Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415486CLMGeorge W Morrison1993-02-26——8726 Maple Ave, Plano, TX, 750410.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-401727CLMDavid Elliott1994-06-10UHC-64957-1688877048198120 Spring St, Mesa, AZ, 852010.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422443CLMEmma B Silva1977-06-11UHC-22819-36—6272 Church St, Plano, TX0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
32,829 rows, page 107 of 657PreviousNext