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

Provider network, lowest dq score first

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-20882PRVRalph Shaw1955-09-18UHC-87502-9881350073356408 Central Ave, San Antonio, TX, 782380.90Name re-casedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
PRV-25914PRVWayne Davis1956-05-25UHC-67278-9624484152144681 Oak St, Eden Prairie, MN, 553090.90Name re-casedDate of birth reformattedMember ID reformattedWhitespace trimmed+1 more
PRV-22452PRVJulia Jensen1958-06-21—38946187076824 Broadway, Phoenix, AZ, 850140.90Phone reformattedCity re-casedState code upper-casedWhitespace trimmed+1 more
PRV-21044PRVAbigail Freeman1940-01-20—39757756707577 Baseline Rd, Minneapolis, MN, 554770.90Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
PRV-26987PRVCalros Wang1947-05-21UHC-28233-139844229467—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
PRV-22586PRVEvelyn C Lane1985-04-14UHC-61513-035677666790—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28800PRVHarold Lewis1983-03-15—4272662732—0.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-24313PRVBrandon S Fernandez1986-09-06UHC-58402-8070998751604574 Canyon Rd, Seattle, WA, 981860.92Phone reformattedMember ID reformattedWhitespace trimmedPlaceholder values cleared
PRV-21490PRVRaymond H Schmidt1954-07-01—66262102578835 Valley View Dr, Jacksonville, FL, 322610.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-27407PRVArthur Wallace1961-07-10—6658667099—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20267PRVBarbara Greene2007-11-17—37649921396074 Washington St, Scottsdale, AZ, 852020.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-23876PRVFrances B Carpenter1989-07-13—27893705781399 Mountain View Dr, Plano, TX, 750460.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26479PRVChristine W Singh1970-02-03—2526413605835 Main St, Tempe, AZ, 852550.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-26566PRVRuth Olson1960-10-19UHC-37143-79—8833 Sage Ct, Seattle, WA, 981200.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-29533PRVMateo Black1994-09-12—3126194905—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-21335PRVDebra H Marquez1996-03-18—58796863166543 Lincoln Way, Mesa, AZ, 852740.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
PRV-20493PRVJoan Z Peters1971-09-12UHC-81748-1529558233862879 Camelback Rd, Eden Prairie, MN, 553630.92Phone reformattedCity re-casedEmail lower-casedPlaceholder values cleared
PRV-20833PRVSarah Reed1980-11-17—4288826213—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-22367PRVThomas I Sullivan1982-02-28—76597271378589 Indian School Rd, Denver, CO, 802850.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-29026PRVJerry Banks1945-09-20—6254404110249 Oak St, Columbus, OH, 432020.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-28594PRVAnn B Sims1992-02-16—4029507313—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26582PRVBrenda A Baker1962-01-23UHC-57775-486448973432—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-29578PRVTyler Lewis1972-06-24—26761431332862 Forest Ave, Los Angeles, CA, 900800.92Phone reformattedCity re-casedEmail lower-casedPlaceholder values cleared
PRV-22909PRVMariana T Green1989-08-17UHC-41515-80—9052 Grand Ave, Denver, CO, 802220.92City re-casedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-22497PRVChristian Marshall1994-01-04UHC-58093-6984850916165719 Sunset Blvd, Minneapolis, MN, 554780.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28787PRVCarolyn Li1947-07-28—7749764183—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23068PRVVictoria Contreras1974-07-19—5102282443—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22366PRVJeean Watkins1990-03-21——5101 Mountain View Dr, Seattle, WA, 981530.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-24585PRVCarolyn Fields1953-10-11—35152235309599 Lincoln Way, Tampa, FL, 336110.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24870PRVSamuel F Bunrs1982-07-12UHC-91892-688969619072—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28465PRVRyan Washington1986-04-02—44320455157264 Lincoln Way, Glendale, AZ, 853610.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-26662PRVValentina Wong1950-04-08UHC-87911-515475147665316 Pine Dr, Gilbert, AZ, 852400.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28783PRVBilly Hayes1974-05-19—20677690943862 Apache Blvd, Tucson, AZ, 857650.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-28782PRVBilly Hayes1974-05-19—20677690943862 Apache Blvd, Tucson, AZ, 857650.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-24827PRVBeverly Sanchez1980-11-10UHC-76900-915537700961—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-21772PRVDebra Collins1980-11-19UHC-86010-856784952922—0.92Phone reformattedMember ID reformattedWhitespace trimmedPlaceholder values cleared
PRV-24418PRVAlbert O Tran2004-12-08—74184279782632 Cedar Ln, Austin, TX, 787790.92Date of birth reformattedPhone reformattedCity re-casedPlaceholder values cleared
PRV-28321PRVKelly Berry1991-01-10UHC-75286-6526398480634490 Hillcrest Rd, Eden Prairie, MN, 553610.92Name re-casedPhone reformattedMember ID reformattedPlaceholder values cleared
PRV-29178PRVMason Stephen1947-02-10—34551109245786 Church St, Austin, TX, 787210.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-27564PRVCynthia Porter1983-10-11—2749709102—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24226PRVGloria Richardsoon1981-06-07UHC-97404-898168222234—0.92Name re-casedPhone reformattedEmail lower-casedPlaceholder values cleared
PRV-21862PRVRalph Gutierrez1950-11-24—31143976029361 Sage Ct, Denver, CO, 802590.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25300PRVSara Jones1965-11-04—8552580299—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22433PRVMateo K Clark2006-01-06UHC-38810-308574659904399 Mesa Dr, Scottsdale, AZ, 852040.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-29076PRVCarolyn Mendez1962-06-27—9322944875—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-25985PRVRebecca Foster1972-09-20UHC-85099-2437556381062598 Oak St, San Diego, CA, 921980.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-25987PRVAlexis Armstrong1996-08-18UHC-63561-9560158688881658 Canyon Rd, Austin, TX, 787330.92Phone reformattedMember ID reformattedState code upper-casedPlaceholder values cleared
PRV-28706PRVAhmed Campbell1939-09-19—40988468771367 Cedar Ln, San Antonio, TX, 782150.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20927PRVRaymond Murphy1991-12-08——9534 Lincoln Way, Scottsdale, AZ, 852430.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
PRV-23155PRVKatherine O Porter1983-04-25UHC-44069-862825333842—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 159 of 192PreviousNext