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-140374ENRGrace Myers1966-04-16UHC-71788-5343927506702819 Canyon Rd, Eden Prairie, MN, 553530.56Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-130151ENRDavid Mendoza1946-04-09UHC-49624-8128420071744939 Bayshore Dr Apt 40, Miami, FL, 331430.56Name split from “Last, First”Unit split from streetState name converted to codeWhitespace trimmed
ENR-102287ENRLarry Gutierrez1974-05-23UHC-44338-82—8354 Indian School Rd, Houston, TX, 770120.56State name converted to codeZIP+4 trimmedGender normalisedWhitespace trimmed
ENR-139875ENRBrenda D Lawrence2008-09-19UHC-03077-348376431059418 Jefferson Ave, Mesa, AZ, 852060.56Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised
ENR-118719ENRJonathan F Wong1976-04-11UHC-36675-4459965105257028 Canyon Rd, Orlando, FL, 328150.56Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased
ENR-118718ENRJonathan F Wong1976-04-11UHC-36675-4459965105257028 Canyon Rd, Orlando, FL, 328150.56Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased
ENR-100944ENREthan Vargas1950-02-18UHC-32789-06—6425 Highland Ave Apt 3, Phoenix, AZ, 850050.56Name split from “Last, First”Two-digit birth yearUnit split from streetPlaceholder values cleared
ENR-122550ENRJesse West1991-03-21UHC-94829-6630668564557491 Union St Apt 28, Eden Prairie, MN, 553650.56Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased
ENR-117998ENRMaria Mills2002-02-20UHC-87139-7995589961134692 Park Pl, Columbus, OH, 432110.56Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised
ENR-119323ENRShirley W Adams1972-07-20UHC-91288-4091595112748927 Ridge Rd, Houston, TX, 770700.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-102775ENRAmber Armstrong1991-11-26UHC-39729-71—145 Sage Ct # 117, Atlanta, GA, 303920.56Name re-casedTwo-digit birth yearPhone missing area codeUnit split from street
ENR-127706ENRDennis J Holmes1981-01-15UHC-23663-3490442373688792 Elm St, Miami, FL, 331530.56Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised
ENR-111649ENRRoy F Baker1988-08-17UHC-30265-0460991209163050 Elm St Apt 21, Phoenix, AZ, 850610.56Name split from “Last, First”Two-digit birth yearUnit split from streetEmail lower-cased
ENR-110493ENRRichard K Hayes1959-05-15UHC-24657-48—3622 Meadow Ln, Gilbert, AZ, 852690.56Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised
ENR-130484ENRSara K Roberts1950-08-19UHC-52367-8853888982227982 Maple Ave, Fresno, CA, 937990.56Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code
ENR-119105ENRLori F Hunt1990-05-24UHC-23583-9234284290514504 Forest Ave, Plano, TX, 750130.56Middle initial moved out of first nameTwo-digit birth yearStreet suffix standardisedAddress re-cased
ENR-121662ENRJudith Obrien1942-09-19UHC-60232-9951098203733631 Highland Ave, Tempe, AZ, 852330.56Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-107741ENRStephanie Cooper1971-11-02UHC-79625-8441832822389795 Broadway, Columbus, OH, 432910.56Name split from “Last, First”Date of birth reformattedState name converted to codeZIP+4 trimmed
ENR-115561ENRVicotria W Morales1951-10-05UHC-18505-7586444124607253 Spring St, Sacramento, CA, 958970.56Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised
ENR-131956ENRScutt Z Lawrence2002-08-06UHC-34761-115983835297823 Valley View Dr # 845, Tempe, AZ, 852810.56Two-digit birth yearPhone reformattedSSN last four extractedUnit split from street
ENR-139020ENRBradley Santiago1976-02-23UHC-26632-7792792464039398 Spring St, Fresno, CA, 937760.56Name split from “Last, First”City re-casedState name converted to codeZIP+4 trimmed
ENR-111531ENRCharles Russell—UHC-62543-1595797434107797 Central Ave, Tempe, AZ, 852530.56Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed
ENR-135642ENRJacob J Patterson1994-09-20UHC-78868-43—3426 Maple Ave, Dallas, TX0.56Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing
ENR-107017ENRAlbert J Li1973-10-24UHC-19977-9896390724351364 Park Pl, Charlotte, NC0.56Street suffix standardisedAddress re-casedState name converted to codeZIP missing
ENR-105175ENRTyler Wagner1952-07-18UHC-10977-6563091654748381 Main St, Gilbert, AZ, 852700.56Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code
ENR-107626ENRAlan Fox1965-06-19UHC-67661-8373591718672320 Main St, Glendale, AZ, 853910.56Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised
ENR-138297ENRSara Q Gutierrez1954-04-09UHC-54998-4593792774438912 Baseline Rd, Orlando, FL0.56Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
ENR-104663ENRJeffrey M Scott1991-03-07UHC-08770-76—8428 Washington St, Fresno, CA, 937880.56Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased
ENR-128842ENRMegan Q Burton1960-11-09UHC-99195-7747183904666057 Jefferson Ave, Los Angeles, CA, 900690.56Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+6 more
ENR-136374ENRTerry Ellis—UHC-09830-87—2093 Indian School Rd, Chandler, AZ, 852280.56Date of birth missingPhone missing area codeZIP+4 trimmedPlaceholder values cleared
ENR-116509ENRShirley C Ryan—UHC-99536-6462834900144300 Grand Ave, Tempe, AZ0.56Date of birth missingStreet suffix standardisedAddress re-casedZIP missing
ENR-139054ENRWalter Schultz1969-11-16UHC-56300-7047184512638527 Desert Sky Blvd, Denver, CO, 802840.56Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed
ENR-128340ENRIsabella X Pena1952-12-15UHC-37201-2440546702296705 Grand Ave, San Antonio, TX, 782970.56Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised
ENR-112531ENRValentina Rios1989-10-21UHC-36880-7345177718172665 Harbor Blvd, Orlando, FL, 328870.56Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-131561ENRWillie Rojas2006-11-19UHC-32937-0190899669534191 Palm Dr, Tempe, AZ, 852100.56Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed
ENR-117923ENRMary F Marquez—UHC-65462-14—9126 Union St, Atlanta, GA0.56Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing
ENR-128769ENRRandy O Williams1972-03-18UHC-07902-3476043903962660 Mountain View Dr, Columbus, OH, 432310.58Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+5 more
ENR-106371ENRWillie H Greene1988-07-26UHC-19975-5956822041728894 Union St, Charlotte, NC0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-133294ENRJeffrey E Myers1943-12-10UHC-57569-2878981487842112 Forest Ave, Tampa, FL, 336690.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-108576ENRAbigail Jacckson1970-06-20UHC-80175-9668574518992843 Bayshore Dr, Chandler, AZ, 852920.58Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-127840ENRChristian B Buttler1982-04-27UHC-45946-2227163177929899 River Rd, Glendale, AZ, 853720.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-112160ENRAbigail I Graham1955-08-18UHC-59485-9480569292048863 Ocean Ave, Dallas, TX0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-128744ENRJeremy T Flores1973-01-23UHC-14635-7875286527788701 Highland Ave, Columbus, OH, 432910.58Two-digit birth yearSSN last four extractedState name converted to code
ENR-108941ENRJacob W Jenkins1968-04-24UHC-53925-63—3294 Union St Apt 12, Glendale, AZ, 853550.58Phone missing area codeUnit split from streetGender normalised
ENR-108940ENRJacob W Jenkins1968-04-24UHC-53925-63—3294 Union St Apt 12, Glendale, AZ, 853550.58Phone missing area codeUnit split from streetGender normalised
ENR-115440ENRAnna O Edwards2007-08-12UHC-96929-2158886611534080 Palm Dr, Tucson, AZ, 857820.58Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-112580ENRNicole L Hayes1981-12-01UHC-37888-4538240244918810 Cedar Ln, Columbus, OH, 432090.58Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
ENR-107952ENRZachary G Morales1978-06-05UHC-64775-1460559276622616 Lincoln Way, Seattle, WA, 981230.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-103837ENRRebecca S Warren1997-04-06UHC-69309-05—7385 Market St, San Diego, CA, 921890.58Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-120291ENRAnglea Willis1984-11-27UHC-64489-2838922451364786 Hillcrest Rd, Seattle, WA, 981950.58Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
43,101 rows, page 112 of 863PreviousNext