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-59468TPABrittany Medina1995-11-10—38085636008502 Baseline Rd, Glendale, AZ, 853110.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57973TPAPeter Richardson1988-10-15——4232 Mesa Dr, Phoenix, AZ, 850080.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-55740TPADanielle Thompson1993-05-12UHC-07773-71—5664 Ridge Rd, Columbus, OH, 432210.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-56894TPAAshley Kelley1990-07-03——9283 Indian School Rd, San Diego, CA, 921290.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-61700TPAJordan Greene——23292024952298 Camelback Rd # 808, Scottsdale, AZ, 852550.52Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-54548TPATerresa Myers1966-05-12UHC-67569-91—3439 Pine Dr # 322, Tucson, AZ, 857630.52Name split from “Last, First”Date of birth reformattedUnit split from streetGender normalised+2 more
TPA-61166TPADeborha Owens1969-09-28——7234 Highland Ave, Fresno, CA, 937210.52SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-62922TPAThomas Jimenez1993-09-18——7889 Forest Ave # 726, Gilbert, AZ, 852670.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-63948TPANatalie Ryan2004-06-05——9790 Washington St # 404, Minneapolis, MN0.52Name re-casedUnit split from streetZIP missingGender normalised+2 more
TPA-61511TPAKayla Brooks———9810 Forest Ave, Miami, FL, 331050.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61309TPAAhmed Li——8079369613—0.52Name split from “Last, First”Date of birth unreadablePhone reformattedGender normalised+2 more
TPA-58524TPAMarcus Boyd1980-03-05—88523314518120 Central Ave Apt 2, Las Vegas, NV, 891440.52Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
TPA-56478TPASteven George—UHC-39607-73—3251 Desert Sky Blvd, Charlotte, NC0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-57168TPAAlice I Sanders2002-07-10——1418 Forest Ave, Plano, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-57167TPAAlice I Sanders2002-07-10——1418 Forest Ave, Plano, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-61310TPAAhmed I Li———9424 Park Pl, Eden Prairie, MN, 553610.52Name re-casedDate of birth missingState name converted to codeGender normalised+2 more
TPA-61489TPAValentina Morris2000-09-25UHC-14927-47—1890 Mesa Dr, Austin, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-59776TPANancy Austin1950-10-02——3707 Valley View Dr # 833, Austin, TX0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62452TPADenise L Hughes1997-09-03——8318 Central Ave, Denver, CO, 802190.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-58481TPAGerald Banks1998-10-17UHC-54196-42—1424 Desert Sky Blvd, Mesa, AZ0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-51416TPAKevin Rogers1973-08-11——4596 Central Ave, Plano, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-54609TPA—Junk2004-04-13—62880478415051 Market St, Plano, TX, 750430.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61902TPAJames Gardner1993-12-01——4528 Desert Sky Blvd, Nashville, TN0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-57281TPAEthan Welch———1962 Mesa Dr # 404, San Antonio, TX, 782210.52Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-55690TPAJohn Harper2004-01-19——7402 Ocean Ave, Atlanta, GA, 303890.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-50283TPALauren Spencer1956-03-13——9516 Valley View Dr Apt 7, Mesa, AZ, 852800.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-55424TPASharon Davis1962-12-16——5576 Highland Ave, Fresno, CA, 937500.52Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58319TPARichard Hicks1987-02-15——6440 River Rd, Eden Prairie, MN, 553210.52Date of birth reformattedCity re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-57062TPACarl Schmidt——77745733481359 Pine Dr, Mesa, AZ, 852540.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-57054TPAMarrk Green1988-03-05UHC-58036-68—464 Ocean Ave, San Diego, CA, 921140.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-52112TPADiane S Banks1988-03-16——8353 Ocean Ave, Orlando, FL, 328730.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52743TPAGloria Bennett——36137358718792 Grand Ave, Minneapolis, MN, 554190.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56738TPABrian Carter1941-08-02——4200 Valley View Dr # 372, Los Angeles, CA, 900140.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50049TPADylan Reed———5538 Park Pl, Gilbert, AZ, 852090.52Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-59977TPADoris Fisher1999-12-25—30821150523931 Oak St Apt 4, Glendale, AZ, 853760.52Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+2 more
TPA-63777TPASteeve Robertson1974-04-26——4568 Canyon Rd, Fresno, CA, 937350.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62684TPALauren Reid———4573 Willow Ct, Los Angeles, CA, 900210.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57860TPAGregory Smith1980-08-27——9597 Sage Ct, Charlotte, NC, 282670.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-62454TPAJerry Mendez1963-06-22——5505 Canyon Rd # 908, Las Vegas, NV, 891990.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61993TPAPhilip T Burke1967-07-13——5182 Apache Blvd, Plano, TX, 750680.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-58073TPADenise Ward1959-07-06——8358 Lake View Rd, Miami, FL, 331130.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-52099TPAAlbert Espinoza1962-06-23——2343 Central Ave Apt 6, Plano, TX, 750500.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-51624TPAKathryn Wang2007-01-19——7432 Mountain View Dr, Chandler, AZ, 852160.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-54050TPAJoan Gilbert1995-06-14——6266 Valley View Dr # 715, Austin, TX, 787020.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
TPA-52193TPAArthur I Contreras1943-10-20UHC-78188-71—3294 Baseline Rd, Jacksonville, FL, 322770.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-55604TPAChristian West1982-01-14——7534 Sage Ct, Los Angeles, CA, 900370.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
TPA-56299TPAJudith Gomez1944-02-18——7594 Pine Dr # 271, Denver, CO, 802310.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-63202TPABarbara C Carroll1966-01-23——7998 Harbor Blvd, San Diego, CA, 921160.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59221TPAArthur Kelley1973-10-12——5723 Washington St, Jacksonville, FL, 322020.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
TPA-52298TPAKeith Hernandez1998-11-21—43535180611394 Apache Blvd # 931, Scottsdale, AZ, 852390.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
14,474 rows, page 23 of 290PreviousNext