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-420317CLMLori Black1953-07-21UHC-24306-3540895334364320 River Rd, Fresno, CA, 937430.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-406359CLMLucia Lynch1968-04-09UHC-33985-3956048615468941 Forest Ave, Atlanta, GA0.48Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-407564CLMMelissa Valdez1954-02-10UHC-81960-04—962 Valley View Dr, Dallas, TX, 752280.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-416814CLMLori J Cruz1990-04-25UHC-87156-17—6582 Sage Ct # 449, Eden Prairie, MN, 553870.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-427645CLMSofia Arnold1973-09-13UHC-41265-386218378889423 Market St, Sacramento, CA, 958430.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-415950CLMJuan Butler1952-03-08UHC-52359-45—4309 Willow Ct, Plano, TX0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-425528CLMScott Johnston1965-08-10UHC-34433-48—7864 Oak St, Nashville, TN, 372090.48Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-430627CLMEdward A Hunt1999-06-24—94633642192783 Bayshore Dr # 610, Atlanta, GA, 303850.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-422114CLMGloria Brooks1946-03-27——9448 Cedar Ln Apt 27, Orlando, FL, 328130.48Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-424176CLMPriya Ford1969-05-03UHC-66719-80—6295 Indian School Rd Apt 11, Denver, CO, 802560.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-405111CLMTerry Peterson1964-12-22—5813042921298 Desert Sky Blvd, Glendale, AZ0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-414510CLMSamual Guerrero2004-08-11UHC-70261-2435622211194432 Willow Ct, Plano, TX, 750400.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425206CLMPaul Porter1941-07-27UHC-28456-8424834595164240 Church St, Plano, TX, 750250.48Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-425668CLMAngela Gonzalez1964-02-05—29230595091263 Meadow Ln, Tempe, AZ0.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-425463CLMTeresa T Powell1981-09-23—82536756256134 Cedar Ln Apt 22, Orlando, FL, 328630.48Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-410493CLMMaria Silva1963-04-08—36077622404127 Church St, Denver, CO, 802490.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-421952CLMSamuel Fisher1970-06-03UHC-59857-8435865462332380 Highland Ave, Seattle, WA, 981110.48Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
CLM-405637CLMBrandon Snydre1968-12-04UHC-55662-93—8063 Pine Dr # 281, Nashville, TN, 372480.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-409705CLMBrian Reid1972-04-13UHC-22030-1827921205137920 Valley View Dr, Orlando, FL0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416946CLMRalph Montgomery———4474 Sage Ct Apt 36, Mesa, AZ, 852540.48Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+4 more
CLM-418954CLMPeter Washington1952-06-03UHC-58356-44—9079 Meadow Ln, Glendale, AZ, 853870.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431815CLMChharles Clark1989-03-17UHC-21985-1788146927708197 Mesa Dr # 112, Tempe, AZ0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-419619CLMVirginia Weaver———5687 Sage Ct, Glendale, AZ0.48Name re-casedDate of birth missingCity re-casedZIP missing+4 more
CLM-401235CLMAmanda G Sullivan1941-09-23—94649078363262 Lake View Rd, Jacksonville, FL, 322410.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-404288CLMLori Vega2002-09-02UHC-08440-55—1434 Main St, Plano, TX0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-418261CLMJonahtan H Ferguson1981-06-09—43027983284690 Forest Ave, Gilbert, AZ, 852760.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-429541CLMOmar O Boyd1939-02-16UHC-90001-1362924455015368 Lake View Rd, Tempe, AZ, 852570.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-431020CLMSarah S Dunn—UHC-26514-9825451406874136 Grand Ave Apt 5, Dallas, TX, 752680.48Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-403225CLMMichael Campbell2005-09-05UHC-94863-84—1057 Maple Ave Apt 29, Austin, TX, 787310.48Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-400875CLMTimothy Kelly1988-07-01—48931001292193 Mountain View Dr, Seattle, WA0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-404187CLMSharon Santos1990-01-28UHC-46936-59—6404 Bayshore Dr # 971, Denver, CO0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-422561CLMKeith Foster1973-01-10UHC-88227-2384669712323575 Oak St, Phoenix, AZ, 850430.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-423204CLMKeith Griffin1979-04-15—50884260491713 Cedar Ln, Sacramento, CA0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420146CLMSusan Yang2000-01-13UHC-21009-4247698699353414 Church St # 502, Jacksonville, FL, 322950.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-423616CLMAustin Harvey1988-02-02UHC-73934-26—8260 Main St # 666, Denver, CO0.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-425703CLMKayla Willis1944-09-11UHC-95285-80—7871 Ridge Rd # 923, Tampa, FL, 336160.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-407340CLMJoshua Hanson1960-08-22—7238151215967 Oak St, Eden Prairie, MN, 553340.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-428452CLMMateo Park2002-04-13UHC-21681-0687435470875295 River Rd, Denver, CO0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416612CLMElijah Burke2003-04-06UHC-58551-91—7099 Elm St Apt 9, Glendale, AZ, 853600.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-400489CLMMichael Bery1992-08-04UHC-59279-12—7385 Canyon Rd, Orlando, FL, 328580.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-409588CLMDonald Vaquez1960-05-26——1869 Mesa Dr, Scottsdale, AZ0.48Name re-casedDate of birth reformattedCity re-casedState name converted to code+4 more
CLM-429453CLMWayne Lucas1983-03-12UHC-83195-72—7615 Indian School Rd, Fresno, CA0.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-401125CLMJordan Welch2001-11-13UHC-43144-83—2704 Maple Ave # 582, Denver, CO, 802260.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-404954CLMStephen Peterson1980-01-06UHC-33520-0684789606249687 Central Ave, Dallas, TX, 752210.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-412970CLMStephanie Chavez1946-04-09UHC-88000-5496257288875606 Cedar Ln, Fresno, CA, 937290.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403044CLMBrittany Kim1958-12-16UHC-44063-25—6440 Central Ave Apt 9, Houston, TX, 770100.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-414018CLMMariana R Snatiago2006-11-22UHC-36282-5653178070234386 Jefferson Ave Apt 23, Tucson, AZ, 857370.48Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-426850CLMKathryn Thompson1988-02-25UHC-66658-7538499092399214 Forest Ave # 804, Minneapolis, MN, 554160.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
CLM-403618CLMEugene Patel1989-11-06UHC-40110-14—7309 Spring St, Charlotte, NC, 282200.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425173CLMBrenda Cruz2006-05-16UHC-82459-61—2625 Sunset Blvd, Plano, TX0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
32,829 rows, page 19 of 657PreviousNext