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-408025CLMSophia Petesr1943-03-13UHC-41273-9855424577811565 Bayshore Dr, Scottsdale, AZ, 852830.70Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-403609CLMRobert F Jordan1974-09-10——6722 Meadow Ln, Miami, FL0.70ZIP missingGender normalisedPlaceholder values cleared
CLM-429431CLMDorothy Collins2002-11-16UHC-40897-1274838665837220 Forest Ave, Mesa, AZ0.70Name split from “Last, First”City re-casedZIP missing
CLM-431358CLMDylan Morrison1948-06-26UHC-76007-546839591610368 Apache Blvd, Columbus, OH, 432310.70Street suffix standardisedAddress re-casedZIP+4 trimmed
CLM-417909CLMBradley Herrera2006-02-10UHC-52427-22—3645 Mountain View Dr, Scottsdale, AZ0.70Name split from “Last, First”ZIP missingPlaceholder values cleared
CLM-416859CLMAmber Jackson1940-04-15UHC-61032-14—5632 Pine Dr, Columbus, OH, 432160.70Name split from “Last, First”Date of birth reformattedSSN last four extracted
CLM-432328CLMBobby Walsh1990-07-09UHC-84978-59—5742 Oak St Apt 33, Las Vegas, NV, 891580.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
CLM-401960CLMSofia Garza1971-11-23UHC-84750-50—8092 Park Pl, San Antonio, TX0.70Street suffix standardisedAddress re-casedZIP missing
CLM-426127CLMVictoria Rogers2008-05-10UHC-57091-14—1444 Indian School Rd, Plano, TX0.70Phone missing area codeZIP missingPlaceholder values cleared
CLM-415720CLMRichard Riley1989-01-11UHC-00852-6777029207354315 Pine Dr, Columbus, OH, 432920.70Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-410121CLMDyaln Oliver1958-01-17——53 Central Ave, Scottsdale, AZ, 852800.70Name split from “Last, First”SSN last four extractedPlaceholder values cleared
CLM-428035CLMLawrence L Johnston1981-05-16UHC-28017-01——0.70Middle initial moved out of first nameTwo-digit birth yearPlaceholder values cleared
CLM-416735CLMOmar Chavez1976-12-25UHC-90070-5536996546222433 Baseline Rd, Seattle, WA, 981320.70Two-digit birth yearPhone reformattedGender normalised
CLM-405233CLMVicturia Hawkins1973-05-10———0.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-402004CLMYJunk1982-06-16UHC-02972-27—2654 Cedar Ln, Minneapolis, MN, 554480.70ZIP+4 trimmedPlaceholder values clearedNo usable name (quarantined)
CLM-410158CLMDeborah D Evans1948-06-12UHC-93956-02—7216 Harbor Blvd, Gilbert, AZ, 852700.70Name split from “Last, First”Gender normalisedWhitespace trimmed
CLM-411648CLMNicholas Ryan2006-10-26UHC-54730-669654173413565 Sunset Blvd, Phoenix, AZ, 850300.70Name split from “Last, First”Two-digit birth yearPhone reformatted
CLM-427257CLMMateo Armstrong1989-08-23———0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-431446CLMBenjamin Parker1988-03-13——1109 Grand Ave, Chandler, AZ, 852260.70Two-digit birth yearSSN last four extractedPlaceholder values cleared
CLM-405565CLMJackJunk1974-02-24——6010 Broadway Apt 13, Plano, TX, 750130.70Unit split from streetPlaceholder values clearedNo usable name (quarantined)
CLM-401000CLMDiana Stevens1981-11-16UHC-59010-76—7736 Valley View Dr, Nashville, TN, 372490.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
CLM-424777CLMArjun Meyer2002-05-20UHC-42340-6664359503515146 Valley View Dr, Mesa, AZ, 852350.70ZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-411000CLMScott Kennedy1993-02-22——7062 Market St, Plano, TX, 750990.70Name split from “Last, First”State name converted to codePlaceholder values cleared
CLM-410360CLMAhmed Riley2007-03-13——5024 Hillcrest Rd, Jacksonville, FL0.70State name converted to codeZIP missingPlaceholder values cleared
CLM-422181CLMMarcus Lewis1981-05-06UHC-53639-04—2066 Main St, Atlanta, GA, 303430.70Name split from “Last, First”Phone missing area codeWhitespace trimmed
CLM-430764CLMCarolyn Simmons1960-04-05UHC-93810-9687665165297621 Camelback Rd, Jacksonville, FL, 322700.70Name split from “Last, First”Date of birth reformattedGender normalised
CLM-415264CLMRichard V Kelley1957-06-25——6004 Sunset Blvd, Orlando, FL, 328560.70Name split from “Last, First”SSN last four extractedPlaceholder values cleared
CLM-403973CLMCatherine O Warren1967-02-15UHC-42276-35—290 Grand Ave, Fresno, CA, 937350.70Phone missing area codeGender normalisedPlaceholder values cleared
CLM-425046CLMRalph H Morris1971-12-28UHC-47328-94—2055 Forest Ave, Austin, TX, 787180.70State name converted to codeGender normalisedPlaceholder values cleared
CLM-401499CLMJudith Arnold1968-02-05——5198 Church St, Dallas, TX, 752620.70State name converted to codeGender normalisedPlaceholder values cleared
CLM-430921CLMBetty X Perez1997-03-07———0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
CLM-420110CLMRandy Medina1973-05-25UHC-46897-05—2559 Washington St, San Antonio, TX, 782920.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-402874CLMStephen Ray1957-01-19UHC-90976-19—630 Lake View Rd, San Antonio, TX, 782280.70Two-digit birth yearZIP+4 trimmedPlaceholder values cleared
CLM-417392CLMBetty Mason1987-07-19UHC-13974-16—4776 Hillcrest Rd, Tempe, AZ, 852620.70Street suffix standardisedAddress re-casedGender normalised
CLM-410452CLMCharlotte Warren1953-12-28———0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-403693CLMGary Weber1981-03-13UHC-46874-68—7590 Forest Ave Apt 19, Seattle, WA, 981000.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
CLM-416685CLMNathan Reid2008-12-27UHC-64789-7072480868847259 Mesa Dr, Glendale, AZ0.70Phone reformattedZIP missingGender normalised
CLM-404515CLMDeborah Munoz1989-05-06——5131 Apache Blvd, Gilbert, AZ, 852650.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-422953CLMNancy Soto1954-12-24——437 Maple Ave, Los Angeles, CA, 900390.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
CLM-412893CLMJoe Richards1945-09-03——5655 Ridge Rd, Minneapolis, MN0.70ZIP missingGender normalisedPlaceholder values cleared
CLM-416311CLMWalter Phillips1998-10-01——3291 Broadway # 341, Fresno, CA, 937550.70Unit split from streetGender normalisedPlaceholder values cleared
CLM-418562CLMVincent Laawson1948-08-14——2658 Valley View Dr, Chandler, AZ, 852520.70State name converted to codeGender normalisedPlaceholder values cleared
CLM-407708CLMMichelle Luna2001-07-03UHC-80345-60—2555 Pine Dr, Los Angeles, CA, 900920.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-402833CLMMartha Chapman1947-11-06—5645129782—0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-416325CLMDeborah W Maldonado—UHC-25667-87—904 Canyon Rd, Fresno, CA, 937860.70Date of birth unreadableStreet suffix standardisedAddress re-cased
CLM-407996CLMStephen Herrera1949-10-11UHC-09183-2975428097823354 Grand Ave, Nashville, TN, 372540.70Phone reformattedState name converted to codeGender normalised
CLM-421194CLMOmar Coleman1979-12-02UHC-91190-23—4576 Camelback Rd, Sacramento, CA0.70ZIP missingEmail lower-casedGender normalised
CLM-415656CLMJack Garza1965-12-27UHC-07484-53——0.70Two-digit birth yearPhone missing area codePlaceholder values cleared
CLM-429102CLMBrenda Phillips1961-06-05—80435370231876 Central Ave, Miami, FL0.70Two-digit birth yearZIP missingPlaceholder values cleared
CLM-415479CLMPhilip Payne1950-02-15UHC-56576-45—448 Grand Ave, Tucson, AZ, 857770.70Phone missing area codeGender normalisedPlaceholder values cleared
32,829 rows, page 222 of 657PreviousNext