# 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/).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://makerdao.daogov.info/further-reading-and-resources/learning-resources.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.