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-61829TPABradley Weber1991-06-17—72248296116986 Pine Dr, Miami, FL, 331020.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59093TPAVirginia Watkins2004-05-11UHC-81608-0656437241168207 Oak St, Dallas, TX, 752960.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-60879TPADonna J Black1968-08-19——7639 Maple Ave, Chandler, AZ, 852240.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51763TPASandra Fuller1983-09-17—79154834072866 Bayshore Dr, Los Angeles, CA, 900640.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51317TPAKimberly Tran1951-09-18UHC-62232-7654377939396364 Bayshore Dr, Eden Prairie, MN, 553850.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-56220TPAChristian U Hughes1943-03-18—60747287649665 Willow Ct, Phoenix, AZ, 850770.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-64107TPARussell Scott2006-07-06—58221575976832 Lake View Rd, Houston, TX, 770450.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-62132TPAJack Danies1952-12-08—67647841726951 Church St, Atlanta, GA, 303130.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
TPA-52586TPARachel Campbell2005-02-19—68241968923867 Cedar Ln, Las Vegas, NV, 891010.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61942TPAEddward Ray1980-01-04—98244737535698 Palm Dr, Tempe, AZ, 852520.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52252TPAMartha Jonse1984-08-03—79179265354291 Market St, San Diego, CA, 921870.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50394TPAPatrick Moore1955-03-04——1188 Lincoln Way, Scottsdale, AZ, 852360.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50712TPAAustin J Torres1970-06-15UHC-05553-1332436022506803 Canyon Rd, Jacksonville, FL, 322680.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51125TPAJulie Wilson1938-03-07——5092 Park Pl, Tempe, AZ, 852910.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56480TPAViincent N Austin1943-10-28—28243382779755 Sage Ct, Dallas, TX, 752170.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-59723TPARussell Nunez1987-06-15UHC-92246-28—9308 River Rd, Jacksonville, FL, 322870.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53825TPACatherine Marquez2000-01-20—30052681455431 Church St, Austin, TX, 787250.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61955TPABrittany Watson1971-04-25UHC-75844-2133483809073073 Market St, Sacramento, CA, 958740.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55370TPAJulie Alexander1990-01-15——8043 Pine Dr, San Diego, CA, 921640.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54999TPABradley Meyer1978-02-03—80578397312160 Central Ave, Jacksonville, FL, 322360.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59382TPAGloria Martiez1959-09-01UHC-12879-768025233117840 Central Ave, Las Vegas, NV, 891620.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57595TPAAmanda Cole1962-01-02——7895 Camelback Rd, Charlotte, NC, 282700.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56880TPARichard H Riley1989-01-11——4315 Pine Dr, Columbus, OH, 432920.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52047TPAValentina Y Ward1990-11-26——8511 Harbor Blvd, Charlotte, NC, 282070.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63957TPAMary V Hudson1995-01-14—77547971939385 Mesa Dr, San Diego, CA, 921710.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50990TPAAna Singh1964-06-17—28255729221586 Park Pl, Sacramento, CA, 958750.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-58207TPAWillie Y Miller1998-07-08—81025587491508 Canyon Rd, Atlanta, GA, 303940.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-53551TPAVirginia Lynch1950-12-07—95376215442636 Ocean Ave, Tucson, AZ, 857280.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-62103TPAJeremy Daniels1986-05-05UHC-66664-57—1579 Palm Dr, Sacramento, CA, 958300.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-64374TPALuis Hall1954-04-13——2269 Canyon Rd, Columbus, OH, 432670.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50006TPANoah Estrada1992-02-10——6313 Desert Sky Blvd, Eden Prairie, MN, 553150.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53678TPAKaran Wells1989-06-21—73066473483908 Sunset Blvd, Nashville, TN, 372360.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57484TPAWei Baiely1975-02-24——609 Hillcrest Rd, Minneapolis, MN, 554310.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-63197TPAJanice Park1971-10-21—74855124007404 Meadow Ln, Eden Prairie, MN, 553630.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63512TPASusan Larson1966-04-24UHC-58072-9594078382318213 Indian School Rd, Orlando, FL, 328590.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61819TPAMendoza Rebecca2006-03-10——9585 Baseline Rd, Houston, TX, 770940.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63728TPAAngala Hughes1940-09-03—25257780247322 Church St, Houston, TX, 770750.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-64291TPAGay Santos1957-03-08—2328547760947 Grand Ave, Miami, FL, 331680.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58430TPAJoyce I Reyd1965-10-13—34672669793296 Sunset Blvd, Scottsdale, AZ, 852410.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51340TPAMargaret Bailey1998-01-13UHC-09162-9983159145019793 Elm St, Orlando, FL, 328040.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50891TPARaymond Hart1973-03-08—44140622692095 Market St, Eden Prairie, MN, 553090.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55819TPAFrances Fields1952-11-04——565 Main St, Tempe, AZ, 852390.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52808TPAMargaret Marshall1960-09-25—7563809209420 Forest Ave, Minneapolis, MN, 554200.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-51491TPABruce Cooper1967-06-28—89245443974779 Palm Dr, Tampa, FL, 336470.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52656TPAArjun U Anderson1939-10-02—29193378656456 Meadow Ln # 395, Los Angeles, CA, 900040.76Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
TPA-52901TPAChristina Fox1919-04-09—5979043437873 Spring St, Tempe, AZ, 852450.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63082TPABenjamin Hudson1960-11-03——5758 Mountain View Dr, Tucson, AZ, 857620.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55709TPAKathleen Alvarez2002-05-10——4674 Forest Ave, Glendale, AZ, 853940.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60723TPAKimberly Sandoval1942-08-19——4288 Pine Dr, Mesa, AZ, 852820.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53656TPAThomas Richardson1996-01-21——8105 Bayshore Dr, Tucson, AZ, 857750.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 109 of 290PreviousNext