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-55674TPAAmber E Reyes1997-03-24——6206 Ridge Rd, Minneapolis, MN, 554110.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59763TPAJacob Wallace1969-05-04—8632623231—0.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
TPA-63166TPAYukki Ruiz1972-03-21——6056 Ridge Rd, Nashville, TN, 372570.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50677TPASam Mejia2003-07-13——3601 Canyon Rd # 573, Sacramento, CA, 958470.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-59687TPAChristina Morgan1976-12-17——5685 Cedar Ln, Phoenix, AZ, 850430.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-52821TPAStephanie X Burns1963-07-07—52953539642406 Indian School Rd, Charlotte, NC, 282310.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-58263TPAMartha Warren1954-11-19——3383 Lake View Rd, Scottsdale, AZ, 852390.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58264TPAMartha Warren1954-11-19——3383 Lake View Rd, Scottsdale, AZ, 852390.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63353TPAStephen Armstrong1947-08-05——6996 Spring St, Phoenix, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-59265TPAJeremy O Barnes1995-11-25—64852525638573 Ocean Ave # 464, Chandler, AZ, 852610.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-59339TPANathan Nelson1980-02-19UHC-05465-76—2023 Park Pl, Tampa, FL, 336080.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-52811TPAGlorria Elliott1962-09-06——9566 Hillcrest Rd, Houston, TX, 770080.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-53610TPAIsabella Fernandez———4521 Jefferson Ave, Orlando, FL, 328430.66Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-54333TPAAlexis Ruiz1973-05-05——3858 Harbor Blvd, Sacramento, CA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-58397TPATheresa Thompson1998-04-21—30653721277858 Palm Dr, Plano, TX0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-53074TPACharles Bryant1995-10-01——8292 Hillcrest Rd # 683, Las Vegas, NV, 891060.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63041TPAPatricia Wilson1962-09-25——7558 Mesa Dr, Columbus, OH, 432200.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
TPA-55553TPAMark Cllark1939-01-17—33981614295557 Meadow Ln, Sacramento, CA, 958370.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-52364TPAKathleen Torres1993-09-19——6571 Desert Sky Blvd, Scottsdale, AZ, 852000.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55002TPADaina Grant1941-09-26UHC-53597-9652157561519206 Apache Blvd # 662, Glendale, AZ, 853500.66Name re-casedDate of birth reformattedUnit split from streetGender normalised+1 more
TPA-57483TPAJacob Smith1974-05-08——4760 Canyon Rd, Atlanta, GA, 303610.66Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-57366TPASandra Vega1949-12-23UHC-13934-8647859257462681 Lake View Rd, Glendale, AZ, 853700.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60445TPAFatima Gardner1950-06-01—23469000627090 Ocean Ave, Glendale, AZ, 853180.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-51407TPARuth Hill1985-12-12—3805349906557 Jefferson Ave # 720, Plano, TX, 750280.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-54595TPAMarilyn Hill1991-04-08——8995 Desert Sky Blvd, Tucson, AZ0.66Name re-casedState name converted to codeZIP missingWhitespace trimmed+1 more
TPA-59206TPAJason Murray1983-04-12——532 Baseline Rd, Los Angeles, CA, 900800.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60821TPAClark Elijah1945-08-06——1361 Desert Sky Blvd, Eden Prairie, MN, 553620.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
TPA-56740TPAJacqueline McCoy1939-11-01—98197562544927 Church St, San Antonio, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-61807TPAJason Wang1984-12-16——7758 Lincoln Way # 350, Mesa, AZ, 852880.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-51441TPATeresa Tran1997-11-01——9048 Grand Ave, Charlotte, NC, 282210.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59957TPAEdward Duncan1961-06-25——619 Market St, Denver, CO, 802800.66Date of birth reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
TPA-52432TPABrenda Richards1981-09-18UHC-59898-63—9371 Apache Blvd, Scottsdale, AZ, 852530.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-59939TPAStephanie F Day1968-05-02——5173 Highland Ave, Atlanta, GA, 303610.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-59516TPAHeather Duncan1946-05-05——7012 Central Ave, Mesa, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-57966TPAJennifer Santos1944-02-16——4465 Hillcrest Rd, Seattle, WA, 981300.66Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+1 more
TPA-55320TPAJulia Wells1952-11-04——1572 Jefferson Ave, Scottsdale, AZ, 852100.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-56432TPAJoan Gutierrez2006-05-28UHC-02943-57—3674 Harbor Blvd, Tampa, FL, 336830.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-58471TPAKaren P Kim1993-01-13——8068 Mountain View Dr, Dallas, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-58470TPAKaren P Kim1993-01-13——8068 Mountain View Dr, Dallas, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-50334TPAPatrick R Robinson1977-04-11UHC-78696-4327764569117387 Bayshore Dr, Sacramento, CA, 958620.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50333TPAPatrick R Robinson1977-04-11UHC-78696-4327764569117387 Bayshore Dr, Sacramento, CA, 958620.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58011TPAWalter Guzman1980-07-20—92688437989478 Washington St, Tucson, AZ, 857870.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-64096TPAKimberly Ferguson2005-09-06——9024 Mesa Dr, Scottsdale, AZ, 852470.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-63925TPASophia R Gonzales1944-04-12——9811 Ocean Ave, Minneapolis, MN, 554540.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60288TPABrandon Hall1997-08-11—92149374861192 Union St, Chandler, AZ, 852800.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
TPA-58547TPAFrank Miller1990-12-09——310 River Rd, San Antonio, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-54493TPAOmar Estrada1956-07-13—36881037815347 Sunset Blvd, Minneapolis, MN, 554050.66Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-50678TPAJordan Rice2007-11-12——6869 Ridge Rd, Miami, FL, 331120.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
TPA-61139TPAAlexander Fowler——6175116671—0.66Name re-casedDate of birth unreadablePhone reformattedGender normalised+1 more
TPA-60079TPAIsabella Freeman1965-09-13UHC-53754-47—2072 Market St, Los Angeles, CA, 900590.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
14,474 rows, page 84 of 290PreviousNext