View dump.tsv
focus_area amount disclosed amount numDonations disclosed numDonations numDonees disclosed numDonees amount % disclosed donations % disclosed donees % disclosed
AI risk 43692297.00 36344525.00 11 6 11 6 0.831829 0.5455 0.5455
Animal welfare 23329114.00 3464000.00 46 4 32 3 0.148484 0.0870 0.0938
Biosecurity and pandemic preparedness 26720421.00 16520000.00 13 2 10 2 0.618254 0.1538 0.2000
Criminal justice reform 21682543.00 1828000.00 64 6 52 5 0.084307 0.0938 0.0962
Effective altruism 2167947.00 1125000.00 3 1 3 1 0.518924 0.3333 0.3333
Global catastrophic risks 10427960.00 2500000.00 8 1 8 1 0.239740 0.1250 0.1250
Land use reform 1449865.00 300000.00 8 1 8 1 0.206916 0.1250 0.1250
Neurobiology 2970000.00 2970000.00 1 1 1 1 1.000000 1.0000 1.0000
Organ donation 250000.00 200000.00 2 1 1 1 0.800000 0.5000 1.0000
View dump.tsv
donee amount donation_date focus_area disclosed
Forum for Climate Engineering Assessment 76234.00 2016-05-01 Global catastrophic risks 0
Solar Radiation Management Governance Initiative 500000.00 2015-07-01 Global catastrophic risks 0
University of Cape Town 493425.00 2016-09-01 Global catastrophic risks 0
Future of Life Institute 100000.00 2016-03-01 Global catastrophic risks 0
ClimateWorks Foundation 3000000.00 2017-03-01 Global catastrophic risks 0
Harvard University 2500000.00 2016-12-01 Global catastrophic risks 1
Rutgers University 2982206.00 2017-03-01 Global catastrophic risks 0
UCLA School of Law 776095.00 2017-04-01 Global catastrophic risks 0
Future of Life Institute 1186000.00 2015-08-01 AI risk 1
View gist:3bd6c82811c83031ccd96bd50ce30da9
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
View dump.tsv
focus_area amount disclosed amount numDonations disclosed numDonations numDonees disclosed numDonees
AI risk 43667297.00 36344525.00 10 6 10 6
Animal welfare 23314153.00 3464000.00 45 4 32 3
Biosecurity and pandemic preparedness 26720421.00 16520000.00 13 2 10 2
Criminal justice reform 21525543.00 1828000.00 62 6 50 5
Effective altruism 2167947.00 1125000.00 3 1 3 1
Global catastrophic risks 10427960.00 2500000.00 8 1 8 1
Land use reform 1199865.00 300000.00 7 1 7 1
Neurobiology 2970000.00 2970000.00 1 1 1 1
Organ donation 250000.00 200000.00 2 1 1 1
View gist:201d16ea8017419b67c5147d8607d8fc
mysql> select substring_index(cause_area,'/',1),sum(amount),count(*) as numDonations,count(distinct donations.donee) as numDonees from (select donor,donee,donation_url,donation_date from disclosures group by donor,donee,donation_url,donation_date) as d1 left join donations on d1.donation_url=donations.url and d1.donor=donations.donor and d1.donee=donations.donee and d1.donation_date=donations.donation_date group by substring_index(cause_area,'/',1);
+---------------------------------------+-------------+--------------+-----------+
| substring_index(cause_area,'/',1) | sum(amount) | numDonations | numDonees |
+---------------------------------------+-------------+--------------+-----------+
| AI risk | 36344525.00 | 6 | 6 |
| Animal welfare | 3464000.00 | 4 | 3 |
| Biosecurity and pandemic preparedness | 16520000.00 | 2 | 2 |
| Criminal justice reform | 1828000.00 | 6 |
View gist:e2eb73f5c641e0d140aeb9ed70a557ae
mysql> select donor_side_name,count(*),sum(amount) from disclosures left join donations on disclosures.donor=donations.donor and disclosures.donee=donations.donee and disclosures.donation_date=donations.donation_date group by donor_side_name order by sum(amount) desc;
+------------------+----------+-------------+
| donor_side_name | count(*) | sum(amount) |
+------------------+----------+-------------+
| Holden Karnofsky | 6 | 96244000.00 |
| Dario Amodei | 3 | 35940000.00 |
| Paul Christiano | 5 | 31804000.00 |
| Kevin Esvelt | 2 | 18020000.00 |
| Nick Beckstead | 13 | 16758525.00 |
| Jaime Yassif | 1 | 16000000.00 |
View gist:6304fa8ede9c591290e491daa5da36ed
mysql> select donor_side_name,count(*) from disclosures group by donor_side_name order by count(*) desc;
+------------------+----------+
| donor_side_name | count(*) |
+------------------+----------+
| NULL | 8 |
| Chloe Cockburn | 8 |
| Nick Beckstead | 7 |
| Lewis Bollard | 7 |
| Alexander Berger | 6 |
| Howie Lempel | 4 |
View dump.tsv
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 5 columns, instead of 3.
donor donee url donation_date count(*)
Laura and John Arnold Foundation Harvard University http://www.arnoldfoundation.org/grants/ 2016-01-01 9
Laura and John Arnold Foundation Harvard University http://www.arnoldfoundation.org/grants/ 2015-01-01 8
Laura and John Arnold Foundation University of Chicago http://www.arnoldfoundation.org/grants/ 2016-01-01 8
Bill and Melinda Gates Foundation Global Health Innovative Technology Fund https://iatiregistry.org/publisher/bmgf 2014-11-19 7
Bill and Melinda Gates Foundation International Vaccine Institute https://iatiregistry.org/publisher/bmgf 2012-05-08 7
Laura and John Arnold Foundation Johns Hopkins University http://www.arnoldfoundation.org/grants/ 2016-01-01 7
Bill and Melinda Gates Foundation RESULTS Educational Fund https://iatiregistry.org/publisher/bmgf 2014-11-11 6
Bill and Melinda Gates Foundation RESULTS Educational Fund https://iatiregistry.org/publisher/bmgf 2014-01-27 6
Laura and John Arnold Foundation New York University http://www.arnoldfoundation.org/
View gist:d8b20da4543e1234c99da8715e1e474b
mysql> select count(distinct donee) as numDonees from donations where influencer is not NULL and cause_area REGEXP "AI risk";
+-----------+
| numDonees |
+-----------+
| 3 |
+-----------+
1 row in set (0.01 sec)
mysql> select count(distinct donee) as numDonees from donations where influencer is NULL and cause_area REGEXP "AI risk";
+-----------+
View gist:c25add6320ce743e0ae32386347c9a6d
80000-hours-general-support
accountable-justice-project-general-support
aclu-nor-cal-prosecutorial-accountability
american-civil-liberties-union-foundation-oregon-prosecutorial-accountability
california-renters-legal-advocacy-and-education-fund-general-support
center-applied-rationality-general-support
center-applied-rationality-sparc
center-health-security-biosecurity-global-health-security-and-global-catastrophic
future-humanity-institute-general-support
future-life-institute-artificial-intelligence-risk-reduction