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-58685TPADiana Freeman1962-07-17——2721 Elm St, Jacksonville, FL, 322340.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-63279TPAAnrdea Lee1994-12-25—56469997307227 Jefferson Ave, San Diego, CA, 921030.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-63982TPAGrace Le———7146 Central Ave, San Antonio, TX, 782440.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-62198TPARichard I Peters1949-07-14—24123118188617 Central Ave Apt 11, Minneapolis, MN, 554180.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
TPA-63356TPAMaria Reeed1944-03-19UHC-26909-68—7228 Ridge Rd, Jacksonville, FL, 322570.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54028TPADanile Pena1978-06-28——9596 Meadow Ln, Los Angeles, CA, 900350.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-51010TPASofia Collisn1946-10-12—8884414268603 Elm St, San Diego, CA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51543TPAGreegory Elliott1961-08-16——1131 Central Ave, Atlanta, GA0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-56231TPAMichelle Woong1995-11-14——9654 Central Ave, Chandler, AZ, 852150.62Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more
TPA-63494TPAGeorge Estrada1989-06-18—22350029193618 Canyon Rd, Atlanta, GA, 303000.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50782TPAHiroshi B Coleman1985-04-06——3352 Central Ave, San Antonio, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55591TPAJacob Romero1954-10-10——7038 Apache Blvd, Nashville, TN, 372090.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52058TPARonald Brooks1990-04-28——7486 Union St, Glendale, AZ, 853820.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51165TPAJennifer Henry1968-06-10UHC-46109-60—4536 Camelback Rd, Orlando, FL, 328430.62Name re-casedDate of birth reformattedCity re-casedState name converted to code+3 more
TPA-60111TPARndy Cruz1939-06-22UHC-45387-968934782097790 Willow Ct # 472, Scottsdale, AZ, 852560.62Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
TPA-51884TPAWalter Torres1979-09-18—55248810148908 Apache Blvd, Denver, CO, 802710.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50702TPACynthia Ryan1992-07-22UHC-40295-56—4288 Union St, Minneapolis, MN, 554570.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50783TPAHiroshi Coleman1985-04-06UHC-24824-9457883613923352 Central Ave, San Antonio, TX, 782420.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53305TPARoger Q White1948-08-05UHC-38078-4533745702521094 Baseline Rd, Seattle, WA, 981050.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58701TPASara Wagner1946-04-23—49428862529658 Highland Ave, Minneapolis, MN0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62073TPAEvelyn Gonzales1941-07-02——3451 Market St, Denver, CO, 802600.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58208TPAEthan Davis1973-12-20——6281 River Rd, Eden Prairie, MN, 553440.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57781TPAKeith Bell1989-12-22——9563 Willow Ct Apt 15, Tempe, AZ, 852680.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-62011TPAJacob Patterson1994-09-20UHC-78868-4343790984063426 Maple Ave, Dallas, TX, 752780.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55136TPANancy Clark1938-12-27—79581289665468 Ocean Ave, Seattle, WA, 981140.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59009TPAChristina Armstrong1977-06-05—66756066437060 Park Pl, Las Vegas, NV, 891130.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54691TPAAshley Ford2001-12-13—53831251947109 Forest Ave, Sacramento, CA, 958460.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62835TPAJoe Ricce1994-06-12——1843 Bayshore Dr, Tucson, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52790TPAAlbert Owens1942-03-01——367 Central Ave, Charlotte, NC, 282360.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62254TPATom Y Moore1980-09-27——8891 Elm St, Miami, FL, 331940.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-62416TPAValentina Cole1960-02-19UHC-84010-9332331739211496 Mountain View Dr, Seattle, WA, 981470.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-53267TPAPatricia Hayes2000-07-03——5615 Grand Ave, Jacksonville, FL, 322750.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53209TPABryan Bradley1941-10-26—87366366828041 Park Pl, Fresno, CA, 937640.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54260TPAJustin Vargas2004-09-15UHC-10790-41—3263 Hillcrest Rd, Los Angeles, CA, 900350.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54425TPARebecca Schultz1952-02-20UHC-71809-103428799932765 Sunset Blvd Apt 26, Plano, TX, 750330.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-59617TPAMelissa E Kennedy1998-11-03—46434050807833 Park Pl, Fresno, CA, 937850.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53101TPADanielle Pierce1956-11-16—77168469615592 Ocean Ave, Atlanta, GA, 303280.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54369TPANicoole Hayse1939-04-16UHC-32516-687178720107695 Apache Blvd, Plano, TX, 750900.62Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-63958TPAYuki Park2003-04-23——6274 Camelback Rd, Tampa, FL, 336960.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52411TPARoger Porter1992-03-10——5095 Ridge Rd, Chandler, AZ, 852560.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54956TPADonna James2006-06-08UHC-73198-99—6962 Mesa Dr, Miami, FL, 331540.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60220TPAFrances Guerrero1985-09-19—85774657855198 Main St, Mesa, AZ, 852610.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59266TPALucia Smith1964-01-03——980 Ridge Rd, Austin, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55102TPAMaria Snyder1966-05-27—84487808965805 Mountain View Dr, Denver, CO0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63463TPAWayne Morris1956-06-07——6002 Baseline Rd, Charlotte, NC, 282970.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-51678TPAScott Soto1974-04-19UHC-72076-66—9872 Hillcrest Rd, Plano, TX, 750850.62Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-59526TPAWilliam Olson1938-04-23—84268231122655 Park Pl, Charlotte, NC, 282700.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64331TPAPamela Alvarao2003-01-04——144 Mountain View Dr # 461, Eden Prairie, MN, 553550.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-62622TPASamuel Medina1943-08-15—87347189451746 Grand Ave # 589, Sacramento, CA, 958070.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-51541TPAJoyce Wang1980-08-14UHC-08056-6432966351052091 Pine Dr, Tucson, AZ, 857870.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
14,474 rows, page 43 of 290PreviousNext