# Subgraphs Overview


- [DAOhaus Goerli Subgraph](https://thegraph.com/hosted-service/subgraph/hausdao/daohaus-v3-goerli) Playground
- [Querying The Graph](https://thegraph.com/docs/en/querying/querying-the-graph/)

Our subgraph schema is composed of the following entities:

- DAOs
- Proposals
- Votes
- Members
- Rage Quits
- Shamans
- Records
- Vaults
- Event Transactions


## Explorers and API Endpoints

- Mainnet
- [Explorer](https://thegraph.com/explorer/subgraph?id=9uvKq57ZiNCdT9uZ6xaFhp3yYczTM4Fgr7CJHM6tdX9H&view=Overview)
- API: https://gateway.thegraph.com/api/[api-key]/subgraphs/id/GfHFdFmiSwW1PKtnDhhcxhArwtTjVuMnXxQ5XcETF1bP
- Goerli
- [Explorer](https://thegraph.com/hosted-service/subgraph/hausdao/daohaus-v3-goerli)
- API: https://api.thegraph.com/subgraphs/name/hausdao/daohaus-v3-goerli
- Gnosis Chain
- [Explorer](https://thegraph.com/explorer/subgraphs/5oXHJGgAWTSEXHK5FGf7mcxYtk6rSz7MJV5ccvGfoW6q?view=Overview)
- API: (https://gateway.thegraph.com/api/[api-key]/subgraphs/id/5oXHJGgAWTSEXHK5FGf7mcxYtk6rSz7MJV5ccvGfoW6q)
- Polygon
- [Explorer](https://thegraph.com/hosted-service/subgraph/hausdao/daohaus-v3-polygon)
- API: https://api.thegraph.com/subgraphs/name/hausdao/daohaus-v3-polygon
- Arbitrum
- [Explorer](https://thegraph.com/hosted-service/subgraph/hausdao/daohaus-v3-arbitrum)
- API: https://api.thegraph.com/subgraphs/name/hausdao/daohaus-v3-arbitrum
- Optimism
- [Explorer](https://thegraph.com/hosted-service/subgraph/hausdao/daohaus-v3-optimism)
- API: https://api.thegraph.com/subgraphs/name/hausdao/daohaus-v3-optimism

## Example Queries

### DAO

Get a specific DAO with it's profile record

{
  dao(id: "0x0daoaddress") {
    id
    createdAt
    profile: records(
      first: 1
      orderBy: createdAt
      orderDirection: desc
      where: { table: "daoProfile" }
    ) {
      createdAt
      createdBy
      contentType
      content
      }
  }
}

Get a list of DAOs

{
  daos(first: 5, orderBy: createdAt, orderDirection: desc)  {
    id
    createdAt
  }
}

### Members

Get a list of members for a DAO

{
  members(where: {dao: "0x0daoaddress"})  {
    id
    createdAt
  }
}

### Proposals

Get a list of proposals with it's votes for a DAO

{
  proposals(where: {dao: "0x0daoaddress"})  {
    id
    yesVotes
    noVotes
    yesBalance
    noBalance
    createdAt
    votes {
      id
      balance
    }
  }
}