> For the complete documentation index, see [llms.txt](https://makerdao.daogov.info/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://makerdao.daogov.info/further-reading-and-resources/learning-resources.md).

# Data on MakerDAO

### Data Sources

<table data-view="cards"><thead><tr><th>Source</th><th>Description</th><th>Links</th><th>Screenshot</th></tr></thead><tbody><tr><td><strong>MakerDAO Governance Tracker</strong></td><td><ul><li><strong>CSV exports</strong> available on the tracker's website</li><li>Comprehensive API endpoints </li></ul></td><td><ul><li><a href="https://tracker-gov.makerdao.network/">Web version</a></li><li><a href="https://data-api.makerdao.network/docs#/">API doc </a></li></ul></td><td><img src="/files/azeOYOMHul8C2f6ZqbAA" alt=""></td></tr><tr><td><strong>Maker Burn</strong></td><td>Rundown of collaterals and other financial information (e.g., expenses, treasury) via a nice web interface</td><td><ul><li><a href="https://makerburn.com/#/rundown">Web version</a></li></ul></td><td><img src="/files/KF4OFVjhO1RLU4PzCPPx" alt=""></td></tr><tr><td><strong>Maker Governance Portal</strong></td><td><ul><li>Website with <strong>great UI to explore</strong> information on proposals and delegates</li><li>Limited API endpoints covering key governance metrics </li></ul></td><td><ul><li><p><a href="https://vote.makerdao.com/">Web version</a> </p><ul><li><a href="https://vote.makerdao.com/polling">Polls (i.e., proposals)</a></li><li><a href="https://vote.makerdao.com/delegates">Delegates</a></li></ul></li><li><a href="https://vote.makerdao.com/api-docs">API doc</a></li></ul></td><td><img src="/files/dKFKthmedHY2H7W4Pyik" alt=""></td></tr><tr><td><strong>Dune Analytics</strong></td><td><ul><li>Crowdsourced, customizable dashboards that retrieve and visualize data on blockchains.</li><li>Provides powerful analysis with <strong>simple SQL queries</strong></li></ul></td><td><ul><li><a href="https://dune.com/SebVentures/maker---accounting_1">MakerDAO - Dashboard</a> by @SebVentures</li></ul></td><td><img src="/files/WWvivbfKveUxPIvuR3pG" alt=""></td></tr><tr><td><strong>Crypto Data Aggregators</strong></td><td><p>Data aggregators can provide data on: </p><ul><li>distribution of tokens</li><li>transaction fees on the Ethereum blockchain</li><li><strong>costs of borrowing governance tokens</strong></li></ul></td><td><ul><li><p><a href="https://www.coingecko.com/">CoinGecko</a></p><ul><li><a href="https://www.coingecko.com/en/coins/maker/tokenomics">Tokenomics of MKR</a></li><li><a href="https://www.coingecko.com/en/api/documentation">API Doc</a></li></ul></li><li><p><a href="https://etherscan.io/">Etherscan</a></p><ul><li><a href="https://etherscan.io/charts">Ethereum Charts &#x26; Statistics</a></li><li><a href="https://docs.etherscan.io/">API Doc</a></li></ul></li></ul></td><td><img src="/files/cl5hn5LWTAdA4w7vd63y" alt=""></td></tr></tbody></table>

### API and Scripts&#x20;

#### API Tool

* [RapidAPI](https://paw.cloud/) - Mac
  * Returns data in JSON format
* RStudio - Mac and Windows&#x20;
  * Require transforming of openapi.json files into R scripts, can be quickly done via ChatGPT (sample script available below)
  * Easier manipulation of return data (e.g., parse json data into table formats)
  * openapi.json files are available to download via API webpages and the Open API json files tab below

{% hint style="info" %}
First, try out the API endpoints using web interface or API tools such as RapidAPI.

Then, write R scripts to access specific API endpoints, retrieve data of interest, and parse them into table formats (e.g., csv, xlxs).
{% endhint %}

#### Scripts

{% tabs %}
{% tab title="Open API json files" %}

### MCD Governance Tracker

{% file src="/files/uHHHVIqu5M1n4iWcBenC" %}
More information available at <https://data-api.makerdao.network/docs>
{% endfile %}

### Maker Governance Portal

{% file src="/files/8q0i430445uun2QJD8h9" %}
More information available at <https://vote.makerdao.com/api-docs>
{% endfile %}
{% endtab %}

{% tab title="Example R script: API for Maker Governance Portal" %}

### API for Maker Governance Portal (transformed by ChatGPT)&#x20;

* Note: This script is based on V1, while the V2 has been implemented at <https://vote.makerdao.com/api-docs>.&#x20;

{% embed url="<https://gist.github.com/linxule/53caa096237c1bb3fe8ab9b733e5bacf>" %}
{% endtab %}
{% endtabs %}

[![Creative Commons Licence](https://i.creativecommons.org/l/by-nc/4.0/88x31.png)](http://creativecommons.org/licenses/by-nc/4.0/)

© 2023 Xule Lin & Ying-Ying Hsieh. This work is licensed under a [Creative Commons Attribution-NonCommercial 4.0 International License](http://creativecommons.org/licenses/by-nc/4.0/).