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-56124TPAKeith Ross1939-07-21——4892 Baseline Rd, Phoenix, AZ, 850260.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-56597TPAWillie Butler1959-10-24——1562 Central Ave Apt 17, Mesa, AZ, 852150.48Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51289TPAArjun Turner1984-09-08—76967179818735 Valley View Dr Apt 1, Phoenix, AZ, 850670.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-52026TPASean Torres1939-04-18——1225 Park Pl, Las Vegas, NV, 891210.48Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
TPA-54034TPADennis Foster——95462301147226 Ocean Ave, Jacksonville, FL, 322120.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61411TPADortohy Wag1974-07-20——4129 Bayshore Dr # 533, Columbus, OH, 432680.48Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+4 more
TPA-55281TPAFrank Castillo2005-01-02UHC-40282-62—3298 Jefferson Ave, Miami, FL, 331290.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-60006TPASharon Garza1994-02-05—44542333499247 Highland Ave, Columbus, OH, 432980.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-56209TPAMadison Lopez1945-02-18UHC-54424-312767735983673 Grand Ave, Las Vegas, NV, 891770.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-60000TPAGregory G Le1939-12-05UHC-77243-5491581640623244 Spring St, San Diego, CA0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-59737TPAJanet Ryan——95588061021484 Mesa Dr, San Antonio, TX, 782030.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50003TPAJames K Hunter1960-03-14——6535 Bayshore Dr, Orlando, FL, 328320.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
TPA-64070TPAVincent Riley1964-12-24——1651 Grand Ave, Atlanta, GA, 303810.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-54682TPACarlos Thompson2002-01-26——7115 Apache Blvd Apt 38, Tampa, FL, 336520.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-59357TPAElizabeth Santiago1974-02-24UHC-79914-44—1713 Ridge Rd # 159, Mesa, AZ, 852740.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-56002TPAJean Lucas1978-04-09—58351111579228 Central Ave, Jacksonville, FL, 322840.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61292TPABarbara Johnston1990-12-20—25739314566135 Ridge Rd # 327, Glendale, AZ, 853890.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-58426TPADanny Johnson1941-03-27—28548108468387 Church St # 385, Tempe, AZ0.48Name re-casedDate of birth reformattedUnit split from streetState code upper-cased+4 more
TPA-50179TPAJeremy K Young2002-05-20——6020 Jefferson Ave # 274, Columbus, OH, 432870.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-64411TPAEmily Stephens1940-08-13——7973 Mesa Dr, Scottsdale, AZ, 852040.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56482TPASophia Perez1948-12-19—44527874322043 Forest Ave # 457, Sacramento, CA0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-61018TPACarol Meyer1979-07-21—24294895813897 Camelback Rd Apt 35, Nashville, TN, 372650.48Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-50617TPAJack U Hunt1974-11-04——8639 Main St, Miami, FL, 331440.48Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
TPA-55720TPAAngela Z Watkins1997-08-02——2215 Canyon Rd, Tampa, FL, 336130.48Name re-casedDate of birth reformattedPhone missing area codeCity re-cased+4 more
TPA-54859TPAMadison Rios1983-03-13UHC-86944-5223145870488428 Desert Sky Blvd, Eden Prairie, MN0.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-52756TPABill Stewart——21980796077629 Ridge Rd, Tampa, FL, 336500.48Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more
TPA-56767TPAHelen Castillo1915-10-10——4757 Highland Ave, Los Angeles, CA, 900100.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
TPA-59003TPAFrank Munoz1968-01-24—44661692012100 Indian School Rd, San Diego, CA0.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-58495TPAAlice Gordon1961-02-17——9363 Lincoln Way, Seattle, WA, 981220.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58572TPAKelly Hernandez1968-02-05—36444542955878 Lake View Rd, Atlanta, GA, 303560.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-64148TPABobyb Bailey1943-08-01——2275 Baseline Rd Apt 37, Plano, TX, 750320.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-63664TPADylan R Stephens1982-08-03—38780700188540 Meadow Ln, Plano, TX, 750480.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-60639TPAJudy X Reed1995-10-25UHC-47525-60—7590 Grand Ave, Atlanta, GA, 303780.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-64379TPAEily Hamilton1958-04-24——1869 Apache Blvd Apt 16, San Antonio, TX, 782780.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-55063TPALucia Bailey1938-08-26——5146 Meadow Ln, Plano, TX, 750540.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
TPA-59329TPASteven R Price1939-01-16—80640485582043 Grand Ave, Houston, TX, 770620.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58929TPAGerald Gardner1952-06-01—34148827202245 Meadow Ln, Charlotte, NC0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61639TPAAhmed Carter1980-10-01—81232569936189 Valley View Dr, Atlanta, GA, 303310.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-53474TPAJennifer Moore1994-12-06—41639017723483 Church St, San Diego, CA, 921520.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56548TPAPeeter Gilbert1961-12-23—31825301044458 Canyon Rd Apt 33, Tucson, AZ0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-55447TPABobby A Schultz1958-07-18——1371 Maple Ave, Seattle, WA, 981980.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
TPA-58416TPAMark Hoffman1993-10-18——7240 Union St, Nashville, TN, 372280.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55476TPAMaria McDonald2008-06-24—78889417518439 Elm St, Houston, TX, 770440.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61119TPARonald Reed1957-07-28—62955203856289 Baseline Rd, Tucson, AZ, 857830.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-51300TPANatalie Weber1977-12-13—84494892452493 Pine Dr, Jacksonville, FL, 322790.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57557TPATimothy Wong——68341097063169 Camelback Rd, Fresno, CA, 937930.48Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+4 more
TPA-61745TPAVictoria Hill1974-05-05—40520984367117 Pine Dr Apt 11, Phoenix, AZ, 850360.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-61929TPAAaron Z Murphy1966-01-06—95773275055832 Mountain View Dr, Chandler, AZ0.48Name re-casedDate of birth reformattedPhone reformattedState name converted to code+4 more
TPA-50987TPAPamela R Vazquez1976-04-22—26577180142062 Park Pl, Fresno, CA, 937580.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54136TPANiocle Soto1976-07-06UHC-29038-3030653248478682 Elm St, Fresno, CA0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
14,474 rows, page 9 of 290PreviousNext