EA - EffectiveAltruismData.com is now a spreadsheet by Hamish Doodles

<a href="https://forum.effectivealtruism.org/posts/pwPbQPv8EL9piJRfa/effectivealtruismdata-com-is-now-a-spreadsheet">Link to original article</a><br/><br/>Welcome to The Nonlinear Library, where we use Text-to-Speech software to convert the best writing from the Rationalist and EA communities into audio. This is: EffectiveAltruismData.com is now a spreadsheet, published by Hamish Doodles on July 23, 2023 on The Effective Altruism Forum. A few years ago I built EffectiveAltruismData.com which looked like this: A few people told me they liked the web app. Some even said they found it useful, especially the bits that made the funding landscape more legible. But anyway, I never got around to automating the data scraping, and the website ended up hopelessly out of date. So I killed it. But it recently occurred to me that I could do the data scraping, data aggregation, and data visualisation, all within Google Sheets. So with a bit of help from Chatty G, I put together a spreadsheet which: Downloads the latest grant data from the Open Philanthropy website every 24 hours (via Google Apps Scripts). Aggregate funding by cause area Aggregate funding by organization. Visualise all grant data in a pivot table that lets you expand/aggregate by Cause Area, then Organization Name, then individual grants But note that expanding/collapsing counts as editing the spreadsheet, so you'll have to make a copy to be able to do this. You can also change the scale of the bar chart using the dropdown And you can sort grants by size or by date using the "Sort Sheet Z to A" option on the Amount or Date columns. Here's a link to the spreadsheet. You can also find it at www.effectivealtruismdata.com. Other funding legibility projects Here's another thing I made. It gives time series and cumulative bar charts for funding based on funder and cause area. You can hover over points on the time series to get the total funding per cause/org per year. The data comes from this spreadsheet by TylerMaule. Another thing which may be of interest is openbook.fyi by Rachel Weinberg & Austin Chen, which let's you search/view individual grants from a range of EA-flavoured sources. Openbook gets its data from donations.vipulnaik.com/ by Vipul Naik. I'm currently working on another spreadsheet which scrapes, aggregates, and visualises all the Vipul Naiks's data. Feedback & Requests I enjoy working on spreadsheets and data viz and stuff. Let me know if you can think of any other stuff in this area which would be useful. This is a joke. This is also a joke. Thanks for listening. To help us out with The Nonlinear Library or to learn more, please visit nonlinear.org

First published

07/23/2023

Genres:

education

Listen to this episode

0:00 / 0:00

Summary

Link to original articleWelcome to The Nonlinear Library, where we use Text-to-Speech software to convert the best writing from the Rationalist and EA communities into audio. This is: EffectiveAltruismData.com is now a spreadsheet, published by Hamish Doodles on July 23, 2023 on The Effective Altruism Forum. A few years ago I built EffectiveAltruismData.com which looked like this: A few people told me they liked the web app. Some even said they found it useful, especially the bits that made the funding landscape more legible. But anyway, I never got around to automating the data scraping, and the website ended up hopelessly out of date. So I killed it. But it recently occurred to me that I could do the data scraping, data aggregation, and data visualisation, all within Google Sheets. So with a bit of help from Chatty G, I put together a spreadsheet which: Downloads the latest grant data from the Open Philanthropy website every 24 hours (via Google Apps Scripts). Aggregate funding by cause area Aggregate funding by organization. Visualise all grant data in a pivot table that lets you expand/aggregate by Cause Area, then Organization Name, then individual grants But note that expanding/collapsing counts as editing the spreadsheet, so you'll have to make a copy to be able to do this. You can also change the scale of the bar chart using the dropdown And you can sort grants by size or by date using the "Sort Sheet Z to A" option on the Amount or Date columns. Here's a link to the spreadsheet. You can also find it at www.effectivealtruismdata.com. Other funding legibility projects Here's another thing I made. It gives time series and cumulative bar charts for funding based on funder and cause area. You can hover over points on the time series to get the total funding per cause/org per year. The data comes from this spreadsheet by TylerMaule. Another thing which may be of interest is openbook.fyi by Rachel Weinberg & Austin Chen, which let's you search/view individual grants from a range of EA-flavoured sources. Openbook gets its data from donations.vipulnaik.com/ by Vipul Naik. I'm currently working on another spreadsheet which scrapes, aggregates, and visualises all the Vipul Naiks's data. Feedback & Requests I enjoy working on spreadsheets and data viz and stuff. Let me know if you can think of any other stuff in this area which would be useful. This is a joke. This is also a joke. Thanks for listening. To help us out with The Nonlinear Library or to learn more, please visit nonlinear.org

Duration

2 hours and 23 minutes

Parent Podcast

The Nonlinear Library: EA Forum Daily

View Podcast

Share this episode

Similar Episodes

AMA: Paul Christiano, alignment researcher by Paul Christiano

Release Date: 12/06/2021

Description: Welcome to The Nonlinear Library, where we use Text-to-Speech software to convert the best writing from the Rationalist and EA communities into audio. This is: AMA: Paul Christiano, alignment researcher, published by Paul Christiano on the AI Alignment Forum. I'll be running an Ask Me Anything on this post from Friday (April 30) to Saturday (May 1). If you want to ask something just post a top-level comment; I'll spend at least a day answering questions. You can find some background about me here. Thanks for listening. To help us out with The Nonlinear Library or to learn more, please visit nonlinear.org.

Explicit: No

Details

AI alignment landscape by Paul Christiano

Release Date: 11/19/2021

Description: Welcome to The Nonlinear Library, where we use Text-to-Speech software to convert the best writing from the Rationalist and EA communities into audio. This is: AI alignment landscape, published byPaul Christiano on the AI Alignment Forum. Here (link) is a talk I gave at EA Global 2019, where I describe how intent alignment fits into the broader landscape of “making AI go well,” and how my work fits into intent alignment. This is particularly helpful if you want to understand what I’m doing, but may also be useful more broadly. I often find myself wishing people were clearer about some of these distinctions. Here is the main overview slide from the talk: The highlighted boxes are where I spend most of my time. Here are the full slides from the talk. Thanks for listening. To help us out with The Nonlinear Library or to learn more, please visit nonlinear.org.

Explicit: No

Details

AMA on EA Forum: Ajeya Cotra, researcher at Open Phil by Ajeya Cotra

Release Date: 11/17/2021

Description: Welcome to The Nonlinear Library, where we use Text-to-Speech software to convert the best writing from the Rationalist and EA communities into audio. This is: AMA on EA Forum: Ajeya Cotra, researcher at Open Phil, published by Ajeya Cotra on the AI Alignment Forum. This is a linkpost for Hi all, I'm Ajeya, and I'll be doing an AMA on the EA Forum (this is a linkpost for my announcement there). I would love to get questions from LessWrong and Alignment Forum users as well -- please head on over if you have any questions for me! I’ll plan to start answering questions Monday Feb 1 at 10 AM Pacific. I will be blocking off much of Monday and Tuesday for question-answering, and may continue to answer a few more questions through the week if there are ones left, though I might not get to everything. About me: I’m a Senior Research Analyst at Open Philanthropy, where I focus on cause prioritization and AI. 80,000 Hours released a podcast episode with me last week discussing some of my work, and last September I put out a draft report on AI timelines which is discussed in the podcast. Currently, I’m trying to think about AI threat models and how much x-risk reduction we could expect the “last long-termist dollar” to buy. I joined Open Phil in the summer of 2016, and before that I was a student at UC Berkeley, where I studied computer science, co-ran the Effective Altruists of Berkeley student group, and taught a student-run course on EA. I’m most excited about answering questions related to AI timelines, AI risk more broadly, and cause prioritization, but feel free to ask me anything! Thanks for listening. To help us out with The Nonlinear Library or to learn more, please visit nonlinear.org.

Explicit: No

Details

What is the alternative to intent alignment called? Q by Richard Ngo

Release Date: 11/17/2021

Description: Welcome to The Nonlinear Library, where we use Text-to-Speech software to convert the best writing from the Rationalist and EA communities into audio. This is: What is the alternative to intent alignment called? Q, published by Richard Ngo on the AI Alignment Forum. Paul defines intent alignment of an AI A to a human H as the criterion that A is trying to do what H wants it to do. What term do people use for the definition of alignment in which A is trying to achieve H's goals (whether or not H intends for A to achieve H's goals)? Secondly, this seems to basically map on to the distinction between an aligned genie and an aligned sovereign. Is this a fair characterisation? (Intent alignment definition from) Thanks for listening. To help us out with The Nonlinear Library or to learn more, please visit nonlinear.org.

Explicit: No

Details