Hack the Opioid Crisis: Aggregating data

laveshaparker commented 6 years ago

What problem are we trying to solve?

Having fresh and complete data to supplement the map project and to serve as internal tools and support to the other Hack the Opioid Crisis projects. This data should be the backbone to the user-facing projects and have a compatible and clean API that they can work with.

Who will benefit (directly and indirectly) from this project?

The other projects under the Take Back Day initiative and at the end of the day, the Take Back Day attendees.

Where can we find any research/data available/articles?

We have data sources from the Attorney General's office in this public repo and can try and scrape other sites if we need to. DisposeMyMeds.org (community pharmacies) and Walgreens (maybe tied to CVS locations might be separate, needs to be looked into.) NYS Department of Conservation also has locations. DEA pop up sites list: takebackday.dea.gov

What help is needed at this time?

It also needs developers who are excited about writing tests, webscraping, and data cleaning.

What are the next steps (validation, research, coding, design)?

Architecture

What DB are we going to use to store this data?
How will we deploy it as a service?
How will this work as an API for other projects?
How can we test the data so that users don't ever see sites that are so incomplete that they can't get to them or are wrong?

How can we contact you outside of Github(list social media or places you're present)?

Kalim kalim.fleet@gmail.com Daeha daehako@gmail.com

Project management

Checklist for NEW ideas :baby:

Hey, you're official! You're now part of the growing Progressive HackNight community. Here's a few things to get started (a couple you've probably already done).

[x] Create this idea issue
[x] Flesh out the who, where, and what questions above
[x] Start the conversation about this new idea on Slack (this project uses #general )
[ ] Respond with at least one update on this issue within the next month

Checklist for ACTIVE projects :fire:

Let's get this project started! When this idea starts taking off, the Progressive HackNight Team will start helping this project's lead(s) out with project management and connecting you to resources you may need. To get there, please complete and check off the following:

[ ] Post an update at least once a month to this issue. Use BASEDEF for ideas, but it's ok even if your update is just "nothing new happened this month" or "we saw a small increase in traffic to our app this month". If there's no activity for two months, that's no problem, life happens. We'll just label this as backlog so others know you'll get back to it when you have the time. If nobody hears from you at all in more than two months, we may mark it as abandoned so that others can pick up this idea and run with it.
[x] Create a GitHub repository and Slack channel for work.
[ ] Create issues to describe each task that you plan to do or need help with and how a contributor can get started on that task. You might start and stop a lot, so consider issues as your to-do list.
[ ] Create a team for your core contributors
- This will make it easier for you to manage your github repo access. People on a team have the same level of access. Admin access will allow your trusted contributors to make changes as needed.
- You can remove and add people to your team as needed.
- Note: You can also allow collaborators outside of your team and give them more limited access.
[ ] Create a Google Drive, Dropbox, or other cloud storage to share larger files
- Github and Data.World are good for code and data, respectively, especially when you need version control. But they're not good for very large files, documentation, articles, etc. A cloud storage option will allow you to easily share, create, and collaborate on documents with your team and help organize ideas and thoughts.
- Doing this early on can help your team stay organized and to onboard new contributors who wouldn't have access to files you all have shared over email.

If you get stuck at any point, feel free to reach out to the leadership team with an email to steering@progressivehacknight.org or come find an organizer at a HackNight. We're here to help bring great ideas to life!

violazhong commented 6 years ago

https://docs.google.com/spreadsheets/d/1P1QcChPp53fT5bn6u-xS7Zt_OfswZJN8AddRRG1z9j4/edit?usp=sharing

Adding several major websites we might work with

ibrand commented 6 years ago

This project ended up providing the data that supplied the map (#9)

ProgressiveHackNight / project-ideas