View gist:278bdf870fd667bc3f324d1ba656490c
Martin_Garrix 2004_Summer_Olympics link 99
other-search 2004_Summer_Olympics_national_flag_bearers external 174
other-empty 2004_Summer_Olympics_national_flag_bearers external 311
2016_Summer_Olympics_Parade_of_Nations 2004_Summer_Olympics_national_flag_bearers link 26
2004_Summer_Olympics_opening_ceremony 2004_Summer_Olympics_national_flag_bearers link 379
2000_Summer_Olympics_national_flag_bearers 2004_Summer_Olympics_national_flag_bearers link 43
2008_Summer_Olympics_Parade_of_Nations 2004_Summer_Olympics_national_flag_bearers link 45
Main_Page 2004_Summer_Olympics other 205
June_11 2004_Summer_Olympics other 28
other-external 2004_Summer_Paralympics external 115
View gist:bb129cff0cae8f0989928842bc5dfe63
mysql> select donor,donee,influencer from donations where influencer REGEXP ',';
| donor | donee | influencer |
| Open Philanthropy Project | Beth Israel Deaconess Medical Center | Chris Somerville,Heather Youngs |
| Open Philanthropy Project | Urban Institute | Luke Muehlhauser,Alexander Berger |
| Open Philanthropy Project | 80,000 Hours | Nick Beckstead,Nicole Ross
View Makefile
mysql $(MYSQL_ARGS) $(DATABASE) < sql/documents/documents-schema.sql
mysql $(MYSQL_ARGS) $(DATABASE) < sql/donations/donations-schema.sql
mysql $(MYSQL_ARGS) $(DATABASE) < sql/donees/donees-schema.sql
mysql $(MYSQL_ARGS) $(DATABASE) < sql/donors/donors-schema.sql
mysql $(MYSQL_ARGS) $(DATABASE) < sql/disclosures/disclosures-schema.sql
# mysql $(MYSQL_ARGS) $(DATABASE) < sql/disclosures/open-phil-disclosures.sql
mysql $(MYSQL_ARGS) $(DATABASE) < sql/documents/80k-docs.sql
mysql $(MYSQL_ARGS) $(DATABASE) < sql/documents/ace-docs.sql
mysql $(MYSQL_ARGS) $(DATABASE) < sql/documents/cea-docs.sql
View weights_network.gv
# License: CC0
# Output produced using `dot -Tpng -O weights_network.gv`
digraph G {
subgraph cluster_0 {
node [style=solid, color=blue4, shape=circle];
View simple_network.gv
# License: CC0
# Output produced using `dot -Tpng -O simple_network.gv`
digraph G {
subgraph cluster_0 {
node [style=solid, color=blue4, shape=circle];
#!/usr/bin/env python3
# Run this like: ls -1 | ./
import sys
ignored = [
#!/usr/bin/env python3
import sys
import pandas as pd
import matplotlib.pyplot as plt
calls = 0
data = []
with open(sys.argv[1], "r") as f:
for line in f:
View gist:54fb59943819395704e3d053b6c3d7e0
[Query_ID] => 10
[Duration] => 0.59338725
[Query] => select
case when influencer is NULL
then 'Unclassified'
else influencer
end as influencer,
count(distinct donee) as numDonees,

Thank you so much for your followup, Issa.

  • It's better listed as an organization than a project, please.
  • The launch date was June 2016. 0 FTEs, but 5 part-time volunteers thus far. It is headquartered in in the UK.
  • The initial co-founders include
    • Nell Watson – Evangelist
    • Anish Mohammed – CyberSecurity Strategist
    • Remco Bloemen – Algorithmic Engineer
    • Aleksandra Orchowska – Human Interfaces Specialist
  • Feel free to quote publicly, thank you.
View out.sql
('Adam Weissman','Machine Intelligence Research Institute',10000.0,'2015-01-17','year','donee contributor list','AI risk','',NULL,NULL,NULL,NULL)
('Alan Chang','Machine Intelligence Research Institute',18000.0,'2017-09-29','year','donee contributor list','AI risk','',NULL,NULL,NULL,NULL)
('Alan Chang','Machine Intelligence Research Institute',16050.0,'2018-01-17','year','donee contributor list','AI risk','',NULL,NULL,NULL,NULL)
('Aleksei Riikonen','Machine Intelligence Research Institute',14372.0,'2015-01-17','year','donee contributor list','AI risk','',NULL,NULL,NULL,NULL)
('Alex Edelman','Machine Intelligence Research Institute',5132.0,'2017-12-23','year','donee