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
CLM-415606CLMBeverly Garza1973-04-17UHC-81899-1157351856831411 Indian School Rd, Scottsdale, AZ, 852730.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401216CLMEthan Maldonao1970-10-25—56773781722378 Sunset Blvd Apt 39, Phoenix, AZ0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-121318ENRSteven O Brooks1991-05-11UHC-72425-7435349808556614 Camelback Rd, Tampa, FL0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56364TPALinda N Patterson———9882 Oak St, San Antonio, TX, 782600.50Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-137601ENRKevin Hunt1991-04-08UHC-33272-1271335982363595 Indian School Rd # 596, Las Vegas, NV, 891180.50Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
ENR-137602ENRKevin Hunt1991-04-08UHC-33272-1271335982363595 Indian School Rd # 596, Las Vegas, NV, 891180.50Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
PRV-20381PRVKatherine Carpenter1949-04-23UHC-20620-5967068394294824 Lake View Rd, Plano, TX, 750460.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-117686ENRJeremy X Armstrrong1989-04-21UHC-07659-0471880705149463 Harbor Blvd # 406, Plano, TX, 750510.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-120657ENRCharlotte Le1992-07-09UHC-00963-843487060294928 Hillcrest Rd, Plano, TX0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-29492PRVBryan Clark1978-05-19—3174122429705 Camelback Rd Apt 27, Tampa, FL, 336380.50Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+3 more
ENR-131894ENRMelissa Harper1989-08-25UHC-49551-9567189219743459 River Rd, Las Vegas, NV, 891010.50SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-133404ENRDavid Brown1991-08-27—7872387239729 Pine Dr, Minneapolis, MN, 554780.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-400042CLMEric James2006-07-22——6336 Hillcrest Rd # 398, San Diego, CA, 921450.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-28718PRVEveyln Smith1939-01-01—67270203427492 Ridge Rd Apt 9, Fresno, CA0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-112670ENRJudy V Hanson1999-12-04UHC-90420-0843994074845974 Ridge Rd, Los Angeles, CA, 900980.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101767ENREdward L Perez1969-07-23UHC-70988-2183692875407363 Meadow Ln, Houston, TX, 770930.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-128774ENRPriya Lynch1982-09-24UHC-09790-72—3494 Baseline Rd # 635, Minneapolis, MN, 554100.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-20338PRVCarolyn Barnes1978-04-07—69338529236013 Church St, Las Vegas, NV, 891510.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142518ENRWalter U Santos—UHC-32733-1967159106088694 Baseline Rd, Nashville, TN, 372340.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116358ENRJoshua Hughes1955-03-25UHC-99643-1428940418168245 Spring St, Phoenix, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-25492PRVArthur Chavez1973-02-02UHC-10907-0236860142733230 Pine Dr, Miami, FL, 331790.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140997ENRAmanda L George1985-07-05UHC-69524-049428066070742 Oak St, Orlando, FL0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-420737CLMRebecca Henry—UHC-09021-94—8916 Spring St, Los Angeles, CA, 900170.50Date of birth missingPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-403352CLMJeremy Torres1982-06-17UHC-01486-0979664530958802 Jefferson Ave, Plano, TX, 750170.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-431491CLMKimberly Little1941-09-26UHC-05525-1684943753365743 Valley View Dr, Las Vegas, NV, 891400.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126193ENRMariana E Nguyen1974-09-10UHC-30578-857332586892789 Highland Ave, Glendale, AZ, 853380.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126408ENRDaaniel Parkar1977-04-03UHC-98857-9356394623755608 Canyon Rd, Tucson, AZ, 857590.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-407268CLMKenneth J Gordon1939-07-13UHC-62055-4220561838608838 Sage Ct # 778, Chandler, AZ, 852280.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-108238ENRVincent Rodriguez1950-05-23UHC-00309-0566362774646259 Oak St, Tucson, AZ, 857530.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61059TPAAshley Oliver1973-04-06——229 Bayshore Dr, Gilbert, AZ, 852010.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-57700TPANicholas Montgomery1976-12-24—27472172898660 Baseline Rd, San Antonio, TX, 782500.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-404180CLMRyan Rivera1974-02-14UHC-04975-49—6236 Desert Sky Blvd Apt 6, Mesa, AZ, 852580.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54697TPASarah Bowman1983-04-27——3180 Apache Blvd, Los Angeles, CA0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-406833CLMPhilip Woods2001-02-24UHC-83948-75—8935 Valley View Dr, Eden Prairie, MN0.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-126278ENRAlexis Weaver1944-03-20UHC-87568-87855937704573 Valley View Dr, San Antonio, TX, 782480.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418087CLMMargaret Mills1980-01-24—55757132132628 Market St, Phoenix, AZ, 850230.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-58576TPASharon Sanchez1996-03-09——6949 Canyon Rd # 643, Tempe, AZ, 852710.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
ENR-128136ENRJohn Andrews2005-10-17UHC-79943-1364338391228205 Mesa Dr, Orlando, FL0.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-124552ENRKelly N Hunt1985-12-13UHC-13321-3157386538656920 Willow Ct, Sacramento, CA, 958100.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-123334ENRDiae Scmhidt—UHC-84210-9393636249739409 Washington St, Gilbert, AZ, 852420.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-129631ENRMegan V Carter1953-09-14UHC-16129-5346740719612354 Canyon Rd, Tucson, AZ0.50Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more
TPA-56561TPAWei Romero1986-01-19—22285845168922 Willow Ct Apt 12, Scottsdale, AZ0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-132997ENRDebra Garza—UHC-76716-0929580227646122 Highland Ave, Austin, TX, 787560.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418232CLMEugene Soto1991-01-02UHC-38273-8034032532469360 Lake View Rd, Eden Prairie, MN, 553340.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-132219ENRHenry Jackson—UHC-50017-2060457861146329 River Rd, Las Vegas, NV, 891230.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-124440ENRLawrence V Alvarado1956-02-11UHC-24233-9584781938828480 Valley View Dr, Minneapolis, MN0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415440CLMJackie Owens1994-08-23UHC-62366-83—2104 Mountain View Dr, Gilbert, AZ, 852420.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138721ENRJudith I Sanchez1953-05-23UHC-37863-85—4710 Maple Ave, Jacksonville, FL, 322100.50Name split from “Last, First”Middle initial moved out of first nameMember ID reformattedStreet suffix standardised+3 more
CLM-432526CLMAhmed Hoffman1991-01-20UHC-79652-3273247120296488 Desert Sky Blvd, Eden Prairie, MN, 553450.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-123009ENRBobby T Mendez1987-11-04UHC-62846-2136438930265296 Central Ave, Atlanta, GA0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
100,000 rows, page 99 of 2,000PreviousNext