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-21656PRVAnna Carpenter1952-02-03UHC-11448-93—5759 River Rd, Jacksonville, FL0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20891PRVJudith Rivera1968-04-15——5604 Ridge Rd, Los Angeles, CA, 900050.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-26269PRVDiana Lane1990-09-25UHC-80512-9782430774123391 Indian School Rd # 279, Mesa, AZ, 852650.50Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+3 more
PRV-26592PRVDeb Robinson1946-06-14UHC-84327-1438470630633973 Union St, Austin, TX, 787340.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21950PRVDanielle Collins1983-10-27—48248842802407 Park Pl, Tampa, FL, 336100.50Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
PRV-21630PRVDiego Q Riley1994-07-22UHC-05758-7520967928701017 Harbor Blvd, Miami, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26572PRVRuth Ford1973-12-26—72195637123627 Desert Sky Blvd # 199, Tempe, AZ0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-21704PRVBen Harvey1949-06-01UHC-69892-5161960528922760 Apache Blvd, Tucson, AZ, 857440.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27632PRVEric Robertson2008-07-10UHC-01745-7821862717673096 Union St, Fresno, CA, 937660.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-27631PRVEric Robertson2008-07-10UHC-01745-7821862717673096 Union St, Fresno, CA, 937660.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-20428PRVNicole Simpson1969-11-11UHC-07493-843016101518802 Ridge Rd Apt 26, Nashville, TN, 372330.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-22644PRVHelen K Freeman—UHC-18574-51—712 Main St, San Antonio, TX0.50Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
PRV-23946PRVSophia Hill1975-08-12UHC-72031-8929084164654128 Spring St, Denver, CO0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-23391PRVKimberly Y Vazquez1959-02-18UHC-98212-7290355279087007 Church St, Mesa, AZ, 852460.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-28759PRVFatima T Knight1963-09-13UHC-92327-02—5467 Oak St, Phoenix, AZ, 850450.50Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-26724PRVNoah Brown2003-02-09UHC-23265-67—8408 Bayshore Dr, Seattle, WA, 981290.50Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
PRV-29245PRVAbigail I Ruiz1976-09-10—95636802185194 Lake View Rd # 322, Miami, FL, 331320.50Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-20561PRVSharon O Patterson—UHC-01025-6848921404217671 Central Ave, Atlanta, GA, 303640.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28862PRV—Junk2006-03-14—49287317678767 Harbor Blvd, Sacramento, CA0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29430PRVJohn Luna1982-01-25UHC-17026-9351981737752837 Jefferson Ave, Mesa, AZ, 852940.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22754PRVJudy Rius1956-10-21—69893888667327 Meadow Ln, Plano, TX0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22755PRVJudy Rius1956-10-21—69893888667327 Meadow Ln, Plano, TX0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26588PRVVincent H Thomas2004-10-15——4712 Willow Ct, Nashville, TN, 372640.50Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
PRV-21550PRVSara Ray1970-06-23UHC-20937-4355048008792228 Jefferson Ave, Las Vegas, NV, 891200.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-21416PRVNancy W Estrada1976-03-22—79163656127743 Oak St, Phoenix, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-21985PRVJanice K Alexander2008-05-23—88745237528708 Central Ave, Sacramento, CA, 958320.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21720PRVElliott N Karen1970-11-18UHC-05863-6378135433107428 Forest Ave, San Antonio, TX, 782010.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-24020PRVTeresa L Castro1974-07-06UHC-25853-305968562151324 Ridge Rd, Tampa, FL0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-24022PRVMarcus West1999-09-26—23067476447751 Union St, Mesa, AZ, 852220.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20903PRVMary U Daniels1969-09-15—32624261463406 Market St, Denver, CO, 802590.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20481PRVJohn Santiago2005-10-04—92178307709707 Ridge Rd, Dallas, TX0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23795PRVJason Wang1942-07-04UHC-43783-3553543194081287 Harbor Blvd # 201, Los Angeles, CA, 900110.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-21163PRVAaron Larson1996-05-07—68399198053534 Union St, Nashville, TN0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25124PRVMichael Patterson1950-07-25UHC-52330-3953447573149741 Sunset Blvd, Mesa, AZ, 852260.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-25049PRVJuan McCoy1958-08-17UHC-62486-62—8094 Market St, Chandler, AZ, 852370.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-25976PRVValentina Nguyen1947-05-01—24297084248410 Sunset Blvd, Columbus, OH, 432700.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20386PRVAnn I Harris1962-11-20UHC-28678-4888888400992246 Ridge Rd, Charlotte, NC, 282430.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29149PRVLoogan GJunk2006-12-10UHC-62238-0152952754187132 Main St, Atlanta, GA, 303640.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24668PRVMarcus Gardner1991-03-10UHC-24243-4498092670869015 Meadow Ln, Sacramento, CA, 958900.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-29119PRVSusan Knight1999-02-05—60931488001461 Mesa Dr, Gilbert, AZ, 852990.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
PRV-22783PRVValentina Rios1989-10-21—45177718172665 Harbor Blvd, Orlando, FL, 328870.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28627PRVRaymond J Day1984-07-02—83725692298570 Main St, Miami, FL, 331530.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26744PRVCheryl Barnes1966-10-02UHC-88098-4378421844086986 Mountain View Dr, Tempe, AZ, 852860.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20043PRVDoris T Mendoza1986-11-26UHC-29920-8730699775475813 Willow Ct, Charlotte, NC0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23303PRVAna Carlson——32028016046642 Church St, Columbus, OH, 432870.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-23988PRVTheresa Mendez1976-12-25——7707 River Rd # 553, Miami, FL0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-23275PRVJacob V Welch1958-01-25——1663 Highland Ave, Jacksonville, FL, 322160.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-28173PRVNancy Y Johnson1982-09-21—73937503015070 Mountain View Dr, Atlanta, GA, 303750.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28630PRVAustin Rogers——64774304937743 Sage Ct, San Antonio, TX, 782730.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-28858PRVCynthia Ross——91155340629101 Pine Dr, Seattle, WA, 981080.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
9,596 rows, page 14 of 192PreviousNext