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-21891PRVMarcus Delgado1990-12-17UHC-19436-2390092399632234 Camelback Rd, Glendale, AZ, 853750.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-21540PRVLawrence M Hamilton1949-01-17—36622688278701 Sunset Blvd, Sacramento, CA, 958810.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25132PRVJudith R Castro1946-06-18—33892494189281 Baseline Rd, San Diego, CA, 921800.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28981PRVGeorge Williamson1953-03-23—31525096532608 Spring St, Sacramento, CA, 958790.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28440PRVZachary Guerrero1961-10-11UHC-59045-4296172564239075 Desert Sky Blvd, Chandler, AZ, 852870.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-20987PRVDavid Y Parker1972-06-19UHC-27308-0359731744003490 Church St, Seattle, WA, 981260.74Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-22039PRVDiane D Gibson1978-01-07UHC-53548-2572892136288641 Highland Ave, Austin, TX, 787200.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20480PRVSantiago Rivera1951-02-05—42765678613442 Camelback Rd, Minneapolis, MN, 554430.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-28288PRVLaura Thomas1940-04-21UHC-63477-4081048044482534 Central Ave, Columbus, OH, 432270.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-27185PRVCynthia Ray1952-08-09UHC-95030-1624233452315099 Ocean Ave, Sacramento, CA, 958990.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21861PRVWilliam F Moreno1953-05-16UHC-32552-3071226647797067 Forest Ave, Austin, TX, 787290.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23133PRVBruce V Little1941-07-05—75126087762833 Sunset Blvd, San Diego, CA, 921150.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26161PRVThompson Barbara1967-10-28—62735342458600 Washington St, Tempe, AZ, 852330.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27513PRVAna Jordan1952-10-12—88454001015091 Washington St, Seattle, WA, 981680.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27280PRVGabriel C Patterson1980-06-05UHC-73125-8796422521232762 Elm St, Glendale, AZ, 853930.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-22828PRVCharlie Taylor1946-01-22——3261 Jefferson Ave, Austin, TX, 787630.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28343PRVDiana Ellis1985-05-03—39433155762713 Maple Ave, Phoenix, AZ, 850470.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24994PRVAlbert L Santos1956-12-07—54789756238286 Harbor Blvd, Mesa, AZ, 852460.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-23922PRVStephen Hansen1939-05-11UHC-67426-32—8089 Pine Dr, Fresno, CA, 937390.74Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-21121PRVAndy Rivera1983-06-13UHC-42281-6690272227803452 Broadway, Nashville, TN0.74Name re-casedDate of birth reformattedMember ID reformattedCity re-cased+3 more
PRV-28577PRVNatalie O Rios1962-12-13—42381124578638 Broadway, Tucson, AZ, 857870.74Name re-casedTwo-digit birth yearPhone reformattedAddress re-cased+3 more
PRV-24949PRVLuis Delgado1999-05-08—50322233726453 Grand Ave, Las Vegas, NV, 891930.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23286PRVMaria Edwards1962-11-07UHC-00544-8945962115912604 River Rd, Mesa, AZ, 852590.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22446PRVBryan Herrera2003-11-28—83744248527399 Palm Dr, Glendale, AZ, 853860.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27108PRVDonald R Hudson1976-01-19——6764 Baseline Rd, Charlotte, NC, 282840.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23113PRVJustin Y Castro1943-10-26—33660279955655 Bayshore Dr, Tucson, AZ, 857190.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21248PRVDavid Lawrence1940-06-20UHC-89096-3048749633039104 Washington St, Fresno, CA, 937410.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20300PRVJustin Shaw1971-02-13UHC-36800-9772325223599091 Baseline Rd, Eden Prairie, MN, 553010.74Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-26755PRVAmber Nichols2004-09-27UHC-96274-4940531099922520 River Rd, Scottsdale, AZ, 852690.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-22899PRVPhilip Montgomery1947-11-16UHC-95197-1397245507472672 Spring St, San Antonio, TX, 782110.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25106PRVSophia Larson1987-04-20UHC-69834-5130290125286801 Washington St, Tempe, AZ, 852630.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26844PRVNathan Watkins1974-08-06—79832438192794 Market St, Minneapolis, MN, 554610.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-26123PRVKathleen Castillo1998-11-21UHC-90571-8441223815973704 Sage Ct, Dallas, TX, 752490.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-28642PRVJacob J Estrada2003-02-10—76352467273162 Park Pl, Miami, FL, 331980.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25762PRVJacob Jacobs2002-01-06—21235638182374 Jefferson Ave, Columbus, OH, 432960.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-28241PRVPriya Lopez1947-04-09—20765667956000 Harbor Blvd, Chandler, AZ, 852960.74Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-20877PRVAndrew Little1958-05-10UHC-87409-1959466731457294 Spring St, Chandler, AZ, 852570.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24774PRVAngela Rose1944-09-19UHC-67908-8052659601672743 Ridge Rd, Houston, TX, 770060.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-23914PRVJoseph Tran1948-01-21UHC-70624-2075835889545524 Oak St, Los Angeles, CA, 900940.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27020PRVNicholas Gonzalez1964-04-11—64361529776958 Lincoln Way, Los Angeles, CA0.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-25108PRVMatthew Dunn2008-11-24UHC-78000-2878060519922604 Ocean Ave, Tempe, AZ, 852820.74Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
PRV-29383PRVRaymond W Mendoza1993-02-15UHC-69480-2186726984465981 Maple Ave, Chandler, AZ, 852680.74Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-20308PRVMegan N Fields2000-05-15UHC-44065-2291860578281242 Spring St, Columbus, OH, 432120.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26124PRVFatima Kelly1973-06-10UHC-76176-6584541842694014 Jefferson Ave, Mesa, AZ, 852370.74Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-24490PRVDiana Oliver2003-10-02UHC-09068-4132825690894633 Hillcrest Rd, Seattle, WA, 981340.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-20198PRVArjun Lucas1993-03-09UHC-83630-6928975026167452 Indian School Rd, Nashville, TN, 372370.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21955PRVPatricia Nichols1945-03-18—31161966739725 Desert Sky Blvd, Eden Prairie, MN, 553970.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22475PRVDenise Olson1951-05-11—23745337799865 Maple Ave, Phoenix, AZ, 850640.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27543PRVAaron Nunez1987-02-13—92044286335598 Canyon Rd, Tampa, FL, 336530.74Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-28812PRVCarol Warren1952-07-21—77272837167040 Hillcrest Rd, Gilbert, AZ, 852660.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
9,596 rows, page 82 of 192PreviousNext