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
ENR-109202ENRKathleen Li1966-09-10UHC-10889-86—3196 Sage Ct, Tampa, FL, 336540.52Date of birth reformattedPhone missing area codeSSN last four extractedState name converted to code+2 more
PRV-29017PRVKye A Hunt1959-07-03—20335740489635 Highland Ave, Denver, CO, 802540.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-140265ENRGary M Willis1986-05-06UHC-32252-9597533477244272 River Rd, Miami, FL, 331950.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-124704ENRAmy H Taylor1947-07-05UHC-08045-4151426747765915 Pine Dr, San Diego, CA, 921260.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-26505PRVDonna Hansen1961-06-10—870450680533 Meadow Ln, Atlanta, GA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122477ENRJordan A Ford1978-07-12UHC-27315-4197829920781158 Oak St, Minneapolis, MN, 554270.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118650ENRZachary Aguilar1985-09-04UHC-72976-9366258721879862 Palm Dr, San Diego, CA, 921890.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-109074ENRMateo Lopez1978-04-21UHC-64208-9573972978592923 Desert Sky Blvd, Dallas, TX, 752220.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-126415ENRJacqueline Evans1967-02-19——9777 Elm St, Tucson, AZ, 857060.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-140591ENRSusan Snyder1943-02-09UHC-74817-71—7267 Cedar Ln, Austin, TX, 787740.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-135697ENRGreg Arnold1972-04-17UHC-68214-7293629113118907 Washington St # 407, Columbus, OH, 432450.52Name split from “Last, First”Phone reformattedUnit split from streetState name converted to code+2 more
ENR-141463ENRJerry J Porter2001-07-04UHC-76978-3854125560911252 Ocean Ave # 486, Charlotte, NC0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-28973PRVChristopher Evans1905-10-23—84396334999894 Maple Ave, Tucson, AZ, 857300.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112822ENRJuaan I Patterson—UHC-85494-38—6790 Lake View Rd, Dallas, TX, 752080.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-101793ENRLaura M Young—UHC-15182-9341153310877598 Meadow Ln, Gilbert, AZ, 852580.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-110961ENRFrances O Burns1977-06-07UHC-13404-9934354861439458 Pine Dr Apt 23, Glendale, AZ, 853050.52Middle initial moved out of first nameName re-casedDate of birth reformattedUnit split from street+2 more
CLM-400384CLMSusan Freeman1948-01-26UHC-73337-8641825352458141 Pine Dr, Sacramento, CA, 958100.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-23066PRVPaul Burke1956-05-24—94053550527574 Apache Blvd, Eden Prairie, MN0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-26721PRVHeather Hart1960-06-27UHC-02743-9263850637178139 Highland Ave, Jacksonville, FL, 322120.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-412198CLMMark Tran1961-04-26——427 Washington St, San Diego, CA, 921640.52Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-134853ENRJoyce Wells1988-11-18UHC-37536-8173574105793694 Sage Ct, Dallas, TX, 752150.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-419612CLMCynthia Banks1996-04-05UHC-21793-89—8267 Ridge Rd, Minneapolis, MN, 554890.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-114466ENRRichard X Vasquez1944-10-03UHC-80242-2175742247528197 Lake View Rd, Plano, TX0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430845CLMEmma Richardson1955-11-07UHC-56071-9865389119084375 Ridge Rd, Eden Prairie, MN, 553130.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142437ENRArthur E Guerrero1959-07-27UHC-80930-8095664784871737 Highland Ave, Austin, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-50620TPASophia Pierce1973-09-23—47666937776744 Desert Sky Blvd # 732, Glendale, AZ, 853820.52Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
ENR-137439ENRRick Tran—UHC-09404-57—7877 Oak St, Plano, TX, 750030.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-106913ENRJudith M Harris—UHC-25584-4969726329821921 Park Pl, Tucson, AZ, 857230.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-117138ENRAmy Bryant1950-02-10UHC-84464-07—2882 Oak St, Fresno, CA, 937090.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-408892CLMJean W Carr1969-06-27UHC-65157-91—901 Central Ave, Los Angeles, CA, 900950.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
TPA-59777TPAMark Payne1972-10-19——3285 Desert Sky Blvd, Plano, TX, 750870.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60404TPADoris Torres———7807 Sunset Blvd, Phoenix, AZ, 850710.52Name split from “Last, First”Date of birth missingCity re-casedState name converted to code+2 more
ENR-125299ENRCynthia Z Bishop1962-06-21UHC-36612-6765564770924621 Palm Dr, Orlando, FL, 328720.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-125300ENRCynthia Z Bishop1962-06-21UHC-36612-6765564770924621 Palm Dr, Orlando, FL, 328720.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410949CLMLawrence Ortega1984-07-09—96320233131931 Lake View Rd, Plano, TX, 750900.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
PRV-21622PRVAlice Welker—UHC-55066-7630841758093598 Willow Ct, Minneapolis, MN, 554370.52Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+2 more
ENR-103006ENRCamila Y Hunt1977-03-09UHC-86053-1082281427556537 Hillcrest Rd, Scottsdale, AZ, 852660.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63999TPACarol J Lane1971-04-14—48267301671038 Apache Blvd, Dallas, TX, 752070.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-110658ENRSofia B Rice2004-01-26UHC-99088-4944538821633177 Camelback Rd, Los Angeles, CA0.52Name split from “Last, First”Phone reformattedSSN last four extractedState code upper-cased+2 more
CLM-424519CLMCarlos Kelly1978-01-20UHC-55263-23—4048 Palm Dr, Jacksonville, FL, 322670.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-116248ENRAnn Morals1982-03-06UHC-02904-0592661270153142 Park Pl Apt 9, Austin, TX0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-53277TPAOlivia Turner1961-10-26——3240 Sunset Blvd, Eden Prairie, MN, 553140.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
TPA-51371TPASarah Crawford1996-06-24—59483581268210 Cedar Ln, Columbus, OH0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-410062CLMJerry Flores1995-09-19—39860943299045 Indian School Rd, Glendale, AZ, 853900.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135468ENRPaul Brooks1980-03-07UHC-19750-7749339466462313 Indian School Rd, Plano, TX, 750030.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109377ENRChristina Garza1981-02-15UHC-89482-732033280584305 Church St, Tampa, FL, 336640.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-60446TPABrenda Munoz1979-05-11——6309 Park Pl, San Antonio, TX0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-120474ENRLaura Q Ramos1995-07-22UHC-35531-48—9515 Jefferson Ave, Tucson, AZ, 857540.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-113616ENRLinda V Martin—UHC-10140-612188808792318 Valley View Dr, Austin, TX, 787830.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-106484ENRGabriel J Owens1992-12-11UHC-29998-6536666543535073 Desert Sky Blvd, Houston, TX, 770410.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 162 of 2,000PreviousNext