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-24858PRVSamantha Murphy2001-03-03—3075669853455 Ocean Ave, Houston, TX, 770350.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-25501PRVKimberly Pierce1978-12-17—78751416478849 Valley View Dr, Columbus, OH, 432530.92Name re-casedPhone reformattedEmail lower-casedPlaceholder values cleared
PRV-25897PRVCarlos W Richardson1951-12-10—5654652141887 Apache Blvd, Phoenix, AZ, 850090.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24299PRVSandra Taylor2006-11-26—486278196793 Church St, Austin, TX, 787500.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20699PRVAustin M Yang1983-07-18—86158220649563 River Rd, Los Angeles, CA, 900990.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27476PRVArthur Washington2000-07-27UHC-09983-59—7566 Willow Ct, Gilbert, AZ, 852940.92Name re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-29482PRVWilllie Bennett1969-01-25—6495868623—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-29481PRVWilllie Bennett1969-01-25—6495868623—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-23223PRVCamia Z Roberts1987-10-16UHC-48203-37760957063295 Bayshore Dr, Scottsdale, AZ, 852880.92Name re-casedPhone reformattedMember ID reformattedPlaceholder values cleared
PRV-27988PRVBilly Hansen1974-02-21UHC-24086-776437986171201 River Rd, Jacksonville, FL, 322470.92Date of birth reformattedCity re-casedState code upper-casedPlaceholder values cleared
PRV-24000PRVSara Butler1957-12-03—2283393807—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24048PRVBarb Shaw1954-03-19—8052923555—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25472PRVKayla Brooks1954-09-14—59925149812690 Oak St, Los Angeles, CA, 900070.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-29428PRVMartha Luna1981-06-14—87441828312310 Grand Ave, San Diego, CA, 921440.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
PRV-20190PRVMatt Vega1998-08-17UHC-91944-1948343045514884 Desert Sky Blvd, Tucson, AZ, 857220.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-25008PRVCharles L Webb1990-08-11—44440798772023 Desert Sky Blvd, Las Vegas, NV, 891540.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-23577PRVHenry Gomez1957-07-16UHC-44840-4651659323018724 Bayshore Dr, Scottsdale, AZ, 852110.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-28652PRVMason R Perkins1988-11-23—50026276927401 Forest Ave, Seattle, WA, 981330.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25077PRVWilliam F Foster2005-12-22—47827427641191 River Rd, Columbus, OH, 432680.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26281PRVJudy Hansen1968-08-13UHC-56044-4547840421417537 Union St, Gilbert, AZ, 852960.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-26824PRVJudy Welch1968-06-08UHC-74292-5270072619115041 Palm Dr, Phoenix, AZ, 850550.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24204PRVKayla Knight1945-02-22UHC-65232-6347683491873353 Highland Ave, Mesa, AZ, 852460.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24172PRVAhmed Jackson1980-07-21—91657988656354 Lincoln Way, Eden Prairie, MN, 553950.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-24173PRVAhmed Jackson1980-07-21—91657988656354 Lincoln Way, Eden Prairie, MN, 553950.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-21112PRVKenneth Tucker1947-04-12UHC-48286-4323842976131345 Meadow Ln, Gilbert, AZ, 852500.92Date of birth reformattedMember ID reformattedCity re-casedPlaceholder values cleared
PRV-24699PRVAbigail P Harrison1940-04-21UHC-99217-264068453285—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25122PRVBrittany Aguilar2000-11-16—7482644177—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25123PRVBrittany Aguilar2000-11-16—7482644177—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23903PRVTyler X Dominguez1982-11-27UHC-61632-3891228855147545 Canyon Rd, Nashville, TN, 372390.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-22096PRVValentina Wheeler1944-03-26—43279649087039 Broadway, Atlanta, GA, 303290.92Date of birth reformattedPhone reformattedAddress re-casedPlaceholder values cleared
PRV-28226PRVLawrence L Johnston1981-05-16UHC-28017-0193331078185252 Highland Ave, Tempe, AZ, 852400.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25017PRVGonzales Nathan2006-02-18UHC-41893-3664221839484173 Desert Sky Blvd, Orlando, FL, 328750.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22158PRVMasno Graham1983-02-26UHC-31696-707858257532—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23796PRVLori C Williamson1950-06-12UHC-02443-0253020431952701 Union St, Tampa, FL, 336010.92Date of birth reformattedPhone reformattedCity re-casedPlaceholder values cleared
PRV-24710PRVPaul L Henry1950-12-23—77790248979855 Broadway, Columbus, OH, 432330.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-26277PRVGabriel Shaw1975-05-15UHC-14473-314667579911—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28821PRVCarol Aguilar1981-06-17UHC-79105-607134119036—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-20661PRVHiroshi D Baker1984-01-19UHC-28647-9943989966156310 Indian School Rd, Glendale, AZ, 853570.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25844PRVRichard Lawson1976-05-25UHC-60156-0337544358199040 Ridge Rd, Las Vegas, NV, 891280.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27975PRVHarold Murpy1948-08-24UHC-22265-133436309579—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-28160PRVMei Watkins2004-04-13—39148531627539 Elm St, San Diego, CA, 921830.92Date of birth reformattedPhone reformattedState code upper-casedPlaceholder values cleared
PRV-24683PRVHeather Jones1988-04-22—51338203607379 Broadway, Dallas, TX, 752910.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28488PRVLogan Scott1988-08-15UHC-34279-8150524341969396 Cedar Ln, Nashville, TN, 372430.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25849PRVBradley Hayes1967-08-21—97997496407711 Mountain View Dr, Orlando, FL, 328450.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20527PRVJessica Mitchell1962-04-20—5653138278—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25721PRVShirley Wheeler1995-08-12UHC-40849-4574236795454790 Ridge Rd, Las Vegas, NV, 891560.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20231PRVJooshua Vasquez1940-01-03—82763723558275 Washington St, Austin, TX, 787730.92Name re-casedPhone reformattedEmail lower-casedPlaceholder values cleared
PRV-26848PRVJean Lawrence1974-03-03UHC-43612-2364099518933662 Lincoln Way, Gilbert, AZ, 852920.92Date of birth reformattedCity re-casedState code upper-casedPlaceholder values cleared
PRV-28469PRVEryc Shaw1996-01-06—25524113405021 Indian School Rd, Charlotte, NC, 282760.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21846PRVSara Carter1945-03-08——4145 Lake View Rd, Phoenix, AZ, 850970.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 162 of 192PreviousNext