Json to CSV Converter: https://konklone.io/json/

Json Editor: https://jsoneditoronline.org/#right=local.mabepi&left=local.bepupe

Query Explorer: https://graphql-console.subsquid.io/?graphql_api=https://query.joystream.org/graphql

Alternative Query Explorer: https://query.joystream.org/graphql

Joystream Explorer: https://joystream.explorer.subsquid.io/graphql

Joy Scanner: https://jscan.io/

Blocks and Dates of each Council Terms

query{
  electedCouncils {
    electedAtTime
    endedAtTime
    electedAtBlock
    endedAtBlock
  }
}

No. of created threads (last term)

query ForumDataReport($councilStartBlock: Int!, $councilEndBlock: Int!) {
    threadCreatedEvents(where: {inBlock_gte: $councilStartBlock, inBlock_lt: $councilEndBlock}, limit: 10000) {
    inBlock
    thread {
      id
      title
      author {
        handle
      }
      category {
        id
        title
      }
    }
  }
}

{
  "councilStartBlock": XXXXXX,
  "councilEndBlock": XXXXXX
  
}

No. of deleted threads (last term)

query ForumDataReport($councilStartBlock: Int!, $councilEndBlock: Int!) {
  threadDeletedEvents(where: {inBlock_gte: $councilStartBlock, inBlock_lt: $councilEndBlock}, limit: 10000) {
    inBlock
    thread {
      title
      id
      author {
        handle
      }
      category {
        title
        id
      }
    }
  }
}

No. of created/deleted posts (last term)

Created post check in: https://jscan.io/

You can also sum below query and add to new threads created

query CreatedPosts($councilStartBlock: Int!, $councilEndBlock: Int!) {
  postAddedEvents(where: {inBlock_gte: $councilStartBlock, inBlock_lt: $councilEndBlock}, limit: 10000) {
    inBlock
    postId
  }
  postDeletedEvents(where: {inBlock_gte: $councilStartBlock, inBlock_lt: $councilEndBlock}, limit: 10000) {
    id
    inBlock
  }
}