Challenges

Challenge #1

Create a solution to convert non-financial supporters into financial supporters.

Challenge #2

Create a solution that allows information to be more easily stored, managed, harvested and accessed by the Second Harvest team.

Challenge #3

Create a solution that allows Second Harvest to leverage the potential benefits of its data.

Challenge #4

Create a solution that shares information between donors and volunteers in real-time.

Challenge #5

Expedite the process of capturing and digitizing donor information.

Messages to Participants

Challenge #1

  • The focus of this solution should lean towards conversion strategy

Challenge #2

  • Users have access to smart devices, and voice memo capabilities

Challenge #3

  • Data may need to be cleaned up

Challenge #4

  • Solution needs to be easily accessible on smart devices

Challenge #5

  • Solution needs to be used for raffle tickets
  • Solution needs to include
    • Name
    • Address
    • Phone
    • Email
  • Information will be used to convert to mailing list

Resource List

All data has been scrubbed all of the identifying information from these lists (name, email, phone #, etc.). Columns have been left for contact information in files where it’s applicable, but have replaced the specifics with a ‘Yes’ where something is available and a ‘No’ where it isn’t.  In lieu of address information we’ve used postal codes, so where a postal code appears we do have access to that constituent’s address, but where a ‘No’ appears we do not. Also, please note that we have left in unique constituent id’s in all of the data sets and these are consistent across all of the files.


  1. Contact info for current supporters
    For this individual, their postal code is listed, which means we have their address, we have their email address, their phone number, as well as permission to email them. Using the provided ID, you can look up this constituent across all of the other data sets to follow.

  2. Contact info for e-news subscribers
    This is a full up-to-date list of our e-news subscribers.

  3. Demonstration of current online donation process
    This document outlines the current donation process.

  4. Annual Online Donations
    For the online gifts file we have included all individual gifts received online during our last two fiscal years (our fiscal year begins on September 1st). Please note that we’ve excluded any gifts over $1,000 and any monthly pledges that are processed online – we solicit and treat these gifts differently and they skew the online giving metrics pretty substantially. We have included both donation amounts and our campaign designations for each gift, but these will probably require a bit of explanation from us during the hackathon.

  5. Food Collection & Delivery Data
    These files combine both pick-ups from food donors and deliveries to agencies, but they are both well labelled. We have also removed the identifying information for all of these organizations but they all have their unique constituent id’s listed.

  6. Recipient Agency Survey Data
    This is a full data dump of our annual agency survey. We have excluded the first 8 questions from the data because they all refer to specific identifying organizational   information. Please note that we currently conduct this survey through Survey Gizmo. We’ve also attached a pdf of all the questions just so you have them.

  7. Chart for Sharing Food Donor/Pick-up Information
    This chart includes all of the specifics that we require for a volunteer food pick-up. Right now this sheet is only used offline and it is filled in manually.

  8. Samples of Handwritten Raffle Tickets
    The samples attached are scanned copies of historical raffle tickets