PHR Database Cleanup

Current team

No one yet. Enlist yourself below!

Still Needs

1 database engineer.

Here's the gist

Since 1986, Physicians for Human Rights (PHR) has used medicine and science to document and call attention to mass atrocities and severe human rights violations.This is a high priority project to audit and clean up PHR database of record.

Problem

PHR has identified multiple problems with existing database: duplicates, incorrect or incomplete data, incorrect data type, correct data in wrong fields, etc.

Goal

PHR would like assistance running MYSQL queries against our SQL server database of record. These queries would be built to help us identify incomplete, incorrect, or irrelevant parts of our constituent dataset allowing us to replace, modify or delete the inaccuracies in a batch process. Additionally, we would like help in developing the best processes for cleanup and ongoing maintenance. The goal is to help us improve our data and target specific constituent groups with higher accuracy through our communications. By improving our data hygiene we will also be able to make more informed decisions regarding our strategic direction.

Skills

MySQL, SQL, Data Analytics, SQL Server. Raiser’s edge experience.

Point of contact

Philip Hadley, Digital Communication Manager

Can you help?