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-118383ENRTimothy E Gordon1977-07-23UHC-55444-6986060297443979 Bayshore Dr, Jacksonville, FL, 322880.50Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
ENR-104584ENRCynhtia E Gardner1988-06-20UHC-10851-3532788142333740 Desert Sky Blvd, Orlando, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141538ENRDouglas D Cruz1961-04-01UHC-70015-6728179396569571 Baseline Rd, Columbus, OH, 432780.50Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-120076ENRCarlos U Henderson1938-09-10UHC-04658-8388877343143916 Washington St, Plano, TX, 750930.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129549ENRBenjamin V Payne1991-12-09UHC-66516-3433049426269168 Ocean Ave, Austin, TX, 787790.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-120567ENRRonald Hoffman1958-08-16UHC-16807-5398921992668607 Ocean Ave, Tucson, AZ0.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-109703ENRValentina P Johnston1945-05-04UHC-69203-68—7623 Cedar Ln # 378, Tampa, FL, 336570.50Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
ENR-107885ENRAbigail George1993-07-19UHC-48841-1888239718425368 Lincoln Way, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-141874ENRDonna Guzman1957-03-28UHC-41209-8360193209122470 Meadow Ln Apt 38, Austin, TX, 787380.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-107363ENREugene N Jimenez1984-02-04UHC-93297-6092543858441999 Willow Ct, Eden Prairie, MN, 553970.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-127933ENRVictoria X Estrada1995-09-18UHC-18975-43—1939 Park Pl, Seattle, WA, 981240.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-131357ENRScott I Tran1946-11-08UHC-41541-2564598471681906 Sage Ct, Houston, TX0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-121721ENRWilliam Dixon1965-10-14UHC-96330-9143932391489245 Pine Dr, Miami, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140790ENRNancy C Contreras2005-09-10UHC-96093-3636078797427476 Cedar Ln Apt 3, San Antonio, TX, 782950.50Date of birth reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
ENR-101863ENRStephhanie A Black1984-02-20UHC-71521-2680728912713602 Meadow Ln, Mesa, AZ, 852780.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103064ENRPamela Jensen1984-10-04UHC-45453-8163447759075245 Market St, Las Vegas, NV, 891120.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133102ENRTeresa Campbell—UHC-61936-6793198353928865 Mountain View Dr, Eden Prairie, MN, 553570.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-137920ENRGary B Wang1996-04-02UHC-83488-5966928707018882 Jefferson Ave, Los Angeles, CA, 900140.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
ENR-105499ENRKevin Baker2001-01-12UHC-06930-2789668714869150 Church St, Jacksonville, FL, 322250.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136489ENRWayne Z Cruz1964-09-07UHC-31174-70—5670 Indian School Rd, Seattle, WA0.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-136490ENRWayne Z Cruz1964-09-07UHC-31174-70—5670 Indian School Rd, Seattle, WA0.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-137014ENRBecky C Hamilton1954-02-23UHC-26416-0321551936152665 Indian School Rd, Plano, TX, 750190.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-103099ENRDaniel Williams1960-04-16UHC-03175-49—2563 Park Pl, Dallas, TX, 752210.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142303ENRJoan Price1938-10-13UHC-30347-2587752178665568 River Rd, Seattle, WA, 981440.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113803ENRRussell E Murray1951-06-16UHC-02728-23—8438 Canyon Rd, Fresno, CA, 937360.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-131616ENRSandra Valdez—UHC-92310-3276766993834090 Main St, Tampa, FL, 336040.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-142382ENRAnna E Taylor1988-07-15UHC-89479-0731199531686456 Mesa Dr, Minneapolis, MN, 554350.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-141928ENRStephanie Elliott1957-09-15UHC-77580-0736881065112713 Bayshore Dr, Gilbert, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-132546ENRHanson Scott2000-08-24—84364898421929 Union St # 655, Tempe, AZ, 852120.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-106518ENRJoe O Salazar1995-08-18UHC-98084-2584944684408258 Hillcrest Rd, Seattle, WA, 981080.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-102172ENRMartha D Harrison1980-03-26UHC-15211-7865560610267138 Lincoln Way, Denver, CO, 802880.50Name re-casedCity re-casedState name converted to codeZIP+4 trimmed+3 more
ENR-107357ENRPeter Marquez1975-02-20UHC-35980-72—4952 Jefferson Ave, Jacksonville, FL, 322850.50Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+3 more
ENR-124822ENRHannah R Ryan1983-08-14UHC-82129-983147035927604 Washington St, Minneapolis, MN, 554490.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124559ENRMarilyn T Reyes1975-10-22UHC-73685-7736495362846140 Baseline Rd # 257, Eden Prairie, MN, 553650.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-121718ENRValentina R Aguilar—UHC-88614-9323860953224653 River Rd, Glendale, AZ, 853760.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-125794ENRBruce Bryant2000-02-16UHC-90920-7058499274902016 Grand Ave Apt 13, Eden Prairie, MN, 553610.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-142936ENRElijah Hudson1984-06-27UHC-37723-8531272628583818 Sage Ct, Phoenix, AZ, 850000.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-114230ENRJerry G Phillips1991-05-02UHC-17758-1020741265461057 Meadow Ln, Charlotte, NC, 282800.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108614ENRKyle Berry1981-08-15UHC-29527-443613128002205 Central Ave, Jacksonville, FL, 322880.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137575ENRChristina P Mitchell1960-10-28UHC-77759-595852691353228 Union St, Jacksonville, FL0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-134354ENRHelen C Maldonado1993-11-23UHC-15722-4046664041776844 Highland Ave, Charlotte, NC, 282850.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117538ENRMarcus Whitte1984-02-10——3172 Main St, Scottsdale, AZ, 852990.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-122911ENRNoah Ward1945-03-10UHC-78806-2776334270703345 Ocean Ave, Mesa, AZ, 852990.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-134386ENRSamuel G George2008-12-03UHC-58433-1495977481782754 Cedar Ln, Denver, CO, 802220.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
ENR-125611ENRKelly V Greene1963-12-04UHC-79987-7333062643256586 Market St, Las Vegas, NV0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117609ENRRussell S Bailey1987-04-01UHC-87909-5242242402934758 Maple Ave, Chandler, AZ, 852760.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141970ENREmily O Taylor1946-06-08UHC-53019-8148344109606234 Elm St Apt 35, Charlotte, NC, 282380.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-113532ENRMegan T Garcia1979-11-28UHC-85835-9482965065879530 Forest Ave, Austin, TX, 787230.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-134082ENRMelissa S Hicks1954-01-18UHC-05893-6078537544938011 Central Ave, Tempe, AZ, 852660.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedCity re-cased+3 more
ENR-131659ENROlivia Cole1982-06-23UHC-64377-815763539617915 Valley View Dr, Tampa, FL, 336590.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
43,101 rows, page 53 of 863PreviousNext