# View total topics per category/sub category
**URL:** https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486
**Category:** Support
**Tags:** moderation
**Created:** [11월 12, 2015, 8:16오전 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486 "2015-11-12T08:16:23Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [11월 12, 2015, 8:16오전 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/1 "2015-11-12T08:16:23Z")
So I am probably missing it…but I cannot seem to find a quick way to view the number of topics per category? I know I can go into “edit” on the category page, and get the number of topics from that page where it states “Can’t delete this category because it has xxx topics”, but I am hoping to see more than one category at a time (ideally all on one screen). Is this possible to do somewhere?
---
### Author:  [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [11월 13, 2015, 2:53오전 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/2 "2015-11-13T02:53:59Z")
Why do you need to see this number? What is it useful for?
Anyway, it is visible on the /categories page.
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [11월 13, 2015, 5:18오전 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/3 "2015-11-13T05:18:53Z")
> [@codinghorror](#):
>
> Why do you need to see this number? What is it useful for?
The Discourse I am a moderator on is for a game in active development. In addition to hosting discussion about the game as a whole, it serves as the bug reporting system for the developers. The game has been out in alpha for 2 years now, with coming up on 13 major releases. Before that 13th release we (the moderators) are trying to do a bit of “cleanup” as as the number of bug reports, suggestions, and other topics spike with each release. Being able to quickly see which categories have more topics is good for us to know where to devote our time.
> [@codinghorror](#):
>
> Anyway, it is visible on the /categories page.
I could be staring right at it, but I don’t see the number of topics in a category here. I see the rate at which there new topics have been created, but not something like “there are 1,234 topics in Suggestions”…
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [11월 13, 2015, 5:24오전 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/4 "2015-11-13T05:24:45Z")
This sounds like a job for CLI (ActiveRecord) or the [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin. (SQL)
[https://github.com/discourse/discourse-data-explorer](https://github.com/discourse/discourse-data-explorer)
Are you any good and putting together queries?
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [11월 13, 2015, 5:28오전 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/5 "2015-11-13T05:28:31Z")
> [@Mittineague](#):
>
> [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin.
I do know SQL, so I would be able to queries for that type of data, and I do see that on the admin page, but…1) I am not an admin, and 2) the plugin is disabled.
---
### Author:  [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [11월 13, 2015, 5:49오전 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/6 "2015-11-13T05:49:39Z")
You might be able to see this in the json data for the categories page. Can
you check @techapj
---
### Author:  [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [11월 13, 2015, 6:29오전 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/7 "2015-11-13T06:29:32Z")
Yes, the total “topic count” data for each category is present in `/site.json` endpoint.
@jomaxro search for `topic_count` here `http://discourse.stonehearth.net/site.json` and you will find what you are looking for 😄
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [11월 13, 2015, 6:32오전 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/8 "2015-11-13T06:32:35Z")
> [@techAPJ](#):
>
> search for `topic_count` here `http://discourse.stonehearth.net/site.json`
Awesome, thanks!
###### Now, if only chrome displayed json files in a slightly more readable format…
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [11월 13, 2015, 8:02오전 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/9 "2015-11-13T08:02:27Z")
> [@jomaxro](#):
>
> Now, if only chrome displayed json files in a slightly more readable format…
There are extensions for that 😉
---
### Author:  [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [11월 18, 2015, 10:05오후 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/10 "2015-11-18T22:05:32Z")
> [@zogstrip](#):
>
> There are extensions for that 😉
Just saw this reply…thanks! I found a nice one that does the formatting. Feel free to close this thread up!
---
### Author:  [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [11월 18, 2015, 10:52오후 UTC](https://meta.discourse.org/t/view-total-topics-per-category-sub-category/35486/11 "2015-11-18T22:52:19Z")