Skip to content

Instantly share code, notes, and snippets.

@riceissa

riceissa/gist:e2eb73f5c641e0d140aeb9ed70a557ae

Last active August 11, 2017 05:36
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/e2eb73f5c641e0d140aeb9ed70a557ae to your computer and use it in GitHub Desktop.
Save riceissa/e2eb73f5c641e0d140aeb9ed70a557ae to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
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 |
| NULL | 10 | 7128000.00 |
| Daniel Dewey | 4 | 5158525.00 |
| Luke Muehlhauser | 6 | 4364000.00 |
| Lewis Bollard | 7 | 3464000.00 |
| Carl Shulman | 2 | 3029000.00 |
| Adam Marblestone | 1 | 2970000.00 |
| Claire Zabel | 1 | 2500000.00 |
| Chris Olah | 1 | 2400000.00 |
| Helen Toner | 3 | 1990000.00 |
| Alexander Berger | 7 | 1500000.00 |
| Chloe Cockburn | 8 | 1345000.00 |
| Jacob Steinhardt | 3 | 1304000.00 |
| Ben Hoffman | 1 | 1186000.00 |
| Howie Lempel | 4 | 800000.00 |
+------------------+----------+-------------+
20 rows in set (0.16 sec)
Raw
gistfile2.txt
mysql> select donor_side_name,amount from disclosures left join donations on disclosures.donor=donations.donor and disclosures.donee=donations.donee and disclosures.donation_date=donations.donation_date where donor_side_name='Holden Karnofsky';
+------------------+-------------+
| donor_side_name | amount |
+------------------+-------------+
| Holden Karnofsky | 30000000.00 |
| Holden Karnofsky | 30000000.00 |
| Holden Karnofsky | 30000000.00 |
| Holden Karnofsky | 2970000.00 |
| Holden Karnofsky | 2970000.00 |
| Holden Karnofsky | 304000.00 |
+------------------+-------------+
6 rows in set (0.02 sec)
Raw
gistfile3.txt
mysql> select d1.donor_side_name,count(*),sum(amount) from (select distinct donor_side_name, donor, donee, url, donation_date from disclosures) as d1 left join donations on d1.donor=donations.donor and d1.donee=donations.donee and d1.donation_date=donations.donation_date group by d1.donor_side_name order by sum(amount) desc;
+------------------+----------+-------------+
| donor_side_name | count(*) | sum(amount) |
+------------------+----------+-------------+
| Holden Karnofsky | 3 | 33274000.00 |
| Dario Amodei | 2 | 32970000.00 |
| Paul Christiano | 3 | 30804000.00 |
| Kevin Esvelt | 2 | 18020000.00 |
| Jaime Yassif | 1 | 16000000.00 |
| Nick Beckstead | 7 | 7218525.00 |
| Daniel Dewey | 4 | 5158525.00 |
| Carl Shulman | 2 | 3029000.00 |
| Luke Muehlhauser | 4 | 3025000.00 |
| Adam Marblestone | 1 | 2970000.00 |
| Lewis Bollard | 4 | 2964000.00 |
| NULL | 4 | 2721000.00 |
| Claire Zabel | 1 | 2500000.00 |
| Chris Olah | 1 | 2400000.00 |
| Helen Toner | 3 | 1990000.00 |
| Ben Hoffman | 1 | 1186000.00 |
| Chloe Cockburn | 6 | 1045000.00 |
| Jacob Steinhardt | 2 | 804000.00 |
| Alexander Berger | 2 | 500000.00 |
| Howie Lempel | 1 | 200000.00 |
+------------------+----------+-------------+
20 rows in set (0.11 sec)
Raw
gistfile4.txt
mysql> select d1.donor_side_name,year(donations.donation_date),count(*),sum(amount) from (select distinct donor_side_name, donor, donee, donation_url, donation_date from disclosures) as d1 left join donations on d1.donor=donations.donor and d1.donee=donations.donee and d1.donation_date=donations.donation_date and d1.donation_url=donations.url group by d1.donor_side_name,year(donations.donation_date) order by sum(amount) desc;
+------------------+-------------------------------+----------+-------------+
| donor_side_name | year(donations.donation_date) | count(*) | sum(amount) |
+------------------+-------------------------------+----------+-------------+
| Holden Karnofsky | 2017 | 1 | 30000000.00 |
| Dario Amodei | 2017 | 1 | 30000000.00 |
| Paul Christiano | 2017 | 1 | 30000000.00 |
| Kevin Esvelt | 2017 | 1 | 17500000.00 |
| Jaime Yassif | 2017 | 1 | 16000000.00 |
| Daniel Dewey | 2017 | 2 | 4394000.00 |
| Nick Beckstead | 2016 | 4 | 4038525.00 |
| Holden Karnofsky | 2016 | 2 | 3274000.00 |
| Adam Marblestone | 2016 | 1 | 2970000.00 |
| Dario Amodei | 2016 | 1 | 2970000.00 |
| Claire Zabel | 2016 | 1 | 2500000.00 |
| Lewis Bollard | 2017 | 2 | 2464000.00 |
| Chris Olah | 2017 | 1 | 2400000.00 |
| Carl Shulman | 2017 | 1 | 1994000.00 |
| Nick Beckstead | 2017 | 1 | 1994000.00 |
| Luke Muehlhauser | 2016 | 3 | 1839000.00 |
| NULL | 2016 | 2 | 1535000.00 |
| Ben Hoffman | 2015 | 1 | 1186000.00 |
| Nick Beckstead | 2015 | 1 | 1186000.00 |
| Luke Muehlhauser | 2015 | 1 | 1186000.00 |
| NULL | 2015 | 1 | 1186000.00 |
| Helen Toner | 2015 | 1 | 1186000.00 |
| Carl Shulman | 2016 | 1 | 1035000.00 |
| Jacob Steinhardt | 2016 | 2 | 804000.00 |
| Helen Toner | 2016 | 2 | 804000.00 |
| Paul Christiano | 2016 | 2 | 804000.00 |
| Daniel Dewey | 2016 | 2 | 764525.00 |
| Chloe Cockburn | 2016 | 3 | 650000.00 |
| Kevin Esvelt | 2016 | 1 | 520000.00 |
| Lewis Bollard | 2016 | 1 | 500000.00 |
| Chloe Cockburn | 2017 | 2 | 395000.00 |
| Alexander Berger | 2016 | 1 | 300000.00 |
| Alexander Berger | 2015 | 1 | 200000.00 |
| Howie Lempel | 2015 | 1 | 200000.00 |
| Chloe Cockburn | NULL | 1 | NULL |
| Lewis Bollard | NULL | 1 | NULL |
| Nick Beckstead | NULL | 1 | NULL |
| NULL | NULL | 1 | NULL |
+------------------+-------------------------------+----------+-------------+
38 rows in set (0.19 sec)
Raw
gistfile5.txt
mysql> select donation_date from disclosures;
+---------------+
| donation_date |
+---------------+
| 2017-03-01 |
| 2017-03-01 |
| 2017-03-01 |
| 2016-04-01 |
| 2017-03-01 |
| 2017-02-01 |
| 2016-06-01 |
| 2016-07-01 |
| 2016-07-01 |
| 2016-07-01 |
| 2016-07-01 |
| 2016-07-01 |
| 2016-05-01 |
| 2016-05-01 |
| 2016-05-01 |
| 2016-05-01 |
| 2016-05-01 |
| 2016-05-01 |
| 2016-05-01 |
| 2017-03-01 |
| 2017-03-01 |
| 2017-03-01 |
| 2017-03-01 |
| 2017-03-01 |
| 2017-03-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2016-06-01 |
| 2016-06-01 |
| 2016-04-01 |
| 2016-04-01 |
| 2016-12-01 |
| 2016-07-01 |
| 2017-03-01 |
| 2017-05-01 |
| 2016-02-01 |
| 2016-02-01 |
| 2016-02-01 |
| 2016-05-01 |
| 2017-01-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-08-01 |
| 2016-03-01 |
| 2016-03-01 |
| 2016-03-01 |
| 2016-03-01 |
| 2016-03-01 |
| 2016-03-01 |
| 2017-07-01 |
| 2017-07-01 |
| 2017-03-01 |
| 2017-03-01 |
| 2017-03-01 |
| 2017-03-01 |
| 2017-03-01 |
| 2017-05-01 |
| 2016-02-01 |
| 2016-02-01 |
| 2016-07-01 |
| 2016-07-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
| 2015-08-01 |
+---------------+
88 rows in set (0.00 sec)
Raw
gistfile6.txt
mysql> select d1.donor_side_name,year(d1.donation_date),count(*),sum(amount) from (select distinct donor_side_name, donor, donee, donation_url, donation_date from disclosures) as d1 left join donations on d1.donor=donations.donor and d1.donee=donations.donee and d1.donation_date=donations.donation_date and d1.donation_url=donations.url group by d1.donor_side_name,year(d1.donation_date) order by sum(amount) desc;
+------------------+------------------------+----------+-------------+
| donor_side_name | year(d1.donation_date) | count(*) | sum(amount) |
+------------------+------------------------+----------+-------------+
| Holden Karnofsky | 2017 | 1 | 30000000.00 |
| Dario Amodei | 2017 | 1 | 30000000.00 |
| Paul Christiano | 2017 | 1 | 30000000.00 |
| Kevin Esvelt | 2017 | 1 | 17500000.00 |
| Jaime Yassif | 2017 | 1 | 16000000.00 |
| Daniel Dewey | 2017 | 2 | 4394000.00 |
| Nick Beckstead | 2016 | 4 | 4038525.00 |
| Holden Karnofsky | 2016 | 2 | 3274000.00 |
| Adam Marblestone | 2016 | 1 | 2970000.00 |
| Dario Amodei | 2016 | 1 | 2970000.00 |
| Claire Zabel | 2016 | 1 | 2500000.00 |
| Lewis Bollard | 2017 | 2 | 2464000.00 |
| Chris Olah | 2017 | 1 | 2400000.00 |
| Carl Shulman | 2017 | 1 | 1994000.00 |
| Nick Beckstead | 2017 | 2 | 1994000.00 |
| Luke Muehlhauser | 2016 | 3 | 1839000.00 |
| NULL | 2016 | 2 | 1535000.00 |
| Ben Hoffman | 2015 | 1 | 1186000.00 |
| Nick Beckstead | 2015 | 1 | 1186000.00 |
| Luke Muehlhauser | 2015 | 1 | 1186000.00 |
| NULL | 2015 | 1 | 1186000.00 |
| Helen Toner | 2015 | 1 | 1186000.00 |
| Carl Shulman | 2016 | 1 | 1035000.00 |
| Jacob Steinhardt | 2016 | 2 | 804000.00 |
| Helen Toner | 2016 | 2 | 804000.00 |
| Paul Christiano | 2016 | 2 | 804000.00 |
| Daniel Dewey | 2016 | 2 | 764525.00 |
| Chloe Cockburn | 2016 | 4 | 650000.00 |
| Kevin Esvelt | 2016 | 1 | 520000.00 |
| Lewis Bollard | 2016 | 2 | 500000.00 |
| Chloe Cockburn | 2017 | 2 | 395000.00 |
| Alexander Berger | 2016 | 1 | 300000.00 |
| Alexander Berger | 2015 | 1 | 200000.00 |
| Howie Lempel | 2015 | 1 | 200000.00 |
| NULL | 2017 | 1 | NULL |
+------------------+------------------------+----------+-------------+
35 rows in set (0.18 sec)
Raw
gistfile7.txt
mysql> select d1.donor_side_name,year(d1.donation_date),donations.donation_date,donations.url,amount from (select distinct donor_side_name, donor, donee, donation_url, donation_date from disclosures) as d1 left join donations on d1.donor=donations.donor and d1.donee=donations.donee and d1.donation_date=donations.donation_date and d1.donation_url=donations.url;
+------------------+------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+
| donor_side_name | year(d1.donation_date) | donation_date | url | amount |
+------------------+------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+
| Claire Zabel | 2016 | 2016-12-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/miscellaneous/harvard-university-solar-geoengineering-research-program | 2500000.00 |
| Nick Beckstead | 2015 | 2015-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/future-life-institute-artificial-intelligence-risk-reduction | 1186000.00 |
| NULL | 2015 | 2015-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/future-life-institute-artificial-intelligence-risk-reduction | 1186000.00 |
| Helen Toner | 2015 | 2015-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/future-life-institute-artificial-intelligence-risk-reduction | 1186000.00 |
| Ben Hoffman | 2015 | 2015-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/future-life-institute-artificial-intelligence-risk-reduction | 1186000.00 |
| Luke Muehlhauser | 2015 | 2015-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/future-life-institute-artificial-intelligence-risk-reduction | 1186000.00 |
| Paul Christiano | 2016 | 2016-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/machine-intelligence-research-institute-general-support | 500000.00 |
| Jacob Steinhardt | 2016 | 2016-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/machine-intelligence-research-institute-general-support | 500000.00 |
| Nick Beckstead | 2016 | 2016-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/machine-intelligence-research-institute-general-support | 500000.00 |
| Daniel Dewey | 2016 | 2016-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/machine-intelligence-research-institute-general-support | 500000.00 |
| Luke Muehlhauser | 2016 | 2016-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/machine-intelligence-research-institute-general-support | 500000.00 |
| Helen Toner | 2016 | 2016-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/machine-intelligence-research-institute-general-support | 500000.00 |
| NULL | 2016 | 2016-08-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/machine-intelligence-research-institute-general-support | 500000.00 |
| Nick Beckstead | 2016 | 2016-06-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/george-mason-university-research-future-artificial-intelligence-scenarios | 264525.00 |
| Daniel Dewey | 2016 | 2016-06-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/george-mason-university-research-future-artificial-intelligence-scenarios | 264525.00 |
| Nick Beckstead | 2017 | 2017-03-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/future-humanity-institute-general-support | 1994000.00 |
| Daniel Dewey | 2017 | 2017-03-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/future-humanity-institute-general-support | 1994000.00 |
| Carl Shulman | 2017 | 2017-03-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/future-humanity-institute-general-support | 1994000.00 |
| Dario Amodei | 2017 | 2017-03-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/openai-general-support | 30000000.00 |
| Paul Christiano | 2017 | 2017-03-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/openai-general-support | 30000000.00 |
| Holden Karnofsky | 2017 | 2017-03-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/openai-general-support | 30000000.00 |
| Chris Olah | 2017 | 2017-07-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/montreal-institute-learning-algorithms-ai-safety-research | 2400000.00 |
| Daniel Dewey | 2017 | 2017-07-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/potential-risks-advanced-artificial-intelligence/montreal-institute-learning-algorithms-ai-safety-research | 2400000.00 |
| Lewis Bollard | 2016 | 2016-04-01 | http://www.openphilanthropy.org/focus/us-policy/farm-animal-welfare/global-animal-partnership-general-support | 500000.00 |
| Lewis Bollard | 2017 | 2017-03-01 | http://www.openphilanthropy.org/focus/us-policy/farm-animal-welfare/humane-society-international-east-asian-and-oie-projects | 1364000.00 |
| Lewis Bollard | 2017 | 2017-05-01 | http://www.openphilanthropy.org/focus/us-policy/farm-animal-welfare/humane-society-international-india-animal-welfare-reform | 1100000.00 |
| Jaime Yassif | 2017 | 2017-01-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/biosecurity/center-health-security-biosecurity-global-health-security-and-global-catastrophic | 16000000.00 |
| Kevin Esvelt | 2016 | 2016-05-01 | http://www.openphilanthropy.org/focus/global-catastrophic-risks/biosecurity/igem-synthetic-biology-safety-and-security | 520000.00 |
| Chloe Cockburn | 2016 | 2016-04-01 | http://www.openphilanthropy.org/focus/us-policy/criminal-justice-reform/accountable-justice-project-general-support | 350000.00 |
| Chloe Cockburn | 2016 | 2016-07-01 | http://www.openphilanthropy.org/focus/us-policy/criminal-justice-reform/vera-institute-justice-new-orleans-user-funded-justice-system | 100000.00 |
| Chloe Cockburn | 2016 | 2016-02-01 | http://www.openphilanthropy.org/focus/us-policy/criminal-justice-reform/vera-institute-justice-common-justice | 200000.00 |
| Chloe Cockburn | 2017 | 2017-02-01 | http://www.openphilanthropy.org/focus/us-policy/criminal-justice-reform/aclu-nor-cal-prosecutorial-accountability | 250000.00 |
| Chloe Cockburn | 2017 | 2017-03-01 | http://www.openphilanthropy.org/focus/us-policy/criminal-justice-reform/american-civil-liberties-union-foundation-oregon-prosecutorial-accountability | 145000.00 |
| Alexander Berger | 2016 | 2016-06-01 | http://www.openphilanthropy.org/focus/us-policy/land-use-reform/california-renters-legal-advocacy-and-education-fund-general-support | 300000.00 |
| Kevin Esvelt | 2017 | 2017-05-01 | http://www.openphilanthropy.org/focus/scientific-research/miscellaneous/target-malaria-general-support | 17500000.00 |
| Dario Amodei | 2016 | 2016-03-01 | http://www.openphilanthropy.org/focus/scientific-research/miscellaneous/massachusetts-institute-technology-synthetic-neurobiology-group | 2970000.00 |
| Adam Marblestone | 2016 | 2016-03-01 | http://www.openphilanthropy.org/focus/scientific-research/miscellaneous/massachusetts-institute-technology-synthetic-neurobiology-group | 2970000.00 |
| Holden Karnofsky | 2016 | 2016-03-01 | http://www.openphilanthropy.org/focus/scientific-research/miscellaneous/massachusetts-institute-technology-synthetic-neurobiology-group | 2970000.00 |
| Nick Beckstead | 2016 | 2016-03-01 | http://www.openphilanthropy.org/focus/scientific-research/miscellaneous/massachusetts-institute-technology-synthetic-neurobiology-group | 2970000.00 |
| Jacob Steinhardt | 2016 | 2016-05-01 | http://www.openphilanthropy.org/giving/grants/center-applied-rationality-sparc | 304000.00 |
| Paul Christiano | 2016 | 2016-05-01 | http://www.openphilanthropy.org/giving/grants/center-applied-rationality-sparc | 304000.00 |
| Nick Beckstead | 2016 | 2016-05-01 | http://www.openphilanthropy.org/giving/grants/center-applied-rationality-sparc | 304000.00 |
| Holden Karnofsky | 2016 | 2016-05-01 | http://www.openphilanthropy.org/giving/grants/center-applied-rationality-sparc | 304000.00 |
| Luke Muehlhauser | 2016 | 2016-05-01 | http://www.openphilanthropy.org/giving/grants/center-applied-rationality-sparc | 304000.00 |
| Helen Toner | 2016 | 2016-05-01 | http://www.openphilanthropy.org/giving/grants/center-applied-rationality-sparc | 304000.00 |
| Luke Muehlhauser | 2016 | 2016-07-01 | http://www.openphilanthropy.org/giving/grants/center-applied-rationality-general-support | 1035000.00 |
| NULL | 2016 | 2016-07-01 | http://www.openphilanthropy.org/giving/grants/center-applied-rationality-general-support | 1035000.00 |
| Carl Shulman | 2016 | 2016-07-01 | http://www.openphilanthropy.org/giving/grants/center-applied-rationality-general-support | 1035000.00 |
| Alexander Berger | 2015 | 2015-08-01 | http://www.openphilanthropy.org/focus/us-policy/miscellaneous/waitlist-zero-general-support | 200000.00 |
| Howie Lempel | 2015 | 2015-08-01 | http://www.openphilanthropy.org/focus/us-policy/miscellaneous/waitlist-zero-general-support | 200000.00 |
| Nick Beckstead | 2017 | NULL | NULL | NULL |
| NULL | 2017 | NULL | NULL | NULL |
| Chloe Cockburn | 2016 | NULL | NULL | NULL |
| Lewis Bollard | 2016 | NULL | NULL | NULL |
+------------------+------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+
54 rows in set (0.18 sec)
Raw
gistfile8.txt
mysql> select d1.donor_side_name,year(d1.donation_date),donations.donation_date,d1.donation_url,d1.donation_date,amount from (select distinct donor_side_name, donor, donee, donation_url, donation_date from disclosures) as d1 left join donations on d1.donor=donations.donor and d1.donee=donations.donee and d1.donation_date=donations.donation_date and d1.donation_url=donations.url where donations.donation_date is NULL;
+-----------------+------------------------+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+--------+
| donor_side_name | year(d1.donation_date) | donation_date | donation_url | donation_date | amount |
+-----------------+------------------------+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+--------+
| Nick Beckstead | 2017 | NULL | http://www.openphilanthropy.org/giving/grants/80000-hours-general-support | 2017-03-01 | NULL |
| NULL | 2017 | NULL | http://www.openphilanthropy.org/giving/grants/80000-hours-general-support | 2017-03-01 | NULL |
| Chloe Cockburn | 2016 | NULL | http://www.openphilanthropy.org/focus/us-policy/criminal-justice-reform/harvard-university-program-criminal-justice-policy-and-management | 2016-07-01 | NULL |
| Lewis Bollard | 2016 | NULL | http://www.openphilanthropy.org/focus/us-policy/farm-animal-welfare/humane-society-united-states-corporate-cage-free-campaigns | 2016-02-01 | NULL |
+-----------------+------------------------+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+--------+
4 rows in set (0.17 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment