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-53061TPANatalie C Greene1994-06-18——2081 Apache Blvd, Jacksonville, FL, 322590.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50322TPAKaren Rojas1996-05-21—90383847376039 Sage Ct, Miami, FL, 331840.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
TPA-55306TPABecky Greene2006-05-05——3070 Palm Dr, Tampa, FL, 336940.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53282TPAMason Ramirez1964-05-03——3165 Spring St, Fresno, CA, 937690.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63953TPAValentina Larson1991-08-25——7653 Sage Ct, Scottsdale, AZ, 852180.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59731TPAAmy L Davis1987-11-28—66587213124547 Indian School Rd, Phoenix, AZ, 850620.76Name split from “Last, First”Date of birth reformattedPhone reformattedPlan code upper-cased+2 more
TPA-53270TPAAnn Sullivan1992-08-26—94228491004276 Desert Sky Blvd, Glendale, AZ, 853910.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57327TPAHannah McDonald1947-12-15UHC-37231-0438021243426505 Elm St, Tampa, FL, 336080.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50869TPAArthur M Grant1960-10-23——1067 Pine Dr, Miami, FL, 331140.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61181TPABenjamin Stone1986-11-28UHC-33045-31—8811 Palm Dr, Tampa, FL, 336450.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50480TPAAngela Mills1973-10-09UHC-64081-9871427568153753 Harbor Blvd, Tucson, AZ, 857890.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-55502TPAPriya Sanchez1999-09-05——8031 Jefferson Ave, Los Angeles, CA, 900120.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-62616TPAHenry F Hunter1946-09-13—97374978581756 Indian School Rd, Las Vegas, NV, 891030.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59388TPALarry Bradley2001-10-13———0.76Name re-casedDate of birth reformattedEmail lower-casedGender normalised+2 more
TPA-53914TPABrenda Murphy1982-06-14—22787692056272 Pine Dr, Tampa, FL, 336800.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-52068TPAAnn Cook2002-01-18UHC-96679-7740528812466761 Park Pl, Fresno, CA, 937460.76Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+2 more
TPA-61616TPALogan Webb1979-06-25——8356 Jefferson Ave, Plano, TX, 750560.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-50015TPAKayla Chapman1944-12-14—6788408311713 Harbor Blvd, Scottsdale, AZ, 852550.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54095TPAStephen Miller2007-03-24——5983 Union St, Chandler, AZ, 852760.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60484TPAArjun Austin1960-03-04UHC-84919-23—2454 Highland Ave, Tempe, AZ, 852110.76Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61206TPAJason Hansen1991-12-27—59125438124417 Sage Ct Apt 33, Eden Prairie, MN, 553450.76Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
TPA-57872TPAWaltr Dominguez1944-11-03——7860 Palm Dr, Atlanta, GA, 303040.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-50175TPAMadison Wright1971-11-10——1261 Harbor Blvd, Chandler, AZ, 852640.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62718TPAChristina Gonzalez1968-01-23UHC-26758-34—87 Sage Ct, Jacksonville, FL, 322180.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61266TPABilly Green1939-11-06—46462640151467 Sage Ct, Las Vegas, NV, 891650.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60807TPAJoseph Owens1949-05-26—85199510777608 River Rd, Austin, TX, 787970.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63547TPADennis Delgado1991-08-14——7235 Bayshore Dr, Fresno, CA, 937250.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59399TPARebecca F Murray2002-09-21——6746 Lake View Rd, San Antonio, TX, 782730.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-52931TPANicole Burke1985-04-14—90498542777663 River Rd, Orlando, FL, 328720.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
TPA-58688TPAAbigail Armstrong2006-10-06—96357831749469 Apache Blvd, Dallas, TX, 752310.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63524TPAMark Simpsn1942-03-02——3103 Park Pl, Fresno, CA, 937170.76Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-51592TPAMartha G Bell1992-02-24UHC-89637-12—3913 Main St, Las Vegas, NV, 891310.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62134TPAGrace Thompson1957-11-22—86698465907788 Market St, Las Vegas, NV, 891160.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55990TPASandra Williamson1981-10-08—49394251366358 Canyon Rd, Mesa, AZ, 852400.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58376TPADaniel Grant1940-01-14——3420 Ocean Ave, Phoenix, AZ, 850770.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59970TPAAna J Riec1967-05-27—30361134992102 Grand Ave, Chandler, AZ, 852320.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-61644TPASandra Morrison2004-08-01—32033098821976 Spring St, Gilbert, AZ, 852680.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50205TPAHiroshi Ortega1979-11-11—7748608302188 Elm St, Austin, TX, 787990.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56366TPARonald Murray1953-02-23UHC-21726-19—1842 Meadow Ln, Gilbert, AZ, 852130.76Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+2 more
TPA-55730TPAKayla Reid2003-09-12UHC-98078-99—2115 Market St, Sacramento, CA, 958450.76Name re-casedTwo-digit birth yearMember ID reformattedCity re-cased+2 more
TPA-58968TPAAisha Cooper1962-03-06——7175 Broadway, Denver, CO, 802000.76Name re-casedDate of birth reformattedCity re-casedState name converted to code+2 more
TPA-62113TPAPriia Collins1942-04-01——6339 Baseline Rd, Mesa, AZ, 852460.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-62025TPAAndrew Carroll1942-04-21——8282 Baseline Rd, Tempe, AZ, 852540.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60913TPAJoe Thomas1975-10-17——9108 Washington St, San Antonio, TX, 782150.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59035TPAFrances N Guerrero1961-08-23—51339430353108 Pine Dr, San Diego, CA, 921230.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50415TPALori Dixon1939-09-23UHC-20645-16—2347 Sunset Blvd, Plano, TX, 750030.76Name re-casedDate of birth reformattedCity re-casedGender normalised+2 more
TPA-53019TPAMaria C Hanson1991-05-16—71241542654857 Oak St, Tampa, FL, 336440.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50446TPABradley P Stewart1968-02-12UHC-82552-49—1693 Indian School Rd, Minneapolis, MN, 554790.76Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54638TPATeresa Wong1980-10-10—45227917913782 Valley View Dr, Austin, TX, 787940.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56477TPASteven George1971-03-07UHC-39607-7381653427571231 Park Pl, Los Angeles, CA, 900670.76Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 123 of 290PreviousNext