PrepperPrepper Open Data Bank

PREF_04_CENSUS

truestar inc.   population statistics   every 5 year

Summary

This dataset includes the prefectural population data of over 15 years old by occupations and sex, which is edited and integrated by truestar based on the data of the national census.

Sample Data

Features/Usages

This dataset contains demographic statistics in the unit of Japanese prefectures by occupations. The occupational classification such as “Administrative and managerial workers” and” Sales workers” is based on the “Japan Standard Occupational Classification” provided by Ministry of Public Management.
You can also easily combine this dataset with other datasets released at Snowflake Data Marketplace such as “PREF 00 FUNDAMENTAL” by using “PREF CODE”.

Data Fields

  • 2020
  • 2020_2
  • 2015
RESEARCH_YEAR
PREF_CODE
PREF_NAME
PREF_NAME_EN
PREF_CODE_NAME
SEX
OCCUPATION_CATEGORY
POPULATION_15YEARS_AND_OVER
OCCUPATION_PERCENTAGE
RESEARCH_YEAR
PREF_CODE
PREF_NAME
PREF_NAME_EN
PREF_CODE_NAME
SEX
AGE_GROUP_5YEARS
OCCUPATION_CATEGORY
POPULATION_15YEARS_AND_OVER
OCCUPATION_PERCENTAGE
RESEARCH_YEAR
PREF_CODE
PREF_NAME
PREF_NAME_EN
PREF_CODE_NAME
SEX
OCCUPATION_CATEGORY
POPULATION_15YEARS_AND_OVER
OCCUPATION_PERCENTAGE

References

  • 2020
  • 2015

Edited by truestar based on the national census 2020 provided by e-Stat (Japanese Government Statistics)

https://www.e-stat.go.jp/stat-search/files?page=1&layout=datalist&toukei=00200521&tstat=000001136464&cycle=0&year=20200&month=24101210&tclass1=000001136467

Edited by truestar based on the national census 2015 provided by e-Stat (Japanese Government Statistics)
https://www.e-stat.go.jp/stat-search/files?page=1&layout=datalist&toukei=00200521&tstat=000001080615&cycle=0&tclass1=000001124175&tclass2val=0

Special Notes

■ About PREF_04_CENSUS2020 and PREF_04_CENSUS2020_2

In the Census 2020, “POPULATION_15YEARS_AND_OVER” and “OCCUPATION_PERCENTAGE” are listed in separate tables. And “AGE_GROUP_5YEARS” column is added only for “POPULATION_15YEARS_AND_OVER”.

Truestar has merged two tables into one table to make them the same as 2015 and we have prepared the table without “AGE_GROUP_5YEARS” column(PREF_04_CENSUS2020) and the table with “AGE_GROUP_5YEARS” column(PREF_04_CENSUS2020_2).

Since  the original data of “OCCUPATION_PERCENTAGE” does not have “AGE_GROUP_5YEARS” column, the column is edited and added by truestar.

Update History

2022/1/28 : Rename JAPAN_PREFECTURE_CENSUS_04 to PREF_04_CENSUS2015

2022/6/30:Release PREF_04_CENSUS2020 / PREF_04_CENSUS2020_2 as BETA ver.