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-118225ENRNancy X Murray1976-09-03UHC-72199-7060685353082773 Maple Ave, Scottsdale, AZ, 852430.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141900ENRJuan G Myers2000-11-12UHC-57612-7596234495185401 Park Pl, Dallas, TX, 752810.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-117930ENRRyan V Harvey1976-06-26UHC-08814-3474766426655411 Harbor Blvd Apt 27, Mesa, AZ, 852720.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-111585ENRElizabeth Bell1968-12-27UHC-65359-8734764913584741 Hillcrest Rd Apt 11, Dallas, TX, 752490.60Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-105362ENRMarilyn Y Jimenez2007-08-03UHC-04201-0454584401527500 Maple Ave, Gilbert, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-119477ENRKathryn P Hall1978-10-11UHC-42231-0434097305984517 Jefferson Ave, Phoenix, AZ, 850860.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-134332ENRDorothy F Collins1942-04-11UHC-66552-9448692860278752 Broadway, Orlando, FL0.60Date of birth reformattedPhone reformattedMember ID reformattedAddress re-cased+4 more
ENR-138076ENRStephen E Fuller1966-02-27UHC-14276-0359124343633178 Valley View Dr, San Antonio, TX, 782230.60Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-126980ENRKeith Diaz1996-11-13UHC-14729-9286960376502922 Park Pl, Minneapolis, MN, 554550.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-116060ENRLarry V Morgan1952-06-04UHC-19275-7970597293185623 Market St, Sacramento, CA, 958740.60Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-110232ENRSophia J Bowman1983-01-26UHC-12484-2479461087401910 Forest Ave, San Diego, CA, 921670.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110380ENRHarold D Hudson1980-08-07UHC-86397-5549749241077039 Jefferson Ave, Dallas, TX, 752540.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-111530ENRAlbert Burton2004-07-01UHC-40536-6527977105968988 Pine Dr # 495, Tucson, AZ, 857450.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-137722ENRJim R Kelley1947-11-13UHC-86255-5090362096149773 Ocean Ave Apt 27, Tampa, FL, 336830.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-106264ENRJesse Gardner1984-12-15UHC-82310-0344898267547386 Central Ave, Glendale, AZ0.60Name re-casedPhone reformattedCity re-casedZIP missing+4 more
ENR-109514ENRJulia George1959-01-27UHC-91645-0346949812122430 Valley View Dr, Charlotte, NC, 282210.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-111231ENRCharles C Morrison1954-02-22UHC-66990-4170699653795746 Harbor Blvd, Glendale, AZ, 853530.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-122246ENRPaul U Lawson2005-04-09UHC-29000-2436395309762360 Mesa Dr, Eden Prairie, MN, 553720.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-136068ENRLauren R Murphy1969-08-21UHC-46397-9192372970882578 Lake View Rd # 376, Orlando, FL, 328450.60Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-104118ENRAustin Hughes2000-06-04UHC-81540-494454953335138 Meadow Ln, Eden Prairie, MN, 553080.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-142759ENRAndrea Kelly1999-08-23UHC-83502-0174157903863451 Valley View Dr, San Antonio, TX, 782300.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-113856ENRMei S Neslon1998-05-06UHC-81996-0993758332686349 Indian School Rd, San Antonio, TX, 782630.60Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-130285ENRSean G Cooper1974-10-22UHC-87922-428649372471567 Bayshore Dr, San Antonio, TX, 782910.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-109240ENRVirginia C Weber1973-10-18UHC-27686-5944922577283723 Ocean Ave, Seattle, WA, 981030.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-116317ENROlivia X Pena1962-11-01UHC-64907-3949940226983732 Lake View Rd, Las Vegas, NV, 891860.60Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110277ENRJudy X Little2002-04-17UHC-61353-4436394326511140 Cedar Ln, Columbus, OH0.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114483ENRHeather H Lynch1996-05-02UHC-37423-636293745670695 Highland Ave, Plano, TX0.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-102427ENRPatricia G Wood1957-06-24UHC-51254-08—2526 Meadow Ln, Jacksonville, FL, 322600.60Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-140352ENRKathryn B Salazar1942-07-06UHC-94095-017883228340996 Sage Ct, San Antonio, TX, 782490.60Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107295ENRMason D Ryan1990-04-02—50652489065688 Pine Dr, Chandler, AZ, 852970.60Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
ENR-107281ENRCamila L Meyer1971-08-08UHC-63608-2745293043743788 Main St, Glendale, AZ, 853100.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-106962ENRSofia X Ortiz1942-11-24UHC-21428-8694446031858551 Market St # 716, Fresno, CA, 937760.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-120683ENRAmy Bell1952-11-17UHC-13517-158357067795588 Church St, Plano, TX, 750540.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-108483ENRMarcus J Delgado1990-12-17UHC-19436-2390092399632234 Camelback Rd, Glendale, AZ, 853750.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-105757ENRAustin Lucas1973-04-28UHC-18883-68—9566 Oak St, Minneapolis, MN, 554540.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-108265ENRIsabella Carr1960-06-13UHC-32279-0668875179861829 Mountain View Dr, Phoenix, AZ, 850080.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111640ENRSarah Henderson1972-04-16UHC-24133-9357169004318426 Cedar Ln, Mesa, AZ, 852380.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109624ENRKathryn L Carpeenter1974-11-22UHC-20471-7224790611847653 Canyon Rd, Las Vegas, NV, 891530.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-121321ENRCarol N Dunn—UHC-98857-5196445507975140 Apache Blvd, Fresno, CA, 937310.62Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+3 more
ENR-120181ENRMary U Crawford1987-09-04UHC-87669-1250736089169191 Ocean Ave, Scottsdale, AZ0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-120182ENRMary U Crawford1987-09-04UHC-87669-1250736089169191 Ocean Ave, Scottsdale, AZ0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-113706ENRCatherine Y Bennett1945-01-20UHC-61792-3149184528369312 Indian School Rd, Orlando, FL, 328540.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123606ENRAndrrew O Matthews1977-04-05UHC-70642-5078121819519858 Baseline Rd Apt 31, Orlando, FL, 328950.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-111022ENRCamila Lucas1959-11-09UHC-50549-37—4364 Maple Ave, Chandler, AZ, 852050.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-140871ENRDebra Q Burton1998-08-18UHC-42500-849399357160639 Cedar Ln, Plano, TX, 750740.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127351ENRDanielle Murray—UHC-55126-7446830169097790 Meadow Ln, Eden Prairie, MN, 553300.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
ENR-112421ENREmily Stewart2005-11-05UHC-09336-7072760103994286 Forest Ave # 201, Atlanta, GA, 303660.62Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-128915ENRAnthony James—UHC-64793-6597941472742390 Church St, Glendale, AZ, 853850.62Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+3 more
ENR-141885ENRArthur S Kennedy1983-12-05UHC-39550-8561530301001114 River Rd # 901, Scottsdale, AZ, 852150.62Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-135449ENRWayne Boyd1966-06-01UHC-37084-5442844964913787 Apache Blvd, Miami, FL, 331910.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 134 of 863PreviousNext