言語：
英語
プロダクト種別：
データ
親プロダクト：
JAPANESE CITY DATA(日本の市区町村データ)
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.
Please select the table you wish to view from the data dictionary in the Snowflake Marketplace.
Click here for sample data from Japanese City Data
E_NAME | TABLE REFERENCE |
ESTATDB_STATS_FULL_ID | CI_ST |
CITY_CODE | CI_ST |
STATS_YEAR | CI_ST |
STATS_VALUE | CI_ST |
STATS_UNIT | CI_ST |
ESTATDB_STATS_FULL_NAME | CI_ST_MST |
ESTATDB_RESEARCH_TABLE_ID | CI_ST_MST |
STATS_TAB01_CODE | CI_ST_MST |
STATS_TAB01_NAME | CI_ST_MST |
STATS_CAT01_CODE | CI_ST_MST |
STATS_CAT01_NAME | CI_ST_MST |
STATS_CAT02_CODE | CI_ST_MST |
STATS_CAT02_NAME | CI_ST_MST |
STATS_CAT03_CODE | CI_ST_MST |
STATS_CAT03_NAME | CI_ST_MST |
STATS_CAT04_CODE | CI_ST_MST |
STATS_CAT04_NAME | CI_ST_MST |
ESTATDB_TABLE_NAME | CI_TB_MST |
PREF_CODE | CI_MST |
PREF_NAME | CI_MST |
CITY_NAME | CI_MST |
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_ID | ESTATDB_STATS_FULL_NAME | STATS_VALUE | CITY_NAME | ESTATDB_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.