Analyzing Sake in Ishikawa Prefecture Using National Tax Agency Data
Hello everyone.
Are you enjoying the development period for the "Sake x Hackathon"?
This time, I would like to analyze the liquor tax data published on the National Tax Agency's website to explore the characteristics of sake in Ishikawa Prefecture.
I want to explore the characteristics of sake in Ishikawa Prefecture.
The analysis report is here
The actual analysis results have been published as a report, so
if you are interested, please take a quick look.
Observations from the analysis results:
I have extracted some graphs and rankings from the report's analysis results, and
I will provide a digest of what kind of insights might be visible.
I hope this will be useful for your analysis methods, visualization techniques, and target setting in the hackathon!
Summary
The essence of Ishikawa is not a "major production area", but a medium-sized cluster deeply specialized in refined sake (seishu). Total liquor production is 4,531kL, ranking 40th in the country, but refined sake is 3,823kL, ranking 17th out of the 44 prefectures published. When narrowed down to refined sake, it moves up 23 places, and the ratio accounting for 84.4% of production within the prefecture is 2nd among published values. Even excluding population size, the depth of demand for refined sake remains.
Per capita refined sake sales volume is 5.02L, ranking 4th in the country. This is 1.63 times the national average of 3.08L, confirming a heavy bias in demand toward refined sake that is difficult to see from total sales volume alone. Even when adjusted for area, the concentration of sake breweries is clear, but the scale per location is medium. There are 9.56 refined sake licenses per 1,000km², ranking 9th in the country, and the refined sake production density is 913.2kL, ranking 12th out of 44 prefectures. On the other hand, the production volume per location of 95.6kL ranks 21st in the country. In the Hokuriku region, Ishikawa is the hub for volume, but the three prefectures have different structures. Ishikawa accounts for 40.5% of refined sake production and 42.4% of sales in the three Hokuriku prefectures. Toyama exceeds Ishikawa in production volume per location, and Fukui exceeds Ishikawa in refined sake specialization and production/sales ratio, showing differences in production area structure rather than simple superiority or inferiority.
Ishikawa residents have one of the highest per capita sake consumption rates in the country, and
the proportion of sake in the prefecture's total production is the second highest in the country, so
it is a prefecture where sake is very familiar.
However, when looking at simple production volume at the national level,
it doesn't even come close to Hyogo, Kyoto, or Niigata...
Specialization in refined sake is 2nd in the country, and absolute volume also exceeds the median
Ishikawa's 84.4% is not a high ratio simply because the total liquor production volume is small. The refined sake production volume of 3,823kL exceeds the national median of 2,937kL, placing it in the "high specialization, medium or higher scale" category among the top 10 prefectures for refined sake production ratio. It is a production area that sits between high-specialization small-scale areas like Fukui and high-specialization large-scale areas like Niigata and Akita.
When looking at specialization and scale at the same time, Ishikawa's comparison partners change
If looking only at the refined sake ratio, Fukui and Kochi stand out, and if looking only at volume, Hyogo and Niigata stand out, but Ishikawa is in the middle of both axes. Comparison targets differ depending on the point of discussion; Fukui is close in specialization, Yamagata and Kochi are close in production area scale, and Toyama is close to or in a contrasting position to Ishikawa in terms of brewery productivity.
Total sales volume follows population—first, separate the scale effect
The correlation coefficient between prefectural population and liquor sales volume is r=0.97, and the structure is such that large metropolitan areas tend to rank higher based on absolute volume rankings alone. Ishikawa has a population of 1.098 million, ranking 33rd in the country, and a total liquor sales volume of 75,020kL, ranking 31st in the country. Both are in similar positions, and much of the small total sales volume is explained by population size.
Well, if the population is large, the consumption volume is also large.
Here, I will divide by population.
When adjusted per capita, sake demand in Ishikawa ranks 4th in the country
Ishikawa's per capita sake sales volume is 5.02L, which exceeds both the national average of 3.08L and the prefectural median of 3.16L. Beyond the absolute volume of 5,507kL in sake sales, the intensity of demand remains even after adjusting for population, meaning Ishikawa's 7.3% sake sales ratio is not just a result of population size. Note that sales volume includes tourist and commercial demand, and does not represent consumption by residents alone.
Niigata, Akita, Nagano, Ishikawa, and Yamagata follow.
I'm starting to get a sense of the rice-growing regions, aren't you?
Also, let's divide the number of sake manufacturing licenses by area.
When adjusted for area, Ishikawa is a "production region where sake breweries are close together"
There are 9.56 sake manufacturing licenses per 1,000km², ranking 9th in the country, and sake production volume is 913.2kL, ranking 12th out of the 44 prefectures that published data. License density is 2.15 times the national average, and production density is 1.11 times, so production volume is not as prominent as the density of breweries. The number of licenses per 100,000 people is 3.64, ranking 9th in the country, which is 2.69 times the national average of 1.36. Clustering can also be confirmed through population adjustment. However, since total area includes forests and the like, this should be interpreted as one aspect of regional clustering rather than operational efficiency or habitable area density.
In the three Hokuriku prefectures, Ishikawa is the hub for volume, while Toyama and Fukui have different strengths
Ishikawa accounts for 40.5% of sake production, 42.4% of sales, and 40.0% of licenses in the three Hokuriku prefectures. However, production volume per license is 124.9kL in Toyama, 95.6kL in Ishikawa, and 73.9kL in Fukui. The ratio of sake production to sales is 88.5% for Fukui, 69.4% for Ishikawa, and 65.4% for Toyama. The differences are that Ishikawa is the intersection of the largest market and largest production area, Toyama has a high scale per license, and Fukui has strong specialization and market balance.
Summary
While Ishikawa Prefecture's sake production volume is not high,
in fact, the number of sake breweries per area and the needs per population are at the top level in the country.
In other words, local residents have sake close at hand.
However, there are also challenges,
such as a decrease in reach to young people and a lack of awareness among tourists.
While incorporating official statistical information,
good luck with your hackathon development!
いいなと思ったら応援しよう！
この記事は noteマネー にピックアップされました
