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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-126999ENRJake M Foster1988-11-23UHC-38844-7794651082373819 Lake View Rd, Tucson, AZ, 857250.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140647ENREric K Flores1962-10-19—45093887943873 Indian School Rd, Seattle, WA0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-118113ENRDeennis E Elliott1975-04-06UHC-09901-4741469875193313 Maple Ave Apt 40, Gilbert, AZ, 852650.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-123898ENRJohn W Thoams1960-05-14UHC-00769-2957690662038931 Baseline Rd, Scottsdale, AZ, 852820.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107881ENRAlexander Aguilar1999-03-21—37986045152890 Jefferson Ave, Columbus, OH, 432380.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-106832ENRBarbara G Howard2002-07-14UHC-62387-2321026205396324 Mountain View Dr, Jacksonville, FL, 322350.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-106644ENRStephen Q Ortiz1988-12-03UHC-98013-7273957134304836 Lake View Rd, Las Vegas, NV, 891600.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104009ENRGeorge F Fields1964-08-07UHC-41024-1980925680736238 Desert Sky Blvd, Seattle, WA, 981750.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-120237ENRPatricia Spencer1947-04-21UHC-85753-719207712357450 Apache Blvd, Plano, TX, 750640.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130234ENRMegan Rios1951-04-03UHC-47867-27—9068 Central Ave, Atlanta, GA, 303610.62Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+3 more
ENR-135814ENREmily R Reynolds1962-04-06—89033926825254 Mountain View Dr # 199, Austin, TX, 787120.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-135815ENREmily R Reynolds1962-04-06—89033926825254 Mountain View Dr # 199, Austin, TX, 787120.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-127203ENRAnthony Marttinez1979-08-19UHC-21138-2838954039345560 Forest Ave, Denver, CO, 802590.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-128407ENRAlbert K Gonzalez1968-09-15UHC-36932-9545193688849216 Indian School Rd Apt 38, Mesa, AZ, 852000.62Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-128406ENRAlbert K Gonzalez1968-09-15UHC-36932-9545193688849216 Indian School Rd Apt 38, Mesa, AZ, 852000.62Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-131961ENROlivia O Wheeler1965-10-28UHC-30003-9037850666393824 Union St, Dallas, TX, 752460.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105415ENRJulie Contreras1939-10-28UHC-05984-7627887242387644 Hillcrest Rd, Phoenix, AZ, 850390.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112589ENRBrandon Jacobs1962-07-15UHC-72775-5573293925536182 Lincoln Way, Houston, TX, 770190.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-111439ENRDouglas Boyd2008-01-05UHC-31244-3523592833864939 Grand Ave, Tempe, AZ, 852280.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-128055ENRBetty Wnag1999-02-05UHC-35789-1855881613665018 Elm St, Jacksonville, FL, 322770.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117341ENRMatthew S Medina1961-09-14UHC-54702-1964427521679132 Spring St, Houston, TX, 770610.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-128526ENRChristine E Ortega1942-02-14UHC-20181-2382347273922376 Jefferson Ave # 672, Tampa, FL, 336970.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-107753ENRPatricia Hanson2006-01-25UHC-26195-414478472521142 Mesa Dr, Seattle, WA, 981790.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-121127ENRRaymond O Morales1963-01-08UHC-83339-3886023097918567 Highland Ave, Gilbert, AZ, 852550.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141288ENRAmanda Ramirez1977-06-27UHC-56022-9846456216609257 River Rd, Houston, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129798ENROmar F Freeman1968-07-21UHC-21072-5871127394046603 Highland Ave, Seattle, WA, 981780.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-124660ENRAmy Torres1995-01-01UHC-25276-4964135179235717 Desert Sky Blvd, San Antonio, TX, 782400.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136779ENRSusan Braadley1982-11-11UHC-96595-2995978755673310 Camelback Rd, Denver, CO, 802010.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-106489ENRBryan Elliott1966-07-01UHC-17957-0662235818938813 Grand Ave, San Antonio, TX, 782600.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-123529ENRElizabeth O Wells1985-09-11UHC-74329-8944779617608340 Baseline Rd, Dallas, TX, 752820.62Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139545ENRDiane Carter1974-06-22UHC-52209-863799179824663 Main St, San Diego, CA, 921730.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121985ENRCharles J Watson1952-06-16UHC-58095-7971020904252196 Spring St Apt 37, Tempe, AZ, 852210.62Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-131218ENRHeather Fuller1938-09-04UHC-97671-8293034233485849 Mesa Dr, Minneapolis, MN, 554780.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111692ENRMariana Mason1965-12-17UHC-25369-2845724678477478 Mountain View Dr, Jacksonville, FL, 322700.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111693ENRMariana Mason1965-12-17UHC-25369-2845724678477478 Mountain View Dr, Jacksonville, FL, 322700.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134482ENRRuuth U Garcia1950-03-07UHC-31706-7723477751417453 Forest Ave # 135, Mesa, AZ, 852800.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-110552ENRSteven Bradley1945-04-08UHC-73547-5554359712533819 Canyon Rd, Denver, CO, 802710.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118564ENRGabriel D Cloe2007-05-03UHC-91900-15—373 Cedar Ln, Houston, TX, 770620.62Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-131652ENRAnna Hamilton1982-06-21UHC-04826-7543078662896670 Apache Blvd, Atlanta, GA, 303260.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119908ENRRoy Ramos1976-03-09UHC-72382-3544236441828873 Willow Ct, Austin, TX, 787670.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-116406ENRBrandon Bans1955-04-16UHC-97066-5459041775919580 Mesa Dr, San Antonio, TX, 782140.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-138531ENRMelissa Palmer1968-09-20UHC-45257-0764797398744242 Camelback Rd, Columbus, OH, 432060.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-132612ENRLawrence T Aguilar1978-05-28UHC-26192-0365129570012892 Jefferson Ave Apt 35, Los Angeles, CA, 900540.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-138470ENRFrank N Duncan1992-10-19UHC-13504-4390285856008825 Baseline Rd, Jacksonville, FL, 322640.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111372ENRIsabella S Shaw1993-05-27UHC-87611-4443869050504412 Palm Dr, Atlanta, GA, 303690.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-123034ENRAlice W Bryant1967-08-03UHC-87888-2631165803987231 Palm Dr, Chandler, AZ, 852650.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134692ENRDennis Warren1969-11-23UHC-83107-2687189280533986 Mountain View Dr, Miami, FL, 331780.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-125824ENRRobert Rees—UHC-55341-743663152536100 Canyon Rd, Seattle, WA, 981000.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-139389ENRWei R Ramirez1956-12-24UHC-24389-2826630560089644 Willow Ct, Las Vegas, NV0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109440ENRAmy Matthews1977-12-25UHC-25580-7873956865194188 Hillcrest Rd, Mesa, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 135 of 863PreviousNext