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-112430ENRBobby Hernandez1974-07-03UHC-97966-7130224288036500 Harbor Blvd, Orlando, FL, 328490.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127109ENRAlice Mendoza1973-07-01UHC-85886-8431637853734821 Cedar Ln, Atlanta, GA, 303360.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-109813ENRMason Ramirez1964-05-03UHC-58089-01—3165 Spring St, Fresno, CA, 937690.48Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
ENR-103209ENRKeith Mills1940-08-12UHC-71507-3791351906873588 Canyon Rd, Plano, TX0.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-114695ENRJonathan W Lawson1945-03-06UHC-79224-89856414071612 Forest Ave, San Antonio, TX, 782100.48Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-111556ENRNathan Rose1964-05-05UHC-57831-42—439 Baseline Rd, Denver, CO0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-115169ENRLogan N Collins—UHC-11070-9951140081049814 Pine Dr, Las Vegas, NV, 891370.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-107032ENRNicole Hanson2006-01-09UHC-87068-6257685262523984 River Rd, Jacksonville, FL, 322170.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120857ENRJordan Carroll1999-11-13UHC-70296-2993278090773188 Desert Sky Blvd, Atlanta, GA, 303570.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127700ENRJoyce S Perez1958-08-13UHC-34295-4568644138468692 Hillcrest Rd, Miami, FL, 331060.48Date of birth reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-129439ENRElijah Cerr1980-02-25UHC-17312-6153567709328995 Sunset Blvd, Miami, FL, 331570.48Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-126821ENRJesse Thomas1968-01-15UHC-48971-2938661484781706 Valley View Dr, Miami, FL, 331680.48Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-101268ENRJoan Singh1960-03-25UHC-03484-7672489196135676 Palm Dr # 496, Eden Prairie, MN, 553170.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-100284ENRGeorge R Knight1976-08-20UHC-05781-7840343275145156 Palm Dr, Gilbert, AZ0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-121912ENRKathryn Y Perkins1951-10-26UHC-15775-3432148502668788 Highland Ave, Charlotte, NC0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-139904ENREmily F Ortiz1959-03-07UHC-21261-5871454289209081 Willow Ct # 686, Charlotte, NC, 282030.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-114765ENRRussell V Donald1974-02-22UHC-63213-4674929272205913 Maple Ave, Houston, TX, 770460.48Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-102535ENRLisa L Thompson1939-05-26UHC-64914-6493245476586126 Ridge Rd # 441, Houston, TX, 770960.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-115085ENRVictoria O Cooper1960-10-11UHC-00539-4933239981496043 Forest Ave, Charlotte, NC0.48Name re-casedSSN last four extractedCity re-casedState name converted to code+4 more
ENR-125753ENRLaura OJunk1969-02-08UHC-98868-6731546338832369 Bayshore Dr, Dallas, TX, 752530.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-103126ENRLori King1957-04-06UHC-92761-5834124088983025 Lake View Rd, Jacksonville, FL0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124214ENRHelen Oliver1978-08-26UHC-84939-8074466773287301 Church St, Columbus, OH, 432500.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-101152ENRFatima E Nguyen1984-03-14UHC-77642-9598044925782819 Palm Dr Apt 39, Houston, TX, 770800.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-118950ENRJacqueline E Spencer—UHC-18603-59—1667 Camelback Rd, Tampa, FL, 336220.48Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
ENR-142146ENRMargaret M Stone1939-12-20UHC-82602-399749293907854 River Rd, Phoenix, AZ, 850410.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-123326ENRElizabeth Pierce1956-05-17UHC-85478-5075363615571579 Union St, Gilbert, AZ, 852670.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-114497ENRRoger Nunez1974-03-26UHC-36065-0687198461547888 Market St, Glendale, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-121465ENRAlexander Sttone1954-02-21UHC-79178-97—5648 Harbor Blvd, Atlanta, GA, 303520.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-124990ENRHelen G Mendez1949-07-10UHC-76991-2452797637138102 Market St # 888, Glendale, AZ, 853000.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-115800ENRJesse N Pena—UHC-04366-25—2100 Jefferson Ave, Charlotte, NC, 282200.48Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
ENR-131628ENRAisha Harvey1979-02-02UHC-39601-0922929882334208 Main St, Dallas, TX, 752110.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124527ENRLuis S Nichols1972-03-13UHC-68522-2725182779993220 Apache Blvd, Nashville, TN, 372810.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-123382ENRBrandon Harper1987-08-21UHC-68742-3729094778436786 Willow Ct, Gilbert, AZ0.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-114247ENRAisha Allen1956-12-26UHC-82372-2687342716015681 Hillcrest Rd, Dallas, TX, 752880.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-135183ENRJoe C Harvey1970-03-07UHC-23152-2060540236987400 Spring St, Orlando, FL, 328900.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-111553ENRLarry Murphy—UHC-56832-3662398916475457 Harbor Blvd, Tempe, AZ, 852110.48Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-119733ENRBrenda P Martin1947-08-27UHC-38052-6632870576411423 Forest Ave, Charlotte, NC0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-111542ENRAustin X Bryant1982-03-20UHC-43474-7852755598753056 Willow Ct, Houston, TX, 770080.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-134491ENRMartha U Richardson2002-07-26UHC-71174-1953379514623299 Ocean Ave Apt 29, Glendale, AZ, 853600.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-100369ENRCharltote M Oritz2002-10-16UHC-52389-49—7944 Canyon Rd, Columbus, OH, 432390.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-133993ENRSophia G Walker1996-05-18UHC-84938-9398196777722087 Highland Ave, Las Vegas, NV, 891400.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-105739ENRKyle Shaw1944-01-27UHC-46000-39—9403 Washington St, Charlotte, NC, 282720.48Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-123938ENRStephanie O Grant2000-05-13UHC-90074-5567765542253746 Maple Ave # 831, San Antonio, TX, 782430.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
ENR-113181ENRSofia Weaver1968-06-05UHC-51460-0835936018261381 Union St # 767, Mesa, AZ, 852340.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-111572ENRVincent R Shaw1984-04-27—77226736293323 Church St, Eden Prairie, MN, 553940.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104485ENRSamuel Le1988-05-21UHC-07604-1173681418238848 Cedar Ln # 856, Columbus, OH, 432290.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-133216ENRPeter N Walsh2004-07-27UHC-87363-5942549942403658 Meadow Ln, Tempe, AZ, 852080.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-103817ENRGregory Hudson2001-05-05——3589 Spring St, Tucson, AZ, 857010.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-110651ENRAlbert S Morrison1992-12-06UHC-99651-9977030167757326 Harbor Blvd, Mesa, AZ, 852350.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120594ENRMaria Rios1988-04-10UHC-61386-44—9019 Cedar Ln, Sacramento, CA, 958030.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
43,101 rows, page 39 of 863PreviousNext