PrepperPrepper Open Data Bank

PR_FD20

truestar inc. Polygon・Population Statistics Every year

Summary

This dataset is an analysis dataset for each prefecture created by truestar using the administrative area data (polygon data) from the Ministry of Land, Infrastructure, Transport and Tourism’s National Land Numerical Information and the population statistics data from the national census published by the government’s statistics e-Stat.

For each polygon, the latitude and longitude of the prefectural capital city were obtained from the location information of the municipalities published by the Geospatial Information Authority of Japan and the point data is also provided. However, all islands that do not contain representative points are classified as remote islands.

Features/Usages

We apply a polygon data join process to ensure that each record corresponds to a prefecture code, making it easy to match with statistical data by prefecture. The data includes basic statistics such as population and number of households, enabling hassle-free analysis and visualization of commercial areas at the prefectural level.

There are three types of polygon data: one that generalizes the boundaries of the raw data to make it lighter, one that excludes islands from the generalized data, and one that excludes islands only in Tokyo, which can be used according to the analysis purpose.

Matching with statistical data by prefecture code and sharing with GEOGRAPHY type enables easy mapping using BI or GIS tools.

Sample Data

Please select the table you wish to view from the data dictionary in the snowflake marketplace.

Click here to view sample data from Japanese Prefecture Data

Data Fields

E_NAME
RESEARCH_YEAR
PREF_CODE
PREF_NAME
PREF_NAME_EN
PREF_CODE_NAME
LONGITUDE
LATITUDE
POPULATION
POPULATION_2015
POPULATION_MALE
POPULATION_FEMALE
NUMBER_OF_HOUSEHOLDS
NUMBER_OF_HOUSEHOLDS_2015
AREA
POPULATION_DENSITY
POPULATION_CHANGE_LAST_5YEARS
POPULATION_CHANGE_RATE_LAST_5YEARS
HOUSEHOLD_CHANGE_LAST_5YEARS
HOUSEHOLD_CHANGE_RATE_LAST_5YEARS
POINT_JP_PREF
POLYGON_JP_PREF_LIGHT
POLYGON_JP_PREF_2_LIGHT
POLYGON_JP_PREF_3_LIGHT

References

The data is prepared by truestar, based on the following data.

Administrative Region Data of MLIT’s National Land Numerical Information

“Numerical Map (Basic Land Information)” of the MLIT’s Geospatial Information Authority (Approval (Use) R 4JHs 243 based on the Surveying Law)

https://nlftp.mlit.go.jp/ksj/gml/datalist/KsjTmplt-N03-v3_1.html


Location Information of Municipalities by MLIT’s Geospatial Information Authority

https://www.gsi.go.jp/KOKUJYOHO/center.htm


Basic Collection of Population and Household Statistics from the 2020 Population Census by e-Stat

Table 1-1: Population by Gender, Number of Households by Type of Household and Household Members, Population as of 2015 (Revised), Number of Households as of 2015 (Revised), Population Change over 5 Years, Population Growth Rate over 5 Years, Number of Households Change over 5 Years, Household Growth Rate over 5 Years, Sex Ratio, Area (Reference), and Population Density – Nationwide, by Prefecture, and by Municipality (including municipalities in 2000 (Heisei 12))

https://www.e-stat.go.jp/stat-search/files?page=1&layout=datalist&toukei=00200521&tstat=000001136464&cycle=0&tclass1=000001136466&result_page=1&tclass2val=0