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-50022TPAAndrea Murphy1945-01-09——3741 Spring St, Atlanta, GA, 303500.78Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-59745TPAAlexander Wells1997-01-06——5592 Broadway Apt 40, Los Angeles, CA, 900670.78Date of birth reformattedUnit split from streetCity re-casedEmail lower-cased+1 more
TPA-50810TPAJake Holmes1993-04-12——9299 Apache Blvd, Austin, TX, 787640.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56859TPAAustin Johnson2008-01-03UHC-23041-703726102415517 Mountain View Dr, Minneapolis, MN, 554400.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63072TPAAndrew Ford1967-04-18—25571900874446 Bayshore Dr, Scottsdale, AZ, 852660.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52155TPAJason Delgado1987-09-17—50049849823835 Spring St, Jacksonville, FL, 322940.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-52944TPABarbara Valdez1962-04-05UHC-84229-9544923528392787 Church St, Houston, TX, 770310.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51444TPABrruce Schultz1995-08-09—7342515216—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-57586TPAHannh Lucas1986-12-09UHC-54951-707145655361—0.78Name split from “Last, First”Phone reformattedMember ID reformattedWhitespace trimmed+1 more
TPA-52706TPAKayla Myers1980-11-25UHC-24038-47—3718 Church St, Tampa, FL, 336860.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61148TPAMadison Russsell1985-02-24—24721857797334 Mountain View Dr, Tucson, AZ, 857060.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50204TPACarol Price1952-02-15—8587886015288 Mountain View Dr, Seattle, WA, 981670.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62252TPAAdam Webb1998-12-15——8448 Meadow Ln, Seattle, WA, 981910.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62772TPAJanice Rose1962-07-21——4623 Highland Ave, Chandler, AZ, 852340.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51274TPAMary Wilson1988-12-11UHC-70575-82—7940 Ocean Ave, Atlanta, GA, 303900.78Member ID reformattedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-52457TPAMelissa Alexander2002-05-27—26099909226643 Broadway, Scottsdale, AZ, 852330.78Name split from “Last, First”Address re-casedState code upper-casedWhitespace trimmed+1 more
TPA-52154TPAJason Delgado1978-09-17—50049849823835 Spring St, Jacksonville, FL, 322940.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62049TPAChristine Wright1944-09-24——5725 Ocean Ave, Orlando, FL, 328570.78Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-57072TPACharles Marshall1967-01-01——8778 Valley View Dr, San Antonio, TX, 782080.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63942TPAPeggy Ortiz1991-11-07——3380 Mesa Dr, Houston, TX, 770530.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59530TPAAlexander Williamson1974-12-09—41581275703105 Highland Ave, Glendale, AZ, 853750.78Phone reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-63764TPAShirley Lee1955-01-13UHC-46809-42—429 Camelback Rd, Chandler, AZ, 852300.78Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-58582TPAPamela Cunningham1960-12-24UHC-98605-9881259875318681 Washington St, Scottsdale, AZ, 852940.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53453TPAJacqueline I Williamson1953-06-01—39969180341442 Canyon Rd, Las Vegas, NV, 891620.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58006TPAEmma G Cook1960-02-23——2069 Willow Ct, Houston, TX, 770960.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52327TPADiana Hill1999-04-05—8165362298—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-50439TPAJustin Ortiz1956-12-05———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-56588TPAAmanda Parker1947-02-27——2487 Apache Blvd, Denver, CO, 802040.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61029TPAMark Weber2004-03-02——7694 Central Ave, Scottsdale, AZ0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-56018TPARyan Harvey1976-06-26UHC-08814-34—5411 Harbor Blvd, Mesa, AZ, 852720.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60981TPADebra R Knight1992-04-27——4546 Church St, Tampa, FL, 336440.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59138TPADeborah Little2005-05-14—813789128016 Sunset Blvd, Miami, FL, 331250.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51117TPAKenneth Hughes1975-08-17——3248 Bayshore Dr, Miami, FL, 331150.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-63128TPAShirley Cunningham1973-12-10—59494054443784 Central Ave, Seattle, WA, 981670.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57526TPAChristina K Fox1971-08-23—82075441808318 Central Ave Apt 3, Dallas, TX, 752090.78Date of birth reformattedPhone reformattedUnit split from streetWhitespace trimmed+1 more
TPA-64472TPAWilliam Jordan1957-04-02——8101 Oak St, Houston, TX, 770650.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56204TPAElijah Hudson1967-07-17——4748 Apache Blvd, Nashville, TN, 372260.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60055TPADorotthy Price2007-01-05—60982746041418 Sunset Blvd, San Diego, CA, 921530.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-64021TPAKyle Oliver1974-12-19——16 Mesa Dr, Minneapolis, MN, 554280.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64432TPARandy Riley1975-07-01UHC-06936-5532551058082611 Jefferson Ave, Plano, TX, 750540.78Name re-casedPhone reformattedCity re-casedGender normalised+1 more
TPA-55799TPANathan Fernandez1993-03-22—59199239605278 River Rd, Jacksonville, FL, 322470.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61673TPAKevin Rios1985-03-20—2482016127—0.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-57648TPAJudith Castro1946-06-18—3389249418—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-59445TPANoah Torres1979-09-16——2460 Grand Ave, Eden Prairie, MN, 553250.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56635TPAAlbert Hall1981-10-24——8750 Central Ave, Tampa, FL, 336540.78Name re-casedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-57038TPAAlen Marquez2002-02-16UHC-88620-29—2304 Central Ave, Fresno, CA, 937420.78Street suffix standardisedAddress re-casedPlan code upper-casedWhitespace trimmed+1 more
TPA-62736TPASandra B Stewart1956-07-25—82575575537198 Harbor Blvd, Seattle, WA, 981400.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52102TPASean Hawkins1985-10-16——89 Desert Sky Blvd, Nashville, TN, 372320.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-53921TPAWalter Peterson1965-10-07—73956617634110 Spring St, Seattle, WA, 981440.78Phone reformattedSSN last four extractedCity re-casedWhitespace trimmed+1 more
TPA-50651TPAKimbberly Russell1995-05-06—3322823386—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
14,474 rows, page 158 of 290PreviousNext