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-21381PRVKatherine Knight2001-03-26—89150777077895 Willow Ct, Plano, TX, 750490.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25154PRVJessica Fernandez1951-04-07——3338 Highland Ave, Austin, TX, 787890.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
PRV-27786PRVAlan Ryan1940-06-15—72234843755901 Grand Ave, San Diego, CA, 921740.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27233PRVCynthia Bomwan1956-03-14—66126014455228 Market St, San Diego, CA, 921230.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-28882PRVTheresa M Munoz1962-04-06UHC-44745-7789330398282470 Camelback Rd, Atlanta, GA, 303640.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23522PRVKyle Henry1990-02-17—55534311667259 Ocean Ave, Seattle, WA, 981760.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-23413PRVDorothyJunk1945-01-19UHC-03800-595283984440—0.80Member ID reformattedWhitespace trimmedPlaceholder values clearedNo usable name (quarantined)
PRV-21972PRVChristian Santiago1987-03-15—39477032483993 Jefferson Ave, San Antonio, TX, 782020.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24402PRVDenise Wells1998-09-06—46485887748604 Lincoln Way, Columbus, OH, 432320.80Phone reformattedCity re-casedState name converted to codePlaceholder values cleared
PRV-29243PRVLauren Medina1962-06-02—74584147132179 Bayshore Dr, Phoenix, AZ, 850860.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29400PRVRoger S Wang1950-02-04—52873107095745 Jefferson Ave, Charlotte, NC, 282710.80Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased
PRV-23676PRVFlores Mateo1975-04-04UHC-34251-403226007276486 Highland Ave, Jacksonville, FL, 322490.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28544PRVAmber Olson1965-06-20—66024465861119 Mesa Dr, Tempe, AZ, 852540.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
PRV-29455PRVChuck A Nunez1953-05-25UHC-42084-7186271042831663 Mesa Dr, Seattle, WA, 981790.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-27959PRVJordan Padilla2000-03-12—39546947041639 Baseline Rd Apt 29, Phoenix, AZ, 850320.80Phone reformattedUnit split from streetEmail lower-casedWhitespace trimmed
PRV-29196PRVAna X Elliott1959-04-12—78535052974973 Mountain View Dr, Seattle, WA, 981190.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28216PRVAhsley Cook1970-12-27UHC-87838-912563277536510 Valley View Dr, Glendale, AZ, 853090.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26051PRVCarol Ortega1996-01-15UHC-51717-7359678030695241 Central Ave, Tampa, FL, 336120.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20034PRVAnna McDonald1972-03-16UHC-61383-3178375943695798 Union St, Los Angeles, CA, 900150.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-29223PRVKenneth Y Jacobs1972-07-26UHC-31074-32—9236 River Rd, San Antonio, TX, 782340.80Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
PRV-28237PRVBruce Harvey2004-03-21—68975922839486 Indian School Rd, Orlando, FL, 328760.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21008PRVRobert Holmes2006-04-09—9536015335—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-29417PRVRonald Ford1963-10-11—36823916572253 Lake View Rd, Columbus, OH, 432540.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-29289PRVMatthew Graham1962-06-15—95397104785330 Union St, Nashville, TN, 372480.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20984PRVEthan O Arnold2005-02-01UHC-72887-0161768749261015 Oak St, Gilbert, AZ, 852860.80Date of birth reformattedPhone reformattedState name converted to codePlaceholder values cleared
PRV-26631PRVNatalie Myers2006-05-19—66157600515100 Main St, Miami, FL, 331280.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
PRV-21859PRVWilliam V Snyder1941-06-07—91028468231256 Baseline Rd, Mesa, AZ, 852660.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29523PRVRalph Daniels2005-10-09——6510 Lake View Rd, Mesa, AZ, 852000.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21571PRVDiana Valdez2005-07-24—80461342311783 Cedar Ln, Chandler, AZ0.80Phone reformattedCity re-casedZIP missingEmail lower-cased
PRV-20897PRVDiego Williams1978-12-01—68276591001963 Willow Ct, Chandler, AZ, 852520.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21017PRVEric Woods1986-03-05——9334 Sunset Blvd, Orlando, FL, 328170.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20103PRVGloria U Woods1998-09-16UHC-12398-946929728201—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-20958PRVDoris Sullivan1938-05-11UHC-02605-1627765446762615 Park Pl, Atlanta, GA, 303800.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20959PRVDoris Sullivan1938-05-11UHC-02605-1627765446762615 Park Pl, Atlanta, GA, 303800.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21290PRVKathy Sandoval1962-05-14——5904 Central Ave, Tempe, AZ, 852420.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24393PRVKeith Jones1987-02-19—24741923425349 Palm Dr, Orlando, FL, 328840.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24481PRVJordan Bishop2008-09-23—73225465615429 Meadow Ln, Phoenix, AZ, 850830.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28935PRVDaniel Turner—UHC-52643-654509372554—0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-22896PRVGeorge Murray1964-10-14—52655284742753 Central Ave, Columbus, OH, 432250.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-25826PRVMason Wells2004-02-13UHC-76605-772822414322—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-27047PRVLarry J Medina1994-12-02UHC-84410-1166823840289134 Desert Sky Blvd, San Antonio, TX, 782110.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25954PRVLaura P Perry1980-02-09UHC-48608-369038203639—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-22184PRVEric L Palmer1964-11-24UHC-87376-847423225171—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24642PRVGeorge Bryant1965-11-15UHC-88695-40—2407 Bayshore Dr, San Diego, CA, 921810.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-22522PRVRalph Fernandez1991-09-20UHC-99815-83—8245 Ocean Ave, Fresno, CA, 937690.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-22534PRVJerry Lawsoon1992-06-03—55962059886696 Spring St, Los Angeles, CA, 900100.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27670PRVJohn Hayes2002-11-20UHC-59901-878908777429—0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22128PRVSara Fields2004-02-19UHC-44926-4241745295091134 Union St, Austin, TX, 787070.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-25775PRVMari Perkins2001-09-19UHC-59431-0594277082337167 Mountain View Dr, Tucson, AZ, 857380.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
PRV-25484PRVMaria Harper1941-06-14—8067183814—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 138 of 192PreviousNext