Skip to content

Instantly share code, notes, and snippets.

@riceissa

riceissa/gist:735a0e50f802c16b2e700395e15be415

Created July 27, 2018 04:34
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/735a0e50f802c16b2e700395e15be415 to your computer and use it in GitHub Desktop.
Save riceissa/735a0e50f802c16b2e700395e15be415 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> select person,group_concat(organization) from aiwatch.positions where organization in (select distinct(donee) from donations where donor='Open Philanthropy Project') and person in (select distinct(donor) from donations where donee='Machine
Intelligence Research Institute') group by person;
+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| person | group_concat(organization) |
+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Andrew Hay | Machine Intelligence Research Institute |
| Ben Hoskin | Machine Intelligence Research Institute |
| Blake Borgeson | Machine Intelligence Research Institute |
| Buck Shlegeris | Machine Intelligence Research Institute |
| Edwin Evans | Machine Intelligence Research Institute |
| Eric Rogstad | Center for Applied Rationality |
| Frank Adamek | Machine Intelligence Research Institute |
| Henrik Jonsson | Machine Intelligence Research Institute,Machine Intelligence Research Institute |
| Jaan Tallinn | Berkeley Existential Risk Initiative,Future of Life Institute,Machine Intelligence Research Institute |
| Janos Kramar | Machine Intelligence Research Institute,Future of Life Institute |
| Jed McCaleb | Machine Intelligence Research Institute |
| Jeremy Schlatter | Machine Intelligence Research Institute,Berkeley Existential Risk Initiative,OpenAI |
| Jesse Liptrap | Machine Intelligence Research Institute |
| John Salvatier | AI Impacts,Future of Humanity Institute |
| Joshua Fox | Machine Intelligence Research Institute |
| JP Addison | Centre for Effective Altruism |
| Kevin Fischer | Machine Intelligence Research Institute,Machine Intelligence Research Institute |
| Liron Shapira | Machine Intelligence Research Institute,Machine Intelligence Research Institute |
| Louie Helm | Machine Intelligence Research Institute,Machine Intelligence Research Institute,Machine Intelligence Research Institute |
| Marcello Herreshoff | Machine Intelligence Research Institute,Machine Intelligence Research Institute,Machine Intelligence Research Institute,Machine Intelligence Research Institute,Machine Intelligence Research Institute |
| Max Kesin | Future of Life Institute |
| Michael Blume | Machine Intelligence Research Institute |
| Mihaly Barasz | Machine Intelligence Research Institute |
| Pablo Stafforini | Centre for Effective Altruism,Centre for Effective Altruism,Centre for Effective Altruism |
| Patrick LaVictoire | Machine Intelligence Research Institute,Machine Intelligence Research Institute |
| Paul Christiano | University of California, Berkeley,AI Impacts,OpenAI,Future of Humanity Institute,OpenAI,Machine Intelligence Research Institute |
| Peter Hurford | Animal Charity Evaluators,Animal Charity Evaluators |
| Ryan Carey | Machine Intelligence Research Institute,Future of Humanity Institute |
| Sam Eisenstat | Machine Intelligence Research Institute |
| Stephanie Zolayvar | Center for Applied Rationality,AI Impacts |
| Tomer Kagan | Machine Intelligence Research Institute |
| Victoria Krakovna | Future of Life Institute |
+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
32 rows in set (0.16 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment