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-21501PRVBilly Morgan1977-10-28UHC-03233-8484781824852010 Union St # 989, Denver, CO, 802240.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
PRV-25445PRVJanice Weaver1973-10-17—61380300401279 Oak St, Denver, CO, 802250.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24303PRVShirley Adams1972-07-20—91595112748927 Ridge Rd # 823, Houston, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25239PRVJanice Marquez1938-09-08UHC-17144-80—8672 Cedar Ln, Chandler, AZ, 852530.50Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-20248PRVGrace D Rodriguez1994-03-14——4481 Sage Ct, San Antonio, TX, 782170.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
PRV-28639PRVJose Yang1996-12-24UHC-79343-1761392545646764 Ridge Rd, Tampa, FL, 336570.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28006PRVOlivia Lynch1992-07-18UHC-54864-6850825430132929 Union St, Los Angeles, CA, 900620.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21607PRVBrian Martin1955-12-12—29297555238828 Cedar Ln, Seattle, WA, 981130.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-22993PRVMegan Olson1945-10-28UHC-31741-4667041012263348 Ridge Rd, Los Angeles, CA, 900970.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23981PRVAndrea Wilson2006-01-08—52481817874292 Pine Dr, Tempe, AZ, 852820.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24958PRVKelly V Espinoza1999-11-27——2936 Canyon Rd, Sacramento, CA, 958580.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26165PRVWilliam C Castro—UHC-34758-3586282382595084 Park Pl Apt 2, Eden Prairie, MN, 553420.50Name split from “Last, First”Date of birth unreadablePhone reformattedUnit split from street+3 more
PRV-27429PRVAndraa Sanders1942-07-25——1519 Harbor Blvd, Houston, TX, 770510.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-21089PRVKeith Degado1945-11-19UHC-23405-4071856113832236 Forest Ave # 419, Sacramento, CA, 958840.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-22352PRVAngela X Cook—UHC-77530-8544251927795523 Forest Ave, Tucson, AZ, 857210.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23219PRVCarol Thomas1955-07-27——621 Apache Blvd # 471, San Diego, CA, 921130.50Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
PRV-28776PRVAshley V Marquez1939-01-03UHC-56997-244835801301384 Lake View Rd Apt 8, Nashville, TN, 372790.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25632PRVMei J Stevens——25076842297727 Highland Ave, Glendale, AZ, 853830.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-26441PRVDiane Henry1975-02-03—27690779132927 Ridge Rd Apt 7, Chandler, AZ, 852680.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-24907PRVJerry Bowman1954-04-03UHC-10796-0621575522305417 Oak St, Eden Prairie, MN, 553470.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21681PRVAhmed Munoz1980-06-16—38277641973355 River Rd, Plano, TX, 750540.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
PRV-28847PRVChristian I Simmons1996-09-04UHC-30204-7440085924998494 Central Ave Apt 38, Phoenix, AZ, 850920.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-21983PRVJulia Webb1990-04-26—56532743135812 Oak St Apt 39, Fresno, CA, 937670.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-24141PRVJanet W Wallace1939-11-19UHC-29568-5585887939712662 Elm St Apt 37, Glendale, AZ, 853950.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-20621PRVKayla Wong1966-10-13—61249291385312 Apache Blvd, Mesa, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-28856PRVDonna P Torres1957-03-17UHC-62265-9268781026352673 Park Pl, Tempe, AZ0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
PRV-25904PRVChristopher Bishop1981-09-28—75632580329509 Forest Ave, Houston, TX, 770780.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-28837PRVJudy Munoz1939-12-27—22783197371477 Lincoln Way, Fresno, CA, 937670.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21956PRVSofia Greene1976-05-20UHC-16642-19—6125 Apache Blvd, Denver, CO, 802390.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-21899PRVVirginia Greene2005-06-22UHC-49687-5626555240914747 Willow Ct, San Diego, CA, 921520.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25895PRVKelly Vasquez1994-11-02——2110 Church St, Mesa, AZ, 852740.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
PRV-28238PRVBruce Harvey2004-03-21—68975922839486 Indian School Rd, Orlando, FL, 328760.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22226PRVVirginia G Yang1988-08-28UHC-41415-62—200 Jefferson Ave, Mesa, AZ, 852870.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-22374PRVJose Maldonado1953-02-07UHC-41703-3176634824475368 Camelback Rd, Los Angeles, CA, 900140.50Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
PRV-20878PRVDrew Little1958-05-10UHC-87409-1959466731457294 Spring St, Chandler, AZ, 852570.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21624PRVTerry D Guzman1950-12-08—47587129393966 Bayshore Dr, Nashville, TN, 372470.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27160PRVJuy Kim1947-05-11—26559551751313 Market St, Miami, FL, 331610.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24658PRVKathryn Ortega2002-07-27UHC-85581-79—1848 Main St, Atlanta, GA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25461PRVBarbara F James1988-06-23UHC-77875-98—2480 Ocean Ave # 741, Miami, FL, 331030.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25758PRVEthan Simmons1947-08-08UHC-10103-539273792900922 Palm Dr, Tempe, AZ, 852590.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-24726PRVRonald Lee1941-06-28——7618 Desert Sky Blvd, Seattle, WA0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-25022PRVKaren Nunez1964-07-26UHC-53022-613893833489315 Indian School Rd, Atlanta, GA, 303240.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-26466PRVRachel Flores2001-04-19UHC-51774-4447685152624893 Central Ave, Houston, TX, 770600.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-23713PRVDebra Duncan1989-01-03UHC-10860-4159038882172197 Washington St, Tempe, AZ, 852770.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23356PRVMason B Murphy1956-11-11UHC-40374-1921187990223805 Pine Dr Apt 28, Eden Prairie, MN, 553000.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-23244PRVTyler M Morales1959-07-02—72645911833280 Ridge Rd, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23245PRVTyler M Morales1959-07-02—72645911833280 Ridge Rd, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22149PRVLucia E Butler1997-12-24UHC-64949-99—3810 River Rd, Denver, CO, 802100.50Name re-casedTwo-digit birth yearPhone missing area codeMember ID reformatted+3 more
PRV-22150PRVLucia E Butler1997-12-24UHC-64949-99—3810 River Rd, Denver, CO, 802100.50Name re-casedTwo-digit birth yearPhone missing area codeMember ID reformatted+3 more
PRV-22594PRVPatricia Gomez—UHC-71807-5229284186743964 Highland Ave, Scottsdale, AZ, 852990.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
9,596 rows, page 10 of 192PreviousNext