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-51490TPACarlos Hanson1971-09-03——4864 Indian School Rd, Houston, TX, 770370.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53705TPARyan Diaz1991-04-01——1621 Willow Ct, Columbus, OH, 432950.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56753TPAArjun Hart1977-06-09——4075 Lincoln Way, Miami, FL, 331870.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-54261TPALinda Matthews2000-05-27——5828 Baseline Rd, Tampa, FL, 336930.82Date of birth reformattedPhone missing area codePlaceholder values cleared
TPA-50562TPAChristoppher Espinoza1994-09-18——5093 Lake View Rd, Eden Prairie, MN, 553780.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54023TPAShirley McDonald1949-08-25——3937 Church St, San Diego, CA, 921640.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55170TPAMelissa J Jordan1981-10-21——1628 Central Ave, Mesa, AZ, 852350.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-53956TPAHiroshi Dunn1962-03-27———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-62119TPAMariana N Rios1939-03-01—47664929818891 Pine Dr, Tampa, FL, 336240.82Middle initial moved out of first nameDate of birth reformattedPlaceholder values cleared
TPA-50735TPAArthur Mason1975-07-11——5652 Jefferson Ave # 471, San Antonio, TX, 782660.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-51999TPASusan R Perz1949-07-28—76326151464019 Sage Ct, Nashville, TN, 372550.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51998TPASusan R Perz1949-07-28—76326151464019 Sage Ct, Nashville, TN, 372550.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61865TPAAaron Scott1982-12-27——4438 Lincoln Way, Seattle, WA, 981290.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53035TPASamuel Williamson2003-01-11——8488 Valley View Dr, Austin, TX, 787980.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53950TPABardley Bell1989-10-15——8241 Meadow Ln, Jacksonville, FL, 322680.82Name re-casedGender normalisedPlaceholder values cleared
TPA-52971TPABruce Robinson1945-08-13—73330200342956 Spring St, Charlotte, NC, 282080.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63113TPAShirley Rojas1966-01-02——4695 Indian School Rd, Fresno, CA, 937600.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51657TPAJesse Alvarez1939-04-07——8496 Harbor Blvd, Scottsdale, AZ, 852710.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-51988TPABrenda Warren1960-08-12——331 Harbor Blvd, Glendale, AZ, 853980.82City re-casedGender normalisedPlaceholder values cleared
TPA-52452TPAAbigail Fowler1986-06-21——4013 Broadway, Charlotte, NC, 282400.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-63210TPAShirlay Bowman2008-11-14——2368 Spring St, Columbus, OH, 432670.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-60921TPADouglas Santos1976-05-26———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-51345TPAMelissa Thompson1990-08-26——9669 Valley View Dr, Orlando, FL, 328890.82Name re-casedGender normalisedPlaceholder values cleared
TPA-61540TPAHiroshi Garza2006-11-05—80657863613626 Indian School Rd, Plano, TX, 750180.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62807TPACarol O Bryant1951-09-03——2505 Meadow Ln, Jacksonville, FL, 322920.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54555TPASteven Scott1953-04-17———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-62451TPADenise Lynch1987-10-14UHC-13077-33—4471 Indian School Rd, Miami, FL, 331350.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52046TPAJulia Pena1937-11-13——8514 Indian School Rd, Phoenix, AZ, 850740.82Phone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-59814TPALawrence Fox1941-09-28——4708 Park Pl, Mesa, AZ, 852330.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57471TPAAhmed Singh1979-01-17——1917 Grand Ave, Miami, FL0.82ZIP missingEmail lower-casedPlaceholder values cleared
TPA-54686TPAAhmed Garza1967-12-09——9602 Palm Dr, Nashville, TN, 372920.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-59086TPAStephanie Armstrong1994-01-24———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-50083TPAGeorge Knight1976-08-20——5156 Palm Dr, Gilbert, AZ, 852920.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53452TPAThomas Day1955-03-09UHC-43689-23—990 Sunset Blvd, Gilbert, AZ, 852680.82Name re-casedGender normalisedPlaceholder values cleared
TPA-61802TPAJremy Yang1957-01-06——7540 Valley View Dr, Phoenix, AZ, 850490.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-50231TPAMartha A Martinez1965-11-09UHC-71585-61—4824 Maple Ave, Scottsdale, AZ, 852610.82Member ID reformattedGender normalisedPlaceholder values cleared
TPA-58840TPAOlivia Campbell1987-09-15———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-51962TPAWalter Coleman1958-02-24——4297 Canyon Rd, Houston, TX, 770600.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-50194TPASarah Patterson2000-04-06———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60560TPADensie Stewart1985-01-04——5897 Lincoln Way # 251, Seattle, WA, 981480.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-57751TPAHart Sandra1950-09-18UHC-51984-99——0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-53406TPARachel Hart2008-09-02———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-62927TPAPamela Russell1939-08-22———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-54669TPAEugene Peterson1942-11-20——2480 Ocean Ave, Minneapolis, MN, 554890.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-52012TPAHannah Hunter1956-12-07—64053212218685 Market St, Los Angeles, CA, 900720.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51782TPAZachary R Carpenter1946-09-12——4234 Central Ave, Phoenix, AZ, 850250.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62089TPAStephanie Bnnett1990-02-04——9669 Maple Ave, Glendale, AZ, 853010.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57402TPAElijah Tucker1958-10-28—98236459186906 Harbor Blvd, Plano, TX, 750550.82Date of birth reformattedPhone reformattedState name converted to code
TPA-63808TPADouuglas Guerrero1996-08-04—65088304083106 Baseline Rd, Nashville, TN, 372220.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55683TPAWillie Guuzman1959-02-17—62423385548300 Hillcrest Rd, Atlanta, GA, 303340.82Street suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 207 of 290PreviousNext