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-25685PRVJudy Hoffman1949-11-07UHC-63831-15—9408 Valley View Dr, Phoenix, AZ, 850160.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-26268PRVDiana P Lane1990-09-25—82430774123391 Indian School Rd, Mesa, AZ, 852650.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20671PRVCamila Snydre1953-12-15UHC-87849-6834199190785462 Union St, Austin, TX, 787760.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-26435PRVSandra Franklin2007-06-07—55149419278987 Palm Dr, Jacksonville, FL, 322570.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21906PRVAaron J Obrien1967-10-21——2467 Central Ave, Chandler, AZ, 852770.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26556PRVAaron Coleman1950-11-02—46847164385871 Forest Ave, Las Vegas, NV, 891920.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-22670PRVTheresa Cunningham2004-01-18—96139036628763 Washington St, Tempe, AZ, 852770.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24495PRVAisha Owens2002-06-26—23170753187806 Main St, Orlando, FL, 328680.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20557PRVEthan T Fuller1964-02-12UHC-06353-046324719102975 Mountain View Dr, Nashville, TN, 372160.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-24294PRVRebecca Bennett1948-04-27UHC-21274-8982974181455990 Camelback Rd, Gilbert, AZ, 852680.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26812PRVDiego Ferguson1984-06-08UHC-07762-2297068595371523 Union St, San Antonio, TX, 782290.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-24948PRVLuis Delgado1999-05-08—50322233726453 Grand Ave Apt 30, Las Vegas, NV, 891930.76Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
PRV-29102PRVDorothy Spencer1947-06-15—46041766228114 Sage Ct, Gilbert, AZ, 852470.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24225PRVMei B Bradley1999-03-09UHC-98883-3396965361313322 Palm Dr, Denver, CO, 802770.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21410PRVGabriel Robinson1952-09-09—98247797339720 Desert Sky Blvd, Nashville, TN, 372020.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28769PRVRachel M Fowler1983-05-20—24388327168542 Forest Ave, Minneapolis, MN, 554050.76Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-20531PRVAnna K King1941-01-11UHC-76044-905507012262251 Main St, Eden Prairie, MN, 553230.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-29100PRVLawrence Berry1995-06-24—46720413524585 Canyon Rd, Miami, FL, 331620.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
PRV-29203PRVJordan Brooks1963-03-19UHC-55414-7275165789279719 Church St, Plano, TX, 750530.76Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-23531PRVRussell U Armstrong1968-04-21UHC-31168-6891058698207959 Sunset Blvd, Columbus, OH, 432030.76Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more
PRV-26853PRVCharlotte Richards1938-04-21UHC-72303-3752042543932821 Canyon Rd, Plano, TX, 750280.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29003PRVAlexander Stephens1991-02-08—71862551947415 Oak St, Glendale, AZ, 853190.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24131PRVDorothy Boyd1945-09-27—96767899747813 Lincoln Way, Sacramento, CA, 958940.76Name re-casedPhone reformattedCity re-casedGender normalised+2 more
PRV-24108PRVJesse M Sandoval1962-10-14—87626744932084 Jefferson Ave, Jacksonville, FL, 322860.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-23026PRVAustin Herrera2002-09-12——9279 Park Pl, Charlotte, NC, 282680.76Name split from “Last, First”Date of birth reformattedCity re-casedEmail lower-cased+2 more
PRV-28460PRVAnn Santiago1990-01-07UHC-72018-8943134141034669 Main St, Glendale, AZ, 853380.76Phone reformattedMember ID reformattedZIP+4 trimmedEmail lower-cased+2 more
PRV-24791PRVOmar Williamson1954-08-11—37533426923803 Willow Ct, Scottsdale, AZ, 852670.76Date of birth reformattedPhone reformattedState code upper-casedEmail lower-cased+2 more
PRV-27968PRVMarilyn R Sullivan1952-05-20—27485195085246 Desert Sky Blvd, Miami, FL, 331430.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22622PRVJoyce Morris1967-12-27UHC-36491-2977055299034392 Elm St, Scottsdale, AZ, 852790.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21839PRVAlbert Owens1942-03-01UHC-26507-26—367 Central Ave, Charlotte, NC, 282360.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27236PRVJudy Lee1996-08-09——3033 Mesa Dr, Tempe, AZ, 852650.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-21131PRVSharon Vasquez1943-08-14UHC-15996-0284298828682682 Broadway, Phoenix, AZ, 850780.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
PRV-21181PRVDebra Lawson1939-08-19UHC-10156-1698042912476946 Market St, Dallas, TX, 752700.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24786PRVMelissa Henderson1956-08-04UHC-06487-0544665958443872 Highland Ave, Los Angeles, CA, 900210.76Name re-casedDate of birth reformattedPhone reformattedCity re-cased+2 more
PRV-20706PRVPatrick Carter1986-11-22UHC-68722-5659337868159383 Washington St, San Diego, CA, 921010.76Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-25499PRVRyan Hernandez1959-01-19UHC-51810-1357270945836988 Sage Ct, Charlotte, NC, 282050.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21713PRVLarry Bradley1979-01-15UHC-38911-80—1967 Meadow Ln, Tucson, AZ, 857560.76Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
PRV-23621PRVCarlos Y Guerrro1960-03-11—697585936953 Grand Ave, Gilbert, AZ, 852410.76Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-22398PRVHelen L Austin2003-09-10—58281971539204 Ridge Rd, Glendale, AZ, 853450.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22397PRVHelen L Austin2003-09-10—58281971539204 Ridge Rd, Glendale, AZ, 853450.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23114PRVKenneth G Wells1941-09-05—96770924756601 Highland Ave, Chandler, AZ, 852840.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-27673PRVDiego Lucas1952-06-09UHC-55378-4273734705045253 Church St, Columbus, OH, 432050.76Date of birth reformattedPhone reformattedState name converted to codeEmail lower-cased+2 more
PRV-26554PRVBarbara V Rogers1993-12-17—93249831283065 Valley View Dr, Mesa, AZ, 852920.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-21235PRVRaymond H Hanson1990-05-20UHC-40217-4971439117753321 Grand Ave, Atlanta, GA, 303880.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23050PRVRonald Dominguez1989-05-26—24374530454274 Desert Sky Blvd, San Antonio, TX, 782000.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-24179PRVMegan Andews1974-07-14—43771037179086 Palm Dr, Columbus, OH, 432740.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26155PRVPeter Arnold1996-09-19—63472080043662 Ocean Ave, Charlotte, NC, 282820.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28093PRVSandra Perkins1942-06-25—51341816201706 Apache Blvd, Miami, FL, 331370.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24783PRVVictoria W Mitchell1998-08-11—79435588552965 Forest Ave, Chandler, AZ, 852640.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-26575PRVJustin M Knight1985-10-27UHC-39714-9625557619952762 Forest Ave, Seattle, WA, 981020.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
9,596 rows, page 93 of 192PreviousNext