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-121058ENRArthur R Jones1952-10-25UHC-47132-0569171331016332 Camelback Rd, Tucson, AZ, 857050.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-112896ENRVirginia X Fox1962-11-23UHC-87518-0684154768105562 Grand Ave, Miami, FL, 331430.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-110142ENRRaymond Banks2004-07-09UHC-53680-5188234346832102 Central Ave # 626, Denver, CO, 802360.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-108962ENRNancy H Spencer2009-09-06UHC-62462-1768037610986931 Ocean Ave, Charlotte, NC, 282550.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-142910ENRDouglas Berry1969-10-11UHC-83888-3988632846621607 Lake View Rd, Jacksonville, FL, 322700.62Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more
ENR-122841ENRElizabeth Gibson1955-05-15UHC-53210-523338331944833 Sage Ct, Tampa, FL, 336610.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112077ENRCheryl M Riley1984-03-14UHC-78761-1547966055661550 Spring St, Eden Prairie, MN, 553850.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123592ENRDaniel G Marquez1957-01-11UHC-27316-1343241133584511 Meadow Ln, Tampa, FL, 336640.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114396ENRJanice O Holmes1981-12-11UHC-67731-098938854425638 Elm St, San Antonio, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134012ENRAnna G Hart1988-05-13UHC-08766-7942137933748807 Mesa Dr, San Antonio, TX, 782530.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-139824ENRDiego H Contreras1948-02-23UHC-46032-0659448155552310 Forest Ave, Eden Prairie, MN, 553600.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137218ENRRaymond T Gzman1991-02-02UHC-14684-4236065114352259 Union St, Seattle, WA, 981730.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130335ENRJennifer U Weaver1966-01-21UHC-23136-2651794453378978 Oak St, Denver, CO0.62Date of birth reformattedPhone reformattedMember ID reformattedState name converted to code+3 more
ENR-111081ENRAnthony E Henderson1989-01-09UHC-92935-4722622703413140 Central Ave, Tucson, AZ, 857010.62Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-107703ENRMgan N Wilson1938-09-13UHC-23279-4456931762339365 Jefferson Ave, Gilbert, AZ, 852780.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123288ENRWei G Harris1954-03-16UHC-52056-9453947487605028 Ridge Rd, Columbus, OH, 432120.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120463ENRJaon W Riios2008-12-12UHC-15718-0421858547933062 Grand Ave, Chandler, AZ, 852160.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100504ENRGrace Soot1946-03-03UHC-54130-5042389276174634 Forest Ave, Orlando, FL, 328190.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-103883ENRGary B Barnes1956-08-21UHC-36095-5760576124714992 Ridge Rd, Mesa, AZ, 852650.62Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-128197ENRLogan F Mills2004-06-12UHC-21983-8957799044283968 Grand Ave # 848, Sacramento, CA, 958510.62Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-103900ENRSamuel Ortiz1965-08-20UHC-34784-0826570979425149 Jefferson Ave, Fresno, CA, 937850.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-135693ENRJoe Rose1951-06-22UHC-91305-4694750849669445 Hillcrest Rd, Plano, TX, 750630.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-140022ENRRay Peters1972-08-03UHC-72190-33—2221 Lake View Rd, Austin, TX, 787320.62Name re-casedDate of birth reformattedMember ID reformattedSSN last four extracted+3 more
ENR-112102ENRSantiago Ris2000-12-27UHC-32377-672939297477337 Elm St Apt 2, Glendale, AZ, 853240.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-141092ENRSarah Turner1985-04-22UHC-91678-0879193487612910 Valley View Dr # 747, Columbus, OH, 432200.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-115668ENRJean P Parker1969-10-17UHC-94740-7172345867221308 Church St, Mesa, AZ, 852740.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-112169ENRBrian P Contreras1961-03-10UHC-53081-0165798091213766 Ridge Rd Apt 30, Houston, TX, 770240.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-140887ENRAhmed J Castro1947-09-25UHC-57979-5052334841647417 Park Pl, Tucson, AZ, 857630.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109353ENRMateo Taylor1978-02-24UHC-48830-6886733240344707 Church St, Denver, CO, 802030.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126869ENRArjun F Lawrence1984-05-05UHC-29118-42—6371 Sage Ct, San Antonio, TX, 782940.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-121099ENRCheril I Rose1998-08-22UHC-60983-94—1514 Church St, Houston, TX, 770170.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124225ENRMartha T Castro1983-04-01UHC-41311-3022070658265565 Hillcrest Rd, Nashville, TN, 372340.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-119014ENRAshley Mejia1941-02-15UHC-36724-7259843040731713 Union St, Austin, TX, 787330.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129024ENRJason Espinoza1941-09-04UHC-85301-174345411814764 Indian School Rd, Dallas, TX, 752020.62Date of birth reformattedPhone reformattedMember ID reformattedZIP+4 trimmed+3 more
ENR-108038ENRTeresa Reid1988-07-24UHC-23512-0461663251397882 Market St # 374, Nashville, TN, 372570.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-121060ENRAustin Stevens1960-06-14UHC-43550-7655670499682950 Spring St, Mesa, AZ, 852680.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100404ENRWalter E Coleman2005-01-12UHC-49325-18—4570 Ocean Ave, Austin, TX, 787860.62Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
ENR-100221ENRJustin D Espinoza1972-09-14UHC-99989-0347987316072598 Elm St, Eden Prairie, MN0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115678ENRGeorge Tucker1943-03-16UHC-44073-6325449308398913 Ocean Ave, Austin, TX0.62Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
ENR-119473ENRWilliam Nelson1969-02-23UHC-40816-5441745857523672 Main St, San Antonio, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142359ENRRachel Wallace1996-08-06UHC-99092-84—1465 Camelback Rd, Minneapolis, MN, 554500.62Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-132485ENRValentina L Roberts1942-02-27UHC-23942-7634840159343276 Highland Ave, Fresno, CA, 937840.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127707ENRMadison I Fisher1940-11-14UHC-88122-62—2191 River Rd, Tampa, FL, 336750.62Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-121475ENRHiroshi Z Sanchez1999-06-15UHC-87722-88—5705 Union St, Sacramento, CA, 958090.62Name re-casedDate of birth reformattedCity re-casedState name converted to code+3 more
ENR-110532ENRBrian C Schmidt1958-10-15—58828853131569 Sunset Blvd, Tempe, AZ, 852960.62Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more
ENR-107228ENRSophia Green1975-07-06UHC-94628-7988159923472872 Forest Ave, Las Vegas, NV0.62Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-138645ENRRichard Q Wheeler1945-09-02UHC-39801-4686795403044484 Valley View Dr, Charlotte, NC, 282160.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111498ENRJerry Scott2004-10-26UHC-49219-1830529593678838 Baseline Rd, Nashville, TN, 372490.62Member ID reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
ENR-127942ENRVincent Diaz1958-10-01UHC-09083-9133378186128104 Lincoln Way # 427, Seattle, WA, 981470.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-113158ENRLarry B Ford1953-07-21UHC-19018-0566379651035272 Maple Ave, Tempe, AZ, 852450.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 137 of 863PreviousNext