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-57134TPABrandon Garcia1945-12-04—9413637070—0.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
TPA-51583TPAEveyn Ray1941-10-09——1967 Camelback Rd, Eden Prairie, MN, 553300.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-56239TPAAna Willis1954-03-06——7807 Apache Blvd, Chandler, AZ, 852100.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-50396TPARaymond Walker2005-07-26——1409 Washington St, Mesa, AZ, 852470.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
TPA-54656TPAFatima McDonald1941-06-09——4487 Washington St, Los Angeles, CA, 900560.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54125TPABecky Campbell1953-05-09—7623964285—0.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
TPA-62920TPATim Andrews2004-10-24—62958660918479 Market St, Gilbert, AZ, 852930.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-62621TPASamuel Medina1943-08-15—87347189451746 Grand Ave, Sacramento, CA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-62550TPARichard Rice1977-10-05—52688448052371 Mesa Dr, Plano, TX, 750100.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-62195TPANathan Wong2001-08-11—76224124397166 Sage Ct, Phoenix, AZ, 850840.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-62461TPADylan A Greene1964-02-10——8214 Mesa Dr, Gilbert, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-59784TPAJanet Morgan1968-04-24——2596 Sunset Blvd, Chandler, AZ0.66Name split from “Last, First”Date of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-54003TPAKyle Day———1724 Jefferson Ave, San Diego, CA, 921880.66Name split from “Last, First”Date of birth unreadableCity re-casedWhitespace trimmed+1 more
TPA-55620TPAJack P Wells1996-07-24——3646 Sunset Blvd, Tempe, AZ, 852490.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61025TPAJoyce B Jaes1976-07-06——6288 Lake View Rd, Tampa, FL0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
TPA-59685TPAMichael Patterson——79885016421907 Lincoln Way, Los Angeles, CA, 900830.66Name split from “Last, First”Date of birth unreadableCity re-casedWhitespace trimmed+1 more
TPA-53963TPANoah Robinson1979-07-12——6750 River Rd # 206, Denver, CO, 802380.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-60758TPAAndrea Bryant1955-03-03—49533356042442 Church St, Las Vegas, NV0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-51170TPAMarcus Richards2008-01-28——8720 Market St, Atlanta, GA, 303820.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-56701TPADonald Fowler2005-03-25UHC-20542-5222640094818557 Central Ave Apt 23, Eden Prairie, MN, 553690.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-51772TPAJeremy Richards1990-07-11——9885 Union St, Atlanta, GA, 303940.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-53684TPAJackie Grant1978-12-02UHC-43018-83—925 Indian School Rd, Minneapolis, MN, 554180.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52905TPANency Andrews1983-12-26——627 Grand Ave, Glendale, AZ, 853550.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-58313TPASean Reynolds1989-10-25—57828816717232 Broadway Apt 17, Charlotte, NC, 282980.66Phone reformattedUnit split from streetState name converted to codeWhitespace trimmed+1 more
TPA-64252TPAAmy C Bowman2001-08-19UHC-43285-35—6542 Valley View Dr, Eden Prairie, MN, 553680.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
TPA-61239TPALauren Schmidt1958-01-11—49446513906676 Central Ave, Austin, TX, 787410.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-62998TPATheresa Carter1968-12-13UHC-04988-64—4683 Palm Dr, Chandler, AZ, 852620.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60017TPACheryl Barnes1966-10-02——6986 Mountain View Dr # 845, Tempe, AZ, 852860.66Name re-casedDate of birth reformattedUnit split from streetState name converted to code+1 more
TPA-52064TPAKaren Walker1965-08-19——8920 Grand Ave, Denver, CO, 802880.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60591TPAAlice Russell1976-09-09——1599 Bayshore Dr, Orlando, FL, 328900.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-60590TPAAlice Russell1976-09-09——1599 Bayshore Dr, Orlando, FL, 328900.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-52576TPADavid Lewis1981-04-09——5645 Apache Blvd, Eden Prairie, MN, 553660.66Two-digit birth yearStreet suffix standardisedAddress re-casedPlan code upper-cased+1 more
TPA-54227TPAAlan V Brown1974-07-24——7523 Central Ave, Tempe, AZ, 852340.66Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+1 more
TPA-55072TPAJuan Beell1953-01-03——8862 Hillcrest Rd, Phoenix, AZ, 850210.66Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-58559TPAJeffrey Wells1992-03-12——6803 Apache Blvd, San Antonio, TX0.66Two-digit birth yearState code upper-casedZIP missingWhitespace trimmed+1 more
TPA-59769TPAAlice W Graham——6428106306952 Hillcrest Rd, Las Vegas, NV, 891210.66Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62815TPAAndrea Morrison1968-07-20——7960 Jefferson Ave # 395, Houston, TX, 770950.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60114TPAHannah S Bailey1947-05-14——1908 Forest Ave # 695, Houston, TX, 770760.66Date of birth reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
TPA-64167TPACatherine Allen1954-03-19——9190 Harbor Blvd # 115, San Antonio, TX, 782350.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-58107TPAJerry Patel———8468 Lake View Rd, Minneapolis, MN, 554270.66Name split from “Last, First”Date of birth unreadableCity re-casedEmail lower-cased+1 more
TPA-63432TPABradley Larson1960-11-16—20331072969556 Maple Ave, Phoenix, AZ0.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62033TPAKevin Nguyen1977-12-18UHC-97416-97—3474 Palm Dr, Tempe, AZ, 852820.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-64089TPAMaria Moore1952-08-07——3317 Lincoln Way, Atlanta, GA, 303690.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50406TPAJustin Gordon2006-04-25UHC-77734-8397282131359124 Union St, Glendale, AZ, 853880.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53829TPABrenda Jimenez1946-09-24——3317 Mountain View Dr, Atlanta, GA, 303150.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-59960TPAJose Torres1962-07-26—79868012905904 Desert Sky Blvd, Eden Prairie, MN, 553890.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60097TPAOmar Schultz1966-11-10UHC-58276-63—6554 Park Pl, Austin, TX0.66Two-digit birth yearCity re-casedZIP missingWhitespace trimmed+1 more
TPA-51474TPAEmily Stone1960-03-28——2674 Baseline Rd, Los Angeles, CA, 900760.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57926TPAJoseph Romero1989-01-14—4585417086390 Mesa Dr, Miami, FL, 331210.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57964TPATurner Kayla1972-08-22——2610 Sunset Blvd, Minneapolis, MN0.66Name re-casedState name converted to codeZIP missingWhitespace trimmed+1 more
14,474 rows, page 74 of 290PreviousNext