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-128931ENRJanet Tran1986-08-20UHC-03218-9667090171222658 Broadway, Phoenix, AZ, 850180.62Two-digit birth yearPhone reformattedAddress re-casedCity re-cased+3 more
ENR-132200ENREmma Carter1944-09-24UHC-03566-3282244168652297 Elm St, San Diego, CA, 921170.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129720ENRHeather P Cook1973-01-10UHC-56657-2021994150626040 Mountain View Dr, Tampa, FL, 336720.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-131846ENRJoe Bishop1988-10-18UHC-08767-4852791546206422 Harbor Blvd, Nashville, TN, 372730.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-102143ENRNicholas Long2005-07-10UHC-15445-0825147246158095 Main St, Orlando, FL, 328010.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-106875ENRDanielle Silva1965-11-19UHC-68389-9139241901471052 Jefferson Ave, Phoenix, AZ0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-106311ENRAnn Castro1960-02-13UHC-12437-5939681113938739 Sunset Blvd # 811, Columbus, OH, 432150.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-133645ENRWillie Richardson1974-11-11UHC-00108-3561524212621339 Cedar Ln, Austin, TX, 787030.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108093ENRCarol J Allen1949-11-14UHC-29947-5250989353036323 Elm St, Mesa, AZ, 852570.62Name re-casedPhone reformattedCity re-casedState name converted to code+3 more
ENR-106406ENRJulia G Gardner1971-04-02UHC-75422-8575075521724318 Park Pl, Tampa, FL0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-112687ENRGeorge D Hernandez1951-04-18UHC-03121-8655434912265190 Hillcrest Rd # 802, Chandler, AZ, 852350.62Name re-casedPhone reformattedUnit split from streetCity re-cased+3 more
ENR-124518ENRRussell Avarado1957-01-28UHC-65013-7040159393608197 River Rd, Gilbert, AZ, 852500.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-142113ENRWliliam J Jordan1990-02-22UHC-70177-7180136800901244 River Rd, Glendale, AZ, 853290.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-142114ENRWliliam J Jordan1990-02-22UHC-70177-7180136800901244 River Rd, Glendale, AZ, 853290.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-136033ENRMari Y Wright1998-06-04UHC-40044-2898376228811445 Baseline Rd, Austin, TX, 787900.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-122816ENRAlexis J West1996-10-23UHC-01606-3438661295305812 Church St, Dallas, TX, 752640.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-103078ENRBernda G Le1970-07-25UHC-89078-7530263355754818 Ocean Ave, Fresno, CA, 937850.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125695ENRBradley J Santos—UHC-59865-8436240431388363 Sage Ct, Phoenix, AZ, 850790.62Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+3 more
ENR-107189ENRBetty B Rojas1989-12-03UHC-73203-9661335971908374 Grand Ave, Dallas, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130142ENRMason L Esspinoza1994-02-10UHC-05793-04—8800 Sage Ct, Eden Prairie, MN, 553580.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135705ENRKim Luacs1954-06-01—25124505963323 Bayshore Dr # 545, Tucson, AZ, 857370.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-102550ENRLucia B Vargas1975-11-13UHC-57841-4258976258244762 Lake View Rd, Jacksonville, FL, 322010.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-109425ENRFrank L Cartar1989-09-19UHC-96878-7768739639698971 Market St, Tempe, AZ, 852100.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-141325ENRLori E Mason—UHC-67088-66—6710 Main St, Seattle, WA, 981280.62Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
ENR-122917ENRBradley Y Ramirez2001-02-14UHC-95752-2094789061921256 Canyon Rd Apt 7, Mesa, AZ, 852610.62Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130420ENRRaymond I Snyder1975-01-06UHC-68621-7970753182912895 Park Pl, Denver, CO, 802800.62Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more
ENR-121505ENRDeborah K Jamse1944-12-13UHC-46277-475233074985335 Indian School Rd, Tempe, AZ, 852850.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-136503ENRCarol E Stevens1947-08-14UHC-99194-4378139583415527 Highland Ave, Eden Prairie, MN, 553210.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104705ENRJeffrey B Butler1961-04-09UHC-23786-415206609486689 Church St, Fresno, CA, 937650.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-108266ENRCJunk1953-10-08UHC-26846-5694152820953747 Ocean Ave, San Antonio, TX, 782460.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134054ENRDavid Powell1977-12-09UHC-52885-0720355836752066 Palm Dr, Miami, FL, 331770.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-128075ENRMarilyn E Herrera1950-01-20UHC-81602-2736854674337170 Meadow Ln, Plano, TX, 750600.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-100595ENRShirley B Ray1966-11-12UHC-66697-86—1778 Cedar Ln # 406, Glendale, AZ, 853830.62Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+3 more
ENR-100594ENRShirley B Ray1966-11-12UHC-66697-86—1778 Cedar Ln # 406, Glendale, AZ, 853830.62Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+3 more
ENR-129799ENRFatima U Alvrado1954-04-01UHC-94101-3621888045202711 Desert Sky Blvd, Chandler, AZ, 852770.62Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+3 more
ENR-130467ENRJustin Tucker1968-12-26UHC-61253-6166034133577759 Forest Ave, Denver, CO, 802310.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-127723ENRRobert Z Perez1995-06-13UHC-74612-059224637523309 Church St, Phoenix, AZ, 850670.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125379ENRCrhistina Foster1940-05-04UHC-20894-6369030746331579 Church St, Plano, TX, 750520.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-104049ENRSofia O Jordan2004-12-20UHC-64020-4043224379698382 Church St, Plano, TX0.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-130553ENRHannah Z Yang1960-11-12UHC-38205-9086285638449744 Church St, Tucson, AZ, 857130.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134932ENRJanet Delgado1978-07-16UHC-23589-5096083194182078 Willow Ct, Los Angeles, CA0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110250ENRJesse H McCoy1975-02-20UHC-92772-9593428040517398 Oak St, Charlotte, NC, 282460.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-110249ENRJesse H McCoy1975-02-20UHC-92772-9593428040517398 Oak St, Charlotte, NC, 282460.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-133034ENRDouglas M Ford1943-10-27UHC-73862-0395567220868892 Willow Ct, Mesa, AZ, 852040.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122132ENRLarry V Cunningham1981-10-10UHC-55343-9638237702992368 Canyon Rd, Tucson, AZ, 857210.62Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122129ENR—Junk1978-03-13UHC-39687-1744522929002215 Valley View Dr, Orlando, FL, 328580.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-104409ENRSamantha K Ryan—UHC-28334-4866852378234238 Pine Dr, San Antonio, TX, 782980.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-104728ENREmily V Le1997-12-09UHC-71304-1592192778477478 Oak St, Minneapolis, MN, 554790.62Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-135734ENRAhmed D Carter1994-10-16UHC-42546-6852450892895512 Sunset Blvd, Minneapolis, MN, 554140.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-103131ENRKaren Little1995-03-03UHC-06105-7973521929838088 Sunset Blvd, Eden Prairie, MN0.62Name re-casedPhone reformattedMember ID reformattedCity re-cased+3 more
43,101 rows, page 138 of 863PreviousNext