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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-63080TPAHansen Linda1941-10-09UHC-10492-62—6644 Union St, Houston, TX, 770220.80Date of birth reformattedCity re-casedGender normalisedPlaceholder values cleared
TPA-62384TPABenjamin Simmons1971-06-14UHC-86087-23—8450 Camelback Rd, Gilbert, AZ, 852240.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51436TPABeverly Flores1948-09-02——107 Pine Dr, Las Vegas, NV, 891480.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53428TPAHenry Cruz1938-06-10——8192 Apache Blvd, Los Angeles, CA, 900800.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51710TPALaura Hunt1976-05-20UHC-71086-48—8673 River Rd, Atlanta, GA, 303390.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-52412TPAAlbertJunk1974-11-08—81787941716938 Camelback Rd, Atlanta, GA, 303090.80Name re-casedPhone reformattedPlaceholder values clearedNo usable name (quarantined)
TPA-63970TPATerry Hansen——8696771414—0.80Date of birth reformattedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-60988TPAMei Alvarado1943-12-01UHC-70588-83—6950 Elm St, Fresno, CA, 937010.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61792TPAKelly Richardson1957-03-09———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63393TPAAnn Williamson1963-02-12——567 Meadow Ln, Atlanta, GA, 303220.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57118TPAWalter Garcia1973-08-07——723 Maple Ave, Miami, FL, 331170.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58780TPAJohn Mendez1971-06-11——4815 Pine Dr, Chandler, AZ, 852800.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57387TPAZachary Kennedy2001-01-05——505 Oak St, Mesa, AZ, 852970.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-55851TPAFrank F Alexander1999-12-26——2263 Washington St, Phoenix, AZ, 850220.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53977TPAAna D Jackson1950-11-11——9519 Indian School Rd, Tucson, AZ, 857680.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57226TPAJudith Owens1954-02-15UHC-36194-2761077561681095 Willow Ct, Las Vegas, NV, 891640.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-57069TPAMichelle Taylor2003-11-02——9367 Park Pl, Tucson, AZ, 857900.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55699TPASandra Ngyen1962-09-03——7065 Sunset Blvd, Columbus, OH, 432200.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52508TPAJon Foster1953-09-06—94932971847387 Lake View Rd, Charlotte, NC, 282840.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-58767TPALinda Yang1984-09-27——1067 Washington St, Seattle, WA, 981550.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59234TPALinda Hart1951-12-22———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-51569TPABrandon V Lopez1955-02-03UHC-50184-1532931678661851 Market St # 764, Mesa, AZ, 852850.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-62577TPAKyle Brown2002-05-02———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62578TPAKyle Brown2002-05-02———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62341TPADiane A Stephens1965-11-18—24057885236459 Grand Ave, Phoenix, AZ0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-63928TPAAhmed Young1946-04-02——1525 Pine Dr, Scottsdale, AZ, 852260.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-63927TPAAhmed Young1946-04-02——1525 Pine Dr, Scottsdale, AZ, 852260.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-62402TPABeverly Romero1974-10-21——6971 Jefferson Ave, Las Vegas, NV, 891150.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62403TPABeverly Romero1974-10-21——6971 Jefferson Ave, Las Vegas, NV, 891150.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63619TPASarah Guzman1987-10-28UHC-17666-83—615 Broadway, San Diego, CA, 921470.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61655TPAShirley Soto1948-09-15UHC-96595-3132742110756577 Baseline Rd Apt 20, Nashville, TN, 372170.80Date of birth reformattedPhone reformattedUnit split from streetPlaceholder values cleared
TPA-55515TPAAmber Castro1997-08-04——6391 Elm St, Atlanta, GA, 303580.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57247TPALaura I Herrera1959-06-27UHC-79427-432112781293—0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-56955TPAAmber Jones1998-10-18UHC-67006-65—8598 Sage Ct, Nashville, TN, 372230.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-63498TPAChris Stephens2002-06-22—38757595928367 Oak St, Miami, FL, 331860.80Phone reformattedCity re-casedState name converted to codePlaceholder values cleared
TPA-63747TPAJesse Z Allen1954-12-09——9067 Willow Ct, San Antonio, TX, 782280.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58496TPAAnn Kennedy1955-04-17——5760 Cedar Ln, Chandler, AZ0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-59734TPAEmily Fuller1986-02-02——5531 Baseline Rd, Tampa, FL, 336710.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-57269TPAMadison Meyer1954-09-22——6065 Ridge Rd, Tampa, FL, 336150.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
TPA-58601TPAAngela Flores1985-04-07—93841763037310 Jefferson Ave, Charlotte, NC, 282310.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-60919TPABobby Riley1960-03-26UHC-22969-34—2284 Main St, Denver, CO, 802050.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54507TPAJessica M Soto1971-04-14———0.80Name split from “Last, First”Date of birth reformattedPlan code upper-casedPlaceholder values cleared
TPA-60622TPAEspinoza Mark1949-06-23UHC-64946-78—6788 Ocean Ave Apt 22, Mesa, AZ, 852590.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-56777TPABetty Howell1945-07-07UHC-85571-97—7429 Canyon Rd, Fresno, CA, 937230.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50230TPAGeorge Nichols1992-08-10——6925 Harbor Blvd, Columbus, OH, 432340.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60533TPALori Yang1974-08-09—71747544655415 Forest Ave, Dallas, TX, 752730.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-60082TPARuth Jackson2003-08-16—72481215024532 Jefferson Ave, Mesa, AZ, 852360.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
TPA-64098TPAJohn T Snyder1971-02-14——3129 Desert Sky Blvd, Austin, TX, 787870.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62324TPAMary Herrrera1973-03-20——7943 Palm Dr, Houston, TX, 770400.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-56877TPAAhmed Meyer1980-10-19—25552110625017 Canyon Rd, Miami, FL, 331300.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 162 of 290PreviousNext