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-56803TPAPaul Lewis1972-03-11——8134 Harbor Blvd, Houston, TX, 770030.82Name re-casedPhone missing area codePlaceholder values cleared
TPA-62879TPAMei Griffin1994-03-17——9170 Union St, Tucson, AZ, 857750.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57720TPASantiago Romero1978-11-20———0.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-58718TPAPriya Foster1959-09-06——5159 Highland Ave Apt 38, Fresno, CA, 937920.82Unit split from streetState code upper-casedPlaceholder values cleared
TPA-50016TPADiane Lee1970-01-11———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-54206TPAJames Aguilar1996-05-17——6531 Meadow Ln, Glendale, AZ, 853950.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64056TPANatalie Vazquez1974-09-11—26453130828208 Main St, Nashville, TN, 372440.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59455TPAWilliam Clark1986-07-21——7594 Cedar Ln, Tampa, FL, 336800.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63487TPAJanet Hawkins1947-06-21—78345543942446 Indian School Rd, Seattle, WA, 981470.82Phone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-63486TPAJanet Hawkins1947-06-21—78345543942446 Indian School Rd, Seattle, WA, 981470.82Phone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-56579TPAAndrea Ruiz1988-04-27—4356946150—0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-51855TPAMelissa Thompson1976-02-10———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-53319TPAAhmed Sanders1950-04-11———0.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-55944TPAMary Jacobs1983-06-07——4376 Elm St, San Antonio, TX, 782340.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52882TPABrian Nunez1966-01-09——8089 Sunset Blvd, Las Vegas, NV, 891660.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60634TPAAnn Sims1960-10-04——7084 Elm St, Nashville, TN, 372320.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-63007TPADylan Russell1950-01-20——875 Camelback Rd, Fresno, CA, 937950.82Name split from “Last, First”City re-casedPlaceholder values cleared
TPA-57923TPAAndrew Simmons1996-11-15—40386888291958 Valley View Dr, Denver, CO, 802410.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62871TPAJose Jensen1939-09-04——4470 Church St, Mesa, AZ, 852430.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63889TPANathan Shaw2003-08-10——9411 Willow Ct, Miami, FL, 331640.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54376TPACynthia Contreras1978-03-06——4353 Washington St, Phoenix, AZ, 850430.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54435TPAAraon Cruz2008-01-18—59629607537271 Jefferson Ave, Phoenix, AZ, 850910.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-64175TPAAdam Schmidt1973-02-12——3416 Palm Dr, Orlando, FL, 328270.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-54392TPABetty Ellis1999-10-26——8398 Market St, Minneapolis, MN, 554370.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-60125TPABryan Robertts1938-07-04——6377 Indian School Rd, Tempe, AZ, 852560.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56723TPADanielle Sims1961-10-28——3165 Willow Ct, Tampa, FL, 336070.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52109TPALinda Padilla1947-02-20UHC-69153-86——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-61704TPAAhmed Hoffman1978-02-08——7858 Spring St, Gilbert, AZ, 852960.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56173TPAPhilip Gonzalez1948-06-04———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54703TPAVirginia Freeman1960-09-05—40769035669052 Cedar Ln, Nashville, TN, 372750.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-55212TPAJuan Singh1968-07-02———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-56629TPADennis Mendoza1983-03-10UHC-19611-28—2596 Ocean Ave, Phoenix, AZ, 850160.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63530TPAJack Torres1949-02-10——110 Spring St, Nashville, TN, 372710.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-58913TPAElijah Williamson1989-12-24——868 Union St, Seattle, WA, 981340.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55735TPABrandon Kim————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-57349TPAKimberly Payne1942-04-07——4517 Bayshore Dr, Jacksonville, FL, 322530.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57073TPAEvelyn Elliott1949-01-12——5279 Pine Dr, Houston, TX, 770460.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61326TPAWayne Perkins1943-09-07——5373 Highland Ave, Mesa, AZ, 852120.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-61168TPASantiago Baker1991-02-27——3643 Park Pl, Los Angeles, CA, 900270.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-50854TPABeverly Ramos1944-03-10—9183627716—0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55948TPANoah Padilla1984-09-20——5201 Highland Ave, Austin, TX, 787740.82Name re-casedState name converted to codePlaceholder values cleared
TPA-62479TPAAustin Welch1963-04-23——278 Palm Dr, Gilbert, AZ, 852770.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-50603TPAEdward Perez1969-07-23———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56709TPABarbara Carter1941-08-17——5676 Ridge Rd, Chandler, AZ, 852900.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-58994TPAJennifer Watkins1993-04-21———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-62359TPAJoe Morgan1965-07-21——8689 Church St, Sacramento, CA, 958730.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62459TPASam Warren2003-06-02—2472459264—0.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-63182TPALauren Sullivan1938-07-08——1058 Spring St # 265, Miami, FL, 331580.82Date of birth reformattedUnit split from streetPlaceholder values cleared
TPA-54589TPAJuan Santos———9303 Central Ave, Nashville, TN, 372310.82Date of birth missingWhitespace trimmedPlaceholder values cleared
TPA-64146TPAKevin Hughes1944-07-02——7328 Bayshore Dr, Glendale, AZ, 853190.82Name re-casedGender normalisedPlaceholder values cleared
14,474 rows, page 214 of 290PreviousNext