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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-28605PRVBruce Fox1979-09-06UHC-44206-8177399399254844 Cedar Ln, Austin, TX, 787440.52Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+2 more
ENR-129453ENRAlexis Ross2001-04-24UHC-76669-0687438088362335 Baseline Rd Apt 19, Atlanta, GA, 303860.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-130122ENRNatalie Payne1972-03-19UHC-54535-1258833607943159 Maple Ave, Columbus, OH, 432680.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-134779ENRJonh D Payne1947-12-01UHC-58602-12—4417 Hillcrest Rd, Atlanta, GA, 303630.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-119222ENRSophia J Howell1982-03-08UHC-19520-7967288648293708 Mountain View Dr, Nashville, TN, 372950.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-106040ENRAmber F White1962-10-21UHC-86611-6882091176472131 Sunset Blvd, Miami, FL, 331050.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420322CLMJudith Price2003-12-14UHC-74259-56—1389 Highland Ave # 415, Mesa, AZ, 852690.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-116001ENRDoris Guerrero1951-01-14UHC-32145-6122331368141029 Spring St # 887, Las Vegas, NV0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-137499ENRBilly L Ford—UHC-13141-0141849241435605 Sunset Blvd, Tempe, AZ, 852470.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-131771ENRNathan T Ward1943-08-19UHC-63876-9969625446291774 Bayshore Dr, Gilbert, AZ0.52Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-403966CLMMark Crawford—UHC-80518-14—9452 Mesa Dr, Eden Prairie, MN, 553980.52Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+2 more
ENR-140174ENRNancy Le1985-02-27UHC-53754-1163623548949375 Washington St, Scottsdale, AZ0.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-106697ENRJonathan P Bell1988-02-22UHC-75396-8965590206714740 Forest Ave, Sacramento, CA0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-421290CLMHelen Guerrero—UHC-70876-54—3231 Baseline Rd, Glendale, AZ, 853290.52Date of birth missingPhone missing area codeCity re-casedState name converted to code+2 more
CLM-411628CLMArthur Matthews1958-09-05——8260 Palm Dr, Plano, TX, 750350.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415879CLMBetty Hrat1993-04-17UHC-32493-85—4852 Union St, Charlotte, NC, 282290.52Name re-casedTwo-digit birth yearPhone missing area codeGender normalised+2 more
ENR-107215ENRRoger D Porter1992-03-10UHC-61167-6234572762445095 Ridge Rd, Chandler, AZ, 852560.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
ENR-111624ENRAlice Fox—UHC-49138-6975569182674968 Mountain View Dr, Charlotte, NC0.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29315PRVDoris Espinoza———5805 Meadow Ln, Scottsdale, AZ, 852440.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-108975ENRZachary Wallace1994-02-09UHC-31902-2129693097197504 Ridge Rd, Miami, FL, 331090.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61891TPAFrank Garcia1941-07-01——9059 Market St, Denver, CO, 802680.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-100043ENRJulie G Carter1979-07-02UHC-96665-3059390606301136 Desert Sky Blvd, Charlotte, NC, 282920.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-139026ENRBetty Henderson1979-05-25UHC-12907-6876378169175407 Willow Ct, Fresno, CA, 937240.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400297CLMDouglas George1985-12-18UHC-91044-29—9884 River Rd, Tempe, AZ, 852170.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56398TPAArthur Pierce1950-01-16——6768 Lincoln Way, Tampa, FL, 336730.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-59469TPAJon Woods1970-07-25—9612302794727 Church St # 855, Las Vegas, NV, 891560.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408807CLMWilson Beverly—UHC-39470-08—6056 Forest Ave, Jacksonville, FL, 322890.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-102106ENRBrittany V Contreras1961-08-02UHC-96678-5753720950274487 Pine Dr, Nashville, TN, 372830.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-142801ENRGeorge Y Ramos1962-03-15UHC-92611-30—2114 Willow Ct Apt 7, Seattle, WA, 981130.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-135645ENRAhmed G Harrison1977-06-08UHC-65862-40—1572 Palm Dr, Minneapolis, MN, 554850.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-58987TPANoah Cook1982-04-09—6506429202496 Market St, Tempe, AZ, 852630.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426385CLMShirley Soto1948-09-15UHC-96595-31—6577 Baseline Rd, Nashville, TN0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-114830ENRKimberly Chavez1943-06-23UHC-51576-1655652251363310 Oak St, Charlotte, NC, 282910.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-419889CLMDiana Flores1943-09-06UHC-29823-1555095075568278 Hillcrest Rd, Tucson, AZ, 857500.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-105279ENRJesse Ryan1984-11-25UHC-71476-43—1048 Mesa Dr, Glendale, AZ, 853030.52Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418624CLMEdward B Russell1991-02-21UHC-31057-9440299660997133 Meadow Ln # 217, Tucson, AZ0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-63687TPAChristian Coleman2001-06-07—63782266871394 Palm Dr # 409, San Diego, CA0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-140003ENRElijah N Jensen1939-08-12UHC-95595-9489342046568686 Harbor Blvd, Houston, TX, 770090.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-54706TPAJose Munoz1982-11-23——7787 Mesa Dr, Tampa, FL, 336650.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-107473ENROlivia Chavez1973-01-15UHC-71126-9161566289285964 Meadow Ln, Atlanta, GA, 303710.52Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+2 more
CLM-424867CLMHiroshi Q Brooks1990-08-15UHC-65032-33—741 Canyon Rd, Nashville, TN, 372320.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-104741ENRAaron Brown2000-01-02UHC-60711-0959393378851818 Elm St, Sacramento, CA, 958590.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28922PRVBilly Wnag1952-12-17—28387107789796 Canyon Rd # 922, San Antonio, TX, 782460.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-103918ENRWalter Perry—UHC-37779-0289440103484439 Willow Ct, Nashville, TN, 372710.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-100649ENRAngela Palmer1967-07-24UHC-70076-8775970201198072 Church St, Mesa, AZ0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119899ENRKyle Payne1959-08-12UHC-34802-4750370257066422 Forest Ave, Gilbert, AZ, 852390.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53714TPARoy Mendez1973-06-03—77322065139475 Meadow Ln, Scottsdale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-118770ENRRalph Reed1978-06-03UHC-28797-2932890653056164 Main St, Nashville, TN, 372050.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429085CLMThomas Snyder1999-07-18—51498563682100 Baseline Rd, Las Vegas, NV, 891160.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-422482CLMBobby Wilson1980-12-08——2048 Lake View Rd, San Antonio, TX, 782460.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 165 of 2,000PreviousNext