Various Japanese government agencies publish a ton of data, however they are often only available in xls/csv format and need to be manually cross-referenced. For example:
* Want to know which city in Tokyo has the most people from a given country? [This site](https://www.toukei.metro.tokyo.lg.jp/gaikoku/2023/ga23010000.htm) has the number of foreigners per city (区 and 市) for each country.
* Want to see how this compares to the overall population of the city? You need to get that data from [another spreadsheet](https://www.toukei.metro.tokyo.lg.jp/juukim/2023/jm23010000.htm).
* Want to see how this changed overtime? Prepare to check and cross reference multiple spreadsheets manually
* Want to know how much a city spends on education? The [Ministry of Internal Affairs and Communications publishes the budget of all municipalities of Japan](https://www.soumu.go.jp/iken/zaisei/r03_shichouson.html) in a single spreadsheet (technically 4: one for an overview, one detailing the income sources, and two detailing the expenses, but each contains all municipalities of the country)
* But this data doesn’t really make sense without knowing the population or the population under 18, which you need to source elsewhere (e.g. [from here](https://www.toukei.metro.tokyo.lg.jp/juukiy/2023/jy23000001.htm) for Tokyo)
* Or maybe you want to see it per the number of schools? [That data is also available for Tokyo](https://www.toukei.metro.tokyo.lg.jp/gakkou/2023/gk23qg10000.htm), but again another set of spreadsheets
There is even an [open dataset portal](https://data.e-gov.go.jp/info/en) by the Digital Agency that aims to collect these sources, though [not all links are kept up-to-date apparently](https://asia.nikkei.com/Spotlight/Datawatch/Over-20-of-Japan-s-open-dataset-contains-unavailable-info).
Which brings me to my question: is there any site that visualizes and lets people query these datasets easily?
Here are the potential ones that I found:
* the Data Portal has a [showcases section](https://data.e-gov.go.jp/data/en/showcase?organization=default), but those only include 6 showcases
* the [RESAS](https://resas.go.jp/) system is [dubbed as](https://apolitical.co/solution-articles/en/japan-has-built-the-worlds-largest-national-economic-data-viz-tool) “the world’s largest national economic data viz tool”. It’s a bit hard to use, but still the best I could find
* [Data Commons](https://datacommons.org/) by Google looks like the perfect future tool, but currently it only has very basic data from Japan
by Ok_Philosopher_7716