PrepperPrepper Open Data Bank

CI_PCS20_01

Summary

This dataset is a view that combines the “Population and Basic Census” data from the national census (2020 edition) with data extracted from the municipal survey statistics table [CI_ST], the municipal statistics master [CI_ST_MST], the municipal survey master [CI_TB_MST], and the municipal master table [CI_MST].

This data includes such as population, number of households, population by age, and population by gender.

The survey year is 2020.
The ESTATDB_RESEARCH_ID (survey ID) for the City, Town, and Village Survey Master [CI_TB_MST] is 0112020.

Sample Data

Data Fields

E_NAMETABLE REFERENCE
ESTATDB_STATS_FULL_IDCI_ST
CITY_CODECI_ST
STATS_YEARCI_ST
STATS_VALUECI_ST
STATS_UNITCI_ST
ESTATDB_STATS_FULL_NAMECI_ST_MST
ESTATDB_RESEARCH_TABLE_IDCI_ST_MST
STATS_TAB01_CODECI_ST_MST
STATS_TAB01_NAMECI_ST_MST
STATS_CAT01_CODECI_ST_MST
STATS_CAT01_NAMECI_ST_MST
STATS_CAT02_CODECI_ST_MST
STATS_CAT02_NAMECI_ST_MST
STATS_CAT03_CODECI_ST_MST
STATS_CAT03_NAMECI_ST_MST
STATS_CAT04_CODECI_ST_MST
STATS_CAT04_NAMECI_ST_MST
ESTATDB_TABLE_NAMECI_TB_MST
PREF_CODECI_MST
PREF_NAMECI_MST
CITY_NAMECI_MST

Special Notes

Issue:

There are records where the ESTATDB_Statistics_full_name [ESTATDB_STATS_FULL_NAME] is the same, but the statistics value [STATS_VALUE] is different.

Reason for difference:

This is because the ESTATDB_Table_name [ESTATDB_TABLE_NAME] is different.

Details:

  • This is an example of table number 3-3 and table number 4-3-1.
ESTATDB_STATS_FULL_IDESTATDB_STATS_FULL_NAMESTATS_VALUECITY_NAMEESTATDB_TABLE_NAME
0112020009|202001|0|0|00|0人口|国籍総数|総数|総数|総数1,973,395札幌市3-3男女,年齢(5歳階級),出生の月,国籍総数か日本人別人口-全国,都道府県,市区町村
0112020010|202001|0|0|0|00人口|国籍総数|総数|総数|総数1,726,966札幌市4-3-1男女,年齢(5歳階級),配偶関係,国籍総数か日本人別人口(15歳以上)-全国,都道府県,市区町村

Example Case:

The statistics values, such as STATS_VALUE, are different despite the ESTATDB_STAT_FULL_NAME being the same.

The reason for the difference in statistics values is because Table Number 3-3 includes the total population, including those under 15 years old, while Table Number 4-3-1 includes the total population of those over 15 years old.

Note:

If only ESTATDB_STAT_FULL_NAME is specified to calculate the statistics value, it will result in the sum of the statistics value from two tables.

Solution:

When specifying ESTATDB_STAT_FULL_NAME to calculate the statistics value, please also specify ESTATDB_STAT_FULL_ID or ESTATDB_TABLE_NAME.