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-57697TPAJack Hart2004-03-07—66235312825071 Hillcrest Rd, Plano, TX, 750860.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
TPA-56959TPAGeorge Bennett1984-02-09UHC-71808-02—4299 Mountain View Dr, Orlando, FL, 328170.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52393TPACynthia Tucker——9889590428—0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50916TPALuis Sullivan1943-02-09——2265 Maple Ave Apt 19, Los Angeles, CA, 900100.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56440TPANicole Long1966-04-13——200 Grand Ave, Chandler, AZ, 852030.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51430TPAAshley Park1946-12-01UHC-07501-1487761704219167 Forest Ave, San Antonio, TX, 782970.68Phone reformattedState name converted to codeZIP+4 trimmedPlaceholder values cleared
TPA-63295TPAJennifer Bowman1995-06-08——9289 Canyon Rd, Mesa, AZ, 852440.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-63930TPAMason Q Stone1983-10-10——5591 Park Pl, Glendale, AZ, 853920.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
TPA-57527TPABrian Gutirerez1995-03-11——6475 Central Ave, Sacramento, CA0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-57755TPAHenry Jacobs1983-09-26—33347961399810 Palm Dr, Houston, TX, 770830.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-57112TPALarry Richardson1968-09-23——5408 Ocean Ave, Atlanta, GA, 303180.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60630TPASofia Walkre1997-10-01——3784 Oak St, Mesa, AZ0.68Date of birth reformattedZIP missingGender normalisedPlaceholder values cleared
TPA-64265TPATyler Daniels1980-04-06——1390 Hillcrest Rd, Las Vegas, NV, 891040.68Phone missing area codeGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52563TPADurisJunk1951-03-03——1581 Canyon Rd, Houston, TX, 770970.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
TPA-53431TPASuphia Bowman1983-01-26UHC-12484-24—1910 Forest Ave, San Diego, CA, 921670.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52936TPAVirginia Hoffman1947-09-20——4417 Spring St, Plano, TX, 750000.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-50074TPARick Kelley1961-01-10——1539 Spring St # 849, Atlanta, GA, 303070.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
TPA-57729TPAWliliam Patterson1974-02-18——9035 Sunset Blvd, Miami, FL, 331720.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56722TPAAlan Cole1941-01-04——5628 Forest Ave, Austin, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-50078TPAJean Torres1997-05-05——2059 Camelback Rd, Houston, TX, 770250.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-54213TPADiego Greene2000-06-01UHC-14523-34—6260 Camelback Rd, Glendale, AZ, 853700.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56353TPABrooks Valentina1954-12-15UHC-68658-61801520453245 Hillcrest Rd, Minneapolis, MN, 554340.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-53685TPAJcqueline Grant1978-12-02——9887 Spring St, Charlotte, NC, 282690.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54090TPABrandon Peena1938-08-08——3328 Ridge Rd, Plano, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-60668TPALucia L Baker2008-04-25——6471 Cedar Ln, Dallas, TX, 752160.68Name re-casedTwo-digit birth yearState name converted to codePlaceholder values cleared
TPA-53353TPAEmma Graham1978-09-13——6542 Central Ave, Glendale, AZ, 853060.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52365TPATimothy Rice———7784 Canyon Rd, Fresno, CA, 937140.68Date of birth unreadablePhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-56284TPABradley Arnold1957-01-14——525 Lake View Rd, Gilbert, AZ, 852710.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-55482TPAElizabeth Shaw1951-01-16—34569009564539 Oak St, Gilbert, AZ, 852810.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-55652TPAFrances Z Larson1940-09-28—46394048002245 Highland Ave, Tempe, AZ, 852910.68Two-digit birth yearPhone reformattedState name converted to codePlaceholder values cleared
TPA-58961TPAPaul Brooks1952-12-01——5911 Lake View Rd, Tucson, AZ, 857620.68Name split from “Last, First”City re-casedState name converted to codePlaceholder values cleared
TPA-51737TPAElijah Reynolds——38029254212737 Baseline Rd, Chandler, AZ, 852850.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
TPA-55514TPAAmber Castro1997-08-04——6391 Elm St, Atlanta, GA, 303580.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55565TPAJesse Morgan1946-10-11UHC-62080-2489653527305089 Indian School Rd, Denver, CO, 802890.68Two-digit birth yearPhone reformattedState name converted to codePlaceholder values cleared
TPA-60488TPAAnna Wong————0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-57802TPAAndrea Patel2008-04-01——9262 Hillcrest Rd, Columbus, OH, 432010.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-62309TPAJeffrey Y Guerrero1971-02-16UHC-34240-66—7245 Grand Ave, San Diego, CA, 921720.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50468TPADavid Contreras1993-11-13——8288 Spring St, Glendale, AZ, 853450.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-63347TPALauren Barnes———9543 Union St, Denver, CO, 802060.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58907TPASamantha King1995-06-21——8728 Hillcrest Rd Apt 9, San Diego, CA, 921020.68Unit split from streetState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-55828TPASusan Adams1992-09-01—53881365628014 Valley View Dr, Minneapolis, MN, 554100.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
TPA-60008TPARussell Gutierrez1986-01-15——1669 Market St, Minneapolis, MN, 554540.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61774TPAFatima James1959-08-22——751 Ridge Rd, Atlanta, GA, 303560.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60123TPAMaria Scott1942-07-07——7104 Church St, Austin, TX, 787790.68Two-digit birth yearState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-51839TPAChristine Coleman1988-07-15———0.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
TPA-51951TPAWillie Boyd2004-10-16UHC-34280-19—2977 River Rd, Gilbert, AZ, 852610.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-64324TPARoger G Martinez1990-03-15——6998 Cedar Ln, Phoenix, AZ, 850490.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53459TPAJanice Simpson1998-06-25—2879244771—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
TPA-60868TPADorothhy C Fox1960-10-15——6342 Willow Ct, Minneapolis, MN, 554300.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55268TPAAbigail Taylor1942-07-02——7514 Market St, Dallas, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
14,474 rows, page 92 of 290PreviousNext