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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-61066TPATeresa Rivera1967-12-18UHC-46808-74—9292 Forest Ave, Fresno, CA, 937170.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59033TPADonald Wallace1977-01-23—24932361817020 Forest Ave, Columbus, OH, 432550.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51152TPAJuan Wheeler1984-09-25——1189 Ocean Ave, Scottsdale, AZ, 852740.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50513TPAJudy Ford1982-07-24—95229560283524 Market St, Tucson, AZ, 857930.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
TPA-50510TPADonna Weaver1983-01-05——8693 Desert Sky Blvd, Chandler, AZ, 852990.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50509TPADonna Weaver1983-01-05——8693 Desert Sky Blvd, Chandler, AZ, 852990.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59415TPAPhilip O Rodriguez1939-08-18UHC-28391-78—4856 Desert Sky Blvd, Atlanta, GA, 303340.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-57801TPACynthia Ford1986-06-11—6936057795—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52326TPAKathryn J Watson2004-11-20——3234 Palm Dr, Charlotte, NC, 282110.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64292TPAGary Santos1957-03-08——947 Grand Ave, Miami, FL, 331680.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55338TPABenjamin Shaw1993-05-24—63591949244124 Bayshore Dr, San Antonio, TX, 782980.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60028TPATiimothy Carpenter1970-04-07UHC-24778-33—8987 Hillcrest Rd, Mesa, AZ, 852170.80Name split from “Last, First”Date of birth reformattedCity re-casedWhitespace trimmed
TPA-56476TPAAlice Gutierrez2008-02-02——8084 Baseline Rd, Tampa, FL, 336260.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61373TPALius Kelley1998-05-21—80646473254043 Spring St, Las Vegas, NV, 891280.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-56465TPAChristine Adams1968-07-14—84387368171600 Maple Ave, Las Vegas, NV, 891780.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
TPA-60304TPAJulia G Meyer1969-08-25——5564 Central Ave, Minneapolis, MN, 554740.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56875TPAAizha Patel1941-10-21———0.80Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-58248TPAGary Brown1950-01-24UHC-63458-01—5247 Jefferson Ave, Tucson, AZ, 857890.80Date of birth reformattedCity re-casedState name converted to codePlaceholder values cleared
TPA-57980TPAMarcus Stephens2007-12-18—28048869645019 Mesa Dr, Columbus, OH, 432950.80Phone reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased
TPA-51847TPAMatt Carroll1999-01-17——223 Market St, San Diego, CA, 921250.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51876TPAScott Garrett1953-01-20—23048710979209 Desert Sky Blvd, Las Vegas, NV, 891910.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52974TPAMichael Olson1956-12-01——7701 Bayshore Dr, Nashville, TN, 372650.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59860TPALarry S Cole1986-09-09UHC-55286-40—7402 Meadow Ln, Jacksonville, FL, 322620.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-52707TPACatherine Diaz2002-04-23——8471 Union St, Glendale, AZ, 853770.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-59664TPADavid Ford1991-03-11——9634 Baseline Rd, Columbus, OH, 432760.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56264TPACynthia Bryant1971-11-16UHC-52549-89—5310 Washington St, Los Angeles, CA, 900110.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52514TPASantiago Mendoza1939-10-25———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55835TPAKatherine Gomez————0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-50153TPAMarcus Luna1991-11-07—35039225942817 Bayshore Dr, Las Vegas, NV, 891260.80Phone reformattedCity re-casedZIP+4 trimmedPlaceholder values cleared
TPA-63817TPAJlie Palmer1948-07-04——2721 Palm Dr, Chandler, AZ, 852930.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-59473TPANathan Martinez1944-04-01—94944439562561 Bayshore Dr, Nashville, TN, 372070.80Phone reformattedCity re-casedState name converted to codePlaceholder values cleared
TPA-55178TPAAshley Perry1987-02-07——3205 Ridge Rd, Atlanta, GA, 303590.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56617TPASophia Maldonado2002-05-12—21972328301306 Ridge Rd, Miami, FL, 331930.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-50008TPAMartha Stone1952-05-13——776 Oak St, Eden Prairie, MN, 553320.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-64009TPAMegan Wells1950-08-28—42038500931527 Canyon Rd, Tucson, AZ, 857000.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63589TPACynthia George1980-06-14——8732 Sunset Blvd, Miami, FL, 331650.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51332TPAMegan K Gordon2001-04-14—79844458145144 Maple Ave, Tampa, FL, 336630.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58466TPALogan Ward1949-05-04UHC-80647-46—2233 Cedar Ln, Plano, TX, 750510.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59188TPAWillie Paark1944-02-21—29094737653730 Elm St, Denver, CO, 802490.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60225TPADenise Vargas1949-10-23—6146730135—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56576TPAAnn Adams1983-01-10—56150627375537 Camelback Rd, Sacramento, CA, 958320.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62058TPASamuel Weaver1995-11-10——7528 Central Ave, Mesa, AZ, 852330.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60381TPAOlivia F Day1963-05-16UHC-80025-41—9042 Pine Dr, Tampa, FL, 336280.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63952TPASarah Cook2000-11-01——103 Grand Ave, Dallas, TX, 752190.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52718TPAMichelle Nelsno1947-08-08——2704 Lincoln Way, Nashville, TN, 372860.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-50805TPABetty T Peters1940-12-28——7521 Camelback Rd, Sacramento, CA, 958810.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-55221TPADebra Lewis1949-12-24—43480893989547 Meadow Ln, Austin, TX, 787660.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-59873TPAZachary George1982-02-19——8626 Ridge Rd, Seattle, WA, 981230.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51749TPAJeremy Snyder1997-11-27——4178 Park Pl, Jacksonville, FL, 322090.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61402TPAThomas Jordan2002-12-16—71049813492492 Hillcrest Rd, Scottsdale, AZ, 852240.80Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased
14,474 rows, page 181 of 290PreviousNext