Skip to content

Instantly share code, notes, and snippets.

@riceissa

riceissa/gist:3bd6c82811c83031ccd96bd50ce30da9

Created August 12, 2017 19:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save riceissa/3bd6c82811c83031ccd96bd50ce30da9 to your computer and use it in GitHub Desktop.
Save riceissa/3bd6c82811c83031ccd96bd50ce30da9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> select donee,donation_date,(donor,donee,url,donation_date) in (select donor,donee,donation_url,donation_date from disclosures group by donor,donee,donation_url,donation_date) as disclosed from donations where donor='Open Philanthropy Project';
+----------------------------------------------------------------------+---------------+-----------+
| donee | donation_date | disclosed |
+----------------------------------------------------------------------+---------------+-----------+
| Forum for Climate Engineering Assessment | 2016-05-01 | 0 |
| Solar Radiation Management Governance Initiative | 2015-07-01 | 0 |
| University of Cape Town | 2016-09-01 | 0 |
| Future of Life Institute | 2016-03-01 | 0 |
| ClimateWorks Foundation | 2017-03-01 | 0 |
| Harvard University | 2016-12-01 | 1 |
| Rutgers University | 2017-03-01 | 0 |
| UCLA School of Law | 2017-04-01 | 0 |
| Future of Life Institute | 2015-08-01 | 1 |
| Electronic Frontier Foundation | 2016-11-01 | 0 |
| Machine Intelligence Research Institute | 2016-08-01 | 1 |
| George Mason University | 2016-06-01 | 1 |
| Center for Human-Compatible AI | 2016-08-01 | 0 |
| AI Impacts | 2016-12-01 | 0 |
| Future of Humanity Institute | 2017-03-01 | 1 |
| OpenAI | 2017-03-01 | 1 |
| Montreal Institute for Learning Algorithms | 2017-07-01 | 1 |
| UCLA School of Law | 2017-05-01 | 0 |
| Distill | 2017-03-01 | 0 |
| New York University | 2015-08-01 | 0 |
| Free Migration Project | 2016-05-01 | 0 |
| International Refugee Assistance Project | 2016-05-01 | 0 |
| Protect the People | 2016-02-01 | 0 |
| U.S. Association for International Migration | 2014-07-01 | 0 |
| ImmigrationWorks Foundation | 2014-07-01 | 0 |
| Center for Global Development | 2014-03-01 | 0 |
| ImmigrationWorks Foundation | 2015-12-01 | 0 |
| Niskanen Center | 2015-10-01 | 0 |
| Center for Global Development | 2017-03-01 | 0 |
| Global Animal Partnership | 2016-04-01 | 1 |
| Compassion in World Farming USA | 2016-04-01 | 0 |
| Green Monday | 2016-11-01 | 0 |
| The Humane League | 2016-11-01 | 0 |
| The Humane Society of the United States | 2016-11-01 | 0 |
| Mercy For Animals | 2016-11-01 | 0 |
| The Humane League | 2016-02-01 | 0 |
| The Humane League | 2016-07-01 | 0 |
| Humane Society International | 2016-08-01 | 0 |
| Mercy For Animals | 2016-08-01 | 0 |
| Animal Equality | 2016-08-01 | 0 |
| Fórum Nacional de Proteção e Defesa Animal | 2016-10-01 | 0 |
| People for Animals | 2016-08-01 | 0 |
| Brighter Green | 2016-09-01 | 0 |
| The Good Food Institute | 2016-09-01 | 0 |
| Mercy For Animals | 2016-02-01 | 0 |
| WildAid | 2016-09-01 | 0 |
| World Animal Protection | 2016-10-01 | 0 |
| The Humane Society of the United States | 2016-02-01 | 1 |
| Compassion Over Killing | 2016-12-01 | 0 |
| The Pollination Project | 2016-12-01 | 0 |
| Eurogroup for Animals | 2016-12-01 | 0 |
| Dyrevernalliansen | 2017-02-01 | 0 |
| Animal Welfare Standards Project | 2016-12-01 | 0 |
| Albert Schweitzer Foundation for Our Contemporaries | 2017-01-01 | 0 |
| Albert Schweitzer Foundation for Our Contemporaries | 2017-01-01 | 0 |
| Farm Forward | 2017-01-01 | 0 |
| Royal Society for the Prevention of Cruelty to Animals | 2017-02-01 | 0 |
| Compassion in World Farming | 2017-02-01 | 0 |
| Jeanne Marchig Centre | 2017-03-01 | 0 |
| Humane Society International | 2017-03-01 | 1 |
| Griffith University | 2016-12-01 | 0 |
| Wageningen UR | 2017-03-01 | 0 |
| Foundation for Food and Agricultural Research | 2017-04-01 | 0 |
| Animal Charity Evaluators | 2017-04-01 | 0 |
| International Society for Applied Ethology | 2017-03-01 | 0 |
| Institute for Advancement of Animal Welfare Science | 2017-03-01 | 0 |
| World Animal Protection | 2017-03-01 | 0 |
| Humane Slaughter Association | 2017-06-01 | 0 |
| The Greenfield Project | 2017-04-01 | 0 |
| Compassion in World Farming USA | 2017-05-01 | 0 |
| Animal Equality | 2017-05-01 | 0 |
| People for Animals | 2017-05-01 | 0 |
| Humane Society International | 2017-05-01 | 1 |
| Mercy For Animals | 2017-05-01 | 0 |
| Eurogroup for Animals | 2017-05-01 | 0 |
| Blue Ribbon Study Panel on Biodefense | 2017-01-01 | 0 |
| Johns Hopkins Center for Health Security | 2017-01-01 | 1 |
| Center for International Security and Cooperation | 2016-10-01 | 0 |
| Johns Hopkins Center for Health Security | 2016-10-01 | 0 |
| Blue Ribbon Study Panel on Biodefense | 2016-08-01 | 0 |
| International Genetically Engineered Machine Foundation | 2016-05-01 | 1 |
| Blue Ribbon Study Panel on Biodefense | 2015-04-01 | 0 |
| Future of Humanity Institute | 2016-09-01 | 0 |
| Nuclear Threat Initiative | 2017-02-01 | 0 |
| Georgetown Center for Global Health Science and Security | 2017-03-01 | 0 |
| National Academy of Sciences Engineering and Medicine | 2017-05-01 | 0 |
| Genspace | 2017-02-01 | 0 |
| BioBricks Foundation | 2017-04-01 | 0 |
| Ayni Institute | 2016-03-01 | 0 |
| Institute of the Black World | 2016-03-01 | 0 |
| New Virginia Majority Education Fund | 2016-10-01 | 0 |
| The Ordinary People Society | 2016-03-01 | 0 |
| Texas Fair Defense Project | 2016-10-01 | 0 |
| Legal Services for Prisoners with Children | 2016-07-01 | 0 |
| Justice Strategies | 2016-10-01 | 0 |
| Youth First Initiative | 2016-10-01 | 0 |
| Center for Court Innovation | 2016-07-01 | 0 |
| Essie Justice Group | 2016-10-01 | 0 |
| Ayni Institute | 2016-07-01 | 0 |
| Alliance for Safety and Justice | 2016-06-01 | 0 |
| Accountable Justice Project | 2016-04-01 | 1 |
| American Conservative Union | 2016-05-01 | 0 |
| ReFrame Mentorship | 2016-07-01 | 0 |
| Human Impact Partners | 2015-10-01 | 0 |
| Mijente | 2016-08-01 | 0 |
| New York University | 2015-04-01 | 0 |
| National Association of Community and Restorative Justice | 2016-11-01 | 0 |
| Correctional Association of New York | 2016-04-01 | 0 |
| Florida Rights Restoration Coalition | 2016-08-01 | 0 |
| Impact Justice | 2016-12-01 | 0 |
| Florida State University Project on Accountable Justice | 2015-02-01 | 0 |
| Promise of Justice Initiative | 2016-05-01 | 0 |
| JustLeadershipUSA | 2015-12-01 | 0 |
| Civil Rights Corps | 2016-12-01 | 0 |
| Ayni Institute | 2016-12-01 | 0 |
| Brooklyn Community Bail Fund | 2016-09-01 | 0 |
| Faith in Texas | 2016-09-01 | 0 |
| Harvard University Program in Criminal Justice Policy and Management | 2016-07-01 | 1 |
| Vera Institute of Justice | 2016-07-01 | 1 |
| Alliance for Safety and Justice | 2016-02-01 | 0 |
| Voice of the Ex-Offender | 2016-02-01 | 0 |
| The Ordinary People Society | 2016-07-01 | 0 |
| Pew Public Safety Performance Project | 2014-07-01 | 0 |
| Colorado Criminal Justice Reform Coalition | 2016-06-01 | 0 |
| Vera Institute of Justice | 2016-06-01 | 0 |
| Vera Institute of Justice | 2016-02-01 | 1 |
| Prison Policy Initiative | 2016-06-01 | 0 |
| BetaGov | 2013-12-01 | 0 |
| Washington Office on Latin America | 2013-12-01 | 0 |
| LEAD National Support Bureau | 2016-12-01 | 0 |
| The Soze Agency | 2016-12-01 | 0 |
| The Ordinary People Society | 2016-12-01 | 0 |
| Mothers Against Police Brutality | 2016-12-01 | 0 |
| Dream Corps | 2016-12-01 | 0 |
| Colorado Criminal Justice Reform Coalition | 2016-12-01 | 0 |
| Mission: Launch, Inc. | 2017-01-01 | 0 |
| Prison Policy Initiative | 2017-02-01 | 0 |
| Justice Solutions | 2017-02-01 | 0 |
| ReFrame Mentorship | 2017-02-01 | 0 |
| American Civil Liberties Union of Northern California | 2017-02-01 | 1 |
| Florida Rights Restoration Coalition | 2017-02-01 | 0 |
| Fair and Just Prosecution | 2017-01-01 | 0 |
| National Network for Safe Communities | 2017-02-01 | 0 |
| National Alliance of Faith and Justice | 2017-03-01 | 0 |
| Color of Change | 2017-05-01 | 0 |
| Blackbird | 2016-12-01 | 0 |
| American Civil Liberties Union Foundation of Oregon | 2017-03-01 | 1 |
| Vera Institute of Justice | 2017-03-01 | 0 |
| American Civil Liberties Union Foundation | 2017-04-01 | 0 |
| College and Community Fellowship | 2017-03-01 | 0 |
| Dignity and Power Now | 2017-06-01 | 0 |
| Court Watch NOLA | 2017-04-01 | 0 |
| East Bay Forward | 2017-04-01 | 0 |
| Better Boulder | 2016-04-01 | 0 |
| Sightline Institute | 2015-10-01 | 0 |
| Seattle for Everyone | 2016-02-01 | 0 |
| California Renters Legal Advocacy and Education Fund | 2016-06-01 | 1 |
| Urban Institute | 2015-09-01 | 0 |
| Smart Growth America | 2015-07-01 | 0 |
| Greater Greater Washington | 2017-06-01 | 0 |
| Roosevelt Institute | 2016-06-01 | 0 |
| Center for Popular Democracy | 2015-12-01 | 0 |
| Center on Budget and Policy Priorities | 2016-07-01 | 0 |
| Center for American Progress | 2016-03-01 | 0 |
| Economic Policy Institute | 2016-06-01 | 0 |
| Peterson Institute for International Economics | 2016-04-01 | 0 |
| Center for Popular Democracy | 2015-01-01 | 0 |
| Center on Budget and Policy Priorities | 2014-09-01 | 0 |
| Center for Popular Democracy | 2014-08-01 | 0 |
| Rescuing Biomedical Research | 2016-01-01 | 0 |
| Future of Research | 2016-04-01 | 0 |
| Foundation for the National Institutes of Health | 2016-07-01 | 0 |
| Innovative Genomics Institute | 2016-12-01 | 0 |
| Target Malaria | 2017-05-01 | 1 |
| CDC Foundation | 2017-05-01 | 0 |
| New Partnership for Africa’s Development | 2017-04-01 | 0 |
| Project Peanut Butter | 2016-09-01 | 0 |
| MIT Synthetic Neurobiology Group | 2016-03-01 | 1 |
| Associated Students of the University of California, Berkeley | 2015-02-01 | 0 |
| Population Services International | 2012-08-01 | 0 |
| Founders Pledge | 2016-09-01 | 0 |
| US Cochrane Center | 2012-07-01 | 0 |
| Brookings Institution | 2015-06-01 | 0 |
| University of Pennsylvania | 2016-03-01 | 0 |
| Carnegie Endowment for International Peace | 2015-03-01 | 0 |
| Center for Applied Rationality | 2016-05-01 | 1 |
| Alliance for Open Society International | 2014-07-01 | 0 |
| Center for Applied Rationality | 2016-07-01 | 1 |
| Cochrane Collaboration | 2014-06-01 | 0 |
| International Development Association | 2014-03-01 | 0 |
| Center for Global Development | 2013-06-01 | 0 |
| ARNOVA | 2015-08-01 | 0 |
| Rockefeller Archive Center | 2014-08-01 | 0 |
| Center for Global Development | 2013-07-01 | 0 |
| Center for Global Development | 2016-02-01 | 0 |
| Pepperdine University | 2014-06-01 | 0 |
| Georgetown University | 2015-08-01 | 0 |
| Waitlist Zero | 2014-09-01 | 0 |
| Waitlist Zero | 2015-08-01 | 1 |
| RAND Corporation | 2014-08-01 | 0 |
| Drug Policy Alliance | 2017-03-01 | 0 |
| 80000 Hours | 2017-03-01 | 1 |
+----------------------------------------------------------------------+---------------+-----------+
202 rows in set (0.04 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment