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-28320PRVPhilip X Gray1982-01-06—41292656746954 Sage Ct, Dallas, TX, 752140.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-27917PRVKatherine Butler1938-10-05—79054446687504 Desert Sky Blvd, Houston, TX, 770990.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-26837PRVMegan Y Thompson2007-01-06—74537774629786 Union St, Orlando, FL, 328960.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26158PRVSara H Moore1996-03-26—49672109637068 Market St, Tucson, AZ, 857810.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29275PRVArthur Valdez1996-08-18UHC-18114-7742966740008255 Ocean Ave, Columbus, OH0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-25965PRVDorothy B Greene1965-11-01——1956 Indian School Rd, Glendale, AZ, 853380.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-22645PRVCharlotte O Peterson1963-07-15UHC-11340-186588626908833 Central Ave, Tempe, AZ, 852430.64Middle initial moved out of first nameName re-casedPhone reformattedState name converted to code+2 more
PRV-23461PRVEugene Ryan1938-10-12UHC-31719-6265685339928037 Valley View Dr, San Diego, CA, 921330.64Name split from “Last, First”Date of birth reformattedMember ID reformattedGender normalised+2 more
PRV-27373PRVJustin Chavez1947-05-07—90979397718672 Canyon Rd, Tucson, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26929PRVAaron Reyes1996-04-11UHC-76516-13—593 Pine Dr, Phoenix, AZ0.64Name re-casedTwo-digit birth yearCity re-casedZIP missing+2 more
PRV-23227PRVMark Green1981-09-10—46166975481449 Maple Ave, Los Angeles, CA, 900080.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-26493PRVPhilip Olson——72798440013574 Lake View Rd, Chandler, AZ, 852100.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20707PRVAnn R Harris1985-01-28—58699208942557 Willow Ct, Dallas, TX, 752060.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-29557PRVJanny King1997-10-25UHC-93242-2176027062972291 Forest Ave # 402, San Antonio, TX, 782240.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-26699PRVWei Morris1970-02-14—21397376469555 Central Ave, Mesa, AZ, 852530.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21552PRVElijah Schultz1982-05-16—58865197666187 Pine Dr, Tampa, FL0.64Name re-casedTwo-digit birth yearPhone reformattedZIP missing+2 more
PRV-20760PRVJulia Nguyen1941-11-07—86124664174434 Washington St, Tucson, AZ, 857220.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-26957PRVBryan S Franklin1981-12-17UHC-08186-778982608770325 Valley View Dr, Scottsdale, AZ, 852000.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22674PRVBruce Griffin1978-03-04——5529 Ridge Rd, Los Angeles, CA, 900410.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23281PRVLori Jordan1985-05-24UHC-12979-7072149276073367 Ocean Ave, Mesa, AZ, 852090.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22344PRVDiego Hill1986-04-18UHC-71876-2770228532752197 Church St, San Antonio, TX, 782270.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25369PRVBrian M McCoy1958-07-15UHC-72352-9822049231738242 Union St, Tempe, AZ, 852380.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22749PRVHeather SJunk1960-05-18—7263988696—0.64Name re-casedTwo-digit birth yearPhone reformattedEmail lower-cased+2 more
PRV-25786PRVJose Yang——96957082353298 River Rd, Tucson, AZ, 857370.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28867PRVJesse Floras2008-11-16UHC-66809-5175198917057763 Hillcrest Rd, Nashville, TN, 372750.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28937PRVGeorge Estrada1989-06-18UHC-50821-5022350029193618 Canyon Rd, Atlanta, GA, 303000.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21697PRVSamuel Wylson2003-04-10UHC-53403-9068584132424811 Broadway, Sacramento, CA, 958650.64Name split from “Last, First”Phone reformattedMember ID reformattedGender normalised+2 more
PRV-23043PRVSantiago Perkins1977-11-25—54460445036183 Apache Blvd, Scottsdale, AZ, 852850.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28734PRVAustin Contreras1941-12-19UHC-72120-4928879227147460 Canyon Rd, San Diego, CA0.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21128PRVJudy Hawkins1942-06-04UHC-30240-1984848728471144 Washington St, Houston, TX, 770890.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-23371PRVCheryl S Lee1957-11-25—77956544486438 Baseline Rd, Dallas, TX, 752450.64Middle initial moved out of first nameTwo-digit birth yearPhone reformattedEmail lower-cased+2 more
PRV-25345PRVRachel Jacobs1997-04-04UHC-30192-7947390854028448 Camelback Rd, Gilbert, AZ0.64Name re-casedPhone reformattedCity re-casedState name converted to code+2 more
PRV-22889PRVAmber Howell1967-03-16—6768224706575 Hillcrest Rd, Minneapolis, MN, 554850.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-20423PRVMaria W Mendez1940-06-16UHC-87975-3176297833982907 Cedar Ln, Orlando, FL, 328480.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-26390PRVPamela Q Grant1949-06-15—71233535936343 Maple Ave, Denver, CO, 802350.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-26796PRVMark Garrett1994-11-07UHC-56857-9050545498377693 Central Ave, Miami, FL, 331960.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27923PRVJacob Alvarado1953-02-16—75275220878878 Ocean Ave, Nashville, TN, 372690.64Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-29208PRVCarol Willis1982-12-20—90232561005189 Cedar Ln, Eden Prairie, MN, 553330.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21190PRVMarcus T Little2001-03-28—87258415899687 Ridge Rd, Gilbert, AZ, 852660.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21189PRVMarcus T Little2001-03-28—87258415899687 Ridge Rd, Gilbert, AZ, 852660.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20673PRVGeorge Castillo2008-10-04UHC-12374-3020747009325752 Sage Ct, Phoenix, AZ, 850550.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28657PRVCarol Duncan1943-10-11UHC-01787-2160390479139468 Forest Ave, Scottsdale, AZ, 852540.64Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-20696PRVCarr P Fatima1954-11-23UHC-87958-422424617953931 Cedar Ln, Charlotte, NC, 282260.64Middle initial moved out of first nameName re-casedPhone reformattedState name converted to code+2 more
PRV-22668PRVDoris Stewart1968-03-04—61945110775776 Sage Ct # 203, Minneapolis, MN, 554800.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-24545PRVAngela Willis1984-11-27UHC-64489-2838922451364786 Hillcrest Rd, Seattle, WA, 981950.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-23484PRVMichael Bishop1941-05-08UHC-40617-3924785812565310 Lincoln Way, Tempe, AZ, 852310.64Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more
PRV-27983PRVAlbert U Johnston1961-05-09UHC-58242-5755487785045512 Highland Ave, Tucson, AZ, 857500.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-23582PRVDebbie X Jimenez1956-11-20——5416 Market St, Orlando, FL, 328730.64Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-24036PRVDoris Singh1950-09-25UHC-06680-5042160817627706 Sage Ct, Las Vegas, NV, 891200.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-22314PRVEmily Ellis2001-01-27UHC-19306-549315959115321 Sage Ct, Austin, TX, 787480.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
9,596 rows, page 48 of 192PreviousNext