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-127876ENRAmber G Moreno—UHC-25618-8030948507914874 Camelback Rd, Atlanta, GA, 303170.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-134056ENRJusitn I Rojas1950-01-27UHC-93944-4741030072715377 Cedar Ln, Mesa, AZ, 852600.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107350ENRJose B Lawrence1967-12-22UHC-16741-1523388996049696 Valley View Dr, Atlanta, GA, 303000.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51609TPAKeith Vazquez1965-05-23——6164 Grand Ave, Scottsdale, AZ, 852990.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-429983CLMJulie Romero———5486 Central Ave, Nashville, TN, 372920.50Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-104102ENRDiego Daniels1953-10-13UHC-77752-8623935792433198 Highland Ave, Eden Prairie, MN, 553570.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50318TPADiego Holmes1965-05-21——5512 Sage Ct, Scottsdale, AZ, 852380.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-402891CLMGrace Hawkins1938-07-27UHC-70840-06—1559 Willow Ct, Fresno, CA, 937010.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-117142ENRDiana V Lane1940-04-01UHC-50137-2876837049623196 Sunset Blvd, Eden Prairie, MN, 553780.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-118302ENRSamuel V Padilla1955-10-19UHC-58277-7330527143926345 Jefferson Ave, Minneapolis, MN, 554700.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-53799TPAVictoria Chen1947-02-23—6924259533925 Ridge Rd, Orlando, FL, 328080.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117757ENRKeith Woods1954-03-22UHC-83597-4626230733288189 River Rd # 524, Denver, CO, 802240.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-101385ENRAnthony Sanchez1983-04-09UHC-43379-6687553789388793 River Rd, Chandler, AZ, 852940.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400461CLMDiana McDonald2001-02-15UHC-97280-61—5119 Canyon Rd, Nashville, TN, 372830.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124775ENRAhmed Kim2004-08-23—75372182194911 Forest Ave # 468, Nashville, TN, 372980.50Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more
PRV-28368PRVPaul Y Ross—UHC-15295-38—3208 Lincoln Way, Plano, TX, 750290.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-405255CLMAlexis Washington1997-12-03—26270644805669 Valley View Dr, Columbus, OH0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118987ENRMei B Bradley—UHC-98883-3396965361313322 Palm Dr, Denver, CO0.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415828CLMWilliam Scott1938-04-20UHC-86572-89—2049 River Rd, Dallas, TX, 752070.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-131939ENRJulia Maldonado1985-02-06UHC-81622-15—2094 Bayshore Dr, Nashville, TN, 372120.50Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more
PRV-28949PRVDenise Thomas2003-03-03—21084597994212 Church St # 332, Phoenix, AZ, 850090.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-419254CLMChristopher Perkins1980-12-20—90879193828198 Baseline Rd Apt 6, Scottsdale, AZ, 852560.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-24788PRVKaren Cook—UHC-61680-9960469586937461 Mountain View Dr, Fresno, CA0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-122718ENRJoyce Santiago2000-08-25UHC-78000-992348295751832 Highland Ave # 934, Los Angeles, CA, 900080.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-137332ENRMartha Henderson1970-11-08UHC-50518-6321083410554102 Forest Ave, Chandler, AZ0.50Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
ENR-139174ENRLuis Y Stevens2002-07-18UHC-41015-83—7599 Grand Ave, Sacramento, CA, 958500.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414474CLMJean Marquez1976-10-18UHC-24571-4352589968805307 Desert Sky Blvd # 337, Columbus, OH, 432200.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-100180ENRGabriel U Olson1967-05-06UHC-29339-5123491799072526 Ridge Rd, Eden Prairie, MN0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429239CLMSandra Brown2005-02-05UHC-38120-34—4287 Central Ave, Mesa, AZ, 852780.50SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-404414CLMWayne Johnson—UHC-32196-1261873174264894 Palm Dr, Charlotte, NC, 282220.50Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-136804ENRJanice Hamilton1977-02-23UHC-98453-7639667201566541 Cedar Ln, Las Vegas, NV, 891370.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-420625CLMDoris Hatr1999-03-26UHC-42027-01—793 Lake View Rd # 378, Eden Prairie, MN, 553880.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-23161PRVMadison Ellis1974-10-12—63931161935893 Central Ave # 221, Atlanta, GA, 303850.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-416710CLMLogan Green1972-01-18—513446785632 Willow Ct # 353, Chandler, AZ, 852660.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-129708ENRHannah White1953-06-08UHC-97230-8289130796274277 Palm Dr, Eden Prairie, MN, 553680.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-117590ENREvelyn Y Reyes1999-09-05UHC-54787-27692756032648 Mountain View Dr, Los Angeles, CA, 900350.50Middle initial moved out of first nameName re-casedDate of birth reformattedSSN last four extracted+3 more
ENR-137045ENRAlice Cruz1939-01-08UHC-28830-6847323834234350 Meadow Ln, Houston, TX, 770290.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-129239ENRJohn F Espinoza1999-03-28UHC-35989-4492732326322404 Elm St, Denver, CO, 802800.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-413560CLMCheryl Ward1986-10-26——1170 Spring St, Nashville, TN0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
CLM-407292CLMJoyce Thompson1952-02-17——2819 Pine Dr, Fresno, CA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412224CLMPriya R Henry1997-12-11UHC-78896-2662679441096340 Mountain View Dr, Gilbert, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111958ENRLarry V Smith1953-11-11UHC-68077-8266470071871043 Park Pl Apt 30, Las Vegas, NV, 891070.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-425964CLMAshley Bryant2006-10-04UHC-46537-8355361071507372 Pine Dr Apt 13, Miami, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61175TPAGlooria King—UHC-54429-89—932 Ocean Ave Apt 5, Denver, CO, 802710.50Date of birth reformattedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
ENR-108201ENRMariana B Luna1950-08-20UHC-89166-28—8589 Sage Ct Apt 14, Austin, TX, 787230.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
PRV-21537PRVValentina Montgomery1983-04-19UHC-94649-4091481295569150 Forest Ave, Nashville, TN, 372380.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-113228ENRAmber Hamilton1974-09-16UHC-67162-0187222770656618 Maple Ave, San Diego, CA, 921720.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53969TPABilly Le1940-01-19——5795 Baseline Rd, Glendale, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-419434CLMJonathan Q Silva2006-05-10UHC-97068-21—8190 Cedar Ln, Fresno, CA, 937520.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-431016CLMRandy Bishop1982-05-13UHC-81792-57—7863 Oak St, Tempe, AZ0.50Name re-casedDate of birth reformattedState name converted to codeZIP missing+3 more
100,000 rows, page 134 of 2,000PreviousNext