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-27783PRVAnna F Murray1999-08-04—57190609867304 Highland Ave, Atlanta, GA, 303760.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22101PRVAlice N Spencer1967-03-01UHC-71190-2754421205084684 Mountain View Dr, Houston, TX, 770170.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25767PRVEvvelyn Vargas1969-01-18—54849433329477 Forest Ave, Plano, TX0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28803PRVDonald Freeman1947-02-17UHC-62334-1160043426091080 Palm Dr, Tucson, AZ, 857690.62Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more
PRV-20920PRVFatima Schmidt1943-10-08—34422400973998 Palm Dr Apt 33, Denver, CO, 802560.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-22283PRVGrace D Santiago2002-12-09—8919238749776 Forest Ave, Seattle, WA, 981180.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-27710PRVTimothy Stevens2003-10-25UHC-96853-7289630758386676 River Rd, Miami, FL, 331030.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26378PRVDeb Arnold1957-02-20—61744883174570 Willow Ct, Mesa, AZ, 852280.62Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
PRV-23940PRVDavid Shaw1953-04-17—59838593698652 Main St, Miami, FL, 331650.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25388PRVMaria P Allen1981-07-03UHC-99806-87—5825 Mountain View Dr, Austin, TX, 787420.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24510PRVVirginia Thomas1979-03-16—24067610937410 Union St, Miami, FL0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-23115PRVMason Hunter2003-09-27UHC-81262-8249192303085611 Church St, Eden Prairie, MN, 553160.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22703PRVArjun R Elliott1997-06-07UHC-67426-3757975935136148 Grand Ave, Tampa, FL, 336540.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21183PRVPhilip B Nichols1988-04-04—61449717565140 Park Pl, San Diego, CA, 921550.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21168PRVBetty Padilla1979-09-12UHC-00259-1676483721997491 Canyon Rd, Tampa, FL, 336090.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21876PRVSamuel Ford1993-08-17—39869765355737 Apache Blvd, Miami, FL0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-25708PRVCarlos Wallace2003-07-27UHC-05396-1841555189491063 Washington St, Austin, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26073PRVDiego H Patel1946-05-27—67662975754558 Sage Ct, Plano, TX, 750230.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22848PRVMei Johnson1978-02-23—36376108234634 River Rd, Plano, TX, 750890.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-26989PRVJacqueline V Cook1960-06-10UHC-56396-26—4684 Elm St, Scottsdale, AZ, 852030.62Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
PRV-22088PRVEmma Tucker1955-10-18UHC-67045-13—4116 Market St, Mesa, AZ, 852450.62Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
PRV-24685PRVSara Little1981-10-12UHC-34139-9872093617425850 Jefferson Ave # 409, Plano, TX, 750860.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-20124PRVJacqueline Chen1997-08-07—70324787755143 Grand Ave, Los Angeles, CA0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-21129PRVNoah Ross2000-02-10—57394790097804 Maple Ave Apt 32, Los Angeles, CA, 900500.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-21275PRVLucia Wood1943-05-22UHC-17073-62—8150 Pine Dr, Fresno, CA0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-23214PRVEryc E Carter1938-12-19—22967449039773 Ocean Ave, Sacramento, CA, 958370.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25348PRVJordan Perry1955-11-17UHC-77617-5462095296526145 Sunset Blvd, Phoenix, AZ, 850720.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23029PRVJoyce Roberts2007-01-12——2751 Jefferson Ave, Los Angeles, CA, 900460.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-28332PRVAaron Gonzalez1962-11-03—25389120289680 Mountain View Dr Apt 38, Seattle, WA, 981030.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-24865PRVMelissa Anderson1981-07-02—32760357608861 Canyon Rd, Atlanta, GA, 303620.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28525PRV—Junk1950-10-06UHC-31579-16—588 Valley View Dr, Jacksonville, FL, 322130.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-22191PRVStephanie Bishop1982-12-17—72770180295282 River Rd, Las Vegas, NV, 891630.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-24216PRVAbigail Z Griffin1998-10-20UHC-96170-8445397686817618 Ridge Rd Apt 6, Minneapolis, MN, 554460.62Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
PRV-28628PRVRaymond Day1984-07-02—8372569229227 Elm St Apt 37, Tucson, AZ, 857570.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-26151PRVJordan Rose1980-10-09UHC-57654-1681657134634464 Lincoln Way, Gilbert, AZ, 852410.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
PRV-20157PRVChrristian Carpenter1947-09-17—49365765168062 Canyon Rd, Los Angeles, CA, 900820.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21350PRVAlbert Murphy1953-11-18UHC-70792-6892568119983133 Lincoln Way Apt 27, Miami, FL, 331320.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
PRV-28295PRVGrace F Duncan1999-06-14UHC-41719-7559052518926527 Harbor Blvd, Orlando, FL, 328790.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-21948PRVTerry Kelly1981-02-01UHC-39031-08—2627 Highland Ave, Phoenix, AZ, 850770.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20336PRVSamuel C Mejia1960-06-12—80231230633111 Mesa Dr, Seattle, WA, 981800.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-26062PRVGloria V Johnson1987-03-02UHC-44130-9769652148683218 Hillcrest Rd # 876, Orlando, FL, 328260.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-27788PRVBryan Gibson1951-10-22—86465573427359 Sage Ct, Orlando, FL0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23397PRVNatalie Fernandez1950-09-17—41520301259177 Hillcrest Rd, Houston, TX, 770330.62Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+3 more
PRV-29190PRVChristina Maldonado1968-01-13UHC-10398-3064155008007835 Grand Ave, Austin, TX, 787630.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24947PRVAlbert Stephens1949-04-17—26766820752513 Lake View Rd # 406, Seattle, WA, 981630.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-26291PRVAbigail Cunningham1938-09-28—87729530744046 Oak St, Tampa, FL, 336630.62Name re-casedPhone reformattedCity re-casedState name converted to code+3 more
PRV-26106PRVStephanie Ross1998-02-27—4375058933504 Sunset Blvd, Austin, TX, 787950.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-28267PRVAdam X Obrien1982-04-02——4314 Sunset Blvd, Chandler, AZ, 852080.62Name split from “Last, First”Name re-casedDate of birth reformattedStreet suffix standardised+3 more
PRV-25766PRVEvelyn Vargas1969-01-18UHC-34654-1154849433329477 Forest Ave # 952, Plano, TX, 750850.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-21033PRVSarah M Alvarado1963-04-16—20955816486407 Grand Ave, Orlando, FL, 328930.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
9,596 rows, page 37 of 192PreviousNext