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-27022PRVJustin Ryan1975-11-04—21538262281898 Camelback Rd, Plano, TX0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-21379PRVMateo Rivera——5374470369115 Canyon Rd, Scottsdale, AZ, 852070.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20299PRVBrenda Weaver1950-07-25—95964603105530 Grand Ave Apt 35, Tampa, FL, 336170.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-22898PRVAaron Hicks—UHC-68928-73—6607 Desert Sky Blvd Apt 28, Eden Prairie, MN0.52Name re-casedDate of birth unreadableUnit split from streetZIP missing+2 more
PRV-24008PRVKathryn Hart1950-12-28UHC-87384-3470660070871571 Main St Apt 13, Scottsdale, AZ, 852870.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-20235PRVCharles M Bradley1951-07-19UHC-01729-01—7702 Willow Ct, Jacksonville, FL, 322630.52Middle initial moved out of first nameTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-25282PRVWei Rogers1958-11-27UHC-04137-5478698052244311 Market St, Atlanta, GA0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24566PRVJack M Barnes1979-04-24UHC-75054-56—3185 Washington St, Las Vegas, NV, 891250.52Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-25356PRVJames Sanders2000-11-24—69767753592275 Sage Ct, Minneapolis, MN0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-29096PRVTony R Bishop1984-03-26UHC-85028-3938445794102606 Valley View Dr, Seattle, WA, 981340.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28217PRVAshley D Cook1970-12-27UHC-87838-91—857 Palm Dr, Tampa, FL, 336280.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-25471PRVScott Alvarado1973-09-21—96492973885896 Hillcrest Rd, Glendale, AZ, 853990.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21589PRVJessica Alexander1973-06-17——5403 Jefferson Ave, Phoenix, AZ, 850340.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-24227PRVSara F Murphy2008-01-24UHC-77515-8536690103477201 Cedar Ln, Las Vegas, NV, 891840.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21294PRVAlexis Harvey1991-02-11UHC-56292-04—6202 Bayshore Dr, Nashville, TN, 372110.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23833PRVMatthew F Burke1982-01-07—55445102372792 Desert Sky Blvd, Nashville, TN, 372910.52Name split from “Last, First”Phone reformattedState name converted to codeZIP+4 trimmed+2 more
PRV-22218PRVLawrence Maldonado—UHC-97544-20—7498 Main St, Glendale, AZ, 853670.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21655PRVRebecca Franklin2008-01-09UHC-18936-068234147070—0.52Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+2 more
PRV-22250PRVJason Cole1993-10-28UHC-29923-1332980915917591 Market St, Eden Prairie, MN, 553810.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21776PRVGrace Garrett1993-10-14UHC-31113-3831572229911674 Oak St # 574, Plano, TX, 750240.52Name split from “Last, First”Two-digit birth yearUnit split from streetCity re-cased+2 more
PRV-24494PRVAndrew Larson1994-01-10UHC-19155-72—7764 Highland Ave, Austin, TX, 787100.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-28811PRVScott B Howell1997-12-18—84588243381511 Willow Ct, Scottsdale, AZ, 852410.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25454PRVMartha Castro1984-04-01——5565 Hillcrest Rd Apt 25, Nashville, TN, 372340.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21271PRVGeorge Moreno1975-07-02UHC-65364-3558586321109621 Cedar Ln, Phoenix, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
PRV-23119PRVAaron Gacia1963-04-27—75197651267813 Desert Sky Blvd, Minneapolis, MN, 554240.52Name split from “Last, First”Date of birth reformattedState name converted to codeGender normalised+2 more
PRV-24051PRVPaul Alvarez2000-05-10——7640 Washington St, Houston, TX, 770480.52Name split from “Last, First”Date of birth reformattedZIP+4 trimmedGender normalised+2 more
PRV-23200PRVCharlotte I Payne2005-01-13—47249833092382 Grand Ave, Glendale, AZ, 853540.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-26644PRVSofia Hicks1952-05-23UHC-80393-05—1685 Church St, Phoenix, AZ, 850600.52Name split from “Last, First”Phone missing area codeState code upper-casedZIP+4 trimmed+2 more
PRV-29191PRVGerald Gardner——86487055542107 Willow Ct, San Antonio, TX0.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-26718PRVAhmed Castillo1996-09-28UHC-03994-9392952623765587 Meadow Ln, Sacramento, CA, 958070.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
PRV-28752PRVJanet Carroll1938-02-10UHC-53190-2053262161376292 Union St Apt 6, Orlando, FL, 328100.52Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
PRV-28929PRVGrace D Hughes1965-10-15—6717940564181 Central Ave, Tampa, FL, 336320.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23860PRVDorothy F James1987-02-16UHC-93469-7740161111758094 Indian School Rd, Eden Prairie, MN, 553920.52Name split from “Last, First”Phone reformattedState name converted to codeZIP+4 trimmed+2 more
PRV-28780PRVChristopher L Aguilar1967-09-11UHC-33800-17—3042 Sage Ct, Plano, TX, 750140.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-27807PRVBobby Dean1941-05-26UHC-81117-274083330786717 Valley View Dr Apt 12, Jacksonville, FL, 322870.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-26811PRVDiego Ferguson1984-06-08UHC-07762-2297068595371523 Union St Apt 4, San Antonio, TX, 782290.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-20637PRVAhmed Gutierrez1938-05-12——6178 Forest Ave, Columbus, OH, 432040.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25649PRVEmily Jimenez1974-01-09—92174385802840 Spring St, Minneapolis, MN, 554160.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23419PRVJuan Coleman2008-05-26—96836167728188 Desert Sky Blvd Apt 17, Sacramento, CA, 958800.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-24735PRVRyan J Hill1966-09-13—35939730072450 Ridge Rd, Tempe, AZ, 852860.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23143PRVTom X Luna1986-04-10—89025439703916 Bayshore Dr, Houston, TX, 770250.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-20601PRVStephanie X Allen1995-11-20——8645 Apache Blvd, Tempe, AZ0.52Name split from “Last, First”SSN last four extractedState code upper-casedZIP missing+2 more
PRV-26105PRVStephanie Ross1998-02-27——504 Sunset Blvd, Austin, TX, 787950.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-26431PRVTeresa D Simpson1957-04-18——1259 Mountain View Dr, Orlando, FL, 328200.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-26001PRVRoger Fisher1980-08-23UHC-56175-5339171212267021 Meadow Ln, Tempe, AZ, 852060.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-23309PRVKayla Carr1964-05-19—697783529137 Camelback Rd, Phoenix, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23058PRVChristina Hart1954-04-21—83998330236532 Bayshore Dr, Las Vegas, NV, 891440.52Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
PRV-29339PRVAshley Vargas1958-09-03—68050328379179 Cedar Ln Apt 13, Chandler, AZ, 852190.52Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
PRV-22404PRVRoger U Hawkins2004-10-01UHC-20801-6127687443433171 Harbor Blvd, Plano, TX, 750120.52Middle initial moved out of first nameTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-21152PRVRyan Jimenez1955-06-10UHC-81271-9227650957532708 Forest Ave Apt 1, Denver, CO, 802940.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
9,596 rows, page 16 of 192PreviousNext