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-58533TPAAdam Wheeler1950-10-17———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-51156TPARebecca Mitchell1963-07-21——6206 Bayshore Dr, Houston, TX, 770990.82SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-60455TPALuis Gilbert2002-05-27——2140 Lake View Rd, Columbus, OH, 432500.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-53814TPANathan Bennett1952-12-14UHC-27614-09—2690 Lincoln Way, Denver, CO, 802060.82State name converted to codePlan code upper-casedPlaceholder values cleared
TPA-54977TPAMelissa U Wong2007-04-25—45247208094112 Park Pl, Las Vegas, NV, 891450.82Name re-casedStreet suffix standardisedAddress re-cased
TPA-53361TPAJose Munoz2004-08-05———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-53360TPAJose Munoz2004-08-05———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-54139TPAAngela Wang1967-03-01——8641 Valley View Dr, Orlando, FL, 328870.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50448TPAArjun McCoy1954-10-07——2077 Spring St, Dallas, TX, 752470.82Date of birth reformattedPhone missing area codePlaceholder values cleared
TPA-50925TPACatherine Phillips1981-08-26——8247 Desert Sky Blvd, Seattle, WA, 981640.82Name re-casedGender normalisedPlaceholder values cleared
TPA-59331TPAGerald Rios1976-03-19——3000 Maple Ave, San Antonio, TX, 782520.82Two-digit birth yearEmail lower-casedPlaceholder values cleared
TPA-61689TPAMargaret F Weaver1989-04-17UHC-13952-43——0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-53989TPAKevin Z Taylor1978-04-04——9498 Main St, Eden Prairie, MN, 553260.82Middle initial moved out of first nameName re-casedPlaceholder values cleared
TPA-57018TPARuth Flores2008-03-05——2065 Elm St, Columbus, OH0.82State code upper-casedZIP missingPlaceholder values cleared
TPA-62100TPAMadison Reyes1946-04-18——6130 Elm St, Orlando, FL, 328970.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56871TPAJuan Williams1950-11-24——8198 Lincoln Way, Scottsdale, AZ0.82Name re-casedZIP missingPlaceholder values cleared
TPA-59485TPABradley Rogers1987-12-20——8042 Pine Dr, Seattle, WA, 981690.82Date of birth reformattedState code upper-casedGender normalised
TPA-53137TPAJose Fuller1988-04-27—42554508307713 Willow Ct, Denver, CO, 802230.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-50780TPAAmy Rice1991-06-04—7905690744—0.82Name split from “Last, First”Plan code upper-casedPlaceholder values cleared
TPA-58164TPALucia Guerrero1979-04-01UHC-85694-8744691979848907 Mountain View Dr, Glendale, AZ, 853790.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-60770TPARalph A Ruiz1950-05-14———0.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-53248TPAMark R Rojas1975-02-01——3472 Ridge Rd, Atlanta, GA, 303810.82Name re-casedGender normalisedPlaceholder values cleared
TPA-59653TPAPriya Lynch1982-09-24——3494 Baseline Rd, Minneapolis, MN, 554100.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51722TPAJonathan Bennett1968-03-13———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56234TPAKathleen Morris1962-10-27——3402 Highland Ave, Dallas, TX, 752360.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60855TPAJerry Thomas1975-09-28—4854250951—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-58381TPAAbigail Mitchell1968-08-24—2578456056103 Broadway, Columbus, OH0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-58543TPAChristina Morgan1999-03-07———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-58345TPACamila Thompson1939-01-12——5263 Broadway, Sacramento, CA, 958800.82Name split from “Last, First”Address re-casedPlaceholder values cleared
TPA-51662TPAMason Marquez1998-12-04——3220 Maple Ave, Sacramento, CA, 958430.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63667TPAJustin Le1977-05-22——1662 Market St, Phoenix, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-59342TPAJudy Santiago1999-05-13——132 Pine Dr, Tempe, AZ, 852480.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61793TPACarl Carr1985-06-03———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-63242TPAJack Pierce————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-56526TPAJohn Henry1944-01-19———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56525TPAJohn Henry1944-01-19———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55846TPAMaria Dean2007-10-07——6450 Lincoln Way, Tempe, AZ, 852960.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63529TPADiane Schultz1948-08-24—4099193242—0.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-58565TPAJerry Lane1949-10-23——2060 Ocean Ave, Orlando, FL, 328200.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61005TPAMarilyn F Lynch1992-09-01———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59316TPATerry Lane1939-07-20———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57815TPANoah Rogers1958-04-08—8824235999—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-60951TPAAndrew Hunt————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-52623TPABrittany Hall1964-03-06UHC-67985-87—6962 Desert Sky Blvd, Houston, TX, 770810.82State name converted to codePlan code upper-casedPlaceholder values cleared
TPA-50064TPAJennifer Cole1962-10-12—63965727175396 Elm St, Charlotte, NC, 282310.82Date of birth reformattedStreet suffix standardisedAddress re-cased
TPA-64024TPAMichelle Le1978-11-05—8044317304—0.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-52224TPASean Soto1956-01-28———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-62704TPAPamela Cooper1993-04-16—59956354297204 Indian School Rd, Miami, FL, 331070.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-62145TPARuth Flores1999-02-18——7256 Valley View Dr, Gilbert, AZ, 852920.82City re-casedGender normalisedPlaceholder values cleared
TPA-54006TPAOlivia Ramos1998-07-18———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
14,474 rows, page 206 of 290PreviousNext