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-121560ENRScott Lopez1953-08-14UHC-54516-93—7734 Hillcrest Rd, Tucson, AZ, 857380.52Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126627ENRSandra X Powell1996-04-25—97585055459548 Main St, Los Angeles, CA, 900260.52Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised+2 more
ENR-139115ENRKJunk1940-07-15UHC-71964-5387378102526331 Ocean Ave, Dallas, TX, 752910.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140741ENRAaron Freeman—UHC-00601-67—6995 Oak St, Mesa, AZ, 852160.52Name split from “Last, First”Date of birth reformattedDate of birth unreadablePhone missing area code+2 more
ENR-117654ENRMatthew Fwler1946-10-15UHC-68471-3366061374105316 Washington St, Chandler, AZ, 852350.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-119223ENRKJunk1971-03-15UHC-94640-273012390145547 Oak St, Plano, TX, 750880.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117649ENRJason Johnston1987-07-21UHC-86002-9696556558025392 Highland Ave, San Diego, CA, 921020.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-136096ENRSantiago V Gutierrez1969-07-10UHC-16012-725246898145851 Willow Ct, Dallas, TX0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117333ENRJunathan O James1965-04-14UHC-64223-13—4591 Mesa Dr, San Antonio, TX, 782880.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-142015ENRSamuel P Kim—UHC-44901-5762464473933839 Park Pl, Columbus, OH, 432160.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-127520ENRJoran Robinson1979-06-15UHC-00837-84—1116 Washington St, Tucson, AZ, 857850.52Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+2 more
ENR-108711ENRMartha S Young—UHC-71458-4022522118215367 Grand Ave, Tucson, AZ0.52Date of birth unreadablePhone reformattedCity re-casedState name converted to code+2 more
ENR-106351ENRAngela G Gordon1989-03-20UHC-91021-02—4781 Pine Dr, Miami, FL, 331080.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-123036ENRJennifer Dominguez1988-12-24UHC-64982-19327522690418 Meadow Ln Apt 16, Columbus, OH, 432630.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-103955ENRJuan S Silva1974-10-08UHC-07687-3365128263895111 Mountain View Dr Apt 2, Las Vegas, NV, 891750.52Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+2 more
ENR-135733ENRLawrence W Flores2008-06-27UHC-58157-26—7822 Oak St, Los Angeles, CA, 900240.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-109315ENRNatlaie T Moore2005-08-23UHC-14590-35313814566659 Mountain View Dr, Atlanta, GA, 303230.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112129ENRBenjamin Delgado2000-04-14UHC-96396-6375490415077626 Bayshore Dr, Houston, TX, 770960.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117643ENRSam N Harris1982-11-16UHC-32799-2940061196446925 Desert Sky Blvd, Scottsdale, AZ, 852700.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109153ENREthan Garza1967-07-06UHC-36481-2273889931552460 Lincoln Way, Tempe, AZ, 852060.52Name split from “Last, First”City re-casedState name converted to codeGender normalised+2 more
ENR-113412ENRChristina Burton1943-07-17UHC-38322-1658534746047991 Mesa Dr, Miami, FL, 331940.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-104913ENRHeather T Walsh1942-10-11UHC-45163-9892130222786927 Oak St, Eden Prairie, MN, 553650.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137458ENRJacqueline F Salazar1945-04-25UHC-37624-7751476559527958 Bayshore Dr # 730, San Antonio, TX, 782390.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-107264ENRBruce S Rammos1948-03-06UHC-52527-1537949855716296 Main St, Glendale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-121251ENRBobby Gray1981-10-12UHC-95919-3555279487236636 Ridge Rd, San Antonio, TX, 782870.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102693ENREmily Z Adams2000-07-22UHC-15907-1346663486589365 Sage Ct # 739, Orlando, FL, 328230.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-114119ENRShirley Armstrong1993-03-18UHC-87313-6626758318725754 Harbor Blvd, San Antonio, TX, 782240.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137255ENRRussell N Ford1949-11-02UHC-94139-91—5170 Apache Blvd, Jacksonville, FL, 322200.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
ENR-104545ENRLori N Duncan1965-10-18UHC-77386-40—2740 Oak St Apt 15, Plano, TX, 750930.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-108928ENRRandy L Sandoval1951-11-13UHC-38306-8094435151975598 Canyon Rd, Denver, CO, 802350.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-118396ENRNathan Y Howell1991-01-14——3009 Harbor Blvd, San Antonio, TX, 782370.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-141531ENRKayla Rojas1944-07-13UHC-54092-53—6042 Church St, Tucson, AZ, 857850.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-123072ENRAlan Gibson2000-06-13UHC-40231-8034426072186176 Mountain View Dr # 875, Fresno, CA, 937400.52Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+2 more
ENR-125568ENRCharlotte Weber—UHC-81561-0674453283436065 Sage Ct, Scottsdale, AZ, 852650.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-125032ENRKathy W Perry1973-08-28UHC-08328-1289770801436377 Park Pl, Nashville, TN0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-108654ENRBrenda Bradley1954-10-17UHC-06264-5261675243125192 Meadow Ln, Jacksonville, FL, 322420.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-114012ENRJoshua D Rogers1964-01-23UHC-33304-4878924933547625 Maple Ave, San Diego, CA, 921870.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-101719ENRRaymond U Foster1973-06-17UHC-62692-5528698694049571 Sunset Blvd, Jacksonville, FL0.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-142778ENRSamantha Johnston1973-06-25UHC-14942-21—6942 Valley View Dr, Eden Prairie, MN0.52Two-digit birth yearState name converted to codeZIP missingEmail lower-cased+2 more
ENR-101492ENRSoifa Lewis1968-03-02UHC-63635-5896279272909224 Bayshore Dr, Mesa, AZ, 852140.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-136446ENRSophia A Nguen1979-10-14UHC-35591-59—1745 Highland Ave, Miami, FL, 331190.52Name re-casedTwo-digit birth yearPhone missing area codeEmail lower-cased+2 more
ENR-102927ENROlivia Hart1976-10-26UHC-78547-45—9622 Highland Ave, Houston, TX, 770170.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-120835ENRGabriel Hawkins1949-12-22UHC-32513-5286434193263579 Desert Sky Blvd, San Antonio, TX, 782170.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-110044ENREric U Banks1956-02-08UHC-92677-899595534496776 Central Ave, Gilbert, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-102513ENRJames E Montgomery1987-04-13UHC-66712-6576779096992804 Central Ave, Charlotte, NC, 282980.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-140129ENRJoan Hudson1956-12-10UHC-12759-1386222996448106 Ridge Rd Apt 6, Tempe, AZ, 852850.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-100508ENRAna Morales1955-09-19UHC-77060-0677841962741236 Valley View Dr, Scottsdale, AZ, 852470.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-123749ENRSantiago Martinez1959-06-09UHC-34421-47—225 Harbor Blvd, Minneapolis, MN0.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-115549ENRSamantha V Romero1976-08-07UHC-70881-286645502381909 Lincoln Way Apt 33, Minneapolis, MN, 554470.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-122296ENRGregory Woods—UHC-74086-9385441623562736 Oak St, San Diego, CA0.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
43,101 rows, page 94 of 863PreviousNext