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-23174PRVLaura Daniels1978-04-28—71658950632172 Lincoln Way, Chandler, AZ0.52Name split from “Last, First”Two-digit birth yearPhone reformattedZIP missing+2 more
PRV-23364PRVJulie Johnson1971-12-09——4699 Sunset Blvd, Houston, TX, 770230.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-23365PRVJulie Johnson1971-12-09——4699 Sunset Blvd, Houston, TX, 770230.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-22311PRVElizabeth Stevens1993-01-09UHC-16032-76—5198 Union St, Jacksonville, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
PRV-23255PRVOmar Thomas1983-02-04——3899 Union St Apt 32, Eden Prairie, MN, 553540.52Name split from “Last, First”Unit split from streetCity re-casedState name converted to code+2 more
PRV-27949PRVBrittany M Watson1971-04-25——3073 Market St, Sacramento, CA, 958740.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-22485PRVJanice Diaz1987-06-13UHC-88057-73—2994 Indian School Rd, Chandler, AZ, 852670.52Name split from “Last, First”Two-digit birth yearCity re-casedState code upper-cased+2 more
PRV-26111PRVEJunk2000-05-06UHC-64732-9976794262347447 Central Ave, Miami, FL, 331710.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-29198PRVAnthony Perkins1988-06-09——5905 Elm St, Las Vegas, NV, 891130.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21784PRVLinda Y Palmer——92256325914786 Sunset Blvd, Dallas, TX, 752280.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-26988PRVKathleen Day1982-02-23UHC-81831-31—5003 Ocean Ave, Glendale, AZ, 853900.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-28007PRVHarold N Black1953-02-20UHC-08811-16—1814 Lincoln Way, San Diego, CA, 921870.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-25756PRVOlivia Franklin2003-08-18—23083049072718 Palm Dr, Seattle, WA, 981010.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-27291PRVJose T Patterson1982-09-22—84965509509395 Sunset Blvd, Houston, TX0.52Phone reformattedState name converted to codeZIP missingGender normalised+2 more
PRV-22589PRVBrenda Alvarado1980-06-28UHC-41851-99—6602 Oak St, Jacksonville, FL, 322430.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-23300PRVAnthony Guerrero1972-11-10UHC-93685-6026229204006030 Main St, Austin, TX, 787330.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23399PRVDavid Y Armstrong1946-07-26UHC-93636-05—1887 Ridge Rd, Gilbert, AZ0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
PRV-21241PRVGeorge Bradley1978-09-01UHC-28120-866594321783114 Highland Ave, Denver, CO, 802260.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28387PRVMegan Morgan1997-09-07——9294 Lake View Rd, Tempe, AZ, 852520.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21206PRVNancy Oliver1944-10-25UHC-38921-64—8923 Baseline Rd, Plano, TX, 750660.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
PRV-28199PRVKevin Guerrero—UHC-55296-6537958914364927 River Rd, Fresno, CA0.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-28370PRVNicole K Willis1997-02-08UHC-86882-0474080182671520 Highland Ave, Gilbert, AZ, 852990.54Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+1 more
PRV-25101PRVWillie C Elliott1943-01-20UHC-22957-69—9782 Ridge Rd, Tempe, AZ, 852890.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-25100PRVWillie C Elliott1943-01-20UHC-22957-69—9782 Ridge Rd, Tempe, AZ, 852890.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-28326PRVShirley A Meyer1976-09-12—2663373260413 Cedar Ln, Seattle, WA, 981870.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
PRV-27624PRVDonna Ellis1965-07-03UHC-56478-1737769342094083 Desert Sky Blvd, Jacksonville, FL, 322930.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-24013PRVPaul Millls2000-08-05UHC-43060-6378451701185434 Indian School Rd, Plano, TX0.54Two-digit birth yearPhone reformattedZIP missingGender normalised+1 more
PRV-29016PRVBrittany E Wells2001-01-14——1690 Jefferson Ave, Austin, TX0.54SSN last four extractedCity re-casedState name converted to codeZIP missing+1 more
PRV-28765PRVAhmed J Singh———8556 Apache Blvd, Plano, TX0.54Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-26528PRVEmily Bennett1981-02-04—39866428035579 Lake View Rd, Fresno, CA, 937230.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-26059PRVMason V Sanchez1953-01-04——1884 Forest Ave, San Antonio, TX, 782780.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
PRV-28764PRVWeaver Danielle1971-06-27UHC-98676-06—724 Palm Dr, Atlanta, GA, 303410.54Name split from “Last, First”Two-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
PRV-26919PRVJean Holmes1977-09-23—80857287245649 Oak St # 929, Los Angeles, CA, 900660.54Phone reformattedUnit split from streetState name converted to codeZIP+4 trimmed+1 more
PRV-23974PRVChristine V Martinez1999-08-16UHC-53553-34—4871 Mountain View Dr # 113, Tampa, FL, 336160.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-27677PRVFrank Robertson1982-05-16UHC-20010-8680275831772074 Hillcrest Rd, Tampa, FL0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-23736PRVGerald M Pena1978-10-23UHC-42304-14—9382 Bayshore Dr, Phoenix, AZ, 850380.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-24482PRVDouglas Q Hunt1965-02-04UHC-18462-4060023160717565 Canyon Rd, Tucson, AZ, 857710.54Name re-casedTwo-digit birth yearZIP+4 trimmedGender normalised+1 more
PRV-24174PRVStephanie Graham1961-05-16—48866029035498 Spring St, Austin, TX, 787400.54Two-digit birth yearState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
PRV-27140PRVJerry O Jenkins———5012 Broadway, Houston, TX0.54Name re-casedDate of birth unreadableZIP missingGender normalised+1 more
PRV-26371PRVPaul Jordan1958-10-24UHC-04379-22—3424 Apache Blvd, Los Angeles, CA, 900200.54Name split from “Last, First”Two-digit birth yearPhone missing area codeCity re-cased+1 more
PRV-24122PRVTyler Q Alvarado1993-03-01UHC-30206-42—1297 Valley View Dr, Gilbert, AZ, 852640.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-29000PRVBrandon J Edwards1948-04-23UHC-65049-62—3531 Church St, Sacramento, CA, 958500.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-28225PRVCarl Russell—UHC-40882-6898837286633970 Palm Dr, Dallas, TX, 752040.54Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-24071PRVChristine O Bryant1964-01-02UHC-13671-7831391130308446 Union St, Jacksonville, FL, 322340.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-26847PRVKaren Campbell——97064130404437 River Rd, Columbus, OH, 432640.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
PRV-21614PRVAlbert Mason1953-03-14—76959360392440 Desert Sky Blvd, Glendale, AZ, 853550.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22713PRVWJunk1997-09-04UHC-42544-6870531177432246 Broadway Apt 10, San Diego, CA, 921260.54Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared+1 more
PRV-20734PRVJulia Ortega———9413 Jefferson Ave, Denver, CO, 802810.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
PRV-21399PRVDiego Ramirez1976-05-26UHC-23908-8470580866438373 Ridge Rd, Fresno, CA, 937340.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
PRV-28817PRVCamila E Li—UHC-40969-55—4919 Harbor Blvd, Gilbert, AZ, 852580.54Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+1 more
9,596 rows, page 20 of 192PreviousNext