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-55733TPADylan Hicks1950-10-04——4675 Willow Ct, Tempe, AZ, 852770.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60604TPAJoshua Wagner1939-06-04——6809 Market St, San Diego, CA, 921750.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63513TPASusan Larson1966-04-24——8213 Indian School Rd, Orlando, FL, 328590.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-52443TPAHeather Q Austin1990-10-11——6047 Lincoln Way, Austin, TX, 787740.82SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-62440TPAJerry Willimason—UHC-31382-25—4925 Jefferson Ave, Chandler, AZ, 852330.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-63423TPALori Cruz1941-06-02——1354 Harbor Blvd, Atlanta, GA, 303880.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61149TPAMariana Campbell2008-05-15——2470 Palm Dr, Minneapolis, MN, 554000.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-63835TPAHarold Nichols1968-04-05——4690 Cedar Ln, Mesa, AZ, 852890.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60527TPAEvelyn Contreras1977-01-11—80727244158517 Sunset Blvd, Jacksonville, FL, 322400.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60870TPABradley Russell1976-02-07——3277 Bayshore Dr, Sacramento, CA, 958330.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50658TPACheryl Cunningham1949-09-03UHC-44238-01—1762 Cedar Ln, Chandler, AZ, 852800.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50659TPACheryl Cunningham1949-09-03UHC-44238-01—1762 Cedar Ln, Chandler, AZ, 852800.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51199TPAElijah Lopez1963-03-01——9012 Lake View Rd, Columbus, OH, 432450.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-61636TPAJoyce Perez1977-06-24UHC-21788-6857484352939017 Washington St, Dallas, TX, 752450.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-53815TPANathan Bennett1952-12-14—97155661252690 Lincoln Way, Denver, CO0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-56280TPAHenry Wells1994-05-08——7167 Highland Ave, Scottsdale, AZ, 852160.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-59548TPASean Lee2001-11-20—59187092153969 Forest Ave, Charlotte, NC, 282310.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-62679TPARussell Bell————0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
TPA-57430TPATerry Rychardson1984-07-04UHC-96410-44—6145 Park Pl, San Antonio, TX, 782860.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-56043TPAAisha Braadley1972-12-24——8630 River Rd # 701, Denver, CO, 802110.82Unit split from streetCity re-casedPlaceholder values cleared
TPA-61060TPAElijah Williams1959-10-23—5933260049—0.82SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-59303TPADorothy Riley1986-06-13———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64351TPASteven Wagner1975-01-28——4395 Central Ave, Eden Prairie, MN, 553880.82Name split from “Last, First”City re-casedPlaceholder values cleared
TPA-61926TPASarah Carroll1969-05-06———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57473TPADiane Rogers2003-10-08UHC-26032-76——0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52540TPADebra Patel1948-01-07—23882163403271 River Rd, Orlando, FL, 328350.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51121TPAGrace Chapman1971-05-12———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-55751TPABarbara Rivera1996-04-26——3211 Main St, Plano, TX, 750770.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51208TPAKimberly Ryan2004-10-07———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-52941TPADonald Castillo1942-07-26—5183424288—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-62584TPATeresa Roberts1968-09-01——1856 Sage Ct, Sacramento, CA0.82Name re-casedZIP missingPlaceholder values cleared
TPA-50697TPAWayne Santiago1999-03-04——1288 Highland Ave, Charlotte, NC, 282530.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51786TPAFatima Elliott1950-11-05——8296 Sunset Blvd, Charlotte, NC, 282120.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62496TPAMark Guzman1953-04-07UHC-53643-04—9499 Forest Ave, Scottsdale, AZ, 852920.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-56435TPAJonathan Carter1981-09-14——8631 Apache Blvd, Glendale, AZ, 853170.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55586TPAJerry Alvarez1959-06-05——7735 Market St, Seattle, WA, 981150.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54154TPARoy Crawford1991-07-27UHC-84794-41—6673 Oak St, Seattle, WA, 981750.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-54155TPARoy Crawford1991-07-27UHC-84794-41—6673 Oak St, Seattle, WA, 981750.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-63427TPAMatthew T Guerrero1957-02-20UHC-41469-99—1771 Apache Blvd, Dallas, TX, 752460.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60231TPAMichelle Mendez1967-12-20——1553 Hillcrest Rd, Sacramento, CA, 958200.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-63200TPARandy I Matthews1981-08-02UHC-28402-87—6547 Willow Ct, Eden Prairie, MN, 553190.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-54732TPAJulie Stone1998-01-11—61650793211065 Meadow Ln, Phoenix, AZ, 850800.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-50119TPAWalter Estrada1987-03-07——1573 Indian School Rd, Eden Prairie, MN, 553040.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-56274TPAJanike Hunter1982-03-04UHC-06562-97—4443 Jefferson Ave, Chandler, AZ, 852460.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-53628TPARalph Hayes1956-12-23——6945 Valley View Dr, Tampa, FL, 336240.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58312TPAJacob Medina1968-08-23—69546156168514 Park Pl, Tempe, AZ, 852430.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-61860TPAJanet Le1964-08-14UHC-70945-4996470083851029 Oak St Apt 22, Tucson, AZ, 857130.82Phone reformattedUnit split from streetPlaceholder values cleared
TPA-50473TPABilly Le1997-10-17UHC-14949-45—7834 Sage Ct, Mesa, AZ, 852250.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62178TPAFatima Warren1943-01-18——9247 Oak St, Minneapolis, MN, 554530.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61938TPAAisha Cunningham1996-12-02—2372707273764 Valley View Dr, Tampa, FL, 336830.82Street suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 212 of 290PreviousNext