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-24621PRVMartha Campbell2007-12-27UHC-49054-08—2352 Broadway # 466, Mesa, AZ, 852870.66Name split from “Last, First”Unit split from streetCity re-casedWhitespace trimmed+1 more
PRV-25164PRVJean Reed1949-09-15—35792078395322 Sage Ct Apt 38, Fresno, CA, 937140.66Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-21817PRVHenry Snyder1946-09-18—39189308724659 Church St, Houston, TX, 770290.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-29013PRVGary Walsh1981-08-23UHC-49344-0422430175333763 Church St, Tampa, FL, 336700.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-22321PRVVega Ahmed1991-05-16——1975 Jefferson Ave, San Diego, CA, 921140.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
PRV-25406PRVSharon Cole——74126751113762 Cedar Ln, Tempe, AZ, 852290.66Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-20278PRVHelen Holmes1978-08-01UHC-13051-2723475749962988 Elm St, Austin, TX0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-28070PRVDonald Mendez1996-11-14—90840658958762 Camelback Rd, Mesa, AZ, 852700.66Name split from “Last, First”Phone reformattedState name converted to codeWhitespace trimmed+1 more
PRV-21319PRVRussell R Elliott2002-09-26UHC-72403-5276351656158498 Camelback Rd, San Diego, CA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-23202PRVLuis Clark1983-08-07UHC-84938-1320142976248275 Church St, Columbus, OH, 432640.66Name re-casedPhone reformattedMember ID reformattedState name converted to code+1 more
PRV-27332PRVMarilyn James1952-06-17UHC-01639-2783540615421285 Palm Dr, Glendale, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-25704PRVMarilyn Barnes1957-12-23—62538215484785 Apache Blvd, San Diego, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-20865PRVAaron I Gilbert1981-09-11UHC-80916-3853351871211483 Hillcrest Rd, Nashville, TN, 372870.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-21025PRVMegan Little1998-09-25UHC-03625-8270642992372116 Washington St, Dallas, TX, 752000.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23417PRVJusitn Miller1980-01-22—25631262867254 Harbor Blvd, Houston, TX, 770970.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-23258PRVWilliam Coleman2004-12-19UHC-42116-5251021669892790 Forest Ave, Mesa, AZ, 852000.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25232PRVJack E Meyer1996-06-12—89284939748203 Mesa Dr, San Diego, CA, 921400.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-20057PRVRobert Jenkins1948-04-28UHC-46816-2372082740333732 Lake View Rd, Glendale, AZ, 853570.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21563PRVVirginia Smith2001-07-22—89023009519017 Palm Dr, Atlanta, GA, 303820.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
PRV-22156PRVBilly X Diaz1969-05-21—71621392209501 Meadow Ln, San Antonio, TX, 782010.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
PRV-21327PRVWei Y Schmidt1974-03-03—31894839401246 Apache Blvd Apt 36, Houston, TX, 770220.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-26543PRVPatricia E Sanchez1942-07-20UHC-39394-078386555550—0.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
PRV-28168PRVGeorge W Johnston1985-06-01——1092 Highland Ave, Austin, TX, 787980.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-23587PRVShirley R Howard——30867823079430 Lincoln Way, Charlotte, NC, 282740.66Date of birth missingPhone reformattedState name converted to codeWhitespace trimmed+1 more
PRV-26766PRVRandy Stweart1955-03-05—25298289358689 Grand Ave, San Diego, CA, 921370.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-26596PRVJessica Duncan2003-02-01—59676651668245 Oak St Apt 34, Mesa, AZ, 852130.66Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+1 more
PRV-26595PRVJessica Duncan2003-02-01—59676651668245 Oak St Apt 34, Mesa, AZ, 852130.66Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+1 more
PRV-23565PRVFrances Harvey1985-03-28—70264774393719 Mesa Dr, Minneapolis, MN, 554140.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-27939PRVBenjamin F Jones2000-11-10—41762855153840 Palm Dr, Nashville, TN, 372400.66Middle initial moved out of first namePhone reformattedCity re-casedZIP+4 trimmed+1 more
PRV-21913PRVHannah Jenkins1993-11-15——1368 Mesa Dr, Austin, TX, 787560.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
PRV-29071PRVJanice Marshall1985-02-22—90586648195578 Bayshore Dr # 980, Sacramento, CA, 958240.66Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+1 more
PRV-27881PRVRoy Elis2006-02-21UHC-97344-0421356066662423 Central Ave, Mesa, AZ, 852340.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-21239PRVRoy C Olson1967-08-06UHC-36243-1051854839786622 Bayshore Dr, Chandler, AZ, 852000.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-27583PRVAbigail Morrison1950-04-01—3974204494928 Bayshore Dr, Minneapolis, MN, 554480.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-25336PRVFrances Hanson1989-05-10—87035764096548 Willow Ct, Phoenix, AZ, 850410.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-25082PRVDanielle Q Peterson1949-01-25——1519 Jefferson Ave, Mesa, AZ, 852650.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-25935PRVPriya H McDonald1965-08-04—69663634855136 Apache Blvd, Tempe, AZ, 852770.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-24560PRVMadison T Padilla1968-11-07—41646939786184 Ridge Rd, Miami, FL, 331780.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-26666PRVBruce Clark1990-05-02UHC-63878-3786440936562717 Ocean Ave, Houston, TX, 770770.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25509PRVKelly G Bishop1958-01-12UHC-23217-2496159199303102 Highland Ave, Chandler, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-28582PRVNancy Fields1983-01-08—6887513580900 Palm Dr Apt 38, Scottsdale, AZ, 852820.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25947PRVAlan O Pierce1970-01-22——4710 Camelback Rd, Charlotte, NC, 282350.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-29560PRVPeter M Wang1989-06-01UHC-50056-3224033554097241 Baseline Rd, Seattle, WA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-26841PRVKen James1941-08-01UHC-79845-73—2485 Baseline Rd, Gilbert, AZ, 852290.66Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-23698PRVDiana Brown1961-08-05UHC-44223-6964177580414932 Oak St, Miami, FL, 331330.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
PRV-23956PRVPatricia E Greene1965-08-26—76179886704374 Canyon Rd, Nashville, TN, 372590.66City re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-23955PRVPatricia E Greene1965-08-26—76179886704374 Canyon Rd, Nashville, TN, 372590.66City re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-21897PRVVirginia Greeene2005-06-22UHC-49687-5626555240914747 Willow Ct, San Diego, CA, 921520.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-21678PRVJoe A Hamilton2003-10-17UHC-71097-95—9027 Central Ave, Sacramento, CA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-20399PRVMaria Washngton1968-08-24—60748329211478 Bayshore Dr, Sacramento, CA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
9,596 rows, page 68 of 192PreviousNext