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-57203TPARebeca Armstrong1941-01-17UHC-21586-5160884332734269 Jefferson Ave, San Diego, CA, 921520.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-53748TPAKelly Stewart1997-10-28——5781 Jefferson Ave, San Antonio, TX, 782630.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61545TPAEric M Andrews1969-06-10—84578933062279 Park Pl, Austin, TX, 787500.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59953TPABetty Cox1944-01-01—28336299983527 Central Ave, Jacksonville, FL, 322750.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53939TPABetty Fields2006-08-24—54787389852940 Cedar Ln, Scottsdale, AZ, 852730.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-60648TPATeresa Murphy1967-10-09——4268 Broadway Apt 19, Mesa, AZ, 852690.62Name re-casedDate of birth reformattedUnit split from streetCity re-cased+3 more
TPA-62843TPAFrnak Sanchez1993-06-22——3489 Ridge Rd, Miami, FL, 331530.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-64401TPAStephen B Watkins1966-10-20—36078630375875 Harbor Blvd, Gilbert, AZ, 852400.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56939TPAAngela Cook2008-11-05UHC-30513-3623985937468553 Valley View Dr, Los Angeles, CA, 900320.62Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
TPA-56007TPAMadison Fields1987-12-28—24845958501394 Willow Ct, Charlotte, NC, 282780.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50122TPASantiago Valdez2000-02-24UHC-41588-95—6743 Hillcrest Rd, Charlotte, NC, 282660.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-62305TPAAmanda K Ford1946-05-22—66781056025380 Indian School Rd, Charlotte, NC, 282330.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54254TPAChristian Morales1962-03-03——2651 Palm Dr Apt 3, Miami, FL, 331170.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-60270TPACatherine Hart1973-11-23——1502 Oak St, Gilbert, AZ, 852080.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55241TPANicholas Morgan1977-02-06——4559 Union St, Sacramento, CA, 958390.62Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-56910TPAAndrew Cole——90377915328388 Cedar Ln, Mesa, AZ, 852180.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
TPA-55590TPASamuel Kelly1979-03-20——9308 Washington St # 455, Chandler, AZ, 852450.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-60406TPAJerry Ramos———4035 Sage Ct, Chandler, AZ, 852490.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
TPA-64124TPARandy Parker1952-10-17UHC-86823-7237036459195505 Grand Ave Apt 2, Houston, TX, 770130.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-56659TPAKyle Payne1959-08-12——6422 Forest Ave, Gilbert, AZ0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62641TPADonald Gomez1938-04-07——6300 Ocean Ave Apt 18, Plano, TX, 750110.62Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-55255TPAWilliam Delgado1946-03-23UHC-33161-8040681717859138 Sunset Blvd, Fresno, CA, 937340.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-60818TPAAlex V Silva1984-08-10—32585101465783 Pine Dr, Phoenix, AZ, 850080.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54448TPATheresa Diaz1940-08-20——1367 Highland Ave, Nashville, TN, 372150.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57003TPAAlexander Johnston2006-02-24—80285156823793 Lake View Rd, Gilbert, AZ, 852470.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-64204TPAAmber Greene1990-06-27—26674035469432 Park Pl, San Antonio, TX, 782040.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-53828TPAKathleen Harris1996-05-02UHC-29359-29—7651 Ocean Ave Apt 28, Charlotte, NC, 282970.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54752TPAEric Lane1948-11-21—59863732461483 Meadow Ln, Fresno, CA, 937560.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-64465TPAAndrew Homes———4855 Mountain View Dr, Gilbert, AZ, 852910.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-54208TPAAaroon Taylor1978-06-11——4151 Sage Ct, Las Vegas, NV, 891970.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53322TPAHannah Clark1981-05-15UHC-95602-2968199262182713 Jefferson Ave, Fresno, CA, 937370.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61697TPAPhilip Brooks1954-04-07—95062825712349 Central Ave Apt 29, Tucson, AZ0.62Date of birth reformattedPhone reformattedUnit split from streetState code upper-cased+3 more
TPA-61698TPAPhilip Brooks1954-04-07—95062825712349 Central Ave Apt 29, Tucson, AZ0.62Date of birth reformattedPhone reformattedUnit split from streetState code upper-cased+3 more
TPA-54870TPALori Garcia1993-06-24UHC-39221-56—988 Sage Ct # 598, Tampa, FL, 336910.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-59456TPAWayne Marshal1983-10-09—39122030856085 Church St, San Antonio, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56139TPAAdam Welch1959-06-12—94631287044241 Desert Sky Blvd, Tampa, FL, 336480.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62588TPATyler Peters2001-11-01——1544 Market St, Fresno, CA, 937380.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62485TPAMark Y Hicks1991-04-12——2633 Hillcrest Rd, Austin, TX, 787180.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55627TPAPeter Salazar1985-08-06——624 Grand Ave, Dallas, TX, 752460.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-51812TPACarol Perry1987-06-27UHC-00745-17—2551 Washington St, Plano, TX, 750430.62Name re-casedDate of birth reformattedCity re-casedZIP+4 trimmed+3 more
TPA-62278TPASean Kelly2003-08-08——4766 Grand Ave, Eden Prairie, MN, 553070.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57520TPAJoe Turner1987-12-01—374515797555 Union St, Charlotte, NC, 282960.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50272TPACarol Hunt1967-11-23—55337607883809 Apache Blvd Apt 30, Columbus, OH, 432150.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
TPA-56344TPADiane Weaver1964-05-12—65238492842791 Maple Ave, Atlanta, GA, 303190.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52468TPARaymond Gardner1948-01-19——1331 Indian School Rd, Scottsdale, AZ, 852600.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53838TPANathan Rose1964-05-05——439 Baseline Rd, Denver, CO, 802690.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50871TPARuth M Murray1938-05-13UHC-90896-5828931167701962 Lake View Rd Apt 5, Dallas, TX, 752590.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50870TPARuth M Murray1938-05-13UHC-90896-5828931167701962 Lake View Rd Apt 5, Dallas, TX, 752590.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-61146TPAEthan Sims1969-05-08—61393807396288 Elm St, Plano, TX0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60067TPACarolyn Cole1970-01-18—39376355964149 Mountain View Dr, Tempe, AZ, 852880.62Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
14,474 rows, page 40 of 290PreviousNext