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-51000TPAGerald Walsh2000-04-07——8766 Forest Ave, Plano, TX, 750520.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-56083TPACheryl Cruz1952-05-01———0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-50748TPAJacob Diaz1951-10-15—262935769537 Camelback Rd, Glendale, AZ, 853270.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53312TPABruce Sanchez1966-12-13UHC-67947-39—9891 Highland Ave # 771, Tempe, AZ, 852160.68Member ID reformattedUnit split from streetGender normalisedPlaceholder values cleared
TPA-60436TPARonald West2007-07-24—34990132551699 Union St, Minneapolis, MN, 554670.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-59770TPARuth Olson1960-10-19——8833 Sage Ct, Seattle, WA, 981200.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63760TPAJordan Munoz2007-05-27UHC-45378-23—4852 Mountain View Dr, Mesa, AZ, 852110.68Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased
TPA-58058TPATimothy P Castillo1953-12-13—80528476703418 Baseline Rd, Tucson, AZ0.68Name re-casedTwo-digit birth yearZIP missingPlaceholder values cleared
TPA-63418TPADaniel Davis2004-12-08UHC-43463-17—8632 Camelback Rd, Dallas, TX, 752720.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-56462TPAJacob Watkins1948-01-23—98252317421221 Church St, Fresno, CA, 937190.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-53545TPAMegan Henry1944-01-14——4325 Hillcrest Rd, Las Vegas, NV, 891530.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-50156TPABobby C Gilbert2001-02-27——6310 Grand Ave, Dallas, TX, 752530.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62729TPABetty Stephens2006-12-15——2735 Lincoln Way, Atlanta, GA, 303370.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64437TPACarlos Gardner1963-10-26——503 Elm St, Columbus, OH, 432410.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-61561TPADonald Kennedy2005-08-27——2438 Grand Ave Apt 28, Austin, TX, 787580.68Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-58069TPASullivan Janet1962-02-20UHC-73270-99——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62699TPAEthan S Butler1957-01-03UHC-86946-5925525166784299 Forest Ave, Columbus, OH, 432840.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-52794TPATerry Coooper1988-02-23——3070 Bayshore Dr, Minneapolis, MN, 554390.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-57604TPAEdward Gomez1996-05-03—27467184026547 Ridge Rd Apt 23, Eden Prairie, MN, 553660.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51415TPAJackie K Allen1974-05-11——7384 Palm Dr, Plano, TX, 750390.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57033TPACynthia Webb1953-08-22——4802 Hillcrest Rd, Scottsdale, AZ0.68Name split from “Last, First”City re-casedZIP missingPlaceholder values cleared
TPA-64171TPACarolyn Gonzalez2007-10-04———0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56331TPABilly Parkeer1967-06-08——6710 Maple Ave, Mesa, AZ, 852200.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-61482TPAMadison Coopre2001-05-26——300 Church St, Las Vegas, NV0.68Name re-casedZIP missingGender normalisedPlaceholder values cleared
TPA-53133TPANicholas Gibson———6030 Camelback Rd, Minneapolis, MN, 554890.68Date of birth missingGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58429TPAWalter Gilbert1963-05-27——2595 Maple Ave, Chandler, AZ, 852660.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51774TPAAlexander F Berry1967-05-21——806 Apache Blvd, Los Angeles, CA, 900480.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64370TPADorothy Gomeez———4929 Elm St, Los Angeles, CA, 900300.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54516TPAAnela Moreno1984-07-14——5944 Park Pl, Houston, TX, 770010.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
TPA-51311TPACharlotte Rogers1974-05-26—68233511381968 Cedar Ln, Columbus, OH0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-59145TPARaymond Munoz1976-05-13——8454 Apache Blvd, Scottsdale, AZ, 852480.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54570TPAMargaret Owens1976-07-02——549 Oak St, Tampa, FL, 336380.68Name re-casedTwo-digit birth yearState name converted to codePlaceholder values cleared
TPA-62094TPADeborah Perry1941-09-28——1929 Oak St, Fresno, CA, 937770.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-52910TPADenise T Henderson————0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-53302TPAJeremy Hunt1973-03-21UHC-40999-45—9281 Sunset Blvd, Tucson, AZ, 857500.68Two-digit birth yearState code upper-casedZIP+4 trimmedPlaceholder values cleared
TPA-57487TPAJudith Cunningham1999-05-20UHC-01302-60—2252 Mesa Dr, Minneapolis, MN, 554360.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60302TPABryan Hayes1950-07-05——994 Park Pl, Tempe, AZ, 852250.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60301TPABryan Hayes1950-07-05——994 Park Pl, Tempe, AZ, 852250.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63046TPARussell Torres1984-12-02UHC-27828-45—4623 Lake View Rd # 404, Nashville, TN, 372050.68Unit split from streetGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56309TPACamila Ortiz2008-06-21——8674 Cedar Ln, Houston, TX, 770470.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-56853TPAHannah Dunn1973-09-11——9272 Mountain View Dr, Dallas, TX, 752170.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-64232TPABobby Simpson1961-07-27——133 River Rd, Dallas, TX, 752570.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-59980TPAJonathan Alexander2001-11-14——1803 Willow Ct # 197, Las Vegas, NV, 891340.68Name re-casedUnit split from streetZIP+4 trimmedPlaceholder values cleared
TPA-54845TPAAlexander T Parker1977-02-05——5802 Palm Dr, Nashville, TN, 372820.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-61352TPAKimberly Bell1938-02-18—57870199059241 Elm St, Mesa, AZ, 852700.68Two-digit birth yearState code upper-casedGender normalisedPlaceholder values cleared
TPA-60561TPAMargaret Roberts1939-12-16——5221 Cedar Ln, Houston, TX, 770170.68Name split from “Last, First”Date of birth reformattedSSN last four extractedPlaceholder values cleared
TPA-57324TPAMadison Lee1972-03-08——4679 Bayshore Dr, Chandler, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-58285TPAAmanda McCoy2002-05-06UHC-05467-15—9338 Jefferson Ave, Chandler, AZ, 852430.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-58403TPASandra White1941-03-24——498 Main St, San Antonio, TX, 782530.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62655TPAMartha Davis1983-01-03—72373251121368 Harbor Blvd, San Antonio, TX, 782710.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
14,474 rows, page 100 of 290PreviousNext