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-52380TPAHannah Garrett1993-01-09—6057650156478 Sunset Blvd, Minneapolis, MN, 554930.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57674TPAEmily Harris1967-10-25UHC-11654-18—5568 Apache Blvd, Orlando, FL, 328600.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51887TPACatherine Richardson1988-01-10—42482231464471 Elm St # 799, Seattle, WA, 981890.76Name re-casedPhone reformattedUnit split from streetCity re-cased+2 more
TPA-62296TPANicholas West1984-01-12—23950187155521 Grand Ave, Fresno, CA, 937760.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62295TPANicholas West1984-01-12—23950187155521 Grand Ave, Fresno, CA, 937760.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55570TPAYuki Hoffman1940-03-10—64937410974114 River Rd, Tampa, FL, 336480.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60999TPAWei Ward1973-01-21—87998957046543 Jefferson Ave, Minneapolis, MN, 554550.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58743TPANicholas Bowman1993-08-02UHC-35066-30—8094 Main St, Sacramento, CA, 958070.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55215TPAKelly White1985-06-10——9539 Camelback Rd, Minneapolis, MN, 554070.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51789TPAPriya Owens1988-02-28——4814 Sage Ct, San Antonio, TX, 782780.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-64427TPARchel Adams1939-03-26—67058795065892 Oak St, Tucson, AZ, 857240.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53629TPAMari Castro1982-03-13UHC-41645-88—2918 Grand Ave, Columbus, OH, 432140.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63343TPAKevin Cole1983-12-18——1759 Forest Ave, Phoenix, AZ, 850300.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52161TPAKathryn Turner1952-02-22——1319 Harbor Blvd, Eden Prairie, MN, 553960.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50486TPADnaiel Bailey1967-02-12—70833852856557 Main St, Las Vegas, NV, 891560.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63433TPABradley F Larrson1960-11-16——9556 Maple Ave, Phoenix, AZ, 850570.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59481TPAPamela Scott2003-06-02——5921 Harbor Blvd, Tucson, AZ, 857610.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58687TPAIsabella Li1948-04-28—9009209380802 Ocean Ave, Charlotte, NC, 282700.76Name re-casedPhone reformattedState code upper-casedGender normalised+2 more
TPA-60412TPAHelen Woods1975-06-19—83295760269455 Canyon Rd, Atlanta, GA, 303360.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51656TPAStephen Cook2001-11-05UHC-38054-368816650692433 Main St, San Antonio, TX, 782020.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56012TPAVirginia Roberts1992-01-18—52697486641146 Sunset Blvd, Los Angeles, CA, 900790.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-56380TPAEugene Washington1980-11-20UHC-11579-9089398045659165 Lake View Rd, Houston, TX, 770990.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61351TPARichard Montgomery1971-02-03——1231 Market St, Nashville, TN, 372930.76Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-58581TPAJesse Spencer1969-06-10—7362875725935 Palm Dr, Columbus, OH, 432030.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61367TPASara Webar——67561632244638 Lincoln Way, San Antonio, TX, 782060.76Name re-casedDate of birth unreadablePhone reformattedState code upper-cased+2 more
TPA-63703TPAPaul Obrien1946-06-15——9081 Broadway, Denver, CO, 802820.76Name re-casedDate of birth reformattedCity re-casedGender normalised+2 more
TPA-53052TPAAustin Walsh2006-10-21—69148552478506 Bayshore Dr, Charlotte, NC, 282270.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53411TPACharlotte Lucas1968-04-03—7639253746333 Harbor Blvd, Dallas, TX, 752440.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-57379TPAPeter Bennett1998-11-28——9378 Cedar Ln, Tempe, AZ, 852550.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61202TPAEric Li1942-04-03—28163779473044 Park Pl, Denver, CO, 802120.76Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
TPA-57059TPACamila Walsh1960-01-13——2775 Harbor Blvd, Tempe, AZ, 852150.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54172TPAIsabella Parker1955-02-11—38031554983506 Grand Ave, Glendale, AZ, 853390.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59629TPASandra Stevens1963-08-22—38538658406300 Lake View Rd, Tempe, AZ, 852550.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62648TPAMason Schultz2002-10-21—29394415979103 Highland Ave, Columbus, OH, 432150.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50218TPAJacob Gomez1951-07-05UHC-46357-4450341337423679 Union St, Sacramento, CA, 958110.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50776TPAKathleen Nelson2002-03-19—35654825557481 Mesa Dr # 742, Nashville, TN, 372870.76Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
TPA-60038TPAJose Wagneer2000-01-15——2135 Spring St, Scottsdale, AZ, 852110.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61923TPAYoung Ruth2000-10-28—6558933083335 Desert Sky Blvd, Gilbert, AZ, 852260.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58322TPALarry Chapman1981-11-16——3349 Union St, Eden Prairie, MN, 553900.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55354TPARoy Mills1949-09-10——1396 Union St, Sacramento, CA, 958030.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54487TPAJmaes Johnson1945-07-21UHC-22933-11—9124 Grand Ave, Tempe, AZ0.76Name re-casedDate of birth reformattedMember ID reformattedZIP missing+2 more
TPA-55737TPAWalter Carr1972-11-13——5262 Jefferson Ave, Houston, TX, 770550.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55943TPABill Fowler1940-08-11—66893932879182 Bayshore Dr, San Diego, CA, 921860.76Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
TPA-63213TPACharlotte Ramos1996-05-05—87147274553625 Ocean Ave, Denver, CO, 802490.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60792TPADiana Turner1970-11-06—7939690217—0.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-60782TPANoah Garza2008-06-07—58167585873042 Market St, Plano, TX, 750140.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50612TPAArthur B Banks1955-09-13——5876 Bayshore Dr, Seattle, WA, 981110.76Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-62515TPADenise Dominguez1972-05-01——2833 Palm Dr, Jacksonville, FL, 322760.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56257TPABenjamin Padilla1974-09-23——6589 Forest Ave, Austin, TX, 787680.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55144TPAMartha J Ramirez1997-05-05——9690 Valley View Dr, Los Angeles, CA, 900910.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 113 of 290PreviousNext