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

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-21994PRVBradley B Russell2000-07-16UHC-45171-1127499221935244 Valley View Dr, Minneapolis, MN, 554460.66Two-digit birth yearPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
PRV-24424PRVElizabeth Ray1992-08-26UHC-71909-0154035878213693 Main St, Scottsdale, AZ, 852880.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-24776PRVLori S George1947-08-05UHC-37487-2754371239506812 Broadway, Tempe, AZ, 852390.66Name split from “Last, First”Date of birth reformattedMember ID reformattedGender normalised+1 more
PRV-20948PRVKeith Bennett———1922 Ocean Ave, Jacksonville, FL, 322270.66Name re-casedDate of birth unreadableZIP+4 trimmedWhitespace trimmed+1 more
PRV-22746PRVElijah Gray2003-07-26UHC-73436-7763829698911329 Elm St, Minneapolis, MN0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-26632PRVScott Thomas1979-06-10—71383050683750 Bayshore Dr, Chandler, AZ, 852390.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-20842PRVMaria Snyder1940-07-24——6204 Ocean Ave Apt 13, Plano, TX, 750300.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21980PRVGloria Stone1965-04-03UHC-46016-1848633769742107 Park Pl, Charlotte, NC0.66Name re-casedPhone reformattedState name converted to codeZIP missing+1 more
PRV-28570PRVAshley E Wallace1961-07-08—84780643592406 Church St, Tucson, AZ, 857720.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-20788PRVCarl Lynch1955-06-17—41263200422173 Highland Ave, Charlotte, NC, 282980.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21914PRVMelissa Q Montgomery1985-02-11—39852848491611 Spring St, Plano, TX0.66Name re-casedPhone reformattedZIP missingGender normalised+1 more
PRV-20143PRVSantiago Peters1999-11-21UHC-16126-85—8248 Willow Ct, San Antonio, TX, 782100.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-25413PRVChristine Warren1963-10-03—80266794469742 Sunset Blvd, Dallas, TX, 752480.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-29365PRVVirginia Fowler1958-10-27UHC-04162-6258288424219688 Union St, Las Vegas, NV, 891260.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-29232PRVSamantha R Thompson1941-01-01—41399368432218 Indian School Rd, Austin, TX, 787130.66State code upper-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-28775PRVAshley Marquez1939-01-03—4835801301384 Lake View Rd, Nashville, TN, 372790.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-28269PRVJesse Bker1985-01-05UHC-05897-89—6412 Lincoln Way, Houston, TX, 770330.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-26655PRVRandy Green2005-06-07—248998024749 Ocean Ave, Tempe, AZ, 852110.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-26052PRVSandra Reynolds1954-03-23—75834367607653 Valley View Dr, Austin, TX, 787850.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-29333PRVMargaret F Fernandez1938-09-28UHC-38371-52—1878 Ocean Ave, Atlanta, GA, 303090.66Date of birth reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
PRV-22709PRVBrandon H Walker1966-03-01—62581594315607 Cedar Ln, Mesa, AZ, 852380.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-29510PRVSandra M Scott1974-11-01—41158087823389 Harbor Blvd, Las Vegas, NV, 891580.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-25865PRVWilliam Garcia1954-01-11UHC-02353-2222429303884474 Highland Ave, San Antonio, TX, 782340.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-27859PRVLarry A Evans1973-09-28—86947809536969 Harbor Blvd, Mesa, AZ, 852650.66Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+1 more
PRV-22861PRVFrances D Graham1971-04-22——1867 Ocean Ave, Nashville, TN0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
PRV-22862PRVFrances D Graham1971-04-22——1867 Ocean Ave, Nashville, TN0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
PRV-27804PRVMartha Q Soto1987-07-21UHC-39559-9864941239421011 Lincoln Way, Glendale, AZ, 853370.66Name split from “Last, First”Phone reformattedEmail lower-casedGender normalised+1 more
PRV-23386PRVMelissa Jordan1981-10-21—63088226531628 Central Ave, Mesa, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-25850PRVVirginia M Chapman1962-03-20UHC-48124-8179045424935683 Forest Ave, Miami, FL, 331470.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
PRV-22571PRVJohn Lee1980-12-10—27851920627726 Mesa Dr, Nashville, TN, 372980.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22651PRVKathryn Tran1970-07-24—68738482504838 Mountain View Dr, Tucson, AZ, 857540.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-27143PRVMariaa Hart1940-09-21——4802 Union St, Gilbert, AZ, 852650.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21958PRVGabriel Ross1982-07-27—41237472435064 Mesa Dr, Sacramento, CA0.66Phone reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
PRV-20934PRVJack Fisher1998-07-20—69576617702171 Mountain View Dr, Charlotte, NC, 282880.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21197PRVScott Long1943-11-10——484 Willow Ct, Austin, TX, 787380.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-27242PRVBradley Morgan1948-01-20—38449813006148 Cedar Ln, Atlanta, GA, 303590.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-23843PRVRoy Patl1990-10-21UHC-86246-70—567 Elm St, Dallas, TX, 752910.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-26534PRVMarilyn Daniels1964-06-17—90254550442712 Canyon Rd, Tempe, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-27232PRVMarilyn Jones—UHC-57668-65—9289 Main St, Fresno, CA, 937800.66Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-24070PRVJimmy Yaang1959-04-07——1173 Canyon Rd, Scottsdale, AZ, 852430.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21464PRVSteven Rojas2006-10-03UHC-06323-4885960088976813 Baseline Rd, Gilbert, AZ, 852890.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-25642PRVDanielle Wheeler1997-09-09UHC-34384-7767621148903755 Church St, Houston, TX, 770020.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-29045PRVCharlotte Chapman1979-11-17—40759910253896 Church St, Miami, FL, 331030.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23543PRVJacob Campbell1958-03-04UHC-01919-31—9605 Park Pl, Jacksonville, FL, 322460.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-27499PRVBetsy Weaver1985-07-09—59250165772357 Ocean Ave, San Antonio, TX, 782390.66Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+1 more
PRV-27871PRVJanice Duncan2003-08-22—21257144931469 Central Ave # 758, Los Angeles, CA, 900990.66Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+1 more
PRV-27121PRVRussell Hudson—UHC-77582-7985392302022756 Washington St, San Antonio, TX, 782970.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-20032PRVMaria Y Little1960-05-19UHC-54516-48—1205 Hillcrest Rd # 714, Dallas, TX, 752110.66Date of birth reformattedUnit split from streetCity re-casedGender normalised+1 more
PRV-23945PRVNatalie Bell2005-03-27UHC-15700-522149450989—0.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
PRV-26910PRVChristian Kelley2008-11-28UHC-69731-27—2826 Union St, Columbus, OH, 432450.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
9,596 rows, page 65 of 192PreviousNext