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-24598PRVLori Roberts1999-01-04UHC-78605-17—9741 Canyon Rd, Houston, TX, 770710.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
PRV-25877PRVJack Murray1958-06-16UHC-23811-5691449122833124 Sunset Blvd Apt 19, Houston, TX, 770110.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-23057PRVPaul Bailey1947-01-06UHC-74026-8334342192692994 Pine Dr, Las Vegas, NV0.50Name re-casedDate of birth reformattedState name converted to codeZIP missing+3 more
PRV-21342PRVJordan Torres1974-05-15UHC-00744-8083050211355082 Bayshore Dr, Phoenix, AZ, 850460.50Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+3 more
PRV-23482PRVBilly Lawson1989-05-13—32079843062366 Oak St, Columbus, OH0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-20002PRVLaura Alvarado1939-03-06—20820463444347 Church St, Plano, TX, 750860.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-23342PRVDoris McCoy1984-08-26—66447601057393 River Rd, Gilbert, AZ0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21435PRVRobert Crawford2006-02-15UHC-52692-5759893242854891 Meadow Ln, Sacramento, CA, 958370.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27810PRVTeresa Elliott1939-11-27UHC-87593-18—621 Grand Ave, Gilbert, AZ, 852590.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-28477PRVHenry Harrison—UHC-33101-6835184852807019 Washington St, Chandler, AZ0.50Name re-casedDate of birth unreadableMember ID reformattedZIP missing+3 more
PRV-21673PRVJacob M Obrien1949-07-03UHC-92455-5167943317229669 Mountain View Dr Apt 37, Jacksonville, FL, 322810.50Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more
PRV-21843PRVAlexis Wheeler1957-05-26—36397242976355 Highland Ave, Orlando, FL, 328900.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-23642PRVBruce Garrett1989-08-06UHC-03054-9588428217202966 Harbor Blvd, Glendale, AZ, 853240.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-20052PRVAnthony R Maldonado1958-06-17UHC-57454-9888162984597136 Sage Ct # 287, Dallas, TX, 752460.50Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-23456PRVChristian Fuller1993-07-18UHC-09907-7368091339701377 Desert Sky Blvd Apt 14, Eden Prairie, MN, 553050.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
PRV-28284PRVSophia Morgan1989-01-15—3636774936504 River Rd, Houston, TX, 770480.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23638PRVHiroshi S Mason1963-11-06—85423560094512 Willow Ct Apt 27, Columbus, OH, 432430.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-26911PRVJack J Smith1950-07-24UHC-36697-2995668242154569 Spring St, San Antonio, TX, 782470.50Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+3 more
PRV-25956PRVLaura Cooper2007-11-04—35965640231831 Willow Ct, San Diego, CA, 921060.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
PRV-21941PRVLori Q Lane2006-03-28UHC-27982-3283045970425174 Church St Apt 34, Atlanta, GA, 303920.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-29356PRVYuki R Hunt1998-12-09—58244162145754 Main St # 170, Tucson, AZ, 857800.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-26820PRVWatkins N Amber1976-10-16UHC-11916-1129546106599383 Baseline Rd, Tempe, AZ, 852920.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-20441PRVBilly Lopez1955-10-08—41539725203626 Sage Ct Apt 22, Seattle, WA, 981250.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-20381PRVKatherine Carpenter1949-04-23UHC-20620-5967068394294824 Lake View Rd, Plano, TX, 750460.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-29492PRVBryan Clark1978-05-19—3174122429705 Camelback Rd Apt 27, Tampa, FL, 336380.50Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+3 more
PRV-28718PRVEveyln Smith1939-01-01—67270203427492 Ridge Rd Apt 9, Fresno, CA0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-20338PRVCarolyn Barnes1978-04-07—69338529236013 Church St, Las Vegas, NV, 891510.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25492PRVArthur Chavez1973-02-02UHC-10907-0236860142733230 Pine Dr, Miami, FL, 331790.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22012PRVDenise Ryan1976-07-02UHC-47417-6473020172775141 Baseline Rd, Eden Prairie, MN0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-22001PRVBenjamin B Davis1971-12-09—96378817784361 Cedar Ln, Las Vegas, NV, 891510.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23818PRVRichard Alvarez1969-07-23—81629298785615 Oak St, Tampa, FL, 336530.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26163PRVVictoria H Flores1944-02-20UHC-25370-9232679851597285 Apache Blvd # 886, Tempe, AZ, 852610.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-22914PRVRonald Perez1992-01-17UHC-32632-1240292413568671 Pine Dr # 693, Austin, TX, 787650.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-25249PRVMariana Ryan——78732588292596 Valley View Dr, Plano, TX, 750820.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
PRV-23499PRVHiroshi X Hanson1939-12-11UHC-76924-2494847553776791 Baseline Rd, Minneapolis, MN, 554250.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-24308PRVArjun Johnston1966-02-05UHC-67323-9363198129423085 Forest Ave, Austin, TX, 787630.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-23623PRVCamila James1946-05-03—90374636376031 Oak St, Eden Prairie, MN, 553540.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-27152PRVWanye Stephens1981-07-10UHC-60073-1047573550748351 Hillcrest Rd # 342, Seattle, WA, 981890.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-25291PRVKimberly R Ortega2000-05-19UHC-66789-55—7148 Sage Ct Apt 17, Jacksonville, FL, 322970.50Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
PRV-27665PRVJasson Ramirez2005-12-13UHC-29490-8577471867626091 Cedar Ln, Plano, TX, 750290.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24733PRVJuan Butler1952-03-08UHC-52359-4535654661794309 Willow Ct Apt 19, Plano, TX, 750310.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-22685PRVNancy Rios1945-11-03——7547 Highland Ave Apt 19, Columbus, OH, 432860.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-23180PRVKayla Stephens1947-07-20UHC-86478-9680153859152909 Washington St # 771, Miami, FL, 331060.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-21558PRVJohn B Oliver1954-09-26——3713 Lake View Rd, Charlotte, NC, 282260.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-25978PRVScott Hughes1958-01-10UHC-53716-2682174851575069 Lincoln Way, Orlando, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-25979PRVScott Hughes1958-01-10UHC-53716-2682174851575069 Lincoln Way, Orlando, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-20523PRVBetty Yuong1987-10-28UHC-02259-5077824858608656 Sunset Blvd, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28329PRVWallace Thomas1978-02-12UHC-19625-0245963176624115 Market St, Las Vegas, NV0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21870PRVMarcus Turner1974-12-07——5655 Bayshore Dr, Columbus, OH, 432620.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-24661PRVTyler Banks2001-05-24—50865463826126 Ocean Ave, Seattle, WA, 981100.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
9,596 rows, page 11 of 192PreviousNext